SUMMARY:

• 12 years of experience as a SAP BI/BW on HANA Architect/Consultant with overall 12 years of experience which includes varied experience of working in domains of Manufacturing, Chemical Industry & Pharma.
• Currently holding H1B visa and working based out of Seattle, WA.
• Extensively worked in projects involving Implementation, Migration, Up - gradation, Application support and maintenance for Confidential, ArcelorMittal, Confidential and Novartis.
• Expert in transforming business decisions into functional requirements and thereby converting those into technical specifications to formulate an appropriate multi-dimensional design/planning model after assessing against the usage of standard SAP delivered Business Content.
• Administered BO servers for BO 4.1 SP5 platform and ensured high availability of the platform for reporting needs.
• Developed Views in HANA Studio for external Reporting in Tableau Desktop.
• User Management in BO Platform based on the roles mapped according to SOX compliance.
• Developed Crystal Reports (designer based and free hand SQL based) and published in the BO Launch Pad for mass distribution.
• Developed SAP HANA views - a new functionality provided by SAP for consuming BW Backend Objects as views from HANA database directly without addressing BW Backend.
• Expertise in SAP BW Architecture including Extractors, Data Sources, Info Objects, Info sources, ODS Objects, Info Cubes, Info Packages, and Hierarchies.
• Converted BW key figure model to account based model in BW for enabling BPC reporting
• Expertise in SAP BW7.X and BW on HANA configuration and Query development.
• Proficient with planning, Gap analysis, design implementation, trouble shooting, performance tuning, production support and user training of SAP Business Information Warehouse.
• Expertise of various data design models - Multi Dimensional data modeling/Star Schema and Extended Star Schema models.
• Proficient in Performance tuning using Aggregates/BIA, Rollup, Partition, Compression and BW Statistics.
• Written complex Update routines, Transfer routines, Transformations (start and end routines).
• Proficient in Debugging ABAP in any event of data mismatch/short dumps
• Developed F4 BADIs for BEx Prompts so that the end user only looks at the list of values which are appropriate for reporting.
• Worked with Master and Transaction Data User Exits on R/3 and Variable exits.
• Knowledge in the areas of SLT (HANA), ABAP Data flows (BODS) for Data extraction from SAP systems.
• Knowledge in Using Idocs for loading data into SAP ECC and LSMW for batch recording the data into ECC.
• Knowledge in data warehousing techniques for data cleansing, Slowly Changing Dimensions (SCD) phenomenon, surrogate key assignment and Change Data Capture (CDC).
• Proficient in Data staging using ODS before transferring data to required data targets.
• Experience in creating Views, Generic Data sources in SAP R/3.
• Extensively involved in the data extraction of CO-PA, LO, Generic (View, FM, Info set Query) and non-SAP data into SAP BW server.
• Worked on Front End, BEx (Business Explorer) Analyzer, BEx Broad Casting, BEx Query Designer Queries, and Workbooks.
• Experience in SAP R/3 modules: Sales & Distribution (SD), Materials Management (MM), Inventory Management (IM) and Finance and Controlling (FI/CO), COPA
• Experience in Data-Modeling, Delta Extraction, Generic Delta Extraction, Data Loading Scheduling.
• Designed documentation standards for Technical and Functional Specs and test plans for UAT, Integration testing.
• Used Service- Now, Remedy, Solution Manager and Charm for Change management.
• Mentored team members on the new BI skills and coding scenarios.
• Involved in end-user training and documentation.

TECHNICAL SKILLS:

DW Tools: SAP BW 7.5/7.4 on HANA

Database: HANA, Oracle, SQL Server, Teradata

ETL Tools: BODS

Programming Languages: ABAP,SQL

Front end tools: BEx, BO Webi, Crystal Reports, Tableau, Analysis for Office

Semantic Layer: Universe (UDT & IDT)

Publishing tools: Using CMC to publish tools on BO Launchpad, 360Cast

PROFESSIONAL EXPERIENCE:

Confidential, Seattle, WA.

SAP Business Objects Administrator

• Providing access to users based on the requests via ticketing tools(Service Now)
• All BO users logins and Security checks (Who is accessing what) verification
• Providing SOX Compliance reports on BI platform based on the requests from SOX team
• Monitoring all services running on the all the App servers and Web servers
• Providing business communication on downtime or delays in data availability
• Testing the availability of all Universe connections to respective Databases
• Making the BO Platform highly available for end Users
• Monitoring day to day scheduled jobs in CMC Instance manager
• Attending regular IT Calls for Business Objects developments and Releases
• Supporting the development teams with Deployments of the Projects and Releases
• Troubleshooting if any issues with Reports (Technical support to Users)
• Performed Bug fixing in Production for long running reports and supported the development team
• Running Integrity Checks on all Universe (including Test once) to ensure through parsing (Syntax/Sematic Checking)
• Generating SOX Compliance reports on the BO Environment on quarterly basis.
• Discuss performance issues and database views issues with DBA
• Assessing the impact of Windows Patches applied on the servers
• Reboot of servers before Month end cycle starts to assure all the servers are up and running in the critical time
• Regular BO repository Maintenance like decommissioning of Connection/Universe/ Documents/reports
• New Universe/report modification (when needed)
• Data mapping to new tables in the universes (when needed)
• BO resource allocation like linking universe / Documents to Users and User Groups (when needed)
• Applying Security Certificate on the URL for accessing the BI Launch pad and CMC.
• Meeting BO users to understand and resolve issues from their perspective

Confidential

Project Lead/ DWH&ETL Specialist

• Involved in blue print phase of various projects that require ETL as BODS and BW as data warehouse.
• Driven SAP HANA views project - a new functionality provided by SAP for consuming BW Backend Objects as views from HANA database directly without addressing BW.
• Developed Complex Calculation, analytical views and attribute views and used SQL scripting to enrich the views.
• Developed Data flows in BODS for extracting data from legacy systems and integrating it with BW.
• Involved in migration of BW7.3 on Oracle to BW7.4 on HANA as an architect in performing housekeeping activities and also involved in Conversion activities.
• Involved in Functional migration of BW system(SHAPE for Sandoz) into another BW(Pharma) system there by proposing business value and operating efficiency.
• Involved in single tool approach at an organization level for change request management, as we have many tools that are currently being used for this activity.
• Worked in co-ordination with Application owners/Business Owners & IT Infrastructure team for data retention and availability.

Confidential

Team Lead/Solution Architect

• Applied Agile BI methodology in this project to reduce the turnaround time and to help in quickly adapting to changing business needs.
• Designed new data flows which include Semantic Partitioned Objects, Transformations, DTPs and Process chains.
• Developed Account model cubes in BI from the existing Key figure model cubes to support BPC applications
• Provided the Solution for Daily Sales report in order to provide day wise comparison of budgeted Sales Vs Actual Sales at a profit center level using ABAP and BI for COPA data model.
• Created new data mart for exporting data set to MSBI for enabling the reporting on a different front end.
• Optimized the Process chains for bigger time windows for intraday loads in the month end closing.
• Written F4 BADIs to enable required selection for the end users based on their authorizations in the queries and transitioned the functionality to reporting users.
• Created BEx Queries for enabling the BO Analysis reports.
• Used BODS to fetch data from third party system for data integration in our BI system.
• Process chain maintenance as a part of Month end closing activities.
• Has been acting as Tier 3 Support for the BPA User community for handling complex issues and Change requests in Hypercare.
• Using NovaSol (Solution Manager) for change request management in our BI System.

Confidential

Solution Architect

• Involved in Technical Specification preparation and leading the implementation.
• Created new Dataflow which include Semantic Partitioned Objects, Transformations, DTPs & Process chains
• Developed Tableau reports on top of BEx reports and standalone excel reports.
• Created underlying BEx queries for Crystal reports so that calculation is always performed at the BEx Queries
• Created Crystal report with highly formatted objects with 3d graphics add on .
• Created BO publications on launch pad using Crystal reports.
• Developed test scenarios based on inputs from Business user’s inputs.
• Performed Unit Testing, Integration testing as well as UAT for Go live approval.
• Process chain maintenance as a part of Month end closing activities.
• Used SAP CHARM for change request management.
• On boarding new business users by provisioning roles in GRC 10.

Confidential

Team lead and Individual Contributor

• As a team lead, led the project for replacing Informatica with BI 7.0.
• Created Technical specifications from the functional specification.
• Developed implementable solutions with functional inputs from end users.
• Identified the Mappings that pull the data from the legacy source system.
• Replicating the logic that has been existing in the Informatica in the BI system using ABAP.
• Designed Infocubes, DSO and Multiproviders.
• Designed process chains for loading the targets as the part of the project.
• Developed BEx reports as per the End-user requirements.
• Performed the scheduling, Budgeting and resourcing the project.

Confidential

Team Lead

• Identified the services that can be performed from offshore location as a part of process improvement.
• As a Team lead planning the activities based on priorities under the purview of SLA and SOW.
• Creating the roster for the support activities.
• Tickets ( eg Break Fix or minor changes) are handled using Remedy and Maintenance tasks(Change requests like Change/Creation of Transformations) using Service-Now
• Informatica Maintenance has been performed. Starting of the Services and Backing up of data on a periodic level.
• Broadcasting of data using Information Broadcasting in pdf & Workbook formats. Adhoc requests are handled on a regular basis.
• BI security administration has been performed. Identification of roles based on the business areas.
• GRC Requests are performed on the portal according to the security requests. GRC workflow needs to be followed for performing the tasks.
• Load Monitoring has been done using Process chains.
• Files are loaded using process chains in the background on an Adhoc basis. Files are placed on Application server using standard UNIX commands as well as Hummingbird Connectivity.
• Weekend, Year-End and Month-End Activities are performed to make reports accurate.
• Factory Calendar Maintenance in done with the request from the Business usually at the end of the calendar year.
• Actively involved in System testing ( Unix to Linux Upgrade of SAP BI 7.0)
• BI maintenance activities are performed based on SOLMAN report( KPI of System Performance) like Removing unused aggregates, archiving old data (old data as per User’s purview).

Confidential

System Analyst

• Collecting the functional requirement from the client and understanding the technicality involved in it.
• Converting the functional requirement into a technical requirement based on which solution can be designed in BW system.
• Developed new data flows using Infosets, ODS, Cube, InfoObjects, Multiproviders and also customized the existing objects according to the requirement subsequently.
• Worked extensively on LO Cockpit and Involved in mapping the SAP R/3 Logistics data starting extraction from data source till uploading the data into Infocubes.
• Performed in deletion of Setup tables and filling up of the same in order to bring the missing documents using Repair Full request in LO Extraction.
• Enhanced the datasources by adding the required additional fields in ECC and mapped the same with corresponding newly created InfoObjects on BI side.
• Involved in creation of Generic delta using Timestamp delta mechanism.
• Developed function modules for the generic extractors to extract the data from R/3 to BW in the respective DSO.
• Developed transformations and start routines using ABAP to incorporate Business logic and perform data manipulation.
• Created BEx Reports providing insight of business intelligence for decision making using Formulas, Selections, Calculated key figures, restricted key figures and used variables with User entry/Default value.

Confidential

System Analyst

• Maintenance of Authorization profiles based on roles
• Load Monitoring activities and resolving the issues depending on the criticality of the issues
• Preparation of RCA for the issues faced and proposing a solutions and fixes for the same.
• Giving knowledge transfer to the newly joined team members.
• Resolving change requests based on the priority.

Confidential

System Analyst

• As an onsite team member taken the knowledge transfer from the Clients and pass it on to the offshore team members.
• Given the Reverse knowledge Transfer back to client so as to meet the client set standards.
• Collecting the functional requirement from the client and understanding the technicality involved in it.
• Converting the functional requirement into a technical requirement based on which solution can be designed in BW system.
• Improving the performance of loads by optimizing the process chains which are vastly used in this environment.
• Modifications in the ABAP are done in order to meet the end user raised change requests.
• Written function modules for the generic extractors to extract the data from R/3 to BW in the respective DSO.
• Designed and built Infocubes, Multiproviders and ODS as part of solution for the Change requests raised by the end-users.
• Developed Open hub destinations as per the end user requirement.
• Attending the functional meetings along with the client for discussing the feasibility of providing the solution for the new requirements raised by the end user community.
• As an onsite team member need to make sure that the reporting data is available in the morning for the End users. This can be done only by monitoring the load activities.

Confidential

BW Support Consultant

• As a Team member in Load Monitoring prepared work schedule for the team
• BW Data load Scheduling, Monitoring and Troubleshooting data extraction/ load Problems.
• Maintaining the queue - related to the system generated tickets and customer generated tickets.
• Collecting the load failure data and analyzing the load failures for frequency of load failures in loads and providing RCA to the client in order to get their approval.
• Scheduling the Backfills to be done for the week with the required break-ups.
• Involved in monitoring and scheduling of Info package groups and Process chain.
• Involved in Converting InfoPackage Groups to Process Chains.
• Ensure that all periodic schedules like daily/weekly and monthly are successful.
• Analyze the errors occurred while uploading the data if the request fails and make the latest data available in data target.
• Involved in on going Knowledge Transfer activities including user documents preparation.
• Analysis of Short Dumps and interaction with the BASIS Support Consultants to rectify issues.
• Worked on Optimization of data loads.
• Analyzed production load errors and rectified the same in stipulated time.
• Defined various background jobs for Info package groups.
• Wrote Routines to handle Invalid Characters.
• Involved in creating and moving Transports from Development to Production using Customer specific transportation tool GSKC (Global SAP Knowledge Center)

Confidential

Programmer Analyst

• Done Gap Analysis for the EDW BW Inventory Project views
• Involved in the development of ODS, Generic Datasources and InfoObjects.
• Written routines at Update Rules, Transfer Rules.
• Created Transport requests for developed objects and updated in GSKC site (client specific process).
• Preparation of Technical Specifications.
• Preparation of Test Cases.
• Preparation of Data Validation in Production server.
• Modified Info source, Data Targets and writing Backfill programs for Info Providers.
• Written Start Routines, Transfer Routines & created Update Rules.
• BW Data load Scheduling, Monitoring and troubleshooting data extraction/ load Problems.
• Created and maintained start routine to filter out prior unwanted data while loading.

Confidential

Audit team Member

• QA activities such as Quality Assurance Audits, CM Audits
• Identifying project metrics and ensuring the process adherence to PTR
• Reviewed process related project documentation such as PGD, CM Plan
• Identifying Risks and contingency plans for the same
• Preparing QAG training manuals for the respective teams
• In CAR and DAR analysis
• Maintaining check lists for ISO re-certification