SUMMARY:

• Distinguished DWH Architect and SENIOR DATA WAREHOUSE / BI PROFESSIONAL
• Hands - On DWH/Solution Architect - Data Architecture - ETL Architecture/Development - Integration Architect - Customer Facing - Managed On Site/Off Site teams - Practice Lead
• Confidential is a hands on, result oriented professional with 19+ years of experience in IT Industry
• Understand 'Big Picture' concepts as well as ‘hands-on’ details required to make complex projects succeed.
• Very Good ability to understanding Business and ask the right Qs. Versatile, Flexible and positively motivated by "unsolvable" technical problems.
• Goal oriented, consistently reliable and strong under pressure

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.0SQL 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

PROFESSIONAL EXPERIENCE:

Confidential, Buffalo, NY

DWH Consultant | Data Architect | ETL Design

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
• Creating proposals, RFPs etc.

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

Confidential, Columbus, Ohio

DWH Consultant | Data Architect | ETL Design and Development

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, Columbus, Ohio

DWH ARCHITECT/ IBM MDM Implementation| Data Architect

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, Columbus, Ohio

DWH ARCHITECT

Responsibilities:

• Architecting and implementing data warehouse and BI solution from ground up.
• Working closely with vendor partner teams onsite and offsite
• Develop and nurture relationships with our business partners, IT support groups and vendors
• Help influence Overall direction / strategy of BI solution
• 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
• Design and development of Data loading processes including INFORMATICA and Oracle components
• Involved in design discussion related to reporting needs
• Working closely with DBAs to implement Data base solutions
• AGILE BI methodology for implementing this solution is used on the effort
• 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
• 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, Roanoke, Virginia

DATA ARCHITECT / BUSINESS ANALYST

Responsibilities:

• 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, Columbus, Ohio

DATA ARCHITECT / ETL LEAD

Responsibilities:

• 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, Columbus, Ohio

DATA ANALYST / ETL DESIGNER

Responsibilities:

• 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, Columbus, Ohio

DWH DESIGNER AND DEVELOPER

Responsibilities:

• 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, Columbus, Ohio

DATA ARCHITECT / DEVELOPER

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
• 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, Holland, Michigan

DATA MODELER AND ETL TEAM LEAD

Responsibilities:

• 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.