SRUJANA REDDY Email ID: addg51@r.postjobfree.com

Oracle Developer Phone: 732-***-****

SUMMARY

·About 4 years of IT experience as an Oracle PL/SQL Developer, more than 1 year as an ETL/Big Data Developer, involved in Requirement gathering, Analysis, Design, Development and Unit Testing.

·Written SQL Queries, PL/SQL package, function, stored procedure, triggers, and cursors.

·Created database objects like tables, views, sequences, synonyms, indexes using SQL Developer.

·Transferred data using data transfer tools like FTP (File Transfer Protocol) and SFTP.

·Experience with all phases of the Software Development Life Cycle.

·Have worked in fast paced AGILE environment & attended daily scrum meeting.

·A good understanding of UNIX and shell scripting.

·Used PL/SQL and SQL*Loader to create ETL packages for flat file loading and error capturing into log tables.

·Experience in developing various database objects like Tables, Views, Indexes, Procedures, Functions, Triggers and Packages and using them for business development.

·Write UNIX shell scripts to call SQL’s, procedures, functions to perform ETL process on the data.

·Knowledge on advanced PL/SQL functionalities such as collections, bulk processing, analytical functions, performance tuning, packages, external tables, materialized views.

·Worked with complex SQL queries with joins, date functions, constraints, sub-queries.

·Good understanding and knowledge of Hadoop Big Data Ecosystems (MapReduce, HDFS, Hive, Pig, Sqoop).

·Worked on loading and transforming large sets of data using python-spark library developed by data warehouse team.

·Proficient at working as a team player with an aim of contributing towards the team's success. Involved in unit testing.

·Strong communication skills for both technical level and with end users.

EDUCATION

·Master’s Degree in Electrical & Computer Engineering from Southern Illinois University with 3.6 GPA

·Bachelor’s Degree in Electronics and Communication Engineering from Jawaharlal Nehru Technological University, India

TECHNICAL SKILLS & ABILITIES

·Databases : Oracle 11g/12c

·Languages : Oracle SQL, PL/SQL, HTML

·Scripting Tools : WinSCP, Shell and Putty

·Operating Systems : Windows, Linux, Mac

·Oracle Utilities : SQL Loader, Explain Plan, Oracle Database Utilities

·Database Development Tools : SQL Developer, TOAD, UNIX/LINUX Utilities, Aginity Netezza

·Management Tools : TFS Visual Studio, GIT, Control M Scheduler

·Applications : MS Word, MS Excel, Outlook, PowerPoint

·Hadoop Big Data ecosystems : MapReduce, HDFS, Hive, Pig, Sqoop

EXPERIENCE

I5TECH, INC. MARCH 2019 – CURRENT

CLIENT: Blue Cross Blue Shield of North Carolina, Durham, NC

DURATION: Feb 2019 – Current

Project Name: Care Radius application projects

Responsibilities:

·Responsible for the technical planning, design, programming, implementation, documentation, and maintenance of systems application software.

·Worked for Care Radius(BlueCross NC application) Healthcare projects.

·Understanding of client’s functional requirements and participate in writing functional design document.

·Read through Functional design document to write the Technical Specification document and code.

·Created PL/SQL scripts to extract the data from operational database into simple flat files using UTL_FILE package and do transformation of the data and load into final tables.

·Used bulk collections for better performance and easy retrieval of data, by reducing context switching between SQL and PL/SQL engines.

·Used Pragma Autonomous Transaction to avoid mutating problem in database trigger.

·Collaborated with developers to enhance supportability and identify performance bottlenecks.

·Write SQL scripts to fetch data from Teradata database into flat files, compare with existing data for delta rows and update the records in the User Defined Tables to update the Alerts on Care Radius UI.

·Wrote Unix Shell scripts to process PL/SQL scripts on daily basis and load data into the User Defined tables or create files based on the project requirement.

·Worked on SQL Loader lo load data from flat files obtained from various systems every day.

·Coordinate with DBAs for tasks such as creating/rebuilding indexes, adding partitions, and analyzing tables.

·Created technical design for the back-end PL/SQL based on business requirement documents and the functional system design.

·Work with vendors on File Transfers, create scripts to check for counts balances between vendor & BlueCross authorizations and send email notifications if the counts are out-of-balance.

·Involved in moving the data from flat files to staging area tables using SQL loader.

·Extensively used for all and bulk collect to fetch large volumes of data from the table.

·Performance testing and rewriting of low performing production Code/SQL statements & procedures.

·Writing stored procedures, triggers and monitoring performance to ensure efficient data retrieval, improve performance using Explain Plan.

·Performed Unit testing and Functionality testing of the financial module based on test scenarios and validating the data on Care Radius front end.

·Scheduled the batch jobs on Control-M.

·Handled errors using Exception Handling for the ease of debugging and displaying the error messages in the logs.

·Documented code in accordance with company policies, company standards and industry best practices.

·Coordinated with QA and Production support teams during code deployment in their respective environments.

Environment: SQL Developer, PLSQL Developer, Putty, WinSCP, CareRadius(EXL Services), Control M Scheduler, Teradata SQL Assistant, WinSCP, ServiceNOW

CLIENT: Mastercard, O’Fallon, MO

DURATION: Mar 2017 – Feb 2019

Project Name: Multiple projects in Data Warehouse ETL

Responsibilities:

·Responsible for the technical planning, design, programming, implementation, documentation, and maintenance of systems application software.

·Consult with Business Owners on new projects.

·Participate in implementation, including maintenance, user allocation, file design, coding, error removal, logic optimization, systems re-evaluation, testing, user approval, final corrections, and program and run time documentation.

·Involved in analysis, design, coding and Testing.

·Develop batches and maintain them using an internal application ‘Batch Manager’.

·Wrote complex SQL queries using joins, sub queries and inline views to retrieve data from the database.

·UNIX Shell Scripting to automate procedure execution from UNIX box.

·Wrote and modified Oracle PL/SQL, SQL statements procedures and functions that are called in the UNIX shell script.

·Responsible for creating and modifying the PL/SQL procedure, function according to the business requirement.

·Used SQLLDR utility in the UNIX scripts to load the data into the database tables.

·Involved in writing cross database queries.

·Load data from Oracle instance to Netezza using NZLOAD utility in the UNIX script.

·Wrote PL/SQL statements, stored procedures and functions, following best practices regarding QA and implementation standards.

·Export and import data into HDFS and Hive using sqoop.

·Experience in working with Windows, UNIX/LINUX platform with different technologies such as Big Data, SQL, Shell Scripting etc.

·Involved in creating Hive tables, load data into partitioned tables and writing Hive queries.

·Involved in loading and transforming large sets of structured, semi-structured and unstructured data and analyzed them by running Hive queries and Pig scripts.

·Write, debug, diagram, create flowcharts, code, and document programs.

·Responsible for delivering accurate, quality batch application code based on design specifications.

Environment: TOAD, Putty, WinSCP, GIT, Aginity, BMC Remedy

CLIENT: LAUSD, Los Angeles, CA

DURATION: Mar 2016 – Feb 2017

Project Name: Student ID

Responsibilities:

·Developed PL/SQL Packages, Stored procedures, Triggers, and finely tuned them for performance. Extensively used PLSQL tables and Bulk loader programs for processing data and loading into oracle tables.

·Knowledge of Extraction Transformation and Loading (ETL) processes using Unix shell scripting, SQL, PL/SQL and SQL*Loader.

·Used Bulk Collections for better performance and easy retrieval of data, by reducing context switching between SQL and PL/SQL engines.

·Implemented various automated UNIX shell scripts to invoke PL/SQL anonymous blocks, Stored Procedures, Functions, Packages.

·Developed both inbound and outbound interfaces to load data into targeted database and extract data from database to flat files.

·Used FTP to transfer the files into different servers as per needed by the business users.

·Developed complex SQL queries using various joins and developed various dynamic SQL’s throughout the project.

·Involved in Unit testing of the Reports and PL/SQL Stored procedures.

·Modified existing codes and developed PL/SQL packages to perform Certain Specialized functions /enhancement on Oracle application.

·Worked with different FTP clients (WinSCP) for loading data from the windows environment to the Unix environment.

·Experience in using Cursors for processing of data.

·Developed batch programs using UNIX shell scripts to generate reports daily, weekly & monthly.

Environment: Oracle SQL Developer, Putty, WinSCP, TFS Visual Studio

Contact this candidate