SUMMARY:

• 9 years of experience in analysis, design, development, testing and implementation as ORACLE PL/SQL DEVELOPER.
• Expert in multiple RDBMS including Oracle 11g/10gr3/9i/8i/8.x/7.x with PL/SQL, Microsoft SQL Server 2000).
• Expertise in Information Engineering and Object Oriented principles and techniques with OLAP and reporting tools.
• Expertise in using tools such as TOAD, SQL*Plus, SQL developer, PL/SQL developer.
• Expertise in understanding Slowly Changing Dimensions Type1, Type2 and Type3.
• Experience in integration of various data sources with Multiple Relational Databases like Oracle, SQL Server, MS Access and Flat Files.
• Worked on advanced PL/SQL constructs like Oracle supplied packages, Nested Tables, Varrays, Records, Types, Dynamic SQL and Analytical functions.
• Worked on Forms and Reports 6i & 9i.
• Created indexes on tables for fast retrieval of data.
• Experience in PL/SQL collections, Bulk collections and Exception handling.
• Worked in SQL, PL/SQL development and database support as well as maintenance.
• Experience in using SQL*Loader for loading data from flat files into Oracle tables.
• Performance tuning using Explain Plan, SQL-Trace, TK-Prof oracle utilities and creating relevant system and user documentation.
• Experience in Data modeling tools like Erwin, Visio and Oracle designer.
• Good understanding of Oracle Data Dictionary, RDBMS and Normalization techniques.
• Substantial development experience in creating Procedures, Packages, Functions, Triggers and other database objects using SQL, PL/SQL.
• Created and tested PL/SQL blocks and UNIX shell scripts.
• Used UNIX shell scripts to automate day-to-day operations.
• Strong working experience in the Gathering the Requirements, Data Analysis, Design, Development, Implementation and Testing of Data Warehousing using Data Conversions, Data Extraction, Data Transformation and Data Loading (ETL)
• Strong interpersonal skills, ability to interact with individuals at all levels, excellent communication and presentation skills.

Technical Skills:

Languages:

C, C++, SQL, PL/SQL.

Operating Systems:

WINDOWS ’95,\'98 & NT/2000/XP, Hp Unix, Sun Solaris.

GUI Tools:

Oracle 10g, Oracle Forms 6i & 9i, Oracle Reports 6i & 9i, Developer 2000 , MS Access

Databases & RDBMS:

ORACLE 7.X, 8, 9i, 10gr2, MY SQL, MS Access, DB2, SQL Server 2005, Teradata.

Web Browser:

Internet Explorer 8.0, 6.0, 5.0, Netscape 7.0, 6.0, Mozilla Firefox 1.5

Defect Management Tool:

Test Director 7.5/8.0, Quality Center 10.0

Data Warehousing Tools:

Informatica Power Center 8x

BI Tools:

TOAD, SQL Developer, SQL Navigator 4, MS Visio, Erwin.

Educational Qualification:

Bachelors of Computer Science

Certification:

Oracle certified associate (OCA).

PROFESSIONAL EXPERIENCE
Confidential,Nashville Feb 2012– Till Date
Module Lead
eResponse Project: Confidential, is leading health care service provider with more than 500 clinics around the world.
eResponse is the responses which got from Payers upon submitting claims for the service provided to customers. The responses from payers (Insurance companies) can be in different formats Paper/835/Correspondence. The responses from payer can be completely denial, partial denial, claim status etc. There are certain rules setup in the system to find the type of response got from payer. Once after finding out the type of response the collection team can act immediately on those claims. This in turn will generate revenue for Davita.
Responsibilities:

• Involved in SDLC gathering requirements from end users.
• Creating the functional and technical design documents.
• Defining and designing the test plan and test cases.
• Developed views to facilitate easy interface implementation and enforce security on critical customer information.
• Developed stored procedures and triggers to facilitate consistent data entry into the database.
• Written Stored Procedures using PL/SQL and functions and procedure for common utilities.
• Participated in system analysis and data modeling, which included creating tables, views, indexes, synonyms, triggers, functions, procedures, cursors and packages.
• Created programming code using advanced concepts of Records, Collections, and Dynamic SQL.
• Developed Database Triggers for audit and validation purpose.
• Used Advanced Queues functions for faster data accessibility.
• Writing validation packages using PL/SQL package.
• Used PL/SQL to validate data and to populate billing tables.
• Used advanced Bulk techniques to improve performance.
• Developed Installation scripts for all the deliverables.
• Performed functional testing for the procedures and packages.
• Created and manipulated stored procedures, functions, packages and triggers using TOAD.
• Wrote heavy stored procedures using dynamic SQL to populate data into temp tables from fact and dimensional tables for reporting purpose.
• Extensively worked on Quality test plans and reviewed the Quality System Test Plan & Test cases.
• Fine-tuned for performance and incorporate changes to complex PL/SQL procedure / Packages for updating the existing dimension tables using PL/SQL Developer on Oracle RDBMS.
• Creating and executing SQL queries to perform Data Integrity testing on an Oracle Database to validate and test data using PL/SQL developer.
• Performed data Validation and comparison for data loads and migrations in different applications.
• Provide requirements around data quality as it pertains to ETL.

Environment: Oracle 11g, Informatica, Data ware Housing, SQL Server 2005 / 2008, MS Suite ( MS Access, MS Excel, MS PowerPoint, MS Visio), HP Quality Center 10.0, Share Point, Windows.

Confidential,Santa Oct 2010 – Jan 2012
Module Lead / System Analyst / Sr. Data Quality Analyst
Deal Management System: Confidential,is rebate solution stack that enables our price exception systems efficient and scalable by providing better data management, analysis, controls, and policy direction, providing better pricing decision and guidance for Intel.

Web Quote: Creating and processing quotes for the products vary depending on the product hierarchy and corresponding dimensions. Web Quote is one of the parts of Common Architecture Decision Support Systems.
COGNOS Reporting tool: Output of all quotes were reported though COGNOS tool by using the SQL queried output of quote and Geo data, Division, and compare the billing figures.
Responsibilities:

• Mentoring the team with team building activities.
• Involved in SDLC gathering requirements from end users.
• Creating the functional and technical design documents the changes required.
• Requirements Gathering.
• Meeting with Stake holders.
• Defining and Designing the test plans.
• Designing and defining test cases in HP Quality center.
• Coordinating with Other Planning tracks for executing Integration testing and User Acceptance testing.
• Coordinating and managing the team activities.
• Coordinating with the clients for System Test and User Acceptance Test.
• Issue tracking and Status Reporting.
• Participated in system analysis and data modeling, which included creating tables, views, indexes, synonyms, triggers, functions, procedures, cursors and packages.
• Performed functional testing for the procedures and packages.
• Extensively worked on Quality test plans and reviewed the Quality System Test Plan & Test cases.
• Creating and executing SQL queries to perform Data Integrity testing on an Database to validate and test data
• Performed data Validation and comparison for data loads and migrations in different applications.
• Provide requirements around data quality as it pertains to ETL.

Environment: Data ware Housing, SQL Server 2005 / 2008, Teradata V2R6, Teradata SQL Assistant, , T-SQL, SQL, MS Suite ( MS Access, MS Excel, MS PowerPoint, MS Visio), HP Quality Center 10.0, Cognos 8.0 / 10 , Share Point, Windows.

Confidential,US Aug 2009 – Sep 2010
Module Lead / Data Analyst/ Oracle PL/SQL Developer
Confidential,is one of the top companies who are in to semi-conductor devices manufacturing. I2 technologies, who are leaders in supply chain management products, have deployed their products like Supply chain planner, Demand Manager and Demand Fulfillment to support Infineon’s Master production plan, marketing forecasting and Order promising processes. We are currently supporting these applications, which are the base for Infineon’s business.
Responsibilities:

• Involved in SDLC gathering requirements from end users.
• Creating the functional and technical design documents.
• Defining and designing the test plan and test cases.
• Developed views to facilitate easy interface implementation and enforce security on critical customer information.
• Developed stored procedures and triggers to facilitate consistent data entry into the database.
• Written Stored Procedures using PL/SQL and functions and procedure for common utilities.
• Participated in system analysis and data modeling, which included creating tables, views, indexes, synonyms, triggers, functions, procedures, cursors and packages.
• Created programming code using advanced concepts of Records, Collections, and Dynamic SQL.
• Developed Database Triggers for audit and validation purpose.
• Used pipelined functions for faster data accessibility.
• Writing validation packages using PL/SQL package.
• Used PL/SQL to validate data and to populate billing tables.
• Used advanced Bulk techniques to improve performance.
• Developed Installation scripts for all the deliverables.
• Performed functional testing for the procedures and packages.
• Created and manipulated stored procedures, functions, packages and triggers using TOAD.
• Wrote heavy stored procedures using dynamic SQL to populate data into temp tables from fact and dimensional tables for reporting purpose.
• Extensively worked on Quality test plans and reviewed the Quality System Test Plan & Test cases.
• Fine-tuned for performance and incorporate changes to complex PL/SQL procedure / Packages for updating the existing dimension tables using PL/SQL Developer on Oracle RDBMS.
• Created oracle reports on 9i.
• Creating and executing SQL queries to perform Data Integrity testing on an Oracle Database to validate and test data using PL/SQL developer.
• Worked on UNIX shell wrappers, Oracle PL/SQL programming and stored procedures.
• Performed data Validation and comparison for data loads and migrations in different applications.
• Provide requirements around data quality as it pertains to ETL.

Environment: Oracle 10g R2, SQL PL/SQL, PL/SQL Developer, Erwin 4.1, ETL (Informatica 8.1/7.1), UNIX, Shell Scripting, Autosys,, SQL Loader, UTL Files, RCS, WinSQL Professional

Confidential,Atlanta, GA Mar2008 – Aug2009
ETL Developer/ Data Analyst/Oracle PL/SQL Developer
Confidential,is one of the world’s leading providers of data, voice and high speed DSL Internet access services. At AT&T, leadership and success is earned through commitments kept and relationships developed with the customers, employees and communities we serve.
The Business Intelligence Database (BID) was created after the merger of BellSouth Mobility and SBC Wireless to form Cingular Wireless.. There are numerous sources from which BID gets its data and numerous applications extract data from BID. It is important to integrate new data from these sources properly in to the BID. A BID user should be able to provide an enterprise view of the company, using the BID data, in a single report. Project team’s responsibility is to solve the production problems raised by the user
Responsibilities:

• Executed and scheduled tasks; batch processing, metadata management and data mapping.
• Worked with Development team to create necessary operational documents and transition daily support activities with Tier1 team
• Created ETL documents detailing the ETL (database navigation and data transformation) logic used by developers as coding specifications.
• Extract Data Requirements from process oriented Requirements Documents
• Created and thoroughly documented Logical and Physical Data Model in accord with Project Plan
• Conducted Data Model Presentations upon achieving project milestones.
• Performed Business Analysis, Data Analysis and Dimensional Data Modeling
• Analyzed business requirements and interfaced with vendors for development and enhancement of a system to support multiple business areas including Asset Management, portfolio management and risk management.
• Involved in migration of mappings / workflows from Development to Testing and to production.
• Experienced in data integration, metadata management, ETL, data modeling tool sets
• Also created scripts to automatically generate the SQL to authenticate the results of the ODS and Data Mart load processes.
• Developed Reports and Graphs to present the results to the management.
• Performed Data Driven Testing of the Application for different users/data sets.
• Identified, tracked and resolved performance problems. Made recommendations on potential functional and technical improvements to planned or existing system components and applications.

Environment: Erwin 4.1, ETL (Informatica 8.1/7.1), Oracle, SQL Server 2005, T-SQL, TOAD 7.6, UNIX, Shell Scripting, SQL Server 2005, Autosys, Teradata V2R6, MLOAD, FLOAD, B-Teq FEXPORT, TPUMP, SQL Assistant 6.0, WinSQL Professional.

Confidential, Oct2007 – Feb 2008
Data Analyst/ETL/PL/SQL
Confidential, is a tactical solution, a web based diagnostic call handling tool to track the progress of customer journey within fault arena. Eclipse guides the advisor through the call. The application will ask advisors questions and use the results of diagnostics tests to route the agent to knowledge that will enable them to bring the customers call through to conclusion.
Responsibilities:

• Gathering the requirements from client.
• Estimation effort and Statement of Work for complete migration of objects.
• Creation of Oracle database in offshore development server.
• Creating the functional and technical documents.
• Defining and designing the test plan and test cases.
• Mapping of Data types in SQL Server 2005 and Oracle 10g.
• Migration of tables , views, functions , procedures etc. from SQL SERVER 2005 to Oracle 10g
• Created ETL documents detailing the ETL (database navigation and data transformation) logic used by developers as coding specifications.
• Executed and scheduled tasks; batch processing, metadata management and data mapping.
• Worked with Development team to create necessary operational documents and transition daily support activities with Tier1 team
• Extract Data Requirements from process oriented Requirements Documents
• Created and thoroughly documented Logical and Physical Data Model in accord with Project Plan
• Deployment of code in Onsite servers.
• Migration of data from live server to Oracle 10g.
• Performed Data Driven Testing of the Application for different users/data sets.
• Identified, tracked and resolved performance problems. Made recommendations on potential functional and technical improvements to planned or existing system components and applications
• Resource planning for monthly Deliverables.
• Offshore support to new environment.
• Coordinating with the client.
• Issue tracking and Status Reporting.

Environment: Erwin 4.1, Oracle, SQL Server 2005, T-SQL, TOAD 7.6,PL/SQL Developer, SQL Plus, Red Hat Linux, UNIX, Shell Scripting, SQL Server 2005, Autosys, SQL Assistant 6.0, WinSQL Professional, Quick Test Professional

Confidential,USA Nov 2006 – Sep 2008
Oracle PL/SQL Developer
Outbound Net change: The Project Aim is to replace the current Master Data management system with MDS (I2 ABPP). MDS supports item, store, customer introduction and maintenance. MDS caters 50 other downstream systems by feeding incremental Master Data daily. The Net change Calculation logic is developed using PL/SQL Stored Procedures.
I2 MDM-DF Integration: The primary objective of i2 DF Enhancements is to plan for Constrained SKU Items.
Outbound Data Synch Up: There are around 50 target systems which get master data from MDS. Out of sync framework notifies whenever any target system goes out of sync with MDS system. Targets send the master data which they received periodically. MDS computes out of sync data received from target system by comparing data with master data tables. Master Data Admin will be given User interface to check any out of sync notifications and correct them.
Responsibilities:

• Created various SQL and PL/SQL scripts for verification of the required functionality.
• Created Stored Procedures, functions, Database triggers, Packages, cursors and SQL Scripts based on business requirements.
• Developed Triggers and shell Scripts to load the staging tables.
• Worked on complete SDLC (System Development Life Cycle) including system analysis, high level design, detailed design, coding and testing.
• Creation of database objects like Tables, Views, Procedures using Oracle tools like SQL*Plus and SQL Developer.
• Modified existing codes, PL/SQL Packages to perform certain specialized functions and enhancements on Oracle Application.
• Involved in Index Monitoring for identifying the Unused Indexes.
• PL/SQL Collections were extensively used for high performance of stored procedures.
• Developed Shell and PL/SQL scripting for regular maintenance and production support to load the data in regular intervals.
• Created Relational database design using Erwin tool, create Logical data base design and then created physical database design.
• Creating Index’s, passing hints, analyzing the table statistics and Table partitioning.
• Applying constraints and writing triggers to apply the business rules.
• Involved in handling errors and transaction processing in the procedures.
• Oracle data loading into oracle database from intermediate files using SQL loader and UTL_File.
• Using SQL trace and TKPROF accurately assessed the efficiency of the SQL statements when application runs.
• Created Complex Dynamic/Static/parameterized reports and Charts using Reports 9i.
• Involved in performance tuning using Explain Plan, TKPROF utilities.
• Tuned PL/SQL packages with advances features like Bulk collect, For All, DBMS_JOBS etc.
• Involved in analyzing Schema’s, Tables and Indexes as part of Optimization.
• Actively involved in System testing and deploying application.
• Involved in migration of mappings / workflows from Development to Testing and to production.
• Experienced in data integration, metadata management, ETL, data modeling tool sets.

Environment: Oracle 9i/ 10G, SQL * Plus, TOAD, PL/SQL Developer, SQL Loader, Shell Scripts, Informatica.

Confidential,Hewlett Packard Apr2006 – Oct 2006
Oracle PL/SQL Developer
Confidential,is a web based application which is used by hp channel partners across the globe. Any partner who deals with hp products has to register on this portal. This portal provides him all information regarding different existing and forthcoming products.
Responsibilities:

• Created various SQL and PL/SQL scripts for verification of the required functionality.
• Created Stored Procedures, functions, Database triggers, Packages, cursors and SQL Scripts based on business requirements.
• Developed Triggers and shell Scripts to load the staging tables.
• Worked on complete SDLC (System Development Life Cycle) including system analysis, high level design, detailed design, coding and testing.
• Creation of database objects like Tables, Views, Procedures using Oracle tools like SQL*Plus and SQL Developer.
• Modified existing codes, PL/SQL Packages to perform certain specialized functions and enhancements on Oracle Application.
• Involved in Index Monitoring for identifying the Unused Indexes.
• PL/SQL Collections were extensively used for high performance of stored procedures.
• Developed Shell and PL/SQL scripting for regular maintenance and production support to load the data in regular intervals.
• Creating Index’s, passing hints, analyzing the table statistics and Table partitioning.
• Applying constraints and writing triggers to apply the business rules.
• Involved in handling errors and transaction processing in the procedures.
• Oracle data loading into oracle database from intermediate files using SQL loader and UTL_File.
• Actively involved in System testing and deploying application.

Environment: Oracle 9i, SQL * Plus, TOAD, SQL Loader, Shell Scripts, HP UNIX, Perl Scripting, Documentum.

Confidential,USA Aug 2003- Mar2006
Application Developer
Confidential,has one application (called IVOS) for handling vehicle rental and insurance related data. As there are certain limitations in the IVOS system, the client decided to use new application called ABACUS. The underlying Oracle database structure is also different. But client needs to use old data in the new system. This necessitates conversion of existing data.
Responsibilities:

• Created various SQL and PL/SQL scripts for verification of the required functionality.
• Created Stored Procedures, functions, Database triggers, Packages, cursors and SQL Scripts based on business requirements.
• Developed Triggers and shell Scripts to load the staging tables.
• Worked on complete SDLC (System Development Life Cycle) including system analysis, high level design, detailed design, coding and testing.
• Creation of database objects like Tables, Views, Procedures using Oracle tools like SQL*Plus and SQL Developer.
• Modified existing codes, PL/SQL Packages to perform certain specialized functions and enhancements on Oracle Application.
• Involved in Index Monitoring for identifying the Unused Indexes.
• PL/SQL Collections were extensively used for high performance of stored procedures.
• Developed Shell and PL/SQL scripting for regular maintenance and production support to load the data in regular intervals.
• Creating Index’s, passing hints, analyzing the table statistics and Table partitioning.
• Applying constraints and writing triggers to apply the business rules.
• Involved in handling errors and transaction processing in the procedures.
• Oracle data loading into oracle database from intermediate files using SQL loader and UTL_File.
• Actively involved in System testing and deploying application.

Environment: Oracle 9i, SQL * Plus, TOAD, SQL Loader, Shell Scripts, HP UNIX.