Summary
Overview
Work History
Education
Skills
Languages
Work Availability
Certification
Software
Work Preference
Timeline
Generic
AMIT MORE

AMIT MORE

Software Developer - Lead/Manager
Vikhroli, Mumbai,MH

Summary

  • SOFTWARE PROFESSIONAL – ORACLE PL/SQL LEAD Seeking challenging assignments with an organization of repute across the industry in executing full life-cycle development projects; ramping-up projects within time, budget & quality parameters, as per project management & best practice guidelines. PROFILE
  • Technically competent and result oriented IT professional with over 16 Years of experience in Software Design/ Development, Implementation in Applications, Testing, Maintenance & Support, Programming in SQL & Oracle PL/SQL, Developing codes for Stored Packages, Procedures, Triggers, Functions and Workflow.
  • Sound experience in solution/ application development, such as analyzing information system needs, evaluating end-user requirements, custom designing solutions, troubleshooting for the applications and presentations. Core competencies in full project implementation lifecycle including Testing, Coding and Code Review and Modification.
  • Excellent programming skill in SQL with logic development, integration of application oriented Procedures and Functions into Packages, Database Architecture, Modeling, Design & Development, Data integration & migration using SQL
  • Loader. Keep abreast with latest programming techniques and industry standard software documentation process.
  • Equipped with the knowledge to build various tools to automate the Project related activities while structure customized solutions to meet customer’s specific needs.
  • Focused and hardworking individual with thorough knowledge and technical understanding. Possess an analytic bent of mind and confidence to take challenging assignments. Excellent communication & interpersonal, efficient time management and organization skills, ability to handle multiple tasks under high pressure and tight deadlines. Core Competencies Software Development Technical/ Quality Support Test Planning/ Execution Troubleshooting/ Root Cause Analysis Program Analysis Cross-functional Coordination Team Management Client Relations Management Complete Software Development Life Cycle Training & Development Problem Solving Skills

Overview

19
19
years of professional experience
1
1
Language

Work History

Manager

Ernst & Young LLP
09.2024 - 12.2024
  • Technology Consulting
  • Requirement Gathering
  • Writing Complex SQLs
  • Optimization of SQLs and PLSQL
  • Writing Stored Procedures,Functions,Packages,Triggers as per requirements
  • Bug Fixing
  • Extracting Reports for the Development
  • Providing the daily Status.
  • Preparing the Documemts for Development
  • Preparing Unit test case documents and executing unit test cases.
  • Troubleshooting the Issues
  • Training and Leading Subordinates
  • Managing the team.

Lead - PLSQL

ASI Analytics
06.2023 - 09.2023
  • Analysis of Requirements
  • Coding for the requirements
  • Developing Stored Procedures,Functions,Packages,Triggers as per requirements
  • Bug Fixing.

Lead

IRIS SOFTWARE LTD
03.2022 - 05.2023
  • Leading and supporting, guiding the development Team.
  • Analysis of Requirements.
  • Preparing the documents for development.
  • Preparing Stored Procedures, Functions, Packages, Triggers As per requirement
  • Analysis and fixing the defect identified by QA team.
  • Attending the Scrum Calls organized by client.
  • Performing Unit Testing.
  • Writing stored procedures for Data Migration from one environment to another.

Senior Software developer

Mindgate Solutions pvt. Ltd
09.2021 - 03.2022
  • Preparing Script for bulk data upload .
  • Implementing the scripts prepared in production environemt.
  • Participating in smooth implementation of the project and extending post-implementation, application maintenance and technical support.
  • Writing SQL queries, preparing stored procedures, packages, function and triggers as per requirement
  • Do performance tuning of the SQL queries
  • Understanding business requirements and preparing design documents for those requirements.

Sr. PL/SQL developer

ASM Enterprise solutions Pvt. Ltd
03.2016 - 08.2021
  • Accountable for conducting system study and co-ordination with team members for requirement mapping, system design & integration, implementation etc.
  • Participating in smooth implementation of the project and extending post-implementation, application maintenance and technical support.
  • Responsible for writing SQL queries, stored procedures, functions, packages, triggers as per the requirements.
  • Monitoring indexes in database and fixing the issues.
  • Analyzing the new business requirements/Change Requests (CR's) assigned & proposing a technical solution for the same.
  • Perform Coding for CRs and Defects
  • Analyzing the Issues Identified in the System and perform coding for fixing the same.
  • Analyzing & fixing all the bugs/ defects identified & reported by the testers, quality team and clients, conducting Research and Development on issues created after testing and ensure smooth implementation of the project.
  • Mentoring and conducting various Knowledge Transfer Sessions for the team mates for better adaptability to functional and business logic of the assigned module and acquainting them with changes in the assigned module.

Sr. Software Engineer

MASTEK LTD
11.2012 - 05.2015
  • Leading, mentoring & monitoring the performance of the team members to ensure efficiency in process operations and deliver quality support.
  • Perform Coding For CRs And Defects.
  • Preparing Program Specifications for the development.
  • Preparing the Unit Test Plans (UTP) for the Gaps Developed.
  • Analyzing the Issues Identified in the System and perform coding for fixing the same.
  • Analyzing and fixing the defects identified by the Quality Control team and client.
  • Preparing IDF’s and other documents related to developments activities
  • Testing and verifying the XML outputs generated from code as per the requirements.
  • Collaborating with the team members to maintain a continuous stream of information regarding the project status and progress
  • Deftly coordinating with onsite for timely delivery of project & query resolutions.
  • Executing each deliverable according to company’s SDLC and passed all reviews for best practices, code quality, security audits, and performance.
  • Handling maintenance of the existing code and its modification/ enhancement as per requirements to meet the current and anticipated load
  • Preparing Unit Test Plans for developed gaps and performing Unit testing to ensure functional viability of the code.

Sr. Software Engineer

DIRECT SOLUTIONS LTD
06.2012 - 11.2012
  • Developing Stored Procedures, Functions, Packages and Triggers.
  • Optimizing the SQL Queries.
  • Preparing scripts for Bug Fixing
  • Attending Client calls.

Senior Analyst Programmer

COMSOFT PTE. LTD
09.2011 - 02.2012
  • Requirement Gatherings along with BA and other Team Members.
  • Preparing the Program Specifications of the requirements gathered.
  • Writing the Unit Test plans for the development.
  • Writing the various DDL scripts like creation of tables, constraints, indexes,sequences views and synonyms.
  • Writing Stored Procedures, Functions, Packages and Triggers as per the requirements.
  • Testing the code developed.
  • Execution of Unit Test Cases written for development.
  • Providing support to Testing team for understanding the requirements.
  • Providing support for System Testing.
  • Providing support for UAT testing.
  • Providing Production support.

Senior Software Engineer

MPHASIS LTD
01.2011 - 08.2011
  • Participating in smooth implementation of the project and extending post-implementation, application maintenance and technical support
  • Performing data modeling using Ervin Tool.
  • Involved in designing test plans & gap analysis to ensure that Business Requirement and
  • Functional Specification are fulfilled.
  • Handling various technical aspects like preparing program specifications & LLD, software design, coding of modules, monitoring critical paths & taking appropriate actions in end-to- end development of software products.
  • Coding for bootstrapping the data from MS-Excel to Oracle Database.
  • Gathering the requirements.
  • Having Conference call with client for daily status of work.
  • Preparing the Unit Test Cases.
  • Execution of Unit Test Cases.

Sr. Software Engineer

MASTEK LTD
08.2008 - 11.2010
  • Working on oracle forms, SQL commands, reports, writing complex SQL queries by using joins and inline views to retrieve data from database
  • Maintaining Quality procedures related to the project & submitted the same to the Consultant.
  • Perform Coding For Gaps, CRs And Defects.
  • Preparing Program Specifications for the development Activities.
  • Preparing the Unit Test Plans (UTP) for the Gaps Developed.
  • Testing The Gaps Developed.
  • Analyzing the Issues Identified in the System and perform coding for fixing the same.
  • Analyzing and fixing the defects identified by the Quality Control team and client.
  • Generatingand Checking the Various reports related to Billing System.
  • Reviewing the Code and program specifications.
  • Providing UAT support to the Client.

Sr. Executive

NELITO SYSTEMS LTD, Hewlett Packard
05.2006 - 08.2008
  • Responsible for writing SQL queries, stored procedures, functions, packages, triggers as per the requirements & report generation and converting the large SQL statements into PL/SQL blocks to improve the database performance.
  • Writing SQL as per the requirements.
  • Writing stored procedures, functions, packages, triggers as per the requirements.
  • Writing SQL for report generation.
  • Monitoring indexes, sequences in database.
  • Fixing the issues of the branches occurred during migration.
  • Taking care of migration activity
  • (Retail Banking/ Trade Finance/ GBM/ Lockers/ FCNR/
  • Signatures).
  • Checking whether the General ledger is tallied and then migrating it.
  • Migratingdata of retail banking and provide reports to the branches.
  • Running the scripts in database for starting the migration.
  • Executing ctls and sqls during live migration.
  • Key Projects Handled
  • As per annexure attached

Education

B. Com -

Mumbai University SYJC
01.2006

Training in SQL & PL/SQL from SQLSTAR -

St. George High School, Mumbai University
01.2003

SSC -

Mumbai University
01.2001

Data Science And Analytics -

Quickxpert InfoTech
08.1985

Professional Diploma - IT

GNIIT -

NIIT

ORACLE FINANCIALS from ERP -

Skills

  • Technical Skills
  • Programming Languages SQL,PL/SQL
  • Databases Oracle 9i, Oracle 10g, Oracle 11g Enterprise Edition Release, Oracle 12c
  • Developing Environment SQL
  • Plus, SQL Developer, Toad, PLSQL developer
  • Operating Systems MS-DOS, UNIX, Windows XP, Windows 2003 Server, Linux, HP-UX B1123

Languages

Marathi
Native language
English
Proficient (C2)
C2
Hindi
Proficient (C2)
C2

Work Availability

monday
tuesday
wednesday
thursday
friday
saturday
sunday
morning
afternoon
evening
swipe to browse

Certification

  • Professional Diploma in IT - GNIIT from NIIT.
  • SQL/PLSQL from SQLSTAR.
  • ORACLE Financials from ERP.
  • Data Science and Analytics from Quickxpert infotech.

Software

ORACLE

UNIX

Work Preference

Work Type

Full Time

Location Preference

On-SiteRemoteHybrid

Important To Me

Work-life balanceCompany CultureCareer advancementFlexible work hoursPersonal development programsHealthcare benefitsWork from home optionTeam Building / Company RetreatsPaid sick leaveStock Options / Equity / Profit Sharing4-day work weekPaid time off

Timeline

Manager

Ernst & Young LLP
09.2024 - 12.2024

Lead - PLSQL

ASI Analytics
06.2023 - 09.2023

Lead

IRIS SOFTWARE LTD
03.2022 - 05.2023

Senior Software developer

Mindgate Solutions pvt. Ltd
09.2021 - 03.2022

Sr. PL/SQL developer

ASM Enterprise solutions Pvt. Ltd
03.2016 - 08.2021

Sr. Software Engineer

MASTEK LTD
11.2012 - 05.2015

Sr. Software Engineer

DIRECT SOLUTIONS LTD
06.2012 - 11.2012

Senior Analyst Programmer

COMSOFT PTE. LTD
09.2011 - 02.2012

Senior Software Engineer

MPHASIS LTD
01.2011 - 08.2011

Sr. Software Engineer

MASTEK LTD
08.2008 - 11.2010

Sr. Executive

NELITO SYSTEMS LTD, Hewlett Packard
05.2006 - 08.2008

B. Com -

Mumbai University SYJC

Training in SQL & PL/SQL from SQLSTAR -

St. George High School, Mumbai University

SSC -

Mumbai University

Data Science And Analytics -

Quickxpert InfoTech

Professional Diploma - IT

GNIIT -

NIIT

ORACLE FINANCIALS from ERP -

Similar Profiles

CREATE PROFILE
AMIT MORESoftware Developer - Lead/Manager