SUMMARY:

• Dynamic Business Intelligence (BI) ETL Lead Developer having around 10+years of professional experience using Informatica ETL on Oracle, DB2 and SQL Server Databases.
• Proven experience in developing and implementing end to end full BI life cycle projects associated with the ETL processes and integrating legacy systems through different ETL tools.
• Experience with Demantra integrations with stored procedures and implementing data integrations thru PLSQL packages, strong understanding of industry standards and process in Insurance and Manufacturing domains.
• Participated in requirements gathering, conducted PoC(proof of concept) sessions with users and business stake holders.
• Experience XML sources using data transformation studio for extracting thru B2B.
• Rich experience and understanding Datawarehouse end user reporting requirements, trouble shooting issues with Cognos and OBIEE dash boards and reports, analyzing further with in ETL and providing resolutions as part of ongoing support for BI applications.
• Worked on Production support for Datawarehouse applications, providing 24*7 support, certified ITIL associate and well understanding of incident management and root cause analysis.
• Expertise in analyzing the requirements, preparing high level design and technical design, development, testing, debugging, documentation and maintenance of business Applications. Well - versed in SDLC (Software Development Life Cycle) and worked on agile methodologies.
• Worked on end to end ETL implementations by defining the ETL strategies for data integration, loading, cleansing the data from legacy systems and loading into datawarehouse and enterprise databases.
• Strong experience in Oracle, DB2 with SQL and PL/SQL with analyzing the complex queries, tuning queries for performance, developing Stored Procedures, Packages.
• Worked on UNIX shell scripts, setup Unix parameters to execute and configure the Informatica schedules on Unix OS.
• Migrated ETL code from Development to QA repositories thru Deployment groups, XML export and import and prepared ETL migration documents for Production migration.
• Experience with Oracle Business Intelligence Enterprise Edition (11g), worked on Prebuilt OBIEE Informatica mappings SDE and SIL for handling customization and enhancements, and worked on performance tuning. Experience in Scheduling and monitoring Informatica sessions for automation of loads in DAC.
• Hands on experience working with reading data thru SAP R3 IDoc, XML sources and Targets, working thru web services, Configuring Informatica workflows to read thru Web services.
• Expertise in designing enterprise wide Dimensional Modeling, designing Star Schemas and Snow Flake Schemas, Operational Data Store, leveraging large data warehouses.
• Expertise in all phases of Data Warehouse implementation, have implemented many custom Data Marts and end-to-end Data Warehouse solutions; possess a healthy combination of functional and technical skills and substantive appreciation of business processes.
• Extensive experience in OLAP tools, Materialized Views, and partitioning techniques for highly responsive Decision Support Systems. Proficient in providing Business Intelligence solutions dealing with Cubes and Multi-dimensional models.
• Highly creative, self-motivated with a positive attitude and ability to take any challenge with an objective to succeed. Excellent technical, communication and interpersonal skills.

TECHNICAL SKILLS:

Operating Systems: Windows 98/NT/2000/2003,HP UNIX 11i/11.0, Sun Solaris, Red Hat Linux AS3/AS4, IBM AIX

Languages: PL/SQL, SQL*Plus, XML

RDBMS: Oracle 11i/10g/9i/8i, Oracle SQL, PL/SQL, SQL*Plus, SQL*Loader, Teradata, Oracle DBMS, Greenplum Database 4.2, SQL Server 2005/2000/7.0/6.5, DTS, SSIS, MS Access 2000, Sybase, DB2.

OLTP: Oracle Apps 11i(EBS),Siebel 7,SAP R3

BI Suite: OBIEE 11g

Planning tools: Oracle IOP(Integrated Operations Planning)

Utilities: SQL*Loader, Export/Import

Data Modeling Tools: Erwin 4.5/4.0/3.5.5/3.0, Microsoft Visio

ETL Tools: Informatica Power Center 9.5/8.6/8.1/7.1.4/7.1.1/6.0, Cognos Data Manager 8.0,Cognos Decision Stream 6.5/7.0,IBM Datastage v8.x/v7.x

Cleansing tools: Trillium

OLAP Tools: IBM Cognos 7.x/8.3, Business Objects 6.5/ SAP Business Objects 4

Scheduler Tools: IBM Tivoli, Control M, Crontab, UC4 and Windows scheduler.

Database Query Tools: PL/SQL Developer, TOADIT Service Management SuiteRemedy

Bug Tracking tools: HP ALM, Mercury Quality Center, Bugzilla

Job Scheduling Tools: Control M, UC4, TWS (Tivoli Workload Scheduler) and Crontab

PROFESSIONAL EXPERIENCE

Confidential, Eden prairie MN

ETL Informatica Developer

Technologies/Tools:I nformatica Power Center 9.5, Oracle Demantra 12.2, PL/SQL Developer, OBIEE, QAD eb2.1, Control M, Exadata, Oracle 11g, Golden Gate, Qlik View

Responsibilities:

• Participated and implemented various initiatives of Confidential Hydraulics SIOP Demantra implementations.
• Analysis of Source, Requirements, existing OLTP system and identification of required hierarchies for dimensions and facts from the Database.
• Involved in preparing data sets and performed data PoCs to simulate Demantra application for collecting batch statistics and forecast quality measures.
• Developed Logical and Physical data models that capture current state/future state data elements and data flows using Erwin / Star Schema.
• Developed several Informatica objects like workflows, worklets, sessions, mappings by using workflow manager and designer respectively.
• Defined the ETL Standardization process to convert legacy ETL to Informatica 9.5
• Managed and helped other team members in defining various transformations like Expression, Joiner, Lookup, Filter, Stored Procedure and Router for implementing core data validations and business rules.
• Implemented Slowly Changing Dimensions (SCDs, Both Type 1 & 2).
• Cleansed the source data, extracted and transformed data with business rules, and built reusable mappings, known as ‘Mapplets’ using Informatica Designer.
• Analyzed various logs during the data integration for bringing up performance and improved cost of the informatica objects by eliminating the bottlenecks.
• Involved effectively in defining new ETL solutions by analyzing the existing code and on time delivery.
• Developed Unix Scripts and configured parameters to execute the Informatica workflows
• Performing sessions with Business users by creating Proof of Concepts for end to end data integration process.
• Co-coordinating the UAT and Production migration for Informatica objects with Users and other business stake holders.
• Analyzed informatica maps, sessions, workflows by identifying the performance bottlenecks and tuned for better performance.
• Gathered Functional requirements and prepared High level design documents, low level design documents, unit test plan and migration templates.
• Deployment to Production, Scheduling the Informatica Jobs through Control M and Warranty Support for the Deliverables.
• Defined and created facts, metrics, attributes, filters, and prompts and drafted by preparing Report Definition Documents (RDD).
• Designed and Delivered the Business reports for the end users by using Cognos Query Studio, Report Studio and Analysis Studio.
• Documented Release management process, ETL migration and Database changes.
• Preparation of Unit Test Plans and testing with the same.
• Extensively worked with Flat files and Database tables.
• Worked on production support tickets and the resolutions for high, medium and low priority incidents through Remedy incident system.

BI Datawarehouse/ETL Developer

Technologies/Tools:I nformatica Power Center 9.5, Oracle IOP 4, PL/SQL Developer, IBM Cognos 8, OBIEE 11g, QAD eb2.1, Control M, Exadata, Oracle 11g, Golden Gate, Qlik View

Responsibilities:

• Participated and implemented various initiatives of Confidential Hydraulics SIOP implementations.
• Analysis of Source, Requirements, existing OLTP system and identification of required dimensions and facts from the Database.
• Develop Logical and Physical data models that capture current state/future state data elements and data flows using Erwin / Star Schema.
• Participated in the design of Star & Snowflake schema data model.
• Developed several Informatica objects like workflows, worklets, sessions, mappings by using workflow manager and designer respectively.
• Defined the ETL Standardization process to setup new ETL using Informatica 9.5 mappings as part of cognos to OBIEE conversion project.
• Managed and helped other team members in defining various transformations like Expression, Joiner, Lookup, Filter, Stored Procedure and Router for implementing core data validations and business rules.
• Implemented Slowly Changing Dimensions (SCDs, Both Type 1 & 2).
• Extensively worked with DAC setup, working custom Informatica mappings in OBIEE as part of cognos to OBIEE conversion.
• Cleansed the source data, extracted and transformed data with business rules, and built reusable mappings, known as ‘Mapplets’ using Informatica Designer.
• Analyzed various logs during the data integration for bringing up performance and improved cost of the informatica objects by eliminating the bottlenecks.
• Involved effectively in defining new ETL solutions by analyzing the existing code and on time delivery.
• Developed Unix Scripts and configured parameters to execute the Informatica workflows
• Performing sessions with Business users by creating Proof of Concepts for end to end data integration process.
• Worked on the bugzilla cases raised during the QA and UAT of the project requirements.
• Co-coordinating the UAT and Production migration for Informatica objects with Users and other business stake holders.
• Analyzed informatica maps, sessions, workflows by identifying the performance bottlenecks and tuned for better performance.
• Gathered Functional requirements and prepared High level design documents, low level design documents, unit test plan and migration templates.
• Deployment to Production, Scheduling the Informatica Jobs through Control M and Warranty Support for the Deliverables.
• Defined and created facts, metrics, attributes, filters, and prompts and drafted by preparing Report Definition Documents (RDD).
• Designed and Delivered the Business reports for the end users by using Cognos Query Studio, Report Studio and Analysis Studio.
• Documented Release management process, ETL migration and Database changes.
• Preparation of Unit Test Plans and testing with the same.
• Extensively worked with Flat files and Database tables.
• Worked on production support tickets and the resolutions for high, medium and low priority incidents through Remedy incident system.

BI / Informatica Developer

Technologies/Tools:I nformatica Power Center 9.5, Oracle IOP 4.2,PL/SQL Developer, QAD mfgpro, Control M, Oracle 11g, Erwin 4.0, Pl/Sql.

Responsibilities:

• Managed and helped other team members in defining various transformations like Expression, Joiner, Lookup, Filter, Stored Procedure and Router for implementing core data validations and business rules.
• Implemented Slowly Changing Dimensions (SCDs, Both Type 1 & 2).
• Cleansed the source data, extracted and transformed data with business rules, and built reusable mappings, known as ‘Mapplets’ using Informatica Designer.
• Involved in the development of Informatica mappings and also performed tuning for better performance.
• Developed Informatica mappings to load into Greenplum as Target database using PWX drivers.
• Analyzed various logs during the data integration for bringing up performance and improved cost of the informatica objects by eliminating the bottlenecks.
• Involved effectively in defining new ETL solutions by analyzing the existing code and on time delivery.
• Worked on production support tickets and the resolutions for high, medium and low priority incidents through Remedy incident system.
• Developed Unix Scripts and configured parameters to execute the Informatica workflows
• Performing sessions with Business users by creating Proof of Concepts for end to end data integration process.
• Worked on the bugzilla cases raised during the QA and UAT of the project requirements.
• Co-coordinating the UAT and Production migration for Informatica objects with Users and other business stake holders. Analyzed informatica maps, sessions, workflows by identifying the performance bottlenecks and tuned for better performance.
• Gathered Functional requirements and prepared High level design documents, low level design documents, unit test plan and migration templates.
• Deployment to Production, Scheduling the Informatica Jobs through Control M and Warranty Support for the Deliverables.
• Designed the Cognos Frame work manager packages and Cognos transformer cube models.
• Defined and created facts, metrics, attributes, filters, prompts and drafted by preparing Report Definition Documents (RDD).
• Designed and Delivered the Business reports for the end users by using Cognos Query Studio, Report Studio and Analysis Studio.
• Documented Release management process, ETL migration and Database changes.
• Preparation of Unit Test Plans and testing with the same.

Sr BI / Informatica Developer

Technologies/Tools:I nformatica Power Center 8.6, Cognos data manager, IBM Cognos v8.x, Greenplum Database 4.2, PL/SQL Developer, Oracle EBS 11i, Control M, OBIEE 11g, Erwin 4.0, Pl/Sql, XML.

Responsibilities:

• Involved in requirements gathering, functional and business requirements specification.
• Organizing and coordinating discussions with Technical Team and Clients.
• Preparing the High Level, Low Level Design Documents, Technical specs and updated accordingly as per requirements.
• Managed and helped other team members in defining various transformations like Expression, Joiner, Lookup, Filter, Stored Procedure and Router for implementing core data validations and business rules.
• Implemented Slowly Changing Dimensions (SCDs, Both Type 1 & 2).
• Cleansed the source data, extracted and transformed data with business rules, and built reusable mappings, known as ‘Mapplets’ using Informatica Designer.
• Involved in the development of Informatica mappings for Order Management subject area and developed customized mappings and also performed tuning for better performance.
• Analyzed various logs during the data integration for bringing up performance and improved cost of the informatica objects by eliminating the bottlenecks.
• Involved effectively in defining new ETL solutions by analyzing the existing code and on time delivery.
• Worked on production support tickets and the resolutions for high, medium and low priority incidents through Remedy incident system.
• Developed Unix Scripts and configured parameters to execute the Informatica workflows
• Performing sessions with Business users by creating Proof of Concepts for end to end data integration process. Extensively worked with XML sources and targets and configured informatica sessions to use web services.
• Worked on the bugzilla cases raised during the QA and UAT of the project requirements.
• Co-coordinating the UAT and Production migration for Informatica objects with Users and other business stake holders.
• Analyzed informatica maps, sessions, workflows by identifying the performance bottlenecks and tuned for better performance.
• Gathered Functional requirements and prepared High level design documents, low level design documents, unit test plan and migration templates.
• Deployment to Production, Scheduling the Informatica Jobs through Control M and Warranty Support for the Deliverables.
• Designed and Delivered the Business reports for the end users by using Cognos Query Studio, Report Studio and Analysis Studio.
• Documented Release management process, ETL migration and Database changes.
• Preparation of Unit Test Plans and testing with the same.

ETL Informatica Developer

Technologies/Tools: Informatica Power Center 7.1.3/8.6, Mercury QC, TOAD, SAP Business Objects Crystal reports, Control M, UC4, IBM Tivoli Scheduler, HP UNIX, Oracle 8i/9i/10g, DB2, Erwin 4.0, Pl/Sql.

Responsibilities:

• Cleansed the source data, extracted and transformed data with business rules, and built reusable mappings, known as ‘Mapplets’ using Informatica Designer.
• Involved in the development of Informatica mappings and also performed tuning for better performance.
• Analyzed various logs during the data integration for bringing up performance and improved cost of the informatica objects by eliminating the bottlenecks.
• Involved effectively in defining new ETL solutions by analyzing the existing code and on time delivery.
• Worked on Unix Scripts and maintained, setup parameters to execute the Informatica workflows.
• Performing sessions with Business users by creating Proof of Concepts for end to end data integration process.
• Co-coordinating the UAT and Production migration for Informatica objects with Users and other business stake holders.
• Worked on the Mercury Quality center test scripts for the ongoing projects and resolved the issues during the QA and UAT of the projects.
• Worked on production support tickets and the resolutions for high, medium and low priority incidents through Remedy incident system.
• Analysis of Source, Requirements, existing OLTP system and identification of required dimensions and facts from the Database.
• Develop Logical and Physical data models that capture current state/future state data elements and data flows using Erwin / Star Schema.
• Developed several Informatica objects like workflows, worklets, sessions, mappings by using workflow manager and designer respectively.
• Managed and helped other team members in defining various transformations like Expression, Joiner, Lookup, Filter, Stored Procedure and Router for implementing core data validations and business rules.
• Documented Release management process, ETL migration and Database changes.
• Preparation of Unit Test Plans and testing with the same.Documented Release management process, ETL migration and Database changes.

ETL Developer

Technologies/Tools: Informatica Power Center 8.1, IBM Data Stage v8.x/7.x, SAP R3, UNIX, Windows NT, Oracle 9i, SQL, PL/SQL, SQL * Loader, PL/SQL Developer, Bugzilla, XML

Responsibilities:

• Involved in the development of Informatica mappings and also performed tuning for better performance.
• Analyzed various logs during the data integration for bringing up performance and improved cost of the informatica objects by eliminating the bottlenecks.
• Involved effectively in defining new ETL solutions by analyzing the existing code and on time delivery.
• Performing sessions with Business users by creating Proof of Concepts for end to end data integration process.
• Co-coordinating the UAT and Production migration for Informatica objects with Users and other business stake holders.
• Creating the DataStage jobs and Develop and implement tests on all data stage jobs.
• Schedule and plan all data stage tasks.
• Gathered Functional requirements and prepared High level design documents, low level design documents, unit test plan and migration templates.
• Using parallel processing capabilities and Session-Partitioning and Target Table partitioning utilities.
• Created Mapping Parameters and Variables.
• Handled operating system tasks by generating Pre and Post-Session UNIX Shell Scripts.
• Created and Scheduled Sessions and Batch Processes based on demand using Informatica Server Manager.

ETL Developer

Technologies/Tools: Informatica Power Center 8.1, IBM Data Stage v8.x/7.x, Siebel CRM 7, DB2, Business Objects 6.5, Oracle 9i, SQL Server7.0, PL/SQL Developer, UNIX.

Responsibilities:

• Developed mappings/Transformation/mapplets by using mapping designer, transformation developer and mapplet designer in Informatica PowerCenter.
• Developed Informatica Mappings and also tuned for better performance.
• Created Sessions, reusable Worklets and Batches in Workflow Manager and Scheduled the sessions at specified frequency.
• Written SQL Overrides in source qualifier transformations according to business requirements.
• Created folders to organize and store all Meta data in the repository, mappings and sessions. Created active, passive and reusable Transformations.
• Creating the DataStage jobs and Develop and implement tests on all data stage jobs.
• Schedule and plan all data stage tasks.
• Worked on production support tickets and the resolutions for high, medium and low priority incidents through Remedy incident system.
• Debugging the mappings with Debugger option in PowerCenter Designer.
• Created and tested data model mappings from source systems to target systems. Designed and documented conversion processes for source and target systems. Used Informatica to analyze source and target tables, flat files.
• Implemented Join, Expression, Aggregate, Rank, Lookup, Update Strategy, Filter and Router Transformations in Mappings.
• Created Oracle stored procedures and used it in Informatica mappings with Stored Procedure transformation and Pre & Post session scripts. Manually tested all the mappings developed in Power Center repository and checks the data transformation according the specifications.