Professional Summary

*.* Years of competitive work experience in Software Development using Oracle 19c/12c/11g/10g/9i, SQL, PL/SQL, Big Data – Apache Hadoop, UNIX Shell Scripting, Python as Senior developer.

Proficient in Analysis, Design, and Implementation of Business Applications using the Oracle Relational Database Management System.

Good knowledge on Oracle tools like SQL * PLUS, PL/SQL, SQL Developer and TOAD.

Good knowledge on Big Data tools like Hive, Impala, Spark.

Expertise in creating Oracle objects like Tables, Synonyms, Triggers, Indexes, and Views.

Extensively involved in creation of Complex SQL queries, Performance Tuning, PL/SQL Stored Procedures, Functions and Packages for business needs.

Developed Test Scripts, Test Cases, and SQL QA Scripts to perform Unit Testing, System Testing, Load Testing and integration testing.

Worked in various levels of SDLC (System Development Life Cycle), which involves Analysis, Design, Development, Testing, Implementation and support with extensive exposure in database.

Enthusiastic and eager to learn new tools, pro-active and quick learner.

Skills Profile

Technical

Operating System

Windows 2007/2008/2012/2017, Windows 7, UNIX, Linux

Database

Oracle 9i/ 10g/ 11g/12c/19c, SQL Server, Apache Hadoop

Tools

Toad, SQL Developer, SQL Plus, Apache Hive, Impala, Apache Spark, Spark SQL, GIT, TeamCity, Agile Rally & Jira

Languages

SQL, PL/SQL, HQL, HTML, C, C++,Python, Shell Scripting

Other

Data Modeling, Relational Modeling

Functional

Training & Development

Mentored team members and new joiners, Good in logical, problem resolving & debugging skills

Trainings & Certifications

Oracle Certification - Oracle PL/SQL Developer Certified Associate

Professional Experience

Client Name

Barclays

Project Name

Mercury Data Sourcing

Project Duration

October 2015 to Present

Role/Title

Senior Database Developer

Work Location

Whippany, NJ, USA

Project Description

CCAR is an annual comprehensive capital analysis and review tool, which represents a substantial strengthening approach of Federal Reserve Bank to ensure that large BHC’s have through, robust process and sufficient capital to continue its operations managing and allocate their capital distributions. The Federal Reserve expects large, complex BHC’s to held sufficient capital and maintain access to funding, to continue to serve as credit intermediaries, to meet their obligations to creditors and counterparties, and to continue operations even in adverse environment.

Responsibilities

Analyzing the business requirements of the project by studying the Business Requirement Specification document.

Understanding the business process flow and analyzing the requirements. Prepare HLDs (High Level Designs) and Technical Designs for requirements.

Converting logical data model to physical data model by creating all the relevant objects like Tables/GTT/Views/Indexes/Sequences/Constraints in the database.

Configuring the static data in the database based on business needs for the application.

Maintaining all the source code in the version control tool GIT.

Supporting all the Release process by migrating the code from one environment to another and finally to Production Go-Live.

Performing the Post sanity checks after every DB release happens in production to ensure no errors and the environment is error free.

Maintaining the sources after every release in the GIT release branches.

Supporting building new database schemas both on Oracle and Hive using the sources from GIT

Supporting data migrations in Oracle/Hive databases in different environments based on business needs.

Performing Post sanity checks after data migration and releasing the environment to developers.

Comparing two schemas in Oracle/Hive once the data is copied by DBA to ensure the environment is ready to be used.

Handling ad-hoc requests from application developers like data copying or objects creation or releases in different environments like DIT/CIT/SIT/UAT.

Creating Custom Packages, Procedures, and functions according to the business requirement.

Involved in SDLC using Agile methodology including designing, coding and testing.

Created database objects like tables, views, procedures, packages using Oracle tools like SQL* Plus, SQL Developer and TOAD.

Created & maintained Indexes and sequences for faster retrieval of the information and enhance the database performance.

Operating Systems

Oracle EXADATA, Windows 2008/2012/2017, Windows 7 & 10

Software / Tools

Oracle 11g/12c/19c, Apache Hadoop, Toad, SQL Developer, SQL Plus, Apache Hive, Impala, Apache Spark, GIT

Languages

Oracle SQL, PL/SQL, HQL, Shell Scripting, Python

Organization Name

Streamline Health Inc.

Project Name

Clinical Analytics (Looking Glass), Access Any Where

Project Duration

May 2014 to September 2015

Role/Title

Software Engineer

Work Location

New York, NY, USA

Project Description

Clinical Looking Glass is an inquiry engine whose design functionally creates a “quality of care ontology” reusing/including/repurposing familiar on to logic concept in the healthcare space through the imposition of new relationships that define a quality assessment ontology. Clinical Looking Glass (CLG) copies event data from the medical record. An event is anything that happens to an individual. Examples include laboratory tests, echocardiograms, admissions, medications, birth, and death.

Responsibilities

Understanding the business process flow and analyzing the requirements. Prepare HLDs (High Level Designs) and Technical Designs for requirements.

Created Custom Packages, Procedures, and functions according to the client’s requirement.

Involved in Agile including Planning & Estimation, Sprints, Retrospective Analysis.

Performing manual testing of the product by creating unit test cases.

Creating database objects like tables/views/indexes/triggers etc

Operating Systems

Windows 2003/ 2008 / 2012

Software / Tools

Oracle 9i/10g, SQL Developer, TFS, Visual Studio, SQL Plus, MS SQL Server

Languages

SQL, PL/SQL, Shell scripting

Organization Name

SIEMENS Technology and Services Private Limited, India

Project Name

Syngo, Syngo-via

Project Duration

July 2008 to January 2013

Role/Title

Senior System Engineer

Project Description

syngo.via is the universal imaging software for 3D reading and advanced visualization. Multi-user, multi-modality, and multi-disciplinary, it streamlines radiology, links departments, and connects sites. It brings a new level of quality and efficiency to all your viewing, reading, and reporting processes. syngo.via is a smart, scalable imaging software that works for everyone: from practices to clinics to hospital chains. With the ongoing shift to value-based imaging, interoperability is critical for interlinking imaging with patient care. syngo Workflow offers a platform that is patient, user, and management-centric to drive efficiencies in radiology from the enterprise down to the user.

Responsibilities

Configuration management:

ClearCase and MultiSite VOB administration using SY tools and scripts

Defining triggers according to the project requirements and implementing triggers using Perl, Installation/Up gradation of ClearCase and Windows patches

Metrics collection, Main review support activities, ClearCase and MedMake user support, Configuration management:

ClearCase and MultiSite VOB administration using SY tools and scripts

Defining triggers according to the project requirements and implementing triggers using Perl, Installation/Up gradation of ClearCase and Windows patches

Metrics collection, Main review support activities, ClearCase and MedMake user support, View/VOB servers and build clients maintenance

Involved in installation of project software (like Adobe Framemaker, Primal script & SnagIT and few Rational Tools)

Build and release activities:

Setup Build environment for new projects, setup ClearCase and build environment for new machines and new projects.

Involved in configuration of build environment and timely delivery of builds/packages

Took the ownership of SY developed Non-Product Software’s

Contributed towards improving build performance/process

Pre-Release activities, CD-Production as part of Release activities

LTA performed for released versions View/VOB servers and build clients maintenance

Involved in installation of project software (like Adobe Framemaker, Primal script & SnagIT and few Rational Tools)

Build and release activities:

Setup Build environment for new projects, setup ClearCase and build environment for new machines and new projects.

Involved in configuration of build environment and timely delivery of builds/packages

Took the ownership of SY developed Non-Product Software’s

Contributed towards improving build performance/process

Pre-Release activities, CD-Production as part of Release activities

LTA performed for released versions

Operating Systems

Windows 2003/ 2008, IBM AIX, UNIX

Software / Tools

Oracle 10g/11g, SQL Developer, UNIX Shell, Perl, ClearCase

Languages

SQL, PL/SQL, Shell, Perl, C++

Education

Educational Record

Course of Study

Specialization

Name of University

Address of University

Year of Completion

Master of Science

Computer Science

New York Institute of Technology

1855 Broadway, New York, NY, USA 10023

2015

Bachelor of Engineering

Computer Science

Visveswaraiah Technological University

Belgaum, Karnataka, India

2008

Professional Organizations

Work Experience Details

Organization’s Name

Designation

Dates of Employment

Location

Explanation for Interruption / gap

From

To

Synergy Global Technologies Inc.

Senior Consultant

01-Oct-2019

Present

Whippany, NJ

IDC Solutions

Senior Consultant

13-Aug-2018

12-Aug-2019

Whippany, NJ

Capgemini America Inc.

Senior Consultant

05-Oct-2015

31-May-2018

New York, NY

Streamline Health Inc.

Software Engineer

21-May-2014

04-Sep-2015

New York, NY

Joined College to continue my education, Master of Science

Siemens Technology and Services Private Limited

Senior Software Engineer

11-Jul-2008

31-Jan-2013

Bangalore, Karnataka

Contact this candidate