SUMMARY

• Over 11 years of experience in information management and development with focus on Business Intelligence and Data warehousing using SAP Technologies.
• Expert in Project Management, Business Consulting, Business Analysis, Metadata Management, Reporting and Dashboards with SAP HANA, SAP BW and SAP Business Objects product suites.
• Successfully implemented 4 End to End HANA projects.
• Successfully implemented 11+ End to End Full BW Implementations.
• Expertise in translating business requirements from Power Plant, SCM (Material Management, Warehouse Management, Purchasing, Inventory Management), EAM (Plant Maintenance, Quality Management, Project Systems, SD(Sales, Deliveries, Billing), Finance into technical implementations supported by sound data models.
• Experience working in Utilities and Oil & Gas domains.
• Extensively worked on new features on BW 7.3 like new run - time options to load only unique records, “Reading directly from DSO Rules, Remodeling of DSO’s, setting up NLS parameters in Query Designer etc.
• Expertise in creating process chains, Meta chains, Scheduling Start Process, monitoring process chains etc.
• Hands on experience in BW reporting using BEx Query designer & BEx Analyzer using which Created Structures, Calculated key figures, Restricted key figures, Customer exits, Formulas, Selections, exception and conditions.
• Performance tuning of BEx queries using Indexes, aggregates, Cube compression and partitioning.
• Expertise in LO (SD, MM, WM), FI and Generic data extraction mechanisms.
• Expertise in creation of BEx Analyzer Queries, Workbooks, structures, variables, calculated key figures, restricted key figures, and RRI reporting, Ad-Hoc Queries.
• Expertise on creating APD’s (Analysis Process Design) for complex scenarios.
• Expertise in Process Chain Creation and monitoring.
• Extensively Worked on the BW Archiving(NLS)
• Prepared training documentation for the End-Users on BW Report Usages.
• Conducted training for end-users and provide technical directions to associate developers and contractors.
• Experienced working on Onsite-Offshore Delivery Model.
• Has created OSS Messages for solution resolutions.
• Having an excellent presentation, communication and interpersonal skills.
• Profound noledge of HANA Architecture.
• Expertise in HANA Data Provisioning with both Data Services and SLT.
• Expertise in creation of Attribute, Analytic and Calculation Views.
• Expertise in Export/Import on objects in HANA.
• Expertise in Creation of Stored Procedures in SQL.
• Expertise in HANA Security - Maintaining Users and Authorizations, Analytic Privileges.
• Expertise in SAP HANA SLT.
• Expertise in FI Standard Accelerators.
• Profound noledge of BW on HANA Architecture.
• Adept in optimizing BW Objects DSO’s/Info cubes/Planning objects.
• Experience on analysis of optimized objects.
• Experience on resolving various issues during Optimization.
• Experience on BW upgrade from BI 7.0 to BW 7.3.
• Involved in the Pre Upgrade Activities
• Running of Reports for activation of all the Objects.
• Running RSRV for the Consistency Check for Master and Transactional Data.
• Running the Report RSUPGRCHECK Report for Checking the Consistency Check.
• Alpha Conversion Check.
• Experience on Post Upgrade activities.
• Good Understanding of SAP BI integration with BO.
• Expertise in SAP Business objects Universes creation and modification with UDT and IDT.
• Expertise in Web Intelligence reports creation.
• Experience on Qaaws, BICS functionalities for Xcelsius dashboards.
• Expertise in Business Objects Explorer.
• Expertise in Lumira.
• Good Understanding of Data Services Architecture.
• Expertise in jobs, workflows and data flows.
• Expertise in various transforms.
• Expertise in object migration from DEV QA PRD.
• Demonstrated proven project and team leadership qualities through several cross-functional SAP project implementations.
• Has acquired tremendous experience on a worldwide corporate platform from both a business and technology perspective.
• Has achieved success through my ability to cultivate business relationships in an organization and communicating effectively throughout all stages of a project.
• The core of my professional focus TEMPhas been on application project lifecycle management in a team environment, collaborating with both clients and consulting partners to achieve business initiatives.
• Applied and implemented ASAP methodologies (Project Preparation, Business Blueprint phase, and realization, Final Preparation, Go-live and Support).
• Proven abilities in handling account management activities SOW, MSA of critical accounts, building client relationships, vendor management, and delivery related activities. Major areas of expertise include the following:
• Account/Engagement Management
• Strategic Planning and Execution
• Budgetary Planning & Control
• Team Development & Leadership Grooming
• Billing, Invoicing, SOW, MSA, Contract Management and Renewal.
• Negotiating new billing rates during new and contract extensions.
• Vendor Management
• Pre-Sales Support, Customer Mining
• Outsourcing & Managed Services
• Business Consulting
• Process & Procedures Re-engineering
• Off shoring Assessment and Implementation
• Six Sigma methods.

TECHNICAL SKILLS

ERP: SAP R/3 V 4.7, ECC 6.0.

Data warehouses: BW 3.5, BI 7.0, BI 7.3, HANA 1.0 SP4.

Languages: C, C++, Java and ABAP/4.

Reporting Tools: BEx, WAD,UDT, IDT, Webi, XCelsius.

Operating Systems: UNIX, Windows XP, Windows NT, Windows2000, Windows 98, DOS.

Databases: PL/SQL, Oracle 8i, HANA.

Conceptual Knowledge: ALE, IDOC, RFC, BAPI.

User interface: OLAP, Visual Basic, SAP UI5.

Domain Knowledge: SD, MM, FI, CO, CRM, HCM.

Internet Technologies: HTML, JSP.

Archiving Technologies: NLS.

Testing Tools: HP Quality Center, HP ALM

Office utilities: MS Office, MS Excel, MS Visio, MS Power Point.

Project Management Tools: IPM+, MS Project Plan

ITIL Tools: Service Now, Remedy, Star Team, Solution Manager

ETL Tools: SAP Business Objects Data Services 4.0

PROFESSIONAL EXPERIENCE

Confidential

SAP HANA Architect/TEMPPrincipal Consultant

Environment: Health and Safety: This project is to provide the custom reporting for the Health and Safety factors within the client. Has activated standard business content, customized DSO’s and created Webi reports for the same.

Responsibilities:

• Performed project management duties involving resource management, time management, effort estimates and the Project Plan. Also responsible for the project end-to-end design/implementation and delivery.
• Responsible for the end-to-end delivery of multiple projects.
• Interacted with stake holders, Business users, functional and technical teams to understand and gather the business requirements for preparing functional and technical design specification documents.
• Developed the process flows and use cases as per the business requirements.
• Responsible for trouble shooting problems and providing solutions for a successful project delivery.
• Participate in project reviews, design and Code reviews and provided solutions wherever needed to fine tune the issues.
• Developed and implemented complex Script based Calculation View and stored procedures.
• Developed Odata Services to expose the HANA data to SAP Process Orchestration.
• Implemented near real-time data load for reporting through Stored Procedure logics.
• Developed and implemented the technical design to consume the existing BW DSO data through SAP HANA views in HANA Studio and tan exposing them to Business Objects for reporting for multiple projects.
• Responsible for the SLT implementation for the Finance Month-End Processing.
• Worked along with the Security Team in Role Identification/Creation and Role Assignment.
• Developed Universes to support the Webi Reports and XCelsius Dashboard for various projects.
• Worked on Business Explorer to create Information Space for the Business to explore the data to perform adhoc data analysis.
• Conducted User Training for various BI Tools and developed training documentation.

Confidential

SAP BW/BO Lead

Environment: SAP BI 7.0, SAP ECC 6.0

Responsibilities:

• Co-ordination multiple teams at onsite (BASIS, Infrastructure, Data Center etc.) as per defined RACI matrix for the project
• Liaise with the customer for Release management
• Participate in project reviews, design and Code reviews
• Participate in noledge management activities across project teams
• Gathered reporting requirements for FSCD and BCA modules and developed functional design document.
• Interacted with development and testing teams to ensure correct execution of the project.
• Monitoring of Info packages, PSA Deletion and Setting up of Quality Server for Unit Testing.
• Involved in Integration, Regression testing, production support activities.

Confidential

SAP BW/BI Lead

Environment: SAP BI 7.0, SAP ECC 6.0

Responsibilities:

• Responsible for requirement gathering and Fit-Gap Analysis.
• Involved in mapping the SAP ECC logistics Data Extraction from Data Source using LO Cockpit Extractor to upload the master/transaction data into Info cubes.
• Developed generic extractors, Data Sources, Info Sources for Data extraction, transformation and loading from SAP R/3 system to SAP BW.
• Extensively worked on test script creation, Integration and Regression testing.
• Extensively worked on creating Webi reports for FI, SD and MM modules.

Confidential

Sr. SAP BW/BI Consultant

Environment: SAP BI 7.0, SAP ECC 6.0, SEM 3.1, CRM 3.0

Responsibilities:

• Gathered reporting requirements and designed the data flow from SAP R/3 to BW for specific functional areas like, FI-CO, SD, MM and QM.
• Involved in creation of Data Sources, Info Sources for Data extraction, transformation and loading from SAP R/3 system to SAP BW.
• Improved the Query Response time by reorganizing the Dimensions & providing Line Item dimensions.
• Extensively involved in setting up of procedures for extracting data from SAP R3 by using Generic Extraction and Customizing LO Cockpit by using enhancements and writing User-Exit programs as per requirements.
• Developed various reports like Aged Inventory Report, Days of Supply report, Safety Stock Days of Supply reports.
• Worked on performance tuning of queries by maintaining Aggregates, Compression and Partition of info cubes.
• Involved in production support activities like data load monitoring and issue resolutions.

Confidential

BI Consultant

Environment: Business Objects XI, Crystal XCelsius, Oracle

Responsibilities:

• Gathered reporting requirements for finance and SD domains.
• Involved in creating and maintaining Info Cubes, Operational Data Store, PSA, Info Objects, Info Areas, Multi Providers, Info Sources, Data Sources, and Info Packages.
• Extensively involved in setting up of procedures for extracting data from SAP R3 by using Generic Extraction and Customizing LO Cockpit by using enhancements and writing User-Exit programs as per requirements.
• Worked on the design and development of the BO Universe.
• Worked on SD and FI rapid marts.
• Created queries and generated reports on the universe using Crystal reports.
• Developed dashboards using XCelsius.