Milind Burange
Summary
Total Technical Experience 20 years that includes Oracle SQL & PL/SQL PostgreSQL(Postgres with SQL Alchemy ORM), Snowflakes, Python (with FastAPI / Flask) and Oracle EBS on support + development Experience in all phases of Software Development Life Cycle, (SDLC). Good Experience of Development and Implementation, Team Handling, Sound Functional and Domain knowledge on most of all manufacturing modules.
Overview
23
23
years of professional experience
Work History
Project Leader + Development
FRB – First Republic Bank
06.2015 - Current
- FRB – First Republic Bank is a project which is having different modules in Oracle my responsibility to get the requirement from onsite coordinator and Understanding the business requirements and develop the objects in Oracle like ( Procedure, Functions trigger and Packages) and provide data to Middle ware team like Micro services / TIBCO using the XML schema also working on performance tuning.
Team Lead / Development and Data Conversion
ERP Project for Symantec
06.2011 - 04.2015
- Corp Sustain Support -> SYMANTEC is a project which is having different modules in Oracle Applications 11i development and support for the CRM modules like Oracle Service Contracts, Oracle Install Base along with other custom objects
- Understanding the business requirements in the Oracle Service Contracts, Install Base & Receivables
- Debugging APIs and found the root causes for many issues and provided the solutions
- Developed number of reports and Concurrent programs and PL/SQL procedures and Packages and registered them in the Oracle Applications using AOL
- Supporting the incidents and given the solutions within an SLA
- Managing the team members and helping in providing the solutions for the incidents
- Cloud Migration -> The prime objective is to migrate the sales data from Clear well Database to Symantec ERP Database
- Capturing requirement from OAC and developing New Custom APIs to migrate data into Oracle ERP Clear well Migration -> The prime objective is to Migrate the data from Cloud Database to Symantec Database
- Capturing requirement from OAC and developing Procedure to migrate data.
Sr. Technical Leader / Application Development and Team Handling
eManufacturing - Enhancement and Development
03.2010 - 03.2011
- The prime objective is to make the application available to all PnG employees anytime, anywhere in a cost effective way
- The application is available to employees in the form of individual bundles like eOrganization, eOperations, eLog, Global Benchmark, eLearning, eCalendar and eSecurity
- Each of these bundles have a set of operations defined with it and has played a significant role in building the application
- Responsibilities in this project include1.Requirements and Analysis Understanding the requirements of the client and act as a functional and technical resource.2.Data Base design.3.Handling Database Activity (DBA) like user session management, Creation of Users, Roles, Granting and Revoking privileges
- Data Loading, Backup and Recovery, Performance Tuning, Creation and Management of Tablespaces and Data Files.
Sr. Technical Leader / Performance Tunning and Data migration
Development and Implementation for Vodafone
06.2009 - 02.2010
- Responsibilities in this project include1.Understanding the Templates of the client and working as a Sr
- Technical resource.2.Migration of data as per template 3.Coding (Procedure, Function, Packages and Trigger etc) and Query development for reports.4.SQL Tuning for Reports.5.Data testing and Migration to Production database.
Sr. Technical Leader / Support and Application Development and Team Handling
eManufacturing Systems
09.2007 - 05.2009
- Offshore Daily Support Solving Problems and Enhancement of eManufacturing Application for PnG, Include Database Coding (Modification and New Development of Store Procedure, Functions, Trigger, Packages etc
- Monitoring daily process logs , DBA Activity ( Space Management, Session management, SQL Tuning, Export and Import the Database) and Preparation of Impact Analysis (IA), Work Business Schedule ( WBS ), Detail Design Specification ( DDS ), Project Plan and Technical Support to other resource also Preparing DB Test Cases as well as UTC.
Module Leader / Development and Maintenance
Material Management Systems
04.2006 - 08.2007
- Main objective of these systems is Monitoring Row Material Inventory through GUI systems and Linked with Another Modules like Finance and Planning and Costing
- It comprises Indent, PO, Delivery Challan, Sales order, Issue Slip, MRN, MMT, RM and WIP Stores
- Material receipt and dispatch takes place between 2 locations and multiple departments
- Daily and periodic reports comprises store ledger, stock status statements, Cardex report and various document reports
- Also involve activities like Responsibilities in this project include1.Requirements and Analysis Understanding the requirements of the client and act as a Sr
- Technical resource.2.Creation of Tables and Creation of Schema Object (Procedure, Function, and Trigger).
Module Leader / Development
Planning and Production Dispatch Systems
01.2005 - 03.2006
- Modify in the Existing System like Project Master, Revision Notes, Carton Packing, Manual and Barcode FGMT, Manual and Barcode Invoicing
- Actively participated in the newly developed Cluster Invoice Billing
- Reports comprise Invoice reports, FG Ledger Report, Production, FG Store and Dispatch reports, stock ledger, and various MIS reports
- For Planning - Bill of Material Master (BOM), BOM Copier Utility, Control Chart for RM Transaction, Report for Material Requirement Planning (MRP)
Module Leader / Development
Payroll Systems and Time and Attendance Systems
08.2003 - 12.2004
- Developed forms and Reports for Employee Master, Bank Master, Grade Master, Category Master, Attendance, Earning and Deduction Transaction and Salary processing
- Reports comprise Grade wise / Branch wise salary reports, Monthly and Statutory Yearly Reports for ESIC, PF, Bonus, Form 16 etc
- Develop Form for Leave Punching, Leave Register Report, Daily / Monthly Attendance reports and Other Reports
- System was connected to the attendance machine, which uses proximity cards.
Module Leader / Development
Work Order Tracking Systems
12.2001 - 08.2003
- Production is based fully on the WO, which is raised by the Planning dept depending upon the material availability after performing MRP
- WO and Sub WO are raised for different departments after taking in to consideration BOM and subsequently issue notes are raised to the store
- In Process production is monitored using barcode Guns
- Reports comprise document and MIS reports
- Responsibilities in this project include1.Understanding the technical document and developed the Various Forms and Reports
- 2.Creation of Schema Object (Procedure, Function, Trigger).3.Testing and debugging
Education
B. Sc (Computer) -
J. B. Collge of Science, Wardha, Nagpur University, Nagpur
01.2001
Skills
- Development
- Coding skills
- Oracle EBS
- MM
- Material management
- MRP
- Oracle SQL
- PL/SQL
- Unit Testing
- PostgreSQL
- SQL Alchemy ORM
- Snowflakes
- Cursors
- Procedure
- Function
- Triggers
- Packages
- XML schema
- Python
- FastAPI
- Flask
- Application Performance Tuning
- Design and development
- Interface
- Conversion programs
- Oracle Applications modules
- External packages
- Custom applications
- Import data
- Data migration
- Data integration
- Oracle DB
- Cloud DB
- Automated testing
- Jenkins CI/CD framework
- Test strategies
- Test plans
- Automation test data
- Document
- Mentor
- QA engineers
- Testing framework
- QA process
Consultative Skills
Able to advice the customer on adoption of relevant tools w.r.t the application platforms Proficient in building POCs using latest technologies.
Experience Details
20.0, Oracle ERP - Oracle SQL PL/SQL, Oracle Forms & Reports
Domain Knowledge
Presently working Banking Domain (CIF - Customer Information Facility). Experience in all Manufacturing Domain. (9 yrs. functional experience in Purchase, Warehouse (Stores) and planning department in Manufacturing Industry). Oracle Install Base Service Contract R11i Oracle Order and Material Management R11i
Personal Information
- Passport Number: R4463810
- Passport Date Of Issue: 09/08/17
- Passport Place Of Issue: NAGPUR
- Passport Expiry Date: 09/07/27
Timeline
Project Leader + Development
FRB – First Republic Bank
06.2015 - Current
Team Lead / Development and Data Conversion
ERP Project for Symantec
06.2011 - 04.2015
Sr. Technical Leader / Application Development and Team Handling
eManufacturing - Enhancement and Development
03.2010 - 03.2011
Sr. Technical Leader / Performance Tunning and Data migration
Development and Implementation for Vodafone
06.2009 - 02.2010
Sr. Technical Leader / Support and Application Development and Team Handling
eManufacturing Systems
09.2007 - 05.2009
Module Leader / Development and Maintenance
Material Management Systems
04.2006 - 08.2007
Module Leader / Development
Planning and Production Dispatch Systems
01.2005 - 03.2006
Module Leader / Development
Payroll Systems and Time and Attendance Systems
08.2003 - 12.2004
Module Leader / Development
Work Order Tracking Systems
12.2001 - 08.2003
B. Sc (Computer) -
J. B. Collge of Science, Wardha, Nagpur University, Nagpur
Similar Profiles
Erwin TabuadaErwin Tabuada
Professional Car Detailer / Releasing Officer at PrimoShine Under FRB Prime Inc.Professional Car Detailer / Releasing Officer at PrimoShine Under FRB Prime Inc.
Triya RamhitTriya Ramhit
Administrative Officer at FRB IMMOBILIER LTEEAdministrative Officer at FRB IMMOBILIER LTEE
JULIUS KOFI DARKOJULIUS KOFI DARKO
Credit Executive at Republic Bank Ghana( Republic Boafo)Credit Executive at Republic Bank Ghana( Republic Boafo)
CHRIS SHAHROZIANCHRIS SHAHROZIAN
Learning & Development | CRM Training Lead | Digital Learning & Project Coordinator | CRM Team Leader at DAMAC PropertiesLearning & Development | CRM Training Lead | Digital Learning & Project Coordinator | CRM Team Leader at DAMAC Properties
Juan Ignacio BaierJuan Ignacio Baier
Project Development Leader at Dow ChemicalProject Development Leader at Dow Chemical