Divyanjay Singh

Operations Associate

Mumbai, India12 yrs 7 mos experience

Most Likely To SwitchAI ML Practitioner

Key Highlights

Over 8 years of experience in data analytics.
Led cross-functional teams in complex data projects.
Expertise in SQL and Python programming.

Stackforce AI infers this person is a Data Analytics professional with a strong focus on Fintech and Business Intelligence.

Contact

Skills

Core Skills

Data AnalyticsTeam LeadershipData VisualizationBusiness InsightsBusiness AnalyticsData InsightsBusiness AnalysisProject ManagementData EngineeringData AnalysisBusiness IntelligenceData Management

Other Skills

Agile Project ManagementAgile WorkflowAirflowAmazon AthenaApache AirflowArtificial Intelligence (AI)AutomationBusiness DevelopmentBusiness StrategyCRMCascading Style Sheets (CSS)ComplianceCritical ThinkingCustomer Relationship Management (CRM)D3.js

About

I am a seasoned data analytics professional passionate about leveraging data-driven insights to drive business growth and innovation. Throughout my career, I've had the privilege to lead and collaborate with cross-functional teams, building reporting infrastructures, and solving complex data problems for startups and MNCs. With over 8 years of experience in data analytics, I've held key roles across various domains including Financial Services, credit risk and mutual funds, and E-commerce for healthcare and real estate. In these roles, I've honed my skills in business and product analytics, reporting and insights generation, leadership, team management, and project delivery. I have supported businesses both as an individual contributor and as a leader, transitioning through roles from customer support to MIS executive, to business analyst, and currently as a Manager of Data Analytics. Throughout these roles, I've initiated and led projects involving complex business analysis, reporting and dashboard development, data cleansing, transformation, and analytics infrastructure improvement. My expertise lies in SQL and Python programming, complemented by proficiency in tools such as Tableau, D3.js, Jupyter Notebook, Airflow, GitHub, AWS S3, Amazon Redshift, and Microsoft Excel.

Experience

12 yrs 7 mos

Total Experience

3 yrs 1 mo

Average Tenure

8 yrs 1 mo

Current Experience

Payu

3 roles

Manager Data Analytics

Promoted

Jun 2022 – Present · 4 yrs · On-site

Managed org-level Data Insights team by recruiting, and training data engineers, analysts, and BI developers.
Impact: Dedicated SME support for Finance, Sales, Risk, and Product teams.
Established a portfolio of 50+ critical tableau dashboards, 30+ Metabase queries, and 6 airflow cron jobs for various business verticals. Impact: Dedicated ownership rendering Data Integrity and Compliance.
Curated analytics projects to investigate trends and generate business insights. Impact: key recommendations in business strategy and decision-making.
Enhanced support for stakeholders by leveraging agile workflow, setting up on-call support, creating handbooks, and cross-training resources. Impact: Reduction of overall TAT by 30%
Reduced context sharing and QA time by assigning individual projects for growing necessary Data engineering and development skills within the team. Impact: Increased self-sufficiency and efficiency by 80%
Represented data team in 10+ internal and external audits from RBI and private companies, provided documentation and ad-hoc support related to org-level reporting.
Provided dedicated support for Finance in 5 Direct Assignment projects with data related to ad-hoc analysis, and complex reporting. Impact: 100% on-time resulted in successful transactions of over Rs760 M portfolio.

Data InsightsTableauMetabaseAirflowData IntegrityCompliance+3

Senior Business Analyst

Promoted

Apr 2020 – Jun 2022 · 2 yrs 2 mos · On-site

Took initiatives in optimizing reporting infrastructure and worked on several analytics projects in collaboration with risk team.
Supported Analytics and reporting for 2 major business ventures (Cross Sell & API lending) right from ideation phase to going live by doing data churning, funnel reporting over excels, building metabase dashboards and eventually deploying TTD dashboard on tableau.
Performed detailed product comparison analysis for SMS based income interpretation by collaborating with product and data science team and comparing inhouse data model and vendors in the market.
Helped new Product managers, by writing a document that simplified complex of a critical code piece which was responsible for >60% drop in funnel.
Solved challenges of policy team referring data scattered across multiple tables and excel files by designing and orchestrating a data pipeline to store different versions and models of risk scores in one table by using airflow, python, and redshift database, which decreased the TAT for risk scores related asks by 50%.
Managed all central reporting using 2 resources (tableau dev and data engineer) by focusing on task prioritization and project management, it involved handling Tableau developments, airflow cron jobs for reporting, data warehouse management and ad-hoc reporting across multiple verticals.
Reduced overall SLA breaches by 20% and handled scaling challenges by initiating and prioritizing routine code optimization tasks in existing reporting infrastructure.
Supported analytics projects for policy team by working on critical problem statements like low-income segmentation, DTI cuts, reject inference analytics.
Supported product by collaborating on projects like fraud user database and policy coding for partner lending.

Reporting InfrastructureData ChurningFunnel ReportingMetabaseTableauData Pipeline+2

Business Analyst

May 2018 – Apr 2020 · 1 yr 11 mos · On-site

Learnt python, GitHub, Jupyter notebook, pandas, airflow, JavaScript, d3.js and implemented the knowledge by setting up basic reporting infrastructure with cron jobs and html-based dashboards.
Established first centralized funnel report to summarize org level customer journey performance metrics using on Metabase using SQL.
Enhanced the same with additional metrics using data from cross-DB connections using Python, HTML and D3.js
Built 3 dashboards on HTML and JavaScript with python code as backend.
Created and Automated Partner lead reporting for 50+ partners using Airflow scheduled python code.
Pioneered weekly headlines encouraging data awareness among engineering teams, by publishing handcrafted weekly insights on emails using Jupyter notebooks.
Established Clarity on Attribution by building first Data warehousing solution in the org by creating data pipelines on redshift using Airflow.
Established customer lifecycle and risk assessment visibility by building TTD dashboard by designing and building Datawarehouse solution that can optimally store customer lifecycle data along with and 70+features.
Established insights by preparing 4 Business insight Documents that shed light on individual aspects of funnel along with quick interactive dashboards on google sheets.
Promoted DB knowledge and associated business context to 15+ new joiners at the time of company merger

PythonGitHubJupyter NotebookPandasAirflowJavaScript+3

Aegis limited

Assistant Manager - Business Analytics

Oct 2017 – Apr 2018 · 6 mos · Mumbai Metropolitan Region

Analysing Customer behaviour trends and optimising the resources to enhance customer experience.

Care24

Buisiness Process Analyst

May 2016 – Sep 2017 · 1 yr 4 mos · Mumbai Metropolitan Region

# Creating hourly, daily , weekly,monthly reports for individual departments.
# Fetching data from the system and sending to the stakeholders in an understandable
and interactive format.
# Analyzing BI tools that serve the purpose of all the data requirements in the company
and automate the data services.
# Minimize the time taken by anyone who does data transactions by automating the work.
# Successfully understood the data structure and taken over the responsibility to serve all
the data requests by all the departments of the company within a short time span of 3 months.
# Introduced auto refreshing customizable reports with the help of google spreadsheets
# Learnt HTML and CSS and currently learning Javascript as an additional skill to get closer to
the goal of creating an information repository for all accross the company.
# Explored and created reports on BI tools like Yellowfin, Klipfolio, pentaho,slemma,tableau etc
# Initiated and built several dashboards for many critical process from scratch..

Housing.com

3 roles

MIS Executive

Apr 2015 – May 2016 · 1 yr 1 mo

# Established an awareness of analytical importance in strategic advancement
# Direct reporting to functional head and strategically tackled problems faced on the floor
# Automating every report to provide real time analysis of the performance
# Created systems that highlighted areas of action
# Calculating Incentives and coordinating with the Payroll and finance department.
# Providing training to Customer Service Representatives on MIS and other data-related processes
# Creating data structures which can support dynamically changing processes and
generate reports
# Successfully managed making reports for more than 200 employees to the Operations
and Payroll since in the position
# Gained SQL knowledge and understood Database management by practically learning from
the data and have corrected and rewritten most of the report generating queries in the system
# Maintained a healthy employee Database Management System and Leave Management System
# Aligned single report across all verticals and maintained hassle-free daily updation
# Initiated many interactive dashboards to Agents, Tls , Managers to check performances at
all levels
# Successfully structured Quality Analysis process
# Strengthened the data structure with maximum utilization of Google spreadsheets

Assistant Team Lead

Promoted

Jan 2014 – Apr 2015 · 1 yr 3 mos

Process–Lead Generation – ▪ 2014, Jan –Feb. Process manager –Mrs.Kavita Ganesh
# Lead a team of 5 fresh CSRs with a pilot process. Managed their productivity and roster
Experimented on data assigning and reporting
# Presented a complete detailed report to give complete analysis about the process to the
upper management
Process–Lead Generation, ▪ 2014, Feb-June– Process manager – Mr. Shrey Jain
# Worked on a team of 32 CSRs for scaling up the target and breaking it
# Learned Excel, charts and report making
# Developed Team handling skills.
Process–Outbound, ▪ 2014, June-March-Process Manager –Mr. Saurabh Baggaru
# Lead different teams with variable CSR Counts and various Processes
# Won Team Battles 4 times
# Won Star Team Leader Batch twice
# Learned working on SQL queries and worked on database and generated reports
# Made DAR sheet (Data analysis Report)
# Developed Team Spirit and enthusiasm within self

CSR

Aug 2013 – Dec 2013 · 4 mos

Role–CSR – ▪ 2013, August–2013, December. Process manager – Mrs. Ganesh
# Worked on various Types of calling (Outbound, Inbound, Cold calling, Target based calling)
# Lead a small project of lead management of a team of 6 CSRs
# Generated leads single handedly for a new pilot process
# Created a presentation on optimizing the usage of Google Chrome for all the employees
# Learnt Google forms and trained all the colleagues. Also created a backup for the
Backend application which reduced the dependency on the Tech
# Awarded with the Champ Of the Month title for sept 2013
# Learned the skills of convincing, remaining calm and focused in pressurized situations
# Had Been selected for a single unit Pilot process
# Was promoted to ATL within first 5 months of carrier