CHANDRA KOTHMIR

ad260o@r.postjobfree.com

703-***-****

Summary: -

An Assertive professional with 7 + years of IT experience handling all phases of SDLC like analysis, design, development, implementation and deployment of large software products in both Client/Server and Web Server Environment.

Experience in Design, Development, and Enhancement and Maintaining applications in Oracle 9i/10g/11g/12c using SQL, PL/SQL.

Expertise in Database Design, Development, and Enhancement and Maintaining using Oracle 12c/11g/10g/9i/8i, Web deployment, PL/SQL Forms 10g/9i, Oracle SQL Loader in Windows and UNIX environments.

Experience in report writing using SQL Server Reporting Services (SSRS) and creating various types of reports like drill down, Parameterized, Cascading, Conditional, Table, Matrix, Chart and Sub Reports.

Proficient in PLSQL programming, designed and developed Stored procedures, Functions, Triggers, and Packages to provide database access and manipulation functionality

Developed and Automated batch load process using SQL*Loader, Shell scripts and Crontab

Used oracle features like Collections, Ref cursors, Analytical functions, Global temp tables, External tables and Materialized views

Expertise in database performance, data warehouse, ETL, SQL queries, PL/SQL procedures, packages, functions, cursors, triggers, interfaces and data conversion using PL/SQL, SQL*plus, TOAD, and SQL developer & full suite of Oracle Tools including development and customization of Oracle Developer (Reports & Forms) and Oracle discoverer.

Education:

Bachelors in computer science,2013, JNTU

Masters in computer science, 2016, CALUMS

Technical Skills: -

Databases

Oracle 8i/9i/10g/11g/12c, MySQL 5, MS SQL SERVER 2005/2008, DB2/UDB, SAP Tables and MS Access

Other Technologies

HP Project and Portfolio Management (PPM), HP ALM/QC, Oracle E-Business Suite 12, Oracle Recovery Manager (RMAN),

Programming Languages

SQL, PL/SQL, Unix shell scripts, SAS, C/C++/C#, Perl, XML, HTML, VB.NET

ETL Tools

IBM Info Sphere Data Stage, Informatica

Data Warehousing

Star & Snow-Flake Schema Modeling, Erwin, Sybase Power Developer,

Dev. Tools

Windows/Linux/Mac OS Environment, Eclipse, Git, XCode, Subversion (SVN), CVS, ClearCase.

Tools

TOAD, SQL*PLUS, SQL Developer, SQL*Loader, Crystal Reports, Forms 6i/9i/10g, Reports 6i/9i/10g, Work Flow Builder and XML Publisher.

FAA (Oklahoma City, OK) Oct 2018 – Present

Oracle PL/SQL Developer

Responsibilities:

Created various database objects like tables, views, materialized views, procedures, functions and packages using oracle tools like Toad, SQL Developer and SQL* plus.

Extensively used bulk collection in PL/SQL objects, partitioned the fact tables and materialized views for improving the performance.

Creating indexes on tables to improve the performance by eliminating the full table scans and views for hiding the actual tables and to eliminate the complexity of the large queries.

Performed SQL and PL/SQL tuning and Application tuning using various tools like EXPLAIN PLAN, SQL*TRACE, TKPROF and AUTOTRACE.

Transferred SQL and Korn shell programs into ODI and created data extracts.

Extensively used the advanced features of PL/SQL like Records, Tables, Object types and Dynamic SQL.

Involved in Importing and exporting Tables, Users, and Schemas.

Designed DW tables, scripts, ETL maps and ODI Extracts, Configured ODI modules and ETL tools and supported accessible applications, and documented and maintained ETL specifications and processes.

Experience with custom development of data warehouse, operational data store, and OLTP systems.

Responsible for Unit Testing and Integration testing of PL/SQL Packages, Procedures, Functions and Database Triggers.

Worked in Production Support Environment as well as QA/TEST environments for projects, work orders, maintenance requests, bug fixes, enhancements, data changes, etc.

Environment: Oracle 10g / 11g/12c, SQL, PL/SQL, SQL*PLUS, SQL*Loader, Oracle Forms 9i/10g, Reports 9i/10g, CVS, TOAD, UNIX, Shell scripting.

NEXTERAENERGY (Juno Beach, FL) Apr 2018 – Oct 2018

Oracle PL/SQL Developer

Responsibilities:

Worked on the bulk uploading of huge amounts of statistical data to the database.

Wrote Loader scripts using SQL Loader/External tables to load large tables.

Designed and developed classes using core Java for thread safety in money transactions using Multithreading.

Responsible for developing and modifying several PL/SQL packages, procedures, functions, views and triggers using PL/SQL.

Optimized queries by obtaining Explain Plan, analyzing tables, providing hints, and adding Indexes on tables where required.

Performed maintenance work on the database.

Analyzed data integrity problems and provided assistance in giving solutions.

Actively involved in troubleshooting database issues.

Worked with trading partners to implement and troubleshoot connectivity to EDI systems that included Secure FTP, FTP with PGP encryption for batch transactions and Web services for real time transactions.

Reviewed errors and EDI transaction reports and analyzed information for trends.

Environment: UNIX, Oracle 11g, PL/SQL, SQL*Plus, SQL*Loader, Oracle Pro*C, Microsoft Excel, TOAD, APEX 4.4.2 SQL, PL/SQL, SQL*Loader.

Xerox Corporation (Rochester, NY) July 2016 – Mar 2018

Oracle PL/SQL Developer

Responsibilities:

Extensively used bulk collection in PL/SQL objects, partitioned the fact tables and materialized views for improving the performance.

Creating indexes on tables to improve the performance by eliminating the full table scans and views for hiding the actual tables and to eliminate the complexity of the large queries.

Performed SQL and PL/SQL tuning and Application tuning using various tools like EXPLAIN PLAN, SQL*TRACE, TKPROF and AUTOTRACE.

Transferred SQL and Korn shell programs into ODI and created data extracts.

Extensively used the advanced features of PL/SQL like Records, Tables, Object types and Dynamic SQL.

Involved in Importing and exporting Tables, Users, and Schemas.

Designed DW tables, scripts, ETL maps and ODI Extracts, Configured ODI modules and ETL tools and supported accessible applications, and documented and maintained ETL specifications and processes.

Designed ETL packages dealing with different data sources (SQL Server, Flat Files) and loaded the data into target data sources by performing different kinds of transformations using SSIS.

Created tables, views, stored procedures, functions, CTEs and indexes to support database and ETL applications.

Modifying scripts to handle automated Loading/Extraction and Transformation (ETL) of data using SSIS.

Environment: Oracle 10g / 11g/12c, SQL, PL/SQL, SQL*PLUS, SQL*Loader, Oracle Forms 9i/10g, Reports 9i/10g, CVS, TOAD, UNIX, Shell scripting, MS SQL Server 2014/2012, SSIS/SSAS/SSRS.

Contact this candidate