Nitika Chauhaan

Associate Consultant

London, England, United Kingdom6 yrs experience

Most Likely To Switch

Key Highlights

Top 10 Employee recognition at Downing
Led digital transformation of reporting systems
Saved over 1,000 hours through automation

Stackforce AI infers this person is a Data Analyst with expertise in Finance, Healthcare, and Power industries.

Contact

Skills

Core Skills

Data AnalysisMicrosoft AzurePower BiSqlTableauNetwork Analysis

Other Skills

Adobe PhotoshopAutoCADAzure SynapseCYMECognosDevOpsGoogle AnalyticsIBM Cognos AnalyticsJenkinsMicrosoft ExcelMicrosoft OfficeMicrosoft Power BIMySQLPostgresSQLPython

About

With a strong foundation in portfolio management and over 5 years of experience in data analytics, I specialize in transforming complex data into strategic business insights. My expertise spans the healthcare, finance, and power industries, where I have honed my skills in Microsoft Azure tools such as Azure Blob Storage, Azure Synapse Analytics, Azure DevOps, Python, SQL, Power BI (DAX) and SAP. I focus on optimizing data pipelines, automating workflows, and enhancing reporting systems to support portfolio analysis and business intelligence. Having completed a Master's in Data Analytics from the University of Strathclyde, I thrive in collaborative environments, working closely with stakeholders across functions to bridge the gap between technical solutions and business needs. I develop data-driven strategies that enhance operational performance and drive business outcomes. My passion for continuous learning and innovation keeps me at the forefront of emerging technologies in the data space.

Experience

Downing

Portfolio Analyst

Jan 2024 – Present · 2 yrs 2 mos · London, England

As a key member of the data team, I focus on automating reporting processes and developing efficient data systems using Power BI, SQL, Azure Synapse, DevOps and Python scripts.
I have collaborated with the Downing renewable development team (DRD) to create a system for seamless data storage and reporting automation, leading to significant improvements in operational efficiency.
Key Achievements:
Recognized as one of the Top 10 Employees at Downing in my first year for outstanding contributions and performance.
Led the digital transformation of the reporting system, automating manual processes and delivering detailed Power BI dashboards.
Saved over 1,000 hours so far by streamlining reporting processes through automation, greatly enhancing team productivity.
Develop and implement Python scripts, integrating APIs to automate data workflows, improving efficiency and data accuracy.
Design and optimize SQL tables to support robust data architecture, ensuring smooth integration for reporting and analysis.
Collaborate with cross-functional teams, including the renewable development team, to continuously improve system performance.

Microsoft ExcelData AnalysisMicrosoft OfficeSQLMySQLPython (Programming Language)+1

Apollo 24|7

Data Analyst

Sep 2021 – Jul 2022 · 10 mos · Hyderabad, Telangana, India

Worked as a part of core Data Analytics team which works closely with the CXOs, Product Managers, Marketing, sales and operations team.
I have worked on following data driven projects and empowered decisions making across different verticals.
Engineered the whole process of product tracking with Product and Tech team to analyse the performance of the product using python scripted google sheet tracker which automatically updates at every 5 minute interval.
Created a pharmacy and diagnostics dashboard which highlights the complete infographics of booked, delivered and cancelled orders on daily basis which is further utilised for obtaining useful insights
Built several reports using PostgresSQL for the marketing and sales team to help them in tracking discount coupons, chronic diseases, generated revenue etc.
Helped Business and Operations team in laying out their plans by understanding their business needs and goals and accordingly built scripted reports to satisfy their requirements.
Trained and managed a team of 2 Data Analyst and 3 interns to provide end to end solutions throughout organisations

TableauMicrosoft ExcelData AnalysisMicrosoft OfficeSQLMySQL+3

Tata power-ddl

Network Analyst

Mar 2019 – Sep 2021 · 2 yrs 6 mos · Delhi, India

Designed 15+ network schemes for improving system reliability and load enhancement in 4+ zones
Evaluated technical feasibility of 5+ new connections and load enhancement of 10MVA (approx) for all consumer segments
Conceptualised mitigation plans by assessing technical losses in Model Town district to save INR 1+ mn in FY19-20
Resolved 25+ cases of high voltage complaints from the consumer end based on consumer meter voltage data
Spearhead HVDS Planning for 70+ Distribution Transformers by utilizing assets to save INR 1+ mn in capex
Bagged 3rd position for Overall performance in Youth Power Confluence (YPC) for ET/MT Batch in 2018-19

Microsoft ExcelData AnalysisMicrosoft OfficeSQLAutoCADPython (Programming Language)+5

Hindustan wellness

Technical Analyst

Jun 2018 – Dec 2018 · 6 mos · Gurugram, Haryana, India

Developed and implemented 2 interfaces of CRM modules for improving the system work efficiency of sales and laboratory group
Analysed and interpreted healthcare package data to identify market trends, patterns and opportunities for the business and clients
Conducted customer data analysis to derive top packages requests by performing database defragmentation and clustering using SQL queries

Microsoft ExcelData AnalysisMicrosoft OfficeSQLSAP PM Module