SUMMARY

• Over 13 years of IT experience in Analysis, Design and Development of SAP applications of which above 12 years in SAP BW/BI, SAP HANA, SAP BPC, S4/HANA, SAP ABAP on HANA Live and BusinessObjects reporting.
• Experience in information and data architecture, system upgrades, requirement analysis, solution design, enhancements, implementation and support.
• Excellent Team Player and Team handling Capabilities.
• Good knowledge in SAP BI/BW implementation with in depth technical skills in various SAP R/3 implementations, Rollouts, Upgrades, and Post implementation support in MM and SD mainly using LO - cockpit extractions.
• Hands on experience in End to End SAP BW to HANA Migration as well as Native HANA modelling and Architecture.
• Implemented SAP BI/BW with in depth skills in FI-CO module and worked on sub modules likes FI-AA (asset accounting, Customer/Vendor Analysis), FI-AR, FI-AP, FI-GL, and Controlling Project accounting mainly using standard extractors with customized and generic extractors.
• Extensive experience in developing BW processes and models with InfoObjects, InfoCube, DataStore Objects (DSOs), Composite Providers, Advanced DSOs, Open ODS views, Transformations, MultiProviders, InfoSets, Open Hubs, DataSources, Update & Transfer Rules, Process Chains.
• Worked on SAP HANA implementation projects with both Native HANA and SAP BW on HANA Landscapes.
• Worked on HANA Live implementation, S4HANA Embedded BW and HANA CDS view implementation.
• Expert in creating new Core Data Service, Converting views to Extension table and Procedure proxy.
• Expert in in new ABAP Open SQL language and code to data programming.
• Excellent knowledge on: Advanced DSO, Open ODS view, Transient provider, Embedded analytics, HANA live, HANA database artifact, HANA XS, Procedure, CDS, BW4HANA Optimized HANA Optimized DSO's, Transient, Composite, Hybrid Providers, Publishing HANA Model in SAP BW, Import SAP Net Weaver BW Model to HANA
• Experience with SAP HANA data modeling using Attribute View, Analytical View, Calculation view, Stored Procedures, Table Functions, Decision tables & Analytical Privileges.
• Good Knowledge SAP HANA. Experience HANA data modeling using Attribute View, Analytical view and Calculation view Experience in SAP HANA Data Provisioning using SAP LT Replication Server (SLT ) and Data services Knowledge.
• Seasoned hands-on professional skilled in balancing user requirements, client objectives, and technology capabilities in ERP, Data Analytics, Business Planning and Budgeting.
• Expert in SAP BPC Planning, Master data and dimensions modelling, BPC Models Design and Architecture, System Administration, Data Manager Packages, Transformations, Script Logic, Business Process Flows, Business Rules, Work status, Data Access Profiles, BW/BPC integration.
• Developed EPM Excel Add-in Reports & Input Forms for Financial Budget Planning, Cost Center Planning, R&D Project Expense Planning, Sales Operations Planning, CO-PA, Funds and Grants management planning (FM) using Funds Center, Fund, Commitment Item, Grants, Funded Program).
• Hands-on experience in analysis, architecture, implementation, migrations, upgrades, and production support of end-to-end SAP Business Intelligence environments including front-end BI (Business Objects), back-end (BW and HANA DB), Web Intelligence (WebI), Analysis for Office and Dashboards, Design Studio, and HANA DB connector.
• Good knowledge on HANA scripting and Data provisioning activities
• Hands on experience in Smart Data Integration (SDI)
• Good experience in working projects where the backend data model is built in SAP BW and front end reports are delivered using Business Objects tools like Webi, Design studio and Analysis office.

PROFESSIONAL EXPERIENCE

Confidential, Tampa, FL

SAP HANA / BW Consultant

Responsibilities:

• Collect requirements, perform fit/gap analysis, evaluate and propose HANA deployment scenarios.
• Create SAP HANA Proof of Concept (POC) including Attribute, Analytical and Calculation Views.
• Translate traditional data modeling concepts into SAP BW/HANA modeling concepts Create Information models to migrate SAP and non-SAP sources into SAP HANA environment.
• Document functional and technical specifications for SAP HANA Information Views Perform data provisioning using SAP Landscape Transformation (SLT) for replication of ECC data.
• Establish best practices and modeling guidelines for modeling views in SAP HANA Transport objects via Delivery units across different landscapes.
• Join data from multiple datasets to provide unified view of data based on use cases Utilize HANA Live views (query, reuse and private) in the custom created views Create/Debug SQL functions to identify the technical/data issues using SQLScript.
• Implement Smart Data Access (SDA) for accessing remote data sources.
• Develop views using Filters, Variables, Input Parameters, Calculation and Restricted columns.
• Create reports using Business Objects (BOBJ) tools like Webi, Analysis for Office and Lumira
• Worked extensively in BEx Query Designer, Excel Analysis for Office, Crystal Reports and Web Application Designer.
• Worked on design and development of planning / input forms and reports using SAP BW, SAP BPC EPM Excel Add-in and SAP ECC data source enhancements, BW - BPC data integration, delta data loads, process chain automation.

Lead SAP BW/BOBJ/HANA Consultant

Confidential

Responsibilities:

• Participating in project planning sessions with project managers, business analysts and team members to analyze business requirements and outline the proposed solution.
• Preparing high level and low level design documents by following MPS BW 7.4 powered by HANA design principles.
• Performed pre-migration activities for BW on HANA implementation from 7.3 to 7.4 and optimized BW modeling objects as per the need for BW on HANA.
• Participating in brain storming sessions for optimal use of BW7.4 HANA features in existing HANA application.
• Conducting design reviews with MPS governance and MPS architects.
• Identifying critical objects and queries for PSEDW applications before BW system migration from BI 7.3 to BW 7.4 on HANA.
• Performing housekeeping activities like PSA clean up, Identifying and moving historical data to NLS, deleting unused aggregates and other objects to reduce DB size before BW system migration.
• Testing and verifying the PSEDW BW identified critical objects after SAP BW 7.3 system migration to BW 7.4 on HANA.
• Identifying and converting normal cubes into HANA optimized cubes for performance optimization for PSEDW application.
• Integration Testing, Business acceptance testing and Parallel Run testing, Handover, Hypercare etc.
• Performed lead reviews for identified modules against defined standards and templates.
• Extensively worked on LO Extraction Cockpit to extract Logistics data from Source System (R/3).
• Developing ‘Safety & Max Stock’ Logistics Module using SAP FM based generic extractors, Infocubes, DSOs, Transformation with Expert Routines, DTPs, Info packages and process chains.
• Consumption of HANA information Models in BW by creating Composite and Transient Providers.
• Coordinating with MPS IS team and Business Users during business acceptance testing and parallel run.
• Developing and documenting test cases and test results after SIT, BAT and parallel run.
• Resolving priority 1 failed test cases raised in HP QC tool.
• Improved performance of the LO and MM Module Identified applications by 40% and data consistency by 20%.
• Identifying critical objects and queries for PSEDW applications before BW system migration from BI 7.3 to BW 7.4 on HANA.
• Performing housekeeping activities like PSA clean up, Identifying and moving historical data to NLS, deleting unused aggregates and other objects to reduce DB size before BW system migration.
• Testing and verifying the PSEDW BW identified critical objects after SAP BW 7.3 system migration to BW 7.4 on HANA.
• Identifying and converting normal cubes into HANA optimized cubes for performance optimization for PSEDW application.
• Migrating data from non-SAP systems into SAP HANA using BODS.

Confidential, Brunswick Gardens, NJ

SAP HANA Lead Consultant

Responsibilities:

• Re-organize and redesign the global data warehouse reporting solution consisting of SAP HANA, SAP BW, SAP BI and other relational database like Microsoft SQL DB.
• Delivered enterprise global reporting KPI template for OTC, Supply chain, Financial Supply chain, Finance, Manufacturing and Warehouse management business users.
• Build a scalable LSA++ architecture for the BW on HANA data warehouse.
• Responsible for migrating a stabilize BW data warehouse to SAP HANA and subsequent planned migration to SAP BW4HANA connected to Business suite.
• Activation of Hana Live report and real time reporting using enterprise HANA live reporting Create various CDS views and reuse some of the HANA live view as extended views in ABAP.
• Developed VDM, ADSOs, Open ODS views, Composite Providers, DTPs, exposed HANA models to BW and performed Data Provisioning using SDA.
• Proficient in IDT to create Universe and BO reports, and Design studio for reports and dashboards.
• Customized and created different real time report using SLT as data provisioning.
• Design real time reports using a combination of HANA live report and historical data from BW.
• Created different Analytic view, Graphical & SQL scripted calculation view Build an hybrid native Hana + SAP BW
• Planned and implemented HANA dynamic tiering for cold data.
• Redeveloped BW security and transports strategy for all users.
• Co-ordinate project deliverable and schedules.
• Co-ordinate onshore-offshore resource allocation and deliverables.
• Co-ordinate the activities between onshore HANA/BW resource and offshore resources
• Involved in initial requirements gathering, business blue print, and gap analysis and integration needs of BPC Planning project.
• Worked on design and development of planning / input forms and reports using SAP BW, SAP BPC EPM Excel Add-in and SAP ECC data source enhancements, BW - BPC data integration, delta data loads, process chain automation.
• Worked on master and hierarchy data setup and dimensional modelling of materials, batches, classification, customers, markets, product brand, product size, and package.
• Worked on design and development of planning / input forms and reports using SAP BW, SAP BPC EPM Excel Add-in and SAP ECC data source enhancements, BW - BPC data integration, delta data loads, process chain automation.
• Developed Data manager packages, Script Logic, transformations, flat file data (CSV) uploads.
• Defined testing strategy for BO upgraded to 4.x and other existing processes.
• Data migration into other non- SAP databases for EDW using ETL BODS.
• Created the blueprint for CRM Sales Pipeline data modeling in HANA.
• Created Functional and Technical design document to extract Sales Pipeline, Business Partner, user Status and System Status data in BW on HANA.
• Created documentation as per Confidential & Confidential standards, templates and design patterns. Involved in doing estimation, project assessment and status review.
• Worked on BW on HANA, Virtual and Persistent layers. Used HANA design tools and Eclipse tools.
• Created HANA views: attribute view, Analytical view, calculated view.
• Used WEBI to create reports on BOBJ universes, BEX queries.
• Loaded data from SAP and Non-SAP sources using SLTs and BODS.

Environment: SAP BODS/BO 4.1, ECC6/CRM7- CR&B/ISU, MS-SQL server, Oracle. SAP HANA 1.0 SP09, Predictive Analytics, BODS, ETL, ECC 6.0, CRM, Erwin, Oracle, SLT, BW, SQL, PL/SQL, BO4.1, Web Intelligence, IDT, Design Studio. Preparation of Road map for simple finance & building the team for the project.

Confidential, Sugar Land, TX

SAP Business Objects Admin/ Developer

Responsibilities:

• As part of this project, handling different Confidential and taking care of all sales, purchase and inventory related flows. Creating new Business Objects 4.1 on WEBI, Crystal and Design Studio reports as per user requirement and handling BW related changes in both Retails and Merchandise teams. Creating and monitoring Batch jobs
• Scheduling and monitoring process chains related to SAP BW flows
• Prepared detailed documentation of all the Business objects Reports and Universes which were created newly.
• Creating universes with in BO 4.1 and dashboards on Design Studio 1.6
• Creating and publishing stories Lumira server, cloud and in BI Launchpad
• Created the complex Business objects 4.1 Webi reports as per the business requirements
• As a Tableau Developer, using Tableau for Data Analysis, Digging the data for source, systems analysis and deeply diving the data for Predictive findings and for various data Analysis.
• Providing user training and helping users who uses tableau reports.
• Performed Scheduling of the reports to the end users BI Inbox and E-Mails and publishing the reports into public folder.
• Recreated the Web intelligence reports from Desktop reports
• Coordinated the User Acceptance Testing for all the SAP Business Objects reports.
• Build stored procedures and ad-hoc SQL queries to solve business needs

Environment: QlikView12, QlikSense 2.0, SQL Server 2008 R2/ 2012, Oracle Database, Maximo, Microsoft Access, SVN tool, SSIS, SSRS, SAP Business Objects 3.1 and 4.1 Tableau, SAP Data Services and Informatica.

Confidential, Houston, TX

Senior SAP Consultant

Responsibilities:

• Gathered and understood business requirements, designed and developed end-to-end solution for Cost Center and Profit Center Planning:
• Built Data Modeling in BW for staging and transforming data from ECC.
• Designed and created Environment, Models and Dimensions.
• Created Packages, Transformation and Conversion files to import master and transaction data from BW to BPC.
• Created Logic Scripts and DM Packages to copy versions, update Work Status, archive data, and perform calculations.
• Designed and set-up Security objects such as Teams, Task Profiles and Data Access Profiles.
• Configured Work Statuses to lock data, set-up Drill-through, and enabled Audit and Comments.
• Designed and built Cost Center Planning, Profit Center Planning, Scenario Planning and HC and Salary Planning Input Templates and Reports for Forecast and Budget; and created VB macros to perform various actions.
• Implemented and enhanced a number of BAdI’s:

  START ROUTINE and END ROUTINE BAdI’s for loading master data and hierarchies from BW to BPC; RETRACTION BAdI to post the planned data from BPC to ECC by calling a BAPI; WRITEBACK BAdI to disaggregate the plan data entered at different parent level combinations and to distribute the values evenly to the underlying base members; perform currency conversion; and UJ CUSTOM LOGIC BAdI to copy versions, calculate data, post data to ECC, update Work Status, extract data from BPC Model and update DSO.

• Created a copy of UJD TEST PACKAGE to customize the parameters to be passed to each DM Package; created programs to perform selective deletion from InfoCubes, to rename UJBR Back-up file, to clean-up Work Status, Audit and Comments tables, to update Dimension members and to update TVARVC values.
• Designed and built Archiving, Back-up and Clean-up solution for BPC.
• Identified, troubleshoot and resolved Production issues in BPC and Excel; and provided support as BPC Admin.
• Performed upgrade of existing BPC 10.0 objects to BPC 10.1.
• HANA and Business Objects Development done across all the business Areas for the BI Projects:
• Developed all Technical Specifications based on Functional Specifications that outlines required Characteristics, Measures and Business Rules. The Technical Specification outlined the overall HANA design to meet and satisfy the Business Reporting Requirements.
• Using data provisioning methods like SAP SLT for real time data and Business Object Data Services (BODS) non sap data Flat file upload and direct extraction connection (DXC) to acquire the data into SAP HANA Data Mart.
• Setup Table Replication (SLT) for ECC and 3rd party table's real time into Hana. Data replication enhancements created for custom fields when required (during replication).
• Developed the following HANA Data Models: Attribute Views for master data, Analytic Views for Transaction Data and Calculation Views (Graphical and SQL Script) to Join/Union the various Attribute and Analytic Views for report consumption with time dimensions.
• Creating Information Models (Calculation Views, Analytical views, Attribute views) as per the business requirements with functional areas of FI, CO, MM, SD, CRM and PS data.
• Creation of Input Parameters, Variables and mapping them with BO reports
• Time generation in HANA studio, SQL scripts for calculating Time characteristics in HANA views
• Schema mapping in HANA studio for Export and Import transports from different lifecycle systems. Export and Import of HANA views between different lifecycle systems through Developer mode as well as through Delivery unit.

Confidential

Sr. Applications System Analyst

Responsibilities:

• Installed, configured and administered the Business Objects 4.1 SP1/4.0 SP3 environments and configuring Development, Test and Production cluster virtual environments.
• Configured and integrated LDAP Authentication, mapping extended user attributes in the LDAP Directory to Business Objects and applying security using extended user attributes on Business Objects Universes and Reports (.unx)
• Developed technical documentation and Administration of the BusinessObjects Platform 4.1 that ensured SAP BusinessObjects platform applications are developed in compliance with architectural standards, established practices with organizational policies and procedures.
• Acted as internal consultant providing assistance, counsel and advice both to the stakeholder and MD Anderson colleagues in systems design, through the use of purchased of licensed software, and in-house developed programming.
• Performed and oversees system applications Implementation design, development, installation, maintenance and enhancement in regard to best practices.
• BO Upgrade from XIR3.1 to 4.1 and also responsible for applying service pack and fix pack to BO installation and also deployed WAR files after upgrade.
• Ensured all the environments are in synchronization and checked supported environments and hardware requirements from the Products Availability Report (PAR) document for the new installation.
• Scheduled Crystal Reports, including parameters requested by end user, to be received on a weekly basis of past-due accounts.
• Deploying stored procedures to the database for access as data sources for new Crystal Reports.
• Increased efficiency by implementing plan for Crystal Reports to be stored on the web server for access by end users
• Design specialty ad-hoc Crystal Reports for team leaders, Managers, and Corporate Executives The development of a total of 6 reports using Web Intelligence, according to functional specification and write the technical specification for each development.
• Provide complex reports solutions in Web Intelligence using advanced functionality like report level prompts, scope of analysis and ranking data source from DB2.
• Architect and developed a Campaign Marketing Dashboard that measures leads and contacts for different marketing channels. Implemented end to end solution, starting from the Universe, to the Web Intelligence dataset layer, to the Dashboard Designer and Design Studio.
• Follow the company procedures to migrate from the development environment to QA (quality assurance) all the universes and reports until the production server.
• Provide training to the final users about the correct use of the new business Intelligence elements.

Confidential, Houston, TX

Lead SAP HANA/BW/BOBJ Consultant

Responsibilities:

• Responsible for re-designing and reorg enterprise supply chain reports.
• Requirement gathering with the business community and all the SCM business analyst.
• Designing and developing the Technical specification document based on the functional specification document.
• Deployment of SAP HANA live report.
• Responsible for blueprinting, requirement gathering, design, strategy and eventually the build of SAP HANA.
• Responsible for blueprinting, requirement gathering, design, strategy and eventually the build of SAP HANA.
• Created functional and technical specifications for Data models based on BW on HANA.
• Designed and created Master data HANA Attribute views.
• Designed and created Analytical and Calculated Views as per the reporting needs.
• Worked on master and hierarchy data setup and dimensional modelling of materials, batches, classification, customers, markets, product brand, product size, and package.
• Worked on design and development of planning / input forms and reports using SAP BW, SAP BPC EPM Excel Add-in and SAP ECC data source enhancements, BW - BPC data integration, delta data loads, process chain automation.
• Developed Data manager packages, Script Logic, transformations, flat file data (CSV) uploads, Developed Cost Center accounting, Internal Orders, R&D Budgeting, Average Sale Price modelling, Rate and Activity Cost planning, Exchange Rates, Project Systems data models

Environment: SAP BI 7.31/7.4, SAP S4 HANA, HANA 1.0 SP9/SP10, Simple Finance 2.0, HANA Live, ECC 6.0, PS, PM, QM, FI, HR, BPC, WEBI and Design Studio.

Confidential, Brooklyn, NY

Sr. BOBJ Consultant

Responsibilities:

• Created high performance KPI dashboards and WebI reports for various modules like SD, MM, PP, POS, FI and Controlling (including COPA) with user interactivity.
• Designed the front end for the dashboard and detailed report, formed templates for the team to continue with the developments.
• Partnered with SAP, Basis team, Super users, Power users and BW technical teams to explore the housekeeping options, activities and guidelines recommended by SAP for improving the performance of data loads, queries, and reports including Portal. Implemented best practices and applied several OSS Notes.
• Shortened data loads, query/report runtimes and month-end closing timelines.
• Better service levels to the report consumers ensuring better user experience.
• Closely worked with BO and BODS team to meet Customer specification. Designed and developed Xcelsius Dashboard using various components. Used Insertion type, Dynamic visibility and alert techniques in dashboard to provide effective visualization.
• Designed and developed WebI reports using charts, tables, cells, document linking, filter, ranking, input controls, and conditional formatting using universes and BICS connections.
• Involved in developing universes using IDT (Information Design Tool) for relational databases.
• Created Connections, Data foundation layer and Business Layer, defined classes and objects in Information Design Tool (IDT) and published it to repository.