SUMMARY

• Around 10 years of extensive techno - functional experience in SAP BI/BW in 3.0, 3.5 and Netweaver 2004s (7.0), 7.3 versions and SAP ABAP
• SAP Certified SAP HANA Consultant with Hands on project Experience in SAP HANA 1.0.
• Extensively worked in Data Modeling,Data Provisioning,Optimization, Reporting,Security and Authorization aspects of SAP HANA 1.0
• Good working noledge of different replication technologies like Business objects data services, SAP LT replication for replication into SAP HANA database.
• Good understanding and experience inproviding security restrictions on models using analytic privilegesand assigning to Authorization roles for different types of users in SAP HANA.
• Good noledge of In-memory database concepts like in memory column store and row store.
• Experience in using complex SQL CE functions for pushing data intensive logic to the database instead of the application layer.
• Involved in complete life cycle implementations of SAP BW.
• Worked extensively in creating user groups, importing roles from SAP BW and enabling single sign on, assigning security, access levels etc.,
• Expert in frond-end reporting with Web Reporting, BOBJ/BI, BEx, WAD, Excel development, BSP, and other web technologies.
• Extensive experience in SAP BI application management and support.
• Extensive hands-on experience in working with SAP application modules such as Logistics, SRM, HR& FI-CO.
• Worked in the realization of complete reporting solution in Procure to Pay (P2P) area.
• Expert level skills in Bex Analyzer and WAD
• Experience working with Cross-Functional Analytics and Operational reports from SRM, MM and AP subject areas.
• Realized KPI’s like Costcenter Allocations (Variances), Feature-Mix & TCP, Vendor Reliability metric, Balance Sheet, Sales Cockpit etc.
• Sound Understanding of the SAP BW architecture and able to realize complex BI solutions.
• Sound BW ABAP Skills with experience enhancing extractors and optimizing load performance.
• Expert in designing logical data models based on functional requirements and load strategy specifications to capture source data, data consolidation mechanisms, and integration scenarios for reporting purposes
• Competency in all phases of the project from analysis, design, development, configuration, testing, as well as documentation, and providing end-user training
• Experienced in Unit Testing, Integration testing and using HP Testing tools
• Technical and functional expertise well augmented by excellent analytical and interpersonal skills, with the ability to interpret business requirements and transform into technical deliverables.
• Worked closely with Business Users, Managers and Technical Architects.
• Custom Report programming including ALV reports across all functional modules and Model View Controller approach with Classes and methods (OOPS Concepts)
• Performance tuning ABAP code, Debugging and trouble-shooting break-fix issues
• Data Conversion programs using BDC and BAPIs
• Creating custom forms using SAP Scripts, Smart forms, Enhancements using Enhancement Spots,BADI’s,User Exits,Module pool programming, Web Dynpro Application Developments, Workflow, Experience in ALE, EDI, RFC and IDOC configuration.

PROFESSIONAL EXPERIENCE

Confidential

SAP BWConsultant

Responsibilities:

• Developed various transformations to cleanse the data and enhance the master and transaction data using Formula Builder and start and transfer routines with ABAP4 to suit the business requirements
• Populated various data targets like Info Objects, ODS and Info Cubes, with Master data and Transactional data from ECC 6.0, legacy systems using flat file interface via Data Staging area (PSA)
• Debugging the Extractor checker, Start routines and End routines
• Performance Tuning - Evaluated statistical performance and provided recommendations for optimization. Improved data load and query performance by doing compression, aggregates, and partitioning.
• Open Hub interface to transfer data from BI to Flat Files to load to an external system.
• Created DTPs, Info packages for Full, Initial, Early init, Delta and Full repair loads for both Master data and Transaction data
• Created process chains using various process to automate data loading, activation of DSO, compression, drop and create indexes, init fills, roll up, attribute change run and DBstats etc.,
• Performed huge data loads into DSO and Info Cubes from ECC as well as the legacy systems
• Developed Queries to access data from various BW Info Providers like DSO, Info Cubes, Info Objects, Multi Providers and Info Sets using BEx query designer
• Created Jump queries (using RRI), Restricted Key Figures, Calculated key Figures, Filters, Conditions, Variables and Structures
• Created various interfaces from BW to various non-SAP systems using APD and OPEN HUB.
• Experience and noledge of the various methods to access and extract master data and fact data (including consolidated data) from BPC (Business Planning and Consolidation)
• Automated BPC Master and Fact data loads from BW to BPC
• Worked in the modeling and realization of key performance metrics likethe DAPU(Daily Accounting Period Update) indicator which would give the higher level executives the insight into Sales, Pending, Invoice able, Canceled and Excluded order line information.
• Worked in the realization of reports in the Business Objects Explorer and Analysis for office.
• Worked closely with the business during requirement gathering, testing.
• Worked closely with the ETL (data services) team in formulating the source to destination mapping logic and in addressing the data provisioning challenges faced due to a highly heterogeneous nature of the data being sourced from multiple SAP and non SAP source systems into the SAP HANA database.
• Held workshops with the business users to explain the usage of the SAP HANA Studio.
• Involved in extensive Integrity testing and reconciliation of the HANA models with the source data.
• Worked closely with the business objects team in trouble shooting and ensuring that BOBJ Webi reports run seamlessly with the HANA models.
• Worked in the security aspects of SAP HANA like creating analytic privileges.
• Worked in performance tuning and optimization of SAP HANA models.

Confidential, Illinois

SAP BWConsultant

Responsibilities/Deliverables:

• Extensively worked in the backend development, deployment and support ofmultiple SAP BW projects like: SRM BW Reporting, E-billing, HR Reporting, Bank Balance, Foundation IP, SAP HANA BW Integration and Enterprise SAP HANA pilot.
• Installed standard business content for SRM and worked on the custom enhancements to realize the custom requirements from the business,
• Developed custom BW modelfor org unit and cost center security as part of the BW HR project.
• Worked in the realization of the aggregated bank balance solution as part of the Bank balance project.
• Worked in the realization of a reporting solution leveraging existing BW infrastructure to provide a consolidated view of the metrics for the upper management and senior executives from the legal department and various BU’s as part of the legal Foundation IP project.
• As part of the HANA Integration project, optimized the Foundation IP related content.
• Worked Extensively in Data Modeling,Data Provisioning, Optimization, Reporting, Business content, and Security and Authorization aspects of SAP HANA 1.0 as part of enterprise SAP HANA pilot.
• Extensively worked with the SAP HANA studio for administration and data modeling.
• Good noledge in SAP MM,AP,FICO relational database model in SAP ECC for replication into SAP HANA
• Experienced in using SAP Business objects Data services and SAP LT replication server for data provisioning into SAP HANA from SAP ECC
• Worked in the realization of GET Dashboard pilot data model in SAP HANA.
• Extensively used Business Objects tools like Business objects Explorer,Web intelligence and Xcelciusdashboards to report against SAP HANA data.
• Extensively used SQLScript and SQL CE functions in developing complex and performance optimized Calculation views
• Extensively developed Attribute views,Analytic views and Calculation views modeling using SAP HANA Development studio
• Experienced inproviding security restrictions on data models using analytic privilegesand assigned to Authorization roles for different types of users in SAP HANA.

Confidential, Dallas, Texas

SAP BW - Application Management

Responsibilities/Deliverables:

• Worked as an SAP BW Lead Consultant for customer that has implemented SAP BW 7.0
• Work involved daily BI process chain monitoring and break fix, resolving BI incidents, model defects and application infrastructure requests.
• Worked closely with the project team in taking the transition after each release and taking over the support after go live.
• Developed the following Inventory reports:
• Stock Overview
• Inventory Aging
• Slow Moving Items
• Used the standard extractor 2LIS 03 BF for goods Movement, 2LIS 03 UM for Material movements and 2LIS 03 BX for Stock Initialization in the realization of BI Inventory reports.
• Worked in resolution of a myriad of BI issues like TRFC errors, delta breakages, failure in IDOCS, failures due to short dumps, delayed data loads, invalid PSA entries and troubleshooting missing documents in BI etc.
• Build Efficient Aggregates on Stock Overview, COPA and GL line item and summary cubes to drastically improve the runtimes of queries running on top of these cubes.
• Worked on standard SAP content for BW statistics analysis and Build Statistics queries that halp in the query and workbook runtime statistical analysis.
• Worked extensively on G/L reconciliation in addressing the issue of G/L totals not getting summed up to zero for certain periods and profit centers. Worked with the new G/L extractor
• Experienced in raising effective OSS messages for issues that needed SAP halp.
• Extensively worked in account based COPA reconciliation and worked with SAP in tackling the problem of missing COPA documents in BI.
• Extensively worked in G/L line items and G/L totals month end reconciliation to inform the business that all FI data is reconciling before they start month end reporting.
• Build efficient aggregates on info cubes to improve the BI query runtimes as part of BI performance optimization.
• Built BEx queries with Restricted Key Figures, Calculated Key Figures and Variables which would be utilized to build the Business Objects OLAP Universes.

Confidential

SAP BW Consultant

Responsibilities/Deliverables:

• Extensively worked in realizing SRM and MM reporting in BW.
• Work Involved the Development and testing of SAP Supply chain BI reports, production support of SAP BI Supply chain landscape, resolution of Application development and configuration requests.
• Worked closely with the supply chain business users in understanding the requirement s for new BI reports and changes involved as part of production support of existing BI reports.
• Developedsupply chain analytic reports like Vendor delivery Performance, Master Purchase order,Status of Goods and Service Confirmation report, Expiring Contracts and Contract Details report,Contract at Product Level,Open Items report etc adhering to the requirements from the business.
• Developed interactive WAD Dashboards for Supply Chain business users.
• Successfully involved in the unit testing and integration testing of SRM and MM BW data and reports as part of FPL SAP Phase 2 implementation.
• Successfully completed the support pack upgrade testing of Supply chain BI reports.
• Closely Worked with the SAP security team in providing different authorizations based on roles for creating and saving the global and local variants for BI reports for supply chain users.
• Worked in implementation of a solution to enhance the SAP standard SRM extractor for contract statuses.
• Involved in implementing the solution to fix the delivery status and delivery timing field for partial receipts in vendor delivery performance logic.

Confidential

SAP BW ABAP Developer

Responsibilities/Deliverables:

• Worked as a SAP BI Consultant for customer that has implemented SAP BW 7.0
• This project is a brand new full implementation of P2P reporting in SAP BI.
• Worked in the realization of complete reporting solution in Procure to Pay (P2P) area.
• The Reporting included Cross-Functional Analytics and Operational reports from SRM, MM and AP subject areas.
• Used LO cockpit for ECC data extractions.
• Enhanced and used these standard SAP extractors to pull P2P data in BI:
• 0BBP TD SC 1 (SC)
• 0BBP TD SC APPR 1 (SC Approval)
• 2LIS 02 SCL (PO)
• 2LIS 06 INV (MM Invoices)
• 0FI AP 4 (vendor Line Items)
• Extensively used Netweaver 2004s Features, Business Content was migrated from 3.5 versions.
• Latest functionalities like DTP, Remodeling Tool, Transformations, Advanced WAD, and Report Designer etc were used.
• Automated the loads, aggregate rollups and change runs using process chains.
• Effective Dashboard was deployed for all the web reports developed.
• Portal Themes, 0ANALYSIS PATTERN were used to create custom web reports
• Extensively used Reporting functionalities like Information Broadcasting, RRI, Cell Editors and Custom variables.
• Analyzed collective performances of various queries to improve performance.
• Created Indexes, Aggregates, partitions and other optimizing techniques to improve loading times.
• Lead a Pilot project to integrate the backend SAP BW with BOBJ
• Created standard universes on BEx queries to enable ad-hoc reporting at end users.
• Extensive worked on CMC App in assigning access levels to users and applying the security settings to user groups.

Confidential

SAP ABAP Programmer

Responsibilities/Deliverables:

• Interfaced between iTrakForce (JAVA based web application, non-SAP system) and HR Master Data (SAP ECC 6.0) using SAP PI
• Conducted map & gap analysis with SAP HR integration with third party tool
• Documented detail business requirements for proposed interfaces with SAP HR
• Essayed a key role in defining functional, technical specifications and unit test documents of the interfaces
• Coordinated between SAP and PST for any additional support required for certification of interfaces
• Worked in ALE, IDOC, HR related message types & segments to send and receive data through IDOCS in R/3 system
• Evaluated the functional specification
• Developing the Technical Specification Document based on the Function Specification input.
• Developed ABAP code confirming to client standards and completing the unit test plan
• Deliver objects in time following projects standards and guidelines