PROFESSIONAL SUMMARY:

• Around 12+ years of professional experience of which over 10 years in SAP as Lead BW Consultant with strong leadership & inter personal skills. Hands - on expertise in SAP HANA, BW4HANA, BW, BO, BODS, BPC, Analysis Office, Tableau, Power BI & Cognos.
• Experience in working with cross functional teams and worked as a lead consultant for projects like on-site & offshore models.
• BW - 10 Years, HANA - 3+ Years, BO (WEBI & Explorer) - 5+ Years, BW HANA - 3+ Years, BODS - 2+ Years, BPC - 2 Years, Tableau (Developer & Admin) - 2+ Years, Power BI - 1+ Years, Analysis Office - 2+ Years
• Experience in multiple Implementation and support projects of BW4HANA, HANA, BW 7.x, Tableau, BODS, BO and Cognos 11.
• HANA MODELLING - Designing Views (Attribute View, Analytic View, and Calculation View), Stacked Calculation Views, Views that needs multiple table functions, counters, Restricted and Calculated measures, input parameters, filters, transparent filters, debugging Views and HANA Modelling using SQL Script & role creation.
• BW4HANA MODELLING - Enabling the external access to objects in BW and generating HANA views. Creating Composite provider/ODS Views. Using the tools to convert the existing BW objects to ADSO and generating HANA views for the BW Objects.
• Experience in HANA integration project, re-designing/migrating the existing data flows from SAP BW/ Sybase/ Legacy systems to HANA.
• Experience in BW4HANA upgrade/implementation project, migrating the existing BW objects to ADSO & re-developing the BW objects/data flows in BW4HANA, creating ODS views on top of remote sources using Smart Data Access.
• Developed a solution to generate reports using Open ODS views to minimize the support activities.
• Experience in BODS, created Data Service mappings to load the data from ECC and Oracle DW to SAP BW, the mapping involved extensive use of complex transformations like query/ case/ merge/ validation/ lookup/ transform the Data Flow.
• Sound experience in data modelling, design & development of BW/BI Objects (ETL Design & Reporting).
• Experience in developing the ETL process from SAP/Non- SAP systems to Sybase and then to report the data in WEBI/Explorer & Tableau.
• Developed complex reports including revisions within limited time and under budget from extensive experience with BOBJ using OLAP connecting (BICS) with the BW as backend.
• Defined the star schema on the data foundation in Information Design Tool.
• Designed and developed the ETL process from SAP & Non- SAP source systems using transformations and Customer Exits / User Exits / IP Routines / DTP Routines.
• Experience in designing APD’s & Open Hub destination process & related ABAP coding for OHD.
• Experience in Upgrade and Migration from BW 3.5 to BI 7.3, 7.4 & 7.5 and from BO 3.x to 4.x.
• Experience in extracting data from SAP R/3 like SD, MM, FICO & PP using new dimension products like BI extraction methods such as LO Cockpit and maintaining the delta queues.
• Experience in performance tuning, maintenance of system performance through compression, roll up of Aggregates, creating indexes and PSA deletion & Loading performance.
• Experience in creating the BEx queries, WEBI Reports & Dashboards and customer exist variables, Calculated/Restricted Key figures, Hierarchies, Hierarchy node variables, structures, UDT, IDT…. etc.
• Experience in post-production (after Go-live) support activities in various projects.
• Worked with Interface systems while sending reports to end users.
• Experience in BO tools, like WEBI, Explorer and Xcelsius reports. Migrated the existing BW reports to WEBI Reports & Dashboards using Universe & BICS connections.

TECHNICAL SKILLS:

Strategy/DB: HANA, Sybase, ERP, CRM, JDA, ACAM, AMAX, MYSQL

Technology: SAP, .Net, Kiel C, Networking, Sybase, Data Services, SQL

SAP: SAP BW4HANA, SAP BI / BW, SAP R/3, ABAP, BO, BODS, BPC, HANA, Vora

Reporting Tools: Analysis Office, BEx, Business Objects (WEBI, Dashboard designer & Crystal Reports), Tableau, Microsoft Power BI & EPM (BPC V 10.X)

PROFESSIONAL EXPERIENCE:

Confidential - Chicago

Lead BW/HANA Consultant

Applications - SAP BW, BO, BW4HANA, HANA, Analysis Office, Tableau, Cognos & Lumira.

Responsibilities:

• Participate and understand the business needs, application requirements and develop the required reports to gain access to the underlying data and to ensure the quality & error free deliverables.
• Responsible for providing process improvement solutions, design, enhancements & team management etc.
• Interact with the cross functional teams to understand the business needs/support for ongoing developments.
• Upgrade from 7.3 to 7.4 & then to BW4HANA upgrade. Upgrade activities & Post go-live support.
• Generating HANA views for the existing data flows to access them from BW4HANA & HANA.
• Lead the team of 6 consultants for the projects BW Upgrade & Migration to BW4HANA.
• Creating calculations views, ODS Views, ADSO’s, Composite provider, data flow as per the business requirements to report them in Analysis Office & WEBI
• Upgrade testing, migration testing, reports testing & message/fix the data issues per the analysis.
• Creating the reports/Dashboards in Analysis Office/WEBI & Tableau based on the business needs.

Confidential, California

Senior Analyst/Developer BW/HANA Consultant

Applications - HANA, SAP BW/BI, Business Objects, BODS, BPC, Tableau, Splunk & analytical applications.

Responsibilities:

• Architect, Implement & support all Business Analytical applications & solutions.
• Participate in high level meetings to gather the requirements from users on various KPI’s and to provide an effective solution for their reporting needs.
• Worked on multiple applications/tools across the landscape with good to know/understand mind set to help the users to understand the new/upgraded tools in the analytical area.
• Design/migrate from existing landscape to new landscape based on the reporting needs.
• Design and debug the new/existing flows to understand the bottlenecks and to fix the issues.
• Monitoring and fixing the load issues related to BW, BO, Data Services & JDA, AMAX, AGILE systems.
• Testing various Applications /Tools / Reports / Servers for any kind of planned/unplanned upgrades
• Other in-house support on the existing tools/applications.
• Handling/Worked on some of the internal projects in areas (SAP BW, BO, Data services & Tableau & Microsoft Power BI)
• Reports/Dashboards creation in BEx, BO, Tableau, Power BI & BPC
• Integrated the existing flows/reports with the other systems to provide the business with new/customize data models for analysis.
• Worked on Tableau upgrade projects and to enable SSL/SSO authentications, like Kerberos & SAML in Tableau.
• Worked on HANA developments, creating Analytical/Calculated Views to bring the data from HANA DB to Tableau & Power BI.
• Migrating data from JDA, SPEED, ECC to HANA (Integration Project).

Confidential - Pittsburgh, PA

Lead BW/BO HANA Consultant

Applications - SAP BW, Business Objects & Support on Functional SD, MM, PP, FICO

Responsibilities:

• Gathering the requirements from the users and providing solution/suggestion based on the requirements & developments.
• Creating/executing the test scenarios at the time of system upgrade (From BW 7.0 to BW 7.3).
• Re-engineering the existing processes and modifying them to fit/meet the requirement as requested by the users.
• Monitoring the process chains, fixing data load issues & new developments / Enhancements.
• Managing the support team (All Modules) onsite and offshore.
• As a Project Manager for BOBJ upgrade from 3.0 to 4.1 and carried out BW testing after upgrading the BW system to EHP1 (GOIB Client).
• New flows for transferring data from SAP to NON- SAP databases using Open Hub destination process.
• New developments & customization in FI (AR & AP) & Master Data enhancements.
• Worked on Issues related to BOBJ reports and the back end is BW.
• Created WEBI & Crystal reports and Dashboards related to FI (AR & AP) & (New G/L Account based data sources for rebate processing), HR for monitoring organization performance, SD (Billing) & PP.
• Creating & customizing the BEx queries as per the BOBJ Dashboard requirements.
• Developing the new webi reports as per the user’s requirements (Designing the backend ETL processes through APD’s & BEx queries) & moving the data from SAP to other databases by using Open Hub destination process.

Confidential - Chicago, IL

Senior BW Consultant

Applications - SAP BW, Business Explorer, MYSQL

Responsibilities:

• Developing the objects in BI 7.3 system as per the existing BW 3.5 system.
• Creating the complete data flow / Objects / Reports in the new BI 7.3 system as per BW 3.5 system which is current production system.
• Implementing new dataflow as per the business for new requirements related to SD & FI.
• Created Routines (Start, END & Field level) routines, custom variables, user exists.
• Enhanced FI data sources and related BADI which helps for direct access of the virtual providers.
• Creating the new reports as per the business.
• End to End testing.
• Load monitoring / Production Support.

Confidential

Senior BW Consultant

Applications - SAP BW, Business Explorer

Responsibilities:

• Production support, Support Incidents, developments & enhancements.
• Fixing the data load errors, analysis on improving the data load performance.
• Scheduled data loads to BW from SAP R/3. Monitored data loads which are running hourly, daily, weekly & monthly basis and solving errors in case of failures.
• Handling of errors while loading the data into Data Targets because of data inconsistencies, source system connectivity, conversion exits and Transfer Rules/Update Rules.
• Enhancements based on user requests.
• Supporting and monitoring the transports for Project releases. Loading the data into the targets as per the plan after transporting the objects successfully.
• Debugging the programs, update rules, transfer rules and transformations as per the restoration tickets.
• Converting some of the old processes/flows to 7.0 including the Open Hub destination processes.
• Contacting the business regarding the issues (Tickets).
• Providing the statuses of the tickets to the clients in daily & weekly meetings.
• Ad-hoc activities and testing.
• Performance testing after system hardware upgrade (Super Dom Testing)
• Fixed major recurring data load issues PSA deletion processes to make the system stable and completed successfully.
• Analyzed the data loads to improve load performance and successfully reduced the load timings by 2 hours (for daily applications).
• Automated few of the month end and year end activities / processes using ABAP routines.

Confidential

BW Consultant

Applications - SAP BW, Business Explorer

Responsibilities:

• Developments & Production Support.
• Creating the new data flows and info providers to achieve the business needs.
• Creating generic Data sources using Table / View / Info sets and applying the business logics as per the requirements in transformations & in User / Customer exists.
• Monitoring data loads, Custom developments, Production Support activities and generating queries.
• Created and modified Info Objects, Info cubes, DSOs and Transformations, loaded Transaction data from SAP R/3 and flat files with the help of Info Packages and DTPs.
• Created Generic Data Source by adding required fields to pull all historical data of sales.
• Worked on Xcelsius, WEBI, BEx Query Designer and WAD for creating reports.
• Configured daily, weekly, monthly Process chains for loading master data and transaction date into business warehouse.
• Participated in system upgrade activities.
• Customized/Configured Info Objects, Data Source, Info sources, Transfer Rules, Communication Structure, Update Rules, ODS Objects.
• Data Modelling, Data Extraction, Data Loads, Scheduling jobs, monitoring data loads Reporting and Support.
• Interacted with Subject Matter Experts, Business Analysts and Users for preparation of Data Modelling, Business Content, and Queries.
• Created Multi Providers on Info Cubes (Orders, Delivery and billing for specific queries) and DSO for unique restricted document level data.
• Created Info Objects, DSO’s & Info cubes and Transformations and loaded these objects with Master and Transactional data from SAP R/3 and flat files by creating Info Packages and DTP.
• Scheduled Info Packages to load data from DSOs to Info Cubes. Used Full and Delta to load the data into Data Targets daily & monthly, created process chains to automate the processes.
• Extensively worked on Performance concepts such as Cube Partitioning, Indexing, maintaining aggregates and Compression.
• Worked on BEx Analyzer in generating reports like Promotional Reports, Production list, Planning File Entries using Exceptions, Filters and conditions, Structures, Variables, Restricted and Calculated Key Figures and RRI.

Confidential

Customer Support/Quality Executive

Responsibilities:

• Quality Control - Developed and implemented a new Quality Control regime to assess customer service representative employee effectiveness, reducing service cancellation and improving customer satisfaction.
• Received appreciation from Confidential continuously for 3 times in a year.
• Managed a team of 30 in-house and 10 outsourced customer service representatives ensuring they deliver high quality customer support on daily basis.