SUMMARY:

• Strong Leadership, leading 5 track leads and 29 team members onsite and offshore
• Experience within life sciences and Sarbanes Oxley/ISO 9000 regulated environments.
• Extensive SAP HANA/BW and Business Intelligence experience in multiple implementations and production support roles.
• Strong project management experience, Gantt Chart, PERT/CPM and Scrum/Agile Methodologies
• Advanced project risk management skills utilizing qualitative and quantitative risk assessment techniques, project crashing and fast tracking. Probabilities & Impact and Decision trees
• Excellent analytical and problem solving, written, verbal communication and presentation skills.
• Superior business analytics and quantitative analysis techniques, including Linear and Multiple Regression Analysis, Pearson Correlation, ANOVA, Testing Hypothesis and linear programming.
• Understanding of Big Data emerging technologies, Blockchain, Data Science, Machine Learning, Data Analytics Data Governance, and Data Democratization.

TECHNICAL SKILLS:

Enterprise Resource Planning: SAP ECC6.0, R3 (PP, MM, SD, FI/CO, HR)

Data Warehousing: ETL

SAP BW 2.X, 3.X, BI 7.X, BW/4HANA: SAP SLT, SAP Data Service (BODS)

Reporting: Business Explorer Browser/Analyzer, BOBI 4.0, 4.1, Cognos 10.

Project Management: Microsoft Project /Clarity Work Bench/Smartsheet/Asana

Software Testing Modeling: QTP 8.0, Mercury 9.0, Panaya, Oracle SQL Developer, VISIO

Object Oriented Analysis: UML, Rational Rose, MS VISIO

Database Management Methodologies: SAP BW/HANA,SAP HANA 1.0 SP12, Oracle SQL, Microsoft SQL ASAP, LSA, LSA++, Waterfall, Agile (Scrum/ KANBAN), Advanced Excel Data Analysis, SPSS, Minitab, Python.

WORK HISTORY:

Confidential

Manager - SAP OPERSTIONS & SUPPORT

Responsibilities:

• Overseeing the delivery of Application Managed Service (AMS) in support of the SAP application.
• Lead a team of 29 members, 5 Onsite track leads and 24 offshore professionals within one of the top 5 biggest databases in the world.
• Run the support operation in the SAP BW, HANA, BOBI Reporting, BODS and Confidential DataStage / Infosphere.
• Review and manage the creation and investigation of Root Cause Analysis and Problem Management cases.
• Manage and articulate high priority bridge calls to troubleshoot severe and high priority incidents with track leads, BASIS, Network and LINUX administrators.
• Conduct and lead daily operations’ meeting with onsite/ offshore members and weekly management reporting meetings with key executives.
• Achieved significant reduction of high priority incidents and user service requests.
• Acted as a data steward in Data Governance teams and helped clients in forming data governance/Data quality teams (data custodians and data stewards).
• Participate in month-end, quarter-end, and year-end closing and ensure the quality and availability of the data.
• Prepare and review project plans to determine time frame, funding limitations, procedures for accomplishing project, staffing requirements, and allotment of available resources to various phases of the project.
• Plan and prepare the initial Work break down structure and project schedule.
• Direct and coordinate activities of project personnel to ensure that project progress is on schedule and within prescribed budget.
• Review status reports prepared by project personnel and modify schedules or plans as needed.
• Prepares project reports for management, client, or others.
• Confer with project personnel to provide technical advice and to resolve problems
• Interact with stakeholders and project’s owner to identify, approve and release of user stories/backlogs.
• Decide and prioritize the approved sprints.
• Conduct daily scrum meeting with onsite/offshore teams to identify setbacks and mitigate the risk.
• Monitor the progress of the project with burn down chart and identify burn down velocity.
• Project the project completion date and compare it with the completion target date.
• Report progress to the client’s management and obtain required approvals.
• Lead change management meeting and prepared change requests for Change Advisory Boards meeting.
• Lead Risk and Issues meeting, to identify and prioritize risk.

Confidential

Team Lead - SAP BW/ HANA ANALYTICS

Responsibilities:

• Strong team lead experience, leading 12 team members onsite and offshore.
• Conducted workshops and brain storming sessions to gather user requirements and translate it into technical specifications.
• Worked with project personnel, product owners to identify products backlog.
• Conducted brain storming sessions and workshops to identify and the approved sprints.
• Create the work break down structure and project schedule.
• Analyzed and documented relevant business processes, worked with the team to create blueprints for HANA implementation. Carried out interviews with customers to define requirements.
• Engaged in all relevant change management activities, where needed.
• Facilitated large-group projects’ related brainstorming sessions, organized and ran conference room meetings.
• Defined, documented and reviewed functional requirements.
• Led the detailed design and configuration phase and conducted gap analysis.
• Managed training classes, including train-the trainer, one-on-one or classroom style training.
• Reviewed end user documentation, training materials, curriculum and schedule

Confidential

Senior Consultant / SAP HANA/BW

Responsibilities:

• Provided engagement management and selected appropriate methodologies.
• Worked with systems’ analysts, developers and cross-functional project team members to accomplish development activities that include logical and physical data models, technical contents of reports, proposals and solution implementations leveraging BI design principles, reports/dashboards design, development, testing and deployment.
• Assisted in proposal development and acted as a liaison/business process expert to assure successful implementation.
• Created solution roadmap, addressed short and long-term organizational needs.
• Managed training classes, including train-the trainer, one-on-one or classrooms.
• Reviewed design documents, functional and technical specification, provided direction to analysts and developers.
• Designed data models; defined required HANA Views, virtual models and necessary objects for the implementation.
• Worked hands-on in developing and customizing objects to leverage BI solutions and resolve integration issues.
• Created and maintained schemas and relational tables in HANA database.
• Examined data in source systems for inconsistencies, reviewed transformation logic and proposed corrective alternatives.
• Interviewed client’s users and supplied requirements’ specifications, blue prints and system design specifications.
• Updated design history files and drafted training manuals.
• Remotely managed resources in USA, Canada and Overseas.

Confidential

Sr. BI Architect, SAP PRACTICE

Responsibilities:

• Evaluated SAP BW architecture and provided feedback to the implementation team to facilitate the integration of Cognos 8 with SAP BW and ensured optimum performance.
• Evaluated variety of DataSources and advised on model tuning to ensure compatibility and leveraging SAP BW models.
• Contributed to system performance tuning and advised on solutions that reduced processing time by 95% on 60% of the reports.
• Worked with BASIS and Security teams to insure proper migration between environments. Supported new upgrades and software patching.
• Worked with internal and external team members and guided implementation and solution design.
• Modified and created new MultiProviders to match report requirements by including new InfoProviders.
• Enhanced InfoCubes based on user requirements.
• Evaluated and modified BEx queries to utilize proper design for overall successful implementation and advised the modelers and developers of solutions for arising problems.
• Researched implementation setbacks including analysis of user requirements and provided feedback to implementation teams to achieve feasible solutions.
• Worked with the implementation teams and supported building and testing variety of Cognos Frame Work Manager’s models, Cognos reports and dashboards

Confidential

Sr. SAP BW ANALYST/DEVELOPER

Responsibilities:

• Worked extensively in Data modeling, Extraction, Reporting, Process Chains, Monitored and scheduled data loads.
• Created structures, formulas in BEx reports and extensively used Cal KF and RKF in info-provider level to improve COPA Cube and Net Sales report performance.
• Teamed up with R/3 developers to create Star Schema and data model for field sales force master data and constructed BEx report to provide sales data by Sales Rep., Product Line and Sold-to Party.
• Developed a Forecast Accuracy report using MAPE (Mean Average Percentage Error) formula by comparing monthly forecasted data with actual sales on a three-month basis.
• Designed data model and report for Manufacturing Strategy Accuracy project to meet the customer requirements by extracting data from custom defined tables in R/3.
• Remotely monitored process chains to ensure successful data loads and fix load errors.
• Documented URS/SRS/SDS and DHF on the vault Lotus Notes database.
• Extracted data from SD, MM, and PP modules of SAP R/3 and from flat files into SAP BW using Generic Extraction, LIS structures, COPA and LO data extraction techniques.
• Worked with BASIS team to ensure proper transports between environments and maintained routine deletion of PSA data in Development and Sandbox environments
• Used inclusion/exclusion to filter on single value and range of characteristics.
• Created a custom Revenue report to be used as a revenue monitor for the construction of the SEM management cockpit and dashboard. Built a Reconciliation Report that compared sales data with GL entries.
• Monitored, loaded and used BW statistics cubes to obtain necessary data for troubleshooting.
• Built COPA Model with additional Cubes to separate legacy data from R/3 data.
• Built a multi-provider to enable more logical partitioning.
• Enhanced COPA MultiProviders by adding new time characteristics for specific change management.
• Configured and delivered InfoCubes and ODS’s reporting objects for business end-users.
• Activated Business Content and enhanced InfoCubes with delivered / custom InfoObjects.
• Improved InfoProviders performance through aggregates and MultiProviders.
• Created Transfer/Update Rules, Formulas and routines to translate business processes into end reporting objects.
• Extracted data from SD, MM, and PP modules of SAP R/3 and from flat files into SAP BW using Generic Extraction, LIS structures, COPA and LO data extraction techniques.
• Extensively used BEx analyzer, created queries with variables, exceptions, conditions and used RRI feature to jump between the queries to analyze the data