SUMMARY

• Close to 12 years of rich experience in software development life cycle comprising 4 years’ in SQL & PL/SQL, 8 years in Informatica PowerCenter and 1 year in Data Modeling.
• Experience in handling multiple project for customer account.
• Extensive experience using different SDLC methods like Agile, Waterfall, and Spiral Model.
• Developing data conversion/migration roadmap.
• Building team competencies through focused development efforts.
• Design and recommend ETL and analytics solutions in DWH and BI space.
• Experience working at client place at multiple geography in onsite - offshore model as well as Individual contributor.
• Expertise in Requirement Understanding and Analysis, ETL Design, Technical Design Docs (HLD, LLD).
• Extensive experience in ETL release management at all environments - migrating objects from Dev to Test to Prod.
• Experience in integrating various data sources like Oracle, SQL Server, DB2 UDB, Flat File, SAP and Sales force.
• Proficiency in data warehousing techniques like SCD, CDC and surrogate key assignment.
• Experience in code review (of Informatica mappings, PL/SQL, Shell scripts with standard best practices used in the industry).
• Strong experience in preparing test plans and test cases.
• Expertise in SQL, PL/SQL procedures/functions, triggers and exceptions.
• Experience in UNIX Shell Scripting.
• Expertise in Data modelling (Relational and Dimensional modelling).
• Implemented IBM IIW/IAA model for Claim center and policy.

TECHNICAL SKILLS

ETL Tools: Informatica PowerCenter 9.x, 8.x, PL/SQL

Databases: Oracle11g/10g/9i/8i, MS SQL Server 2005/2008, MS Access 7.0/2000

Data Modelling: Erwin

Development/Productivity Tools: PL/SQL, SQL*Plus, Toad, HP Quality Center

Functional Areas: Manufacturing, Healthcare and Life sciences, Energy & Utilities, Banking and Finance, Salesforce.com

Scheduling Tool: Control M

Languages: SQL, PL/SQL, UNIX Shell Scripting

Operating Systems: Windows NT/2003/2008,XP,7,8 Linux and HP-UNIX

PROFESSIONAL EXPERIENCE

Confidential, Hoboken, NJ

ETL Tech Lead

Environment: Oracle-11g, Informatica 9.6

Responsibilities:

• Understanding the business need and requirement details with respect of ETL implementation through Informatica
• Design discussion with SMEs/Business
• Presentation of technical design and attaining approval from business in case of change management.
• Preparing technical design document.
• Updating the stake holders about the progress.

Confidential, NY

ETL Tech Lead

Environment: Oracle-11g, Informatica TDM 9.6

Responsibilities:

• Understanding the business need and requirement details respecting ETL implementation through Informatica
• Design discussion with SMEs/BAs
• Presentation of technical design and attaining approval from business in case of change management.
• Preparing technical design document.
• Code review and addressing the technical queries of the team.
• Technical enhancements of code.
• Tuning and optimizing the code.

Confidential

Project Manager

Environment: Oracle-11g, Informatica 9.1

Responsibilities:

• I was responsible for planning and estimation.
• Participate in release management
• Task assignment and delivery responsibilities.
• Onsite-offshore co-ordination.
• Addressing the technical queries of the team.
• Preparing the Weekly Status Reports and Activity tracker.

Confidential

Data Architect

Environment: Erwin

Responsibilities:

• Designed the EDW and Central data mart as per IBM IAA/IIW model to implement claim centre.
• Created the source-target mapping doc to sync data definitions of GWCC data with IBM IIW model.
• Supported the ETL and Reporting team to understand the source-target mapping.

Confidential

ETL Architect

Environment: Oracle-11g, Informatica 9.1

Responsibilities:

• Understand and analyze the ETL requirements from business.
• Develop the Data mart dimension model.
• Create ETL TDD (Technical design doc).
• Planning to configure, and deploy code in various environments.
• Handle release management
• Task assignment and delivery responsibilities.
• Inputs to Project Planning and estimation.
• Onsite-offshore co-ordination.
• Addressing the technical queries of the team.
• Preparing the Weekly Status Reports and Activity tracker.

Confidential

ETL Tech Lead

Environment: Oracle-11g, Informatica 9.1, IBM DB2 Warehouse Manager.

Responsibilities:

• Understand and analyze the ETL requirements from business.
• Understand the Forklift process.
• Develop the Informatica workflows and mappings as per forklift solution design.
• Involved in planning to configure, and deploy code in various environment.
• Created and scheduled workflows to be executed as per the schedule provided by business team.
• Debug, monitor and troubleshoot data sourcing solutions.
• Task assignment and delivery responsibilities.
• Onsite-offshore co-ordination.
• Addressing the technical queries of the team.

Confidential

ETL Architect

Environment: Oracle-11g, Informatica 9.1, Salesforce.com

Responsibilities:

• Understand and analyze the ETL requirements from business.
• Understand the Fire service business functioning and system study.
• Create Technical design document (low level design).
• Develop highly complex mappings and reusable Informatica objects.
• Debug, monitor and troubleshoot data sourcing solutions as it was my first attempt to integrate with Sales force.
• Participate in release management.
• Support to configure, deploy code in various environment.

Confidential

ETL Lead

Environment: Oracle-11g, Informatica 8.6.1, IDQ 8.6, UNIX.

Responsibilities:

• I was responsible to get the knowledge transition of database and ETL sourcing flow (Informatica) from UBS SMEs
• Understand the Wealth management functioning and system study.
• Design and planning data sourcing metadata solutions
• Debug, monitor and troubleshoot data sourcing solutions
• Create and deploy scripts for data sourcing
• Participate in release management
• Support to configure, deploy code in various environment.
• Contributing in the preparation of SMTD document.

Confidential

Lead Developer

Environment: Oracle 10G, Informatica 8.1.1, B.O XI.

Responsibilities:

• Understanding the business need and requirement from customer to decide ETL strategy using Informatica.
• Inputs to Project Planning and estimation.
• Onsite-offshore co-ordination.
• Technical design & development of critical ETL components using Powercenter 8.1.1.
• Developed complex mappings using Normalizer Transformation.
• Developed mapping for incremental data extraction from upstream
• Created reusable mapplets used in upstream data extraction mappings.
• Created and scheduled workflows to be executed as per the schedule provided by business team.
• Created email tasks to send success/failure emails to mailer list.
• Developed PL/SQL procedures required in the ETL process.
• Code review of the module to ensure it meets the functional requirements.
• Monitoring and requirement tracking.

Confidential

Lead Developer

Environment: Informatica 8.6.0, BO 6.5, Oracle 9i.

Responsibilities:

• Requirement analysis and understanding the business logic.
• Onsite-offshore co-ordination.
• ETL High level and low level design.
• Informatica mappings development and unit testing.
• Code review to maintaining the quality of design and code.
• Providing the status reports to customers.
• Contributing in Process / flow enhancement.

Confidential, San Joes, CA

Sr. Developer

Environment: Informatica 8.1.1, Oracle 10G, J2EE (with Struts framework), OBIEE 10.3.1.

Responsibilities:

• Understanding the business need and requirement details for the offshore team.
• Preparing high/low level technical design document for the “Partner mapping” module.
• Developing Informatica Mappings and unit testing.
• Developed staging mappings for loading data from upstream to staging area by applying CDC logic.
• Developed Informatica mappings for loading the data incrementally into the target by using mapping variables.
• Created mapping / script to generate parameter file to define the mapping variables values using job control table.
• Creating partition at session level to improve the performance.
• Tuning and optimizing the Informatica SQ query.
• Addressing the technical queries of the team.
• Preparing the Weekly Status Reports and Activity tracker.
• Reviewing the code and suggesting corrections and improvements.
• Defect Tracking (Reviews as well as Testing).
• Deploying the new/changed code to the test server for QA.

Confidential, Texas

Lead Developer

Environment: Oracle PL/SQL for ETL.

Responsibilities:

• Understanding the business need and requirement details respecting ETL implementation through PL/SQL
• Preparing technical design document.
• Task assignment to the team (Development and change/enhancements).
• Coding of main business rules through backend Triggers, Stored programs and Packages using PL/SQL
• Tuning and optimizing the code.
• Code review and addressing the technical queries of the team.
• Preparing the Weekly Status Reports and Activity tracker.

Confidential, Houston, TX

Sr. Developer/DBA

Environment: Business Object, Oracle 9i, PL/SQL

Responsibilities:

• Handled code development through PL/SQL and tuning the PL/SQL code.
• Managed the offshore database for memory management and backups.
• Created and maintained new DB instances and handled export/import for development and testing purposes.

Confidential

Sr. developer/ DBA

Environment: PL/SQL, Oracle 9i, Erwin, Sun Solaris

Responsibilities:

• Identified the database changes required to support CANADA and IPC functionalities.
• There are six external databases which pour GM data to OWB application.
• I've identified the process changes that would come up to support CANADA and IPC requirements.
• Modified data model using Erwin.

Confidential

Sr. Developer

Environment: UNIX, Oracle 9i, PL/SQL

Responsibilities:

• Developed the “COPY”, “COPY BACK”, and “CONFLICT SCENARIOS” through PL/SQL stored procedure.
• Tuning and optimizing the database objects (i.e. Views, triggers, Functions, Procedures etc).

Confidential

Developer

Environment: Oracle 9i, PL/SQL

Responsibilities:

• Handled the development of new DB objects to implement new business login into the application.
• Did the performance tuning for the existing DB objects.
• Created new schemas in the database, used to grant and revoke privileges to users.

Confidential

PL/SQL Developer and SCEPTRE Support team member

Environment: PL/SQL

Responsibilities:

• Understanding the system and the data flow within the system
• Tuning and optimizing the database objects.
• Database related tickets, such as service request for database related changes and admin edit,
• Change Requests- minor/major enhancements or feature addition
• New developments and modification of the application for better functionality and additional business logic.

Confidential

Responsibilities:

• System Study, coding main business rules through backend Triggers, Stored Subprograms and front-end procedures and functions.
• Develop and Customize.