K Shilpa

• Developed multiple packages, procedures, functions, and triggers for backend programs using PL/SQL.
• Designed logical and physical databases, including star schema design, and identified fact and transaction tables for small business and consumer markets (SBCM) customers.
• Created SQL scripts for database objects such as tables, views, sequences and implemented table partitioning and the snapshot process for data warehousing.
• Monitored and tuned Oracle 12c database performance, analyzed deadlocks, and conducted code walkthroughs and peer reviews.
• Designed ETL processes, loaded customer data from flat files into Oracle tables, and implemented job monitoring and email notifications using Apex 5.0.3.

Environment: Oracle 12c, SQL, PL/SQL, Apex 5.0.3, HTML, Unix, Windows 2007/2010.

• Developed PL/SQL code for updating payment terms and gained experience in C & C programming on UNIX.
• Interacted with business users to gather and analyze requirements, developed ETL process strategies, and provided technical solutions via Minor Development Documents for process change requests.
• Designed database schemas and data mapping for client databases, created star schemas using dimensional modeling, and wrote complex SQL queries and PL/SQL procedures for data extraction.
• Involved in performance tuning and optimization of SQL queries for a large data warehouse, developed PL/SQL packages, procedures, functions, and automated data processes using UNIX shell scripting.
• Designed ETL processes for data extraction, mapping, and conversion, prepared test plans, and created induction manuals and production support documents.
• Created and updated database designs and data models.
  Identified issues within databases, performed troubleshooting and implemented effective solutions.
• Collaborated with cross-functional teams to deliver high-quality database solutions within established project timelines.
• Modified databases to meet needs and goals determined during planning process.