 Experience in technology driven project development, SDLC planning / managing and Business Analysis in the IT sector.
 Strong SQL, PL/SQL background with strengths in initial back-end programming, debugging, troubleshooting and optimizing PL/SQL.
 Ability to develop/maintain applications and write Oracle PL/SQL queries.
 Experience in Linux and Windows environments.
 PLSQL: Procedures, Functions, Packages, Triggers, Cursor, Cursor attributes, Implicit Cursor, Cursor variable. Collections (Varray & nested tables), Operations on whole collection, Manipulating individual element in collection, collection methods Records, Bulk operations and Performance Tuning.
 Proficient in writing SQL, PL/SQL stored procedures, packages and triggers.
 Good communication and interpersonal skills with good analytic power.
 Monitored, troubleshot, and resolved issues involving operating systems.
 Administered workstation configuration and connectivity to servers, databases, and applications.
 Well versed with Unix/Linux to perform unattended operating system installation and configuration
 Expertise in creating procedure, cursor, function, packages and trigger
 Very good conceptual knowledge of Joins, Sub query Object, Nested Table Using Object etc.
 Implemented discretization and binning, data wrangling: cleaning, transforming, merging and reshaping data frames
 Determined optimal business logic implementations, applying best design patterns
 Designed data visualization to present current impact and growth
 Manage a technician that oversees automation and carries out daily tasks.
 Managed, developed, and designed a dashboard control panel for customers and Administrators using Django, OracleDB, PostgreSQL, and VMWare API calls.
 Maintained Oracle, and Postgres DB's
 Wrapper developed in Python for instantiating multi-threaded application and running with other applications
 Experienced in Automation using Shell Scripting.
 Strong Database & UNIX OS troubleshooting.
 Scheduling Backup and Backup scripts.
 Administered the database by resizing the rollback/temporary segments and tablespaces to handle the high volume of incoming data.
 Involved in database administration tasks like security management, space reorganization, performance tuning, etc.
 Performance information and monitoring/interpreting alert log and trace files.
 Wrote several Korn Shell Scripts for auditing ORACLE database
 Designed and developed various SQR reports.
 Trained end users on systems and application.
 Involved in the Unix standards committee for code walk thru of other developers programs.
 Developed batch programs in KSH and wrote Scripts to run them on Unix Cron Scheduler.
 Designed and performed Oracle benchmarks for achieving optimal database performance for the OLTP system.
 Developed object oriented databases with Python and PERL.