Venkatachalam K 📊📈 Email & Phone Number

Salt Lake City, Ut, Us

San Mateo, California, United States

Salt Lake City, Utah, United States

Salt Lake City, Utah, United States

Salt Lake City, Utah, United States

• Preparation of procurement data in Collaboration with the Business Intelligence Team • Data extraction, Transformation, wrangling using Alteryx workflows (ETL pipelines).• Created interactive dashboards with KPIs & insights in PowerBI on health care product prices and vendor performances

Salt Lake City, Utah, United States

Worked as Teaching assistant in Business statistics course, managing two section of students (120) assisted them in projects using the statistics concepts such as inference, hypothesis testing, logistic and linear regression, A/B testing etc.

Tiruchirappalli, Tamil Nadu, India

• Managed a team of BI developers and Data integration engineers in implementing end to end BI solutions.• Collaborated with clients and stakeholders to understand their business needs and requirements, and translate theminto technical specifications for BI solutions.• Demonstrated proficiency in writing, understanding, and debugging complex SQL statements, utilizing SQL to createad hoc queries, views, and SCDs. Proficient in Python for data analysis, adept at handling and analyzing complexdatasets, and generating meaningful visualizations.• Carried out data analysis and business intelligence initiatives, extracting, transforming, and loading data from diversesources, including SQL databases, flat files, and cloud storage. Processed various data types (JSON, XML, CSV, IOT).• By analyzing large sales and financial data (SAP HANA & Sales force data) in MS SQL Server and SSRS, presentedactionable insights and sales growth opportunities that increased sales revenue by 15% ($60 million to $70 million).• By conducting root cause analysis (RCA) using advanced analytics regression and developing SQL queries in SQL MSserver to analyze operations data, presented insights on operational inefficiencies& increase productivity by 10%.• Used SQL and Python to analyze total warehouse inventory of 1200+ varieties of materials, identified $2 million inpotential cost savings, and developed data-driven insights in Tableau to improve inventory management by 15%• Drove efficient data analytics and reporting solutions by designing and implementing Dimensional Modeling with StarSchema, resulting in a 30% improvement in data retrieval.• Teamed up with technical experts to create comprehensive BI documentation including data dictionaries.

Tiruchirappalli, Tamil Nadu, India

• Proficient in debugging complex T-SQL/MySQL statements. Have an experience in integrating and pulling data via REST and third-party API’s• Proficient in designing, creating, validating, and constructing ETL pipelines within SSIS and Azure Data Factory.• Worked with SAP developers to ingest data (sales, production, and financial transaction data) from SAP HANA, SDR, PLM into ADLS on a daily basis and orchestrate the data movement to Snowflake using ADF pipelines.• Expertise in the Microsoft Business Intelligence stack, including SSRS, SSIS, SSAS, query analyzer and profiler.• Experience in Azure stack (Azure Data factory, Synapse analytics, Azure Data Studio, Storage Accounts, Key Vault, Logic Apps, Dedicated SQL Pools, Spark Pools)• Expertise in Git, CI/CD tools and practices for automating the development and deployment of data pipelines• Supported for implementation of data governance policies and procedures to ensure the quality and security of the data.

Masters In Business Analytics, Business

Bachelor Of Engineering (B.E.), Electrical And Electronics Engineering, 8.9

Associate’S Degree, Mathematics, 9.49

High School, Distinction