Resume

Project Data

Location:

United States

Posted:

March 15, 2018

Contact this candidate

Resume:

Summary:

** ***** ** ********** ** a SAP BI/BW/BO 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 BASF, ArcelorMittal, Armstrong World Industries and Novartis.

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 extracting data from 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.

Education

Degree

University

Year of Passing

B.Tech

(Bachelors in Mechanical Engineering)

RVR&JC College of Engineering Affiliated to Acharya Nagarjuna University, Guntur.

2002

Certificate Program

AutoCAD, CATIA, PRO-E from Engineer’s CADD center, Hyderabad

2003

Post Graduate Diploma

Post Graduate Diploma in Design and manufacturing Management from London South Bank University, London, UK.

2005

Technical Skills:

DW Tools

SAP BW 7.5/7.4 on HANA, BW/

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

Certifications:

Sl#

Certification

Date

SAP CERTIFIED APPLICATION ASSOCIATE- BUSINESS INTELLIGENCE WITH SAP NETWEAVER 7.0

23/04/2010

Six Sigma Lean Certified Associate

22/03/2012

Awards & achievements

Sl#

Award

Date

Above and Beyond Award for achieving challenging goals in MIS Program at Novartis.

15/01/2016

TOP Award Q1 2016 at Novartis for excellence in performance Management for Daily Sales Program

Q1 2016

Project Profile:

12.

Project Name : Houlihan

Client

T-Mobile

Role

SAP Business Objects Architect

Organization

TechMahindra

Duration

27/12/2017 – till date

Team Size – 6

Location: Seattle, WA

Module: BO 4.1, HANA, Teradata, Oracle, Netezza, MS SQL server 2013

As America's Un-carrier, T-Mobile US, Inc. (NASDAQ: TMUS) is redefining the way consumers and businesses buy wireless services through leading product and service innovation. The Company's advanced nationwide 4G LTE network delivers outstanding wireless experiences to 71.5million customers who are unwilling to compromise on quality and value. Based in Bellevue, Washington, T-Mobile US provides services through its subsidiaries and operates its flagship brands, T-Mobile and MetroPCS. For more information, please visit http://www.t-mobile.com.

Understanding business reporting requirements to fit the given SAP landscape.

Develop Teradata/SAP BW/HANA based universes, reports/dashboards

Environment support for testing activities

DevOps mode of work for all deployed projects

Manage working multiple projects under tighter deadlines with risk mitigation

Work with multiple technology(SAP/Teradata/Virtualization) & Business stakeholders for design decisions

Used VB scripting where the conventional BO functionality is not supporting the business requirement.

11.

Project Name : Houlihan

Client

T-Mobile

Role

SAP Business Objects Administration/Application Maintenance

Organization

Contractor

Duration

09/01/2017 – 27/12/2017

Team Size – 12

Location: Seattle, WA

Module: BO 4.1, HANA, Teradata, Oracle, Netezza, MS SQL server 2013

Providing access to users in all the environments 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

Convening IT Calls on the timelines and restrictions with business for Business Objects developments and Releases

Analysing SQL for any long running reports on various databases and optimize it as required

Supporting the development teams with Deployments of the Projects and Releases

Troubleshooting if any issues with Reports and Universes (Technical support to Users)

Performed Bug fixing in Production for long running reports and supporting the development team

Running Integrity Checks on all Universe to ensure through parsing (Syntax/Semantic Checking)

Generating SOX Compliance reports on the BO Environment on quarterly basis.

Discuss performance issues and database views issues with DBA for the respective databases.

Perform reconciliation with the Webi reports and underlying databases for any issues.

Assessing the impact of Windows Patches applied on the servers by applying on the test system and eventually to production servers.

Reboot of servers before Month end cycle starts to assure all the servers are up and running in the MEC period

Regular BO repository Maintenance like decommissioning of Connection/Universe/ Documents/reports

New Universe/report modification (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.

11.

Project Name : Cross Divisional Architecture

Client

Novartis Healthcare

Role

Project Lead/ DWH&ETL Specialist

Organization

Novartis Healthcare

Duration

01/12/2015 – 30/09/2016

Team Size – 12

Location: Hyderabad, India

Module: SAP – BI 7.4, SAP BEx, BO Analyzer, ABAP, BODS, HANA, Tableau

Novartis provides healthcare solutions that address the evolving needs of patients and societies. Focused solely on healthcare, Novartis offers a diversified portfolio to best meet these needs: innovative medicines, eye care products, cost-saving generic pharmaceuticals, consumer health products, preventive vaccines and diagnostic tools. Novartis is the only company with leading positions in each of these areas.

Project Description: Provide Cross divisional Architect support for various projects and engagements across Sandoz, Pharma & Alcon.

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.

10.

Project Name : Dynamic Management Reporting

Client

Novartis Healthcare

Role

Team Lead/Solution Architect – Finance IT

Organization

Novartis Healthcare

Duration

01/07/2014 – 30/11/2015

Team Size – 8

Location: Hyderabad, India.

Module: SAP –BI 7.4, SAP BEx, BO Analyzer, ABAP, BODS

Project Description: Implementing the DMR Project for Providing the business users with the BO analysis reports and workbooks based on agile methodology.

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

Developed and architected 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.

Project Name : Integrated Management Reporting

Client

Novartis Healthcare

Role

Solution Architect - Finance IT

Organization

Novartis Healthcare

Duration

20/05/2013 – 30/06/2014

Team Size – 12

Location: Basel,Switzerland & Hyderabad,india

Module: SAP –BI 7.4, Crystal Reports, BO Launchpad, SAP BEx, Tableau.

Project Description: Implementing the IMR Project for Providing the business users with the highly formatted crystal reports via BO Launchpad.

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 .( www.threedgraphics.com)

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.

Project Name : Armstrong – Implementation

Client

Armstrong World Industries

Role

Team lead and Individual Contributor

Organization

Genpact

Duration

01/05/2012 – 19/05/2013

Team Size – 2

Location : Hyderabad, India

Module : SAP –BI 7, ABAP, Informatica Powercenter 8.1

Armstrong World Industries, Inc. is a global leader in the design and manufacture of floors, ceilings and cabinets. In 2010, Armstrong's consolidated net sales totalled approximately $2.8 billion. Based in Lancaster, Pa., Armstrong operates 31 plants in seven countries and has approximately 9,300 employees worldwide.

Project Description: Replacing Informatica with SAP BI as an ETL tool for loading data to BI 7.0 from legacy Source systems.

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.

Project Name : Armstrong World Industries

Client

Armstrong World Industries

Role

Team Lead

Organization

Genpact

Duration

22/07/2011 – 01/05/2012

Team Size – 6

Location : Hyderabad, India

Module : SAP –BI 7, SAP GRC, ABAP, Informatica Powercenter 8.1

Project Description:

Application Maintenance and Support of SAP BW 7.0 systems and Planning the activities using Offshore model. Maintaining the SLA Metrics (eg MTTR) according to SOW.

Contribution:

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).

Project Name : ITSWE T&M Implementation

Client

Arcelor Mittal

Role

System Analyst

Organization

Mahindra Satyam

Duration

14/06/2010 – 20/07/2011

Team Size – 5

Location : Gent, Belgium

Module : SAP –BI 7,ABAP

Arcelor Mittal is the leader in all major global markets, including automotive, construction, household appliances and packaging. The Group leads in R&D and technology, holds sizeable captive supplies of raw materials and operates extensive distribution networks.

Project Description:

The objective of this project is to implement the business proposed changes into the SAP Functionalities and roll out the solutions.

Contribution:

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.

Project Name : ITSWE Maintenance Project

Client

Arcelor Mittal

Role

System Analyst

Organization

Mahindra Satyam

Duration

26/12/2008 – 13/06/2010

Team Size – 6

Location : Offshore- Hyderabad

Module : SAP –BI 7,ABAP

Project Description:

Recurrent(ongoing) and evolutive (incidental) maintenance also plays a major part in the project. Maintenance of Authorizations in BI system.

Contribution:

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.

Project Name : ITSWE Maintenance Project

Client

Arcelor Mittal

Role

System Analyst

Organization

Mahindra Satyam

Duration

14/05/2008 – 25/12/2008

Team Size - 6

Location : Gent, Belgium

Module : SAP –BI 7,ABAP

Project Description:

The objective of this project is to convert the business defined changes into the SAP Functionalities and work out the solutions. Recurrent and evolutive maintenance also plays a major part in the project. The load monitoring activities needs to be carried out as well.

Contribution:

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.

Project Name : BASF SAP BW Load Monitoring Project

Client

BASF

Role

BW Support Consultant

Organization

Lanco Global Systems Limited

Duration

(02/2007) – (03/2008)

Team Size – 12

Location : Hyderabad (Offshore support)

Module : SAP –BW 3.5

Project Description:

BASF Corporation is the North American based Florham Park, New Jersey in affiliate of BASF AG, Ludwigshafen, Germany. It has diverse product mix including chemicals, polymers, automotive and industrial coatings, colorants, and agricultural products.

Contribution:

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)

Project Name : EDW- BW -Migration Projects (Inventory, Master, Transaction Data)

Client

BASF corporation

Role

Programmer Analyst

Organization

Lanco Global Systems Limited

Duration

(11/2006) – (01/2007)

Team Size - 8

Location : Hyderabad (Offshore support)

Module : SAP –BW 3.5

Project Description:

BASF has been using Oracle Enterprise Data Warehouse (EDW) as a warehousing solution for their business intelligence. The objects in EDW are being migrated to SAP BW in a phased manner.

The objective of this Project is to identify the EDW views, which have to be migrated to SAP-BW and create the BW objects corresponding to the identified EDW views as well as creation of Data Targets for extraction of data from SAP-R/3 for Objects Specified by BASF.

Contribution:

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.

Project Name : Audit

Client

ISO Re-Certification Audit

Role

Audit team Member

Organization

Lanco Global Systems Limited

Duration

(11/2006) – (03/2008)

Team Size: 4

Location : Hyderabad

Project Description:

Involved in QA activities such as Quality Assurance Audits and reviewing project documentation such as PGD, SOW etc. Been an Auditee for the ISO 9001:2000 Recertification Audit (September 2007) and has been successful in retaining the same for the next three years.

Contribution:

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

Contact this candidate