SUMMARY

• Highly motivated International professional, certified SAP HANA data modeling with extensive experience in SAP BW / BOBJ life cycle development, BI application design, and data warehousing modeling for global clients.
• Define requirements and prepare detailed technical specifications to ensure solutions meet business and user needs. Supervise and collaborate with on - and off-shore development and technical teams; coordinate task delivery and quality.

AREAS OF EXPERTISE:

• Business Requirements Gathering
• Data Warehouse Design / Development
• Project leading Onshore / Offshore
• Software Development Life Cycle
• ETL Data Source & Target Mapping
• BI Applications / Reporting Dashboards
• Technical Specifications Development
• Implementation / Deployment / Upgrades
• Troubleshooting & Problem Resolution

TECHNICAL SKILLS

Platforms: Windows, Microsoft SQL Server, Oracle

Applications / Tools: SAP BW 7.0 / 7.4, HANA, SAP HANA Studio, SAP BusinessObjects Business Intelligence (BI) BOBJ 3 / 4, Universe Design Tool, Webi, Design Studio, Analysis for OLAP / Office, Lumira), BEx Query Designer / Analyzer, BPC, SAP ECC CRM & ISU, Teradata, Informatica, Word, Excel, PowerPoint, Visio

Languages: ABAP, SQL, HANA SQL script, PL SQL, Transact SQL, ASP.NET, Java, UML

PROFESSIONAL EXPERIENCE

Confidential, Cranberry, PA

SAP BW BOBJ Technical Lead

Environment: SAP BW 7.4, ABAP, BEx Query Designer, SAP BOBJ 4.1 (BICS, Webi, Analysis for OLAP / Office, Lumira), ECC, CRM, Word, Visio, PowerPoint, SQL

Responsibilities:

• Successfully designed and implemented data flows for Customer Relationship Management (CRM), Sales and Distribution (SD), Project Systems (PS), Quality (QM), Plant Maintenance (PM), Environment Health and Safety EHS.
• Managed the development team activity and coached resources for the implementation of optimal reporting applications with SAP tools. Prepare and drove the steering comities;
• Developed tens of complex reports and dashboards run by thousands of users worldwide.
• Wrote sophisticated queries for tracking KPIs of Sales Analytics, Projects financial performance, Finance, Controlling, Plant Maintenance, Quality Notifications, Nuclear Safety.
• Fully installed Business content for the newly acquired SAP modules.
• Implemented end to end data flows for areas without delivered SAP content; with file interfaces and function modules based extractors.
• Successfully collaborated with the basis team for the platform migration to SAP BW 7.4 and SAP HANA.
• Developed HANA data model and data flow for Quality Management reporting.
• Oversaw integration testing and support users for acceptance test

Confidential

SAP BW BO & ETL Consultant

Environment: Windows, SAP Business Warehouse (BW) 7.0 / 7.3, SAP BusinessObjects Business Intelligence (BI), SAP CRM, BEx Query Designer / Analyzer, BOBJ 3 / 4 (Universe Design Tool, Webi, Analysis Edition for OLAP), Word, Excel, PowerPoint, ABAP, SQL

Responsibilities:

• Confidential International, Global IT System Data Warehouse / BOBJ Reports Implementation: Collaborated with team members and source system SMEs for implementation of SAP 7.0 and BOBJ 3.1 solutions, as well as upgrades to SAP 7.3 and BOBJ 4.
• Successfully designed and implemented reporting application allowing global analysts to track KPIs of Sales opportunities, Marketing campaigns, and Project System.
• Lead reporting efforts through all stages including Blueprinting, Realization, Cutover, Go-Live, and Post Go-Live. Managed and coached team members onshore and offshore.
• Performed requirements analysis, developed technical scenarios and specifications, assessed workloads, led design workshops, designed BI data model, and wrote technical documentation.
• Implemented complex extractors including function modules.
• Created process chains, wrote queries with complex logic, and promoted transport requests between platforms.
• Advised on solutions development and report enhancements; reviewed, investigated, and resolved trouble tickets submitted by end-users.
• Electricite De France (EDF) BI / ETL Project: As SAP BW / ETL consultant, provided lifecycle project management for major reporting effort with 300+ stakeholders for France’s leading power and gas supplier serving 30M+ clients.
• Conducted requirements feasibility assessment, led design workshops, coordinated end-to-end testing and data flow QA testing.
• Prepared detailed technical specifications for BW data flows, queries, universes, reports, and Informatica ETL extracts from BW, CRM, and ISU.
• Built BW DataSources, Infoproviders and process chains.
• Developed strategy to automate data quality error handling resulting in reduction of affected rows in ETL area.
• Wrote ABAP codes for customer exits, transformation routines, and data source enhancements.
• Managed implementation of Analyzer Workbooks, BOBJ Universes and Webi reports for 50+ KPIs across service contract quotations, service contracts, sales contracts, complaints, activities, billing, collections, and energy consumption, and CRM.
• Provided on-going user support, troubleshooting, and problem resolution; evaluated and implemented change requests.
• Agence Des Eaux Seine Et Normandie (AESN): Business Intelligence Developer building data warehouse and reporting dashboards for financial aids and payment KPIs for Department of Ecology agency.
• Supervised ETL and BOBJ team activities; coordinated scheduling, reviewed progress, and conducted necessary follow-up.
• Handled requirements gathering; designed and developed data model, developed BO universe and ETL (ODI) data flows, and Webi reports.

Confidential

Business Intelligence Developer

Environment: Windows, SSAS, SAP BusinessObjects, Universe Designer, Desktop Intelligence, Business Intelligence (BI), SQL, Teradata

Responsibilities:

• Caisse D’Epargne (BPCE Group): Charged with designing, developing, and implementing BOI universes and Deski & Webi reports for marketing campaign KPIs for this retail banking and insurance company.
• Crédit Municipal de Paris (CMP): Implemented SSAS for KPI reporting.