SUMMARY:

• SAP Certified BW 3.0 Solutions Consultant
• Over 8 Years of professional experience in design, development, and implementation of business applications, design and development of full life cycle implementation, of SAP BI as Techno Functional consultant.
• Successfully implemented more than 3 highly visible projects as project manager at different customer locations
• Highly motivated team player with strong communication, organizational and analytical skills.
• Worked in teams and adhered to the planned development time frame.
• Excellent analytical, communication and presentation skills.
• Implemented 9 full life cycle BW projects for FI, CO, Procurement, SD, Inventory, IPM and SPM 2.0 (Spend Performance Management - Spend Analytics) modules
• Exposed to full lifecycle right from BW configuration, modeling, analysis, design specification, development, performance tuning and maintenance
• Experience in all areas of SAP BW which includes Data-Modeling, Data Extraction, Generic Extraction, Data Loading (Full/Delta Up-Load), Scheduling, Monitoring, Info-cubes, Info-Source, Multi-Providers, ODS objects, BEx-Analyzer, BEx-Query, Work books, Web Reporting and Xcelsius 2008.
• Involved in end to end design and construction of BW objects
• Proficient in data modeling using MDM and BW extended star schema models
• Extensively built InfoObjects, InfoSources, InfoPackages, ODS, InfoCubes.
• Performed extensive CO-PA, LO Cockpit and generic data extractions.
• Configured and implemented BW reporting using BEx analyzer/browser and WAD
• Worked in BEx Analyzer in building Queries and saving it in Workbooks and created Custom Queries using Variables & Structures, Aggregates - Jump queries
• Worked extensively on Web reporting.
• Worked on Xcelsius 2008 SP3 to create dashboards connecting directly to Bex queries using BICS connectivity
• Worked on SAP Enterprise Portal iViews and Roles. And hands on experience in transporting Portal objects
• Knowledge of BW and Enterprise Portal security and authorizations
• Ability to interpret ABAP routines written in BW.
• Very strong in developing complicated custom queries
• Ability to Configure and implement BW reporting using BEx analyzer/browser and WAD
• Worked extensively on BEx Query designer building custom queries and hosted the same on SAP Portal.
• Ability to interact with business users to identify the reporting requirements and deliver the same in the expected time frame
• Strong Practical and conceptual knowledge of Restricted Key Figures, Calculated Key Figures, Exceptions, Conditions, Variables and Filters, and their usage to derive the expected results
• Knowledge of CRM and its functional scope in the world of BW
• Ability to understand, interpret and corner potential and existing problems to come out with feasible solution
• Performed Test runs to test sample reports adhering to the reporting requirements to get the final user approval
• Strong in BW touch-points to SAP modules like FI/CO, SD, MM, HR, IPM. Spend Analytics 2.0 and SAP products like ECC, APO and CRM
• Ability to understand what is delivered in SAP standard Business Content and the areas that warrant custom development.
• Conducted training for end-users. Developed business process documentation.
• Scheduling of Data upload with data Targets as PSA/ODS/ Info Cube.
• Capable of developing, documenting, and enforcing guidelines for application development to ensure high standards for usability and customer experience.
• Strong planner and organizer with demonstrated ability to master new concepts quickly, incorporate the latest technology, and develop business solutions that increase efficiency, productivity, and profitability.

COMPUTER SKILLS:

• ERP: SAP R/3 4.7, 4.6c, 4.6b, 4.0b, 3.x, and ECC 5.0/6.0
• Data Warehousing: BW 7.3BW 7.01 (EHP1), BI 7.0,BW 3.5, 3.1c, 3.0b, 2.1c.
• Analytical tools: BOBJ 3.1, BEX, WAD
• Databases:Oracle 9i/8i/8.0/7.x, DB2, SQL Server 7.0, MS SQL Server 2000, MySQL, and Sybase.
• IDE/Front End Tools: Microsoft Developer Studio, Adobe Photoshop, Flash, MS FrontPage, Top Style.
• Operating Systems: Linux, UNIX, Windows NT/XP/2000/98/95.

• Masters in Information Systems Management

PROFESSIONAL EXPERIENCE:

Confidential,Houston, TX July ‘12 – Till date
Project Manager/SAP BW Team Lead

Environment: SAP ECC 6.0, SAP BW 7.3, BEX, Adobe Flex UI, DB2, Windows 7

Responsibilities:

• Played combined role of Project Manager and BW Architect to help the customer to implement SPM 3.0 (Spend Performance Management)
• Leading a virtual/physical team of 5 resources
• Participated in creating a RFP for SPM implementation
• Responsible to plan, schedule and execute all stages of enterprise software, hardware and system implementations.
• Assessed business implications for each project phase and monitored progress to meet deadlines, standards and cost targets.
• Provided business consulting, knowledge expertise in spend performance management methodologies, process assessment work, and the application of technologies to business.
• Created project plan and made sure that the team aligned to time lines and budget
• Conducted weekly status meeting with all the stake holders to address any issues/concerns they might have and let them know where the team stands on the timelines
• Actively involved in requirement gathering from end users
• Suggested/implemented SAP BW best practices duringdifferent cycles of the project
• Configured and implemented SPM data extraction kit
• Installed SPM related business content and customized the content to include additional fields
• Prepared blueprint document and got it approved by the project stakeholders
• Helped customer in categorizing their Spend into Direct vs., Indirect
• Guided BASIS in installing different SPM components
• Incorporated custom logic to categorize Spend at different levels
• Configured the SPM UI

Confidential,Temecula, CA Dec ‘11 – June ’11
SAP BW Architect

Environment: SAP ECC 6.0, SAP BW 7.3, BEX, ORACLE, Windows 7

Responsibilities:

• Was responsible for overall SAP BW architecture design
• Configured SAP BW 7.3 fresh install
• Estimated project time lines with specific milestone hard gates and got it approved by the steering committee
• Created project plan and made sure that the team aligned to time lines and budget
• Conducted weekly status meeting with all the stake holders to address any issues/concerns they might have
• Actively involved in requirement gathering from end users
• Suggested/implemented SAP BW best practices duringdifferent cycles of the project
• Followed all the SDLC processes defined and got all the project related document approved at specific hard gates
• Designed the SAP BW data flow taking into consideration the dependencies
• Responsible for delivering the functional/technical Specifications according to the client reporting requirement
• Analyzed and Mapped Business requirements to BW.
• Identified Business Content that can be leveraged.
• Worked closely with BASIS to help them understand the way BW works as BW was new to Abbott vascular environment
• Implemented Inventory module to facilitate visibility to the Raw Materials Days on Hand
• Implemented Procurement module to give a visibility to the customer on their Spend pattern (Direct Spend vs. Indirect Spend)
• Created APD process to capture inventory snap shots on a monthly basis
• Created custom extractors on different Z tables to source data to BW
• Created Meta Process chains to load data taking data load/system maintenance dependencies into consideration
• Actively developed all the BI related backend objects
• Developed several inventory/procurement and RF Pick efficiency reports in Bex
• Created test cases for User acceptance testing sign off
• Worked with users closely during the UAT to help them understand the reports and different calculations in the reports
• Responsible for filling the setup tables and initializing the delta
• Fixed all the transport related issues during the cutover
• Loaded all the historical data during production cutover and enabled delta accordingly
• Conducted work shops for users to train them to use Business explorer and make them understand the navigational tips and tricks

Confidential,Houston, TX May ‘11 – Dec ‘11
Senior SAP BW Consultant (Onsite lead)

Environment: SAP ECC 6.0, NetWeaver 2004s, CRM 7.0, APO, SAP BW 7.0, Xcelsius, Webi, ORACLE, Windows XP

Responsibilities:

• Was Technical lead leading a team of 6 at off shore
• Had been one point of contact for any BI related work for the company’s CIO
• Communicated with the C Suite on a regular basis
• Responsible for delivering the technical Specifications and development according to the client reporting requirement
• Actively involved in requirement gathering from end users
• Analyzed and Mapped Business requirements to BW.
• Was actively involved in identifying Business Content that can be leveraged.
• Implemented Procurement module to give a visibility to the customer on their Spend
• Implemented all Logistics related touch points (SO, Deliveries, Shipment. Shipment Cost)
• Implemented Accounts Receivables for Credit department
• Implemented Inventory module to stage the data in BI for BPC to consume
• Delivered all the reports in 3 different modes – BEX, Webi and EP
• Delivered a Xcelsius dashboard to corporate leadership to give them visibility of Spend at the company
• Developed process chains to load data from BI/CRM to APO
• Designed and delivered very complicated reports for Order to Delivery (OTD) and Order to Shipment (OTS)
• Designed and delivered very complicated reports for Freight Visibility
• Actively developed all the BI related backend objects

Confidential, NYC Feb ‘11 – May ‘11
Senior SAP BI Architect/Project Manager

Environment: SAP ECC 6.0, NetWeaver 2004s, SAP BW 7.0, HR, ORACLE, Qlik View, Windows XP

Responsibilities:

• Was Project Manager and was responsible for all project deliverables
• Created and maintained the Project plan during the life of the project and was responsible for all other project related activities
• And as an Architect, was responsible for requirement gathering from Executive HR team
• Created User Functional Requirement Document (UFRS) to capture all the requirements
• Converted the User requirements from SAP BI standpoint and designed system architecture and delivered System Design Document (SDS)
• Did GAP Analysis, and suggested alternative custom development to fill in the GAP’s
• Created Write-Optimized DSO’s to facilitate load to Qlik View
• Enhanced views in ECC to include new fields to the extractors for reporting purposes
• Analyzed and Mapped Business requirements to BI and Qlik View (3rd Party Reporting tool).
• Analyzed HR module data that was housed in SAP BI and converted them into report specifications
• Created database design for 3rd party reporting tool (Qlik View) to align with SAP BI data model, to create Executive dashboard for HR Analytics

Confidential,Beaverton, OR August ‘10 – Jan ‘11
Senior SAP BW Consultant

Environment: SAP ECC 6.0, NetWeaver 2004s, SAP BW 7.0, Event manager, MM, ORACLE, Windows XP

Responsibilities:

• Responsible for supporting Pegasus, a BI based Nike custom tool which tracks the life cycle of Purchase Order
• Resolve production issues whenever they arise in Pegasus space
• Developed new enhancements according to client requirement
• Monitored batch jobs that down stream data into BI and fix any issues when they arise
• Developed MDX queries to use in Nike Java Portal

Confidential,Richmond, VA May ‘10 – July ‘10
Senior SAP BW Consultant (Front End developer)

Environment: SAP ECC 6.0, NetWeaver 2004s, SAP BW 7.0 (EHP1) - SP5, Xcelsius 2008 - SP3, DB2, Windows XP

Responsibilities:

• Was responsible for building Executive Dash boards using Web Application designer (WAD) according to the client reporting requirement
• Extensively used WAD web items comprising of various combinations to achieve the desired result
• Used multiple queries in the Web Template to mitigate the complexity of the dash boards in the Portal
• Created more than 300 queries and templates to achieve the complex dash board functionality
• Used Waterfall and Scatter Plot chart type in the dash boards
• Supported the project in UAT to fix defects that were identified during UAT
• Did a Proof of concept (POC) demonstrating the new functionalities of Xcelsius 2008 SP3 connecting to Bex Queries directly using BICS connection
• Used one big query to create multiple views of Dash boards by manipulating the aggregation levels in the report unlike in WAD, where you would need one query for each aggregation level
• Replicated same dashboard that were created in SAP WAD in Xcelsius 2008 as part of POC
• Documented the functionality of the Xcelsius 2008 compared to SAP WAD functionality

CERTIFICATIONS:

• A+ from CompTia
• Advanced Networking Certificate from Ferris State Univ.
• Certified SAP BW 3.0 Solutions Consultant