RSS

Vijay Mahawar – Resume

Last updated on July 2nd, 2020 at 10:54 pm

VIJAY MAHAWAR
Male | vmahawar@gmail.com
Linkedin URL: https://in.linkedin.com/in/vijaymahawar


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, Unix and Oracle Financials EBS R12.
    Functional Specialties: Derivatives, Fundamental Analysis, Technical Analysis and Portfolio Management.

WORK EXPERIENCE

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

  • 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.
  • Currently pursuing “Post Graduate Diploma in Data Science & Statistics” from Symbiosis Centre for Distance Learning.

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

S.N.Mahawar & Associates May – Jun 2015 Management Trainee 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.
Tata Infotech Ltd., (Now TCS), Noida Jan – May 2005 Trainee This was part of my MCA Final Semester training. I was member of the project development team comprising of 85 members working on Messaging System.
Muskaan, Jaipur Apr – May 2004 Trainee This was part of my MCA 2nd Year Summer Internship. I had developed the website for the NGO.

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 (MCP ID: 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

MBA (Finance & Marketing) 2016 Sri Sri University, Cuttack , Odisha 7.48(CGPA)
MCA 2005 Birla Institute of Technology, Mesra, Ranchi (Jaipur Campus) 86.00%
B.Com 2002 Commerce College, University of Rajasthan 67.33%
Class XII 1999 Jaipur Bharatiya Vidhya Bhavan’s Vidhyashram, CBSE, Jaipur 83.40%
Class X 1997 KPCV Senior Secondary School, CBSE, Chennai 83.20%
 

Comments are closed.

 
snowflake snowflake snowflake snowflake snowflake snowflake snowflake snowflake snowflake snowflake snowflake snowflake snowflake snowflake snowflake snowflake snowflake snowflake snowflake snowflake