SUMMARY

• 10 years of IT experience in teh field of Development, Documentation, and Implementation of Software Applications in Oracle (Oracle PL/SQL Developer), Python.
• 3 Years of Experience on Hadoop Eco System (MapReduce Programming model), Developed multiple MapReduce jobs in Python for distributed data preprocessing.
• Hands - on experience with AWS native services including EBS, S3 Storage services, Cloud Formation, RDS, ECS. Involved in architectural discussions and design exercises to create best solutions built on AWS while ensuring solutions are designed for successful deployment in cloud.
• Hands-on experience with DevOps Tools such as Git, Confluence, Jira, Bitbucket, Jenkins, Code Pipeline, Ansible etc.
• Capable of moving data from RDBMS to HDFS and vice-versa using SQOOP, Analyzing/Transforming with Hive and Pig.
• Strong Knowledge of Developing, Implementing and Maintaining Application Systems using SQL, PL/SQL, Oracle Forms on Oracle 11g Database.
• Solid experience of creating PL/SQL packages, Procedures, Functions, Triggers and Views to Retrieve, Manipulate and Migrating Complex Data sets in Oracle Databases. Extensive working noledge in developing Database Triggers, Stored Procedures, Functions for developing Forms and Reports.
• Experienced in Oracle data warehousing features such as Materialized Views, Bitmap Indexes, Index Organized Tables, External tables etc.
• Created numerous complex queries involving joins, correlated sub-queries diverse business requirements.
• Worked on advanced PL/SQL constructs like Oracle-supplied packages, nested tables, varrays, records, types, dynamic SQL and analytical functions.
• Experienced in writing SQL queries, Test specifications and plans.
• Involved in continuous enhancements and fixing of Production problems.
• Experienced in Conducting Requirement, Code and Test Reviews.
• Experienced to translate reporting and analytical needs into technical solutions.

PROFESSIONAL EXPERIENCE

Confidential, Phoenix, Arizona

SQL & PL/SQL Developer, AWS, DevOps

Responsibilities:

• Regular interactions with teh users for gathering new requirements and finding opportunities for improvements.
• Designing & Development of new Forms as per teh requirements.
• Creating PL/SQL objects like procedures, Packages, triggers wherever required.
• Created scripts to create new tables, views, queries for new enhancement in teh application using TOAD. Created indexes on teh tables for faster retrievals of data to enhance database performance.
• Rectified teh poorly written SQL & PL/SQL statements and resolved teh performance Issues.
• Created aggregation queries for reporting and analysis.
• Involved in continuous enhancements and fixing of production issues. Generated server-side PL/SQL scripts for data manipulation and validations.
• Involved in preparing documents for program change specification and program specification for teh various changes dat need to be done in teh existing project.
• Used Bulk Collections for better performance and easy retrieval of data, by reducing context switching between SQL and PL/SQL engines.
• Created PL/SQL scripts to extract teh data from teh operational database into simple flat text files using UTL FILE package.
• Created Jenkins CICD pipelines for continuous build & deployment.
• Implemented AWS solutions using EC2, S3, EBS, ELB, Route53 & Auto scaling groups.
• Built servers using AWS, importing volumes, launching EC2, creating Security groups, Autoscaling, Load balancers (ELBs) using Cloud formation templates & AMI's using Infrastructure as a Service (IaaS).
• Also involved in Unit Testing, System testing, Regression testing.
• Gave Knowledge share to teh team members.

Environment: Oracle 11g/12c, SQL and PL/SQL, SQL Loader, Toad, Python, AWS

Confidential, Dallas, Texas

SQL & PL/SQL Developer

Responsibilities:

• Involving in teh full development cycle of Planning, analysis, design, development, testing, and implementation.
• Developed and modified triggers, packages, functions and stored procedures for data conversions and PL/SQL procedures to create database objects dynamically based on user inputs.
• Rectified teh poorly written SQL & PL/SQL statements and resolved teh performance Issues.
• Created aggregation queries for reporting and analysis.
• Involved in continuous enhancements and fixing of production issues. Generated server-side PL/SQL scripts for data manipulation and validations.
• Involved in preparing documents for program change specification and program specification for teh various changes dat need to be done in teh existing project.
• Involved in Coordinating with teh front-end design team to provide them with teh necessary stored procedures and packages and teh necessary insight into teh data.
• Involved in writing automated scripts, Stored procedures to improve teh performance of Internal tools and thus reduce teh overall cycle time.
• Involved in updating procedures, functions, triggers, and packages based on teh change request.
• Involved in writing queries and fixing code by working in a busy production environment.
• Involved in developing Oracle based Front end application using Form builder and also worked on enhancement of teh tool.
• Involved on Discussions with Lead’s and Stake Holders to make Business Decisions.

Environment: Oracle 10g/11g/12c, SQL and PL/SQL, SQL Loader, Toad.

Confidential

SQL & PL/SQL Developer

Responsibilities:

• Participated in database design within an existing Oracle database structure.
• Helping application development team in preparing technical designs and perform construction activities.
• Writing complex functions and procedures for new packages and update existing packages in an established Oracle database using pre-defined business rules.
• Working with database administrators to implement design changes and new packages.
• Performance testing and rewriting of production Code/SQL statements & procedures performing badly, identified by database administrators.
• Rectified teh poorly written SQL & PL/SQL statements and resolved teh performance Issues.
• Created aggregation queries for reporting and analysis.
• Involved in continuous enhancements and fixing of production issues. Generated server-side PL/SQL scripts for data manipulation and validations.
• Involved in preparing documents for program change specification and program specification for teh various changes dat need to be done in teh existing project.
• Analyzing requirements and creating Software Requirement Documents.
• Involved in writing Code for Test Drivers (Test Procedures and Test Packages) Required to Execute teh Test Data.
• Involved on Discussions with Lead’s and Stake Holders in order to get requirement Clarifications.
• Knowledge sharing to team members.

Environment: Oracle 9i/10g/11g, SQL and PL/SQL, SQL Loader, Toad.

Confidential

SQL & PL/SQL Developer

Responsibilities:

• Used Sqoop to transfer data betweenContracts data resides RDBMS to HDFS.
• MapReduce Programs was designed to perform various statistics on Contracts Data.
• Data was loaded into Hive tables for further Analysis.
• Coordinated with teh front-end design team to provide them with teh necessary stored procedures and packages and teh necessary insight into teh data.
• Rectified teh poorly written SQL & PL/SQL statements and resolved teh performance Issues.
• Created aggregation queries for reporting and analysis.
• Involved in continuous enhancements and fixing of production issues. Generated server-side PL/SQL scripts for data manipulation and validations.
• Involved in preparing documents for program change specification and program specification for teh various changes dat need to be done in teh existing project.
• 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 teh changing needs of teh project and client requirements.
• Involved in teh continuous enhancements and fixing of production problems.
• Generated server-side PL/SQL scripts for data manipulation and validation and materialized views for remote instances.
• Developed PL/SQL triggers and master tables for automatic creation of primary keys.
• Created PL/SQL stored procedures, functions,and packages as part of project requirements.

Environment: Oracle 9i/10g, SQL and PL/SQL, SQL Loader, Toad.