SUMMARY

• 6+ years of extensive experience in BI Architecting, Design and development for various Data ware housing projectsusingInformatica PowerCenter 9.x/8.x/7.x, SAP Business Objects, Oracle, DB2,MS SQL Server 2005 etc.
• Experience in all the phases ofSoftware Development Life Cycle involving Requirement Analysis, Design, Coding, Testing, and Deployment.
• 4+ years of data modeling experience using ERWIN.
• Experience in working with business analysts to identify study and understand requirements and translated them into ETL code in Requirement Analysis phase.
• Experience in creating High Level Design and Detailed Design in the Design phase.
• Expertise in Business Model development with Dimensions, Hierarchies, Measures, Partitioning, Aggregation Rules, Time Series, Cache Management.
• Extensively worked on the ETL mappings, analysis and documentation ofOLAP reports requirements. Solid understanding of OLAP concepts and challenges, especially with large data sets.
• Well versed in OLTP Data Modeling, Data warehousing concepts.
• Strong knowledge of Entity - Relationship concept, Facts and dimensions tables, slowly changing dimensions and Dimensional Modeling (Star Schema and Snow Flake Schema).
• Experience in integration of various data sources like Oracle, DB2, Sybase, SQL server and MS access and non-relational sources like flat files, XML files into staging area.
• Experience in creating Reusable Transformations (Joiner, Sorter, Aggregator, Expression, Lookup, Router, Filter, Update Strategy, Sequence Generator, Normalizer and Rank) and Mappings using Informatica Designer and processing tasks using Workflow Manager to move data from multiple sources into targets.
• Experience in creating Reusable Tasks (Sessions, Command, Email) and Non-Reusable Tasks (Decision, Event Wait, Event Raise, Timer, Assignment, Worklet, Control).
• Tuned mappings using Power Center-Designer and used different logic to provide maximum efficiency and performance.
• Experienced in UNIX work environment, file transfers, job scheduling and error handling.
• Extensively worked on developing and debugging Informatica mappings, mapplets, sessions and workflows.
• Understanding & working knowledge of Informatica CDC.
• Experienced with IDE/IDQ tools for Data Analysis / Data Profiling and Data Governance.
• Worked on Performance Tuning, identifying and resolving performance bottlenecks in various levels like sources, targets, mappings and sessions.
• Experience in writing, testing and implementation of the PL/SQL triggers, stored procedures, functions, packages.
• Involved in Unit testing, System testing to check whether the data loads into target are accurate.
• Experience in support and knowledge transfer to the production team.

TECHNICAL SKILLS

ETL Tool: Informatica 9.x/8.x/7.x (Power Center), SSIS

Data Quality Tool: IDQ 9.x/8.x ( Informatica Data Quality)

Data Modeling: ERwin r7.3/4.0/3.5(Star schema/Snow flake)

Languages: C, SQL, PL/SQL, Java

Databases: Oracle 8i/9i/10g/11g/12c, MS SQL Server 7.0, 2000, 2008, DB2

OLAP Tools: BusinessObjectsXIR2, OBIEE

SQL Tools: SQL Developer, TOAD, SQL*PLUS, SQL*Loader

Office Tools: MSOffice, MS Project, Microsoft Visio

Scheduling Tools: AutoSys, ControlM

Operating Systems: Windows 95/ 98/NT/2000/7, XP, UNIX

PROFESSIONAL EXPERIENCE

Confidential, CO

Sr Informatica Developer

Responsibilities:

• Documenting user requirements, Translate requirements into system solutions and developed implementation plan and schedule.
• Extensively participated in functional and technical meetings for designing the architecture of ETL load process (mappings, sessions, workflows from source systems to staging to DW).
• Developing Mapping Documents indicating the source tables, columns, data types, transformation required, business rules, target tables, columns and data types.
• Creating Several Informatica Mappings for the CDC change data capture to populate the data into Dimensions and Fact tables.
• Extensively used ILM tool for data masking.
• Extensively used ETL to load data from flat file to Oracle database.
• Responsible in developing the ETL logics and the data maps for loading the tables.
• Developing Complex Transformations, Mapplets using Informatica to Extract, Transform and Load data into Data marts, Enterprise Data warehouse (EDW) and Operational data store (ODS).
• Creating Informatica Exception Handling Mapping for Data Quality, Data Cleansing and Data Validations.
• Writing complex Oracle SQL queries for Source Qualifier SQL Overrides.
• Working on Performance Tuning of the complex transformations, mappings, sessions and SQL queries to achieve faster data loads to the data warehouse.
• Creating session tasks, event waits & raise, command task, worklets etc in the workflow manager and deployed them across the DEV, QA, UAT and PROD repositories.
• Generating Email Notifications through scripts that run in the Post session implementations.
• Have written lots of SQL Scripts in Pre-SQL and Post-SQL session tasks.
• Designed mappings for populating Tables for one time load and incremental loads.
• Catching up for the applications and need to make sure catch up process is completed
• Analyze functional requirements provided by Business Analysts for the code changes.
• Create workflows based on dependencies in Informatica for the code changes.
• Writing UNIX scripts for scheduling the Control-M jobs to automate the processes.
• Writing UNIX scripts for unit testing the ETLCode (Sessions, Workflows, Log Files).
• Unit test the Data Mappings and Workflows and validate the data loaded into database.
• Involved in ETLCodemigration from Environment to Environment.
• Involved in creation of Environment Document which provides instructions to Implement/Test the Project in QA and Production environments.
• Troubleshooting issues reported in production environment, Co-ordinate with quality control in final resolution of issues and production release of programs.

Environment: Informatica Power Center 9.x, IDQ, Oracle 10g/11g, UNIX, Shell Scripts, TOAD 10.6, Control-M 6.4, ERwin7.3, HP Quality Center 10.0.

Confidential, Los Angeles, CA

Sr. Informatica Developer/ Data Analyst

Responsibilities:

• Preparation of Scope of Work.
• Analyze existing mappings and sessions for performance issues.
• Worked with different Informatica tuning issues and fine-tuned the transformations to make them more efficient in terms of performance.
• Responsible for Error handling.
• Suggest probable tuning solutions.
• Coordinated with the DBA Team, Source systems, BSA team, offshore team and Data Quality team for Different data loads (System test Load, Integration System Test Load, UAT Load and Pre production deployment load) and identify bugs, new requirement changes and Data Quality Issues.
• Incorporating performance related changes to mappings and sessions.
• Identifying the areas of re-usable functionality and designing re-usable ETL components to be useful across different data domains and lines of business
• Unit testing of mappings and sessions.
• Updating Design documents and test scripts due to changes.
• Design, implement and manage multiple, concurrent hardware and software systems of varying sizes and complexities. Work with IT and Business managers to plan, control, and implement technical solutions to business problems.
• Prepare status reports and participate in meetings.
• Provides guidance and mentoring and to less experienced personnel.
• Frequently leads formal and informal teams of other internal technical staff or external resources.
• Responsible for Informatica ETL Development, Source to Target mapping.
• Involved in configuring the Data warehouse while specifying and setting the size of the database.
• Involved in designing the various Reusable Informatica Objects.
• Implemented various transformations like Expression, Aggregator, Lookup, Normalizer, Joiner, Filter, Union, Stored Procedure, Router, Sequence Generator, Rank and Update Strategy.
• Involved in creating mapplets that would be reusable in various other mapping interfaces having similar business requirements.
• Responsible for administration of Informatica PowerCenter.
• Participating in special projects involving the implementation of a new tools or applications.

Environment: Informatica Power Center 8.6.1/9.x, Oracle 10g, SQL server 2005 &2008, PL/SQL, SQL*Plus, Windows NT, Unix Shell Scripting, Erwin 4.

Confidential, Saint Paul, MN

Sr. Informatica Developer/ Data Analyst

Responsibilities:

• Interacting with business owners to gather both functional and technical requirements.
• Developing technical specifications and other helpful ETL documents following CME Group’s standards.
• Involved in creating logical and physical data models using CA ERwin data modeler. Generating the DDL scripts for the physical data model.
• Use Agile methodology for SDLC and utilize scrum meetings for creative and productive work.
• Design and develop PL/SQL packages, stored procedure, tables, views, indexes, and functions; implement best practices to maintain optimal performance.
• Design, develop, and test Informatica mappings, workflows, worklets, reusable objects, SQL queries, and Shell scripts to implement complex business rules.
• Load historical and intraday trades, settlements, positions, and product data into Oracle data warehouse to enable business analysts to better understand, monitor, and analyze liquidity generating performance of Market Maker firms trading CME Group’s products.
• Migrating historical data from DB2 to the Oracle data warehouse.
• Transferring the data from various sources like XML, flat files, DB2 into Oracle data warehouse.
• Extensively worked on SCD type 2 using Look up transformation.
• Identifying bottlenecks/issues and fine tuning them for optimal performance.
• Oversaw unit and system tests and assisted users with acceptance testing. Responsible for capturing, reporting, and correcting error data.
• Used Business Objects XI R2 to programmatically generate reports and gather necessary information about report instances.
• Performed/automated many ETL related tasks including data cleansing, conversion, and transformations to load Oracle 10G based Data Warehouse.
• Worked closely with Business Intelligence (BI) team and assisted them to develop reports using Business Objects reporting tool.
• Conducted code reviews to make sure the business requirements are met and the coding standards are followed.
• Coordinated with System support team to setup the system test environment for code migration and code execution process in QA environment.

Environment: Informatica Powercenter 8.x, CA ERWIN r7, Oracle 10g, SQL Server 2005, PL/SQL, PeopleSoft V8, Toad, Case Management System, Business Objects

Confidential, Hiawatha, IA

Informatica Engineer

Responsibilities:

• Involved in structuring and designing the DODS database models and Star schema for the new Client requirements for NOC Telemarketing extracts, jQuery extracts and DOSR (Daily Order Status Report) extract.
• Worked with multiple business users on understanding the whole Sterling order management process of different phases or orders from Creation till the release to shipment steps that helped in flexible design of OMNI Reporting project.
• Responsible for designing and implementing the ETL process from multiple Sterling to multiple Staging tables and then to respective DODS tablesin Informatica 8.5.1/8.6 along with Informatica Power Exchange.
• Involved in working on the Data Analyser, Data Quality and data profiler tool for handling the business logic and exception logic from the inbound feeds and also the outbound feeds.
• Responsible for creating, testing and deploying multiple ESP (External Scheduling processor) schedules in development, testing and production mainframe boxes.
• Contributed to the advanced partitioning and index methods on Oracle database structures in production and testing environment.
• Involved in handling the defects through the Quality Center Defect Management system and also Action Remedy (AR) system for DEV/TEST/PROD issues.
• Created multiple standard and how-to documents for Informatica/UNIX shell and Mainframe activities to be handled on a daily basis and uploaded to sharepoint.
• Involved in Performance tuning of multiple Informatica mappings to improve performance as the volume of Internet orders entered the system on a daily basis. The factors involved were PDO (Push down optimization), bulk loading and also adding indexes on the staging tables.

Environment: Informatica Power Center 8.6.1/8.5, OBIEE, SAS, Oracle 10g, DB2, MS Sharepoint, QC Defect Tracking system, AR process, UNIX, AIX.

Confidential

Software Developer

Responsibilities:

• Extracted Data from Different Sources by using Informatica.
• Extensively used Informatica client tools Source Analyzer, Warehouse designer, Mapping designer and Mapplet Designer
• Extracted data from different sources of databases. Created staging area to cleanse the data and validated the data.
• Designed and developed complex Aggregate, expression, filter, join, Router, Lookup and Update transformation rules.
• Developed schedules to automate the update processes and Informatica sessions and batches.
• Analyzed, designed, constructed and implemented the ETL jobs using Informatica.
• Developed mappings/Transformations/mapplets by using mapping designer, transformation developer and mapplet designer in Informatica Power Center.
• Developed Shell scripts to setup runtime environment, and to run stored procedures, packages to populate the data in staging tables.
• Created Users, user groups, database connections and managed user privileges using supervisor.

Environment: Informatica Power Center 7.1.1, Oracle 8i, MS SQL SERVER 2000, SQL, PL/SQL, SQL*Loader, UNIX Shell Script.