Kiran Thirunagari

Sr. Developer / Analyst–SAP BW*HANA/BI Reporting and Data Analytics

Email: ad2sxr@r.postjobfree.com

Mobile: 517-***-****

LinkedIn: https://www.linkedin.com/in/KTAnalytics/

Immigration status – Green Card

Professional Summary

Results-driven senior SAP Developer Analyst with over 15 years of experience in data warehousing and business intelligence. Skilled in technical problem solving, optimizing data-driven insights, strategic decision-making and collaborating with cross-functional teams. Proficient in analyzing complex data sets and creating comprehensive reports to support business decision-making. Seeking a challenging role in SAP BW/BI development where I can leverage my experience across multiple domains to drive strategic decision-making, optimize data driven insights, and lead teams.

●Core competencies include SAP BW/BI, BW4HANA, BW on HANA, Native HANA, BOBJ, BODS, and SAP Analytics cloud and Azure to any project with good understanding of SAP ERP modules O2C, P2P, R2R, FI-CO, Supply Chain.

●Extensive experience in working with various reporting tools such as BEX, BO WEBI, Power BI, and SAC. In Depth knowledge in creating Dimension Calculation Views to retrieve master data, Calculation Views using Cube or Star Join to extract fact data and utilizing Star Schema modeling for optimized data analysis. Good experience using all types of joins and all components of HANA (like Input parameters, variables etc.) and some experience with CDS views and AMDP transformations.

●Practical experience in utilizing SAP BW for data modeling and reporting in BW 3.5, 7.0, 7.3 BW 7.5 on HANA, and SAP BW 4 HANA to support business analytics and reporting requirements. Worked with a range of features and tools such as Composite Providers, Advanced DSOs (ADSOs), ODP, and LSA++ architecture.

●Extensive experience and a strong track record in report building using BEX and Business objects WEBI. Over the years, I have successfully created numerous reports in both BEX and BOBJ, leveraging my expertise in utilizing the Query Designer within these tools. I am highly skilled in designing and developing tabular and visualization reports in BOBJ WEBI, harnessing the power of tables, charts, graphs, and other visual elements to present data in a meaningful and impactful manner.

●Good exposure to SQL and hands on experience in stored procedures, using SQL with WEBI and HANA also good understanding with Table functions.

●Able to Handle SLT, SDA and data extraction using Data services

●Develop Real-Time data models for reporting and analytics, ABAP programs, user exits, routines and activate business content.

●Worked in optimizing the Performance for high-volume and complex information delivery scenarios and monitored BW data runs, communicate, and troubleshoot issues related to BW

●Optimize end-user data access response times by closely observing the data loading times and report execution times and making necessary changes to improve the performance.

●Some understanding with Azure Data factory, Azure Data Bricks, Python.

●Independently gathers, analyzes, and identifies opportunities for enhancements, works closely with Business and Technology partners to seek and provide smart resolutions to business issues

●Translate the user requirements into functional and technical design, application configuration, and testing scenarios. Also done the effort estimation and work delegation activities that helps the project management.

Hands on experience with activities like month end and year end closing, reconciliation of ECC data with BW and also actively involved in minor and major releases of work during deployment.

●Hands on experience building Analytical dashboards in SAC involves gathering requirements, Identify the key metrics, KPIs, and data sources, design a data model within SAC, define the relationships, hierarchies, and measures required for analysis and reporting, Data wrangling, creating Stories for the dashboards, adding visualizations to the story canvas by selecting the appropriate charts, graphs, and tables. Customize each visualization by defining measures, dimensions, and filters to visualize the data accurately, configure interactive features within the story, such as drill-downs, filters, and linked analysis, to enable users to explore the data further and gain deeper insights, calculated measures, formulas, and variables to perform advanced calculations,

●Worked on some planning dashboards in SAC involved gathering requirements, collect and integrate the relevant data required for planning activities, create and configure the planning model within SAC and set up the necessary dimensions, data input forms, and planning functions required for the planning dashboard, create visualizations that present planning data in a clear and meaningful way using charts, graphs, tables, and other visualization components, Configure data refresh settings to ensure the planning dashboard is updated with the latest data.

●Hands on with Microsoft Power BI reporting development. Created various reports and dashboards using the objects such as stacked bar charts, column charts etc. using Power BI.

●Familiar with understanding the relationships, cardinality, M language and DAX, DAX functions etc.

●Good hands in Data preparation, analysis and visualization using Power BI desktop. Also, familiar working in Query editor working with customizations of the reports, handling with filters, pivot-unpivot, formatting the reports, appending the queries, splitting columns, merging queries, creating joins, creating table manually

●Adept at working with standard and generic extractors, Info Objects, Start and end routines, Hierarchies, Info Sources, Update Rules, Transfer Rules, Transformations, Info Cubes, Multi Cubes, Multi & Composite Providers, ODS/DSO, Info Sets, Info Packages, Data Transfer Process (DTP), Open Hubs.

●Equipped with broad and varied experience in technical and business skills across numerous industries such as healthcare, medical devices, utilities, government projects, food and beverage, manufacturing, retail, telecom, and consumer packaged goods (CPG).

●Led development projects for some of the reputed firms in the industry, including Bacardi, Kellogg's, BD technologies, Stryker, US Cellular, MUD, and BNSF railways.

●I am well versed with HP Quality Center (now ALM) and have extensive experience in conducting OQ and PQ testing processes. I have created comprehensive OQ and PQ test plans and successfully executed both OQ and PQ testing. Additionally, I have taken on the role of Test Lead for a project.

●Expert in Requirements Gathering, Functional and Technical Specification Documentation, Test Case Writing and Test Result Documentation using HPQC. I am skilled in transcribing technical documents for Production support and providing End-User training on reports navigation and BW basics.

●Delivered high-quality work by collaborating with cross-functional and implementation teams spread across the globe. Onsite Coordinator/Lead for various BW development and support projects. Participated in preparing effort estimation for projects including project schedule and resource planning. Also experienced in tracking milestones and meeting delivery expectations

●As a certified Scrum professional, I possess a strong understanding of the various components of the Scrum Framework, including the roles of Scrum Master, Scrum Product Owner, and the Scrum Team. I am well-versed in Scrum Artifacts such as Product Backlog and Sprint Backlog, as well as Scrum Events including Sprint, Sprint Planning, Daily Scrum, Sprint Review, and Sprint Retrospective.

●Well-versed in using ticketing tools such as ServiceNow and Remedy with excellent documentation, communication, and problem-solving skills, both verbal and written. Able to work independently analyzing data requests, documenting business requirements, and designing reporting solutions related to BW

Education

Post Graduate_ Program in Data Science and Business Analytics from University of Texas at Austin (Currently Pursuing)

Master in Business Administration (IT) from Preston University London UK.

Bachelor of Engineering from Bangalore University India

Skill Set

•SAP BW4HANA, Native HANA,

•Business Objects WebI, BEX, SAP SAC, Power BI

•SAP S4HANA, ECC, SAP CRM

•ABAP, Visual basic 6.0, SQL & PL/SQL, CDS Views, AMDP transformations

•Azure, MS Office, HP ALM, Agile-Certified Scrum Master, Certified Salesforce Admin.

Professional Experience

Apps Boat Inc Oct 2019 – Present

Software Engineer (Sr. SAP BW HANA Reporting and Analytics Consultant)

Project: BD Technologies

Environment: SAP ECC, SAP HANA, Native Hana, Power BI, SAC, Azure

Gathered business requirements and created functional specification documents for Customer Master, Material Master, and Billing Master. Designed and developed HANA Calculation views that feed Power BI reports. My skills in this area include creating Calculation views with input parameters, variables, and various joins, as well as generating calculated columns by reading the existing data flow from Hive in Azure data factory.

Project: BNSF Railways

Environment: SAP ECC, SAP GRC, SAP BW on HANA, SAP BEX. Native Hana, WEBI, Power BI

Created generic data sources in the GRC system and extracted data to BW. Developed an ADSO in BW 7.5, along with transformations, DTPs, and Info packages. Additionally, created Calculation views and used them to develop a report and dashboard in Power BI. Furthermore, worked with Native HANA to develop information models based on data sourced from SAP GRC system.

Project: Metropolitan Utilities District

Environment: SAP ECC, CRM, SAP BW4HANA, SAP Analytics Cloud, SAP BEX. Native Hana, WEBI.

CRM interaction center statistics reports were developed in WEBI. CRM call center activities extracted to BW using generic extractor. Data loading performance improved by optimizing the extraction for the process related to Equipment from ECC. SAC dashboard was built based on information models and calculation views, which were created using data sourced from Oracle and SQL Server using SDI. Stored procedures were used to automate the process of data loading.

Project: Moody’s Corporation

Environment: SAP S4 HANA, SAP BW4HANA, Success factors, Power BI, SAC, SAP BEX., Native Hana, Power BI

Gathered requirements from HR users to build calculation views and dashboards. Designed, developed, Tested, and deployed the Cal views and Dashboards for Talent acquisition, Compensation, and other areas of HR. Created dashboards in Power BI

Project: Astellas Pharmaceuticals

Environment: SAP S4 HANA, SAP BW4HANA, SAP Analytics Cloud, SAP BEX., Native Hana

Involved in change request and support activities. Closely worked with business teams on their tickets and provided them resolutions. Extracted ACDOCA data using CDS views and built data models by developing composite provider, calculation views and ODS views.

Project: Stryker

Environment: SAP S4 HANA, SAP BW4HANA, BOBJ, SAP HANA, Office Analysis, SAC, MS Power BI

Involved in cutover activities plan preparation to implementation of upgrade of BWHANA from 1.0 to 2.0 both Application upgrade and HANA DB upgrade. Worked on support tickets raised by sales representatives and provided them with solutions. Created the back-end objects like info objects, ADSO, Composite provider and calculation views.

Project: TDS Communications/US Cellular

Environment: SAP ECC, SAP BW, SAP BODS, BOBJ, SAP HANA, Office Analysis

Worked with Engineering business analysis team to build their own application from the data coming from BW. Analyzed the data and realized the missing gaps, enhanced the existing data sources, and map them to BW. Project system data sources are configured to extract Actual Costs data and Commitment Line Items data.

Innovecture Inc April 2017 – Mar 2018

Software Developer (SAP BW HANA)

Worked on some POCs and trainings related to BW and HANA

Environment: SAP ECC, SAP BW, SAP BODS, SAP HANA, SAP BOBJ

Working on the implementation of physical separation of the business units of the client. Collected the requirements from the users and created the URS documents and converted them to FRS documents. Worked with data migration from BW to SQL lake using Open hubs in BW and Query transformation in BODS.

Becton Dickinson, Mar 2013 – Jan 2017

IT Analyst - Analytics & Reports

Environment: SAP BW, SAP CRM, SAP ECC, SAP HANA, SAP BODS, SAP BOBJ

Played an instrumental role in managing the coordination between IT and Business, in comprehending the users' requirements, developing functional specifications, and subsequently translating them into technical specifications. My responsibilities include in managing various change requests, roll-out projects, as well as major, minor, and emergency releases, overseeing the different phases of testing and release to production. Overall, my contributions were critical to the successful development and deployment of the application.

Palnar Inc, Apr 2008 – Mar 2013

Programmer Analyst – SAP BW(Consultant)

Environment: SAP BW, SAP ECC, SAP BOBJ

As a consultant, worked for different projects like Bacardi, Hospira, Kellogg’s and Tate & Lyle. The primary responsibility is to design, develop, test, deploy and support the application.

Palnar Transmedia India Sep 2004 – Apr 2008

SAP BW(Consultant)

Environment: SAP BW, SAP R3

As a consultant, worked for Roche diagnostics. The primary responsibility is to design, develop, test, deploy and support the application.

Contact this candidate