Lokesh Reddy Police

Advanced Analytics Intern

ABB•  May 2020 - Present

• I have contributed to developing an advanced analytics strategy for manufacturing, marketing, sales, and supply chain defined business cases. • Worked on Proof of Concept for a new project where I have analyzed the scope of Analytics to perform on the data available. • Applied predictive analytics algorithms like ARIMA Forecasting and NLP algorithms to perform text processing on the Inventory data. • Contributed in designing robust databases, creating data marts, ETLs, data analysis and reporting. • Created two dashboards which will get the data from a Cloud Datawarehouse and visualizes the data using Advance Analytics Visuals. • Worked on agile project framework, participated in daily SCRUM calls, and provided task updates.

Software Engineer

MAQ Software•  July 2017 - July 2019

Migrated two projects from on-premise to cloud. Developed tabular models from scratch which includes design, data load, creating measures, implementing partitions for faster data load. Implemented GDPR policies across six projects in the span of two months. Automated test cases that run periodically to ensure the correctness of data. Mentored juniors on how to analyze the data of different sources and guided them in development activities. Built an application to track job states, schedules, data flows. Job responsibilities include designing robust databases, data integration, creating data marts, ETLs, data analysis, and reporting. Worked on agile projects, participate in daily SCRUM calls, and provide task updates. Expertise in understanding the business domain in-depth and implementing the solutions using MSBI technologies. Customized interactive visualizations with business intelligence capabilities, where end users can create reports and dashboards by themselves. Certifications: 1. DP-200: Implementing an Azure Data Solution 2. AZ-203: Developing Solutions for Microsoft Azure 3. 70-768: Developing SQL Data Models 4. 70-767: Implementing a Data Warehouse using SQL 5. 70-778: Analyzing Data with Power BI 6. 70-761: Querying Data with Transact-SQL 7. 70-762: Developing SQL Databases 8. Data Warehousing for Business Intelligence Specialization 9. CS50 Introduction to Computer Science