Rakesh

408-***-****

ac3eqj@r.postjobfree.com

Experience Summary

Over 5+ years of IT experience in Oracle PL/SQL Development, Analysis, Design, Modeling, Testing and Implementation of Data Warehouse Business Applications.

Involved in all phases of the SDLC (Software Development Life Cycle).

Excellent skills in Designing and Development of Applications using Oracle PL/SQL.

In depth Knowledge and experience of Data Warehouse/Data Mart design, Data Migration and Implementation concepts.

Hands on experience on Data Warehousing Design Methodology, Data Warehouse Concepts, Database Design/Architecture including both OLAP & OLTP data and complete lifecycle of project from Design to Development and Implementation.

Used OLTP extensively for Order processing, ticket tracking and personnel file systems.

Experienced with OLTP on Optimized data validation of incoming data during transactions.

Good knowledge of UNIX shell scripting.

Strong experience in coordinating and providing support to UAT/QA Team during testing phase of Project.

Excellent SQL skills, experienced in writing complex queries.

Good knowledge of Data Modeling using ETL tools, Star Schema, Snowflake Schema, and Entity-Relationship Diagrams.

Experience in Bulk Data loading using Oracle utilities like SQL Loader, External Tables.

Experience in using Data sources/Targets such as Oracle, MS SQL ServerDB2, XML and Flat files.

Expertise in Developing and Customizing Oracle Forms and Reports using Oracle Forms 11g/10g/9i/6i, Reports10g/9i/6i, Discoverer 9i/10g, XML Publisher and developing concurrent programs using SQL, PL/SQL.

Strong experience on Advanced PL/SQL programming in implementing the concepts and features using Bulk Collect, Bind Variables, Ref Cursors, Execute Immediate, Exception handling, Procedures, Functions, Packages, Triggers, Autonomous transactions, Global Temporary tables, external tables, Hierarchical Queries, Aggregate Functions, Analytical Functions, Batch Jobs.

Extensive experience in Query Performance Tuning by Analyzing tables, hints, DBMS Profiler, TKPROF, SQL Trace, Explain Plan, Bulk Collect feature, Materialized View, DBMS packages and exception handling, Global Temporary tables and Troubleshooting Oracle database issues.

Good Knowledge on Client-Server application development using Oracle […] PL/SQL, SQL *PLUS, TOAD and SQL*LOADER.

In depth knowledge of RDBMS concepts, with hands on exposure in the Development of Relational database environment using SQL and PL/SQL using database tools like PL/SQL developer, SQL developer, Toad, SQL Navigator.

Experience in providing knowledge transfer and support to the team.

Production support experience across various projects.

Proficient knowledge of PL/SQL Object Types, Oracle Parallel Queries, Materialized Views, Bulk Collects and Collections.

Developed Oracle Forms and Oracle Reports using 10g, 11g depending on the functional requirement document.

Highly Organized and Efficient to prioritize and manage multiple tasks.

Technical Skills

Databases Tools PL/SQL Developer, Toad, SQL Navigator, SQL Enterprise Manager, SQL Server Analysis Service (SSAS), Oracle SQL Developer.

ETL Tools Data Transformation Services (DTS) – Export/Import, SQL Server Integration Service (SSIS), Oracle Data Integrator(ODI)

Reporting Tools Evision Arogs, Tableau, Oracle reports, SQL Server Reporting Services (2014/2008/2005/2000), MS Access, MS Excel

Database Oracle 10g/11g/12c, MS SQL Server 2012/2008/2005/2000, MS Access.

Programming PL/SQL, T-SQL, C

Web Technologies HTML, DHTML, CSS, AJAX, jQuery, XML, XSL, Java Script (Validation), CSS

Operating Systems Windows (95/98/2000), Windows 2003/2008 Server, Windows XP, Linux, Windows Vista

Professional Experience

Client: N2N Services Inc. - Duluth, GA April 2016 to Present

PL/SQL Developer

N2N Services is the leader in systems integration in higher education which supports Integration platform as a service (iPaaS) solution that offers a library of pre-built APIs covering the most common data integration challenges for Colleges and Universities.

Projects:

Push to Banner (Pushing the data to Banner from 3rd Party Applications by converting the person and application data from Application to XML and storing it in the Banner DB.)

Id Match Process (Before creating a new Student record in the DB we go through this process for not creating a duplicate record.)

Registration Process for students to register to classes by using a Mobile Application(MODO).

Applying Meal Plan assignment and Post Mail Box Charges to the students in the University.

Banner to Canvas Integration

Time Machine (Displaying the differential data when the jobs are run).

Responsibilities:

Worked with the project Stakeholders and Users in understanding the Business requirements for the project.

Planning development timelines, Tracking development status and Delivering all deliverables on time.

Participated in day to day agile processes like scrums and sprints.

Design and Develop Oracle Packages, Functions, and Procedure and Postgres functions.

Install Postgres and Clone Production databases to Lower environments.

Participated in the Analysis phase, Preparing the technical specification, Development and Testing documents.

Responsible for System/Software upgrades configuration.

Responsible for Code reviews.

Involved in User Acceptance testing and Post production support. Ensured that all defects are resolved by team within time.

Trained interns with System architecture, Project guidelines and Development processes.

Build and maintain Oracle PL/SQL packages and stored procedures (using TOAD and PL/SQL developer), Workflows, and SQR reports as requested by client, for Processing and Analysis.

Used Ref cursors and Collections for accessing complex data through joining many tables.

Extensively involved in Performing database, SQL's, API's tuning and optimization.

Handled Exception extensively for the ease of debugging and displaying the error messages in the application.

Coordinated with front-end Developers for Implementing logic in stored procedures and functions for faster retrieval of data.

Performed need based DBA activities like DB schema creating and maintenance for Development, QA, QC and Staging environments, Jobs scheduling in Scheduler, Data Import from production for QA/QC, DB Objects Creation and validation.

Interacting with UI development team to Develop in tandem back-end solutions with front-end web executions.

Designed and developed the data migration Scripts and Programs to upgrade the Development, QA, UAT and Production DB schemas upgrade to Oracle 12c from Oracle 11g in Development and Production Environments.

Analyzing and prioritizing the production issue tickets and moving them from development to scheduled releases.

Worked as the Production support engineer for more than 15 Universities.

Developed test cases that were used in conjunction with the Quality Assurance team to validate code.

Interacted with Business Users in creating Unit and System Test cases for enhancements in the existing application.

Application support in resolving production problems for existing application and ensure all issues get resolved accordingly.

Delivered tasks accurately in time provided.

Created numerous simple to complex queries involving self joins, correlated sub-queries, functions, cursors, dynamic SQL.

Developed Oracle partitions, and performance tuning/query tuning.

Experience in creating ETL transformations and jobs using Oracle using dynamic packages and procedures using oracle code.

Used Git and Jira as our versions control and ticket submission tools.

Environment: Oracle 11g/12c, MongoDB, SQL, PL/SQL, TOAD, Oracle Developer, SQL*Loader, SQL*PLUS

McKesson, Arizona June 2015 to Mar 2016

Oracle PL/SQL Developer

As part of McKesson Corporation, we develop Oracle objects and Forms for loading and summarizing data and creating front-end application.

Responsibilities:

Configured and designed Entity Relationship Diagram (ERD) with Data Design team to illustrate the logical structure of the database.

Developed Procedure, Package, and Functions to update and maintain the database.

Wrote PL/SQL Procedure & Triggers to validate database records.

Developed Stored Procedures and Complex Packages using PL/SQL for maintaining Patient Information

Created Stored Procedures for Batch Processing and involved in moving large data using Bulk Insert for all methods.

Developed Complex SQL Queries using various Joins and developed Dynamic SQL (Sub Queries and Correlated sub queries, Join Conditions).

Development using Forms 10g.

Perform ETL Testing by validating data.

Performed SQL and PL/SQL tuning and Application tuning using various tools like EXPLAIN PLAN and TKPROF.

Extensively using Hints to direct the optimizer to choose an optimum Query Execution Plan.

Created new database objects like Sequences, Procedures, Functions, Packages, Triggers, Indexes and Views in development and Production environment in PL/SQL and SQL*Plus.

Optimized the Query performance with modification in PL/SQL queries, removing unnecessary columns, eliminating redundant and inconsistent data, normalizing database, establishing necessary joins, creating useful indexes.

Created Documentation of development code and the test cases involved.

Designed database tables using various normalization techniques and database rules.

Followed all processes and procedures for application deployment for new as well as existing

Design, develop and conduct unit test plans for ensuring application code is functioning correctly.

Debugging and fixing production data.

Review meeting with the manager, architect and team to discuss day-to-day task and backlogs.

Environment: PL/SQL, Data Models, AWR reports, ADDM reports, MS Excel, SQL*Navigator, Teradata, SQL *Plus, Web Forms, ad-hoc, TOAD, Power Builder, PowerShell scripting.

Spiceblue, Chennai, Apr 2014 to Jun 2015

Oracle PL/SQL Developer

Spiceblue has acquired ITecq and it develops mobile applications for major retailers. I am part of Common Repository team to build a common data warehouse to support mobile reporting databases.

Responsibilities:

Developed database Tables, Triggers, Cursors, Procedures, Functions and Packages to meet business

requirements.

Extensively used Ref cursors, PL/SQL Collections and Dynamic SQL.

Assisted with performance tuning of SQL queries and fixed the slow running queries in production with utilities like Explain plan and Trace.

Coordinated with the front-end design team to provide them with the necessary stored procedures and packages and the necessary insight into the data.

Worked on gathering and analyzing requirements for the component assigned to me.

Work with data architect to make sure the table creation and related objects are developed as per the requirement.

Worked on SQL*Loader to Load data from Flat files obtained from various facilities every day.

Created Package to migrate data across various environments.

Created and used HTML for data management and transmission.

Created views to pull data from Staging area and load into Data Warehouse tables.

Created DBMS_SCHEDULER enables scheduling and automated execution of PL/SQL blocks, stored procedures and external procedures and executables.

Analyzing data in target DB.

Involved more in performance tuning.

Environment: Oracle 10g/11g, Oracle SQL Developer, TOAD, SQL*Loader, FTP, Linux, SQL.

Object Technology Solutions India Pvt Ltd – Hyderabad, India May 2012 to Mar 2014

SQL Developer

Object Technology Solutions is a service based company for progressive reporting and risk management practices and allows the optimal business solutions for IT business strategies.

Responsibilities:

Actively participated and interacted with users, team lead, DBAs and technical developer to fully understand the requirements of the system.

Worked on the Reports module of the project as a developer on MS SQL Server 2008 (using SSRS, T-SQL, scripts, stored procedures and views).

Conducted and automated the ETL operations to Extract data from multiple data sources, transform inconsistent and missing data to consistent and reliable data, and finally load it into the Multi-dimensional data warehouse.

Extracted data from Oracle database with MS Access, and performed SQL query, data analysis and verification.

Involved in the development of custom stored procedures, functions, triggers with PL/SQL, T-SQL.

Developed Database triggers, Functions and Procedures to implement Business rules.

Designed and developed several types of reports using Oracle Reports.

Wrote stored procedures to get the fields required for the reports.

Involved in Analysis, Designing & coding. Analyzed customer requirements.

Developed Daily Production Reports for our clients using Oracle Reports

Involved in testing, review and code optimization for different Campaigns in the project.

Involved in Technical Documentation, Unit testing, Integration testing and writing the Test plan.

Created datasets using stored procedures and reports using multi-value parameters.

Environment: Oracle 11g/10g, SQL Server 2008/2005, Reports 10g/6i/9i, T-SQL, PL/SQL, SQL Loader, SQL*plus.

Contact this candidate