Data Engineer United States

Varun Etakula

Data Engineer/ Sr.Backend Developer

973-***-**** *****.*******@*****.*** Dallas, TX, United States Open to Remote Open to Hybrid LinkedIn

SUMMARY

•12+ years of IT experience (6+ years in Tolling industry (supported HCTRA(Harris County Toll Road Authority) through Electronic Transaction Consultants, LLC (ETC) ), 3+year in Banking/Finance(Wells Fargo, DTCC (Depository Trust and Clearing Corporation), 1+ year in Retailing(Dollar General), 1+Year in Health Insurance (Obama care (Washington Health Benefit Exchange)), 1+year in Government Housing (NYCHA(New York City Housing Authority)) as a Sr. PL/SQL developer, ETL Developer and Reports.

•System Analysis, Design, Development & Support of Oracle Database 8i/9i, 10g /11g / 12C/19C in Production, staging and Development environments and 2+ years as Oracle SOA Suite 11g developer.

•Excellent skills in designing and development of applications using Oracle 19c/ 12c/11g/10g/9i/8i, SQL, PL/SQL, Reports 10g/9i/6i, Oracle Application Express 19.

2/18.1, UNIX/Perl/Linux Shell Scripting and expertise in Oracle Service Oriented Architecture (SOA) with a strong focus on Business Process Execution Language (BPEL).

•Expertise in data loading and data extraction between Snowflake and AWS S3.

•Hands on experience in working in JSON and XSLT for processing and generating XML Reports.

•Excellent Knowledge of Business Intelligence and Data Warehousing Concepts.

•Have hands on experience in creating mappings, defining workflows and tasks using Informatica Power Center as a ETL tool for data warehousing applications.

•Experienced in reviewing and tuning the PL/SQL programs for better performance.

•Expertise in Oracle Service Oriented Architecture (SOA) with a strong focus on Business Process Execution Language

(BPEL).

Expert in providing technical solutions using Oracle SOA Suite 11g/10g (BPEL, ESB/Mediator, Rules Engine, BPM Work list).

•Expertise in SOA, Orchestration and Integration technologies in the areas of Web Services, ESB, SOAP, WSDL, BPEL, XML, XSD, UDDI, XML and Web services Security.

•Knowledge of data modeling techniques includes virtually every flavor of Entity-Relationship (ER) modeling, Physical and Logical data modeling.

• Involved in all phases of SDLC (Software Development Life Cycle), from analysis, design, development, testing, implementation and maintenance with aggressive deadlines good knowledge on Oracle tools like SQL, PL/SQL, SQL * PLUS and used TOAD in many development projects.

•Hands-on experience in UNIX shell scripting, used scripts for auto batch process.

•Experience in developing External Tables, Joins, Indexes and sequences.

•Expertise in creating Oracle objects like Tables, Synonyms, Triggers, Indexes, Views, Materialized Views and Table Partitions.

•Proficient in advance features of Oracle for PL/SQL programming like using Cursor variables, Ref. Cursors, Varrays, nested tables and Dynamic SQL.

•Experience in Query Performance Tuning by Analyzing tables, Bulk Collect feature, FORALL statements, and Troubleshooting Oracle database issues.

• Identified several SQL and PL/SQL bottlenecks using PL/SQL Profiler (package DBMS_PROFILER), explain plan, auto trace and tuned them to suit SLA.

•Developed and Modified PL/SQL packages, functions, Procedures as per customer requirement to make new enhancements or to resolve problems.

•Enforcing data integrity using integrity constraints & database triggers.

• Improve the performance of the slow SQL queries by implementing indexes, using FORALL and BULK COLLECT.

•Working knowledge with different source control tools-GIT,SVN,Bitbucket, IBM Clear case etc.,

•Experienced in analyzing the performance metrics of Database applications to ensure it meet the standards and providing optimal solution for scalability of the applications.

•Experienced in preparing unit test plan and test cases and performing the unit testing and fixing the defects. WORK EXPERIENCE

Sr. Backend Developer

Client-Depository Trust & Clearing Corporation (DTCC) Coppell,TX, United States Depository Trust and Clearing Corporation (DTCC) is a financial services company that provides clearing and settlement services for financial markets. It acts as a central clearinghouse, manages assets, reduces counterparty risk, facilitates trade reporting, and operates technology platforms for efficient processing. Its role is to ensure the smooth functioning of securities markets and enhance transparency in the financial system. Involved in the Requirement Analysis, Requirement Walkthrough, Design Walkthrough and Test Plan walkthrough with Business and Architect Teams.

Worked on the SQL Scripts, Packages, Stored Procedures, Functions and Views to implement the Business logic to generate the reports.

Worked on data migration from Oracle to the Snowflake through data files using AWS S3 as an external stage. Worked closely with the front end application (Angular Java Script) team to integrate Snow sqls for the Weaver Reporting tool.

Worked on the Snow flake store procedures and UDFs to support backend applications. Converted all the views query's from Oracle to the Snowflake compatibility as part of the migration. Involved in the production support of the Data load processes, Issue Analysis, Root Cause Evaluation, Issues Resolution and Closure.

Automated builds and deployment using Jenkins as part of Continuous Integration. Prepared test data, support and resolved the defects in raised by QA/UAT or Risk Teams. Used GIT and Bitbucket as source control repositories for code maintenance and delivery support. Skills & Tools used: Snowflake, Oracle Database 19c, PL/SQL Developer, Oracle performance tuning, AWS S3, GIT, Bitbucket.

Sr. PL/SQL Developer

Client-Electronic Transactions Consultants (ETC)

Sep '21 — Jul '23

Richardson, United States

Project: Harris County Toll Road Authority (HCTRA) RITE2.0 HCTRA was created by Harris County Commissioners Court in order to construct, maintain, and operate toll roads in the rapidly growing Greater Houston Metropolitan area. The RITE Solution is an impressive suite of enterprise roadside solutions and back office business applications incorporating high- level process automation that streamlines customer service account management, violation-loss recovery, and accounting. This solution provides features for achieving diverse roadside toll collection, operational effectiveness and efficiency, reliable financial reporting, and compliance with laws, regulations, and policies It provides an effective, efficient, user-friendly interface and accurately and reliably collects millions of toll transactions each day on some of the country's busiest toll roads. Participate in business requirement discussions, design meetings, functional and technical discussions, brainstorming sessions.

Created comprehensive enterprise E-R Diagrams of entire tolling system using SQL*Developer Data Modeler. Designing, modifying, developing, writing and implementation of software programming applications. Creation of database (PL/SQL) objects like Tables, Views, Materialized Views, Sequences, Procedures, Functions and Packages etc., as per the business requirements to make new enhancements. Creation of database (PL/SQL) objects like Indexes, Bulk Binds, Constraints and implementing the Bulk Processing

(Bulk Collect/For All) and Hints on Tables/SQLs for Performance Tuning of the database by making use of Explain Plan, TKPROF & DBMS Profiler.

Creation of packages, procedures, pipelined table functions, jobs, programs, triggers, Object types, leveraging Oracle 12c's new features.

Worked in Legacy application maintenance environment to do the gap analysis between HCTRA Legacy and HCTRA BOS and did reverse engineering to identify the bottlenecks in old system. Created custom SQL build script that creates entire database with seed data in a new PDB, runs wtPLSQL unit tests, creates JUnit XML for Jenkins reporting, unplugs and zips PDB for storage on Nexus server. Participate in full development life cycle of enterprise scaled software applications utilizing Oracle, object-oriented analysis, design, and implementation of web-based applications. Analyze and solve application issues in various environments like DEV, TEST, UAT and Production. Provide debugging and code analysis support and support implementation of application software releases and other related activities like scheduling and running the jobs. Work closely with the QA and business team to investigate issues and find out the root cause for issues and resolve any data discrepancies in the Waterfall and Agile Data Models. Participate in the testing process through test review and analysis, test witnessing and certification of software system analysis, design and implementation of web-based applications.

Provide production support for system issues to include warranty support for software solutions that involves both On Call and after hour's support.

Provide code delivery support for tracking changes in source code using source control management system tool-GIT. Skills & Tools used:

Oracle Database 19c, PL/SQL Developer, Oracle performance tuning, HP Quality Center, TOAD. Control-M, Unix, Linux, MS PowerPoint, MS Word, MS Excel, GIT. Client Sr.Oracle pl/sql Developer

Client-Dollar General

Jul '20 — Aug '21

Nashville,TN, United States (Remote)

Digital Pop shelf and Assortments project that deals with identifying the sales and refilling the store stacks with items from different dollar general distribution centers that are located across the country. The items are widely classified into different categories like Fresh, Tobacco and general items etc., Every type of items have many suppliers/vendors and have its own way for storage in Distribution Centers and make it available Online. Participate in Sprint planning and work with technical lead to code the changes and do the testing and to create the test documents for review.

Worked on Dollar General Internal Framework UI Tool for creating Alerts on jobs failures and Dashboards to monitor the job run times, Data loads and to analyze performance. Data Analysis on existing Gold Application Data which is a vendor product to rewrite using Oracle and worked on migration of Vendor Data (GOLD)Application to Oracle. Worked on developing the Day-to-Day requirements from Business to customize the Vendor product to support DG Business solution and also developing the tactical solution for Gold Application Tables for order processing. Worked on Creating OpCon Jobs/Alerts to schedule the Jobs the jobs on Daily basis and also trigger an alert whenever there is a Data issue or mismatch in UNIX environment. Created VIEWS for generating reports and restricting data access to different users. Created different packages leveraging Oracle 12c’s new features such as pipelined table functions with FORALL and BULK COLLECT to collect BULK records as a whole and pass from one procedure to another. Extensively used PARTITIONING (list, range, Hash and Composite ) on tables for performance improvements. Worked on MATERIALIZED VIEWS with COMPLETE, FORCE

refreshes to improve the Performance of different applications. Improved performance of the process by analyzing EXPLAIN PLAN, using HINTS and AWR report.

Worked on ANALYTICAL functions like LISTAGG, RANK, ROWNUMBER, and DENSE RANK in order to segregate the data for reporting purposes.

Involved in writing complex hierarchical queries using CONNECT BY PRIOR clauses and other complex SQL Queries to support Java applications.

Used ORACLE DATABASE DICTIONARY to gather users and their privileges, tables, table columns and their data types, integrity constraints, indexes, statistics about tables and indexes used by the optimizer, privileges granted on database objects, storage structures of the database etc., Worked on GIT as Version control tool for code delivery support and also tracking changes in the source code. Skills & Tools used: Oracle Database 12c, TOAD, Oracle performance tuning, JIRA, Unix, Linux, MS Power Point, MS Word, MS Excel, GIT.

Sr.Pl/Sql Developer

Client- Electronic Transactions Consultants (ETC) (Contract) Jun '18 — May '20

Richardson,TX, United States

Responsibilities:

Participate in full development life cycle of enterprise scaled software applications utilizing Oracle, object-oriented analysis, design, and implementation of web-based applications. Creation of database (PL/SQL) objects like Indexes, Bulk Binds, Constraints and implementing the Bulk Processing

(Bulk Collect/For All) and Hints on Tables/SQLs for Performance Tuning of the database by making use of Explain Plan, TKPROF & DBMS Profiler.

Analyze and solve application issues in various environments like DEV, TEST, UAT and Production. Provide debugging and code analysis support and support implementation of application software releases and other related activities like scheduling and running the jobs. Work closely with the QA and business team to investigate issues and find out the root cause for issues and resolve any data discrepancies in the Waterfall and Agile Data Models. Participate in the testing process through test review and analysis, test witnessing and certification of software system analysis, design and implementation of web-based applications. Provide production support for system issues to include warranty support for software solutions that involves both On Call and after hour’s support.

Provide code delivery support for tracking changes in source code using source control management system tool – GIT. Skills & Tools used: Oracle Database 12c, PL/SQL Developer, Oracle performance tuning, HP Quality Center, TOAD. Control-M, Unix, Linux, MS Power Point, MS Word, MS Excel, GIT. Pl/SQL Developer

Client-Wel

Sep '17 — May '18

Minneapolis, United States

Integrated Compensation Application (ICA) under Wealth and Investment Management (WIM) module is an internal application used by Producers to track sales/referrals and commission pay outs and for Managers to review them. It also tracks information to support the evaluation of bonus-eligible team members. SEI Trust 3000 (SEI) is the current source system which provides reports, statements, update and store client account and contact information, keep track of client assets, process cash deposits, withdrawals, and trade securities. WIM's planned new system of record "SEI Wealth Planning (SWP)" to replace the current source system. The main scope of the project is to ensure that ICA system would accommodate the changes due to the conversion of SEI Trust 3000 platform to SEI Wealth Platform (SWP) and provide essentially the same functionality and calculations. Responsibilities:

Understand and analyze requirements, follow up with business analysts and subject-matter expert team for any clarification, if required.

Developed and modified Oracle packages, stored procedures, functions, synonyms, tables and indexes to get the data from two different source systems and implement new business requirements and rules. Created PL/SQL scripts using advanced features like bulk collect, pl/sql tables and dynamic sql for better performance. Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application.

Worked on Query Optimization Techniques for complex SQL Statements that are running longer and provided solutions to make the process run faster.

Worked on Performance tuning by using Explain plans and various hints. Responsible for primary development of testing strategies. Performs more complex analysis of business requirements and system specifications.

Written Test cases for compare source and target database systems. Used the ALM tool to track the defects and solve them. Environment: Oracle 12C, Oracle performance tuning, Oracle SQL Developer, ALM. Pl/SQL Developer

Client-Electronic Transactions Consultants (ETC) (Contract) Jan '15 — Aug '17

Richardson, United States

Project: HCTRA Legacy to BOS Data Migration Responsibilities: Involved in Design, development, implementation and maintenance of custom oracle applications written in PL/SQL. Involved in design and implementation of an application called Online Customer Service Center for HCTRA (Harris County toll road authority) BOS (Back-office systems). Involved in the gap analysis between HCTRA Legacy and HCTRA BOS and did reverse engineering to identify the bottlenecks in old system.

Extensively involved in Writing PL/SQL Stored Procedures, Functions, and Packages to meet the business requirements. Code tuning or Query Optimization done using Explain Plans, Hints Involved in many presentations, demonstrations, code reviews, scheduling and running the jobs. Extensively used analytical functions, pivoting and Materialized Views for reporting purposes. Implemented multi-threaded framework to schedule migration jobs with optimum threads. Creating the test plans, reviewing test plan results executed by internal QA and take necessary action if any test case fails. Tracking the issues reported by external QA teams and includes them as part of internal QA execution in test plan. Provided production support and 24/7 support for resolving the critical production issues. Involved in the solving the tickets that are raised by the end users. Responsible for creating PLSQL Programs for Data Validation and Data Conversion. Environment: Oracle 11g, Oracle performance tuning, PL/SQL Developer, QC, TOAD.

PL/SQL Developer

Deloitte

Jan '14 — Jul '15

Camphill,PA, United States

Project- The Washington Health Benefit Exchange was created in state statute in 2011 as a "public-private partnership," separate and distinct from the state. The Exchange is responsible for the creation of Washington Health plan finder, an easily accessible, online marketplace for individuals, families and small businesses to find, compare and enroll in Qualified Health Plans. Responsibilities:

Developed various procedures, functions and packages to implement the new business using Oracle PL SQL. Worked very closely with functional team to understand the Development related requirements. Extensively worked in Oracle SQL, PL/SQL, SQL*Plus, SQL*Loader, Query performance tuning, Created DDL scripts, created database objects like Tables, Views Indexes, Synonyms and Sequences. Created indexes on the tables for faster retrieval of the data to enhance database performance. Created records, tables, collections (nested tables and arrays) for improving Query performance by reducing context switching.

Ease of debugging and displaying the error messages in the application. Created PL/SQL scripts using advanced features like bulk collect, pl/sql tables and dynamic sql for better performance. Involved in Unit testing PL/ SQL Stored Procedures and Functions. Developed complex queries as per client request as a part of production support Created test scenarios for created code and distribute across to the QA along with Knowledge transfer. Performs Oracle database troubleshooting and management. Involved in maintenance and resolve CR tickets. Environment: Oracle 11g, Oracle performance tuning, Oracle SQL Developer, TOAD, PL/SQL. Oracle Consultant

Client- New York City Housing Authority (NYCHA) New York, United States New York City Housing Authority (NYCHA) provides public housing for low- and moderate-income residents throughout the five boroughs of New York City. It also administers a citywide Section 8 Leased Housing Program in rental apartments. Responsibilities:

Developing highly complex applications using Oracle 11g database as backend with expertise in design and development of Oracle PL/SQL packages and procedures. Responsible for analyzing, Design and developing the code logic in Oracle Forms and also worked on Oracle databases which is to develop and maintain for the real production environments. Developed Packages and customized functions and Triggers based upon the business logics. Participated in system analysis and data modeling, which included creating Tables, Views, Indexes, Synonyms, Triggers, Functions, Procedures, Cursors and Packages.

Utilized SQL*Loader to load flat files into database tables. Used PL/SQL developing to load data from the source table to the target table based on the business logic.

Developed conversion programs to bring Legacy details into Oracle table using SQL*Loader, PL/SQL Package and populated data into base tables.

Migrated existing Core Interfaces from 10g to 11g, Unit tested, deployed on to the Production Environment. Involved in the Generic Exception handling implementation for migrated processes of SOA Suite 10g to 11g Added Error Handling Framework to the migrated processes. Involved in the BPEL processes that contain and also, for the mediator components to capture the mediator faults. Involved in the redesigning of existing processes to support the new features in SOA 11g (EDN). Developed Mediators for routing the requests to different BPEL processes and integrating with the legacy systems (Siebel and Maximo).

Created PL/SQL blocks using Cursors, REF Cursors, Collections Nested Table, various Complex Triggers

Designed and developed data-centric Web-enabled applications using Oracle Application Edition (APEX). Developed PL/SQL Procedures, Functions and Packages and used SQL loader to load data into the database. Involved in tuning and optimizing SQL queries by using quest control tools and manual by EXPLAIN PLAN. Used TOAD, Oracle PQL developer tools for faster application design and developments Performance tuning, SQL tuning. Used Materialized Views in order to improve the performance. Proposed and coded enhancements on Oracle PL/SQL Environment: Oracle SOA suite 11g, Oracle Database 11g, BPEL, Oracle SQL Developer, TOAD, PL/SQL, UNIX (Solaris), PUTTY., XML, WSDL, XSDs.

Oracle pl/sql Developer

Client-PANDUIT Corporation Tinley Park, United States PANDUIT was responsible for new invention that uniquely organized control panel wiring and allowed new wires to be added quickly and neatly. It is responsible for introducing thousands of problem-solving new products and remained committed to providing innovative electrical and network infrastructure solutions. Responsibilities: Created many Generic Stored Procedures, Functions, Database Triggers, Packages, Tables, Indexes, Views, Synonyms, Sequences using SQL and PL/SQL.

Extensively used PL/SQL programming in back end and front-end Functions, Procedures, and Packages to implement business Logics/rules.

Extensively worked in Oracle SQL, PL/SQL, Query performance tuning, Created DDL scripts, created database objects like Tables, Indexes, Synonyms and Sequences.

Analyzed the system requirements and performed logical and physical design of the database. Developed service-oriented architecture (SOA) based design involving designing complex schemas (XSDs) for the registration form of the mobile calculator application. Developed BPEL process to integrate various existing services into end-to end process flow and to retrieve it accordingly. Developed web service for the calculator metrics using BPEL process to capture the information of the usage of the mobile application.

Used SQL*Loader for data uploading from flat files. PL/SQL Coding and SQL tuning throughout the development wherever needed.

Experience in developing Dynamic SQL and Ref cursors and Hands-on experience in writing Packages, Stored procedures, Functions, and Database.

Created application schema as tables, view and indexes and customized the stored procedures and database triggers in PL/SQL.

Exception handling and cursor management in PL/SQL. Involved in developing packages to transfer data from different Oracle forms to Oracle database, every time whenever processor do the transactions. Involved in form level coding for Approval, Data Entry, Data Query and Response Modules as per the requirements. Developed UNIX Shell scripts to automate table creation, execute procedures. Designed Conversion and Interface Programs using PL/SQL procedures and packages. Analysis, Development, Testing and Implementation using Oracle 11g/10g. Environment: Oracle SOA Suite 11g,Oracle Database 11g, Oracle performance tuning, SQL

loader, Oracle SQL Developer, TOAD, PL/SQL,BPEL, DB Adapter, XML, WSDL, XSDs. EDUCATION

Masters in Computer Science, St. Mary's University of San Antonio, TX (GPA: 3.6/4) United States Bachelors in Computer Science and Engineering, JNTU, India India CERTIFICATIONS

• Oracle Database 12c: Advanced PL/SQL Developer Certified Professional

• Oracle Cloud Infrastructure (OCI)- Associate Jul '23 SKILLS

Database Management Oracle performance tuning, Snowflake, oracle database 19 C Development Tools TOAD, GIT

Project Management JIRA, Bitbucket

Operating Systems Unix, Linux, Windows 10

Productivity Software MS Power Point, MS Word, MS Excel

Contact this candidate