Summary
Overview
Work History
Education
Skills
Certification
Software
Microsoft Excel, Tableau, SQl Server, Python, Visual basic Macro
Hobbies
Work Availability
Timeline
Lekhraj Singh

Lekhraj Singh

Data Analytics/ MIS Reporting
Ambernath West,Maharashtra
There is a powerful driving force inside every human being that, once unleashed, can make any vision, dream, or desire a reality.
Tony Robbins

Summary

Perceptive and logical data analyst with proven ability to communicate with both technical professionals and end users to identify and translate business requirements. Offering 5 years of experience driving data accuracy and integrity. Proven ability to build and lead teams of talented professionals to develop valuable process solutions to meet business objectives.

Overview

1
1
Language
4
4
Certifications
17
17
years of post-secondary education
5
5
years of professional experience

Work History

Senior Data Analyst

Star India Pvt Ltd
Lower Parel, Maharashtra
09.2019 - 03.2020
  • Preparing, reports and research analysis for Bank.
  • Working in the environment of Data gathering, design and creating dashboards and reports.
  • Preparing customer ratings report of different channels by extracting data from different platform.
  • Feeding the data into the software with TV shows name, timing and various information.
  • Have worked on Google analytics for extraction of data for different geographical location and use that data in reports.
  • Analyze Internal Metrics and performance data & recommend solutions for decision making.
  • Have worked on BI tools like Power BI,Python for better and error free output.
  • Automation of reports using macros and excel formulae's.
  • Analyze new reports & opportunities, Manage and enhance projects through proactively participation in process.
  • Taking initiative in the team & helping co-ordinates to get the work done quick & efficiently.

Data Analyst

Eduvanz Financing Pvt Ltd
Marol, maharashtra
03.2019 - 08.2019
  • Performed system analysis, documentation, testing, implementation and user support for platform transitions.
  • Produced Daily,monthly and weekly reports using advanced Excel spreadsheet functions.
  • Evaluated consistency and importance of different business intelligence data against needs to determine optimal courses of action.
  • Recommended data standardization and usage for protection of data integrity.
  • Synthesized current business intelligence data to produce reports and polished presentations, highlighting findings and recommending changes.
  • Developed database objects, including tables, views and materialized views using SQL.
  • Identified and documented project constraints, assumptions, business impacts, risks and scope exclusions.
  • Corrected any data entry error to prevent later issues such as duplication or data degradation.

Associate Manager

Netafim Agricultural Financing Agency
01.2018 - 01.2019
  • Preparing MIS reports,Dashboards, Adhoc reports on regular basis and as per the request.
  • Preparing multiple number of letters with the help of mail merge in MS word and drafting the letters to the loan applicants
  • Calculating the EMI's paid and pending of loan applicants with the help of Advance Excel formulas
  • Sending remainder to applicants via Email with excel attachment regarding the payment of EMI in advance
  • Automation of reports with the help of VBA code are done for error free and less time consumption
  • Scheduling the meetings of all the sales manager for making discussion and strategy for improving the collection from the market
  • Keeping the track of applicants document and sending important updates to them through telephone and emails
  • Creating automation in system for making the entry of applicant details to reduce the duplicate entry or errors.
  • Maintaining the MIS report of all the sales manager and their performance for monthly and quarterly review.
  • Creating ratings report of all the managers as per their performance and sending it to higher management and HR team.

Assistant manager

MIS
Turbhe, Maharashtra
12.2015 - 02.2017
  • Creating the MIS reports,Dashboard on daily, weekly basis as per the specified formats.
  • Have good experience on preparing Power point presentation as per the requirement.
  • Have good knowledge on working of Tableau tool for data representation and visualization of the reports.
  • Extraction of data from tools like Sql server, Business Object to implement on the report
  • Preparing adhoc reports as per the request of higher management
  • Communicating with Pan India managers about their daily performance report for creating the report on daily basis.
  • Using VBA tool for automation of report and time saving of reports.
  • Planned team-building exercises to increase employee performance and job satisfaction.
  • Helped with planning schedules and delegating assignments to meet coverage and service demands.
  • Conducted weekly staff meetings to motivate staff members, address concerns and questions, plan improvements, and evaluate progress toward goals.

Data Analyst

Eclerx Services ltd
Airoli, Maharashtra
03.2011 - 06.2013
  • Working in the environment of Data gathering, design and creating dashboards and reports.
  • Have good command over data management by using finest tools like Excel SQL Server 2005 & MS-Access database.
  • Have good experience on preparing Power point presentation as per the requirement.
  • Have good knowledge on working of Tableau tool for data representation and visualization of the reports.
  • Automation of reports which are daily,weekly & monthly basis with the help of visual basic application to reduce errors in report.
  • Analyze new reports & opportunities, Manage and enhance projects through proactively participation in process.
  • Taking initiative in the team & helping co-ordinates to get the work done quick & efficiently.
  • Communicating with Clients/officials on E-mails, chats and telephone calls to have a smooth run of projects effectively
  • Prepare report as per the requirement of Senior managers on urgent basis
  • Provide training to new joiners to make familiar with the process

Education

MBA - Finance

Dr. V.N Bedeker Institute Of Management Studies, Thane
05.2013 - 06.2015

B.com - Commerce

R.K Talreja College, Ulhasnagar
05.2007 - 07.2010
  • Graduated with first class from Commerce backgroung.

High School Diploma -

S.I.C.E.S College, Ambernath
04.2005 - 05.2007

Schooling -

Madansingh Manvirsingh Memorial High School, Ambernath
05.1995 - 06.2005

Skills

    Data Visualization

undefined

Certification

Diploma in software Engineering (Gniit)

Software

Excel, Vba, Sql Server, Business Objects,Tableau,Power BI, Python

Microsoft Excel, Tableau, SQl Server, Python, Visual basic Macro

  • Expertise in Microsoft excel by creating KPI dashboard by using formulas,Pivot table,Pivot Charts for representation of data.
  • Good in working with large volume of data with proper tools and technique to get the better output from the raw data
  • Have good command over Sql server for Extraction and manipulation of data from the database and use that data into reports
  • Have worked on Google analytics for extraction of data for different geographical location and use that data in reports.
  • Have good experience on preparing Power point presentation on specified topics as per the requirement given by higher authority
  • Have used business intelligence Tableau tool for better visualization of data for good understanding of data
  • Automation of reports with the help of visual basic macro for time saving and error free reports
  • Worked with BI tools like Python for better optimization of data,Data efficiency,less time consumption and with one click authorization to the report
  • Analyze Internal Metrics and performance data & recommend solutions for decision making
  • Well versed in handling client and higher management with communication with telephone and email in regular intervals
  • Proper decision making skill helps to handle the difficult situation very effectively
  • Using Good techniques to solve the problem with quick resolution within the time frame
  • Constantly upgrading the skill to utilize it into the working hours so it that the task get completed before ETA.
  • Handling and working with the team members by proper co-ordination and planned manner so that works get finished in time
  • Good bonding and proper flow of information with team member so that the assigned task does not get hampered

Hobbies

  • Interest in playing Chess with friends and colleagues in free time
  • Exploring historic places and adventure trips with friends
  • Collecting the latest news about the upcoming Tech & gadgets

Work Availability

monday
tuesday
wednesday
thursday
friday
saturday
sunday
morning
afternoon
evening
swipe to browse

Timeline

Senior Data Analyst - Star India Pvt Ltd
09.2019 - 03.2020
Data Analyst - Eduvanz Financing Pvt Ltd
03.2019 - 08.2019
Associate Manager - Netafim Agricultural Financing Agency
01.2018 - 01.2019
Assistant manager - MIS
12.2015 - 02.2017
Dr. V.N Bedeker Institute Of Management Studies - MBA, Finance
05.2013 - 06.2015
Data Analyst - Eclerx Services ltd
03.2011 - 06.2013
Diploma in software Engineering (Gniit)
12-2010
A+ Course(Hardware & Networking)
06-2009
Tally
10-2007
Certification of MS Office 2007 Basics
07-2007
R.K Talreja College - B.com, Commerce
05.2007 - 07.2010
S.I.C.E.S College - High School Diploma,
04.2005 - 05.2007
Madansingh Manvirsingh Memorial High School - Schooling,
05.1995 - 06.2005
Lekhraj SinghData Analytics/ MIS Reporting