PROFESSIONAL FOCUS:

• Data Management - Data Warehousing & Business Intelligence (architecture & development)
• Data Science - Data Analytics, Machine Learning (supervised learning), & Data Visualization

PROFESSIONAL SUMMARY:

• Demonstrated expertise on DW (Inmon & Kimball Architectures) and BI Best Practices
• Outstanding BI Tool comprehension & data design concepts including “Performance” & “Ease of Use”
• Lead designer/developer for backend analytics
• SQL development/analysis/performance tuning, SAS analysis, procedural language coding
• Strong understanding of IBM Insurance Industry Warehouse (IIW) Customer model
• Mastered BO Designer (universe design/development/Webi) and competent with numerous additional BI tools
• Successful delivery of both batch and real-time systems
• Working knowledge of Hadoop and Big Data technologies
• Business value: Demonstrated ability to strategically plan, execute, and achieve maximum business value
• Assessment: Provide in-depth analysis & assessment on org’s current state of info. delivery capabilities
• Business-driven: Focus on allowing the customer to drive decision-making process throughout the life cycle
• Analysis & Design: Strong data analysis & design including business analytics design & presentation
• Flex & innovation: Demonstrated out-of-the-box thinking and exceptional problem solving skills
• 20+ yrs leading and developing OLTP applications, DW & BI reporting systems, & analytics projects
• 20+ yrs using RDBMS technology & OLAP
• 20+ yrs Data Architecture & Solution Development for Information Delivery
• Have successfully managed hardware & software teams including IT department staff & data warehouse teams

DEVELOPMENT SKILL SUMMARY:

• Demonstrated ability to effectively perform any of the following activities at an extremely high level:
• Conducted assessment of data & existing capabilities in many different environments
• On many occasions have coached BAs to improve methods for BI & DW projects
• Designed successful OLTP apps, DW/BI apps, & analytics projects
• Developed OLTP apps, complex SQL & Code for Analytics, successful BI apps
• Extremely adept at discovering root causes, tracking issues, and minimizing reoccurrence

SPECIFIC TECHNOLOGY SKILLS:

Data Bases: Oracle-10 SQL Server-6 DB2-5 Teradata-2 Netezza-2 MySQL-1 Reliance-5 Sybase-1 MS Access-2 Pilot CC-2 Pilot OLAP-1 MongoDB-0

Languages: SQL-10 PL/SQL-4 T-Sql-2 Assembler-1 Java-1 Basic-1 C-1 SAS-1 Fortran-6 Foxpro-3 Cobol-1 Python-0 Pascal-0 R-0

Tools: Erwin-8 PowerDesigner-3 IEF case tool-1 Lbms case tool-1 Flowchart-4 Data flow diagram-3 Toad-5 MS mgmt studio-3 Rapid SQL-6 SQL Navigator-3 Pilot Lightship-1 Pilot command ctr-2 Tableau-1 BO Designer-12 BO Webi-5 BO supervisor-4 Crystal reports-2 MS Access Query-1 Xcelsius-2

PROFESSIONAL EXPERIENCE:

Sr. BI / Visualization Consultant

Confidential, Flagstaff, AZ

Responsibilities:

• Designed and developed Tableau dashboards (call center / recruiting) to replace Xcelsius dashboards and BO charts.
• Conducted extensive data analysis and assisted with visualization designs for prospect/call center KPIs.
• Designed and developed BO universe with suite of performance (recruitment) charts.
• Developed multiple call center performance dashboards using Xcelsius.
• Contributed to design of data warehouse (university prospect data & employee call center performance metrics).
• Developed data quality checks to assist with trouble-shooting, documenting errors, and tracking resolutions.

Technologies: Tableau, SQL, Business Objects XI R3/R4, SQL Server 2012, SQL Server Mgmt Studio, Xcelsius

Confidential, Erie, PA

DW Architect / Lead Business Analytics Developer

Responsibilities:

• Designed and implemented multiple data analytics projects for Marketing Campaigns.
• Designed & developed solution to provide list of prospects within 25 miles of each sales office (2,000 offices).
• Designed & implemented solution to link customers’ Confidential data to enterprise data for ad-hoc marketing analysis & reporting.
• Continued implementation of IBM IIW Model for data warehouse .
• Designed & developed complex SQL for customer-centric dimensional views.
• Developed Conceptual, Logical, and Physical Data Models for data warehouse projects.
• Developed ETL requirements, transformations, and mappings for customer data mart.
• Conducted extensive performance tuning on DB2 databases.

Technologies: DB2, SQL, ERWIN 7.2 & 8, Embarcadero Rapid SQL, Business Objects XI R4, PL/SQL, SAS, MS Visio

Confidential, Decatur, IL

Sr. Business Objects Consultant

Responsibilities:

• Applied security best practices to redesign & implement organization’s Business Objects security.
• Migrated multiple BO & Crystal reports from multiple report servers into a single clustered environment.
• Resolved issues from previous attempts to implement extremely complex advanced features on multiple BO universes.
• Provided recommendations for data warehouse architecture to improve usability.

Technologies: SQL Server 2008, Business Objects XI R3

Confidential, Bloomington, MN

Sr. Business Objects Consultant

Responsibilities:

• Resolved issues with problematic Business Objects project and completed on schedule.
• Provided and documented recommendations for data & ETL architecture to avoid similar issues in the future.
• Modified BO universe and fix approx. 20 mostly complex reports.
• Built new universe and reports for drug / outcome project.

Technologies: Teradata V2R6.0, Oracle 10g, MS SQL Server, BO XI R3

Confidential, Bloomington, IL

Sr. BI Consultant

Responsibilities:

• Modified Enterprise’s Software Development Methodology (SDM) to improve BI project delivery
• Developed guidance for developing conceptual, logical, and physical data models.
• Developed hierarchical framework for breaking down BI Solutions into components for alignment with BI Architecture.
• Integrated BI best practices, templates, and training/guidance into existing SDM.

Technologies: DB2, Excel, MS Visio

Confidential, Madison, WI

Lead BI Architect

Responsibilities:

• Designed layered security architecture for Business Objects using Oracle policies and BO security mechanisms.
• Developed best practices for Business Objects (customized to Dean Environment).
• Collaborated with HP/Knightsbridge Architecture Team to develop BI Architecture.
• Developed foundation for Business Intelligence Center of Excellence.
• Lead / mentored multiple staff (BAs, DBAs, developers, and administrators) on multiple reporting projects.
• Developed analytics universe & data mappings for offshore development.

Technologies: Oracle 10g, Business Objects XI R2, Xcelsius, Live Office, CDMA (HP Data Mapping Tool), MS Visio

Confidential, Baltimore, MD

DW Architect / Lead BI Developer

Responsibilities:

• Lead BI project - met very aggressive milestones/deadlines - to build a scheduled reporting system for Japanese market.
• Developed universes & multiple reports using Japanese character set.
• Served as technical advisor to multiple projects (mentored junior & mid-level Business Objects developers).
• Developed Dimensional Model for global enterprise with diverse business rules by geographic region.
• Incorporated global concepts, such as time zones, international exchange rates, Japanese character set, etc.
• Managed critical scheduling & timing issues for publications of external reports for multiple time zones.
• Key role facilitating offshore development for Xcelsius project using Universe & Web Services.

Technologies: Oracle 10g, Netezza, BO XI R2, Erwin 7.x, Xcelsius, MS Visio (Data Warehouse: 100+ Terabytes)

Confidential, Dearborn, MI

Senior Business Objects Consultant

Responsibilities:

• Innovated new design for BO Parts Universe - greatly improved query performance for all detail “Auto Parts” reports (typical reports ran in 4 or 5 seconds rather than 1 or 2 minutes)
• Updated Business Objects universe and replicated suite of mainframe Focus reports.

Technologies: Oracle 10g, Business Objects 6.5, Oracle SQL Developer

Confidential, San Fran, CA

Business Intelligence Lead

Responsibilities:

• Managed & coordinated Implementation of new Business Objects Enterprise environment.
• Designed & implemented Business Objects Security (using Active Directory).
• Lead Business Intelligence effort on new Financial Services Data Warehouse.
• Designed & developed BO universes to deliver BI ad hoc capability and developed suite of reusable Webi reports.
• Designed & managed Business Objects Administration & Release Procedures.
• Developed best practices for data mart & BI report development (customized to specific environment).

Technologies: Oracle 10g, Business Objects XI R2, Erwin, Toad, Data Integrator Metadata Bridge, MS Visio

Confidential, St. Louis, MO

Business Intelligence Lead

Responsibilities:

• Designed and developed new BO universe and reports for external customers.
• Developed ETL using T-SQL.

Technologies: T-SQL, SQL Server 2000, MS SQL Enterprise Manager 8.0, Business Objects 6.1.5