SUMMARY

• 7+ years of experience in Software Development and Expertise in Informatica 9.x/8.x/7.x
• Strong experience in the Analysis, design, development, testing and Implementation of Business Intelligence solutions using Data Warehouse/Data Mart Design, ETL, OLAP, BI, Client/Server applications.
• Well acquainted with Informatica Designer Components - Source Analyzer, Transformation Developer, Mapplet and Mapping Designer.
• Hands on experience in Data warehousing development using ETL tools such as Informatica Power Center 9.x/8.x/7.x and developed Informatica Mappings and Workflows with Worklets & Tasks using various Transformations for ETL of data from Multiple Sources to Data Warehouse.
• Hands on Experience in ER Model, De-Normalization, Dimensional Data Modeling, converting Snow-Flake Schema to Star Schema, Dim Hierarchies, Dim Extensions, Physical & Logical Data Modeling.
• Experience in identifying performance bottlenecks and tuning of Informatica Sources, Targets, Mappings, Transformations and Sessions for better performance and efficiency.
• Trouble shooting the issues coming up with informatica.
• Data Modeling: Experience in analyzing, designing and modeling data warehouses and star schema data marts for various business verticals like Retail sales, Health Care (Pharmacy), Financial and Insurance, Good at Database Design, conceptual, logical and physical Data Modeling, Star Schema, Snowflake; FACT and Dimensions tables, slowly changing dimensions (SCDs).
• Expertise in Data Warehouse/Data mart, ODS, OLTP and OLAP implementations teamed with project scope, Analysis, requirements gathering, data modeling, Effort Estimation, ETL Design, development, System testing, Implementation and production support.
• Experience in all phases of Data warehouse development from requirements gathering for the data warehouse to develop the code, Unit Testing and Documenting.
• Experience in using Automation Scheduling tools like Autosys and Control-M.
• Experience in data modelling designing physical, logical and conceptual moelling.
• Hands on experience with Data warehouse Application Console (DAC) in customizing, designing, executing and monitoring ETL Processes.
• Experience in Extraction, Transformation & Loading of data from multiple sources to Data Warehouse using Informatica OTB mappings and DAC.
• Worked extensively on OBIEE Reporting tool containing Administration Tool, OBIEE Answers, OBIEE Intelligent Dashboards, BI Publisher, Delivers and iBots.
• Experience in creating requests, adding filters, creating prompts, and creating pivot tables using OBIEE.
• Strong experience in developing OBIEE/Siebel Analytics Repository (.rpd) - three layers (Physical Layer, Business Model & Presentation Layer)
• Experienced in Data Modeling using Dimensional Data Modeling, Star Schema modeling, Fact and Dimensions tables and Physical, Logical data modeling in the OBI Administration tool.

TECHNICAL SKILLS

Reporting Tools: OBIEE (11.1.x,10.1.3.x), Siebel Analytics 7.x,Oracle BI apps7.9.6

ETL Tools: Informatica Power Center 9.x/8.x/7.x, ODI 11gR1

Tools: SQL Plus 3.3/8.0, Toad, DAC 10.x

RDBMS: Oracle 11g/10g/ 9i/8i, SQL Server 2008/2005, Siebel CRM, Oracle EBS,MS Access

Operating Systems: Windows, UNIX, Linux

Languages: SQL, PL/SQL,XML

Data Modeling: Star Schema Modeling, Snowflake Modeling

PROFESSIONAL EXPERIENCE

Confidential, ERLANGER, KENTUCKY

INFORMATICA DEVELOPER

Responsibilities:

• Extensively worked on the Informatica Power Center 9.0 tools - Designer, Workflow Manager, Workflow monitor.
• Extensively created mapping/Mapplets, reusable transformations using all the transformations like Joiner, lookup, filter, expression, stored procedure, aggregator, update strategy, worklets etc.
• Developed Workflows using task developer, worklet designer, and workflow designer in Workflow manager and monitored the results using workflow monitor.
• Created various tasks like Session, Command, Timer and Event wait.
• Modified several of the existing mappings based on the user requirements and maintained existing mappings, sessions and workflows.
• Tuned the performance of mappings by following Informatica best practices and also applied several methods to get best performance by decreasing the run time of workflows.
• Extensively worked with the QA team to get the system and Integration testing done successfully and involved in ETL testing, Created Unit test plan and Integration test plan to test the mappings, created test data.
• Involved in preparing material and training Business users
• Implemented slowly changing Dimensions (SCD, Both Type 1 & 2).
• Extensively worked on transformations like Lookup (Connected and Unconnected), Aggregator, Expression, Router, Filter, Update Strategy and Sequence Generator.
• Created and Scheduled Sessions and Batch Process based on demand, run on time, run only once using Informatica Workflow Manager.
• Involved in Creating Tasks in the DAC for New or Modified Informatica Workflows.
• Created Custom Index’s in the DAC.
• Involved in Building and Running Execution Plan with the DAC.
• Involved in running DAC Full Load and scheduled it for Incremental Load, also successfully handled the ETL failures with the DAC.
• Involved in importing and exporting DAC metadata in the process of migration from one environment to another.
• Performed Unit, Integration and Regression testing to validate and mapping functionality.
• Maintained extensive documentation for design, implementation and testing OBIEE Analytics requests, Dashboards.
• Involved in requirements gathering, analysis, and functional specification documents.
• Customized the existing Analytics Metadata Repository (.rpd) using OBIEE Admin tool by adding new measures into BMM layer.
• Upgrade the Repository from existing OBIEE 10g to OBIEE 11g.
• Designed and developed Web catalog, Reports/Dashboards with different Analytics using Oracle Business Intelligence Presentation Services.
• Configured Web Catalog Objects (Dashboards, Pages, Folder and Reports).
• Performance tuning of Dashboards/Reports and made changes to database by implementing the materialized views, partitions, re-building of indexes.
• Created iBots for caching the reports and delivering the reports contents.

Environment: OBIEE 11.1.1.5/10. x,Oracle BI Applications 7.9.6(Financial analytics), Informatica9.x/8.x, DAC, Oracle EBS, Oracle 11g, Toad.

Confidential, DETROIT, MI

INFORMATICA DEVELOPPER

Responsibilities:

• Participated in the design, development and deployment of reporting solutions.
• Designed and Developed Informatica Mappings from Scratch to Load the Data from Source System to Staging system and Warehouse System.
• Developed complex Initial/Incremental Informatica Objects (Workflows / Sessions, Mappings/mapplets with various transformations.
• Experienced with InformaticaPowerExchangefor Loading/Retrieving data from mainframe systems.
• Developed Informatica Mappings using corresponding Source, Targets and Transformations like Source Qualifier, Sequence Generator, Filter, Router, Joiner, Lookup, Expression, Update Strategy, and Aggregator.
• Developed complex mappings in Informatica to load the data from various sources.
• Implemented performance tuning logic on targets, sources, mappings, sessions to provide maximum efficiency and performance.
• Parameterized the mappings and increased the re-usability.
• Used Informatica power center for extraction, transformation and loading data from heterogeneous source systems
• Extensively created mapping/Mapplets, reusable transformations using all the transformations like Joiner, lookup, filter, expression, stored procedure, aggregator, update strategy, worklets etc
• Worked on Informatica Power Center tools- Designer, Repository Manager, Workflow Manager, and Workflow Monitor.
• Parsed high-level design specification to simple ETL coding and mapping standards.
• Designed and customized data models for Data warehouse supporting data from multiple sources on real time
• Involved in building the ETL architecture and Source to Target mapping to load data into Data warehouse.
• Created mapping documents to outline data flow from sources to targets.
• Involved in Dimensional modeling (Star Schema) of the Data warehouse and used Erwin to design the business process, dimensions and measured facts.
• Extracted the data from the flat files and other RDBMS databases into staging area and populated onto Data warehouse.
• Maintained stored definitions, transformation rules and targets definitions using Informatica repository Manager.
• Designed the Physical Layer with Aliases, views and followed all Industry standards.
• Designed BMM Layer and presentation layer according to the Business requirements.
• Configured the OBIEE Repository (RPD) and Implemented Security (Object Level and Data Level Security in the OBIEE Repository and Answers) using Repository Variables, Session Variables.
• Developed many Dashboards with different views (Pivot Table, Chart, Tabular and View Selector), dynamic dashboard prompts and guided navigation links
• Migration of Repository, OBIEE webcat and Informatica mapping across the environment.
• Implemented and configured Actions on development, Test, Production and UAT assigned users are groups and also masked the data and restricted users.

Environment: Oracle Business Intelligence 11.1.1.6/11.1.1.7 , BI Publisher, Oracle PL/SQL, Informatica 9.1/9.5, Toad, Windows XP, Oracle 11g

Confidential, NAPERVILLE, IL

INFORMATICA DEVELOPER

Responsibilities:

• Proactively communicated with the business users to understand the needs and develop requirement documentation.
• Designed and Developed Informatica Mappings from Scratch to Load the Data from Source System to Staging system and Warehouse System.
• Developed complex Initial/Incremental Informatica Objects (Workflows / Sessions, Mappings/mapplets with various transformations.
• Developed mapping parameters and variables to support SQL override.
• Created mapplets to use them in different mappings.
• Developed mappings to load into staging tables and then to Dimensions and Facts.
• Used existing ETL standards to develop these mappings.
• Worked on different tasks in Workflows like sessions, events raise, event wait, decision, e-mail, command, worklets, Assignment, Timer and scheduling of the workflow.
• Created sessions, configured workflows to extract data from various sources, transformed data, and loading into data warehouse.
• Used Type 1 SCD and Type 2 SCD mappings to update slowly Changing Dimension Tables.
• Extensively used SQL* loader to load data from flat files to the database tables in Oracle.
• Modified existing mappings for enhancements of new business requirements.
• Used Debugger to test the mappings and fixed the bugs.
• Wrote UNIX shell Scripts & PMCMD commands for FTP of files from remote server and backup of repository and folder.
• Involved in Performance tuning at source, target, mappings, sessions, and system levels.
• Prepared migration document to move the mappings from development to testing and then to production repositories.
• Developed Workflows using task developer, worklet designer, and workflow designer in Workflow manager and monitored the results using workflow monitor.
• Modified several of the existing mappings based on the user requirements and maintained existing mappings, sessions and workflows.
• Tuned the performance of mappings by following Informatica best practices and also applied several methods to get best performance by decreasing the run time of workflows.
• Extensively created mapping/Mapplets, reusable transformations using all the transformations like Joiner, lookup, filter, expression, stored procedure, aggregator, update strategy, worklets etc.
• Extensively worked with the QA team to get the system and Integration testing done successfully and involved in ETL testing, Created Unit test plan and Integration test plan to test the mappings, created test data.
• Involved in preparing material and training Business users.

Environment: Oracle Business Intelligence 11.1.1.6, informatica 9.1/9.5Oracle Data Integrator 11gR1, Oracle SQL Developer 3.0, Windows XP, Oracle 11g

Confidential, TAMPA, FL

OBIEE/INFORMATICA CONSULTANT

Responsibilities:

• Effectively interacted with the end users for requirement gathering and defined requirement specifications document by access and retrieval of financial and personnel data from one single source.
• Worked extensively on OBIEE Answers and Dashboards to create the reports as per the Client requirements.
• Used Informatica power center for extraction, transformation and loading data from heterogeneous source systems and to create mappings, mapplets transformations, re-usable transformations, etc.
• Involved in design and development of complex ETL mappings and stored procedures in an optimized manner.
• Implemented partitioning and bulk loads for loading large volume of data
• Extensively usedInformaticadebugging techniques to debug the mappings and used session log files and bad files to trace errors occurred while loading
• Wrote Custom SQL Codes for the reports. Developed Workflows using task developer, worklet designer, and workflow designer in Workflow manager and monitored the results using workflow monitor.
• Created various tasks like Session, Command, Timer and Event wait.
• Modified several of the existing mappings based on the user requirements and maintained existing mappings, sessions and workflows.
• Tuned the performance of mappings by following Informatica best practices and also applied several methods to get best performance by decreasing the run time of workflows.
• Extensively created mapping/Mapplets, reusable transformations using all the transformations like Joiner, lookup, filter, expression, stored procedure, aggregator, update strategy, worklets etc.
• Extensively worked with the QA team to get the system and Integration testing done successfully and involved in ETL testing, Created Unit test plan and Integration test plan to test the mappings, created test data.
• Involved in preparing material and training Business users
• Applied Optimization Techniques for the better performance of the reports.
• Worked with business analyst and users (Financial Advisors or FAs) to gather analytics requirements and created the business model using star schemas.
• Trained End Users and Pilot Users about OBIEE Tools.

Environment: OBIEE 10.1.3.4,Oracle BI Applications 7.9.4(Financial analytics, HR analytics), Informatica 8, DAC,Oracle 10g,Oracle EBS, SQL Developer, SQL*Plus, Informatica Power Center 7.1Windows-XP

Confidential

INFORMATICA DEVELOPER

Responsibilities:

• Analyze and understand the requirement documents, and prepared design documents
• Preparation of Unit Test Plans and verification of functional specifications and review of deliverables.
• Analyzed the requirements to identify the necessary tables that need to be populated into the staging database.
• Developed ETL mappings, Transformations and Loading using Informatica PowerCenter 7.x
• Developed mappings and workflows as per business logic, quality and coding standards prescribed for the module using Informatica PowerCenter 7.x.
• Developed, implemented and enforced ETL best practices standards.
• Created mappings using transformations like Source Qualifier, Aggregator, Expression, lookup, Router, Filter, Update Strategy, Joiner, Union, and Stored procedure, and XML transformations.
• Worked on Informatica PowerCenter tools - Source Analyzer, Warehouse Designer, Mapping & Mapplet Designer and Transformation Developer.
• Implemented Type I, II changes in slowly changing dimension tables.
• Used Error handling strategy for trapping errors in a mapping and sending errors to an error table.
• Performance tuning and bottleneck resolution.
• Created Unix Shell scripts to automate workflows.
• Used Workflow Manager for creating workflows, work lets, email and command tasks.
• Development of mappings in Informatica and reporting in Micro strategy and Business Objects.
• Performed regression Testing and Validation of data

Environment: Informatica PowerCenter 6.1, Oracle 9i, SQL*Plus, Toad, Windows 2000, Micro strategy, Mercury Quality Center