EXPERIENCE SUMMARY:

• Having around 13 years of strong experience in leading Client Engagements, Project management and Pre - sales along with in depth hands on expertise in SAP BW BOBJ & HANA. Confidential also worked with highly recognized clients and respected organizations and had been a high performer with many client accolades and awards from those organizations. Have been had multiple visits to the USA on B1 Visa for client engagement and co-ordination with offshore.
• Lead the governance and operational review meetings and present the status updates and performance alignment to the KPIs identified and transitions as applicable to the management internal and client.
• Accountable for preparation and execution of Tactical Governance monthly review with the Customer. Works with the Customer to make this review effective and efficient.
• Conflict management between Delivery Coordinators and the Customer during the development delivery cycle. This responsibility is not limited to functional specification acceptance, Work Order acceptance or Demand Management.
• Collaborates with the Customer to prepare the Statement of Work for the Work Orders received through the Iterative Waterfall, Scrum or Distributed Scrum Delivery Models.
• Collaborates with the Customer to establish new ways of working and drive the change management for the onsite Supplier staff.
• Ensure 100% compliance of the software development processes. Ensure best practices being followed across all the project teams
• Manage multiple teams at Onsite/Offshore comprising of different SAP & Non-SAP Technologies like ECC, MDM,EP,BI, BO, HANA, Testing (Automation/Manual), CRM, Scrum Teams etc.
• Resource Recruitment, Selection, Hiring, Loading of the Onsite/offshore resources, Ensure quality of resources & Offshore team building and cohesiveness across the onsite and off shore teams, Manage/plan team member transitions effectively
• Monthly review meetings with Project Mangers & Team Leads and vendor resources, Provide continuous Delivery Excellence by new initiatives, Customer Delight, Associate Delight, Participating in Delivery Review/Quality review
• Executed Multiple Implementation, Rollout, Upgrade, & RTS engagements in SAP Space
• Experienced in governing SAP engagements with internal COE and SMEs and external resources through effective vendor management.

TECHNICAL EXPERTISE:

SAP BW: SAP BW/4, BW 7.5, 7.x& 3.x

ERP Tools: SAP R/3 4.7; ECC 6.0; SAP CRM 7.0, IS Retail

Languages: ABAP/4, SQL

Business Objects Tools: BO 4.0 Tool - Web Intelligence, Data Services, Design studio, Crystal Reports and SAP Lumira

Analytical Tool: HANA SP09

Other Testing Tools: HP Quality Centre, Service Center, Lotus

Functional Knowledge: SAP SD, SAP MM, SAP PP, SAP FI

SAP SKILLS:

• Expertise in SAP ERP (SD, MM) and BI.
• Knowledge and exposure on ABAP and BO
• SAP HANA
• SAP BODS
• TABLEAU
• MS POWER BI
• Qlik View

PROFESSIONAL EXPERIENCE:

Confidential

Responsibilities:

• Upgrade and Migration to newer version( from 7.x to 7.5 to BW/4 )
• End to end management of projects from conceptualisation and visualisation to technology mapping and final execution of projects.
• Mapping client’s requirement and providing them best solutions involving evaluation and definition of scope of project and finalisation of project requirements.
• Managing and leading team members; allocating resources among team members and guiding team members during the project, till final delivery.
• Managing Turkish and Dutch user isses from Service Center
• Managing BW projects to ensure that deliverables are met within schedule, budget & quality
• Involved in roadmap development and responsible for project implementation
• Worked on SLT (SAP Landscape Transformation) configuration and replicated the data from source system to SAP HANA system.
• Created Developer Profile in Management Console and obtained credentials to connect to BODI
• Imported ATL files for Rapid Mart to be used with SAP ECC
• Wrote SQL statements to create table DDL in staging area, also for Dimension and Fact tables
• Created the ETL Jobs in BODS in a multi-developer environment maintaining versions in CR
• Added SQL Statements, functions and Variables in Initialization and End-job Scripts, created Workflows, Data Flows, IfThenElse Statements and Where Clauses
• Used Formats and Transforms including Flat File formats, Query, Table Comparison, History Preserving, Hierarchy Flattening, Match Transform, Validation Transform, Key Generation and Map Operation.
• Used Auditing and filtering features to analyze the data flow and performed debugging to do Error Management
• Utilized Lookups, Lookup ext, table Joins, Match, Merge transforms and custom functions
• Utilized Data Profiling including Column and Relationship on tables
• Performed Job Validation and Syntax checks and Dry Run to evaluate for errors, execution time and bottlenecks. Utilized the Debugging function adding Breakpoints, Try and Catch block, Target table Auto-Correct Load and Auto-recovery mechanisms
• Loaded the test data to estimate job run time and Performance Statistics and optimized and fine tuned the job. Used Push Down where applicable.
• Exported Metadata in XML format to be consumed by the Universe to generate Webi Reports
• Scheduled Jobs in Management Console and in Tidal maintaining Parent-Child relationship and dependencies in QAS and communicated the same with the BO Admin
• Creation of Attribute views, Analytic views, Calculation Views based on replication data in HANA modeler.
• Creation of Analytic privilege and applied restrictions on the Information views.
• Experience in SAP BO Design Studio Dashboard Implementation.
• Mobile App for Process chain monitoring, Gateway Configuration, Authorization, Enabling SSO
• Involved in writing CSS, Java, Local and Global Scripts in Dashboards as per business requirement
• Created the project schedule in Microsoft Project, designed the SOW with staffing plan, developed budget plan with Microsoft Excel, and used other standard ThyssenKrupp documentation to run the projects.
• Stored all living documents in SharePoint and approved documents in Quickbase.
• Conducted scoping meetings and blueprinting sessions for gathering requirements to identify all GAP's/RICEFW's needed by the business and IT.
• Ran a project with Business Intelligence and Business Warehouse (BI/BW) team which included 3rd Party system and reports.
• Oversaw the scope of work which included the project planning, business process mapping, blueprinting, design, configuration, and setup of technical environment.
• Managed client portfolio budgets of … and team size of 11 functional/technical employee direct reports in different areas of SAP (SD, MM, IM/WM, and FI/CO).

Confidential, Chicago, IL

Envirorments: SAP BW 7.3, SAP BO Functional: PS & FI, MM

Practice Lead

Responsibilities:

• Assisted in developing and refining forecasts for project variables as necessary throughout the project.
• Created WEBI reports with multiple data providers and synchronized the data using Merge Dimensions and purge.
• Effectively used BO functions like cross tab, master detail, sorts, alerters, drill methodology, Breaks, etc.,
• Optimize usage of BW, HANA and BO
• Closely worked with functional team and users in creating new Change requests
• Developed work plans for individual tasks and managed team for SAP BI.
• Onsite & offshore Coordination Prioritized and estimated the effort for custom developments.
• Build and sustain strong interpersonal relationships by interacting with clients and peers through understanding of the customer’s business, their processes, and their priorities to ensure that system functionality and performance meet current and future business requirements
• Gathered and analyzed the requirement to replicate the ECC content in HANA using data provisioning.
• Created blueprint for Technical/Functional specifications and standard modeling documents for HANA.
• Established the best modeling and recommended strategies and architecture for SAP HANA.
• Integrated BOBI 4.1 with SAP HANA 1.0 (SP8) to create universes based on HANA tables and views.
• Worked on data replication for SAP ECC using SAP Landscape transformation (SLT).
• Developed ETL jobs with heavy transformations for data acquisition from SAP ECC and Non SAP systems.
• Performed trigger based data replication using SLT technique for SAP ECC.
• Monitored triggers, data loads for SLT schema.
• Involved in creating transformation in SLT for enhancing BP Role, BP Status and business required fields.
• Build HANA Information models (Attribute Views, Analytical Views, Calculation Views and Column/Row based tables) in HANA design studio for efficient data integration.
• Created SQL script based Calculation Views using CE functions.
• Developed Real-Time Information models to support SLT replicated tables from SAP ECC.
• Created Variables, Input Parameters and Calculated/Restricted columns on Calculation Views.
• Build Schemas, analytic privileges and granted permissions for BI users.
• Transported objects by creating delivery units between SAP landscapes.
• Build SAP BO universes on top of HANA information models for WEBi/Dashboard reports.
• Created WEBi reports, crystal reports, BO Dashboards based on universe created over HANA models.

Confidential

Envirorments: BW 3.5, 7.0 & 7.3, BPC7.5, Functional: DBM & VMS, FI, MM

Responsibilities:

• Designed and developed complete flow for Plant Maintenance report for “Material Where used list” using Generic extractions.
• Delegating the work to the offshore team and responsible for all the deliverables from offshore.
• Planning the work from offshore at the beginning of every month and estimating the delivery dates of the deliverables with the user approval.
• Represent the offshore team in weekly meeting with front office for weekly status updation.
• Involved in the designing of the dataflows
• Involved in the workshop arranged by solution referent from client for requirements gathering
• Involved in preparation of quotation of the objects, using project specific Quotation Matrix. The Quotation includes the total number of objects for the dataflow & the number of mandays, number of resources to complete the object.
• Installed standard Business Content and Migrated the flow from BW 3.X to BI 7.0
• Designed flow for adherence rate report which measures variance of quantity produced in factory to the quantity planned by master planner.
• Created Transformations and written start, individual and end routines as per client requirements
• Created datasource using Function module as per the need
• Recognized by client as reviewer for ABAP code in the developments.
• Expert in debugging the code to find issue.
• Created Data Transfer Process and designed Process Chains for the dataflows
• Installed standard business content reports and also designed custom queries as per the requirement
• Involved in the development of reports using Business Objects Web Intelligence to cater Ad-hoc reporting needs.
• Created reports using Business Objects functionality's like Queries, Drill Down, Cross Tab, Master Detail and Formulae's
• Created Supply chain Analytics and Stock Ledger Analytics
• Extensively worked with formatting the reports according to the user requirements.
• Involved in the integration testing with solution referents from clients
• Maintained separate documents for Technical specification, List of Transports & Data load file ( includes list of process chains and dependencies)
• Taken the complete responsibility of Golive of individual objects (r/3 setup tables to BI cube datalaod)
• Support:
• Monitoring tickets in ITASM (ticketing tool) and assign tickets to team members based on priority.
• Involved in creation on BW Support service catalogue which acts as base for service work invoice.
• Resolved many data mismatch issues /tickets.
• Single point of contact for proper update of documentation wherever applicable (corrections and evolution tickets).
• Single point of contact for all Go-Lives from Offshore.
• Upgrade
• BW pre & post upgrade activities
• Performance Testing
• Quality Check
• New data flow designs
• Handling New CR’s
• BPC Support
• Served as a BW BPC consultants to implement SAP Business Planning and Consolidation module for Sales
• Involved in Requirements gathering activity by interacting with the client SPOCs and Business Managers.
• Designed and developed custom BW Data model for staging date to BPC.
• Developed custom infocubes and master data objects for BPC loading.
• Worked on data extraction strategies involving Export and import Data from BPC application to file service and from 3rd party tool to BPC application.
• Worked on creation of Transformation and conversion files in BPC for transaction and Master Data loads to BPC.
• Contributed to Documentation by writing Technical Specifications and Unit Test Scripts.
• Involved in Unit Test execution of the Deliverables.
• Participated in other client projects to provide strategic assistance as needed.
• Was part of the production support, solving the issues from users
• Closely worked with functional team and users in resolving the issues.
• BOBJ Implementation:
• Create Data Architecture, Execution Architecture for GIMS BI.
• Effort estimation for Universes (Semantic Layer) / Web Intelligence Report Design, Database Objects Development efforts using ADM BI Estimator.
• Analysis, Design Universes on top of Golden Source Datawarehouse and Algorithmics Historical Data Marts(DWH/HDM).
• Collaboration with Client and Vendors from different Geographies - Golden Source, Algorithmics; Aflac Japan and Aflac US Business in Requirement gathering, System Integration, Testing.
• Collaboration with Data Governance team in preparation of Data Dictionary for Golden Source Data Warehouse
• Design Ad-hoc friendly Universes, Linked Universes for Aflac JP / US Historical Data Marts.
• Optimization and Performance Tuning of Universes and Reports by creating Materialized Views to improve Report run time.
• Train Business Users in SAP Business Objects Designer, Web Intelligence Reports and enable Universe framework for Ad-hoc Reporting.
• Perform Data Profiling / Data Quality test on Golden Source Data Warehouse
• Support Proposals, Quality Reviews, Technology Architecture Peer Reviews as a Technology SME
• Prepare/Review skill Training materials and provide Organizational level Trainings.
• Backup Activities
• Had been to San Antonio to represent offshore team in the steering committee meetings with the clients.
• Attend weekly ticket review meeting with client
• Attend weekly domain meeting with client and prepared Flash report.
• As a weekly activity plan work for next 1 to 2 months with an update on estimated time to complete.
• As a weekly activity check whether monthly baseline is reached in DBM domain.

Confidential

Envirorments: BW 7.0 & 7.3, Functional: IS Retail & CRM, FI, MM

Responsibilities:

• Working in Stage 2 implementation of SAP IS Retail. Stage 2 implementation includes process of sales from POS, E commerce, Bulk sale process from DC and implementation of POSDM on SAP BI
• Designing of interface from source system to SAP IS Retail for stage 1
• Did Stock initialization
• Desigined Promotional Reports, Revaluation Reports,
• Created data flow for POS analysis
• Managing SAP POSDM Data, ECC and CRM to BW for fine tuned data flows
• Process chais monitoring for historical data

Confidential

Environment: s: SAP BW 7.0

Responsibilities:

• Created Custom generic Data Sources and created functional modules to extract the data to BI system.
• Creation and Maintenance of Standard & custom Info sources, Info objects, Info cubes, ODS Objects, PSA, Update rules, transfer rules, MultiProviders and Info Packages.
• Installation of relevant SAP business content as and when required requirements.
• Creation of reports using BEX Analyzer and Workbooks such that the execution time is evenly distributed throughout the report by using Free characteristics, Restricted Key Figures, Calculated Key Figures, Variables, Exceptions.
• Extensive usage of administration workbench.
• Involved In transportation of entire Development-Quality-Production.
• Worked on Reconciliation reports, Amortization reports, Disbursement reports
• Used PSA to stage the data before transferring the ODS content to the Info Cube.
• Worked on DSO (flat) reporting to facilitate data analysis in a drill down or summarized way to give detailed level of reports.
• Designed Process chains for Master Data and Transaction data.
• Involved exclusively in designing/creating Crystal Reports
• Provided graphical reports with crystal reports to the client.
• Tested the aggregate awareness to ensure the query is pulling correct level of aggregation.
• Participated in meetings with end users and clients in gathering report requirements from business end users, high level analysis and design, quality assurance review of the applications.
• Trained end users on Data loading through Process Chain and Troubleshooting techniques and created awareness on BEx reports, Crystal Reports, Business Object reports.