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

A Hardware & Networking

Data Analysis

AutomationBusiness ObjectsData management

Tableau

Business Object

Decision makingEnglishFinance

VBA Macros

ExcelPower pointOptimizationPythonSQL Server

Data formatting

Data validation

Search Engine Optimization

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

Similar Profiles

CREATE PROFILE
Lekhraj SinghData Analytics/ MIS Reporting