PROFESSIONAL SUMMARY:

• 10 years of experience of techno - functional expertise in SAP BW/BI and SAP BO Tools such as WEBI, Analysis for office, Dashboard Design (Xcelsius).
• Working knowledge on SAP BW HANA
• Ability to conceptualize and build a technical solution based on business requirement and zeal to learn new technologies
• Adept in team management, about 6 years of team management experience.
• Excellent written and verbal communication skills
• Strong in all aspects of BW: Requirement gathering, design, data modeling, data staging, activating and enhancing standard Business Content and reporting
• Upgrade Experience in SAP BW from 3.5 to BI 7.0, BW 7.0 to 7.4 and support pack upgrade
• Expert in handling Production Support projects and all support related activities tracking, planning, monitoring, reporting issues timely as per SLAs, task delegation, business communication etc.
• Proficient in Data Extraction from SAP ECC (LO-Cockpit extractors, FI, SD, MM, CO-PA, Generic Extractors) and from Non-SAP sources like flat file. Good knowledge of SD, FI and Inventory modules
• Expertise in the front end BW components like BEx analyzer, Query designer, Web Application Designer, Web Reports, WEBI, DashBoard Designer, Advanced Analysis for Office
• Proficient in performance tuning techniques which involves the evaluation of statistical performance, data load improvisation and query performance using compression, aggregates, partitioning
• Worked with BWA for faster reporting
• Well-versed with the CTS layer for BI modeling artifacts
• Good Experience in SAP ABAP for debugging and writing start, end, field, IP, DTP routines, data Source enhancements and user exits
• Well-versed in unit/integration testing of business processes, preparing deployment plans, cut-over tasks in QA and production systems.
• Working knowledge of SAP BW HANA- Data provisioning using SAP Landscape Replication Server (SLT), SAP HANA Design Studio modeling, creation of HANA Views-Attribute, Analytic and Calculation, design and development of HANA objects like Advanced DSO, Composite provider, Open ODS View

TECHNICAL SKILLS:

Data Warehousing Tools: SAP BW/BI (3.5, 7.0, 7.4), SAP Business Objects 3.0, SAP HANA 1.0

ERP: SAP R/3 ECC 5.0, 6.0

Languages: SAP ABAP, SQL

RDBMS: Microsoft SQL Server 2000, Oracle, Microsoft Access

Tools: ServiceNow, HP Quality Center, Remedy, MS Power point, word and excel

PROFESSIONAL EXPERIENCE:

Confidential

Offshore AM & AD Team Lead

Software: SAP BW3.5, SAP BI 7.0, SAP BI 7.4, ServiceNow tool, HP Quality Center

Responsibilities:

• As offshore team lead managed delivery of all business requirements, performed effort estimations, task delegation, coordination with onsite counterpart by holding daily/weekly status call
• Interacted with product owner for requirement gathering and co-authored functional specifications along with solution architect. Translated requirement from business into technical specification
• Designed development for required functionality including creation of BW modeling objects, Routines, Reports, Documentation of designed functionality
• Troubleshooting on data integrity, design, functional and technical issues and facilitated on time delivery
• Designed data flow from FI-GL source in ECC to BW. Build of the BI objects- Info-objects, DSOs, Info cubes, Multi provider, query, workbook and implementation of business logic via transformations and ABAP routine
• Created data flow and Reconciliation report for data coming from legacy system Kewill and for data coming from SAP ECC system for sales and billing. Performed V3 updates using LBWE to get data from outbound queue of R3 into delta queue of BW system
• Created IDOC reports in BW by extracting IDOC information from ECC IDOC tables
• Assured quality of deliverable through unit and integration testing and accelerated UAT approval by promptly fixing issues encountered which ensured adherence to stringent delivery timeline and hyper care support also provided
• Worked as offshore team lead for both support and development activities, where performed Data Load monitoring, Incident handling, team shift management, Analysis, development, testing and implementation of customer request and delivered new and complex high quality solutions to clients in response to varying business requirements
• Coordinated with onsite counterpart tracking of tickets/incidents by holding daily/weekly status call
• Worked on SLA based ticket resolution, Bug-fix analysis, Production monitoring and Performance improvement and enhancements issues. Worked on tools like ServiceNow, and HPQC
• Documented root cause analysis of production issues and maintained repository for easy
• Worked on issues, failures during BW service pack upgrade from SP12 to SP17
• Worked on BEx Broadcasting and provided automated reports to user per their requirement
• Worked on BIA/BWA issues impacting data quality in reports
• Imparting knowledge to the new recruits in various aspects of project handling and knowledge transition.
• Worked closely with SAP Basis and SAP Security team for successful upgrade delivery
• Handled all issues on priority by coordinating with other teams and provided regular updates to stakeholders
• Developed BW test scripts in HPQC for upgrade activities and worked on all testing scenarios to complete the testing for all landscapes
• Worked on hyper care issues
• Listed all business used BEx Workbooks and respective queries in the system then worked on planning and efforts for migration
• Converted all BEx workbooks into Analysis workbook manually
• Thorough unit and integration testing was performed and helped users for UAT completion. Created user guide for users for easy access to new tool
• Post migration created Analysis reports over newly created BEx queries

Confidential

Application Developer

Software: SAP BW 3.5, SAP BI 7.0, SAP BO 3.0, Remedy, HPQC (Testing tool)

Responsibilities:

• Responsible for incidents/Change Requests/Tasks/assignment from Remedy tool and monitoring data loads, perform weekly, monthly support activities and to work on development CRs
• Effective and efficient communication with key business users and within team
• Responsible for coordinating weekly and month end activities with countries and team
• Worked on multiple support issues include data mismatch between ECC and BW within BW, in reports due to query issues. Worked to fix those issues through debugging transformations, data sources, CMOD codes, short dumps, multi providers mappings, delta flows, debugging queries, fix calculated and restricted key figures, identifying currency translation/ unit conversion, debugging and fixing routines (BW routines/CMOD codes) and explaining the flow to user for user understanding issues
• Proactively identified the root cause of tickets and maintained tracker for same
• Worked on issues regarding support to BIA.
• Worked with Qlikview team to rectify their reporting issues
• Created few WEBI reports per user requirement
• Worked on developments related to CRs in all three areas of extraction modeling and reporting
• Attended meetings inter company, with client, with users
• Interacted with R/3 (Functional), PI teams for resolutions of various issues
• Provided KT to new Joiners
• Worked on data flow migration from BW 3.5 to BW 7.0 data flow
• During upgrade worked on multiple issues during flow migration due to object inconsistencies, ABAP coding compatibility etc.
• Worked on Unit testing, Integration testing and preparation of test cases
• Worked closely with users to resolve all issues raised during UAT
• After Go-live worked for hyper care support worked on post-production upgrade issues and timely resolved all

Confidential

Application Developer

Software: SAP BW 3.5, SAP BI 7.0, SAP BO 3.0

Responsibilities:

• Worked on performance and data inconsistencies
• Worked on data load monitoring and failures and took preventive majors/RCA for load failures in production system
• SLA based BW ticket resolution and implementation of change request participated in cut over activities for demand planning during upgrade project
• Worked on data validation, simulation, preview of data loads
• Created manual reports in excel as per stakeholders requirement
• Implemented Daily Flash Report (Sales reporting) application in SAP BI system for sales data flow from SAP ECC to SAP BI system
• Created objects like Info objects, Info cubes, Info source, Multi providers, Transfer structure, and Info packages, process chains at data modeling level as per design requirement
• Created BEx Queries on Multi Providers keeping in mind user requirements. Created Queries having Filters, Free Characteristics, Exceptions, Restricted Key Figures and Calculated Key Figures
• Created Web Templates in Web Application Designer for reports
• Created Business object WEBI reports
• Created excel/spreadsheet based dashboards for daily flash reports to share with higher management
• Created test plan in HP quality center and executed them for completion of testing
• Involved in UAT and hyper care support
• Created status and trend reports and shared with top management