Sunand Kosuru

*** ****** **., ** *******, GA ****2 724-***-**** adv4dg@r.postjobfree.com

Solution Architect S4HANA/Analytics

Senior IT consultant with extensive experience implementing ERP and Analytics solutions for organizations in a variety of industries including Railroad, hi-tech, aerospace, energy, commodities, and more. He was engaged in 17 full life cycle implementations over the past 23 years. He brings expertise in enterprise-wide ERP and data warehousing architecture domains and end-state information management designs to meet the needs of clients.

Selected Skill Areas: Strategy Development & Business Analytics Master Data Management Process Improvement Integration Software Data Warehousing Project Management & Delivery Agile & Waterfall System Integration Project Requirements Gathering Training & Development Testing CutOver Planning and Go-Live Hyper Care support

Professional Experience

AVS Insight Solutions Inc – Atlanta GA Oct 2018 - To Date

Principal Solution Architect Client: Norfolk Southern GA

Norfolk Southern is a Rail Road company mainly into Freights. The project implementation involved implementation of SAPHANA on Cloud along with Group reporting and SAP Analytics on Cloud. SDI the integration tool between On-prem and the Cloud and for the automation of SAC Security implemented IAS/IPS solution. In the first phase, Finance, Group reporting and Financial Planning is being implemented. In his role he was responsible for system architecture, business requirements, re-design legacy solutions to improve the process, Integrations, Converting complex codes from legacy systems into S4HANA, setting up testing solutions, coordination user acceptance testing and working with the QAC and Basis teams in the cutover activities. The program was on Agile Mythology

Deloitte Consulting – May 2018 to Sep 2018

Specialist Master Client: Airgas Philadelphia PA

Airgas, an Air Liquids Company, is the Nation’s leading single-source supplier of gases, welding equipment and supplies, and safety products. The Project was to replace its existing financial reporting solution with a more robust solution to streamline its existing processes and improve its overall efficiency and effectiveness for the consolidation, financial reporting, and planning areas. I was involved with architecting the BPC 10.1 on S4HANA solution. The scope involved both Planning and consolidation. The planning solution involved Capex, Opex, Gross Margin and PnL. Workforce was planned in a separate system and extracted into BPC. The transaction data was harmonized in BW from SAP and non-SAP systems and then extracted into BPC using Data Manager Packages. A total of 36 input forms 14 reports in Planning, Consolidation had 23 input forms and 6 reports.

AVS Insight Solutions Inc – Atlanta GA 2016-Jan 2018

Principal Solution Architect (JAN 2017- JAN 2018)

Client: AMTRAK Role: Solution Architect: Financial & Project Planning Leading Accenture Federal Service and Amtrak team to implement new SAP BPC 10.1 (HANA) Net Weaver implementation The scope of this project is to implement SAP BPC10.1, a solution that will aid the Amtrak Financial Planning team in producing a transparent, metric driven and meaningful annual budget, 5 year plan, and revised budget within 60 days of appropriation, as well as day to day reporting, monthly forecasting and analysis. As a Solution Architect, I managed 12 sub work streams from business and data integration team from IT for plan, design and build phase of the project. I was responsible for conducting workshops to document As-Is processes and To-Be processes, Architect BPC/BW HANA solution based on requirements for Financial Project Planning Solution. Led team of Accenture Federal and Amtrak to design and deploy BPC/BW solution, interacted with key resources from Business and IT to design Environment, Models, and Dimensions for proposed solution. Responsible for configuring BPC/BW - Input schedules, Reports, data loads from ECC and BI, data loads from flat file, data transfer within application. Guide Onsite and Offshore team to configure Environment, Models, Dimensions, Reports, Input Forms, Logic Scripts, Security roles in BPC. Led to a successful Go-Live of Phase 1 of the project in October 2017, which included Operating and Other Expenses and provided hyper care support and transitioning to support team by conducting knowledge sharing sessions.

CAPGEMINI – Atlanta, GA – 2009-2016

Senior Manager (2014-2016) Manager (2009-2013) – Progressively increased responsibilities within Capgemini; as a senior manager, hired, supervised, and motivated a technically-skilled staff to achieve maximum productivity and effective operations. Facilitated BPC training for 26 employees and developed 500+ reports to demonstrate the capability of SAP's ERP Solutions during sales and requirements gathering processes. Led cross-functional business workshops to enhance information availability resulting in informed management decision-making. Worked on improving Capgemini’s estimation tool to allow for a competitive edge in the market.

SELECT PROJECT WORK:

■Sr. Solution Architect – CHS (2015-2016) – Instituted use of a standard development framework methodology and application system development process in the finance area. Led day-to-day activities associated with the construction, enhancement, and support of SAPHANA applications. Designed conversion and extraction of Legacy systems data and integrated with SAP ECC data.

-Planned legal and management consolidation of 150 entities, 2445 profit centers, and 4150 cost centers.

-Collaborated with the business to support process within 6 months.

-Changed from ‘red’ status to ‘green’ within 30 days of taking over; maintained ‘green’ status for project’s lifecycle.

■Sr. Solution Architect BI/BPC – United Copper Industries (2015-2015) – Led a team of 4 onshore and 4 offshore resources; gathered reporting and planning requirements utilizing end-state design session workshops with senior client counterparts. Served as a subject matter expert to translate IM business requirements into system solutions.

-Approved RICEFW developed by the project team to ensure client's requirements were addressed.

-Ensured delivery of 25 business analytical reports in supply chain, finance, inventory, and production.

-Delivered 12 input templates and reports to assist client with the planning process.

■Managing Solutions Architect BI/BPC – Seventy Seven Energy (2014-2015) – Selected to serve as BPC lead for a full life cycle implementation on SAP HANA, this involved all SDLC phases blueprint, realization (build/testing), deployment, and support. Updated all parties on project standing and provided status reports to the PMO; completed on time and on budget.

-Directed and mentored project engagement team of 5 onsite and 4 offshore resources.

-Tasked with additional responsibility of managing BI related work due to subject matter expertise.

■Sr. Manager (BI) – Availl (2013-2014) – Asked to assist client during realization phase, this included refining BI and BW reporting cubes, re-engineering existing BEX Analyzer, WEBI, BOBJ, and Crystal warehousing/reporting architectures. Utilized ETL tools such as BW extractors and data services to address client's data requirement needs.

-Demoed advantages of moving to HANA; helped to landscape index databases and improve reporting efficiencies.

-Guided and managed a BI/BW team (15 onshore and offshore) through the successful implementation of SAP BI/BW; optimal performance resulted in promotion to senior manager position.

-Faced challenges head-on; inputted 3 years of historical Legacy sales data into BI and merging it with the ECC data.

■BPC/BI Lead – TAG (2013-2013) – Managed a team of 4 onshore and 6 offshore through BPC, this included balance sheet, expense and cost center, rolling forecast, and reporting. BI functional areas included PTP, FTM, PS, and CTC. Oversaw data extraction, which included SRM, ECC, and CRM; data was being exported to Oracle, Callidus, NCC, SCC, LAS, Comtrak, and Seibel.

-Worked with team to consolidate the following: balance carry forward, currency translation, inter-company eliminations, consolidation of investments, journals, validations, re-classifications, and reporting.

■Project Manager BI – Coco-Cola (2012-2013) – Took on quality control piece of BI project (22 projects were being executed at client site). Initiated process of creating standard template documents for all projects. Utilized Microsoft Projects to assist in on-time delivery of projects; managed scope change in a prioritized manner.

-Project managed rollout of business content development on a global scale; template rollout of SAP’s ECC 6.0 solution, this included applications such as BW NetWeaver, BOBJ, Data-Services, and CRM.

-Designed effective solutions for the data extraction process, which connected call center activities in a CRM with the sales order in ECC to improve sales performance.

■Project Manager BI Lead – Target (2010-2012) – Led a multi-year business transformation engagement, which included the direction of 5 BI and 5 BPC resources onshore and 13 offshore BI resources. Oversaw all aspects of project, including scope management, resource management, requirement analysis, solution architecture, configuration, development, testing, deployment, post-implementation transition, and realization of cost benefits.

-Designed BI and BPC solution in the areas of retail-specific functionality (i.e. accounts receivable, accounts payable, treasury, general ledger, project system, financial asset management, and purchase-to-pay).

-Traveled internationally on multiple occasions to facilitate smooth onshore and offshore transitions.

■Manager BI Lead – Smith and Nephew (2009-2009) – Recognized as a key individual in BI assessments for new opportunities; developed a BI roadmap. Projects included high-level design and estimating resource requirements, identifying process gaps in capturing data required in the source systems, and recommending necessary configuration changes.

-Conducted group discussions with client’s management-level personnel; identified concerns and reporting needs.

-Prepared presentation documents to acquire funding for projects; presented to client’s finance department with an emphasis on the project’s ROI and opportunity loss.

BEARINGPOINT – Pittsburgh, PA – 2004-2009

Manager – Assumed leadership role, overseeing projects and team of 2-15 BI developers including design, implementation, testing, and roll-out of enterprise data warehouse and data marts including development of proof-of-concepts. Developed and maintained operational, analytic, dashboard, and executive-level reporting using Business Objects Crystal Reports, Microsoft Reporting Services, Microsoft, SharePoint, and other BI tools. Created and enforced corporate standards for data warehouse design and data integrity. Evaluated and analyzed existing OLTP databases and developed/maintained integrations to data warehouse. Ensured data architecture supported existing and future requirements of evolving business model.

SELECT PROJECT WORK:

■Manager BI – Celanese (2008-2009) – Delivered a new SAP BI implementation in the areas of FI, MM, SD, and PP. Directed a team of 6 through supporting client’s team and identifying/defining KRIs, PIs, and KPIs for the organization. Conducted training sessions for super users and end users. Configured complex "order touch" reporting for order status changes.

■Project Manager BI – R.J Reynolds (2005-2008) – Oversaw a team of 14 through a project implemented in phases. Areas of implementation in BI involved FI, MM, PP, and SD. Led complex data warehouse designs and monitored BI system as volume of data grew. Managed authorization and security of BI data based on corporate needs.

-Designed leaf purchase planning process with iterative planning updates for Tobacco leaf procurement.

-Configured and coded data extraction from SAP and non-SAP systems using various interface technologies such as DB connect, UD connect, and web services.

■Lead BI Manager at Hyundai (2004-2005) – Contracted into lead BI role, responsible for blue printing project (fixed bid project) and subsequently implementing and realizing the project until go-live. Oversaw a team of 12 and worked on implementation areas including FI, PP, IM, PUR, SD and CPM; completed project on-time and on-budget.

-Identified KPIs and designed reports to present in CPM; extracted automobile classification data in the BI environment.

Previous positions included Consultant roles with Rockwell Collins and CHEP as well as Senior Consultant for Coco-Cola. Functioned in a wide-range of roles focusing on business intelligence, dataflow, and custom report building.

Education

Bachelor of Technology –NIT Surathkal, Mysore University –India

Training & Certifications:

SAP-HANA – TechETraining (2016); BPC – TechETraining (2014); Engagement Management Cert, Capgemini (2012); BW – Authorizations, SAP Academy (2004); SEM210 – Business Planning & Simulation, SAP Academy (2003); BW210 – Architecture & Configuration, SAP Academy (2001); BW205 – Reporting, SAP Academy (2000); BW220 – Extraction, SAP Academy (2000)

Citizenship : US Citizen

Contact this candidate