Summary:

• Ten Plus (10+) years of Software Life Cycle experience in System Analysis, Design, Development, Implementation, and Testing in various domains like Insurance, Banking, and Pharmaceutical
• Nine Plus (9+) years of solid ETL (Extract Transform Load) data integration and Data Warehouse experience using Informatica Power Center 8.6.1/8.1/8.0/7.1.4/7.1.3/7.1.2/7.1.1/ 7.0/6.2/6.1/5x, Repository Admin Console, Repository Manager, Designer, Work Flow Manager, Work Flow Monitor, Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet Designer, Mapping Designer, Workflow Designer, Task Developer, Worklet Designer, Gant Chart, Task View
• Solid experience in Data Warehousing Concepts like Ralph Kimball Methodology, Bill Inmon Methodology, OLAP, OLTP, Star Schema, Snow Flake Schema, Fact Table, Dimension Table, Logical Data Modeling, Physical Modeling, Dimension Data Modeling using Erwin 4.2/4.0/3.5.5/3.5.2, Microsoft Visio
• Ten Plus (10+) year’s experience in Relational Databases like Oracle 10g/9i/8i/7.x, MS SQL Server 2000/7.0/6.5, Sybase SQL Server 12.0/11.x, Teradata V2R5/V2R4, DB2 UDB 8.0/7.0/6.0, MS Access 7.0/2000, IMS Data, SQL, PL/SQL, SQL*Plus, Sun Solaris, Linux, UNIX, Stored Procedures, Functions, Oracle Performance Tuning, Indexes, Functions, and Packages, and VLDB
• Involved in the Re-designing of the Data warehouse from the scratch in all SDLC phases
• Experience in Toad and Visual Source Safe version Control
• Experience in UNIX shell scripting for Informatica Job scheduling, posts-sessions, file archiving and other tasks
• Involved in multiple Informatica projects corporate-wide
• Extensively worked on production support issues and resolved them using session logs, workflow logs, and used e-mail task for capturing issues via e-mail along with the session logs
• Exceptional problem solving skills
• Excellent Interpersonal Skills with the ability to work independently and with the Team

Education & Certifications:

• B.S in Computer Science
• Post Graduate Diploma in Computer Applications

Technical Skills:

Data warehousing: ETL Informatica PowerCenter 8.6.1/8.1/8.0/7.1.4/7.1.3/7.1.2/7.1.1/7.0/6.1.2/6.1.1/5x, Repository Manager, Designer, Work Flow Manager, Work Flow Monitor, Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet Designer, Mapping Designer, Workflow Designer, Task Developer, Worklet Designer, Gant Chart, Task View, Ralph Kimball Methodology, Bill Inmon Methodology, Star Schema, Snowflake Schema, Data Warehouse, Data Mart, FACT tables, and Dimension tables.
Databases: Oracle 11g/10g/9i/8i/7.x, T-SQL, MS SQL Server 2000/7.0/6.5, Sybase SQL Server 12.0/11.x, Teradata V2R5/V2R4, MS Access 7.0/2000, IMS Data, SQL, PL/SQL, SAP
Job Scheduling : BMC Control M, Informatica Scheduler
Environment : UNIX (Sun Solaris, HP, Linux 6), Windows 2003/2000/XP/98,Others Microsoft Word, Microsoft Excel, Outlook

Professional Experience:

Confidential, Cedar Rapids, IA July 2004 to Till date
Sr. Programmer Analyst / ETL Lead
Confidential Americas includes the U.S., Canadian, and Mexican operations of Confidential N.V., one of the world\'s leading life insurance organizations. 
The Confidential Americas companies offer a wide range of competitive and innovative products to numerous markets through a highly diversified distribution system. The diversity in what we offer and how we offer it allows us to serve a variety of customers and leverage our capabilities as the marketplace changes. 
Project Description: Exists TWO Data warehouses (EDW/NDW), Initially EDW designed for ONE source system in PL/SQL by Oracle in later stages added up to 14 sources systems to support the Investment Division Reporting processes. Gradually EDW became slow and decided to Re-design the NDW (New Data Warehouse) from the Scratch and completed Phase-1 of the project.
Responsibilities:

• Responsible for Requirement Gathering Analysis and End user Meetings
• Responsible for Business Requirement Documents BRD\'s and converting Functional Requirements into Technical Specifications
• Create High level Design Document from Business Requirement
• Create Detail Design Document from High Level Design Document
• Performed cleansing, standardization, data quality checking
• Creating staging designs and analyzing source data
• Extraction of existing logic from the Current data warehouse
• Worked on the latest releases features like UDF’s
• experienced in best practices design of ETL implementations in a high volume environment
• Involved in Change-Data-Capture (CDC) Process using informatica’s MD5 function
• Created complex mappings to handle the Data Quality check
• Responsible for mentoring Developers and Code Review of Mappings developed by other developers
• XML solid understanding and development
• Defining, designing and implementing approaches to perform initial loads and ongoing updates of the database systems.
• Identifying, designing and developing process improvements.
• Transforming and loading data according to the business specifications.
• Coding and unit testing modules.
• Creating ODS and Data Marts.
• Executing system, integration and regression tests.
• collaborate with other teams during system and integration testing phases to ensure proper functioning as part of the larger system.
• Performing enhancements and bug fixes as required.
• Documentation of all activities like high level design, detail design, test cases, release document
• ability to work under changing dynamics and under tight deadlines to handle multiple projects
• extensive used shell scripts to call workflows, archive files, command tasks into order to implement Pre and Post cleanup processes
• Extracted data from various heterogeneous sources like Oracle, SQL Server, and Flat Files
• Extensively used various active and passive transformations like Filter Transformation, Router Transformation, Expression Transformation, Source Qualifier Transformation, Joiner Transformation, and Look up Transformation, Update Strategy Transformation, Sequence Generator Transformation, Rank Transformation, and Aggregator Transformation
• Proficient in Purging old data, Monitoring and improving applications and Database Performance.
• Responsible for best practices like naming conventions, Performance tuning, and Error Handling
• Responsible for Performance Tuning at the Source level, Target level, Mapping Level and Session Level
• Responsible for best practices like naming conventions, Performance tuning, and Error Handling
• troubleshoot problems by checking sessions and error logs and used debugger for complex problem troubleshooting.
• Implemented best practices of ETL
• Solid Expertise in using both Connected and Un connected Lookup transformations
• Extensively worked with various lookup caches like Static Cache, Dynamic Cache, and Persistent Cache
• Worked closely with business analysts to understand and document business needs for decision support data.
• Developed Re usable Transformations, Re-Usable Mapplets, Re-usable Lookups
• Worked with Shortcuts across Shared and Non Shared Folders
• Developed Slowly Changing Dimension Mappings for Type 1 SCD and Type 2 SCD
• Responsible for implementing Incremental Loading mappings using Mapping Variables and Parameter Files
• Responsible for determining the bottlenecks and fixing the bottlenecks with performance tuning
• Used Update Strategy DD_INSERT, DD_DELETE, DD_UPDATE, AND DD_REJECT to insert, delete, update and reject the items based on the requirement
• Worked with Session Logs, and Workflow Logs for Error handling and Troubleshooting in all environment
• Responsible for Production Support and Issue Resolutions using Session Logs, and Workflow Logs

Environment: 
Informatica PowerCenter 8.6.1 (Repository Manager, Designer, Workflow Manager and Workflow Monitor, Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet Designer, Mapping Designer, Workflow Designer, Task Developer), Oracle 10g, SQL Server 2008, SQL, PL/SQL, Enterprise Control M Scheduler, Multi-Edit, Flatfiles, Autosys, Unix, Microsoft Visio, VSS

Confidential, New York Feb 2003 – May 2004
Informatica Developer
The scope of the project was to integrate financial data coming from different sources into one Citi Data Warehouse. The scope also included creating Business Objects Reports for performance evaluation of the organization.
Responsibilities:

• Worked closely with business analysts to understand and document business needs for decision support data.
• Performed extensive analysis of metadata to test the integrity, consistency and appropriateness of the data to be brought into the centralized Citi Data from various sources.
• Prepared business mappings requirements.
• Imported various heterogeneous and homogenous sources using Informatica PowerCenter 6.0 Source Analyzer.
• Developed various transformations using the Transformation Developer in the Informatica PowerCenter 6.0 Designer.
• Used Aggregate transformations when group by clause is necessary.
• Created various mappings to facilitate the loads from Mainframe to the dimensions using Informatica PowerCenter 6.0 mapping designer.
• Designed sessions using Workflow Manager and monitored using Workflow Monitor.
• Datamodelling using Erwin.
• Designed and developed mappings using new features of Informatica 6.2 that include Sorter Transformation and executed tasks (sessions) using Workflow Manager, Workflow Monitor.
• Created and Maintained Universes using Business Objects Designer.
• Developed various reports in Business Objects that have drill down capabilities.
• Used Business Objects free hand SQL to generate Adhoc reports.
• Created Cardinalities, Contexts, Joins and Aliases for resolving Loops and checked the Integrity of the Universes.
• Knowledge of Webi SDK model and implementation.
• Created Add-Ins and Macro’s based on the end users requirement using VBA.
• Worked on Excel spreadsheets and MS Access
• Generated web reports using Web Intelligence to popup in Java Server pages.
• Scheduled the process using Broadcast agent and supervisor Activities.
• Helped in maintenance work related to reports.
• Used of Filters and Conditions.

Environment:
Informatica PowerCenter6.x, Business Objects 6.0, Web-Intelligence 6.0, Broadcast Agent 6.0, Supervisor 6.0, Designer 6.0, Info View 6.0, SQL SERVER 2000, Oracle 8i/9i, XML, V2R3,ERWin 4.1, Windows NT, UNIX-SOLARIS
Confidential, Memphis, TN Mar 2002 – Dec 2002
Developer
Confidential is a global leader in providing integrated communications and embedded electronic solutions.The primary Objective of project was to create an integrated Enterprise Data Warehouse to facilitate the analysis of cost and revenue data for products manufactured and sold by Confidential that is useful to generate robust and standardized reports to coordinate their various sources of information for better decision-making. The data warehouse which is being implemented is flexible enough to accommodate future changes such as inclusion of manufacturing and overhead costs at product level. 
As a Consultant the following were my contributions:

• Involved in Installation & Configuration of Informatica Server and Client Tools.
• Extracted data from sources like Oracle database, Flat Files and XML files.
• Imported and Created Source Definitions using Source Analyzer.
• Imported and Created Target Definitions using Warehouse Designer.
• Created Mappings using Mapping Designer to load the data from various sources, using different transformations like Aggregator, Expression, Filter, Joiner, Lookup, Router, Sequence Generator, Source Qualifier, and Update Strategy transformations.
• Created Mapping Parameters and Variables.
• Handled operating system tasks by generating Pre and Post-Session using Shell Scripting
• Created and Scheduled Sessions and Batch Process based on demand using Informatica Server Manager.
• Used pmcmd command to schedule sessions and batches and to recover the sessions.
• Involved in installing the Business Objects, creating Repository, creating Users and User Groups using supervisor models.
• Responsible for requirements gathering and writing specifications
• Involved in designing, developing & testing the universe for report generation.
• Created reports for various portfolios using universe as the main data provider.
• Created & tested reports using Business Objects functionality like Queries, Slice and Dice, Drill down, @Functions, Formulae etc.
• Created graphical representation of reports such as Bar charts, Pie charts etc as per the End user requirements.
• Exporting the reports to Broadcast Agent Server, which is used to Schedule and Monitor the reports.
• End User community Training in basic and advanced reporting.
• In-charge of allocating work/modules to co-developers
• Testing of Universe and Reports, which includes Database connectivity.
• Tested objects in the universe, to ensure the correct mapping of the objects.
• Tested resolved loops and contexts to ensure the correct results from the query.
• Tested the universe structure to ensure the tables are properly updated along with the database.
• Tested the aggregate awareness to ensure the query is pulling correct level of aggregation.

Environment: Oracle 8.1.6, Informatica Power Center 5.1, Business Objects 5.1, ERwin 4.0, SQL, PL/SQL, SQL*Loader, Shell Scripting, HP-UNIX, Windows NT/2000, MS-Access

Confidential, Milwaukee, WI Feb 2001 – May 2001
Business Objects Consultant
Confidential is a Financial Billing Application for Insurance Carriers. There is a comprehensive reporting module as well as patient collection module. The application also has a recall module and an appointment-scheduling module that handles different specialty groups. To accommodate data in their clinical database, define and create reports to specific and complex user needs. The adhoc report generation has more complex queries in it.
Responsibilities:

• Created complex Reports, Sub Reports and Drill through Reports used to show details from the Cubes Create shell script to manipulate Oracle data .
• Created Oracle views to improve the performance of the reports. These views were then imported to the catalog.
• Installation of Business Objects.
• Designed universe for reporting.
• Fitting Business Objects into the company Information Architecture.
• Supported Business Users and Developed new and Maintained the exsisting Universes.
• Created Multi Dimensional Reports(Full Client Reports) as per Client Requirements.
• Used to create Repository and User Profiles to different groups by using Repository Manager.
• Exported the Universe to the Repository to make resources available to the Users
• Formatted the Reports to the Users requirements using all the requirements in Business Objects like Slice and Dice, Drill Down, @Functions and Formulas etc.
• Designed and developed extensive Business Objects reports, including complex reports using multiple queries, combination chart and tables, will setup Business Objects Universe for each reporting group Assist in establishing a Business Objects environment.
• Data Mining with Business Miner.
• Publishing complex reports on WebI
• Extensively used WebI.

Environment: Business objects 4.0, WebIntelligence 2.5, SQL Server v7.0,  Unix, Oracle 8i, Windows NT Server v4.0