Kiran Kumar K S
Bangalore
Summary
Insightful Lead Data Analyst known for high productivity and efficient task completion. Skilled in data visualization, statistical analysis, and predictive modeling to deliver actionable insights. Excel in communication, problem-solving, and teamwork to exceed project goals. Committed to leveraging analytical skills and collaborative approach to drive organizational success.
Overview
12
12
years of professional experience
Work History
Lead Data Analyst
Ecolab Digital Center
Bangalore
09.2023 - Current
- Involved in Migration of moving Source from SSAS to PowerBI Dataset
- Collaborating with cross-functional teams, providing guidance, and ensuring the successful execution of Migration
- Involved in production support Involves identifying the root cause and fixing it for smooth Transition of subscriptions which involves rerunning ADF Jobs
- Involved in optimizing the slow performance reports
- Involved in crating SSRS Data Driven subscriptions
- Initiated to develop Reporting Catalog, Data Dictionary for the project
- Created PowerBI report for Business Analysts to track subscription which we send on daily basis also provides the insights on deliver trend ETC
- Created a Power Automate flow which sends the notification the Teams when we receive a failure Alerts
- Created a Dashboard to track the efforts on on-call support which helps decision making and provides insight on focus areas
- Created a Power Automate flow that automatically blocks Teams calendar when any Team member in on leave
- Which includes Approval being sent to manger alongside an email to all the Team members on the unavailability on Out of office
- Secured 1st place in Bi-Level 2 Certification program
- Performed ETL using Fabric such as transforming raw source files into a usable format for analytics purposes.
- Demonstrated strong problem-solving skills, resolving issues efficiently and effectively.
- Prioritized and organized tasks to efficiently accomplish service goals.
Advisory System Analyst
IBM
Bangalore
08.2021 - 09.2023
- Involved in the analysis of the requirements and gathering requirements for the project
- Analyzing different data sources
- Database design of Development and Staging area
- Created SSIS packages by using different data Transformations like Derived Column, Lookup, Conditional Split, Merge Join, Merge, Union, Sort and Execute SQL Task to load into Database
- Involved in creating databases, Tables, Unique/Check Constraints, Views, Stored Procedure, and their relationship in the data warehouse
- Developed various ETLs to upload data to DB on daily basis
- Involved in performance tuning of queries for query efficiency
- Migrated 50+ reports from SSRS to PowerBI and PowerBI Paginated Report
- Involved in deployment of SSIS packages and created jobs using SQL Agent
Consultant
Sonata Software
Bangalore
07.2019 - 08.2021
- Database design of Development and Staging area
- Analyzing different data sources
- Created SSIS packages by using different data Transformations like Derived Column, Lookup, Execute SQL Task, FTT (Cozy Roc Component), to load into Database
- Writing SPs to cleanse the data
- Creating package to drop files on to SharePoint location
- Improving the performance of the Store procedure as well as the packages
- Monitoring the ETL jobs
Senior Data Analyst
Sonata Software
Bangalore
06.2017 - 03.2019
- Analyzing different data sources and crating Data Lineage Documents
- Creating Tabular model and modelling according to the project needs
- Creating simple pipelines in ADF
- Creating Slicers based on requirements
- Involved in performance tuning of Packages
- Involved in deployment of Power BI Desktop to Power BI services
- Monitoring gateways and working on Ad-hoc Change Requests
- Written Complex DAX calculation as per the requirement to maintain business measures
- Worked on report permissions and dashboard permissions to provide access to different users
- Used Quick insights to get various types of visuals to match the requirements
- Worked on improving performance in iPad
Software Engineer
Theorem India Pvt Ltd
Bangalore
04.2014 - 06.2017
- Involved in the analysis of the requirements and gathering requirements for the project
- Involved in creating databases, Tables, Unique/Check Constraints, Views, Stored Procedure, and their relationship in the data warehouse
- Project involves complete uplift and re organizing data warehouse with an additional data source to Increase the optimization to ensure proper delivery of business needs
- Developed various ETLs to upload data to DB on daily basis
- Involved in performance tuning of queries for query efficiency
- Production support on Go-Live activities and Job Monitoring
Trainee Software Engineer
ProEmTech Infosystems Pvt.Ltd
07.2013 - 12.2013
Skills
- MSBI (SSIS, SSRS, and SSAS)
- Power BI
- Data visualization
- ETL processes
- SQL querying
- DAX calculations
- Performance tuning
- Data analysis
- Data integration
- Fabric
- Power Bi Datasets
Timeline
Lead Data Analyst
Ecolab Digital Center
09.2023 - Current
Advisory System Analyst
IBM
08.2021 - 09.2023
Consultant
Sonata Software
07.2019 - 08.2021
Senior Data Analyst
Sonata Software
06.2017 - 03.2019
Software Engineer
Theorem India Pvt Ltd
04.2014 - 06.2017
Trainee Software Engineer
ProEmTech Infosystems Pvt.Ltd
07.2013 - 12.2013
Similar Profiles
Shaiby JosephShaiby Joseph
Salesforce QA Lead | at Ecolab Digital CenterSalesforce QA Lead | at Ecolab Digital Center
CHARAN KUMAR GAJULACHARAN KUMAR GAJULA
Snowflake DevOps Engineer at ECOLAB Digital CenterSnowflake DevOps Engineer at ECOLAB Digital Center
ADHNAN MANZISADHNAN MANZIS
SOFTWARE ENGINEER at Ecolab Digital CenterSOFTWARE ENGINEER at Ecolab Digital Center
Raghu Vamsi MRaghu Vamsi M
Associate Manager- Finance at Reverie Language Technologies LimitedAssociate Manager- Finance at Reverie Language Technologies Limited
Shwetha AgarwalShwetha Agarwal
Artist Manager at Nineone IncArtist Manager at Nineone Inc