Profile Summary:

• Around 9 years of extensive IT Experience in Requirements Gathering, Software Analysis, Design, Development, Implementation, Maintenance and leading teams for a wide range of applications in all phases of Software Development Life Cycle.
• Over 5 years of experience with Informatica 9.x/8.x Power Center as an ETL tool.
• Over 6 years of application development experience in Oracle 10g/11g, mainframe DB2 and DB2 UDB.
• Over 5 years of experience with Mainframe languages and tools.
• Over 4 years of experience in estimating, scheduling and leading projects from discovery to warranty phase.
• Expertise in writing the technical specification documents HLD LLD from business requirements after analyzing the systems.
• Experience in working with different data sources like Oracle, DB2UDB, Mainframe DB2, Teradata, COBOL Files and Flat files.
• Mappings created using Lookup, Aggregator, Joiner, Expression and Normalizer Transformation.
• Extensive experience designing Informatica mapping strategies for both type-1 Full Load and type-2 Historical Data update processing.
• Developed reusable Transformations and Mapplets by using Mapplet designer.
• Extensively worked with Informatica tools like Designer, Workflow manager and Workflow Monitor.
• Excellent track record of leading end-to-end implementation and integration projects to successful completion under tight deadlines.
• Experience with industry standard methodologies like Waterfall, Agile, and Scrum methodology within the Software Development Life Cycle.
• Extensively worked on Database utilities like SQL Loader, BTEQ, Toad and AQT.
• Experienced in writing PL/SQL Procedures, Functions, Packages, Stored Procedures, Performance Tuning and Batch Processing.
• Experience in various Industry Sectors Such as Retail, Health Insurance Enrolment and Billing and P C Insurance applications Commissions .
• Excellent analytical, problem solving, communication and interpersonal skills, with ability to interact with individuals at all levels.
• Experience in project support like handling incidents and changes and experience with HP Service Center, Clarity, MS Project 2010.
• Experience in job scheduling tools like CA7 and ESP.
• Valuable experience in handling offshore teams.

Technical Skills:

Operating System : Windows 2000/98/NT, UNIX, MVS

Tools : Informatica Power Center 9.x/8.x , Putty, WinSCP, CA7, ESP, SyncSort File-Aid, MS Project, Visio, HP Service Center

Database : ORACLE 10g/11g, DB2 UDB, Mainframe DB2, Teradata

Languages : SQL, PL/SQL, Shell Scripting, COBOL, CICS

Professional Work Experience:

Confidential

Informatica Lead

Responsibilities:

• Worked with Business Users to gather the Requirements and business logics for the new changes.
• Analyzed existing source systems and the new target tables.
• Prepared Functional specs, Technical specs, Test plan, Test Cases and Unit test plans.
• Created a design document for data flow process from different source systems to target system.
• Extensive use of Informatica Transformations like Joiner, Aggregators, Connected unconnected lookups, Filters, Sequence generators, Routers, Expression, Sorter etc.
• Created reusable transformations and mapplets to import in the common mappings to avoid complexity in the mappings using Informatica designer.
• Used PL/SQL procedures and functions in mappings to do complex database level operations.
• Estimated, scheduled and co-ordinated work with the offshore team.
• Designed and developed exception handling and data cleansing / standardization procedures.
• Involved in migrating the Mappings, Sessions, Workflows from Test environment to Production environment.
• Optimizing ETL process for performance, identifying and managing data quality issues.
• Created documents for data flow and ETL process using Informatica mappings to support the project once it implemented in production.
• Provided Lights-on support for the existing calculation application.

Environment:

INFORMATICA POWER CENTER 9.1, UNIX, ORACLE 10G/11G, TOAD, SHELL SCRIPTING, AND WINDOWS

Confidential

Informatica Lead

Responsibilities:

• Leading a team of 6 members.
• Interacted with Business Users to gather the Requirements and interpret Use Cases for new .Net screens and new batch business logic.
• Estimated development hours using SMC and Function Point methodologies.
• Designed the blueprint of processing information from Hallmark third party through Informatica and Mainframe batch and reflecting necessary information on .Net screens.
• Reviewed the technical specification document and data mapping/data flow document.
• Directed the team to track the development status of project and assigned the work according project time line and individual workload.
• Tracking project milestones by creating and presenting Weekly/Monthly Status Reports.
• Directed the team to maintain high standard documents and deliverables by defining and providing templates for Informatica mapping design, Screen prototype design, error log design, unit and system testing, system migration and job schedules.
• Used PL/SQL procedures and functions in mappings to do complex database level operations.
• Designed and developed exception handling and data cleansing / standardization procedures.
• Created and Documented ETL and batch Test Plans, Test Cases, Test Scripts, Expected Results, Assumptions and Validations.
• Optimizing ETL and batch process for performance, Identifying and managing data quality issues.

Environment:

INFORMATICA POWER CENTER 8.6, ORACLE 10G, TOAD, MAINFRAME DB2, SHELL SCRIPTING, MAINFRAMES, .NET AND WINDOWS

Confidential

Informatica Lead

Responsibilities:

• Leading a team 7 members including onshore and offshore.
• Attending project kick-off and requirements meetings and clearly understanding requirements documentation, explaining them to the offshore team and clarifying and finalizing them with the client IT and Business teams.
• Prepared and reviewed estimates, presented and justified them to the Project Management team and sending finalized estimates back to offshore for resourcing and project planning purposes.
• Written high-level design documents from the BRD provided by business Analyst.
• Created Technical specifications after HLD walkthrough with business and users and review it with the whole development team.
• Designed completely new interfaces involving ETL and batch and coordinated their development by organizing internal and external interfacing areas.
• Developed PL/SQL Packages, Functions, Procedures, and Triggers to implement the Business Logic.
• Tuned SQL and stored procedures for performance and to meet user requirement.
• Performed the Unit Testing and smoke testing which validate the data is mapped correctly which provides a qualitative check of overall data flow.
• Created and Documented ETL and Batch Test Plans, Test Cases, Test Scripts, Expected Results, Assumptions and Validations.
• Tracking project progress, making sure that Project Plans and milestones are met and reviewing and presenting WSRs and MSRs to the IT and PM teams.
• Creating release documentations using Service center and update Release Management team regularly on the project status.
• Providing rotating Lights-On support for the Mainframe Batch and Informatica Batch processes.

Environment:

INFORMATICA POWER CENTER 8.6, ORACLE 9I/10G, TOAD, MAINFRAMES, COBOL, SHELL SCRIPTING AND WINDOWS NT

Confidential

Technology Analyst - ETL

Responsibilities:

• Leading a core development team of three members
• Involved in jobs and analyzing scope of application, defining relationship within between groups of data.
• Collaborated with Project Tech leads to analyze requirements and provide inputs to help in estimating effort.
• Written high-level design documents from the BRD provided by Business Analyst
• Created Low-level documents Technical specifications and design document after HLD walkthrough with business and users
• Translated detailed design into working code base, reviewed coding done by other team members and maintained versioning and prevented overlapping of code
• Written stored Procedures and Functions to archive data on timely basis and keep the database size in control.
• Designed and developed complex Procedures, Functions Packages to handle errors and exceptions at database level using PL/SQL.
• Involved in creating staging Tables, Indexes, Sequences, Views and performance tuning like analyzing tables, proper indexing.
• Provided offshore hour Lights-On support for Informatica Batch and Mainframe Batch Enrolment and billing cycles, maintain and assign abend ticket records to team members and retain resolution document repository.
• Created and Documented ETL and Batch Test Plans, Test Cases, Test Scripts, Expected Results, Assumptions and Validations.
• Created and maintained the detailed project documentation.
• Worked with user requests, resolved their issue with data load and answering their question regarding jobs and their load frequency.
• Identifying bugs in existing mappings by analyzing the data flow, evaluating transformations and fixing the bugs so that they conform to the business needs.

Environment:

INFORMATICA POWER CENTER 8.6, ORACLE 9I/10G, TOAD, QMF, MAINFRAME DB2, COBOL, SHELL SCRIPTING AND WINDOWS NT

Confidential

Technology Analyst - ETL

Responsibilities:

• Provided round-the-clock single person support for the OMVS unix batch that received all retail data, eg. Advertising, pricing and promotions, etc., packaged and compressed them based on regions and broadcasted them to all the stores before opening according to the time zone via Netman satellite.
• Design and maintain the ETL processes to store all the received data into DB2.
• Ensure SLAs for refreshing of retail storefront dashboard from tables after completion of batch ETL processes.
• Responsible for technical integrity within the application/subsystem.
• Identified improvement opportunities and documented and justified them as application enhancements.
• Designed, Coded, Tested and implemented the enhancements to the jobs/programs in order to reduce support issues.
• Meeting and coordinating with various interfacing teams like advertising, promotions, etc. and discussing and solving any data transmission issues they face.
• Managing planning and allocation for the offshore team and coordinating that effort.

Environment:

OMVS UNIX, STORED PROCEDURES MAINFRAME DB2, ETL, VSAM FILES AND WINDOWS XP

Confidential

Software Engineer - ETL

Responsibilities:

• Studied and analyzed the business requirements.
• Interacted with different group of users for analysis of the system.
• Used stored procedures to do complex database level operations.
• Involved in creating staging Tables, Indexes, Sequences, Views and performance tuning to load into tables, analysing tables, proper indexing and dropping.
• Performed Performance Tuning of sources, targets, mappings, transformations and sessions.
• Designed ETL flows to move data between the two financial systems.
• Monitoring the Scheduled jobs and Respond for ant failure alert received from server.
• Created documents which give the clear idea about the Tables, Views, script files, Log files, Source Flat files information, FTP Process, Control files and Production migration information.
• Ensuring configuration control of all documents in the project to meet CMM audit requirements.

Environment:

ETL, STORED PROCEDURES, MAINFRAME DB2, VSAM FILES, UNIX AND WINDOWS XP