Summary
Overview
Work History
Education
Skills
Projects
Certification
Timeline
Generic
VIVEK RAINA

VIVEK RAINA

Gurugram

Summary

Highly skilled and experienced professional with expertise in Python/SQL programming,data analysis and batch tech specialization.Seeking challenging role where I can utilize my technical skills and knowledge to contribute to success of dynamic team.Excels in problem-solving, attention to detail and delivering high quality results.

Overview

3
3
years of professional experience
1
1
Certification

Work History

Programmer Analyst/Data Analyst/Senior Batch Tech Specialist

WIPRO
07.2021 - Current
  • Handled end to end implementation of projects in Healthcare and banking technology domain
  • Developed and implemented data analysis algorithms using scripts of python and SQL to optimize batch processing efficiency, resulting in 20% increase in system performance
  • Collaborated with cross-functional teams to design and implement custom software solutions for complex data analysis projects, resulting in improved data accuracy and actionable insights
  • Provided technical expertise and support for troubleshooting and resolving batch processing issues,reducing system downtime by 15%
  • Conducted in-depth data analysis to identify trends and patterns,informing strategic decision-making and driving business growth initiatives
  • Proficient in Python,MongoDB,SQL, SAS, ETL, Advanced Excel, Mainframe, SDLC, STLC, Agile Methodologies
  • Databases/Servers: MYSQL,PostGRE SQL, DB2.

Education

Bachelors Of Engineering - Information Technology

Model Institute of Engineering And Technology
Jammu, JK
08-2021

(10+2) - Non-Medical

Happy Model Academy
Udhampur, JK
03-2017

Skills

  • PostGre SQL
  • My SQL
  • Mongo DB
  • Python
  • SAS Software
  • Advanced Excel
  • Jira (Defect Management)
  • Mainframe -JCL,Cobol
  • Software Development Lifecycle
  • Agile Methodologies
  • Data analysis
  • Data Manipulation
  • RDBMS

Projects

Alexa based language translator (English to Dogri language) -

Team Mate

  • In this system the user will give the voice commands to alexa and will wait for response, Alexa will reply it in the translated language.
  • Amazon developer console used to create skill and publish application in Alexa skill store.

Mass Communication -

Analyst

  • First working project in wipro.
  • Aligned in production team as Analyst.
  • We created and automated Jobs which sends automatic emails to clients such as Welcome Letters.
  • We also maintained client's database and worked on complex datasets and simplifies it.
  • We worked with 150+ US clients including airline industry as well.
  • Technologies Used - MySQL,PostGre SQL,Python,Advanced Excel,Database Testing,Jira.

Annual Enrollment Automation -

Senior Analyst

  • In this Project: We worked with more than 50+ banks in USA.
  • We worked on health and welfare domain.
  • We took care of client's new/current payrolls,insurance plans,claims,Card-debit/credit.
  • We closely worked with operations team to automate,configure and maintain clients data.
  • We created and automated jobs that reformats raw data coming from client's side through EFT's (Electronic file transfer) and load it accordingly.
  • We also automated data loading using python,SAS,Proc SQL on mainframe OS.
  • Automated jobs that checks client's eligibility on any of the plans then loads the data accordingly.
  • Technologies - Python,PostGre SQL,MySQL,SAS,Excel,ETL,Jira.

Certification

  • Google Analytics for beginner's. (Google - 08/2017)
  • Introduction to Relational Database and SQL. (Coursera - 07/2020)
  • Google Cloud fundamentals Core Infrastructure. (Coursera - 07/2020)
  • Complete SQL training and Certification. (Udemy - 05/2023)
  • SAS Programming Learn SAS from beginner to advanced. (Udemy - 07/2023)
  • PostGre SQL Become an SQL developer. (Skillup - 06/2024)

Timeline

Programmer Analyst/Data Analyst/Senior Batch Tech Specialist

WIPRO
07.2021 - Current

Bachelors Of Engineering - Information Technology

Model Institute of Engineering And Technology

(10+2) - Non-Medical

Happy Model Academy
VIVEK RAINA