VIJAY MAHAWAR

Last updated on November 16th, 2021 at 01:02 am

OBJECTIVE

An Oracle Technologist with a blend of Data Scientist skills, who can combine both his technical and business knowledge to help the firm transition into a futuristic organization using latest technology features & industry best practices.

SUMMARY

A commerce graduate with Masters in Computer Application (MCA) and Masters in Business Administration (MBA) having 10+ years of work experience as Oracle Technologist primarily in BFSI domain.

Vijay has rich experience of 10+ years as Oracle Technologist in BFSI domain using Advanced SQL/PLSQL in development & performance tuning with hands on Oracle 19c and Oracle Autonomous Database over cloud.

• Worked as Software Engineer, Business Analyst and Consultant during tenure in esteemed organizations like Larsen &Toubro Infotech Ltd., HCL Technologies Ltd., Dell Services Ltd., Sapient Consulting Pvt. Ltd. and Genpact Headstrong Capital Markets Ltd.
• Rich experience of working with global clients with presence in APAC, EMEA, LATAM and US.
• Extensively worked in ETL and Data warehousing environment, especially in batch jobs.
• OCP (Oracle Certified Professional) in both Developer track and DBA track in Oracle 11g.
• Oracle Financials ERP training on Oracle E-Business Suite R12 version covering GL, AP, AR, CM and FA modules.
• Certified in “Bloomberg Market Concepts” from Bloomberg Institute and “Customer Relationship Management” from IIMBx (IIM Bangalore).
• Cleared NCIAC – “NSE Academy’s Certified Investment Analyst Champion” and NCDP – “NSE Academy’s CertifiedDerivatives Pro”
• Completed training on demand from “Oracle Database 12c R2: Advanced PL/SQL” from Oracle University
• Domains familiar with – Customer Billing Application; Mortgage Payment Protection Insurance; Incident Management;Change and Release Management and Corporate Banking & Investment Banking, Customer Relationship Management (CRM).
  Technical Specialties: Oracle SQL, PLSQL, Data Warehouse, ETL, Python Programming, Unix and Oracle Financials EBS R12.
  Functional Specialties: Derivatives, Fundamental Analysis, Technical Analysis and Portfolio Management.

WORK EXPERIENCE

Independent Consultant (May 2021 onwards)

• 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 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.

Principal Consultant, Apps Associates Pvt. Ltd., Gurugram (Apr 2017 – Apr 2021)

• Started working as SQL/PLSQL developer for the leading Management Consulting client.
• The project aimed at fulfilling the reporting need of the client with Oracle BI Publisher 12c as front-end and Oracle 12c as backend, Oracle DAC 11g tool was used for running/scheduling the ETL jobs and PPM tool to deploy the code. Development Database uses 19c version.
• The project primarily used Project Accounting Modules. Other EBS modules used in the project were GL, AP, AR
• My role involved in reverse engineering the existing functionality of the legacy application and develop SQL and PL/SQL solution to use latest and optimal feature of the Oracle for the new components.
• Performance Tuning and refactoring of Legacy Application using latest feature of PL/SQL and SQL.
• Collaborated with stakeholders post production support for monitoring, analyzing, supporting applications after go live.
• Created Real Time Dashboards and Visualization using Business Intelligence Tool. 
• Developed ETL workflows using Informatica Powercenter 10.
• Hands on experience in Alteryx Workflow (ETL), Snaplogic(ETL) and Tableau(BI Reporting)
• Hands on experience of BI Publisher  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.

Independent Consultant (May 2016 – Apr 2017)

• Started working as Independent consultant after MBA. Presently 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.

Senior Associate, Sapient Consulting Pvt. Ltd., Gurgaon (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.
• I was in the “wall of fame” for my work at the client site during the month of November 2011.
• 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.
• During my tenure I had attended Oracle event on “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 in 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.

Senior Analyst, Dell Services 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.

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).

Momentum Technologies (now Sopra); L&T Infotech Ltd. Mumbai; TSYS Card Tech Ltd. Noida (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)
• Cleared Sun Certified Java Professional (SCJP 1.4)

INTERNSHIPS & PROJECTS

DOMAIN SKILLS

• NSE Academy’s Certified Investment Analyst Champion (NCIAC) and NSE Academy’s Certified Derivatives Pro (NCDP)
• NCFM certificate in Securities Market, Mutual Funds, Banking Sector & Insurance Module; Certified Scrum Master (CSM) and SAFe 4 Scrum Master (SSM).
• NCFM certificate in Capital Markets Fundamental – International, Capital Markets Dealer’s Module.
• Certificate in Finance Modelling using Excel and Advance Excel, Bloomberg Market Concept from Bloomberg Institute.

TECHNICAL SKILLS

• Microsoft Office 365 – Excel, Power point and Word; Microsoft Visio; ERWin, Toad, SQL Developer and PLSQL Developer
• Oracle 11g Tools – PL/SQL Language, OBIEE 11g for reporting and OWB 11g for Data warehouse.
• OCP certified (DBA and Developer Track in Oracle 11g), OCE in Oracle RAC 11g and OCE in SQL.
• Microsoft Certified Application Developer (MCID: 3554642), SCJP (Sun Certified Java Professional) in JDK 1.4
• Member of Oracle User Groups – AIOUG, ODTUG and OTN.

EXTRA-CURRICULAR ACTIVITIES & HOBBIES

• Member of IT Committee and Operations Committee in MBA. (Aug 2014 – Mar 2016)
• Runners-up in Chess Competition conducted by ABIT Engineering College, Cuttack. (Sep – 2014)
• Reading (Fiction, Non-Fiction), Current Affairs, Swimming, Watching Cricket, Playing Chess, Yoga Enthusiast.

EDUCATIONAL QUALIFICATION