Sudhir Pawar

• Implemented the generated Parque file from Historical Data Generated Monthly & Yearly in FA reports.
• If parque file is available than the report will be generated by reading Parque File else it will be generated from DB

• Create and develop various Oracle objects such as Tables, Views, Triggers, Stored Procedures and Functions in PL/SQL, Packages in PL/SQL and Dynamic SQL.
• Debugging pl/sql code,writing complex queries,optimizing queries.
• Interacting with the Clients and giving them resolutions and Fix.
• Interacting with the front end developers and taking requirements from them.
• Query Tuning & optimization
• Implementation of HRMS - Succession Planning Tool for Uco Bank

• Create and develop various Oracle objects such as Tables, Views, Triggers, Stored Procedures and Functions in PL/SQL, Packages in PL/SQL and Dynamic SQL.
• Debugging pl/sql code,writing complex queries,optimizing queries.
• Interacting with the Clients and giving them resolutions and Fix.
• Interacting with the front end developers and taking requirements from them.
• Query Tuning & optimization
• Developed Data Migration Script To export the Data from Legacy System to New System
• Tuned the Dashboard Screen Handled a team of 5 People as a Scrum Master using the Jira tool.

• Create and develop various Oracle objects such as Tables, Views, Triggers, Stored Procedures and Functions in PL/SQL, Packages in PL/SQL and Dynamic SQL.
• Debugging pl/sql code,writing complex queries,optimizing queries.
• Interacting with the Clients and giving them resolutions and Fix.
• Interacting with the front end developers and taking requirements from them.
• Query Tuning & optimization
• Developed Data Purging Logic for Santander
• Developed Messages (MT!199,MT299,MT192,MT196,MT202) for Remittance Application - DIB
• Designed and developed a dynamic procedure for extracting columns from stub ,to create tables and queries using those columns.

Project Accomplished at 3i-Infotech ltd

Client: Matajir (Saudi Arabia)

Project/Module Name: ULS(Loan Banking System)

About Project: Data Migration Project

My Role and Responsibilities:

• • Create and develop various Oracle objects such as Tables, Views, Triggers, Stored Procedures and Functions in PL/SQL, Packages in PL/SQL and Dynamic SQL.
• • Debugging pl/sql code,writing complex queries,optimizing queries.
• • Interacting with the Clients and giving them resolutions and Fix.
• • Interacting with the front end developers and taking requirements from them.
• • Worked on data Migration Project from their Legacy system to ULS

Client: State Bank of Mauritius(SBM)

Project/Module Name: Finacle

About Project:Worked on Finacle Reports

My Role and Responsibilities:

• • Create and develop various Oracle objects such as Tables, Views, Triggers, Stored Procedures and Functions in PL/SQL, Packages in PL/SQL and Dynamic SQL.
• • Debugging pl/sql code,writing complex queries,optimizing queries.
• • Interacting with the Clients and giving them resolutions and Fix.
• • Interacting with the front end developers and taking requirements from them.
• Writing complex Sqls pertaining to Reports

Project Accomplished at Polaris Technologies Ltd

Client: Citi Bank

Project/Module Name: Real Estate Management SystemsAbout Project: Handling Project related to RealEstate and Lease Management

My Role and Responsibilities:

• • Create and develop various Oracle objects such as Tables, Views, Triggers, Stored Procedures and Functions in PL/SQL, Packages in PL/SQL and Dynamic SQL.
• • Debugging pl/sql code,writing complex queries,optimizing queries.
• • Interacting with the Clients and giving them resolutions and Fix.
• • Interacting with the front end developers and taking requirements from them.
• • Writing PL SQL scripts for RFC(request for Change)

Project Accomplished in Prithvi Infosystem solutions Ltd

Client: ABS

Project/Module Name: American Bureau of Shipping

About Project: Certification of SHIPS to be Launched in the Sea

My Role and Responsibilities:

• • Create and develop various Oracle objects such as Tables, Views, Triggers, Stored Procedures and Functions in PL/SQL, Packages in PL/SQL and Dynamic SQL.
• • Debugging pl/sql code,writing complex queries,optimizing queries.
• • Interacting with the Clients and giving them resolutions and Fix.
• • Interacting with the front end developers and taking requirements from them.

Project Accomplished in TechMahindra

Client: AT & T

Project/Module Name: Job administration Management(JAM)

About Project: JAM is a Job Administration Management tool used by AT&T to handle the complete life cycle of the Job,from order to manufacturing and Sale .it is mission critical software used all over the United Nation.

My Role and Responsibilities:

• • Create and develop various Oracle objects such as Tables, Views, Triggers, Stored Procedures and Functions in PL/SQL, Packages in PL/SQL and Dynamic SQL.
• • Debugging pl/sql code,writing complex queries,optimizing queries.
• • Interacting with the Clients and giving them resolutions and Fix.
• • Running different Cron jobs and making changes to them .
• • Interacting with the front end developers and taking requirements from them.

Client: British Telecom UK

Project/Module Name: Data COE – Keep It Clean

About Project: Loading Cleanse data from Excel Sheet into Oracle Tables as per the Dcmo Tabs i.e Base Tables,Comparing them with BFG Tables using oracle procedures,Generating Discrepancy Report on BFG Rules specified , Calculating Data Quality rowwise & attributewise.

My Role and Responsibilities:

• • Create and develop various Oracle objects such as Tables, Views, Triggers, Stored Procedures and Functions in PL/SQL, Packages in PL/SQL and Dynamic SQL.
• • Loading Cleanse data from Excel into Base Tables using SQL* LOADER.
• • Interacting with the Clients and understanding requirements.
• • Implementing those requirements into Procedures and Generating Data Quality Reports.
• • Interacting with the front end developers and taking requirements from them.

Project Accomplished in Egon software Pvt Ltd

Client: Diarough ltd(Belgium)

Project/Module Name: WebSales

About Project: Websales project that helps Diarough displaying and selling Diamonds to its Customers.

My Role and Responsibilities:

• • Responsible to analyze the requirement from .Net Developers and provide the technical solution for the same.
• • Responsible for Database Security,taking timely backups using Export Utility .
• • Create and develop various Oracle objects such as Tables, Views, Triggers, Stored Procedures and Functions in PL/SQL, Packages in PL/SQL and Dynamic SQL.
• • Creating Tablespace and Users , Importing DMP files.
• • Keeping Logs of the the changes made to Objects ,test them on LocalServer and then upload it on Production Server.
• • Create and develop various scripts to configure the various automated process to allow User to upload the customer Polished Diamonds data in the form of various Excel files into oracle base tables.

Project Accomplished in CharmiSoftware Exports

Client: Diarough Ltd

Project/Module Name: Diamonds Manufacturing System.

About Project: The scope of project is to Keep track of the Diamonds Parcels from Rough to Polish among various locations situated at Belgium,Bankok and Canada and Price Estimation of Polished Diamonds.

My Role and Responsibilities:

• • Responsible for Development and Enhancement of the application using Visual Basic as Front End and Oracle as Backend.
• • Analyze System Requirements to create a Technical Design with the assistance of other Sr. Developers/Architects/Tech. Leads and convert the business requirements to technical understanding, instantiate, iterate, and terminate the code logic to meet the user needs.
• • Design and development of VisualBasic Forms, database structure and PL-SQL to implement business requirements.
• • Design and Development of reports as per the client requirements using Crystal reports Tool
• • Responsible to prepare unit test cases and test plan and conducting unit testing and uploading the changes.
• • Responsible for giving support to the client in their day to day operations.
• • Generating Adhoc Reports for the Client by writing Complex Queries at the BackEnd.