SUMMARY

• Experienced in Development and support of Software Applications in the areas of SAP HANA/BPC/BW & TABLEAU.
• Experience on implementing projects using ASAP and WATERFALL methodologies of Project Preparation & Blue Print Design.
• Worked on HANA SLT, BODS and DXC methods and replicated data to BW using Composite providers & Transient providers.
• Had worked closely on Data migration optimization activities as part of migrating BW 7.3 on DB6 to BW 7.4 on HANA.
• Have excellent insights to functional and technical aspect of SAP (BPC) 10.0.
• Expertise in running Consolidation and plan & Forecast, ownership, IC eliminations and handling large volumes of data from BW to BPC.
• Expertise in all phases of BW/BPC Implementation - Data Analysis, Data Modeling, Data Extraction/Uploading and Reporting.
• OLTP Extraction from SAP R/3 into BW using different extraction structures such as LO, CO-PA, and Generic Extractors along with flatfileextractions of Data from application server and carried out transports to Quality and production environments.
• Expertise in Unit testing, Integration testing and user Acceptance testing.
• Expert in Unit, System and User Acceptance Testing and Performed Data Validation for all the reports and dashboards generated from various database sources.
• Working experience in extracting data from SAP & non-SAP systems. Sophisticated skills to work on Flat File Extraction, FI Data Sources, BI Content Data Sources.
• Involved in the production support, Scheduling Process Chains, fixing errors and daily ETL Data load (Full/Deltaup-load) Monitoring of the BWProcess chains for Daily, Weekly, Monthly data loads.
• Experience in Performance Tuning including Aggregates, Partitioning, and Indexing.
• Providing Lower environment and production support on technical issue. Had resolved issues by working on incident tickets and proactively monitored to make sure the SLA’s have been met.
• Worked on designing and development of Tableau visualization solutions.
• Extensive experience inTableau Desktop, Tableau Server, Tableau Public, Tableau Online, Tableau reader in various versions of Tableau (8.x).
• Developing JIL code for Autosys to automate the BW process chains on Autosys Development environment.
• Performing the tasks on the Batch jobs like FORCE START, ON ICE, ON HOLD, OFF HOLD, OFF ICE, CHANGE STATUS, KILL, TERMINATE.
• Conduct peer reviews of custom enhancements to ensure compliance with all appropriate quality standards.
• Worked on AGILE/SCRUM, facilitated sprint planning, backlog grooming, daily stand-up meetings, reviews, retrospectives, release planning, demos and other Scrum-related meetings.
• Knowledge on BIG DATA Analytics, Hadoop frameworks (Sqoop, Hive, Pig, Hbase & Impala) and Predictive Analytics.
• Flexible, enthusiastic, project oriented team player with excellent communication skills and leadership abilities to develop creative solution.
• HANA Modeling: Attribute Views, Analytic Views, Calculation Views,
• Constant filters and Variables, Graphical and Dynamic views.
• DXC Configuration for Data Replication using existing Extractors in ECC.
• SPS09 support multiple HANA DB’s on single HANA systems.
• SPS10 will allow 1 to n Asynchronous table replications
• SLT Configuration for ECC table replication into HANA, BODS, DXC and NLS services.
• Replicating data from HANA Views to Composite Providers, Open ODS Views for BEX reporting.
• Experienced in SAP BPC 10.0 Net Weaver in planning and consolidation.
• Experience in creating the Environments, Application sets, Models, Dimensions,
• Building the respective dimension and setting up the dimension member.
• Created and Maintained Transformation Files and Conversion files, Answer prompts used UJD TEST PACKAGE to automate data loads.
• Worked with Data manager packages and create Business Process Flows.
• Worked on process chain maintenance, Answer prompts.
• Experience in the areas of Modeling and extraction.
• Reporting based on BW Info-providers using tools like BEX analyzer, Query Designer.
• Scheduling BW/BPC Pc’s through Autosys.
• Preparation of high level ART’s based on the Business requirement.
• Involved in development, review & Testing of Autosys JILs using IXP.
• Expertise in UNIX commands and Shell Scripting in PUTTY.
• Worked on puling Flat files from Legacy Database into SAP Application server through Autosys.
• Creating calendar scenarios, syndication of files from SAP to multiple systems.
• Developed reports, Dashboards using TABLEAU 8.3 for quick reviews to be presented to Business and IT users.
• Prototyped data visualizations using Charts, drill-down, parameterized controls to highlight the value of analytics in Executive decision support control.
• Creation of Dimensions, Measures, filters, reports, and dashboards created advanced chart types, visualizations and complex calculations to manipulate the data.
• Developed visualizations and dashboards using Desktop.
• Developed workbooks from multiple data sources using Data Blending.

TECHNICAL SKILLS

SAP: SAP BW 7.0, 7.3, 7.4, Native HANA, BW On HANA (SP09, SP10) SAP BPC 10.0

Reporting Tool: BEX, BOBJ, TABLEAU

Data Base: SAP HANA, Oracle, MY SQL.

Ticketing Tools: HP Quality Center, Remedy, HP Service Manager

Automation Tools: AUTOSYS, IXP, PUTTY

Methodologies: ASAP, Agile, Waterfall and SDLC

Microsoft Packages: MS Office, MS Access, MS VISIO.

Languages: SAP BI ABAP, SQL Scripting for HANA.

PROFESSIONAL EXPERIENCE

Confidential

SAP BW/HANA

Responsibilities:

• Worked closely with the Business Relationship Management, Architecture, Development and Support teams
• Involved in delivering the projects from ideation to implementation and support.
• Develop functional / technical specifications and other documentation, as needed for audit purposes.
• Worked with business closely in designing and reviewing the T-specs to ensure the development is as per the expectation. involved in Technical and Functional Unit Testing.
• Worked on SuccessFactors API’s as the source feed for data into BW by creating a BODS connection to transform live feeds and data into BW further created HANA modelling and projected HANA optimized composite providers for external reporting using BEX and WEBI.
• Extensively worked in BW Info cube, DSO, Multi-providers, Info sources, Info objects, Transformations, DTP’s Extractors, info sources, Info packages, Data sources andPC’s.
• BW configuration, ETL background and Info Cubes design, strong on End-to-End BW Configurations
• Worked on BW/HANA modelling techniques by creating HANA models and Attribute, Analytical and Calculation views.
• Used inner, outer joins and union Process, Projection, Aggregation, Join and followed the best practices to implement the Calculation Views.
• Provide knowledge transfer / support / assistance to the Applications development and Support team.
• Engaged end users in UAT sessions and conducted MOC cutover.
• Actively involved and participated in the planning and execution of a detailed cutover plan by executing the work breakdown structure to ensure a smooth and successful Go-live.

Confidential, GL

Harmonization

Responsibilities:

• Used SLT mechanism to replicate ECC tables for reporting on ledger group and mapping tables in to HANA
• Worked on HANA Modeling, Attribute Views, Analytic Views, and Calculation Views.
• Used inner, outer joins and union Process, Projection, Aggregation, Join and followed the best practices to implement the Calculation Views.
• Worked on bringing in data from HANA views into SAP BW using ODS, Composite providers, Virtual providers, and Transient providers for reporting purpose.
• Worked on SAP-HANA Data provisioning using SLT, DXC, and Flat File Up loader, SAPHANA Architecture.
• Replicated the AMDP methodology in the extractors to build joins and calculation logic by automating the Data load process.
• Made sure the reports performance was as expected also checked the possibilities to enhance the process if they were not meeting the SLA’s.
• Provide knowledge transfer / support / assistance to the applications sustain and support team.
• Develop functional / technical specifications and other documentation, as needed for audit purposes.
• Actively involved and participated in the planning and execution of a detailed cutover plan for a smooth and successful Go-live

Confidential, VA

Functional Analyst

Responsibilities:

• Was closely involved in the initial Blue Printing phase and engaged in workshops with the business to understand the ’AS- IS’ and ‘TO- BE’ requirements and developed the GAP analysis.
• Designed and developed Process Design Documents (PDD) in the areas of IM, PTP, P2P, TM and OTC.
• Played a key role in the Design, Customization, Development and testing.
• Involved and helped with the mapping exercise with BW, BI Content and HANA optimized Data elements toAnalyze the KPIs in order to recommend new solutions.
• Worked closely with developers on Sales Order and KPIs in order to recommend new solutions.
• Was deeply involved in designing various intercompany billing scenarios to meet both Plants.
• Optimization by defining Business rules and other specifications to meet business requirements.
• Was closely involved in Data Conversion efforts specific to OTC and IM Data from ECC.
• loads during cutovers and Go-Live periods for a successful and smooth GO-Live
• Work closely with the Business Relationship Management, Architecture, and Sustaining and Support teams
• Delivering projects from ideation to implementation and support.
• Provide knowledge transfer / support / assistance to the Applications Sustain and Support team.
• Develop functional / technical specifications and other documentation, as needed for audit purposes.
• Design reporting / dashboard solutions in the SAP BW space.

Confidential

HANA Developer

Responsibilities:

• Involved in the design, configuration and documentation of various business processes between BW and HANA.
• Worked in relevant DMO activities for migrating BW7.3 on DB6 to BW 7.4 on HANA.
• Initiate/Monitor upload processes, Perform technical validation of uploaded data as part of migration project.
• Well verse with SAP HANA Administration, Hana perspectives and Modeling using Different types of views, SQL.
• Used SLT replication, which allows running multiple HANA DB’s on a single HANA system.
• Worked on HANA Modeling: Attribute Views, Analytic Views, and Calculation Views.
• Worked on Procedures, SQL Scripts.
• Used BEx Queries as source in HANA by creating snapshots in T-code RSDDB.
• Derived BPC Audit Data by using the BPC tables to perform HANA modeling using them.
• Used Projection, Aggregation, Join and Union Process and followed the best practices to implement the Calculation Views.
• Worked on bringing in data from HANA views into SAP BW using ODS, Composite providers, Virtual providers, Transient providers for reporting purpose.
• Worked on SAP-HANA Data provisioning using SLT, DXC, and Flat File Up loader, SAPHANA Architecture.
• Developed and tested different migration tools to help in having a smooth and efficient Data migration process.
• Actively involved and participated in the planning and execution of a detailed cutover plan for a smooth and successful Go-live.

Confidential

BPC Developer

Responsibilities:

• Worked on creating Models, Dimensions and Properties dimensions.
• Loaded Master data from BW info objects to BPC dimensions.
• Worked on Data Manager Package to load Master data and Transaction data from BW to BPC. Transformation Files, Conversion Files, BADI’s.
• Created complex logic transformation files and conversation files to handle the data manipulation while loading data into BPC Model.
• Used UJD TEST PACKAGE to automate data loads.
• Worked on inter-company elimination and currency conversion.
• Developed Delta INITS to load deltas from BW multi-providers.
• Involved in Transporting BPC objects to higher Environments.
• Configure the ownership the application for the consolidation of investment
• Maintain the business rules for Currency translation, intercompany elimination, ownership calculation
• Copy packages to copy the forecast, plan, budget data.
• Configure data manager extraction from ECC and BI system for the actual, plan data.
• Have knowledge in EPM reporting and Input Templates.
• Actively involved and participated in the planning and execution of a detailed cutover plan or a smooth and successful Go-live.
• Balance sheet and external audit purpose, ME-close, Consolidation book, Legal book close & Management close.
• Actively involved and participated in the planning and execution of a detailed cutover plan for a smooth and successful Go-live.

Confidential

BW Analyst

Responsibilities:

• Extensively worked in BW Info cube, DSO, Multiproviders, Info sources, Info objects, Transformations, DTP’s Extractors, info sources, Info packages, Data sources andPC’s.
• Development reviews, FS, TS, TUT reviews.
• BW configuration, ETL background and Info Cubes design, strong on End-to-End BW Configurations.
• Handled Operational and Analytical BW systems simultaneously.
• Automated the process of rolling forward the SPO’s as part of WRF and MRF activities.
• Successfully completed Unit testing, Integration testing and user Acceptance testing for the development before moving it to higher environments.
• Preparation and reviews of technical specifications, Unit testing documents.
• Worked on pulling Flat Files from Legacy Database into SAP Application Server through CA Autosys.
• Preparation and reviews of technical specifications, Unit testing documents.
• Solving Production issues of BW/BPC Developments.
• Co-ordinate with teams during customer acceptance testing and Automation of BW data flowsUsing Autosys tool.
• Solving Production issues of BW/BPC Developments.
• Resolve and fulfill SAP BI Incidents and service requests raised by users according to SLA.
• Supported the day-to-day data load monitoring, fixed data and checked the performance issues.
• Analyze, design and conceptualize data model, develop, and implement and maintain technical solutions to meet business requirements in SAP BI system.
• Participated in Bridge calls to check and resolve the Issues by coordinating with various team.
• Closely involved with business to create test cases and test scripts to conduct integration, volume and performance testing on some of the complex business functionalities.
• Gained extensive knowledge and experience in the process of system Validation protocols.

Confidential

Autosys Developer

Responsibilities:

• Developing and Testing the Batch jobs on Autosys in DEV and TEST Servers according to the requirement, using JIL (JOB INFORMATION LANGUAGE).
• Maintaining the job-scheduling database for the automated scheduling system to schedule the execution of application and support batch jobs.
• Performing additions, changes, or deletions to the scheduled batch workload as authorized by the application developers or technical support teams.
• Adding, Changing and deleting the Batch jobs on the servers on basis of change Ticket. Changing the Job information language (JIL) for the Batch jobs.
• Creating application code for the application team to get Job failure notification.
• Worked on the tasks on the Batch jobs like FORCE START, ON ICE, ON HOLD, OFF HOLD, OFF ICE, CHANGE STATUS, KILL, TERMINATE.
• Testing the Batch jobs on the TEST IXP server and submitting to the Peer reviews.
• Creating the Visio diagrams to depict the total development of Automation code.
• Finding the root cause of the issues in concern and following the documented procedure to resolve the issues by contacting the right group of people

Confidential

Tableau Developer

Responsibilities:

• Analyzed business requirements, functional specifications of the project.
• Interacted with business users to know what is expected requirements and developed the Tech specs.
• Developed reports, Dashboards using & Tableau (8x) for quick reviews to be presented to business and IT users.
• Prototyped data visualizations using Charts, drill-down, parameterized controls to highlight the value of analytics in Executive decision support control.
• Created reports to users in Tableau by connecting to excel sheet and CSV files.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets using Tableau (Desktop).
• Generated context filters and used performance actions while handling huge volume of data.
• Creation of Dimensions, Measures, filters, reports, and dashboards created advanced chart types, visualizations and complex calculations to manipulate the data.
• Developed visualizations and dashboards using the TABLEAU Desktop and uploaded to Tableau server for the end users.

Confidential

Business Analyst

Responsibilities:

• Analyzed customer business requirements, functional specifications of the projects in designing the web store.
• Built an operations cycle to enhance customer experience & increase revenue and ROI to the client.
• Interacted with client contacts and responded promptly to queries and requests and assisted the engagement team in identifying and solving the client issues.
• Prepared well-defined business Requirement documents (BRD) and statement of Work (SOW) based on clients view to meet his expectations.
• Supported research on new ideas and participated in developing new concepts and framework driving business development initiatives.
• Analyzed and managed seller database, provided data to support internal and external marketing.
• Participated in recruiting and training efforts supporting the recruiting team and talent management initiatives.
• Interacted with client contacts and responded promptly to queries, requests and assisted the engagement team in identifying and solving the client issues.
• Defining the plan and defining the project scope according to approved features list.
• Performing Man-hour estimation and making the proposals.
• Analyzed and managed seller database, provided data to support internal and external marketing.
• Built an operations cycle to enhance customer experience & increase revenue and ROI to the client.
• Conducted regular meetings and conferences with the trading assistants in all the major cities in Australia.