Vijay Mahawar

Vijay Mahawar

MBA in Finance,Marketing | Master in Computer Application | Commerce Graduate | Oracle Technologist | an Analyst | Data Scientist | Chess aficionado | Shutter-bug | Yoga enthusiast

Gurugram, India

vijay@mahawar.net

His Blog

Linkedin Profile

+91-9829124845


SKILLS

SQL

80%

PLSQL

80%

Performance Tuning

70%

Python

50%

ETL

70%

DatawareHousing

70%
 

LANGUAGES

English

Hindi

Tamil

German

 

CERTIFICATES/PROJECT REPORTS


“I just don’t want to give my best, but I want the best for you as well”

10+ Years in SQL, PL/SQL, Python, ETL, Datawarehousing

Skill-O-Graph Academic/Employment

Source code of above graph created on Kaggle is here

Work Experience | Trainings | Education | Certificates

Work Experience

Independent Consultant / Freelance Consultant, Gurugram
May 2021 - Current

  • Started working as freelance professional for reputed clients on Database Migration projects using: Oracle SQL, PLSQL with optimised solution.
  • Expertise in ETL tools for Business Intelligence, Data Analytics, Python for problem solving and solutions for Data Science; Machine Learning and Reporting Needs.
  • Accomplished in understanding business of fortune 500 clients and delivering high quality and robust solution.
  • Demonstrated high level of professional work ethics and client confidentiality.
  • Part-timed with Zomato for delivery of essential services during the peak of pandemic.
  • Volunteered for International Day of Yoga 2021 for Ministry of AYUSH, Government of India; Sri Sri School of Yoga and Yoga Certification Board.
  • Completed PG Diploma in Data Science and Statistics from Symbiosis Centre for Distance Learning.
Top
Principal Consultant / Apps Associates India Pvt. Ltd., Gurugram
May 2018 - Apr 2021

  • Started working as SQL and PL/SQL developer for the leading Management Consulting client at the client location in Finance Analytics.
  • The project aimed at fulfilling the reporting need with Oracle BIP 12 as front-end and Oracle 12c database as backend, Development database runs on Oracle 19c version.
  • Oracle DAC 11g tool was used for running/scheduling the ETL jobs and PPM tool to deploy the code.
  • The project primarily used Project Accounting Modules. Other EBS modules used in the project were GL, AP, AR.
  • Role involved reverse engineering the existing functionality of the legacy application. Performance Tuning and refactoring of Legacy Application using latest feature of PL/SQL and SQL.
  • Collaborated with stakeholders in all phases of development life cycle.
  • Developed ETL workflows using Informatica Powercenter 10.
  • Collaborated with stakeholders post production support for monitoring, analysing, supporting applications after go live.
  • Created Tableau dashboard for Management and Production Support team to visualise the month end support jobs metrics for a given GL Period.
  • The dashboard gave running jobs within ETA and for a specific business country-wise on map. Users were Management, Production Support and Automation Team.
  • Business/Management got clear estimates/projection on the quarter-on- quarter projects revenue and costs from business. GL Ledger Books status like closed, opened, permanently closed etc.
  • The Dashboard used data sources like excel - csv extracts, oracle database. It was scheduled for a weekly refresh as well as live connection. At some occasion alteryx workflows were used to generate the extracts for Tableau dashboard.
  • Maintained and supported Python scripts to generate and validate the production data using Pandas, cx_Oracle library used for CRUD operation.
  • Hands on experience in Snaplogic (ETL) and TIBCO Jaspersoft.
  • Hands on knowledge of BI Publisher for the project requirement using Excel Template for one of the project need.
  • Briefly explored and developed Jenkins job for Automation project to deploy Informatica workflows to different environment.
  • Completed training on demand from "Oracle Database 12c R2: Advanced PL/SQL" from Oracle University.
  • Certified in Scaled Agile Framework (SAFe) Scrum Master (SSM) from ScaledAgile.
  • Completed certificate course in Customer Relationship Management from IIMBx (IIM Bangalore).
  • Completed Single Course in Customer Relationship Management (CRM) from Symbiosis Centre for Distance Learning, Pune with A+ grade.
  • Undergone one day OBIEE 12c workshop at the client location for the project need.
  • Undergone internal training on AWS and AWS for Data Science from Linkedin Learning.
  • Completed online trainings on BI Publisher, Undergoing self-paced training on Informatica PowerCenter on Udemy.

Principal Consultant / Genpact Headstrong Capital Markets, Noida
Apr 2017 - Apr 2018

  • Worked as consultant for the Investment Banking client of Genpact Headstrong Capital Markets at the client location.
  • Attended Oracle Open World and Code Developer Event at New Delhi in May 2017.
  • Undergone training on Lean Digital Transformation and .NET bootcamp.
  • Cleared NCFM module in Capital Markets Dealers module and Capital Markets Fundamental – International module.
Top
Independent Consultant / Freelance Consultant, Gurugram
May 2016 - Apr 2017

  • Started working as Independent consultant after MBA. Worked in setting up database for startup companies in India.
  • Undergone Oracle Financials ERP training on Oracle EBS R12 version covering GL, AP, AR, CM and FA modules.
  • Cleared NCFM exam in Banking Sector Module, Insurance Module, Derivatives Market and Options Trading Strategy.
Top
Senior Associate / Sapient Consulting Pvt. Ltd., Gurugram
Jun 2011 - Jul 2014

  • Worked with Investment Banking client of Sapient Global Market in the back office at the client location.
  • Project included varied technologies viz. Oracle 11g, Oracle Warehouse Builder 11g and Autosys Jobs.
  • Played the role of Senior Oracle PL/SQL Developer and Analyst while working in Agile Scrum Framework.
  • Interacted with the business users to understand end-to-end requirement.
  • Prepared design specification, technical specification, test cases. release scripts, release checklist and rollback scripts.
  • Conducted session on Top 10 features in Oracle 11g within the team.
  •  Attended Oracle event:
    • "Oracle Technology Network (OTN) Developer Day": 
      • Jul 2011 at Intercontinental Eros, New Delhi;
      • Jan 2012 at The Claridges, New Delhi.
    • Events from ODTUG and AIOUG:
      • Mar 2012 - “Quest Asia FORTUNE12”, Mumbai.
  • Undergone five days workshop on "Oracle 11g: DBA Security" from Oracle University.
  • Undergone four days workshop on "Oracle 11gR2 DBA: Real Application Clusters and ASM".
  • Upgraded OCP DBA in Oracle 10g to Oracle 11g; Cleared OCE in Oracle RAC 11g and Grid Infrastructure Administrator
Top
Senior Analyst / Dell Services Pvt. Ltd., Noida
Feb 2010 - May 2011

  • Worked on a project for Mortgage Payment Protection Insurance for Banks.
  • The project aimed to provide a generic web based application to market their Insurance product.
  • The speed to market was primary focus of the project.
  • Technologies used in project: Java, XML, Oracle 10g, PLSQL. Traveled to UK (London) for the initial project requirement and developed generic routine for the product.
  • Collaborated with the Business Analyst and Software Architects within the team.
  • Analyzed the requirement and developed database service for the UI and business service.
  • Prepared and maintained the setup SQL scripts to install, configure the application.
  • Maintained and set up database environment for Development, UAT and support for the offshore team.
  • Participated in auditing, encryption/decryption and performance tuning of existing application.
  • Undergone four days workshop on "Oracle 10g Performance Tuning" from Oracle University.
  • Upgraded OCA Developer in Oracle 9i to OCP in 11g Oracle PL/SQL Advanced Developer.
  • Completed PGDBA (Finance) from Symbiosis Center for Distance Learning.
Top
Software Engineer / HCL Technologies Ltd., Noida
Oct 2007 - Jan 2010
  • Worked as Software Engineer and delivered challenging assignments on time.
  • Had worked in the full project life cycle, from requirement gathering, analysis, development and support of a web based project management tool
  • Generated reports to cater to the needs of the various stakeholders.
  • Analyzed the requirement, developed oracle database objects and reports using Oracle Business Intelligence tool.
  • Had worked extensively on data warehousing and ETL environment.
  • Received Certificate of Appreciation for the period Nov '08 - Dec '08 for outstanding effort and performance.
  • Cleared Oracle Certified Professional (OCP) in Oracle Database 10g Administration and Oracle Database SQL Expert (OCE).
Top
Momentum Technologies (now Sopra); TSYS Card Tech Ltd.; L&T Infotech Ltd. Noida & Mumbai
Jun 2005 - Oct 2007
  • During this time I worked in Momentum Technologies Ltd. (now Sopra) as Software Engineer Trainee.
  • In L&T Infotech Ltd., worked in the BFSI SBU as Oracle PL/SQL Developer.
  • Independently handled the customer billing module for a German client.
  • Developed scripts, automated batch jobs and database objects for processing customer bills.
  • Was with TSYS Card Tech Ltd.(Noida), as Analyst for short period.
  • Cleared Oracle Certified Associate (OCA) in Oracle 9i Database Developer.
  • Cleared Microsoft Certified Application Developer (MCAD) (MCID - 3554642)
  • Cleared Sun Certified Java Professional (SCJP 1.4)
Top

Management Trainee / Internships & Projects

Website Management / S.N.Mahawar & Associates
May 2015 - Jun 2015
  • Renewal, Maintenance and Management for a website for “S. N. Mahawar & Associates” as part of the summer internship in MBA.
  • Demonstrated entrepreneurial abilities and skills in Finance, Technical and Marketing area.

Java Developer Trainee / Tata Infotech Ltd., (Now TCS), Noida
Jan 2005 - May 2005
  • This was part of MCA Final Semester training.
  • Team member of the project development team comprising of 85 members working on Messaging System.

Website Developer / Muskaan, Jaipur
Apr 2004 - May 2004
  • This was part of MCA Second Year Summer Internship. Developed the website for the NGO.
Top

Education

(Part Time) PGDDSS, Symbiosis Centre for Distance Learning - 75.89%
2019 - 2021

Post Graduate Diploma in Data Science and Statistics.

Subjects in 1st Semester:- (Completed)
Basics of Statistics - 72/100
Data Structures and Algorithms - 75/100
Introduction to Data Science - 80/100
Introduction to R Programming - 82/100

Subjects in 2nd Semester:- (Completed)
Advanced Statistics with Data Analyst - 81/100
Emerging trends in Data Science - 72/100
Machine Learning with R and Python - 82/100
Python Programming - 83/100

3rd Semester:- (Completed)
Case Study (33/50)
Project (61/100)


(Part Time) CRM, Symbiosis Centre for Distance Learning - A+ Grade
2019

Customer Relationship Management(CRM) single course.


(Full Time) MBA (Finance,Marketing) Sri Sri University, Cuttack, India - 7.58 CGPA
2014 - 2016

Masters Degree in Business Administration with specialisation in Finance and Marketing.

Self-audits were:

  • Finance :-
    • Trimester IV - Corporate Restructuring: Mergers & Acquisitions
    • Trimester V  - Corporate Risk Management
    • Trimester VI (Capstone Project) - Financial Modelling for Corporate Valuation
  • Marketing :-
    • Trimester IV - Consumer Behaviour
    • Trimester V  - Direct Marketing & e-Marketing
    • Trimester VI - International Marketing
  • Choice-Based Audit: Yoga & Naturopathy

(Part Time) PGDBA (Finance), Symbiosis Centre for Distance Learning - 59.54%
2006 - 2010

Post Graduate Diploma in Business Administration with specialisation in Finance

Project study on Mobile Banking in India.


(Full Time) Master in Computer Application, Birla Institute of Technology, Mesra, Ranchi - 8.6 CGPA
2002 - 2005

Masters Degree in Computer Application.

Activities and societies: Second Semester - Summer Internship with Muskaan - Jaipur based NGO for road safety awareness.

Fourth Semester - Created project chess cum chat applet.

Fifth Semester - successfully designed, developed and tested a Digital Clock made of LEDs attached to Parallel Port and controlled by computer program. This was created by 3 members team - Sumit Jha, Om Babu Gupta and myself.

Fifth Semester - Seminar on Linux Administration and Server Configuration


(Part Time) Advanced Diploma in Software Technology, STG International Ltd. - A Grade
2000 - 2002

Trained subsequent batches on Oracle Developer/2000 - Forms 6 and Reports 6.

First Semester - Computer Concepts, MS-Office, Programming techniques using C++ and Web Design-Internet (Grade A)

Second Semester - RDBMS using Oracle 8i, Programming with Developer/2000 - Forms 6 and Reports 6, SQL Server 7.0 (Grade A)

Third Semester - OOPS and OOAD with UML Concepts, Java Programming (Applet and Application)
 (Grade B)

Fourth Semester - Visual Basic 6.0, Active Server Pages (ASP) (Grade A)

Fifth Semester - Visual InterDev, Web Administration and e-Commerce (Grade C)

Sixth Semester - Real Time Project and Technology Updates (Grade A+)


(Full Time) B.Com, Commerce College, Jaipur - 67.30%
1999 - 2002

Bachelor Degree in Commerce


Class XII, Bharatiya Vidhya Bhavan’s Vidhyashram, Jaipur - 83.40%
1999

Specialisation in Commerce with Mathematics and Economics


Class X, KPCV Senior Secondary School, Chennai - 83.20%
1997

Class X

Top