Summary
Overview
Work History
Education
Skills
Certification
Disclaimer
Timeline
Generic

Ashish Ashok Mahajan

Pune,Maharashtra

Summary

Dynamic and results-driven professional seeking a position within a growth-oriented company that values analytical and technical expertise. Proven ability to leverage strong problem-solving skills to enhance operational efficiency and drive profitability. Committed to contributing innovative solutions that align with organizational goals and foster continuous improvement. Eager to collaborate with a talented team to achieve exceptional results and support the company's mission.

Overview

12
12
years of professional experience
1
1
Certification
1
1
Language

Work History

Principal Data Engineer

Saama Technology
03.2022 - Current
  • Description:- Data Migration into snowflake from SAP system and building data products on top of the migrated data for business users consumption.
  • Environment:- Snowflake, DBT, Git Lab, DVA, Pl-SQL, Tableau, MS SQL Server, Azure Synapse, SQL Developer, Request Management, Git.
  • Client:- ROCHE
  • Description:- Migrated legacy systems to modern big-data technologies, improving performance and scalability while minimizing business disruption.
  • Designed and implemented Data Vault 2.0 models, enhancing scalability & business rule integration.
  • Collaborated on ETL (Extract, Transform, Load) tasks, maintaining data integrity and verifying pipeline stability.
  • .Fine-tuned query performance and optimized database structures for faster, more accurate data retrieval and reporting.
  • Led end-to-end implementation of multiple high-impact projects from requirements gathering through deployment and post-launch support stages.
  • Enhanced data quality by performing thorough cleaning, validation, and transformation tasks.
  • Optimized data processing by implementing efficient ETL pipelines and streamlining database design.
  • Collaborated with cross-functional teams for seamless integration of data sources into the company''s data ecosystem.
  • Provided technical guidance and mentorship to junior team members, fostering a collaborative learning environment within the organization.
  • Reviewed project requests describing database user needs to estimate time and cost required to accomplish projects.

Sr. Software Engineer

L&T Infotech
01.2019 - 03.2022
  • Description:- Centralized Administrative unit system which is monitor the system and find out the cost saving opportunity with business. We have automation of invoices like in different file format like Pdf, Xsl, Xml,822 and rate card data in the form of standard templates. To identify the cost saving opportunity BNM business team requires to liaise with account owner and other stakeholders of the period.
  • Environment:- Oracle SQL Developer, SVN, Request Management, Jobs, Process Configuration, Bitbucket, Git, Tectia.
  • Client:- CITI Bank North America (Bank Network Management & Bank Balance Tracking System).
  • Responsibilities:- Designed and programmed backend workflows using Oracle 10g.
  • Created PL/SQL packages, stored procedures, and functions.
  • Worked in an Agile environment for faster delivery.
  • Wrote and optimized complex SQL queries, cursors, and PL/SQL programs.
  • Took part in release activities and client calls to understand requirements.
  • Coordinated with designers and testers to implement business needs.
  • Prepared design documents, unit testing logs, and technical documents.
  • Built an in-house platform to track daily balances and account flags.
  • Processed end-of-day bank balances and reconciled SWIFT (940 & 950) messages.
  • Handled multiple data feeds from different source systems.

Sr. Software Engineer

Tech Mahindra
01.2019 - 08.2019
  • Description:- PACS is the common planning system of Logical inventory and planning system which manages the whole engineering life cycle from network planning, network routing till Service implementation.
  • Environment:- Oracle Pl-SQL developer, SVN, Request Management.
  • Client:- British Telecom, UK (Planning assignment and configurations system (PACS).
  • Responsibilities:- Designed and developed backend workflows using Oracle 10g.
  • Created PL/SQL packages, stored procedures, functions, and cursors.
  • Worked in Agile methodology for development and delivery.
  • Wrote and optimized complex SQL queries and PL/SQL programs.
  • Participated in release activities and client calls to gather requirements.
  • Collaborated with designers and testers to implement business functionality.
  • Prepared and maintained design documents, unit testing logs, and technical documentation.

System Analyst

Ebix Cash Technologies Ltd.
07.2016 - 01.2019
  • Description:- Infrastructure Development Finance Company Ltd (IDFC) is India's leading integrated infrastructure finance player providing end to end. Infrastructure financing and project implementation services. In this project, We integrate our existing core products (LOS, LMS, COLLECTION) as per the IDFC requirements.
  • Environment:- Oracle Pl-SQL developer, SVN, Request Management, JIRA, BMC.
  • Client:- IDFC Bank (Mumbai) and Core product development.
  • Responsibilities:- Created PL/SQL functions, procedures, and packages.
  • Developed LMS-Collection interface for batch processing and amortization.
  • Built packages for instrument processing (upload, download, and batch).
  • Handled clearing processes with multiple instrument types.
  • Automated general ledger entries, payment modes, and end-of-day processing.
  • Written packages for amortization schedules and EMI rescheduling.
  • Used Bugzilla and JIRA for issue tracking and defect management.
  • Provided expert technical support, reducing system downtime and minimizing disruptions to daily operations.
  • Created detailed documentation for both internal reference and client-facing presentations, improving communication between stakeholders.

Oracle PLSQL Developer

HCL Technologies Ltd.
05.2015 - 07.2016
  • Description:- FDW application (Finance IT) is based on DEUTSCHE BANK employees. Data reporting and Bonus, Share and User details of clients. Application handles both cash and stock compensation of all DB Employee And Users. Database has OLTP and OLAP data models. It’s needs. to process the data on monthly basis OLAP reporting happens through FIM.
  • Environment:- Oracle (Sql/Plsql) 11.2.3g Toad, Putty, Incident/Service Request Management, DB Cobra application.
  • Client:- Deutsche Bank.
  • Responsibilities: -Created PL/SQL functions, procedures, and packages.
  • Developed LMS-Collection interface for batch processing and amortization.
  • Built packages for instrument processing (upload & download).
  • Written packages for amortization schedules and EMI rescheduling.
  • Used Bugzilla and JIRA for issue tracking and defect management.

PLSQL Developer

POS Nirvana Pvt. Ltd.
06.2013 - 05.2015
  • Description:- POS Nirvana is a Point-of-Sale enterprise application which is based on hotel management. It deals with user management also. Complete inventory of the hotel along with the staff information and users visiting the hotel is managed in the database.
  • Environment:- Oracle 11g, Android user interface and functionality, Basic Command of Linux, Source Control (SVN), Tomcat Application Server.
  • Client:- Mint Indian Bistro LV.
  • Responsibilities:- Created and optimized PL/SQL procedures, functions, and triggers.
  • Wrote complex SQL queries (joins and subqueries) to solve business needs.
  • Used SQL subprograms and anonymous blocks to fix real-time issues.
  • Modified user objects as per client requirements.
  • Generated end-of-day (EOD) reports by location.
  • Developed basic Android UI screens and core Java functionality.
  • Performed functional and unit testing, and prepared reports.

Education

B.E - Computer science and engineering

Priyatam Institute of Technology And Management
01.2012

Mathematics

New Vision Hr. Sec. School
Burhanpur, M.P.
01.2008

10th - undefined

New Vision Hr. Sec. School
Burhanpur, M.P.
01.2006

Skills

  • Programming Languages: Snowflake , DBT, DVA, Tableau, Oracle SQL, PLSQL, GitLab , DataOps, Azure Synapse, Basic PySpark And Unix Commands

  • Database: Snowflake,Oracle 10,11g, Oracle 12C, Sql Server

  • Operating Systems: Windows 2000/XP/7

  • Dev Methodology: Object Oriented Programming

  • Architecture: MVC

Certification

SNOWPRO CORE

Disclaimer

I am confident of my ability to work in a team. I hereby declare that the information furnished above is true to the best of my knowledge. Place: PUNE (ASHISH ASHOK MAHAJAN)

Timeline

SNOWPRO CORE

11-2024

Principal Data Engineer

Saama Technology
03.2022 - Current

Sr. Software Engineer

L&T Infotech
01.2019 - 03.2022

Sr. Software Engineer

Tech Mahindra
01.2019 - 08.2019

System Analyst

Ebix Cash Technologies Ltd.
07.2016 - 01.2019

Oracle PLSQL Developer

HCL Technologies Ltd.
05.2015 - 07.2016

PLSQL Developer

POS Nirvana Pvt. Ltd.
06.2013 - 05.2015

10th - undefined

New Vision Hr. Sec. School

B.E - Computer science and engineering

Priyatam Institute of Technology And Management

Mathematics

New Vision Hr. Sec. School
Ashish Ashok Mahajan