SUMMARY

• Extensive experience wif expertise in analysis, design, development and implementation of Data Warehousing and Business Intelligence applications using ETL and BI tools such as Oracle, DB2, MS SQL server, and Teradata databases on windows and UNIX platforms.
• Have experience in tool selection and implementation, requirements gathering, project and team leadership and mentoring to junior developers.
• Expert level experience in Data Integration and Data Warehousing using ETL tool INFORMATICA PowerCenter 7.x/8.x/9.x (Source Analyzer, Warehouse Designer, Mapping/Mapplet Designer, Sessions/tasks, Worklets /Workflow Manager), Datastage 8.7(Designer, Director), Pentaho (Integration Designer) and complete noledge of data warehouse methodologies (Ralph Kimball, Inmon), ODS, EDW, and Metadata repository.
• Hands on experience of Informatica tools Power Exchange, Power Analyzer, Power Connect, Data Mart, OLAP and OLTP.
• Worked on Agile Driven project and very well aware of sprint planning, daily stands ups.
• Experience integrating Salesforce connector, Powerexchange connector for Mainframe wif in PowerCenter.
• Expert - level mastery in designing and developing complex mappings to extract data from diverse sources including flat files, RDBMS tables, XML files, applications, Teradata, SAP sources and proficient in implementing complex business rules by creating reusable transformations, Workflows/Worklets, and Mappings/Mapplets.
• Experience in SQL Tuning, Optimization, rule based optimization, cost based optimization and Hints.
• Experienced in using Business Objects XI R2 and Cognos 8.4 Report Developer to build user defined queries, reports to enable drill-down and slice and dice analysis on multiple databases.
• Strong expertise in relational data base systems like Oracle, SQL Server, MS Access, Teradata, DB2 design and database development using SQL, PL/SQL, SQL PLUS, TOAD, and SQL-LOADER.
• Highly proficient in writing, testing, and implementation of triggers, stored procedures, functions, packages, and cursors using PL/SQL.
• Experience in Task Automation using UNIX Shell Scripts.
• Excellent analytical, problem solving, and communication skills wif ability to interact wif individuals at all levels.
• Flexible to work using new technologies.

TECHNICAL SKILLS

ETL Tools: Informatica Power Center/Power Mart 9.x/8.x/7.x, Informatica Cloud, Power exchange 9.5, DataStage 8.7, Pentaho, SSIS.

Analysis/Reporting Tools: Business Objects 6.x/XI R2, Cognos 8.4, Oracle Discoverer 10g and OBIEE.

Data Modeling: Erwin, NORMA and MS Visio.

Scheduling Tools: Autosys, TWS,Control-m, DAC, Stone Branch, OPCON.

Databases: Oracle 11g/10g/9i/8i, MS SQL Server 7.0/2005/2008, DB2, Teradata V2R6, MS Access

DB Tools: SQL*Plus, SQL* Loader, NEXUS, TOAD 8.5, BTEQ, Teradata SQL Assistant, Teradata Loader Utilities (Multi-Load, Fast-Load)

Languages: C, C++, JAVA.

Environment: UNIX, HP-UX, IBM-AIX, LINUX, WINDOWS XP/NT/2000

Languages: SQL, PL/SQL, T-SQL, XML, UNIX, Shell Scripting

Other tools: BMC Remedy, PVCS Tracker, Clearquest, SharePoint and Visual Source Safe.

PROFESSINAL EXPERIENCE

Confidential, MN

Sr Consultant

Responsibilities:

• The main Objective of the BIMECC project is rewrite the ETL code to replicate the operational datastore in to stage environment to avoid direct connections to the transactional system for Medtronic energy component center(MECC).
• Worked on performance tuning and design issues wif current ETL loads.
• Extensively worked on Factory works, Test Vault, 3C, Kronos and JDE sources to bring data to the Datawarehouse for reporting
• Extensively used Re-usable Objects like Informatica Mapplets.
• Performance Fine-tuned sources, targets, mappings, and sessions to improve the performance.
• Extensively worked on migration of existing jobs on Autosys to TWS and making sure the job dependencies stay the same.

Environment: Informatica 10.1/10.2, Oracle 12c, SQL Server 2016, TWS, Toad 12.12, Service Now, WINCP, and Unix.

Confidential

ETL Informatica Consultant

Responsibilities:

• Validate existing template workflow to test Informatica 10.1.1 on the sandbox environment to ensure smooth upgrade wif other environments
• Involved in all phases of the project planning, design, construction
• Involved in tweaking the whole ETL design for better performance of big parameter tables
• Including Dev, UAT and Prod, setting the configuration files which is done in the specified tables and created technical specs documents for all the enhancements
• Create jobs on mainframe using JCL to update front-end screens data for production support tasks

Environment: Informatica 10.1.1, Mainframe, PowerExchange, My Passport, SQL Server 2010, Oracle 11g, Filezilla, ServiceNow

Confidential, MN

Sr Consultant

Responsibilities:

• Developed ETL code using Informatica to reflect the business requirements.
• Communicated wif business customers to discuss the requirements and enhancements.
• Created shell scripts to fine tune the ETL flow of the workflows.
• Did the Performance tuning at the functional level and at the mapping level and used SQL overrides to minimize data transfer over the network.
• Effectively used Informatica parameter files for defining mapping variables, workflow variables, and relational connections.
• The main objective of the data conversion project is to convert Legacy JDE and SAP Data to Medtronic SAP Data so dat going forward Covidien’s business can be fully functional through Medtronic applications.
• The main Objective of the BIMECC project is rewrite the ETL code to replicate the operational datastore in to stage environment to avoid direct connections to the transactional system for Medtronic energy component center(MECC).
• Worked on performance tuning and design issues wif current ETL loads.
• Extensively worked on Material Classification, Business Partner Collection and Disputes Modules wif in SAP System.
• Used SAP LSMW and IDoc programs to load Data Files.
• Extensively used Re-usable Objects like Informatica Mapplets.
• Utilize Informatica cloud to bring the data from force.com and wrote data replication tasks to stage the data in to the warehouse.
• Performance Fine-tuned sources, targets, mappings, and sessions to improve the performance.
• Wrote Informatica mappings as a wrapper tool to load the stage tables using conversion SQL.
• Expertise in setting up Informatica jobs in Autosys for daily, monthly loads.
• Extensively worked on migration of existing jobs on Autosys to TWS and making sure the job dependencies stay the same.
• Developed Informatica Pre-Session and Post-Session UNIX scripts to automate the data load processes to target data warehouse.
• Extensively used oracle tuning techniques to improve the performance on the one-time data conversion loads to save time during cut-over simulation.

Environment: Informatica 9.6/10.1, Oracle 12c, SQL Server 2016, Autosys, TWS, Toad 11.6, SAP, Service Now, WINCP, and HP ALM, Windows.

Confidential, MN

Sr ETL Consultant

Responsibilities:

• Extensively involved in studying the business requirements and developed the mapping specifications from the business requirements and the data model.
• Developed Informatica Mappings and Sessions based on mapping specifications to load data from source flat files and RDBMS tables to target tables.
• The CEF project source data (flat files, relational databases) is extracted from all the transactional systems and loaded into the data warehouse, which is the union of all the constituent pieces of the TCF businesses like Digital, Online banking, Customer Service, Teller etc.
• Distributed the data from Worktables to many stage tables using Informatica.
• Repository administration such as creating repositories, folders, managing groups, users, and security.
• Part of Informatica Upgrade project to prepare test plan for workflows, batch scripts and Transmission jobs.
• Created multiple environments in database and corresponding folders in Informatica to ensure parallel development/QA during sprints.
• Extensively used Re-usable Objects like Mapplets to decode and encode PCI/NPI compliance data.
• Extensively worked wif MOVEIT team to setup inbound and outbound file transfers for the project.
• Prepared Run book, job flows and other SLA documents for CEF and EMV Projects.

Environment: Informatica 9.1, Oracle 11g, Toad 11.6, Service Now, MOVEIT, Mainframe, WINCP, StoneBranch, Rackspace and HP ALM, Windows.

Confidential, Saint Paul, MN

Sr ETL/Informatica Consultant

Responsibilities:

• Involved in all phases of the project planning, design, construction.
• Actively working on a PeopleSoft Conversion project for HR based system.
• Involved in the migration of all legacy TACHY devices to the new Dragon NXT environment.
• Involved in tweaking the whole ETL design for better performance of big Parameter tables.
• Created Materialized views for different business lines and delivered the files through EAI adapters.
• Worked on data management strategy to setup ETL competency center for BSC to standardize the integration process overall.
• Experience in using PL/SQL oracle packages such as DBMS STATS, DBMS JOB and UTL FILE.
• Followed agile methodology principals to deliver the code to production faster wifout unnecessary documentation.
• Used Bulk and FORALL to improve the performance of PL/SQL blocks.
• Worked wif management in project origination & halped in creating some POC’s for testing the performance of the new servers and handling the physical deletes of the records from the source system.

Environment: Informatica 9.5, PL/SQL, SQL Server 2008, Oracle 11g, HP-UX, Toad 11.5, SQL server Management Studio, WINCP and IBM Clearquest.

Confidential, MN

ETL Lead/Admin

Responsibilities:

• Implemented a new Customer Relationship Management (CRM) data warehouse for the 4 PCG Metro Trust Advisory Centers for Wealth management bank customers.
• Developed Informatica Mappings and Sessions based on data mapping specifications to load data from Powerexchange Datamaps on mainframe and RDBMS tables to SQL Server Target tables.
• Developed baseline estimates for future Salesforce.com Project and wrote high-level data requirements.
• Developed Load Routines in powercenter to load data from force.com using salesforce connector.
• Developed change data capture(CDC) mapping routines using Powerexchange.
• Involved in working wif Implicit Cursors, Explicit cursors and Ref Cursors for writing PL/SQL store procedures.
• Tuned long running Source qualifier SQL queries and also halped the Super users to tweak adhoc SQL queries for better performance.
• Experience working wif XML data using XML Parser transformation for a compliance business user.
• Created the migration documents to migrate the Informatica, UNIX scripts using Informatica repository manager and Powerexchange Navigator.
• 24x7 production support on rotation basis among the ETL team members.

Environment: Informatica 9.5 Powercenter, and Powerexchange, Salesforce, DB2, SQL Server 2008, PL/SQL, LINUX, SSIS, SQL server Management Studio, Powerexchange Navigator.

Confidential, MN

ETL Lead/Admin

Responsibilities:

• Worked closely wif our Business line to understand their technical landscape and standards, source data models, data quality issues, information needs/requirements and translate them into ETL requirements specifications.
• Developed complex parallel jobs using DataStage designer and Quality Manager.
• Worked on production support tickets in ITSM and prioritized/triaged tickets in the weekly support calls.

Environment: IBM InfoSphere Datastage 8.7, DB2, SQL Server 2008, LINUX, SSIS, SQL server Management Studio, WINSQL.

Confidential, MN

Sr. Informatica Consultant

Responsibilities:

• Involved in integration of data sources like flat files, SQL server, DB2, Oracle for IP Science project to the Enterprise Data warehouse (EDW).
• Extensively used MD5 functionality wif in informatica to implement change data capture(CDC) to Improve the performance of the loads.
• Developed ETL Specifications, Mappings for WESTIP data source according to the Thomson’s data warehousing coding guidelines.
• Developed, documented and executed unit test plans.

Environment: INFORMATICA 9.1, Oracle 11g, SQL Server 2005, LINUX, Business Objects 3.1, TOAD 10.1, WINSQL.