PROFESSIONAL SUMMARY:

• Strong working experience in the, Data Analysis, Design, Development, MDM, IDQ Implementation and Testing of Data Warehousing using ETL
• Strong working experience in Informatica Data Integration Tools - Designer, Workflow Manager, Workflow Monitor and Repository Manager.
• Proficient in all phases of the System Development Life Cycle (SDLC).
• Requirements Gathering, Data Scrubbing, Design, Development, Performance Tuning and Unit Testing.
• Experience in database design, Entity-Relationship Modeling and Dimensional Modeling.
• Extensively involved in creating Complex Mappings and reusable components like Reusable Transformations, Mapplets, Worklets and control tasks to implement reusable business logic.
• Excellent in coding SQL, PL/SQL Procedures, Functions, Triggers and Packages.
• Proficient in SQL Tuning to ensure best query performance.
• Excellent experience in creating UNIX scripts, scheduling jobs using Autosys, Tivoli schedulers.
• Worked Extensively on ETL process using SSIS package
• Assisted in Data modeling by creating Star schemas using MS Visio and Erwin tools.
• Primary activities include data analysis identifying and implementing data quality rules in IDQ and finally linking rules including Address Doctor to Power Center ETL processes and delivery to MDM Data Hub and other data consumers.
• Experience in enhancing and deploying the SSIS Packages from development server to production server.
• Developed business rules for cleansing/validating/standardization of data.
• Developed User Exits for implementing custom business rules.
• Defined System Trust and Validation rules for the base object columns.
• Developed MDM Hub Match and Merge rules Batch jobs and Batch groups.
• Created Query Groups and packages in MDM Hub Console.
• Extensively involved in creating Complex Mappings and reusable components like Reusable Transformations, Mapplets, Worklets and control tasks to implement reusable business logic
• Developed Slowly Changing Dimension Mappings of Type I, and II
• Experience in creating test scripts and performed Unit and Systems tests. Also provided,
• User Acceptance Testing Assistance and fixed bugs on the fly during testing.
• Extensively worked on Onsite-Offshore models. Participated in requirements gathering in onsite and transferred the knowledge to offshore.
• Organized and efficient to prioritize and manage multiple tasks even in a stressful environment with stringent deadlines.
• Excellent logical and analytical skills and strong ability to perform as part of a team.
• Proficient in shell scripting, unit testing, code migration/deployment, Pre and post production support, extensions, customizations and Maintenance. Experience in Creating ABAP Mapping in Power center with Power Connect for SAP .
• Used Informatica Power Connect for SAP to pull data from SAP R/3

TECHNICAL SKILLS:

Databases: Oracle 11g/10g/9i/8i, SQL Server2000/2005.

DB Tools: TOAD, SQL*Plus, SQL*Loader, PLSQL Developer

Oracle Tools: Oracle Reports 10g/6i, Oracle Forms 11g/10g/6i.

Language: SQL, PL/SQL, C, C++, Java.

ETL tools: Informatica Power Center 8.6/9.1/9.6

Data Modeling Tools: MS VISO, ERWIN, SSIS, and SSRS

Web Technologies: HTML, JSP, Servlets, VBScript

Scripting Languages: UNIX shell (Bourne and KORN) Scripting, Perl.

Test Automation Tools: Win Runner, Load Runner, QTP, and Test Director and Quality Center Center.

Version Control: CVS, SVN.

Operating Systems: Windows 98/2000/XP, HP UNIX, and LINUX.

PROFESSIONAL EXPERIENCE:

Confidential, NY

PLSQL/ETL Developer

Responsibilities:

• Involved in different phases of SDLC for all the new modules including Physical and Logical Design, Code Development, Testing, Implementing and Maintenance.
• Involved in creating Logical and Physical Models using MS VISIO 2007.
• Helped in designing and building data models using Embarcadero-ER studio.
• Analysed big data for genomics using PERL scripts.
• Good experience in developing ETL (Extraction, Transformation and Loading) procedures and Data Conversion Scripts using Pre-Stage, Stage, Pre-Target and Target tables.
• Developed Type 2 Slowly Changing Dimension (SCD) model using star schemas.
• Proficiently developed new Packages, Functions, and Stored Procedures using PL/SQL as well as modified the existing ones as per the user requirement.
• Extensively created Tables, Indexes, Views, and Sequences for the new modules.
• Experienced developing oracle forms based on views, tables and procedures in tabular and form layouts.
• Experience in Exception handling and experienced in agile environment.
• Created synonyms and granted privileges on schema objects for other users to be able to share and access content.
• Worked extensively with advanced features of PL/SQL like record and table types.
• Experience in using Explain Plan for query level performance tuning.
• Involved in periodic Performance Tuning and Unit Testing of the PL/SQL code by using appropriate joins, indexes, and partitions.
• Created SSIS Package for uploads and schedule them as SQL Server 2012 Agent. Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases.
• Analyzed the tables periodically to improve query response time.
• Coordinated with the offshore support team in resolving critical issues during the Production Run.
• Troubleshooting issues related to SQL, SSIS and SSRS.
• Worked with DBAs to analyze performance as well as during table space and schema lock issues.
• Performed Data Migration between different environments using DB Links
• Used other features like PL/SQL Wrapper, Hints, Materialized Views,
• Created standalone procedures using Dynamic SQL and cursors to migrate data within the same database.
• Extensive experience of promoting the new initiatives, enhancements and code fixes to various DEV and QA environments through the Deployment Process using UNIX platform.
• Worked with HTML development for the part of a project.
• Implemented SQL Cache dependency techniques in .NET for performance optimization.
• Extensively used TOAD for development and administration of various relational databases objects.
• Strong experience in Data Warehousing and ETL using Informatica Power Center 8.6.
• Proficiently used, created, and maintained various codes and SQL scripts on different branches of Clear Case (Version Control).
• Experience with Extreme Programming using Agile Methodologies.

Environment: Oracle10g, UNIX (Sun Solaris 5.8/5.9), SSIS, SSRS, TOAD 9.6, MS Visio 2007, HTML, Clear case, .NET, Informatica 8.6.

Confidential, Philadelphia, PA

PLSQL/ETL Developer

Responsibilities:

• Responsible for developing and testing of client application code related to US Business applications.
• Worked with Business Systems Analysts and Database Administrators to understand and implement functional and non-functional requirements into the project.
• Created and developed various DB objects like tables, views, materialized Views, partitioning tables, indexes, sequences, synonyms using TOAD. For the business application development.
• Involved in writing PL/SQL packages, procedures, and functions.
• Extensively used Materialized views and DB links for remote instances to retrieve data from other databases
• Developed ETL process (Extraction, Transformation and Loading of data into Data warehouse).
• Involved in developing scenarios for Unit, Integration testing to ensure that all the components work correctly when integrated.
• Interacting with the users and troubleshooting the problems involved with the development of stored procedures, Triggers and with the privileges.
• Modify existing ETL scripts to fix defects at the root cause as enhancement part of project.
• Exported reports into various formats like XML, PDF, HTML, EXCEL, and MS-Word.

Environment: Oracle 11g, PL/SQL, SQL, TOAD, Windows XP, UNIX, SQL*Loader, SQL*Developer, Putty, Tortoise SVN, Informatica Power Center 9.

Confidential, Atlanta, GA

ETL Developer

Responsibilities:

• Developed PL/SQL Procedures and UNIX Scripts for Automation of UNIX jobs and running files in batch mode.
• Involved in Database Tuning and Improved Application performance using Explain Plan, Hints, Stats, Indexes and SQL trace.
• Created Mail Scripts in UNIX to send notification on successful completion or failure of various Interfaces and Jobs, with Customized Subject and Text.
• Created JILs for scheduling the jobs in Autosys.
• Extensively used Putty to login into UNIX environment
• Extensively used software configuration management system, such as Subversion
• Developed UNIX scripts for transmitting files from the secure server to the customer specified server, using various FTP batch processes.
• Designed and developed Oracle Monthly Reports.
• Scheduled the execution of PL/SQL Procedures using UNIX Shell scripts for updating of Base tables from Transaction Tables.
• Automated data loading, extraction and report generation using UNIX Shell Scripting.
• Responsible for the Production Support and Code Fixing
• Worked on UNIX environment and shell scripting for creating Batch Jobs using UNIX KORN, AWK UNIX Shell Scripts and API’s Using PERL Scripts.

Environment: Informatica Power Center 8.6/8.1, Oracle 11g/10g, Qlik view 11, Teradata 13.0/12.0, PL/SQL, SQL*Loader, UNIX, Erwin, IDQ.

Confidential, Phoenix, AZ

ETL Developer

Responsibilities:

• Gathered business requirements from end users and authored requirement and specification documents.
• Used various Optimizer Hints to speed up the SQL queries.
• Used SQL*Loaders to download the data into warehouse database from the flat files and other data files across different platforms.
• Developed SQL and Shell scripts to create temporary tables and developed SQL*Loader scripts to load data into the temporary staging tables.
• Designed and developed forms using Oracle Forms 10g to allow the end users to manage the customer relation effectively and efficiently.
• Worked on creating Materialized Views to maintain copy of the remote data at local node.
• Mostly involved in code reviewing and performance tuning with optimization techniques in PL/SQL.
• Solving the complicated run time errors while running the process along with DBA team members.

Environment: Informatica Power Center 8.6/8.1, Oracle 11g/10g, Qlik view XI, Teradata 11.0/12.0, Autosys, PL/SQL, SQL*Loader, UNIX, Erwin.

Confidential, Chicago, Illinois

ETL Developer

Responsibilities:

• Involved in the development of database objects in both OLTP and OLAP databases.
• Addressing day-to-day issues with business users using tools like TOAD.
• Having good knowledge on Claims, Benefits, Provider and Contract affiliations.
• Created documentation for migration and performed extensive testing during the various phases of product implementation.
• Designed and developed the logic for handling Slowly Changing Dimension tables load by flagging the record using update strategy for populating the desired
• Developed reusable map-letsand transformations for reusable business calculations
• Used exception handling logic in all mappings to handle the null values or rejected rows
• Tuned the ETL components to gain the performance and to avoid business continuity.
• Worked with Persistent Caches for Conformed Dimensions for the better performance and faster data load to the data warehouse
• Involved in performance tuning and optimization of Informatica Mappings and Sessions using partitions and data/index cache to manage very large volume of data
• Performed query overrides in Lookup Transformation as and when required to improve the performance of the Mappings
• Design, develop, implement, and assist and in validating ETL processes.
• Did unit testing and development testing at ETL level in my mappings
• Involved in the Daily maintenance of the database that involved monitoring the daily run of the scripts as well as troubleshooting in the event of any errors in the entire process.
• Performed Unit Testing and Integration Testing of the Application. Involved in preparing documentation and user support documents.
• Load balancing of ETL processes, database performance tuning and capacity monitoring
• Developed and customized existing reports as per client specific requirements using Oracle Reports Builder 10g.
• Used Clear case for version controlling and Clear Quest for ticketing system.

Environment: Informatica Power Center 9.1/8.6/8.1, Oracle 11g/10g, Teradata 13.0/12.0, DB2 UDB, PL/SQL, SQL*Loader, UNIX, Erwin.

Confidential

ETL Developer

Responsibilities:

• Created the ETL design documentation, Mapping document, Migration document, Test cases.
• Extracted data from source systems, Applied complex transformation and then loaded in the Target table.
• Created Technical Specification documents based on high level requirement documents.
• Extensively worked in the performance tuning of programs, ETL procedures and processes.
• Error checking & testing of the ETL procedures & programs using Informatica session log.
• Worked in Teradata Utilities, Fastload, Bteq, multiload
• Performance Tuned Informatica Targets, Sources, mappings & sessions for large data files by Increasing data cache size, sequence buffer length and target based commit interval.
• Reviewed Technical specification documents with the functional owners.
• Developed parallel jobs using technical specification documents.
• Tested the jobs and data in Oracle.
• Reworking if any discrepancies in the flat file extracts.
• Fixing the Bugs raised during System and integration testing.
• Created Sequence jobs and scheduled them.
• Done Audit and Reconciliation for the data during SIT.

Environment: Informatica Power Center 9.1/8.6/8.1, Oracle 11g/10g, Teradata 10, PL/SQL, SQL*Loader, UNIX, Erwin.