Balarama Kaka

ad2g65@r.postjobfree.com

469-***-****

Professional Summary:

Around 10 years of extensive experience as an Oracle Developer in Analysis, Design and Implementation of Business Applications using the Oracle Relational Database Management System (RDBMS), Support and Migrations projects on different domains.

Expertise in Software Development Life Cycle (SDLC) of client implementations including Requirements Gathering, Business Analysis, System Configuration, Design, Development, Testing, Technical Documentation and Support.

Well versed in developing various database objects like Packages, Stored Procedures, Functions, Triggers, and Tables, Indexes, Constraints, Materialized Views and others in Oracle 11g/10g /9i database.

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

Strong experience Expertise in Client-Server application development using Oracle 11g/10g/9i/8i, PL/SQL, SQL *PLUS, TOAD and SQL*LOADER.

Solid experience in writing complex SQL queries and PL/SQL procedures to extract data from various source tables.

Proficient in loading data from flat files into database tables using SQL*Loader scripts.

Worked with Arrays, Records, Dynamic SQL and Exception Handling.

Involved in Performance Tuning which included creating indexes, partitioning tables, providing Hints, modifying tables using Explain Plan, SQL trace and TKPROF.

Worked with tools like PL/SQL Developer, SQL Developer, SQL*Loader, TOAD, SQL plus.

Automating data loading, extraction, reports generation using UNIX Shell scripting.

Experience in handling very large data files using Export-Import Utilities and SQL*Loader.

Efficient in creating Test cases and performed data validation and process testing for application moving into production.

Experience in UNIX Shell Scripts using Korn shell for executing PL/SQL code and performing other activities in UNIX.

Prepare/Maintain documentation on all aspects of ETL processes, definitions and mappings to support knowledge transfer to other team members.

Exceptional experience in dealing with various databases like Oracle, DB2, SQL Server, MS Access, and Flat Files.

Expertise in working with built-in packages like DBMS_LOB, DBMS_SQL, DBMS_SHEDULER, DBMS_DDL, UTL_FILE.

Knowledge of Principles of Data Warehouse using Fact Tables, Dimension Tables and Star/Snowflake schema modeling.

Highly organized and efficient to prioritize and manage multiple tasks.

Proven ability to work efficiently in both independent and team work environments.

Technical Skills:

Databases

Oracle 12c/11g/10g/9i,, SQL Server 2005/2007, MS Access, DB2

Languages

SQL, PL/SQL, Pro*C, C/C++, JAVA, .NET, XML, UNIX Shell Scripting, Perl Scripting.

Oracle Tools/ GUI

Oracle Forms and Reports 6i/9i/10g/11g, Discoverer 4i/9i/10g

Tools

TOAD, SQL DEVELOPER, PLSQL DEVELOPER, SQL*Loader, Oracle SQL*Plus, SQL Navigator, UNIX/LINUX Utilities.

Version Control and Ticketing

SVN, PVCS, HP Service Manager.

Web Technologies

HTML, Apache, Microsoft Internet Information Server (IIS), VBScript, Java Script, CSS, XML.

Operating Systems

Windows Family, MS-DOS, Unix, Solaris

Work Experience:

Baker Hughes, Houston, TX Aug 2019-Till Date Oracle Developer

Baker Hughes Company is an American international industrial service company and one of the world's largest oil field services companies. The company provides the oil and gas industry with products and services for oil drilling, formation evaluation, completion, production and reservoir consulting. It operates in over 120 countries, with research and manufacturing facilities in other countries

Roles & Responsibilities:

Collaborated with Business Analysts and Business Objects team to gather requirements from market makers i.e. vendor about adding a new intermediary layer between ROM application and Execution Station for the orders placed through vanguard and translate the requirement into technical specifications.

Created new stored procedures that are used by upstream application to send data to ROM database orders table and route them to different vendors by checking business rules through Routing Engine.

Designed and Developed UNIX Shell Scripts to receive data from Enterprise DB whether an account is self-managed or managed by personal Advisory services of vanguard and store the data into ROM database through batch processing and generating reports which will be useful for business and ITS.

Created Package and Tables that is called inside UNIX shell script for Inserting data into staging table and updating the main account table and also maintaining the history for account table.

Created, Scheduled & Monitored control-m job with dependency on mainframe job that will send file every 30 mins and UNIX job will read that file and updates the main account table.

Provided support to product owner ITS with Adhoc queries and creating reports for day to day orders that were executed per sec.

Created relevant staging and target tables to load the CSV files, identified the business validation rules and SQL loader script generator application using UNIX shell scripting and PL/SQL.

Worked on SQL* Loader to load data from flat files obtained from various files.

Created Portals for EMM on Inquisient to filter the data for users easily using HTML & JAVA SCRIPT.

Worked on Performance Tuning of the SQL queries, which takes long time to process the request using Explain Plans to reduce the response time.

Extensively used Joins and sub-Queries to simplify complex queries involving multiple tables.

Worked on Upgrading of oracle databases from 11g to 12C and implemented oracle 12c standby database.

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

Create Requirement Traceability matrix to ensure all requirements defined for a system are

tested and also monitor application performance through unit & functional testing.

Create change Record & coordinate with respective teams to deploy the code in production &

also post certify the changes after release.

Worked in Production Support Environment as well as QA/TEST environments for projects, work orders, maintenance requests, bug fixes, enhancements, data changes, etc.

Performed Unit Testing and Integration Testing of the Application. Involved in preparing documentation and user support documents.

Validated and loaded data into Oracle Database using DB links and external tables from CSV files.

Participating in Daily status meetings to update the status of work.

Fixing bugs, data quality monitoring and involving in production support by efficiently debugging the production issues.

Involved in the On-Call Support.

Environment: Oracle Database 12c/11g, Windows 8, UNIX, Putty, Control-M, SQL Developer, Toad, XML, SQL, PLSQL, Unix Scripting, HP Quality Center, HTML.

ETC, Richardson, TX Mar 2017-July 2019

PL/SQL Developer

ETC is a leading systems and services provider for the tolling and transportation industries. The company’s nearly two decades of delivering technically sophisticated solutions has supported man of the country’s largest toll authorities and helped transform the industry with first of its kind advancements. ETC’s solutions collect more than $1 billion in toll transactions every year. I was involved in HCTRA, which was mainly focused on building queries using operational tables, creating packages to pull up the data.

Roles & Responsibilities:

Involved in Design, Development and Testing of Conversions, Interfaces, Workflow and Reports.

Collaborated with Business Analysts and Business Objects team to understand the requirements and translate the requirement into technical specifications.

Coordinated with the front-end design team to provide them with the necessary stored

Procedures and packages and the necessary insight into the data.

Involved in writing SQL queries, PL/SQL programming and created new packages and procedures and modified and tuned existing procedure and queries using TOAD.

Strong knowledge of Extraction Transformation and Loading (ETL) processes using UNIX shell scripting, SQL, PL/SQL and SQL Loader.

Created PL/SQL Stored Procedures, Functions, Packages and Triggers, extensively used cursors, ref cursors, User defined object types, Records in PL/SQL Programming.

Worked on Tuning of the SQL queries, which takes long time to process the request using Explain Plans to reduce the response time.

Extensive querying using SQL*plus / TOAD to monitor quality and integrity of data.

Extensively worked in performance tuning of programs, ETL procedures and processes and used debugger to troubleshoot logical errors.

Proficient in advance features of Oracle 11g for PL/SQL programming like using cursor, variables, Reference cursors, Varray’s, nested tables, Dynamic SQL and Bulk Binds.

Built and maintained SQL Scripts, Indexes, reports and queries for data analysis and extraction.

Participated in Daily status meetings to update the status of work.

Worked on Scheduler to schedule Jobs/Packages for running.

Performed Unit Testing and Integration Testing of the Application. Involved in preparing documentation and user support documents.

Proactive tuning of SQL/PLSQL issues.

Involved in Code Reviews and test Reviews and participated in Quality Audits.

Developed complex SQL queries to perform the back end testing of the Oracle database using SQL and UNIX shell commands.

Worked on job scheduling using DBMS_SCHEDULER.

Provided support to the User/Customer incase if they have any questions on running the Reports.

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

Worked extensively on different types of transformations like expression, union, filter, aggregator, update strategy, lookup, stored procedure, sequence generator, Normalizer and joiner.

Involved in 24/7 production support as per the need basis.

Environment: Oracle Database 10g/11g, Windows 8, PL/SQL Developer, Toad, XML, SQL, PLSQL, UNIX Shell Scripting.

CVS Caremark, Monroeville, PA May 2015 – Feb 2017

Oracle Developer

CVS Caremark is an American retailer and health care company and offers pharmacy benefit management and prescription mail order services. They employ a combination of clinical interventions, discounted drug purchase arrangements and formulary management strategies to help manage drug costs for members and clients. This project mainly focused on Forms and Reports development and changing existing Forms, Reports, Auto enrollment process and production support.

Roles & Responsibilities:

Analyze the Business Requirements (BRD) and convert them into Technical Specification (Technical Design Document).

Worked with Business Analysts, Business users, IT leads and system Analysts to understand the requirements and translate the requirement into technical specifications.

Involved in all phases of Design, code, test, and debug programs of varying levels of complexity.

Prepared technical documentation, create test plans and perform testing.

Created PL/SQL Stored Procedures, Functions, Packages and Triggers, extensively

Used cursors, ref cursors, User defined object types, Records in PL/SQL Programming.

Expertise in developing Forms and Reports and developed PL/SQL Packages, Stored procedures, Triggers, Tables, joins, Indexes and sequences.

Involved in writing SQL queries, PL/SQL programming and created new Packages, Procedures and modified existing procedure and queries using TOAD.

Involved in the generation of User Interface using oracle forms by extensively creating forms as per the client requirements.

Developed and customized existing reports and forms as per client specific requirements using Oracle Reports and Forms Builder 11g.

Involved in Updating PL/SQL Functions, Procedures, and Packages, Cursors, for validation and loading of data based on current requirement.

Involved in Unit testing, integration testing and supporting testing during QA and UAT phase.

Customized Forms and Reports by changing size of the fields adding new fields into the display, changing the layout of the Report and forms appropriate.

Developed and customized existing reports as per client specific requirements using Oracle Reports Builder 11g.

Developed and designed user-friendly UI interfaces according to the client requirements using JavaScript, JSP, PL/SQL packages, and PL/SQL tables.

Involved in connecting JSP and Mod PL/SQL frontend forms to access the Oracle 11g database.

Created new reports for generating automatic weekly/Monthly Reports as per user requirement in production Support.

Fixing bugs, Client Feeds setup and maintenance, Data loads and Data migration support.

Involved in Unit testing, code reviewing and preparing design specification document.

Analyzing the issues, performing extensive defect fixing in Production support through HP Service Manager.

Involved in database development by creating PL/SQL Functions, Procedures, and Packages, Cursors, Error handling and views.

Debugging and Fixing Production Data.

Involved in production release and support of PL/SQL, Oracle Forms and Reports.

Environment: Oracle Database 11g/12c, Windows 8, UNIX, SQL Developer, Toad, XML, SQL, PLSQL, Unix Shell Scripting, Forms Builder 11g, Reports builder.

PAXAR, Bangalore Jan 2013 – Apr 2014

PL/SQL Developer

IMS is one of the largest supply chain management and promotional product suppliers which provides fortune 100 companies with end to end merchandising solutions, they need to promote their brands and drive sales. This project mainly focused on production support, reports development and custom application extension development.

Roles & Responsibilities:

Involved in all phases of software development including gathering requirements, creating specifications, development of database objects, developing code and validating programs.

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

Wrote generic PL/SQL code modules (PL/SQL Libraries) for Reports to handle data manipulations on client.

Developed back end interfaces using PL/SQL Stored Packages, Procedures,

Functions, Collections and Triggers.

Designed and implemented client-server application using Oracle Forms Builder.

Involved in the generation of User Interface using oracle forms by extensively creating forms as per the client requirements.

Proactively tuned SQL queries leading to significant improvement in system response time and efficiency.

Developed UNIX scripts for transmitting files from the secure server to the customer specified server, using various FTP batch processes.

Performed various activities like creating, debugging and modifying data base objects and User defined functions and finely tuned them for performance.

Developed complex SQL queries to perform the back-end testing of the Oracle database using SQL and UNIX shell commands.

Created and monitored the Oracle DBMS JOBS as a part of weekly tasks.

Involved in fixing bugs within Packages and Stored Procedures.

Data migration between different Unix/Linux environments using Export/import utility.

Involved in Tuning Database & Application performance using Explain Plan.

Involved in the Daily maintenance of the database that involved monitoring the daily run of the scripts as well as troubleshooting in the event of any errors in the entire process.

Performed Unit Testing and Integration Testing of the Application. Involved in preparing documentation and user support documents.

Involved in 24/7 production support as per the need basis.

Environment: Oracle Database 10g, Windows 7, UNIX, SQL Developer, XML, SQL, PLSQL, UNIX Scripting, Perforce, Putty.

Education Details:

Masters in Computer Applications from Madras University, India.

Bachelor’s in Computer Science, Mathematics, and Statistics from Acharya Nagarjuna University.

Contact this candidate