SUMMARY:

• An Oracle Certified Professional with more than 10 years experience in all phases of systems development life cycle. Professional experience covers the following areas: ETL, Data Warehousing, Data Conversion, Data Migration, Home and Auto Insurance, Banking, Energy Billing, Telecommunication, System Integration, Testing, Support and Application Development.
• Extensive experience on IBM DataStage, Cognos, Oracle PL/SQL, SQL*Plus, SQL*Loader, Oracle RDBMS, Toad, SQL Navigator, PL/SQL - Developer, XML and Unix Shell Scripts. A good team player and team leader, reliable, work well under pressure, ready to learn new technologies and face new challenges

TECHNICAL SKILLS:

Data Warehouse Tools: IBM Infosphere DataStage 8.7,IBM Cognos Express 10(Report Studio, Query Studio, Framework Manager)

Programming Languages: PL / SQL, SQL, XML, HTML

Databases: Oracle 11g, 10g, 9i, 8i.

Operating systems / Scripting: AIX UNIX, Solaris UNIX, HP-UNIX, Windows(7, XP, 2000,NT ), Perl Script

Oracle Tools: PL/SQL, SQL, SQL*LOADER, TOAD, PL/SQL-developer, SQL NAVIGATOR, SQL-developer, Forms10g, Forms 6i, Reports10g, Reports 6i

Other Software Products: Erwin, Visio, Microsoft Word, Excel, PowerPoint, Lotus Notes.

Source Control: ClearCase, ClearQuest, MKS Integrity,TOAD(Team Coding), StarTeam, PVCS.

PROFESSIONAL EXPERIENCE:

Confidential

Snr. Oracle PL/SQL Developer

Responsibilities:

• Developed various DataStageparallel jobs according to source to target mapping document using XML stage, Copy, Merge, Filter stages to process the source data from Oneshield Dragon Auto Policy System intostaging and target Oracle tables for data warehousing.
• Extracted data from XML messages of Oneshield Dragon Auto Policy System and then transformed according to the requirement using source to target mapping document and Loaded into data warehouse tables using various stages like XML, Look up, Aggregator, Transformer, Join, Copy, Remove Duplicates, Sort, Column generators, Funnel and Oracle Connector.
• Executed DataStage parallel jobs through sequencer for better performance and easy maintenance.
• Created Sequencers with Error Handling, Restarting the Jobs and Trigger Email.
• Worked extensively withDimensional modeling,Data migration,Data cleansing,ETL Processes for data warehouses.
• DevelopedUNIX shell scriptsto automate file manipulation and data loading procedures.
• Analyzed the defects and applied fixes in the Data stage jobs and Sequencers.
• Created parallel jobs in DataStage to import data from heterogeneous data sources like Oracle tables and Text files.
• Collaborated with EDW team in,High Level designdocuments for extract, transform, validate and load ETL process data dictionaries, Metadata descriptions, file layouts and flow diagrams.
• Collaborated with EDW team in,Low Level designdocument for mapping the files from source to target and implementing business logic.
• PerformedUnit Testing, System Integration Testing and User acceptance testing
• Extensively worked with database objects including tables, views, indexes, schemas, PL/SQL packages, stored procedures, functions, and triggers.
• Documented ETL test plans, test cases, test scripts, and validations based on design specifications for unit testing, system testing, functional testing, prepared test data for testing, error handling and analysis.
• Development various Data warehousing reports for Personal Line of Business Auto using IBM Cognos Express 10(Report Studio).

Confidential

Snr. Oracle PL/SQL Developer

Responsibilities:

• Documentation of technical specification for the development of the Anti Money Laundering application based on the functional specification.
• Produced Detailed Design of the Anti Money Laundering (AML) application interface to other systems.
• Developed, unit tested and documented PL/SQL Packages, procedures, and functions to populate Oracle database tables for Anti Money Laundering (AML) Customer WatchList Management System for Compliance.
• Wrote SQL*LOADER scripts for data loading into Anti Money Laundering(AML) / Customer WatchList Management System for compliance.
• Wrote various Unix Shell scripts for nightly batch jobs processing for Anti Money Laundering(AML) / Customer WatchList Management system for Compliance.
• Wrote various interface PL/SQL procedures, functions to Vendor Application for Anti Money Laundering (AML) known as Detica Norkom to generate watchlist alerts.
• Wrote documentations for Unit Test Plan, Unit Test Cases, Unit Test Results and System Deployment / Implementation Plan for the functional areas of the Anti Money Laundering(AML) / Customer WatchList Management System.
• Developed various SQL scripts to create views, indexes, sequences, synonyms,
• User accounts and user privileges for development and testing environments.
• Did performance tuning for SQL query, Procedures and Functions for Customer WatchList Management System using SQL Tuning Advisor, SQL Access Advisor, DBMS PROFILER package, BULK COLLECT, EXPLAIN PLAN, INDEXES.
• Wrote various reports to generate XML output.
• Wrote various validation and testing scripts in PL/SQL, SQL for system testing, system integration testing and business acceptance testing for the functional areas of the system during the application testing phase.
• Worked with the Quality Assurance team during System testing cycle of the project in resolving defects raised based on priority.
• Did peer code reviews to make sure the programs meet the requirements in the System Design Specification.
• Used MKS Integrity for Source Control during development of new codes and maintenance of the existing SQL scripts, Procedures, Functions and PL/SQL packages.
• Post Go-Live change request and production support for the Anti Money Laundering / Customer WatchList Management System.

Confidential

Snr. Oracle PL/SQL Developer

Responsibilities:

• Involved in complete System Software development Life Cycle (SDLC) of Data warehousing for the Policy Administration System from development to SIT, UAT and production environments using Star schema dimensional modelling.
• Developed, implemented and documented Datastage parallel ETL jobs to populate various dimensions and facts tables for the data warehousing system using Datastage Oracle Connector Stage, XML Stage, Transformer Stage, Join Stage, SQL queries, PL/SQL procedures and functions from source to staging and staging to target Oracle tables.
• Implemented various data profiling SQL scripts for source transaction policy system.
• Implemented data warehouse concepts of Star Schema, Dimensions and Facts tables for the project.
• Generation ofSurrogate Keysfor the dimensions tables for indexing and faster access of data in Data Warehouse.
• Wrote various SQL queries for balance and reconciliation from source to target system for the ETL jobs.
• Developed, implemented and documented DataStage parallel ETL jobs to populate various conformed dimensions used in the data warehousing system from source to staging and staging to target tables for the project.
• Involved in the design process of the spreadsheets for Source to Target Mapping documents for the ETL jobs.
• Created Sequencers with Error Handling, Restarting the Jobs and Trigger Email.
• Developed, implemented and documented DataStage parallel ETL jobs to populate transactional fact and aggregate fact tables using SQL Queries, PL/SQL procedures, functions and packages.
• Designed and developed ETL jobs and UNIX scripts that loads and processes the source data from source systems to target systems on daily and monthly basis.
• Performance tuning for PL/SQL Procedures, Functions and Packages to achieve good system performance for ETL processes as required.
• Designed, implemented and documented common error log during ETL process using PL/SQL procedures, functions and packages.
• Wrote shell scripts to call the anonymous PL/SQL blocks for the ETL jobs.
• Worked with the Business Analysts during system development phase of the project to ensure accurate development of the functionality of the business.

Confidential

Snr. Oracle PL/SQL Developer

Responsibilities:

• Involved in complete System Software development Life Cycle (SDLC) of Data warehousing, Decision Support System.
• Designed, developed and documented facts and dimensions for subject areas using star schema for dimensional modelling.
• Designed, developed and implemented transformation processes using ETL process that will load data into the Data Warehouse from various sources.
• Developed scripts which meet aggregate requirement of ETL processes for the project.
• Prepared excel spreadsheets for Source to Target Mapping.
• Created and implemented target definitions based on star schema design and developed aggregate tables to accommodate storage of summarized data.
• Designed and developed ETL jobs and UNIX scripts that loads and processes the data on daily basis.
• Performance tuning for PL/SQL Procedures, Functions and Packages to achieve good system performance for ETL processes as required.
• Design and build PL/SQL error processing and error log procedure and Packages.

Confidential

Snr. Oracle PL/SQL Developer

Responsibilities:

• Involved in complete System Software development Life Cycle (SDLC) of Data warehousing, Decision Support System.
• Documentation of business requirements, functional specifications, technical specification for the development ETL process to load data into various tables and defining ETL standards.
• Involved in the design and writing of business reports using Oracle Reports 6i.
• Developed scripts which meet aggregate requirement of ETL processes for the project.
• Wrote various documentation on ETL Design document, Source to Target Mapping Document and Input Specification document and Test Strategy and Test Plan document.
• Designed, developed and documented facts and dimensions for subject areas using star schema for dimensional modelling.
• Designed and developed ETL jobs and UNIX scripts that loads and processes the data on daily basis.
• Developed Data cleansing scripts for the ETL processes.
• Performance tuning for PL/SQL Procedures, Functions and Packages to achieve good system performance for ETL processes as required.

Confidential

Snr. Oracle PL/SQL Developer

Responsibilities:

• Developed the following documents for the projects mentioned above:
• ETL Design document, Source to Target Mapping Document and Input Specification Document, Test Strategy, Test Plan and Application support documents.
• Analyzed business processes and operational functions to determine system requirements and solutions.
• Performed Unit, Volume and Integration Testing on the functional areas of the project.
• Developed SIT scripts using SQL in Oracle, PL/SQL and UNIX shell script.
• Did performance tuning for Procedures, Functions and Packages to achieve good system performance.
• Wrote various SQL*LOADER scripts for data conversion from legacy system into the Oracle tables of the replication system.
• Wrote various design documents for data mapping during data conversion and data replication process.Prepared logical data model and physical data model for the functional areas of the replication application.Coordinating with Business Users for the requirements for developing / modifying programs.Maintaining / Developing the interfaces between the different feeder systems ranging from legacy systems to Oracle based systems.
• Developed various SQL scripts to create views, indexes, sequences and synonyms.
• Did enhancements to the existing packages due to change requests to the functional areas of the replication program.

Confidential

Senior Oracle PL/SQL Developer

Responsibilities:

• Did query tuning for Procedures, Functions and Packages for system performance using DBMS PROFILER package, BULK Binding, EXPLAIN PLAN, and INDEXES.
• Developed various SQL scripts to create views, indexes, sequences and synonyms.

Confidential

Senior Oracle PL/SQL Developer

Responsibilities:

• Did query tuning for Procedures, Functions and Packages for system performance.
• Developed various SQL scripts to create views, indexes, sequences and synonyms.
• Wrote various SQL*LOADER scripts for data conversion from legacy system into the Oracle tables of the new system.Wrote various SQL scripts for data setup.
• Developed various ad-hoc reports using SQL*PLUS scripts.
• Created and maintained various PL/SQL blocks of database triggers.
• Managed schema objects like tables, views, indexes using SQLPLUS scripts.

Confidential

Oracle PL/SQL Developer

Responsibilities:

• Wrote various ad-hoc reports using SQL*PLUS.
• Developed views, database triggers for various functional areas for different clients.
• Involved in the development of various reports in PL/SQL and modification of the existing packages developed in PL/SQL.
• Used ClearCase source control to check-in and check-out the source code.

Confidential

Oracle Analyst / Programmer

Responsibilities:

• Wrote various UNIX shell scripts to handle some of the batch processes.
• Involved in the design and writing of business reports in Crystal Reports 8.5, using Oracle 8i as the data source.
• Wrote technical specifications for various back-ends processing that used PL/SQL packages.
• Wrote Unit Test cases to carry out unit testing for the PL/SQL packages.
• Used ClearCase source control to check-in and check-out the source code.
• Used ClearQuest for defects resolution based on priority.

Confidential

Oracle Analyst / Programmer

Responsibilities:

• Used PVCS source control to check-in and check-out the source code.