Professional Summary

• Having 8 years of IT experience which includes over 6 years of experience in Data warehousing using Informatica Power Center/Power Mart 8.5/8.1/7.1.4/6.2/6.1
• Having extensive experience in using Informatica for data extraction, transformation and loading (ETL) along with an extensive experience in database analysis for data warehouses with strong understanding of Dimensional Modeling, Star and Snowflake Schemas
• Proficient in using Erwin 4.0/3.5 tool for creating physical and logical data models
• Experience in generating reports using BI tool like Cognos 8.X/7.0/6.6
• Highly experienced in integrating Heterogeneous data sources like Oracle, SQL Server, DB2 and Flat Files
• Strong experience in programming using SQL, SQL*Plus, PL/SQL Procedures and Functions
• Proficient in UNIX Shell Scripting for File Validations and Job Scheduling
• Profound Knowledge of System Development Life Cycle (SDLC)
• Good written and communication skills and an excellent team player

Technical Skill Set
Data Warehousing: Informatica Power Center 9.0.1/8.5/7.1.4/6.2 (Designer, Workflow Manager, Repository Manager), Informatica Power Mart, Power Connect, Power Exchange, Datamart, Metadata, OLAP, OLTP
Business Intelligence : Cognos 8.0/7.0/6.6 (Report Studio, Query Studio, Impromptu, Transformer, Power Play Reports, IWR, PPWR), Business Objects 6.5/5.x (Supervisor, Designer, Reporter) 
Databases: Oracle 10g/9i/8i/7.x, Sybase 12/11/10, Netezza, MS SQL Server 6.5/7.0/2000/2005, Teradata V2R4, DB2 UDB 8.0/7.x/6.x, MS Access ’97/2000
Tools: Erwin 4.0/3.5, SQL*Plus, SQL*Loader, SQL Server Analysis Manager, Control-M, Autosys, Developer 2000 (Forms 4.5/5.0, Reports 2.5/3.0),Facets, TOAD, UML, RUP, JUnit, Dbunit DBArtisan, Clear Case, Clear quest MS Access Reports, MS Visio 10.0
Programming: SQL, PL/SQL, Transact SQL, Visual Basic 6.0/5.0, ASP, C, C++, UNIX Shell Scripting
Operating Systems: Sun Solaris 2.6/2.7/2.8, HP-UX, IBM AIX 5.3, MS DOS 6.22, Windows 95/98/2000/2003/XP, Windows NT 4.0
Others: HTML 4.0, DHTML, ASP 3.0/2.0, JavaScript, JSP, CGI, PERL, MS Excel, MS Office

Education
Bachelor of Engineering in Computer Science

Professional Experience

Confidential, Ashburn, VA Jul ’10 – Apr‘12
Informatica Developer
Project: Risk Analysis

Risk Analysis provides a system for Confidential\'s Office of Research and Analysis to generate reports for distribution to field inspectors. These reports provide potential areas for accounting irregularities at the issuer level which become the focus of the field inspections.

Responsibilities:

• Interface with users to capture and analyze business needs and user’s strategic information requirements
• Performed source data assessment, validation and identified the quality and consistency of the source data
• Created mapping specifications based on the analysis of source data, user requirements and business rules
• Created Several Informatica Mappings to populate the data into dimensions and Fact tables
• Created mapping variables and parameters to perform the incremental loading of data
• Created various transformations such as Aggregator, Update strategy, Router, Source Qualifier, Filter, Expression, Look-up, Sequence Generator and Joiner
• Created several mappings that involve Type - II slowly changing dimension (SCD) techniques
• Extracted and transformed data from Fixed-Width, Delimited flat files and Oracle. Loaded staging tables using Informatica
• Involved in scheduling sessions and workflows to load the data.
• Created Unit, Accuracy and Integration testing documents also extensively involved in Performance tuning at various levels.

Environment: Informatica 9.0.1/8.5, Oracle 10g/9i, MS SQL Server 2005, COBOL, SQL, PL/SQL, Shell scripts, TOAD, IBM AIX 5.3

Confidential, Skokie, IL Jan ’09 – May ‘10
Sr. ETL Consultant
Project: Diabetes Data mart

Confidential is a hospital-based, nonprofit organization that offers home care services and medical services. Their integrated delivery system includes Evanston, Glenbrook and Highland ParkHospitals as well as theConfidential Home Services, Confidential Medical Group, and theConfidential Foundation. The purpose of this data warehouse is to provide the Medical group users with reports consisting of Diabetes component values, specialties, physicians, locations and patient’s data. The reports also include the charges and transactions of medical benefits.

Responsibilities:

• Involved in Analysis, Requirements gathering and documenting technical specifications
• Worked on Informatica Power Center using various kinds of transformations to implement simple and complex business logics
• Actively involved in using heterogeneous Source data from Oracle and SQL server.
• Extensively used Source Qualifier transformation to filter data at the source level rather than at transformation level
• Transformations used are Connected & Unconnected Lookups, Router, Expression, Aggregator, Filter, Sequence Generator, Joiner etc
• Resolved Loops by creating table aliases and contexts
• Created the sessions and batches and monitored them using Informatica Server Manager
• Extensively involved in performance tuning at source, target, mapping and session levels
• Prepared the external pre and post session processes for the Informatica Power Center, using Unix Shell Scripting
• Involved in preparing detailed Business Analysis documents, Data Mining, ETL design documents and unit test plans for the mappings

Environment: Informatica 7.1.4, Cognos 8.0 MR2, Oracle 10g/9i, MS SQL Server 2005, COBOL, SQL, PL/SQL, Shell scripts, TOAD

Confidential., Branchville, NJ Jul ’08 – Dec ‘08
Data warehouse Developer
Project: Knowledge Management Data mart

Confidential is one of the largest property and casualty (P&C) companies in the U.S., providing a broad range of insurance and alternative risk management products and services. The Knowledge Management (KM) project primarily focuses on building a datamart that provides porting capability at operational and managerial levels. The data is extracted from the KM Data Warehouse and loaded into the KM Data Mart. 

Responsibilities:

• Interacted with users to capture and analyze business needs requirements
• Worked extensively on Informatica Designer to create and manipulate source and target definitions, mappings, mapplets and transformations
• Created mapping specifications and documents based on the mapping logic and business rules
• Created several mappings to load dimension and fact tables
• Worked with various transformations such as Source Qualifier, Aggregator, Update strategy, Filter, Router, Expression, Look-up, Sequence Generator and Joiner
• Implemented slowly changing dimensions techniques while developing the mappings
• Created Informatica mappings along with PL/SQL Procedures/Functions to build business rules to load data
• Extracted and transformed data from MS SQL Server, Fixed-Width and Delimited Flat Files
• Involved in creating and scheduling the sessions and workflows to load the data into target tables
• Created Unit, Acceptance and Integration testing documents and test cases
• Extensively involved in tuning the performance at various levels and worked on data Profiling and Partitioning using Informatica Power Center 7.1.1
• Coordinated the reporting team in creating Catalogs, IQDs and generating the reports like Simple list reports, Group list reports and Cross tab reports using Cognos Impromptu tool

Environment: Informatica 7.1.1/8.1, Cognos 7.x series, MS SQL Server 2000, SQL, PL/SQL, TOAD, RUP, Windows XP

Confidential, Harrisburg, PA Nov ’07 – May ’08
Informatica Consultant
Project: CCMIS Reporting Data mart

Confidential project mainly consists of childcare funds, Subsidies, Claims amounts generated from different vendors and the state of Pennsylvania. Confidential Reporting Data mart project is focused on extracting data from different data sources like Oracle, Sybase and loading it into the data mart for the purpose of generating and analyzing the business and user reports.

Responsibilities:

• The project source data is extracted from all the CCMIS operational systems and loaded into the data warehouse, which is the union of all the constituent pieces of the business
• Involved in the design and development of the data acquisition process for the data warehouse including the initial load and subsequent refreshes
• Worked on Informatica Power Center 7.1 and used Source Analyzer and Warehouse Designer to import the source and target schemas, also used the Mapping Designer to map the sources to the targets
• Participated in the review and approval of the technical transformations and requirements document. Used technical transformation document to design and build the extraction, transformation and loading (ETL) modules
• Worked with various transformations including Aggregator, Expression, Filter, Router, Union, Source Qualifier, Joiner, Look Up and Stored Procedure to incorporate the business rules into the mappings
• Developed complex Informatica mappings and also tuned them for optimal performance
• Tuned the cache of various transformations and calculated the useful cache size for better performance and optimal usage of cache
• Created mapping variables and parameters to perform the incremental loading of data
• Extensively used Informatica Power Center to load data from Flat Files and Oracle database into Target databases
• Created the sessions and workflows and monitored them using Informatica Workflow Manager and Workflow Monitor
• Worked on Unix Scripts for Scheduling batch jobs
• Performed Unit and Integration Testing
• Involved in generating and validating the reports using Cognos Impromptu tool

Environment: Informatica Power Center 7.1/6.2, Oracle 9i, Sybase 12.0, DBArtisan, Cognos 7.0, SQL, TOAD, PL/SQL, AutoSys, UML, Sun Solaris 2.8 UNIX, Windows XP

Confidential, Minneapolis, MN Jan ’07 – Nov‘07
Programmer Analyst
Project: Banking Data Warehouse (BDW)

The project involved in the maintenance of Decision Support System for Confidential by means of integrating data from disparate feed systems, situated across different locations, into a repository of meaningful business information. The Banking Data Warehouse (BDW) system for Confidential is designed to handle the increasing data volumes generated by the bank\'s growing, active client base while improving customer service levels. The BDW Solution provides quick access to data to enable a more informative decision making process. BDW helps people do their jobs more effectively and efficiently. Data is accessible and flexible and presented in a usable format, allowing more time for analysis
Responsibilities:

• Involved in System Study, Business Requirements Analysis and Documentation
• Involved in designing Data mart using star schema techniques and Dimensional Data Modeling using ERWIN
• Worked on Informatica– Source Analyzer, Warehouse designer, Mapping designer & Mapplet designer, and Transformation developer
• Created Informatica mappings with procedures to build business rules to load data
• Most of the transformations used include Source qualifier, Aggregators, Connected & unconnected lookups, Filter and Sequence generator
• Created UNIX shell scripts for scheduling the sessions
• Created the batches to run several sessions sequentially and concurrently
• Involved in tuning the sessions and mappings
• Involved in design and development catalogs for reports generation
• Involved in different Team review meetings
• Extensively performed Unit Testing and System Testing

Environment: Informatica Power Center 6.0/5.1 (Repository Manager, Server Manager, Designer), Cognos 7.0 (Impromptu Administrator, Power Play Transformer, Power Play, Upfront), Oracle 9i/8i, DB2, PL/SQL, Junit, DBUnit, UNIX, Windows NT

Confidential Jun ‘05 - Nov ‘06 
Software Engineer
Confidential provides a gamut of services to globally reputed Travel and Transportation organisations.In this project I was involved in analyzing the database model and designing the application for Customer Relationship Management (CRM) Intranet site.
Responsibilities:

• Worked on Reservations and GDS system development and maintenance project
• Designed Web reporting subsystem
• Participated in Inventory and Pricing system enhancements
• Controlled Customer data warehouse and Reservation systems
• Supported essential application programming
• Participated in design/management of SQL/Oracle databases
• Estimated performance and performed tuning operations

Environment: Windows NT 4.0, Oracle 8.x/7.x, MS SQL Server 6.5/6.0, JavaScript, Visual Basic 5.x, Power Builder 2.x, HTML, Forms 3.0/4.0.