SUMMARY

• 8+ years experience as a SAP BI/BW/BOBJ Developer Architect, techno - functional consultant and lead with hands-on Upgrade experience.
• Excellent understanding of business processes in various industries like oil & gas, retail, manufacturing, medical and public sector.
• Proven ability to work as Project lead diligently with different levels of the client organization(Senior Management, Managers, and Analysts)
• Involved in multiple full-life cycle implementation following the ASAP methodology. Performed requirements gathering sessions with end users and designed BW systems to meet analytical needs. Vast experience in backend and frontend objects development.
• Good experience in designing Infocubes, DSOs by using data extracted from R/3 modules SD, Purchasing, MM, PM, PP, FM, FIAR/AP/GL, CO, CO-PA, HR, REFX as well as legacy systems.
• Expertise in development of queries using BEx analyzer in Excel Workbooks, BEx Web Application Designer, Business Objects OLAP and formatted queries using Crystal Reports.
• Hands-on experience in creating reports on DSOs, Infocubes, Virtual Multiproviders and Infosets. Excellent ABAP skills. Configured ETL and data flow to infoproviders.
• Knowledge of SAP HANA in-memory database technology which processes analytical and transactional data in-memory.
• Involved in data extraction using Business content datasources, LO Cockpit, CO-PA, Generic Extractors, Open Hub service and APD.
• Trained end-users on BW reporting.
• Strong analytical and system design skills.

TECHNICAL SKILLS

Data Warehousing: BI NW 7.3, 7.0, BI NW2004s, SAP BW 3.5, 3.0B, 2.1C

ERP: SAP ECC 6.0, R/3 4.6C, 4.5B, 4.0B, SAP Enterprise 5.0, 3.1H, ABAP/4, SD, MM, PP, PM, FM, FI/CO

Reporting: SAP BEx Analyzer, SAP Business Objects 3.1, 4.0, BW Web Application Designer, Web I, Explorer, Xcelsius, Crystal Reports

DBMS: Oracle 8.i/7.3, SQL Server, MS Access

Programming Languages: ABAP, HTML, PL/SQL

Applications: Developer 2000, MS Excel, Powerpoint, MS Project 2002/2000/98 , MS-Office XP/2000/98, Lotus Notes

Operating Systems: Windows Vista/XP/2000/NT/98, Linux, UNIX, Sun Solaris, Macintosh Op. System (Mac OS)

PROFESSIONAL EXPERIENCE

Confidential, California

SAP BI BOBJ Consultant

Environment: SAP BO 4.0 suite

Responsibilities:

• Responsible for delivering the reporting requirements as needed by the end users.
• Involved in requirements gathering sessions to determine the reports and created business blueprint documentation.
• Extensive usage of Business Objects as a report designing solution.
• Designed Universes, derived tables and Master Perspectives to create reports.
• Utilized WebI to design detailed reports with user defined conditions.
• Created Prompts to facilitate reports as determined by selection criteria entered by end users.
• Extensive usage of WebI features such as filters, sections, breaks and hierarchies.
• Used Xcelsius/Dashboard design tool to create dashboard functionality to facilitate improved end user navigation.
• Crystal Reports to format reports.

Confidential

SAP BW BOBJ Consultant / Architect

Environment: SAP-BI Netweaver 7.0, 7.3, BO 3.1, 4.0

Responsibilities:

• Highly involved in full life cycle of BWimplementation such as Database Sizing, Data requirements gathering, Participation in Business Blueprint Workshops, Gap analysis, face-face to interactions with business teams and decision-makers to identify business requirements and define a Project Charter.
• Involved in the implementation of SD, MM and FI Info cubes to extract the data from R/3 system and transporting intoBW and monitoring them.
• Extensive working knowledge in ASAP Methodology, Data Modeling. Extensive experience in Data Extraction from LO Cockpit, and Flat files.
• Performed several enhancements for business content cubes by adding custom infoobjects which were needed for reports.
• Involved in preparing design documents for data targets such as Infocubes and DSOs.
• Prepared reporting requirements and created queries in BEx analyzer. Extensive usage of restricted key figures, calculated key figures, exceptions, filters.
• Created user entry as well as customer exit variables in reports.
• Create reports in Business Objects suite and configuring multiple BO Universes. Used Xcelsius for designing Dashboard as per requirements.
• Created process chains for timely load of master data and also scheduled daily load of transaction data.
• Heavily involved in Go-Live and cutover activities. Provided production support after go live.
• Created Aggregates where needed to enhance query performance, performance tuning, number range buffering, BW Accelerator, Partitioning, Compression,BW Statistics, job Scheduling and load monitoring.
• Extensively involved in testing, Go-Live, Production Support, End-user training and Documentation.
• Loaded data from flat files and from Oracle DB via DB Connect.

Confidential, Bartlesville, OK

SAP BW Consultant

Environment: BI NW2004s, SAP ECC 6.0, Oracle DB, Windows XP

Responsibilities:

• P2P Project is a business processes project focused on optimizing Procurement processes in order to achieve maximum efficiency.
• I was part of the BI team that measured the efficiency of the business processes put in place by the P2P team. We achieved this by creating a set of 20 Metrics.
• Extensively involved in process of upgrade from B1 NW2004s to BI.7. Performed conversion of datasources from 3.x to 7.x and managed delta loads during the upgrade.
• We created 16 Leading Indicators and 4 KPIs (Key Performance Indicators).
• Heavily involved with Process team and functional team in order to decide on the formulas and logic to calculate the Metrics.
• The BI component was a very important part of the project because the results of the Metrics calculated by the BI team were used to measure the success of the P2P project.
• Hence there is significant onus and visibility on the BI team due to this.
• On the whole a very challenging project with heavy interaction with the business users and managers.
• Created web templates for the Metrics reports and utilized the bar graph feature. Published web templates in the Portal.
• Transport of objects from Dev to QA to Production environment.
• Flexible Real Estate Management
• Involved in backend development for REFX project.
• This is a new implementation in the formative stage.
• Activated Business Content cubes, queries. Also created custom queries.
• Used user exit in ECC and enhanced Master data for Contract, Property & Building.
• Created web templates and also utilized portal to display web templates.

Confidential, West Palm Beach, FL

SAP BW Lead Consultant

Environment: SAP BW 3.5, BI NW2004s, SAP ECC 5.0, Oracle 8i/8x, Windows XP.

Responsibilities:

• Collected business requirements from the business and functional R/3 teams and translated them into BW data models.
• Extensively worked on gathering the reporting requirements for Materials Management (Procurement) and Plant Management area as well as Funds Management area.
• Developed all the back-end objects for MM and PM functional areas and also created BEx queries.
• Performed enhancements to several R/3 extractors including Logistics extractors, master data extractors in order to achieve the analytical needs of end users.
• Performed several enhancements for business content cubes by adding custom infoobjects which were needed for reports.
• Implemented infocube partitioning to improve query response time after data compression.
• Developed BEx queries in MM and PM area and created variables to increase flexibility of the reports.
• Provided end users with versatile reports by enhancing both transaction and master datasources and using the concept of navigation attributes effectively.
• Developed a data flow and process chains to load data into the various data targets at scheduled times.
• Created jump queries using RRI functionality between two reports in BW. Also created jump queries between a BW query and an R/3 transaction in order to drill down into more detailed data.
• Trained end users on BEx functionality.
• I was the main functional and reporting resource in the team for Phase 2 rollout which included more backend enhancements and BEx reports.
• Prepared functional specs and developed all reports for the Comprehensive Annual Financial Report (CAFR), a very important annual Financial report prepared here at SFWMD.
• Presented the queries to the end users and functional team and based on their feedback modified the queries and their format.
• The client is now in the process of an upgrade to BI NW2004s. I was involved in a feasibility study along with the client resources and prepared a document on how BI NW2004s would replace existing processes of BW 3.5.
• I was instrumental in preparing the blueprint document for the upgrade and also performed various realization activities for the upgrade.
• Amongst the many new features, I explained to the client resources how the redesigned new write-optimized data store objects would greatly increase efficiency upon replacing the ODS in the current landscape.

Confidential, Houston, TX

SAP BW Consultant

Environment: SAP BW 3.0B, SAP R/3 4.6C, 3.1H, Oracle 8i/8x, Windows 2000/NT

Responsibilities:

• I was involved in the full life cycle implementation for this project right from blueprinting data modeling phase to go-live and continued by production support.
• Production & Revenue Accounting (PRA) is a customized SAP module developed only for Oil & Natural Gas companies.
• My primary role within the BW team was BW developer. I was in charge of data modeling, developing the infoobjects, cubes and ODSs. Also involved in meetings with business folks, end users to determine reporting needs and translate into BW specifications.
• Over 90 % of infoobjects used were custom. I was involved in designing the data model for several data targets based on the functional specifications collected from interaction with the R/3 team.
• Involved in extraction of PRA data and also FI data. Modification of several generic datasources. No business content extractors were available, so the project team had to build and implement generic extractors and work with the PRA SAP R/3 team in this regard.
• Developed several ODSs and infocubes and wrote ABAP routines for update and transfer rules in order to achieve unique reporting requirements.
• Designed and built process chains for loading of master, text and transaction data.
• Noteworthy tasks also included creating numerous customer exit variables and virtual key figures to satisfy analytic reporting.
• Involved in post production support. Activated BW Statistics cubes and created reports to analyze query performance, number of hits and query usage by end users. Accordingly undertook periodic r improvement tasks such as creating aggregates, used data retention strategy.