Sql Developer Software Development
Resume:
Ramdas Yadav
***********@*****.***
Professional Summary:
Over 16+ years of programming experience as an Oracle PL/SQL Developer in Analysis, Design and Implementation of Business Applications using the Oracle Relational Database Management System.
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.
Experience with Data flow diagrams, Data dictionary, Database normalization theory techniques, Entity relation modeling and design techniques. Expertise in Client-Server application development using Oracle 12c/11g/10g/9i/8i, PL/SQL, SQL *PLUS, TOAD and SQL*LOADER.
Effectively made use of Table Functions, Indexes, Table Partitioning, Collections, Analytical functions, Materialized Views, Query Re-Write and Transportable table spaces.
Good knowledge on logical and physical Data Modeling using normalizing Techniques.
Created Tables, Views, Constraints, Index (B Tree, Bitmap and Function Based).
Developed Complex database objects like Stored Procedures, Functions, Packages and Triggers using SQL and PL/SQL.
Developed materialized views for data replication in distributed environments.
Experience in Oracle supplied packages, Dynamic SQL, Records and PL/SQL Tables.
Loaded Data into Oracle Tables using SQL Loader.
Partitioned large Tables using range partition technique, experience with Oracle Supplied Packages such as DBMS_SQL, DBMS_JOB and UTL_FILE.
Worked extensively on Ref Cursor, External Tables and Collections.
Expertise in Dynamic SQL, Collections and Exception handling.
Good knowledge of key Oracle performance related features such as Query Optimizer, Execution Plans and Indexes.
Experience with Performance Tuning for Oracle RDBMS using Explain Plan and HINTS.
Created Perl Scripts for invoking SQL scripts and scheduled those using TWS.
Having good knowledge of Incident management, Problem Management & Change management process.
Good knowledge of VB 6 and Basic knowledge of VB .Net & Java technology.
Excellent communication, interpersonal, analytical skills and strong ability to perform as part of a team.
Technical Skills
Databases: Oracle 9i/10g/11g/12c/19c(SQL,PL/SQL, Procedure, Function, Packages, Triggers, SQL Loaders..)
Reporting Tools: Crystal Report, Oracle Reports 6
Operating Systems: UNIX(Sun Solaris, Linux), Windows
Programming Languages : SQL, PLSQL, Core Java, XML, VB 6.0, Unix shell scripts,XML
Source Control: SVN, Git
Educational Qualification:
Bachelor of Engineering (Information technology) in 2005
Professional Experience:
PLSQL Developer, Atos Syntel INC, Troy, Michigan Aug 2022 to till Date
Client: Volkswagen NAM, Auburn Hills, Michigan, USA.
Design, develop, support, and deliver solutions using multiple technologies including ORACLE SQL, PL/SQL JAVA/J2EE, Angular Js, and Unix, Perl Script etc.
Creating packages, procedures, functions, triggers, tables, views.etc.
Proactive/Reactive performance tuning of oracle queries and procedures functions.
Preparing Oracle Queries and Excel templates based on client requirements to ease processing of the business users’ requests.
Maintain/Enhance the oracle reports written in oracle developer 6i.
Improved the month end process execution by almost 50% by changing the logic, oracle queries, joins, bulk operations used in month end process.
Resolved the row locking issue by adding pragma autonomous transaction pragma
Review the database changes done by offshore team and guide them wherever required.
Prepare projects specific daily/weekly/Monthly reports for higher management.
Work on customer specific application ETA, application defects and apply appropriate fixes and make enhancements to the application to meet customer requirements.
Maintain currently developed applications and support business in technical issues arising in incident management, service requests, problem management and enhancements/projects.
Analysis of BSR documents and prepare estimate for them
Preparing the project related documents for future reference.
Executing daily incidents, service request, changes & problem tickets reported through Service Center 3.0 ticketing tool and completing them on time.
Admin related activities including jobs monitoring and analyze the Unix job alerts
PLSQL Developer, Atos Syntel, Pune, India Dec 2015 to Aug 2022
Client: Volkswagen NAM, Auburn Hills, Michigan, USA.
Design, develop, support, and deliver solutions using multiple technologies including ORACLE PL/SQL JAVA/J2EE, Angular Js, and Unix, Perl Script etc.
Creating packages, procedures, functions, triggers, tables, views.etc.
Proactive/Reactive performance tuning of oracle queries and procedures functions.
Improved the data loading time to load the data from factory system to sales system by 70% by replacing sequential data processing with SQL loader. This will make the data available for processing within short span of time.
Maintain/Enhance the oracle reports written in oracle developer 6i.
Improved the oracle report loading time by 40% by adding performance tuning parameters, change the queries and adding indexes.
Manage team of 24 people and guide them technically/ functionally whenever required.
Attend daily/weekly/Monthly customer meetings.
Prepare projects specific daily/weekly/Monthly reports for higher management.
Work on customer specific application ETA, application defects and apply appropriate fixes and make enhancements to the application to meet customer requirements.
Maintain currently developed applications and support business in technical issues arising in incident management, service requests, problem management and enhancements/projects.
Analysis of BSR documents and prepare estimate for them
Preparing the project related documents for future reference.
Executing daily incidents, service request, changes & problem tickets reported through Service Center 3.0 ticketing tool and completing them on time.
Admin related activities including jobs monitoring and analyze the Unix job alerts
PL/SQL Developer, Atos Syntel, Pune, India Jun 2014 to Dec 2015
Client: Benjamin Moore, NJ, USA.
Creating packages, procedures, functions, triggers, table, views ... etc. as per the client request.
Performance tuning of oracle queries and procedures functions.
Preparing the project related documents for future reference.
Executing daily requests for data additions, updating both manually and through SQL mass load files, reported through SDM12 ticketing process and completing items accordingly.
Executing daily incidents, service request, changes & problem tickets reported through SDM12 ticketing tool and completing them on time.
Preparing Oracle Queries and Excel templates based on client requirements to ease processing of the requests.
PL/SQL Developer, RSystems International Ltd, Pune, India Dec 2012 to Jun 2014
Client: SGVF, Vietnam
Active participation of migration of SFVF bank’s existing loan processing, repayment and collection software to Rsystems application.
Data migration from old system to new system by using oracle queries, SQL Loader, or creating master tables.
Created the required indexes on table to improve the performance.
Proactive performance tuning by generating AWR and ADDM reports and tune the reported queries as much as possible.
Add the partitions wisely on newly created database to keep the database performance upto date for the OLTP transaction.
Design and develop of LOS oracle workflow procedures in oracle and integrate it in application.
Active participation in oracle migration from 10g to 11g
Develop web pages using XLS and java based framework and java script as per the client request as a part of change request.
Improved the End Of Day (EOD) process by 75% by adding indexes, hints, parallel executions, increasing no of open cursors.
Perform end to end testing of the applications and Error casual analysis.
Creation of project level documents like function specification, program specification
Performance tuning of oracle objects as well as SQL’s used in application.
PL/SQL Developer, RSystems International Ltd, Pune, India Apr 2012 to Dec 2012
Client: Security Bank, Philippines.
Developed most of the database packages, procedures, functions, views, triggers, tables….
Performance tuning of oracle objects as well as SQLs used in application.
Implemented the interface with 16 Credit score companies to download the required data from them and process it in LOS (Loan origination System).
Developed whole dedupe process including external as well as internal dedupe while processing the loan application.
Developed all interfaces with client third party system using java classes.
Setting up and maintain UAT, SIT and production environment from offsite.
Analyze the change request and prepare the documents like Impact analysis, functional specification …
Prepare unit & integration test scripts.
Review the work done by team members.
Creation of project level documents like functional specification, program specification...
System Analyst, AESSEAL India Pvt Ltd, Pune, India Aug 2008 to Apr 2010
Client: AESSEAL PLC, UK
Develop packages, procedures, functions, triggers…etc. as per the client request
Develop asp.net forms as per the client request
Creation of different types reports in crystal reports tool and integrate them in application.
Perform Unit & Integration testing
Implementation changes on production.
Resolution of integration as well as production issues.
Conduct code reviews.
Software Developer, Rajdeep Info-techno Pvt Ltd, Pune, India Oct 2006 to Aug 2008
Developing the Oracle package, procedure, function... Etc. and frontend forms in VB6.0
Understanding client requirements and prepare the documents.
Perform Unit & Integration testing
Resolution of production issues
Individually supported whole application.
Creation of reports in crystal report.
Personal Details:
Date of Birth Jul 4th, 1982.
Gender Male
Marital status Married.
Passport number U4442114
VISA Type H1B
Contact this candidate