Summary
Work History
Education
Skills
Accomplishments
Hi, I’m

Sivaramakrishna D

Specialist, Data Architect

Summary

Motivated and data driven Data Specialist ,Architect with 13 years of experience, I offer profound expertise in Business Analytics and intelligence application development. My specialization includes skills in Data Architecture, Data Warehousing, Data Modeling, Database Design, and ETL procedure development

Extensive experience in diverse projects, including Implementation, Rollouts, Upgrades, and Support. In terms of industry knowledge, I have a comprehensive understanding of Supply Chain Operations, covering areas such as On-Time In-Full (OTIF) performance, Inventory Optimization, Demand Forecasting,Material Availability, Planning, Global Repair Operations, and Continuous Improvement Maintenance

Work History

Vestas wind technology

Specialist, Data Architect
06.2014 - 04.2016

Job overview

  • Lead the design and implementation of end-to-end supply chain solutions on On-premise and Cloud, integrating data-driven insights to enhance operational efficiency.
  • Developing & enhancing various key KPIs and tools like OTTR/OTIF (Delivery performance), Express shipment overview, SS Recommendation Model, Consumption statistics, RSPL Model, Entry point simulations, Failure rate calculations, Surveillance, surplus, ITO other works related to supply chain operations
  • Collaborate with various teams, including those responsible for data sources like SAP, SF, SCADA, and Quality etc along with Business Owners and IT partners. Understand and analyze the business requirements, and transform them into scalable data solutions
  • Develop & produce insights for Global repair operations and to track the all the critical data/insights from single data product ( REN Utilization and E2E supporting KPIs and metrics to know gaps to focus)
  • Support as Backend model SME for Strategic initiatives E2E supply chain by external vendors – Logics for existing models, Support on core blocks and data for Monthly/weekly reports for demand cycle &planning.
  • Scope problem statement to assure business continuity that we need to migrate to cloud and benefits of using it &Aligning with Stereo. Finalized the first wave of SCR Azure Data Model project by migrating 6 key Service Supply Chain Data product( from our on-premise database to Azure cloud and rebuilding the front-end in Power BI
  • I worked as a Data Architect for the Global Operating Model (GOM) Leap program. My job was to create performance models for both upstream and downstream Key Performance Indicators (KPIs). This involved integrating information from two sources, SAP and SF.

Ford Motor Company

Senior Business Intelligence Consultant
06.2014 - 04.2016

Job overview

  • Plan and sequentially build and integrate interfaces for Ford Asia Pacific's motor processing system, focusing on data modeling. Implement interfaces for SAP systems such as Lead, Vista, S2, DRAGONFLY, etc.
  • Ensure customer and lead information undergoes cleansing by Acxiom. Cleaned data is then updated in the Master Data Management (MDM) server, and the updated data is transmitted to the Customer Relationship Management (CRM) system along with vehicle and lead details. Develop various reports to monitor these metrics in different SAP systems.

EXL analytics
Chennai

Business Intelligence Analyst
09.2012 - 06.2014

Job overview

  • Understanding business requirements, analysis of data points available in the system and make decisions for financial recovery.

Verizon Data services
Chennai

Software Engineer
10.2010 - 09.2012

Job overview

  • Carrollton Overall Analytics is an OLTP system which stores the customer information regarding members and their purchase and views. The warehouse was running on SQL Server 2008 with a web-based Dot Net front-end, implemented infrastructure to support over 3.8M dataset users consisting of more than 150 databases.
  • involves understanding business requirements, analysis of data points available in the system and make decisions for generation of revenue, interacting with relevant customers and proposing solutions to facilitate generation of reports by way of DB creation and automated feeds.

Education

JNTU University

University Overview

  • Bachelor of Technology from JNTU University with an aggregate of 75.96%,2006-10
  • Board of Intermediate with 96.6% from Sri Chaitanya Junior College, Vijayawada,2004-06
  • SSC with 91% from A.P.R School, Vizag, 2003-04.

Skills

  • Traditional Data Stack: MS SQL SSMS SSIS SSASPower BIDAX/Data Analysis
  • Cloud / Modern Data Stack: Azure Snowflake databricks dbtBig dataPython
  • Agile Methodology/Kanban – Daily scrum, sprints planning, backlog refinement, retrospective
  • Supply Chain Analytics- Data Modelling - Supply chain concepts, SAP (MM, SD), SAP CRM,SAP MDM, SAP BI/BW,Sales force,Business Intelligence Roadmap Design
  • Supply Management-Process Improvement-Change management-Analytical Thinking-Root Cause Analysis-DIMAC-Business Intelligence Roadmap Design

Accomplishments

Accomplishments
  • Achieved recognition with four "Employee of the Quarter" awards for outstanding performance at Vestas. Additionally, received the Innovation Cycle Award for Cost Optimization in Express Shipment
  • Received “Employee of the Quarter” Awards for the best performance 5 times from Ford motors.
  • Received “On the Spot” and “star” Awards for the best performance in Verizon Data Services India Pvt Ltd.
  • Secured 112 rank in 6th National IT Aptitude Test where the score is among the Top 1% (99.23 Percentile).

Similar Profiles

CREATE PROFILE
Sivaramakrishna D