SUMMARY

• Over 15+ years of experience in designing, development, and E2E implementation of Information Technology Systems in SAP BW/BI/HANA and ECC it includes 5 E2E Implementations on SAP BI/BW and 2 E2E implementation on HANA and development.
• Hands on experience in leading all stages of system development efforts, including requirements definition, design, architecture, Testing and project based efforts while managing, motivating, and guiding team.
• Experienced SAP BI with over 10+ years of experience in Commercial Industries.
• Excellent reputation for resolving problems, improving customer satisfaction, and driving overall operational improvements.
• Consistently saved costs while increasing profits.

TECHNICAL SKILLS

• SAP BI/BW Architecture,ETL
• Advanced
• Bex Explore (BEX) - Queries, Excel & Web Reporting
• SAP BPS/SAP IP
• SAP ABAP
• HTML,JAVA,C++,VBA,SQL
• MS Access, Excel
• Python,SQL
• Windows -XP,2000,NT
• SAP BOBJ
• SAP HANA
• Microsoft Office Suite
• Cognos,Qlikview,Tableau, PowerBI
• Predicted Analysis tool: Weka,Knime,RapidMiner, Alteryx
• SAP BPC
• SAP R/3 ECC 5.0, 4.7/4.6c/4.5/4.0,EH6,EHP7
• SAP BW 7.4, Data stage
• Reporting Tool: BOBJ WEB Intelligence, Cognos 8.x/7.x, Business Objects XI 3.1(Web Intelligence, Xcelsius) BEX Reporting, Web Reporting & BW 3.5/3.x/2.x, Crystal Report 7.X/8. X
• HANA Studio
• HR, SD, MM and FI/CO., APO, PP,
• Windows 7, 2000, NT, 98, XP, MS-DOS, Sun Solaris
• Visual Basic, Developer 2000, and SAP GUI
• SAP ABAP/4, JAVA and Visual Basic, R Language
• Oracle 9i/8i, SQL Server and MS-Access, Hana
• MS-Office & MS-Project

PROFESSIONAL EXPERIENCE

SAP ANALYTICS CONSULTANT

Confidential

Responsibilities:

• Involved in data migration and conversion activities that include, extraction, transformation, migration, validation and reconciliation of data.
• Involved in information gather phase.
• Designed and implemented SAP HANA data modeling using Attribute View, Analytic View, and Calculation View.
• Worked on Advanced DSO, Open ODS View, Composite providers & Transient providers.
• Proficient in importing HANA models into BW system.
• Extensively worked on Attribute Views (Standard, Time and Derived), Analytic and Calculation Views
• Graphical and Script based Creation of Hierarchies, Variables and Input parameters.
• Worked with Transient Providers, Hybrid Providers and Operational Data Provisioning.
• Facilitates collaboration with end users, Business leads, and Test leads to identify & categorize Test scenarios, Test cases, and Test data in QA. Provide reconciliation reports for business sign-off.
• Created seasonal Analysis dashboard tool to visualized trend and seasonality of the commodities.
• Use historical order data and standard statistical modeling techniques to generate the baseline statistical forecast in excel.

SAP BI Functional Analyst

Confidential

Responsibilities:

• Work directly with the business and other IT counterparts to prioritize, design, plan, manage, and deliver reporting and analytics solutions.
• Currently leading and managing an enterprise-wide effort of identifying the Key Performance Indicators (KPIs) across all the domains of the organization.
• These KPIs will be used to develop a corporate dashboard to facilitate fact based decision making.
• Highly motivated team player with Strong organizational, Presentation and Analytical skills.
• Interact with business representatives to gather requirements, prioritize work, develop enhancements to the existing system, coordinate testing, and perform change management/training for BI Reporting and applications.
• Designed Complex Web I reports including Combined Queries and Drill down reports.
• Worked on Creating WEBI reports using Prompts, filters, Variables and various Manual cell Calculations.
• Extensive experience in working on IDT (Information Design Tool).
• Created BICS Connection using IDT in SAP BI 4.0.
• Using Import selective Meta data for SAP BODS 4.1 imported Meta data in the ETL Process prior to on boarding data into sap HANA, created schemas and data provisioned using SAP LT Replication Server SLT
• Involved in business and Architecture discussions & studied of Business and technical flow of current objects to understand the Technical & Functional Migration.
• Conducted presentations for the senior leadership to communicate the status and escalate any issues requiring their intervention.

SAP BI Lead Analyst

Confidential

Responsibilities:

• Perform and document gap analysis.
• Prepare estimates for Global SAP and BW system Integration project.
• Work effectively with cross-functional teams within Global IT to ensure delivery of efficient solutions and to assist in problem identification and resolution.
• Responsible on handling integration between multiple systems for reporting using Xcelsius, Web Intelligence.
• Provided technical expertise to the business by developing Detailed Technical Designs, reviewed Functional Designs and conducted Data Model reviews.
• Understand design documentation including the high-level data model and understand the complexity and dependencies and plan the timelines for development based on the resource availability.
• Designed, developed and implemented enterprise-level Business Intelligence solutions to address ongoing business strategies.
• Involved in HANA development such as Calculation views Attribute/Analytic using HANA modeler.
• Setup Table Replication SLT for ECC table's real time into Hana.
• Data replication enhancements created for custom fields when required during replication.
• Performed data modeling and developed Analytical views for the transactional data, Attribute views for the master data, and the calculation views as final model in HANA Studio.
• Scheduled extract refresh for weekly and monthly reports.
• Gathered and analyzed the requirement to replicate the ECC content in HANA using data provisioning.
• Responsible in providing leadership, guidance, and mentoring for a team of 3 Business Intelligence members.
• Work closely with businesses to understand issues and requests for enhancements.
• Designed Web Reports Using Be Queries BICS Connection.
• Performed feasibility study on various BOBJ tools and recommended ideal tools that suffice the user requirements.
• Manage with Offshore Manila team to manage and coordinate daily Task.
• Conduct regression testing and take corrective actions as needed to ensure that existing BI solutions are not negatively impacted by changes in business rules and functionality.
• Lead weekly status meetings with the team to monitor progress.