PROFESSIONAL SUMMARY:

• 9 years of overall IT experience.
• Over 8 years of strong data warehousing, ETL and OLAP experience using Informatica Power mart and Power Center 4.7/5.0/6.2/7.1.2/8.1.1 (Source Analyzer, Data Warehousing Designer, Mapping Designer, Mapplet, Transformations), Business Objects, Oracle 10g/9i/8i/8.0/7.x, MS SQL Server 6.5/7.0/2000/2005, MS Access 7.0/’97/2000, and MS Excel.
• Knowledge in Data Profiling to strengthen overall data quality and implementation of Server Grid for Load Balancing.
• Performance Monitoring and Tuning.
• Problem Analysis and Support.
• Exposure to diverse database technologies from flat file DB to RDBMS.
• Experience in all aspects of the System Development Life Cycle.
• Outstanding engineer capable of improving all aspects of development lifecycle to include coding, testing, debugging, and final rollout.
• Experience working with On-site/Offshore model.
• Worked with Clarify (CRM) with special concentration on Clear Support, Clear Contracts and Clear Call Center, Clarify Customizations using DD Editor and UI Editor and Clear Basic.
• Experience in client-server application development experience using Visual Basic.
• Excellent communication skills and ability to learn new things and be highly motivated.
• Participation in Teamwork and managing as a Onsite Team Lead
• Ability to learn and adopt new technologies quickly
• Ability to work under stringent deadlines with teams as well as independently

EDUCATION: Bachelor of Science

Operating Systems : Windows XP/2000/9x/NT, UNIX, Linux.
Languages : Visual Basic, Clear Basic, ASP, PL/SQL, T-SQL.
Database : Oracle – 8.x/9i/10g, SQL Server 6.5/7.0/2000/2005, UDB DB2 8.0,
Sybase.
Data Modeling Tool : Erwin, ER Studio
CRM Tools : Clarify 7.0/8.0
DWH Tools : Informatica-Power mart/Power Center 5.1/6.2/7.x/8.1.1, Business
Objects 5.1/6/Xi, Cognos, Oracle Discoverer.
Tools : IBM Rational Portfolio Manager (Project Management),
Manage Now (Problem Management & Change Management),
ERequester (track build activities and the effort estimates).

SIGNIFICANT PROJECTS:

Client : Confidential,Union City, CA.
Duration : March 2007 to till date,
Role : Sr.Informatica Developer.
Environment: Informatica Power Center8.6, Informatica MDM, Informatica Powerexchange8.x, Oracle10g, UDB-DB2, SAS, IBMs-AIX, UnixShellScripting, TOAD, ERWIN, Autosys, MS Access.

Description :

Confidential,specializes in offering brand name computers, software and peripherals at discounted wholesale prices.For more than a decade A & M Computers is serving to PC enthusiasts, system integrators, business organizations, government agencies, non-profit organizations and educational institutions for all their computer purchasing and support services
requirements.

Responsibilities:

• Involved in the full life cycle development of the project including: design, development, and testing.
• Involved in gathering business user requirements, understanding the business model (E-R Diagrams), database table and query design, extracts and use of report query tools and Identify technical risks, assumptions, and dependencies.
• Documented user requirements, translated requirements into system solutions and develop implementation plan and schedule.
• Worked with SAS technology for Enterprise Data Integration, Data access engines & Data Quality Management.
• Extracted data from multiple sources such as DB2, Oracle, XMS, and Flat Files & MS Access and loaded the transformed data into targets in Oracle, Flat Files.
• Worked extensively on Mapping Designer to design and create mappings, transformations to implement transformation logic.
• Used Surrogate keys in the Data Ware house tables to manage the Slowly Changing Dimensions (SCD) properly and easily.
• Involved in matching data across multiple data sources, merged duplicate records, inserted linkages and relationships IDs & created master record using IDQ.
• Used SAS Data integration to combine and analyze huge quantities of data to make discoveries, solve complex problems , deploy accurate results and information throughout the enterprise.
• Worked with ODI to leverage optimizations for Oracle Database to perform EL-T data movement, transformation, data quality and standardization operations.
• Developed complex mappings with Custom Transformations, Web Services Consumer, XML Sources, Application Source and Multi User Sources.
• Worked with T-SQL for Control-of-flow language ,Local variables ,Various support functions for string processing, data processing, mathematics, bulk insert & changes to DELETE and UPDATE statements.
• Tuned DB & DBM configuration parameters and DB2 registry variables for better memory utilization .
• Worked with Informatica Master Data Management for Data Migration, Data Quality Management & Data Synchronization.
• Created Sessions and Workflows to carryout the ETL process, configured sessions and connection parameters.
• Used stored procedures for truncating the tables and deleting the rows from error logs.
• Worked with Informatica Data Explorer for data profiling and Informatica Data Quality tools.
• Used Power Exchange to import source definitions and to extract data from DB2 UDB sources.
• Developed reusable transformations and mapplets, which were used in other operations.
• Worked with Variables and Parameters in the mappings to pass the values between sessions
• Created debugging sessions before the session to validate the transformations and also used existing mappings in debug mode extensively for error identification by creating break points and monitoring the debug monitor.
• Managed ODBC connections.
• Worked on software engineering/SDLC tools, particularly Microsoft Team Foundation Server (TFS), to document and track work items from initial request through production deployment.
• Conducted performance tuning on sessions by optimizing block size, data cache size, sequence buffer length and commit interval.
• Used UNIX Shell Scripting to automate the loading process.
• Developed Unit test cases and Unit test plans to check data is correctly loading.

Client : Confidential,Minneapolis, MN.
Duration : April 2006 to February 2007.
Role : Sr. Informatica Developer
Environment : Informatica Power Center 8.1.1, Informatica Power Exchange 5.x,Oracle 9i, SQL,PL/SQL,UDB DB2, ODI,OLTP,Toad, Mercury Test Director8.0,HP-UNIX, Citrix.

Description :

Centerpiece project is a Global SAP implementation and is meant to manage business for Medtronic client at its locations spread across the world viz. North America ( USA & Canada, Mexico, Latin America), Europe, Japan, Asia Pacific (Australia and New Zealand) etc. It is a multi generation, multi location complex project and is one of the flagship SAP Accounts for IBM in health care and life science industry.

Responsibilities:

• Worked on Informatica – Source Analyzer, Data warehousing designer, Mapping Designer, Mapplet designer and Transformations.
• Implemented Joiner, Expression, Aggregator, Sorter, Rank, Lookup, Update Strategy, Filter, stored procedures, Normalizer Transformation and Router Transformations.
• Responsible for managing scope, planning, tracking, change control, aspects of the Informatica Objects.
• Review and Monitor progress.
• Used the Power Center 7.1.2, Designer’s debugger to test and fix bugs in the mappings.
• Generated Reusable Transformations, Mapplets and used them extensively in many mappings.
• Worked with Variables and Parameters in the mappings to pass the values between sessions.
• Involved in Migration of project from Development to test and then to Production environment.
• Created and Monitored Sessions using Informatica Power Center Server to load data in to the Target Database.
• Involved in Informatica GRID configuration & Data Modeling (ERD process).
• Worked on Informatica developments and enhancements by creating new mappings and making changes to the existing mappings as per the business requirements.
• Extensively used ETL to load data from flat files to Oracle 9i and flat files.
• Worked on converting PL/SQL loads to Informatica loads.
• Conducted performance tuning on sessions by optimizing block size, data cache size, sequence buffer length and commit interval.
• Mercury Test Director is used for assigning and tracking the Change Requests (CR’s) and Test Problem reports (TPR’s).
• Responsible for Running the Build.

Client : Confidential,Orange, CA.
Duration : May 2005 – March 2006
Role : Informatica Consultant
Environment: Informatica PowerCenter7.1/6.2, Oracle 8i/9i, SQL, PL/SQL, Business Objects5.1,HP-Unix, WindowsNT 4.0, Rational Rose, Clear Case, PVCS.

Description:

Confidential,is a leading mortgage company. Several of the applications use Informatica for their reporting and data mart needs. All these teams use a centralized production environment. Involved in Design, Development and Implementation of Enterprise Data Warehouse and extensively worked with distributed databases to extract data into staging area.

Responsibilities:

• Participated in build of the Data Warehouse which includes the Design of Data mart using Star Schema.
• Integrated various sources in to the Staging area in Data warehouse to Integrating and Cleansing data.
• Extensively involved in successfully upgrading from Informatica 6.2 to 7.1.2.
• Involved in Analysis/Design/Development and Implementation and successfully completed all the work involved in converting the company’s Operational data Store from SQL to Oracle database and deployed the systems in Production, with full Production Support.
• Interacted with business analysts to identify and develop business requirements and transform it into technical requirements and ultimately responsible for delivering the solution.
• Extensively used Change Data Capture (CDC) approach efficiently to capture only the changes.
• Responsible for creating and effectively executing deployment plan to move all the objects, tables, mappings, workflows, SQL scripts and created new jobs and their dependencies in Production
• Involved in Control-M Implementation, Extensively used the scheduling tool Control M to schedule jobs and their dependencies in production.
• Completely involved and alert during Nightly Process Monitor, Easily Solved variety of issues during Production Support, ensuring smooth completion of data loading process.
• Worked with DBA to fine tune complex SQL’s, do regular Run-Stats on the tables, drop and re-create indexes to decrease run times of various Informatica mappings which process large volume of data.
• Extensively worked in planning the Metadata strategy and responsible for maintaining of the Metadata in the Enterprise Data Warehouse (EDW).
• Involved in working with the Data Modeler in Data Modeling.

Client : Confidential,Ann Arbor, MI.
Duration : March 2004 to April 2005.
Role : Informatica Consultant
Environment: Informatica PowerCenter 7.1.1, Business Objects 5.1, Oracle 9i, UDB DB2 8.1, Toad, UNIX, Citrix, eRequester and Rational Portfolio Manager (RPM).

Description :
Confidential,is a global leader in collecting, organizing and publishing value-added information to researchers, faculty, and students in libraries, government, universities, and schools in over 160 countries. ProQuest serves academic, public, corporate, and K-12 libraries, in addition to K-12 classrooms and higher education students and faculty.
ProQuest has signed an outsourcing agreement with IBM Global Services (IBM) for Application Development / Maintenance (AD/M) services.
Responsibilities:

• Worked on Informatica – Source Analyzer, Data warehousing designer, Mapping Designer, Mapplet designer and Transformations.
• Worked on Informatica developments and enhancements by creating new mappings and making changes to the existing mappings as per the business requirements.
• Worked on converting PL/SQL loads to Informatica loads.
• Involved in development of various data migrations projects using Informatica like Siebel sales release (extracted and transformed data as per business rules from third party system ‘CALLBACK’ and loaded into Siebel tables), MDR database lease (extracted and transformed data as per business rules from third party leased flat files and loaded into Oracle tables to be used by Business Objects for reports).
• Developed ETL DASH BOARD, which is used to track all the daily and monthly load statistics.
• Developed email routines to indicate failure or successful completion of workflows.
• Involved in Migration of project from Development to Production environment.
• Used Repository Manager to create folders, which is used to organize and store all Metadata.
• Created mappings to migrate data from Flat files, DB2, Sybase, Oracle, and MS Access to data warehouse.
• Implemented Joiner, Expression, Aggregator, Sorter, Rank, Lookup, Update Strategy, Filter, stored procedures, Normalizer Transformation and Router Transformations.
• Worked on building Universes and universe modification using Business Objects on Oracle as database.
• Resolved loops by creating aliases and contexts.
• Created Measure Objects, Conditions and Functions as per the User requirements.
• Developed Business Objects reports.
• Involved in preparation of design documents, technical documents and Unit test documents.
• Involved in Application migration phases (Application Specific Migration Phase, Guided and Assisted perform phase and parallel perform phase).
• During Migration prepared various documents like Application specification Plan document, Application information document, Application support control plan and parallel perform completion report document.
• Provided estimates and schedule inputs for service request (both Project service requests and Blanket service requests).
• Responsible for creating all service requests in eRequester application which is used to track build activities and the effort estimates.
• Responsible in creating all the tasks created in eRequester application back in Rational Portfolio Manager (RPM) application which is used for tracking effort tracking, resources allocation and as document repository.
• Be on on-call support for problem tickets which are assigned through Remedy system.
• Assign tasks against Service Requests/Problem Tickets/User Queries to the team members.
• Establish the cause of problem and try to resolve at Onsite.
• Be the primary contact for customer/end-user queries.
• Support release/rollout activities in acceptance and production environments.
• Participate in review of requirements and high-level design with client.
• Review and Monitor progress.
• Ensure compliance with Software Development Life Cycle (SDLC).

Client : Confidential,Madison, WI.
Duration : January 2003 – February 2004
Role : Informatica Consultant.
Environment : Informatica Power Center 6.1, Business Objects 5.0/6.1 , Oracle 8i, MS SQL Server 7.0, PL/SQL, Windows NT, Erwin, UNIX Shell Scripting.

Description:

Confidential,is multi-specialty integrated healthcare delivery system based in Madison, Wisconsin, which provides Medical and Health services, Health Insurance, Ancillary health services and Clinical Research through a network of Dean-owned clinics throughout southern Wisconsin.

Responsibilities:

• Business Analysis and Requirements Gathering.
• Involved in logical and physical data modeling.
• Analysis and Design of ETL processes.
• Extensively used Business Objects for BI reports.
• Created and managed Universes.
• Extraction, Transformation and Loading of the data Using Informatica Power Center’s Designer and Server Manager.
• Worked on Informatica tools –Source Analyzer, Warehouse designer, Mapping Designer and Transformation Developer.
• Involved in the development of Informatica mappings and also tuned them for better performance.
• Different sessions were run in the Server Manager and the log was studied to modify the mappings to obtain correct result from the transformation.
• Used ETL to load data from source to Oracle database.
• Worked on Data Conversion and Data Analysis. Stored data in the Data Warehouse about Claims, Customers, and Accounts.

Client : Confidential,Minneapolis, MN.
Duration : October 2001 to December 2002.
Role : Informatica Consultant
Environment : Informatica Power Center 4.7/6.0, Oracle 7.x/8.0, Windows NT and UNIX.

Description :

Confidential, is The Broadband Company. ADC\'s network equipment, software, and systems integration services make broadband communications a reality worldwide by enabling communications service providers to deliver high-speed Internet, data, video, and voice services to consumers and businesses.

Responsibilities:

• Worked using various Informatica designer tools like Source Analyzer, Data warehousing designer, Mapping Designer & Mapplet, and Transformations.
• Extensively involved in data Extraction, Transformation and loading (ETL Process) from source to target using Informatica.
• Extracted order entry data, product and revenue data from Flat files, Oracle using Informatica.
• Involved in creation of cubes and dimensions.
• Developed aggregate, join, look up transformation rules (business rules) to generate consolidated (fact/summary) data identified by dimensions using Informatica tool.
• Involved in deployment of Type 2 dimensions to keep track of historical data.
• Informatica populates the data warehouse on daily basis using Extraction, Transformation and loading methods. The ETL job was run on daily basis to feed data to Data warehouse.