SUMMARY:

• As a Project Lead for Business Intelligence and Data Warehouse solutions implementation, I have provided leadership in developing Enterprise scale - able Data Warehouses that are closely aligned to business goals and objectives.
• I have had a wide range of skills based 16 years of experience in modeling, designing and developing data warehouse applications.
• As a Data Architect, I gained experience in the implementation and deployment of Enterprise-Wide information systems and integrated business solutions in both OLTP and OLAP environments utilizing a structured Software Developing Life Cycle.
• I also have a proven track record of successes with data management practices, processes and procedures.
• I am dedicated and self-motivated entrepreneurial leader possessing highly developed communication and presentation skills.

KEY SKILLS:

• Expert knowledge of ERWIN and ER/Studio data modeling tools.
• Excellent requirements gathering and consensus building skills.
• Experience in gathering reporting requirements and working with stakeholders to define KPIs.
• Strong data mapping and metadata management background.

TECHNICAL SKILLS:

Environment: Windows XP/Vista, UNIX, Dec VAX, PC-LAN/Client Server, Motorola MPC

ETL Tools: Informatica, Abinitio, PL/SQL, Toad

BI Tools: Business Objects, Cognos, Microstrategy, Hyperion

Case & Front-End Tools: Business Objects 5.0, Cognos, ERwin/ERX 3.5, ER/Studio, ModelMart, Oracle Designer 2000, IEW, Windows Excelerator, S-Designor Professioner, Baan V DEM/Orgware, DOS & LAN/PACBASE, Informatica ETL Tools(Designer, PowerCenter, Server Manager)

Enterprise Resource Planner: PeopleSoft 6.0, SAP, Baan III, IV, and the V Series. Manufacturing Shopfloor Package; Flowstream.

Databases: Oracle, Teradata, SQL Server, Sybase, DB2, Informix, Access, RDB

4GLs: Rapid SQL, Ingres 4GL VIFRED & ABF development tools, JYACC Jam/Jpl, Oracle Form Applications, .NET.

Languages: C/C++, SQL, VB, UNIX Scripting, PL/SQL, SQL/SQLMOD, Cobol, Simscript, CDD/Plus, Vax DCL, PL/1, RPG-II

Tools: Informatica Apps, ERwin, ER/Studio, Word, Excel, Project, PowerPoint, Visio 2000, Sterling Gentran 3.5., etc.

PROFESSIONAL EXPERIENCE:

Confidential, Chicago, IL

Solutions/Data Architect

Responsibilities:

• I was responsible for developing functional/application logical and physical models in ER/Studio to support implementation of SAS Business Intelligence Business Rules Manager and Government Risk Compliance solutions.
• In scope were Data Enrichment, Rate Analysis, Rate Assignment and Accounting Arrangement Modules.
• Produced target ER/Studio Logical and Physical dimensional data models for the Data Enrichment and Accounting Arrangement module with sub-models of Product/Item, Order, Invoice, Party/Customer and Sales Territory.
• Mapped the target ER/Studio Logical and Physical dimensional data models back to Cisco Enterprise Data Warehouse.
• Mapped the target ER/Studio Logical and Physical dimensional data models to the operational source systems.
• Developed ETL scripts to extract, load Customer and Product Master Data(s) to Development and Test Oracle11 databases followed by updates to the Metadata tools.
• Worked closely with the DBA on database performance monitoring, database tuning, identification and correction of performance bottlenecks of ETL scripts to ensure peak performance of the Oracle11 environment.

Confidential, Glenview, IL

Business Intelligence Enterprise Data Modeler/Architect

Responsibilities:

• Produced in Visio, Information asset models for presentation to executives.
• Produced in Visio, enterprise conceptual models for presentation to executives, senior management and SME’s.
• Produced in Erwin, enterprise conceptual entity models for presentations to senior management, SME’s, analysts, and developers.
• Produced robust business metadata/data dictionary from the material documents gathered and information leaned from JAD sessions conducted with various experts of the functional areas in the enterprise functional scope.

Confidential, Bloomingdale, IL

Systems Analyst/Architect Project Lead

Responsibilities:

• Conducted client interviews and JAD sessions to gather business requirements.
• Worked with client to define project scope, develop and define Key Performance Indicators (KPI’s) during piloting.
• Produced in ERWin fully attributed Associate OLTP workforce Logical Data Model; Retail Sales/Profitability and Operational Compliance Scorecard OLAP Multi-dimensional Models in support of the Workforce management project.
• Integrated the newly developed Associate logical model into the existing EDW Teradata by expanding the EDW Teradata Associate Labor reference model to accommodate newly identified workforce operational attributes to support newly defined SAP Workforce management KPI’s.
• Validated KPI’s by mapping calculation/algorithm metrics, measures back to the EDW Teradata, Retail Sales/Profitability and Operational Compliance Scorecard multi-dimensional models.
• Created Retail Sales/Profitability and Operational Compliance Scorecard subject areas fact/qualifier matrix to identify dimensions and reporting hierarchies.
• Completed Employee and other workforce master data documentation and the corresponding Metadata updates.
• Integrated SAP Accounting, Controlling, non-productive procurement and Treasury processes with other modules like MM, FI, CO, QM.

Confidential, Milwaukee, WI

Senior Data Modeler / Data Analyst

Responsibilities:

• Produced ERWin dimensional data models in support of the joint venture (JV) Miller / Coors Enterprise Data Warehouse (EDW).
• Partnered with Miller/Coors JV project teams and SME s to define sales profit margin KPI s.
• Partnered with Miller/Coors JV project teams to translate & map new JV business requirements between Miller and Coors.
• Consolidated existing enterprise product and sales reporting data models into dimensional data models that will leverage the existing EDW in the creation of planned JV data marts.
• Worked with Oracle 10&11 and DB2 DBAs to translate the logical models into workable physical models and databases.
• Optimized SQL and PL/SQL. Assisted in creating test strategies, scenarios, unit and integrated testing environments.
• Applied patches to E - Business suite and Oracle databases, cloned Oracle E-Business Suite environments.

Confidential, Chicago, IL

Lead Data Modeler / Data Analyst

Responsibilities:

• As a data modeler, worked with various members of the project team, the Operational Data Store (ODS) development team to develop VSAM to DB2 conversion 3NF logical models to meet current and future business/operational requirements for Blue Chip - a high volume On-Line Transaction Processing (OLTP) health care claims adjudication, processing and payment application.
• Responsible for gathering, documenting requirements for the data models, defining business functions and subject areas scope, identifying & resolving data model issues, mapping requirements (COBOL copybooks, reports, etc) to completed data models.
• Fully integrated the DB2 3NF logical data model into Insurance Group renewals / Health care Providers / Membership ODS in accordance with company standards using ERWin.
• The resulting deliverables were pre-adjudication and adjudication logical models developed from the gathered requirements, current legacy Blue Chip application and subject area/matter experts.
• Work with the responsible Database Administrators to produce a matching physical model.

Confidential, Washington, DC

Data Architect and ETL Controls Analyst

Responsibilities:

• Produced in ER/Studio dimensional Models for the restatement data mart that included the securities and loans areas.
• Translated reporting requirements into technical requirements for the Restatement Financial Data Warehouse (RFDW).
• Validated the data mart models against the requirements and ensured master data is captured in entirety.
• Mapped source systems to the data mart models.
• Identified, validated and mapped data sources from loans and securities data work streams, existing financial data warehouse to the RFDW models.
• Performed data analysis along with validation and testing of reporting applications in Business Objects.
• Designed ETL that extracted data from custom loan and securities sub ledgers on Oracle 10g with Ab Initio as the ETL tool, Business Objects XI as the report and query tool.
• Designed and implemented a robust and extensive ETL controls infrastructure to sustain Sarbanes-Oxley (SOX) and other regulatory compliance. The controls infrastructure consisted of rules driven exception handling database in conjunction with custom Ab Initio control components and an automated reconciliation process. The custom Ab Initio control components performed in-process after fact data validation reasonableness tests and other tests algorithms on the RFDW KPIs.

Confidential, Chicago, IL

Lead Data Modeler / Data Analyst

Responsibilities:

• Created entity 3NF logical models and physical models that generated the DDLs for DBA implementation into either ODS or Data Warehouse target environments.
• Provided remediation and troubleshooting support for data quality issues on existing BDW Star Schemas, ODS data structures and applications.
• Documented data requirements (required data elements & their attributes, associated transformation/loading rules and metadata) and defining the data quality checks and measures required for the source data feeding the Operational Data Store (ODS on Oracle) or the Brokerage Data Warehouse (BDW on DB2).
• Provided analysis and documentation of data sources Beta System a leading provider of integrated information solution to Financial Businesses such as Brokers) to end - users of securities, data management department and decision support services.
• Acquired and maintained detailed knowledge of data domains/subject-areas such as Brokerage Reporting, SOX compliance / NYSE Regulation 401B strategic, Account Managing Application and OPS Credit/Fail while assisting business analyst in data and requirements gathering.
• Developed in Erwin dimensional or/and conceptual data models for these subject areas from very detailed requirements document and ETL specs.
• Facilitated data modeling and data model review sessions with business analysts, Data architects, DBAs/Environment managers and project managers during JAD or technical review sessions.
• Work with the functional / subject-area Database Administrators to produce a first draft physical model.

Confidential, Schaumburg, IL

Data Manager

Responsibilities:

• Responsible for collection, cleansing, and change control of the data being converted and migrated mostly from Legacy - AS400 to SAP.
• Designed change control procedures for SAP Material and Customer master data in the post-Go Live SAP environment.
• Provided SAP implementation data analysis and workflow management for all data-related activities for the SAP implementation project.
• Worked in tandem with project management and corporate quality assurance to provide quality analysis, process workflow and documentation while complying to regulatory FDA data verification and validation requirements from legacy to the newly deployed SAP system.

Confidential, Wilmington, NC

Senior Scientist

Responsibilities:

• Validated manufacturing ERP Shopfloor Package - Flowstream and its LIMS system interface processes for consistency with batch job requirements and compliance with FDA regulations.
• Developed detailed shop floor manufacturing processes/workflows and entity relationship data models in Erwin for implementation and execution in Flowstream on an Oracle database platform.
• Generated reports and data analysis in Cognos Developed OQ's for chemistry production Excel spreadsheets.
• Validated systems used to create, modify, maintain, or transmit electronic records as well as developed and executed SOP's that guarantee compliance to FDA "21 CFR Part11" electronic records and signature requirements.

Confidential, Chicago, IL

Data Architect and Team Lead

Responsibilities:

• Planned, developed and deployed data warehouse and decision support applications for the Nutrition and Consumer sector.
• Supervised and coordinated business analysts efforts in the business requirements gathering phase critical to developing the end - user reporting in Business Objects.
• Refined and consolidated business requirements from autonomous retail sales regions such as North America, Latin America, Europe, Asia/Pacific. Each operated its own OLTP source systems such as SAP, JD Edwards, BPCS and Platinum systems.
• Documented each region s unique retail business practices, conventions, Unit of Measures and local currency, which required association tables that mapped each of the source systems to enterprise wide Data Warehousing (DW) standards.
• Oversaw the development of the business, operational, and user requirements.
• Developed a normalized conceptual data model of the Nutrition and Consumer business Sector model, the fact / qualifier matrix, the metadata model and the DW Sales and Customer Profit margin aggregate level dimensional data models in Erwin.
• Implemented the Data warehouse Sales and Customer Profit margin aggregate level dimensional data model on Oracle 8.1 and Business Objects 5.0. The Extraction, Transformation and Load (ETL) applications were designed and developed in Informatica, PL/SQL and unix shell script.
• Designed project development, testing and production environments with standards, processes and protocols.
• Developed the Multidimensional model document that described Sales and Customer Profit margin aggregate level multidimensional data model. Other deliverables included the Data warehouse architecture document that described the technology infrastructure, the source systems, metadata requirements, volume metrics, and data retention policy.

Confidential

Senior Consultant

Responsibilities:

• Validated Baan Business Control reference data models and process flows during workshops by explaining the full technical implications of process re - engineering decisions that were being made.
• Analysis included cost/benefit analysis of proposed Confidential (Baan Series) personalization/customizations to business operational gaps and issues.
• Established a Baan application change control system for Picker, including a customization and development environment with procedures and standards in place.
• Created legacy data mapping, conversion, migration templates and tools for Confidential .
• Developed, managed and coordinated data conversion for the four strategic business units.
• Utilized Baan OrgWare - Dynamic Enterprise Modeler to create data models and entity-relationship diagrams of the new Confidential functionality and data structures such as the Business Partner, Commission and Rebate to facilitate the discussion workshops.
• Helped select and implement Sterling Gentran, an EDI translation software to meet Picker EDI requirements.
• Provided Confidential installation and system administration support, patch upgrades, debugging and testing.
• Trained systems personnel in Baan systems administration procedures documentation, conventions and standards.
• Created and maintained a Sim1 Baan training environment for a single Financial/multiple Logistical companies configuration, and over a 100 user sign - ons.
• Designed, recommended and implemented a VRC structure for training, conversion, testing and production environments complete with application naming conventions, and software release protocol.
• Developed a data conversion plan to migrate data from their various legacy systems to Confidential .
• Implemented, coded and tested Confidential Customization/Personalization and new Development.