Sql Oracle

Sai Teja

Professional Summary

* ***** ** ** ********** in Analysis, Design, Development, Tuning, Scheduling of Jobs and production support using Oracle SQL, PL/SQL in Healthcare, Banking, Finance and Retail industry using the Oracle RDBMS Technology, Oracle Development Tools and other Client/Server on Linux, Unix and Window platforms.

Strong Exposure in writing simple and Complex SQLs, PL/SQL Functions and Procedures, Packages and creation of Oracle Objects - Tables, Functions, Packages, Materialized views, Triggers, Synonyms, User Defined Data Types, Nested Tables and Collections.

Expertise in Client-Server application development using Oracle 11g/10g/9i/8i, PL/SQL, SQL *PLUS, TOAD and SQL*LOADER.

Proficient in writing complex SQL Queries, stored procedures, Normalization, Database Design, creating Indexes, Functions, Triggers, Sub Queries and tuning SQL queries using HINTS and EXPLAIN PLAN.

Designing and developing application schemas, ER Diagram, Tables (Partitioned Tables, Index Organized Tables, External Tables and Global Temporary Tables), Clusters, Indexes, Views, Materialized views, Triggers, Procedures, Functions and Packages.

Experience in advanced PL/SQL concepts like Bulk collect, FORALL, and implemented Dynamic SQL, Records, Arrays and Exception Handling.

Experience in Performance Tuning and Explain plan, Tkprof,Sql loader,DBMS_JOB, Utl_File,Indexes, Import and Export utilities and Shell scripting for auto process.

Experience in translating business requirements into creation of Database Objects.

Experience with Data flow diagrams, Data dictionary, Database normalization theory techniques, Entity relation modeling and design techniques.

Extensive experience in using Oracle utility tools like SQL*Loader, Import and Export.

Experience in writing Unix Shell Script for Oracle concurrent programs.

Pre Analysis and Testing of Clients requirements in to Mapping Documents, Extensive work experience in Oracle 11g, Oracle 10g databases, scheduling of Jobs on Tidal and data loader tool called Relation Junction, PERL and UNIX shell programming.

Strong experience in Data conversions from MSSQL, MySQL, ACCESS, AS400 to Oracle.

Experienced in building cross browser compatibility applications using HTML5 and CSS3.

Building Web User Interface (UI) using HTML/HTML5, DHTML, XHTML, Angular JS, CSS/CSS3 and JavaScript, jQuery that follows W3C Web Standards and are browser compatible.

Excellent knowledge in database development using Oracle PL/SQL and Unix Scripting.

Good ability to quickly grasp and master new concepts and technologies.

Strong problem solving & technical skills coupled with confident decision making for enabling effective solutions leading to high customer satisfaction.

Proven proficiency in multi-tasking skills.

Having good experience in the SDLC phases of Analysis, Design, Development, Implementation, testing and Support.

Experience in developing Data Warehouse / Data Mart applications using ETL tool Informatica Power Center (6.x, 7.x, 8.x).

Experience in implementation of ETL methodology in Data Extraction, Transformation and Loading process.

Good knowledge in C/C++ including thread synchronization multithreading, multi processing, concurrency and TCP/IP Socket Programming.

Knowledge in Core Java, Java Server Pages, Servlets, JavaScript, JDBC.

Education

Bachelor of Technology in Computer Science from Sastra University.

Technical Skills

OS : RHEL, Solaris, HP-UX 10.x, Windows, OpenVMS/VAX

RDBMS : Oracle 11g/10g/9i/8i/7, MS-SQL 2005

Languages : PL/SQL, T-SQL, C, C++, Java, shell scripting, VBScript, VB 6, WMI, Python, Perl

Tools : Utilities IDE

OEM :SQL*Loader, Exp/Imp, TKPROF, RMAN, SQL*Plus, SSH, Oracle Designer, Erwin, SCP/SFTP, FileZilla, Putty, Oracle Streams/JMS, Oracle Forms/Reports 6i/9i, Oracle JDeveloper 10g, Eclipse, Emacs, Vim, Talend Open Studio, Cognos, Crystal Reports, Remedy ARS, Accurev, Toad, Atlassian JIRA, Transbase CD, SQuirrel SQL

Web Development : PHP, JSP, CSS, XML, XSD, XSLT, JSON, HTML, jQuery, AJAX, GWT

Professional Experience

Family Dollar – Matthews, NC June 2015 - till date

Oracle PL/SQL Developer

Responsibilities:

•Written Oracle PL/SQL Stored Procedures, Packages, Functions, Triggers, Cursors and Views for extraction of Promotions, Price changes, Zone Changes and their associated items as per business requirement to make new enhancements or resolve issues.

•Generated SQL scripts to install database objects in production environment including Tables, Views, Primary Keys, Indexes, Constraints, Sequences Synonyms, Packages, Procedures, and Functions.

•Developed the Perl and Shell scripts to automate the nightly batch jobs (Crone Jobs)

•Involved in implementing complex business rules and loading the data from different sources (Oracle, Flat File and XML) to staging tables through Informatica Transformations, and Mappings.

•Implemented Materialized Views for extracting data from remote databases.

•Wrote complex Oracle SQL queries using joins, sub queries and correlated sub queries.

•Participated in Performance Tuning the PL/SQL code using Explain Plan, TKPROF and AUTOTRACE.

•Good hands on Oracle Retail aka Retek suite majorly used in retail industry for managing Merchandising, Inventory management and supply chain activities.

•Developed and designed several Crystal Reports such as Retail price discrepancy report, Holiday/Weekend promotions report, and Promo conflict report et cetera on business requests.

•Experienced in developing Dashboards Reports in Cognos 8 and 10

•Used Python programming and language to develop a working and efficient network within the company.

•Performed research regarding Python Programming and its uses and efficiency.

•Incorporated WCAG into ongoing projects.

•Extensive use of several Oracle provided packages such as UTL_FILE, DBMS_JOBS and DBMS_SCHEDULER.

•Worked on Pro C* programs and sql scripts to generate full extracts of large tables.

•Developed custom batch programs in Pro*C and developed custom Functions, Procedures and Packages Scripts for RETEK -12 implementation.

•

•Hands on building prototypes and applications using HTML5, CSS3, JavaScript, jQuery, Ajax, JSON, Angular.js, Backbone.js and Bootstrap with MySQL database.

•Used Toad and SQL Navigator for development and production environments.

•Assisted in integration of Exadata applications into current IT actionable events and solutions.

•Supported migration of ETL code from development to QA and QA to production environments.

•Good Knowledge in ETL Tools and Oracle Data Integrator(ODI).

•Designed Development Documentation and Support Documentations.

Environment: Oracle 10g, Oracle 11g, SQL, PL/SQL, Perl, Unix Shell scripting, Oracle Retail aka Retek, Oracle Reports 10g, Oracle Forms 10g, Oracle Exadata, SQL *Plus, Toad 9.7.2, Crystal Reports, Cognos, HTML, XHMTL, XML, Informatica 8.x/9.1, Control M scheduler, Appworx, Cron Tab, TWS Scheduling, SQL Navigator, Toad, Clear case versioning

Kaiser, CA Jan 2014 -May 201

Oracle PL/SQL Developer

Responsibilities:

•Involved in SDLC gathering requirements from end users. Participated in system analysis and data modeling.

•Participated in code walkthroughs and review sessions with the development team.

•Coordinated with off-shore team by providing knowledge transfer, walkthrough development documents with off-shore team.

•Well experienced in defining, designing, integrating and re-engineering the Enterprise Data warehouse and Data Marts in different environments like Teradata, Oracle with multiple Terabytes of size and various levels of complexity.

•Developed stored procedures and triggers to facilitate consistent data entry into the database. Written Stored Procedures using functions and cursors for common utilities. Developed views to facilitate easy interface implementation and enforce security on critical customer information.

•Participated in system analysis and data modeling, which included creating tables, views, indexes, synonyms, triggers, functions, procedures, cursors and packages. Created programming code using advanced concepts of Records, Collections and Dynamic SQL.

•Develop the batch jobs for loading the BETA side trades into Broadridge using Perl script, UNIX shell script and Autosys.

•Developed dynamic e-mails using JavaScript, and hand coding of HTML and CSS3.

•Developed C/C++, Pro*C Batch programs using Multithreading Programming for handling large volumes of data for parallel processing/load to purge RMS data.

•Involved in writing application level code to interact with APIs, Web Services using AJAX, JSON and XML.

•Assisted with testing existing code and making necessary enhancements for Oracle 11G upgrade.

•Designed/developed tables, views, materialized view, stored procedures, packages and functions

•Used advanced Bulk techniques (FOR ALL, BULK COLLECT) to improve performance. Developed Installation scripts for all the deliverables.

•Converting the business requirements into Technical requirements, HLD and DD for the customization and get them reviewed by architect.

•Automated scripts by scheduling control-M jobs, by using Unix Shell scripts and windows scripting for improvement in performance of reporting.

•Involved in performance tuning on SQL using AUTO TRACE, EXPLAIN PLAN, TKPROF utilities.

•Created and manipulated stored procedures, functions, packages and triggers using TOAD.

•Converted the standalone MS-Access reports into Oracle Reports, web reports with business logic written in PL/SQL and Java.

•Wrote stored procedures using dynamic SQL to populate data into temp tables from fact and dimensional tables for reporting purpose.

•Created materialized views using different clauses like FAST, COMPLETE, FORCE, ON COMMIT.

•Utilized SQL*loader to load data from external system and developed PL/SQL programs to dump the data from staging tables into Base Tables.

•Experience in working with IMPLICIT CURSORS, EXPLICIT CURSORS, REF CURSORS.

•Worked on Oracle PL/SQL collections VARRAYS, NESTED TABLE, and ASSOCIATIVE ARRAYS with INDEX BY VARCHAR2.

•Extensive work experience in Oracle Warehouse Builder 11g and with Oracle Data Integrator.

•Solid knowledge of HTML as well as W3C WCAG 2.0 and section 508 standards.

•Participated in analysis and designing of Oracle Exadata Server for infrastructure and related projects.

•Experience with creating templates, pages and full sites in HTML, CSS, XML, jQuery, JavaScript, require.js, bootstrap, angular and other front-end technologies.

Environment: Oracle 10g, Teradata, PL/SQL, Exadata, SQL *Plus, Toad 9.7.2, Erwin 4.0, C++, Unix Shell Scripts, HTML, XHMTL, XML, SQL Loader, Oracle reports 10g, Oracle Forms 10g.

Ally Financial – Charlotte, NC Jan 2012 - Nov 2013

Sr. Oracle Developer

Responsibilities:

•Defined business requirements and developed Technical Design Document for programming

•Designed and Developed back-end routines using Oracle PLSQL, Stored procedures/Packages, Triggers and SQL*loader.

•Wrote Unix Shell scripts to generate daily reports for credit class updates of customers.

•Automated jobs through Autosys for creating Mass Adjustment Files to find customer accounts to be charged for late payments.

•Worked on range partitioning of history tables in order to improve batch performance.

•Implemented modifications to the existing code to add a memo to a customer account through API.

•Created daily reports of customer accounts which needed to be notified for adding a memo.

•Used advanced SQL and analytical functions in various queries.

•Gathering the functional requirements from users and converting them into Technical requirements using AIM methodology and get sign-off from DBA/Architects.

•Implemented Perl packages extensively. Used multithreading. Used SOAPLite module to communicate with different web-services based on given WSD.

•Developed Perl scripts to automate frequent reports for the users.

•Developed Perl scripts to load data feeds into GASS and to generate feeds for the downstream systems

•Creating new Forms (Developer 2000), Reports (Reports 10g) and writing back end procedures, function, trigger, packages (PL/SQL).

•Used package like DBMS_JOB to determine if there are any jobs that are to be performed, or any changes are made to the program or procedure.

•Created Parameterized Reports and Customized Existing Reports for presentations using Cross-Tab reports and Sub-reports and Running Totals/Formulas in crystal report.

•Used for all and bulk collect to fetch large volumes of data in PL/SQL objects.

•Automated repetitive processes by writing shell scripts.

•Worked on accessing the application interface that integrates the internal applications with the billing system.

•Developed complex procedures to handle errors and exceptions at the database level using PL/SQL.

•Used PL/SQL Tables, Ref Cursors to process huge volumes of data and used bulk collect and bulk bind for mass update as performance improvement process.

•Created Sophisticated Reports using Cognos Report Studio.

•Worked extensively on various bug fixes in Reports 6i, Discoverer 10g, and Forms 6i.

•Application Development using Oracle Forms 10g, Oracle Reports 10g.

•Tested application in Unit Test and deployed applications into the production server.

•Consistently coordinated with production support and also responsible for estimating the time factor for several jobs depending upon the data volume size.

•The role required extensive interactions with Business Managers and Users

Environment: Unix, Oracle 9i/10g, PL/SQL, SQL*Plus, SQL*Loader, TOAD, PL/SQL, SQL, HTML, XHMTL, XML, SQL LOADER, Toad, Oracle database 10g; Oracle Forms 6i, 10g; Oracle Reports 6i, 10g, Oracle Application Server 10g, Cognos 8.2/3/4 (Framework Manager, Report Studio, Query Studio, Analysis Studio, Cognos Connection)

Cognizant - India Nov 2010 - Dec 2011

Sr. Oracle Developer

Responsibilities:

•Analyzed, designed, modeled, and implemented new database schemas.

•Monitoring Fragmentation, Row Chaining and High water marks.

•Generated SQL and PL/SQL Scripts to create stored procedures, functions, packages and database triggers.

•Designed competent PL/SQL programs using PL/SQL collections, Records types, and Object types.

•Good knowledge on joins, which are inner join, Left outer join and Hash join, Semi join.

•Involved in working on Oracle Pseudo columns like ROWID, ROWNUM, SYSDATE, SYSTEM TIMESTAMP, USER etc.

•Experience in working a variety of analytical functions, RANK, DENSERANK, LAG, LEAD, and PARTITION OVER.

•Automated Quality Check tasks by creating PL/SQL procedures, cursors, functions and dynamic SQL. Enhanced it with creating exceptions for error handling. Created triggers for auditing purpose and created group, tabular and form reports.

•Implemented various UNIX Scripts to generate the data in CSV format.

•Tuned several Oracle SQL statements using Explain Plan, Auto Trace utilities.

•Responsible for database design and development and Application Tuning.

•Implemented various automated UNIX shell scripts to invoke PL/SQL anonymous blocks, Stored PROEDURES/FUNCTIONS/PACKAGES using SQL PLUS session in silent mode.

•Written several DDL, DML and TCL operations.

•Provided 24*7 on call support to production environment.

Environment: Oracle 10g, PL/SQL and Windows XP, HP UNIX, Oracle SQL Developer, Putty, UNIX, PUTTY, PVCS, WinSCP, SQL, PL/SQL, UNIX Shell Scripting, SQL*Plus, SQL*Loader, MS Office.

L&T Infotech - India Aug 2008 - Oct 2010

Oracle Developer

Responsibilities:

•Involved as a key team member for Requirement Analysis during the design phase and interaction with the client.

•Involved in writing backend Packages extensively in PL/SQL.

•Involved in Code Reviews and preparing Unit test cases.

•Maintained the data integrity and security using Integrity Constraints and Triggers.

•Optimized and enhanced the existing procedures and SQL statements for the better performance.

•Defining and reviewing the coding standards besides reviewing the code.

•Created, debugged and modified Stored Procedures, Triggers, Tables, Views and User-Defined Functions.

•Extensively involved in preparing Detailed Technical Documents from the functional specifications.

•Preparation of Checklists, identification of Test Cases and preparing Test Plans.

•Developed Perl and Shell scripts for upload of data feed into database

•Actively Involved in Integration and Deployment in Production Environment.

•Customization of code as per the user requirements.

•Involved in the analysis of the existing database.

•Responsibilities included Oracle reports, Discoverer reports, packages, procedures, functions and custom tables.

•Designed and extensively worked on Project Documentation.

•Separating Tables and Indexes on different locations for reducing Disk I/O Contention.

•Extensively used EXPLAIN PLAN, TKPROF, SQL TRACE, ANALYZE and HINTS.

•Used Bulk Binds and Bulk Collect.

•Designed Pragma Autonomous Transactions.

•Implemented External tables and created Sequences to generate numbers on the fly.

•Co-ordination between Development, Testing and Production teams and attending bridge calls and technical discussions regarding future developments and releases.

Environment: Oracle Database 9i, TOAD, Microsoft Windows Server 2002 R2, Unix, PUTTY, PVCS, WinSCP, SQL, PL/SQL, Unix Shell Scripting, SQL*Plus, SQL*Loader, MS Office, Windows XP, Oracle Reports 6i, Oracle Forms 6i

Contact this candidate