Summary
Overview
Work History
Education
Skills
Accomplishments
Projects
Work Availability
Timeline
Hi, I’m

GAYATRI GAUTAM

Data Analyst Cum Software Engineer
Bhopal
There is a powerful driving force inside every human being that, once unleashed, can make any vision, dream, or desire a reality.
Tony Robbins
GAYATRI GAUTAM

Summary

Proactive Sr Data Analyst cum Data Engineer with 8+ years product management experience in small start-up business environments. Effective driver of product development lifecycle from concept to delivery. Communicative and collaborative with proven history of improving business operations to support corporate growth and revenue.

Overview

9
years of professional experience
5
years of post-secondary education

Work History

Johnson & Johnson

Sr Data Analyst Cum Data Engineer
10.2021 - Current

Job overview

  • Analyzed large amounts of data to identify trends and find patterns, signals and hidden stories within data.
  • Leveraged text, charts and graphs to communicate findings in understandable format.
  • Used business objects, business intelligence and other reporting tools to extract data from data solutions and data warehouses.
  • Working on Time series Analysis and prediction modeling.
  • Performed root-cause analysis on data-related system problems to recommend or execute corrective action.
  • Interpreted business questions and collaborated with engineering teams to identify data sources.
  • Identified, reviewed and evaluated data management metrics to recommend ways to strengthen data across enterprise.
  • Updated and developed scripts and queries to extract and analyze data from multiple sources.
  • Deployed predictive analytics models to forecast future trends.
  • Collaborated on ETL (Extract, Transform, Load) tasks, maintaining data integrity and verifying pipeline stability.
  • Designed and developed analytical data structures.
  • Communicated new or updated data requirements to global team.
  • Prepared documentation and analytic reports, delivering summarized results, analysis and conclusions to stakeholders.
  • Documented and communicated database schemas using accepted notations.
  • Designed data models for complex analysis needs.

Eagle Constructions GWL

Sr Analyst
08.2020 - 07.2021

Job overview

  • Investigated system issues and implemented resolutions to reduce downtime.
  • Performed system analysis, documentation, testing, implementation, and user support for platform transitions.
  • Validated results and performed quality assurance to assess accuracy of data.
  • Cultivated relationships with industry leaders and within company to share tips and information.
  • Conducted workplace compliance training to reduce liability risks and operate effectively.
  • Performed budget analysis to control expenditures and predict future budget needs.
  • Guided acquisition process to capture projected cost and revenue synergies and move combined organization forward.
  • Identified and resolved problems through root cause analysis and research.
  • Queried databases for information needed for report processing.
  • Performed audits of subsidiaries to protect shareholders and potential investors from fraudulent or unrepresentative financial claims.
  • Created data models to support decision-making processes.

Tata Communication LTD

Analyst
12.2015 - 06.2020

Job overview

  • Investigated system issues and implemented resolutions to reduce downtime.
  • Performed system analysis, documentation, testing, implementation, and user support for platform transitions.
  • Validated results and performed quality assurance to assess accuracy of data.
  • Cultivated relationships with industry leaders and within company to share tips and information.
  • Optimized core processes to improve business performance and operational agility.
  • Conducted workplace compliance training to reduce liability risks and operate effectively.
  • Performed budget analysis to control expenditures and predict future budget needs.
  • Guided acquisition process to capture projected cost and revenue synergies and move combined organization forward.
  • Identified and resolved problems through root cause analysis and research.
  • Recommended process improvements to continually identify, analyze and fix constraints and challenges.
  • Queried databases for information needed for report processing.
  • Identified clear connections between policies and business results to eliminate or reduce confusion and help employees achieve goals.
  • Assessed data modeling and statistics to integrate high-level business processes with data rules.
  • Developed and maintained data warehouses and data marts to support business operations.
  • Identified patterns and trends in large data sets and provided actionable insights.
  • Utilized data visualization techniques to present and explain complex data sets.
  • Deployed predictive analytics models to forecast future trends.
  • Developed complex dashboard and reporting tools to track business performance metrics.
  • Collaborated with stakeholders to identify business needs and data sources.
  • Analyzed data to identify root causes of problems and recommend corrective actions.
  • Created data models to support decision-making processes.

Infosys

Sr Process Analyst
01.2015 - 11.2015

Job overview

  • Pinpointed cost-effective process improvements through simulation of potential process alterations, discovering optimal enhancements without interrupting live production efforts.
  • Produced documentation outlining process improvement solutions.
  • Performed quality assurance checks on transactions and account actions to assess Market compliance

Education

IST College

Master of Science from Computer Science
04.2001 - 04.2011

BSSS Bhopal
Bhopal

Bcom Computer from Computer + Commerce
04.2001 - 04.2019

Scaler Academy
Online

ML & AI Advance Level Training from ML AI
04.2001

Skills

Latest skill Spark-SQL,Data-bricks Py-Spark,confluence,JIRA,ADF,storage Synapses, ADF pipeline,Logic appundefined

Accomplishments

  • 2 RNR Award 2015,2017
  • 3 Appreciation mail from client end
  • 4 Performance Bonus
  • Best Employee of the Year certification from company (2020)
  • 4 Appreciation mail from client end in Kelvin project

Projects

Johnson & Johnson, Oct-2021 till date, Sr Data Analyst Cum Data Engineer, Johnson & Johnson is the world’s largest healthcare products company, J&J distributes pharmaceutical and medical products to retailers, wholesalers, health care professionals and hospitals; and offers consumer products through retail outlets and distributors. The company offers its products in the US; Europe; Asia-Pacific and Africa; and Latam countries, Emea countries etc. The Vaccine Project Object is to manage Covid-19 vaccine resources to protect people, from the world’s most challenging and wide-reaching infectious diseases like COVID-19. High volume, fast turn freight solutions that can help reduce transit times and improve delivery performance & save people life to protect millions of people around the world, and continuously to focus on ensuring the vaccine is available for people most in need. Kelvin is an Intelligent Business Performance Management Platform, that has smart dash boards to start with and can reach to essential depth from each metric. Provides Targets, Alerts and Exception management with harmonized front end. Kelvin holds metrics from all areas of supply chain (plan, source, make and deliver). Project Kelvin helps to standardize and harmonize all the available metrics across streams. Kelvin Project Object Single source for all metrics across supply chain areas. (Plan, source, make and deliver) Re-structured front end. Visualization is uniform, making it easy to consume. Not just a dashboard, but is smarter with Targets, Alerts and Exception Management. Actionable events can be triggered. Ability to root causing and jumping to respective actions. Ability to comment over the metric, those can be viewed and answered by other users. Action Management and tracking Integration with other existing control tower tools and business performance. Tools. Metric correlation – ability to identify/trigger action on connected and impacted metrics. 

MP Road Development Corporation ltd (MPRDC), Aug-2020 to July-2021, Sr Data Analyst,MPRDC- State Highway Authority by Govt. of Madhya Pradesh With prime responsibility of developing entire network of State Highways, National Highways and Major Dist. Road repair, develop, improve, operate and maintain the roads, highways, express highways, bridges, culverts embankment, sideways, subways, flyovers, tunnels, railroads, multi - modal transport systems and infrastructure, models and complexes in India (MDR) through “public - private partnership" scheme and others being developed under the regular contract scheme others being developed under the regular contract scheme. The project object is to find State wise Progress & Target Achievements through Real time Dashboard by use of Tools & technique (Power Bi & Tableau) & Track the Cost & performance State wise to improve the quality Road Network.

 Tata Tele services ltd, Sep-2019 to June-2020, Circle Data Analyst (MPCG), TTSL- It is one of India’s leading mobile telecom service providers delivering mobile connectivity and services to consumers across the country. The company has been at the forefront of redefining the telecom experience in India, launching innovative products and services, playing an enabling role in simplifying consumer lives and expanding digital inclusion. It is the first private telecom operator to launch 3G services in India in November 2010. Over the years, Tata Tele services  Limited has been a key driver of the telecom revolution in the country. In non-voice services, the company through its wide range of pioneering offerings such as e-Governance, Machine to Machine (M2M) and m-Remittance (m-Rupee) services, has helped in improving citizen services, public safety and governance. The project object is to improve Circle Wise Performance analysis & Target Achievements through Real time Dashboard and story board by use of Tools & technique through IOT Device and connect with multiple sources like SQL, Excel, Sap Hana, and PBI to improve customer Service with Zero Escalation. 

Tata communications ltd, 12/2015 - 08/2019, Data Analyst (MPCG),  TCL- A digital transformation of enterprises globally, including 300 of the Fortune 500 – unlocking opportunities for businesses by enabling border less growth, boosting product innovation and customer experience, improving productivity and efficiency, building agility and managing risk. With its solutions orientated approach, proven managed service capabilities and cutting-edge infrastructure, Tata Communications drives the next level of intelligence powered by cloud, mobility, Internet of Things (IoT), collaboration, security and network services. Tata Communications carries around 30% of the world’s internet routes and connects businesses to 60% of the world’s cloud giants and 4 out of 5 mobile subscribers. The Company’s capabilities are underpinned by its global network, the world’s largest wholly owned subsea fibre backbone and a Tier-1 IP network with connectivity to more than 200 countries and territories. Tata Communications Limited is listed on the Bombay Stock Exchange and the National Stock Exchange Tata Communications has been a part of the rich heritage of the internet in India. The project object is to find Circle Wise, Individual, city and Local area wise Performance & Target Achievements through Real time Dashboard and story board by use of Tools & technique through IOT Device and connect with multiple source like SQL, Excel, Sap Hana, PBI, Tableau to improve the performance of the circle and help management to take data driven decision.

 CISCO, Feb-2015 to Nov-2015, Senior Process Analyst, Excel, PBI, and SQL, The project object is to handle financial escalation of the client by extracting PBI report and performing direct query in SQL to get better insight resolution on Commission.

Availability
See my work availability
Not Available
Available
monday
tuesday
wednesday
thursday
friday
saturday
sunday
morning
afternoon
evening
swipe to browse

Timeline

Sr Data Analyst Cum Data Engineer

Johnson & Johnson
10.2021 - Current

Sr Analyst

Eagle Constructions GWL
08.2020 - 07.2021

Analyst

Tata Communication LTD
12.2015 - 06.2020

Sr Process Analyst

Infosys
01.2015 - 11.2015

IST College

Master of Science from Computer Science
04.2001 - 04.2011

BSSS Bhopal

Bcom Computer from Computer + Commerce
04.2001 - 04.2019

Scaler Academy

ML & AI Advance Level Training from ML AI
04.2001
GAYATRI GAUTAMData Analyst Cum Software Engineer