SUMMARY

• Overall 8 years of experience in analysis, design, development, testing and implementation of application software as Oracle PL/SQL developer.
• Expertise in Client - Server application development using Oracle, PL/SQL, SQL *PLUS.
• Effectively made use of Table Functions, Indexes, Table Partitioning, Collections, Analytical functions, Materialized Views, Query Re-Write and Transportable table spaces.
• Good knowledge on logical and physical Data Modeling using normalizing Techniques.
• Created Tables, Views, Constraints, Index (B Tree, Bitmap and Function Based).
• Developed Complex database objects like Stored Procedures, Functions, Packages and Triggers using SQL and PL/SQL.
• Excellent technical and analytical skills with clear understanding of design goals of ER modeling for OLTP and dimension modeling for OLAP.
• Experienced in XML and JSON parsing, multithreading using both 1st party and 3rd party frameworks including NSXMLParser, NSJSONSerialization, TouchXML, SBJSON and PLIST.
• Experience in Oracle supplied packages, Dynamic SQL, Records and PL/SQL Tables.
• Loaded Data into Oracle Tables using SQL Loader.
• Experience with Oracle Supply Packages such as DBMS SQL, DBMS JOB and UTL FILE.
• Created Packages and Procedures to automatically drop table indexes and create indexes for the tables.
• Worked extensively on Ref Cursor, External Tables and Collections.
• Extensively used SQL* Loader, SQL+ shell scripts in various Windows and Unix-like operating systems to load data.
• Experienced with Database Query Log (DBQL) Query Performance Tuning, Teradata Active System Management (TASM)
• Experience in SQL performance tuning using Cost-Based Optimization (CBO).
• Good knowledge of key Oracle performance related features such as Query Optimizer, Execution Plans and Indexes.
• Experience in using Windows Communication Foundation (WCF) in a self-hosting mechanism, implementing the Service-Oriented Architecture (SOA) using the REST methodology, to SOAP messages between metadata endpoints.
• Worked extensively with Ado.net objects, LINQ, Entity Framework, to interact with databases like SQL Server, Oracle.
• Built reusable Unix programs like Email Notification Unix Shell Script which was proven useful in many automations.
• Expert in creating various PL/SQL stored procedures, views, functions and temporary tables for data input to the Crystal Reports.
• Documentation and maintenance of applications in Oracle databases.
• Strong experience in SQL, PL/SQL, stored procedures, functions, triggers and packages within Oracle databases.
• Extensive knowledge and experience in EAI in IBM Integration Bus (IIB), IBM WebSphere Message Broker V8.0/V7.0.
• Served as a subject matter expert for the ETL development/implementation team for the Oracle Data Integrator (ODI).
• Experience in creating Materialized Views in data warehousing environment.
• Expertise in using software Oracle Developer (Forms/Reports), and "TOAD for Oracle" in analysis, design, and implementation of business applications using Oracle RDBMS.
• Unix Shell Scripting for SCP, processing flat files and archiving of flat files.
• Experience with Performance Tuning for Oracle RDBMS using Explain Plan and HINTS.
• Created Shell Scripts for invoking SQL scripts and scheduled them using crontab.
• Experience in working with RDBMS including Oracle, SQL Server and MS Access
• Expert in creating various PL/SQL stored procedures, views, functions and temporary tables for data input to the Crystal Reports.
• Strong proficiency with jQuery, jQuery plugins (Validator, Drag and Drop, AutoComplete), AJAX, Dynamic HTML (DHTML), JSON and XML.
• Good knowledge in Data Modeling (Physical & logical data modeling) using data Modelers. Major responsibilities include getting requirements from the user, developing Crystal Reports maintaining proper documentation of the reports for future reference
• Excellent communication, interpersonal, analytical skills and strong ability to perform as part of a team.

TECHNICAL SKILLS

Databases: Oracle, MS SQL Server

Scripting: UNIX, SQL, PL/SQLOS Citrix XenServer, Windows, Windows 98/XP/professional, Ubuntu, centos, red hat Linux enterprise.

Query Tools: TOAD, SQL Developer, SQL Navigator, SQL* Plus, PL/SQL Developer, Data modelling

Other Tools: SQL*Loader, MS Office (Word, PowerPoint, Excel, Visio);

Languages: Transact-SQL, XML, FetchXML, C, C++

PROFESSIONAL EXPERIENCE

Confidential, Colorado Springs, CO

Oracle PL/SQL Developer

Responsibilities:

• Coordinating with front-end developers for implementing business logic in stored procedures, Triggers and functions using T-SQL.
• Analyze architecture, including relationship between database tables and relationships of business data stored.
• Analyze data, automate monitoring of very large datasets to identify data anomalies early to minimize impact to customer facing data, and write code to reconcile.
• Recommend target database solution based on business and/or technical requirements such as RDBMS vs. No SQL database.
• Created and modified complex functions, stored procedures, packages and Triggers by using Oracle PL/SQL based on the business rules.
• Modified Procedures and Functions to suite the improved business requirements.
• Extensively worked on Schema Migration, Database Program Migration, Data Migration from Db2 Server to Oracle by using Oracle SQL Developer.
• Building logical and physical Data Models using normalizing Techniques
• Working with Shell and Perl Scripts for Database migration from Db2 to Oracle.
• Execute database statements from Java code, including SQL statements, prepared statements, and stored procedures.
• High-performing database designs/code to retrieve large datasets and optimize system resources.
• Tune poor performing SQL to run at optimized levels; exercise intermediate to advance practices to identify poorly performing code and identify areas to improve it.
• Developed REST APIs using Web API (REST API)
• Designed and implemented Web API (REST API) to support mobile applications
• Used Postman to test the RESTful API for HTTP requests such as GET, POST, and PUT.
• Worked on SQL Tuning by using various tools like EXPLAIN PLAN, DBMS PROFILER, Hints etc.
• Worked on Dynamic SQL by using Execute Immediate and DBMS SQL along with Bulk Collect.
• Created SQL Scripts, Functions, Procedures and Packages for customer interface.
• Tested Oracle PL/SQL and Stored Procedures.
• Wrote complex PL/SQL packages for Customer Interfaces, Payment Interfaces and Broker Commissions for Oracle Applications.
• Designed and built PLSQL & Unix programs to accomplish functional requirements.
• Created SQL Server query to generate XML files.
• Customized RESTful web service using Spring RESTful API, sending JSON format data packets between frond-end and middle tier controller.
• Proficient using UNIX command and Shell Scripting.
• Designed Oracle 11g database to keep records of customers and their orders.
• Involved in various phases of Software Development Life Cycle (SDLC).
• Encrypt data to restrict visibility of sensitive information and was solely responsible for fixing all the security vulnerabilities in the application using HPE Fortify Audit Workbench.
• Created and maintained repository in GIT and POC for any production deployment and monitoring.
• Configured Maven dependencies for application building process that created POM.xml files.
• Used MAVEN to define the dependencies / plugins and build the application.
• Deployed applications on IBM WebSphere Application Server Network Deployment in QA, Staging and Production environments daily and troubleshot various configuration and application issues.
• Used JMS API for asynchronous communication by putting the messages in the Message queue, such as PDF, Excel report generation.
• Worked on administrative tasks on IBM WebSphere Application Server like creating queue managers, defining queues, channels, listeners and adding queue managers to clusters.
• Manage database updates across lower environments.
• Created integrations with end systems using Snap logic API builder tool and step up ultra-pipelines and resumable pipelines for ETL process.

Environment: PLSQL Developer, Oracle Database12C, XML, SQL*Developer, UNIX Shell Scripts, SnapLogic, Python.

Confidential

Oracle PL/SQL Developer

Responsibilities:

• Analyzed all business functionality related to back end database interfaces.
• Collected, cleansed, and provided modeling and analyses of structured and unstructured data used for major business initiatives.
• Implemented PL/SQL scripts in accordance with the necessary business rules and requirements.
• Wrote Event Triggers, PL/SQL Program Units for Reports for Client Validations.
• Formatting, Testing, and rerunning the existing reports.
• Developed various Oracle sub functions like Stored Procedures, Functions, and Packages using PL/SQL as per the design documents.
• Wrote complex SQL queries to retrieve information from the databases depending on the requirement.
• Generated sequences that can be shared by multiple users to generate unique integers.
• Conducting full lifecycle analysis to include requirements, activities and design the Datawarehouse.
• Developed user documentation for all the application modules, error tables and error handling methods and techniques.
• Managing and designing the reporting environment, including data sources, security, metadata and Supporting the data warehouse in identifying and revising reporting requirements.
• Responsible for monitoring the performance and stability of the software during performance test prior to going- live and after going-live continued to monitor as part of the post-production support.
• Created SSIS packages to extract data from flat files, Teradata, Oracle, DB2 and transform the data according tothe business requirements and load the data in SQL server tables.
• Used ETL (SSIS) to develop jobs for extracting, cleaning, transforming and loading data from various sources tovarious destinations.
• Successfully implemented and executed database store procedures for Cleaning Base Objects, Stage Jobs, Load Jobs.
• Setup an automated batch process created an automated scheduler to merge the records to theappropriate staging tables and perform Data Quality and analysis.
• Deployed and tested Restful webservice to perform CRUD operations, Merge and Soft Delete Jobs on database.
• Created user documentation for all the application modules, error tables and error handling methods and techniques
• Created visually impactful dashboards in PowerPoint and Excel for data reporting by using pivot tables and VLOOKUP. Extracted, interpreted, and analyzed data to identify key metrics and transform raw data into meaningful, actionable information
• Responsible for monitoring the performance and stability of the software during performance test prior to going- live and after going-live continued to monitor as part of the post-production support.

Environment: Oracle 10g/11g, PL/SQL, SQL*Plus 10.1, UNIX, ASP.NET MVC, Power BI, Report Builder 1.0/2.0, OBIEE 10.1.3.x, SQL*Loader, Bootstrap, Toad 8.6 & 9.1, Windows, SAP Crystal reports

Confidential

Oracle/PL SQL Developer

Responsibilities:

• Worked on Triggers and Functions for many data retrieval operations
• Involved in Oracle User creation
• Involved in Doing Partitioning and Sub partitioning on table to improve performance.
• Writing Tuned SQL queries for data retrieval involving complex join conditions.
• Wrote stored procedures, functions, Packages, Triggers.
• Involved in writing cursors and handling exceptions.
• Used Import/Export utilities of Oracle.
• Designed and documented REST/HTTP APIs, including JSON data formats and API versioning strategy.
• Wrote complex SQL queries including inline queries and sub queries for faster data retrieval from multiple tables.
• Created and managed primary data base objects such as Tables, Views, Indexes Sequences and Synonyms.
• Designed reports with complex sub reports, Drill down, Cross Tabs, formulas, functions, parameters, scheduled reports, alerts, multiple grouping, running totals, Charts, graphs, mapping, multiple sections, mailing label.
• Good experience in report customization via the use of Grouping, Sorting, Field Highlighting, Conditional Formatting, Running Totals, Summaries, Static & Dynamic Parameters, Static & Dynamic Graphic Objects, Custom Formulas and Custom Functions (SQL Queries).
• Involved in debugging SQL procedures and Shell scripts.
• Developed presentation layer includes UI components, validations using HTML5, applying styles using CSS, used jQuery to make Ajax calls.
• Wrote backend scripts that performed maintenance tasks on the contract data using JDBC.
• Used Spring IOC for dynamic bean injection.
• Initiated the data migration project to migrate data from its legacy systems to oracle.
• Spring AOP to modularize cross-cutting concerns in aspects.

Environment: Oracle 9i/10g, Windows XP, PL/SQL, SQL*PLUS, SQL Developer, SAP Crystal reports, data modelling.

Confidential

Oracle Developer

Responsibilities:

• Involved in requirements gathering, designing, developing, testing and deploying backend procedures, function & packages in PL/SQL particularly for maintaining payments.
• Worked on optimizing existing procedures and functions.
• Used Oracle materialized views / snapshots, clusters and partitions for faster query performance.
• Improved query performance through usage of bit map and function based indexes, explain plan, analyze, hints and joins.
• Extensively used PL/SQL collections and records.
• Created synonyms to maintain the security to give access to specific users.
• Created curser designs and passed cursor variables as program parameters; created subtypes based on existing types of the application.
• Used nested tables, string indexed and nested collections, and wrote PL/SQL programs using collections and coded them; compared associative arrays to collections.
• Used sequences to automate number generation for employees.
• Used different exception handlers and created some user defined exception handlers.

Environment: Oracle 9i, SQL*Loader, SQL*Plus, Toad 8.6.1, PL/SQL, Oracle Forms/Reports 9i.