ADITYA MANTHA
Bengaluru
Summary
Working as a Senior Consultant with total experience of 10 years, and having relevant experience of 9.5 years as a Database developer. Worked intensively on all phases of SDLC. Experience in working directly with client so I carry a good comprehension of client interfacing skills.I am very flexible and always keen to learn new business domain and technologies. Primarily I am part of the Database team to develop database design, planning for enhancements,Preparationand Execution of Test cases, Unit testing and Integration, regular application support and maintenance. I have extensively worked in the following topics in Oracle - Tables, Views, Materialized Views, Index, LOBs, Packages, Procedures and Functions, DB links, Synonyms, Sequences, Types, Triggers, Analytic Functions, collections and performance tuning. I am open to learning and working on new tools and technologies.
Overview
10
10
years of professional experience
1
1
Certification
Work History
Senior Consultant
Oracle Financial Services Software LTD
09.2024 - Current
- Client: HSBC ISO20022
- Led a Dev Team of 5 Members
- Involved in Requirement gathering from the client
- Involved in Scrum Calls from the Client on a Daily Basis
- Involved in all the Requirement Discussions with the Internal Team management
- Involved in Gathering all the Data from HSBC, Analyzing the Data, and give an Estimation to it
- Involved in modifying the existing packages to include all the LEI fields as a part of Extraction
- Involved in running the Online Interfaces job through FCIS Application to generate CSV File
- Analyzed the Scripts and Updated them to make it Time Efficient
- Involved in testing all the Data from Start to End
- Involved in Successfully Completing Multiple Test Runs of the Data
- Involved in Reviewing all the Code, making necessary customization wherever required
- Got Appreciation from the Client for Delivering phase 1 development well before the Timeline
Senior Consultant
Oracle Financial Services Software Limited(OFSS)
10.2023 - 09.2024
- Company Overview: Client: HSBC
- Project: TAO Migration
- Involved in Requirement gathering from the client
- Involved in Direct Communication Calls from the Client
- Involved in all the Requirement Discussions with the Internal Team management
- Involved in Gathering all the Data from JPM, Analyzing the Data, and give an Estimation to it
- Prepared all the necessary Migration Scripts in SQL, Analyzed already Existing Scripts and updating them as per the Business Requirement
- Analyzed the Scripts and Updated them to make it Time Efficient
- Involved in testing all the Data from Start to End
- Involved in Successfully Completing 2 Test Runs of the Data
- Prepared Migration patch Scripts wherever Required
- Prepared Recon Scripts for the Client as per the Business Data requirement
- Client: HSBC
- Project: TAO Migration
Senior Consultant
Oracle Financial Services Software LTD
01.2022 - 10.2023
- Company Overview: Project: KBANK Upgradation
- This project is for Upgradation from FCIS version 9.1 to Version 14.7
- Led a team across broad technical, and business disciplines
- Focused team on business objectives and tracked progress to ensure project milestones were completed on time with the desired results
- Requirement gathering from the client
- Worked on FCIS Screen design using RADTOOL
- Preparing Documentation
- Involved in all the Requirement Discussions with the Team management
- Involved in the Development of all the Screens (Frontend and Backend)
- Performed Testing of all the Screens
- Developed, customized, debugged and documented Oracle PL/SQL packages, procedures, functions, triggers and cursors in accordance with company's policies, company standards, and industry best practices, ensuring 95% satisfaction in performance in product
- Project: KBANK Upgradation
- This project is for Upgradation from FCIS version 9.1 to Version 14.7
Developer / Offshore Team Lead
Cognizant Technology Solutions
12.2014 - 10.2021
- Company Overview: Client: Public Services Company of Texas (PNM)
- Meter data storage & management system consist meter data collection, validation, estimation, calculations, and analysis
- MDMS also provides an interface for business users via ItronEE tool and web applications to work upon meters and service orders
- Led a team across broad technical, and business disciplines
- Focused team on business objectives and tracked progress to ensure project milestones were completed on time with the desired results
- Highly experienced professional in utilities domain with good technical and functional knowledge of MDMS product, CIS system and Utilities Billing systems
- Well experienced in working in development, migration, maintenance, production support, testing projects having exposure to all phases of SDLC lifecycle
- Proven team player with an analytical bent to problem solving and delivering under high stress environment with resource constraints
- Delivered excellent customer service and gained respect of client management and end users
- Managing delivery of a production support team of a utility client having AMI systems such as Itron MDMS and complex billing MV-PBS system, Banner CIS and EDI systems
- Automated NonComm Meters: Automated a process which takes all the Active ESIIDs from MDMS and with the help of TIBCO inserts them into CIS system (Banner DB) where it fetches all the service orders generated within last 'n' days for NonComm ESIIDs
- Lastly it sends an email to all the users attaching the report which consists all those ESIIDs
- This Automation saved a lot of time and Hard Work for the users
- Mass Reset of all Failed Service Orders: Created a Stored procedure in Pl/SQL which will perform a Mass Reset ie
- The process will reset all the service orders which are failed on that particular day
- Client: Public Services Company of Texas (PNM)
- Meter data storage & management system consist meter data collection, validation, estimation, calculations, and analysis
- MDMS also provides an interface for business users via ItronEE tool and web applications to work upon meters and service orders
Education
Masters of Computer Application -
University Of Pune
01.2014
Bachelor of Science - CS
University Of Pune
01.2011
HSC - Science
Maharashtra State Board
01.2008
SSC -
Maharashtra State Board
01.2006
Skills
- ORACLE
- SQL SERVER
- SQL
- PLSQL
- MYSQL
- Shell Scripting
- MDM
- ItronEE
- Appworx
- ITSM
- Excel
- Applens
- Team Foundation Server
- HTML
- RAD Tool
- Flexcube Investor Services
- SonarQube
- WinScp
- SOAP UI
- JIRA
- Confluence
- Weblogic
- Windows
- UNIX
About Me
DOB-07/31/91
Languages Known-English, Hindi, Telugu, Marathi
Certification
- Oracle Certification in Database: SQL Fundamentals (1Z0-051)
- MANLOG L0 Certification
- Energy Utility Deep Dive Certification
- Sql Server CCP
Achievements
- Received " Diamond In the Rough"Award for best new Entrant in the organization-2015.
- Received Best Team Lead Award.
- Led the cultural activities Team in cognizant for 3 years.
- Organized various events,sports and fun activities.
- Led Account Cricket team to win EUPL(Energy Utilities Premier League) championship- Feb 2020
Timeline
Senior Consultant
Oracle Financial Services Software LTD
09.2024 - Current
Senior Consultant
Oracle Financial Services Software Limited(OFSS)
10.2023 - 09.2024
Senior Consultant
Oracle Financial Services Software LTD
01.2022 - 10.2023
Developer / Offshore Team Lead
Cognizant Technology Solutions
12.2014 - 10.2021
Masters of Computer Application -
University Of Pune
Bachelor of Science - CS
University Of Pune
HSC - Science
Maharashtra State Board
SSC -
Maharashtra State Board
Similar Profiles
Sivadas K RSivadas K R
Product Manager at Oracle Financial Services Software LtdProduct Manager at Oracle Financial Services Software Ltd
Dipak PadileDipak Padile
System Administrator at Oracle Financial Services Software LimitedSystem Administrator at Oracle Financial Services Software Limited
Akarsh PoovaiahAkarsh Poovaiah
Project Consulting Ops : Sr. Business Analyst at Oracle Financial Services Software Ltd.Project Consulting Ops : Sr. Business Analyst at Oracle Financial Services Software Ltd.
SharathSubrhamanya M KSharathSubrhamanya M K
QA Analyst 2 - Prod Dev at Oracle Financial Services SoftwareQA Analyst 2 - Prod Dev at Oracle Financial Services Software
Kishore GSKishore GS
Assistant Manager | Business Development at Flipkart Internet Pvt LtdAssistant Manager | Business Development at Flipkart Internet Pvt Ltd