SUMMARY

• A responsible and committed engineer with experience designing, implementing, and adapting to technically sophisticated applications with Experience in all aspects of development from initial implementation & requirement discovery, through release, enhancement, and support SDLC & Agile techniques. Proficient in AWS cloud, Oracle SQL, PL/SQL programming, ETL (Extract, Transform & Load) techniques for Data Processing & Analysis, Data modeling and Data visualization technologies.
• Experience in analysis, design, development, implementation and testing of Oracle applications in data warehousing and client/server environment. Knowledge in AWS related to data migration to AWS cloud.
• Experience in Oracle SQL & PL/SQL including all database objects: Stored procedures, Stored functions, Packages, TYPE Objects, Triggers, cursors, REF cursors, Parameterized cursors, Views, Materialized Views and PL/SQL Collections.
• Strong experience in Data warehouse concepts, ETL.
• Experience with Oracle SQL & PL/SQL programming and used Database utility programs like TOAD & SQL Navigator. Familiar with SQL Loader to load data from external source like flat files into database tables.
• Proficiency on using various Oracle utility tools SQL Plus, TOAD, PL/SQL Developer, SQL Navigator, SQL*Loader. Strong knowledge in Oracle cursor management, collections, and exceptional handling.
• Hands - on experience in creating triggers to enforce data integrity and audit purpose. Expertise in query performance tuning by using Explain plan, SQL trace and TKPROF utilities and Hints provided by Oracle.
• Experience in Data migration techniques using External tables, import/export, SQL*loader, bulk & batch processing. Good understanding of Oracle data dictionary and normalization techniques. Experience in Oracle 11g/10g/9i/8i systems. Created new databases and users: set up backups, export, and other monitoring scripts. Highly knowledgeable in SDLC methodologies (Waterfall & Agile).
• Experience of snowflake (cloud-based data-warehousing) and Data migration from existing Data Lakes to Snowflake. Experienced in working on RDBMS, OLAP, and OLTP concepts.
• Research-oriented, proactive, self-starter with strong technical, analytical, and interpersonal skills.

TECHNICAL SKILLS

Backend Oracle: 11g/10g/9i Database Enterprise Edition

Frontend Oracle: Developer Suite 10g/9i/2000, SQL * Loader, SQL * Plus, OFSAA - Oracle Financial Services Analytical Applications.

Database Tools: Oracle Reports 10g/6i, Oracle Forms 11g/10g/6i.

Database Utilities: SQL*LOADER, UTL FILE, DBMS Packages, TKPROF, etc.

Programming: ORACLE PL/SQL 10g/9i/8.0, UNIX K-Shell Scripting, C, JAVA, JDBC, Java Script, Visual Basic

RDBMS: Oracle 9i/10g/11g, MS Access 2000/2002, MS-SQL Server 2005/2000/7.0/6.5

Databases: Oracle Exadata, 10g, MySQL, SQL, PL/SQL

Operating Systems: UNIX (Linux, HP-UX, Sun OS5.7, Solaris, RHEL, Centos, Ubuntu), Windows

AWS Tech: S3, EC2, EMR, SNS, SQS, IAM, KMS, RedShift, CloudFormation, CloudWatch, Lambda, VPC, Route53, RDS, DynamoDB, Kinesis, Snowflake

DevOps Tools: Jenkins, GitHub, Nexus, JIRA, Zabbix

Third Party Tools: SQL Navigator, TOAD 8.6/7.5/7.0, GitLab, GitHub -source code management.

Project Methodologies: Agile/Scrum, Waterfall

PROFESSIONAL EXPERIENCE

Confidential - Cary, NC

Systems Engineer - PL/SQL Developer

Responsibilities:

• Involved in the end to end development of the application for the CPE maintenance of Confidential care which provides the services on the devices from cisco and non-cisco vendors.
• Coordinated with external teams and business teams to gather the initial requirements for overall project to finalize the design and dependencies.
• Coordinated with the front-end design team to provide them with the necessary stored procedures, Triggers, Functions and packages and the necessary insight into the data.
• Involved in data loading using PL/SQL and SQL*Loader calling UNIX scripts to download and manipulate files.
• Worked on SQL*Loader to load data from flat files obtained from various facilities every day.
• Created and modified several UNIX Shell Scripts according to the changing needs of the project and client requirements.
• Developed PL/SQL triggers and master tables for automatic creation of primary keys. Created PL/SQL objects for moving data from staging area to the data warehouse.
• Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application
• Liable for maintaining quality reference data in Oracle by performing activities like cleaning, transformation and ensuring Integrity in a relational environment.
• Experience in Database Application Development, Query Optimization, Performance Tuning and DBA solutions and implementation experience in complete System Development Life Cycle.
• Initiated a lot of fine-tuning mechanisms to tune the database as well as the queries to complete a set of given jobs or tasks in optimal time.
• Collaborated with product management to design, build and test systems.
• Worked with developers and performance engineers to enhance supportability and identify performance bottlenecks.

Confidential - McLean, VA

PL/SQL Developer

Responsibilities:

• Involved in full life cycle of the project from Design, Analysis, logical and physical architecture modeling, development, Implementation, testing. Supported the Daily LCR, IRR, NSFR and FTP use cases.
• Analyze business requirements & design, map, and load data from various sources like flat files, XML files to Target database. Worked with Business partners to gather requirements & come up with modern data pipeline designs. Working on various DDL, DML, and DCL (TCL, ACL) statements to extract BLOB & CLOB data from Oracle RDBMS database.
• Involved in planning AWS architecture for moving existing infrastructure and process on to cloud platform.
• Modified existing stored procedures, functions, cursors and triggers using TOAD for maintaining complex integrity constraints and implementing the complex business rules.
• Developing Oracle objects (Packages, Procedures and Functions) & integrate them with OFSAA front end using OFSAA user interface/OFSAA application suite. Develop, document & unit test PL/SQL procedures required to support web-based application, external interfaces, data migration and scheduled back-end processes.
• Extensively developed PL/SQL Packages, Stored procedures, Triggers & finely tuned them for performance.
• Used PLSQL tables and Bulk loader programs for processing data and loading into Oracle tables.
• Proactively tuned SQL queries leading to significant improvement in system response time and efficiency.
• Applied Ad-Hoc SQL queries for Data Analysis and Testing.
• Involved in Data Extraction, Transformation and Loading (ETL process) from source to target and worked on Windows Batch scripting, scheduling jobs and monitoring logs. Involved in troubleshooting, debugging, problem solving and tuning for improving performance of the backend application programs.
• Responsible for translating the business requirements into technical specifications by creation Jira stories.
• Involved in business analysis and technical design sessions with business and technical staff to develop requirements document and ETL design specifications. Involved in Sprint/PI planning with business users for designing and planning a data ingestion strategy. Anchored production deployment activities adhering to the Change Management process. Involved with Data life cycle management design process.

Confidential - Pittsburgh, PA

Oracle Developer

Responsibilities:

• Involved in SDLC gathering requirements from end users. Developed views to facilitate easy interface implementation & enforce security on critical customer information. Developed stored procedures & triggers to facilitate consistent data entry into database. Written Stored Procedures using PL/SQL & functions & procedure for common utilities. Participated in system analysis & data modeling, which included creating tables, views, indexes, synonyms, triggers, functions, procedures, cursors, and packages.
• Experience in application development using various features of Oracle like Bulk Collections, Table
• Developedoracledatabase procedures, functions, packages, and triggers.
• Developed PLSQL code extensively using Cursors, Ref Cursors,OracleCollections, PLSQL Record Object Types, Associative Arrays, Variable Arrays, Nested Tables, passing the table types as parameters, reading, modifying these table types, Exception Handling techniques
• Extensively used various IDE's SQLdeveloper, SQL PLUS tools/utilities for compiling/debugging the code.
• Functions, Autonomous Transactions, Dynamic SQL, Object types, Records and External tables.
• Using Forms, developed customized bug systems, and New hire process.
• Involved in performance tuning of targets, sources, mappings, and sessions.
• Assisting QA Teams for bug testing, User Acceptance Testing (UAT) & System Integration Testing.

Confidential, Irving, TX

Oracle Developer

Responsibilities:

• Created stored procedures, functions, packages, collections, triggers, object types to implement complex business functionality. Data optimization, scrubbing and manipulation of staged data using PL/SQL packages. Use of PL/SQL bulk collection and DML (insert/update/delete) methods.
• Worked extensively in database development like developing Triggers, Functions, reports, and forms.
• Oracle Applications modules HRMS Oracle, PL/SQL, SQL*Plus, Forms, Reports Skills.
• Encapsulated error handling and use of autonomous transaction for logging. Used UTL FILE for exporting data and UTL MAIL to generate E- mails. Used PL/SQL for high performance of stored procedures.
• Assisted with testing existing code and making necessary enhancements for Oracle 11G upgrade. Created database objects such as tables, indexes, views, triggers, sequences, synonyms.
• Worked on writing complex SQL queries (cursors, ref cursors, sub queries, correlated sub queries). Provided support for multiple business groups and managed SDLC for multiple projects to satisfy business needs.

Confidential, San Diego, CA

Systems Analyst

Responsibilities:

• Developed user defined functions based on requirements. Developed backend interfaces using PL/SQL Stored Packages, Procedures, Functions, Collections & Triggers. Created PL/SQL procedures & packages.
• Customized Reports and Forms to meet user’s requirements. Query optimization and performance tuning.
• Created integrity constraints & Database Triggers for data validations. Used PL/SQL Tables and Records in payment generation process. Written Test Plans and Involved in unit testing
• Created relevant staging tables to load CSV files, identified business validation rules. Created SQL Loader script generator application using UNIX shell scripting & PL/SQL. Experience in creating tables & sequences for the experimental data load capture. Loaded the data into the tables using TOAD and SQL*plus.
• Created metadata validation lookup tables and pre-populated them using SQL Loader generator application.
• Worked in database development like developing procedures, packages, triggers, functions, Discoverer, XML Publisher, reports and forms. Designed competent pl/sql programs using pl/sql collections, Records types, and Object types. Good knowledge on joins, which are inner join, left outer join & Hash join, Semi join

Confidential

Programmer

Responsibilities:

• Analyzed business requirements for enhancements needed in contract Administration application & related policy modules. Documented detailed requirements & prepared DLD for new enhancements. Performed several DDL, DML & TCL operations. Created huge database packages with related functions & procedures.
• PL/SQL programming including Development of new backend packages, procedures & functions to in corporate advanced modules. Worked on BULK COLLECT for bulk loading data into various transaction tables. Used UTL FILE to load the data into oracle tables from FLAT, CSV and Text files.
• Added database triggers to some history tables of the database. Refresh development and test databases using export/import utilities. Provided 24*7 on call support to production environment.
• Implemented various automated UNIX shell scripts to invoke pl/sql anonymous blocks, Stored PROEDURES/ FUNCTIONS/PACKAGES using SQL PLUS session in silent mode.
• Worked on inline and correlated sub queries based on business context. Implemented various customized Oracle reports using different techniques in Oracle sql/pl-sql. In-depth analysis of problem tickets to dig out root cause for the problems. Involved in Impact analysis of the defects to the associated functionalities and modules in the Production environment