Rupesh Kumar Mandadi Phone: 972-***-****

Email: ac2eb3@r.postjobfree.com

Professional summary:

Total 8 years of diversified experience in defining entities, attributes and entity relationship diagrams as Oracle PL/SQL developer

Extensive experience in all areas of Project Life Cycle including requirement analysis, system analysis, design, development, documentation, testing, implementation and maintenance.

Working Knowledge on Unix operating system and shell scripting

Good understanding of Data modeling concepts like ER Diagrams, UML, Use Cases, Normalization and De-normalization of Tables.

Developing Data Extraction, Transforming and Loading (ETL) mappings and scripts using Informatica Power Center using Designer

Proficient in writing PL/SQL stored procedures, packages, functions and triggers. Worked with testing team to create test cases for unit and integration testing.

Well-acquainted in working with complex SQL queries with joins, date functions, inline functions, sub-queries to generate Ad-hoc reports, functions and procedures .

Strong experience in writing SQL Queries, Views, Materialized Views, Cursors, Collections, Ref Cursor, Cursor variables, System Reference Cursor, Dynamic SQL, Exceptions. PL/SQL tables in 11g, 10g, and 9i.

Experience in query optimization, performance tuning using SQL Trace, TKPROF, Explain Plan, Indexing, Hints, Bulk Binds, Bulk Collect, Creation of global temporary tables and table partitioning.

Worked on new features like RESULT_CACHE, Table functions and Pipelined Functions to improve the performance

• Working knowledge in DBMS_PROFILE to identify performance bottleneck in PL/SQL code

Experience in writing Unit test plans and Unit testing and Involved in Production Fixes and Production Support activities.

Worked on INDICIS OF and VALUES OF and MULTISET to deal with Collections

Experience in Oracle and Other Utilities/tool: TOAD, SQL Developer, UNIX Shell Scripting, Export/Import, SQL*Loader.

Knowledgeable in writing test plans, defining test cases, developing and maintaining test scripts, Analyzing errors, interaction with team members in fixing the errors.

Experienced in using Exception Handling methods along with Pragma_Exception_init in order to associate our own created exception names.

Expertise in using advanced PL/SQL like Collections and Analytical Functions.

Experience in developing reports and forms using Crystal Reports, Oracle Forms Builder, Reports Builder and XML Publisher.

Very good understanding of data warehouse principles like fact tables and dimension tables,star and snowflake schema modeling

A Self-starter with a positive attitude, willingness to learn new concepts and accept challenges.

Strong interpersonal skills, ability to interact with people at all levels. Good communication and presentation skills.

EDUCATION: Bachelor Degree in Computer Science from Jawaharlal Nehru technological university, India

Technical Skills:

ETL Tools

Informatica Power Center 9.x/8.x

Databases

Oracle 11g/10g/9i, SQL Server 2005.

Languages

HTML, PL/SQL, SQL, Shell Scripting, Java, XML

Tools

TOAD, SQL Developer, Informatica, C#, SQL*Plus, PLSQL Developer, SQL*Loader, TKPROF, MS Office 2007,2010,Forms, Reports

Scripting

Unix Shell Scripting

Operating Systems

Windows 9x/2000/XP/7, Linux Red Hat and Sun Solaris

Professional Experience:

Implementation Partner: Creative Ideas Simple Solutions (CISS) May 2016 – Present.

End Client: Department Of Education Washington D.C.

Oracle PL/SQL Developer

The Integrated Partner Management (IPM) Initiative is a strategic effort that will, through process reengineering and process automation, provide in one solution, improved eligibility, enrollment, and oversight processes used to manage partner entities as they administer Title IV Financial Aid for students.

.

Responsibilities:

Involved in project life cycle like Designed, developed, implemented, maintained and tested the application.

Creation of database objects like tables, indexes, views, Procedures, Functions, Packages, Triggers, synonyms.

Created Data model with embarcadero data modeling tool

Developed complex queries on Database and developed PL/SQL Procedures to give in nice strategic plans to higher level of management.

Collectively used different types of control statements in order to process and manipulate data in the Stored Procedures.

Developed Triggers to enforce complex business rules and to audit changes to data.

Tuned SQL statements and Procedures using Explain Plan and TKPROF.

Extracted data from various sources like oracle and Flat files.

Analyzed many packages and modified to meet the business requirement and Improved the performance of the application by re-writing the SQL query.

Analyze one of the package and wrote functional document as per our business requirement.

Created many trigger and sequences for the application, Created and modified many views as per business requirement.

Extensive query optimization and performance tuning. Created the integrity constraints and Database Triggers and Dynamic SQL for the data validations and Used PL/SQL Tables and Records

Responsible for creation of Database Tables, Triggers Stored Procedures (using Cursors) and functions. Fine-tuned the SQL(Materialized views)

Created relevant staging tables to load the CSV files, identified the business validation rules.

Loaded the data into the tables using SQL*Loader and Analyze and fix the performance issues with DBMS_PROFILER

Used Bulk collect operations to improve the record fetching Performance and for all statement to deal with DML statements in iterative statements

Environment: TOAD,SQL Developer Oracle 11g, ASP.Net, JavaScript, c#, Microsoft Excel, MS Access, Windows server

Choice Hotel International Service Corp, Phoenix, AZ Nov-2013 – April-2016

Oracle PL/SQL Developer

Choice Hotels International, Inc. is a hospitality holding corporation. The company owns the motel brands Comfort

Inn, Comfort Suites, Quality Inn, Sleep Inn, Clarion, Cambria Suites, Mainstay Suites, Suburban Extended Stay, Roadway

Inn, and Ascend Collection. And implemented different price optimizing techniques and reservation email service and

Storing the booking and customer information.

Responsibilities:

Developed PL/SQL stored procedures, packages, and triggers for data load and transformation, and data extraction.

Extensively used sub queries and joins while writing stored procedures.

Involved in extensive coding using Oracle PL/SQL.

Implemented many analytical and aggregate functions for mathematical calculation.

Created records, Objects, collections to store ordered group of elements of faster assessment of tables.

Worked on Bulk collect to improve performance of data fetches

Worked on For-all with DML operation to improve the performance

Involved in working on Oracle Pseudo columns like ROWID, ROWNUM, SYSDATE, SYSTEMTIMESTAMP, USER etc.

Analyzed some existing scripts and created technical specifications for the script.

Alter many scripts as per requirement.

Improved the performance of the application by rewriting the SQL queries.

Analyze existing package and do the changes as per business requirement.

Used views, procedures and functions to pull the data and Wrote complex SQL query by using joins and create documentation for use by other developers and internal customers.

Create and execute unit and integrations tests to ensure code meets requirements.

Tuned and Optimized the SQL statements using Explain Plan and SQL trace utilities.

SQL*Loader was used to load the data from the flat files to database tables.

Developed batch jobs, shell scripts to automate file transfers, data cleansing, loading and final data processing.

Performed the unit testing for procedures, functions and packages.

Environment: Oracle 11g, SQL Developer, TOAD, Sun Solaris, SQL, PL/SQL, MS Access, SQL*Loader, WCAG 2.0, Tableau.

Zeta Interactive, Burlington, MA Dec 2012 – Nov 2013

Oracle PL/SQL/ETL Developer

It is a standardized project of Zeta Interactive which provides Payroll generation, Time and Attendance system & Leave system. The Employee and Payroll Systems objective is to provide a system which manages the employee details, the Payroll activity done in a company depending upon the employee’s attendance and its calculation which is very huge. The users will consume less amount of time through computerized system rather than working manually. The system will take care of all the payroll activities like managing each employee’s attendance, the number of leaves taken by that particular employee and calculation in a very quick manner.

Responsibilities:

Extracted data from various sources like Oracle and Flat file.

Extract data is loaded into new database using Informatica.

Worked on Demoralization Technique to improve the fetch performance in Data Warehouse Environment.

Migrated data from legacy systems to the data warehouse environment using SQL and PL/SQL Scripts.

Created staging tables and load the data and perform required transformations and load data into base tables.

Performed transformations using aggregate, expression and filter transformation.

Created the integrity constraints and Database Triggers for the data validations

Created PL/SQL Tables and Records

Load the data from Excel file, Text File to oracle database.

Analyzed and computed statistics to improve response time for queries.

Prepared test cases and conducted Unit Testing for this module.

Provided new reports development and enhancements to existing reports.

Extensive query optimization and performance tuning.

Worked on enhancements and bug fixes.

Wrote queries/procedures to retrieve and store data in the Oracle database.

Created Procedures, Triggers, Functions and Tables.

Developed the business functionality using Oracle PLSQL

Developed and maintaining the Database objects as a part of module development.

Provided Ad hoc reports for daily transaction

Monitor SMS jobs for successful completion

Provide SMS logs to client

Provided production support to the batch jobs.

Query the database and test the results of various applications

Document the results of the tests to development teams tasked with fixing any issues that arise.

Environment: Oracle AS, Java, J2EE (Servlets, EJB, JSP), spring and Discoverer, Toad, SQL * Loader, Informatica Power center

Fluous Solutions, Mumbai, India August 2010 –Dec 2012

Oracle PL/SQL Developer.

This application has been developed for insurance company usage .This information regarding the services and its policies .The home page incorporates basic options like available policies and their benefits terms and new schemes etc. This system handles the information for all the Insurance Policyholders including their different types of Policies, Policy Numbers Policies, Policy Numbers, Insurer’s Name, and Type of Insurance to the person, Insurance code, Insurance Agency Area, Agency Code, Division of Field Officer, Payment Method, and Policy Payment Date etc.

Responsibilities:

Developed PL/SQL Stored Procedures, Functions, Packages and SQL Scripts.

Loaded the data into database tables using SQL*loader from flat files.

Developed scripts for tables with partitions and indexes, views, materialized views and functions as per the business requirements.

Developed Test Scripts, Test Cases, and SQL QA Scripts to perform Unit Testing, System Testing and Load Testing.

Developed and modified triggers, packages, functions and stored procedures for data conversions and PL/SQL procedures to create database objects dynamically based on user inputs

Wrote SQL, PL/SQL, SQL*Plus programs required to retrieve data using cursors and exception handling

Worked on Analytical function

Created collection types such as nested tables and associative arrays and varray

Worked with bulk collect and for all statements to improve performance

Improved the performance of the application by rewriting the SQL queries.

Created PL/SQL scripts to extract the data from the operational database into simple flat text files using UTL_FILE package

Used the standard Oracle package DBMS_SCHEDULER to automate / schedule jobs on daily, weekly and monthly basis and to run jobs in parallel to improve time-constrained performance.

Developed Procedures for efficient error handling process by capturing errors into user managed tables.

Coordinated with DBA in creating and managing tables, indexes, table spaces, auditing and data quality checks.

Developed data conversion procedures in PL/SQL and Involved in maintaining batch processing PL/SQL procedures for data extraction for feed creation.

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

Environment: Oracle 11g/10g, UNIX, PL/SQL, SQL*PLUS, SQL*Loader, TOAD, SQL Server

Infronics Systems Hyderabad/Mumbai, India June 2009 – August 2010

System Engineer

Developed a Billing system for housing construction industry. The software featured receiving quotations from contractors in terms of labor and fixed price, terms and conditions of contract deriving final work order. System enabled generating accounting bills for a financial year

Responsibilities:

Responsible for Study, Analysis, Design, Development/Customization and Testing/Debugging of the application.

Involved in logical modeling and physical modeling of application.

Developed Stored Procedures, Functions, Packages and SQL Scripts using PL/SQL.

Involved in creation of Conceptual Modeling covering all the business requirements.

Loaded the data into database tables using SQL*loader from flat files.

Developed SQL scripts, packages, procedures, cursors, tables, views, materialized views and functions as per the business requirements.

Developed SQL and PL/SQL scripts to transfer tables across the schemas and databases.

Data loaded from legacy systems (ETL-Informatica) using PL/SQL and SQL*Loader.

Used the standard Oracle package DBMS_SCHEDULER to automate / schedule jobs on daily, weekly and monthly basis and to run jobs in parallel to improve time-constrained performance.

Developed Procedures for efficient error handling process by capturing errors into user managed tables.

Used Bulk Collect and FOR ALL to improve the retrieval of data

Coordinated with DBA in creating and managing tables, indexes, table spaces, auditing and data quality checks.

Developed data conversion procedures in PL/SQL. Involved in maintaining batch processing PL/SQL procedures for data extraction for feed creation.

Developed Shell scripts to automate execution of SQL scripts to check incoming data with master tables, insert the valid data into Customer Management System and invalid data into error tables which will be sent back to sender notifying the errors.

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

Environment: Oracle 10g, SQL * Plus, TOAD, SQL*Loader, LINUX Red Hat, PL/SQL Developer.

Skill Set:

Oracle SQL

Oracle PL/SQL

Performance Tuning

UNIX Shell Script

Informatica

Contact this candidate