SUMMARY:

• Experienced Sap Business Warehouse and HANA development lead with a demonstrated history of working in the Retail and and Defense industries. Skilled in SAP NetWeaver Business Warehouse (SAP BW), SAP BI, SAP HANA, BOBJ, Box, Qlik Sense, SAP ERP, Visual Basic, and Analysis. Strong data modeling professional with a Bachelor of Science (BS) focused in Information Management and Technology from Syracuse University.

TECHNICAL SKILLS:

Office Applications: Microsoft (Word, Excel, Access, Visio, Project, Outlook), ITSM Remedy, IBM Rational Suite

Languages: ABAP, SQL, HTML, Visual Basic, JAVA

Enterprise Applications: SAP BW 3.x & 7.x, SAP ECC (R/3), SAP BW on HANA, HANA Studio, Qlik Sense, Business Objects (BOBJ), BW BEX Analyzer, Web Intelligence, BP

PROFESSIONAL EXPERIENCE:

Confidential

SENIOR SAP BW SYSTEM LEAD AND ARCHITECT

Responsibilities:

• Responsible for Production Support of the entire BW landscape for all Functional Areas including SD, MM, EPM, FI, PL, CRM amongst others.
• Lead architect and developer for many large modeling projects.
• Perform data analysis and design on many complex build projects and solutions to existing system issues.
• Head testing and implementation of BW systems and servers migrating to IBM Cloud.
• Lead off - shore and on-shore resources in large technical projects.
• Work directly with Business Users to develop new queries and Qlik Sense dashboards for high level executives.
• Work directly with EDI and XI team to develop data flows and load files into BW system.
• Expertly and efficiently Redesigned all existing Process chains to be more efficient and cut load time to reach service level agreement.
• Develop and Maintain BPS/BPC processes and real-time infocubes.
• Create and Modify Authorization objects and Security Roles.
• Configure server and IDOC settings for ECC and BW.
• Create and Modify Currency Keys in ECC and BW.
• Work directly with Business Users to develop new reports and functionalities for high level executives.
• Work directly with EDI and XI team to develop data flows and load files into BW system.
• Maintain strong relationship with Functional Analysts and Cross Functional teams to develop and interpret requirements for the business.
• Analyze Database table discrepancies and identify solutions and implement them.
• Work with complex business requirements including proposing end to end architectural solutions to the business and functional analysts.
• Trouble shoot complex reporting inconsistencies reported by users.
• Identify corrupted indexes in ECC and repair them to improve extraction.
• Develop Aggregates to make reports run faster and more efficient.
• Develop enhancements for all Functional areas including customization of standard business content and creation of generic datasources, integrating the data flows into the process chains, and creating/modifying BEX reports and implementing Macros.
• Develop complex Decision Tree based Process chains including Event Triggers, Infospokes, and very specific time driven criteria.
• Lead effort to purge historical data from both ECC and BW.
• Writing ABAP Start Routine/End Routines/Expert Routines to perform look ups and manipulate complex loads.
• Perform some Basis Functions such as set up RFC Connections between several environments and trouble shoot all issues involved.
• Supporting new regional Go-Lives including building custom functionality as well as helping train the new users.
• Train on HANA solutions including Open ODS Views, Smart Data Access, Design Studio, Analytic Manager, Analysis Process and others.
• Train on Hadoop system development as well as data science (Python)

Confidential

SENIOR SAP BW on HANA SYSTEM FI LEAD

Responsibilities:

• Responsible for Production Support of the entire BW landscape for Financial area.
• Part of team responsible for converting BW data flows to BW on HANA
• Experience working on HANA Enterprise Modelling including Analytical Views, Calculation Views, Attribute Views, CE functions, and SQL scripting.
• Work with HANA Optimized DSO's, HANA Optimized InfoCubes, Composite, Transient, Hybrid Providers, Publishing HANA Model in BW, and Importing SAP BW Model to HANA.
• Experience inAnalysis, Design, Development, Implementation, Deploymentand maintenance ofBusiness Intelligence applications including Universe Designer, Desktop Intelligence, Web Intelligence, Info View.
• Resolve production support tickets related to process chain load failures as well as user BEX report issues.
• Develop enhancements for Financial area involving customization of standard business content and creation of generic datasources, integrating the data flows into the process chains, and creating/modifying BEX reports.
• Maintaining all documentation including functional/technical specs for all objects in the landscape.
• Providing technical guidance to more junior members of the team.
• Constantly interfacing with users and the Super User community regarding prioritization and requirement gathering.

Confidential

SENIOR SAP BW 7.0 DEVELOPER

Responsibilities:

• Heavily involved in the full life cycle for both functional and technical upgrades/enhancements to the system
• Resolve critical production tickets in the BW area.
• Provide time and effort estimates followed by completing all enhancements for BW.
• Led BW Nearlining Effort(SAND/Informatica) .
• Interact, gain and analyze requirements, and ensuring customer service with users and process owners using superb oral communication skills
• Troubleshot SID Generation limit issue where most of Financial area needed to be remodeled within a week
• Responsible for all Financial Process Area (AR/AP/GL/COPA/AA/SL), Application 13 Logistics Extractor.
• Gather user requirements and generate functional and technical specs.
• Mentoring Junior BW members to strengthen their technical expertise.
• Monitor the Nightly BW Data Loads.
• Working on Performance tuning to optimize both the data load time as well as the query run times.
• Constantly developing new generic and standard datasources, Infoobjects, DSOs, Infocubes, Infosets, Open Hubs, Process Chains, BEx Reports to satisfy various requirements.
• Often working on many parallel projects that require prioritization and time management.
• Created and modified Gold Standard Documentation for several types of projects and structures
• Technical and Mapping Documents
• Function Specifications
• Data Flow Diagrams

Confidential

UPGRADE DEVELOPER/TESTER

Responsibilities:

• Responsible for ad hoc development requests as well as fixed defects in 3.5 BW environments to help get the client upgraded from BW 3.5 to BW 7.4 environment.
• Developed new 7.4 functionality such as Transformations and DTP’s to replace old objects.
• Performed data loads for master data and transactional data using process chains.
• Created and modified process chains to optimize the data loads.
• Resolved data related defects that came out of business testing.
• Developed SAND/Informatica Data Archiving process and was responsible for Nearlining/Archiving several Terabytes from BW system

Confidential

PRODUCTION SUPPORT ANALYST/SAP BW 3.5 DEVELOPER

Responsibilities:

• Part of the team responsible for 24/7 monitoring of the system from both technical and data integrity perspectives
• Monitored and ran the Production BW Load Network by monitoring various batch jobs and data loads as well as implementing fixes for failures, handling user and system locks, and ensuring a smooth completion of all scheduled processes.
• Trained other team members to monitor data loads and served as POC for nights and weekends for failure support.
• Handled and supported all client production problems and tickets, questions, and requests in the SAP BW 3.x environment.
• Was responsible for data loads for master data and transactional data.
• Implemented development enhancements and transported them to Production including Infoobjects, ODS Objects, Info-Cubes, Multi-Providers, Update Rules, and Transfer rules.
• Maintained and updated documentation of the BW landscape.
• Modified Front End BEx reports based on specifications from the client users.