Summary
Overview
Work History
Education
Skills
Certification
Accomplishments
Timeline
Generic

Satya Sambangi

Pittsburgh,PA

Summary

Over 15+ years of programming experience as an Oracle PL/SQL Developer and experience with production support activities. Excellent communication, analytical, interpersonal skills, and strong ability to perform as part of team.

Overview

18
18
years of professional experience
1
1
Certification

Work History

Product Development Support

QGenda
11.2021 - Current
  • Archiving and posting the data files for all clients based on their request
  • Handling all production support calls and fixing the user access issues
  • All the migration needs and disabling users access after moving to new product
  • Gathering the client requirements, estimating the LOE and defining the timelines

PL/SQL Developer

Schedule360
10.2007 - 10.2021
  • Schedule360 is an advanced centralized scheduling system for hospital nurses, staff and pharmacy stores
  • Self-scheduling shifts, availability postings, shift swaps, vacations, set schedule rotations, shift search criteria, messaging to peers and customized reporting
  • Worked on database design, roles and privileges, application development, SFTP file feeds to third party products, and coordinating with data center team.
  • Gathering the client requirements, estimating the LOE and defining the timelines
  • Designed tables, indexes, integrity constraints, roles and privileges
  • Developed PL/SQL packages, procedures, functions, materialized views, Unix shell script for automate SFTP file feeds, data loads using SQL*Loader
  • Implemented Bit map indexes, B-tree indexes, oracle hints, CTE queries, analytic functions, collections, merge statements, bulk collect, forall etc. in performance tuning.
  • Production Support

Education

Master of Commerce -

Andhra University
India

Skills

  • Oracle 10g, 11g, 12c, 19c
  • Performance Tuning
  • SQL Query Optimization
  • PL/SQL and SQL Expertise
  • Stored Procedures, Packages, Functions, Triggers
  • Toad, Oracle SQL Developer, SQL Loader
  • Oracle APEX, JSON
  • Advanced SQL Queries (CTE)
  • Oracle Analytical functions
  • SFTP file Transfers
  • JIRA, Servicenow, GIT
  • Oracle OEM, AWR, ADDM, TkProf and Explain Plan
  • HTML, Javascript and CSS

Certification

  • Oracle APEX Cloud Certified Developer Professional
  • Oracle Database PL/SQL Developer Certified Professional
  • Oracle Database SQL Certified Associate

Accomplishments

  • Involved in complete design and development life cycle of application
  • Improved customer satisfaction by handling production support and deliverables.
  • Improved performance by tuning SQL, PL/SQL and creating and rebuilding Indexes.
  • Successfully finished integrations with EPIC, ETIME, Payroll and Analytical systems

Timeline

Product Development Support

QGenda
11.2021 - Current

PL/SQL Developer

Schedule360
10.2007 - 10.2021

Master of Commerce -

Andhra University

Similar Profiles

CREATE PROFILE
Satya Sambangi