SUMMARY:

• SAP Technical/Functional consultant with 10+ years of experience in providing Data Analytics, Data Modeling and Reporting solutions using SAP BW, SAP HANA, SAP ABAP and SAP BOBJ technology. Experience in multiple full cycle development and implementation.
• More than 10 years of BW Development experience with SAP BW7.3, 7.4, BW ON HANA, BW/4HANA
• Hands on experience in complex data modeling
• Involved in overall design, development, testing and maintenance of custom MultiProviders, InfoCubes, DSOs, DataSources, Custom Extractors, InfoObjects, DTP, etc. based on the reporting requirements
• Hands on experience in creating new BW/4HANA Objects such as: Composite Provider, Open ODS View, InfoObject, DataStore Object
• Experience converting classing BW objects to BW/4HANA objects (such as InfoCube to ODS Object)
• Worked on transformation start/end routines, extract structure and BEx queries
• Experience in data extraction from ECC, flat file to BW. Experience in data loading and designing/running process chain
• Hands on experience in development of reporting solutions in BOBJ tools (Lumira, WebI) with BEX queries as source
• Experience in designing/developing/testing Open Hubs
• Transport Collection and migration experience
• Experience in identifiying/resolving transport failures/issues during the transport process
• Hands on experience creating, executing, scheduling complex process chains
• Hands on experience in troubleshooting broken process chain
• Experience creating DTPs, DTPs with filter, error DTP etc
• Extensive experience doing peer review of BW objects and overall BW data modeling solution
• Extensive experience in developing Data Mapping documents, Technical documents and Function documents for BW solution
• Extensive experience in providing data flow diagram and present it to the management in both functional as well as technical manner
• Hands on experience in development on HANA Studio. Proficient in developing SAP HANA information models such as HANA Views (Calculation and Attribute views) with graphical and SQL scripting.
• Hands on experience in development of reporting solutions in BOBJ tools (Lumira, WebI) with HANA views as source
• Created several ABAP reports to analyze Purchase Order, Purchase Requisition, Sales, FI documents to validate the archiving criteria
• Created several ABAP reports to delete old/outdated documents from the system to free up the space
• Created report that lists all customers, the materials ordered and the net price for a given customer by sales area
• Hands on experience in design, development and testing of start routine, end routine, field routine and expert routine
• Development of RICE (Report, Interface, Conversion, Extension) objects as well as Technical Specifications from Functional Specifications, Creation of Component Test Cases
• Expertise in development/deployment of SAC/Design Studio Reports with several data presentation methods, mainly using tables, charts, filters, groups, breaks, drill down, data insertion based on the end user requirements.
• Knowledge of creating Design Studio Reports with several data presentation methods, mainly using tables, charts, filters, groups, breaks, drill down, linked reporting, based on the end user requirements.
• Expertise in creating WebI reports with several data presentation methods, mainly using tables, charts, filters, groups, breaks, etc.
• Used several WebI formatting options - formulas, variables, data synchronization, if logic for calculation, date functions, and so on
• Strong experience in creating multiple query, combined query, sub query
• Expertise in managing documents in CMC using BI Launch pad, integrating WebI documents in Live Office (Word, Excel, PowerPoint)
• Designed Dashboard reports with SAP BW and SAP HANA as data sources
• Experience in creating/modifying several static and dynamic dashboard reports
• Used various properties/tools of Dashboard Design to make simple to complex Reports such as - Components, various chart types, binding data by range, data by series, hybrid method, selectors, dynamic visibility, drilldown, ticker, alerts, List Builder etc.
• Experience in designing highly formatted reports in Crystal Reports for Enterprise, Crystal Report 2011/2008
• Experience in using various formatting options like Query Filter, Interactive Filter, Parameters (Static, Dynamic, Cascading), Formulas, Running Totals, Predefined Objects, Grouping, Sorting, Cross-tab report, sub-report, Chart, Flash file, Alerts
• Experience in designing, modifying BI Workspace (Dashboard Builder) and Module.
• Experience in creating/maintaining Information Spaces, Information View set using BOBJ Business Explorer
• Experience in creating Analysis Workspace, analyzing historical data from OLAP application (SAP BW, HANA)
• Strong experience in designing universe using UDT and IDT Tools
• Experience in resolving the loops, SQL traps (chasm, fan) by using Aliases, Contexts, and shortcut joins
• Experience in designing optimum universes using @Functions (@prompt, @aggregate aware, @select, @where, index awareness (primary/foreign key), aggregate tables, derived tables)
• Experience in creating single /multiple source universe on data targets like HANA tables, HANA views, MS Access, Oracle, and SAP BW Cubes, MultiProviders, BEx Queries.
• Created universes in IDT with BICS connection. Also, used relational, OLAP connections.
• Hands on experience in development with DENODO VDP 7.0. Proficient in extracting data from multiple sources and creating complex queries.

PROFESSIONAL EXPERIENCE:

Confidential, Fort Belvoir, VA

BOBJ/BW/HANA Developer

Responsibilities:

• I was responsible for resolving issues/tickets that were related to several solutions in Production and currently being transitioned to sustainment.
• These solutions were developed in SAP HANA, SAP BW and BOBJ tools.
• This project is about adding Army Aviation Enterprise capability and provide the Army enhanced Business Intelligence/Business Warehouse capabilities
• I was directly involved in requirement gathering, development using SAP HANA, BW, BOBJ as well as testing and executing the solution
• Hands on experience in development on DENODO VDP 7.0. Proficient in extracting data from multiple sources and creating complex queries.
• Creating/Testing connections to various data sources (HANA, HADOOP, SAP BW, ORACLE) and extracting data, merging, applying business logic and consuming the data by reporting layer/tools
• Designed/Developed complex data models in BW, Designed/developed several reports in SAP BOBJ (WEBI, Design Studio, Lumira) for Enterprise Materiel Status Reporting
• Created/Executed several test cases for BW models as well as BOBJ reports.
• Helped in requirements gathering
• Designed/Developed complex data models in BW, Designed/developed several reports in SAP BOBJ (WEBI, Design Studio, Lumira) for Enterprise Equipment Master
• Created/Executed several test cases for BW models as well as BOBJ reports.
• Helped in requirements gathering
• This project was about the creation of technical environment in SAP BW to extract AESIP’s Material Master Data from their ECC system to BW and provide reporting capability on top of that using SAP BOBJ technology.
• Created multiple Queries and WebI Reports as part of the Material Master Reporting solution delivery for Confidential for the Material related information.
• Helped designed the BW backend modeling architecture for the Material Master Reporting Solution.
• Technical and Functional requirement development.
• Created and executed Test Scripts.
• Involved in creation and execution of cutover documents development, execution as well as post-production support.
• MM3.3 scope included the business process of development, management, and distribution of Serviceable Reference Table, End Item Code, Material Category Position 4/5, SPI and Packaging information throughout the Army Enterprise.
• Created Technical and Functional requirements documentation.
• Created and Executed the Test Scripts in all three landscapes (Development, Quality, and Pre-Production).
• Designed, Created, and Tested several Web Intelligence (WebI) and Crystal Reports.
• Created cutover documents and executed them as part of deployment to production.
• Successfully obtained the user sign-off and handed the project over to sustainment.
• As for the reporting solutions, several reports for creation, update, change, historical reports were to be provided in SAP BW/BOBJ environment for this delivery.
• Created several BW Backend objects as part of the solution
• Created several BOBJ (WebI, Crystal, Dashboard) reports
• Involved with the entire project life cycle (development, testing, deployment)

Technology Consultant

Confidential, Rosslyn, VA

Responsibilities:

• Responsible for helping the development team with the development work.
• Worked on providing several reporting solutions using SAP Business Object Tools, mainly Web Intelligence.

Software Engineer

Confidential, Arlington, VA

Responsibilities:

• Delivered complex ‘Ranked List’ WebI report where the various opportunities are ranked based on their likelihood of conversion to sale. The report also includes information for each opportunity; including the name, ID, activity history, relationship with USPS, industry, and customer address information. The Ranked List Report offers powerful functionality; the user may filter records by district, job title, or sales representative and view prioritized opportunities at each sublevel.
• Delivered a complex ‘Closed Sales’ Dashboard report that informs USPS management about the gross movement of opportunities through sales process. The report aggregates opportunities by sales phase, specifically, as open opportunities, opportunities pending sale, sold opportunities and lost opportunities.
• Designed Universes to fulfill Sales Organization reporting requirements. For e.g. designed a complex universe that can be used to analyze the opportunities ranking based on their likelihood of conversion to sale. The universe was connected to Oracle based schemas. Universe had 11 tables and sufficient care was taken that they did not have any traps or loops. An aggregate fact table was used to have optimum performance. Developers were asked to create an aggregate table to fulfill this BOBJ reporting requirement.
• Participated in blue print sessions to gather reporting requirements
• Experience in converting requirements into data source mapping and then converting them into functional and technical design documents
• Experience in giving training to the client
• Experience in workload estimations and production cutover documents preparation

Confidential, Washington, DC

SAP BW/BOBJ Senior Analyst

Environment: SAP BOBJ 4.0, SAP BW 7.3, Oracle 11.2.0.2

Responsibilities:

• Assisted in Production System upgrade from BW 7.0 to 7.3 after successfully upgraded 3 lower level environments (Development, Test, and QA)
• Experience working with SAP to resolve the upgrade related issues
• Assisted in Business Objects upgrade from 3.1 to 4.0.

Confidential, Alexandria, VA

SAP BW/BOBJ Analyst

Environment: BOBJ 3.1, BW 7.0, Oracle, BEx Designer/ Analyzer

Responsibilities:

• Worked on developing a tool, DAG Tool, which achieved the following requirements:
• Apply Data Management and Governance principle
• Archive the documents that met archiving guidelines
• Delivered WebI reports for supply chain namely - Purchase Order Completion Report, Purchase Requisition Completion Report, and Sales Order Completion Report.
• Designed complex universes to fulfill supply chain reporting requirements.
• For e.g. designed a complex universe that can be used to analyze the completion of PO documents by DLA document type for a given cost center.
• The universe used the Purchase Order Header/Line item table, document type table, and multiple custom tables to analyze the KPIs like quantity and total cost.
• Experience in end to end ownership of developmental tasks, right from designing and development, integration testing and all the way to client presentation and training
• Attended various business meetings to gather, analyze and document functional and technical requirements for universes and reports, created functional/technical documentations
• Created unit/system/regression test scripts and executed them
• Participated in the regular project status meetings with the internal team and with the client
• Involved in overall development, testing and maintenance of custom MultiProviders, InfoCubes, DSOs, DataSources, Custom Extractors, InfoObjects, DTP, etc. based on the reporting requirements
• Worked on transformation start/end routines, extract structure
• Creating complex BEx Queries
• Experience in data extraction from ECC, flat file to BW. Experience in data loading and designing/running process chain