Summary

• 8 years of programming experience as an Oracle Developer in Database Development and providing ETL/Business Intelligence Solutions using Oracle OWB and Informatica
• Involved in all phases of the SDLC Software Development Life Cycle like analysis, design, development, testing, implementation and maintenance against aggressive deadlines.
• Experience in Installation Setup, Configuration, Maintenance and tuning of Oracle 11g/10g/9i on Windows NT/Vista/2003/2007.
• Expertise in Client-Server application Installation and development using Oracle 11g/10g/9i, PL/SQL, Java, SQL PLUS, TOAD, SQL LOADER, OWB and Informatica.
• Experience in creating and designing relational and dimensional databases and its objects by applying Normalization and De-normalization techniques for both OLTP and OLAP Systems.
• Well versed in creating logical and physical data modeling using Erwin and Sybase power designer.
• Expertise in creating Tables, Views, Indexes B-Tree, Bitmap and Function Based , Table Partitions, Collections and Materialized Views.
• Developed Complex database objects like Stored Procedures, Functions, Packages and Triggers using SQL and PL/SQL.
• Experience in using Export/Import utilities and developing ad-hoc queries using SQL
• Well versed with Oracle Supplied Packages such as DBMS SQL, DBMS JOB, UTL FILE
• Expertise in utilizing advanced PL-SQL Concepts like Cursors, Records, Dynamic SQL and exception Handling
• Good Knowledge in writing and debugging programs in both UNIX and Windows Environment using Unix/Shell scripting.
• Experience in SQL performance tuning using Cost-Based Optimization CBO and Rule Based Optimizer RBO .
• Experience in Performance Tuning using Explain Plan, HINTS, TK proof and Auto Trace.
• Experience in Designing and Developing OWB Mappings, workflows using OWB Design center.
• Experience in Designing and Developing Informatica Mappings, sessions and workflows using Informatica Power center Designer and Power center workflow manager.
• Experience in Developing Slowly changing dimensions, Error Handling and Performance tuning using ETL concepts.
• Worked on highly encrypted network systems familiar with public key private key setup for SFTP processes.
• Review of all offshore deliverables and artifacts ETL Code review and Technical Design Review .
• Experience in utilizing scheduling tools like Control M, UC4 and Autosys.
• Excellent communication, interpersonal, analytical skills and strong ability to perform as part of a team

Technical Skills

• Databases : Oracle 9i/10g/11g, MS SQL Server, Teradata
• Programming Languages : SQL, PL/SQL, TSQL, C, C , Java
• Tools and Utilities : SQL PLUS, SQL LOADER, PL/SQL Developer, Toad,
• OWB, ODI, Informatica, OBIEE, SVN subversion, TFS, Control M, UC4
• Operating Systems : Windows NT/ 2000/2003/2007 , UNIX Sun Solaris and Red hat
• LINUX

Professional Experience

Confidential

Role: Sr. PLSQL/ETL Developer

Responsibilities:

• Gathering requirements from Process team and documenting them into detailed functional and technical specifications and created test cases.
• Evaluated existing data mart Star Schema and determining Entity relationships between tables using Erwin Data modeler.
• Worked on SQL Loader to load data from flat files obtained from various facilities every day.
• Created and modified UNIX shell Scripts to process source files on daily basis.
• Involved in the continuous enhancements and fixing of production problems.
• Created Views, Materialize views, PLSQL stored procedures, functions and packages for moving the data from staging area to data mart and optimized the loads.
• Created PL/SQL scripts to extract the data from the operational database into simple flat text files using UTL FILE package.
• Extensively used the advanced features of PL/SQL, like Records, Cursors and Dynamic SQL.
• Used Pragma Autonomous transactions to commit changes by the compiler within PLSQL Blocks.
• Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application.
• Handled Data in terms of Terra bytes and also performed Data analysis, Data Profiling and Data validation on the data coming from multiple source systems.
• Performed SQL and PL/SQL tuning and Application tuning using EXPLAIN PLAN and Hints
• Leverage Explain plan and TK Proof to improve Query Performance.
• Created indexes on the tables for faster retrieval of the data to enhance database performance.
• Configured Project Modules, Location modules and managed users to setup OWB 11.2.0.
• Created ETL mappings for dimensions and facts in the data mart using OWB 11.2.0 and Informatica power center designer 9.1.
• Implemented Slowly Changing Dimensions Type I II in different mappings as per the requirements.
• Scheduled the jobs using Control-M and Autosys scheduling tools.
• Worked on highly encrypted network systems familiar with public key private key setup for SFTP processes.
• Worked in Onshore - offshore model environment.
• Involved in Knowledge Transition Sessions to Client team.
• Provided 24/7 on call production support

Environment: Oracle 11g, SQL Plus, TOAD, SQL Loader, SQL Developer, Shell Scripts, OWB 11.2.0, Informatica 9.1, Erwin, Windows XP, SVN, Control-M

Confidential

Role: Sr. PLSQL/ETL Developer

Project: Smart Meter installation

The program was to install Smart energy meters for constellation energy customers by replacing legacy meters. Smart meters helped constellation energy to get better analytics on their customer's energy consumption.

Responsibilities:

• Interacted with Business Analysts and Users in requirement gathering and documented them into detailed functional and technical specification documents.
• Contributed at JAD sessions with Data Architects and team members in building Data flow diagrams and ER Diagrams.
• Designed and developed database tables, Constraints and Sequences to construct Star Schema In the Data mart
• Created Table Partitions on tables which holds data in large volumes.
• Did the Data analysis on the source system
• Extensively used SQL Loader and DB links to load data from flat files and legacy systems into stage tables.
• Created complex PL/SQL Procedures, Functions and packages to transform data before loading into Target warehouse.
• Extensively used Cursors, Bulk Collects and Exceptions in developing Procedures, Functions and packages.
• Performed unit testing, supported integration testing and end user testing
• Configured project modules in OWB 11.2.0 to Connect source and target locations
• Developed ETL technical design for all dimensions and facts in the data mart
• Designed and Maintained UNIX Shell scripts to migrate Database objects to environments Dev, Stage, Sandbox, and PROD .
• Created views and Materialized views for Reporting team to access data
• Scheduled nightly batch flow using UC4 scheduling tool.
• Worked closely with the DBAs to performance tune the ETL mappings from a database and OWB perspective.
• Extensively used EXPLAIN PLAN utility to leverage SQL queries.
• Extensively involved in using hints to direct the optimizer to choose an optimum query execution plan.
• Applied Patches on both server and client side to migrate OWB to ODI.
• Involved in Setting up Topology connections to Oracle Database.
• Involved in the continuous enhancements and fixing of production problems
• Extensively worked on production issues with effective defect management

Environment: Sybase Power Designer, TFS, MS Share Point, Oracle SQL Developer, Oracle Warehouse Builder 11.2, UC4, Windows, UNIX, OBIEE 10gR3

Confidential

Sr. PLSQL/ETL Developer

Ingenix Risk Adjustment Data System IRADS allows to process encounter/diagnosis data for Medicare Advantage MA plans to facilitate accurate revenue reimbursement from CMS for MA members chronic conditions. IRADS is the internally created application created to properly collect, store, and submit Reconcile client encounter data to CMS and perform error corrections on HCC codes of MA member Conditions to accurately reflect RAF for health plan reimbursement.

Responsibilities:

• Documented technical design documents based on the BRD and FSD provided.
• Used Erwin Data Modeling tool to establish Entity relationships between tables.
• Worked with external tables, loaded data from flat files into Oracle tables using SQL Loader.
• Created and maintained tables, views, complex PL/SQL procedures, functions, and packages and performing DML operations using insert, update and delete statements.
• Used Collections Varrays, Index by tables and Nested tables to improve functionality with in PL/SQL.
• Extensively used both implicit cursors and explicit cursors and their attributes.
• Extensively used the oracle exception handling techniques for implementing all types of exceptions.
• Performed Administrative activities like creating projects, establishing ODBC connections using Power Center repository manager.
• Extracted data from multiple source systems like Flat files, SQL Server 2008,Teradata 12 to load into Oracle database.
• Developed mappings, mapplets and workflows by using Transformations provided in Power center Designer of Informatica PowerCenter8.6.1 to Extract, Transform and Load ETL of data into the data warehouse.
• Implemented slowly changing dimensions to maintain current information and history information in dimension tables.
• Used Informatica Power Center Workflow manager to create sessions, batches to run with the logic embedded in the mappings.
• Extensively used Transformations like Router, Aggregator, Joiner, Expression, Lookup, Update strategy and Sequence generator to handle complex transformation rules required to load target fact and dimension tables.
• Performed unit testing and fixed the bugs identified.
• Fine tuned and optimized the mappings to improve the performance thereby decreasing the run time.

Environment: Oracle 10g, SQL, PL/SQL, SQL Plus 3.1, SQL Loader, Informatica 8.6.1, OBIEE 10gR3, UNIX.

Confidential

PLSQL/ETL Developer

• The Prudential Insurance Company of America, one of the largest life insurance companies in the U.S.
• These companies offer a variety of products and services, including mutual funds, annuities real estate
• Brokerage franchises, relocation services, and more.

Responsibilities:

• Worked on Database design with the team.
• Writing PL/SQL code using the technical and functional specifications.
• Generated SQL and PL/SQL scripts to install create and drop database objects including Tables, Views, Indexes, Constraints, Sequences and Synonyms.
• Involved in writing Packages, Functions, Stored Procedures and Database Triggers.
• Developed complex queries to retrieve the data.
• Worked on Database tuning and performance monitoring.
• Involved in creating Index's, passing hints, analyzing the table
• Involved in client installation of Informatica 8.6.1
• Data Profiling on source systems before loading and target system after loading.
• Extracted data from Flat files and Oracle data marts to load into Enterprise data warehouse.
• Created complex mappings using transformations provided in Informatica to load data using data warehouse.
• Detected and corrected bugs during system integration and user acceptance testing.
• Created sessions and workflows using Informatica Power center workflow monitor.
• Performance tuning and optimizing mappings by identifying bottlenecks

Environment: Oracle 10g, UNIX shell programming, TOAD, SQL Plus, Linux, Informatica 8.6.1, Autosys

Confidential

PL/SQL Developer

• ERP Analysts is a fast growing full service company offering simplified IT Consultation, Application
• Development, Maintenance, Migration, Testing, IT Infrastructure, Business Intelligence and Training
• Services across varied platforms for Energy and Utilities, Financial and Insurance, Life Sciences and Manufacturing sectors.

Responsibilities:

• Interacted with Business Analysts and Users in requirement gathering Built complex queries using SQL and wrote stored procedures using PL/SQL.
• Worked in Data modeling, Data mapping and Data flow.
• Involved in Requirement gathering and writing Functional and Technical documents.
• Responsible for writing and modification of PL/SQL stored procedure, functions, packages and Database triggers.
• Created new Tables, Indexes, Synonyms and Sequences needed as per new requirements.
• Created materialized views, Inline Views normal views where business requirements needed.
• Tune the SQL queries and complex procedures to improve performance.
• Created database triggers for data security Consistency.
• Experience in writing procedures, functions and packages for new requirements.
• Used advanced PL/SQL concepts like Bulk collect, PL/SQL tables and Dynamic SQL for DML operations for better performance.
• Developed PL/SQL and web PL/SQL stored procedures.
• Implemented Advanced PL/SQL Concepts for better performance of PL/SQL Applications.
• Wrote PL/SQL backed stored procedures for database access and tuned them efficiently.
• Worked in Production Support Environment testing for projects, work orders, maintenance requests, bug fixes, enhancements, data changes, etc.
• Extensively used EXPLAIN PLAN utility to leverage SQL queries.
• Performance tuning of Oracle Databases and User applications.
• Created and monitored workflows and tasks using Informatica Power Center Work flow Manager
• Involved in Unit Testing for the application
• Involved in solving day-to-day problems, giving support to the users

Environment

Oracle 10g, TOAD, PL/SQL, Explain Plan, TKProf, Informatica, HTML

Confidential

PLSQL Developer

This project involved design and development of an Online banking system. The project Involved

Creating forms for employees and customers to use the banking facilities such as viewing account balances, statements and performing other operations

Responsibilities:

• Requirement analysis of a banking system.
• Designed ER diagrams and normalization of database.
• Used Developer 2000 to create forms.
• Developed scripts to create tables, views, procedures and functions and executed them using SQL Plus.
• Wrote triggers to handle user generated events.
• Modules like Login, deposit, withdrawal, interest calculation account balance were developed
• Session management to provide security to web access.
• Run batch jobs for loading database tables from flat files using SQL Loader.
• Created Unix Shell scripts for automating the execution process.
• Created Records, Tables, Objects, Collections Nested Tables and Arrays , and Error Handling.

Environment: SQL, PL/SQL, ORACLE 9i, Windows Vista.