We provide IT Staff Augmentation Services!

Senior Consultant Resume

SUMMARY:

  • Over 13 years of experience in IT Industry, including 12 Years of experience in SAP BW/BI and SAP ECC with specialization on Sales & Distribution (SD), Material Management (MM), Finance (FI), Controlling (CO), Media (SD - ME) Modules, 3 Years of HANA experience for BW on HANA and APO and 3 Years of experience in Embedded C/C++ and Mainframe.
  • Worked on many Full Life cycle Global Implementations in the Pharmaceutical, Manufacturing, Media, Financial Services, Oil & Gas Industries in US and India.
  • Activated, Installed and Extended Business Contents based on Gap Analysis established on user requirements.
  • Extensive experience on Data Warehousing Workbench (RSA1) Components: InfoObject, InfoSource, InfoPackage, InfoCube, ODS/DSO, Multiprovider, InfoSet, Update rules, Communication Structure, Transfer rules, Transformation Rules, Data Transfer Process (DTP) and Analysis Process Designer (APD).
  • Implemented Process Chain in BW to automate the Data Load (Full/Delta) into respective InfoCubes and ODS from ECC to BW for various ECC Modules.
  • Extensively worked on BEx (Business Explorer) Analyzer and Web Application Design (WAD) for building Queries. Created and Enhanced Queries using Conditions, Exceptions, Variables, Restricted Key Figures and Calculative Key Figures.
  • Performed SAP BW Performance Tuning by Creating Aggregates for frequently used Queries, Partitioning, Compression and Creating Secondary Index for InfoCubes.
  • Worked with ABAP Workbench in the areas of ABAP/4, Data Dictionary, IDoc, LSMW and Enhancements/User Exits.
  • Worked on different SAP BW version 3.0B/3.1C/7.0/7.3/HANA, SAP R/3 4.6C/4.7, ECC 5.0/6.0
  • Extensively worked on BusinessObjects (BO) Webi and Advance Analysis. Successfully implemented Dashboards using Confidential with different connectivity to BEx queries like Live Office, BICS (NetWeaver Connectivity), QaaWS (Query as a Web Services).
  • Creative Problem-Solving with effective interpersonal and organizational skills, ability to learn new things quickly in fast pace environment.
  • Worked on two full life cycles of product development using SDLC approach.
  • Worked on different aspects of different microprocessors, microcontrollers and ARMs.
  • Extensively worked on different IDEs (Integrated Development Environment) for software development using Embedded C/C++.
  • Also worked on different engineering tools for PCB designing and simulation of designed digital circuits.
  • Extensively worked on design part of different peripherals like keyboard, Crystal LCD, LEDs and speaker.

TECHNICAL SKILLS:

ERP: SAP BW version 3.0/3.1, SAP BI-7 (NW2004s), SAP BW HANA, R/3 version 4.5/4.6/4.6C, APO 4.0

SAP Modules: SD, MM, DP, SEM

Languages: C, C++, Embedded C, Embedded C++, J2EE, ABAP/4, COBOLEasyTrieve, IMS DB, VSAM, JCL

Database Tool: Oracle 8i, SQL, PL/SQL

Operating Systems: Win ’95, ’98, ‘2000, ‘NT, ‘XP, MS-DOS, Linux

Office Tools: Microsoft Word, Excel, Power Point, Access, Visio, Outlook

Web Tools: Microsoft FrontPage, HTML

Reporting Tool: BEx (Business Explorer) Analyzer, Web Application Design (WAD), Cognos, BusinessObjects Webi, Confidential, Advance Analysis Office

Processors: 8085, 8086, Intel 8051, Philips 89C51RD2, Philips ARM LPC21xx Family

Engineering Tools: Keil uVision 2.0, Keil uVision ARM 3.0, MATLAB, Express PCBProtel99 SE, TargetPool 3001.

PROFESSIONAL EXPERIENCE:

Confidential

Senior Consultant

Responsibilities:

  • As part of PROPLE R3, Confidential has decided to implement the SAP CRM and corresponding BW solution feeding data to GDW/GP.
  • I worked on my aspects of CRM systems like resource management, contact information, Quote Solution and Material Pricing.
  • Also worked on centering the business partner master for the usage for all the solutions across the board for CRM.
  • Worked on many areas of Quote Solution to apply complex logic in the end routine of the DSO - material pricing, different pricing condition, deletion and SCR changes, REF PH and PC configuration, adjusting product structure based on the item type etc.
  • Also worked on building two most useful function modules for multiple modules in BW for configuration material and items, as well as acquired company flag. These FMs are built with generic input to make sure they can be used by different solutions without much effort.
  • Material Pricing is one complex solution where depending up on the date intervals from multiple tables, detail date intervals are to be generated to make sure all the measures can be populated on the same line.
  • During go-live of the project, real time pending requirements were to fetch information from source every 15 minutes. This was scheduled since at that time only direct quotes were involved and volume was within the SLA of 15 minutes. After few months of go-live, there was a requirement raised to incorporated indirect quote along with direct in the same data set to be fetched every 15 minutes.
  • Indirect quotes were added to the existing extractor logic, but during EST business hours, and month/quarter end volume started increasing and at few instances, the run time started going beyond 45 minutes. This lead us to think about thinking of a new approach.
  • There were many issues that surfaced after go-live in production. It was hard to fix all the issue at the same time. With SLA being breached and with the existing issue, there was a need to look for another approach to tackle all the issues at the same time.
  • I suggested the real time approach, since the volume of pending quotes at any given time were next to constant of about 3000. Earlier approach was to fetch everything and drop unnecessary quotes from BW DSO after every 15 minutes load. I changed the approach and started fetching information real time from CRM only for the required number of pending quotes.
  • Earlier average time spent on CRM system every 15 minutes was approximately, 7 minutes. After the real time approach, the average time spent on CRM every 15 minutes is 3 minutes. Business is happy since now report looks accurate.
  • At Confidential, for material pricing they use external tool called Vendavo. Interface flow was, data was seeded in ECC which then was pushed to Vendavo. Vendavo is a pricing engine, which generates the pricing model depending on the algorithm. Once the pricing model data is generated, it pushes back the data to ECC in 14 different tables - A906, A911, A912 etc.
  • The ask was to create an extractor for BW to generate price book with two main measure - list price & field cost price. With the help of list price, there were many other measures needed to be calculated - maintenance, warranty, warranty upgrade & part retention costs.
  • Maintenance, Warranty, Warranty Upgrade & Part Retention costs were stored as % of list price in the table KONP. The only issue was the validity dates. All of the 14 tables had their own validity dates and it was hard to determine the continuous interval using all the 14 tables.
  • Business agreed to use one table for all of these meausures - ie. A913 for maintenance, A665 for Warranty etc.
  • After go-live, they asked for the accurate price and they asked to in corporate all the tables. We started incorporating the tables and performance of the extractor started to deteriorate.
  • I worked with basis to pin point the exact point in the code which needed to be tuned. After the fix, the extractor started to take 5 minutes from 6 hours to load about 350k records from ECC to BW.
  • Once performance tuning was taken care of, we started incorporating more tables for all the measures.
  • Extractor is successfully working in production without any issues.
  • A New revenue flow has been created for PROPEL R3. This was replicated from the production as starting point and then updated/modified as per the new requirements from PROPLE R3.
  • A new block of code is added for the software unbundling and covered product to suffice the requirement for PROPEL R3.
  • Also a new cost flow is developed using the new R3 requirements.
  • Supported the testing through all the testing phases of cycle 1, 2, 3 and Biz Sim.
  • As a part of migration project humongous tables of deferred revenue were to migrate to HANA database in ECC. These tables are crucial for business and it was very much important to make sure the table after migration holds the same data as of old table.
  • Manual comparison of these tables were not possible due to the volume of the table.
  • The approach was suggested to migrate the old ECC tables into HANA sidecar on BW and later through methods the data is compared in BW on HANA.
  • After the first migration test, it was very much evident that only comparison was not enough and migration team needed the data before and after to see why there is a discrepancy.
  • To give them this flexibility HAP (HANA Analysis Process) was designed on the method and the data was pushed to BW from HANA through the datasource based on the HAP.
  • BEx (Business Explorer) queries were also created on the ADSO holding data discrepancy for easy access to the data for migration team.

Environment: SAP ECC 6.0, SAP BI 7.4, BusinessObjects 4.0 Webi, BusinessObjects 4.0 Advance Analysis Excel/Web, Microsoft Office

Confidential, Southborough, MA

Principal SAP BW/BI Techno-Functional Consultant

Responsibilities:

  • Deferred Revenue Reporting is one of the key business report in Confidential organization.
  • DRR gives Confidential an insight to the revenue which Confidential is going to earn in the upcoming quarters as a part of their contracting services to end users for their sold products - Hardware, Services etc.
  • Since DRR is mix of multiple business areas - Sales (Bookings) & Finance (Revenue), it was hard to co-relate both the data set into one report till date.
  • My role was to have DRR as a reality and it has been executed quite well and successful.
  • Extensively worked with business to understand the requirement and pain points so far in existing reports.
  • Generated the data architecture to for DRR and developed the same with the most efficient and accurate ABAP programming.
  • Also generated the deletion logic into SAP BW using complex ABAP to overcome the shortcoming functionality of SAP ECC.
  • Data has been merged and massaged into SAP BW and sent to GreenPlum ( Confidential Propritory Datawarehouse) and reported in Tabluea.
  • Data is prepared to the most possible extent to minimize the support effort in GreenPlum and Tableau.
  • Also created a summary report in BOBJ-Webi for the aggregated view of the data to help end user facilitate in their quarter end process.
  • Open PO report has been in Confidential since its first go-live, but since then it has never satisfied the business requirement. Since the open PO involves the business key dimensions from PO creation to delivery (goods receipt), different data grain was always a challenge in BW.
  • To mitigate this gaps, I first created an ABAP ALV grid report in ECC for the business to test to make sure that logic given by business would work for them.
  • Initial idea was to move this to production as the final output, but then later business came back asking for the slice and dice functionality, which demands for BW / BOBJ.
  • Depending upon the type of orders - Direct, Single account assignment and Multiple account assignments, all POs are first segregated and then treated depending upon the logic given by business.
  • The major breakthrough in this solution was to have a custom extractor on EKBE, since the after ever goods receipt and/or invoice the report should be updated with the new total good receipt quantity and/or invoice quantity and amount.
  • I worked with the process team to learn more about how the data gets into EKBE and determine that once data entered into EKBE, it can never be changed. It can be reversed to cancel the goods receipt, but existing material document can never be updated.
  • Once we brought EKBE into BW, another challenge was to change the existing data in BW and for that we prepared the delta in such a way that every time a GR or Invoice is posted, it creates delta for PO item and while looking up on EKEB, quantity and amounts would be updated.
  • As a part of R3 PROPEL, I worked on multiple solutions like - Resource, Pricing Book, Contacts, Customers and Quotes.
  • The main responsibility is to read through the functional document prepared by the business and design a data model to suffice the same.
  • Develop the data model in development environment and also prepare the Technical Document for future .
  • Also prepare the Unit Test document and support and defect during the FAT.
  • Currently all the solutions are in FAT and being tested.

Environment: SAP ECC 6.0, SAP BI 7.3, BusinessObjects 4.0 Webi, BusinessObjects 4.0 Advance Analysis Excel/Web, Microsoft Office

Confidential, Findlay, OH

Senior SAP BW/BI Techno-Functional Consultant

Responsibilities:

  • Worked with data team and many process team from ECC to understand the conversion data and how the data is currently stored in legacy.
  • Met with legacy people to understand what level of detail is available from legacy system and what is the current process of loading data into SAP BW.
  • Worked with the SAP America to understand the actual implemented Pre-Consolidated Cubes and the current design.
  • Identified the conversion objects for which mapping data is required for historical data conversion in BW.
  • Worked with technical team to make sure, table structure is compatible enough to be used for SAP BW Historical Data Conversion.
  • Prepared the high-level and detail-level conversion strategy mentioning scope of work, assumptions, risks and mitigation strategy, data loading and data validation strategy.
  • Prepared the detail technical specification for SAP America to do actual development.
  • Presented the strategy document (functional specification) to client and got the sign-off from client and technical team.

Environment: SAP ECC 6.0, SAP BI 7.3, BusinessObjects 4.0 Webi, BusinessObjects 4.0 Advance Analysis Excel/Web, Microsoft Office

Confidential, New Haven, CT

Senior SAP BW/BI Techno-Functional Consultant

Responsibilities:

  • Documented the draft functional requirements in excel and prepared the gap that needs to be filled in before functional specs can be written.
  • Meeting with business users to understand the gap and document the functional requirements to list down the reports required by business.
  • Performed the rationalization of the report to make sure, number of reports per function modules look feasible in the given time frame.
  • Prepared the functional specification template and documented sample functional specifications for business user as a starting point.
  • Ran all the responsible business users through template and made sure they understand what to fill in and change in the existing functional specification to document their requirements.
  • Got the sign-off on agreed upon functional specs in a timely manner.
  • Also prepared the strategy to convert historical data into a warehouse for a reporting.
  • Suggested different options with pros-cons of each of them to the business and suggested them the best option that may be feasible for them.
  • Also worked on the draft data architecture for UIL based on the requirement gathered from users.
  • Prepared the draft DA document to give business an idea about the future architecture of their BW system may look like.

Environment: SAP ECC 6.0, SAP BI 7.01 (NW2004s), Microsoft Office, Microsoft Visio

Confidential, Houston, TX

Senior SAP BW/BI Functional Consultant

Responsibilities:

  • Worked with end users at Confidential to understand their supply chain business and requirements for the BI reports.
  • Worked closely with the technical business process team to identify the source of data based on the requirements mentioned in functional specification documents.
  • Translated the business requirements into technical requirements using the BI expertise and knowledge. Worked with development team members to make sure they understand the technical requirements in depth.
  • Also made sure that development team understands the business requirement and process, which helped them developing back-end objects keeping any future requirement that may come in.
  • Also architect the data model in the area of supply chain keeping usage of business content and any customization that may require to suffice the business requirements.
  • Also worked on design, development and testing of some of the urgent requirements from business which involves enhancement of datasource, BW ETL and creation of new report.
  • Worked on the design and development of process chains considering business dependency.
  • Also reviewed and approved designed from other process teams and proved by data architect skills by pointing out strong design issues and giving suggestions to resolve them.
  • I have also worked in BOBJ tool for 2 years, so I am very well familiar with the compatibility issues of BOBJ and BI.
  • I have also designed couple of Webi reports and created some demo dashboard components where user can jump from Webi to BEx queries and from Dashboard to BEx queries by passing the prompt selection.
  • Recently working on Sustainment activity, where I am bringing value to business by correcting any issues with the existing data model or queries.
  • Have hands-on Experience on Confidential Builder and Confidential Dashboard builder.
  • Also worked on BO Web Intelligence to prepare the validation reports for Confidential .
  • Worked on different components of Confidential, e.g. button based menu, different charts, URL (to jump from Confidential to BEx queries) and print button.
  • There are many BEx functions, which make BEx query non-compatible with BOBJ. Worked on those queries to find out the 50/50 solution, where most can be delivery from BEX queries and rest can be computed in BOBJ.
  • Executive Dashboard is designed in Confidential and comprises of 5 important KPIs identified by the business. Because these KPIs span across multiple functions and grain is differently stored in different InfoCubes, we brought up a concept of KPI cube.
  • KPI Cube is a single cube where all the required KPIs are stored at required grain for dashboard. This may also contain the required data with respect to time horizon.
  • To achieve the KPI Cube, we used the existing queries from different funtions and used them into APD. Using different APD processes, we achieved the required gain and stored the information into single DSO and then into KPI Cube.
  • Also suggested label based menu for better visibility of selection for profit center hierarchy selection.
  • Mentioned executive dashboard was built through QaaWS and currently being re-designed in BICS.
  • After the acceptance of Executive Dashboard, business came up with the idea of creating a dashboard by different functional managers.
  • As I am the functional owner for supply chain, I am involved in design of supply chain dashboard. This dashboard is designed in BICS and this dashboard shows many strong points of using BICS over QaaWS / Webi-Live office connection.

Environment: SAP ECC 6.0, SAP BI 7.01 (NW2004s), BEx Analyzer, Business Objects XI 3.1 Enterprise, Confidential 2008 FP 2.3

Confidential

SAP BW/BI Manager - BI Architect

Responsibilities:

  • Activated the Media Sales & Distribution Standard Datasources from Business Content in R/3.
  • Also created some of the generic extractors based on views/tables as per the requirement.
  • Create generic extractors in SAP BI based on two InfoObjects’ M Tables and T Tables. Used the extractor to generate the transactional data.
  • Worked on transformation rules to create a monthly record into daily records for a month.
  • Enhanced the standard datasource 2LIS 11 VAITM through the communication structure. The enhanced field was VBKD-POSEX N.
  • Also enhanced the standard datasource 0FIAR 4 to add the business area into it.
  • Create ODS and Infocubes as a part of ETL process to store the data. Also created mutliprovider to integrate the data from all the circulations InfoCube.
  • Create InfoSet to have the inner join from two DSO and have that data loaded into InfoCubes for further processing
  • Worked on the data level security to ensure that the data is access in the desired manner and there shouldn’t be any issue while accessing the same data through BO or Dashboard.
  • Created BEx queries, so that the performance is optimized at the BO Webi Reports and Dashboards.
  • Have hands-on Experience on Confidential Builder and Confidential Dashboard builder.
  • Also worked on BO Web Intelligence to prepare the data for Confidential .
  • Worked on different charts like Pie Chart, Column Chart, Line Chart, Alerts and selectors like Combo Box, List Box, Check Box, Radio Buttons in Confidential .
  • Create the required ETL in SAP BI and arranged the objects in BI so that all the data can be fit in minimum objects, which gives good flexibility in the maintenance work.

Environment: SAP ECC 6.0, SAP BI 7.01 (NW2004s), BEx Analyzer, Web Application Designer (WAD 7.0), Business Objects XI 3.1 Enterprise, Confidential 2008 FP 2.3

Confidential

SAP BW/BI Manager

Responsibilities:

  • Almost 80 existing BEx queries are migrated to web reports.
  • BI 7.0 Web Template is designed for Specner’s with Logo, Report title, Tab Strip, Check Box, List Box, Quick Link buttons & Navigational Pane.
  • Also demonstrated the BI 7.0 advance features to client
  • Designed the front page in Web Application Designer 3.x with the frames, picture and tickers.
  • Also designed the reporting roles and re-arranged the existing reporting roles as per the client’s requirements.
  • Worked on data level security and assured that new roles do not affect or overlap with the existing roles in the system.
  • Also designed the Confidential ’s Portal theme and customized the same.
  • Prepared the detail document, explaining the migration of web template for any future changes or new requirements and delivered the same to the client.
  • Have hands-on Experience on Confidential Builder and Confidential Dashboard builder.
  • Also worked on BO Web Intelligence to prepare the data for Confidential .
  • Worked on different charts like Pie Chart, Column Chart, Line Chart, Alerts and selectors like Combo Box, List Box, Check Box, Radio Buttons in Confidential .
  • Create the required ETL in SAP BI and arranged the objects in BI so that all the data can be fit in minimum objects, which gives good flexibility in the maintenance work.
  • Also worked on APD (Analysis Process Designer) to cook the data required for BO & Confidential for the given time frame.

Environment: SAP ECC 6.0, SAP BI 7.0 (NW2004s), BEx Analyzer, Web Application Designer (WAD 7.0), BI Java SP19-Patch 30 Portal, Business Objects XI 3.1, Confidential 2008

Confidential

SAP BW/BI Senior Consultant

Responsibilities:

  • Analyzed the source of the information and did a detail study on the source systems. Prepared the matrix to conclude what % of data is available in SAP R/3 and flat file (Excel).
  • Prepared the blue printing for the solution and implemented the same. Designed the BW Objects like InfoCube, DSO, Transformation rules and queries.
  • Also wrote the ABAP routines wherever required.
  • Design the end result in BEx queries which will be further implemented through Crystal / BO Solution.
  • Analyzed the source of the information and did a detail study on the source systems. Prepared the matrix to conclude what % of data is available in SAP R/3 and flat file (Excel).
  • Prepared the blue printing for the solution and implemented the same. Designed the BW Objects like InfoCube, DSO, Transformation rules and queries.
  • Prepared the Cost Center and Cost Element Hierarchy as per the business requirement. Created different Cost Center hierarchy as per the report requirements.
  • Also wrote the ABAP routines for customer exit variables.
  • Design the end result in BEx queries which will be further implemented through Crystal / BO Solution.
  • Analyzed the source of the information and did a detail study on the source systems. Prepared the matrix to conclude what % of data is available in SAP R/3 and flat file (Excel).
  • Prepared the rough blueprinting and tested the same. MIS is sourcing data out of many systems, so further needs to prepare the compatibility chart in terms of the data granularity.

Environment: SAP ECC 6.0, SAP BI 7.0 (NW2004s), BEx Analyzer

Confidential

SAP BW/BI Senior Consultant

Responsibilities:

  • Analyzed the source of the information and did a detail study on the source systems. Prepared the matrix to conclude what % of data is available in SAP R/3 and flat file (Excel).
  • Install the business content for Sales & Distrbution, Material Management, Production Planning and Finance AP (Account Payable) and AR (Account Receivable) and enhanced the same as client’s requirement.
  • Implemented the Sales & Distrubution, Material Management, Production Planning and Finance AP (Account Payable) and AR (Account Receivable) as a part of PoC in BI7.0.
  • Created multiple reports in BEx and WAD 3.x and published the same into the specified role.
  • Created different queries and Web reports which include graphs, canned reports and analytical reports.
  • Also demonstrated the functionality and capability of Business Intelligent Warehouse as a reporting tool.

Environment: SAP ECC 6.0, SAP BI 7.0 (NW2004s), BEx Analyzer, Web Application Designer (3.x)

Confidential

SAP BW/BI Senior Consultant

Responsibilities:

  • Analyzed the reports and prepared the pain points for each of the reports. Also prepared the corrective actions and suggestions. All the actions and suggestions are prepared after thorough testing in the Quality system.
  • Report requirement to run the report by region / store all the time. Used the split data logic split the data from ONE InfoCube to multiple InfoCube. Configured the multiprovider accordingly to improve the report performance.
  • Also suggested aggregates based on the query definition. Creating aggregates for big regions also helped improving query performance.
  • Performed the Data Archiving of the data providers to improve the report performance. Prepared the detail document explaining step-by-step procedure and delivered the same to client for future .
  • Tested the Scheduling of background report using Reporting Agent in BI 7.0. Prepared the detail document explaining step-by-step procedure and delivered the same to client for their future .
  • Prepared the Shell Script for POS data Load improvement.
  • Designed and developed the Open Hub Destination and APD to improve the basket analysis daily APD data load. Client BI team could never load the data since January 2009 for the mentioned report, which is made possible through modified design.
  • Also helped client BI team to prepare one CRM report. Client requirement was to write a macro to populate certain result in the report. Prepared the performance optimal macro to make sure that macro doesn’t become overhead for the query performance.
  • Apart from the major contribution, helped Confidential BI team time-by-time on small issues they faced during the period of assignment

Environment: SAP ECC 6.0, SAP BI 7.0 (NW2004s), BEx Analyzer

Hire Now