Summary:

• 8 years of IT experience in Data warehousing and Business Intelligence with emphasis on Business Requirements Analysis,Application Design, Development, testing, implementation and maintenance of Data Warehouse and Data Mart systems in the Financial, Banking, Manufacturing, Retail, Insurance, and Pharmaceutical industries.
• Excellent communication and interpersonal skills. Ability to work effectively in a team as well as individually.
• Involvement in all phases of SDLC (Systems Development Life Cycle) from analysis and planning to development and deployment.
• Around 6 years of development and design of ETL (Extract , Transform and Loading data) methodology for supporting data transformations and processing, in a corporate wide ETL Solution usingInformatica Power Center (8.x/7.x/6.x/5.x).
• 4+ years of experience in OLTP Modeling (2NF,3NF) and OLAP Dimensional modeling (Star and Snow Flake) using Erwin (conceptual, logical and physical data models).
• 1.5 Years of hands on experience in Upgrading Informatica 6 & 7 versions to Informatica 8.
• Strong Data cleansing experience using data cleansing functions like replacechr, replacestr, isdate in Informatica.
• Extensively worked on developing Informatica Mappings, Mapplets, Sessions, Worklets and Workflows for data loads.
• Experience in POWERCONNECT / POWEREXCHANGE to connect and import sources from external systems like SAP R/3, DB2, Salesforce, Mainframes, and AS/400.
• Experience in identifying and resolve ETL production root cause issues. Experience in maintenance, enhancements, performance tuning of ETL code.
• Knowledge of Informatica administration in windows and Linux environment
• Experience in Cognos 8/ 8.3/8.4 BI Suite (framework Manager, Cognos connection, Report Studio, analysis Studio and Query Studio)
• Skills in Report Development, Modeling (Relational, DMR), Dash Board Report in Cognos 8.
• Proven experience at building, motivating and leading professional teams, managing projects and supporting client relationships.
• Knowledge of tools such as Erwin and MS Visio Professional.
• Experienced with Multiple Databases including Oracle, Teradata, MS SQL Server and DB2.
• Sound Skills in structured query language (Oracle SQL) and PL/SQL.
• Very good Experience with Crystal Reports, Crystal Enterprise, Excel, and Access experience.
• Developed test case’s for business and user requirements to perform System / Integration / Performance testing.
• Continuously monitor the accuracy of the data and the content of the delivered reports.
• Provided off-hour and weekend production support on a rotational, on-call basis.
• Strong problem solving skills, ability to develop strategies for clients, and provide detailed documents to clients. Expertise in OLTP/OLAP/OOAD System Study, Analysis and E-R modeling, developing Database Schemas like Star Schema and Snowflake Schema used in relational, dimensional and multidimensional modeling.

ETL TOOLS:Informatica PowerCenter 8.X/7.1/6.2/5.1.2/1.5/1.7/, Informatica Power Center Connect, Informatica power Exchange/Power Connect, Datastage 7.5.3.

DATA MODELING:Erwin r7.3/4.x, Microsoft Visio.SQL*Plus, Toad, SQL*Loader, PL/SQL Developer, WinSql.

ORACLE TOOLS:SQL, PL/SQL Programming, C, C++, Perl.

REPORTING TOOLS:Cognos BI 8.x/7.x, MS OLAP, Business Objects.

OPERATING SYSTEMS: Windows XP/NT/2000 and MS-DOS

WEB :HTML, XML, FrontPage, Flash, and JAVASCRIPT

WEB SERVERS:IIS, Netscape Enterprise Server, IE

APPLICATION SERVERS:Apache Tomcat, Web sphere application server(WAS 6.0)

PROFESSIONAL EXPERIENCE:

Confidential, Emeryville, CA Oct 08 Till date
DWBI / Informatica Lead

Responsibilities:

• Interacted with business users and source system (OLTP) IT teams to define, agree and document incoming data mapping specifications.
• Involved in Designing, Developing & Testing.
• Created data modeling using ERWin for staging area as well as Promotion and Coupon analysis Data mart (Snowflake Schema).
• My roles also includes, leading onsite and offshore resources.
• Provided project estimations to client and upon agreement with client delivered project accordingly.
• Worked with Informatica Power Center to move data from multiple sources into a common target area such as Data Marts and Data Warehouse.
• Used different transformations to develop Mappings such as Joiner, Aggregator, Router, Expression, Normalizer, connected/ unconnected Lookups, Data Masking transformation and Update strategies.
• Used POWEREXCHANGE for SAP R/3 to connect and import source data.
• Extracted data by importing SAP R/3 [CRM, MM, SAP Industry Solutions (IS) - Retail] Sources and by using ABAP program.
• Wrote Teradata BTEQ, FLOAD, MLOAD, TPUMP and Fast Export scripts to import / export data.
• Migrated data from Oracle to Teradata by using BTEQ, FLOAD and MLOAD scripts.
• Designed mappings which identify duplicate customer records and de dupe / merge records based on business rules. Created customer master data management [MDM].
• Developing PL/SQL Packages, procedures, Functions, Triggers, Cursors as per the business requirements.
• Extensively used ETL to load data from wide range of sources such as flat files (CSV, fixed-width or delimited)
• Created OLTP source metadata reports using Informatica Data Explorer (IDE).
• Implemented Data Quality Address standardized mappings with Experian QAS data files.
• Created mapping to upload ADS (Alliance Data System) data into Staging Area and updated customer contact details ( address / phone ) based on ADS data
• Used the Data Masking transformation to change sensitive production data to realistic test data for non-production environments.
• Performance tune ETL mappings, Maintenance, enhancements and deployment of ETL code.
• Captured Oracle redo log files by using (Change Data Capture) CDC updated that in target side.
• Created several projects, packages and metadata models in Cognos Framework Manager.
• Created highly customized reports in Cognos 8 Report Studio and some of the Ad-hoc reports in Query Studio.
• Created coupon promotion analysis and best customer reports for each store and department wise, monthly / quarterly RFM reports.
• Performed QA and Code review for my code and other developer’s code.
• Experience in creating and writing Unix Shell Scripts.( Korn Shell Scripting - KSH)

Environment: Informatica 8.6.1, PowerExchange, IDQ, IDE, Cognos BI 8.3,ERwin Data Modeler r7.3, Oracle10g ,PL/SQL, XML,SQL Server 2005,DB2,SAP R/3, Teradata V2R6, AutoSys ,Toad 9.0.1.8, RHE Linux 4.0, Korn Shell Scripting(KSH).

Confidential,NewJersey Aug 07 Sep 08 DWBI / Informatica Lead

Responsibilities:

• Interacted with Business Analyst (Line of Business) to understand requirements and translated them into the appropriate technical solution.
• Created data modeling for staging area as well as Data warehouse (Star Schema) database.
• Extensively worked on developing Informatica Mappings, Mapplets, Sessions, Workflows and Worklets for data loads
• Extensively used ETL to load data from wide range of sources such as flat files (CSV, fixed-width or delimited)
• Performance tune ETL mappings, Maintenance and enhancements of ETL code.
• Responsibilities included Designing and Developing complex Informatica mappings including Type-II slowly changing dimensions.
• Taken part of Informatica administration. Migrated development mappings as well as hot fixes them in production environment.
• Identifies, researches, and resolves ETL root cause of production issues or system problems.
• Wrote numerous BTEQ scripts to run complex queries on the Teradata Database directly rather than implementing the same in Informatica, to reduce the time it takes for successful execution.
• Developed Teradata FLOAD and MLOAD for populating new and already existing Teradata tables
• Created packages using Microsoft Data Transformation Services (DTS/SSIS)
• Created several projects and packages in Framework Manager and worked with Framework Manager to create metadata models and published packages based on the security.
• Constructed Drill Through, Master-Detail and dashboard reports using parameterized filters in Report Studio.
• Validated report results with the source data and sanctioned the reports to production environment.
• Created Reports in Report studio comprising of list reports, cross-tab reports and chart reports, Maps, Repeater tables using underlying multiple query structure by using filters, calculations, complex expressions, conditional formatting, and prompts including cascading prompts.
• Carried out training sessions for users to learn how to execute Cognos reports in Cognos connection.
• Responsible for preparing test cases and technical unit testing for the developed reports.
• Responsible for to analyze and apply new requirements to existing reports.
• Continuously monitor the accuracy of the data and the content of the delivered reports.
• Involved in Onsite & Offshore coordination.
• Responsible for to provide production support and resolve issues.

Environment: Informatica 8.1.1, Cognos 8.x BI, Erwin 4.x, Oracle9i, PL/SQL, SQL Server 2005,SSIS, Teradata V2R5, Windows 2003, IBM AIX5.3, Korn Shell Scripting (KSH).

Confidential,Columbus, OH Oct 06 Aug 07
DWBI Informatica Developer

Responsibilities:

• As an ETL Lead, responsible to analyze functional requirement and up to implementation of project in production.
• Created technical design specifications for the provided functional requirements.
• Created data modeling for staging area as well as Data warehouse (Star Schema) database using Erwin.
• Extensively worked on developing Informatica Mapplets, Mappings, Sessions, Worklets and Workflows for data loads
• Extensively used ETL to load data from wide range of sources such as flat files (CSV, fixed-width or delimited)
• Responsibilities included Designing and Developing complex Informatica mappings including Type-II slowly changing dimensions.
• Identifies, researches, and resolves ETL root cause of production issues or system problems.
• Performance tune ETL programs, Maintenance and enhancements of ETL code.
• Migrated ETL project from Datastage7.0 to Informatica7.1.1
• Implemented OLAP Cubes using Cognos 8.2/7.3
• Created the reports like Slice and Dice, Drill Down, Cross Tab, Master Detail and Formulae etc
• Created the reports as per the requirement of user provided templates.
• Created Filters (Condition Objects) to improve the report generation.
• Created Hierarchies from providing drill down options for the end-user.

Environment: Informatica 7.1.1, Datastage7.0, ERWin 4.x, Flat Files, Oracle8i, Microsoft SQL Server 2000 as a data warehouse database, XML, Cognos 8.2/7.x, MS Analysis Services for OLAP Cubes, and Panorama Nova View V 4.5 for front end reporting, Windows NT 2000.

Confidential,Manson OH Mar 06 - Oct 06
Informatica Developer

Responsibilities:

• Responsible to analyze functional specification and prepared technical specification accordingly.
• Regular client communication for issue resolution over conference call, email, telephone
• Technical Unit Testing from Offshore as well as coordinating with on-site.
• Implemented logical and physical data modeling for ETL staging area using Erwin.
• Responsible for developing data extracts and transformation mappings using Informatica Powercenter6.2 & PowerConnect6.2.
• Taken part in ETL SAP Split Architecture.
• Accessing source data and addressing data quality in legacy sources applications
• Preparing and loading / migrating data into SAP and Supporting the data migration lifecycle
• Provided Go-Live support for Poland market implementation.
• Generated and Installed an ABAP Program using Power Connect to pull the data from SAP R/3. Populated incremental / delta data from SAP R/3 by connecting to CDHDR and CDPOS SAP tables.
• Responsible for developing EUR Region Market specific objects. (UK, Germany, France, Denmark, Sweden, Finland, Norway.)
• Co-ordination for raising Backup/Restore requests.
• Infrastructure related trouble shooting and follow-up with Infrastructure team if required.
• Taken care of to test DSNs provided by client using Easy Soft ODBC-ODBC Bridge for entire EUR Region. Remote ODBC access to databases when an ODBC driver is not available for client platform.
• Provided 24/7 on-call production support for Global ETL.

Environment: Informatica Power Centre (6.2), PowerConnect 6.2 for SAP R/3, SAP LSMW, AS400, Oracle, SQL Server, MS Access, Flat Files, Sybase and DB2 UDB as a staging and target database on UNIX operating system, IBM AIX5.1, Korn Shell Scripting.
Confidential,India Sep 03 Feb 06
DWBIDeveloper

Responsibilities:

• Responsible to Move database Schema changes to stage or production.
• Performed database tuning using SQL Profiler.
• Managed and resolved design issues during development stage. Worked closely with developers.
• Backup management in Production Environment.
• Responsible for developing all data extracts and transformation programs using Microsoft Data Transformation Services DTS, PL/SQL stored procedures, packages and functions.
• Heavily involved in the development methodology, database design, and data modeling.
• Implemented Full Text Search for Complete Database to search on Keywords or Phrases.

Environment: VB6.0, MS-SQL Server 2000 and Crystal reports7.0, Microsoft Search Solutions [Microsoft Index Server & Full Text Search], MS OLAP, MS SQL Data Transformation Services (DTS) Windows NT 4.0.

Confidential,India Jul 02 - Sep 03
SQL/DW Devloper

Responsibilities:

• Installation and configuration of SQL Server 2000 on Window 2000/NT OS.
• Implementing Backups and Restoring when necessary.
• Used BCP utility to publish table output to text files.
• Involved in creatingstored proceduresfor high system performance.
• Used SQL Profiler to monitor the server performance, debug T-SQL and slow running queries.
• Managing of users including creation/alteration, grant of system/db roles and permission on various database objects.
• Developed DTS Packages to transfer the data between SQL Server database and files.
• Assistance in Implementation.
• Used Designer to create source definitions, design targets, create mapping and develop transformations.
• Created different transformations for loading the data into DB2 database e.g. Source Qualifier, Joiner transformation, Update Strategy, Lookup transformation, Router Transformations, Expressions, Aggregator, Sequence Generator.
• Created and Monitored Workflows and Sessions using Informatica PowerCenter Server.
• Creation and management of Database Maintenance Plan for various database consistency checks.
• Extensively Developed SQL scripts for maintaining administration tasks.

Environment: SQL Server 2000, Enterprise Manager, Windows 2K, SQL Profiler, DTS, and BCP,Informatica.
Confidential,India May 01 Jun 02

• Jr SQL Developer

Responsibilities:

• Used SQL* LOADER to load data into table space.
• Connected to Remote Data Bases using Data Links and pulled required data.
• Designed and developed front-end application using CGI/C ++ programming. Insert, update and deletion were done using these forms.
• Handled Complex queries with TRANSLATE & DECODE.
• Granting access to different users for the system
• Modifying the profiles of different users
• Development and report generation.
• Involved in writing different stored procedures, triggers in PL/SQL as per functionality

Environment: Oracle 7x, PL/SQL, SQL*PLUS, SQL*LOADER, SQL Scripts, Developer 2000, Windows.