OBJECTIVE:

Seeking a position where more than 15years of Data Warehouse design, extensive ETL development and Relational Databases expertise and knowledge will add to organization value.

SUMMARY:

• Fifteen years of extensive experience in Information Technology with special emphasis on ETL design & development to support building Data Warehouses/Client - Server/e-commerce applications.
• Worked on all the phases of the Data warehouse life cycle that involves gathering requirements from business users, source to target ETL design documents creation, development, analysis & testing of the data in the Data warehouse.
• Practical understanding of the Data modeling (Dimensional & Relational) concepts like Star-Schema Modeling, Snowflakes Modeling, fact and dimension tables. Implemented Kimball and Inmon Methodologies based on the Clients Data warehouse usage and reporting needs.
• Strong database, data warehousing and ETL background under Oracle, Teradata, SQL Server and Informatica Power Center 5.1/6.2/7.1/8.1/8.6/9.1/9.5/9.6. Excellent understanding of data marts and multi-dimensional models, Legacy data, People soft HRMS data and SAP data and Business process integration using Web Methods.
• Mastery over the ‘ETL process’ with many years of experience in Extraction of the data from various source systems ranging from various RDBMS to flat files, Transformations using various kinds of transformations and Loading the transformed data into the Data Warehouse followed by the analysis of the loaded data with the help of OLAP tools.
• Strong Business Intelligence and OLAP experience under Cognos Report Net, Cognos PowerPlay, Business Objects 5.1/6.1/10i, OBIEE and Crystal Reports 8.5/10.
• Extensive client/server development experience using Visual Basic 6.0, C, Pro*C, Power Builder 5.0, Transact-SQL, PL/SQL and Java under UNIX operating system.

TECHNICAL SKILLS:

ETL Tools: Informatica Power Center/Power Mart 5.1/6.2/7.1/8.1/8.6/9.1/9.6 , Power Exchange 8.x.

ERP: People Tools 8.42.15, EPM 8.8, HRMS 8.4, SAP.

OLAP & Reporting Tools: Cognos series 8, Business Objects, Crystal Reports.

Data/Object Modeling Tools: Erwin 4.1/4.5/7.2, Oracle Designer, Power Designer 10.

RDBMS: Oracle 8i/9i/10g/R12, DB2 8.1/8.5, SYBASE, Teradata, MS Access 2000, Netezza, SQL Server 2000/2005.

Operating Systems: MS Windows 98/NT/2000/XP, UNIX (AIX, HP)

Languages: Java, C++, C, UNIX Shell Scripting, SQL, PL/SQLInternet Technologies:XML, HTML, DHTML, XSLT, UML, JavaScript, Perl.

WORK EXPERIENCE:

Confidential, New Carrolton, MD

Sr. ETL Lead Informatica Developer/Sr. ETL Architect

Responsibilities:

• Working as part of ETL Development team supporting various Business Units and getting data ready for Reporting teams by creating mappings, workflows and Unit test cases.
• Worked as the primary point of contact for 24x7 support schedule on a regular basis that involves running, monitoring and scheduling Informatica Workflows, Linux server issues, networking issues and database issues that cause workflow failures.
• Worked on remediating, troubleshooting and triaging the Informatica code failures and implemented transmittals which is deploying the code in Prod environment.
• Worked actively with the Development team for Performance tuning and identifying the bottle necks in Prod environment and worked closely with the DBA team and networking all along to get the desired Performance results out of the Informatica code in Production.
• Supported multiple projects at the same time for Production support, Issue Resolution, enhancements to the ETL code, Database changes and created ETL releases and migrations scripts.
• Mentored a small set of developers with ETL best practices, mapping development using Informatica tool and supporting the code.
• Worked with Informatica Admin console to make sure the nodes are active and running, creating users and assigning roles, Integration services are running and updating the host key files and troubleshooting issues when there are issues with domain and nodes.
• Worked on Admin console for recycling the Integration services.
• Regularly worked on implementing the hot fixes and making sure the fixes are implemented accurately.
• Worked on starting and shutting down the Informatica services from the command line on all the hosts that Informatica server is hosted.
• Worked on executing the transmittals in Production environment like running shell scripts and deploying new workflows and migrating code changes from lower environments.
• Supported multiple projects at the same time for Production support, Issue Resolution, ETL releases and deployment scripts.
• Day to day activities involved monitoring the workflows, running scripts, troubleshooting workflow failures and submitting the root cause analysis to the relevant development team.
• Worked with change control module by creating, assigning and working on KISAM tickets created as part of Production support.

Environment: Informatica Power Center 9.1/9.5, DB2, SQL Server 2008, Control- M, UNIX/ LINUX.

Confidential, Hartford, CT

Sr. Lead ETL Informatica Developer/ ETL Architect

Responsibilities:

• Interacted with end-users and functional analysts to identify and develop business requirements and transform them into technical requirements.
• Scheduled and managed production change control related to ETL applications and involved in setting up development, deployment and production support procedures.
• Created the functional and technical requirement design document for the interfaces that involve extracting data from DB2 database and need to be loaded to Oracle database.
• Created mappings based on the technical design document involving filter, router and normalizer transformations.
• Worked on parsing clob data using Java string tokenizer by using it in the Java transformations in the mappings to parse the data into individual values.
• Worked on creating complex mappings based on the requirements and workflows to schedule the ETL code with lot of command tasks and variables and parameters.
• Worked on XML transformations as part of dealing with unstructured data and semi structured data. Also dealt with XML sources and XML parser transformations as part of the mappings.
• Used Java transformation to parse unstructured data using pattern matching and used Perl scripts to split large xml files into multiple small files with parameters specified.
• Worked on creating the deployment plan with the Architects for migration of the code to Production environment from QA after the UAT has been successfully completed.
• Developed workflows and sessions and scheduled them using Autosys after migrating them to Production from UAT.
• Created Unit Test Plan and cases and documented them based on the design specs.

Environment: Informatica Power Center 9.0.1, DB2, Oracle 10g R2 (R12), SQL Server 2008 R2, WebMethods 8.0, Autosys, UNIX.

Confidential, Saint Paul, MN

Sr. Lead ETL Informatica Developer / Data Quality Consultant

Responsibilities:

• Involved in requirements analysis with business users for design of tables in the new Warehouse.
• Based on the requirements, created the high-level design specs, source to target mapping documents and later created unit testing documents for code reviews based on that.
• Created mappings, mapplets, sessions and workflows as part of the development extracting data from an application which is a Sybase database to load the data into the warehouse and involved in validation of the data.
• Created parameter files, workflow error reports using OPB tables and dependencies between sessions and workflows.
• Worked in creating the deployment scripts to move the Informatica workflows between different environments and eventually to Production after successful unit testing.
• Created post development and maintenance docs for future reference and support.

Environment: Informatica Power Center 8.6, Data Quality, Power Exchange, DB2 8.x, Sybase, SQL server 2008, DB Artisan 8.0

Confidential, Miami, FL

Sr. ETL Informatica Lead Developer

Responsibilities:

• Involved in creating the logical and physical model based on the user requirements that have been finalized and approved by the business users.
• Worked on preparing the source to target design documents based on the data model and created technical requirements design document.
• Extensively did data profiling since data was coming from different source systems and there was lot of inconsistencies that had to be identified before it was sent to the mart.
• Used Visio to design the flow of data between staging and the data marts as part of representation of the data transformations.
• Extensively used transformations like Lookup, Router, Filter and Update strategy since most of the mappings have been SCD type 2 with history needed in dimensions.
• Extensively worked on performance tuning of the mappings based on the run time and memory allocations keeping in view the Informatica’s best practices.
• Worked as a developer in creating complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views and SQL joins for applications.

Environment: Informatica Power Center 8.6, Oracle 10g, DB2 8.5, UNIX.

Confidential, Minnetonka, MN

Sr. ETL Informatica Architect/ Data Modeler

Responsibilities:

• Involved with all the phases of the life cycle starting from gathering the requirements for designing DS systems, data modeling involving the design of the logical and physical databases, Data warehouse design.
• Worked on preparing the source to target design documents based on the data model and technical requirements design document.
• Involved in creating the logical and physical model based on the user requirements that have been finalized and approved by the business analysts.
• Created mappings that load data into the dimensions and relevant fact tables that are part of the data mart.
• Extensively used transformations like Lookup, Router, Filter and Update strategy since most of the mappings have been SCD type 2 with history needed in dimensions.
• Involved in creating stored procedures required as part of these mappings to update table stats, creating a date dimension table that calculates relevant days.
• Change requests from business users observed, implemented in ETL and documented.
• Provided primary production supports to the jobs that run nightly and fixed them based on the failures and escalated the issues to the relevant teams.
• Created operations manual that gives a detailed list of the standards observed and the restart logic and instructions needed for the support of the jobs created in the long run.

Environment: Erwin 7.2, Informatica 8.1/8.6, power Exchange 8.6, Oracle R 12.0.X, Teradata, HL 7, COS Batch, UNIX scripting, OBIEE.

Confidential, Saint Paul, MN

Sr. Lead ETL Informatica Consultant/ Data Quality Consultant

Responsibilities:

• Involved in requirements analysis with business users for design of Data Marts.
• Based on the requirements, conducted data analysis to align the data coming from different sources and identified the gaps in the source data
• Created logical and physical models adhering to the Enterprise standards and dictionary.
• Worked with design team in creating model marts, model managers, subject areas, libraries in Erwin to keep all the data models in sync across the enterprise.
• Extensively worked on normalization of the data and integrating the data coming from different sources within various internal departments.
• Designed a new staging area for the entire warehouse that includes the entire list of Source tables used for loading the warehouse, extracting data from Sybase database.
• Involved in creating design documents that interpret the mappings visually and the flow of the data from Source to Target using Visio diagrams.
• Created source to target mapping specifications with transformation rules, design documents and data flow diagrams for the development team. Worked with the ETL development team in supervising and helping them with development related issues.
• Extensively used the transformations like Filter, Router, Aggregator and Look up, Union, Sorter to get the business spec implemented through Informatica mappings.
• Worked on Data Quality workbench to design, test and execute plans on ad-hoc basis and Data Quality server to share the plans between different projects.
• Customized Business Intelligence reports, including query model customization, bursting, editing XML report specifications, and developing custom toolbox items.
• Mentored FTE’s with Informatica and the development standards and methodologies.

Environment: Informatica Power Center 8.1, Sybase, Data Quality, DB2 8.x, SQL server 2005, UNIX AIX, DB Artisan 8.0.

Confidential, Plymouth, MN

Sr. ETL Informatica Consultant/ Siebel Analytics Developer

Responsibilities:

• Built prototype reports from excel spreadsheets during the requirement-gathering phase to visualize the reports and clarify requirements
• Extensively used Siebel Analytics Administration Tool for customizing and modifying the physical, business and presentation layers of metadata repository.
• Created connection pools, physical tables and defined Primary key - Foreign key joins, complex joins in the physical layer of the repository.
• Created and modified logical tables, logical columns and defined Foreign-keys and complex joins. Setup default level of aggregation for measure columns. Defined dimension specific aggregate rules.
• Created dimensions, dimension hierarchies, levels, level-based measures and defined level attributes, level keys.
• Customized the web user interface using cascading style sheets and XML message files.
• Created Proactive agents (iBots) and configured Interactive dashboards to alert the employees as per the requirements.

Environment: Siebel eSales 7.5, Siebel eMarketing 7.5, Siebel Service Analytics 7.7.1, Siebel Marketing Analytics 7.7.1, Informatica Power Center 6.2, DB2, Oracle 9i.

Confidential, Eagan, MN

ETL Informatica Consultant/ Data Modeler

Responsibilities:

• Extensively used transformations like Lookup, Router, Filter and Update strategy since most of the mappings have been change data capture.
• Data is extracted, transformed, loaded into different business Data marts on DB2 (UDB) tables using ETL - Informatica from the sources like VSAM files, SAP.
• The scripts coordinate the incoming data and ensure the appropriate Informatica tasks are run to completion. The scripts also update reporting tables in the warehouse to communicate the load progress to the support team.
• Worked closely with the Information Architect and Database Administrators to identify and analyze data integration and migration strategies.

Environment: Power Designer 10, Informatica 6.2 /7.1.2, IBM DB2 8.1, Power Connect, SAP R/3, Oracle 9i, SQLServer2000, Business Objects 10.

Confidential, Minneapolis, MN

ETL Informatica Consultant/ Business Objects Developer

Responsibilities:

• Managed the entire “ETL process” involving the access, manipulation, analysis, interpretation and presentation of information from various sources to customers in sales.
• Used Informatica Work Flow Manager/Monitor to create tasks and run sessions and performed Unit Testing on the designed mappings
• Designed and Developed Prompts for Web Users for Flexible Querying.
• Worked on database connections, SQL joins, cardinalities, loops, aliases, views, aggregate conditions, parsing of objects and hierarchies.

Environment: Informatica Power Center 6.2, Business Objects Enterprise 6.1, DB2 8.1., SQL Server 2000, Qwest Central 3.1, Erwin 4.1, IBM AIX, Windows NT.