SUMMARY

• 8.9 years of experience in IT industry with in depth understanding of the life cycle of a software development project - Analysis, Software Development, System Testing, Bug fixing, Documentation and implementation.
• 6.10 years experience as an ETL Developer with the development of ETL’s for DatawareHouse/Data Migration using Informatica PowerCenter version 8.x/9.x, Power Exchange and SSIS (SQL Server Integration Services) ETL tools.
• Extensive knowledge on the PowerCenter components as PowerCenter Designer, PowerCenter Repository Manager, Workflow Manager and Workflow Monitor.
• Thorough knowledge in creating ETL’s to perform the data load from different data sources and good understanding in installation of Informatica.
• Fair knowledge in Informatica Developer (IDQ) and Informatica Business Analyst tools.
• Experienced in developing the mappings and transformations using PowerCenter Designer and executing the mappings through Work Flow Manager from multiple sources to multiple targets.
• Experience in integration of various data sources with multiple Relational Databases like SQL Server, IBM DB2 and Sybase and worked on integrating data from flat files.
• Good understanding of the Data Modeling (Dimension and Relational) concepts like Dimension and Fact tables, Star Schema Model and Snow Flake Schema Model.
• Involved in complete lifecycle of a project including writing test scripts and performing unit-testing by writing SQL against the database and validating with end users reports.
• Good knowledge in Data migration from SQL Server to DB2 using SSIS with numerous challenges like data integrity issues, data inconsistencies and high data volumes.
• Extensive knowledge in Data Analysis, Data Requirement Analysis and Data Mapping for ETL processes and the scheduler tool Autosys.
• Involved in implementation activities and Support activities post implementation.
• Experienced in data migration from Legacy systems to SAP target systems.
• Experience in the areas of Life Insurance and Mortgage Insurance domain.

TECHNICAL SKILLS

Design Knowledge: Datawarehouse

Languages: C, XML, SQL and Korn Shell Scripting, T-SQL (sybase), IBM

Mainframes: JCL, PLI

BI Tools: Informatica Power Center 8.x/9.x,PowerExchange, Microsoft SSISInformatica Developer(IDQ), Informatica Business Analyst tools

Domain Knowledge: Life Insurance, Mortgage Insurance

Operating Systems: Windows 98/2000 /XP and UNIX

Databases: Sybase, IBM DB2, MS SQL Server 2005

Job Scheduler: Autosys

Version Control: Serena -PVCS Dimensions

Tools: Toad 9.6, Embarcadero Rapid SQL

Defect Tracking Tool: HP Quality Center

Management Tools: HP Service Center, MS Office 2007, MS Visio 2007

Data Modelling: Erwin

PROFESSIONAL EXPERIENCE

Informatica Developer

Confidential, Auburn, IN

Responsibilities:

• Interaction with the SAP team to understand the migration specifications and underlying Legacy system.
• Evaluate the data migration solution to determine the scope of the overall effort.
• Create the Informatica mappings using Power Exchange to perform the data migration from Legacy systems to SAP.
• Run the mappings to test the migration and validate the test results on SAP.
• Testing of the mappings and validation of results to ensure migration perform according to defined specifications.
• Prepare validation process of the input data to avoid costly overruns by understanding and addressing data issues early.
• Document the steps written with mapping documents at a detailed level.
• Prepare code migration document and work with release team in migrating the code from Development to UAT, Production Servers.
• Production Support which includes the correction of the data that has been migrated according to the application needs.

Environment: Informatica Power Exchange, SQL Server 2005, SAP-IDOC’s

Informatica Developer

Confidential, Milwaukee

Responsibilities:

• Correlate the business to technical aspect and come up with design to create the mappings.
• Parsing design spec to simple ETL coding and mapping standards.Worked on Informatica Power Center tool - Source Analyzer, Data warehousing designer, Mapping & Mapplet Designer and Transformation Designer.
• Creation of Informatica Workflows, sessions and run that Sessions to load into Target and Debugging, Unit Testing of Mappings.
• Integrating the Work Flows to the Autosys jobs to schedule the run of the mappings.
• Perform Informatica code migrations to different Informatica repositories.
• Designed and developed Informatica Mappings to load data from Source systems to ODS and then to the DataWarehouse to DataMart by creating the Dimension nd Fact Tables.
• Extensively used Power Center to design multiple mappings with embedded business logic.
• Creation of mappings with the transformations like Lookups, Joiner, Rank,Source Qualifier, Aggregate, Expression, Filter, Update Strategy, Normalizer, Router,Union,Sorter,Mapplets etc in the Informatica Designer for populating target table in efficient manner per the business need.
• Created UNIX shell scripts for triggering/automating the execution of the informatica mappings.
• Design/develop the UNIX scripts and deployment in production using APLUS tool.
• Create the schema for the new mappings; define the data types, constraints, indexes in the database.
• Worked on command tasks, event wait tasks, event raise tasks, timer tasks to implement business logic
• Designed and developed UNIX scripts for creating, dropping tables which are used for scheduling the jobs.
• Used the scheduler tool Autosys for triggering the Unix scripts which inturn executes the Informatica sessions.
• Involved in writing test plan, Unit, System integration, user testing and Implementation of the modules.
• Assist in User Acceptance testing and ensure that all issues are resolved and an official sign off is obtained from the users regarding the same.
• Monitor the scheduled batch jobs for the execution of the workflows for any issues/failure or unusual behaviour.
• Conduct a thorough code review and ensure that the outcome is in line with the objective and all the processes and standards are followed.
• Review the detail level design and ensure that the IT standards are followed.
• Implementation of Code Fixes and Changes in Production.
• Prepare a detailed implementation plan and checklist.
• Create change management records for components implemented in production. Follow all the processes and standards for change control as specified by the clients Change management policy.

Environment: Informatica Power Center 8.1.1/9.0.1 , Sybase, IBM DB2, Toad, Visio, UNIX, Windows 2007.

Confidential, Milwaukee

Data Retention -Developer

Responsibilities:

• Identify the people soft general ledger system tables for the data retention activities.
• Analysis and understanding of the core business logic behind the tables identified for retention process.
• Create a detailed design document on the Retention/purge process for the GL tables.
• Creating the System appreciatiob document with the available options/proposals for the Data Retention activites.
• Delivering the desinged proposals to the end users and get the sign off on the effective proposal.
• Analysis and understanding the business requirements and the Designing of the data base for the migration of the data from SQL database.
• Conduting the review meetings for the design review and code reviews.
• Develop the Sybase stored procedures with the Business logic, UNIX scripts for executing the procedures.
• Create test cases to test the Retention/Purge process for the tables identified.
• Execute the test cases and validate the results to make sure that the intended records were purged and all the business logic was applied when the data was purged.
• Documents the implementation activties and checklist.
• Perform the testing in multiple test databases to ensure the smooth flow of the process.
• Coordinated with different teams like QA and testing teams, DBA’s for the project execution.
• Worked closely with the QA team during the testing phase and fixed bugs that were reported.
• Deployed the code to different environment in coordination with the engineering team and DBA’s.
• Migration of the Unix scripts and stored procuders with APLUS tool to the production environment.
• Implementation activities of the components created and validate the results after the first run.
• Production support of the components developed for General Leger Purge.

Environment: Sybase Database, UNIX scripts, Sybase stored procedure, Autosys.

Confidential, California

SSIS Developer

Responsibilities:

• Identify the tables for migration required for providing the data for the new web based application.
• Analysis and understanding the business requirements and the Designing of the data base for the migration of the data from SQL database.
• Analyzed user equirements for the system and Identified business rules for data migration
• Evaluate the data migration solution to determine the scope of the overall effort.
• Evaluation of the facotrs like Number and complexity of legacy Systems Type of migration, Cost estimation for the full project lifecycle, Legacy data quality, Amount of data and history to be converted, Target application architecture (i.e. schema, table, data types), Resource bandwidth and availability.
• Understand the existing SQL database structure and get the bad data corrected.
• Cleansing of the incorrect, redundant and outdated records.
• Create the SSIS data mappings to perform the data migration from SQL data base to the new data base designed in DB2 which is a onetime built migration process.
• Tested and validated to ensure migration perform according to defined specifications
• Loaded the data into the new application environment.
• Create test cases to ensure the Data integrity, data correctness and the record count of the data migrated.
• Avoid costly project overruns by understanding and addressing data migration issues early.
• Cleansing the data by Categorizing, standardizing.
• Transforming the data by applying business logic to data in order to adhere to target requirements.
• Document the steps written with mapping documents at a detailed level in order to be able to have an ETL developer applying the logic without having to worry about the reason for the transformations.
• Assist the QA team to perform the testing of the migrated data.
• Worked with DBA to set up development, test, stage and production environments.
• Prepared code migration document and worked with release team in migrating the code from Development to UAT, Production Servers.
• Reviewed code, design and test plans as appropriate throughout project lifecycle to assure IT compliance.
• Production Support which includes the correction of the data that has been migrated according to the application needs.

Environment: Sql Server Integration Services, IBM DB2, SQL Database, MS Access