Resume

Sign in

Developer Oracle

Location:
Washington, DC
Posted:
October 08, 2018

Contact this candidate

Resume:

SKILLS

Primary:

Database Development,

SDLC, SQL, PL/SQL, T-SQL, Oracle 12c, Oracle 11g, SQL SERVER 2016, Performance Tuning, ERWin, MS-Visio, MS Projects, Control-M, ETL, Shell Scripting, Unix, Linux, Oracle Forms, Oracle Reports

Secondary:

XML, HTML, CSS, JavaScript, Core Java, JSP, Servlets, R, Tableau, PHP, MySQL, Python, Informatica

Currently Self-Learning: AWS, ODI, BI Publisher

EDUCATION

M.S. - INFORMATION SYSTEMS • MAY 2018 • MINOT STATE UNIVERSITY, ND, USA

G.P.A. 3.67/4.00

B.E. – COMPUTER ENGINEERING • MAY 2OO5 • UNIVERSITY OF MUMBAI, INDIA

Class – First Class.

Score – 61.13%

ACHIEVEMENTS

Awards achieved in Institutional Shareholder Services Inc/MSCI Inc

Promoted from ‘Senior Associate’ as ‘Associate Vice President’ in 2016

Promoted from ‘Associate’ as ‘Senior Associate’ in 2013

Awards achieved in Ness Technologies (I) Pvt Ltd

Received ‘Excellence Award’ for Q4 2009

Awards achieved in Patni Computer Systems Ltd

Received ‘Valuable Contribution Award’ for the Q3 2008

Received ‘Letter of Appreciation’ award for the in Q3 2006 and Q1 2007

Received ‘Pat on Back’ award in Q4 2007

Received team award in year 2007

ROHAN DESHMUKH

SENIOR DATABASE DEVELOPER AND DATA MODELER

703-***-**** ac7bbu@r.postjobfree.com WWW.LINKEDIN.COM/IN/ROHANADESHMUKH

SUMMARY

Senior Database Developer with more than 12 years of Application and Data Warehouse Development experience in Finance, Education and Insurance domains. Proficient in Oracle and SQL Server Databases using SQL, PL/SQL and T-SQL languages. Enthusiastically learned, experimented and experienced with various technologies over the years like MySQL, Java, JSP, Servlets, HTML, CSS, JavaScript, PHP, Python, R, Tableau and Informatica.

EXPERIENCE

ASSOCIATE VICE PRESIDENT • ISS INC • AUG 2011 – TILL DATE

Lead Data Engineering Team in identifying, evaluating, implementing, and supporting solutions for OLTP, ETL and OLAP systems based on Oracle 12c, Oracle 11g and SQL SERVER 2016

Conduct various meetings with internal and external stakeholders like business analysts, product managers, and, clients to understand their functional and non-functional requirements. Provide solutions, suggestions and recommendations to rephrase requirements or to bridge gaps between requirement to support all possible use cases without compromising performance, security, usability or maintainability of system. Evaluate estimations, task-breakup (WBS) and prepare plan using MS Project for backend implementation.

Create Use Case Diagrams, DFDs, E-R Diagrams, System Diagrams to support any new development using ERWin and MS Visio. Keep documents up-to-date with any alteration or changes within the system during maintenance phase. Design various batch jobs to automate the data flow for complex financial systems dealing with continuous inflowing and outflowing data.

Implement complex functional back-end requirements on Oracle and SQL Server based code using SQL, PL/SQL and T-SQL.to support Web Applications, backend processes, SQL*Loaders, ETL, Data Warehouse and Data Marts. Mentor and assist junior developers from US and India offices in their day to day activities. Additionally, at times, implemented front-end implementation to support any backend implementation using Core Java, JSP, Servlets, JavaScript, HTML, CSS technologies.

Performance Tuning by Query and Process optimization, studying execution plans, data dictionary tables and AWR reports to identify and fix performance issues. Database monitoring using tools like OEM and Express manager, monitoring shell script as well as manually. SQL Profiling and SQL PLAN Management to stabilize execution plan for a query. Proactive monitoring has helped various systems time to time in minimizing business impact.

Coordinate with DBAs, Business, Testing, and Production Management team pears over ongoing release specific activities and production issues. Work with BI team to understand the reporting needs.

CONSULTANT - ERP • COGNIZANT TECHNOLOGY SOLUTIONS INC • DEC 2010 – JUL 2011

Responsible for entire end-to-end Oracle database designing for an application. Responsible for Conceptual, logical and Physical Data modeling using ERWin and MS Visio.

Performing analysis and designing based on functional requirement documents.

Designing and implementing schemas, tables, indexes, procedures, functions, packages using SQL and PL/SQL on Oracle 11g database.

Unit testing and support for UAT and production deployment and troubleshooting.

Coordinate with DBAs, Business, Testing, and Production Management team pears over ongoing release specific activities and production issues.

SENIOR SOFTWARE ENGINEER • NESS TECHNOLOGOIES INDIA PVT LTD • JAN 2009 – DEC 2010

Work as an Oracle PL/SQL and SQL developer on Oracle 10g and Oracle 11g databases.

Responsible for performing analysis and database designing based on functional requirements. Defining and designing tables, indexes, partitioning strategy, stored procedures, functions, packages, triggers etc.

Data modeling and designing the logical and conceptual model for backend using Microsoft Visio.

Extensive hands on exposure to table partitioning, dynamic SQL. Also implemented VPD concept across application.

Doing performance tuning using TKPROF for PL/SQL code. Performance Tuning of an SQL queries by reviewing execution plans and implement changes to fix performance issues.

Using SQL*Loader and External tables to load data to Oracle Database from external files.

Designing Oracle reports to display calculated end-results of tool.

Shell scripting and AutoSys, CRON JOB scheduling to automate some processes.

Unit Testing, Integration testing & debugging to ensure the quality of final deliverables.

Coordinating with client and Java team. Mentoring new team members and to train them on functionality of application. Monitor their work to ensure achieving deadlines of tasks. Work with BI team to understand the reporting needs.

Perform internal reviews for deliverables

Maintain and monitor the deliverable status

Perform Database Administrator activities like taking Backups, Creation of schemas, Performance tuning etc.

SENIOR SOFTWARE ENGINEER • PATNI COMPUTER SYSTEMS LTD • JAN 2006 – JAN 2009

Work as a Oracle SQL and PL/SQL developer.

Understanding the business requirements and create technical design document based on analysis.

Designing/Enhancing and implementing PL/SQL packages, procedures, functions etc. to implement the required functionality and document them. Shell scripting on HP-UNIX.

Design and enhance Oracle Forms and Oracle Reports as per business requirements.

Provide production support for any data-related issues and to design identification and correction scripts to correct data.

To perform SQL performance tuning using TKPROF.

Creation of Unit Test cases based on design and analysis documents.

Unit Testing, Integration testing & debugging to ensure the quality of final deliverables.

Mentoring new team members and to train them on functionality of application.

Perform internal reviews for deliverables.

Maintain and monitor the deliverable status.

Supervise and mentor junior developers in the team.



Contact this candidate