PROFESSIONAL SUMMARY:

• Over 12 years of IT experience in Analysis, Design and Development of SAP applications of which above 10 years in SAP BW/BI and SAP HANA.
• Experience in information and data architecture, system upgrades, requirement analysis, solution design, enhancements, implementation and support.
• Excellent Team Player and Team handling Capabilities.
• Good interpersonal relations, strong communication skills, hardworking and high level of motivation.

BW Expertise:

• Experience as Functional and Technical Consultant in implementing SAP ECC, BI/BW, SD, MM, PS, HR,PC (Product Costing), WM, EWM, TM and FI - CO (GL, AR, AP and Assets) modules.
• Involved in more than 8 full life cycle implementations (including SAP BI 7.5 edition for HANA) from blue-print to Go-Live stages.
• Extensive experience with Requirement Gathering (from process design owners, Business Groups, Power Users and End users), Business Blueprint (Identifying Reports, Gap Analysis, Enhancements), Realization (Design & Development of BI objects) and Post Production Support.
• Good experience as On-Site coordinator, to synchronize project tasks with offshore team members.
• Expert in building SAP-BW/BI Components like ADSO,Open ODS, Composite provider, DSO Objects, Data Marts, MultiProviders, InfoSources, InfoObjects, ODS Objects, InfoSpokes, Update Rules, Transfer Rules and Start Routines.
• Expertise in OLTP extractions from SAP ECC using LO Cockpit, Generic Extractions and non-SAP extraction.
• Enhancement of DataSources using User Exits as per the business requirements.
• Extensively worked on Start Routines, End Routines and Expert Routines at different levels of Transformations to implement business logic.
• Hands on experience in designing and maintenance of InfoProviders and MultiProviders and familiar with creating and customizing of InfoSources, TransferStructures, Update Rules and StartRoutines.
• Hands on experience in performance tuning measures creating Aggregates using BI Statistics Cubes, Query Monitor (RSRT), Workload Monitor (ST03) and BW Accelerator (BWA).
• Worked extensively in BEx Query Designer, BEx Analyzer, Report Designer, Crystal Reports and Web Application Designer. Created custom queries using Conditions, Exceptions, Variables, Structures, Restricted and Calculated Key Figures and created aggregates for frequently used queries.
• Good Knowledge in improving the performance of Applications.
• Excellent communication, interpersonal, managerial skills and positive work attitude and self-motivated to work independently and as well as in a team.

BOBJ/BI BO Expertise:

• Extensive experience in Business Objects Client tools like IDT, Universe Designer, Crystal reports, WEBI BO Explorer, and Analysis for Office.
• Experience in development of SAP Universes in Designer against SAP BI Cubes and BEx Queries.
• Good Working Knowledge on Business Objects (BOBJ) - SAP BI Integration.
• Created formatted reports using Crystal reports.
• Developed Dashboards using Xcelsius and Design Studio.

HANA Expertise:

• Worked on SAP HANA implementation projects with both Native HANA and SAP BW on HANA Landscapes based on HANA ASAP Methodology.
• Good understanding of administration perspective, expert in creation of analytical, attribute views and complex models in calculation views.
• Expert in creating analytical privileges, and have a very good understanding of various components of SAP HANA.
• Excellent knowledge on: HANA Optimized Info Cubes, HANA Optimized DSO’s, Transient, Composite, Hybrid Providers, Publishing HANA Model in SAP BW, Import SAP Net Weaver BW Model to HANA .
• Experience in Data-Provisioning techniques using SAP BO data service and SLT (SAP Landscape Transformation) to perform real-time data replication into SAP HANA.
• Experience with SAP HANA data modeling using Attribute View, Analytical View, Calculation view, Stored Procedures, Table Functions, Decision tables & Analytical Privileges.
• Worked on SAP HANA administration including managing schemas, data model objects, import/export content, HANA Transport for ABAP (HTA).
• Worked on Simple Finance 2.0 Add-on delivered HANA Live Views and ECC delivered HANA Live Views.

WORK EXPERIENCE:

Confidential, Naples, Fl

SAP BW/HANA/Datalake Solution Architect

Responsibilities:

• Re-org and redesign the global datawarehouse solution for the company.
• Delivered enterprise global reporting KPI template for Supply chain, Financial Sup lly chain, Finance, Manufacturing and Warehouse management business users
• Build a scalable LSA++ architecture for the BW datawarehouse
• Responsible for migrating a stabilize BW datawarehouse to SAP HANA and subsequent planned migration to SAP BW 7.5 Edition for HANA.
• Planned Hadoop datalake connection to SAP BW on HANA.
• Redeveloped BW security and transports strategy for all users
• Co-ordinate project deliverable and schedules
• Co-ordinate onshore-offshore resouse allocation and deliverables

Confidential, Houston, TX

SAP BW/HANA Solution Architect

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.
• 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.
• 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.
• Extracted data from legacy system to HANA database using Data services.
• Created analytic indexes and composite provider based on HANA View and BW Infoproviders as per the reporting needs.
• Worked on redeveloping of Bex web templates to Design studio with a different User Interface using different customized cascaded style sheets.
• Created a Complex dashboards for Supply chain, sales, production planning, HR Head Count and FI.
• Developed flexible queries with variables using filters, Navigational attributes, Restricted Key figures, Calculated Key figures, Reusable structures and Currency translation factors in bex.
• Worked on post go live production support in monitoring data loads, fixing and improving performance of load issues and investigating in finding root cause for data issues and worked extensively on support tickets.

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, Shelton, CT

Sr SAP BW/BOBJ Consultant

Responsibilities:

• Expert in requirement gathering, documenting the requirements, designing and then implementing the solution for different complex Requirement.
• Involved in the overall design and implementation of SAP Business Intelligence solution which includes analysis, design, development, performed reviews, support and tuning of large, complex integrated reporting systems.
• Applied deep understanding of SAP BW to design solutions, troubleshoot issues both on the SAP BW and Business Objects side to maintain satisfactory report generation performance.
• Expert in evaluating and recommending best approaches and tools to support business and technical requirements.
• Worked extensively on standard and custom defined LO extractors. Used LO structures for extracting IR Data and also Generic for some complex requirements.
• Worked extensively on Inventory extractors and Non-cumulative and Snap shot model.
• Worked on standard production costing extractor to get different kind of costs from SAP ECC (local cost, supply chain cost and con cost).
• Worked HANA POC for finance team to leverage the existing information.
• Involved in migration of traditional data base to HANA Database.
• Worked on GL line item extractor to sync with inventory balances.
• Written Customer Exit Variables for calculating values with the help of the user entry variables.
• Expertise in using Analysis Process Designer to provide solution for complex business requirements.
• Involved in production activities like data load monitoring, fixing load failures, improving load performance, PSA clean up, table space tracking etc.
• Worked on improving load and reporting performance using APD (load) and BI accelerator.
• Extensively worked in ABAP to build report on system tables, function modules for generic extractors.
• Extensively used Information Broad casting to broad cast month end reports to different user groups.
• Reviewed and resolved both Front end and Back end performance issues.
• Created Information Broadcasting settings on queries to broad cast to mail box.
• Developed various RRI / Jump Targets using RSBBS and use customer exits for unique requirements.
• Resolved Query Performance issues using transactions such as RSRT and RSRTRACE.
• Created webi reports for product costing and published into portals.

Environment: SAP BI 7.0 Ehp1, ECC 6.0, MM (Purchasing and IR), PC, FI and WEBI 4.0

Confidential, Houston, Texas

Sr. SAP BI CONSULTANT

Responsibilities:

• Involved in Full cycle Implementation of Integrating the functional areas MM, SD and FI/CO with BI. Responsible for Design of data models, comparing the model with delivered contents and implementing the business logic with delivered contents along with modifications.
• Good functional knowledge of Sales & Distribution (Sales Orders, Deliveries & Billing), MM (Purchasing), FI and general business process of SAP R/3.
• Activated Sales and Distribution, Purchase Info cubes and DSO objects from the Business content and customized according to business needs.
• Performed statistical setup for purchase, Sales, Billing and Shipment and extracted the data to BI.
• Customized Lo Cockpit data source to include custom defined fields and populated those fields using customer exits before the setup.
• Worked on CRM-Sales, Marketing Analysis, Account Plan, Lead Management, Opportunity Management, Activity Management and Interaction Center verticals.
• Created complete data flow from CRM which includes extractors, Infoproviders, Transformations, DTP’s and Process Chains.
• Worked on Extractors 0CRM SALES ACT 1, 0CRM LEAD H, 0CRM LEAD I, 0CRM OPPT H, 0CRM OPPT I, 0CRM ACCPLN ATTR, 0CRM SALES ORDER I.
• Worked with the datasource 0BPARTNER HIER to load Account Hierarchy data into 0BPARTNER and involved in extracting the Marketing attributes data using the datasource 0CRM MKTATTR ATTR.
• Enhanced the extractor 0CRM SALES ACT 1 to pull the ‘Activity Completion Date’ and ‘Account Plan ID’.
• Used LO extract structures for extracting sales order, delivery-billing information.
• Extended standard Business Contents based on client requirements using User Exit and Function Module.
• Created and scheduled InfoPackages for Full, Delta Initialization, and Delta updates to load both master and transaction data. Created process chains to automate the data load and data target administration.
• Involved in creating reports like Open Opportunities, Opportunities Pipeline Health, Top Opportunities, Account Plan Objectives report along with its follow-up activities data.
• Created WAD Templates each one for Single Query Multiple tabs, Multiple Queries Single Tab and created all CRM WAD reports by embedding these 2 WAD templates.
• Created Account Fact Sheet WAD Dashboard report which includes 11 Queries. This report shows Sales History, Margin History, Credit Status, Orders, Activities, Leads, Account Plan Objectives, and Contacts, Open Opportunities data for an Account or Account group.
• Handled postproduction support and development of new design cycles simultaneously.
• Created several Calculated Key figures, Restricted Key Figures, structures and variables to enhance the reporting features. Implemented conditions and restrictions in the reports based on the requirements.
• Worked with RRI (Report to Report interface) between DSO object and info cube.
• Extensively involved in transporting objects from Development to Quality and then moved to Production.

Environment: SAP BI 7.0, SAP ECC, CRM, SD, MM and FI modules, Windows 2000/NT.

Confidential

SAP BW CONSULTANT

Responsibilities:

• Responsible for developing BW data models and designs, configuring custom and delivered content BW objects, analyzing BW reporting requirements, developing detailed reporting specifications.
• Thorough understanding of the Functional specifications and outstanding issues related to specifications.
• Frequent meeting with the functional team to resolve the outstanding issues and regular updating of functional specifications.
• Responsible for developing High level Data flow and revising the Gap Analysis.
• Worked on extractions from heterogeneous Source System including SAP and non-SAP, Developing SAP BW Objects, applying Extended Star Schema modeling principles in Data Design, and used expert knowledge of data warehousing concepts.
• Developed basic cubes for Premium’s, Claim’s, and Sales data.
• Built various Multi providers on Premium, claim, Sales, Profitability Cubes.
• Extensively involved in setting up of procedures for extracting data from SAP R/3 by using generic extraction.
• Developed infosources and Written several routines in Update and transfer rules.
• Developed Infospokes on Premium and Claims Cubes to extract the data so as to correct the data in production system.
• Created extractors to extract CO-PA data for the relevant Operating Concerns from SAP-R/3 into SAP BW and created corresponding InfoSources, ODS Objects and InfoCubes in BW.
• Extensive knowledge in FICO- Finance & Controlling (General Ledger, AR and AP).
• Designed and developed ProcessChains (RSPC) for master data loads and transactional data loads with the help of info packages. And these process chains are scheduled for periodically.
• Extensively worked on setting up authorization objects, roles, transporting them, and involved in testing reports based on various roles.

BW Support:

• Responsible and managed maintenance and support activities within the SAP BW system.
• Responsible for manage enhancement requests and closely with onshore/offshore vendor to distribute and manage workload.
• Daily coordinate with the offshore team to assign the tasks.
• Daily involved in production data loading and monitoring.
• 24/7 production call support.
• Created a ProcessChain, which deletes the PSA Data based on the Retention Periods.
• Used both initializations with delta update and Full update methods depending on the business requirement.
• Managed and monitored several data loads, captured the errors and corrected the bugs and applied several OSS notes for the errors encountered while loading the data.
• Checking the system performance and database size through DB02 and cleansing the PSA Data Accordingly.
• Resolving the issues that occur during the Loads based on Severity Level.

BW Reporting:

• Developed queries on Different InfoCubes Using BEx Analyzer.
• Created several Calculated Key figures, Restricted Key Figures, structures, variables to enhance the reporting features. Implemented conditions and restrictions in the reports based on the requirements. Used Hierarchies in the reporting to provide drill down features. Designed and developed reports with filters and free characteristics. Designed and provided RRI reporting.
• Extensively worked on Crystal Reports designer to develop formatted reports and web reports.
• Involved in developing front-end queries using Query Designer and Web Application Designer and publishing results on the web.
• Involved in transporting the BW objects from development system to QA for unit testing and integration testing.
• Transport the objects from Development to QA for testing.

Environment: SAP BW3.5, SAP R/3 4.6C/4.7, ABAP/4, FI/CO modules, Windows 2000/NT.