ANUP KUMAR SINGH
Gurgaon
Summary
Senior Data Analyst with over 3 years of experience in Power BI, SQL, and data modeling, specializing in the development of robust data pipelines and ETL processes. Achieved significant milestones by delivering scalable data solutions for Fortune 100 companies using SQL, Databricks, and Python. Proficient in advanced analytics, data visualization, and performance optimization to enhance operational efficiency. Committed to utilizing analytical expertise to foster data-driven decision-making within a forward-thinking organization.
Overview
8
8
years of professional experience
Work History
Senior Data Analyst
Teleperformance Global Services Private Limited
Gurgaon
07.2022 - Current
- Partnered with stakeholders to refine reporting requirements, ensuring reports met their needs.
- Developed and maintained interactive dashboards and reports using Power BI tools and the Power Platform.
- Designed data models by understanding business requirements, transforming them into meaningful insights.
- Collaborated with cross-functional teams to gather requirements, identify data sources, and ensure data accuracy and integrity.
- Performed advanced data modeling and statistical analysis to identify key trends.
- Identified key performance indicators (KPIs) and developed performance measurement frameworks to monitor business performance.
- Identified opportunities for process improvement, automation, and optimization of data analysis workflows.
- Established relationships between data sets and developed tabular and multidimensional data models.
- Designed entity-relationship diagrams to represent the logical structure of databases, detailing entities, attributes, and relationships.
- Implemented row-level security (RLS) on data and comprehended application security layer models in Power BI Service.
- Demonstrated strong knowledge of Data Lake, Data Warehouse, and Data Mart.
- Configured gateway services for Power BI Desktop to optimize data connectivity and ensure seamless report generation.
POWER BI DEVELOPER
Sakshath Technologies
New Delhi
10.2021 - 06.2022
- Created visual reports, KPI scorecards, and interactive dashboards with Power BI Desktop.
- Connected to multiple data sources.
- Developed custom visual reports and published them on the Power BI service.
- Specialized in data modeling, pipelines, warehousing, and visualization.
- Documented DAX formulas, algorithms, parameters, models, and relationships for clarity.
- Developed business-specific charts and calculations.
- Facilitated cross-segment collaboration with NBFC, FMCG, and HR management.
- Skilled in managing database systems using SQL and Azure Cloud.
- Partnered with stakeholders to recognize and integrate essential data streams.
- Developed tabular and multidimensional models using DAX queries and measures, ensuring compliance with data warehouse standards.
ANALYST
Origo Commodities India Pvt Ltd
Gurgaon
07.2019 - 05.2020
- Ensured continuous project updates and improvement by working closely with Price and Warehouse capacity teams.
- Developed key performance indicator-based dashboards for price and warehouse capacity analysis.
- Monitored outstanding payments on a monthly basis.
- Monitored and flagged clients exceeding credit limits, ensuring compliance with margin requirements.
- Identified opportunities for business growth by analyzing utilization patterns of warehouses across various states.
- Prioritized warehouses with higher expenses relative to revenue for enhanced sales efforts and client acquisition
- Managed data loading from development systems to staging environments
- Created various visualizations using Power BI Desktop, published reports to Power BI Service, and shared dashboards with users
- Power BI Features: Proficient in drill down, drill through, bookmarks, tooltips, Power Query, Power Pivot, and DAX functions
- DAX Expertise: Developed visualization reports using Power BI, utilizing custom columns, calculated columns, and measures using DAX
- Forecast Analysis: Developed custom visuals to analyze historical commodity prices alongside current prices, facilitating loan amount estimations for clients
SENIOR RESEARCH ANALYST
Penguin International
Gurgaon
01.2017 - 07.2019
- Business Cycle Analysis: Analyzed client project business cycles using data mining techniques and conducted various generic data research tasks
- Data Extraction and Cleaning: Extracted data from diverse sources and performed thorough data cleaning tasks to ensure data accuracy before updating databases
- Company Profiles: Prepared comprehensive company profiles including business descriptions, diversified segments, products & services, key facts, management team, financial trends, and competitive analysis
- Presented findings to clients
- Quarterly and Annual Reports: Compiled and analyzed quarterly and annual reports for sectors such as IT, FMCG, Oil & Gas, including SWOT & PEST analysis
- Sector-Specific News Articles: Authored concise news articles on sectors like FMCG, Retail, Consumer Durables, and E-commerce
Education
MBA - Marketing & Finance
Indus Business Academy
Greater Noida, India05.2013
Bachelor Of Applied Science - Computer And Information Sciences
Genius Institute Of Information Technology
Jamshedpur, India06.2007
Skills
- Visualization tool – Power BI
- Database Managment - SQL
- Cloud - Azure Cloud, ADF, Databricks
- Data Engineering Tools: Data modeling, ETL/ELT, Data Pipeline
- Familiar - Python
Languages
- English, Advanced (C1)
- Hindi, Advanced (C1)
Timeline
Senior Data Analyst
Teleperformance Global Services Private Limited
07.2022 - Current
POWER BI DEVELOPER
Sakshath Technologies
10.2021 - 06.2022
ANALYST
Origo Commodities India Pvt Ltd
07.2019 - 05.2020
SENIOR RESEARCH ANALYST
Penguin International
01.2017 - 07.2019
MBA - Marketing & Finance
Indus Business Academy
Bachelor Of Applied Science - Computer And Information Sciences
Genius Institute Of Information Technology
Similar Profiles
Dinakaran SambathDinakaran Sambath
Team Leader at TELEPERFORMANCE GLOBAL SERVICES PRIVATE LIMITEDTeam Leader at TELEPERFORMANCE GLOBAL SERVICES PRIVATE LIMITED
DEEPIKA KATARIADEEPIKA KATARIA
Customer Care Executive at Teleperformance Global Services Private LimitedCustomer Care Executive at Teleperformance Global Services Private Limited
Vivek SinghVivek Singh
Assistant Manager Finance and Operations Accounting at Teleperformance Global Services Private LimitedAssistant Manager Finance and Operations Accounting at Teleperformance Global Services Private Limited