SUMMARY

• Over Ten years of experience in analysis, design, development, testing and implementation of applications.
• Performed Extraction, Transformation, loading ETL data from various sources into Data Warehouses and Data Marts using Informatica and PL/SQL.
• Extensive experience working on several databases which include Oracle 8i/9i/10G/11G, MS SQL Server 2000/2005 and MY SQL.
• Extensive experience in all phases of project such as project planning, requirements gathering, analysis, design, development, execute test plans, implementation, enhancements, training and documentation.
• Excellent command over SQL, PL/SQL, Informatica, SQL Loader, Oracle Forms 6i, Reports 6i, Cognos, APEX, Shell Programming and T-SQL.
• Experienced in identifying and understanding Business requirements, developing technical requirements, Database Design and Troubleshooting.
• Developed the Unix Shell Scripts Bourne, Korn and C shell and automated the batch jobs.
• Designing and developing application schemas, ER Diagram, Tables Partitioned Tables, Index Organized Tables, External Tables and Global Temporary Tables , Clusters, Indexes, Views, Materialized views, Triggers, Procedures, Functions and Packages.
• Implemented PL/SQL advanced topics like BULK LOAD, REF CURSORS, Creating XML Documents and loading data from XML files, Collections and UTL FILE to read and write the files.
• Highly proficient in creating Transformations, Re-usable Transformations and Mappings/Mapplets using Designer and creating Workflows using Workflow Manager.
• Experience in Development and maintenance of huge data warehouses using PL/SQL and Informatica.
• Proficient in SQL Query tuning using Hints and utilities such as Explain Plan, AUTOTRACE, TKPROF, ADDM and SQL Advisor.
• Expertise in using job scheduling tools like Autosys, Control M and Cybermation.
• Experience in Snow flake schema , Star schema, Ralph Kimball Methodology, Bill Inmon Methodology, Logical Modeling, Physical Modeling and Dimensional Data Modeling

TECHNICAL SKILLS

• RDBMS Oracle 8i/9i/10G/11G, SQL Sever 2000 and 2005, MYSQL.
• Programming Languages SQL, PL/SQL, T-SQL, C, C , C Sharp Java and Shell Scripts.
• Utilities SQL Loader, Import, Export, Data Pump
• Operating System UNIX Sun Solaris, HP-UX, Linux , Windows 98/XP/2000/2003
• Development Tools Oracle Forms and Reports 6i, 9i, 10g , APEX, Power Builder and Cognos8
• ETL Tool Informatica Power Center 9.0
• Tools Erwin, Microsoft Visio, TOAD, SQL Plus,
• SQL Navigator, PVCS, PVCS Tracker, CVS, Clear Case
• PL/SQL Developer, TIDAL, Cybermation, Control M and Autosys

PROFESSIONAL EXPERIENCE

Confidential

Sr. PL/SQL Developer

Responsibilities:

• Responsible for Business meetings, conversion of business rules into technical specifications
• Developed ETL metadat driven mappings based on the Functional Requirements
• Developed the packages, procedures and functions.
• Developed the stored procedures with the dynamic SQL's to call from the SRT front end.
• Worked with Informatica PowerCenter client tools like Repository Manager, Designer, Workflow Manager, and Workflow Monitor
• Worked with various active and passive transformations in Informatica PowerCenter
• Worked with Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet Developer, and Mapping Designer
• Developed UNIX shell scripts to run the workflows and automated the scripts to run daily loads using TIDAL scheduler
• Extensively worked with Slowly Changing Dimensions Type1, Type2, and Type3 for Data Loads
• Responsible for Performance Tuning at the Mapping Level, Session Level, Source Level and the Target Level
• Extensively worked with Look up Caches like Persistent Cache, Static Cache, and Dynamic Cache to improve the performance of the lookup transformations
• Worked with re-usable objects like Re-Usable Transformation and Mapplets
• Extensively worked with Incremental Loading using Parameter Files, Mapping Variables and Mapping Parameters
• Handled various loads like Daily Loads, Weekly Loads, Monthly Loads, and Quarterly Loads using Incremental Loading Technique
• Responsible for error handling using Session Logs, Reject Files, and Session Logs in the Workflow Monitor
• Extensively worked with the Debugger for handling the data errors in the mapping designer
• Developed the reports using SQL's and automated through UNIX shell scripts.
• Developed the application to create the Affiliations with the APEX
• Develoepd the application to handle the SRT errors wth the APEX

Environment: Oracle 11G, UNIX LInux , Shell Scripting, Informatica Power Center 9.0.1,SQL, PLSQL, APEX

Tidal, Visio, TFS, ASP.net, C .net, SQL Server, Cegedim AS360 and EI and Toad.

Confidential

Senior Oracle Developer

Responsibilities:

• Responsible for Business meetings, conversion of business rules into technical specifications
• Developed the outbound interfcaes using PL/SQL to write the First Report of Injury/Subsequent Report of Injury FROI/SROI data in EDI standard format.
• Developed Stored Procedures, Functions, Triggers and Packages.
• Developed Shell scripts using corn shell script.

Environment: Oracle 11G and 11G, UNIX, SQL, PL/SQL, XML, Autosys, Visio, Innotas, Blueprint, HP Quality Center, ASP.NET, C .net, Visual Studio 2013 and Pl/SQL Developer.

Confidential

Senior Developer

Responsibilities:

• Developed new reports and enhancement to the existing Cognos reports.
• Developed the conversion and interface scripts for ICW system using PL/SQL
• Performed enhancements to the ICW upstream and downstream systems like SPM, XENON, HCRS, GPGL and CARS.
• Trouble shooting of the direct sales, which are loaded from SAP system
• Processed excel files, XML files and CSV files as the part of the integration.
• Coordinated with the downstream systems users and upstream systems users to resolve issues.
• Resolved the production support tickets.
• Analyzed the existing feeds and developed the code to stop sending Genzyme checks to the SAP system.
• Involved in the Design and Development of the ICW 24/7 availability project.
• Unit tested the developed process, writing the test scripts and writing the implementation plan.
• Developed Mappings, Workflow's, Stored Procedures, Functions, Triggers and Packages.
• Developed Bash Shell scripts to make the jobs automated.
• Developed mappings and External tables to load the data from the external files.
• Developed metadata driven mappings

Environment: Informatica Power Center 8.0.1,Oracle 10G and 11G, UNIX HP , Power builder 10.0, Modeln N, Cognos impromtu, Shell Scripting, SQL, PL/SQL, SQL Loader, XML, Control M, Visio, Microsoft Visual SourceSafe, Pl/SQL Developer and Toad.

Confidential

Technical Lead

Responsibilities:

• Created detail design documents for interfaces and conversion.
• Reviewing the code and writing the automated scripts using shell programming.
• Maintaining the code and performing code migration between different environments.
• Created the Batch schedule to automate with the Control M.
• Performed Export and Import of the databases to refresh the Dev and QA environments.
• Created the packages, procedures and functions.
• Written complex SQL queries for the business requirements and validations.
• Created the documentation for the interfaces and conversion.
• Developed the cognos reports.
• Created the java program to create the EDI XML files.
• Provided support during the integration testing.

Environment: Oracle 10g, UNIX HP , Java, Modeln N, CPCC, Cognos 8, Shell Scripting, SQL, PL/SQL, SQL Loader, XML, Control M, CVS, Pl/SQL Developer and Toad.

Confidential

Sr. PL/SQL Developer

Responsibilities:

• Developed the mappings to load the data from various sources like suppliers, Hub and distribution centers. Source files come in different formats like Excel, XML files and flat files.
• Developed shell programs and automated using cybermation tool.
• Providing production support to different applications and analyzing the data issues across the different systems.
• Actively supported business users for change requests
• Created complex Stored Procedures and functions to support efficient data retrieval and manipulation from the UI.
• Written complex SQL queries for reporting purposes and written some anonymous blocks so that L2 can execute these workarounds.
• Performed Database design and Data Modeling using Erwin tool.
• Interacting with business users and identified the requirements.
• Performed Unit testing and helping business users in integration testing.
• Managed the offshore Production support L2 team.
• Performed Code migration in Dev and QA environment.
• Fulfilling daily Application DBA activities like setting up user management creating users, synonyms, privileges, roles, quotas, table, index, sequence etc. , logical export and import of the database and performing backup recovery of the database.
• Performed performance tuning on long running SQL queries.
• Modified the functional design document so that the document synchronies with the code.

Environment: Oracle 10g, UNIX HP , Java, Informatica, Cognos 8, JDA, Shell Scripting, SQL, PL/SQL, SQL Loader, XML, Cybermation, CVS and Toad.

Confidential

Sr. Oracle Developer

Responsibilities:

• Designed and Developed Pfizer Integration Project , MESA interface GL Integration application and OTC Mercury Integration Project .
• Responsible for making enhancements to the existing databases.
• Responsible for coordinating offsite team.
• Created the Stored Procedures, Functions, Packages and SQL Loader scripts.
• Developed the Shell programs and scheduled using Cron Job.
• Improved the performance of SQL queries by creating Indexes on the tables and using Hints.
• Used the Performance tuning utilities like Explain Plan, AUTOTRACE, TKPROF, ADDM and SQL Advisor.

• Writing Complex Reusable SQL queries using Inline Views, Sub Queries, Correlated Sub Queries, SQL Analytics and Oracle Hierarchies and documented the queries.
• Responsible for loading historical data, loading data from Excel sheets and XML data.

• Export and import database schemas, objects using Import/Export utility.

• Performed DBA activities like creation of Tables Partitioned Tables, Index Organized Tables, External Tables and Global Temporary Tables , Views, Triggers and Database Links.
• Fulfilling daily DBA activities: setting up user management creating users, synonyms, privileges, roles, quotas, table, index, sequence etc. and Disk space management Tablespace, rollback segment .

• Involved in Unit testing, Integration testing and documented the results.

• Involved in entire Software development life cycle SDLC of Pfizer Integration Project system design, development, testing and production support .

Environment: Oracle 8i, Oracle 9i, MYSQL, Unix HP , Windows 2003, Java, Power Builder, Microstrategy, SAP, Shell Scripting, SQL, PL/SQL, SQL Loader, XML, Mainframe, CVS and Toad.

Confidential

Sr. PL/SQL Developer

Responsibilities:

• Developed CMS inbound and outbound interface and performed enhancements to the interface.
• Created the SQL Loader scripts and External tables to load the data from Flat files.
• Created the database objects like Tables, Clusters, Indexes, Views and Materialized views.
• Created the Stored Procedures, Functions, and Packages.
• Tuned SQL queries for optimum result.
• Developed the Shell Scripts and Used the Autosys for scheduling Jobs.
• Export and import database schemas, objects using Import/Export utility.
• Promoting code, Applying data fixes, resolving application related database errors in Production Environment.
• Debug and Fix production fallouts due to code fixes on a day-to-day basis.
• Performed database table partitioning, as after consolidation the table sizes would have grown very large.
• Fulfilling daily DBA activities: setting up user management creating users, synonyms, privileges, roles, quotas, table, index, sequence etc. and Disk space management Tablespace, rollback segment and Backup Recovery using hot backups, cold backups and RMAN backups.
• Performed the Application tuning using Oracle performance tuning tools like Explain Plan, SQL Trace and TKPROF.
• Extensively worked in writing SQL Queries.
• Used Collections like variable arrays, nested tables extensively.
• Performed the Data modeling using Erwin.
• Worked with various business groups, functional experts to implement their business and functional Knowledge into working Procedures.
• Used the PVCS tracker for bug tracking and PVCS for code versioning.

Environment: Oracle 9i, SQL Server 2000, Java, J2EE, Windows 2003, Unix, SQL, PL/SQL, T-SQL, Shell Programming, SQL Loader, PVCS, PVCS Tracker, Autosys, Erwin and SQL Navigator.

Confidential

ETL Developer

Responsibilities:

• Analyzed the Specifications and identifying the source data needs to be moved to data warehouse.
• Developed the pre post session shell scripts, which will create the parameter file dynamically.
• Involved in various discussions with end user to analyze Meta data.
• Used different Data Warehouse techniques like Star-Schema, snowflake schema.
• Extensively involved in creating database packages, procedures, functions, cursors and triggers using
• PL/SQL.
• Analyzed and Created Facts and Dimension Tables.
• Extracted data from different systems into Source.
• Extensively used Informatica ETL tool for Lookup, Aggregator, Router, Filter, Expression transformations.

Environment: PowerCenter 7.1, Oracle, DB2, MS SQL Server, SQL, PL/SQL, Erwin, Windows NT/2000.