Summary
Overview
Work History
Education
Skills
Accomplishments
Projects
Hobbies and Interests
Languages
Timeline
Generic
Ravi Kumar Mahto

Ravi Kumar Mahto

New delhi

Summary

Meticulous and highly accomplished professional with 6+ years of experience in Data Analysis Reporting field .. To pursue a challenging career and be a part of progressive organization that gives a scope to enhance my knowledge and utilizing my skills towards the growth of the organization and to excel in this progressive analytics environment to my top potential.

Overview

7
7
years of professional experience

Work History

Analyst Programmer

Wipro
Gurugram
10.2022 - Current
  • Develop new or modify existing SAS programs to load data from the source and create study specific datasets
  • Co-coordinating with other support teams: Development, Operations, QA, Leads, etc
  • Perform validation on derived datasets by following the standard operating procedures during the validation process to check data accuracy
  • Extensive use of PROC SQL, PROC PRINT, PROC SORT, PROC FREQ to perform analysis of the datasets using queries, joining and altering tables using SAS EG
  • Implementation of Adhoc Requests and coding enhancements using various Functions like INPUT, PUT, SUBSTR, INDEX, SCAN, FIND, DAY, MONTH, YEAR, MDY, COMPBL, COMPRESS, TRIM, STRIP, SCAN, SUM,etc

IND Configuration Analyst II

Aon Consulting ltd.
Gurugram
10.2018 - 10.2022
  • Utilized ETL tool Pervasive (Actian) for establishing connections.
  • Generated various reports per requirement specifications.
  • Generated full files, change files, and summary reports.
  • Validated generated reports against predefined standards.
  • Supported the development of newer staff.

Data Analyst

GLobal Logic Technolgies Ltd.
Faridabad
11.2017 - 09.2018
  • Data segregation using crowdsource
  • Verify Entity :Deals with image Processing
  • Bounding Box:Deals in Product Processing
  • Triplet:Adjusting the document size and edges

Education

Master of Computer Application -

G.G.S.Indraprastha University
New delhi
07.2017

Bachelor of Computer Application -

G.G.S.Indraprastha University
New delhi
07.2014

Skills

  • SAS ODS
  • SAS/SQL
  • SAS Programming
  • PROC SQL
  • Excel
  • Base SAS
  • SAS Macros
  • Pervasive
  • Actian(v11)

Accomplishments

  • Converted to FTE within six months of contract period.
  • Got appreciation from onsite team.
  • Provided support to junior colleague.
  • Received Appreciation from Onsite Admin Team.
  • Received impromptu Award.

Projects

Total Benefit Solutions, Flex is a UK project which involves extracting of data from SQL Server excel reports and other flat files. Reports like Payroll, Summary and monthly election reports., Global Health and benefits, UK Banking and Insurance, Preparing need analysis document for business requirements., Client interaction calls to discuss their product need, managing a small team and ensuring deliverables are up to the quality and are on time., Extracting data from SQL Server., Extensively used SQL queries for producing ad-hoc reports and importing data into database using stored procedures, Events and triggers to validate the data from HRIS file., Analyzing data for ambiguities, Performing UAT and creating Project Tracker to ensure quality of deliverables., SQL Development, Functions and Stored Procedures, Experience in Excel, Knowledge of SQL and ETL tool, Prioritizing the work, Co-ordination with on-site team, Mentoring other team members, UAT and Project Tracking, Good Communication Skills

Hobbies and Interests

  • Learning New Technologies
  • Listen Music and Singing

Languages

English, Professional Working Proficiency

Timeline

Analyst Programmer

Wipro
10.2022 - Current

IND Configuration Analyst II

Aon Consulting ltd.
10.2018 - 10.2022

Data Analyst

GLobal Logic Technolgies Ltd.
11.2017 - 09.2018

Master of Computer Application -

G.G.S.Indraprastha University

Bachelor of Computer Application -

G.G.S.Indraprastha University
Ravi Kumar Mahto