SUMMARY:

• SAP Certified Techno - Functional Consultant, with 16+ years of consulting experience in IT Industry includes 10+ years in SAP BW with HANA/Business Objects/BPC/ABAP in Retail, Footwear, Apparel, FMCG, Energy, Semiconductor and Public sector industries. Has worked as Architect, Team Lead and Developer involving various stages of SAP Implementation, Rollout, Support, Enhancement, Upgrade, Migration and Performance Optimization projects for global organizations in multi system landscape architecture.
• Has experience in understanding various business scenarios, expertise in analysis and recommending technical solution and processes.
• Very good in comprehensive problem solving abilities, self-motivated and is a team facilitator
• Specialization in configuration and setup of SAP business content and SAP BW extractors utilization, System Analysis, Requirement Analysis, Validation, Technical Solution Design, Development, Testing and Quality Control with a focus on better performance and easy maintenance of the system
• Extensive experience in business processes and data extraction across the following modules: SD, MM, FI, CO, HCM, PP, PM, PS, SRM, SCM(APO), CRM, GRC, EP, et al
• Expertise in ETL activities like Data Extraction using CO-PA, FI, LO Cockpit and Generic data Extractions, Loading (Full/Delta upload) to InfoObjects, DSO and Cube and Scheduling & Monitoring Process Chains for automated data loads from different Source systems, Data Marts (APD) and Open Hub Services
• Strong understanding of SAP BW 7.3 & 7.4 features and functionality including SPO, HybridProvider, CompositeProvider, DataFlow etc.
• Participate in the migration of SAP BW to SAP HANA including performing optimization of the underlying structures and leveraging BW on HANA and LSA++ architecture functionality
• Well versed in Optimization of ABAP Coding especially in Routine (Start, End and Field) and Exits
• Proficient in performance tuning techniques which involves the evaluation of statistical performance, data load improvisation and query performance using BWA, compression, aggregates and partitioning techniques
• Experience in Modeling Planning Applications using SAP BI Integrated Planning (IP) and created Input Ready Queries
• Worked with Planning Workbench, Planning Layouts, Planning sequences, Utilities in BI IP with use of Transactional info-cubes
• Involved in Full Cycle implementation of Native HANA development, from developing HANA data models using Package, Attribute, Analytical and Calculated views as per reporting requirement needs and involved in HANA Revision upgrade
• Created Business Objects Universes using IDT on top of HANA views, BW BEx Queries and developed Webi reports(using BI Launch pad) and SAP Dashboards in 4.1 and 3.1 versions
• Extensively used Business Objects reporting functionalities such as Master Detail, Slice and Dice, Drilling methodology, Filters, Ranking, Sections, Graphs and Breaks
• Experience in Universe designing, developing and generating complex, Adhoc reports, dashboards, Business views, List of values along with User Acceptance Test (UAT) and data accuracy test
• Migrated Business Objects content across environments using Promotion Management Tool(PMT)
• Lead Experience in Onsite-Offshore model and involved in SAP’s first project - Orange ie., BW on HANA
• Winner of Triumph Outstanding Delivery Excellence Team Award for IR Project
• 5 years of excellent experience in critical, enterprise wide, multi-tier of web and client/server application software products and solutions optimized for large transaction volume using Microsoft, J2EE, Oracle, PL/SQL and Crystal Report for the Manufacturing, Banking & Financial Services

PROFESSIONAL EXPERIENCE:

Confidential, MD

Tech Lead

Environment: Native HANA, BW on HANA, SAP Business Objects, Native HANA, BODS, BPC, Business One, SOAR, Control-M, Hadoop, SAP ECC, ERP Next

Responsibilities:

• Gathering and Analyzing business requirements; develop a technical design
• Development of models and modify the objects and data flow in BW for Global End Use and Sales Operation Management and Allocation Management reports
• Support UAT phase and resolve issues
• Responsible for documenting FSD/TSD as well as new development for peer reference and knowledge transfer
• Created Package, Attribute view for master data, Analytical view, Calculation View for SOP and GEU
• Contributed towards SQL Script development for Incorrect Delivery Priority/Order Reason report
• Optimized the HANA views wherever possible
• Ownership of creation of Delivery Unit of SOP and GEU and coordinate with Basis team to transport
• Analyzed the frequently occurred issue and provided the solution to reduce the tickets
• Build Webi reports and Universes on HANA views in 4.1 version
• Perform optimization of views to consistently improve the underlying data structure and data flows through SAP BW transport and release processes

Confidential, WA

Architect

Environment: SAP ECC, BW, IP, SAP Business Objects, IP, BWA, POSDM, Portal, Service Now, SolMan, Tableau, Tidal

Responsibilities:

• Worked with Key Stakeholders on the gathering of business requirements; develop a technical plan with duration estimates. Execute the plan and deliver the required deliverables within the time estimate
• Proactively identified potential performance and scalability issues by leveraging SAP BW statistics and by coordinating with SAP Basis, infrastructure, and other integrated components and teams.
• Worked closely with BASIS community to align with change management processes and to ensure performance, processes and access is optimal for BI solutions
• Performed optimization reviews to consistently improve the underlying data structure and data flows through SAP BW transport and release processes
• Engaged in Business Objects upgrade from 3.1 to 4.1
• Built Business Objects Universes(.unx) using IDT on BW BEx Queries
• Improved and streamlined processes regarding data flow and data quality to improve data accuracy, viability and value
• Worked on Input ready queries which uses underlying Integrated Planning model
• Responsible for documenting modifications of pre-existing development as well as new development for peer reference and knowledge transfer
• Interacted with the business community to gather/develop functional and technical requirements and translate them into business intelligence applications and reporting solutions
• Facilitated collaboration with end users to identify needs and opportunities for improved data management and delivery
• Provided mentoring and guidance to other developers

Confidential, OR

Architect

Environment: SAP ECC, SAP BW7.4, SRM, Portal, Service Now, SolMan, SUM

Responsibilities:

• Lead BW Upgrade project from End-to-End (version from BW7.1 to 7.4 SP07) which involves Road map finalization, defining preparation activities, Pre and Post upgrade testing, support in functional testing, documentation and interaction with SAP, Basis, Functional and Security team till closure of the project
• Responsible for reporting requirements gathering (includes interaction with business users to finalize the reporting requirement), analysis, review and design finalization
• Design and develop County’s Purchasing organization reporting requirements (enhancement)especially in SRM Public sector components - Bidding Engine, Contract Management, Spend Analysis, Workflows and Purchase Order areas
• Analyze and document current state data flows and structures and optimize it
• Identify the potential gap in BW landscape and provide suggestion to publish additional reports to increase BW end user base (ROI)
• Designed and implemented the solution for BW data extraction to SQL Server using OpenHub
• Support Tickets analysis and resolve critical issues
• Review technical specification and code and support testing activities and educate resources
• Enhanced Organizational management and Personnel administration reporting requirements

Confidential, CA

Architect

Environment: SAP ECC, CRM, BW on HANA, Business Objects, IP, SolMan, EP

Responsibilities:

• Responsible for requirements gathering and analysis, worked closely with business users
• Reviewed Technical Designs developed by team members and directed them to do necessary changes
• Created Package, Attribute view, Analytical View and Calculation View for Sales reporting
• Involved in SQL Script calculation view development
• Best Practices are set for HANA Development
• Developed unit, integration, and performance test plans and assisted team to follow-up
• Reviewed Data Extraction and query performance; and optimized it
• Designed and Implemented CRM data extraction into BW and till webi reports creation
• Interacted with Business users globally for further system improvement recommendation and implementation
• Enhanced and Supported planning queries
• Built Business Objects Universes(.unx) using IDT on BW BEx Queries
• Enhanced multiple module reports based on ongoing business requirement changes

Confidential, NJ

Architect

Environment: SAP ECC, BW, IP, BWA, NLS, Remedy, SCM, BPC, Tableau, HANA, BusinessObjects, DMO

Responsibilities:

• Involved in Optimization project (having 37TB DB size) along with multiple teams globally to achieve BER target
• Analyzed Report Performance, provided technical design recommendation and monitored End- to- End Life cycle implementation
• Responsible for requirements gathering and analysis, worked closely with business users
• Identified the long running queries in the system, suggested necessary changes and assisted teams to improve the report performance
• Reviewed long running ETL Process Chains and optimized it to achieve on time report availability
• Extensively Coordinated Functional and Technical testing team activities for multiple projects
• Developed BW & BI standards, processes and procedures for consistent smooth execution and easy administration and directed teams to follow-up on it
• Created Business Objects Universes using IDT on top of HANA views, BW BEx Queries and developed Webi reports
• Monitored major projects transports to move requests smoothly and resolved conflicts
• Developed planning models using IP based on planning reporting requirements
• Reviewed Technical Designs developed by team members and suggested the changes
• Developed unit, integration, and performance test plans along with CTT and implemented it
• Support testing activities and educate team
• Implemented CO-PA accelerator using HANA
• Resolved escalated critical technical issues related to performance issues
• Interacted with Business users globally for further system improvement recommendation and implementation
• Conducted workshops to educate the Business Support team to utilize the system effectively
• Handled multiple projects such as BW7.31 Upgrade, BWA Upgrade, DB2 Migration, Reconciliation, WorkBooks, et al

Confidential

Architect

Environment: SAP ECC, CRM, BW, IP, BusinessObjects, SolMan, EP, GRC, HCM, FI-CO

Responsibilities:

• Closely interacted with Business Analysts and different user groups to understand, validate and document the requirements, translate these to functional and technical specifications
• Led CMG and BW team
• Conducted design reviews with the teams to ensure the designs adhere to the best practices and the design is optimized for loading/reporting performance.
• Best Practices set for Modeling and Query standards in development
• Involved in creation of planning queries using IP
• Coordinated with testing team to ensure that testing results correspond to the business expectations
• Reviewed early watch alert report and implemented the suggestion in the system to improve the health of system
• Appreciated by client for Speedy Delivery with given resources and achieved Extensive Performance
• Involved in ECC EHP5 upgrade project
• Implementation of HCM/HR module in SAP BW which involves Data extraction, Data modeling, Data loading, Testing, Documentation, Requirement analysis, End user documentation, Reporting and Go-Live Check
• Major Functional Areas covered in HCM/HR were Personnel Administration(PA) and Organizational Management(OM)
• Assisted team to develop webi reports

Confidential

Architect

Environment: SAP ECC, BW, EP, CRM, GRC, IP, BWA, WAD, ABAP

Responsibilities:

• Requirement gathering and validation of new reports and develop Functional and Technical Specification
• Supported team members and assisted in Design, Development, Testing and UAT phase
• Defined the approach to optimize the performance of specific queries and implemented thus reduced run time dramatically
• Analyzed and implemented new techniques for data load optimization
• Assisted in updating a BW/BI reporting environment

Confidential

Senior BW Lead

Environment: SAP SCM7.02, SRM7.02, BW7.31, NW Portal7.3, HANA1.5, SolMan, BPC, CRM

Responsibilities:

• Coordinated team members to achieve 100% test coverage during all test phases
• Raising and Tracking of the reported messages using GTP and analyzed the same
• Participated in Specification Reviews along with Developers and Solution Management
• Analyze and carryout the fresh Test cases in GTP
• Involved in testing of functionality vis - -vis the requirements
• Extraction and Implementation of SRM PPS Reports in BW
• Participated in HANA training provided by SAP
• Actively involved with all Validation teams and ensure that necessary action implemented

Confidential, AZ

Senior BW Lead

Environment: SAP ECC, SCM, CRM, BW, IP, BO, GRC, ABAP

Responsibilities:

• Created project roadmap including project plan, scope, standards, et al
• Involved in requirement gathering and analyzed the FS and Coordination with Functional team
• Involved in Modeling, Extraction and Query creation
• Universe and Webi creation as per reporting requirements
• SAP A1 Certified - Semiconductor Content objects are transported to Client Development System
• Involved in migration from 3.x to 7.0 for PCC Objects
• Involved in transport and testing activities
• Monitoring project deliverables on content and meet the deadline
• Involved in BOBJ report performance tuning

Confidential

BW Lead

Environment: SAP BW, SCM, BEx Analyzer, Remedy, BODI, WAD, Citrix, ABAP

Responsibilities:

• Analyzed the existing system and identified the gap to do automation and improvement; Interacted and convinced the development team to develop necessary things and followed up them till successful implementation; It helped to minimize operational effort
• Attain the permanent solution for each issue as much as possible thus issues are drastically reduced after my tenure into the Project.
• Part of 100% SLA achievement
• Improved the regional query run time dramatically and appreciated by client management
• Played the key role in successfully completed SQL 2005 Database up gradation
• Coordinates with different teams to get the job done since Confidential landscape is having lot of interfaces/applications
• Coordinated the weekly call with P&S team and monthly call with DP community
• Apart from my own responsibilities, helped other teams wherever required to expedite solution
• Assisted in updating a BW/BI reporting environment

Confidential, OR

BW Lead

Environment: SAP BW, BEx Analyzer, ABAP

Responsibilities:

• Involved in Batch monitoring and production support activities
• Resolved the issues as per the priority without missing SLA
• Extensively involved in updating the Business Summary reports as well as late batch notifications
• Responsible for contacting the upstream teams for milestone deliveries proactively
• Actively involved in release activities during the Apr 08 release
• Expertise in handling GBI Batch activities
• Responsible for value added services like escalation reports and frequent failures lists
• Expertise in managing the batch during the system outages
• Extensively worked on weekend work plans
• Monitored of Info Packages and analyzing the reasons for failures of Extractions
• Monitored and Managing of ODS object, Info Cubes and PSA requests
• Maintained Aggregates, indices and Info cube compression to improve query performance

Confidential

SAP BW Lead

Environment: SAP BW 3.0B, SAP R/3 4.6, BEx Analyzer

Responsibilities:

• Customized Business Content objects as per the specification
• Using LO DataSource's to extract the data from R/3 for sales order, delivery and billing information to BW using full/Delta update methods
• Involved in setup table filling for SD application to upload the historical data into BW by scheduling the initialization info package
• Built MultiProvider's to combine several basic cubes and created BEx query based on it
• Involved in performance tuning using Aggregates, Compression, etc.,
• Involved in Process Chain creation to automate loading of all Master and Transaction data in background

Confidential

SAP Consultant

Environment: SAP R/3 4.6, ABAP

Responsibilities:

• Created Report, which has lists Customer wise and Sales Order wise open billing document information. It Includes Billing Document Number, Customer Number, Sales Document Number, Sales Area and Billing Item Details
• Created Monthly Sales Report according to Sales Organization and Distribution Channel
• Display Raw Material Stock: This report was developed to display date wise raw material stock for selected plant, storage location, material. It will display information like opening stock, issued quantity, received quantity, etc.,
• Finished Goods Stock Statement: This report was developed to display monthly Production quantity, Local sales, Export sales, Consumed quantity etc. for the selected plant, material and period
• Display Goods Receipts details: This report was developed to display goods receipts details for selected GR Number, selected vendors and for specified period. And it will display information like purchase order number, purchase order quantity, purchase order date, received quantity, GR date, percentage of completion

Confidential

Software Programmer

Environment: VB.Net, VB 6.0, MSMQ, Oracle 8i, Windows 2000, Crystal Report, SQL

Responsibilities:

• In addition to leading a team of 5 members, involved in coding of Retail Loan, Security, Legal and Pass Book Modules
• Developed components for Branch and Core Server Updation using MSMQ
• Involved in Development of communication layer using VB.Net and MSMQ which is designed on Template Pattern and Complex Queries using Stored Procedures and Triggers
• Report Generation for the above said modules using Crystal Report
• Independently Implemented the Initial Format / Specification for Single Authorization Program for the Entire Retail Loan Module. The above Format / Specification has resulted, subsequently;
• In clubbing the 20 separate authorization programs into one single form
• Reduction of considerable time and effort in development of separate programs