PROFESSIONAL SUMMARY:

• Business Intelligence Developer for 19 years working with HANA, SAP, BW and BusinessObjects.
• Lead member of BI projects providing management, data modeling, system architecture, report development, ETL development, system upgrades and server maintenance.

TECHNICAL SKILLS:

SAP: HANA, BW/4HANA, SAC Analytics, BW 7.5. BEx Analyzer, SDI, ABAP, HANA Development Studio. AFS, FMS, IS - Retail, SolutionManager, BASIS functionality.

BusinessObjects: Web Intelligence, Universe Designer, Crystal Reports, CMC, CCM

Database platforms: HANA, Oracle, SQL Server, IBM db2 / iSeries

Development: SQL, Cognos, PL/SQL, T-SQL, ABAP, asp.NET, VB, C++

Management: Resource procurement, Project Lead, Team Lead, capital and operational expense management, personnel development.

PROFESSIONAL EXPERIENCE:

SAP HANA Developer

Confidential, Cincinnati, Ohio

Responsibilities:

• Creation of data models in HANA Development Studio to support new reports being created for S/4 implementation.
• Engaging business to document requirements for existing reports for transition to SAC Analytics
• New report development in SAC Analytics
• Maintaining legacy SQL Server environment. Included SSIS packages, stored procedures and monitoring of job schedules in SQL Server Management Studio.
• Support of legacy reports in Cognos
• Ensuring real time data replication through HANA SDI tasks. Troubleshooting various replication issues
• Consistent utilization of SAP support for best practices and error resolution with SAP functions

Lead Developer

Confidential

Responsibilities:

• Utilized all functions of BW environment: Modeled and Developed DataStore Objects, InfoCubes, MultiProviders, OpenHubs, Analysis Process Designer, Process Chains, ABAP programs, BEx.
• Experience with BASIS functionality: System upgrades and restores, security and administration. Troubleshooting database, application and performance issues
• Participated in upgrade to SAP HANA, and conversion to SAP BW/4HANA
• HANA: Calculation Views, Analytical Views
• Oversaw entire data delivery functionality of BW system, included over 200 flat files delivered to other systems (internal and 3rd party)
• Vast ABAP development experience with programs, methods, start/end/expert routines
• Enhanced standard SAP extractors and created custom extractors. Pulling data from multiple SAP systems into singular BW system.
• Developed, assisted and trained users on BEx reports and functionality.
• Developed data retention policies and data archiving processes.

SAP Project Team Lead

Responsibilities:

• Integration and shutdown of external global SAP systems, from countries including: Italy, Peru, Chile, Ecuador, Columbia, Japan, Australia, China.
• The Luxottica FMS1 SAP system is one of the largest global installations, in terms of Site/ProfitCenter count.
• Interviewing and hiring of project consultants
• Created standards and processes to ensure stability and delivery of SLAs
• Participated in large project deployment cut-over planning, led successful go-lives
• Projects were critical to the company and under direct executive-level governance.
• IT financial management of Capital and Operational expenses
• Resource Management and Planning. Procurement of resources for entire team
• Status Reporting for all projects within team

Software Engineer

Confidential

Responsibilities:

• Developed ETL processes to feed systems with data after go-live including creation of InfoCubes, DataStores, DataSources, Transformations, Multiproviders and InfoSources.
• Activated pre-packaged BI content and customized as necessary
• Creation of complex transformations involving extensive ABAP code
• Participated in ongoing data conversion workshops to investigate and map legacy system data to SAP structures

Business Objects Administrator & Developer

Responsibilities:

• Key member of several high visibility successful BI projects as a universe developer, report writer, data modeler, SQL developer
• Responsible for all administrative tasks for two separate BusinessObjects enterprise deployments with total user base over 1,000. Led and executed effort to consolidate into one environment
• Responsible for all front-end administration via CMC and back-end server admin and installations
• Clustered environment for fail-over redundancy and fault tolerance including splitting Web Application Servers into a separate cluster
• Developed customer-facing portal using SDK development and firewall config
• Upgraded environment from version XIR2 to XIR3.1
• Designed several data marts utilizing modern methods of data warehousing and data modeling
• Continuously developed and maintained large set of universes with complex features including derived tables, contexts, aggregate awareness, and fan/chasm trap resolution
• Created complex SQL code to load data into tables, views, materialized views
• Supported end-users with report consultation and resolving issues related to data quality and query performance

Associate II Consultant

Confidential

Responsibilities:

• Member of Business Intelligence team providing report development and support to end-users
• Participated in full SDLC and provided monthly releases of enhanced and new Business Objects universes.
• Led large report automation effort and conversion from Desktop Intelligence to Web Intelligence
• Participated in data modeling and design efforts for several BI projects
• Member of local BusinessObjects User Group, meeting regularly and provided content for quarterly meetings