SUMMARY:

• As Project Lead for Data analytics, Business Intelligence (BI) and Data Warehouse (DW) solutions, provided leadership executing scalable enterprise solutions closely aligned to business strategic goals and objectives.
• Have had a wide range of skills based on over 20 years of experience in modeling, designing and developing DW applications.
• As Data architect/Project lead I deployed enterprise - wide information systems and integrated business solutions in both On-line transaction processing (OLTP) and On-line analytical processing (OLAP) environments while adhering to the best of software development life cycle (SDLC) methodology.
• Have a proven track record of successes with data management practices, processes and procedures.
• Dedicated and self-motivated leader with good communication and presentation skills.

KEY SKILLS:

• Expert knowledge of ERWin and ER/Studio data modeling tools.
• Excellent requirements gathering and consensus building skills.
• Experienced working with stakeholders and Subject matter experts (SME) to define Key performance indicators (KPIs).
• Strong data mapping and metadata management background.

TECHNICAL SKILLS:

Cloud & other Environments: Amazon Web services (AWS), Google Cloud Platform(GCP), Windows XP/Vista, UNIX, PC-LAN/Client Server, Motorola MPC.

ETL Tools: Informatica MDM, Abinitio, PL/Sql, BODS&BAPI, SAP Migration Workbench (LSMW)

BI Tools: MicroStrategy, Tableau, Business Objects, Cognos, Hyperion.

Case & Front-End Tools: Business Objects, Cognos, ERwin, ER/Studio, ModelMart, Oracle Designer 2000, IEW, S-Designor Professioner, Informatica ETL Tools (Designer, PowerCenter).

ERP: SAP, Baan III, IV, Baan V Series, Manufacturing Shopfloor Package, MDM.

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

4GLs: Perl and Ruby scripting, Puppet, Ansible, Bash and csh Python, Rapid SQL, ABF development tools, JYACC Jam/Jpl.

Languages: SQLPlus, UNIX Scripting, PL/SQL, Simscript

Tools: Informatica Apps, ERwin, ER/Studio.

PROFESSIONAL EXPERIENCE:

Confidential, Chicago, IL

Senior Corporate Consultant

Responsibilities:

• Lead branch roll-outs of Universal Banking Solution - Flexcube moduleslike customer accounts & savings accounts, funds transfer, Loans, Trade Finance, Retail teller, SMS (security management system) and Gateway interfaces.
• Designed and implemented Enterprise Business Intelligence dashboard/reporting solutionsfor Credit Cards, Mortgages, Personal loans, Ready credit and other lending.
• Developed data models to support Capital Analysis and Review reporting, Loss Mitigation, anti-money Laundry and other risk mitigation systems.
• Re-engineered current business processes to help define a more cost effective, efficient and productive operating model.

Confidential, Cary, NC

Solutions/Data Architect

Responsibilities:

• Created the Financial and Sales functions ER/Studio logical and physical models to support implementation of SAS BI Business Rules Manager and Government Risk Compliance solutions, Data Enrichment, Accounting Arrangement, Rate Assignment and Rate Analysis Modules.
• Produced target ER/Studio Logical and Physical Multi-Dimensional Models (MDM) for Data Enrichment and Accounting Arrangement modules with sub-models of Product, Order, Invoice, Customer and Sales territory.
• Mapped the target ER/Studio Logical and Physical MDM back to Cisco EDW to determine ETL requirements.
• Mapped the target ER/Studio Logical and Physical MDM to source systems to determine ETL requirements.
• Developed ETL scripts in PLSQL, BODS and BAPI to extract and load Customer, Product master data(s) to development environment.
• Tested ETL programs in DB2 and Oracle databases followed by metadata updates.
• Worked closely with the DBAs on performance monitoring, database tuning. Identified and corrected performance bottlenecks of ETL to ensure peak DB performance.

Confidential, Glenview, IL

Enterprise Business Intelligence Data Modeler/Architect

Responsibilities:

• Developed conceptual enterprise models and normalized data models that defined all business functions from JAD sessions conducted and attended by SMEs. In scope were master data(s), Finance, Supply chain, Human resources, Sales, Market analysis, Legal, Clinical Data/Research and Development.
• Produced and presented to executives Information Visio asset models.
• Produced and presented to executives, senior management and SMEs enterprise conceptual models.
• Produced and presented to managers, SMEs, analysts and developers ERWin enterprise ERD models.
• Produced business metadata, profiled DB2 data and Informatica MDM.

Confidential, Bloomingdale, IL

Systems Analyst/Architect Project Lead

Responsibilities:

• Managed requirements gathering, project scoping, translating business and operational requirements into DMs for the Workforce Management and Retail Sales/Profitability projects.
• Conducted user interviews, JAD sessions and pilots to define KPIs, gather business/analytical requirements.
• Created Retail Sales/Profitability and Operational Compliance Scorecard subject areas fact/qualifier matrix to identify dimensions and reporting hierarchies.
• Produced fully attributed ERWin Associate OLTP workforce LDM, Retail Sales/Profitability and Operational Compliance Scorecard Start schema in support of the Workforce management project.
• Integrated the newly developed Associate LDM into the existing Teradata EDW by expanding the Associate Labor reference model to accommodate new attributes that support SAP workforce management KPIs.
• Validated KPIs by mapping calculation/algorithm metrics and measures back to the EDW Teradata, Retail Sales/Profitability and Operational Compliance Scorecard Star schema.
• Migrated functional data utilizing SAP System Migration Workbench (LSMW).

Confidential, Milwaukee, WI

Senior Data Analyst / Modeler

Responsibilities:

• Translated business requirements into LDMs for the Miller / Coors joint venture (JV).
• Produced ERWin DMD in support of the (JV) Miller / Coors EDW.
• Worked with the JV project teams and SMEs to define sales profit margin KPIs.
• Worked with the JV project teams to translate and map new business data between Miller and Coors.
• Consolidated enterprise product and sales reporting LDM into MDM to create JV DMs from the existing EDW.
• Worked with DBAs to translate LDMs into physical DB2 instances. Optimized SQL and PL/SQL ETL scripts.

Confidential, Chicago, IL

Lead Data Modeler/Analyst

Responsibilities:

• Worked with BAs to gather and translate claim processing requirements into claim processing LDMs.
• Worked with the VSAM to DB2 conversion team members and the ODS team to create 3NF models that reflect current and future business requirements for Blue Chip (the claim adjudication and payment system).
• Defined business functional areas and conversion scope. Identified and resolved data model issues/gaps by mapping requirements (COBOL copybooks, reports, etc.) to completed Claim adjudication 3NF models.
• Integrated the ERWin Claim adjudication 3NF models into the ‘Insurance Group renewals/Health care Providers/Membership’ ODS LDM in accordance with company modeling standards.
• Delivered a claim adjudication LDM that reflects the legacy Blue Chip system and SMEs inputs.
• Worked with DBAs to produce matching DB2 DB instances from the 3NF models.

Confidential, Washington, DC

Data Architect and ETL Controls Analyst

Responsibilities:

• Translated reporting requirements to Restatement Financial Data Warehouse (RFDW) requirements.
• Produced in ER/Studio Securities and Loans restatement data mart Snowflake schemas.
• Validated DMs against the requirements and ensured master data is captured in its entirety.
• Identified, validated and mapped data sources from loans, securities, data work streams and existing financial data warehouse to DM Snowflake schemas and RFDW.
• Designed Ab Initio ETL to extract data from custom loan and securities sub ledgers.
• Designed and implemented a robust ETL controls infrastructure to sustain Sarbanes-Oxley (SOX) and other regulatory compliance. The controls consisted of rules driven exception handling DB in conjunction with custom Ab Initio components and automated reconciliation process. The custom Ab Initio controls performed in-process tests after the fact data reasonableness validation and other test algorithms on the RFDW KPIs.
• Validated and tested Business Objects and MicroStrategy reports for completeness and accuracy.

Confidential, Chicago, IL

Lead Data Modeler / Data Analyst

Responsibilities:

• Gathered and documented data requirements -elements, attributes, transformation/loading rules & metadata.
• Defined data quality checks and measures for the interval source data feed to the ODS and BDW.
• Created ERDs and PDMs that generated DDL/Schemas for DB instances in ODS or DW environments.
• 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.
• Conducted data model review sessions with business analysts, data architects, DBAs, project managers.
• Worked with the functional subject-area DBAs to create DB instances from LDMs.

Confidential, Schaumburg, IL

Data Manager

Responsibilities:

• Managed converting and migrating legacy source data to SAP functions and tables.
• Supervised data collection, cleansing, conversion and migration from Legacy - AS400 to SAP.
• Designed change control for SAP Material and Customer master data in the post-Go Live SAP environment.
• Worked with corporate quality assurance to ensure the deployed SAP workflow meets FDA regulations.

Confidential, Wilmington, NC

Senior Data 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 ERWin ERD models for implementation and execution in Flowstream on an Oracle database platform.
• Generated data analysis and Cognos reports.
• Validated systems that create maintain and transmit electronic records.
• Developed and executed FDA "21 CFR Part11" electronic records and signature compliant SOP's.

Confidential, Chicago, IL

Data Architect and Team Lead

Responsibilities:

• Planned, developed and deployed DWs and decision support solutions for Nutrition and Consumer sector.
• Conducted JAD sessions attended by my business analysts to gather/document requirements critical to creating the DMDs, ERDs and developing the end-user Business Objects reports.
• Oversaw the development of the business, operational and user requirements.
• Consolidated business requirements from sales regions as North America, Latin America, Europe, Asia/Pacific, each operating its OLTP systems - SAP, JD Edwards, BPCS and Platinum systems.
• Documented each region’s unique retail business practices, conventions, Unit of Measures and local currency. Created association tables that mapped the varying source systems to EDW standard.
• Developed a normalized conceptual data model of the Nutrition and Consumer division, a fact/ qualifier matrix, a metadata data model and aggregated Sales and Customer Profit margin Star schema.
• Executed the DW Sales and Customer Profit margin aggregate Star schema model in Oracle and Business Objects. The ETL applications were developed in Informatica MDM, PL/SQL and unix shell script.
• Created documents to describe the Sales and Customer Profit margin aggregate Star schema.
• Other deliverables included the DW architecture document that described the technology infrastructure, source systems, metadata requirements, volume metrics and data retention policy.