Kailash Kota

Currently working on a Self-Service BI solution (Data
as a service) to customers for real time analytics.

Designed, planned and lead as a scrum master to
translate an enterprise or business requirements into
long-term information/data architecture solutions,
including conceptual, logical and physical models
for Supply Chain Management.

Developed data pipelines using Microsoft Data Factory on Azure SQL
Server. Designed & developed the Data modelling for various cubes.
Currently working on leveraging Microsoft Fabric for the existing solution.

Designed the CI/CD pipelines for seamless migration
of solution across environments.

Mentored junior consultants, fostering a supportive environment that encouraged
professional growth and skill development.

Reduced project timelines by optimizing workflows, improving communication channels,
and leveraging cross-functional collaboration.

Tools used : Microsoft Azure SQL Server, Microsoft Data Factory, Databricks
Services, Power BI, ADS.
Functional Skills : Supply Chain Management (Project, Production,
Revenue, Service, S&OP).

• Integration of Snowflake DB with Azure environment for data archival.

• Designed and developed the data warehouse, ETL packages using SQL Server Integration Services, Cognos Framework Manager Model, Reports and Dashboards. Developed automation scripts using Shell scripting and Python for end to deployment on Microsoft Azure Cloud.
• Developed SSAS cubes for the newly developed schemas in this release.
• Implemented a Predictive Analytics model as Machine Learning solution for Transportation planning based on IoTs using Microsoft Azure Studio and Python programming.
• Assisted and mentored the cloud teams, consultants for implementation of the product.
• Developed reports on SCPO (Supply Chain Performance optimizer) using Power BI such as Capacity Pegging, Material Pegging, Actual Vs Planned Analysis, Stockout Analysis , Demand dashboards etc
• Developed reports for TM (Transportation Management) using PBI.

Tools used : Microsoft SQL Server, SQL Server Integration Services, Cognos Modelling and reports, SSAS, Power BI, DAX, Microsoft Azure ML studio, Azure Data Analytics, Azure Data Factory, Azure SQL Database, Agile, Shell Scripting.

Functional Skills : Transportation Manager, Supply Chain Management and Logistics.

• Leading the team and interacting with customer for conducting system study for requirements mapping, overall solution design/architecture, low level design, data integration needs, reporting needs, implementation etc on HA environment.
• Understanding business requirements, Data warehouse design and dimension modeling.
• Converting overall design to a working model enhancing analytics and reporting needs of business users by using IBM Cognos and Power BI.
• Utilizing DW/BI best practices for a high performance and robust BI implementation.
• Maintenance and support of the developed DW/BI systems to ensure smooth business execution.
• Developed several datapipelines/packages/mappings using SSIS and Informatica with end to end automatization.
• Developed cubes and models using SSAS and Cognos Framework Manager. Created complex metrics having parameterized dynamically.
• Developed the data security Model for user groups.
• Developed reports and dashboards using Power BI. DAX was widely used to calculate the metrics.

(Onsite – Beijing, China) – Individual Contributor

Successfully implemented the BI solution as an individual contributor and customized the needs of the customer.

Tools Used: SQL Server, Oracle, Informatica PowerCenter, Cognos, SSAS, PowerBI, Microsoft Azure Cloud.

Functional Skills : Transportation Manager, Supply Chain Management , Logistics procurement, Freight Auction Analytics.

• Project lead, lead analyst and a developer. Worked very close with the stakeholders for the requirement gathering.
• Design of the warehouse with respect to Retail module.
• Development of the ETL mappings using Informatica and assigning to my team members.
• Development of simple to complex reports using report studio.
• Performance tuning of the reports on the large datasets.
• Created complex dashboards using Workspace.
• Mentoring the younger team members on their activities.
• ETL testing automation.

Tools Used: SQL Server, Oracle, Informatica PowerCenter, Cognos, SSAS.

Functional Skills : Transportation Manager. Supply Chain , Logistics Procurement.

• Developed robust BI solutions for automation, analysis and data integration activities. Worked extensively on ETL mappings and Cognos modelling and reports.

• Worked on different assignments in field of data warehousing and business Intelligence both in house and on-site