Customer Support Sql Developer

PRASANNA GHARE

***, ***** ******, **** **-*, Budhwar Peth, Near ABC Square, Pune-02

Contact: +91-800*******; Email: *************@*****.*** / ***************@*****.***

IT PROJECT ARCHITECT/LEAD/SR. SOFTWARE ENGINEER/DEVELOPER/CONSULTANT

ORACLE/MYSQL/POSTGRESQL/MONGODB/PYTHON/DJANGO/API/AWS PROJECTS DEVELOPMENT/MGMT

18+ Years of Experience including International (Gulf, UK/1.5yrs Exp) in Applications/Projects Design/ Development/ Implementations/Mgmt./Prod. Support in Oracle/MySQL/PostgreSQL/Python/Django/React/Cloud/AWS Applications

PROFILE

Oracle/PostgreSQL/Python/Django Professional with expertise in Several Full Life Cycle Implementations in Oracle/ MYSQL/MongoDB/PostgreSQL/Python/Django/Flask/Machine Learning/AI/API/Cloud/AWS/React/Linux/Unix etc. Applications/ Database environments, Application outsourcing, Project/Application Design/Data Analysis/ Development/ Management/ Administration, Production Support, Product Management, Solution Architecture.

Strong in design, code review data analysis, design development, application/database migration, hands on programming experience using Oracle/MySQL/MongoDB/Python/Django/JS/API/Cloud/AWS/React and related frameworks to develop MongoDB db. related tasks, develop/deploy Oracle Forms/Reports, database objects, optimizing and tuning queries using Advanced SQL and NoSQL enhancements/ad hoc requests, customer support.

Hands on experience MongoDB platform also apart from RDBMS DB using best practices on Sharding and replica set platform setup, manage, maintain, and troubleshoot the database in mongo dB, experience with MongoDB security, managing roles/permissions/MongoDB backups and restores manually and using MongoDB and other tools.

Adhere to SDLC and company policies; experience in Waterfall/Agile/Scrum framework etc., Responsible for testing and debugging software/apps, development of software fixes, enhancements, components, and/or new software systems and applications, working with teammates to fulfill client requirement & user satisfaction with low operational cost. Build solutions that are scalable with best practices.

Strong verbal/written Knowledge on automated test and reporting tools, effective planning, understand business requirements and execution, effective communication, problem solving by analytical/logical approach, works cooperatively within team, builds relationships, and works cooperatively with others, inside and outside the organization, to accomplish results, participate in conduct interviews, and interact with teams.

Currently looking for preferably Remote/WFH based suitable positions or alternately Hybrid model-based positions and can join on immediate basis or within 10 to 15 days only.

CORE COMPETENCIES

Project Management Application Design/Data Analysis & Modeling/Development & Implementation Database Designing Key Account Management Team Management Production Support SDLC

TECHNICAL PROFICIENCIES

Hardware Platforms

IBM e Server X Series, IBM PC Server, IBM PC, Compaq PC, Wipro/Lenovo PC

Operating Systems

Windows NT 4.0, Windows 2000/2003/2007/2010/2011, Windows XP, UNIX/Linux

Programming Methodologies

Object Oriented Analysis and Design, OOPS, Client-Server, Multi-layer, Multithreading

Languages

VB 6.0, C, C#, Python, Django all features & frameworks, HTML, CSS, JavaScript.

RDBMS

Oracle 8i/9i/10g, SQL, PLSQL/D2K, MSSQL, MYSQL, PostgreSQL, MongoDB

Tools and Utilities

Application Servers-W2K, E2K, Oracle 9iAS, MS office suite, ECommerce

Framework & Others

API, Unix/Linux, Cloud, CI/CD, Web/Micro services, API, Rest, React/Redux

Technologies

D2K 6i/10g, Crystal Reports, ERWIN, Clear case, Autosys, Jira, Agile, Scrum

GUI Tools

TOAD, SQL Developer, Tableau, Kognitio, SVN, TFS, GitHub, Vi Editor.

PROFESSIONAL EXPERIENCE

Udemy/Intellipaat Remote/Pune Oct 22-Till date

Learning/growing and upgrading in various Cloud (AWS, microservices), DevOps, Advanced Oracle, SQL, SQL Tuning, Advanced Python, AI, Machine Learning/Django/Flask frameworks, and related tools, React/Redux, Bootstrap, Oracle, MySQL, PostgreSQL, MongoDB, Docker, Kubernetes, Postman, Rest API, multi-processing architecture etc.

Refresh/Update Knowledge in Design/developing Projects using full stack Python/Django/MongoDB/RDBMS/Web development bootcamp and Cloud deployment using CI/CD pipeline, other tools, doing necessary checks, testing, validations, peer reviews, Sharding and replica set platform setup in MongoDB, manage, maintain, and troubleshoot the db. in Mongo dB and RDBMS etc., refresh full cycle/phases of apps design, development, and cloud deployments

Inmar/Harman, Remote/Pune Apr 15-Jul 22

Lead Software Engineer/Sr. Developer-Architect

Responsible for Production support, Database/Apps migration/design/development/implementation, and adhoc requirement enhancements and support and delivery excellence within timelines & customer satisfaction.

Involved in Oracle/PostgreSQL/Python/Django, React/JavaScript/HTML/CSS/Cloud/AWS/Lambda/Git/Rest API etc. Apps design/development, deployment, Code reviews, Post implementations etc.

Design/developing Oracle/PostgreSQL database objects, D2K forms/reports, optimizing queries and adhoc requests

Follow Jira/Git/Agile/Scrum etc. framework/tools to manage tickets/tasks/issues within given timeframes

Involved in code reviews, bugs fix and enhancements, day-to-day support/dev tasks including design, analysis, customization/changes implementations, incidents/ tickets resolution, deployments/testing etc.

Technosoft/Teamware Solutions, Mumbai Sep 13-Dec 14

Solution Architect/Sr. Developer

Involved in Oracle, Forms/Reports, SQL, PLSQL, PostgreSQL, Java/Web/JavaScript Application development using SDLC cycle and Adhoc basis, analysis, design, architecture, development, delivery, unit testing and implementation, code reviews and post implementation, Prod support in BFS domain.

Involved in code reviews, bugs fix and enhancements, day to day support/dev tasks including Forms/reports design/development, testing, implementation, enhancements, and bug fixes, adhoc requirements and reports developments, incidents/SRs resolution and customer support in Oracle/PLSQL/Forms/Reports/PostgreSQL development, deployments/testing, creating UNIX groups/account setup etc.

Closely worked with both Functional Consultants and Technical consultants for perfect setup and implementation.

Datamatics HR & Consultancy Pvt. Ltd, Pune Sep 12-JulL 13

Sr. Technical Leader /Software Engineer

Responsible for client/project management, Data modeling/design/development and delivery excellence within timelines. Involved in Oracle, SQL, MySQL, Python/Web/Java Application development using full SDLC cycle, code reviews and post implementation in finance/insurance domain.

Involved in designing and developing applications using Oracle/SQL/PLSQL, MySQL databases.

Developing applications using Python/JavaScript and related frameworks to develop API in micro services architecture, caching, and messaging queues, design/develop highly scalable and robust applications

Conducting project reviews and identifying risks and ensuring pro-active mitigating of risks

Tech Mahindra Ltd, Pune Dec 10-Jun 12

Sr. Technical Associate /Tech Lead

Responsible for project management; ensuring delivery excellence within timelines & customer satisfaction

Involved in Oracle, PL/SQL, SQL, MSSQL, Unix and DWH Application development using full SDLC cycle,

Data modeling, design, development, implementations, and Production support.

Involved in code reviews, enhancements and bugs fixes and client management.

Conducting project reviews and audits and identifying risks and ensuring pro-active mitigating of risks

Managed new projects and Minor Enhancements solutioning (architecture, design, UAT)

Deftly executed the project by simultaneously managing both onsite & off shore teams. Supported the onsite team by guiding the off–shore team for development of Workflows, conversion scripts and other functional issues

Sears Holding Corp/IBS Software Services P Ltd Oct 08-Aug 10

Sr. Dev Analyst/S/W Engineer, Pune/UAE

Involved in Oracle/SQL/PLSQL/MSSQL project data modeling, design development/architecture support, Ensuring delivery excellence within timelines and new enhancements, data quality/governance.

Coordinating project start-ups and ensuring smooth functioning by dealing with multiple units, Reviewing / managing the project portfolio; tracking project costs/managing budgets, conducting project reviews and audits, and identifying risks and ensuring pro-active mitigating of risks

Managed new projects and Minor Enhancements solutioning (architecture, design, UAT), Led Disaster Recovery Plan solutioning and Business Continuity Plan template development, developed strategy for converting consumer and interaction databases from external systems and executing it, Managed Business Process analysis and mapped Oracle Order management, Inventory modules for some Divisions, Configured and implemented Oracle Order management, inventory modules, and trained the users on the usage

Cognizant Technology Solutions Aug 06-Oct 08

Associate-Projects, Pune

Ranbaxy Labs Ltd/Extranet S/W Solutions Jun 01-Aug 06

System Analyst-DBA, Pune/A.P.

Global Infotech (I) P Ltd/Spreja Engg. Jan 98-Dec 00

Trainee/Programmer, Pune/Mumbai

PROJECTS HANDLED

Organization

Udemy/Intellipaat, India.

Duration

Oct 22-Till date

Platform

Oracle, PostgreSQL/MySQL/MongoDB/Python/AI/ML/Django, React, Rest API /AWS/Cloud etc.

Synopsis

Ecommerce GreatKart/Taskmate etc. Applications: Learning/growing and refreshing knowledge through full stack Python/Web development applications using SQL/MySQL/ MongoDB/Python/ Django, Rest API/JavaScript/HTML/CSS/Cloud/AWS, Lambda/Docker/Kubernetes etc., Involved in Sharding and replica set platform setup in MongoDB, manage, maintain, and troubleshoot the database in Mongo dB and PostgreSQL/MySQL etc., design/developing Oracle/MongoDB/SQL database objects, D2K forms/reports, optimizing queries and ad hoc requests

Organization

Inmar/EXP Pharmaceuticals Corp, USA.

Duration

Apr 15-Jul 22

Platform

Oracle/PostgreSQL/Python/Django, React/JS/HTML/CSS/Cloud/AWS/Lambda/Git/Rest API etc.

Synopsis

Capex/Portal Applications support: Worked/working for Inmar/EXP Projects in Healthcare supply chain, promotion etc. domains and involved in requirements gathering, analysis/design/ development/migration/testing/Performance tuning, code reviews and Deliverables, customer support etc. using Oracle/PostgreSQL/Python/Django, React/JS/HTML/CSS/Cloud/AWS, Lambda/ Git/Rest API etc., doing code reviews, technical documentations, managing development and Prod. Support/ad hoc requests in healthcare/supply chain domain, handling business user needs etc.

Role

Lead Software Engineer/Architect Developer: Production support and its related tasks/activities

Organization

Bank of America/BNP Paribas, Mumbai.

Duration

Oct 13-Nov 14

Platform

Oracle, Forms/Reports, SQL, PLSQL, PostgreSQL, Java/Web/JavaScript, Toad, SQL Developer

Synopsis

Ebusiness/Oracle Financial Reporting: Worked for Bank of America/BNP Projects in finance domain and involved in requirements gathering, data modeling, roadmap/architecture, analysis/ design/ development/testing/Performance tuning and Deliverables; involved in Oracle, Forms/Reports, SQL, PLSQL, PostgreSQL, Java/Web/JavaScript etc. analysis/development, & implementations, AutoSys jobs management, technical documentations, code optimization, Prod. Support and adhoc requests in finance, Ecommerce domain.

Role

Solution Architect/Sr. Developer Lead: Project architecture/design/development and managing Dev/Delivery related activities.

Organization

Aviva, Norwich, UK/India

Duration

Oct 12-Jul 13

Platform

Oracle, SQL, MySQL, Python/Django/Web/Java, Unix, Perl script, SQL Developer

Synopsis

Unisure Development/support: Worked for Aviva UK Project in insurance domain and involved in requirement analysis/roadmap, data modeling/architecture Oracle forms/reports design/ development, Ebusiness application customizations, development, testing, Performance Tuning and Deliverables; involved in developing & implementing std. policies and procedures including design/technical documentations. Managing development/Prod. Support activities in insurance domain, handling business user needs, Involved in basic Administration activities in Oracle/PLSQL, DWH BI and Installations as necessary and data security/governance.

Role

Tech Lead/Software Engineer: Project architecture/design/development/data quality and delivery related activities etc.

Organization

Tech Mahindra Ltd, Pune

Duration

Dec 10- Jun 12

Platform

Oracle 10g, SQL, PL/SQL, MSSQL, DWH, Autosys, SQL Developer, Unix. Shells/Perl Script

Synopsis

Worked for BT Retail Oracle PIM Project and BTGS ANDES EIP Reuters Delivery Project and gone thru BT Process and methodologies for Project and Deliverables and BT Security policies and guidelines. Involved in various Project Management/Architecture, Roadmap/adoption, and Delivery related activities like CFT calls, requirements gathering, analysis/Design/Development/Tuning, and maintaining Deliverables on time. Also involved in QMG/CIT/Audit, delivery/release tracking/management and maintenance/support related activities etc.

Role

Project Development/Management and Delivery/QMG/Prod. Support related activities etc.

Organization

Sears IT & Mgmt India Pvt. ltd, Pune

Duration

Jan 10-Aug 10

Platform

Oracle 10g, MSSQL, PL/SQL, D2K 6i/10g, Unix, Shells Scripts, SQL Loader, Toad, Jira

Synopsis

Retail Development project: Managing Prod. Support activities in retail domain, handling business user needs/ client requirements, involving in data modeling, dev/impl tasks and managing prod. Support activities.

Role

Oracle Specialist/Sr.Developer Lead; Business Requirements gathering/analyzing, Development/ Implementation tasks, Performance tuning and managing Prod. Support related activities etc.

Organization

ADCB Bank, Abu Dhabi, UAE

Duration

May 09-Oct 09

Platform

Oracle 10g, SQL, PL/SQL, MSSQL, Unix/Linux, Shells, Autosys, SVN

Synopsis

Managing various projects/modules like Tracer Project/ Lulu and Touch Point etc. in banking domain, handling business user needs and client requirements, involving in all dev tasks.

Role

Project Leader/Sr. Developer; Business Requirements gathering/analyzing, Architecture/ Design/Development, Implementation related tasks, Deliverables on time, handling with team members and managing client’s requirements etc. RPD/Dashboard/Reports/Answers etc. design/Dev/Implementations/Admin etc.

Organization

CMA CGM Systems, Dubai, UAE

Duration

Oct 08-Mar 09

Platform

Oracle 10g, SQL, PLSQL, D2K 10g, Unix, Shells/Perl Scripting, Toad & IBM Optim Tool.

Synopsis

The Optim Archive Project is mainly used to archive the prod db. (huge tables dormant/old data) into other tables and then shifts them to different schema db. tables and finally delete the dormant data from prod in increase performance, maintain user response time etc.

Role

Team Member/Solution Architect, Requirements gathering/analyzing, Development tasks using Oracle/Unix/D2K/IBM Optim etc., Peer code reviews. Testing, Implementation, Deliverables in time.

Organization

Lloyds TSB, UK

Duration

May 08-Jul 08

Platform

Oracle 9i, PL/SQL, MSSQL, DWH/ETL, Unix, Autosys, Scripting, Toad, SVN.

Synopsis

LTSB Debt Manager: The project involved gathering requirements, architecture, analyzing it and then design/developing the code in Oracle/Unix according to the requirement, test it and then deploy it on to Dev environment and then finally Prod deployment occurs in concern with onsite team. Managing data governance/security and support related tasks.

Role

Solution Architect; requirements gathering/analyzing and development tasks; peer code reviews.

Development

Worked on the Debt Manager Project; performed various tasks as per the team requirements.

Organization

WMC, US

Duration

Nov 07-Apr 08

Platform

Oracle 10g, MSSQL, PLSQL, D2K 6i, Pl/SQL Developer, Autosys, Unix, Shells/Perl Scripts

Synopsis

CFS system: The project involved data modeling, gathering requirements, analyzing it, and then developing forms/reports according to the requirement; testing the form/report and then deploying it on to different env. Like Dev/Test/Stage, etc. and then finally Prod deployment in concern with onsite team. Analyzing/developing queries using Pl/SQL Developer & checking for correct output.

Role

Sr. Developer; requirements gathering/analyzing and development tasks, peer reviews.

Development

Worked on the CFS-Phase II project and performed various tasks as per the team requirements.

Organization

JP Morgan Chase, UK/USA

Duration

Oct 06-Nov 07

Platform

Oracle 10g, SQL, PLSQL, D2K, SQL Loader, Unix AIX 5.2/Shell Scripting, Autosys.

Synopsis

Worked on development/migration and support kind of projects named as TAEOL and GCHP Prod support system. TAEOL refers to Transfer Agency End of Life is purely based on Banking domain. The database migration from 8i to 10g. It contained different modules like Generic Reports, Silver Misc. Reporting, GLI, and CDSC etc. GCHPS aimed to give production support and maintenance to 9 applications like Income Adjustment, DOD, PNI, Chairs, Customer & Accounts, UEA, Triparty Reports, CAM, Profile Seeker related to GCHPS.

Development

Worked on the TAEOL and GCHPS projects and performed various tasks as per the team requirements. Involved in knowledge transfer, analysis, design, development, review, tuning.

Organization

Viacom Corporation, USA

Duration

May 05-Aug 06

Platform

MS SQL 2000, VB 6.0, Dotnet, Vb.net, C#, VSS, MS Office, ERWIN

Synopsis

A Salary Model System Project designed and developed to calculate salary of Viacom employees. Customer Data received from different source systems consolidated and a unique customer record created and validated.

Role

Individual Contributor/Programmer Analyst

Development

Worked on the SMA project and performed various tasks as per the team requirements. Involved in designing, development of new components using tech like Oracle, SQL, PL/SQL, VB, Dot net etc.

Organization

Ranbaxy Labs Ltd, Pune

Duration

Jun 01-Apr 05

Platform

Oracle8i/9i, SQL, PL/SQL, MSSQL, .Net, Unix/Linux, Shells/Perl Scripts etc.

Synopsis

Involved into in house applications data modeling, design/development, and implementations of systems such as HRIS System for providing a user-friendly system in order to maintain all kinds of HR information related of employees and to generate reports of those employees. New Product Checklist System is web-enabled system to have single point responsibility and ownership for new product launch; and Gate Pass system, Prod. Scheduling system etc.

Role

Project Coordinator /Developer- DBA

EDUCATIONAL & PROFESSIONAL CREDENTIALS

MASTER’S IN COMPUTER APPLICATIONS; 1997; Govt. College of Engg. Shivaji University

BACHELOR’S IN SCIENCE; 1994; Shivaji University

PERSONAL DETAILS

Date of Birth: 22nd February 1974 10th/12th/Graduation/PG % Marks: 81%/ 72.33%/ 70%/ 64.35%

References: Available on Request Current Location: Pune (India), Preferred Location: WFH/Remote

Notice Period: 15 days or earlier Name of Current Organization: Inmar Technologies Pvt Ltd, India.

Passport Details: Passport No: V2999695 (Issued at Pune, India)

Date of Issue: 11/10/2021 Date of Expiry: 10/10/2031

Contact this candidate