­­­­

EXPERIENCE SUMMARY:

• Overall 10+ years of experience in the Information Technology (IT) industry.
• 6+ years of extensive experience in Data Warehouse applications using INFORMATICA (9x/8x/7x/6.1), Oracle, DB2, IBM and UNIX platforms.
• Around 2 years of experience with SSIS ETL tool, Confidential tool Confidential, reporting tool Actuate and Cognos along with Informatica.
• Developed effective working relationships with client team to understand support requirements.
• Experienced to work in Development team, Production support teams in handling critical situations to meet the deadlines for successful completion of the tasks/projects.
• Experience in documenting High Level Design, Low level Design, Unit test plan, Unit test cases and Deployment documents.
• Hands - on experience across all stages of Software Development Life Cycle (SDLC) including business requirement analysis, data mapping, build, unit testing, systems integration and user acceptance testing.
• Excellent interpersonal and communication skills, technically competent and result-oriented with problem solving skills and ability to work independently and use sound judgment.
• Experience in resolving on-going maintenance issues and bug fixes; monitoring Informatica sessions as well as performance tuning of mappings and sessions.
• Expertise in scheduling Informatica jobs using Informatica and Control-M (UNIX).
• Good knowledge in Data warehousing concepts.
• Ability to work in Groups as well as independently.
• A f ast learner and quick in adapting to newer technologies.

TECHNICAL SKILLS:

ETL Tools: Informatica 9x/8x/7x/6.1,SSIS

OLAP Tools: Cognos8.2, Actuate8/9

Languages: UNIX

Databases: Oracle 8/9i/10g, DB2 8.1, SQL, PL/SQL

Operating Systems: DOS, WINDOW XP, 2000, NT

Web ware: Data Modeling Tool

HTML: Visio

Tools: & Utilities: TOAD, SQL Navigator, Putty, Edit Plus, Quality center, Remedy, RPM

PROFESSIONAL EXPERIENCE:

Confidential, Los Angeles, CA

Technical Lead

Environment: SSIS, SQL Navigator, Oracle 10,SQL Server,Putty, Edit plus, Remedy,Winscp

Responsibilities:

• Understand the existing systems and current customer requirements.
• Responsible for creating Low level design document based on the High-level design document for all Data stage jobs.
• Responsible for effective communication between the project team and the customer. Provide day to day direction to the project team and regular project status to the customer.
• Deliver new and complex high-quality solutions to clients in response to varying business requirements.
• Responsible for onsite coordination with the offshore team to get the development work scheduled/delivered with high quality. Worked on development activities on timely manner/peer reviewed offshore work before handing over to the client.
• Responsible for managing scope, planning, tracking, aspects of the project and 24/7 supporting specific application.
• Tune the performance of long running Oracle jobs by Analyzing tables and creating indexes in the table.
• Creating Checklists for Coding, Testing and Release for a smooth, better & error free project flow.
• Creating the Release Documents for better readability of code/reports to end users.
• Handling User Acceptance Test & System Integration Test apart from Unit Testing.
• Responsible to migrate the code to higher environments.
• Responsible to migrate DB components like table scripts, schema, synonyms, Indexes to higher environments for Data Stage jobs.

Confidential, Southfield, MI

ETL Technical Lead

Environment: Data Stage 8.7, SQL Navigator, Oracle 10,SQL Server,Putty, Edit plus, Remedy,Winscp

Responsibilities:

• Understand the existing systems and current customer requirements.
• Responsible for creating Low level design document based on the High-level design document for all Data stage jobs.
• Responsible for effective communication between the project team and the customer. Provide day to day direction to the project team and regular project status to the customer.
• Deliver new and complex high quality solutions to clients in response to varying business requirements.
• Responsible for onsite coordination with the offshore team to get the development work scheduled/delivered with high quality. Worked on development activities on timely manner/peer reviewed offshore work before handing over to the client.
• Responsible for managing scope, planning, tracking, aspects of the project and 24/7 supporting specific application.
• Tune the performance of long running jobs by Analyzing tables and creating indexes in the table.
• Creating Checklists for Coding, Testing and Release for a smooth, better & error free project flow.
• Creating the Release Documents for better readability of code/reports to end users.
• Handling User Acceptance Test & System Integration Test apart from Unit Testing.
• Responsible to migrate the code to higher environments.
• Responsible to migrate DB components like table scripts, schema, synonyms, Indexes to higher environments for Data Stage jobs.

Confidential, Milwaukee, WI

ETL Technical Lead and DataStage Admin

Environment: Data Stage 8.7, SQL Navigator, Oracle 10,SQL Server,Putty, Edit plus, Remedy,Winscp

Responsibilities:

• Understand the existing systems and current customer requirements.
• Responsible for creating Low level design document based on the High level design document for all Data stage jobs.
• Responsible for DataStage admin related activities as well, like upgrade DataStage and job slowness/kill the jobs etc.,
• Responsible for providing DataStage access to the user and code migration to higher environments.
• Responsible for effective communication between the project team and the customer. Provide day to day direction to the project team and regular project status to the customer.
• Deliver new and complex high quality solutions to clients in response to varying business requirements.
• Responsible for onsite coordination with the offshore team to get the development work scheduled/delivered with high quality. Worked on development activities on timely manner/peer reviewed offshore work before handing over to the client.
• Responsible for managing scope, planning, tracking, aspects of the project and 24/7 supporting specific application.
• Tune the performance of long running jobs by Analyzing tables and creating indexes in the table.
• Creating Checklists for Coding, Testing and Release for a smooth, better & error free project flow.
• Creating the Release Documents for better readability of code/reports to end users.
• Handling User Acceptance Test & System Integration Test apart from Unit Testing.
• Responsible to migrate the code to higher environments.
• Responsible to migrate DB components like table scripts, schema, synonyms, Indexes to higher environments for Data Stage jobs.

Confidential

Informatica Technical Lead and Developer

Environment: Informatica 9.0, SSIS, SQL Server Management studio, SQL Navigator, Oracle 10,SQL Server,Putty, Edit plus, Remedy,Winscp, DAC

Responsibilities:

• Understand the existing systems and current customer requirements.
• Responsible for creating Low level design document based on the High level design document for all Informatica mappings and SSIS packages.
• Responsible for developing workflows with Worklet’ Confidential, Event waits, Assignments, Conditional flows, Email and Command Tasks using Workflow Manager.
• Extensively involved in performance tuning on other developer’ Confidential mappings, such as incremental aggregation, manipulating values for DTM Buffer Pool Size and Buffer Block Size values, etc.
• Developed and documented Informatica Mappings/Transformations, and Informatica sessions for the business requirement.
• Tune the performance of long running mappings/SSIS packages by Analyzing tables and creating indexes in table.
• Identified and fixed bottlenecks and tuned the complex Informatica mappings for better Performance
• Involved in review of mappings after development
• Creating Checklists for Coding, Testing and Release for a smooth, better & error free project flow.
• Creating the Release Documents for better readability of code/reports to end users.
• Handling User Acceptance Test & System Integration Test apart from Unit Testing.
• Responsible to migrate the code to higher environments for both Informatica as well as SSIS.
• Responsible to schedule Informatica workflow in Informatica scheduler and DAC.
• Responsible to schedule SSIS packages in SQL server management Studio.

Confidential

Technical Lead

Environment: Informatica 9.0,SQL Navigator, Oracle 10,Putty, Edit plus, Remedy,Control-M

Responsibilities:

• Understand the existing systems and current customer requirements.
• Responsible for creating Low level design document based on the High level design document for all Informatica mappings.
• Responsible for developing workflows with Worklets, Event waits, Assignments, Conditional flows, Email and Command Tasks using Workflow Manager.
• Extensively involved in performance tuning on other developer’ Confidential mappings, such as incremental aggregation, manipulating values for DTM Buffer Pool Size and Buffer Block Size values, etc.
• Developed and documented Informatica Mappings/Transformations, and Informatica sessions for the business requirement.
• Tune the performance of long running mappings by Analyzing tables and creating indexes in table
• Identified and fixed bottlenecks and tuned the complex Informatica mappings for better Performance
• Involved in review of mappings after development
• Creating Checklists for Coding, Testing and Release for a smooth, better & error free project flow.
• Creating the Release Documents for better readability of code/reports to end users.
• Handling User Acceptance Test & System Integration Test apart from Unit Testing with the help of Quality Center as bug logging tool. Created & Documented Unit Test Plan (UTP) for the code.

Confidential

Informatica Developer and Confidential Developement

Environment: Informatica 7.1.3, Confidential, Trueinformation, Confidential portal,Actuate, SQL Navigator,Oracle 9, Putty, Edit plus,Remedy,RPM

Responsibilities:

• Understand the existing systems and current customer requirements.
• Responsible for creating Low level design document based on the High level design document for all the Confidential activities and informatica mappings.
• Involved maintenance work in Confidential as well as Informatica.
• To analyze the design, code and develop the rules in Confidential as well as the mappings/mapplets using ETL tool informatica according to the client specification.
• Used Parameter files for imparting flexible runs of workflows based on changing variable values.
• Extensively involved in performance tuning on other developer’ Confidential mappings, such as incremental aggregation, manipulating values for DTM Buffer Pool Size and Buffer Block Size values, etc.
• Developed and documented Informatica Mappings/Transformations, and Informatica sessions for the business requirement.
• Tune the performance of long running mappings by Analyzing tables and creating indexes in table
• Executed workflows from UNIX box.
• Identified and fixed bottlenecks and tuned the complex Informatica mappings for better Performance
• Involved in creating new Confidential environment in offshore.
• Involved in review of mappings after development

Confidential

Informatica and Report Developer

Environment: Informatica 8, Toad, Oracle 9i, Actuate 8/9,Putty, Edit plus, Confidential, Trueinformation, Confidential portal,Windows XP

Responsibilities:

• Understand the existing systems and current customer requirements.
• Interacting with business analysts and end users to identify and develop business requirements and transform them into technical requirements.
• Responsible for creating Micro design (Low level design) document based on the Macro design (High level design) document for all the reports as well as mappings.
• To analyze the design, code and develop the reports using Actuate tool and create mappings/mapplets using ETL tool informatica according to the client specification.
• Developed complex mappings involving multiple Flat Files as source using Aggregator, Union and update strategy Transformations to combine data from multiple flat file sources to single file
• Extensively involved in checking the data rows for both flat file Sources and relational targets of the ETL process
• Developed complex reports in Actuate 8 environment using SQL query.
• Involved maintenance work in Confidential as well as Informatica.
• Converted Actuate 8 reports into actuate 9 environment(as per client request)
• Involved in review of reports after development

Confidential

Informatica and Report Developer

Environment: Informatica 7.1.3, Actuate8,Toad, Oracle 9, Putty, Edit plus, Windows XP,Actuate8,Quality center

Responsibilities:

• Understand the existing systems and current business requirements.
• Responsible for studying initial requirements document on PFS and HSI applications, documenting requirements into various Function specifications
• Responsible for extending offshore support for production runs of HSI and PFS applications
• Discussing with Confidential support group for solving issues if any for the daily batch runs
• Responsible for creating low level design document based on the High level design for all the mappings for new business unit CML.
• Created and managed repositories, users, folders and assigning privileges.
• To analyze the design, code and develop the mappings using ETL tool Informatica according to the client specification.
• Developed simple pass through mappings to reload dimension tables monthly and annually
• Improve performance of mappings by identifying source, target and mapping bottlenecks.
• Extensively involved in Performance Tuning for ETL process at Source and target.
• Involved in Unit testing.