SUMMARY

• Over 10+ 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 9.x., Informatica MDM(Master Data Management), Informatica BDM(Big Data Management), Informatica TDM(Test Data Management) and Informatica EDC(Enterprise Data Catalog), IICS.
• Design, analysis and coding knowledge with COBOL
• Experience on Big data (AWS), Mainframes and Databricks.
• 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.
• Excellent project management, analytical and documentation expertise to coordinate the maintenance and development of various Web - based andmainframeapplications
• 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, Teradata 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, Informatica MDM and Data Stage, Informatica Power Exchange, Informatica EDC, Informatica BDM, IICS, Informatica TDM

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.
• Analysis on various M&TMainframeand Bond trading platforms
• Design & implement ETL process using Talend to load data from Worked extensively with Sqoop for importing and exporting the data from HDFS to Relational Database systems/mainframe and vice-versa. Loading data into HDFS.
• Worked with test management team (TDM) to understand and create test data
• 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.x, Cognos 10, Cognos 8.4-Framework Manager, Cube Designer, Report Studio, Query Studio, Analysis Studio, Oracle 10 g, Data stage, Kalido, Informatica TDM.

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, Power Exchange .
• 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.
• Design & implement ETL process using Talend to load data from Worked extensively with Sqoop for importing and exporting the data from HDFS to Relational Database systems/mainframe and vice-versa. Loading data into HDFS.
• Handled the tasks of explaining scope, criteria, and entry/exit strategy and Responsible for driving end-to-end Test scenarios efforts and in identifying test data using Test Data Management (TDM) technique
• Handled the tasks of explaining UAT scope, criteria and entry/exit strategy to less trained professionals and Responsible for driving end-to-end Test scenarios efforts and in identifying test data TDM for UAT
• 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.
• Mocked test datausing TDMto test all the scenarios and test cases planned.
• 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, TDM.

Confidential, NYC, New York

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, Teradata 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.
• Helped inETLprocess to load data intolanding tablesofMDM HubusingInformatica 9.1.
• Constantly interacted with business users to discuss requirements.

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

Confidential

Cognos Developer

Responsibilities:

• Implemented Framework Manager Security for Data access, Object level access and Package access based on the Organization Level.
• Designed models & cubes in Cognos Transformer using existing IQD’s from Framework Manager
• Modeled metadata from Oracle data source for use in Report studio and Query Studio using Framework Manager.
• Created various List Reports, Cross tab Reports and Drill through Report in Cognos Report Studio. Created model files in Framework manager.
• Designed Reports using most of the Report studio features (Conditional Formatting, Conditional Page layout, Sections, Page Breaks, Master-detail, Drill Through, Drill Down, Drill Up).
• Worked on Analysis Studio to develop multi-dimensional reporting.
• Done complete testing of Cognos Reports and validated data using Database.
• Modified the existing report as per user request and provided support to the user.
• Fixed the issues with Cognos reports and cubes.
• Migrated reports from Impromptu to Cognos 8.
• Documented functional and technical requirements for the metadata modeling and BI reports

Environment: Cognos 8(Framework Manager, Cognos Connection, Query Studio Report Studio, Analysis Studio, Powerplay, Windows XP, SQL Server 2005Employer: Infosys, Bangalore, India

Confidential

Cognos developer

Responsibilities:

• Used Informatica Power Center for (ETL) extraction, transformation and loading data from heterogeneous source systems into target database.
• Created mappings using Designer and extracted data from various sources, transformed data according to the requirement.
• Involved in extracting the data from the Flat Files and Relational databases into staging area.
• Mappings, Sessions, Workflows from Development to Test and then to UAT environment.
• Developed Informatica Mappings and Reusable Transformations to facilitate timely Loading of Data of a star schema.
• Interacting with the business users to gather business requirements and designing the functional and technical requirement documentation.
• Implementing the script provided by Cognos support to perform different functionalities.
• Developing the transformer models using power play transformer (OLAP) and also developing models using Cognos 8.3 / Cognos 8.4 / transformer.
• Modifying power cubes by adding new dimensions, levels and measures etc.
• Publishing cubes directly from Cognos 8.3/Cognos. 8.4 / transformer using new publish functionality.
• Provided Cognos reports as per user request.
• Modeled metadata from Oracle data source for use in Report studio and Query Studio using Framework Manager.
• Worked with development and project management team for early defect fixes.
• Provided dashboard reports to the users on weekly basis.
• Refreshed daily data by running the scripts in Toad.
• Implemented Security with LDAP and Group level security in Cognos Connection Portal.
• Used Cognos Connection for scheduling and bursting reports across the Business segments and providing additional security to published cubes as well as reports.
• I was also involved in Development Requirement gathering, Development and testing of Informatica mappings and Business Object reports

Environment: Cognos 8.4, Oracle 10 g, Windows XP, SQL, TOAD, Business Object XIR2, Informatica Power center 8.1