SUMMARY

• Over Ten years of IT experience in Analysis, Design, Development, Testing and implementation of Software Applications in Data Warehousing, Web and Client/Server Technologies.
• Over eight years of ETL experience using Informatica Power Center 9.x/8.6/7.1, Informatica Power Exchange, and Informatica Metadata Manager.
• Extensive experience with full Software Development Life Cycle implementation of data warehousing and BI solutions with commendable success in playing various roles
• Proven hands on experience in end to end informatica development including gathering functional requirements, data mapping, design of UML, development, testing and deployment
• Worked in various ERP environments Oracle EBS Financials/Projects/HRMS, MS Dynamics and SAP
• Well versed with Oracle EBS tables, data flow between modules and header/detailed tables
• Very strong knowledge in Enterprise Data Warehouse environment, Dimensional/ Hierarchical data modeling and created data models and data marts using Star/Snowflake schema concepts with considerable flexibility based on user requirements. Implemented Slowly Changing Dimension (SCD) Concepts
• Experienced working with clients on - site, analyzing software requirements and developing solutions and procedures
• Experience in source data analysis, data profiling for data accuracy, adherence to the target database design and designing the strategy to extract, transform and load data
• Experienced in Data Extraction, Transforming and Loading (ETL) between Homogenous and Heterogeneous System using Informatica Power Center (Repository Manager, Designer, Workflow Manager, Workflow Monitor, and Metadata Manger
• Expertise in implementing complex Business rules by creating complex mappings/mapplets, shortcuts, reusable transformations and Partitioning Sessions.
• Made use of Post-Session success and Post-Session failure commands in the Session task to execute scripts needed for cleanup and update purposes.
• Experience in creating Reusable Tasks (Sessions, Command, Email) and Non-Reusable Tasks (Decision, Event Wait, Event Raise, Timer, Assignment, Control).
• Experience in Debugging and Performance Tuning of mappings, identify and resolve performance bottlenecks in various levels like source, targets and mappings.
• Experienced in UNIX work environment, file transfers, job scheduling and error handling
• Expertise in working with Crystal Reports XI/XIR2, 2008, 2011, 2013 and Crystal Reports Enterprise
• Extensive experience in data analysis, developing Stored Procedures, Views, Functions and Complex SQL queries on SQL Server and Oracle
• Effectively worked with the business in gathering requirements and creating requirements traceability matrix and low level and high-level designs.
• Solid experience on working with the business and analysts to develop Use Cases for testing of the web and mobile applications
• Core experience in creating Conceptual, Logical and Physical data models for both OLTP and OLAP database environments using tools like Erwin and Power Designer.
• Very strong knowledge in Enterprise Data Warehouse environment, Dimensional/ Hierarchical data modeling and created data models and data marts using Star/Snowflake schema concepts with considerable flexibility based on user requirements. Implemented Slowly Changing Dimension (SCD) Concepts.
• Actively involved in functional testing of the data integration in various systems and reports developed
• Involved in setting up UAT machines for business testing and assist the business users with any issues.
• Participated actively in Regression testing of the web and mobile applications built and log the unit defects either in Quality Center or SharePoint
• Created detailed data integration design documents to explain the data flow and transformation involved in data cleaning.
• Experience in SQL, PL/SQL, T- SQL using Oracle 11g/10g, MS SQL Server 2008 databases and Experience in writing UNIX shell scripts
• Solid experience in Analysis of Source Systems, building Staging Area & designing Target systems
• Solid understanding of OLAP concepts and challenges, especially with large data sets.
• Hands on experience with Scheduling batch jobs using UC4.
• Efficiently involved in interacting with Scrum Master, Scrum Team and Business Users using the Agile Scrum Framework
• Very involved in handling requests through service now and Remedy

TECHNICAL SKILLS

Data Modeling Tools: ER/Studio 7, ERwin r8/7.x

Data bases: Oracle (11g, 10g, 9i, 8i), DB2, Sybase Central, SQL Server (2012, 2008, 2005, 2000), SAP BW 7.3

ETL Tools: Informatica (9.x, 8.x), SQL Integration Services (SSIS) 2012/2008, PL/SQL Script

Reporting Tools: MicroStrategy 8/9, Business Objects 3.1/4.1, Crystal Reports 2013/2011/2008

Scheduling Tools: UC4 V8.00, Control M

Languages: SQL, PL/SQL, C, C++

Database Tools: SQL * Loader, SQL * Plus, TOAD, SQL Profiler, Oracle SQL Developer

Other Tools: Salesforce.com, MS Visio, Business Intelligence Development Studio (BIDS)MS Project 2007, MS Office, BMC Remedy, Service Now, TFS, Quality CenterShare Point

Operating Systems: Windows95/98/2000/XP/Vista/2007, IBM AIX

Methodologies: Rational Unified Process (RUP), Waterfall, Agile Methodology

PROFESSIONAL EXPERIENCE

Sr. Informatica Developer

Confidential, Bartlesville/OK

Responsibilities:

• Gathering Requirements and design of technical specification documents
• Created Source to Target mapping documents and ETL Design Specs
• Worked with heterogeneous sources like CRM applications, DB2, flat Files, FTP server, Excel files to extract data, transform and load to Oracle data warehouse
• Developed standard and reusable mapping and mapplets using various transformations like Expression, Aggregator, Joiner, Router, Lookup (Connected and Unconnected), Filter, Update Strategy and Sequence Generator
• Implemented Type-1 and Type2 Slowly changing diagrams
• Analyzed session logs produced as the result of mappings created.
• Identified performance issues in existing sources, targets and mappings by analyzing the data flow, evaluating transformations and tuned accordingly for better performance
• Extensively used parameter files and pre and post session assignment variables, commands
• Designed workflows for different tasks to run mappings, decision and sending email notifications
• Created partitioning in sessions to improve the performance
• Created deployment groups to move the data from Dev to QA to Prod environments
• Debugged the issues and errors and fixed them based on priority.
• Fix formatting and database log on issues.
• Perform minor enhancements to the reports.
• Fix defects that are detected by the users during UAT.

Environment: Informatica Power Center 9.6, Oracle 12c/11g, DB2, SAP, Crystal Reports 2013, Crystal Reports 2008, Crystal Reports Enterprise 4.0, Business Objects Suite XI3.1/ 4.1, Oracle 12c/11g, SQL server 2013

Sr. Data Warehouse Informatica Developer

Confidential, Wichita/KS

Responsibilities:

• Interacted with business users to analyze the business process and requirements and transformed requirements to designing the database, documenting and rolling out deliverables.
• Coordinated data profiling/data mapping with business subject matter experts and data architects.
• Helped setup a data warehouse for analysis and reporting purposes.
• Setup folders in Informatica repository and provide access to the users.
• Responsible for Informatica admin activities like creating of users, maintain the parameter files, move the components and do client installations for CPS project.
• Participated in regression testing of the web applications and coordinated the defects with the users on the defects logged in SharePoint.
• Created data integration design documents for source to target data flow.
• Created source to target mappings to load data from transactional data base to the data warehouse.
• Designed new ETL mappings using Informatica Power Center 9.5 to implement business rules and to extract, transform and load data from relational sources(Oracle) to relational target database (Oracle)
• Created Mappings using Mapping Designer to load data from various sources, using different transformations like Source Qualifier, Expression, Lookup, Aggregator, and Update Strategy, Joiner, Normalizer, Filter and Router transformations, Union Transformations etc.
• Designed incremental strategy, Created Mapplets using Mapplet Designer and used them for reusable business logic.
• Used shortcuts to reuse objects without creating multiple objects in the repository and inherit changes made to the source automatically.
• Identified the bottlenecks in the sources, targets, mappings, sessions and resolved the problems.
• Analyzing the data for defects and fixing the defects.
• Updated and fixed existing maps to take care of the slowly changing dimensions.
• Used Session parameters, Mapping variable/parameters and created Parameter files for imparting flexible runs of workflows based on changing variable values.
• Implemented Audit approach, updated the maps to handle logical deletes in the data warehouse.
• Implemented Type 1 and Type 2 SCD’s to track the history.
• Created deployment groups and migration documents to move the objects from Dev to QA and to Production
• Provide solutions to team members on ongoing ETL work.
• Worked closely with the business analysts and business users to finalize requirements for report development.
• Guided the BA’s to set up global reporting templates and standards for report writing.
• Understand Business requirements and created complex SQL queries, Stored Procedures, Views and Packages to read data from Oracle database for Reports.
• Configured parameters and LOV’s in Data Foundation Layer and Created Business Views.
• Designed and Developed new complex customer facing reports using Crystal reports 2011 which included dynamic LOV’s, multiple sub reports, Graphs and Cross Tabs.
• Extensively involved in using the formula fields, parameter fields, Group Selection, Record Selection in Crystal Reports.
• Created formulas to calculate the group summaries at the group level and report summaries.
• Created Shared, Global and Local variables within the formulas.
• Have used Grid Value Functions like currentcolumnindex and currentrowindex to conditionally format row data in Cross-Tab reports.
• Coordinate all areas of system testing, including preparation, execution and installation support to assure quality system changes

Environment: Informatica Power Center Designer 9.5, ERwin r8, Oracle 11g/10g, Crystal Reports 2013/2011 Crystal Reports 2008, Crystal Reports Enterprise 4.0, Business Objects Suite XI3.1/ 4.1, Control M, UNIX, Desktop Intelligence, Visual Studio 2008, Service Now

Data Modeler/ ETL Informatica Developer

Confidential, Saint Paul/ MN

Responsibilities:

• Understand the business process, requirements and transform requirements into logical model.
• Analyze existing application and data to get in-depth knowledge of the business process.
• Extensively worked with the business in setting up different use cases for testing of mobile .net application and web Java application.
• Have written detail use case documents on test the application for different data scenarios.
• Applied naming standards and developed a normalized physical data model that support multi-lingual transactions across the Globe.
• Generated DDL scripts using Forward Engineering to create the Database.
• Reversed Engineered the existing protocol application from a different division and integrated with the new model creating a different subject area.
• Modified the existing model to accommodate the new functionality and enhancements based on the customer feedback.
• De-normalized the model to support the web reporting for the business users.
• Created Source to Target Mappings for various sources (IDMS, AS400, Oracle EBS, Excel Sheets, and SAP BW).
• Extracted data from Flat files, Excel, DB2, SQL and Oracle to build an Operation Data Source.
• Created Complex ETL Mappings to load data using transformations like Source Qualifier, Sorter, Aggregator, Expression, Joiner, Dynamic Lookup, and Connected and unconnected lookups, Filters, Sequence, Router and Update Strategy.
• Worked on complex Source Qualifier queries, Pre and Post SQL queries in the Target.
• Worked on different tasks in Workflow Manager like Sessions, Events raise, Event wait, Decision, E-mail, Command, Worklets, Assignment, Timer and Scheduling of the workflow.
• Extensively used workflow variables, mapping parameters and mapping variables.
• Develop slowly changing dimension Type 2 mappings to maintain the history of data.
• Implemented performance tuning logic on Targets, Sources, Mappings and Sessions to provide maximum efficiency and performance
• Created Deployment groups to move workflows and its dependencies to different repositories using Repository Manager
• Establish Informatica sessions and workflows to extract and load source data into target tables.
• Build Sequential and Concurrent batch jobs to execute Informatica Workflows.
• Conducted code reviews developed by my team mates before moving the code into QA.
• Created detailed data integration design documents to explain the data flow and transformation involved in data cleaning.
• Actively involved in unit testing and regression testing of the applications and reports at various stages of the projects.
• Documented the defects discovered in Quality Center and coordinated with various technical developers in the project.
• Created Data Migration mappings to migrate the existing data from individual databases to target db.
• Utilize SQL Server import and export wizard to create basic packages that copy data from Fox Pro database to SQL Server Landing db.
• Build Complex Stored Procedures to migrate data from landing database to Target Db.
• Coordinate data migration and data mapping with business subject matter expert and data architects.
• Assisted in resolving complex Water and Energy which are used in Functional Reporting.
• Actively involved in day to day stand up meetings and assist in providing Solutions to the business users on complex issues in monthly planning meetings.
• Collaborate with DBA on updating and modifying the databases.
• Implemented Multi Lingual Translations by updating the resource File on a regular basis.
• Co-ordinate Deployment Related activities with the team and the release manager.
• Author integration and migration design documents and report requirements.
• Build the production database and set up UAT testing of the application developed.
• Provide Tier 2 and Tier 3 production support

Environment: Informatica 9.1/8.6, Crystal Reports 2011/2008, Oracle EBS, Business Objects XI R2/XI 3.1, WebI, Desktop Intelligence, SAP BW 7.3, BEx, UC4 V8.0, Java, ASP.net, UNIX, Visual Fox Pro, Sybase Central, MS Dynamic CRM, BIDS, TFS, Remedy, Afaria, Mobil ink, Service Now, Erwin r7.3, Visual Studio 2008, SQL Server 2005/2008/ 2012

Data Analyst/Data Modeler

Confidential, Richmond/VA

Responsibilities:

• Worked on the bank data warehouse and mortgage data warehouse.
• Performed dimensional modeling, identifying facts and dimensions.
• Maintained and enhanced data model with changes and furnished definitions, notes, reference values and check lists.
• Interacted closely with data architects and DBA team to implement data model changes in database in all environments.
• Generated DDL scripts for database modification and views and set tables.
• Collaborated with DBA to create physical model and tables from the logical model.
• Interfaced with testers and performed the process of integration testing.
• Coordinated changes with developers, technical writers and end users.

Environment: Oracle 10g, SQL Server 2008, Teradata, ERwin 7.3, Toad 9.6, Windows XP, XML, Excel, Access, Visio

Informatica Developer

Confidential, Scottsdale/AZ

Responsibilities:

• Developed claim management data warehouse to assist claim professionals to analyze and administer claims in an efficient manner.
• Obtained operational data from multiple sources and loaded into the data warehouse.
• Created mappings and transformations using Informatica.
• Extracted data from flat files and SQL Server source tables and loaded into Oracle target tables.
• Transformed data using Informatica transformations, source qualifier, expression, lookup, router, aggregator, update strategy and normalizer transformations.
• Established various mappings with a collection of all sources, targets, and transformations.
• Set up event wait tasks and command tasks and created sessions, worklets and workflows using workflow manager.
• Scheduled workflows for weekly and monthly runs using workflow manager.
• Processed performance tuning of mappings to improve performance.
• Compared source and target data using T-SQL and SQL queries.
• Performed unit testing and fixed bugs.

Environment: Informatica Power Center 8.6, Oracle 10g, PL/SQL, ERWin, Power Designer 15.0, Windows Server, UNIX, SQL*Loader, DB2, Crystal Reports

Data Modeler/Informatica Developer

Confidential, Westminster/CO

Responsibilities:

• Interacted with business analysts to gather business requirements and implemented business rules to build enterprise data warehouse.
• Established source to target specifications using the physical data model.
• Developed mappings/transformations/Mapplets using mapping designer, transformation developer and Mapplet designer in Informatica Power Center.
• Scheduled and ran extraction and load process and monitored task and workflow using workflow manager and workflow monitor.
• Transformed data using Informatica transformations, lookup, joiner, router, sorter, aggregator, source qualifier, expression, update strategy and normalizer transformations.
• Set up slowly changing dimension Type 2 mappings to keep the history of the data.
• Produced reusable sessions, Worklets and workflows using Informatica Power Center workflow manager.

Environment: Oracle 9i, ERwin 7.0, SQL Server 2005, SQL*Loader, SQL*Plus, MS Access, Informatica Power Center 7.1