SUMMARY

• Certified in SAP HANA, SAP BW 3.x and 7.1
• Successfully implemented major Hana (side cart) HANA - BOBJ projects at 4 different Clients
• Successfully Completed Multiple End-to-End SAP BW implementations
• Designed and implemented Sales Planning (BW-IP) solution for a major food supply corporation
• In depth understanding in EDW, LSA and LSA++ Architectures and methodology
• Proven ability to Lead and Manage SAP BW implementation projects.
• Experience in multiple standard and customer built SAP extractors across multiple modules, such as FI(GL, AP, AR) CO-PA, HR-(PA, OM, TM) PP, SD, MM and PS.
• Project experience includes Aero Space Manufacturing, Financial Applications, Retail Applications and Governmental programs.

TECHNICAL SKILLS

• SAP HANA - Attribute Views, Calculation Views, SQL Procedures, Analytical Privileges and decision tables
• BOBJ - IDT,Universe, Web Intelligence, Xcelsius, Crystal Reports, Design Studio (exposure) and BODS 4.0
• Functional Understanding of SAP FI, CO, PS, MM, SD, HCM, Retail and IP
• SAP BW, ABAP, BEX, WAD and Oracle PL/SQL
• COBOL/370, CICS, VSAM, DB2, IMS/DB, JCL and Telon.
• ES-9000, OS/390, Z/OS, RS 6000 and MF COBOL.
• MS Office Products.

PROFESSIONAL EXPERIENCE

Confidential, White Plains, NY

SAP BI Solution Architect & Tech Lead Development

Responsibilities:

• This project is to replace ABAP-GR55 and KE24 Financial Statement (P&L, BS and Trending of the same) and CO-PA reports into Hana/BOBJ based Reports
• Built all the required views for the P&L, Balance Sheet and the various trending reports based on Quarters and periods.
• Built BOBJ Universe on top of the hana views to produce the required P&L, Balance Sheet Report Variants
• Security, Scheduling of the reports as per the user demands.

Environment: SAP HANA 2.2 Release 16 and BOBJ 4.1 Tools

Modules: FI, CO-PA

Confidential, Raleigh, NC

SAP BI Solution Architect & Lead HANA Development

Responsibilities:

• This project was to replace the existing ABAP Consolidation reports with Hana Views. So complicated multiple site ABAP programs were converted into equivalent HANA Views.
• Combined all Hana Views to create one single view to support a single universe
• Company based consolidated reports were built on Web Intelligence report. In the following phase these are to be replaced with Data Services jobs to load the data into Cognos consolidation model.

Environment: SAP HANA 1.0 Release 112 and BOBJ 4.1 Tools

Modules: SAP ABAP,FI, ASSETS

Confidential, Alachua, FL

SAP BI Solution Architect & Lead HANA Development

Responsibilities:

• This project was to build required hana views to produce sales, billing and delivery reports
• Built BOBJ Universe on top of the hana views to produce the required reports and built a custom security model to support the reporting need for the corporate.
• Built additional hana models to compare the CRM planning numbers against the Billing to determine Sales Rep’s Actual vs Planning goals.

Environment: SAP HANA 1.0 Release 112 and BOBJ 4.1 Tools

Modules: SD and CRM

Confidential, Wichita, KS

SAP BI Solution Architect & Lead HANA Development

Responsibilities:

• This shows the previous pricing conditions, sales prices used for material and for vendors
• Attribute views created based on the pricing tables and calculation view created to combine them for the reporting purpose. PLACE HOLDER syntax used to pass the parameter between Business Object Universe and HANA Calculation view.
• A single BOBJ Universe created to satisfy the reporting need.
• Multiple Web Intelligence created for the customer need.
• This is designed to show the Regular, Overtime Hours and Dollars across multiple cost centers.
• Multiple complex attribute and calculation views built to achieve the results.
• A BOBJ universe built on top of the calculation view with PLACE HOLDER to pass parameters and improve report performance.
• A Dashboard was built on Business Objects Xcelsius to show the charts interactively for Monthly, weekly and Daily variances.
• This is designed to show the costing objects, projects, WBS elements, cost center, cost elements, employee, hours and dollar for each WBS elements for various models.
• Multiple complex attribute and calculation views created
• Multiple Web Intelligence reports created on top of the universe with PLACE HOLDER to pass parameters used to improve the performance of the reports.
• This is designed to show the Quality Inspection for all the Airplanes built by the Confidential and show the trend on the number of inspection forms, defects, employee efficiency over a period, amount spent, regular and overtime paid for those specific teams. In short it will show how efficiently the Quality Inspection process runs in the company.
• The required data was acquired from multiple resources such as ECC/HANA and Oracle tables.
• The ECC data were obtained by means of complex attribute and calculation views.
• The Oracle data was obtained by creating PL/SQL and stage the data to improve performance.
• There are about 27 Web Intelligence reports and charts built against the data to provide the Inspection Metrics required for both the first and second level Managers.
• The Manager hierarchy handled with the help of PL/SQL staged data and HANA SQL manipulation within the HANA scripted calculation view.
• This shows the real-time production order, operation as it progress through the work centers.
• It includes some of the most complex HANA SQL Procedures and staged data to match the issues and receipts of material against the production orders for the next 30 days.
• There are more than 25 HANA SQL Procedures created by me to determine the order of production orders based of the urgency, issues and receipts of materials.
• These status codes get refreshed every 30 minutes to show the current location of the production order.
• Once the order of production order is determined the status will be assigned. This status will tell the shop floor team about the urgency of the production order. Also it helps them to see what need to be done from the status codes assigned by my procedures.
• There are numerous complex attribute and calculation views built to show the current location of order, operation related to the status assigned.
• Multiple BOBJ Universe built to show the dashboards and the Web Intelligence reports.

Environment: SAP HANA 1.0 Release 70, BODS and BOBJ 4.1 Tools, SAP ECC 6.0, ABAP/4, BI 7.1, BExModules: SD, PP, FI, CO and HR-PA, OM.

Confidential, TX

Responsibilities:

• Worked with the functional team and collected the requirements (FDS) and developed the Technical Design Specifications.
• Design the complete security strategy and provided end to end solution and coordinate between Customer, Security and BW Team to achieve the solution.
• Set standards and guidelines, Overall Architecture and decide the deliverables, review data models and help the teams in development where needed.
• Work with the offshore design and development teams.
• Validate and a rove delivered reports to the customer as part of deliverables.
• Built a prototype for the variant configuration data model and the required deliverables.

Environment: SAP ECC 6.0, ABAP/4, BW 7.3, BEx and Business Objects (Universe and Web I).

Modules: SD, MM, PP, FI and CO.

Confidential, NY

SAP BI Architect & Lead Development

Responsibilities:

• Arranged meetings and gathered building blocks for the reporting process and built the technical design documents to build the models to produce reports.
• Identified the related master data elements and enhanced them with required attributes and modified the user exits to load the new attributes.
• As required in the functional design specification designed and developed the P2P (Purchase, Inventory and Vistex) info providers (Multi-provider, info Cubes) using the existing extractors and made the changes to user exits.
• Design the Process Chain to load the info providers (Info Objects, DSO, Info Cubes and Multi-providers).
• Modified the BEx user exits to manage the variables necessary for the queries and validated the results to match the customers existing process.
• Created new Crystal Reports and Dashboard Design (Xcelsius) based on the BEx queries
• Design the security model for the BW implementation.
• Design and Implemented the Sales Planning using SA BW Integrated Planning and maintained the project for 3 years after implementation.
• Designed and developed the security architecture for the BW implementation.

Environment: SAP ECC 6.0, ABAP/4, BI 7.0, BEx and Business Objects tool set.

Modules: MM, CO and (SD) and Vistex.

Confidential, AZ

BI Lead Solution Architect

Responsibilities:

• Worked through the requirement phase to collect the business requirements.
• Build the proto-type dash board using BOBJ- Xcelsius tools.
• Used Visio and ER-Studio to build the required model design for the project development.
• Designed the star-schema and data modeling for the data warehouse for the reliability and working on the Finance model.
• Developing Data Mapping documents for the ETL Developers

Environment: ER/Studio 7.6.1, Informatica, (BOBJ XI 3.1/Cognos), Crystal Reports, Oracle 11g

Confidential, MA

SAP BI Lead Development & Solution Architect

Responsibilities:

• Assisted the customers in shaping up the functional design specifications and completed the technical design specification for the same.
• Identified the related master data elements and enhanced them with required attributes and modified the user exits to load the new attributes.
• As in the technical design specification design and developed the P2P info providers (Multi-provider, info Cubes) using the existing extractors and made the changes to user exits.
• Design the Process Chain to load the info providers (Info Objects, DSO, Info Cubes and Multi-providers).
• Modified the BEx user exits to manage the variables necessary for the queries and validated the results to match the customers existing process.
• Created new Crystal Reports based on the BEx queries and auto scheduled them using a trigger from the process chain based on the info provider’s successful loading.
• Using Live Office connection and the Crystal Report content created Xcelsius dash board for the purchase and requisition reports.
• Conducted User Training for the P2P Queries and explained how the BEx tool can be used to meet their needs.
• Helping the team to improve the load issues in terms of adjusting load parameters, tuning the ABAP codes in transformations and extractors.
• Adjust the Info Providers for better performance and reload where necessary, including adding and removing characteristics.

Environment: SAP ECC 6.0, ABAP/4, BW 3.5, BI 7.0, BEx, Crystal Reports and Xcelsius.

Modules: FI, CO and MM, APO (SCM Module).

Confidential, KS

SAP BI Lead Development & Solution Architect

Responsibilities:

• Developed the relationship extractor for Employee - Manager.
• Developed custom extractors for various attributes of employee.
• Customized the employee master data for general and specific groups.
• Developed the employee roster and created has/has not list.
• Created different PA Admin Info Cubes for additional reports.
• Tested Structural Authorization and implemented alternative methods for authorization for Organizational security.
• Manufacturing Dashboard is a critical reporting tool that gives the status of all airplanes (737, 747, and 777) that are being built by Confidential System for their customers.
• It gives the status of any line unit at a glance where it stands in-terms of Orders, Operation, Quality, Material, Cost and Labor.
• For each metric that shows up in the dashboard a detail query is made available as a jump-to query.
• Architect the whole model and built all the BI Objects and completed the implementation successfully and is being used by 800+ users on a daily basis to know their work center status.
• Developed trend Charts to see the performance of each work center and between line units.
• Worked and improved the performance of the queries and load times of all master data and transaction data.
• This dashboard eliminates 10 man hours effort of creating a corporate dashboard on a daily basis and discrepancy between reports produced by managers on the same day.
• This dashboard uses data from shop control, quality, material reservations and various master data.
• Every extractor is enhanced and customized and primarily used 2LIS 05 ARBPL, 2LIS 05 MATNR, 2LIS 05 COMP.
• A complex process chain is required to load all the data to create the dashboard and meet the SLA on a daily basis.
• All the work stream leads were trained to use the dash board and explained how the BEx tool can be used for their ad hoc query requirements.
• This report makes the financial and warehouse users to speedup their month end process.
• It also gives the detail of how their material is consumed and shows where the shortages or excess available in their storage locations every day.
• Gives them the consolidated ability to view the data at any time by profit center, origin group and GL Accounts.
• Worked with the functional teams to derive the requirements and designed the model to satisfy the user’s requirement.
• Enhanced inventory data sources BX, BF and master data. New custom master data is also created.
• The complete inventory model was built and put in place to meet the requirement successfully.
• Process chains are built and the users are satisfied with the outcome of this project.
• Conducted user training to maximize the use of the BEx queries and provided supporting documents with screen shots.

Environment: SAP ECC 6.0, ABAP/4, BI 2004S, BIA, BEx, BO SDK for SAP, Universe, WebI and Xcelcius.

Modules: HCM (PA, OM), PS, (SCM), PP, MM and QM.

Confidential, GA

SAP Lead Development - Project Manager (Deferred tax Revenue)

Responsibilities:

• The projected saving for this project was in the range of $85M and a recurring annual savings of least $2M.
• Created the project plan, project status and work assignments for the team of functional and technical persons.
• Worked with the user team and technical team to come to usable and agreeable report form for the BI reports.
• Constantly interacting with both functional and technical team to steer the project towards the successful implementation.
• Apart from being a project manager I was also the Architect for the whole BI team and the solution.
• Develop the templates required for the project management and BI development.
• Worked as a lead developer and architect to design a new project to convert ECC transactions based reports into BI reports for the account analysis project.
• This project created BI equivalent reports for ECC report CJE0, KE30, GR55 and Master data reports for elements ACCOUNT, WBS ELEMTS, CUSTOMER and MATERIAL.
• Created custom CO-PA extractor (cost based) for the KE30 report metrics.
• Used multiple data sources and staged them to ware house layer, application layer (DSO) and to reporting Info cubes (Multi-providers)
• Created queries to match the customer report and execute the BEx queries through custom ABAP program to create CSV files and automated the process through process chains.
• The generated files were delivered through shell scripts to various clients.

Environment: Oracle 9.0, SAP R/3 4.7, ABAP/4, BI 2004S, BIA and BEX.

Modules: CO-PA, PS, FI-GL and SD.

Confidential, TX

BW Sr. Analyst

Responsibilities:

• Designed the Information model to accommodate both the existing USA and Mexico data
• Enhanced the extractor and user exits for various transaction loads.
• Enhanced the update rules for the new data targets.
• Created queries updated user exits and defined and modified aggregates.
• Developed ABAP Programs to do various data target administration tasks to improve data loads.
• Created info spokes with BADI extension to extract data for the Enterprise Data Warehouse.
• Planned and defined cut over activities for the MX financial initiative.
• Lead and performed the year end cutover activities (Info Cubes, DSO)
• Worked extensively in the performance tuning of queries and aggregates and obtained good ratings from SAP.
• Load data from non-sap sources such as flat files and DB2 tables.
• Conducted and Presented best practices, logistics extraction and performance tuning to co-workers.
• Designed and updated the process chains for the daily loads and tuned for optimum load performance.
• Worked as a part of on-call rotation team and later as a secondary to other members of the team.
• As part of performance improvement redesigned most of the cubes in production and removed unused dimension and reloaded the info cubes and lead the team of 3 and managed the cutover activities.
• Continued to work with the users to improve enterprise wide data sharing through EDW solutions.
• Continued to monitor BW performance and take actions to meet the SLA.
• Designed auto scheduling of all process chains through event triggering with limited manual intervention.
• Introduced data warehouse layer to minimize load and aggregate build time on certain high volume data loads by means of removing delete overlapping request on full load to Info cubes.
• Created custom ABAP programs to calculate queries in the backend and combined multiple query results to produce single consolidated result.
• Introduced trickle feed process to reduce our high volume extraction of FI-GL load time in the nightly process
• Support and maintain with simple enhancements to the existing BPS systems.
• Developed FI and PCA related BEx queries and enhanced multiple financial queries for better performance.
• Lead the HCM-TM, PD teams successfully through the Project Prep and Blue Print stages to collect and assemble all the documents necessary.
• Developed few utility programs to identify Master data, info types in designing process chain master data dependencies, and gap analysis mapping.
• Collected various metrics required for the Time Reports and Personal Development modules.
• Created a unique model to incorporate Visual Composer with BI Queries to bring up any employee’s historical performance evaluation through the enterprise portal.
• Installed all the business contents and customized according to the collected blue print documents for each cycle reviews to get the go ahead from the user groups.
• Implemented structural Authorization.
• Worked as an extraction architect for retail forecast and replenishment and developed one of the most complex custom extractors for the retail project to identify the 8 weeks, 6 months and 52/53 weeks forecast deviation error reporting model. This will calculate and show the percentage error between actual and forecasted sales.
• Completed the conceptual model for Confidential Canada and sat with SAP Retail consultants to decide and conclude the final design.
• Designed all the extractors, DSOs, Info Cubes, Process Chains and Queries for the forecast error model.

Environment: DB2 9.0, SAP R/3 4.7, ECC 5.0, ABAP/4, SAP BW 3.1, BI 2004S, BIA, BEX, WAD and VC.

Modules: FI-GL, AP, AR, PS, MM, SD, Retail (F&R) and HCM-PA, OM, TM and PD.

Confidential

BW Consultant

• Participated in the Gap Analysis and put together the blue print document.
• Setup and designed the proto-type warehouse, which involved 35 info cubes and 12 ODS installed from Business Content.
• Setup all the master data, info sources, update rules and transaction data extraction for all the cubes.
• Installed the BW technical content cubes and developed queries.
• Designed reports and aggregates for the new and existing reports.
• Developed process chains for various data targets daily loads.
• Designed new info Spokes to interface with other departments to share data.
• Developed test plans and cutover plans.
• Worked on the post-production cutover plans and performance improvements.

Environment: SAP R/3 4.7, SAP BW 3.5 and BEX Analyzer.