Resume	DHIRAJKUMAR UTAGE

DHIRAJKUMAR VISHWANATH UTAGE

Email : dhirajkumar.utage1@gmail.com Phone : +919960845272

Experience Summary
 Over 7 years of programming experience as an Oracle PL/SQL ,Shell scripting Developer in Analysis, Design and Implementation of Business Applications .
 Worked inAustralia for 2 years with wealth Management Bank, have client facing exposure and expertise.
 worked with Investment Bank, Worldbankgroup Bank (IFC and IBRD ), & Wealth Management Bank

 Involved in all phases of the SDLC (Software Development Life Cycle) from analysis, design, development, testing, implementation and maintenance with timely delivery against aggressive deadlines.

 Worked in application support and maintenance projects under ITIL Framework

 Expertise in Client-Server application development using Oracle 11g/10g/9i/8i, PL/SQL, SQL *PLUS, TOAD and SQL*LOADER.
 Strong experience in Data warehouse concepts, ETL.

 Experience in SQL performance tuning using Explain Plan,AUTOTRACE

Experience in ETL techniques and Analysis and Reporting .

 Hands on Experience in Python Development.

Worked for 3 Months and Developed pilot project in Master Data Management using Informatica MDM, Informatica ETL .

Created Shell Scripts for invoking SQL scripts and scheduled them using Autosys.

 Excellent communication, interpersonal, analytical skills and strong ability to perform as part of a team.
Technology

Hardware

Qualifications	Software Products	Tools	Methods

Degree and Date	Institute	Major and Specialization	
Bachelor of Engineering/2012	Sveri's College of Engineering, Pandharpur, Maharashtra, India	Electronics & Telecommunication	
Diploma In Engineering/2009	Government Polytechnic ,Osmanabad ,Maharashtra,India	Electronics & Telecommunication	
X/2006	C.J.S Vidyalay, Yenegur,Taluka-Omerga District- Osmanabad, Maharashtra ,India	-	

Project Thesis

1.

Project	Quality Assurance & Production Management -	

Page 1 of 5

Resume	DHIRAJKUMAR UTAGE

	Counter Risk Calculation Team	
Customer	Morgan Stanley & Co. LLC	
Description	Support Executive -
Morgan Stanley & Co. LLC- QAPM 1.Incident Management
2.Problem Management 3.Knowledge Management 4.Autosys Failures 5.Batch Support
6.ITIL framework Process	
Responsibilities	1.Taking Concerns Actions on escalated alerts By L1 Team

2.Daily Support Activity - Running batches and jobs, checking for failures of automated jobs scheduled and if error occurs resolving the same, if not escalate to Development Team.

3.Some programming and debugging duties in order to develop queries/reports of varying complexity and to troubleshoot and fix programmatic issues related batch jobs and production error.

4.Attending project requirements calls with client project managers and business analysts.

5.Works efficiently in outages and delay, effective follow up
with different teams with concerns notification

6.prepairing the knowledge articles for known errors and
Notify to development team for problem management.	
Tools	Unix, Shell scripting, SQL basics, Autosys, Crontab,	

2.

Project	Federal Risk Calculations Platform (Fidrisk)	
Customer	Morgan Stanley & Co. LLC	
Description	Developer -
Development and Maintenance using Oracle PLSQL,Unix	

Page 2 of 5

Resume	DHIRAJKUMAR UTAGE

Responsibilities	Coordinated with the front-end design team to provide them with the necessary stored procedures and packages and the necessary insight into the data.

Worked on Autosys/Unix/Sql scripts to load data from flat files obtained from various facilities every day.

Created and modified several UNIX shell Scripts according to the changing needs of the Batch/project and client requirements.

Involved in the continuous enhancements and fixing of production problems.

Created PL/SQL stored procedures, functions and packages for data movement, data processing as per business requirement.

Created scripts to create new tables, views, queries for new enhancement in the application using TOAD.	
Tools	Oracle PLSQL , Unix ,shell scripting	

3.

Project	CFApps/ACBS -PLATFORM Support and Maintenance	
Customer	WorldBankGroup - International Finance Corporation	
Description	Application Development of CFApps and ACBS Platform applications.	
Responsibilities		Developed SWIFT Messaging Tool using Oracle PLSQL.

(handled all swift message creation and storage using regular expression)

	 Developed Business Loader for reconciliation and summary statement purpose.

	Developed transaction module different to handle 235 types of transaction using DBMS_SQL package and execute immediate

	Created ETL process and transformations for	

Page 3 of 5

Resume	DHIRAJKUMAR UTAGE

	moving the data from staging area to data mart.

	Created scripts to create new tables, views, queries for new enhancement in the application using TOAD.

	Created indexes on the tables for faster retrieval of the data to enhance database performance.

	Performed SQL and PL/SQL tuning and Application tuning using various tools like EXPLAIN PLAN and AUTOTRACE.

	Extensively involved in using hints to direct the optimizer to choose an optimum query execution plan.

	Used Bulk Collections for better performance and easy retrieval of data, by reducing context switching between SQL and PL/SQL engines.

	Extensively used the advanced features of PL/SQL like Records, Tables, Object types and Dynamic SQL, GTT Tables.	
Tools	Oracle PLSQL (11G Version), Unix, Informatica ETL	

4.

Project	Asgard BTFG Platform Support and Maintenance	
Customer	WESTPAC BANKING CORPORATION(BTFG)	
Description	Developer

Application Enhancement and Maintenance (Level 3 / Project Development)	
Responsibilities	Debugging and fixing Production Batch Issues in Business time.

Debugging and fixing Production issues of application developed using PRO-IV Language.

Involved in the continuous enhancements and fixing of production problems.

Writing Datafix scripts using PLSQL to correct production data as per business requirement.

Created PL/SQL stored procedures, functions and packages for new functionalities.

Involved in data loading using PL/SQL calling UNIX scripts to download and manipulate files.

Performed SQL and PL/SQL tuning and	

Page 4 of 5

Resume	DHIRAJKUMAR UTAGE

	Application tuning using various tools like EXPLAIN PLAN,

Extensively involved in using hints to direct the optimizer to choose an optimum query execution plan.

Used Bulk Collections for better performance and easy retrieval of data, by reducing context switching between SQL and PL/SQL engines.

Created PL/SQL scripts to extract the data from the operational database into simple flat text files using UTL_FILE package.

Extensively used bulk collection in PL/SQL objects for improving the performing.	
Tools	PRO-IV, Oracle PLSQL, UNIX, Auotsys, Shell Scripting	

Personal Details

Date of Birth	12/18/1990	
Nationality	INDIAN	

Passport Details

Name as on passport	Relationsh ip	Passport Number	Date of Issue	Expiry Date	Place of Issue	
DHIRAJKUMAR VISHVANATH UTAGE	-	K6772784	08/27/12	08/26/22	NAGPUR	

Page 5 of 5