Passionate of managerial job, actively looking for career change. Resume
Posted on: 2018-04-04
LOG IN OR REGISTER TO CONTACT ME
This button will open the login/register page in a new tab. After logging in, come back to this page and refresh your browser.
Resume:
P BW on HANA and SAP BI/BO. Involved in delivering IT/SAP solutions in various roles. Actively looking for career change.
Worked with Directors, Managers, Leads and Business users to gather reporting requirements, proposed and implemented feasible SAP BW/BW on HANA solutions in order to meet business challenges.
Assessed customer needs, explained and proposed high level SAP IT architecture and appropriate technology solutions. Addressed the majority of technical questions concerning customization, integration, and general features & functionality of products.
Demonstrated experience in designing and implementing SAP BW and SAP BW on HANA solutions for Large & Complex System Landscapes.
Experienced in SAP BW in Extraction, Modeling, Reporting- using Transformation, Loading, design and development of DSO, Info Cube, Info Object, Process Chains, Query Designer, BEx Analyzer.
Experienced in developing reporting solutions for Production Planning, Manufacturing Execution, Sales, Financials, Auditing, SCM, Logistics, Sourcing, Transportation, and Travel.
Experienced in transforming requirements into screens, design, documenting, providing presentations and rolling out the deliverables.
Extensive experience in designing/architecting back-end solution in SAP BW leveraging SAP HANA.
Extensive experience in designing SAP BW process chains, DTPs, Data sources, Advanced DSOs, Composite Providers and Hybrid Providers in order to develop SAP BW Modeling Solutions to suit business requirements.
Experienced in importing SAP BW Models in SAP HANA, Converting Standard DSO into HANA Optimized DSO, Standard Info Cube into HANA optimized Info cube.
Strong knowledge in all phases of Software Development Life Cycle (SDLC) such as analysis, design, development, testing and implementation on various platforms.
Experienced in Project Planning, Business blueprint, Realization, final preparation and Go-Live support.
Managed and delivered large and complex assignments on time within the budget.
Hands-on experience in full life cycle projects, Excellent Project and Resource Management Capabilities.
Experienced in leading on-site and off-shore project teams.
PROFESSIOANAL CERTIFICATION & TRAINING
- SAP Certification on Business Intelligence with SAP BW and SAP BO.
- Record of Achievement on SAP BW powered by SAP HANA from SAP.
- Record of Achievement on BI Platform Innovations and Implementation from SAP.
- Record of Achievement on BI Clients and Applications on SAP HANA from SAP.
- Record of Achievement on Software Development on SAP HANA from SAP.
- Record of Achievement on SAP HANA Cloud Platform from SAP.
- Record of Achievement on Introduction to Mobile Solution Development from SAP.
- Record of Achievement on Rapid Deployment for SAP Solutions from SAP.
- Record of Achievement on Sustainability and Business Innovation from SAP.
- Record of Achievement on SAP Business Suite powered by SAP HANA from SAP.
- Training on SAP BI and SAP MM.
- Diploma in Computer Applications on C, C++, Java and
Technical Skills:
BI/BW Tools: SAP BW on HANA ., SAP BW, ECC, BEx Query Designer, BEx Analyzer, Web Application Designer (WAD), Web Intelligence (Webi), Analysis Edition for MS Office, Analysis Edition for OLAP.
Databases: IBM DB, SQL Server , MS Access .
Languages: C, JAVA, HTML.
OS: Windows ///XP//.
Other Tools: Rational Clear Case, Rational Clear Quest, Service Center, Visual Source Safe, Lotus Notes, MS Office to , Visio , Microsoft Project.
Professional Experience:
Zimmer Biomet, Warsaw, IN
SAP BW Consultant
Feb – Oct
Description:
Zimmer Biomet is a publicly traded medical device company. Zimmer designs, develops, manufactures and markets orthopedics products, including knee, hip, shoulder, elbow, foot and ankle artificial joints and dental prostheses. Zimmer has operations in more than countries around the world and sells products in more than countries.
Responsibilities:
- Involved in various planning sessions with different Project Managers, Business Managers, Business Analysts and Team Members to analyze requirements and outline the solution.
- Installed the technical content cubes to update BW Statistics data.
- Involved in importing SAP BW Models in SAP HANA, Converting Standard DSO into HANA Optimized DSO, Standard Info Cube into HANA optimized Info cube.
- Coordinated with multiple technical teams (Basis, Database, and BW) in implementing BI Solution.
- Educated executive and senior management on BW by developing and presenting high level BW strategies and solutions.
- Involved in SAP HANA implementation, SAP System Landscape transformation (SLT), and SAP HANA data modeling using Attribute View, Analytic View and Calculation Views.
- Designed the star schema on the BW side and identified the KPIs that formed the fact table and dimension data elements.
- Developed custom BW ODS objects, Info cubes and developed BEx queries on top of the same to support reporting requirements.
- Developed custom BW extractors for extracting data from various source systems like network files, Oracle, Other BW Systems in order to suit business requirements
- Developed transformations, DTPs to support the data model. Developed custom cubes and ODS objects based on data from LIS extractor LIS__VAHDR and LIS__BF.
- Developed Custom Processes within BI to model the complex reporting needs.
- Developed data model to accommodate both Real time and standard data transfer process.
- Involved in SAP BW on HANA implementation. Involved in pre and post BW activities.
- Involved in BW on HANA Modeling for mixed modelling scenarios using HANA Modeler.
- Created various HANA Views (Analytic Views and Calculation Views) with Source BW on HANA
- Involved in day to day BW support activities which involved monitoring/maintaining process chains and executing BW Housekeeping activities
Environment: SAP BW ., SAP BW on HANA ., ECC, BEx Query Designer .x, BEx Analyzer, Windows , Windows .
Foresight Energy, St Louis, MO
SAP BI /BW Consultant
Aug – Jan
Description:
Foresight Energy is a leading producer of thermal coal with reserves in the Illinois Basin. With over billion tons of coal reserves, Foresight Energy is the largest holders of coal reserves in the United States. It reserves are sufficient to support over years of production at its current production level. It operate three of our four mining complexes with longwall mining systems.
Responsibilities:
- Involved in planning sessions with VP and Managers to analyze requirements and outline the functional reporting solution.
- Created Functional Requirements Specifications (FRS) for building the reporting solution with business team.
- Developed data model to accommodate both Real time and standard data transfer process.
- Modified custom code in start routines and end routines based on data transformation needs
- Customized the basic cube with custom Characteristics and Key Figures for reporting.
- Performing troubleshooting and issue resolution, and assisting other developers and Business Users.
- Extensive Involved in designing SAP BW process chains, DTPs, Advanced DSOs, Composite Providers and Hybrid Providers in order to develop SAP BW Modelling Solutions.
- Involved in day to day BW support activities which involved monitoring/maintaining process chains and executing BW Housekeeping activities.
- Post-Go Live/Support ~ handling Incidents, Access requests, Maintenance & Enhancement Tickets.
Environment: SAP BW ., ECC, SD, MM, PP, FICO, BEx Query Designer .x, BEx Analyzer, Windows .
Daiichi Sankyo, Inc., New Jersey, NJ
SAP BI/BW Consultant
Jan to Jul
Description:
Daiichi Sankyo Company, Limited is a global pharmaceutical company and the second largest pharmaceutical company in Japan. The company owns the American biotechnology company Plexxikon, the German biotechnology company U Pharma. Daiichi Sankyo is the producer of Benicar (Olmesartan), an angiotensin II receptor antagonist and top selling drug in the U.S. Global sales of Olmesartan. Daiichi Sankyo delivers innovative products that enhance the lives of millions of people around the world.
Responsibilities:
- Involved in planning sessions with business managers to analyze requirements and outline the solution.
- Performed Architect roles like Design, Development and Implementation.
- Coordinated with program manager and prepared appropriate architecture.
- Helped the business team to understand the design and capability of the BW system for data warehousing purposes in turn helping them map the KPIs and derive meaningful information.
- Involved in mapping the existing business structure (source data for the KPIs) resided in an external application.
- Created Process Chains to automate the data load and data target administration and monitored the processes.
- Involved in configuration of BW Objects like Info Cubes, BEx Queries Configuration.
- Performed Performance Tuning of BW Landscape and BEx Queries for OLAP Connections.
- As a member of BW Production Support team, daily duties involved day to day management of info cubes related to APO, Procurement, Sales, Delivery, Billing, COPA, AR, GL, and Consolidation.
- Maintained and created system and product documentation, and mentored other developers.
Environment: SAP BW ., ECC, Analysis for MS Office, OLAP Analysis, BEx Query Designer, Web Application Designer, BEx Analyzer, Windows .
MWV (MeadWestvaco), Richmond, VA
BI/BW Developer
Aug to Dec .
Description:
MeadWestvaco Corporation is an American packaging company. MeadWestvaco is a producer of packaging, specialty papers, consumer and office products and specialty chemicals. The company has operating and office locations in countries, and serves customers in over countries. The company’s paperboard, package and paper brands included Carrier Kote, Custom Kote, Printkote, Tango, Digipak, Amaray, Dosepak and Vision. MeadWestvaco hold leading positions in the markets it serve. MeadWestvaco manages over million acres of forestlands meeting stringent environmental standards and certified to Sustainable Forestry Initiative standards.
Responsibilities:
- Involved in various planning sessions with different Project Managers, Business Managers, Business Analysts and Team Members to analyze requirements and outline the solution.
- Provided Presentations to Business Managers on solution Overview and SAP BI Applications.
- Involved in full life cycle implementation of SAP BW and SAP Business Objects.
- Developed the design specification for the query views to extract both master and transactional data based on DB schema.
- Developed Complex cell based BEx reporting to compute complicated monthly KPI calculation.
- Developed Reports using Web Intelligence.
- Developed Analysis for Office and OLAP Analysis Reports against OLAP Connections.
- Developed Process chains to automate data loads for individual operating companies.
- Involved in User Training and worked closely with the Business team in coming up with the training materials for end users.
- Worked closely with Basis team and directed them toward the right solutions in case of issues on the system.
- Worked extensively with the security team in assigning and developing appropriate power and end user roles to users across the globe.
Environment: SAP BW ., ECC, SAP Business Objects ., Web Intelligence, Analysis Edition for MS Office, BEx Query Designer .x, BEx Analyzer, Windows .
Amigos Soft Solutions, India
SAP Consultant
Nov – Jul
Responsibilities:
- Performed Design, Development and Implementation.
- Involved in BW upgrade from .C to . & migration from . to BI ..
- Involved in upgrade support of the ECC . and ECC . from a BW perspective.
- Involved in Upgrade activities like OSS, post-upgrade checks, rescheduling jobs, support packs, etc.
- Involved in other tasks during the upgrade like de-scheduling process chains, clearing the delta queues and performing connectivity checks with the source systems.
- Developed Report Template Design documents.
- Involved in Change Management and moved Reports to Production Environment.
Environment: BW .x/., ECC ./., BEx Query Designer, Web Application Designer, Rational Clear Quest.
TTL PVT. Ltd., India
Developer
Jun – Nov
Responsibilities:
- Participated in project planning sessions.
- Worked with managers, application developers, and production teams and across functional units to identify business needs and discuss solution options.
- Plan, design, and implement application database code objects, such as stored procedures and views.
- Developed new processes to facilitate import and normalization.
- Understand the current systems, coding and testing.
- Worked with internal and external clients for import and normalization of third-party data.
- Developed code in C environment for different projects and applications.
- Prepared different reports in MS Excel and MS Access to track progress.
- Created Reports and Presentations for the business analysts and end-users.
Environment: C, MS Project, MS Excel , MS Access , SQL Server , Rational Clear Case, Rational Clear Quest.
Education:
- Master of Business Administration from University of Madras, India.