SUMMARY:

• PMP certified project manager with successful track record in leading complex, multi - million dollar SAP projects to on time and under budget completion. Experience with big 4 consulting firms.
• Certified Sr. SAP Netweaver 2004s - BI / BW Professional with 10 years of experience in Information Technology including SAP ECC, ABAP/4 experience and 9 years of experience in SAP BW/BI and Business Objects and more recent experience in SAP HANA and BW on HANA.
• Experience managing onshore/offshore SAP technical development. Hands on experience with non \SAP technology solutions development as well.
• Implemented full life-cycles (gathering business requirements, analyzing the business process, Identifying and analyzing the Design, Configuration, Unit/Integration testing, D migration, Go-live and Post-go-live support) using ASAP implementation methodology.
• Strong data modeling skills with Multi Dimensional and BW Extended Star Schema models.
• Extensive expertise in Extraction (LO Cockpit, COPA and Generic Extractions) & functional areas MM, SD, FI CO, HCM/HR, APO & CS.
• Customizations - Data source enhancements, generic extractors, functional modules, BAPIs, user Exits and Logistics Cockpit configuration and customization, Data extraction from flat files, UD Connect, DB Connect Data sources for Master data and Transactional.
• BW Operations - Data load management, Job scheduling with events, Data source Enhancement, OLTP extraction data, Loading (Full /Delta Load), Monitoring, Remote Cubes, Data Mart and Open Hub Services, applying OSS Notes and BW Transports.
• BW Security & Authorizations - Implemented Security access authorizations at datamart (Infocubes, Objects and hierarchy) and query levels.
• Reporting - Expertise with Business Objects 4.0 reporting suite and BEx Query Designer, Web Application Designer including ad hoc reporting, pre calculated templates, authorization & creating dashboards/cockpits, Calculated & Restricted Key Figures Exceptions, Replacement Path Variables and RRI jumps, Report Designer, Value Sets, Queries on Multi Providers, Using Reporting Agent for alerts, Publishing reports and iViews in Portal and documentation for end users.
• Performance Tuning - BW Statistics, Multi Providers, Aggregates creation, InfoCube partition & compression, Query tuning and OLAP Cache Monitoring.
• Implementation of CRM BW Analytics including developing custom BW extractors for extracting CRM data.
• ABAP - ABAP/4 programming, ABAP OO, API Programming, User Exits, SAP Scripts, Custom object creation such as Z tables.
• Extensive experience with Transports through complex landscapes.
• Expertise in developing WebI, Crystal, Dashboards, Analysis and Lumira solutions.
• BI 7.3 & 7.4 upgrade experience.
• Experience using BODS
• Experience using BI Accelerator.
• Utilized APD transformation and tools for data mining and complex reporting.
• Experience with Design Studio
• Excellent communication, interpersonal, analytical skills and a stellar performance record backed by solid client references.

TECHNICAL SKILLS:

Languages : ABAP OO, C++, VB. R/3 Cross Applications ALE Configuration, IDoc

Functional Modules: MM, SD, HR, FI CO, APO, CS, PP, CRM, SEM-BPS.

Scripting Languages: HTML, DHTML, XML

Networks: TCP/IP, LAN, WAN, UDP, NS2

Database: SQL, PL / SQL, SQL Server 7.0/2000, DB Connect and Oracle.

Reporting: WebI, Dashboards, Advanced Analysis, BEx Analyzer & Designer, WAD, MS Excel, Crystal Reports

Design Tools: MS VISIO, ERwin

PROFESSIONAL EXPERIENCE:

Confidential, TN

SAP Reporting Manager

Environment: SAP BI 7.3, ECC 6, Business Objects suite, SAP HANA

Business Modules SD, MM, FI, COPA, SCM, OTC

• Reporting Lead responsible for BW Order to Cash Reporting Deliverables - leading a team of twelve resources ranging from core BW to BOBJ 4 resources.
• Intimately involved in all aspects of the project starting from Blueprinting to Go-Live and User Training.
• Conducted Workshops and Presentations with Users and core ECC BAs to elicit and map Reporting requirements.
• Designed the architecture of the BW landscape for the Order to Cash Project.
• Hands on development of complex solutions involving custom extractors, DSOs, Transformations, Cubes, APDs, BAPIs and Open Hubs.
• Involved with implementing Business Objects 4.0 Reporting solutions using Advanced Analysis, WebI and Crystal Reports.
• Devised and implemented Cutover strategy for Go-Live.
• Performance Tuning, Data loads optimization and Technical Support during stabilization.

Confidential, OH

SAP BI Project Manager - DataStage, SAP BW, BOBJ

Environment: SAP BI 7, ECC 6, R/3 3.1i, DataStage, BOBJ

Business Modules FI CO, MM

• Vertical Head for the AR, GL tracks - responsible for entire ETL (DataStage), EDW (BW) and R&A (Bex, BOBJ).
• Designed a Global AR Solution merging data from multiple source systems.
• Led Requirements gathering with business users and Blueprinting sessions with Functional leads and developers.
• Lent expertise on Inventory Management (2LIS 03 BF, UM, BX) scenarios for a non-cumulative data model integrating multiple source systems.
• In charge of an off shore- onsite model comprising of 4 offshore and 4 onsite resources.
• Involved with hands on development, lending technical expertise to developers and successfully meeting timelines.
• Met with Solutions Leadership team at Client on a weekly basis communicating status, suggestions and negotiating any scope creeps.

Confidential, WA

Sr. SAP BW/BI Solutions Lead

Environment: SAP BI 7, ECC 6

Business Modules SD, FI CO, MM, CS, HR

• Created a comprehensive Datamart to host AR reports based on requirements gathered during sessions with the key business users.
• DSOs on standard extractors such as 0FI AR 4 (Open items), 0FI AR 9 (Credit Information) and a Custom extractor on the table BFOD A were used at the content layer.
• Data combinations and lookups Transformations with 2LIS 13 VDHDR/VDITM were carried out and reported off the Datamart layer.
• Created and scheduled Process chains for daily delta loads to the datamart.
• Various A/R reports and custom WAD templates such as Daily Cash Payment Report, Detail Due Date Sequence, Tax w/ Billing report, etc. created employing multiple RKFs, CKFs, offsets for aging and Replacement path variables.
• A requirement for adding new characteristics to a COPA data source was encompassed in the project. This required characteristic to be added to the COPA structure and the COPA settlement rules updated to properly derive the values and the COPA summarization levels regenerated to accommodate this new characteristic. This characteristic was then made available in the existing BI datamart.
• Followed a completely iterative methodology engaging the users throughout the process of testing in various environments to ensure seamless usability of the reports.
• Two main data streams 2LIS 11 VAITM and 0EC PCA 3 combine in this datamart.
• Performed migration of emulated data source.
• Enterprise level storage into Write- optimized DSOs.
• Created Data Transfer Process (DTP) to transfer data within BI from one persistent object to another object.
• Utilized Transformation API (ABAP OO), Classes, Methods for faster, reusable code in Transformation routines across the various developments.
• Use of TVARVC to dynamically filter on changing characteristics values made the Datamart as a whole and in parts more general and flexible.
• Complex derivations and filters including looking up a higher level key and de-normalizing the data to include a fiscal period key in the higher level DSO, populating flags based on characteristics values and combining both the streams of data into one Datastore followed by respective cubes and multiproviders.
• Built various reports including Backlog report, Gross Margin, Monthly Bookings, Future Revenue Recognition report employing multiple CKFs, RKFs, Customer Exit Variables, Text Variables and RRI assignments.
• Created formatted reports with Report Designer.
• Involved throughout from the gathering of the requirements to the go-live and support and in the process gaining invaluable understanding of the particular business practices and building great rapport with key business users.
• Conducted comprehensive Power User training workshops spanning across various business groups which resulted in increased usage of the reporting tools thereby adding to the ROI for the Client.
• The Production Support Team, in contact with the BW Report Users, subscribed to the list of BW Reports / Queries for which the Availability Status was to be monitored.
• Custom ABAP Programs tracked-down all relevant data structures such as InfoProviders, DSO Objects and Master and Transaction Data InfoObjects for such given BW Report / Query.
• Subsequent Process to trigger a BAdI implementation was activated for all the data loads into the data structures.
• Another Custom ABAP Program created to propagate the Status and Overall Status based on the load status captured by the BAdI.
• A Dash Board GUI was developed to provide a single point of control and visibility to the entire load monitoring process that reports the overall status of BW Report Availability.
• Developed a new DSO to store the status of individual reports and a Query on top of the DSO that can be fetched from Intranet Website.
• Initiated meetings with key business users and analysts to gather requirements and discuss scope.
• Extracted Seibel data to BW with Informatica PowerConnect.
• Explored the current business practices and provided detailed mappings of as-is and to-be objects for the migration.
• Played a key role in educating the users about the BI capabilities and helped realize the potential of the developments.
• Designed datamarts for SWO reports and Install Base data view which included multiple DSO’, Cubes and employed Transformation Start and End Routines.
• Used Real time Data Acquisition DTP(RDA) to load data from PSA
• Built complex BEx queries utilizing an array of Offset variables, RKFs and CKFs.
• Developed generic extractors in R/3, multiple objects, DSO, Infospokes (Full, Delta and Pseudo Delta) in BW to extract the Install Base data to an Oracle application where the final combination took place.
• Assigned security authorization objects to user profiles based on business process access specifications.
• Query access limited based on authorization variables by company codes and profit center hierarchies.
• Numerous tickets ranging from simple authorization issues to complex code changes resolved.
• Data load issues addressed and reconciled with source system data- activities such as selective deletions, sequential repair loads et al.
• Developed and scheduled metachains to load daily delta and periodic full loads.
• Utilitzed the standard datasources 0HR PA PD 2, 0APPRAISAL ATTR and 0HR PA PD 1 and helped reconcile data with associated HRP1* and PA* tables.
• Activated Business Content in BI for InfoCubes 0PAPD C01 and 0PAPD C02 and related Master data objects.
• Created Infopackages and DTP to load data in these InfoProviders.
• Created and Changed Bex Query variables, filters, free characteristics and key figure definitions for local copies of reports 0PAPD C01 Q001 and 0PAPD C02 Q004 among others.

Confidential, NY

Sr. BW Consultant

Environment: SAP BW 3.5, SAP R/3 4.6C

Business Modules: SD, FI CO, APO, HR, BCS, MM, CRM

• Analyze the existing architecture & propose modifications, improvements.
• Meet with business users & gather requirements for new reports.
• Responsible for data reconciliation across the platform.
• Designed custom cubes & multiproviders accommodating business requirements. Integrated Infosets to in corporate infoobjects in reports.
• For HR Payroll Reports,the standard datasoure 0HR PY 1 was not sufficient for the reporting requirements.
• Business reporting required the Payroll information to be extracted based on Payroll Periods. The current datasource and the settings in SBIW is not getting me the actual payroll periods.
• Helped identify all the fields and tables for the technical consultant to write a Function Module generic datasource to pick HR Payroll data.
• Pulled in the data from the generic datasource into custom DSO and Cube and created the required Payroll report in BEx.
• Created & implemented Process Chains & Metachains triggering events across modules.
• Implemented Ad Hoc queries & collaborated with Basis on authorizations.
• Developed infoproviders and process chains in APO triggering events back & forth to the staging area(BW).
• Maintained master data for different levels of Business partners, products with good understanding of the CRM table relationship.
• Developed BW analytics for CRM Opportunity Management involving a BPS planning application to update data directly from the Portal screen.
• Utilized APD to extract & Transform data from a Query and load it into ODS object with transformation and further into a reporting Cube for data mining.
• In-charge of on-call for support-related issue resolution.
• Involved in performance tuning based on the executive feedback.
• In charge of all BW transport requests across the landscape released to Basis team.
• Develop BEX queries and workbooks with filters, multiple value global variables & replacement path CKFs to in corporate complex calculations in reports.

Confidential, TX

BW Consultant

Environment: SAP BW 3.5, SAP R/3 4.6C

Business Modules SD, FI

• Analyze business needs and strategic information requirements to ensure the proper business content is available.
• Created the Info Cubes for AR, AP, Billing and Delivery to ensure required characteristics and key figures are available.
• Define Security structures and approve user access
• Implemented Process chains to automate BW data loads
• Implemented BW Statistics to monitor BW activities
• Audit and validate data across all SAP R/3 4.6C and BW 3.5 systems before going into production.
• Implemented Aggregates to improve query performance
• In-charge of performance tuning of data loads and queries
• Monitored the query performance using the tools - BW Statistics and BW Workload analysis
• Designed and implemented a complete security profile for BW - including access based on user types, infoobject access via RSSM, query and workbook roles via PFCG, et al.
• Analyzed the queries using the Query Analysis tool.
• Develop BEX Reports, Queries, Workbooks, and iViews in connection with delivering the information needs of the business to the Portal.
• Work with the end users to help them understand data definitions, and how to use available reporting tools. Also assist end users and their departments develop solutions for capturing business KPIs, and exception reports that facilitate improved and timely decision making.

Confidential, MI

Senior BW Consultant

Environment: SAP BW 3.5, SAP R/3 4.6C

Business Modules SD and FI

Data Modeling, Extraction, Reporting

• Studied global reporting requirements from end users & prepared detail technical specification documents based on functional requirement.
• Configured & Extracted from R/3 using LO cockpit Datasources (2lis 11 VAITM, 2LIS 11 VAKON, 2LIS 13 VDKON, 2LIS 11 VCITM) & from 0FI GL4.
• Created ODSs and summarized & custom InfoCubes for the extracted data.
• Provided requirements regarding a customized transaction code to prompt for region code.
• Developed several start routines for various data extraction procedures for master and transactional data.
• Designed and created Multiprovider for the Sales, Delivery & FI-GL InfoCubes.
• Developed InfoSet to join for ODS for region codes, condition types & amount.
• Created Partitioning, Compression and Indexes as performance tuning measures. Monitored the Database Buffer requirements to improve data loading and reporting efficiency.
• Designed and Developed BEx queries as per end user requirements.
• Created flexible queries on InfoSet in BEx using Navigational attributes & generated reports for user-defined region codes& condition types.
• Generated reports with designed exceptions, variables & restricted keyfigures to Report variance from the planned & actual freight costs.
• Performance Tuning of Data Loads and queries.

Confidential, CA

BW Senior Developer

Environment: SAP BW 3.0B, 3.5 and SAP R/3 4.6C, ABAP/4

Business Modules FI CO

Data Modeling, Extraction, Reporting

• Principal member in design and architect of the system and implemented the project using ASAP methodology in two phases. Responsible for all stages of the Project.
• Involved in all phases of the project life cycle encompassing information gathering, design & architect of the system, modeling, development of BW backend objects, reporting, security & authorization and performance tuning.
• Built 2 multicubes, 2 infocubes, 2 ODS and an InfoSet to extract the business information from the legacy system using DB Connect.
• Customized standard infocubes and ODS for Profit Center Accounting (0PCA C01 & Custom Line Item cube using 0EC PCA 1 & 0EC PCA 3 datasources) and General Ledger (0FIGL O02) to meet real estate specific financial information from R/3. Applied OSS Notes to enhance 0FI GL 4 to bring in business information to merge with the financial data.
• Integrated business data and financial data to meet complex reporting requirements.
• Created web based reports & iviews for business reports and Excel based highly formatted financial reports. Published in the Enterprise Portal for Executive Dash Board Reporting. Also, used BEx broadcaster to publish key reports to regional managers through email.
• Created P&L Reports and Expenses report for Controllable and non-controllable accounts in Finance and “Today is Yesterday”, “Yesterday is Today”, “Today or Yesterday” Scenario reports in Business based on Activity, Activity History and Office information.
• Activated the statistical content to assess the performance of the reporting.
• Involved in performance tuning based on the executive feedback, ST03 output and statistical information using RSRT, Aggregates, Compression and Reporting Agent. Also fine tuned some of the WAS parameters based on SAP recommendation along with Basis person.
• Assisted organization in developing procedures and process for production support activities which involved Change Request Management, Data Load Process and Security & Authorization Management.
• Involved in Preparation, upgrade and post-upgrade check of BW system on its migration to 3.5.

Confidential, TX

Senior BW Consultant

Environment: SAP R/3 4.6C,BW 3.0B, Oracle, Windows

Business Modules SD, FI/CO

Data Modeling, Extraction, Reporting

• Created Custom Cubes and ODS for Sales Order, Delivery and Billing.
• Developed several start routines for various data extraction procedures for master and transactional data.
• Activation of standard extractor for Application Component 11, 12 and 13 in LO cockpit using LBWE.
• Enhancement of Data Sources (2LIS 11 VAITM, 2LIS 11 VASCL, 2LIS 12 VDITM & 2LIS 13 VCITM) using CMOD.
• Created custom Function Module for Unit Conversion and for handling special Characters.
• Re-loading of Item and Schedule line data to the new data targets using Queued Delta with no downtime of SAP R/3 System.
• Created Process Chains for daily delta loads and for clean up operations of PSA.
• Created Partitioning, Compression, Aggregates and Indexes as performance tuning measures. Monitored the Database Buffer requirements to improve data loading and reporting efficiency.
• Developed key reports for all data targets at Sales Org, Distribution Channel, Division and Product Line level.
• Pre-calculated web queries, RRI and Exception reporting were used.
• Created several web queries for Sales Activities based on Sales Order Cube and Income Statement, Manufacturing Cost reports for product lines Polyethylene, polypropylene, etc based on Cost Center Accounting Cube.
• Created organizational level standard web templates for the web reporting.
• Published reports and iviews in the Enterprise Portal.

Confidential, Columbus, OH

BW Consultant

Environment: SAP R/3 4.6C, BW 3.1

Business Modules CO-PA, CO, PCA, DB-Connect

• Conducted User Requirements Gathering workshops and interacted with the Management and Business Users to identify Business Requirements.
• Created a master data cross reference layer to allow reporting across single sets of master data where needed (customer, material, GL account/Cost Element, and profit center)
• Worked on creating DB Connects from SQL server to BW server.
• Designed Report-to-Report Interface to analyze both Summarized and Drilled Down Reports
• Design and modeling of info cubes for PCA, CCA, COPA and extraction of data using Generic and CO-PA extractions.
• Involved in the coding of start routines in the update rules
• Provide Documentation on Best Practices for Support and Maintain after GO-LIVE
• Involved in all the phases of Life cycle development from requirements gathering to putting the project into production
• Involved extensively in Reporting using BEx Analyzer, BEx Web Reports, BEx Map, creating Web Templates and Query Painter/Writer.
• Developed many Infosets from Master Data objects and ODS objects
• Analyzed BW statistics for optimization of data loads and report performance during BW production support.
• Conducting standard testing & validation process

Confidential, Ridgefield, CT

BW Consultant

Environment: SAP R/3 Release 4.5, SAP BW Release 3.0, BEx Analyzer, SD, Pricing Conditions.

• Designed and Created estimation model for BW implementation based on the scope of the requirements and prepared technical specification documents.
• Worked with the technical and functional team to design and develop the Deals Front End screens (ZDEALS) in R/3.
• The zdeals program was developed to enter deals by the user and creates entries in G/L and pricing conditions.
• Custom table was created to hold the deals master data and we created generic extractor to extract the deals data into BW.
• Developed custom ODS and InfoCube to combine the Deals data, Pricing, Sales and GL Accruals.
• Created Virtual Cube on the ZDEALS extractor to give the users real time data by limiting the selection on the query to improve the query performance.
• Created and maintained the required Info Objects, Info Sources, Transfer Rules, Update Rules, ABAP Routines, for the custom deals reporting requirement.
• Extracted data from SAP R/3 using LO Cockpit (2LIS 11 VAHDR, 2LIS 11 VAITM, 2LIS 13 VDKON, 2LIS 11 VAKON) and worked on enhancing the extract structures based on the Client Specs if needed, by writing User Exits, update rules and transfer rules.
• Leveraged on the business content InfoCubes (0SD C03, 0SD S13) to extract sales and pricing data and did enhancements to fill the user reporting requirement.
• Developed reports/queries such as Deals reports, Price Evaluation reports using BEx Analyzer.
• Monitor all the data loads in the Production system and responsible for providing solution for load failures.
• Periodically conduct meetings with Basis and Functional support teams to review issues, priorities, upcoming activities, support needs and other concerns.
• Review SAP early watch recommendations and make necessary improvements.
• Review system statistics and other measures to identify needs for aggregates, indexes, compression etc.

Confidential, Houston

Credit/ Financial Analyst

• Designed and implemented database applications to cover a wide range of tasks for the alliantgroup three phase approach to R&D Tax credit study including assessment and feasibility, analyzing contemporaneous documentation, linking documented database and project information to finalize and perform the quantitative calculation and reporting.
• Provided Crystal Reports to produce tax forms & assessment tools, custom modifications, troubleshooting, administration and technical assistance.
• Studying and exploring the business clients’ operations on an individual basis to enhance data analysis efficiency.
• Analyzing data for all accounts to assure quality, reliability and accuracy.
• Studying and exploring the business clients’ operations on an individual basis to enhance data analysis efficiency.
• Running, designing and manipulating Microsoft Excel reports for clients, sponsors, & upper management summarizing all activities for each account.
• Building a unified database through the use of Microsoft Access, Visual Basic & SQL to enhance the worksite’s data security, reports generation, entity relationships, employee information & employees’ efficiency

References available upon request.