SUMMARY:

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

TECHNICAL 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

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

• 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, 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:

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

Confidential, Milwaukee, Wisconsin

DATA WAREHOUSE CONSULTANT

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, Kalamazoo, Michigan

DATA WAREHOUSE ARCHITECT / BUSINESS ANALYST

Responsibilities:

• Meta Data | Integrated Platform | Rapid Roll Out | Financial Reporting | Customer Facing |Ralph Kimball

Confidential, Groton, Connecticut

DATA WAREHOUSE ARCHITECT / DATA MODELER

Responsibilities:

• Process and Business Modeling | 3NF & Dimensional Modeling | Aggressive Timelines | Provided technical and data architectural direction | ETL Design | Meta data | Business facing

Confidential, Indianapolis, Indiana

Roles: DATA MODELER / / PROJECT LEAD / ETL LEAD

Responsibilities:

• 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