SQl
Sandeep Singh
Senior MIS(BI)
Gurgaon,India
Summary
- Detail-oriented and motivated with a proven record of accomplishment of success and employer satisfaction in developing sales performance metrics, creating new strategies, and assisting in client acquisitions. 4.5 years’ professional experience and having technical background worked on the development and implementation of new business performance metrics,conducted comprehensive competitor analysis, and identified potential business opportunities.
Overview
4
4
years of professional experience
5
5
years of post-secondary education
Work History
Senior MIS(BI)
Aditya Birla Fashion and Retail PVT LTD
Gurgaon, India
12.2021 - Current
- Configured and implemented IT initiatives to produce measurable business value and Data creation,Data extraction and Data updating over the DB.
- Developing and automating the report and required data related to process improvement by using SQL and power BI.
- Used statistical methods to analyze data and generate useful business reports.
- Developed tables, views and materialized views using SQL.
- Developed and led large-scale technology initiatives for long-term strategic plans and solutions.
- Collaborated with IT Application team for application automation and server connection to inter linked tables and data set.
- Created optimal technical solutions to user needs with in-depth system analysis.
- Established working relationships across various departments to understand existing and emerging IT requirements.
- Visualization of reports to the top management from sql to Power BI.
- Helping the team for NSV (MTD, YTD) reports via power BI and excel with daily and weekly follow-up with stores sales team.
- Tested data prediction algorithms based on historical data.
Senior MIS Analyst
Home Credit India Finance Pvt Ltd
Gurgaon, India
02.2018 - 12.2021
- Planned and designed system improvements to meet changing demands.
- Worked with development team to define and implement customer change requests to enhance product functionality.
- Installed improvements and adjusted parameters to optimize functionality.
- Offered input for complex documents to support client-ready final versions.
- Collaborated with upper management to drive strategy and implement new processes.
- Good understanding of the complexities of the Sales process and environment, including direct experience of the sales function and behaviors.
- Date extraction with SQL query, Data cleaning with using Advanced excel and Data visualization by using Power BI.
- Worked on KPI’s Report (Sales, Revenue, Profits and Returns etc...) on daily basis and monthly basis.
- Managed and send DSR (Daily Sales Reports) to the manufacture and partners over the mails.
Education
Bachelor of Engineering - Computer And Science
The Technological Institute of Textile And Science
Hisar 05.2013 - 12.2017
Skills
Reports for senior management
Programming documentation
Automation design
Statistic analysis
Information gathering
Data Modeling
Decision Making
Google Workspace
Software
Power BI
Oracle Business Intelligence Suite Enterprise Edition
Advance Excel
PowerPoint and Microsoft WordPad
SAP
Additional Information
SQl and data analytical using Data module certification from DAX lab Gurgaon (2018).
Timeline
Senior MIS(BI)
Aditya Birla Fashion and Retail PVT LTD
12.2021 - Current
Senior MIS Analyst
Home Credit India Finance Pvt Ltd
02.2018 - 12.2021
Bachelor of Engineering - Computer And Science
The Technological Institute of Textile And Science
05.2013 - 12.2017