SUMMARY 

• Over fifteen (15) years of professional experience in software development activities such as analysis, design, development and testing. Close to thirteen (13) years of experience in Data warehousing (DW) technologies.
• Over Thirteen (14) years of experience in Business Intelligence ETL tools like Informatica Power Center (9.1, 9.5 & 9.6.1) and Languages such as SQL & PL/SQL, Additionally, holds experience in business Intelligence reporting tools COGNOS 10, COGNOS 8.4, COGNOS Reportnet 1.1, Framework Manger, Report Studio, Analysis Studio, Event Studio, Transformer, Powerplay and Access Manager.
• Hands on technical experience as an Informatica Administrator and Oracle DBA supporting application development, data warehouse and production systems. Also, supported the implementation and administration of Powercenter ETL shared environments.
• Experience working with Data Architect in developing the Documentation on ETL Architecture, Scheduling Process, ETL Design Process like Mapping Specifications and Unit test plan.
• Strong understanding of DW concepts, designs, methodologies, tools, SDLC, and approaches.
• Experience in E - R modeling, Normalization, Data Profiling, Data Cleansing, Dimensional Modeling (Star schema, Snow-flake schema) to create Data Models, Logical and Physical design in Erwin implementing Industry accepted methodologies Bill Inmon, Ralph Kimball.
• Experience in AGILE Methodologies - Sprint Planning, Retrospective and Scrum.
• Worked on various projects related with various Relational Databases (RDBMS), Data Warehouse and ETL Tools.
• Good experience working on client/server, OLAP and ETL application development and tools using Informatica Power Center, Unix Shell scripting, Teradata, Oracle PL/SQL & SQL, PostgreSQL, HTML/DHTML, SQL Server 2000, DB2(UDB), MS Access, Data Extraction, Transformation and Loading, Data Movement Strategies and Analysis.
• Good experience working in Teradata, Teradata utilities (BTEQ, MLoad, FastLoad, Tpump), Teradata Manager etc.
• Good experience in Oracle Back-end SQL and PL/SQL Development i.e. Stored Procedures, Functions, Package & Triggers using SQL Developer and Toad as development tools.
• Excellent experience working with UNIX and UNIX shell scripting.
• Ability to meet deadlines and handle pressure in coordinating multiple tasks in a work/project environment.
• Strong communication, organizational and interpe rsonal competencies along with detail-oriented and problem solving skills in the technology arena.
• Ability to work individually as well as in a team with excellent problem solving and trouble-shooting capabilities.
• Self-motivated and committed person with excellent interpersonal communication skills and willingness to learn new tools, concepts and environments.
• Leader & Independent worker having strong background includes full life cycle project development, including analysis, solution design, coding, testing, implementation and ongoing support.

TECHNICAL SKILLS

Operating Systems Languages: Windows XP Professional, 2000 Professional SQL & PL/SQL, Windows NT 4.0, Windows 95, Windows UNIX shell scripting, Server 2003, UNIX, Linux, Sun Solaris 5.1 Windows Scripting, MS-DOS batch programmingDatabases & Database Tools Design & Development Tools Teradata 5.1 Release 2, 6.1 Release 2 Microsoft Visio 2000, Oracle 8.0, 8i, 9i & 10g Erwin, MS SQL Server 2012 COGNOS 10, GreenPlum COGNOS Transformer & Powerplay, Teradata SQL Assistant 6.2 & 7.1 Informatica Power Center 9.6.1 & 9.5, UDB DB2 8.1.8 Cronacle, AutoSys, Control-M, TOAD 7.6, PL/SQL developer

Internet development Additional Skills: VB Script & Java Script Visual Source Safe, HTML, DHTML MS Office Products, Active Server Pages (ASP) Project management, Microsoft Dynamics CRM

PROFESSIONAL EXPERIENCE

Confidential, Chicago, IL

Sr. Informatica Analyst/Developer

Responsibilities:

• Understand the business requirements, analyze them and do gap analysis for all new DWH/Integration projects.
• Developed various Mapping documents to integrate data from various source systems into EDW using Informatica Power Center.
• Extensively involved in source data analysis, data profiling and data cleansing.
• Participated in all DWH design discussions with BI architecture team.
• Helping offshore developers in giving best practices and solutions for issues.
• Performed team lead duties, assigned work to junior team members. Mentored members of Data warehouse with respect to Informatica software.
• Conducted peer design/code review with developers before code walk-thru with data warehouse architects.
• Conducted bi-weekly meetings with Informatica developers to resolve any pending issues/question or concerns.
• Involved in preparation of development Standards and Guidelines for Informatica, Unix Shell scripting, Flat file layouts.
• Developed mappings/Reusable Objects/Transformation/Mapplets by using mapping designer, transformation developer and Mapplet designer in Informatica Power Center 9.1.
• Designed and developed mappings using Source Qualifier, Expression, connected-Lookup and unconnected-Lookup, Router, Aggregator, Filter, Sequence Generator, Stored Procedure, Update Strategy, joiner & Rank transformations.
• Worked in various sources Flat Files, Oracle system, SQL Server, Informix to extract the data and store into DWH.
• Strong in debugging issues in Informatica.
• Created shell scripts to connect various systems across the globe to extract the property information in the form of flat files using shell scripts and load them to the DWH through Informatica.
• Used WinSCP, SFTP to Transfer files between servers.
• Performance tuning using Explain plan.
• Developed various complex stored procedures in PL/SQL.
• Involved in Data Analysis and reducing data discrepancy for the source and target schemas.
• Coordinated in setting up the development, test, production and contingency environment.
• Coordinated with the Informatica administration team during deployments.
• Working closely with users/developers and administrators to resolve the production problems by reviewing design changes.
• Implemented Type 2 Slowly Changing Dimensions to maintain the historical data in Datamart as per the business requirements.
• Involved in Performance tuning for time consuming loads in order to deliver the feed at the earliest to the business as these data are highly critical and the delay in the feed will impact the business.
• Utilized Push down optimization technique to improve the performance.
• Experienced in loading data into Data Warehouse/Data Marts using Informatica Power center and DB2 utilities.
• Exclusively worked with BI/QA teams in troubleshooting defects and escalating them to Architects and High level in case of defects in design and also worked in Data Quality Tickets for improving the performance in case of slowly running queries.
• Used Session parameters, Mapping variable/parameters and created Parameter files for imparting flexible runs of workflows based on changing variable values.
• Involved in creation of various Unix Scripts which help the ETL scheduling jobs & help in initial validations of various tasks.
• Wrote UNIX Shell Scripts for Informatica Pre-Session, Post-Session and Autosys scripts for scheduling the jobs (work flows).
• Involved in Converting and gathering necessary calculation of PL/SQL complex calculations into Informatica mappings.
• Thoroughly involved in all the phases of testing UNIT TESTING, PERFORMANCE TESTING and BUG FIXING etc.
• Involved in PowerCenter upgrade from version 9.5 to 9.6.1
• Created project plan for Development, QA and Production PowerCenter upgrade.

Environment: Informatica Power Center 9.6.1, XML, DB2 UDB, Oracle 10g, Microsoft SQL Server 2012, SQL, PL/SQL, UNIX Shell Scripting, Autosys.

Confidential, Lincolnshire, IL

Sr. ETL Consultant

Responsibilities:

• Understand the business requirements, analyze them and do gap analysis for all new requirements.
• Experience with loading data from many different sources includes SQL Server, flat files, and XML and translate business rules into ETL mapping rules.
• Created and maintained several ETL (Data Extraction, Transformation and Loading) mappings using Informatica Designer to extract the data from multiple source systems to target star schema designed tables. Used several transformations and mapplets to handle complex transformations of data.
• Development of shell scripts for data file handling and Archive process.
• Ability to program Unix shell scripts in applications that schedule, validate flat file data, execute SQL, archive files or FTP files.
• Ability to manage and manipulate large flat files with Unix commands.
• Extensively used SQL Queries for data validation/verification and overrides in Informatica as well as in using views, stored procedures and materialized queries to achieve maximum benefits of Informatica capabilities to run in heterogeneous environments.
• Tested the target data against source system tables by writing SQL queries.
• Performed Unit, Integration and system testing and provided UAT support to business partners.
• Participated in all phases of user acceptance testing with internal and external customers.
• Ability to write and execute comprehensive unit test plans, scripts and SQL.
• Performed “Performance Testing” in Pre-Prod environment for Informatica mappings before releasing code to production environment.
• Providing support for user Adhoc data requests.
• Performance Tuning of the existing projects in production.

Technologies: Informatica Power Center 9.5 (Repository Manager, Designer, Workflow Manager & Monitor), Microsoft Dynamics CRM, MS SQL Server 2012, SQL, PL/SQL, XML, Flat files, UNIX Shell scripting, SecureFX, SecureCRT, Control-M and Agile.

Confidential, Chicago, IL

DW/BI Technical Lead

Responsibilities:

• Responsible to handle and manage BI/DWH projects.
• Understand the business requirements, analyze them and do gap analysis for all new BI projects
• Participated in all DWH design discussions with BI architecture team for all BI projects.
• Participation in Informatica & Cognos Design Reviews.
• Responsible for creating and managing User requirements and technical requirements.
• Helping offshore developers in giving best practices and solutions for issues.
• Strong in debugging issues in Informatica.
• Involved in preparation of development Standards and Guidelines for Informatica, Unix Shell scripting, Flat file layouts and Cognos Reporting,
• Extensively involved in source data analysis and data cleansing.
• Created and maintained several ETL (Data Extraction, Transformation and Loading) mappings using Informatica Designer to extract the data from multiple source systems to target star schema designed tables. Used several transformations and mapplets to handle complex transformations of data.
• Scheduled Informatica batches to populate the datamarts on a regular basis using Workflow Manager, Used several tasks such as E-mail, shell commands, event raise, event wait, decision, timer etc. to build workflows and worklets.
• Used Informatica Workflow Monitor to monitor workflows, worklets and tasks.
• Work with DBAs to implement physical design and database objects and changes (DDL) per specifications.
• Used Teradata Utilities like MultiLoad, FastLoad and TPump in Informatica loads.
• Implemented Partion Primary index for range queries.
• Performance tune the SQL queries by creating Secondary index, Join index, PPI, checking the skew Factor, collect statistics.
• Monitor the tasks and queries using the Teradata Manager PMON.
• Development of shell scripts for data file handling and Archive process.
• Ability to program Unix shell scripts in applications that schedule, validate flat file data, execute SQL, archive files or FTP files.
• Ability to manage and manipulate large flat files with Unix commands.
• Extensively used SQL Queries for data validation/verification and overrides in Informatica as well as in using views, stored procedures and materialized queries to achieve maximum benefits of Informatica’s capability to run in heterogeneous environments.
• Tested the target data against source system tables by writing SQL queries.
• Performed Unit, Integration and system testing and provided UAT support to business partners.
• Ability to write and execute comprehensive unit test plans, scripts and SQL.
• Performed “Performance Testing” in Pre-Prod environment for Informatica mappings before releasing code to production environment.
• Assist production support team for all production issues.
• Involved in Informatica Administration tasks such as creating repositories, folders, DB connections, setting permissions, deploying objects from one environment to another environment, and maintaining/monitoring Informatica repositories/servers.
• Created framework manger models and packages using framework manager and published on Cognos Connection.
• Created complex and interactive reports in Report Studio.
• Analyzed the SQL to improve ETL/reports performance.
• Created dashboard reports in Report Studio to present data graphically
• Worked on migration from Cognos 8.3 to Cognos 10.
• Multidimensional analysis in Power Play structure.
• Created power play cubes using Transformer (Power Play).
• Creating Change requests for deploying the projects to Stage/Production environments.
• Assisting the COGNOS and Informatica Administrators in deploying the project to Stage/Production environments.
• Providing Warranty Support for the projects moved to production.
• Monitoring the projects moved to production and notifies the OPS team in case issue arises.
• Providing support for user Adhoc data requests.
• Performance Tuning of the existing projects in production.
• Tracking the enhancement and Bug Fix Change requests and implementing them.
• Responsible to coordinate with offShore team to manage the BI projects.

Technologies: Informatica Power Center 9.1 (Repository Manager, Designer, Workflow Manager & Monitor), XML, Qlikview, COGNOS 10, Framework Manager, Transformer, GreenPlum, Oracle 11i, Teradata Utilities (MLoad, FastLoad, TPump, BTEQ), SQL, PL/SQL, UNIX Shell scripting, Putty, WinSCP3, SecureCRT and Agile.

Confidential, Chicago, IL

Sr. DW/ETL Consultant

Responsibilities:

• Understand the business requirements, analyze them and do gap analysis for all new DWH projects.
• Developed mappings/Reusable Objects/Transformation/Mapplets by using mapping designer, transformation developer and Mapplet designer in Informatica Power Center 8.6.
• Designed and developed mappings using Source Qualifier, Expression, connected-Lookup and unconnected-Lookup, Router, Aggregator, Filter, Sequence Generator, Stored Procedure, Update Strategy, joiner transformations.
• Worked in various sources Flat Files, Oracle to extract the data and store into Oracle DWH.
• Strong in debugging issues in Informatica.
• Analyzed the SQL to improve ETL performance.
• Ability to write and execute comprehensive unit test plans, scripts and SQL.

Technologies: Informatica Power Center 7.1.4 & 8.6 (Designer, Workflow Manager and Monitor), SAS, Oracle 10G, UDB DB2 v8.1.8, Teradata, Teradata Utilities (MLoad, FastLoad, TPump), SQL, TOAD 9.0, Visio 2007, UNIX Shell scripting, Putty and Hummingbird.

Confidential

Sr. DW/BI Consultant

Responsibilities:

• Understand the business requirements, analyze them and do gap analysis for all new DWH projects.
• Developed mappings/Reusable Objects/Transformation/Mapplets by using mapping designer, transformation developer and Mapplet designer in Informatica Power Center 8.1.
• Designed and developed mappings using Source Qualifier, Expression, connected-Lookup and unconnected-Lookup, Router, Aggregator, Filter, Sequence Generator, Stored Procedure, Update Strategy, joiner transformations.
• Worked in various sources Flat Files, Oracle to extract the data and store into Oracle DWH.
• Analyzed the SQL to improve ETL performance.
• Ability to write and execute comprehensive unit test plans, scripts and SQL.
• Strong in debugging issues in Informatica.

Technologies: Informatica Power Center 8.1 (Designer, Workflow Manager and Monitor), Cognos 8.2 & 8.3, Framework Manager, Report Studio, Analysis Studio, Transformer, Oracle 10G, SQL, DB2, SQL Server, TOAD 9.0, UNIX Shell scripting, Putty, WinSCP3, SecureCRT.

Confidential, Chicago, IL

Sr. DW Developer/RM Team Lead

Responsibilities:

• Understand the business requirements, analyze them and do gap analysis for all new DWH projects.
• Developed mappings/Reusable Objects/Transformation/Mapplets by using mapping designer, transformation developer and Mapplet designer in Informatica Power Center 8.1.
• Designed and developed mappings using Source Qualifier, Expression, connected-Lookup and unconnected-Lookup, Router, Aggregator, Filter, Sequence Generator, Stored Procedure, Update Strategy, joiner transformations.
• Worked in various sources Flat Files, Oracle to extract the data and store into Oracle DWH.
• Strong in debugging issues in Informatica.
• Analyzed the SQL to improve ETL performance.
• Ability to write and execute comprehensive unit test plans, scripts and SQL.

Technologies: Informatica Power Center 8.1 & 7.1.3 (Designer, Workflow Manager & Monitor), Cronacle, COGNOS 8.3, 8.2 & 8.1, ReportNet 1.1 MR3 & MR2, Framework Manager, Cognos Access Manager, Transformer, Teradata SQL Assistant 7.1, Teradata Performance Monitor 7.1, Erwin, Oracle 10G & 9i, SQL, UNIX Shell scripting, Putty, WinSCP3, SecureCRT, Windows batch programming.

Confidential, KS

DW Lead Developer

Responsibilities:

• Understand the business requirements, analyze them and do gap analysis for all new DWH projects.
• Developed mappings/Reusable Objects/Transformation/Mapplets by using mapping designer, transformation developer and Mapplet designer in Informatica Power Center 6.1.
• Designed and developed mappings using Source Qualifier, Expression, connected-Lookup and unconnected-Lookup, Router, Aggregator, Filter, Sequence Generator, Stored Procedure, Update Strategy, joiner transformations.
• Worked in various sources Flat Files, Oracle to extract the data and store into Oracle DWH.
• Strong in debugging issues in Informatica.

Technologies: Erwin 3.5.2, SQL, PL/SQL, Oracle 8i, DB2, SQL Server, Flat Files, Informatica Power Center Designer 5.1.2/6.1,Informatica Power Exchange, Informatica Workflow Manager 6.1, Informatica workflow monitor 6.1, Informatica repository Manager 5.1.2/6.1,TOAD, Windows NT

Confidential

Responsibilities:

• Understand the business requirements, analyze them and do gap analysis for all new DWH projects.
• Developed mappings/Reusable Objects/Transformation/Mapplets by using mapping designer, transformation developer and Mapplet designer in Informatica Power Center 4.7.
• Designed and developed mappings using Source Qualifier, Expression, connected-Lookup and unconnected-Lookup, Router, Aggregator, Filter, Sequence Generator, Stored Procedure, Update Strategy, joiner transformations.
• Worked in various sources Flat Files, Oracle to extract the data and store into Oracle DWH.
• Strong in debugging issues in Informatica.
• Worked on gathering User Requirements, Created Cognos Impromptu Catalogs for Impromptu Reporting and Power Cube development.
• Created standard filters, calculations, prompts and conditions in catalog.

Technologies: Oracle 8.0, Informatica 4.7, Cognos Power Play 6.6, Cognos Impromptu 6.0, Transformer, Powerplay and Windows NT.

Confidential, Chicago

Responsibilities:

• Created Standard and Ad-hoc Impromptu Reports.
• Worked on gathering User Requirements, Created Cognos Impromptu Catalogs for Impromptu Reporting and Power Cube development.
• Created standard filters, calculations, prompts and conditions in catalog.
• Worked on Creating Impromptu reports using catalogs created from Data mart.
• Created and deployed multiple Transformer Models, PowerPlay Cubes.

Technologies: SQL Server, Cognos Power Play, Cognos Impromptu, Transformer and Windows NT