Srinith Yelti

Email: adc14e@r.postjobfree.com

Phone: 619-***-****

PROFESSIONAL SUMMARY:

●Around 8 years of IT experience in Software Design, Development, Integration, Implementation and Maintenance of Business Intelligence and the related Database Platforms

●Extensive experience in writing/debugging Oracle SQL, Dynamic SQL, PL/SQL code i.e. Packages, Stored Procedures, Functions, Triggers, Cursors, Ref Cursors, Constraints, Indexes, Views, Materialized Views, Database Links (DBLINKS), Sequences, Synonyms, and Global Temporary tables, Cursor management, Exception handling etc.

●Proficient in Data Analysis, Data Validation, Data Lineage Data Cleansing, Data Verification and identifying data mismatch in data loading process.

●Extensively involved in writing SQL Queries (Sub queries and Join conditions), PL/SQL subprograms and Query Level Performance tuning.

●Strong understanding of end-to-end project management, SDLC methodologies of Waterfall and Agile.

●Experience in developing web-based applications using JDK1.3/1.4/1.5/1.6, JAVA/J2EE, Applets, Servlets, JSP, RMI, EJB’s, HTML, CSS, XML, Pro C, XSLT, Ant, Maven, log4j, jQuery, JavaScript and JDBC 2.5

●Knowledge on BRM Resource.

●Performed tuning of an application using Explain Plan.

●Expert in Client-Server application development using Oracle 12c/11g, PL/SQL, SQL *PLUS, TOAD, SQL *LOADER.

●Extensive knowledge and Experience in dealing with Relational Database Management Systems including Normalization, Stored Procedures, Constraints, Querying, Joins, Keys, Indexes, Data Import/Export, Triggers and Cursors.

●Exposure in using Tools like TOAD, SQL Developer and SQL*Plus for writing PL/SQL Programs.

●Good knowledge on Upgrading Oracle Forms Reports.

●Experience in creating complex triggers or generate packages and indexes to increase performance and complex SQL queries for joining multiple tables.

●Extensive experience developing External tables and using Oracle utility tools like SQL*Loader, Import and Export programs.

●Extensively involved in SQL tuning, troubleshooting, debugging, and fixing the codes/scripts.

●Profound knowledge of CC&B architecture, Oracle Utilities Framework, CC&B 2.2, 2.3, 2.4, 2.5, 2.6 functional/technical knowledge.

●Oracle Utilities Customer Care and Billing (CC&B) is a complete billing and customer care application for utilities serving residential, commercial, and industrial customers.

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

●Developed and customized several Oracle Forms and Reports using Forms/Reports builder, Crystal Reports, XML publisher and Discoverer as per client specifications.

●Solid understanding of relational databases.

●Experience with data migration using BULK COLLECT.

●Strong SQL Server DDL, DML skills with expertise in writing efficient queries and troubleshooting complex queries.

●Experienced and fully engaged in Software Development Life Cycle (SDLC) which includes gathering and analyzing business requirements, functional/technical specifications, designing, developing, testing, deploying the applications and providing production support.

●Knowledge in the design and development of interactive data, data visualizations, graphical dashboards and reports using any tools like Tableau.

●Extensive Knowledge on Tableau Desktop, Tableau Public, Tableau Reader and Tableau Server.

●Comfortable with advanced tableau topics such as complex calculations, table calculations, Filters, parameters, data blending, extract optimization.

●Knowledge in Designing & Formatting Dashboards using Tableau.

●Excellent skills in creating SQL objects like Tables, Stored Procedures, Views, Indexes, Cursors, DDL/DML Triggers, Temporary tables, User Defined Data types (UDF) and Functions.

●Quick learner, excellent communication skills and good performer both in team and independent job environments. Never missed the deadline of any projects.

TECHNICAL SKILLS:

Web Technologies

HTML/HTML5, CSS2/CSS3, DHTML, XML, XHTML, XSLT, Pro C, Java, JavaScript, AJAX, jQuery, Oracle Forms, JSON, Apache, PHP, Responsive Design

Languages

SQL, PL/SQL, XML, UNIX Shell Scripting, Perl Scripting, C, C++, Perl programming, Java

Tools

PL/SQL Developer, TOAD, SQL Developer, SQL*Loader, Oracle SQL*Plus, SQL Navigator, PUTTY (Unix/Linux Utilities), Solaris, FileZilla, WinSCP, Jira, ERWIN, APEX

Development Tools

Adobe Photoshop CS5, Google Ad Words, Yahoo Search Marketing (spring tool suite)

Oracle Tools/GUI

Forms 9i/10g, Reports 9i/10g, Discoverer 11g

Databases

Oracle 12c/11g/10g, PL/SQL (oracle), MySQL, MSSQL2008/2012

ConnectiveRX, Pittsburgh, PA

Sr. Oracle Developer Jan 2019 – Till Date

Responsibilities:

Performance tuning of existing jobs: Analyze existing packages and procedures.

Rewrite the existing programs using Collections, Bulk Collect-For All and other PL/SQL concepts for performance tuning.

Create PLSQL procedures and packages for implementing new business logics as requested from business.

Working closely with Infra team for database replication project.

Analyze data in huge tables and understand if archival can be implemented to improve performance.

Administrated and created production, development, and test Oracle 12c/11g/10g/9i databases hosted on Aix, Linux, Sun-Solaris and Windows Server.

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

Designed and developed NoSQL solutions for all users.

Installation configuration and monitoring Antiunity Replicate.

Prepare project planning and implementation schedule.

Developed CC&B Test Cases to ensure all client requirements were covered.

Active involvement in performance tuning of applications.

Review code and Coordinate SIT and UAT activity.

Involved in providing application support and maintenance activities like coordination with Operations in distributed environments.

Developed Unix Shell Scripts for scheduling the jobs and created pre and post session commands.

Involve in conversion of 10g forms into 11g as well as 32-bit to 64-bit Pro C modules and make sure they function as supposed to.

Used JSP, Java Script, HTML, and CSS for manipulating, validating, customizing, error messages to the User Interface.

Expertise in developing Java Beans and Custom Tag Libraries, providing client-side validations in Java Script, and providing interactive front-end GUI using AJAX.

Managed and administered all NoSQL database systems.

Installation configuration and monitoring Antiunity Replicate.

Resources are needed to help support additional applications that will be acquired by our team. They will need to provide run the engine and production support.

Performance tuning of Oracle PL/SQL programs for ETL activity.

Environment: Oracle 11g, Oracle 12c, UNIX, Autosys, PL/SQL, ETL, Windows XP, SQL*Plus, SQL*Loader, Oracle Pro C, Microsoft Excel, TOAD, APEX 4.4.2 SQL, CVS, XML, HTML, CSS, JavaScript.

ResMed Inc, San Diego, CA

Sr. Oracle Developer Jun 2017 – Dec 2018

Responsibilities:

Involved in Development, Implementation, and Testing and Deployment of Business applications using Oracle RDBMS

Involved in developing new screens and modifying existing screens on Forms Builder.

Involved in creating built-in triggers on Forms Builder.

Involved in modifying packages and creating new packages.

Involved in creating new triggers.

Involved in creating design documents.

Perform information gathering tasks. Convert business requirements into functional designs customized for the different subsystems of CC&B and trading partners as required.

Upgrade, maintain and troubleshoot Oracle Forms and Reports

Define scope and solutions for interfacing the Oracle CC&B application with external systems.

A team of Oracle BRM Architects and Senior Consultants interacts directly with business clients to gather their requirements.

The specifications are then implemented in a test environment using Oracle BRM to check the feasibility.

Involved in creating the new stored procedures and wrappers for execution

Written complex SQL queries using joins, sub queries and correlated sub queries

Developed / modified Oracle PL/SQL codes like stored Procedures, Functions, Triggers based on technical and functional specification documents

Used Joins extensively in stored procedures, packages.

Evaluated system performance and validated NoSQL solutions.

Managed and maintained Oracle and NoSQL databases in production domain.

Created Cursors and Ref cursors as a part of the procedure to retrieve the selected data

Developed SQL and PL/SQL scripts to transfer tables across the schemas and databases

Handled errors using system defined exceptions and user defined exceptions

Loaded the data into database tables using SQL*loader from text and excel files

Developed Oracle PL/SQL code based on requests raised by changes in business logic, norms, and standards.

Performance tuning of existing Oracle forms as well as newly created Oracle forms using different built-in as well as User-defined functions and procedures.

Written test cases on stored procedures

Developed Unit Test Plans

Developed Unit Test Cases to test the functionality of the procedure

Written Test case scripts

Developed high level test plan for the whole project

Developed SQL scripts, packages, procedures, cursors, tables, views, materialized views, and functions as per the business requirements

Fine Tuned procedures for the maximum efficiency in various schemas across databases using Oracle Hints, explain plan and Trace sessions for Cost based optimization

Performed Strategic Planning, Logical and Physical Data Modeling & Application Tuning

Tuned SQL queries for new reports for faster response time

Tuned the SQL Queries and Stored procedures for better Performance

Collaborated with other project teams for performance tuning of queries.

Created Oracle Hints and worked on Partition tables in Oracle Database, Dynamic SQL

Created the Project Release Plan for the operations team for deployment

Worked on Teradata database

Worked on SAS Enterprise Guide to pull data from Teradata and Oracle databases

Environment: Oracle 11g, Oracle 12c, PL/SQL, TOAD, SQL Developer, Forms 11g and Reports 11g, SVN, PVCS, Windows XP

Axxera Inc, Irvine, CA

Oracle Developer Sep 2016 to May 2017

Responsibilities:

Interacted with Business users and Business System Analyst to understand reporting requirements and prepared Functional Requirement document.

Provide IT Support for Supply Chain Applications include on-call support.

Escalation handling, Maintain SLA.

Involved in Production support for database and monitored User Interface issues within that application.

Fix production issues on priority basis.

Automated processes as per business requirement

Root Cause Analysis of production issues and providing temporary and permanent fixes for data as well as program.

Develop PL/SQL Procedures, Functions, Triggers and Packages to implement business requirements.

Designed and developed Oracle Forms Reports using Forms11g/10g/6i and Reports11g/10g/ 6i Including Forms based on stored procedures

Created User Schemas, TABLES, INDEXES, SEQUENCES, and VIEWS.

Worked extensively on different types of transformations like expression, union, filter, aggregator, update strategy, lookup, stored procedure, sequence generator, Normalizer, and joiner.

Working as a Technical Lead and Programmer for Supply Chain Activities.

Incident management, Request management and Change management – CA service desk, Mercury QC and HP Project Portfolio Management.

Handling job schedules and dependencies using Job Scheduler: CA Workload (Autosys)

Worked on Tuning of the SQL queries, which takes long time to process the request using Explain Plans to reduce the response time.

Worked on PL/SQL to develop stored procedure to manage data flows and external data distribution interfaces.

Built and maintained SQL Scripts, Indexes, reports and queries for data analysis and extraction.

Analyzing the code written by different developers to understand the transformation applied on columns to document them.

Created Range and List Partitions as per the requirement needed.

Understand requirements through regular interaction with business analysts and end users at client’s office.

Identifying areas of system enhancement and submitting the business proposal to customers.

Clarifying the issues of the team members and help them in the proper execution of the project.

Providing Supply Chain training sessions to new team members.

Providing UNIX/PLSQL training sessions to new team members.

Environment: Oracle 12.1, PL/SQL, TOAD, SVN, Visio, Ab Initio (GDE 3.2.5.1; Co-Operating System 3.2.5.2), Windows XP

Design point - Hyderabad, India

Oracle Developer (PL/SQL) Jan 2013- July 2015

Responsibilities:

Involved in Development, Implementation, and Testing and Deployment of Business applications using Oracle RDBMS

Loading test files into Unix environment using FTP client i.e. Core FTP

Involved in testing files in development and production by running Unix shell scripts

Tested the file by running audits on a file using shell script

Transferring encrypted files from client server to vendor server for the vendor to pick those encrypted files using his private key.

Running shell scripts to update the tables with the raw data in the files

Handled ADHOC requests from the Business System Analysts to re-set profanity email for a consumer id

Handled ADHOC request from the BSA’s to re-set deceased setting for a consumer id

Encrypting a file as per the request of BSA

Decrypting a file as per request of BSA

Adding a PGP key to the public key ring

Updating ACE directories on development and production with the latest data as per USPS and running audits on them

Handled tasks when things break in production as scheduled by maestro

Updating maestro calendar with holidays for jobs to run as scheduled

Handled tasks when an ABEND alert is created on production which run overnight everyday by debugging logs and the Korn shell scripts involved in that job

Involved in data sweeps when BSA requests to update a table

Involved in killing jobs when they get stuck and re-running the jobs on CONMAN

Involved in debugging the code when BSA request the reason for the populated data

Worked with BSA’s for doing QC (quality check) after running the audit and update Korn shell scripts

Involved in modifying packages and creating new packages.

Involved in creating new triggers.

Involved in creating design documents.

Involved in creating the new stored procedures and wrappers for execution

Written complex SQL queries using joins, sub queries and correlated sub queries

Developed / modified Oracle PL/SQL code for stored Procedures, Functions, Triggers based on technical and functional specification documents

Used Joins extensively in PL/SQL code development.

Created Cursors and Ref cursors as a part of the procedure to retrieve the selected data

Handled errors using system defined exceptions and user defined exceptions

Loaded the data into database tables using SQL*loader from text and excel files

Developed Oracle PL/SQL code based on requests raised by changes in business logic, norms, and standards.

Written test cases on PL/SQL code developed

Developed Unit Test Plans

Developed Unit Test Cases to test the functionality of the procedure, function, package, trigger, views

Written Test case scripts

Developed high level test plan for the whole project

Developed SQL scripts, packages, procedures, cursors, tables, views, materialized views, and functions as per the business requirements

Fine Tuned procedures for the maximum efficiency in various schemas across databases using Oracle Hints, explain plan and Trace sessions for Cost based optimization

Performed Strategic Planning, Logical and Physical Data Modeling & Application Tuning

Tuned SQL queries for new reports for faster response time

Tuned the SQL Queries and Stored procedures for better Performance

Collaborated with other project teams for performance tuning of queries

Environment: Oracle 11g, PL/SQL, SQL Developer, Core FTP, GNUPG (Secure Communication), TOAD, Forms 11g and Reports 11g, Unix Shell Script, Putty, Maestro, Windows XP, Ultra Edit

VolkSoft Technologies, Hyderabad, India

Oracle Developer (PL/SQL) April 2011 – Dec 2012

Responsibilities:

Written complex SQL queries using joins, sub queries and correlated sub queries

Developed PL/SQL procedures, functions, packages, and triggers

Created Cursors and Ref cursors as a part of the procedure to retrieve the selected data

Developed SQL and PL/SQL scripts to transfer tables across the schemas and databases

Handled errors using system defined exceptions and user defined exceptions

Loaded the data into database tables using SQL*loader from text and excel files

Developed SQL scripts for Referential Integrity check, which checks validity of incoming data with master tables in database

Worked on Oracle Hints. Partition tables in Oracle Database, Dynamic SQL

Developed SQL scripts, packages, procedures, cursors, tables, views, materialized views, and functions as per the business requirements

Fine Tuned procedures for the maximum efficiency in various schemas across databases using Oracle Hints, explain plan and Trace sessions for Cost based optimization

Performed Strategic Planning, Logical and Physical Data Modeling & amp, Application Tuning

Tuned SQL queries for new reports for faster response time

Developed application using Oracle Forms & amp, Reports

Involved in creating INDEXES to avoid the need for large-table, full-table scans, and disk sorts, and for fast retrieval of data from database objects

Tuned the SQL Queries and Stored procedures for better Performance

Optimized the performance of queries by Data Manipulations which includes modifications in SQL queries, removed unnecessary columns, eliminated redundant and inconsistent data, normalized tables, established Joins and created clustered/non-clustered indexes wherever necessary

Modified existing packages, procedures, functions, views, and triggers to handle new database design

Collaborated with other project teams for performance tuning of queries.

Environment: Oracle 10g/11g, PL/SQL, SQL * Plus, Oracle Forms and Reports, SQL Developer, Unix.

Contact this candidate