SUMMARY

• I have 7+ years of IT experience focusing on Data warehousing, Data modeling, Data integration, Data Migration, ETL process and Business Intelligence.
• Package Software: Expertise in Siebel CRM technologies and extensively used Siebel Work Flow, Business Service, Siebel Application Configuration, EIM and EAI. Expertise in Informatica ETL and reporting tools. Deep understanding of the Data Warehousing SDLC and architecture of ETL, reporting and BI tools.
• Drawing on Experience in all aspects of analytics/data warehousing solutions (Database issues, Data modeling, Data mapping, ETL Development, metadata management, data migration and reporting solutions ) I have been key in delivering innovative database /data warehousing solutions to the Retail, Media, Insurance, Energy, Telecom, Pharma and Finance Industries.
• Strong understanding of Data Modeling (Relational, dimensional, Star and Snowflake Schema), Data analysis, implementations of Data warehousing using Windows and UNIX.
• SDLC: 5 years of IT experience in system analysis, design, coding and testing. Extensive experience in the Data Warehousing implementations, Data Migration and ETL for Retail, Product Development, Energy, Finance and Pharma Domain.
• Databases: 7 years of experience using Oracle 10g/9i/8i/8.0/7.0, DB 2 8.0/7.0/6.0, MS SQL Server 2000/ 2005, MS Access 7.0/2000, SQL, PL/SQL, SQL*Plus, SQL*Loader.
• Database Development and Analysis: 6 years of experience in Database Development using mainly Oracle database. Experience with Data Cleansing, Data Profiling and Data analysis. UNIX Shell Scripting, SQL and PL/SQL coding.
• Database / ETL Performance Tuning: Broad Experience in Database Development including effective use of Database objects, SQL Trace, Explain Plan, Different types of Optimizers, Hints, Indexes, Table Partitions, Sub Partitions, Materialized Views, Global Temporary tables, Autonomous Transitions, Bulk Binds, Capabilities of using Oracle Built - in Functions. Performance Tuning of Informatica Mapping and workflow.
• Data Modeling: 5 years of Dimensional Data Modeling experience using Erwin 4.5/4.0/3.5.5/3.5.2 and Ralph Kimball Approach, Star/Snowflake Modeling, Data marts, OLAP, FACT & Dimensions tables, Physical & Logical data modeling, and Data Modeling Tools Visio.
• ETL: 6 years of Data Warehousing experience using Informatica PowerCenter 9.1/8.1/7.1.1/7.0/6.2/5.1.1/4.7, Power Mart 6.2/5.x/4.7, Power Connect for SAP/Siebel/DB2, Power Exchange, Power Analyzer, Power Plug, Data mart, IMS Rx Data (Plantrak, Xponent Plantrak).
• Business Intelligence: 2 years of Business Intelligence experience using Crystal Reports XI/6.x, Developer 2000 (Forms 6i/8i, Reports 6i/8i), Business Object 6.5. And working knowledge of Siebel Analytics and done with Cognos 8.4 training.
• Superior communication skills, strong decision making and organizational skills along with outstanding analytical and problem solving skills to undertake challenging jobs. Able to work well independently and also in a team by helping to troubleshoot technology and business related problems.

TECHNICAL SKILLS

ETL: Informatica PowerCenter 8.1/7.1/7.0/6.2/5.1, Power Mart 6.2/5.1/4.7 PowerConnect, Power Analyzer, ETL, Data Mining, Data mart, OLAP, OLTP, IMS Rx Data, Clinical Data understanding.

CRM: Siebel 8.0 ( ePharma)

Data Cleansing: Trillium 7.6/6.x (Converter, Parser, Matcher & Geocoder

BI & Reporting: Business Objects 6.5 Crystal Reports xi/6.x, working knowledge of Cognos Series 7.0, Impromptu, Cognos Power Play, and Cognos ReportNet 1.1. and SQL Server SSRS

Data Modeling: Erwin 4.5/4.0/3.5/3.0, Logical Modeling, Physical Modeling, Relational Modeling, ER Diagrams, Dimensional Data Modeling (Star Schema Modeling, Snowflake Schema Modeling, FACT and Dimensions Tables), Entities, Attributes, Cardinality, MS Visio

Databases: Oracle 10g/9i/8i/7.x, MS SQL Server 2000/2005, SQL Navigator, SQL*Loader, MS Access

Others: C, XML, Java, Unix Shell Scripting, SQL, PL/SQL, Transact SQL, SQL*Plus, HTML, DHTML, ODBC, TOAD.

Environment: UNIX, Windows 2003/2000/XP/98.

PROFESSIONAL EXPERIENCE

Confidential, NJ

Sr. ETL Developer / Lead

Responsibilities:

• Responsible for Data Quality Efforts and Automation of the ETL process using Informatica PowerCenter 9x.
• Extensive use of Informatica development using Lookup, Normalizer, Stored Procedure, Filter, Expression, Aggregator, router, joiner transformation.
• In the role of ETL face for the client and resolve the ETL issues/ concern from different teams like Architecture Review Board ( ARB ), Data Modeling, BI, Business Users, Techno Functional Users etc.
• Extensive work on performance tuning of Informatica ETL and Database Code.
• Implement the long term solution and use the best practices of Information
• Working with Business partners to get requirement and ad-voc queries and convert those into technical programs and present using BI tool.
• Responsible for creating Cleansing/ Massaging profile on raw data and present in the form of Micro strategy BI reports.
• Responsible for implementing Best Practices and act as a member of Architecture Review Board ( ARB ), Peer to Peer Technical review meetings.
• Responsible for Performance tunings and documentation for ETL and point of contact for any ETL efforts done or to be done.

Environment: Informatica Power Center 9.1, Power Connect, Informatica IDQ, Flat files, XML Files Oracle 9i/10g, Erwin, Sybase, Natezza, MS SQL Server 2005/2000, PL/SQL,Toad, Unix, PVCS.

Confidential

Technology Lead \ Senior ETL Consultant & Analyst \ Data Modeler

Responsibilities:

• Working with business users and business analyst for requirements gathering and business analysis.
• Converted business requirement into high level and low level design.
• Work and manage development team in the design and build phase.
• Done Interface table mapping and ER diagram to populate the x-reference tables.
• Designing and customizing data models for Data warehouse supporting data from multiple sources on real time.
• Worked extensively with complex mappings using expressions, aggregators, filters and Update strategy.
• Used Normalizer transformation with COBOL sources stored in DB2.
• Created reusable mapplets and Transformations starting concurrent batch process in server and did backup, recovery and tuning of sessions.
• Created sequential batches and concurrent batches for sessions.
• Worked on Informatica Power Center tool - Source Analyzer, Data Warehousing designer, Mapping & Mapplet Designer and Transformation Designer. Developed Informatica mappings and also in tuning of mappings for better performance.
• Developed procedures/packages to kickoff the SQL Loader control files/procedures to load the data.
• Worked with Memory cache for static and dynamic cache for the better throughput of sessions containing Rank, Lookup, Joiner, Sorter and Aggregator transformations.
• Written SQL Scripts and Unix Scripts to extract data from Database and for Testing Purposes.
• Supporting daily loads and work with business users to handle rejected data.
• Stored reformatted data from relational, flat file, XML files using Informatica.
• Implemented data cleansing for files using Informatica and trillium.
• Done automation of file provisioning process using UNIX, informatica mappings and Oracle utilities.
• Handling TCS and Confidential offshore team for ETL, services module and Data Modelling.

Environment: Siebel 8.0, EIM, Informatica Power Center 8.6, Power Connect, Flat files, XML Files Oracle 9i/10g, Erwin 4.5, Power Designer, MS SQL Server 2005/2000, PL/SQL, IBM DB2 8.0, Mainframes, Toad, Perl, Unix scripting.

Confidential - NJ

Senior Data Migration (ETL & EIM) Consultant & Analyst

Responsibilities:

• Working with business users and business analyst for requirements gathering and business analysis.
• Converted business requirement into high level and low level design.
• Work and manage development team in the design and build phase.
• Extensive work on Siebel EIM tables, EIM job and administration of the EIM environment.
• Designing and customizing data models for Data warehouse supporting data from multiple sources on real time.
• Extracted data from different relational sources like Oracle and SQL server, transformed the data based on user requirement using Informatica Power Center and loaded data into target, by scheduling the sessions.
• Worked extensively with complex mappings using expressions, aggregators, filters and Update strategy.
• Created reusable mapplets and Transformations starting concurrent batch process in server and did backup, recovery and tuning of sessions.
• Created sequential batches and concurrent batches for sessions.
• Worked on Informatica Power Center tool - Source Analyzer, Data Warehousing designer, Mapping & Mapplet Designer and Transformation Designer. Developed Informatica mappings and also in tuning of mappings for better performance.
• Developed PL/SQL procedures/packages to kickoff the SQL Loader control files/procedures to load the data into Oracle.
• Worked with Memory cache for static and dynamic cache for the better throughput of sessions containing Rank, Lookup, Joiner, Sorter and Aggregator transformations.
• Stored reformatted data from relational, flat file, XML files using Informatica.
• Implemented data cleansing for files using Informatica and trillium.
• Done automation of file provisioning process using UNIX, informatica mappings and Oracle utilities.

Environment: Siebel 8.0, EIM, Informatica Power Center 8.1.5, Power Connect, Flat files, XML Files Oracle 9i/10g, Erwin 4.5, Power Designer, MS SQL Server 2005/2000, PL/SQL, IBM DB2 8.0, Mainframes, Toad, Perl, Unix scripting, Windows NT, PVCS, Autosys

Confidential

Senior Informatica Developer/Analyst

Responsibilities:

• Responsible for design and build data mart as per the requirements.
• Extracted Data from various sources like Data Files, different customized tools like Meridian and Oracle.
• Done analysis of Source, Requirements, existing OLTP system and identification of required dimensions and facts from the Database.
• Extensively used Oracle ETL process for address data cleansing.
• Developed and tuned all the Affiliations received from data sources using Oracle and Informatica and tested with high volume of data.
• Responsible for developing, support and maintenance for the ETL (Extract, Transform and Load) processes using Oracle and Informatica PowerCenter.
• Created common reusable objects for the ETL team and overlook coding standards.
• Reviewed high-level design specification, ETL coding and mapping standards.
• Designed new database tables to meet business information needs. Designed Mapping document, which is a guideline to ETL Coding.
• Migrated mappings from Development to Testing and from Testing to Production.
• Performed Unit Testing and tuned for better performance.
• Created various Documents such as Source-to-Target Data mapping Document, and Unit Test Cases Document.

Environment: Informatica Power Center 8.1/7.1.2, Erwin 4.5, Oracle 10g/9i, Teradata V2R5, XML, PL/SQL, SQL Server 2005/2000 (Enterprise Manager, Query Analyzer), SQL* Loader, SQL * Plus, Autosys, OLAP, Windows XP/NT/2000, Shell scripts, Mainframe.

Confidential, NY

Senior Informatica/Database Developer

Responsibilities:

• Designed and customized data models for Data warehouse supporting data from multiple sources on real time reporting.
• Extracted data from different relational sources like Oracle and SQL server, transformed the data based on user requirement using Informatica PowerCenter and loaded data into target, by scheduling the sessions.
• Worked extensively with complex mappings using expressions, aggregators, filters and Update strategy.
• Created reusable mapplets and Transformations starting concurrent batch process in server and did backup, recovery and tuning of sessions.
• Created sequential batches and concurrent batches for sessions.
• Worked on Informatica PowerCenter tool - Source Analyzer, Data Warehousing designer, Mapping & Mapplet Designer and Transformation Designer. Developed Informatica mappings and also in tuning of mappings for better performance.
• Developed PL/SQL procedures/packages to kickoff the SQL Loader control files/procedures to load the data into Oracle.
• Worked with Memory cache for static and dynamic cache for the better throughput of sessions containing Rank, Lookup, Joiner, Sorter and Aggregator transformations.
• Workflow Manager Used for creating and maintaining the Sessions. Workflow Manger also used to Monitor, edit, schedule, copy, aborts and deletes the session.

Environment: Informatica Power Center 7.1.1/6.2, PowerConnect, Flat files, XML Files Oracle 9i/10g, Erwin 4.5, Power Designer, SAP BW, MS SQL Server 2005/2000, PL/SQL, COBOL Files, Toad, Perl, Unix scripting, Windows NT, Business Objects 6.5, PVCS.

Confidential, NY

Oracle / Informatica Developer

Responsibilities:

• Worked with Business analysts for requirement gathering, business analysis, and testing and project- coordination
• Designed and built Data marts by using Star Schema’s.
• Created Data acquisition and Interface System Design Document.
• Done database modeling for data marts using Erwin.
• Analyzed various data sources for extracting valid data.
• Prepared technical specifications to develop Informatica ETL mappings. Loaded data into various tables conforming to the business rules.
• Developed mappings with transformations and mapplets confirming to the business rules.
• Created different transformations for loading the data into target database using e.g. Source Qualifier, Joiner transformation, Update Strategy, Lookup transformation, Rank Transformations, Expressions, Aggregator, Sequence Generator.
• Processed session data using threads and various tasks such as session and command. Managed database connections and scheduled workflows.
• Done Performance tuning of mappings, transformations and sessions to optimize session performance.
• Done Performance monitoring and tuning experience for Oracle.
• Extensively used stored procedures and also worked with parallel processing also successfully utilized the advance features like Oracle Temporary tables and autonomous transactions to improve the process.
• Created snapshot for the transactional tables in distributed databases and also created Triggers, Procedures and Functions for the backend Development.
• Created scheduling jobs using Autosys Tool.
• Extracted data from source systems to a data mart running on Oracle using utilities like Initial load, Incremental load, parallel loading and Sequential loading.
• Worked on issues with migration from development to testing on Oracle and Informatica.
• Worked on Informatica 7.0 which was installed on NT network, Oracle 9i on UNIX, Toad 8.5 and flat files, ERWIN 4.5 and loading data from Siebel EIM tables and flat files from downstream systems.

Environment: Informatica Power Center 6.2/7.1, Power Connect, Business Objects 6.5/6.0, Erwin 4.0, Oracle 9i, Teradata V2R5, Autosys, Toad, SQL, PL/SQL, Sun Solaris 8.0 and Windows 2000, UNIX shell Scripts, Mainframe.

Confidential, NY

Database (Oracle) Developer & Analyst

Responsibilities:

• Responsible for Business Analysis and Requirements Collection.
• Done Modeling and populating the business rules using mappings into the Repository for Metadata management.
• Understand the business needs and implement the same into a functional database design.
• Designing Logical and Physical Database Designing using Erwin tool.
• Involved in admin tasks like analyzing Table space requirement, load balancing and performance.
• Created Shared and Distributed Catalogs for the Users, also Created Calculations, conditions and Prompts in catalogs by using Oracle Procedures and Packages.
• Implemented Triggers, Views, Synonyms, Hints, Partitioning of Tables, Clustered and Non-clustered indexing. Extensive work on the performance tuning of Oracle ETL process.
• Developed Standard Reports, Cross-tab Reports Charts, and Drill through Crystal Reports.
• Writing PL/SQL procedures for processing business logic in the database. Tuning of SQL queries for better performance.

Environment: Erwin 3.5, Oracle 8i/9i, SQL Server 2000,PL/SQL, SQL * Loader, TOAD, UNIX Shell Scripting, MS SQL Server 2000, Cognos 7.0, Sun Solaris 2.6 UNIX, Windows NT 4.0.

Confidential, NJ

Oracle Developer

Responsibilities:

• Done System study, Analysis, and Project Planning.
• Done Database Designing and Application programming using VB.
• Wrote Database Packages, Stored Procedures, Function, Views & Triggers.
• Done Tuning of SQL-Statements and Oracle ETL process.
• Involved Unit testing and deployment of the application and Database code.
• Training the users, support and maintenance of the application along with the basic awareness of the Oracle ETL process.
• Discussions with client for bug fixing and customization of application. Document the issues with the resolution for the further reference.
• Done documentation of the PLSQL code as well as versioning of the code. Responsible for all the documentation of Application as well as Oracle code.

Environment: Oracle 8i/9i, PL/SQL, SQL, Java, C, HTML, SQL, Toad, PLSQL Developer, Windows NT.

Confidential

Oracle Developer

Responsibilities:

• Done installation and configuration of Oracle databases.
• Reviewed application requirements and development of Oracle forms and reports using Oracle Forms and Reports 6i. Also migrated that stuff to 8i version in the later part of project.
• Recommended Database configuration and also responsible for the Backup and recovery of the part of Database in the Development region.
• Created primary Database storage structures (Table Spaces, Segment, Extent, Data files, Data blocks) and objects (Tables, Views, and Indexes).
• Created and maintained Table Spaces, rollback segments and indexes for applications.
• Managed security of the application by granting and revoking various privileges/roles to users and applications
• Designed and Developed Procedures, Function, Package, View and Triggers.
• Designed and Developed scripts for loading the data into Oracle Database from flat files using SQL Loader.

Environment: Oracle 8.0/7.3, PL/SQL, Pentium PC with Windows NT, UNIX 5.7, SQL, PL/SQL, Shell scripting, Oracle Forms, Reports 6i/8i, TOAD, Erwin, Autosys, SQL Loader.

Confidential

Oracle Developer

Responsibilities:

• Involved in System study, Analysis, and Project Planning.
• Involved in Database Designing and Application programming using VB.
• Designed and Developed Database Packages, Stored Procedures, Function, Views & Triggers.
• Done Tuning of SQL-Statements and Oracle ETL process.
• Done Unit testing and deployment of the application and Database code.
• Done documentation of the PLSQL code as well as versioning of the code. Responsible for all the documentation of Application as well as Oracle code.