Santosh Tammannawar

Oracle PL/SQL |ETL|AWS redshift

Talent

Herndon, FairfaxMember since March 9, 2023

Hire this person

Send a job offer directly to this candidate

About

Over 10+ Years of experience in design and development of Software Applications.

Have been lead developer in my team and effectively communicated participated in gathering requirements from clients and worked on solution designing and preparing design documents and doing code changes and getting them reviewed with clients for approvals.

Experienced in requirement analysis, Impact Analysis, High Level Design, Low Level Design, debugging and unit testing as part of software development life cycle (SDLC).

Expertise knowledge on writing complex SQL queries and created various Data Base objects and involved on Oracle performance tuning.

Expertise knowledge on Oracle PL/SQL with solid understanding of key concepts such as utilizing partitions, dbms jobs, Procedures, Functions, Packages, Triggers, Views, Cursors, Materialized Views, Sequence, Dynamic SQL and Synonyms.

Work experience in Pharmaceutical, Telecom and Utility Domains.

Involved in Table creation of different attributes Constraints, Indexes and Referential Integrities.

Worked on PL/SQL Collections, REFCURSOR, BULK_COLLECT and RECORDS.

Experience in SQL Query Tuning and analyzing EXPLAIN PLAN and reduce cost of queries.

Exposure on AWR report analysis, Profiling and Trace process to improve the PL/SQL Block performance.

Proficiency in AGILE/Kanban methodologies.

Involved in the support, maintenance and development of critical systems.

Experience with AWS RDS instances, configuring and maintaining backup, monitoring, and alerting systems for multiple clients.

Good understanding of relational database concepts, data warehouse, Datamart and data modeling on data modeling tools ERwin, Oracle Data Modeler.

Experience with building proof-of-concepts on newer reporting platforms along with building integrations with Java based applications.

2 years of experience with oracle forms and reports, exposure to build and maintain the new forms and reports as per the customer requirement.

Hands-on expertise Dataflow and Power BI

Good knowledge of BI tools like Oracle BI Publisher Report and QlikView.

Familiarity with database CICD process, concepts and tools

Active team player and self-starter with immense ability to grasp and apply new concepts

Ability to work in shifts, preparing root cause analysis and ensuring the action points.

Involved in resolving production problems for the applications and ensure all support service Level agreements (SLA) are met.

Excellent Problem Solving, Analytical and Debugging Skills