PROFESSIONAL SUMMARY:

• 9 years of IT experience in Informatica Developer with complete software development life cycle including requirement gathering, analysis, design, development, implementation and maintenance of Data warehousing applications.
• Extensive experience DW/BI, BIAPPS &MDM technologies.
• Experience with implementing ETL solutions using Informatica Power Center & Informatica Cloud.
• Experience in all phases of development including Extraction, Transformation and Loading (ETL) data from various sources into Data Warehouses/Data Marts using PowerCenter Components.
• Hands on experience with Informatica Cloud & Informatica Cloud MDM.
• Very good knowledge in data warehouse designs using Star Schema and Snow Flake Schema Architectures, Fact and Dimension Tables, OLTP and OLAP applications.
• Various kinds of the transformations were used to implement simple and complex business logic. Transformations used are: Stored Procedure, Connected & Unconnected Lookups, Router, Expressions, Source Qualifier, Aggregators, Filters, Sequence Generator, Slowly Changing Dimension.
• Hands on experience with Informatica IDQ rules to Cleanse, Standardize and Deduplication.
• Worked on Address Doctor to Standardize Address data in different formats
• Used Debugger in the Mapping Designer to troubleshoot logical errors.
• Knowledge on Data stage.
• Experience in Informatica Administration activities and best practices.
• Experience in writing on - demand LINUX shell scripts for automation of ETL process.
• Worked on Test Scripts, Test Cases to perform Unit testing, System Testing and Load testing.
• Experience in SQL Fine Tuning Queries for better performance with large volume of data.
• Hands on experience with Business Objects reporting (BOXIR/3) tool.
• Experience using Confidential Business Intelligence Enterprise Edition (OBIEE).
• Hand on experience Data warehouse Administration Console (DAC) to schedule and run full and Incremental ETL loads, to schedule the Informatica jobs, and to customize Execution Plans.
• Full life cycle experience including requirement analysis, design, development, testing, implementation and documentation.
• Value Additions were showcased to customers and they were implemented with good response.
• Excellent communication skills, good organizational skills, self-motivated and extremely hardworking with ability to implement business concepts quickly and efficiently.

TECHNICAL SKILLS:

Tool: /Software ETL Informatica Power Center 9.6.1 Informatica Cloud, Informatica Cloud MDM ODI Scheduler Control-M Informatica Scheduling Data warehouse Administration Console (DAC) Shell Scripting Unix Shell Scripting

RDBMS: Confidential 11g SQL Server 2008 Teradata

Query Tools: SQL Developer PL/SQL TOAD SQL Server Management Studio

Languages: SQL,PL/SQL

Operating Systems: LINUX Windows Administration Informatica 9.6.1 Informatica Cloud

Reporting Tool: BOXIR/3 OBIEE

Testing Tool: Hp Mercury Change Management Service Desk Foot Prints

PROFESSIONAL EXPERIENCE:

Confidential - San Rafael CA

Senior DW/BI Consultant

Responsibilities:

• Involved in Analysis, Meeting with Business Analysts and Product owners to get the requirement
• Extract, Aggregate, Transform and validating the data to ensure accuracy and consistency
• Analyze the existing ETL process and develop the mapping as per business requirement.
• Establishing processes for maintaining, enhancing and ensuring the ongoing process and applicability of the reporting platform.
• Monitor all production issues and inquiries and provide efficient resolution for same.
• Working on performance tuning of the SQL materialized view to refresh as expected.
• Worked on code migration activity from Dev to Stage environment.
• Performed data quality analysis to validate the input data based on the cleansing rules and aggregation rules.
• Created predefined conditions in the universe level to restrict the volume of data to be pulled in the report.
• Created Classes, Dimension objects, Measure objects and Detail objects in the universe.
• Worked on Informatica tool like Source Analyzer, Mapping Designer, Transformations, Informatica Repository Manager and Informatica Workflow Manager.
• Worked on ad-hoc reports in BO to validate the data with old repots.
• Added new columns at universe level and validated the objects.
• Created parameters in Informatica Mapping Designer.
• Performed data quality analysis to validate the input data based on the cleansing rules
• Worked on performance tuning of the Task flows and reduced the file usages of the jobs.
• Managed deliverables in terms of Quality and Schedule.

Environment: Informatica 9.6.1, Confidential 11g, SQL Developer, BOXI R/3

Confidential - San Jose CA

Senior DW/BI Consultant

Responsibilities:

• Participating in requirement analysis sessions with Business team and coming up with conceptual, logical and physical data models using power designer.
• Preparing documentation to cover high level design, low level design, source to target mappings, Unit test cases, Promote sheets, Implementation plans, Production turnover document etc.
• Participating in change control meetings and coordinating with all the internal and external stakeholders for successful completion of the tasks.
• Development of ETL mappings to extract data from the various Sources and load it into the databases as required.
• Worked on EDI data integration using B2B Data Exchange.
• Worked on Informatica tool like Source Analyzer, Mapping Designer, Transformations, Informatica Repository Manager and Informatica Workflow Manager.
• Created parameters in Informatica Mapping Designer.
• Performed data quality analysis to validate the input data based on the cleansing rules
• Worked on Informatica Secure Agent migration from windows 32 to 64 bit.
• Worked on performance tuning of the Task flows and reduced the file usages of the jobs.
• Worked on code migration activity from non prod to Production environment. Performing unit testing, integration testing and User acceptance testing (UAT)
• Managed deliverables in terms of Quality and Schedule.

Environment: Informatica 9.6.1, Informatica Cloud, Informatica B2B Data Exchange,VLTrader,SFDC, SQL Server 2008, Workbench,Jira, ReST API, Microsoft Dynamics NAV

Confidential - San Jose CA

Senior DW/BI Consultant

Responsibilities:

• Coordinating with BSA team to understand requirements and updating the existing design documents for all the enhancement requests.
• Preparing Low level Design documents and maintaining them throughout the project and presenting the design in IT and Infrastructure design reviews.
• Preparing detailed test plans on all going development enhancement project.
• Developing and unit testing of Informatica mappings, workflows.
• Performance tuning at all levels i.e. source, target, mappings, workflow/session etc.
• Preparing detailed test plans with strong test cases to validate the data
• Maintaining the learning documents and all the support documents in Support central system.
• Worked on Data Synchronization, Data Replication & Contact validation.
• Worked to identify the SFDC Customer Golden record using Informtica Cloud MDM concept
• Worked on Address Doctor validation for validating the contact information.
• Worked on DQ rules to Cleanse & Standardize Customer, Contact Name, Address, Phone Number, Email Attributes
• Worked on code migration activity from one environment to another environment.

Environment: Informatica Powercenter9.6, Informatica Cloud MDM, Informatica Cloud, Address Doctor, SFDC, SQL Server, Confidential, Workbench, Data loader

Confidential - Sunnyvale CA

Senior DW/BI Consultant

Responsibilities:

• Leading the offshore team and responsible for Task allocation and Tracking
• Worked with Data SME (Subject Matter Expert) gathered all the functional and business requirements necessary for Code Development.
• Prepare the testing scope and testing Schedule.
• Involved in Historical & Incremental test plan preparation.
• Created unit test plans, test cases and reports on various test cases for testing the Dimension and Fact table’s data.
• Prepared guidelines and checklists for the team
• Managed deliverables in terms of Quality and Schedule.
• Performed data quality analysis to validate the input data based on the cleansing rules

Environment: Pentaho, Confidential 11g, TOAD, HP Mercury, OBIEE

Confidential - San Jose CA

Senior DW/BI Consultant

Responsibilities:

• Leading the offshore team and responsible for Task allocation and Tracking
• Involved in Analysis, Meeting with Business Partners in Sales force team.
• Worked on Informatica Power Center 8.6.1(Designer/Manager/Monitor/Repository Manager) for developing Mapping, Mapplets and workflows.
• Worked on Informatica Cloud for developing Data synchronization and Data replication tasks for pulling data from Salesforce.com.
• Designed Complex Informatica mappings with the help of Transformations such as Joiner, Router, Expression, Aggregator, and Lookup transformation, Source Qualifier.
• Used Session parameters, Mapping variable/parameters and created Parameter files for imparting flexible runs of workflows based on changing variable values.
• Responsible for monitoring scheduled, running completed and failed sessions. Involved in debugging the failed mappings and developing error-handling methods.
• Performed data quality analysis to validate the input data based on the cleansing rules.
• Designed improvements to current extract processes to streamline extracts.
• Involved in Historical & Incremental data load.
• Involved in the code review and system testing.
• Modified existing mappings and sessions based on the business requirement.
• Modified existing tables and code for hierarchy changes and streamlined processing. Coded and tested new ETL interface.
• Worked on OBIEE RPD and report level changes as per new enhancement.
• Created unit test plans, test cases and reports on various test cases for testing the Informatica mappings.
• Involved in migrating the Informatica objects & UNIX objects from Development Environment to Testing Environment and then to Production Environment
• Involved in DAC development and execution in all the environments.
• Involved in requirements gathering, project planning and coordinating with offsite and onsite teams for analysis, development, maintenance and support.

Environment: Informatica 8.6.1/9.5.1 , Informatica Cloud, Confidential 10g, Confidential EBS, SFDC, DAC, OBIEE, UNIX shell, TOAD

Confidential - San Jose CA

Senior Informatica Admin&Developer

Responsibilities:

• Interacted with business/end users to analyze business requirements & develop detailed requirement(s) document.
• Handling the Order management module individually.
• Value Additions were showcased to customers and they were implemented with good response.
• Worked on Informatica Power Center 8.6.1 tool - Source Analyzer, Mapping Designer & Mapplets, and Transformations.
• Performance and sizing tuning- Optimizing data loads, index management and query optimization.
• Conducted Performance tuning of application by modifying the SQL statements.
• Various kinds of the transformations were used to implement simple and complex business logic. Transformations used are: Stored Procedure, Connected & Unconnected Lookups, Router, Expressions, Source Qualifier, Aggregators, Filters, Sequence Generator, etc.
• Created and Configured Workflows, Worklets, and Sessions to transport the data to target warehouse Confidential tables using Informatica Workflow Manager.
• Worked on code migration activity from one environment other environment using deployment groups.
• Used Debugger in the Mapping Designer to troubleshoot logical errors.
• Created predefined conditions in the universe level to restrict the volume of data to be pulled in the report.
• Created Classes, Dimension objects, Measure objects and Detail objects in the universe.
• Performed Developer testing, Functional testing, and Unit testing for the Informatica mappings.
• Created new user and user groups for providing informatica access.
• Worked on informatica version upgradation. work with development team on L3 issues and follow the task to completion
• Involved in writing the scripts for INFA admin related activities.
• Involved in migrating the Informatica objects & UNIX objects from Development Environment to Testing Environment and then to Production Environment
• Coordinated with the offshore delivery team for the releases.

Environment: Informatica Power Center 8.6.1, Confidential 10g, UNIX, MS-ACCESS, Toad,Business Object XIR/2.

Confidential

ODI Developer

Responsibilities:

• Extensively involved in business and functional requirement analysis, understanding source systems thoroughly by creating the design process flow used for standard ELT implementations.
• Created the various type 2 mappings and assisted the team members during the mapping development and unit testing.
• Extract the SAP data using Loading Knowledge Module (LKM) and implemented the business logic
• Optimized Query Performance, Session Performance and Reliability.
• Responsible for monitoring scheduled, running completed and failed sessions. Involved in debugging the failed mappings and developing error-handling methods.
• Created unit test plans, test cases and reports on various test cases for testing the Informatica mappings.
• Involved in the User Acceptance Testing.
• Performance tuned the workflows by identifying the bottlenecks in targets, sources, mappings, sessions and workflows and eliminated them.
• Created the template mappings for different layers.
• As the coordinator of the project, responsible for maintaining all the project related codes, documents with proper version control and also maintained a list of Issues faced and resolutions provided during the Rebuilding process.
• Managed deliverables in terms of Quality and Schedule.

Environment: ODI 10g, SAP, OBIEE 10g UNIX, Windows XP

Confidential

DW/BI Developer

Responsibilities:

• Developed Mappings with transformations like Source qualifier, Aggregator, Expression, Lookup, Filter, Router, Sequence Generator, Update strategy, Rank etc.
• Worked on Informatica tool like Source Analyzer, Mapping Designer, Transformations, Informatica Repository Manager and Informatica Workflow Manager.
• Implemented performance tuning logic on targets, sources, and transformations to provide Maximum efficiency and performance.
• Involved in code changes based on additional requirements.
• Involved in Code review, Hand holding the issues during UAT.
• Involved with the Client’s testing team to track the defects to closure and to educate them on the system.
• Migration of Informatica objects from Development Environment to Testing Environment and then to Production Environment.
• As the coordinator of the project, responsible for maintaining all the project related codes, documents with proper version control and also maintained a list of Issues faced and resolutions provided during the Rebuilding process.
• Managed deliverables in terms of Quality and Schedule.

Environment: Informatica Power Center 8.1.1, Confidential 9i, Unix Shell scripting, Toad