PROFESSIONAL SUMMARY:

• Certified as SAP Business Warehouse (BW 7.0) Consultant with around 10 Years of professional experience.
• Certified as SAP ABAP Development consultant.
• Have around 10 years of experience as a HANA /BW versions 7.3,7.0 /BO/ and ABAP Consultant. Have worked on BW with ABAP, BW powered by HANA Implementations.Have Worked in End to End implementation, ongoing production support and enhancement activities in the application areas SCM, SRM, FI,SD,MM, HR, ISU, Billing and CRM.
• Supported sales enablement in the Analytics space with hands on Data modelling using HANA, BW and reporting on BOBJ tools, Lumira, Fiori.
• Have worked for clients from various industries including Banking, Energy and resources, Consumer, Health Care, Public Sector etc.
• Experience in interacting with clients to gather requirements and translate into report wireframe development and delivery including activities like creation of Functional specification, Design documentation,Technical specification, Test cases, Cut over activies, KT to the end clients .
• Extensive working knowledge for designing and developing of both BW Back - end side and Front-end and HANA back end modelling and reporting on BO, Lumira, SAP Fiori.Views, Analytic Views and Calculation Views (both Graphical & SQLscript based) & HANA Data Provisioning using SAP LT ReplicationServer (SLT).
• Good exposure on Schemas, table definitions, Attributes, Measures &Hierarchies in HANA.
• Good Knowledge in HANA security including User Management, Rolesand Privileges.
• Good Knowledge in Direct Extractor Connections.
• Loading data into table definitions.
• Actively participated in Code reviews and Data governance Meetings.
• Extensively worked in SAP BW Data modeling of Info Cube,MultiProvider, Virtual Provider, DSO, Info Objects,Data Marts, Data source, Transformation & DTP, Process Chains for Data loads, Info sets, Open Hub Destination (OHD), APD.
• Involved in Performance tuning of queries and data models.
• Developed BW IP planning application: Creation of BW back end: DSO, Infocube, Realtime Infocube, Aggregation level, Planning function, filters, planning sequence, BEX input ready queries and creation of planning templates using Design studio.
• Involved in Development of SRM BI reporting for a Cross Industry Asset. Lead the team in end to end implementation of BW with reporting on BEX tools.
• Worked for Sun Chemicals POC and lead the team in building the KPI's using WEBI for the functional areas: Inventory, Transportation, Distribution, Revenue.
• Worked extensively on production support activities like Process chain monitoring, resolving data load failures based on the priority in the ticketing tool, ABAP Debugging solving the report issues by interacting with the client, Performance tuning ( Loading and Query), trouble shooting.
• Have developed Complex reports on BEX.Knowledge on BEX query designer, using variables, Restricted Key figures, Calculated key figures, Structures, Conditions, Exceptions, new selections
• Worked on BEX Broadcaster for distribution of reports to the End users.
• Loaded Master data: Attributes, texts and Hierarchies.
• Strong knowledge in SAP BW Administrator workbench, Custom Generated Extractors: COPA and LO extractors, Fi extractors involving: FI-GL, FI-AR, FI-AP,Modelling, BEX reporting, Production Support environment- Process Chains, Data Loading, Scheduling, Monitoring.
• Extraction of data from Non SAP systems and loading into BW .
• Worked on Generic Extractors using Table/Views, Function modules.
• Extensively worked on routines in ABAP at all levels of development including Extraction, Modelling and reporting. Written CMOD codes for the enhancement of DS and for BEX variables.
• Written ABAP Routines: Start, END, Transformation, Expert. Customer exits in extractors, Function modules.
• Created custom Tables in ECC.
• Created Variables using ABAP User Exits.
• Worked on BO Dashboards, WEBI,Crystal, Lumira and Universe.
• Developed Webi reports, Dashboards using Design studio.
• Created Universe using IDT.
• Experience on creating Universes, WEBI reports on different sources like Universe, Bex reports and giving access to Enterprise portal.
• Good at performance tuning Bex and WEBI reports.
• Experience in creating dash boards using Xcelsius and Dashboard Builder.
• Worked on testing of Bex and BO reports of different functional modules.
• Having ability to communicate effectively at all levels of Application Development phases in the Company.
• An excellent team player as well as an individual contributor with good communication and interpersonal skills.
• Quick learner and stronger desire to master in new Technologies.

TECHNICAL SKILLS:

ERP: SAP BW 7.3/7.0, HANA, 3.5ECC 6, BO 4.0, 4.1, FIORI App

Languages: ABAP/4, Java 2.0

Databases: SQL Server 2000 - project experience

Tools: & Utilities: Reporting tools: BEX, Business Objects, Microsoft Excel,Microsoft office - Project experience, Microsoft Visio 6.0, PowerPoint

Operating Systems: Windows 95, 98, 2000, XP

PROFESSIONAL EXPERIENCE:

Confidential, Phoenix, Arizona

Sr Developer

Responsibilities:

• SAP BI/HANA Lead, involved in
• Development of BI IP reporting, ISU billing ISU (IS Utility) reporting and month end/year end support strategy preparation
• . She was leading the end to end implementation of BW with templatesusing BOBJ .
• Developed reports for mobile app using Fiori.
• Gathered reports needed and made a fit gap analysis.
• Prepare Functional specification Based on the Requirements Gathered from Client.
• Prepare High Level Design Documentation of the BW/ BOBJ design,Involved in preparing the Technical specification document .
• Identified the relevant business content queries, DSO’s, Cubes.
• Installed and activated the relevant Datasources, Replicated, Installed data flows, queries in BW environmentand enhanced them.
• Loaded the relevant data.
• Developed the planning application using Real time cubes, filters, planning functions: standard and formulas, Planning sequences, Input ready queries.
• Designed and developed reports in BW BEX, created Universe and reports in BO.
• Worked on lumira forstoryboards.

Environment: SAP BI 7.3,BOBJ 4.0,4.1, HANA, ECC 6, Lumira

Confidential

Team Lead

Responsibilities:

• SAP BI/HANA Team Lead in analytics space, working in the Accenture’s Enterprise Analytics offering within the Resources industry and supported multiple engagements like Sun Chemicals, SCCC. She has involved inDevelopment of SRM BI reporting for a Cross Industry Asset. She was leading the end to end implementation of BI .
• Gathered the SRM reports needed and made a fit gap analysis.
• Identified the relevant business content queries and their respective data flows
• Installed and activated the relevant data flows, queries in BW environment.
• Loaded the relevant data.
• Worked for Sun Chemicals POC and lead the team in building the KPI's for the functional areas: Inventory, Transportation, Distribution, Revenue.
• Created high level design documentation for the back end HANA data model.
• Loaded data into HANA tables
• Created attribute views, Analytical views and calculation views.
• Being the lead, Gather Requirements from the ClientSCCC, Prepare Functional specification Based on the Requirements Gathered from Client.
• Prepare High Level Design Documentation of the BW design,Involved in preparing the Technical specification document .
• Created WEBI Reports.
• Developed BOBJ Dashboards and Reports using the latest BOBJ tool Design Studio.
• Created story boards using Lumira.
• Created Universe on BEX queries,Infocubes.
• Created crystal reports on SAP ECC tables.

Environment: SAP BI 7.3,SAP BPC,HANA ECC 6, BO 4.0,4.1, Design Studio, FIORI

Confidential, San Diego, CA

Team Member

Responsibilities:

• Gather Requirements from the Client, Prepare Functional specification Based on the Requirements Gathered from Client.
• Prepare High Level Design Documentation of the BW design, Involved in preparing the Technical specification document.
• Created SCM (MM, PP, QM) Multi-providers by using Cubes and Master data Infoobjects, DSO’s
• Created Cubes and DSO’s &InfobjectsEtc
• Enhanced some Master data Datasources
• Developed complex ABAP logic in Routines to load inventories data and derive some KPI’s for Inventory Projection Reports.
• Worked on lookups
• Worked on transports.
• Worked on Process Chains.
• Helped Other Team members in achieving their tasks.
• Developed Custom generated Extractors based on Tables/Views to load the Purchase requisition and Clients Raw material Data into BW
• Created Reports on WEBi using Webi rich client and Dashboards in Design Studio.
• Created Universe on BEX queries
• Developed complex Reports for Inventory Projection, Runout Reports in BEX and webi.
• Created Multiple Queries on FICO and SCM.
• Extensively worked on Query Variables exist, Formula variables, Exceptional Aggregations, Restricted Key figures and Calculated key figures and complex Formulas using If else Conditions based on requirements
• Worked on Ad-hoc Queries.
• Created Function Modules.

Environment: SAP BI 7.3,BO 4.1,SAP APO, FI, SCM, ECC 6, Design Studio 1.1&1.2

Confidential, Dallas, Texas

Team Member

Responsibilities:

• Provide Custom solutions to restrict user’s access by cost center.
• Perform Changes to Existing Report (includes changes to existing user exit)
• Customizing standard BI user exit, so the exit contains a variable which will pass the cost center value that the user is authorized for.
• Prepare Functional specification Based on the Change Requirements Gathered from Client.
• Created custom Table in ECC to Maintain User IDs to Cost Center Mapping
• Create Custom transaction code(s) (T-Code) to Maintain/View Custom Table
• Create a Generic table extractor to load User IDs/Cost center mapping to BW
• Created DSO's, Transformation for loading the Costcenter data.
• Created process chains for regularly loading the User data.
• Monitored the process chain loads.
• Prepare High Level Design Documentation of the BW design.
• Preparing the Technical specification document .
• Developed complex ABAP logic for the Custom User Exit in BW report.
• Production support.
• Daily Status reporting.

Environment: SAP BI 7.0, ECC 6

Confidential

Team Member

Responsibilities:

• Prepared TDS,UT documents.Identified &Installed standard BI content objects in area of SCM, Sales, FI & CRM
• Migrated & enhanced flows to achieve desired results,Developed process chains for automated loads
• Designed and maintained the required Info Objects, Info Sources, Transformations, ABAP Routines, ODS Objects, Info Cubes, Info Packages and Process chains
• Activated standard Logistic datasource content on R/3 for sales order items, header & item statuses, Deliveries, MM (Purchasing) & FICO (GL, AR & AP). worked on enhancing the extract structures based on the Client requirement and populated data to those particular enhanced fields by using User exits.
• Involved in Extraction, Transformation and Loading of Data (ETL) - preparing SAP R/3 for SAP BW and defining the loading strategies, initial and delta data loads; loading data from flat files and SAP ECC, scheduling and monitoring data loads.
• Activated available business content on BW side for SD. Created custom InfoObjects, InfoSources, ODS objects, Infocubes and complex transformations.
• Created Aggregates for the Info Cubes to increase Query performance and taken care of all performance related issues.
• Developed several process chains to automate the data flow and data extracts.
• Responsible for enhancing the performance of system by addressing time consuming loads by fine tuning code or system parameters based on situation.
• Involved in Performance tuning of routines in Transformations for loading (ABAP).
• Rectified the inconsistency data between R/3 and BW done the reconciliation.
• Reviewed system statistics and other measures to identify the need for aggregates, indexes, compression etc.

Environment: SAP BW 7.3, IP, BEX 7, SAP ECC, CRM

Confidential

Team Member

Responsibilities:

• Involved in preparing the Technical specification document basing on the functional specification document
• Responsible for design, development and extraction of data from R/3 Source system and Flat files to the BW system.
• Extraction of various master data datasources.
• Involved in designing data flows from BW objects including extracting, transforming, and loading data into info providers like DSOs, Cubes
• Involved in creation of different InfoCubes, ODSs, Master Data Objects, extracting data from R/3 and scheduling of Data Extracts.
• Have used different extractors for data from R/3 to load detailed data to the ODSs and summarized data to the InfoCubes and applied various transformations using ABAP to make the data in consistent with the other systems.
• Have used various extractors like 0FI GL 4, 0FI GL 14 for General Ledger reports, 0FI Gl 10 for Trial Balance
• Created Process Chains to schedule the data loads in to the data targets including realignment runs, info cube rollups.
• Scheduled and monitored the data loads from OLTP systems and Flat files.
• Created Info Spokes/Open Hub interface to transfer data from BI to Flat Files to load to an external system.
• Mainly involved in Conversion and Reconciliation of data in General Ledger.
• Developed and Tested the Objects in BW using some test data and transported them into the Quality keeping in view the dependency of objects.

Environment: SAP BI 7.3, ECC 6

Confidential

Developer

Responsibilities:

• Create test data for BI and Basis and execute them.
• Workon HPQC for test script upload, defect creation and reports. Escalation of issues as need be.
• Daily status reporting
• Perform Integration and Functional Unit Test.

Environment: SAP BI 7/BW 3.5, ECC 6