DEEPAK VISHWANATH DHOLE

Project Account: Union Bank. (April 2020 - May 2023)

Role: SQL/ETL Developer, SQL/PLSQL, Oracle Developer, and Technical Lead.

Project: RA Replacement: This project is to replace the existing application from Moody's risk analyst tool to the FIS Optimist tool. To support this, we have modified our design and logic according to optimistic architecture, created SQL tables, views, functions, procedures, and packages as per the requirements received from the business.

Responsibilities:

• Analyzed business requirements and functional specifications to build up technical design documents.
• Coordination with the business to understand and implement requirements.
• Developed SQL code, XML views as per requirements for transformation to meet customer goals in SQL (SSIS) and Oracle.
• Creation of tables, views, procedures, functions, and triggers to meet development requirements.
• Performed unit testing, integration testing in the development phase, and UAT environments.
• Preparation of deployment scripts and reference guide for higher environments.
• GIT version, branch creation, code check-in, for the deployment process.
• Coordination with various teams and ensuring successful production deployment.
• Worked successfully with diverse group of coworkers to accomplish goals and address issues related to our products and services.
• Provide support to operation teams during the warranty phase, and ensure knowledge is passed on to operational teams for support.
• Versioning tools used include GIT++ for code check-in, and ALM for defect tracking.
• Worked closely with systems analysts, engineers and programmers to understand limitations, develop capabilities and resolve software problems.
• Promoted high customer satisfaction by resolving problems with knowledgeable and friendly service.
• Assisted with customer requests and answered questions to improve satisfaction.
• Updated and maintained databases with current information.
• Completed routine maintenance and repair.

Project Account: Morgan Stanley (Oct 2017 - March 2020)

Role: Offshore Lead for SSIS, SQL/PLSQL Team.

Project:

1) Risk Ranking: This project is based on the users' rank in the organization (risk ranking in terms of entitlement provision).

2) Business Scorecard: This project is based on the key responsibilities, which indicate the divisional count of heads based on different rules.

Responsibilities:

• Approached customers and engaged in conversation through use of effective interpersonal and people skills.
• Managed time effectively to ensure tasks were completed on schedule and deadlines were met.
• Development of various store procedures, packages, and functions as per requirements - DB and SSIS packages.
• Analyzed code and corrected errors to optimize output.
• Troubleshot technical issues related to database development.
• Developed data structures and change models.
• Git check-in, DB codes, and SSIS packages deployments in higher environments for testing.
• Involved in Tableau dashboard creation as per user requirements.
• Identified opportunities to improve system performance, scalability, and reliability.
• Improved and corrected existing software and system applications (batch operations in terms of time of execution).
• Migration of SSIS from SQL Server version 2005 to SQL Server Integration 2012 and 2016 periodically, including compilations, modifications of SSIS packages, and performance tuning for SQL code.
• Mentored junior developers on coding best practices and standards.

Project Account: Westpac (Dec-2016 to Sep-2017)

Role: SQL/PLSQL Developer

Client Company: TeamWare Solutions.

Project: Production Support.

Responsibilities:

• Evaluated existing applications for defects or improvements in functionality or performance.
• Performed root cause analysis for production incidents and identified permanent fixes.
• Analyzed customer requirements to determine appropriate technology solutions.
• Identified opportunities for process improvements to decrease in support calls.
• Ticket Management and Automation - ServiceNow.
• Resolved customer issues by establishing workarounds and solutions to debug and create defect fixes.

• Project: MTS (Material Tracking System)
• MAMS (Material Accounting & Management System)

Role and Responsibilities -

• Testing of Oracle forms (10g), PLSQL code writing in Oracle, creation of views, and user support in terms of writing complex queries to meet their requirements for the MIS report.
• Generate a report in Excel/PDF format with Oracle Jasper Reports.
• Organized and facilitated regular meetings with senior management teams.
• Prepared staff work schedules and assigned team members to specific duties.
• Created reports summarizing progress against organizational goals and objectives.
• Updated and maintained databases with current information.
• Completed day-to-day duties accurately and efficiently.