SUMMARY:

• Over 8+ years of experience in analysis, design, development and implementation of Client/Server and Data warehouse applications.
• Strong experience in designing and developing Business Intelligence solutions in Data Warehouse/Decision Support Systems using ETL tools, Informatica PowerCenter 8.x, 9.x.
• Experience in Repository Configuration, creating Transformations and Mappings using Informatica Designer and processing tasks using Workflow Manager.
• Knowledge in designing Dimensional models for Data Mart and Staging Database.
• Experience in Installation, Configuration, and Administration of Informatica Power Center 7.x, 8.x, 9.x,10.x Client/Server.
• Responsible for interacting with different Business Partners, Vendors & Customers to identify information needs and business requirements for reports.
• Experience in documenting Design specs, Unit test plan and deployment plan.
• Experience in Oracle as Pl/SQL Developer.
• Experience in data integration of various data sources from Databases like MS Access, Oracle, SQL Server and formats like flat - files, CSV files and XML files.
• Experience in Performance tuning of Informatica (sources, mappings, targets and sessions) and tuning the SQL queries.
• Working knowledge of a variety of Relational DBMS products, with experience in designing and programming for relational databases, including Oracle, SQL Server, Teradata, DB2.
• Experience in design and implementation using ETL tools like Informatica (Power Center) Designer, Repository Manager and Workflow / Server Manager.
• Experience in creating various transformations using Aggregator, Look Up, Update Strategy, Joiner, Filter, Normalizer, Sorter, Router, XML, Stored procedure in Informatica Power Center.
• Extensive knowledge in handling Slowly Changing Dimensions (SCD) Type 1/2/3.
• Developed excellent professional skills by working independently and also as a team member to analyze the Functional/ Business requirements and to prepare test plans, test scripts.
• Experience working with SDLC, SCRUM, RUP, Waterfall and Agile methodologies.
• Reliable, responsible, hardworking and good team player.

TECHNICAL SKILLS:

ETL Tools: Informatica 10.x/9.x/8.x/7.x, SQL Server Integration Services (SSIS).

Relational DBMS: Oracle 8i/9i/10g/11g, SQL Server 2000/2005/2008, Teradata v2R4/R6, DB2.

Data Modelling Tools: Rational Rose, ERWin, Visio.

Reporting Tools: Business Objects 6.x/XI, Cognos 8.4/10.2, MicroStrategy 7.1.5.

Scheduling Tools: Tivoli Work Scheduler (TWS) 8.3, Autosys, Crontab.

Operating Systems: Windows 95/98/00/NT/XP, HP-UNIX, SUN-OS, MS-DOS, MVS, z-OS.

Languages: C/C++, Java, JavaScript, HTML, XML, VB, SQL, PL/SQL, T-SQL.

Tools: TOAD 9.x/10.x/11.x/12.x, SQL Query Analyzer 8.0, Oracle SQL Developer 1.1.2Teradata SQL Assistant 7.1.0, SQL * Plus, Eclipse, NetBeans, PVCS, SCM.

PROFESSIONAL EXPERIENCE:

Confidential, Washington, DC

Sr. ETL Developer

Responsibilities:

• Designed and developed ETL strategies and mappings from source systems to target systems. ETL strategies were designed to cater initial and incremental load.
• Worked with production support team to fixes and enhancements on the problems identified in the existing system.
• Worked on multiple defects from different projects at the same time.
• Developed and tested Informatica mappings to load new, modified and deleted data with history.
• Worked with source teams to resolve data quality issues raised by end users.
• Participated in Code Review sessions.
• Applied scripts in production for correcting the incorrect data on the tables.
• Created Test Case/Test Log documents and SQL queries for Unit and System Testing.
• Created, maintained and comminuted all the data refresh request by creating mappings to load data from production environments to lower environments.
• Successfully identified and removed the erroneous data from the core tables and intermediate tables using SQL scripts.
• Implemented performance-tuning techniques by identifying and resolving the bottlenecks in source, target, transformations, mappings and sessions.
• Used debugger to validate the mappings and gain troubleshooting information about data and error conditions.
• Analyzed Session Log files in case the session failed to resolve errors in mapping or session configurations.
• Extensively used PL/SQL Procedures/Functions to build business rule.
• Developed post and pre session shell scripts and scheduled Event based sessions at the Informatica workflow manager.
• Transferred Knowledge on the System to new team members.

Environment: Informatica PowerCenter 9.6/9.5/9.1, Informatica Data Quality 9.1,Oracle 12g/11g, TOAD, SQL Developer, Winscp, XML SPY, Putty, Tidal, SQL* Loader, HP ALM, Sun Solaris Unix and Windows Enterprise 2008

Confidential, Dayton, Ohio

Sr. ETL Developer

Responsibilities:

• Participated in the business analysis process and the development of ETL requirements specifications.
• Involved in Source Data Analysis & Data Profiling and prepared Mapping Specification document based on Data Analysis & Profiling results.
• Prepared Technical Design Document based on Mapping Specification and HLD.
• Developed various mappings for Billing, Claims, Payment process, Lockbox process, Pharmacy, Medicare, Med claim and Decommissioned mappings.
• Utilized Lookup, Aggregator, Joiner, Union, Expression, Filter, Update strategy, Sql and Normalizer, Router, Transaction Control, Sequence Generator, Source Qualifier transformations to model various standardized business processes and implemented business logics.
• Implemented slowly changing dimensions (SCD) - type I & II in different mappings as per the requirements and performed target load order in multiple target instances.
• Increased code reusability using shortcuts, mapplets, reusable transformations, re-used mappings, reusable sessions and worklets to reduce redundancy in code.
• Handled versioning and dependencies in Informatica.
• Created and maintained the shell scripts and parameter files in UNIX for the proper execution of Informatica workflows in different environments.
• Involved in extensive performance tuning by determining bottlenecks at various points like targets, sources, mappings, sessions or system.
• Extensively used Debugger to validate the mappings and gained troubleshooting information about data and error conditions.
• Prepared the error handling document to maintain the error handling process.
• Used PL/SQL procedures/functions in mappings to build business rules to load data.
• Used Pushdown Optimization to push the transformation logic on to the Database both on the Source and the Target sides where ever possible to improve performance of the mapping.
• Monitoring the ETL jobs, generating tickets and fixing the bugs in HP ALM.
• Extensively used Tidal Enterprise Scheduler for running the shell scripts, performing actions, event tasks, scheduling the workflows and dynamically updating the parameter file.
• Participated in daily Confidential scrum meetings, monthly retro meetings, IT Staff team meetings and training sessions.

Environment: Informatica PowerCenter 9.6/9.5/9.1, DB2 UDB, Informatica Data Quality 9.1, Teradata 14/13, Oracle 12g/11g, TOAD, SQL Developer, Surveyor, Winscp, XML SPY, Putty, Tidal, SQL* Loader, HP ALM, QVCS, Sun Solaris Unix and Windows Enterprise 2000

Confidential, Detroit, MI

Sr. Informatica Developer

Responsibilities:

• Studied the existing environment and accumulating the requirements by querying the database on various aspects.
• Identification of various Data Sources and Development Environment.
• Extensively worked on extracting the data from various flat files (fixed width, delimited), applying the business logic and then loading them to the oracle databases.
• Developed complex mappings using transformations such as the Source qualifier, Aggregator, Expression, Lookups, Filter, Router, Sequence Generator, Update Strategy, and Joiner.
• Used Informatica power center for (ETL) extraction, transformation and loading data from heterogeneous source systems.
• Retrieved data from the Oracle CDC Staging tables.
• Participated in discussion with the Business users Data architects in gathering the requirements and finding the data needs.
• Participate in the discussions with the business solutions team in creating and implementing the plans for the designs like Flow Chart diagrams, Conceptual and Logical Diagrams, and defining the terms on the needs of the project.
• Designed and developed complex mappings to load the Historical, Weekly and Daily files to Oracle database.
• Designed and Developed Oracle PL/SQL and Shell Scripts, Data Import/Export, Data Conversions and Data Cleansing.
• Created different move-it jobs to have inbound/outbound transition of files between Confidential and different vendors.
• Developed PL/SQL and UNIX Shell Scripts for scheduling the sessions in Informatica.
• Provide database coding to support business applications using T-SQL
• Built Autosys boxes which schedules the Informatica jobs at very frequent.
• Created E-mail notifications tasks using post-session scripts.
• Tuning the SQL queries as required. Created the PL/SQL Stored procedures, Indexes, Views.
• Create the data results through techniques and tools such as basic SQL queries, data mining, and multidimensional analysis.
• Performed unit testing and documented the results.
• Worked closely with QA team during the testing phase and fixed bugs that were reported
• Designed the Build Docs of the entire release/ project for the production support.

Environment: Informatica PowerCenter 9.5/9.1/8.6.1, DB2, Oracle 11g/10g, Oracle CDC, Oracle Business Intelligence Enterprise Edition (OBIEE 11g), AS400, Cognos, UNIX, MS ACCESS, MS EXCEL 2010, Autosys.

Confidential, Overland Park, KS

Sr. Informatica Developer

Responsibilities:

• Developed mappings/Reusable Objects/Transformation/mapplets by using mapping designer, transformation developer and mapplet designer in Informatica Power Center 8.6.1.
• Knowledge in upgrading from Informatica version 8.6.1 to 9.1.
• Created reusable transformations and mapplets and used them in mappings.
• Used Informatica Power Center 8.6.1 for extraction, loading and transformation (ETL) of data in the data warehouse.
• Implemented Informatica recommendations, methodologies and best practices.
• Implemented populate slowly changing dimension 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
• Involved in creation of Folders, Users, Deployment Group using Repository Manager.
• Worked on different data sources such as Oracle, SQL Server, Flat files etc.
• Created complex mappings in Power Center Designer using Aggregate, Expression, Filter, and Sequence Generator, Update Strategy, Union, Lookup, Joiner, XML Source Qualifier and Stored procedure transformations.
• Worked with command line program pmcmd to interact with the server to start and stop sessions and batches, to stop the Informatica server and recover the sessions.
• Wrote SQL, PL/SQL, stored procedures & triggers for implementing business rules and transformations.
• Created procedures to drop and recreate the indexes in the target Data warehouse before and after the sessions.
• Maintained Full and Incremental loads through Autosys on different environments like Development, Stage, Production and Test environment.
• Created deployment groups, migrated the code into different environments.
• Written ETL Specs and documentation to describe program development, logic, coding, testing, changes and corrections.
• Involved in managing the UNIX servers and defining the file systems/directory structures on the UNIX box for various parameters and deciding the disk space and memory requirements.
• Provided support to develop the entire warehouse architecture and plan the ETL process.
• Documented technical design documents and error logics.

Environment: Informatica PowerCenter 8.6.1, Informatica PowerExchange, Oracle 11g (TOAD and SQL Developer), PL/SQL, Teradata, Cognos & Tableau, UNIX, MS ACCESS, MS EXCEL 2007, Autosys SAP BW.

Confidential, Brooklyn, NY

ETL Consultant

Responsibilities:

• Imported various Sources, Targets, and developed Transformations using Informatica Power Center Designer.
• Developed various Mappings with the collection of all Sources, Targets, and Transformations.
• Created Mapplets using Mapplet Designer.
• Used Type2 mapping to update a slowly changing dimension table to keep full history.
• Captured source file/table definitions, target data, and data mart table definitions.
• Create and maintain metadata and ETL documentation that support business roles and detailed source to target data mappings.
• Involved in designing and extracting the transformations containing the XML Source Qualifier.
• Designed and developed complex Aggregate, Join, Router, Look up and Update transformation rules (business rules).
• Testing and validation of the developed Informatica mappings.
• Monitored sessions using Informatica Server Manager.
• Applied performance-tuning logic to optimize session performance.
• Wrote PL/SQL Packages, procedures, functions in oracle for business rules conformity.
• Utilized SQL loader, export/import utilities for data load and transformation.
• Developed PL/SQL stored procedures for source pre load and target pre load to verify the existence of tables.
• Worked with different databases such as Oracle and Flat files and used Informatica to extract data.
• Involved in Unit Testing, Integration, and User Acceptance Testing of Mappings.
• Worked with Senior Developer in Documenting the ER Diagrams, Logical and Physical models, business process diagrams and process flow diagrams.

Environment: Informatica Power center 8.1/7.1, Toad, Teradata DatabaseV2R5, Oracle 9i/8i, Erwin 4.1, SQL Plus, UNIX, Windows 2003, SQL*Loader.

Confidential

Programmer Analyst

Responsibilities:

• Used update strategy to effectively migrate data from source to target.
• Moved mappings from development environment to test environment.
• Interacted with the business community and database administrators to identify business requirements and data realities.
• Imported and created source definitions from Oracle, SQL Server, Sybase and flat files.
• Created design document Informatica mappings bases on business requirement.
• Created Informatica mappings using various transformations like Joiner, Aggregate, Expression, Filter and Update Strategy.
• Involved in performance improvement project.
• Involved in designing of testing plan (Unit testing and System testing).
• Tested scripts by running workflows and assisted in debugging the failed sessions.
• Improving workflow performance by shifting filters as close as possible to the source and selecting tables with fewer rows as the master during joins.
• Used persistent caches whenever data from workflows were to be retained.
• Used connected and unconnected lookups whenever appropriate, along with the use of appropriate caches.
• Created tasks and workflows in the Workflow Manager and monitored the sessions in the Workflow Monitor.
• Performance Maintenance including managing space, remove Bad Files and monitoring services.
• Set up permissions for groups and users in all Development Environments.
• Migration of developed objects across different environments.
• Also involved in conducting and leading the team meetings and providing Status report to project manager.

Environment: Informatica Power Center 8.x, Oracle 9i, PL/SQL, Windows, ERwin, DB2, Sybase 12.x/11.x and UNIX.