OBJECTIVE:

• To obtain a position in IT, where my knowledge in Informatica, Data warehouse can be used.

SUMMARY

• 6 years of total IT experience and technical proficiency in building Data Warehouses, Data Marts, Data Integration, Operational Data Stores and ETL processes for clients in HealthCare MMIS(Providers, Plans, Claims) domain and T - MSIS.
• 5+ years of strong experience in working with large scale Data Warehouse implementations using Informatica PowerCenter 9.x, Oracle, SQL Server on UNIX and Windows platforms.
• Extensive experience in Extraction, Transformation, and Loading (ETL) data from various data sources into Data Warehouse and Data Marts using Informatica PowerCenter tools (Repository Manager, Designer, Workflow Manager, Workflow Monitor).
• Expertise in implementing complex business rules by creating robust Mappings, Mapplets, Sessions and Workflows using Informatica PowerCenter.
• Experience in performance tuning of Informatica mappings and sessions to improve performance of the large volume projects.
• Experience in Migration, Configuration and Administration of Informatica PowerCenter.
• Experience in integration of various data sources like Oracle, DB2, SQL Server, Flat Files, XML files into Data Warehouse and also experienced in Data Cleansing and Data Analysis.
• Extensively used SQL in distributed environment.
• Worked extensively in all stages of SDLC, from gathering requirements to testing, implementation and support.
• Experience in preparing documentation such as High level design, System requirement document, and Technical Specification document etc.,
• Strong experience in writing UNIX Shell scripts, SQL Scripts for development, automation of ETL process, error handling, and auditing purposes. Experience in using Control-M scheduling tools to organize and schedule jobs.
• Experience in using IBM Clear Quest to track defects and document test cases.
• Worked with cross-functional teams such as QA, DBA and Environment teams to deploy code from development to QA and Production server.
• Experience in project management, estimations, and resource management activities.
• Excellent analytical, problem solving skills with strong technical background and interpersonal skills.
• Good skill in managing team and coordinating with client.

TECHNICAL SKILLS

Data Warehousing/ETL: Informatica Power Center 9.x

Databases: Oracle 11g/10g/9i, DB2 V8.01, SQL Server 2008

Programming: MS SQL, SQL Loader, Shell Scripting

Operating Systems: UNIX, Linux, Windows XP/2000

Other tools & Utilities: Microsoft Outlook, Microsoft Office, SharePoint, IBM Clear Case, IBM Clear Quest

PROFESSIONAL EXPERIENCE

Confidential, New Hampshire, NH

T-MSIS Architect

Responsibilities:

• Interacting with business owners to gather both functional and technical requirements.
• Documenting the business requirements and framing the business logic for the ETL process.
• Developing technical specifications and other helpful ETL documents following SME Group’s standards.
• Design, develop, and test Informatica mappings, workflows, worklets, reusable objects, SQL queries, and Shell scripts to implement complex business rules.
• Load historical and Daily data into Oracle data warehouse to enable business analysts to better understand, monitor, and analyse the business
• Migrating historical data from DB2 to the Oracle data warehouse.
• Transferring the data from various sources like XML, flat files, DB2 into Oracle data warehouse.
• Extensively worked on SCD type 2 using Look up transformation.
• Identifying bottlenecks/issues and fine tuning them for optimal performance.
• Oversaw unit and system tests and assisted users with acceptance testing.
• Performed/automated many ETL related tasks including data cleansing, conversion, and transformations to load Oracle 10G based Data Warehouse.
• Work with DBA’s and systems support personnel in elevating and automating successful code to production. Used control-M for job scheduling, workload automation and for operational flow.
• Developer Shell scripts to transfer files using FTP, SFTP, and to automate ETL jobs.
• Provide on-call support to production system to resolve any issues.
• Conducting code walkthroughs and review peer code and documentation.
• Playing role in design of scalable, reusable, and low maintenance ETL templates.

Environment: Informatica Power Centre 9.1, Oracle 11g/10g, Windows XP, SQL, PL/SQL, Shell Scripting, IBM Clear Case & Clear Quest 7.0.1, SQL Developer.

Confidential

T-MSIS Lead and Developer

Responsibilities:

• Interacting with business owners to gather both functional and technical requirements.
• Documenting the business requirements and framing the business logic for the ETL process.
• Developing technical specifications and other helpful ETL documents following SME Group’s standards.
• Design, develop, and test Informatica mappings, workflows, worklets, reusable objects, SQL queries, and Shell scripts to implement complex business rules.
• Load historical and Daily data into Oracle data warehouse to enable business analysts to better understand, monitor, and analyse the business
• Migrating historical data from DB2 to the Oracle data warehouse.
• Transferring the data from various sources like XML, flat files, DB2 into Oracle data warehouse.
• Extensively worked on SCD type 2 using Look up transformation.
• Identifying bottlenecks/issues and fine tuning them for optimal performance.
• Oversaw unit and system tests and assisted users with acceptance testing.
• Performed/automated many ETL related tasks including data cleansing, conversion, and transformations to load Oracle 10G based Data Warehouse.
• Work with DBA’s and systems support personnel in elevating and automating successful code to production. Used control-M for job scheduling, workload automation and for operational flow.
• Developer Shell scripts to transfer files using FTP, SFTP, and to automate ETL jobs.
• Provide on-call support to production system to resolve any issues.
• Conducting code walkthroughs and review peer code and documentation.
• Playing role in design of scalable, reusable, and low maintenance ETL templates.
• Leading a team of 6-Members
• Involved in Resource loading, calculating Project profitability and managing the team at offshore
• Involved in the project audit and ensuring the project is on track and green.

Environment: Informatica Power Centre 9.1, Oracle 11g/10g, Windows XP, SQL, PL/SQL, Shell Scripting, IBM Clear Case & Clear Quest 7.0.1, SQL Developer.

Confidential

Informatica Developer

Responsibilities:

• Interacting with business owners to gather both functional and technical requirements.
• Documenting the business requirements and framing the business logic for the ETL process.
• Developing technical specifications and other helpful ETL documents following SME Group’s standards.
• Design, develop, and test Informatica mappings, workflows, worklets, reusable objects, SQL queries, and Shell scripts to implement complex business rules.
• Load historical and Daily data into Oracle data warehouse to enable business analysts to better understand, monitor, and analyse the business
• Migrating historical data from DB2 to the Oracle data warehouse.
• Transferring the data from various sources like flat files, Oracle into Oracle data warehouse.
• Extensively worked on SCD type 2 using Look up transformation.
• Identifying bottlenecks/issues and fine tuning them for optimal performance.
• Oversaw unit and system tests and assisted users with acceptance testing.
• Performed/automated many ETL related tasks including data cleansing, conversion, and transformations to load Oracle 10G based Data Warehouse.
• Work with DBA’s and systems support personnel in elevating and automating successful code to production. Used control-M for job scheduling, workload automation and for operational flow.
• Developer Shell scripts to transfer files using FTP, SFTP, and to automate ETL jobs.
• Provide on-call support to production system to resolve any issues.
• Conducting code walkthroughs and review peer code and documentation.
• Playing role in design of scalable, reusable, and low maintenance ETL templates.
• Leading a team with member size of 6.
• Preparing and sending status reports to the management and Client.
• Involved in Resource loading, calculating Project profitability and managing the team at offshore
• Involved in the project audit and ensuring the project is on track and green.
• Supported Go live.

Environment: Informatica Power Center 9.1, Oracle 11g/10g, Windows XP, SQL, PL/SQL, Shell Scripting, IBM Clear Case & Clear Quest 7.0.1, SQL Developer.

Confidential

Informatica Developer

Responsibilities:

• Interacting with business owners to gather both functional and technical requirements.
• Documenting the business requirements and framing the business logic for the ETL process.
• Analyzed the business requirements and functional specifications.
• Extracted data from oracle database and spreadsheets and staged into a single place and applied business logic to load them in the central oracle database.
• Used Informatica Power Center 9.1for extraction, transformation and load (ETL) of data in the data warehouse.
• Extensively used Transformations like Router, Aggregator, Normalizer, Joiner, Expression and Lookup, Update strategy and Sequence generator and Stored Procedure.
• Developed complex mappings in Informatica to load the data from various sources.
• Implemented performance tuning logic on targets, sources, mappings, sessions to provide maximum efficiency and performance.
• Parameterized the mappings and increased the re-usability.
• Used Informatica Power Center Workflow manager to create sessions, workflows and batches to run with the logic embedded in the mappings.
• Created procedures to truncate data in the target before the session run.
• Extensively used Informatica debugger to figure out the problems in mapping. Also involved in troubleshooting existing ETL bugs.
• Created a list of the inconsistencies in the data load on the client side so as to review and correct the issues on their side.
• Created the ETL exception reports and validation reports after the data is loaded into the warehouse database.
• Written documentation to describe program development, logic, coding, testing, changes and corrections.
• Created Test cases for the mappings developed and then created integration Testing Document.
• Followed Informatica recommendations, methodologies and best practices.
• Developed Shell scripts to transfer files using FTP, SFTP, and to automate ETL jobs.
• Leading a team with member size of 3.
• Preparing and sending status reports to the management and Client.
• Participated and involved in Triage calls to solve production issue.

Environment: Informatica Power Center 9.1, Oracle 11g/10g, Windows XP, SQL, PL/SQL, Shell Scripting, IBM Clear Case & Clear Quest 7.0.1, SQL Developer

Confidential

Informatica Developer

Responsibilities:

• Interacting with business owners to gather both functional and technical requirements.
• Documenting the business requirements and framing the business logic for the ETL process.
• Design, develop, and test Informatica mappings, workflows, worklets, reusable objects, SQL queries, and Shell scripts to implement complex business rules.
• Designed workflows with many sessions with decision, assignment task, event wait, and event raise tasks.
• Transferring the data from various sources like XML file into SQL Server data warehouse.
• Extensively worked on SCD type 2 using Look up transformation.
• Identifying bottlenecks/issues and fine tuning them for optimal performance.
• Performed unit and system tests and assisted users with acceptance testing.
• Work with DBA’s and systems support personnel in elevating and automating successful code to production.
• Developed Shell scripts to transfer files using FTP, SFTP, and to automate ETL jobs.
• Playing role in design of scalable, reusable, and low maintenance ETL templates.
• This was an individual project handled by me alone.
• Preparing and sending status reports to the management and Client.
• Participated and involved in Triage calls to solve production issue.

Environment: Informatica Power Center 9.1, Oracle 11g/10g, Windows XP, SQL, PL/SQL, Shell Scripting, IBM Clear Case & Clear Quest 7.0.1, SQL Developer

Confidential

Informatica Developer

Responsibilities:

• Documenting the business requirements and framing the business logic for the ETL process.
• Design, develop, and test Informatica mappings, workflows, worklets, reusable objects, SQL queries, and Shell scripts to implement complex business rules.
• Load historical and Daily data into Oracle data warehouse to enable business analysts to better understand, monitor, and analyse the business
• Transferring the data from various sources like flat files, DB2 into Oracle data warehouse.
• Extensively worked on SCD type 2 using Look up transformation.
• Identifying bottlenecks/issues and fine tuning them for optimal performance.
• Perform unit and system tests and assisted users with acceptance testing.
• Performed/automated many ETL related tasks including data cleansing, conversion, and transformations to load Oracle 10G based Data Warehouse.
• Used control-M for job scheduling, workload automation and for operational flow.
• Developed Shell scripts to transfer files using FTP, SFTP, and to automate ETL jobs.
• Sending weekly status report to the Team lead.

Environment: Informatica Power Center 8.6, Oracle 10g, Windows XP, SQL, PL/SQL, Shell Scripting, IBM Clear Case & Clear Quest 7.0.1, SQL Developer

Confidential

Informatica Technical support and Developer

Responsibilities:

• Informatica Technical support and Production monitoring.
• Fixing the production failures and closing the defects.
• Sending Defect status across the team and client
• Develop, and test Informatica mappings, workflows, SQL queries, and Shell scripts to implement complex business rules that came as CR.
• Performed unit testing on the developed CR’s.
• Sending weekly status report to the Team lead.

Environment: Informatica Power Center 8.6, Oracle 10g, Windows XP, SQL, SQL Developer