SUMMARY:

• +13 years of relevant business intelligence, data warehousing & data analysis experience
• SAP Business Objects 3.x/4.x System Architect (sizing, installing / upgrading, deployment, administration)
• SAP BI/Business Objects Development (Crystal Reports, Web Intelligence, OLAP, SAP Dashboards/ Confidential )
• Predictive Analytics Development (SAS 9.x Mining; currently learning SAP Predictive Analytics/R/HANA toolset)
• Data Warehouse Design & Development - firm grasp of DW principles ( Confidential )
• Data Integration / ETL Development (SAP Data Services, Talend Open Studio & MS SSIS)
• Database Programming & Application Integration (SQL, PL/SQL, T-SQL, MDX, Java and others)
• Will designs, integrates and deploys business intelligence solutions including reports, dashboards, OLAP cubes, prediction models and a variety of other decision support tools for Confidential ’s clients. He also designs and develops extract-transform-load (ETL) solutions for moving data from disparate corporate databases into repositories (data warehouses/data marts) that serve as a platform for building intelligent solutions or that complement existing corporate data stores.
• Other equally important services Will offers include system implementations, database programming/administration and application integration. Considering that the business intelligence development cycle is iterative in nature, Will believes in employing a project management-based approach to developing solutions spanning discover, define, design, develop and deploy phases. In addition to providing consulting services, Will continues to serve as a technical trainer on Business Objects and other BI software.

TECHNICAL SKILLS:

BI Applications: - SAP BusinessObjects BI Platform (Enterprise) XI/3.x/4.x, Crystal Reports v. 6 - 2011,, Web Intelligence 5.x/6.x/XI/3.x/4.x, Universe Design, Information Design Tool, SAP Dashboards ( Confidential ), Data Services (Data Integrator), LiveOffice, Query as a Web Service (QaaWs), Voyager / Analysis for Office, BusinessObjects Design Studio, SQL Server (database, SSAS, SSIS, SSRS), Talend Open Studio, Talend Integration Suite, Oracle RDBMS (8i-10g), Visual Studio .NET, SAS 9.1 Enterprise Miner; Antivia s XWIS 2.5, Centigon s GMAPS 3.0

Business Applications: - Lawson, SAP ERP (ECC), SAP NetWeaver Confidential, Maximo, Oracle Financials, Oracle CC&B, Confidential Call Center

Applications; platforms: - Linux, Windows;, AIX; programming - SQL, PL/SQL, T-SQL, MDX, Java, VB.NET

PROFESSIONAL EXPERIENCE:

BI Consultant

Confidential, New York, NY

Responsibilities:

• Architected solutions to expand scope and functionality of existing reporting functionality within the clients’ billing platform, to address growth and new reporting requirements
• As an outside consultant, worked with a client team and the billing platform vendor to modify and enhance thirteen (13) key billing reports and dashboards running on Crystal Reports 2011 & SAP Dashboards ( Confidential ) respectively
• Analytics are dynamically fed with XML datasets within the ASP.NET application and served within client portals

BI Developer

Confidential, Atlanta, GA

Responsibilities:

• Developing complex, embedded XML-data driven Crystal Reports 2011 forms & Confidential dashboards for four new clients who purchased Confidential ’s flagship product, Confidential, an Employee Benefits Administration System ( Confidential, Confidential & Confidential and Confidential )
• Analytics are dynamically fed with XML datasets within the ASP.NET application and served within client portals

Attendee

Confidential, Las Vegas, NV

Responsibilities:

• Familiarized and reinforced knowledgebase of SAP BI 4.0 Product Stack
• Best practices on how to integrate all BOBJ tools with SAP Confidential - SAP Dashboards, Web Intelligence & Crystal Reports against SAP Confidential (using BEx queries containing a variety of elements such as hierarchies, variables, delegated measures, structures, and calculations, Infocubes and InfoProviders); tweak APS / AJS, use Confidential connections…
• How to set up granular monitoring of BI 4.0 Platform using metrics, probes, and watches on all servers
• How to leverage the new Information Design Tool to build UNX universes for SAP and non-SAP systems
• New features in SAP BI 4.0 Service Pack 4, BusinessObjects Design Studio

Lead BI Architect

Confidential, Marietta, GA

Responsibilities:

• SAP BusinessObjects Business Intelligence Platform: Upgrade, Management & BI Apps Development
• Sizing, upgrading, deploying, configuring and maintaining SAP Business Objects 3.1 to 4.0 Business Intelligence Platform for corporate (internal) and external clients; system migrated from AIX/Windows to Linux in 4.0; sized system based on SAPs and split up APS AJS servers for performance
• Developed Universes and Business Views to serve as the data sources for complex reports using Crystal Reports and Web Intelligence, across a wide domain of data - accounting, HR, billing, marketing, engineering, call center operations
• Developed strategic and operations dashboards - Payments Dashboard (monitoring 13 payment in-bound payment interfaces), Cashier’s dashboard (enables Payment Center Manager to track activity of 6 clerks in a walk-in/drive thru payment center in near-real time) and assisted colleagues with design and architecture for development of two other dashboards (Member Services, Advanced Meter Infrastructure (AMI) Deployment dashboards)
• Datamart / Data warehouse / OLAP Design & Development
• Contributed significantly in design of and implementation (ETL) of the ADS (Analytical Data Store) data warehouse for reporting & analysis from an Oracle MDM ( Confidential ) system.
• Assisted with datamart / OLAP cube on MS Analysis Services for slicing and dicing Accounts Receivables data - project resulted in savings of $1M by identifying and accelerating AR Bad Debt
• ETL, Data Integration
• Part of a team that re-wrote the Bill Print Extraction Job (over 400 unique fields from the source Oracle CIS System) and the Bill Print XML job (multi-schema highly nested XML file typically containing 25,000 bills per night); included error-handling, job status notification and extensive logging
• Predictive Analysis
• Assisted in design of a solution to forecast likelihood of accounts receivables becoming uncollectible (bad debt), using MS Analysis Services Data Mining component
• SQL, PL/SQL Performance Tuning & Development
• Optimized performance of long-running reports / long-refreshing dashboards using a number of techniques including - Oracle Analytic functions, bind variables, collections (bulk inserts / updates), merge / append statements (instead of straight inserts), using parallel execution, global temp tables…

BI Architect / Developer

Confidential, Atlanta, GA

Responsibilities:

• Part of a team that built the Quality Assurance tactical dashboard (using Confidential / SAP Dashboards) for tracking critical business metrics that affected a client’s top (revenue) and bottom (cost) lines;
• Dashboard tracked a number of key revenue streams that were dependent on proper functioning of the customer information system; driver for the dashboard was a failure to run particular batch jobs that resulted in significant revenue losses
• Dashboard tracked inflow of over $1M in company-wide revenue per day
• Developed reports to support delivery of the dashboard and other related requests using Crystal Reports & Web Intelligence
• Designed solution to extend delivery of SAP BusinessObjects 3.0 outside of corporate firewall
• Client needed to a self-serve portal for high-volume residential customers to track consumption and manage invoices;
• Added web server to DMZ, configured firewalls to allow traffic between particular ports and servers, configured Tomcat to receive https traffic from the Internet and modified the look & feel of InfoView / BI Launchpad to suit client’s ps;
• Created publications for automated delivery of personalized content to external clients
• Created a universe to support reporting and dashboarding and implemented row-level security at the Universe level to only show particular data to users

BI Developer

Confidential, Atlanta, GA

Responsibilities:

• Developing complex, embedded XML-data driven Crystal Reports 2011 forms & Confidential dashboards for clients who purchased Confidential ’s Benefits Administration platform ( Confidential, Confidential )
• Analytics are dynamically fed with XML datasets within the ASP.NET application and served within client portals

BI Developer

Confidential, Marietta, GA

Responsibilities:

• Client needed a better management solution than Excel spreadsheets with macros to generate client reports for billing and management; data was being captured in Confidential ’s Call Center application - integrating information from IVRs, ACD & customer information system
• Performed requirements gathering, thoroughly familiarized myself with call center vocabulary and KPIs, and built a universe against a SQL Server database and a number of Web Intelligence documents/reports for reporting. Reports were multi-tab, one per month, with a cumulative annual total.
• Solution significantly alleviated issues related to billing accuracy and timeliness.

Sr. BusinessObjects Consultant / BI Administrator

Confidential, Marietta, GA

Responsibilities:

• Properly sized, upgraded and maintained BusinessObjects XI, XI R2 (upgraded from Crystal Enterprise 10) system for corporate (internal) and external clients; upgraded from Crystal Enterprise 10 to XI; set up Enterprise security model from scratch, connected system to LDAP for authentication, configured load balancing across 3 web servers. Set up auditing functionality, tweaked Activity Universe and configured auditing reports for use
• Created a system to automatically and in near-real-time route and print hundreds of work orders every day using the BusinessObjects servers across a wide campus; solution resulted in a cost-avoidance of over $250K in specialized printing services from IBM
• Developed numerous Universes, and Business Views on top of the new customer information system (CIS) for financial and accounting reporting (using Crystal Reports and Web Intelligence reporting tools)
• Developed dashboards using BusinessObjects Dashboard Builder, Performance Manager & Confidential
• Developed the Marketing Dashboard for tracking of overall customer counts by company and by stage in the customer lifecycle in order manage retention and attrition rates
• An Engineering dashboard to track capital investment project expenditures - used Dashboard Builder and Performance Management tools
• Developed a datamart & accompanying OLAP Cubes (using MS Analysis Services (SSAS) & MS Integration Services (SSIS) 2005) for analyzing company-wide Actuals vs. Budgeted amounts from the Lawson GL system. Cut delay in reporting from 2 months to less than 1 day. Later converted solution
• Delivered a 2-month, slow-paced course to the BI Team on building datamarts / data warehouses on the Microsoft BI Stack using Practical Business Intelligence with SQL Server 2005 by John C. Hancock & R. Toren

Attendee

Confidential, Atlanta, GA

Responsibilities:

• 4-day, intense deep-dive into the Kimball Dimensional modeling techniques including review of common industry dimensional models - billing, utilities, financial services, retail management…

Business Objects Consultant

Confidential, Atlanta, GA

Responsibilities:

• Designed & developed solutions to resolve gaps in reporting, particularly around call center KPIs; assisted with development of particular complex client reports and suggested data integration fixes to resolve technical gaps
• Delivered custom on-site and knowledge-transfer sessions to Confidential ’s BI Team; provided and knowledge-transfer on Crystal Reports, Crystal Analysis (OLAP) and Crystal Enterprise, MS SQL Server development techniques to leverage for better reporting and analysis

Business Objects Consultant

Confidential, Norcross, GA

Responsibilities:

• As a Senior Business Objects Developer, involved in the full lifecycle of Business Objects development including requirements gathering, designing Universes, report creation using Crystal Reports and Web Intelligence, scheduling, testing and assistance with Power User .
• Created complex reports using Crystal Reports XI/10 by consolidating data from disparate operational systems into one concise format based on the needs of Power Users, to reduce the amount of time spent searching for data and to enable information based decision making.
• Involved in the designing and building of Universes and Business Views. Created complex financial reports using queries, slice and dice, drill down, Alerts and formulas.
• Assisted with troubleshooting of SSIS / DTS ETL Jobs that were critical to operation of the Call Center

Attendee

Confidential, New York, NY

Responsibilities:

• 4-day, intense deep-dive into the Kimball Lifecycle Approach, covering all aspects from planning to dimensional modeling to technical and business intelligence architectures, to ETL, deployment, maintenance

BI Consultant

Confidential, Atlanta, GA

Responsibilities:

• Sized, installed, configured Crystal Enterprise v. 10 on Linux for embedded reporting within Proficient Web Analytics platform
• Developed complex reports for Proficient’s clients ( Confidential, Confidential )using Crystal Reports against a MySQL database, leveraging the CE platform for deployment and row-level and column-level security;
• Walked a team of Java developers through the Crystal Enterprise SDK and architected a solution that was developed in Java for logging in (single-sign-on), retrieving and displaying reports from CE on Proficient Analytics’ platform by their customers.

BI Consultant

Confidential, Reston, VA GA

Responsibilities:

• Sized, installed, configured a highly available (HA) and fault-tolerant Crystal Enterprise v. 10 system on 4 Linux servers for corporate reporting; solution entailed configuring multi-homed servers for Crystal Enterprise, working with the Infrastructure team to set up a HA environment for the servers, a load-balanced web tier using Tomcat, a File Repository server in a HA SAN (storage area network)
• Resolved issues with Schedule pages within Crystal Enterprise by modifying CSS properties and deploying client-facing applications
• Provided and knowledge-transfer on Ad-hoc Reporting tool, Live Office and Business Views

BI Trainer & Consultant

Confidential, Miami, FL

Responsibilities:

• Delivered Crystal Enterprise v. 10 and BusinessObjects v. 6.5 boot-camp (accelerated) public sessions
• Delivered all course materials in the Crystal Enterprise, Crystal Reports, Web Intelligence tracks to students in a compressed manner; including hands-on labs and real-world deployment tips and tricks

Business Objects Consultant & Trainer

Confidential, Roswell, GA

Responsibilities:

• Certified BusinessObjects Trainer for Public and On-site Classes
• Delivered over 1,200 hours of instruction on Crystal Enterprise, Crystal Reports, Web Intelligence, Business Views, Live Office, Crystal Analysis (OLAP) and how to use SDK kits to integrate BusinessObjects into existing web portals.

ERP Consultant

Confidential, Atlanta, GA

Responsibilities:

• Part of team that implemented MAXIMO, configured it, populated data in all modules (Inventory Management, Purchasing, Work Order Management, Job Schedules);
• Lead BI Developer responsible for modifying canned reports and creating new reports using Hyperion BRIO
• Converted canned reports to Crystal Reports deployed BI platform and set up delivery / access of reports across all WRCs.
• Part of team that implemented AssetWorks, a facility management system; conducted business process analyses of various units that comprise the university’s Physical Plant Department in order to effectively align the facility management software to the University’s business practices.
• Part of team that implemented MAXIMO, configured it, populated data in all modules and integrated it with the Customer Information System
• Lead BI Developer responsible for modifying and creating new reports and data extracts from MAXIMO to a number of external systems
• Lead BI Developer responsible for all reporting against MAXIMO and Oracle E-Business application using Crystal Reports, Crystal Enterprise against an Oracle 9i database
• Developed complex accounting reports used for reconciliation across both systems; also developed work management tracking reports for maintenance on equipment installed on the taxiways and runways

Project Engineer

Confidential, Roswell, GA

Responsibilities:

• Provided environmental permitting support to petroleum marketing terminals and chemical plants in the analyzing test data and computing emission inventories. In another capacity at the same company, he managed environmental issues relating to water, wastewater, air and hazardous waste generation and disposal
• Analyzed huge amounts of test data to compute emission inventories in support of environmental permitting for petroleum marketing terminals and chemical plants in the South-East US
• Managed environmental issues relating to water, wastewater, air and hazardous waste generation and disposal at a 250-employee chemical facility in South Carolina ( Confidential & Confidential, Confidential )

Database Administrator

Confidential, Clemson, SC

Responsibilities:

• Consolidated and restructured several flat-file databases into an Oracle 7 database for managing the University’s In-House Asbestos Abatement Program
• Developed a front-end application (in VB) for maintaining the database using MS Access