SUMMARY

• 10+ years of experience in Design, Development & Implementation of Data warehouse & Datamart using ETL & Reporting Tools
• Experience implementing OLAP and Dimensional data modeling techniques such as star, snowflake schema and Slowly Changing Dimension Types etc.
• Experience defining Design Patterns, Development Methodologies, ETL Architecture & Standards
• Experience in ETL & Reporting Tool Evaluation process
• Experience in analyzing information system needs, evaluating end - user requirements, custom designing solutions
• Experience in troubleshooting for complex information systems with experience in resolving issues involving retroactive technical investigations
• Performed Data Profiling & Fit Gap Analysis as part of Data Architecture
• Experience in Data Migration, Data Integration & Business Process Mapping
• Experience in customizing and extending BI Apps data model for Financial Analytics, Sales Analytics Subject Areas
• Experience handling major modules independently and across the team
• Extensive hands-on experience in Designing and Developing ETL objects, Performance tuning, Production support and Maintenance using Informatica 7/8/9x Power Center.
• Good Experience in analysis and resolution of bottlenecks for tuning Informatica mappings to improve performance.
• Gather Requirements & Triage issues with the Business Users
• Experience working in Agile & Waterfall Projects
• Experience in Audit, Balance checks and Error handling techniques.
• Experince on DAC scheduling tool.
• Hand on experience in Oracle Business Intelligence Edition Enterprise (OBIEE), Tableau
• Hands on experience to create and modify the Reports, Dash boards in OBIEE
• Worked towards performance tuning in OBIEE and Data Warehouse environment using cache management, aggregate tables, and indexes.
• Knowledge on Pentaho tool
• Gained diverse domain experience by working with client like Logitech, Confidential, Pittsburg National Corp Bank (PNC), Amex, and GE Healthcare.

TECHNICAL SKILLS

Governance: Informatica Power Center 9.x/8.6/7.1, Pentaho, Oracle BI Apps, OBIEE, Tableau

RDBMS: Oracle, Denodo

RDBMS Tools: TOAD, SQL Developer

Programming Languages: UNIX Shell Scripting, Oracle PL/SQL

Version Control Tools: Winscp, CVS

Scheduling Tool: DAC, JAMS

Operating Systems: Windows XP, Windows Vista, Windows 7

PROFESSIONAL EXPERIENCE

Confidential, Fremont, CA

ETL Developer

Language/Platform:Informatica Power Centre 9.1, OBIEE, Tableau, Oracle, UNIX Shell scripting

Job Responsibilities

• Direct interaction with Client Partner, Line of Business, Product Manager, Project Manager.
• Gathering requirements through client interaction, meetings and discussions
• Proactively involved in business analysis and performing data analysis as per the business requirements and translate them into technical specifications
• Working in Agile methodology development.
• Responsible for preparing High-level Design document, Low level design document, Source to Target Mapping document.
• Responsible for reviewing design with tech team and business plan team.
• Designing and developing Informatica mappings and workflows.
• Increasing Code Reusability using Mapplets, Reusable Transformations, Worklets and Reusable Tasks to reduce redundancy in code.
• Developed Audit, Balance checks and Error handling techniques
• Involve in enhancements and maintenance activities of the data warehouse including performance tuning, rewriting of stored procedures for code enhancements.
• Automated the manual steps involved in production jobs.
• Responsible for end of end batch process run during SIT and UAT testing and fixing defects
• Responsible for all kind of release documents and support production release end to end from deployments to user sign off.
• Involved in RPD design & development in OBIEE
• Involved in Reports design in OBIEE Answers/Dashboard
• Involved in creating Tableau reports.

Confidential

Language/Platform:Informatica Power Centre 8.6, DAC, Oracle, OBIEE

Responsibilities

• Involved in Requirement gathering and Data modelling discussion to understand the business logic
• Creating Functional specification and Technical specification documents based on the requirement.
• Responsible for preparing High level Design document, Low level design document, Source to Target Mapping document.
• Designed and developed ETL code using Informatica Power Centre 8.6
• Lead an offshore team of 3 for complete design and developed ETL code using Informatica Power Centre
• Guiding the offshore team to implement the business logic in ETL by explain the design and reviewing the code developed by them
• Involve in enhancements and maintenance activities of the data warehouse including performance tuning.
• Worked on performance tuning to reduce the jobs run time from 12 hours to 4 hours.
• Experience in gathering reporting and analysis requirements, documenting the report specifications, implementing the metadata layers including Physical, Business Model and Mapping, and Presentation layer
• Customized reporting with OBIEE Answers and integrated them into the Dashboards, provided users flexibility of viewing summary report and navigate to detail level using navigation.
• Experience in using OBIEE Answers to create queries, format views, charts, and add user interactivity and dynamic content to enhance the user experience.
• Worked towards performance tuning in OBIEE and Data Warehouse environment using cache management, aggregate tables, and indexes.

Confidential

Language/Platform:Informatica Power Centre 8.6,Oracle, UNIX Scripting, OBIEE

Responsibilities

• Involved in Requirement gathering and Data modelling discussion to understand the business logic
• Creating Functional specification and Technical specification documents based on the requirement.
• Responsible for preparing High level Design document, Low level design document, Source to Target Mapping document.
• Designed and developed ETL code using Informatica Power Centre 8.6
• Created shortcuts and reusable objects.
• Extensively used Informatica client tools - Source Analyzer, Warehouse designer, Mapping designer, Mapplet Designer, and Informatica Workflow Manager.
• The Objective is to extract data stored in different databases such as DB2, SQL server, Flat files and to load data into staging Oracle tables.
• Developed different mappings by using different Transformations like Aggregator, Lookup, Expression, update Strategy, Joiner, Router, Normalizer, Sequence generator etc transformations in the mappings.
• Involved in enhancements and maintenance activities of the data warehouse including performance tuning.

Confidential

Language/Platform:Informatica Power Centre 7.4, DB2, Oracle, UNIX Scripting

Job Responsibilities

• Creating functional spec and technical spec documents based on the requirement.
• Involved in Preparation of informatica Functional Documents.
• Involved in Development of informatica Mappings, Sessions, Workflows using Transformations like Expression, Router, Filter, Connected and Unconnected Lookups, Joiner, Source Qualifier, Aggregator.
• Extensively worked with flat files.
• Modifying the existing mappings accordingly to new requirements & testing it.
• Resolving the issues related with Informatica.
• Monitoring the daily jobs, and resolving if any job failures occur.
• Checking of the data if it’s properly catered to data warehousing or not
• Understand the complexities of all the data warehouse projects running in production.
• Planning and Co-coordinating meetings for Production Support requirements.
• Involved in Development of UNIX Scripts.
• Resolving the issues from the functional Team, related with daily data load for stores.

Confidential

Language/Platform:Informatica Power Centre 7.1, Oracle, UNIX Shell scripts

Responsibilities

• Requirements Collection from client and its analysis.
• Extensively worked with data extraction, Transformation and Loading from source to target system using Informatica power center 7.1.
• Extracted data from different sources like oracle, flat files using Informatica.
• Developed mappings by creating transformations like Source Qualifier, Joiner, Filter, Router, Expression, Aggregator, Sequence generator, Lookup (connected, unconnected), Normalizer, Stored procedure and Update strategy.
• Created sessions, Worklets, Workflows and scheduling jobs and implemented Error handling mechanism for ETL mappings.
• Involved in Unit and load testing of all mappings.
• Prepared all kinds of documents like Mapping specifications, Unit test plans, Interface design specifications and Migration documents.
• Uploading all the related documents into CVS
• Involved in writing UNIX Shell scripts to run Informatica workflows.
• Involved in writing the shell scripts for file polling, creating list files and archiving the files.