PRANAVI ACHANTA

Email: ac7mpy@r.postjobfree.com

Cell: 571-***-****.

SUMMARY:

* ***** ** *********** ********** as an Oracle PL/SQL data warehouse Developer/Data analyst and SAP BO developer with Oracle 10g/11g/12c databases in Analysis, Design and Implementation of Business Applications using the Oracle Relational Database Management System (RDBMS).

Involved in all phases of the SDLC (Software Development Life Cycle) from analysis, design, development, testing, implementation and maintenance with timely delivery against aggressive deadlines.

Good knowledge on Python, Ruby

Created application documents for future reference.

Good knowledge on creating excel reports.

Extensive experience in using SQL, PL/SQL, ORACLE Database, and many other tools, such as SQL*PLUS, SQL Developer and TOAD, TFS, HP QLM

Proficient in Complex SQLs, PL/SQL Functions and Procedures, Packages and creation of Oracle Objects - Tables, Materialized views, Triggers, Synonyms, User Defined Data Types.

Effectively made use of Table Functions, Indexes, Table Partitioning, Collections, Analytical functions, Materialized Views, Query Re-Write and Transportable table spaces.

Developed materialized views for data replication in distributed environments.

Experience with Oracle Supplied Packages such as DBMS_JOB, and Partitioned Large Tables using range partition technique.

Highly skilled in Performance tuning - analyzing query plans and query tuning using the tools such as EXPLAIN PLAN wherever required.

Experience in advanced PL/SQL concepts.

Good knowledge on MS excel formulas.

Expertise in Dynamic SQL, Records and Exception Handling.

Developed and supported Extraction, Transformation and Load process (ETL) using PL/SQL and to populate the tables in OLTP and OLAP Data warehouse environments.

Implement and maintain database security such as create and maintain users and roles, assign privileges to roles and grant roles to users.

Experienced in scheduling the jobs using Autosys.

Experience in understanding complicated performance issues and worked with DBA's to suggest valuable ways to fix the problem.

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

Technical Skills:

Databases

Oracle 10g/11g/12c databases

Operating System

Windows 98/XP, MS Windows 2000/2003/2007/2008/2010

Languages

PL/SQL, HTML, UNIX shell script, Java, C, Python, Ruby, R

Code Version Control Tools

Wincvs, Tortoise SVN, Visual studio

Tools/ Utilities:

SQL*Plus, SQL Developer, TOAD, SQL loader, Oracle SQL developer, MS Excel, MS word, MS office, SAP BO, HPQC, Chef

PROFESSIONAL EXPERIENCE

IMF (International monetary fund), Washington DC March2017-Tilldate

Role: Data Warehouse Developer/Data analyst, SAP Business objects developer

The IMF, also known as the Fund, was conceived at a UN conference in Bretton Woods, New Hampshire, United States, in July 1944. The IMF's primary purpose is to ensure the stability of the international monetary system the system of exchange rates and international payments that enables countries (and their citizens) to transact with each other.

Responsibilities

Use Agile methodology for application development.

Worked as a Backend developer and BO report developer.

Worked on data ware house database involved in root cause analysis for production incidents

Support in requirements gathering from the end users.

Worked with front-end people to develop an application.

Documented all the application related documents for future maintenance.

Generated several reports using SAP BO

Generated reports using Service now

Update design documents according to the changes made to the application

Designed/developed/Modified tables, views, stored procedures, packages and functions.

Coded PL-SQL packages and procedures to perform data loading, error handling and logging.

Involve in Unit Testing for the application developed using test cases in HP QC ALM to increase the performance of the code.

Generated and tested the reports in service now.

Generated Excel reports

Generated the management reports in SAP Business objects (BO) by using SQL queries.

Tuned database SQL statements and procedures by monitoring run times and system statistics. Inserted hints and rewrote code as required.

Used SQL loader to load the data from the files provided by the interfacing applications.

Created new Procedures, Functions, Database links, Packages, Cursors, Dynamic SQL, Table functions as part of Project/Application requirements.

Created partitioned tables and partitioned indexes to improve the performance of the applications.

Partitioning of Tables to accommodate large volume of data and faster data retrieval and created local indexes for partitioned tables.

Good understanding of database objects and ability to troubleshoot issues.

Involved in PL/SQL code review and modification for the development of new requirements.

Code SQL Stored Procedures and integrated with application

Involve in Unit Testing for the application developed using test cases.

Sedgwick CMS, Memphis, TN Aug2016-Jan2017

Role: Oracle PL/SQL Developer

Sedgwick Claims Management Services, Inc., is a leading global provider of technology-enabled risk and benefits solutions. At Sedgwick, caring countsSM; the company takes care of people and organizations by delivering cost-effective claims, productivity, managed care, risk consulting and other services through the dedication and expertise of more than 14,000 colleagues in some 275 offices located in the U.S., Canada, the U.K and Ireland. Sedgwick facilitates financial and personal health and helps customers and consumers navigate complexity by designing and implementing customized programs based on proven practices and advanced technology that exceed expectations.

Responsibilities

Use Agile methodology for application development

Support in requirements gathering from the end users

Update design documents according to the changes made to the application

Designed/developed/Modified tables, views, stored procedures, packages and functions.

Coded PL-SQL packages and procedures to perform data loading, error handling and logging.

Tuned database SQL statements and procedures by monitoring run times and system statistics. Inserted hints and rewrote code as required.

Used SQL loader to load the data from the files provided by the interfacing applications.

Created new Procedures, Functions, Database links, Triggers, Materialized Views, Packages, Cursors, Dynamic SQL, Table functions as part of Project/Application requirements.

Created partitioned tables and partitioned indexes to improve the performance of the applications.

Wrote PL/SQL Database triggers to implement the business rules in the application.

Implemented all modules logic by using Triggers and Integrity Constraints.

Partitioning of Tables to accommodate large volume of data and faster data retrieval and created local indexes for partitioned tables.

Used BULK COLLECT to pull the records faster.

Good understanding of database objects and ability to trigger issues.

Involved in PL/SQL code review and modification for the development of new requirements.

Code SQL Stored Procedures and integrated with application

Involve in Unit Testing for the application developed using test cases.

Environment: Oracle 11.2.0.2, 11.2.0.3, 11.2.0.4, 10g R2 PL/SQL, TOAD

Techgene solutions, India June 2014–Mar 2015

Role: Oracle Consultant

Techgene Solutions is one of the largest computer hardware company, based in India. It is one of the most admired companies in United States of America.

Responsibilities:

•Writing Procedures, Functions, Packages and Triggers

•Continuous debugging and overall support Used %TYPE and %ROWTYPE for anchoring the variables to the database data types.

•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.

•Use Agile methodology for application development

•Support in requirements gathering from the end users

•Update design documents according to the changes made to the application

•Designed/developed/Modified tables, views, stored procedures, packages and functions.

•Coded PL-SQL packages and procedures to perform data loading, error handling and logging.

•Tuned database SQL statements and procedures by monitoring run times and system statistics. Inserted hints and rewrote code as required.

•Backup strategies, scheduling the backups. Backing up and restoring the databases whenever necessary.

•Actively involved in coding SQL statements in PL/SQL.

•Implementing the system at client side and imparting training to the end users at the Regional office in Chennai

•Causal analysis and fixing of the defects/bugs uncovered during the development.

•Attaining daily client meeting and providing reports to the project manager on the development quality.

•Optimized the Oracle PL/SQL queries by Performance Tuning.

Environment: Oracle 9i/10g/11g, PL/SQL, SQL, TOAD, SQL*Loader

EDUCATION

DEGREE: MASTER OF COMPUTER APPLICATIONS

DURATION: JUNE 2011-APRIL 2014

LEVEL: GRADUATE DEGREE

GPA: 3.8

DEGREE: BACHELOR OF COMPUTER SCIENCE AND STATISTICS AND MATHEMATICS.

DURATION: JUNE 2008-APRIL 2011

LEVEL: BACHELOR’S DEGREE

GPA: 3.5

Contact this candidate