SUMMARY:

• 15+ years of total IT experience with Development, Maintenance, Testing and Documentation phases of software life cycle.
• Over 10 years of Data Warehousing, Data Analysis, Reporting, ETL, Development, Maintenance, Testing and Documentation.
• Extensively used Ralph Kimball methodologies.
• Manged offshore ETL Developers.
• Extensively used Agile, waterfall Project methodologies.
• Technical expertise in ETL tools Informatica (Server Manager, Repository Manager, Designer Client tools, PowerCenter 10.1/9.6/8.1/7.1/6.2/5.1, Power Exchange, Workflow Manager, Workflow Monitor, Repository Manager), Power Connect, SQL Server and SQL Loader and teradata.
• Expertise in working with SQL Server, Oracle, Db2 UDB, PL/SQL, Toad and Erwin.
• Involved in functional and technical Systems Analysis & Design, Systems architectural design, Presentation, Process interfaces design, process data flow design, and system impact analysis, Gap analysis, Feasibility analysis and design documentation and presentation.
• Expertise in application development with full lifecycle experience of implementing large client/server Applications.
• Strong in Triggers, Stored Procedures, Functions, Design, Creation, Migration, Upgrading, Performance Tuning, Logical and Physical Design, Installation and Upgrade of Database, as well as managing the Object and System Privileges.
• Involved in Unit Testing, Integration testing and Performance testing.
• Experience in leading, Mentoring, coordinating with teams in an Onsite - Offshore model.
• Technical Coordination - Coordinate with the developers and assist them with various functionality.
• Experienced in working with business users, business analysts, IT leads and developers in analyzing business requirements and translating requirements into functional and technical design specifications.

TECHNICAL SKILLS:

ETL Tools: Informatica Power Center 10.1/9.6/8.6.1, DMExpress and Data Stage

Rdbms: Oracle 11g/10g/9i/8i/8.x/7.x, Teradata, SQL Server 2005 and Db2

ERP: SAP R/3

Languages: SQL 2012/2014/2016, PL/SQL, TSQL, C, C++, Java, Perl/Cgi, Shell Scripts

Data modeling tool: ERWIN

OS: UNIX (Sun Solaris, AIX), MS WINDOWS 2000/9x/NT

PROFESSIONAL EXPERIENCE:

Confidential

Informatica/ ETL Developer

• Created BRD, PDE List and Source data validations for PEAKS ADS.
• Created BRD and PDE lists for GMPP/GDPP Projects.
• Created CRR Data Warehouse for Reg reporting purspose.
• Created ETL mapping documents.
• Development, test and maintenance of the various mappings, mapplets and workflows.
• Created stg region, stg company, stg opcntr, stg substn, stg targets, stg target type, stg acts, dim region and several mappings for CRR Project.
• Created PDE lists for App codes 102, 860 and FAL.
• Created Data Profiling for App codes 102, 860 and FAL.
• Worked on defects and Incidents.
• Tested Informatica mappings and mapplets, Sessions, Batches, and the Target Data.
• Analyzed the explain plans for queries used by reports and tuned them for efficiency.
• Manged offshore ETL Developers.
• Worked on resolutions for Production issues on a daily basis.
• Worked closely with Reporting team.
• Created Stories using Rally tool.
• Used Agile project methodologies.

Environment: Informatica Power Center 9.6, SQL 2016, Unix and TOAD,teradata

Confidential, Greensboro,NC

Lead Informatica/ ETL Developer

• Involved in the ETL process to migrate the Legacy data to SAP system.
• Created ETL mappings using Informatica Power Center tool.
• Wrote several mappings for CR-258,CR-298, CR-299, CR-300 and CR-350 to load data from Legacy system to SAP system.
• Worked on Production support of R1 and R-2 releases.
• Tested Informatica mappings and mapplets, Sessions, Batches, and the Target Data.
• Created several UNIX Shell scripts.
• Created job scheduling process with Autosys tool.

Environment: Informatica Power Center 9.6, Db2, SAP BW, SQL 2014, Autosys, Unix Shell Scripts,teradata.

Confidential, Cary, NC

ETL Developer

• Responsible for analysis, design, development, and testing for ETL solutions.
• Extensively used Ralph Kimball methodologies.
• Developed and tested various mappings and mapplets in the ETL process.
• Created mapping documents for Duke Energy’s DSDR & Next Generation Demand Response projects.
• Created staging, dimensions and fact mappings for DSDR and NGDR.
• Created stg region, stg company, stg opcntr, stg substn, stg targets, stg target type, stg telvent, dim region and several mappings for DSDR and NGDR Projects.

Environment: Informatica Power Center 9.1/9.5, Oracle 10g, SQL 2012, Db2, SQL Server

Confidential, PA

Informatica/ETL Developer

• Responsible for conducting testing of Informatica mappings.
• Created Expenses data mart for internal users.
• Used Ralph Kimball methodologies.
• Creating detailed technical mapping documentation and involve in the day to day operations of development and test phases of the project.
• Created mappings for Business Party, address, address link and Product mappings for staging environment and data mart.

Environment: Informatica Power Center 9.0, Oracle, Flat files, Unix and Windows NT

Confidential, Wilmington, DE

Informatica developer

• Development, test and maintenance of the various mappings, mapplets and workflows involved in the ETL process to migrate the SAP data.
• Wrote several mappings to load QM/INSPL, Normal Accounting, Manufacturing BOMS, Recipes related data from SAP source to target DB2 tables and generated flat files.
• Used Sybase database as a Staging area for this conversion project.
• Extensively used Transformations like Router Transformation, Aggregator Transformation, Source Qualifier Transformation, Joiner Transformation, Expression Transformation and Sequence generator.
• Tested Informatica mappings and mapplets, Sessions, Batches, and the Target Data.
• Analyzed the explain plans for queries used by reports and tuned them for efficiency.

Environment: Informatica 8.6.1/7.1, Power Center 8.6.1/7.1, Sybase, Db2, Unix and Windows NT

Confidential, VA

Informatica Developer

• Created TRI data mart for internal and public users.
• Requirement gathering, functional and technical specification, Application support, Documentation and testing.
• Developed and tested various mappings and mapplets in the ETL process.
• Extensively used Transformations like Router Transformation, Aggregator Transformation, Source Qualifier Transformation, Expression Transformation and Sequence generator.
• Tested Informatica mappings.
• Created mappings to handle history data for AD HOC reports.
• Wrote PL/SQL Stored Procedures, Triggers and Functions.
• Performed Informatica Administator tasks like server shut down, restart, creating user profiles and project folders.

Environment: Informatica 7.1/8.1, Power Center 7.1/8.1, Oracle 10g, PL/SQL and Windows NT.

Confidential, Newark, CA

Senior Informatica developer

• Created ARDW (Accounts Receivables Data Warehouse) for Confidential business users group, ARDW is used to analyze the Accounts receivables data related to customers.
• Prepared Business Requirement Documents.
• Translate the functional specification into Detail Design.
• Wrote PL/SQL Stored Procedures, Triggers, Functions, Packages, Cursors to process the actual and compute commission based on the commission plan and goal.
• Requirement gathering, functional and technical specification, Data Cleansing, Data Design, Data Modeling, Application support, Documentation and testing.
• Design, Development and tested of the various mappings and mapplets in the ETL process.
• Wrote Gl accounts, Gl company, Gl management company, Currencies, Customers, Transactions, Trx lines, Ardw measures, Balannce measures, SalesOrders, DSO mappings to extract data from multiple sources like ERP (Oracle Apps,Oracle) to Oracle Data Warehouse.
• Identified and evaluated the best sources of data both internal and external, data quality analysis, defining and designing the process to extract, transform and load source data into data warehouses and data marts.
• Environment: Informatica 7.1, Power Center 7.1, Erwin, Oracle 9i, ERP, PL/SQL, Unix and Win NT.

Confidential, Omaha, NE

Lead - Informatica / ETL Developer

• Requirement gathering, functional and technical specification, Data Cleansing, Data Design, Data Modeling, Administration, Production and Application support, Documentation and testing.
• Design, Development and maintenance of the various mappings and Mapplets involved in the ETL process.
• Wrote several mappings to load claims related data from multiple sources like ERP (SAP and People Soft) and Mainframe data to Oracle Data Warehouse.
• Used Power center, Repository Manager to maintain various folders for various DataMarts.
• Installed configured and tuned Informatica 7.0/6.2 and also provided support.
• Datawarehouse database was setup using the STAR schema architecture using the Oracle 9 server.
• Testing of Informatica Mappings, Sessions, Batches and the Target Data.
• Mentored the team in the development.
• Environment: Informatica 7.0/6.2, Power Center 7.0/6.2, Erwin, Brio, Oracle 9i, PL/SQL, People Soft, SAP, Main Frame, IBM DB2, Unix and Windows NT.

Confidential, San Francisco, CA

Sr. ETL Specialist

• Design, development, testing phases of Data Warehouse.
• Analysis, requirement gathering, functional/technical specification, development, deploying and testing.
• Involved in Design and Data Modeling using Star Schema.
• Logical & Physical Database Layout Design using Designer 6i/2000.
• Fixed invalid Mappings, testing of Stored Procedures and Functions, Unit and Integration Testing of Informatica Sessions, Batches and the Target Data.
• Wrote several mappings to load claims related data from multiple sources to Data Warehouse.
• Performed Data Conversions.
• Wrote several triggers to load data based on the input. Unit testing PL/SQL Stored Procedures & triggers, and Performance Tuning
• Wrote Design documents, Unit test plans related to Claims, vendors and Payment History details.