SUMMARY

• 6+ years of IT experience invarious stages of System Development Life Cycle including Design, Development, Maintenance and Testing in Pharmaceutical, Insurance, Finance and Healthcare sectors.
• Excellent working knowledge in industry advanced technologies, ASP.NET, VB.Net, C#.Net, Visual Basic 6.0, ASP, Java Script and VB Script.
• Proficient in developing code for database applications using ADO.NET Objects such as SQL Connection Objects, SQL Command Objects, Dataset Objects, Data Reader Objects and Data Adapter Objects
• Sound Understanding of Data warehousing concepts and Dimensional modeling (Star schema and Snowflake schema).
• Extensively worked on Data Extraction, Transformation, Loading with Oracle, SQL Server, Flat File and DB2 using Informatica Power Center 9.0/8.6/8.1/7.x/ 6.x.
• Knowledge in Dimension Data Modeling using Erwin 4.x tool.
• Proficient in coding with SQL, PL/SQL (Procedures, Functions, Triggers, Packages) using TOAD, SQL* PLUS and iSQL*Plus as an interface with the database.
• Extensively worked on Performance Tuning of mappings and sessions.
• Experience with UNIX shell script for Automation of ETL & Data transfer need.
• Exposure to SQL* Loader for bulk loading on Oracle database.
• Experience in Client/Server application development.
• Excellent team player with strong written, communication, interpersonal skills.

EDUCATION/CERTIFICATIONS

• Informatica Certified in Architecture and Administration PowerCenter 8.0
• Informatica Certified in Mapping Design PowerCenter 8.0
• Informatica Certified in Advanced Mapping Design PowerCenter 8.0
• Oracle 9i Certified Professional (OCP) (Exam#1Z0 - 147)
• Oracle 9i Certified Professional (OCP) (Exam#1Z0 - 007)
• B.S. - Computer Science

TECHNICAL SKILLS

ETL Tools: Informatica Power Center 9.0/8.6/8.1/7.x/6.x, Microsoft SSIS, Data Transformation Web Technologies: ASP.NET, ASP, HTML Modeling Tools: Erwin 4.x BI Tools: Oracle Discoverer, Crystal Report Scheduling Tools: Maestro, Control M, Crontab RDBMS: Oracle (10g/9i/8i), Teradata, SQL Server 2005, DB2, MS Access RDBMS Load Tools: SQL*Loader (Oracle) Languages: C#.NET, VB.NET, SQL, PL/SQL, Shell Scripting Operating System: MS Windows Vista/XP/2000/NT/98, MS DOS, Solaris, UNIX

Packages: MS-Office 2007/2003/XP/2000, Flash MX, GIF Animator

PROFESSIONAL EXPERIENCE

Confidential, Worcester, MA Apr 11-present

ETL Team Lead
Confidential, is a leading regional provider of Property and Casualty insurance products for individuals, families and businesses. The Hanover offers a wide range of Property and Casualty products and services through an extensive network of Independent Agents.

Summary:
Confidential, currently uses legacy, Policy Management System based billing systems for all types of billing and commissioning functions. This project is to replace the legacy billing and commissioning systems with Guidewire Billing Center. Along with Guidewire Billing Center implementation, there is a requirement to centralize the operational data of insurance entities like Policy, Customer, Cash Allocation etc, across the enterprise to a single correct source of master data. With this purpose in mind the Operation System of Record as a master set database will be developed. Guidewire Billing Center will read and write data in Operation System of Records database layer via real time services. Informatica PowerCenter ETL jobs will load data from staging tables (Policy Management System Data) into the Operational System of Records data layer. The Guidewire billing system will eventually replace all billing functions currently performed in Hanover Policy Management Systems for all lines of business. This includes basic billing requirement such as Billing, Payments, Legal Collections, Invoicing, Documents, General Ledger Reporting, Payroll Deduct, Reporting and Reconciliation.

Responsibilities:

• Coordinated with business users to gather the new requirements and worked with existing issues
• Involved in business analysis and technical design sessions with business and technical staff to develop requirements document and ETL specification document
• Extensively used Informatica 8.6/Power Exchange to load Policy, Consumer, Billing, Payments, Legal Collections, Invoicing, Documents, General Ledger Reporting and Payroll Deduct subject areas data from Policy Management System (PMSv4) and Point of Sale (POS) to DB2 and Oracle staging tables and from staging to Operational System of Records and then to data warehouse.
• Worked closely with various levels of individuals to coordinate and prioritize multiple projects, estimates, schedule and track on ETL projects throughout Software Development Life Cycle (SDLC)
• Helped the team in analyzing data quality issues and performed testing and debugging on Informatica mappings as per Unit test case documents
• Tuned Informatica mappings and sessions for optimum performance of overall data warehouse process
• Used SQL server transformation for balancing process and dynamic sequencing
• Used Industrial Best Practices (velocity) for Error handling.
• Utilize Tivoli Job Scheduling software to schedule PowerCenter workflows and configured the session for Email notification as per the business need
• Created different types of reports (List Reports, Cross Tab Reports, Drill Through reports) using Hyperion interactive reporting tool
• Prepared the documentation of ETL data warehouse processes to support knowledge transfer and assisted in end user training.

Environment: Informatica 8.6, Informatica Power Exchange, Toad for Data Analyst, IBM Mainframe DB2, Flat files, Oracle 9i, Quality Center 9.0, Tivoli Job Scheduling, Hyperion Interactive Reporting System 9, SQL Server 2008, WS FTP, Windows XP, UNIX

Confidential, Somerset, NJ Feb 10-Mar 11

ETL Tech Lead
Confidential, is a leading provider of insurance and other financial services to millions of individual and institutional customers throughout the United States.

Summary:
Confidential, is in the process of designing the Operational Data Store (ODS) which will be accessed by all various MetLife systems. Operational Data Store will aggregate data and computations from multiple systems including Oracle PAS and will be used as a source for extract needs of MetLife downstream consumers.

Responsibilities:

• Interact with the business users to understand the business requirements.
• Involved in the development of High and Low Design Document documents for the ETL processes.
• Extensively used Informatica 8.6 and Data Transformation to load Policies (CLOB Acord XML) data from OPAS database to ODS Mainframe database.
• Developed various Complex Mappings in Power Center Designer with accuracy and efficiency to achieve operational objectives.
• Used the PowerCenter Debugger for Critical Mappings debugging to check the data flow.
• Used Mapping Parameter in designer to determine source and target connections and to determine the current cycle date.
• Configured UDO transformation to invoke DT service In Informatica Power Center.
• Used Industrial Best Practices (velocity) for Error handling.
• Utilize Maestros scheduler to schedule workflows and configured the session for Email notification.
• Fixed invalid Mappings and involved in preparing unit test cases for Data integrity and Consistency.
• Migrated codes from Development to Testing and from Testing to Production.

Environment: Informatica 9.0/8.6, Informatica Data Transformation, Advance Query Tool, OPAS DB2, ODS Mainframe DB2, Flat files, Quality Center 9.0, WS FTP, Windows XP, UNIX

Confidential, Worcester, MA Aug 09-Jan 10

Sr. ETL/Informatica Consultant
Confidential, is a leading regional provider of Property and Casualty insurance products for individuals, families and businesses. The Hanover offers a wide range of Property and Casualty products and services through an extensive network of Independent Agents.

Summary:
The Customer Service Center (CSC) implemented Salesforce in 2008 to provide their sales organization with a method to identify sales opportunities but customer related policy details are not integrated to Salesforce. This lack of integration makes it difficult for an Insurance Sales Professional (ISP) to clearly identify sales opportunities. It also restricts the Customer Service Representative to identify cross sell and up sell opportunities, and to manage sales campaigns. The objective of the project is to build the system which incorporates the agents, opportunity and dashboard data to Salesforce.

Responsibilities:

• Interact with the users of the existing system to understand the business requirements and types of reports being generated.
• Involved in the development of DEVPO documents for the ETL processes.
• Extensively used Informatica 8.6 to load agent's data from Lynx (DB2), Opportunity data from PMS (DB2) and dashboard data from Slapshot & BIDS (Oracle) to SQL Server Staging tables and from staging to Salesforce.com.
• Developed transformation logic and designed various Simple and Complex Mappings in Designer with accuracy and efficiency to achieve operational objectives.
• Used the Debugger in debugging some Critical Mappings to check the data flow from instance to instance.
• Used Mapping Parameter in designer to determine beginning timestamp for incrementally extracting data and to specify the load region for the mappings.
• Used SQL server transformation for balancing process and pipeline partitioning for mapping optimization.
• Used Industrial Best Practices (velocity) for Error handling.
• Utilize Maestros scheduler to schedule workflows and configured the session for Email notification.
• Fixed invalid Mappings and involved in preparing unit test cases for Data integrity and Consistency.
• Migrated codes from Development to Testing and from Testing to Production.
• Prepared the documentation of ETL processes to support knowledge transfer and assisted in end user training.

Environment: Informatica 8.6, Power Exchange (Salesforce.com), Apex Explorer, Lynx, BIDS, Slapshot, PMS, Apex Data Loader, Oracle 9i, DB2, Flat files, SQL Server 2005, Quality Center 9.0, Toad 9.1, Windows XP, UNIX

Confidential, Mason, OH Sep 08-Jul 09

Sr. ETL Consultant
Procter & Gamble Co. (P & G, NYSE:PG) is an American global corporation that manufactures a wide range of consumer goods.

Summary:
The main objective of the project is to design and develop the Argus Safety System based on the translated data coming from Salesforce.com (CRM Application), which provides the necessary health affect case details that will be used by the safety surveillance team in decision making. My role on the project was to convert the CR (consumer relation) data in SS (safety surveillance) data.

Responsibilities:

• Analyzed and documented existing ETL processes (PL/SQL code) and developed Data Mapping documents for migrating ETL process to Informatica.
• Involved in the development of both High level and Low level design documents for the ETL processes.
• Extensively used Informatica 8.6 to load OLTP data from Oracle and Flat files into Oracle target.
• Designed, developed and tested ETL processes to load Master data from Salesforce.com (comment and Product data) and load translated data from Salesforce.com (case, topic and task etc...).
• Involved in design and review of the Health Effect Section in Salesforce.com to ensure availability of all required data elements.
• Designed transformation logic based on requirements coming from production area and tracks the slowly changing dimension.
• Managed the Metadata associated with the ETL processes used to populate the data warehouse.
• Designed complex mappings involving target load order.
• Tuned the session to improve the performance by increasing the data cache size.
• Utilize Control M scheduler tool and pmcmd to schedule workflows.
• Fixed invalid Mappings, Unit testing of Informatica Sessions and Target data.
• Migrated codes from Development to Testing and from Testing to Production.

Environment: Informatica 8.6, Power Exchange (Salesforce.com), Apex Explorer, Oracle 10g, Flat files, PLSQL, Oracle Discoverer, Control M, Windows XP, UNIX

Confidential, Cary, NC Dec 07-Aug 08

ETL/Informatica Consultant
Confidential, is a professional services provider focused extensively on Data warehousing and Business Intelligence solutions.

Summary:
The main objective of the project is to design and develop the PLR (Personal Lines Retention) Analytical Tool, which provides the necessary policy characteristics that will be analyzed by the state managers in decision making. My role on the project was to interact with the business users for requirement gathering, understanding the CSI's business and develop the analytical tool.

Responsibilities:

• Analyzed the source data coming from different sources (Oracle, SQL Server 2005 and Flat Files) and working with business users and developers to develop the models.
• Used Erwin 4.x to design fact and dimension tables.
• Extensively used Informatica 8.1.0/7.1.3 to load OLTP data from Oracle, SQL Server and Flat files into Oracle target.
• Used the Repository Manager for user management.
• Developed and designed various simple and Complex Mappings Designer with performance, accuracy and efficiency to achieve operational objectives.
• Used Power Exchange CDC (Changed Data Captured) for oracle.
• Tuned the session to improve the performance by Pipeline Partitioning, increasing the data cache size and pushing the transformation logic to database.
• Set up sessions to schedule the loads at requested frequency.
• Extensively used SQL and PL/SQL scripts.
• Involved in preparing unit test cases, integration testing for Data integrity and Consistency.
• Assisted in Upgrading Informatica 7.1.3 to Informatica 8.1.0.
• Migrated codes from Development to Testing and from Testing to Production.
• Contributed in reports designing using Crystal Report.
• Provided End-user training and support.

Environment: Informatica 8.x/7.x, Power Exchange, Oracle 10g/9i, SQL Server 2005, Flat files, Erwin 4.x, PLSQL, Crystal Report, Windows XP, UNIX

Confidential, Mumbai, India Mar 07-Nov 07

Software Executive

Confidential, is India\'s second largest bank; while Fairfax Financial Holdings is a diversified financial corporate engaged in general insurance, reinsurance, insurance claims management and investment management.

Summary:

This is an Insurance Claims Processing System for ICICI Lombard, which keeps track of Claims raised against Insurance Policies like Motor Insurance. My role on the project was to design the UI application which captures the insurance (policies and claims) data.

Responsibilities:

• Met end users and business units to define business requirements and analyze system requirements.
• Involved in designing oracle/SQL server tables.
• Understood and analyzed the client's requirements and involved in GUI designing of the application.
• Worked along with Talisma for various section of business logic.
• Actively involved in Design and implementation of the motor claim requirements like Claim Intimation, Pre-ILA, ILA (Immediate Loss Advice), Assessment Calculator and Assessment Approval.
• Provided the online facility to renew the offline policy.
• Involved in writing stored procedures and SQL queries for use in different modules of the application.
• Migrated codes from Development to Testing and from Testing to Production.
• Deals with different aspect of the claim to the end.
• Contributed in reports designing using Crystal Report.
• Provided End-user training and support.

Environment: ASP.NET, C#.NET, .NET Framework 2.0, ADO.NET, XML, Oracle 8.0, SQL Server 2000, Windows XP, Crystal Report.

Confidential, Pune, India Dec 05-Feb 07

Software Engineer

Indian defense organization is one of the largest Asia's defense organizations. Summary: The main objective of the project was to build different modules for defense organization which keeps tracks of their incoming-outgoing emails, budget management system, person detail management system, tender management system and quality control system.

Responsibilities:

• Developed multi-tiered ASP.Net webapplications.
• Created ASP.Net web pages with HTML and JavaScript.
• Created SQL queries for Business class functions to access databases.
• Developed forms to view/store data toSQL Server 2000 database.
• Worked in team to develop different modules.
• Developed functional text and visual requirements based on client information.
• Implemented XML Web Services for accessing and consuming the applications data across the world using any platform.

Environment: ASP.NET, C#.NET, VB.NET, .NET Framework 1.1, ADO.NET, XML, Web Services, SQL Server 2000, Windows XP, Crystal Report.

Confidential, Mumbai, India Oct 05-Nov 05

Software Programmer
Accommodation Times is India's first and oldest fortnightly newspaper on Real Estate and Property. Accommodation Times with its wealth of experience in the Real Estate sector has accumulated over the years a plethora of information.

Summary:
This project aimed at designing their student management and real estate marketing web site.

Responsibilities:

• Understood and analyzed the client's requirements and involved in GUI designing of the application.
• Implemented the project using ASP.NET, VB.NET and back-end database as Microsoft SQL Server 2000.
• Performed validations on Web Forms using .NET Validation Controls and JavaScript.
• Migrating Access database to MS SQL server.

Environment: ASP.NET, VB.NET, SQL Server 2000, Ms Access, HTML

Course Projects

• Information Generator of Crude Oil Evaluation: Built the web application to handle the information of different crude oil and its products and generated reports according to organization requirement.
• Hospital Management: Built the system to manage records for patients, doctors and other employees. It also manages data about blood bank and wards available in the hospital.