Shivam Gupta

Data Analyst

Noida, Uttar Pradesh, India3 yrs 10 mos experience

Most Likely To SwitchHighly Stable

Key Highlights

Strong foundation in statistical analysis.
Proficient in SQL and Python for data tasks.
Passionate about continuous learning in data analysis.

Stackforce AI infers this person is a Data Analyst with a focus on SaaS and data-driven decision making.

Contact

shivam.gupta@dxc.com LinkedIn

Skills

Core Skills

Data AnalysisSql

Other Skills

Data VisualizationEnglishExcelMicrosoft ExcelPower BIPythonStatistical Data AnalysisWeb Content Writing

About

As a passionate and motivated data analyst, I am eager to take on new challenges and make a positive impact in the field of data analysis. With a strong educational background in data analysis and a solid foundation in statistical analysis, I am equipped with the necessary skills to effectively analyze data and derive meaningful insights. My passion for data analysis drives me to stay up to date with the latest tools and technologies in the field. I am always looking for ways to improve my skills and expand my knowledge, whether it's through online courses, workshops, or networking with other professionals. My attention to detail and ability to think critically make me a valuable asset to any team. I am dedicated to producing accurate and actionable insights that drive business growth and improve decision-making processes. I am excited about the opportunity to contribute my skills and expertise to a dynamic organization where I can continue to learn, grow, and make a difference. If you're looking for a hardworking and enthusiastic data analyst, I would love to connect and explore potential opportunities.

Experience

Dxc technology

2 roles

Data Analyst

Nov 2022 – Present · 3 yrs 4 mos · Noida, Uttar Pradesh, India · On-site

Analyze enterprise agreement.
Collaborated with finance and accounting teams to streamline reporting procedures and improve billing accuracy by 15%.
Excelled in Complex SQL scripting and the implementation of views in Oracle DB.
Utilized Python (Pandas and NumPy) to perform data cleaning, manipulation, and preprocessing tasks, ensuring data accuracy and consistency.
Cleaned and formatted raw data in Excel to prepare it for analysis, ensuring data integrity and accuracy.
Prepare an ad-hoc report for billing.
Develop SQL views in Oracle using Toad tool.
Monitor license utilization and help end customers fix / update orders.
Compiled data on premium, losses, and expenses to create reports used for budgeting and financial forecasting.
Develop Inventory Management Dashboards using Power BI.
Identified and rectified data inconsistencies, ensuring accurate sales revenue and license entitlements.

SQLStatistical Data AnalysisPythonExcelPower BIData Analysis

Data Analyst intern

May 2022 – Nov 2022 · 6 mos · Noida, Uttar Pradesh, India · On-site

Worked closely with Team Leads to understand and maintain focus on their analytical needs, including identifying critical metrics and KPIs, and deliver actionable insights to relevant decision- makers.
Creating a user-controlled sales dashboard in Microsoft Excel that analyses sales by product category for an e-commerce business.
Used SQL for database management and data analysis.
Using data munging and a range of visualization techniques to highlight essential business insights from a messy dataset.

SQLMicrosoft ExcelData VisualizationData Analysis