CAREER OBJECTIVE:

Accomplished Business Intelligence/Systems professional seeking a challenging career opportunity with a reputed company that is looking for a team member who is very detailed oriented and possess 12 years of experience in analysis, design and development of SAP Business Intelligence Solutions.

SUMMARY:

• Ten Years of working experience in coordinating and leading Blueprinting sessions, Requirement Gathering, Report Design and Documentation, Data Analysis, User Acceptance and User Training.
• Many Project Implementations experience including international using both Waterfall and Agile Methodologies (SDLC).
• Extensive Knowledge and Development experience in SAP Systems - BW, HANA, ECC, APO, SPP, EWM, SRM, CRM, SAP Business Objects, BEx Reporting, and BODS.
• SAP BI Expertise - ETL Modeling, Extraction, Reporting, Scheduling, ABAP, SQL Scripting, Performance Tuning.
• Working Experience in Leading Offshore Technical teams.
• Background in Supply Chain Management and Finance.
• Experience in coordinating and working on System Upgrades and Migrations.
• Experience with Project Management and Tracking Tools - Jira, MS Project, ALM, SharePoint, Solution Manger (SOLMAN)
• Proficient with MS Office - Excel, Access, Power Point, Visio
• Experienced and expert IT professional having expertise in driving diverse IT initiatives through strategic planning and facing challenging environments.
• Strong visualization, problem solving and analytical skills with good command over communication and interpersonal skills.

WORK EXPERIENCE:

Business System Analyst

Confidential

Responsibilities:

• Involved in end - to-end project for implementing BI Solutions for International Business.
• This is an Agile project, Worked closely with Architects, reviewed the Grainger BW Architecture and identified necessary changes so the system can accept cross-company, cross-currency data.
• Led Reporting workshops to identify and document Analytical requirements for Canada and Mexico Business in Supply Chain area.
• Worked in Solution Development and Delivery for AGI Pricing, Vistex Reporting, Master Data Re-org.
• Worked with Business Objects Data Services (BODS) and Information Steward for Data Migration.
• Developed Bex and Business Objects Webi Reports for Global Purchasing and Inventory Solutions.
• Lead Offshore Development Team with close monitoring and coordinating Development efforts, Reviews and code approvals.
• Involved in BW Migration to HANA. This was a prototyping initiative to migrate Grainger’s BW system onto HANA.
• Confidential system was successfully migrated to HANA DB.
• Interacted extensively with SAP AGS on migration issues; worked with end-users to complete testing. Worked with SAP on Max-attention Service, and implementing SAP’s recommendations.
• As a project team member, I’m responsible for Requirements Gathering, End-user interaction, Design and Developing BO-Webi Reports for SPP reporting solutions.
• Developed Critical Analysis Reports: on- Monthly EOQ Analysis, Demand Summary Report, Monthly Forecast Analysis, Fixed Demand Expirations Reporting etc.
• Involved in Data Analysis and worked with Functional Analyst to create Functional Specs for Warehouse Management Requirements.
• Developed Bex Reports for Storage Bin Analysis, worked with business users for test cases, involved in user acceptance testing and approvals.
• The requirement is unique to Grainger in the sense that multiple OLTP (EWM) systems connected to one BW system, which brings multiple technical challenges.
• Worked closely with Architects and Basis team on testing and successfully implementing SAP suggested solution for our unique requirement - multiple Grainger’s EWM systems connecting to one BW system.
• Involved in various SAP systems upgrades, issue resolution, testing, implementing new functionality.
• Confidential clearing activity, system refresh issues, validation of data after the upgrade.

SAP BI Analyst

Confidential, Chicago, IL

Responsibilities:

• Extensively involved in analyzing the reporting/planning requirements, design of a comprehensive reporting set-up in BI7.0 for Confidential 's ISCP Reporting.
• Involved in development of detailed Technical Designs based on Functional Designs and Functional Mapping documents.
• Developed Custom ETL Objects included source system enhancements to meet specific reporting. Created technical unit tests (Test Scripts) and performed unit tests of objects built. Actively involved in Integration Testing - Assembly as well as Connectivity testing.
• Effectively handled SIRS (Issue tickets), resolving the issues to users satisfaction and in time.
• Coordinated the transports for the team to migrate the developed objects to integration and production environments

Confidential, Chicago, IL

Performance Specialist

Responsibilities:

• Instrumental in improving query runtime performance - By the end of it, all the queries were running under 10m, drastic improvement from previous average run time of 75m.This resulted in client acceptance of the overall project.
• Involved in making query definition improvements to improve query performance. Query pruning was used to restrict the number of parallel queries on Multiproviders.
• Involved in running the daily runtime metrics and send stats to the Management.
• Worked with Report Agent functionality to warm up the cache and created potential aggregates based on selection criteria to improve query performance.