SUMMARY

• SAP - Certified Solution Consultant in SAP NetWeaver BW.
• Experienced since 2004 in leading technical and functional implementations of SAP BW/BI, including 6 Full Lifecycle Implementations. Experience spans BIW 3.1; NetWeaver 2004s; and BW 7/0. 7.3, and 7.4.
• Proven ability to assemble and lead multidisciplinary teams and engage business counterparts to understand and capture business requirements, communicate project purpose and progress, design and present plans of execution, and present deliverables that include project scope documentation, testing and user verification, technical and functional documentation, user training, and knowledge transfer.
• Skilled in ASAP and AGILE methodologies and able to work in multiple commercial and industrial disciplines including finance, banking, manufacturing, CPG, healthcare, and life sciences.
• Earned reputation for bringing large and complex projects to completion on time and within budget.

TECHNICAL SKILLS

• SAP R/3 (FI, SD, MM, PP, HR, QM) SAP ECC 6.0, CRM, SCM, HCM, IS-Banking, and IS-Healthcare.
• Design, modelling, operation, optimization, and enhancement of InfoCubes, DSOs, ADSOs, Composite Providers, SPO, APDs, Open Hubs, Process Chains, customizing ETL and business content. Experience working with Classification data such as Material and Phrase. Assure use of best practices in custom solutions and optimization of existing designs. Experience with SAP Rapid Deployment Solution for HR.
• Data compression, system monitoring, statistics, dumps analysis, database analysis, early watch report, Solution Manager analysis, transport management, OSS message implementation using SNOTE, Security user/Role analysis, LSA and LSA++ Architecture.
• BW on HANA, modelling HANA views, stored procedures, HANA Indexed views, column and row store storage, database sizing, provisioning using BODS, and memory load and unload parameters.
• Three HANA DB revision upgrades; 2 Oracle DB upgrades; 3 BW upgrades and migrations from BIW 3.5 to NetWeaver 2004s; migration from BW 7.0 to 7.3; migration from BW 7.3 to 7.4; planning and implementing greenfield, sidecar, and hybrid approaches; and database sizing.
• SAP BEx Analyzer, BEx Query Designer, RRI, Currency conversions, Unit conversions, Analysis for Office, Analysis for Olap(Web), Tableau 8.x and 9.x, Dashboards, Design Studio, and Visual Composer 3.0.
• 3.1 - 4.1, Webi, Webi Mobile, Explorer, UDT, IDT, Crystal Reports 2008 - 2011, CMC administration.
• Start, End, and Transformation routines, InfoPackage and DTP routines, Extractor and Variable exits. Optimize code for performance.
• Multiple integration scenarios with SAP and non-SAP applications. Integrated MS Dynamics CRM with BW and integration and support of external Databases such as SQL Server, PostGre, JDA, and SAS. Supported BW models for BPC consolidation and Planning, BI-IP Planning, SAP PI, experience with third party schedulers such as Control-M and Redwood. Supported SAP instances on cloud such as SAP HEC and Amazon AWS.

PROFESSIONAL EXPERIENCE

Confidential - Cummings, GA

SAP BW Consultant & Architect

Environment: SAP ECC 6.0, SAP HCM, SAP BW 7.30, BW 7.40, SAP HEC, AWS, BEx, BO WebI (3.1 & 4.0 SP5), Webi Mobile Reporting (for iPhone, iPad, Android), Design Studio (Desktop & iPad), Explorer (for iPad) BO UDT, BO IDT, Crystal Reports (Enterprise, 2008, 2011) ACS Service Center, MS-SQL Server 2010, JDA, Tableau, SaaS.

Responsibilities:

• Over 2 years, co-led a major upgrade from BW 3.5 to 7.3 on HANA, participating in planning, design, testing and deployment of a hybrid greenfield-sidecar approach. Sized the database for migration in collaboration with SAP architects. The multi phased project required migration of 3.x data flows to 7.3
• Also supported the production system and various reporting applications on a regular basis.
• Enhanced the custom solution for Point of Sale (POS) and expanded the scope to include a dozen major customers from across the globe. Expanded reporting to include interfaces like WebI, Dashboards, Design studio, Tableau and BO Explorer. Migrated most InfoSets and MultiProviders to Composite Providers. Utilized HANA indexed views on a BEx query as source for Tableau TDEs.
• Designed and implemented Reporting solution to Map the complement Sales Document flow which included Sales, Delivery, Billing, Shipping and Shipping Cost Documents for the Sales and Distribution team.
• Supported a BPC implementation, which was on a different landscape with the necessary BW models. Implemented SPOs for easy maintenance and performance.
• For Purchasing, implemented Material Price Variance (MPV) reporting in BW to bring in forecast values from ECC. Enhanced the Purchasing cube to bring in Accounting Document fields from FI-GL to enable reporting on Indirect Purchasing.
• To manage FIFRA compliance, the company had implemented Managing Procedure & Policy Performance (MP3) using the HCM tables. Designed and implemented Custom DataSources for BW and handled M-M modeling scenarios in BW.
• Also for HR implemented RDS for HR to refresh the reporting solution with newer dashboards and self service tools for managers and HR personnel.
• Supported a move of payroll functions from SAP HR to ADP. Enhanced the supporting BW data structures and flow to get updated data feeds from ADP. Ensured that the new BW design and reporting was scalable without too much change management.
• Archive data from BW to NLS for as part of the Data Archival & Retrieval (DART) project which saved close to 25% DB space.

Confidential

Environment: SAP ECC 6.0, SAP-EH&S, SAP BW 7.01, BEx Query Designer, BEx Analyzer, BO WebI (3.1 & 4.0), BO Universe Designer, HP Quality Center, MS-SQL Server 2010.

Responsibilities:

• Implemented the pilot phase of SAP-BW for EH&S with emphasis on incident management, industrial hygiene and occupational health. Involved in all aspects of development, testing, delivery and support.
• Implemented EH&S classification master data to extract the data into BW using function modules.
• Architected logical designs and star schemas for MS-SSIS for data coming from MS Dynamics CRM for their warranty, rebate and site registration processes. Provided sales order and revenue information through Open Hub for SSIS.
• Alert monitoring was implemented for process chains. Information broadcasting was setup using BEx broadcaster for workbooks using pre-calculation server.

Confidential

Environment: SAP ECC 5.0, SAP ECC 6.0,SAP BW 7.1, SAP BObj, BEx Query Designer, Redwood, Data Stage, BEx Analyzer, BO WebI, Crystal Xcelcius, HP Quality Center.

Responsibilities:

• Implemented EDW architecture for scalability to manage multiple source systems
• Used Data Stage to manage data from legacy systems and also to manage flat file master data loads.
• Utilized PI capabilities to push the data to external system “PROS” in XML format.
• Managed high-volume data loads and set up BWA indexes for optimal reporting performance.
• Maintained processes and cookbooks for transports and user security.
• Documented support playbooks and managed knowledge sessions and coordinated offshore resources in managing project schedules and deadlines.

Confidential

SAP BW Consultant & Architect

Environment: SAP 4.7, BI 7.0, Hyperion, BEx Query Designer, BEx Analyzer

Responsibilities:

• Created custom query template for balance sheet & Income statement reporting for Hyperion conversion. Reporting was done across multiple consolidation groups and multiple consolidation item hierarchies.
• Hyperion reports were migrated to BI 7.0, maintaining the same look and feel to minimize the learning curve for users.