SUMMARY

• Over 9+ years of IT experience in Data Warehousing Business Intelligence reporting, Analysis, Design, Development, Testing, Implementation, Enhancement and Support of BI applications for various industries like Retail, pharmaceutical and healthcare.
• Experience in developing ETL mappings and scripts using Informatica PowerCenter 8.x.
• 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.
• Extensively worked on developing and debugging Informatica mappings, mapplets, sessions and workflows.
• Implemented SCD Type1 and SCD Type 2 and Incremental Logic (CDC - Change Data capture) concepts..
• Experience in performance tuning techniques.
• Strong understanding of Data warehouse concepts (Star schema, snow flake schema, facts and dimensions) and SDLC methodologies. proficiency with Unix scripting.
• Experience with Cognos Tools such as Cognos 10.x/8.8 BI suite (Framework manager, Cognos connection, Report Studio, Analysis Studio, Query Studio, Metric Studio and Event Studio) Cognos Report net 1.1 and Analysis Tools such as Cognos Power play transformer 8.x, Business Object XIR2, Informatica Powercenter 8.
• Expertise in Framework manager modeling which includes creating relational and dimensional models. (Database layer, Business Layer, presentation layer and Packages)
• Created security groups and implemented data level, object level and package level security.
• Expertise in developing Multidimensional Cubes using Cognos PowerPlay Transformer.
• Created simple to Complex Reports using Report studio (Drill through, Drill down, Master detail, Report level Joins, conditional formatting, scheduling and bursting the reports) and Analyzed data using Analysis Studio.
• Experience in developing standard and complex dashboards and implemented dynamic grouping using Report Studio.
• Experience in migrating reports from Impromptu to Report Net, and upgrading reports from Report Net to Cognos 8 BI and also upgrade previous version to latest versions (Cognos 8.4 to 10)
• Involved in Installation and Configuration of Cognos 8 BI (All components including Power Play and Framework Manager) in Distributed Environment (Development, Test and Production)
• Extensive experience with database languages such as SQL, and PL/SQL which includes writing queries, Stored Procedures, Functions and View Experience in databases like Oracle 10g/9i/8i MS SQL Server 2005/2000.
• Expertise in Business Object reports and Designer. Created various Webi and crystal reports and involved in various support activities.
• Experience in gathering and documenting end-user business requirements.
• Experience in team management (Task allocation and coordination)
• Excellent team player and self-starter with good ability to work independently, proficient at developing& implementing User Training programs and possess good analytical, problem solving and logical skills with ability to meet deadlines, multitasking and flexible in work schedules.
• Excellent in communication skills.

TECHNICAL SKILLS

BI Reporting Tools: Cognos 10.x, Cognos 8.x, Report Studio, Query Studio, Analysis Studio, Framework Manager, Cube Designer, Cognos Report Net 1.1, PowerPlay Transformer, ImpromptuWebeports, Business Objects XIR2.

ETL Tools: Informatica Power Center 8.x, 9.x, Data Stage

Operating Systems: Windows 2000/2003 Enterprise Server/Windows XP Professional

Databases: Oracle 8i/ 9i, 10g/11g, MS SQL Server 2000/2005

Database Tools: Toad 8.4

Software Packages: MS- office 2003, Microsoft word, excel and Power point

Programming skills: C, C++, HTML, SQL, PL/SQL

PROFESSIONAL EXPERIENCE

Confidential, Houston, TX

Informatica Lead

Responsibilities:

• Responsible for Business Analysis and Requirements Collection.
• 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.
• Experienced in using IDQ tool for profiling, applying rules and develop mappings to move data from source to target systems.
• Extensive experience in integration of Informatica Data Quality (IDQ) with Informatica PowerCenter.
• Maintained stored definitions, transformation rules and targets definitions using Informatica repository Manager.
• Used various transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner, Stored Procedure, and Union to develop robust mappings in the Informatica Designer.
• 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 Confidential 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.

Environment: Informatica Power Center 8.x, Cognos 10, Cognos 8.4-Framework Manager, Cube Designer, Report Studio, Query Studio, Analysis Studio, Oracle 10 g, Data stage, Kalido.

Confidential

Informatica Lead

Responsibilities:

• Responsible for Business Analysis and Requirements Collection.
• 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.
• Used various transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner, Stored Procedure, and Union to develop robust mappings in the Informatica Designer.
• 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 Confidential 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.

Environment: Informatica Power Center 8.6.1, Cognos 10, Cognos 8.4-Framework Manager, Cube Designer, Report Studio, Query Studio, Analysis Studio, Oracle 10 g, Data stage, Kalido.

Confidential

Sr Informatica Developer

Responsibilities:

• Logical and Physical data modeling was done using Erwin for data warehouse database in STAR SCHEMA
• Using Informatica PowerCenter Designer analyzed the source data to Extract & Transform from various source systems (oracle 10g, DB2, SQL server and flat files) by incorporating business rules using different objects and functions that the tool supports.
• Using Informatica PowerCenter created mappings and mapplets to transform the data according to the business rules.
• Used various transformations like Source Qualifier, Joiner, Lookup, sql, router, Filter, Expression and Update Strategy.
• Implemented slowly changing dimensions (SCD) for some of the Tables as per user requirement.
• Developed Stored Procedures and used them in Stored Procedure transformation for data processing and have used data migration tools
• Documented Informatica mappings in Excel spread sheet.
• Tuned the Informatica mappings for optimal load performance.
• Created and Configured Workflows and Sessions to transport the data to target warehouse Oracle tables using Informatica Workflow Manager.
• This role carries primary responsibility for problem determination and resolution for each SAP application system database server and application server.
• Worked along with UNIX team for writing UNIX Confidential scripts to customize the server scheduling jobs.
• Constantly interacted with business users to discuss requirements.

Environment: Informatica Power Center 8.x, Oracle 10 g, Windows XP, SQL, TOAD.