INDUSTRIES

• Retail / High Fashion Automotive Insurance Pharmaceuticals
• Banking Finance Manufacturing Health Care / Nutrition

EXPERTISE

Data Architecture Data Modeling 3NF/Multi Dimensional Ralph Kimball/Inmon Trained by Ralph Kimball University ETL Architecture ETL Lead Integration/Conversion Project Lead AGILE BI / Waterfall Data Analysis Customer Relations Mgmt Strong requirements gathering Skills Strong analytical skills Excellent communication written / oral Master Data Management Data Governance

MANAGEMENT EXPERIENCE

• Identifying and building new competencies in BI Space Building Center of Excellence
• Managing and nurturing relationships with business partners and vendors
• Project planning and Management. Technology evaluation and selection
• Devising Timelines, Coordinating with offshore / onsite teams Strategic Planning
• Managing and building DWH / BI practice and team Client Relations
• Pre-Sales, Proposal Preparation, Bidding Process, RFCs Account Management / Support activities

TECHNOLOGY SKILLS

ETL Tools : INFORMATICA 4.7 and 5.1, 6.x, 7.x, 8.x, 9.1, 9.5 IBM Data Stage 7.x, 8.x, Oracle's OWB

Data Modeling Tools : ERwin, Star-Designer Professional, ER Studio, Sybase Power Designer Databases : Oracle 7,8,9,10g, Exadata,Teradata,Db28.x, Netezza,SYBASE12.0, UDB DB27.0,

SQL Server

Data Loading Utilities : Teradata BTEQ, FASTLOAD, MULTILOAD , NZLoad, SQL Load BI Reporting Tools : Business Objects, OBIEE, Cognos, Crystal Reports, Micro Strategy

Programming Languages: I-SQL, SQL, ANSI SQL, PL/SQL, Visual Basic 5.0 / 6.0, COBOL, Unix Shell Scripting

Project Mgmt Tools : MS Project, Visio, Test Director, MSOffice, and Webster

BUSINESS APPLICATION EXPERIENCE

Confidential

Roles:BUSINESS ANALYST

Solution Architecting and documenting Analysis and assessment of current ETL solution feeding to ACTIMIZE Upgrading Informatica from 8.6.1 to 9.5 with zero downtime Leading ETL Design and Development team

Responsibilities:

Assessed current ETL solution feeding to ACTMIZE fraud and suspected activity detection application. Provided proposal on re-architecting / enhancement opportunities and how to best position for future functionality

• Leading INFORMATICA upgrade with zero downtime from 8.6.1 to 9.5 effort
• Leading an ETL design and development team
• Data Architecture of Anti Money Laundering AML data model
• Creating proposals, RFPs etc.

Technical environment: Oracle 11g, SQL Server, INFORMATICA 8.6, 9.x, ERWIN, Trillium

Confidential

Roles: DWH Consultant Data Architect ETL Design and Development

Solution Architecting and documenting AGILE BI Data Analysis and Quality Data modeling ETL Design and Development Speed Of Service SOS

Responsibilities:

Reverse engineered, 500 tables in 12 schemas to standardize and help organize the data bases, maintain the models / model mart for new changes/additions. Data Modeling/creation of new tables for new processes, staging and EDW / DIM / FACT tables

• Meet with business to understand it's needs for data and reports
• Wrote requirement documents, design documents Implementation checklist, test approach etc. for data delivery for integration and reports. Hands on development work as well.
• Design and develop ETL processes using INFORMATICA PowerCenter 9.x.
• Worked with System owners and SMEs to analyze and document existing schema/processes supporting the current and outgoing POS system. Further study the impact of new POS system being implemented ALOHA on current processes and schemas to help determine what to do with existing processes/objects
• Documented suggested next steps for retiring/rewriting functionality/objects

Technical environment: Oracle Exadata / 11g, INFORMATICA 9.x, ERWIN

Confidential

Roles: DWH ARCHITECT/ IBM MDM Implementation Data Architect

DWH Architecture Solution Architecting and documenting AGILE BI HUB and Spoke Data Analysis and Quality Road Maps Data modeling ETL Design Master data management Integration of several systems CDC

Responsibilities:

• Help Architecting and implementing data warehouse and BI solution from ground up. Then adding more functionality and new source systems to it for multiple lines of business. Assigned to several teams representing different lines of businesses
• Working very closely with SMEs/System Owners/Business in identifying and documenting requirements, business rules, data anomalies, Source to target mapping documents.
• Leading sessions with several source systems and for multiple very high visibility projects to understand sources, requirements etc. to propose architecture and overall solution
• Involved in Implementation of master data management solution using IBM MDM Server.
• Help influence Overall direction / strategy of BI solution. Building Road maps, architecture decisions and architecture documents. Documenting Solutions proposed and communicating to all stake holders.
• Integration of several systems with MDM, and Data warehouse. CDC tool was used.
• Data modeling 3rd nf, dimensional , Data Ware house Architecture Inmon methodology was implemented with selective projects delivered using Kimball , Data Analysis, Design, Build, Developer Support, Heavy SME's/Customer interaction
• Served as Source of direction to all IT colleagues involved in building, testing and implementing proposed solution. Providing direction and help to onsite and offsite teams and junior colleagues.
• Working closely with vendor partner teams onsite and offsite
• Develop and nurture relationships with our business partners, IT support groups and vendors
• Technology evaluation and recommendation
• Help building the team and new competencies in BI Space
• Help Building Center of Excellence
• Identifying Data Quality candidates. Used Information Analyzer. Working closely with Quality Stage expert

Technical environment: IBM Infosphere MDM, IBM DB2 Smart Analytics, IBM Data Stage, Quality Stage, Information Analyzer, ERWIN, SSIS, MS SQL Server, SOA, Microstrategy

Confidential

Roles: DWH ARCHITECT

Confidential Marketing Campaigns Report Prototypes Data Quality Analysis Rapid Reporting Architectural and Design Recommendations

Responsibilities:

• Architecting and implementing data warehouse and BI solution from ground up.
• Working closely with vendor partner teams onsite and offsite
• Involved in design discussion related to reporting needs
• Design and development of Data loading processes including INFORMATICA and Oracle components
• Marketing's CRM Campaign Management Strong Moms targets new moms for marketing Infant Formulas including SIMILAC. As Architect for above effort, Involved in customer facing discussions to understand their business, Campaign processes, challenges and needs. Source Data analysis using complex SQL queries
• Help influence Overall direction / strategy of BI solution
• Develop and nurture relationships with our business partners, IT support groups and vendors
• Working closely with DBAs to implement Data base solutions
• AGILE BI methodology for implementing this solution is used on the effort
• Abbott collects Sales Tracings data from third party Partners and sellers for it's products. This existing application on VM needed migrated to DWH environment. Designed the ETL and data migration process to newly created ODS and DWH environment. There is an application on ODS for tweaking some sales data and product / customer info.
• Working closely with application team in understanding their needs and helping with design and scripts to build/load data as per their needs
• Working with Primary Data Architect in design of data model for STG, ODS and DW areas
• Involved in design discussion related to reporting needs
• Rapid Reporting--- Some business teams would like the ability to load data in excel sheets into a DWH alike environment with basic reporting abilities without having to go through and build a data warehouse / BI solution.
• Involved in conceptual design and data architecture design discussions to help architect the solution
• Design of ETL / data movement process
• Responsible for development of data loading process using INFORMATICA and Oracle

Technical environment: Oracle 10g, INFORMATICA 8.x, SYBASE Power designer 12.5, COGNOS 8.3, Unix, MS SQL Server, SSIS

Confidential

Roles: DATA ARCHITECT / BUSINESS ANALYST

• Data Architecture Source Data Analysis Customer Facing Coordinating with developer and Business Community Developer Guidance and Mentoring INVENTORY General Direction
• Responsibilities: AAP is a nationwide discount Auto retailer. Hired by DWH Practice of major consulting firm to build and deliver Phase II comprising mainly of Orders, Inventory and Goods movement process.
• Activities in business revolved around merchandise movement from vendors to DCs to stores and within stores and supporting feeder stores. Gained understanding of processes like Purchase Orders, Internal Orders, Shipments, Receipts, Returns, Rejections, Damaged goods, Inventory at hand, Forecasted inventory etc.
• Customer facing with users, DC Managers, Store Managers, senior managers, directors and SMEs to understand the business process and systems/apps/reports being used by them. Challenges faced and what their reporting and day to day needs are from existing / future systems. Data analysis
• Creation of Data Mart for Inventory Subject Area along with POs, IOs, SHIPMENTs, RECEIPTs, DEPT and PRODUCT. Working with DBAs very closely in implementing the design and in adding enhancements, fixes etc. Mappings of all data elements from source to targets from legacy systems. Providing direction to developers about building data migration jobs. Helping with general direction of the phase II delivery effort
• Also served as SME and testing person after the jobs were built to verify the results.

Technical environment: Oracle, UDB DB2, IBM Data Stage, ER Studio, MQ Series, OBIEE, Cognos

Confidential

Roles: DATA ARCHITECT / ETL LEAD

Build DWH from Ground up ETL Architecture Technology Selection Real Time Data Warehousing Data Modeling Developer Guidance and Mentoring

Responsibilities:

Third member of the data warehouse / BI Architects team assigned with the task of building BI environment from ground up. Involved in running proof of concepts for selection of tools ETL, Data base and BI Tools

• Involved in over all design of Data ware house, it's schemas staging, Foundation EDW , History and presentation layer
• Created logical and Physical data models in Erwin Stage, Hierarchies, Sales, 3nf, dimensional, History, Error handling , DDL and physical structures like Tables, indexes, Sequences etc while following the data modeling standards
• Source data Analysis
• Lots of end user business interaction to understand the requirements.
• Wrote Functional and technical specifications and requirements documents
• Data modeling OLTP/OLAP/3nf using Erwin 7.x.
• Using Class words, meta data, Model manager.
• Contributed to the data modeling standards
• Design and implementation of ETL Load strategies for IBM Datastage 8.x
• Create ETL source to target mapping documents, Functional Specs, Technical Specs, Conducted Code reviews, design reviews etc for Hierarchies, transactions and master data
• Involved in Design and implementation of Trickle Poll real time data feeds for sales data trickling in from stores in real time basis. Technology involved was DB2, MQ Series and Netezza
• Involvement in Implementation of the ETL / Data modeling tools.
• Designing the overall architecture and then building data ware house one source system at a time.
• Managed People, data warehousing consultants involved in activities of ETL, testing, Off shore coordination, data modeling and off shore deliverables.
• Designed test procedures and methods, implemented them in Quality Center. Design of test templates, test cases and Reviewing code/test results etc

Technical Environment: Erwin, IBM Datastage 8.x using Parallel technology, Netezza, NZload, ANSI SQL, DB2, OBIEE, Shell scripting, ESP Scheduling, ftp, Unix., PeopleSoft

Confidential

Roles: DATA ANALYST / ETL DESIGNER

Source Data Analysis Design and Create ETL Reports Prototyping Heavy Partitioning

Responsibilities

• Source Data Analysis for CRYSTAL / CALL CENTER Business Intelligence Integration and Data Mart development
• Facilitate requirement gathering while working with Systems Analysts
• Design and creation of ETL Specs and jobs using INFORMATICA for Staging, EDW and Data mart
• Modeled and created tables for staging area, EDW and Data Mart
• Used database partitioning heavily for loads of EDW and history tables for better management of data and facilitate better over all performance for ETL and data base reads.

Confidential

Roles: DWH DESIGNER AND DEVELOPER

Process Analysis Documentation TERADATA and Data Stage development TERADATA's Retail Model Responsibilities: Involved in Design discussions and creation of Data models Using Teradata's Retail Model , staging and data ware house tables using Erwin for INSIGHT Integration. Process analysis and documentation

• Design and development of ETL processes using Data Stage Stages like Lookup, ODBC, Joiner, Transformer, MLOAD Bulk Loader , Oracle, BTEQ, MLOAD, Teradata, unix shell scripts, Control-M
• Wrote BTEQ Scripts
• Helping with ETL / Data warehousing standards

Confidential

Roles: DATA ARCHITECT / DEVELOPER

Coordinating with developer and Business Community Developer Guidance and Mentoring high visibility Conversion effort Integration of Compensation data Claims and Policies 401 K Plans data Building teams Property and Casualty

Responsibilities:

• Worked on design of ETL for Future State of Sales MI Data Mart and NRS retirement solutions/401 K data Conversion Project and further integrating it in DWH
• Integrate Compensation data from Callidus software into Data warehouse. Helped build prototype using ETL tool towards strategic direction of incorporating ETL methodology and tool in a strictly BTEQ/Scripting environment.
• Involved heavily in all phases design, build, test, implementation and support of Business Intelligence process and building of data warehouse.
• Requirements analysis, Design of data model, ETL Process and ETL data mappings for loading Data Warehouse, Data Marts and Stage Schemas.
• Managed ETL work of other ETL staff. Helped in writing standards for ETL development.
• Use of Teradata BTEQ jobs, Multiload, Fastload.
• Helping other ETL/Data warehouse department colleagues with training and trouble shooting. Interviewing possible candidates for ETL / Data warehouse positions needs of Nationwide.
• Assisting in Universe creation
• Conversion of data to Callidus/True Comp, Compensation package.

Confidential

Roles: DATA MODELER AND ETL TEAM LEAD

• Inventory Stock levels Forecasting Common Hierarchies JUST IN TIME COMMUNICATE with Stake Holders
• LEAD for Buffer Stock Planning and Integration. Drastic savings in premium freight and excess costs of inventory

Responsibilities:

• Creation and maintenance of data models DWH and STAR schemas using Erwin.
• Worked closely with business for requirement gathering and analysis, ensuring completeness of deliverables and obtaining customer sign off.
• Managed communication and co-ordination with the project stakeholders.
• Involved in Project planning, Effort estimation, resource management and coordination
• Led a team of 5 developers and provided Technical Leadership to build the ETL and Analytic framework
• Designed and created Cognos reports and Cubes using Powerplay
• Designed and created the ETL Process and individual ETL data mappings/processes.

Confidential

Roles: DATA WAREHOUSE CONSULTANT

• Expand Data Marts Single Target Model Integrating data from several database platforms Centralized Reporting
• DATA WAREHOUSE CONSULTANT for Enterprise Business Intelligence Services EBIS Project. This effort made possible to pull customer information together into recruitment, sales and prospect reports. Single target data model

Responsibilities: Involved in Data model changes, creation of schemas to extend the existing Data Mart to include additional data for supporting several new business reporting needs. Facilitating data definition collection sessions. Designing and creation of ETL data mappings for Type 2 Slowly changing dimensions. Performance tuning existing ETL maps .This central reporting repository helped to enforce a common set of business rules and information quality constraints.

Technical Environment: INFORMATICA POWERMART 5.1, Actuate, Crystal reports, Erwin, Oracle 8.1.7, 9I, Shell scripting, UDB DB2 7.0, Sybase 12.0, POWERCONNECT for Mainframe / MQ-Series, Unix Solaris.

Confidential

Roles: DATA WAREHOUSE ARCHITECT / BUSINESS ANALYST

Confidential

Roles: DATA WAREHOUSE ARCHITECT / DATA MODELER

• Process and Business Modeling 3NF Dimensional Modeling Aggressive Timelines Provided technical and data architectural direction ETL Design Meta data Business facing
• DATA WAREHOUSE ARCHITECT for FACTS Financial Accounting for Clinical Trials : Very high visibility project helped in saving millions per year in conducting Clinical Trials and helped substantially in forecasting budgets for conducting Clinical trials in coming years

Confidential

Roles: DATA MODELER / / PROJECT LEAD / ETL LEAD

• Customer Relationship Management CRM and Data warehouse Team
• Software Team Leadership Data Modeling Project Co-ordination ETL Design and development DBA
• Rose through positions of increasing technical and leadership scope. Gained critical buy-in from leadership team with perspective on core competencies, relative risk for build up v/s buy decisions. Involved in running proof of concepts to buy new ETL technology v/s using existing PL/SQL code

Confidential

Roles: Oracle DBA / DATA ANALYST

DBA work PL SQL Development Business Objects Report Creation