SUMMARY

• Have a total of 7+ years of IT experience.
• Have worked as an ETL Developer, Primary Production Support Coordinator with experience in Analysis, Development, Testing, Implementation and Maintenance of Data Warehousing projects.
• Have extensive exposure on Data warehousing domain with understanding of Dimensional Modeling, Star and Snowflake Schemas.
• Extensively used ETL methodology using Powercenter for supporting data extraction, transformation and loading process.
• Experience in Informatica Power Center (versions 8.1.1 & 9.0.0), Mappings, Transformations, Workflow Manager, Workflow Monitor and Repository Manager.
• Extensively involved in Informatica migration/upgrade from version 8.1.1 to 9.0.0.
• Identifying the bottleneck and involved in performance tuning and optimization of ETL loads both at the mapping and the session level and also at the database level.
• Have worked on large Data Warehouse implementations.
• Involved in documentation of Business process and their implementation.
• Involved in enhancing & Supporting of critical applications.. Have closely worked with business users & provided resolution / clarification to issues during UAT phase.
• Proficiency in data warehousing techniques like slowly Changing Dimensions.
• Extensively worked on scheduling tools like Autosys for scheduling ETL workflows & assigning dependencies.
• Extensively involved in testing activities of deliverables to production environment & supporting Go - live activities.
• Extensive Experience in Release Management of Informatica / Oracle /Unix packaging to Production System.
• Experience working on BMC Remedy Tools for Incident Management.
• Extensive exposure on Production support maintenance & Configuration management activities.
• Worked on developing various test cases for testing Informatica code.
• Have excellent interpersonal, verbal & written communication skills. Worked extensively on onsite offshore model and proven customer management skills with business users.

TECHNICAL SKILLS

ETL tools: Informatica PowerCenter 8.1.1 & 9.0.0

Databases: Oracle 10g.

Scheduling tools: Autosys

Operating systems: Windows, UNIX

Tools/Utilities: Toad, Perforce, Rapid SQL, VSS

PROFESSIONAL EXPERIENCE

Confidential, Irvine, CA

Technology Specialist / Primary Production Support Lead

Tools/Technologies: Informatica Power Center 9.0, Oracle, UNIX, Autosys.

Responsibilities:

• Interacted with Functional teams to understand the requirements
• Supporting the production batch for Issue Resolution
• Performed requirements gathering, developed Analysis & Design document
• Involved Business Analyst in requirements gathering, business analysis and project co-ordination
• Design, Development, Testing and coordination with Offshore Team.
• Involved in writing SQL scripts for unit and functional testing
• Coordinated the project tasks with the team and ensured that the projects are completed on time.
• Worked on Autosys Scheduling Tool for Scheduling and Monitoring of jobs.
• Extensively involved in ETL testing, Created Unit test plan to test the mappings, created test data.
• Documentation for the Informatica processes, naming conventions and best practices
• Extensively involved migration process of Informatica, Unix, Database and Autosys changes to Production

Confidential, Irvine, CA

Technology Specialist / Production Support

Tools/Technologies - Informatica 8.6.1, Oracle 10g, Autosys, Unix.

RESPONSIBILITIES:

• Working as an ETL / Data warehouse engineer in the Investment Data Warehouse (IDW) team focusing on building dimensional structures and extracting data from various legacy source systems.
• Collection and translation of business requirements into technical roadmap (ETL Design, Mapping document, Unit test cases) suitable for IDW implementation.
• Extensive worked on Informatica 8.6.1 (mappings, session, workflow) in creating various mappings focusing on SCD2 and SCD1 implementation.
• Worked extensively on critical production related issues ensuring within assigned SLA parameters
• Handling escalated production incidents and supporting them with root cause analysis information
• Extensively involved in creating & updating various support related manuals and preparing monthly metrics dashboards.
• Used Autosys as a scheduling tool for triggering workflows to load dimensional data.
• Using Perforce as a versioning tool for maintaining revision history for code.
• Effective Communication with data architects, designers, application developers and senior management in order to collaborate on projects that involve multiple teams in a vitally time-sensitive environment.
• Effectively involved in allocation & review of various development activities / task with offshore counter apart.

Confidential

Developer

RESPONSIBILITIES:

• Analysis of specifications provided by the client and providing solutions to the team.
• ETL developer.
• Was involved in re-development of various backend scripts catering to business needs.
• Setting up ETL metadata.
• Used Autosys as a scheduling tool for triggering jobs.
• Using Perforce as a versioning tool for maintaining revision history for code.
• Effective Communication with data architects, designers, application developers and senior management in order to collaborate on projects that involve multiple teams in a vitally time-sensitive environment.
• Effectively involved in allocation & review of various development activities / task with offshore counter apart.
• Understanding the business logic behind every piece of code and documenting requirements in a reverse engineering fashion
• Implementing and following quality processes and maintaining CMM related process documents

Confidential

Developer

RESPONSIBILITIES:

• Analysis of specifications provided by the client.
• Setting up ETL metadata.
• Migrating the metadata to QA environment using IN13 tool
• Used Autosys as a scheduling tool for triggering jobs.
• Using Perforce as a versioning tool for maintaining revision history for code.
• Understanding the business logic behind every piece of code and documenting requirements in a reverse engineering fashion