Yaswanth Karanam
London,ON
Summary
Nearly 5 years professional experience in data analysis and data visualization through Power BI and SQL. Solid background in data analysis and business intelligence. Known for translating complex data sets into actionable business insights and contributing to strategic decision-making processes. Demonstrated expertise in statistical analysis and data visualization. Known for reliability, analytical thinking, and results-driven approach. Skilled in Python, SQL, and Excel, ensuring robust data solutions and strategic recommendations.
Overview
5
5
years of professional experience
Work History
Data Analyst and BI Developer
Versilia Solutions Limited
11.2022 - Current
- Improved decision-making processes with accurate data analysis and visualization techniques.
- Enhanced business efficiency by identifying trends and patterns in complex datasets.
- Reduced manual reporting efforts by creating self-service dashboards for various user groups.
- Been part of every month's P&L meeting to monitor KPI's as well as any aspect in the P&L varying month by month and YTD performance.
- Integrated multiple sources of disparate data into cohesive datasets using ETL processes, improving overall analytic capabilities.
- Forecasting coming months or financial year performance when we decide to make any changes to business operations and presenting to team leaders or clients how it affects business.
- Responsible for maintaining inventory in warehouses, forecasting requirements according to market and seasonality.
- Using Python to migrate data and doing transformations from FTP servers to SharePoint, which are in turn used as a source for Power BI reporting.
- Performing predictive and statistical analysis to measure the performance in coming months or years.
- Produced monthly reports using advanced Excel spreadsheet functions.
- Implemented robust control measures to improve analytical output reliability.
BI developer and Analyst
Audela
09.2021 - 08.2022
- Working on Power BI dashboards such as making ad hoc changes to them, Data importing from SQL server or from other sources required by the client is my day-to-day activity.
- Skilled in identifying problems through data, defining ambiguous and complex problems, and solving problems.
- To demonstrate appropriate data analysis methods, made use of calculated columns and Measures queries in Power BI desktop.
- Supported end-users in understanding complex datasets through effective training sessions and documentation materials.
- Ensured data integrity by conducting regular audits, resolving discrepancies, and maintaining strict adherence to corporate security policies.
BI developer
AccuV
01.2020 - 07.2021
- Analyzing Data such as transaction data, finance, revenue and other aspects of P&L.
- By creating SQL scripts, accurately maintained, transferred, and processed data in several databases.
- Streamlined data analysis by implementing efficient BI solutions and tools.
- Wrote and optimized SQL statements to assist business intelligence practices.
- Prepared targeted documentation, specifications, and resources to analyze business data.
- Delivered actionable insights by automating data extraction, transformation, and loading processes.
Education
Master of Engineering -
Western University
London, ON10.2019
Bachelor of Engineering -
Gitam University
Hyderabad, India01.2018
Skills
- Microsoft Power BI
- Data visualization and presentations
- ETL processes
- Microsoft SQL
- Python programming
- Excel functions
- DAX queries
- Data Profiling, Data Mining and Validation
- Statistical Analysis
- Data warehousing
- Analytical problem solving
Timeline
Data Analyst and BI Developer
Versilia Solutions Limited
11.2022 - Current
BI developer and Analyst
Audela
09.2021 - 08.2022
BI developer
AccuV
01.2020 - 07.2021
Master of Engineering -
Western University
Bachelor of Engineering -
Gitam University
Similar Profiles
Alessio ViciniAlessio Vicini
Receptionist at Versilia Lido, UNA EsperienzeReceptionist at Versilia Lido, UNA Esperienze
George MakGeorge Mak
Production Manager at Q Base Solutions Limited / Q Concept LimitedProduction Manager at Q Base Solutions Limited / Q Concept Limited
Richardo KersherRichardo Kersher
Licensed Bailiff at Reality Solutions Limited. Various Law Firms. Supreme Court Of Trinidad And Tobago. R. C. L LimitedLicensed Bailiff at Reality Solutions Limited. Various Law Firms. Supreme Court Of Trinidad And Tobago. R. C. L Limited
Thiik KuotThiik Kuot
Student Council Treasurer at John Paul II Secondary SchoolStudent Council Treasurer at John Paul II Secondary School
John GrahamJohn Graham
Dietary Aide at Westmount GardensDietary Aide at Westmount Gardens