SOM SHEKHAR
Data Analyst
Bengaluru
Overview
7
7
years of professional experience
6
6
years of post-secondary education
Work History
Senior Data Analyst
Accenture
Bangalore
08.2021 - Current
- Client: Amex & BHP
- Developed a real-time Snowflake Monitoring Dashboards for instant insights into database performance
- Collaborated with stakeholders to define key performance indicators and optimize system oversight
- Delivered documentation for seamless integration and usage guidelines
- Enhanced troubleshooting efficiency, reducing incident response time
- Managed diverse Snowflake instances and large datasets for thorough monitoring and analysis of cost incursion
- Utilized Power BI for dynamic, user-friendly dashboards tailored to client needs
- Client: Fedex & JPMC
- Designed an Accelerator tool to discover on-premises database and provide information through interactive dashboards to facilitate Data migration
- Achievement Analysis shows around 60% of tables are unused, and just consuming space
- Provided a detailed analysis of Metadata for the Teradata environments using Power BI dashboards
- Developed analysis documents for consideration of compatible items & key points during migration from source to target
- Worked with Petabytes of data, and 1000+ databases & 300K+ objects for volumetric analysis
- Client: Kemper & UHG
- Designed an Accelerator tool for efficient on-premises database discovery, facilitating Data Migration, Data Supply Chain Modernization, and Performance Optimization initiatives through interactive dashboards
- Successfully reduced Data Discovery phase timeline by 50%, allowing more time for in-depth analysis
- Managed large datasets and over 100 instances for volumetric analysis
- Utilized Power BI to deliver comprehensive Metadata analysis for databases
- Developed scripts for Oracle Exadata and SQL Server database assessment, creating Power BI dashboards for effective presentation of migration-related facts in Cloud migration
- Produced an analysis document outlining compatible items and key considerations for migration from source to target.Client: Accenture Internal
- Worked with Data Discovery tool for comprehensive analysis of client data landscape
- Contributed to the Core Data Engineering team, specializing in developing a Cloud Migration Accelerator tool for recommending and facilitating the transition to the Cloud
- Conducted in-depth assessments of existing solutions and infrastructure for seamless cloud migration
- Formulated migration strategies based on thorough analysis and executed application and data migration activities
- Implemented scalable, high-performance hosting solutions, integrating private and public cloud technologies to meet the demands of modern corporate and digital applications
- Executed legacy infrastructure transformation and migration to enhance business outcomes for the next generation.
- Stakeholder: Accenture Internal
- Worked with Data Discovery tool for comprehensive analysts of client data landscape.
- Contributed to the Core Data Engineering team, specializing in developing a Cloud Migration Accelerator tool for recommending and facilitating the transition to the Cloud.
- Conducted in-depth assessments of existing solutions and infrastructure for seamless cloud migration
- Formulated migration strategies based on thorough analysis and executed application and data migration activities.
- Implemented scalable, high-performance hosting solutions, integrating private and public cloud technologies to meet the demands of modern corporate and digital applications.
- Executed legacy infrastructure transformation and migration to enhance business outcomes for the next generation
Sr. Compliance Associate
Amazon
Bangalore
12.2019 - 11.2023
- Evaluate Amazon Marketplace products using the built-in tool, adhering to predefined rule rationales.
- Stakeholder: Amazon Internal
- Independently create or contribute to the development of performance metrics
- Manage and conduct maintenance, backups, and security protocols for development databases
- Engage in integration, performance, and UAT for Business Intelligence solutions
- Offer technical support for troubleshooting reports
- Collaborate with developers to enhance custom-built applications.
Power BI Developer
PC Solutions Pvt. Ltd
DELHI
03.2019 - 11.2019
- Client: McDonalds for Global geographies
- Coordinated with Project manager to collect the requirements, design documents
- Developed multiple dashboards related to Sales Growth Analysis
- Business Overview, Pricing, Customer Analytics, Segmentation Analysis
- Resource Management using Power Bl
- Client: Love's Travel Stops
- Coordinated with Project manager to collect the requirements, design documents.
Analyst
URS CERTIFICATIONS PVT. LTD
DELHI
08.2017 - 03.2019
- Developed multiple dashboards for Vendor Management related to
- Sales, Product Management, Category Management using Power BI.
Education
B.Tech - Electronics and Communication Engineering
05.2013 - 08.2017
Conduct safety and quality testing for electrical and electronic equipment.
Analyze provider trends in samples, utilizing Bl Reports to optimize company
performance.
Generate, distribute, and evaluate employee performance reports.
Collaborate in the development of audit schedules, working with the Audit
Manager to address audit-related issues.
12th -
01.2012 - 01.2013
10th -
01.2010 - 01.2011
Skills
Power BITableau
Snowflake
SQL
AzurePower AutomatePowerAppsPython
Machine LearningCertification - PL300
Certification - AZ900
Timeline
Senior Data Analyst - Accenture
08.2021 - Current
Sr. Compliance Associate - Amazon
12.2019 - 11.2023
Power BI Developer - PC Solutions Pvt. Ltd
03.2019 - 11.2019
Analyst - URS CERTIFICATIONS PVT. LTD
08.2017 - 03.2019
Manipal University - B.Tech, Electronics and Communication Engineering
05.2013 - 08.2017
Hariyana Vidya Mandir - 12th,
01.2012 - 01.2013
Bharatiya Vidya Bhavan - 10th,
01.2010 - 01.2011