SUMMARY

• Ten years of functional and technical IT experience in analysis, design, development, testing and implémentation of ETL / Data Warehouse Technologies using Informatica 8.x to 10.x.
• Hands on experience on all phases of software development life cycle (SDLC) of Data warehousing, including requirement gathering from business users, analysis, design, creation of mapping documents, specification writing, development, testing, implementation and reviews.
• Extensive ETL experience using Informatica PowerCenter client tools (Designer, Workflow Manager, Workflow Monitor and Server Manager) and Informatica.
• Extensive experience in creating the Workflows, Worklets, Mappings, Mapplets, Reusable transformations and scheduling the Workflows and Sessions usingInformatica Power Center.
• Expertise in working with various transformations using Aggregator, Look Up, Update Strategy, Joiner, Filter, Sequence Generator, Normalizer, Sorter, Router and reusable transformation using Informatica PowerCenter Designer.
• Expertise in debugging and performance tuning the performance of Mappings and Sessions in Informatica and determining the performance bottlenecks.
• Experience in different software development methodologies like Waterfall Model and Agile Software Development process.
• Sound knowledge of Entity - Relationship (ER) Data modelling.
• Experience in interaction between cross functional teams to share the common methodologies, Technical designs/discussions and Project dependencies
• Extensively worked with Oracle PL/SQL Stored Procedures, Functions, Cursors, Indexes and Triggers and involved in Query Optimization
• Experience in Telecom, Banking and Financial domains.
• Expertise in implementing complex business rules involving financial calculations.
• Expertise in Analysis, Design and Implementation of Oracle Golden Gate for Oracle DB and data replication across regional data centers.
• Experience in UNIX Shell scripts for validating and scheduling Informatica jobs.
• Extensively worked on requirements gathering, design, Coding, Reviews, Unit testing, Test strategies and implementation.
• Knowledge of Informatica MDM.
• Demonstrated ability to work and communicate effectively with both business and technical audiences.
• Experience working as an Onsite Tech Lead coordinating with offshore teams
• Ability to quickly analyze and come-up with an efficient industry standard solution for a given problem.
• Willingness to learn and work on new technologies.

TECHNICAL SKILLS

ETL: Informatica PowerCenter 8.1/8.6.1/9.1.0/9.6.1/10.1. Talend, Syncsort.

Languages: C++, Java, Java script, SQL, PL/SQL, Unix Shell Scripting

Middleware: Oracle Golden Gate 10.1

Databases: Oracle 11g/10g/8i/9i, SQL Server 2000/2005/2008 , DB2MS Access 7.0/97/2000, Teradata.

Tools: TOAD for Oracle, SQL Developer, SQL* Loader

Data Modelling: Dimensional Data Modelling, Star Schema and Snowflake Schema, Erwin.

Scheduling Tools: Informatica Scheduler, Autosys, Tivoli, Crontab

Project Management: MS Projects, MS Office and Visio

PROFESSIONAL EXPERIENCE

Confidential, NYC

Sr. Informatica Developer/Lead

Environment: Informatica 9.6.1/10.1, Oracle 11g, Golden Gate 10, 11.1, Unix Scripting, SQL, PL/SQL, Autosys

Responsibilities:

• Involved in the full SDLC of the project including Analysis, Design, Development, Testing, Implementation and Support.
• Understanding Business requirements and preparing HLD and detailed design documnent.
• Extensively worked on deriving and validating the target general ledger code block mappings.
• Develop re-usable Transformations, Sessions, Mapplets, Worklets, Workflow as per the proposed solutions.
• Root cause analysis of the failed jobs.
• Design and implementation of Oracle GoldenGate Replication between Oracle Databases
• Liaise with Confidential business team to gather requirements.
• Implementing performance tuning methods to optimize developed mappings
• Designed/Developed a Informatica Auto Deployment Utility for Confidential . This utility helps to auto deploy the informatica objects from DEV to QA to PROD informatica repositories and viceversa.
• Participate in creating application architecture review sessions and documents.
• Perform high and low-level design, provide pseudo codes, implementation and reviews.
• Developed shell scripts to fine tune the ETL flow of the Informatica workflows
• Performance tuning for proposed solutions. Optimized/tuned mappings for better performance and efficiency.
• Involved in coding of the Business Rules through PL/SQL using the Functions, Triggers, Cursors and Stored Procedures.
• Developing and designing new & modifying existing informatica and Unix components.
• Analyze project requirements and estimate size and effort.
• Provide technical solutions to the business and regulatory requirements.
• Deliver high quality code and unit test application enhancements.
• Support system integration and user acceptance testing.
• Provide deployment and post-deployment support.
• Perform root cause analysis of any issues and work on solutions related to issue fixing.
• On call production support during onsite business hours and weekends.
• Onsite-Offshore coordination.

Confidential, St. Louis, MO

ETL Designer and Developer

Environment: Informatica 9.5.1/9.6.1 , Oracle 11g, Golden Gate 10, 11.1, Unix, SQL, PL/SQL

Responsibilities:

• Understanding Business requirements and preparing HLD and detailed design documnent business requirement.
• Develop Mappings, Sessions, Workflow and scheduled the Workflow to run Confidential a specified frequency.
• Impact analysis of functional changes required in existing systems.
• Performance tuning for proposed solutions.
• Developing and designing new & modifying existing INFA and Unix components.
• Developed Unix shell scripts for file validation, SQL programming and to automate the validation and execution of Informatica jobs.
• Develop database scripts such as SQL queries, PL/SQL Packages, Stored Procedures, Triggers, Functions, Cursors and Indexes.
• Monitoring, Enhancement & Quality addition to Production processes.
• QC deployment and testing.
• Develop troubleshooting guides for operation support team and provide training to operation support team.
• Developed Initial data load scripts to load data across Databases.
• Coordinate with Infrastructure team, system administrator to deploy application in production environment.
• Root cause analysis of the failed jobs.
• Develop golgen gate pocesses to facilitate near realtime data replication.
• Design and implementation of Oracle GoldenGate active-active, Bi-Directional Replication between Oracle Databases
• Preparation of Unit Test Plan and Unit Test cases for the business scenarios
• Performing unit testing and Integration testing scenarios.
• Performing code reviews according to standards.
• Tracking the defects and fixing them.
• Deployment support handle using check list in different environment.
• Release coordination & Implementation activities.
• Provided on call production support on rotation basis within the team.
• Handling client calls and discussing the daily issues and concerns.

Confidential

ETL Developer

Environment: - Informatica 8.6.1, Oracle 11g, SQL, Unix, PL/SQL

Responsibilities:

• Developed Informatica mappings, sessions and workflows to load the data from the source to staging levels and from staging tables to the respective Dimensions and Fact tables.
• Used various transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner, and SQL, Lookup (File and Database) to develop robust mappings in the Informatica Designer.
• Involved in Performance tuning Confidential source, target, mappings, sessions, and system levels.
• Created shell scripts to fine tune the ETL flow of the Informatica workflows.
• Migration of Informatica code to QA and Production Environments.
• Scheduling the jobs in production.
• Monitor the production jobs through IPC Workflow Monitor,Tivoli,Oracle and UNIX.
• Fixing the load failures and restart the load to meet SLA (Service Level Agreement).
• In case of Job Failure Fix the Problem and make the job run successfully.
• Capture failures and process messages.
• Document all the failures and leverage on them when the similar situation occurs
• Validate the production run after successful job execution.
• Root cause analysis of the failed jobs.
• Co-ordinate with all the application groups on any issues.
• Update the run book as and when required.
• Escalating data issues to clients encountered during the load

Confidential

Executive Professional Services/Developer

Environment: PLSQL, SQL, JavaScript, xml, Netsuite API, Payment Gateways API

Responsibilities:

• Develop Server Side scripts to handle transactions within Netsuite system
• Develop user event scripts to execute when certain event is fired.
• Involved in writing Procedures, functions & packages
• Responsible for reconciliation of the sales through Pensio and Collector Payment Gateways for credit card payments.
• Carrying out builds/deployment on test and production servers.
• Active participation in developing and deciding an approach for implementing a new requirement.

Confidential

Developer and Support Executive

Environment: - Informatica 8.1, Oracle 11g, SQL, Unix.

Responsibilities:

• Developed Informatica workflows to load the data from the source to staging levels and from staging tables to the respective Dimensions and Fact tables.
• Scheduling the jobs in production.
• Monitor the production jobs through IPC Workflow Monitor, Tivoli, Oracle and UNIX.
• Fixing the load failures and restart the load to meet SLA (Service Level Agreement).
• In case of Job Failure Fix the Problem and make the job run successfully.
• Capture failures and process messages.
• Document all the failures and leverage on them when the similar situation occurs
• Validate the production run after successful job execution.
• Root cause analysis of the failed jobs.
• Co-ordinate with all the application groups on any issues.
• Update the run book as and when required.
• Escalating data issues to clients encountered during the load