SUMMARY:

• Post graduate engineer and a Certified SAP BI (2.X, 3.X and NW2004s BI7) Consultant with over seventeen years of SAP experience with fifteen years in SAP BW/BI implementations. Over five years of BOBJ and three years of HANA experience.
• An expert in SAP BI BOBJ HANA Analytics, HANA Data modeling, BO Data Services, SLT replication and Visualizations.
• Thorough Hands - on experience with SAP HANA Information Modeling including creation of HANA Attribute views, Analytical views, Calculation views, design time HANA views, Tables and Table views and data provisioning using SLT replication from SAP and non-SAP systems.
• An expert in design and development of Executive Dashboards using the latest tools like Visual Composer(V7.X), BOBJ Xcelsius, Dashboard Designer, Lumira and Tableau.
• And expert in performance monitoring and fine tuning the SAP HANA Data models for efficient BI Analytics
• Security Specialist with a sound knowledge of standard and Analysis authorizations for design and development of BW security models.
• Has a rich work experience in the areas of SAP Logistics (MM, PP, QM, PM, SD), Finance, SRM7.0, CRM7.0 and SPM3.0. An ABAP and SQL guru with expertise in interface application development, BAPI’s, BADI’s, user exits and transformation routine rules.
• Experience in all phases of software development life cycle. Well conversant with the ASAP methodologies and Solution Manager for a systematic and strategic BI implementation.
• Has worked with fortune five hundred companies like Confidential, Confidential, Confidential, Confidential, Confidential, Confidential, Confidential and Confidential .
• Extensive experience in system analysis, design, and development. Excellent communication skills and ability to lead a team as well as work well in a team and manage multiple assignments at the same time.

TECHNICAL SKILLS:

• Design HANA system/Landscape/Configuration of Packages.
• Configured the SLT replication server for Data provisioning into SAP HANA from SAP and non-SAP systems.
• Design of Custom Calc.Views using Graphical and SQL scripts. Good experience with Analytical views, Calculation views using Star joins.
• Worked on HANA LIVE Content, HANA LIVE View Browser, HANA Live Extension Assistant. Extended HANA LIVE Views using the HANA Live Extension Assistant
• Installed and Worked on HANA LIVE Views for SAP FI-GL, SAP SCM, and HANA LIVE SAP Manufacturing
• Lumira /Tableau/WEBI reports and dashboards creation on top of HANA calculation views.
• Expert in optimizing HANA views for best performance to reduce data latency, memory consumption and enhance report performance.
• Expert in architecting and deploying global EDW solutions by following SAP best practices including LSA and LSA++ architecture, utilizing the standard business content, and SAP recommended landscape and platform standards.
• Experience in the latest HANA 1.0 revisions.

PROFESSIONAL EXPERIENCE:

Confidential, El Segundo, CA

Senior SAP BW/HANA Lead Consultant

Responsibilities:

• Involved in the North America Service Management(CRM) Project as a Senior BI Analytics Consultant.
• Responsible for design/development of BI Datamodels/Reporting in the areas of CRM Evaluations, Service to Cash, Inventory Management. Helped in planning the deliverables and estimates.
• Helped the Basis in providing the sizing of the HANA servers for capacity planning, recommended the best practices for optimum performance of the server and for Analytics .
• Worked on SLT replication for data provisioning to SAP HANA from SAP and non-SAP systems(KRONOS). Designed and developed the HANA Views, leveraged the HANA live content and enhanced the same to meet the requirements.
• Worked on building reports and dashboards using the front-end tools like Dashboard Designer and Lumira for Data Visualizations.
• Helped the project in Go-live and post Go-live activities.

Environment: BW 7.4 on HANA SP11, SLT, HANA Live, BOBJ BI4.0, WEBI, Analytics Office, Dashboard Designer, SAP Lumira.

Confidential, Alexandria, VA

SAP BW HANA Senior Consultant

• Involved in the implementation of SAP Fusion Migration projects. Primarily responsible for delivery of Dashboards for OM and Procurement.
• Played a vital role as a BI HANA modeler in migrating the legacy applications from SAP and non-SAP systems to HANA Studio/BW7.4 on HANA to provide a LSA++ layer for ODBC consumption, upstream distributed applications and for reporting using BOBJ tools like WEBI and Design Studio. Replicated the data from SAP And non-SAP systems(FUSION).
• Involved in the design, development, testing and validations for the user sign-off.

Environment: BW 7.4 on HANA SP9, SLT, HANA Live, BOBJ BI4.0, WEBI, Analytics Office, Dashboard Designer, SAP Lumira.

Confidential, Houston, TX

SAP BW Design Lead

Responsibilities:

• Lead two projects at Confidential in the capacity of BW design lead.
• Involved in the requirement gathering, design and project planning, lead the realization phase and coordinated the documentation efforts to make it a complete project delivery.
• Lead the team involving offshore resources in implementing BW CDMS project which deals with the integration of contractor data from non-SAP systems with Plant maintenance and procurement data of SAP.
• Lead Plant maintenance and Project to Assets BW implementation for Asia pacific and Europe regions
• Delivered over hundred and twenty reports in the areas of Plant maintenance and Project to assets areas.
• Co-ordinated with the off-shore resources and delivered the deliverables on time.

Environment: SAP BW 7.3, SAP R/3 ECC 6.0 EHP4, SAP HANA1.0, ABAP, PM, PS, BO BI4, WEBI.

Confidential, LA, CA

SAP BW/HANA Architect

Responsibilities:

• Analyzed, identified and implemented the standard Business content in the areas of FICO, PSM and SRM.
• Conducted the workshops with the business users and collected functional requirements for the FRDB (Finance Reporting Database Reports).
• Designed and documented the Technical documents for the FRDB reports. And lead the BW group to deliver the FRDB reports.
• Delivered 120 Standard reports and 16 FRDB reports.
• Working with BW 7.3 and HANA 1.0 to define function specifications to architect with tech specs and create history reporting from Funds Management (SAP ECC) and Bonds data from ORACLE (non-ECC).
• Configured HANA SAP Landscape Transformation Server and HANA Studio to extract the data from non-SAP systems.
• Configured/created ODBO connections and JDBC connections for accessing the information models from SAP HANA for reporting purpose.
• Deployed SLT & DXC data provisioning services in replicating data from ECC to HANA Database.
• Involved in setting up HANA Analytical privileges to restrict access to the specific HANA views.

Environment: SAP NW2004s BW 7.3(SP5), SAP R/3 ECC 6.0 EHP4, SAP HANA1.0 SP2, ABAP, FI-GL(New),CO, AP,AR and SRM7.0Confidential, Alexandria, VA

SAP BI Lead Consultant

Responsibilities:

• Involved in the GFEBS BI implementation for Budget Execution of Funds management module for EFD.
• Involved in the requirements gathering, built, testing and deployment of the interface and layouts for EFD BI project implementation.
• Built the BI data models needed for the delivery of the outbound interfaces for reconciliation of EFD and GFEBS Budget data.
• Developed the ABAP function module for the derivation of the EFD line of accounting fields for re-using in multiple transformations.
• Developed complex transformations for deriving the results as per the EFD logic.
• Created the IP layouts for PBG layouts and AFP CRA layouts.
• Involved in the documentation of the Functional and Technical specification documents, Component test plan documents and Test models.

Environment: SAP NW2004s BI 7.03, BOBJ XI 3.1, BOBJ BI 4.0, SAP R/3 ECC 6.0 EHP3, ABAP and FM.

Confidential, Houston, TX

SAP BW/HANA Architect

Responsibilities:

• Involved in the implementation of SAP BI/BOBJ project for building an Enterprise Wide Data Warehouse in the areas of Supply chain Management, Order Fulfillment, FI-GL, AP and AR.
• Involved in the Assembly Maintenance and Overhaul project for SCM.
• Designed the data model for building AMO Dashboard application for various user sites.
• Extracted the data from heterogeneous source systems using Data services to build the BW data models.
• Built the complex WEBI reports and Xcelsius dashboards for display on TV screens in multiple sites. Established the security to secure the reports by region.
• Created a dashboard to display BI Reports Usage metrics to users and managers. Used BOBJ Data Services to extract BOBJ reports statistics from InfoView and Portal.
• Worked on the Shipment Costs Details report by building a complex data model extracting the data from different datasets of Shipments, Purchasing and Invoices
• Worked on prototyping the HANA solution provide the HFM data integrated with BW Finance data for executive dashboards.

Environment: SAP NW2004s BI 7.02(SP3), BOBJ XI 3.2, BOBJ BI 4.0, Data Services 2.0, SAP R/3 ECC 6.0 EHP3, SAP HANA1.0,ABAP, MM, PP, QM, PM, CS, SD FI-GL, AP, and AR.

Confidential, Boston, MA

SAP BI Lead Consultant

Responsibilities:

• Leading the P2P and R2R groups of Propel-BI team in the global implementation of SAP BI/BOBJ project for building an Enterprise Wide Data Warehouse.
• Involved in the Design and Development phases of the project. Created the project plan based on resources and tasks to have a clear-cut road map to achieve the deliverables on time.
• Involved in requirement gathering, preparation of the functional and technical specification documents for the BI reporting in the areas of R2R and P2P.
• Leading the efforts of evaluation and estimation of the SPM project implementation, building POC’s and demos.
• Conducted the workshops for the business groups, built the prototypes to demonstrate BI/SRM/SPM scenarios.
• Worked on the preparation of the enterprise wide BW/BOBJ Security Strategy model.
• Advocated the best practices for the BI project implementation.
• Helped in the installation and validation of the BI, SRM, and ECC dev systems by applying the appropriate corrections and OSS notes.
• Managing and mentoring the onsite and off-shore resources to co-ordinate accomplish the design/development tasks.

Environment: SAP NW2004s BI 7.02(SP3), BW Cont7.05, XT7.05, BOBJ XI R3.1 (SP3), SAP R/3 ECC 6.0, ABAP, SRM 7.0, SPM 2.1, new EHP3 FI-GL, AP, MM, PP, QM, PM, CS, SD.

Confidential, Houston, TX

SAP BI/BOBJ Lead Architect

Responsibilities:

• Involved in the implementation of SAP BI/BOBJ project for building an Enterprise Wide Data Warehouse in the areas of Supply chain Management, Order Fulfillment, FI-GL, AP and AR.
• Involved in the requirement gathering, analyzed and installed the needed Business Content, built prototypes for to demonstrate the BI solutions.
• Worked on the preparation of the enterprise wide BW/BOBJ Security Strategy model.
• Helped in the installation and validation of the BI, SRM, and ECC dev systems by applying the appropriate corrections and OSS notes.
• Designed data models to accommodate the ODS layer, PI layer and ADM layers for implementing the EDW datamodels to meet the unknown requirements and to avoid redundancy in different Silos.
• Advocated the best practices for the BI project implementation
• Customized the data models with several enhancements and modifications to meet the user reporting requirements.
• Resolved several data inconsistency issues, fixed profit and loss report, transactional reports by fixing the data model issues.
• Improved the reporting performance by feeding the InfoProviders to BI accelerator.
• Created new InfoSpaces from BO explorer by feeding the InfoProviders onto BIA using polestar via RSDDV.
• Created the OLAP Universes, WEBI reports and Xcelsius Dashboard reports
• Improved the WEBI query definitions and worked on advanced analytics to deliver the BOBJ reports.
• Stabilized the daily data loads with post go live support, resolving the issues with quick fixes. Optimized the slow/late running daily process chains and automated with email messaging in the event of errors
• Conducted the workshops for requirement gathering and for power user training.
• Managed and mentoring the onsite and off-shore resources to co-ordinate accomplish the design/development tasks.

Environment: SAP NW2004s BI 7.02(SP3), BOBJ XI 3.2, BOBJ BI 4.0, SAP R/3 ECC 6.0 EHP3, ABAP, MM, PP, QM, PM, CS, SD FI-GL, AP, AR and HR-OM, PA.

Confidential, Houston, TX

SAP NW 2004s BI and Visualization Architect

Responsibilities:

• Involved in the implementation of BI project for building an Enterprise wide Data Warehouse in the areas of SRM, FI-GL, AP, SPL and HR-OM, PA.
• Responsible for complete implementation of BI project involving Requirement Analysis, Blueprint, Design, Development, Testing, Go-live and post Go-live support.
• Enhanced the master data DataSources and transactional DataSources to meet the user specific requirements.
• Built the generic extractors using function modules and views for extracting the data with complex selection criteria.
• Installed and activated the relevant business content that includes complete datamodels, queries and web templates.
• Built the process chains and automated dataload schedules on daily and weekly basis.
• Built the data models for FI-GL, AP, SPL and HR-PA and OM modules. Involved in the customization of the data models to in corporate the reporting requirements.
• Designed and developed the Executive dashboards using Visual composer7.0 and Xcelsius 2008.
• Designed and developed the BI security model for back-end and front-end access for various levels of the users

Environment: SAP NW2004s BI 7.0(SP17), SAP SRM 5.0, SAP R/3 ECC 6.0, ABAP, FI-GL, AP, SPL and HR-OM, PA.

Confidential, Tempe, AZ

SAP NW 2004s BI/VC Architect

Responsibilities:

• Involved in the Honeywell BI project implementation to remodel and improve the processes to achieve the excellence of enterprise wide information factory.
• Revamped the data models to comply with EDW, in order to achieve overall system performance, controlled data redundancy, flexibility and scalability.
• Avoided the redundant transformations and deployed re-usable objects to reduce the overheads on the CPU. Implemented the BI statistics to facilitate the BI administration cockpit for central monitoring of all the BI processes. Developed the Dashboard applications using Visual Composer to capture the BI metrics.
• Interacted with the business users for requirement gathering, collected the business specs and transformed into technical specs. Developed the documentation strategy for an efficient recording of issues/modifications or development of any object in the system environment. Lead the BI development team in the design and development of the reports.
• Trained and mentored the support and user groups.

Environment: SAP NW2004s BI 7.0(SP14), SAP R/3 ECC5.0, Enterprise Portals and Visual Composer, ABAP, SD, MM, FICO, EC-PCA and ORACLE 10.2.0.2.0 , HP-UX.

Confidential, Racine, WI

SAP NW 2004s BI/VC Lead Consultant

Responsibilities:

• Involved in the implementation of SAP xRPM dashboard Applications using Visual Composer.
• Designed and developed the xRPM BI model for the extraction of Portfolio Item Management, Item Capacity and Item Financial Management data into BI.
• Implemented the xRPM Dashboard applications using Visual Composer.
• Installed the Business content on xRPM and BW systems and extracted the data from xRPM system to BI 7.0 systems.
• Installed the business content xRPM reports and created some custom reports in order to meet the reporting requirements.
• Developed the complex dash board applications with various functionalities like eventing, Tab strips, and various other functionalities using the Visual composer.
• Implemented the Portfolio Item Management, Item Financial Management and Item Capacity management modules of the xRPM.

Environment: SAP NW2004s BI 7.0(SP11), SAP R/3 ECC5.0, Enterprise Portals and Visual Composer, ABAP, PLM, xRPM and ORACLE 10.2.0.2.0 , HP-UX.

Confidential, Houston, TX

SAP NW 2004s BW/BI Senior Consultant

Responsibilities:

• Helped the Energy Supply Group of Confidential in the capacity of senior BI consultant in the implementation of SAP NW 2004s BI 7 project constituting of supply chain management (SCM) and Suppliers relationship management (SRM).
• Analyzed the Business processes and involved in the requirement gathering for meeting the reporting requirements of the SCM and SRM Business.
• Identified the necessary Business Content, mapped the business process requirements with the available Business content. Installed and activated the relevant Business content for Master data and transactional data.
• Implemented the Purchasing, Inventory management and SD using the LO-cockpit extractions.
• Implemented the data extraction process on BI 7.0 that includes installation of the Business content, creating source systems, replicating the datasources and creating data transfer processes(DTP) using the graphical UI provided by new BI 7.0 features.
• Developed the web reports (Dashboard) reports for Supply chain management and SRM modules like Turn rates details report, Net Inventory reports, Open Invoices reports, Purchase order history reports and consignment stock reports and aging reports.
• Developed complex query definitions involving variables with replacement type and custom exits, CKF’s, RKF’s using the query designer. Created the RRI reports by setting up the sender/receiver parameters in RSBBS.
• Developed the workbooks with various templates using the report designer. Created the web templates using the Web application designer and published the reports on the Enterprise portals and Information broadcaster for emailing the reports as PDF files.
• Implemented organizational level BI security for accessing reports by appropriate users using the new security concepts of NW2004s BI7 features.

Environment: SAP NW2004s BI 7.0, SAP R/3 Enterprise edition, ABAP, SCM, SRM5.0 MM, SD and ORACLE 10.2.0.2.0 , SunOS.

Confidential, Huntington Beach, CA

Senior SAP BW Consultant

Responsibilities:

• Worked on the design and development of the InfoProviders needed for meeting the reporting requirements in the areas of FICO, SD, MM and PM.
• Installed and activated the business content as needed on R/3 and BW systems.
• Developed the InfoProviders for Sales orders, Billing, Deliveries, Plant maintenance orders, COPA, Purchasing, Plant maintenance orders and Budget data for plant maintenance.
• Enhanced the master data and transaction data standard extractors using user exits and created generic data sources using function modules and views.
• Created MultiProviders. Modified and enhanced the current reports to meet the reporting requirements.
• Created reports like advanced product availability report, Daily sales report by territory, Vendor confirmations report, Maintenance order report and Plan data by month reports.
• Used variables with replacement process, customer exits and calculated key figures and characteristics to handle complex calculations to meet the reporting requirements.
• Used Reporting agent to schedule the report execution and deliver the results to the users by email.
• Carried out the performance monitoring by using the system tools like ST03N, RSRT and RSRV. Created suitable aggregates and adjusted the OLAP CACHE parameters for a better query performance.
• Improved the back-end load performance by refining the data models, running the DB stats, setting the number range buffering’s and by adopting the parallelization techniques.

Environment: SAP NW2004 BI (V3.5), SAP R/3 Enterprise edition, ABAP, FICO, MM, SD and PM, ORACLE 10.2.0.2.0 , SunOS.

Confidential, Dallas, TX

Senior SAP BW Lead Consultant

Responsibilities:

• Primarily responsible for the BW architecture, design and development of the datamodels for extraction of data from legacy systems to BW.
• Responsible for requirement gathering, system analysis, hardware sizing, design, development and testing.
• Analyzed the requirements and identified the suitable business content for SD, MM, FI/CO and SRM, and had the standard InfoCubes, ODS’s, MultiCubes and various other relevant objects installed and activated.
• Implemented the Enterprise data warehouse (EDW) model to achieve flexibility, reliability and to support the corporate strategy.
• Customized the standard extractor’s and created additional InfoCubes, ODS’s and MultiProviders in-order to meet the end user reporting requirements.
• Carried several manual dataloadings from R/3 to BW for the data integration testing.
• Built the Master and transactional process chains and scheduled accordingly to upload the data into InfoProviders with appropriate dependencies.
• Developed an efficient error handling mechanisms to alert the failures on time.
• Keeping the performance in view partitioned and compressed relevant InfoCubes.
• Planning the Go-live with a minimum down time of the OLTP systems.
• Developed standard document templates and standard practices for every object that is developed. Mentored the users and support groups on the design, data model and the maintenance of the objects.
• Designed and developed the BW security model on the basis of functional area level.
• Developed over 150 single roles for R/3 users, over 40 single roles for SRM users and 50 single roles for the BW users using the profile generator (PFCG).
• Created composite rules and assigned the roles to users by doing mass user assignments by running CATT scripts.
• Designed the R/3 security model on the basis of the classification of the jobs
• BW security model is developed on the basis of functional area level, Data sensitivity and the user group levels.

Environment: SAP BW (V3.5), SAP R/3 Enterprise edition, ABAP, DB6, AIX.

Confidential, Houston TX

Senior BW Consultant

Responsibilities:

• Primarily involved in the Business Blue print, realization, Go-live and post Go-live support phases of the project.
• Implemented the LO-cockpit extractions for Purchasing, Inventory Management, Sales orders, Billing and Deliveries. Made enhancements to the several transactional and master data datasources using the user exits. Installed the business content for master data and transactional datasources. Enhanced the extractors in the areas of Logistics, FI-AP, AR and G/L. Created several generic datasources (using tables/views and Function modules) for extracting the R/3 data from different tables.
• Developed the Master data process chains, Transactional data process chains and Open hub process chains, automated the triggering and monitoring of the same on daily, weekly and monthly basis. Developed an automation program for a third party tool called MAESTRO to trigger and monitor all the process chains and to intimate the failures of any sub processes to the concerned developer via pager.
• Developed several BW reports like Vendor information report, Cost saving report, Spend on contract report, lead time performance report, Contract expire report, Returns report, Open invoices report, Expense reports using query builder and Web application designer.
• Worked on the distribution of the data extracts from BW to external systems like XELUS and UNAS using the Open-Hub service and its components like Infospoke by setting up the source and destiny, type of upload and transformations using BADI’s.
• Handled the troubleshooting with deft in resolving the problems like ORA errors, activation and updating due to inconsistent data problems while loading the data.
• Contributed a lot for performance tuning by making use of the performance analysis tools (STO3N, RSRT and BW statistics). Carried out the DB stats and number range buffering for all the InfoProviders. Adjusted the optimum parameters for RUSCUSTA2 and ROIDOCPRMS parameters. Also adopted the load balancing and parallelization techniques for improving the load performance.
• Tested and tuned the reporting performance by creating the aggregates for appropriate cubes, created secondary indexes on the ODS’s, adjusted the Cache parameters(RSRCACHE) and decided the appropriate Read mode depending on the Infocube type and size for optimum query performance, did the compression of the infocubes .Installed and activated the BW statistics for the performance analysis. Created the proposed aggregates on the cubes and created secondary indexes on the ODS’s for improving the efficiency of reporting and open hub extractions.
• Created time conversion ABAP function module taking care of the time in hours and minutes. And was used in several update rules for calculating the effective time taken with precision in minutes.
• Involved in the implementation of the Global BW security setup by designing the security model with several levels of security.
• Created the necessary authorization objects (RSSM) and made the Infoproviders authorization relevant. Developed security at Geo level, Functional area level and also on the data sensitivity level. Developed End-user, Power user, Developer and Analyst roles.

Environment: SAP BW (V3.0B) with SP23, SAP R/3 4.6C and SAP R/3 Enterprise edition, ABAP, ORACLE 9.2.0.4.0, HP-UX.

Confidential, Beaverton, OR

Senior BW Technical Analyst

Responsibilities:

• Responsible for the data extractions from R/3(AFS) and external systems to BW for Logistics, FI/CO, Controlling and Enterprise Controlling.
• Worked extensively on LO Cockpit and COPA extractions. Loaded the data from R/3(AFS) to BW.
• Managed and monitored several data loadings, captured the errors and corrected the bugs and applied several OSS notes for the errors encountered while loading the data.
• Created transfer routines in the transfer rules, update routines in the update rules and formulae in start routines and update routines using the formula builder. Modified the User exit programs to accommodate the additional fields in the extract structure of the datasource.
• Handled a lot of dataload failures (due to invalid characters, ORA errors etc.,) and fixed them on time in production. Conducted performance tests in the Confidential performance system and analyzed the performance of the system for every subject area loadings. Created the secondary indices for the ODS’s and aggregates on cubes for better query performance. Optimized the load performance by adjusting the ROIDOC parameters, packet sizes and number of info Packages. Used the parallelization techniques while loading into ODS objects.
• Worked with query builder to build queries in the areas of ECCS, CCA, AP, AR and COPA.

Environment: SAP BW3.0B, SAP R/3(AFS) v 4.6C, ORACLE 8.1.7.4.0, HP-UNIX, WAS 6.2.

Confidential, Mountain View, CA

Senior BW Consultant

Responsibilities:

• Implemented ASAP methodology for the quick implementation of the project. Involved in the realization, final preparation and Go-live support phases of the project.
• Designed the architecture for Standard Revenue Recognition module. Created Data Sources via RSO2 in R/3 using function modules and tables/views, written transfer routines to in corporate the business transformation rules.
• Implemented COPA, Created the Sales Order ODS, Revenue ODS, COPA ODS, Revenue Accounting ODS and Deferred Revenue ODS.
• Created respective update rules with necessary update routines. Created the infosources and scheduled several dataloads with update methods like Full update and initialization followed by delta updates. Monitored the scheduled background jobs.
• Created Consolidated Revenue InfoCubes, and uploaded using the generated data marts in BW.
• As a part of maintenance and as per end users requirement, created new columns in the ODS and InfoCubes and uploaded the same without disturbing the historical data.
• Created Virtual key figure and virtual characteristic infoObjects for the effective query management.
• Worked extensively on BEx Analyzer (RRMX). Created queries using BW-Reporting Variables, Navigational attributes and Filters and also on the Multi Cubes. Developed several queries and the workbooks using BEx Analyzer according to end users requirement.
• Used RRI jump queries using the transaction RSBBS for drilling down to other queries and R/3 transactions. Mentored the BW users in handling BEx Analyzer and Browser.

Environment: SAP BW 2.1C/3.0A,SAP R/3 v 4.6C, ORACLE 8.1.7.2.0, HP-UX

Confidential, Springfield, MA

Senior SAP Consultant

Responsibilities:

• Worked on Procurement Cubes, Cost Center Cube, Investment and Inventory Management Cubes. Uploading the Master data and transactional data from SAP R/3 into BW via Data Staging to PSA, ODS and InfoCubes.
• Worked extensively on configuration using Administrator Workbench (RSA1). Customized data Sources, InfoObjects, Info Sources and InfoCubes.
• Analyzed InfoCubes (via RSRV) created and maintained aggregates (RSDDV) to improve the query performance. Worked on CO-PA Extraction to SAP-BW.
• Heavily involved in customizing and activating standard delivered BW business contents in the areas of FI-AP/AR.
• Developed the code for outbound and inbound interfaces for GL reverse translation extract, GL verification extract, case accounting and fleet email notification. Developed the check reconciliation range report, developed an inbound interface which downloads data from external systems and generates a report showing the outstanding checks comparison with SAP R/3 files.
• Developed an outbound interface for calculating the total appreciation and depreciation values for the given company codes.
• Designed and coded a user-friendly front-end drilldown report for maintaining the log information of all the ABAP objects created in SAP R/3. Developed a front-end tool for listing and deleting the duplicate records from the reverse translation table.
• Designed and developed the Sapscripts for printing the customer input form, check disbursement reconciliation statement and payments check report printing.
• Developed HR reports like head count report, assignment of wage-types to GL accounts, customized HR process model to in corporate a payroll check log custom object into the process model to enhance its application for payroll administration.
• Also involved in the production support and fixed several bugs using ABAP Debugger and fine-tuned several programs using SQL Tracing and Run Time analysis tools.

Environment: SAP R/3(4.6C), SAPBW 2.1C, FI/CO, TR, HR and AM modules, Windows 2000 Prof, AIX, DB6.

Confidential, Indianapolis, IN

Senior SAP Consultant

Responsibilities:

• Designed custom LIS structures (LBW0), Data sources in Purchasing, Inventory management and Sales to facilitate process and management reporting using classification data in material master and uploaded the respective data into BW.
• Coordinated integration testing with process teams to validate data in LIS and BW structures and seek end user acceptance. Worked with system admin teams to define specifications for frequency and mode of data transfers and setup batch jobs for InfoPackages. Gathered user requirements and designed custom InfoCube by enhancing Info Sources and InfoObjects. After R/3 upgraded to 4.6C all the Data Sources are replicated and activated. Scheduled the InfoPackages and solved the errors involved.
• More than 200 Manual Loads were done for all the application area. Created ODS Objects and did the load monitoring while scheduling the data uploads. Created Transfer Rules, Update Rules and Update Routines.
• Did the Data Extraction and Data Staging using both LIS (LBW0) and LO Cockpit (LBWE) and extended the structures using user exits to support the business needs. Did the Data Integration test in both Development and Quality boxes and moved the cubes into Production. Did the authorization (PFCG & RSSM) and Security Profile Testing for InfoCubes and reports for end users and power users. Worked extensively on BEx Analyzer (RRMX) and Browser for building queries and Workbooks. Created custom queries using variables and structures. Worked on RRI Jump queries and worked on Web Reporting and Web Publishing.
• Developed reports for the sub modules of MM like Purchasing, Invoice verification and Inventory management. Developed interactive reports like Vendor report for Additional information, Duplicate Invoice report, Register for Manual payments report, Variance report for subcontracting, Property tax statistical information report.
• Involved in translations for various reports i.e. from English to French, Spanish and Deutsch using the transaction SE63.

Environment: SAP R/3(4.6C),SAP BW1.2B/2.0B, FI, CO, HR, MM and SD modules, Windows NT 4.0, Oracle 8.0.

Confidential

Senior ABAP Programmer

Responsibilities:

• Involved in the Implementation of R/3 4.0B for MM, SD and FI/CO modules