Saketh Checka
Verified Expert in Engineering
Software Developer
Johnstown, ON, Canada
Toptal member since September 28, 2021
Saketh is a business intelligence analyst and analytics consultant with five years of experience. He loves to dig into data, find patterns, and make elegant visualizations; he's passionate about creating, scaling, and optimizing organizational reporting that matters. Saketh also enjoys exploring tools and technologies related to databases, ETL, and visualizations. He's looking forward to meeting his clients' needs by building the best products for them and their organizations.
Portfolio
Experience
- SQL - 10 years
- Python - 8 years
- Excel 2013 - 5 years
- Microsoft Power BI - 5 years
- Microsoft Power Automate - 4 years
- Azure - 3 years
- Python 3 - 3 years
- PySpark - 1 year
Availability
Preferred Environment
Python 3, Microsoft Power BI, SQL, PySpark, Databricks, Azure, Apache Superset, Python, Amazon Web Services (AWS), Amazon QuickSight
The most amazing...
...thing I've automated is a reporting process across various departments that saved 100+ hours a day in manual work.
Work Experience
Business Intelligence Engineer
Amazon Advertising
- Developed a dashboard that shows the relationship between different account types and user interactions in advertising the Amazon.com console. Built ETL to get data for the report in Redshift and internal Amazon tools.
- Implemented CI/CD for ETL jobs. Onboarded more than 150 jobs to the CI/CD platform.
- Created stored procedures in Redshift to load data that are used for multiple reports.
Data Engineer
The Argus Group
- Analyzed cloud resource usage and optimized resources and schedules to generate $24,000 in annual savings.
- Reengineered processes in Azure to utilize economies of scale that saved over $100,000 annually in outsourcing costs.
- Owned the development of a GDPR-compliant data hub in Azure using DataBricks (PySpark) and Azure Data Factory.
- Launched a data operation center in PowerBI that shows the data lineage, integrity, and quality of the data hub.
- Ensured organization-wide data integrity by building ingestion data pipelines using data from multiple systems.
- Automated complex business requirements using Power Automate, including capturing survey responses from Microsoft Forms, updating ServiceNow tickets, updating SQL Server table when an email is received or sent, and sending emails with a list of issues.
- Used Power Automate to capture data that updates 600 times/min and is written back to SQL Server table, which is further used for analysis and reporting in PowerBI.
Business Intelligence Analyst
Argus Group
- Revamped data pipelines using indexing and SQL performance tuning, reducing the data refresh time by more than 90%.
- Collaborated with technical and non-technical teams to identify business and research requirements, leading to various KPIs and reports development.
- Worked with various support teams to develop metrics and KPIs that helped reduce resolution time by approximately 50%.
- Developed and implemented data solutions for various teams on multiple projects that resulted in overall cost savings or performance improvement.
- Created and maintained Power BI reports and dashboards that are used daily by over 500 people.
- Developed SSRS reports and automated them to send receipts, payments, and invoices, saving around 50,000 yearly in paper and postal expenses.
Analytics Consultant
Lumeris
- Created reporting processes for finance, claims, customer service, and other departments to track their KPIs and SLAs.
- Created a reporting system in SSRS to automate report generation and eliminated manual report creation.
- Saved more than 100+ hours on a monthly basis by automating the risk adjustment process.
Experience
Senior Data Analyst
Performance Management
Power BI Developer
Education
Master's Degree in Industrial Engineering
University of Minnesota - Minneapolis, MN, USA
Bachelor's Degree in Mechanical Engineering
Amrita Vishwa Vidyapeetham - Coimbatore, Tamil Nadu, India
Certifications
Microsoft Certified: Azure Data Fundamentals
Microsoft
AWS Certified Developer – Associate
Amazon Web Services
CKAD: Certified Kubernetes Application Developer
The Linux Foundation
AWS Certified Cloud Practitioner
Amazon Web Services
Exam 70-778: Analyzing and Visualizing Data with Microsoft Power BI
Microsoft
Tableau Desktop Specialist
Tableau
Skills
Libraries/APIs
PySpark, ODBC
Tools
Microsoft Power BI, Microsoft Excel, Excel 2013, Tableau, Jira, Amazon QuickSight, AWS Glue, Amazon Athena
Languages
SQL, Python 3, Python, Snowflake, SAS
Paradigms
ETL, Business Intelligence (BI), Dimensional Modeling
Storage
Databases, SQL Server 2016, Data Pipelines, Azure SQL, SQL Server Reporting Services (SSRS), Microsoft SQL Server, Redshift, Data Integration
Platforms
Azure, Microsoft Power Automate, Databricks, Amazon Web Services (AWS), Kubernetes, Docker, Windows
Other
Data Warehousing, Reports, Reporting, Data Visualization, Dashboards, Data Analytics, Star Schema, Data Transformation, Data Modeling, Data Engineering, Data Build Tool (dbt), Azure Data Factory (ADF), Teams, Excel 365, Data Structures, Apache Superset, Data Analysis, Analytics
How to Work with Toptal
Toptal matches you directly with global industry experts from our network in hours—not weeks or months.
Share your needs
Choose your talent
Start your risk-free talent trial
Top talent is in high demand.
Start hiring