Bhagya Lakshmi Patnam
Senior Data Analyst
Bengaluru
Summary
Accomplished Senior Data Analyst with a proven track record at Ecolab and Accenture, specializing in data visualization and analytics. Expert in Azure Synapse and Power BI, demonstrating strong problem-solving skills and a commitment to excellence. Certified in Azure Fundamentals and Power BI Data Analyst, showcasing both technical proficiency and effective knowledge sharing.
Overview
9
9
years of professional experience
4
4
Certifications
Work History
Senior Data Analyst
Ecolab
01.2021 - Current
- Understanding requirements in gathering and creating respective visualizations needed.
- Based on the discussion, DAX and M code are implemented to showcase it on the reports.
- Scheduling and Monitoring: Scheduling refresh reports.
- Based on the failure notifications, fixing the issues.
- Integrated data from CRM to Snowflake.
- Took ownership in repointing report source from SQL to Snowflake, dealing with its challenges. Also provided knowledge sharing sessions to global users.
- Hands on Azure Synapse to enable new entity from CRM to Snowflake and its functionalities.
- Monitoring Azure portal on creation of parquet files for delta runs and ADF Pipelines on data mismatches.
Senior Software Engineer
Accenture
10.2017 - 10.2020
- Interacted with end-users to collect requirements and acquire the necessary domain knowledge to become a subject matter expert.
- Responsible for developing and building the Reports/Dashboards and deploying them into the Power BI service.
- Responsible import, reshape, and model the data.
- Responsible, create reports, and visualizations.
- Responsible, create workspaces and apps to share your insights.
- Responsible for importing data from Azure and building the dashboards as per the requirement.
- Responsible for scheduling the dashboards according to frequency (daily, weekly).
- Responsible for providing the RLS security.
- Maintaining and supporting the reports on the Production Server.
Software Engineer
Accenture
05.2015 - 09.2017
- Understanding the Business and its Requirements.
- Involving in creating packages in SSIS Designer using various Control Flow Tasks and Data Flow Transformations to implement Business Rules.
- Used for Loop Container, For Each Loop Container, Sequential Container, and Control Flow Tasks like Execute SQL Task, send mail Task, Execute Process Task, Execute Package Task, File System Task, Script Task, Execute Package Task, and the Data Flow Task.
- Creating tabular, matrix, drill-down, and drill-through reports using SSRS.
- Involving in creating various Drill Down, Drill Through reports, and Sub-Reports as per business requirements.
- Created SP and views and provided fixes at the time of issues.
- Responsible for providing the RLS security.
Education
Bachelor of Technology - EEE
JNTU Anantapur
04.2001 -
Skills
SQL
Snowflake
PSQL
DAX
SSRS
SSIS
Power BI
Certification
• AZ- 900 Microsoft Certified Azure Fundamentals
Timeline
Senior Data Analyst
Ecolab
01.2021 - Current
Senior Software Engineer
Accenture
10.2017 - 10.2020
Software Engineer
Accenture
05.2015 - 09.2017
Bachelor of Technology - EEE
JNTU Anantapur
04.2001 -
Similar Profiles
Clinton JohnsonClinton Johnson
CDL Class A Driver at EcolabCDL Class A Driver at Ecolab
Paul McCartneyPaul McCartney
Facility Care Technical Account Manager at EcolabFacility Care Technical Account Manager at Ecolab
Telladevarapally Phaneendra SharmaTelladevarapally Phaneendra Sharma
Intern at EcolabIntern at Ecolab