We provide IT Staff Augmentation Services!

Senior Consultant Resume

2.00/5 (Submit Your Rating)

Gainesville, FL

SUMMARY:

  • Around 15+ years of IT experience with around 15+ years of SAP including BI,BW, BPC,, ISU, ETL, ABAP, SEM: BPS/ IP, CPM, BO, BPC, BODS, HANA, S/4, Java, others.
  • Worked as both Project management as well as a Techno - functional professional with cutting edge experience in SAP BI, BPC, BO Design Studio, Lumira, Fiori, with full cycle implementation experience in SAP BI/ BO/BPC, with integration, data load, Reporting with Planning and Consolidation, LSA++ architecture.
  • Worked in leadership roles, including Project Management, Architect and Lead roles. Interacted with business and organized several meetings, workshops with clients to gather requirements and confirm project management plans with PMO’s office.
  • Worked on teams with various management and implementation styles including PMBOK, Sprint/Scrum, ASAP, Waterfall, Agile, RASCI, RUP, and SDLC amongst others.
  • Worked in SAP Labs. & developed ‘0’ namespace Business Content for GRC and Risk Management Industry including SOX audit related workflow reporting.
  • Developed blueprints by interacting with the functional experts, business analysts, management and end users. Strong knowledge of business/process data flow in organizations.
  • Ample exposure to SAP Best Practices and ASAP and Value SAP methodologies.
  • Experience on various end to end processes BW reporting solutions like SRM, PTP, OTC, SCM, MTB, MKT, QM, RTR, MII and Planning and consolidation using BPS/IP/BPC/CPM.
  • Experience in SAP BPC 10, 7.x, 5.x (formerly Outlooksoft) Implementations and Integration.
  • Designed, developed and implemented Corporate Performance Management (CPM) systems.
  • Worked on Foreign Currency Translation, Intercompany eliminations, consolidations, Roll-forward applications including custom SSIS package creation and SQL/Script Logic
  • Expertise in creating InfoObjects, InfoSources, PSA, ODS /DSO, DTP, Update/Transfer/ Transformations, InfoCubes, InfoPackages, Multiproviders, Hierarchies, Remote Cubes, DataMart, Open Hub, business content enhancing using User Exits, start/end Routines.
  • APO CRM COPA FICA FICO HR ISU MM PP PM PS QM SD SCM SRM extractions.
  • Worked on SAP Utilities based CR&B (CRM and Billing), CIR extractions into BW/BI.
  • Worked on BW on HANA modeling, Native HANA reporting and multiple HANA POC.
  • Performed data extraction to reporting tools like Business Objects, BO Universe, Crystal, Cognos, Enterprise Portal, Fiori, Lumira, UI5, Webi, Xcelsius,WFM, Success Fctors .
  • Performed extractions from third party ETL tools from legacy systems such as Trillium, Datastage, Hyperion ESSBase, BO DI DF, Informatica, Flat files, along with DB/UDconnect

TECHNICAL SKILLS:

SAP R/3 &BW/BI Versions: BI 2.x/3.x, 2004s/7.0, R/3 ECC 7.0, 6.0, 5.0, 4.7, 4.6C, 4.5B, 3.1H

Sap functional exposure: CO/PA, CPD, FI/CO, HR, MM, PP, PS, PM, QM, SD, SCM, SRM, WM

SAP New Dim. Exposure: APO, EP/PI, CRM, xMII, SEM/IP, BPC, BASIS

Databases exposure: Oracle 8/9i, MS SQL, MAXDB, HANA, HANA S/4

Modeling tools exposure: ERWIN, VISIO, TogetherSoft, Rational Rose

Languages experience: ABAP, RICEF, XML, Java, C, C++, VB, SQL, MDX

Front end experience: BEX/BO/Crystal/Dashboards/DesignStudio/Fiori/Lumira/UI6/Webi, Cognos, Tableau.

ETL / DW Tools exposure: BO, BODS, BPC, Informatica, Hyperion, Datastage

PROFESSIONAL EXPERIENCE:

Confidential, Gainesville, FL

Senior Consultant

Responsibilities:

  • Confidential is heavily invested in SAP infrastructure and has maturity in traditional SAP ERP implementation. They are in the process of S/4 HANA implementation and migration with emphasis on utilizing all the latest BI tools including Lumira, BOBJ, Design Studio, Embedded BW and BW 7.5 on HANA.
  • Was involved in defining and setup of various SAP BI solutions in association with S/4 HANA implementation and migration of both FI and Logistics modules.
  • Organized several workshop sessions to gather and analyze the requirement in the discovery phase to understand type of users and number of users, data sources, data volume among others to determine the sizing, licensing and backend BI architecture needed to support the overall BI vision.
  • Worked as part of BOBJ implementation including latest SBOP 4.3 platform with Data services for data migration, IDT connection definitions, WEBI and Analysis of Office.
  • Implemented S/4 related RDS and Utilities RDS for HANA studio and configured standard HANA live with smart data access and Fiori views for reports, dashboards via Tableau.
  • Worked on documentation for future in- house reference for Confidential with Sizing, Security and architecture recommendations for anticipated usage.
  • Guided and overlooked Live view implementations for HANA live.
  • Involved in HANA live view browser and defining the HANA live view RDS.
  • Recommended the HANA Sidecar implementation scenarios for extensive analytics.
  • Analytics based on VDM, CDS via Smart Business, Multi- Dimensional and Fiori with UI5.
  • Data migration into other non- SAP databases for EDW using ETL BODS.

Environment: SAP HANA 2.x sp10, Lumira, Fiori, BW 7.5, BOBJ SBOP 4.2 SP03, Dashboards, Tableau, Design Studio 1.6, BODS 4.7, ECC6, S4 1511, MS-SQL server 2014 on Windows 2012R2 x64 on VMware 6.0.

Confidential, New Jersey

Senior Conusltant

Responsibilities:
  • Confidential is invested in SAP core technologies and is on a growth expansion all over the world acquiring companies and integrating SAP systems with several international roll outs including Asia Pacific, Middle East, European among others.
  • As part of these roll outs SAP BI an Analytics also have been on the prime requirements to take stock of happenings all over the world using data from all locations.
  • Contributed as Senior BI consultant both to PMO and as Techno Functional capacity to get all requirements, for given time frame and extrapolating resources required /RICEF(s) to implementation, testing, cutover and post production activities.
  • Worked in analytics for core domains including Finance, MM, SD, Master Data reporting and CRM reporting.
  • Worked with multiple currencies and conversions to and from local to USD and vice versa.
  • Worked in data migration to integrate external data/ systems into SAP core systems.
  • Worked on complete implementation from Discovery, Requirements gatherings, Development, Unit testing, UAT iterations, Cutover, post production and training phases of the project.

Environment: BW 7.5, BOBJ, BODS 4.7, ECC6, CRM 7.5.

Confidential, St. Louis

BO/BI/HANA Senior Consultant

Responsibilities:
  • Confidential is in the process of realigning their BI vison by leveraging their recently implemented HANA solution and in view of the future migration to S/4 HANA..
  • Was involved in the project as part of the PMO team representing Client Confidential in overseeing the contributions made by the CAP Gemini team implementation in association with their own PMO team.
  • Gathered and analyzed the requirement in the discovery phase to understand reports being utilized for reporting needs though manual or good to have processes.
  • Performed data modeling and developed Analytical views for the transactional data, Attribute views for the master data, and the calculation views for several models in HANA Studio.
  • Developed data models through HANA studio for business process streams of RTR, OTC, CTC, RTP which includes domains of Billing, Engineering, Finance, Inventory, Materials, Operations, Production, Plants, Sourcing, Revenue planning, project costs & forecasting.
  • Worked on several Key dashboard views including OTIF - On time in Full, Open Orders, Orders backlog, inventory Stock, ITO- Inventory Turns, DSI- Days Sales of Inventory, Corporate Bowling KPIs, Plant Bowling Material charts, BMT- Buffer Management Tool charts based on total flow time, OTTP- On time to Promise, OTTR- On time to release among other KPI. Worked on Supply Chain RDS views for DP and SNP, project costing, WIP analysis, planned vs actuals, project costs and wbs valuation.
  • Integrated with HANA modelling layer: Lumira Server, Analysis of Office, Lumira Desktop, Fiori KPI modeler, Design Studio, Dashboard, UDT, Webi as part of the tools outreach vison.
  • Guided and overlooked Live view implementations for several RDS packages.
  • Created Universes on top of HANA calculation views on top of Analytical, Attribute, SQL script views and developed the Webi reports and dashboards using IDT and Tableau.
  • Involved working with content models, attributes and measures, hierarchies.
  • Integration with HCM and WFM for analytics around headcount reporting and forecasting.
  • Integration of BPC and Longview with Hana Analytics and Embedded BW.
  • Worked on HANA live view browser and defining the HANA live view RDS and SDA.
  • Installed SAP BI SBOP 4.1 on MS 2012 OS with DB connections to HANA 1.0 SP9, SYBASE and MSSQL-2012 with AD/LDAP for 25 concurrent users with security roles.
  • Part of several cutover activities in Agile implementation structure.

Environment: SAP HANA 1.x sp10, Lumira, Fiori, Tableau, Longview, BOBJ SBOP 4.1, JAVA, Design Studio 1.6, BW 7.5, BPC 10.1, ECC6/SCM7, MS-SQL server 2014.

Confidential, Boise

BW/BO Senior Consultant

Responsibilities:
  • At Confidential after initial implementation of CRM&B transaction system, the next stage was the stabilization period. During this period emphasis was on getting the BW extraction going and having the reporting/ EDW requirements provisioned through several phases.
  • Was involved in Project management WBS sessions to determine resources taken for the BW effort and for determination for the number of phases that were needed for given scope.
  • Was part of several architecture and COE meetings to analyze assess and evaluate various architectural, technical options.
  • Was part of discussions for reporting options including product evaluations like BO, MS Power pivot, HANA, Qlickview, SSIS and middle ware like TIBCO, PI, Informatica, BODS.
  • Involved in creation of BW COE team, defining process workflows of documentation, design, code review, data loading, and transports approval for iterative development mode.
  • Helped adding on new definitions in the naming convention standards.
  • Involved in end to end CRM&B BW content (0UC* ) for reporting and EDW needs as part of multiphase agile activities including development, unit testing, end to end testing, cutover implementation and post production support as per SLA.
  • Part of three successful go live projects for various business process streams of CTC, RTR which includes domains of DM (Device Management), Billing,(CS) Customer service and FICA (Contract accounts Receivable and payable).
  • Performance tuning and archiving as per the IT strategy of long term maintenance support.
  • Part of several brainstorming sessions and stand-up meetings with Business Analysts, Developers, Architects, Leads, DBA’s, Sponsors from Management and other team members.
  • Review of other daily support activities- as part of stabilization of the systems.
  • Performed extractor enhancements using ABAP coding and BW modeling.
  • Involved in the upgrade roadmap and POC for BW on HANA Gathered and analyzed the requirement to replicate the desired ECC content in HANA using data provisioning.
  • Worked on Technical specifications and standard modeling documents for HANA.
  • Performed data modeling and developed Analytical views for the transactional data, Attribute views for the master data, and the calculation views along with SQL scripting as final models.
  • Developed data models for Billing, Installation tables in HANA.
  • Worked on SAP Net weaver BW 7.4 on HANA to leverage some of the latest features like Advanced DSO, Composite providers among others.
  • Created Universes on top of HANA calculation views and developed the Webi reports and dashboards using IDT (Information design tool)
  • Created HANA modeling scenarios and activities such as adding a system, creating schemas and content models, attributes and measures, calculation views and within BW open/ advanced DSO, composite providers etc.
  • Involved working with content models, attributes and measures, hierarchies.
  • Worked on RDS to implement ETL Replication map
  • Created dashboards with EDW layer and Tableau.
  • Data migration from legacy systems and ECC into HANA using core data services /BODS and BW extractors/ DXC.
  • Provided expertise in the refresh, patch time table and several firefighting issues including support batch jobs, performance issues and security issues.
  • Worked in several ETL extractions through Informatica/ Open Hub for EDW on SQL server.
  • Provided expertise in BO’s reporting tools: WEBI, Analysis for OLAP/Office/Crystal/Visual.

Environment: SAP BI /BW 7.5,BO 4.1, ECC6/CRM7->CR&B, PI7.3, Informatica9.1, SQL2008

Confidential, Detroit

BW/BO Architect IS-Utilities Intermittent consulting

Responsibilities:
  • DTE is undergoing a huge migration and implementation of CR&B from their CIS systems.
  • Gathered and analyzed the requirement to replicate the desired ECC content in HANA.
  • Worked on Technical specifications and standard modeling documents for HANA.
  • Performed data modeling and developed Analytical views for the transactional data, Attribute views for the master data, and the calculation views as final model in HANA Studio.
  • Developed data models for Billing, Installation tables in HANA.
  • Integrated SAP Net weaver BW to Business objects using OLAP for Analysis.
  • Worked in the performance tuning project involving conversion of older Analytical models to models tuned to HANA using new modelling concepts such as open/ advanced DSO, field based modeling option of creating DSO, composite providers with analytic indexes etc.
  • Created Universes on top of HANA calculation views and developed the Webi reports and dashboards using IDT (Information design tool)
  • Created HANA modeling scenarios and activities such as adding a system, creating schemas and content models, attributes and measures, hierarchies.
  • Worked on Utility Industry solution RDS to implement views, queries and SLT replications.
  • Involved in the HANA cloud solution anticipated through 3rd party vendors.
  • Involved in deployment of HANA live Sidecar landscape with BW hybrid scenario.
  • Involved in providing access to the SAP delivered VDM content on HANA live for self-service BI power users.
  • Worked on HANA core live RDS implementation HBA - package and worked on performance tuning of several calculation, analytical and attribute views.
  • Implemented operational reporting across for various business process streams of RTR, CTC, RTP which includes domains of Billing, FICA, Equipment MM, and Installations MD.
  • DTE uses BODS in several jobs across the organization and was in the process of upgrading their BO environment and needed expertise to have a robust and failsafe environment.
  • Worked on BW ISU/ Utilities/ CR&B requirements, development and implementation.
  • Part of the role to provide implementation and upgrade of the BO systems.
  • Cluster implementation of the BI systems for load sharing.
  • Fail safe mode installation for BI system’s continuous operation within two datacenters
  • Defined testing strategy for BO upgraded to 4.x and other existing processes.
  • Data migration into other non- SAP databases for EDW using ETL BODS.
  • Developed BODS ETL for successful execution of large number of records from SAP.
  • Part of BAPI/ RFC development for interfacing data migration from SAP through BODS.
  • Part of the BODS documentation for data extract form SAP/R3 and best practices.
  • Reviewed existing BODS code and provided best practices for BODS documentation.
  • Worked on pre- implementation of the huge CIS/CR&B migration and BW on HANA POC.
  • Established the best modeling and recommended strategies for BOBJ / SAP HANA.
  • Involved in the sandbox implementation of the new 7.5 BW for HANA for Utilities business content. This was done for determination of effort required to quickly convert content tuned towards HANA SP10 using the latest that modelling tools such as Eclipse provided with 7.5.
  • Installed BOBJ 4.0 and BODS 4.0 and configured SAP and Windows AD authentication.
  • Integrated BOBJ 4.0 and BODS 4.0 with SAP HANA1.0.
  • Created Technical specifications and standard modeling documents for HANA.
  • Created web services for querying HANA database from external end user report portal using real time jobs in data services 4.0 designer.

Environment: SAP BW 7.4 & HANA 1.x, BODS/BO 4.1, ECC6/CRM7->CIS/CR&B/ISU, MS-SQL server, Tableau, Oracle.

Confidential, Monterey, Mexico

SAP BI/BO/BPC Upgrade Project Manager

Responsibilities:
  • As part of the North America Confidential group ARCA the Mexico operations partner is in the forefront of SAP implementations and best practices including ECC, SCM, HANA, BI, and was involved in several upgrades implementation projects among others to be upto date.
  • Was part of ex-SAP employee group GOIT’s PMO team managing and leading several ongoing projects across the entire organization primarily IT among others using reporting from BI through PS and CPD/CPM add-on aka Commercial Project Management.
  • Worked on the ECC/SCM/BI/SEM IP/CPM/BPC/BO/HANA migration/upgrades/implementations though mostly remote support through 5 years by being involved in key time- periods during initial and cutover phases of the various projects.
  • Worked in the Eclipse modelling environment to work on BW 7.4 on HANA and worked on new modelling concepts such as open/ advanced / field based DSO, composite providers etc
  • Was the offshore PM /Architect and point of contact with multiple teams in an extremely international environment with multiple literal languages.
  • Involved in implementation and upgrade of BI/BW systems from 3.x to 7.x to BW on HANA
  • Involved in implementation and upgrade of SAP SCM/APO 4.x to 7.x and BPC 7.x to 10.x
  • Involved in implementation and upgrade of ECC 5.x to 6
  • Involved in implementation upgrade and migration of BOXI to BO 4.0/ 4.1, BODS 4.0 to 4.1
  • Involved in implementation upgrade and migration of BW on HANA 1.0 through sp9
  • Part of APD based data ETL for providing data to EDW Oracle system through Open Hub.
  • BW security upgrade from old authorization concept to the new authorization concept.
  • BPC based Reports & Input Schedules - Created dynamic input Schedules and Script logics to call BADI functions for Projects costs (PPM), PoCM revenues and sub-contract revenues.
  • Front end integration with BO, Lumira and UI5 with HANA live browser app.
  • Involved in operational reporting using HANA live SAP delivered content.
  • Worked on key BO/BW reporting and BW on HANA modeling and HANA live as training template through HANA studio for other developers and users of the organization.
  • WorkSAP best practices throughout the project lifecycle and performance benchmarking
  • Formulated a project plan with milestones based on consensus with multiple team activities.
  • Status meetings and updates for the overall project and cutover steps/activities.

Environment: ECC 5.x/6.x APO, CPD, IM, MM, PS, SCM, SD, SRM, QM, WM,, BPC 7.0/ 10.x, BI 3.x/7.x, HANA 1.x, Oracle 10, BO XI/4.x, BODS 4.x

We'd love your feedback!