Sql Developer

Naresh Reddy Kancharla

Email id:*********@*****.***

Ph no: 832-***-**** EXT 153

Professional Summary

6+ years of IT experience as an Oracle Developer on a variety of UNIX (Solaris, Linux and AIX), Windows platforms with Oracle 8i/9i/10g/11g

Solid development experience with Microsoft technologies, especially SQL Server.

Extensive expertise in SSAS, SSIS, SSRS development

2+ years of experience with C# and published Dundas Dashboards to SharePoint Server

Solid background in relational database design, table design, query/view design, stored procedures, form design, report design, T-SQL, user friendly interfaces.

3+ years of experience with Data Visualization using Dundas Dashboards

Solid troubleshooting and problem-solving skills in SQL Server development.

Strong knowledge in all phases of Software Development Life Cycle (SDLC).

Strong knowledge of Relational Database Management System (RDBMS).

Strong knowledge on Database Lifecycle (DBLC).

Good Expertise in Oracle Server Architecture and basic DBA functionalities.

Strong expertise in Agile software development methodology.

Strong knowledge in exporting and importing data to and from a database using the Expdp/Impdp utility in Oracle 10g and 11g and Exp/Imp utility in Oracle 9i.

Data loading from heterogeneous databases and flat files into Oracle database using SQL*LOADER, External tables and SSIS.

Strong knowledge in writing PL/SQL scripts for the database objects like tables, views, procedures, functions, packages, database triggers, indexes, function based index and sequences.

Experience on multiple projects implemented using the RETEK application.

Experience in trapping, raising and handling errors using Exceptions.

Knowledge of using isql utility to connect and extract data from SQL server 2005 database.

Extensive experience in Data warehousing, Data Analysis, Reporting, ETL, Data Modeling, Development, Maintenance, Testing and Documentation.

Knowledge on writing Transact SQL scripts to query the SQL Server 2005 database, implementing Transact SQL Procedures to enforce business logic.

Knowledge of creating and using Cursors and REF Cursors.

Strong knowledge in creating and using Public Synonyms, DBLinks and Global Temporary tables.

Expertise in creating Materialized views in data warehousing environment, working knowledge of Nested tables, PL/SQL tables and Varrays.

Experienced in designing, scheduling and monitoring UNIX scripts.

Good knowledge of STAR schema and SNOWFLAKE schema in warehouse environment.

Involved in designing numerous Oracle Forms which include master detail forms, customized form sand Reports by interacting directly with End Users and Business Analyst.

Proficient in SQL, PL/SQL, Query/application tuning using Optimizer hints, Explain plan, SQL trace, TKPROF and dbms_profiler.

Oracle and UNIX: design/coding/integration in Pro*C, C, Korn shell, SQL, PL/SQL.

Worked on developing/supporting oracle APEX applications

Our group supports numerous Oracle APEX applications

Good Knowledge in applications in PL/SQL, developing applications in Oracle Forms and Oracle reports.

Working experience in Creating Forms based on tables, views and procedures in tabular and Form layouts.

Experienced in designing, developing, scheduling and monitoring UNIX shell scripts for automation, also using Crontab, Autosys for scheduling routine tasks.

Experience working on a wide variety of public and private sectors, including insurance, financial, roadside assistance, education, telecommunication, retail, gas/oil, publications, and government (forensic and national voting polls).

Good knowledge of JAVA.

Created scripts in Python to process Images and load them into Oracle DB.

Experience in database application development using SQL Plus, TOAD, SQL Developer and PL/SQL Developer

Good understanding of the concept of Normalization, creating interface scenarios and load plans in Oracle Data Integrator (ODI).

Strong experience working with various FTP protocols like FTP, SCP using SSH protocol.

Strong interpersonal and communication skills in dealing with customers, business users.

Clear communication and documentation of technical specifications.

Highly motivated, enthusiastic, strong initiative, excellent team player and a quick learner of new technologies.

Experience in Scheduling batch processing through CONTROL-M.

Expertise in using GITHUB, for code check in, check out and maintenance of the repository.

Experience in using PVCS (VM and Tracker) tools and also CollabNet Subversion Edge to handle the version control system.

Experience in using JIRA, CRUCIBLE, FISHEYE, VersionOne, Footprints for project tracking, teams planning and also reviewing and commenting the code base.

Involved in review of Functional Requirement documents and also creation of Technical Design documents and related Test Case documents.

SQL Server Skills

Highly proficient SQL Server Developer, specializing in the following areas:

BI – Data Warehouse

SSIS, SSRS, SSAS

SQL/PL SQL

Power Pivot

MS Access 2010 and 2007

Unix / Shell Script

VBA(Visual Basic for Applications) Programming

SQL Server ver. 2008/2005 - Database Development, T-SQL, Stored Procedures, Views

Data Management in Microsoft EXCEL using Macros

C#

ASP.Net

VBScripting

Technical Skills

Operating Systems

DOS, Windows XP/NT, Red Hat Linux AS/ES 3.0, UNIX, OS X

Languages

SQL, PLSQL, C, C++, Java

Scripting Languages

JQuery, JavaScript, HTML, XML, UNIX shell scripting, Python

GUI’s Technologies

Oracle Forms/ Reports DS10g/DS9i/6i, Crystal Reports 9/10, Erwin, ODI

Databases

Oracle8i/9i/10g/11g, SQL server 2005, Oracle XML DB, MS Access

Products/Packages

MS Office Products, Microsoft Visual Studio, SQL Server Management Studio

Utilities

SQL* Plus, SQL* Loader, Toad, SQL Navigator, Informatica Power Center

Education:

MS in Information Technology AUG 2013

Professional Summary

Oracle PL/SQL Developer March 2015-Present

Client: T-Mobile, Atlanta, GA

Environment: UNIX, Oracle 11g, PL/SQL, Retek, SQL*Plus, SQL*Loader, Oracle Pro*C, Microsoft Excel, TOAD, APEX 4.4.2 SQL, PL/SQL, SQL*Loader, Reports6i, Toad, Data Modeling, Data migration, CVS, Core Java, .Net (ASP), HP-UX UNIX, XML, SQL SERVER.

Responsibilities:

Created design documents to be reviewed by Architect.

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 the 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 in UNIX.

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

Performed maintenance work on the database in Exadata.

Actively involved in troubleshooting database issues and monitoring UNIX scripts.

Proficient in writing stored Procedures in Netezza and converting cursor based PL/SQL procs into set based sql procs.

Experienced in designing, developing, scheduling and monitoring UNIX shell scripts for automation.

Experience in working with different databases like Netezza, Teradata, MSSQL Server 2008 R2, Oracle 10g/9i/8i and tools like Aginity, Toad, SQL Navigator, Teradata SQL Assistant

Provided SQL and PL/SQL code tuning to improve database response time and performance for several applications.

Developed Oracle Stored Procedures, Functions and Packages to effectively incorporate Business rules.

Worked extensively with Composite data types, Cursors and Dynamic SQL

Worked with Dynamic SQL, Global Temporary Tables.

Worked on SQL*Loader to load data from flat files obtained from various facilities every day. Used standard packages like UTL_FILE, DBMS_SQL, and PL/SQL Collections and used BULK Binding.

Created materialized views, Inline Views & normal views where business requirements needed

Worked in Oracle reports and forms version 6i and 10g.

Worked on Pro*C programs and SQL Scripts to generate full extracts of large tables in Exadata.

Worked in customization of reports in GL and PO.

Experienced in designing, developing, scheduling and monitoring UNIX shell scripts for automation.

Extensively used bulk collection in PL/SQL objects for improving the performing in Exadata.

Developed stored procedures and packages. Extensive work in PL/SQL.

Developed Reports and forms using Oracle Designer in Exadata.

Worked with development of packages and procedures using PL/SQL and functions using ETL and PL/SQL.

Primary developer for Retek's Active Retail Intelligence (ARI) rules based exception-alerting tool.

Involved in multiple projects in the Retek Distribution Management (RDM) functional areas such as Carton Tracking, Central Stock and RTI Sorter Simulation.

Created scripts in Python to process Images and load them into Oracle DB

Worked on developing/supporting oracle APEX applications.

Involved in analysis, development, testing, and 24 x 7 production support.

Our group supports numerous Oracle APEX applications.

Resources are needed to help support additional applications that will be acquired by our team. They will need to provide run the engine and production support.

They will also be asked to perform risk assessments and add needed controls to close any control gaps.

Extensive experience in Data warehousing, Data Analysis, Reporting, ETL, Data Modeling, Development, Maintenance, Testing and Documentation.

In-depth knowledge of XML and XSLT data and processing tools.

Knowledge of both Microsoft and Linux operating systems.

Integrate XML XSLT OOP and other types of programming into databases and applications

Oracle PL/SQL Developer August 2014 – March 2015

Client: DIRECTV, Los Angeles, CA

Environment: Oracle 11g, SQL Server, PL/SQL, Retek, Oracle Pro*C, SQL Server 2005, Data Modeling, Data migration, SQL Navigator, Toad, Unix Shell Scripting, Version Control Software CVS

Responsibilities:

Interacted with architects and business analysts to understand business requirements

Involved with project development teams to convert the model into technical specifications and provide knowledge transfer to quality assurance analysts.

Experienced in designing, developing, scheduling and monitoring UNIX shell scripts for automation.

Used Analytical functions like RANK and DENSE_RANK to assign to components having maximum portion.

Performed normalization of the OLTP database to eliminate redundant data.

Provided infrastructure and DBA Support by using Retek application, providing end-to-end solution for retail business.

Analysis and Design for new system using Oracle Designer, and then creating basic Forms with wizards, and complex designs manually.

Developed Activity Diagrams, State Chart diagrams, Class Diagrams, Use Case Diagrams and Sequence Diagrams using Rational Rose

Created SSIS packages to move data from Sql Server 2005 into Operational Data Store in Oracle data warehouse.

Implemented data mappings, flows and report dissemination mechanisms by architecting Data Marts.

Developed PL/SQL Procedures, Functions, Cursors, Packages, views and Materialized views.

Created dynamic sql queries using Execute Immediate statements.

Worked with data dictionary views to query the required information.

Experienced in developing and monitoring UNIX scripts.

Worked on debugging the code and creating the exceptions to handle bad data and send them to error log files.

Error handling using system defined exceptions and user defined exceptions like INVALID_NUMBER, NO_DATA_FOUND and PRAGMA EXCEPTION_INIT.

Oracle PL/SQL Developer Jan 2012 – December 2013

Client: HSBC, Hyderabad, India

Environment: Oracle 11g/10g, SQL, PL/SQL, SQL Developer, UNIX, TOAD, Shell scripting, subversion(SVN)

Responsibilities:

Understanding the existing business processes and Interacting with End user to finalize their requirement.

Created PL/SQL Packages, Procedures, Functions and Triggers.

Wrote PL/SQL code for data Conversion in store level pricing categories.

Involved in various activities like preparation of Technical Documentation, Client Discussions for purposed solution and User Acceptance Testing.

Used FOR UPDATE clause to lock the records in the cursor and used WHERE CURRENT OF statement to update the records that have been referenced by a for update statement.

Experienced in designing, developing, scheduling and monitoring UNIX scripts for automation

Custom Interface for EDI Supplier and modification on base Retek forms for order system using PL/SQL

Wrote high performance queries/programs using Collections, Nested tables, REF Cursors, pipeline functions

Used a wide variety of exception handlers in the procedures to handle the exceptions.

Created Test Plan for QA and implementation plan for Production, upon completion of unit testing.

Used records, type, cursors, %TYPE and ref cursors in the procedures created.

Created and worked with Global Temporary Tables.

Experienced in scheduling and monitoring UNIX scripts for automation

Tweaked hints like parallel, append, index, etc. to hint the oracle optimizer for better performance.

Made use of Bulk Collect feature to process the data from cursor/ Ref Cursors

Used composite data types like %ROWTYPE and %TYPE.

Written shell scripts to automate loading files into database using Crontab.

Contact this candidate