THOTA DILIP
Hebbal, Bengaluru, Karnataka-******; Phone: 730-***-****; Email: ************@*****.***;
https://www.linkedin.com/in/thotadilip/
CAREER OBJECTIVE
To pursue a challenging career in Data Science and Analytics Domain in an organization that gives scope to enhance my knowledge, skills and reach pinnacle in the computing and data analytics field with sheer determination and hard work. SKILLS
Power BI Tableau
SQL Python
Excel Power Query
Data Analysis Data Modelling
DAX ETL Tools
Problem Solving Logical Thinking
PROFESSIONAL EXPERIENCES
Epsilon India, A Publicis Groupe Company, Bengaluru. Business Operations Analyst 2, Nov 2022 -Present
In my current role as a member of the Data Management team, I am responsible for automating the data flow process and developing and delivering Power BI dashboards.
I defined multiple key metrics and created a comprehensive end-to-end data model & developed executive Power BI dashboard for management to provide critical business insights.
Developed the complex Client Dashboard in Power BI from scratch which shows the data at Client level, Vertical level, Product level & region level for Finance, Sales, People & Delivery Metrics
I automated the T3 data and Job ID reports using Python, providing valuable insights to the project team for efficient resource allocation.
Played a key role in Migration of existing excel dashboard to Power BI.
I designed and delivered the Smart Tab Sales Tableau Dashboard for our TD Bank client.
Established the Power BI environment and facilitated dashboard access through an app, ensuring streamlined and convenient accessibility.
Automated Smart recruitment data using Python, defined various metrics, and developed a Power BI dashboard
Developed RTO dashboard using Power BI & automated the data source integration with Snap Logic
I consistently ensured the delivery of dashboards with a high level of data accuracy and established a standardized process for their regular refresh.
Developed the Jira dashboard using the rest Api’s as data source & scheduled to auto refresh using gate way
Automated the Manual Data manipulation & Data Cleaning processes using Python.
I am responsible for scheduling reports using SAP BusinessObjects and managing updates and modifications to existing reports.
Hinduja Global Solutions/ Sagility, Bengaluru.
Business Analyst Projects, May 2021 -Nov 2022
In my role as a Business Analyst Projects with HGS - Hinduja Global Solutions, I am accountable for providing advanced Visualisations, Analytics and Data Science support through solution development and integration of Analytics with IT products.
Played a key role in Development & delivering of end-to-end OAP Dashboard in Tableau.
Involved in Development & Delivering of Amplifai Dashboard in Tableau.
Worked on Development of Power BI dashboard for HR Analytics
Involved in writing business requirements and proposed solution for the Vendor and Stake holders.
Interacting with development and testing team to explain them new requirements.
Involved in final inspection of the new changes before UAT release to ensure quality.
Automating the Entire data flow process from Manual csv files to the data lake.
Playing crucial role in data collection, data study and integrating of manual S3 files by interacting with the development Team and stake holders.
Worked as consultant in Handling of the data issues & UI issues post implementation of Project through service desk process.
Expertise In doing the RCA to find the permanent solution to the data issue in project.
Creation of different S3 buckets in AWS to collect the data from the client.
Expertise in doing the UAT after the standardization of data to find the accuracy of data flow in the data lake.
Cleaning and analysing the data Using Python received from the client to calculate the performance of agent Under different Metrics.
Working with Hinduja Global Solutions under the Healthcare Digitization domain to enhance employee life experience (ELC) across different stages of the employee lifecycle.
Developed multiple dashboards for the WFM Team Using the Power BI and Excel.
Writing of SQL Queries in order to automate the data governance Process. Intellicrats Info Solutions Pvt Ltd, Kukatpally, Hyderabad. Trainee Cad Engineer, November 2018 – May 2020
Development & Publishing of sales reports to the Management
Record the beam load data in the MS Excel sheets and Analyze the data along with the past data.
Written the RFA and BFA regarding the missed information of the beam strengths varying loads to help the production team.
Worked as key resource between the client and the management in completion of the project. ACHIEVEMENTS & AWARDS
Received Magnitude Award in Epsilon for playing a key role in development of Client Dashboard & delivering it with in the timelines.
Achieved consecutive GEM (Going Extra Mile) awards for outstanding performance over two consecutive quarters in Epsilon.
Rewarded as Top gun in Sagility for the development of AmplifAI Project in faster phase.
Received Top Performer in Intellicrats info solutions for playing a key role in BI Analytics projects. EDUCATION
Kamal Institute of
B.Tech Technology & Science 69.5% 2014-2018
Intermediate
K.N.R. Junior
82.5% 2012-2014
X M.K.R. Model High School 8.3 2011-2012