Profile

• 8 Years of IT Experience
• 6 Years of DW Experience
• 3 Years of Business Intelligence Experience
• 3 Years of Data Analysis Experience
• 2 Years of Data Modeling Experience
• 8 Years of Database Experience

SUMMARY:

• SDLC: 8 years of total IT experience in the Planning, Analysis, Design, Implementation and Maintenance in different domains of Financial, Manufacturing, Insurance & Banking companies
• Data Warehousing: 6 years of strong Data Warehousing experience using Informatica Power Center 8.6/8.5./8.1.1/8.0/7.X/6.X/5.X/4.X (Source Analyzer, Data Warehousing Designer, Mapping Designer, Power plugs, Mapplets, Transformations), PowerMart 6.1/5.1.1/5.x/4.7, Informatica B2B, Warehouse Designer, Power Exchange, Power Analyzer, Power Connect, Power Plug.
• Data Analysis: 3 years of strong Business Analysis experience on Data Analysis, User Requirement Gathering, User Requirement Analysis, Gap Analysis, Data Cleansing, Data Transformations, Data Relationships, Source Systems Analysis and Reporting Analysis.
• Data Modeling: 2 years Highly Proficient in Data Modeling, Strong in Data Warehousing concepts, Dimensional, Star Schema and Snowflake Schema methodologies. Complete understanding of Ralph-Kimball and Inmon approaches to Data Warehousing.
• Business Intelligence: 3 years of BI experience in Business Objects 6.5/6.0/5.1/4.1 (Web-Intelligence 2.5, Designer 5.0, and Developer Suite & Set Analyzer 2.0), MicroStrategy, Cognos Series 7.0/6.0/5.x, Cognos Impromptu, Cognos IWR (Impromptu Web Reports) and Cognos PowerPlay Transformer.
• Experience working on Onshore-Offshore model.
• Strong experience in designing and developing MicroStrategy Reports, Schema objects, Application Objects, Configuration objects.
• Experience with reporting tool like Business Objects, BRIO. Understanding of complex report generation processes in BI tools.
• Data Bases: 8 years of experience using Oracle 10G/9i/8i/8.x/7.x, Teradata v12/v13, DB2 8.0/7.0, MS SQL Server 2008/2005/2000, IBM Informix 7.2, MS Access 7.0/2000, XML, PL/SQL, SQL*Plus, SQL*Loader and Developer 2000, Win 3.x/95/98/2000, Win NT 4.0 and Sun Solaris 2.x. Experienced in PL/SQL scripts and shell scripting. Strong Experience to databases SQL, PL/SQL, SQL*PLUS, SQL*Loader, DBMS Packages, TOAD & ODBC interfaces to Oracle.

EDUCATION:

• Bachelor of Engineering

TECHNICAL SKILLSET:

OLAP, OLTP, Star Schema, Snowflake Schema, RDBMS.

Programming Languages

C++, SQL Plus, PL/SQL, UNIX Shell Scripting, Mainframes Cobol

Scripting Languages

HTML, XML, UNIX Shell Scripting.

Databases

Oracle 11g/10g/9i/8i, Teradata v12/v13, MS SQL 2000, IBM DB2, MS Access.

Operating Systems

Windows 95/98/NT/2000/XP, UNIX, Linux, MS-Dos.

ETL Tools

Informatica Power Center 9.x/8.x/7.x/6.x / 5.x, Informatica Admin Console 9.x

Reporting Tools

MS Access Reports.

PROFESSIONAL EXPERIENCE:

Confidential, CA March’11 – Till Present 
Sr. ETL Informatica Developer 
Confidential is amongst the world’s leading financial services companies with operations in Consumer Banking, Commercial Banking, Global Corporate and Investment Banking and Asset Management.This project relates to the EPAOM (Enterprise preapproval Offers management) which deals with the offers/Referral data of bank customers. The project was to design, develop and maintain a data warehouse to understand the client needs and to provide better customer service and assess current and future profitability. This data is loaded as per the reporting requirements

Responsibilities:

• Involved in couple of projects and worked with Business Analysts and with the project team to understand the business requirements.
• Involved in project cycle plan for the data warehouse, source data analysis, data extraction process, transformation and loading strategy designing.
• Developed Informatica Mappings using Designer to extract, transform data according to the requirements and loaded into database from relational sources and non-relational sources.
• Extensively used different types of transformations like Sequence Generator, Expression, Filter, Router, Sorter, Rank, Aggregator, Look up, Update Strategy, Source Qualifier, Joiner, Normalizer.
• Expertise in Performance Tuning by identifying the bottlenecks at sources, targets, collected performance data for sessions and performance tuned by adjusting Informatica session parameters.
• Resolved bugs in the existing mappings by analyzing the code using debugger.
• Extensively usedTeradata utilities (BTEQ, Fast load, Multiload, TPUMP) to import/export and load the data from oracle, flat files.
• Involved in writing scripts for loading data to target data Warehouse using Bteq, Fast Load, MultiLoad.
• Developed Unix shell scripts “C shells and Perl “ and expert in using Unix utilities(sed, awk, vi, grep)
• Extensively Used Autosys tool for batch scheduling/monitor the Jobs.
• Working knowledge on mainframes, creating the JCLs, parms, datasets and loading the data by running jobs from override library.
• Hands on Experience in writing, testing, and implementation of the triggers, cursors, procedures, and functions at database level using PL/SQL.
• Develop complex Teradata SQL queries to generate ad-hoc reports for the reporting usersofBankofAmerica (BofA) to implement complex business rules.
• Involved in different environments of testing (SIT/UAT/PRODUCTION), trouble shooting of Informatica mappings and SQL queries and also involved in unit testing and developing test cases.
• Created and executed Unit Test Plans, test scripts for the project scenarios and raising defects in Quality Center.
• Experience working in Onshore-Offshore model. Managed offshore team through proper communication and coordination with them to ensure deliverables on time and reviewing the work done by offshore.
• Actively involved in Solution Architect (SA) activities such as attending meetings with business, Gathering / Understanding Business Requirements, foresee any challenges, and suggest alternatives for precise solutions, Documenting LLD and HLD.

Environment: Informatica Power Center 9.0.1/8.6.1, Informatica Power Exchange 8.x Teradata V12/ V13 , Oracle 10g, Toad, Mainframes, SQL, Autosys, UNIX Shell Scripting, Quality Center.

CONFIDENTIAL, Seattle May’09 – Feb’11
Senior ETL developer 

CONFIDENTIAL is the largest membership warehouse club in United States. It has high volume of sales from a single vendor. As part of the project I was mainly involved in Data ware housing using Informatica. The main project work is migrating data from Oracle to DB2. This project consists of multiple source systems spread across various platforms including Oracle, MS access on windows, etc. Migration from legacy systems to a new DB2 based retail data warehouse involved extraction, transformation and loading methodologies and data warehousing concepts.

Responsibilities:

• Managing ETL operations: Job-stream definition and management, parameters, scheduling, monitoring, communication and alerting.
• Developing governance for ETL audit, balance and control: Job-execution statistics, balancing and controls, rejects and error-handling, codes management.
• Designed scheme, sub-scheme for multiple IP platforms, into a single platform delivering data integration capabilities.
• Designing, implementing, managing ETL utility layer: common components supporting all other layers including Sales (Gas and Items)/forecasting capacity/performance requirements and building scalable foundational ETL infrastructure to allow for future growth.
• Involved in data analysis, data profiling.
• Managing and designing mappings with many dimension and fact tables as sources.
• Worked on Informatica Power Center tool to transform data from multiple sources including flat files, DB2.
• Tuning Informatica Mappings and Sessions for optimum performance.
• Performance tuning at session level by using commands which use DB2 Loader.
• Participate in project planning sessions with project managers, data analysts and team members to analyze business requirements and outline the proposed IT solution.
• Created complex mappings which involved Slowly Changing Dimensions.
• Involved in writing UNIX shell scripts for developing complex and high performance ETL solutions.
• Implementation of Business rules and capturing the deleted records in the source systems.
• Worked extensively with the connected lookup Transformations using dynamic cache.
• Worked with complex mappings having an average of 15 transformations.
• Extensively involved in Recovery process for capturing the incremental changes in the Source systems for updating in the staging area and data warehouse respectively.

Environment: Informatica Power Center 8.6, 8.1, Informatica Power Connect / Power Exchange, Oracle 10g, PL/SQL,UNIX Shell Script, Toad, SQL editor.

CONFIDENTIAL, New York Jun’07 – May’09 
Data warehouse developer

The primary objective of the project is to address the needs and requirements of Verizon’s Provisioning Domain necessitated by Verizon’s entry into the Long Distance Market.The Provisioning domain was explicitly responsible for pending, completed and cancelled orders apart from the responsibility to produce and file periodic performance reports with state and federal regulatory agencies.The reports demonstrate Verizon’s level of service to its wholesale customers and the level of service parity with the retail market or Verizon’s affiliates.

Responsibilities:

• Worked with source system experts to determine source of data.
• Source Data Analysis and table design using Erwin.
• Involved in designing the data model using ERWIN and generated the DDL for DBA to implement the tables in the development and production environment. Writing and optimizing SQL queries and Complex Data Modeling.
• Using Informatica Repository Manager maintained the repository, created users, user groups and security access control.
• Created and stored metadata in the repository using Informatica Repository Manager.
• Cleanse the source data, Extract and Transform data with business rules, and built re-usable mappings, using Informatica PowerCenter Designer.
• Created complex joiners, transformations of all types as needed to smoothly pass data through ETL maps.
• Using Informatica PowerCenter created mappings and mapplets defining the transformation logic according to the business rules for the loads.
• Test all the applications and transport the data to target Warehouse Oracle tables on NT server.
• Schedule and run Extraction and Load process and monitor sessions by using Informatica Server Manager.
• Check and Tune the performance of application for optimum system performance.
• Involved in Unit testing, system testing and partly in user acceptance testing.
• Involved in production support.
• Working knowledge on scheduling software.
• Creating BI reports using Business Objects Web and Business Objects Desktop.

Environment: Informatica Power Center 7.1/8.1, ERwin 3.5, Shell Scripts, SQL*Loader, Business Objects 6.5, UNIX, DB2, Oracle 9i, Windows NT

CONFIDENTIAL, Madison, Wisconsin May’06 – June‘07 
ETL-Informatica Developer 

CONFIDENTIAL is charged with designing and maintaining benefit plans that are responsive to the needs of school employees, that are compatible with the collective bargaining philosophy and dynamics, and that are faithful to the fiduciary relationship between the union and its members. The Trust is a not-for-profit corporation that is dedicated to helping public school employees find ways to address the health care cost crisis while providing them comprehensive health care at a reasonable price. The Wisconsin Education Association Council (WEAC) created the WEA Trust in 1970 to provide insurance andbenefit plans for public school employees and their families. The first offerings were health, life, and disability plans. 
Responsibilities:

• Involved in Dimensional Modeling of the data warehouse to design the business process
• Assisted the team in the development of design standards and codes for effective ETL procedure development and implementation
• Worked on Dimensional modeling to Design and Develop STAR Schemas and SNOWFLAKE Schemas, used ER-win 4.0, identifying Fact and Dimension Tables.
• Identified and tracked the slowly changing dimensions, heterogeneous Sources and determined the hierarchies in dimensions
• Worked closely with business analysts to understand and document business needs for decision support data.
• Involved in developing & testing of ETL, Informatica mappings, workflows, sessions using Informatica.
• Extensively utilized Informatica Power Center to load data from oracle and Fixed-Width, Delimited Flat files into Data Warehouse.
• Imported various heterogeneous and homogenous sources using Informatica 7.x source analyzer.
• Involved in working with ODS (Operational Data Store) to extract data from the Data warehouse.
• Involved in writing procedures, functions in PL/SQL.
• Designed sessions using Workflow Manager and monitored using Workflow Monitor
• Created & launched scheduled tasks/sessions. Configured email notification. Setting up tasks to schedule the loads at required frequency using Power Center.
• Automated Worklets and Session schedule using Unix Shell scripts.
• Monitored Sessions using the workflow monitor, which were scheduled, running, completed or failed. Debugged Mappings for failed sessions
• Designed Star Schemas and Bridge Tables to control slowly changing dimensions
• Involved in Unit testing of Mappings and Workflows.
• For better performance created partitions, and used SQL Override option in source qualifier
• Involved in extensive Performance Tuning by determining bottlenecks at various points like targets, sources, mappings and sessions.
• Used session partitions, dynamic cache memory and index caches for improving Performance of Informatica Server.

Environment: Informatica Power Center 7.1.2, Oracle 9i, DB2, Mocha Soft, Aqua Data 4.5, IBM iSeries Access, AIX Scripting.

INDOSOFT International, Hyderabad, INDIA Feb’04 – May‘06
Data Access and Management 
Oracle Developer

INDOSOFT International is a software consulting Services Company that specializes in various areas like IT services, Product Design services, Business Process Outsourcing etc. We developed MIS Package using Oracle Developer as software to maintain all the information starting from Raw material information to sales. This package consists of 5 Modules Inventory Management, Accounts, HRMS, Production and Sales Monitoring.

Responsibilities

• Involved in the design of the overall database using Entity Relationship diagrams.
• Wrote triggers, menus and stored procedures in PL/SQL.
• Involved in developing interactive forms and customization of screens using Forms4.5.
• Involved in data Loading and Extracting functions using SQL*Loader.
• Designed and developed all the tables, views for the system in Oracle.
• Designed and developing forms validation procedures for query and update of data.

Environment: Oracle 8.0, SQL*Plus, SQL*Loader, PL/SQL.