SUMMARY:

• Almost 9 years of overall IT experience.
• 4+ years of experience as ETL Lead managing onshore and offshore resources
• 5+ years of experience as ETL Developer using Informatica PowerCenter
• Experienced in all phases of software development life cycle including requirement gathering, analysis, design, development, testing, debugging and production rollout.
• Data warehousing domain with understanding of Dimensional Modeling, Star and Snowflake Schemas.
• Performance tuning and optimization of ETL loads
• Strong experience in writing SQL, PL/SQL Blocks, Stored Procedures
• Hands on experience on Cognos Reporting
• Worked on POC for Qlikview and Oracle Endeca
• Extensively worked on Autosys Scheduling tool
• Extensive Experience in Release Management of Informatica / Oracle /UNIX packaging to Production System.
• Experience working on BMC Remedy Tools/HP Service Manager for Incident Management, Change Management and Problem Management.
• Have excellent interpersonal, Verbal & Written communication skills. Worked extensively on onsite offshore model and proven Customer Management Skills with business users.

CORE COMPETENCIES:

ETL tools: Informatica PowerCenter 8.1.1 & 9.0.0, Oracle Endeca

Reporting tools: Cognos, Qlikview

Databases: Oracle 10g, SQL Server

Scheduling tools: Autosys

Operating systems: Windows, UNIX

Tools: /Utilities: Toad, Perforce, Rapid SQL

PROFESSIONAL EXPERIENCE:

Senior ETL Developer

Confidential, Camp hill, PA

Responsibilities:

• Provide Estimation for the requirements and plan the release
• Act as single point of contact between business users and developers
• Work with data modelers and DBA’s to Design the dimensional model
• Documented technical analysis and design of ETL processes and testing of those processes.
• Provide Technical Specification Documents for the ETL Load
• Mentor team members in developing Informatica Mappings and Workflows as per the specifications
• Create Validation Scripts for unit testing
• Provide support during Integration, SAT and UAT testing.
• Plan the release and work with other teams to coordinate the code migration
• Provide weekly and Monthly Status Reports to management
• Help the team to overcome issues, challenges in ETL or Cognos Reporting
• Work with database team, release management team, testing team and production support to ensure smooth migration of code to production and knowledge transfer
• Ensure that Best Practices are incorporated starting from design to development
• Raise issues and concerns in a timely manner with concerned teams and managers.

Senior ETL Developer

Confidential, Camp hill, PA

Responsibilities:

• As an added responsibility design a reusable tool using Informatica to validate flat files sent to CMS
• Design the utility to in corporate more than 4000 validations for 8 files sent to CMS
• Data model the oracle tables used as metadata for the file validation
• Support during integration, UAT and production release phase
• Documented technical analysis and design of ETL processes and testing of those processes.
• Provide weekly and monthly status reports to management
• Work with database team, release management team, testing team and production support to ensure smooth migration of code to production and knowledge transfer

ETL Developer/Lead

Confidential, Irvine, CA

Responsibilities:

• Work as ETL Lead and manage team comprising of onshore and offshore resources
• Collaborate with Business analysts for Requirements Gathering, Business Analysis and provided recommendations for maintenance and enhancements.
• Developed functional specifications and worked with other team members to complete the application development and testing.
• Documented technical analysis and design of ETL processes and testing of those processes.
• Extensively worked with Repository Manager, Designer, Workflow Manager and Workflow Monitor.
• Provide weekly reports to Client manager on ETL jobs and raise any issues/risks.
• Worked in a managed services mode and reported available capacity for additional tasks that can be taken up.
• Also work as L3 team for production support
• Provide incident root cause analysis to client BSA and recommend solution to fix the issue
• Coordinate with Database team, application team to resolve Production batch job issues if necessary
• Create incident and track to closure in BMC Remedy for Production Issues. Worked on HP Service Manager as well for tracking Incidents, Problem and Change management tickets.
• Coordinate with Release team to migrate the code to various environment
• Involved in writing SQL scripts for unit and functional testing
• Worked on Autosys Scheduling Tool for Scheduling and Monitoring of jobs.
• Extensively involved in migration process of Informatica, Unix, Database and Autosys changes to Production
• Generated reports as per business requirements using Stored Procedures and generating Business Objects reports
• Communicated and discussed with business users and Application Support Team in order to research and resolve issues.

Technology Analyst

Confidential, Irvine, CA

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.
• Developed transformation logic and designed various Complex Mappings and Mapplets using the Designer
• 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.

Senior Systems Engineer

Confidential

Responsibilities:

• Analysis of specifications provided by the client.
• ETL developer.
• 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
• Responsible for documenting and resolving any production issues.
• Provided end-user training and support.

Senior Systems Engineer

Confidential

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