Summary Experience:

• 8+ Yrsof expertise in Oracle 8i/9i/10g SQL and SQL Plus (DDL, DML and DCL) in Data Analysis, Data Design, Data Storage, Data Integrity, Data Performance, Tables, Synonyms, Sequences, Indexes, Views and Materialized Views.
• 7+ Yrs of expertise in Oracle PL/SQL (Stored Procedures, Functions, Packages and Triggers).
• 6+ Yrs of expertise in Oracle Developer suite 6i/8i/9i/10g (Forms 6i/8i/9i/10g and Oracle Reports 6i/8i/10g).
• Around 1 Yrof expertise in Cognos Reports and Data Warehouse Defining, Analyzing and Designing of data sources, Documenting requirements and Validating data.
• Experience in Oracle Designer and XML programming.
• Knowledge of all phases of ETL (Extraction, Transformation, and Loading) by developing Star Schemas, Programs, Procedures and Solutions for Data Acquisition, Extraction, Cleansing, Transformation, Formatting, Integration and Loading and having working knowledge with Informatica.
• 3+ Yrs of experience in SQL*Loader for loading bulk data from flat files and excel files.
• 2+ Yrs of experience in UNIX (Shell Scripts in Sun Solaris) for FTP, Cron and at jobs.
• Worked in Database tools (Toad, SQL Navigator, PL/SQL Developer and Ora Edit) for Data Design, Data Tracking and PL/SQL Coding.
• Worked in Data Modeling using Oracle Designer.
• Experience in all phases of the Software Development Life Cycle (SDLC) - Database models, Design, Coding, Customizing, Application programming, Testing, Implementation, Maintenance and Documentation.
• Good Analytical, Technical, Communication and Interpersonal skills.
• Self-motivated, Quick Learner and Team Player, Independent, Accountable, Organized, Problem Solver and lead teams to success.

Technical Skills:

Operating Systems: Windows NT/95/98/2000/XP, UNIX 
Languages: Java, XML, HTML, Pro*C, Perl5.6.1, SQL 8.0/10.1, PL/SQL 8.0/10.1
Web Technologies: JSP, Servlets, Beans, EJBs and J2EE.
RDBMS: ORACLE 8i/9i/10g/11g, MS SQL Server 2000
GUI: Developer 2000/6i (Forms 6i/10g), Oracle Enterprise Manager (OEM) and Crystal Reports 8.5
Reporting: Reports 6i/10g and BI Publisher
Database Tools: PL/SQL Developer 5.1, Toad 6.3, DB Surfer 7.0, Ora Edit 3.3, Easy SQL 1.0 and SQL Query Tool 4.1
Data model Tools: Oracle Designer/ERWIN.
ERP: Oracle E-business suite 11i/R12 (PO,INV,OM,AR,AP and GL). 
Version Control: PVCS Version Manager 6.5, Clear Case
OLAP: Informatica, Cognos (Report Studio/Query Studio), Oracle Discoverer 9i.

Project experience:

Confidential, Austin, TX March 2011 to till dateConfidential, the nation’s largest golf retailer, has the retail stores all over the country. Company manufactures custom golf clubs and also distributes golf clubs and components of their own products and as well as other company products. Confidential provides services like club repair, customization of clubs. Golf Smith headquarters is located in Austin, TX and it has retail stores all over U.S. 
Responsibilities:

• Requirements gathering from end user and analysis of requirements.
• Developed and modified Package, procedures and functions to import orders from custom applications (POS and WEB) to oracle application interface tables.
• Created Address verification Procedure to validate address by sending data in XML format to FEDEX web service.
• Created package to calculate Item price using TAXWARE engine third party software.
• Developed Order Entry custom form to enter customer order information with customer details, item details, shipping and payments details into custom application using Forms 10g and Template.fmb.
• Enhanced and fixed the issues in Order Return custom form.
• Created package to build Sales Commission reports (CSV files) using UTL_FILES and sending emails to users.
• Used bulk collection and bulk insert features to improve the performance.
• Used PL/SQL Tables and Record Types.
• Developed Order Import Errors Report, Sales Summary reports and modified pick pack report using Reports10g.
• Created Tables, Triggers, Synonyms and grants as per business requirements.
• Involved in unit testing, integration testing of ORDER ENTRY form, procedures and packages.

Environment: Oracle 10g, Oracle Applications R12 (Order Management, Inventory, AR, AP and GL), PL/SQL Developer, Forms 10g, Reports10g, XML, Windows XP and UNIX.

Confidential, Houston, TX Feb 2011 to Mar’15th 2011Data Conversion (Oracle EBS to SAP)
Confidential is a leading provider of flow equipment products, systems and services to worldwide oil, gas and process industries. Leveraging its global manufacturing, engineering and sales and service network, Confidential works with drilling contractors, oil & gas producers, pipeline operators, refiners and other process owners to control, direct, adjust, process, measure and compress pressures and flows. 
Responsibilities:

• Mapping data between Oracle applications tables and SAP tables.
• Created tables in oracle staging area as per SAP Table structure.
• Developed packages, procedures and functions to pull the data from oracle purchase order, sales order.
• Pull the data related to customers and vendors and loaded the data into staging area mapped the data according to legacy system requirements.
• Involved in unit testing, integration testing.
• Loading the data from base tables to staging area using SQL * Loader.
• Developed the PL/SQL validations to eliminate the unrequited data.
• Verified existing functional requirements with users and gathered missing requirements from users.

Environment: Oracle Applications R12 (Supply chain, Financials), PL/SQL Developer, Windows XP.

Confidential, Austin, TX May 2006 to Dec 2010CHIP (Children Health Insurance Program)
Confidential provides diverse services and products for Government (HHSC) Program Management and Operations, Consulting, and Systems. MAXe-CHIP is the Confidential eligibility and enrollment system. It was developed in Oracle and is based upon the system used to support the State of Children Health Insurance Program. CHIP is a federal/state health coverage program for families who earn too much to qualify for Medicaid, but cannot afford a private health plan. My job responsibilities included analysis, designing, coding and implementation of the new SR’s [System Requirements].
Responsibilities:

• Created Procedures, Functions, Packages and Database Triggers.
• Involved in Data conversion of Health plans.
• Loading the data from flat files to staging area using SQL * Loader.
• Worked on Correspondence, Eligibility and Enrollment modules.
• Worked on Time out package to determine the expiry dates of application.
• Modified existing Unix Shell scripts and compiled and deployed the FORMS in Unix server.
• Developed the PL/SQL validations to eliminate the data from flat file.
• Development of the new forms using the prototypes and synching the existing back end code to the new Formsand modified existing Forms using Forms 9i/10g.
• Created tables, views using (Design Editor) oracle Designer and created ER Diagrams using Entity Relationship Diagrammer.
• Tuned the SQL queries by running Explain plan.
• Developed EL_TEMP Template FMB and reused the template Form to create new Forms.
• Developed new forms like Authenticate call and Snap shot Form.
• Created Materialized views and pulled the data.
• Detected and Rectified errors modified & enhanced the project according to the requirements.
• Developed Applications received summary report, Eligibility Pending detail Report, Enrollment detail Report using Reports 6i.
• Creating technical detail design document and Component Test plans based on system requirements.
• Involved in review meetings of technical design documents and test scenarios created by development team and testing team.
• Testing the application in development environment Unit Testing and System Level testing.

Environment: Oracle 10g/11g, Oracle Designer, Developer suite 10g(Forms and Reports), Oracle Discoverer, Oracle Applications11i,PL/SQL Developer, QualityCenter and UNIX.

Confidential, Bothell, WA Oct 2005 to Mar 2006Billing Conversion
Atlys and Macrocell are the billing systems for Confidential, while Cinglular Utilizes CPW and Telegence as their billing platforms. In an effort to eliminate the multiple billing systems which resulted from the merger, billing data (Atlys/Macrocell) and other customer records will be used as primary sources from which to pull conversion extract files. These files will be transmitted to Cingular (Target) and provide all primary data elements required to build all customer records/profiles within corresponding Cingular Billing Systems.
Responsibilities:

• Mapping data between Atlys files and Oracle tables after analyzing business logic and target system.
• Developed and customized packages, procedures and functions.
• Analyzing tables and indexes, creating required indexes and tuning SQL queries.
• Loading the subscribers data into Oracle temporary tables using SQL * Loader.
• Involved in unit testing, integration testing and code reviews.
• Written the UNIX Shell Scripts to automate the manual jobs like receiving the files, loading the data into tables, running the validations scripts.
• Developed the PL/SQL validations to eliminate the data from flat file.
• Worked on PL/SQL scripts in UNIX environment.
• Involved system requirement walk through meetings.

Environment: Oracle 9.2, SQL 9.2, PL/SQL 9.2, Toad 6.3.3, TOAD, Windows XP, Perl 5.6.1 and UNIX.

Confidential, Reston, VA Mar 2005 to Sept 2005Restatement Project:
Restatement project at Confidential is to restate the prior (2001 to 2004) financial statements for eliminating the use of hedge accounting and to correct the errors in accounting for deferred purchase price adjustments.
For new accounting policies to restatement, the SCB team introduced data derived from newly developed accounting processes and re-executed certain accounting processes to obtain a restated cost basis and fair value of its mortgage-related portfolio. Securities Accounting coordinates with other work streams to exchange data and interfaces with newly developed accounting engines like FAS 91 Amortization; FAS 115 Impairments; EITF 99-20 Impairments; Commitments; Gee Accounting; and Tax. The resulting data is used to generate G/L journal entries and fulfill certain reporting requirements like financial, Management and Operational.
Responsibilities:

• Attend walk-through meetings with Business Analysts, Developers, Project Managers and Leads to provide them the feed back in various requirement and technical documents for Reports.
• Reviewed requirement documents for Securities Based Cost Sub Ledger and Centralized Sub Ledger
• Involved in gathering business requirements, functional requirements and data specification.
• Setting up the Aggregate awareness functionality in the Universe between the objects of Summary tables.
• Creation of different types of reports, such as List, Cross Tab and Chart (for trend analysis) using filters, conditions, calculations, etc.
• Writing Complex SQL queries and optimizing SQL queries.
• Constructing Stored Procedures and improving the performance of stored procedures.
• Developed advanced reports, Drill through Reports and Cross Tab reports using Report Studio.
• Created different types of ad-hoc Reports and Charts in Query Studio
• Developed Reports of different modules like: Financial Sub Ledger, Management and Operational.

Environment: Cognos 8 Business Intelligence, Report Studio, Query Studio Framework Manager, SQL Server 2000/2005, Oracle 9i, TOAD, Windows XP and UNIX.

Confidential. Apr 2003 to Oct 2004ECARE (Hospital System): 
ECARE Project is in-house, online and fully integrated MIS system that has been working in BDF Hospital for both systems OUT-PATIENT (Patient Registration, Accident & Emergency, Clinical Appointments and Patient Diagnostics) IN-PATIENT (Admissions & Discharges, Pharmacy). This project includes other modules like Lab system, Asset System, Finance system and HURIS (Human resource Information) system.
Responsibilities:

• Involved in gathering System Requirements & Analysis of Requirements.
• Involved in preparing Project related documents like System Requirement Documents, Technical documents, Detail Design and Test plans.
• Involved in Database Design and Maintenance.
• Involved in creating stored procedures, packages, functions and user interfaces.
• Tested and implemented of relevant modules.
• Developed forms using Forms 6i/8i
• Created reports using Reports 6i/8i
• Coordinated between Development team and QA team

Environment: Oracle 6i, Oracle Forms 6i, Oracle Reports 6i, Toad, Visual Basic, C++, JAVA, Windows 98/XP and UNX.