PROFESSIONAL SUMMARY:

• Ninteen years of experience in IT industry involving in analysis, designing, developing, testing, supporting, implementation of various client/server, web based and data warehousing applications in Financial, Manufacturing, Insurance, Educational, Heath Care verticals and Marking.
• Eleven plus years of experience as a Data Warehouse consultant using Informatica - PowerMart and Power Center, good understanding of Data Warehouse architecture and life cycle.
• Well versed with Data warehousing concepts using Kimball’s principles or methodology- Dimensional modeling, slowly changing dimensions (type1, type2, and type3), surrogate keys, star schema and snowflake schema in implementing DSS (Decision Support Systems.)
• Solid understanding of Extraction, Transformation and Loading (ETL) process and usage of ETL tools
• Knowledge of various techniques for Performance Tuning involved with sources, targets, mappings and sessions.
• Highly proficient in Development, Implementation, Administration and Support of ETL processes for Large-scale Data warehouses using Informatica PowerCenter and PowerMart.
• Designed and developed efficient Error handling methods and implemented throughout the mappings in various projects.
• Experience in writing Server Side Programming with PL/SQL (Stored Procedures, Stored Functions), UNIX (Korn) Shell Scripting
• Experience in using Business Objects tools (Supervisor, Designer, Business Objects) for Online Analytical Processing (OLAP) Reporting.
• Experience with Other Utilities: TOAD, SQL*Loader, Export/Import

TECHNICAL SKILLS:

ETL Tools: Informatica Power Center v 8.x/7.x / 5.0 & PowerMart v 6.2 / 5.0

Databases: Oracle 10g/9i/8i/7x, MS SQL Server, DB2 and MS Access

Data Modeling: Star-Schema Modeling, Snowflakes Modeling, Dimension Tables, FACT, and Erwin

Operating Systems: Windows 95/ 98/NT/2000, XP, Linux, UNIX

Languages: C, Java, Visual Basic, ASP, VB/JavaScript, SQL, PL/SQL, HTML, DHTML, XML

Tools: and Servers Toad, SQL * Loader, FTP, SQL * Plus

PROFESSIONAL EXPERIENCE:

Confidential, CA

Informatica Sr ETL Consultant

Responsibilities:

• Managing and Monitoring production data loads to ensure data have been loaded into the warehouse properly and the data is ready for reporting.
• Analyzing business requirements and preparing technical documentation and application process and writing test cases.
• Worked on Designing and Creating tables for new setup database, writing sub routines as per the business requirement.
• Analyzing and evaluating data sources fields to match the target fields for moving the data from denormalized legacy system to normalized New Setup database. Developed mappings to load the date form different sources like oracle, flat files
• Gather and clarify requirements directly from the users and PM, developing new informatica process for automating various new ETL activities, generating XML files for partners and reading XML files for reconciliation.
• Used wide variety of transformations which includes Mid stream transformations like HTTP and XML parser, used to make API calls based on different product BIZZID’s to extract all payment plans and Standing Order Configuration data defined in OMX and load them into newly created tables in SETUP database
• Writing UNIX scripts to ftp files, cleaning the data, other required functionalities and place them in the proper source/target directories for processing.
• Enhancement of existing complex ETL processes to support additional design, development and deployment of new and enhanced ETL processes to production and support new load strategy.
• Involved in unit testing, process teating and preparing migration documents.
• Improving the SQL query performance, and updating the technical documents.

Environment: Informatica Power Center v 9.5.1, Oracle 11g, SQL Server 2012 Cognos Reporting, XML Files, CSV Files, Excel files, SQL, PL/SQL, Unix Shell scripting, Windows XP, Toad, Microsoft Visio.

Confidential, NC

Informatica ETL Consultant

Responsibilities:

• Worked on extraction and loading .HDF (Hierarchal data format) files into Oracle tables using Informatica.
• Automated the scripts for converting HDF files into ASCII file formats using DOS utilities to identify the structure and metadata.
• Wrote Perl script to ftp files and place them in the proper source directories for processing, SQL scripts for new reporting schema and modifying the subprograms.
• Extracted and loaded the CO, ozone, and PM design values from excel files into Access database and from Access to Oracle.
• Modified mappings and sessions as per new business requirements and developed workflows to support new load strategy.
• Improved the SQL query performance, and updating the technical documents.

Environment: Informatica Power Center v 7.1.4, Oracle 9i/10g, .HDF files, Excel files, SQL, PL/SQL, Perl scripting, Win 2003 server, Windows XP and, SQL Developer and Toad

Confidential, Monterey CA

Informatica ETL Consultant

Responsibilities:

• Participating, understanding and reviewing the functional requirements which, we get from different states with the Business Analyst and signing off the requirement document.
• Prepared technical design document as per the functional specification and unit test cases.
• Developed and tested Informatica mappings based on the specification.
• Used various transformations to extract data from different formatted files and relational source system.
• Developed reusable transformations and mapplets to offset redundant coding and reduced development time and improving loading performance both at mapping and at session level.
• Created tables in staging to reduce code change in mapping to handle dynamic field positions in the source data files and generating flat file with UDF values in customer defined positions.
• Designed and developed ETL strategy for the Workflows and set dependencies between the workflows.
• Created SQL scripts for configuring staging and OAS environment and parameter files per customer and wrote PL/SQL stored procedures to manipulate the data.
• Created UNIX shell scripts for archiving source files and splitting the file based on the district.
• Analyzed long running SQL's and tuned them.
• Migrated Informatica mappings, sessions and workflows from development environment to QA, CQA and production environments and checking the developed code into CVS for release managements.
• Prepared and maintained all phases of support documents like operation manual, application flows, white board for mappings, workflows and documentation to describe mapping specifications
• Transferred knowledge to outsource team prior to my project completion.

Environment: Informatica Power Center v 8.1, Oracle 9i/10g, Flat Files, SQL, PL/SQL, SQL/Shell scripting, UNIX, Windows XP, SQL * Loader, Toad, Microsoft Visio

Confidential, LA

Informatica ETL Consultant

Responsibilities:

• Analyzed the source fields to match the target fields, creation of source transformations for files and developed mappings to load the date form different sources like oracle, Vsam, flat files
• Developed different mappings like creating dynamic parameter file, master & child loading and reusable Transformations as per the Business requirements to facilitate initial and incremental loads.
• Wrote generic function to capture max value for the key column in every table to generate sequence number by using stored procedure transformation in mapping.
• Performed unit and integration testing after loading the data into target system
• Improved the performance of mappings by moving the filter transformations early into the transformation pipeline, performing the filtering at Source Qualifier for relational databases and by session partition
• Integrated the mappings and session, created workflows and setting dependencies between the sessions.
• Prepared technical specification documents for all the mappings developed

Environment: Informatica Power Center v 7.1.3, Oracle 10g, Cobol Files, Flat Files, SQL, PL/SQL,SQL/Shell scripts, Toad, UNIX, Windows XP

Confidential, CT

Informatica ETL Consultant

Responsibilities:

• Solely responsible in finding ETL bugs for the whole process from stage to hub, hub to Mart and consolidation error recycle process.
• Given write up for bugs found which includes bug description, cause for the bug, resolution to fix the bug and testing scenarios
• Fixed invalid Mappings, Developing new mappings according to Functional specification to extract data from stage to Xref and Helper tables.
• Migrated Informatica mappings from development environment to Pfix and QA

Environment: Informatica Power Center v 7.1.3, Db2 UDB, Sybase, SQL, Toad, UNIX, Win XP

Confidential, IL

Informatica ETL Consultant

Responsibilities:

• Reviewed the functional specification document and prepared technical specification document.
• Developed new mappings and making changes to the existing mappings according to Functional specification and changing requirements to extract data from different sources like Oracle Applications modules, Oracle, DB2, and flat files and loaded them into Oracle database.
• Involved in fixing invalid Mappings, Unit and Integration Testing of Informatica mappings and sessions matching with the client’s scenarios.
• Used various Transformations to handle business rules and functionalities depending upon the requirement
• Created Mapplets with the help of Mapplet Designer and used those Mapplets in the Mappings. Developing reusable transformations to use them across all the mappings.
• Wrote stored procedures and used stored procedure transformations during pre and post target load.
• Versioned mappings in the Development Environment to keep track of the changes in the mappings.
• Integrated all the mappings and session, created workflows using different tasks in the main folder and setting dependencies between the workflows.
• Monitored data loads to ensure data has been loaded into the warehouse properly and the data is ready for reporting.
• Wrote dynamic parameter files to reduce maintenance, fixing existing parameter files, created files to maintain environment variables and wrote scripts files which uses environment variables to run the workflows
• Designed and maintained the operations support document like application flows, white board for mappings, Session & batch and written documentation to describe mapping specifications
• Migrated Informatica mappings, sessions and workflows from development environment to beta and production.

Environment: Informatica Power Center 6.2, Unix, Windows XP, Business Objects v5, Oracle 9i, Flat Files, SQL, Pl/SQL, SQL/Shell Scripts, DB2 UDB, TOAD, SQL * Loader, Microsoft Visio, UNIX

Confidential, VA

Informatica ETL Consultant

Responsibilities:

• Interviewed key stakeholders and business domain experts to identify functional requirements, define tasks and co-ordinate efforts for timely delivery.
• Involved in preparing Data Flow Diagrams.
• Identified preliminary data issues with source systems and resolved the same after holding several discussions with source system teams and business users
• Developed Mapping for flat file, relational sources and integrating other data sources, performing transformations and mapping sources to targets using Informatica (Source Analyzer, Transformation Developer, Warehouse Designer, and Mapping Designer).
• Developed tasks, sessions and workflows for the ETL processes.
• Developed reusable transformations and mapplets in the designer using transformation developer and mapplet designer tools.
• Identified performance bottlenecks and eliminate them through tuning of SQL, PowerMart mappings and sessions
• Involved in fixing invalid Mappings, testing of Stored Procedures and Functions, Unit and Integration Testing of Informatica mappings and sessions.
• Write Unix Shell Scripts for automating the ETL procedures and calling these scripts through cron jobs.
• Created PL/SQL scripts for validating data load jobs, data constraints, scripts to fix data bugs.
• Wrote the Technical Documentation and User Manual
• Involved in Creating Universe in the Designer and making connection with the Oracle Database.
• Created adhoc Reports with Formatting and standard templates, using sorts, Calculations, breaks, and ranking to data and Opening, modifying, saving and sharing existing reports.
• Manipulating data through various presentation styles such as; charts, cross tabs

Environment: Informatica PowerMart 6.2, Oracle 8i, SQL, PL/SQL, Shell scripts, SQL*Loader, windows 2000 server, UNIX

Confidential

Programmer Analyst

Responsibilities:

• Involved in designing database and analyzing the process of application development
• Designed and coding interactive User Screens for both client/Server application and Web site.
• Wrote Sql queries, Stored procedures to ensure the efficient performance of database
• Generated Reports as per the requirement of client by using Seagate Crystal Reports
• Involved in Package and deploying the application
• Given training to End User to use the software effectively

Environment: VB 6.0, Oracle 7x, ASP, VB & Java Script,SQL, Crystal Reports, Ms Word, Install Shied

Confidential

Analyst Programmer

Responsibilities:

• Written database triggers, which do not allow change without proper authorizations in transactions like material return from plant goods issue, goods receipt physical inventory once saved.
• Designed and developed user screens for populating the data into the master and transaction tables, look up and history tables constantly from the source systems.
• Used various components to handle business rules and functionalities depending upon the requirement
• Developed ActiveX components with the help of Designer and used those reusable components in various internal coding.
• Wrote stored procedures using PL/SQL to perform database operations on post-session and pre-session commands.
• Actively participated in Unit testing of the mappings matching with the client’s scenarios.
• Designed and maintained the operations support document for all these Session & batch
• Processes run and monitor session & batch

Environment: VB 6.0, Ms Access, oracle 8i, UNIX (Sun Solaris) SQL, SQL*Loader, SQL, PL/SQL, Windows NT

Confidential

Sr. Software Programmer

Responsibilities:

• Created indent processing screens and master screens (item rate, WPP, vender etc)
• Coding Active X DLLs for querying, manipulating Database.
• SQL Views and stored procedures were created
• Used ADO technology for database access Involved in error handling.
• Utilized Active X controls to provide additional functionality
• Generated key Reports Indent Status Report (ISR), Indent Execution Time Report (IET),
• Allocation Of Pending Items and others Using Crystal Reports

Environment: VB 6.0, Oracle7 x, Windows NT, Crystal Reports 6.5

Confidential

Sr. Software Programmer

Responsibilities:

• Involved in designing database and developed the following interfaces. Employee Information, 2. Employee Advances & Deductions, 3. P.F. Accounting, 4. Payroll Generation, 5. Head of Accounts, 6. Receipts, 7. Payments
• Wrote stored procedures for manipulating database
• Implemented the whole business logic as VB Components
• Generated of Daily Bank and Cash Statements and other reports as per the user requirement using crystal reports.Trained end user to use the software effectively.

Environment: VB 5.0, MS Access 7.0, Windows 98, Crystal Reports 6.5

Confidential

Software Programmer

Responsibilities:

• Involved in full life cycle of projects.
• Developed Active X components for code reusability
• Writing stored procedures and other SQL statements.
• Designed and Developed most of the user interface screens end.
• Wrote procedures and functions to updated to the SQL Sever tables Only the information, which is required by globally.
• Printer object is used for printing bills and Investigation reports such as blood tests, radiographic reports etc.,
• Generated reports using Crystal reports and Excel reports by using VBA according to User group's requirement.
• Bundled all the components for distributable package and deploying.
• Installed the software at client place.
• Trained end user to use the software effectively

Environment: Visual Basic 5.0, VBA, SQL Server 6.5, MS-Access, Active X and Crystal Reports, Windows NT.4.0.

Confidential

Software Programmer

Responsibilities:

• Involved in designing database and developing Key user interfaces
• Designing User interfaces using MDI and standard forms
• Coding Data base access using Ado’s
• Package and Deploying.
• Developed reports using crystal reports 4.5.

Environment: VB 5.0, MS-Access 7.0, Crystal Reports 6.5 and MGI photo suite

Confidential

Software Programmer

Responsibilities:

• Involved in designing database and coding interactive pages in ASP using Java script for client validation, VBScript for Server, validation
• Wrote stored procedures for database manipulation. Written code for above screens using Java Script. Created interfaces for data entry (preparing question by expert lecturer's)
• Created components in visual basic and deployed in Mts
• Generated Reports as per the requirement using crystal reports writer

Environment: ASP 2.0, VB 5.0,Crystal reports 6.x, Visual Interdev6.0, MS-SQL Server 7,IIS, VBScript, JavaScript, HTML