Business Intelligence Power Bi

THEEPEEKAA RAMAKRISHNAN SHANTHI

Charlotte, NC +1-815-***-**** **********@*****.*** LinkedIn

SUMMARY

Results-driven Data Professional with over 5 years of experience in driving profitability through strategic data analysis and cross-functional collaboration. Adept at coordinating and monitoring operations to deliver actionable insights that enhance business performance. Known for strong leadership abilities, strategic thinking, and commitment to elevate the quality of services and products. Passionate about leveraging data to solve complex problems and drive continuous improvement.

SKILLS

Analytical Tools: SQL, R, MS-Excel (Macros), Python, SAS, Alteryx

Database: MySQL, SQL Server

Web Analytics: Google Analytics, Adobe Analytics

IT Management: Scrum, JIRA, MS Office 365, Agile, Visio

Cloud and Warehouse: Snowflake, SAP Cloud Analytics

PROFESSIONAL EXPERIENCE

Certifications: Google Data Analytics, SAP S/4 HANA

ERP Application: SAP S/4 HANA

Visualization tools: Tableau, Power BI

Interpersonal skills: Communication (Written, Verbal), Leadership, Teamwork

Daimler Trucks North America, United States Data Science & Business Intelligence Generalist Feb 2023 – Present

Developed user-friendly Pricing Intel dashboard and gathered all data in one platform using Tableau and Power BI enabling the pricing team to determine cost, revenue, profit and margin% KPIs, resulting in an 8-days reduction in the 60-day-price book timeline.

Enhanced pricing governance impact KPI and part’s lifecycle dashboard to measure the PHC level components that boosted the data visibility by 93% for pricing managers.

Built pricing excellence models in Alteryx and a web scraping interface using Python to analyze global market trends and competitor truck parts pricing, resulting in a 76% profit margin.

Prioritized key objectives/goals & management/troubleshooting of critical issues in SAP HANA and teamed up with cross functional teams to come up with long term solutions to use the system effectively.

Collaborated with Pricing Managers to plan BI strategies, create BI road map and plans to address Enterprise level Business Intelligence needs.

Providing continued maintenance and development of bug fixes for the existing and new SQL and Power Bl Reports.

Cleaned up pricing logic data tables on quarterly basis to accurately track the calculations while having a sales deal, discount, and forex changes.

Generated pricing-related reports using SQL from SAP HANA and snowflake and performed improvement projects to eliminate time-consuming and manual tasks.

Conducted advanced statistical analysis using Python and R in the SAP cloud analytics to forecast market-driven pricing trends for top-selling parts, resulting in an additional $15M in revenue.

Northern Illinois University, United States Graduate Research Assistant Aug 2021 – May 2022

Optimized student’s assignments system by coming up with new challenges to perform statistical analysis using R, SAS, and Python.

Gathered business requirements and authored detailed problems documents along with clean data sets.

Cleansed large volume of datasets to frame problems and solutions for the class. Constructed Problems in T-SQL for Spring 2022 semester.

Launched a business school website using GitHub and HTML and posted business related articles. Tested analytics tags on web pages and validated data using Abode Analytics which increased 46% of user visits.

Coordinated with the professors in weekly meetings to evaluate the datasets as per the requirements to meet the business standards.

Wipro Limited, India Business Data Analyst June 2018 - Mar 2020

Leveraged MS-Excel to perform root cause analysis for double-time posting error between SAP HRP and Workday, and corrected 1 lakh employees’ project live status, filling 44% of project vacancies across India.

Transformed survey insights to analyze employee preferences by enhancing a new data to track and analyze the status using SQL, Python, and Tableau.

Coached a cross-functional team of 7 members for upgrading features using Python and Java, incidents across the project, ensuring rapid response to major incidents, early closure of the issues, and strengthening end-user experience.

Conducted weekly client connect on behalf of the team and discussed the issues faced by the client team to ensure client satisfaction.

Effectively Collaborated with the key business users for a change requests walkthrough to ensure clear understanding of the functionalities implemented.

PROJECTS

Chipline Startup Project – Electric Cars Data Research in India Apr 2020 - Dec 2020

Enacted data analysis based on customer preferences of electric/hybrid cars from company’s database and Kaggle resources by utilizing Power BI/Excel.

Liaised with key stakeholders from different data teams to understand the business requirements for executing current trend market analysis for cars using SQL.

Built monthly trend data and dashboards related to changes, incidents, and problems for clients and executive reporting using Tableau/Power BI. Conducted scope analysis to acknowledge the operational strategy implementation.

Documented the processes, data findings/insights, knowledge transfers, and recommendation. Added 60% value to initiate the project with end-to-end data analysis.

LKQ Heavy Truck, United States Student Consultant (Capstone) Aug 2021 - Dec 2021

Developed and implemented analysis of company’s website using Google Analytics tool, helping client improve SEO ranking, optimize content, improve organic search, organic keywords and improve user engagement.

Deployed social media analytics tools using Google analytics and audited existing platforms to aid social media strategies, branding opportunities, gain competitive intelligence and improve SEO ranking.

Spearheaded a team of 6 to analyze top 10 competitors’ profile and 5M rows data set related to customers for forecasting the customer experience metrics and SEO audit KPIs using Tableau, and Looker.

Authored a detailed report using SQL of the CX metrics and offered recommendations through BI visual dashboards for a sales effectiveness implementation by 43%.

EDUCATION

NIU – College of Business, Dekalb, IL

Master of Science in Management Information Systems (MIS) Jan’21 - Aug’22; GPA 3.6/4.0

Anna University, India

Bachelor of Engineering in Electronics and Communication Engineering Jun’14 - Apr’18; GPA 3.37/4.0

AWARDS AND HONORS SECTION

All-Star 2024 Award: Recognized for delivering exceptional performance and contributions within DTNA Pricing team.

Rookie of the Year 2024 Award: Honored for demonstrating excellence in daily responsibilities, generating measurable revenue gains, and contributing significantly to cross-functional continuous improvement projects within DTNA Aftermarket.

J&A Landgraf Student engageexp Scholarship: Honored with the cash award of 800$ for being active university and community engagement.

OMIS/MIS Esteemed Scholarship award: Awarded with 40% scholarship during my master’s degree for excelling in OMIS academics.

Contact this candidate