Shyam Alok available

Shyam Alok

Consultant - SAP BI/BW SAP BW on HANA

Profileimage by Shyam Alok Consultant - SAP BI/BW SAP BW on HANA from
  • Freelancer in
  • Graduation: not provided
  • Hourly-/Daily rates:
  • Languages: English (Full Professional) | Hindi (Native or Bilingual)
  • Last update: 30.04.2017

Profile Summary: (8.5+ Years of Professional Experience, Valid US Visa: B1/B2)

  • Experience in implementation, support, and enhancement & upgrade and migration project for SAP BI/BW, SAP BI-ABAP.
  • Onsite Lead/Coordinator for SAP BI/BW Implementation Project for over 3.5 Years at Cognizant Philippines
  • Expertise in end to end product/project management with ERP products
  • Experience in managing the client, project management, planning, organizing & leading the project, people development, etc
  • Involved in client relationship management, RFP, SOW, managing SLAs & escalations, liaising between onshore-offshore teams 
  • Technical Skills/Experience:
  • Hands-on experience with the SAP tools like SAP BI/BW, SAP BI ABAP, WEBI, SAP R/3, SAP BeX,
  • Have overview understanding of SAP BPC, SAP HANA, SAP BODS
  • Involved in full life cycle implementations.
  • Involved in Pre-study Analysis, detailed analysis & estimation, Design, development/implementation of BW/BI objects as per business requirements.
  • Domain Knowledge of Logistics & Supply Chain Solutions
  • Certifications & Trainings:
  • SAP Certified - SAP Business Warehouse powered by SAP HANA (Open.SAP.Com)
  • SAP Certified - Extending SAP Products with SAP HANA Cloud Platform (Open.SAP.Com)
  • SAP Certified - BI Clients and Applications on SAP HANA (Open.SAP.Com)
  • SAP Certified - OGSD 7.0 – An Introduction to Oil & Gas Downstream Logistics (Open.SAP.Com)
  • Trained on SAP HANA , SAP BW on HANA, SAP BPC NW 10.0 (EPM), SAP BOBJ
  • Have gone through trainings on Six Sigma (Lean & Yellow/Green Belt), Agile Scrum Master, PMP
  •  Project Management Skills/Experience:
  • Generated more business (FTEs increment leading to more revenues) from the existing client
  • Managed the project schedule, status & communication, financials, risk & change
  • Supervising the Team members, Monthly Leave Plans, Giving Feedbacks for Rating & Suggesting the improvements.
  • Planning for Resource Capacity( Increasing or Decreasing), Involved in evaluating Resources, Monitoring of Existing Resources, hiring new resources
  • Drove process optimization, technical optimization initiatives
  • Coordinated with the business development team & prospect delegates, & Involved in Pre-Sales, Requirement gathering, client accreditation process.
  • Generated leads from Philippines market for the verticals like Life Sciences,T&H practice, Restaurant and Food Services offerings, ManLog Industries, Energy, Telecom, etc for SAP various modules areas and other non-SAP areas.

Client: Zuellig Pharma
                Zuellig Pharma has been successfully serving the Asia healthcare market since 1922; during this time our network has expanded to cover the needs of 13 countries and regions. Our key service solutions involve Clinical Research, Sales & Marketing, Distribution Solution, Patient & Payer Services and Community Pharmacies.
Summary: - Did gap analysis, implementation of SAP BI/BW Projects, generated leads, effort estimation, co-ordination with offshore & client across 5 countries spread over 13 locations
-Managed the deliveries within the time frame & ensured good feedback from the client on the achievement of all performance objectives of the project
-Lead generation, Coordination with new prospect/sales Team/Technical delivery team, etc
Responsibilities in recent project
-Overall responsible for the SAP BI/BW Implementation projects and Local Contractual Reports deliveries
-Have successfully deployed/supported 6 Go-Lives (6BU).
-Involved in gap analysis of the new requirement for different BUs
-Involved with BU & users to understand the business requirement & get into brain storming discussions with the client
-Coordination with offshore and client in onshore-offshore model of work delivery
-Estimating the effort required and planning the resource allocation as per priority & business need
-Planning for Resource Capacity (Increasing or Decreasing), Monitoring of Existing Resources, hiring new resources
-Planned & supervised Cutover Plan, Data Load etc activities
-Suggestion to development team for design change with technical details required& supervised development
-Developing queries; UAT and production support on queries/reports using SAP BeX tool/SAP BI4.0 (WEBI)
-Developed end to end data modeling flows, UAT & supported go live
-Written routines (Start, Field & End) in transformations
-Enhancement done at ECC for various DS (2LIS*, etc), customizing extractor programs, data flow enhancement in SAP BI 7.3 including SPOs enhancement
Client: Pfizer
Pfizer is one of the largest innovators of the Pharma product. We have a leading portfolio of products and medicines that support wellness and prevention, as well as treatment and cures for diseases across a broad range of therapeutic areas; and we have an industry-leading pipeline of promising new products that have the potential to challenge some of the most feared diseases of our time, like Alzheimer's disease and cancer.
Responsibilities in some projects
                Project 1: Roles: SAP BI ABAP Developer
-Involved in estimating the efforts & resource planning for this pilot project
-Successfully complete the production go-live of this project within the estimated deadlines at the client site in USA
-This led to a win of another migration project from the client
-Involved in SAP BW Migration project for all the SD & Inventory objects from SAP BW 3.5 to SAP BI 7.x
-Analyzed the complexity of each object and defined the time lines of each SD & Inventory objects
-Developed and did the unit testing of the SD & Inventory objects
-Created cut over plans for migration of objects to production
-Created transformations, applied formulae, edited start routines & field level routines and end routines as per OOPS ABAP concept
-Involved in cleaning up the old update rules/transfer rules from DW1 to PW1.
Project 2:Roles: SAP BI ABAP Developer
-Incident Management i.e. Ticket Analysis, resolution and reassigning to the corresponding team within SLA.
-Monitor Data loading in BW (Daily / Weekly / Monthly and Ad-hoc) in Production within SLA.
-Solved usual problems with Process chain.
-Created Process chain as per request / edited existing process chain to add nodes / edited scheduling, etc
-Debug Update Rules and Transformations and identify the error.
-Creating test scripts on the HP QC tool and execute test scripts on the tool to verify the integrity of the object on development and quality server.

Prefer remote work from India,
Open to travel on need basis anywhere across the globe.