SUMMARY:

• 10+years of IT experience in the Analysis, Design, Development, Testing and Implementation of business application systems for Health care, Pharmaceutical, Financial, Insurance, Banking.
• 10+ years of Database experience using Oracle 11i/10g/9i/8i/7i, MS SQL Server 6.5/7.0.2000 , MS Access 7.0/2000, Oracle Report Writer, flat files, SQL, JCL, XML, XSL, PL/SQL, SQL*Plus, SQL*Loader and Developer 2000, Mainframe, Windows 3.x/95/98/2000, Win NT 4.0 and Unix. Proficient in working with PL/SQL to write stored procedures, packages, and triggers. Worked with testing team to create test cases for unit and integration testing. Expertise in Endevor, WinSQL, TOAD (Tool for Oracle Application Developers).
• Proficient in Analyzing Business processes requirements and translating them into technical requirements.
• Extensively worked on PL/SQL Object Types, Collections, Ref Cursors, Pipeline functions, Compound triggers, Materialized Views and Table Partitioning.
• Extensively worked with collections to reduce the overhead and improve the performance using bulk collect and bulk bind. Also handled exceptions in collections using Save Exception and %BULK EXCEPTIONS.
• Experienced with DBA activitieslike creating users, granting and revoking privileges on database objects.
• Worked with dynamic SQL queries by creating SQL queries at runtime using EXECUTE IMMEDIATE, DBMS SQL.
• Good Debugging skills and good at using Exceptions and Error Handling.
• Expertise in optimizing and tuning of SQL Queries and PL/SQL applications using utilities like Explain plan, TKPROF & hints, and scheduling the tasks using DBMS JOB/DBMS SCHEDULER.
• Extensively worked on Data Migration from Oracle to Postgres, Postgres to Netezza and vice versa.
• Experience in creating reports by extracting targeted data, transforming it to fit operational needs and loading it into the data warehouse. 
• Good understanding of Oracle Data Dictionary, RDBMS and Normalization Techniques.
• Excellent understanding of Client/Server architecture makes a valuable asset to any project, with Excellent Logical, Analytical, Communication and Organizational Skills.
• Experience in Creating, maintaining, and implementing oracle forms application enhancements and reports that interact with an Oracle database.
• Experience in Supporting, re - design and re-engineering of Oracle forms system interfaces, applications, stored procedures, database tables, system design proof of concept, and system implementation.
• Designed and developed various Oracle Forms and Reports for both Oracle Applications and Custom Development.
• Excellent team player and can work on both development and maintenance phases of the project.
• Efficient team player with excellent communication skills and good interaction with users.
• Well Versed with Agile methodology and worked as Scrum Master.

TECHNICAL SKILLS:

Databases: Oracle 11g/10g/9i/8i/7i, PostgreSQL9.0, MS SQL Server 2008, MYSQL 5.6,Netezza, MS Access 7.0/2000.

DB Dev. Tools: TOAD, SQL Developer, PL/SQL Developer, PGAdminIII, SQL*Plus, Aqua Data Studio, Razor SQL, SQL*Loader, SQL Server Management Studio, Aginity Workbench.

Business Intelligence Tools/Utilities: Eclipse, CVS, MS Access Reports, SQL, PL/SQL, SQL Server 2008/2005, SQL*Loader, TOAD 7.x/8.x/9.x, Enterprise DB Migration Studio, JIRA, Win SQL, SQL Navigator, Winscp, MS Project 2000, Microsoft Visual Source Safe (VSS), Concurrent Version System (CVS), Perforce, ERP, Win runner, Load Runner, Test Director.

Operating Systems: UNIX, LINUX, Windows XP/2000/98/95, MS DOS, MAC.

Languages/Web: C, SQL, PL/SQL, SQL*Plus, HTML, Shell Scripting and MS-Excel, XML, XSLT, HTML, Unix Shell Scripting.

Reporting Tools: Oracle Forms and Reports 10g/9i/6i, Crystal reports 9/10.

Data Warehousing: OLAP, OLTP, MOLAP, ROLAP, ETLInformatica, ETI, Data marts, Star Schema, Snowflake Schema, Data mining, Data Cleansing, Data Profiling.

XML Technologies: XML, HTML.

PROFESSIONAL EXPERIENCE:

Confidential, Miami, FL

Sr. Oracle PL SQL Developer

Responsibilities:

• Worked as a Database Developer and involved in supporting the Assurtrack Speciality Property application.
• Automated the process of sending emails in excel format creating Oracle packages and scheduled them in Endevora source code management and release management   tool   for mainframe computers  using JCL .
• Understand the Business requirements, create the technical design document and convert them into technical specifications.
• Developing and enhancing PL/SQL Stored Procedure, Packages, Triggers and Views as per the work requests and coordinate accordingly with the Business.
• Involved in performance tuning - analyzing query plans, query tuning, partitioning and optimizer hints.
• Worked with Analytic functions to compute an aggregate value based on a group of rows, aggregate functions and other different built Oracle Functions.
• Experienced with DBA activities like creating users, grant and revoke privileges on database projects as per the user’s request.
• Writing and reading PL/SQL Packages to reduce context switching.
• Ability to write complex queries including inline sub queries and correlated sub queries and against very large data sets as per the business requirements.
• Wrote SQL, PL/SQL, SQL*Plus programs required to retrieve data using cursors and exception handling.
• Creating indexes on tables to improve the performance by eliminating the full table scans and views for hiding the actual tables and to eliminate the complexity of the large queries.
• Worked on partitioning large Tables using Range Partitioning, creating Index Organized Table, Rollback Tablespace.
• Fine-tuned procedures/SQL queries for maximum efficiency in various databases using Oracle Hints, for Rule based optimization.
• Create and debug SQL procedures by effective exception handling by creating user defined errors using pragma exception init and raise application error for the ease of debugging and displaying the error messages and scripts used as part of production cycle run.
• Experience with building BI models for standard andadhoc reporting, analysis and risk dashboards.
• Extensive experience in creating reports by extracting targeted data, transforming it to fit operational needs and loading it into the data warehouse. 
• Create, modify or design programreports using SQL scripts by understanding the business requirements.

Environment: Oracle 11g, SQL*Plus, SQL*Loader,JCL, Mainframe, Endevor, Web services, Oracle Forms 11g, Cobol.

Confidential, Jacksonville, FL

Sr. Oracle PLSQL Developer

Responsibilities:

• Worked as a Database Developer and involved in Developing JWDS Dashboard (UI) and Web Page application by collaborating with front end Java Developers.
• Development and optimization of queries that are used to drive this company's business support systems with a focus on train data.
• Understand the Business requirements and convert them into technical specifications.
• Developing and enhancing PL/SQL Stored Procedure, Packages, Triggers and Views and coordinate accordingly with the Java Developers.
• Involved in performance tuning - analyzing query plans, query tuning, partitioning and optimizer hints.
• Worked with Analytic functions to compute an aggregate value based on a group of rows,aggregate functions and other different built Oracle Functions.
• Experienced with DBA activities like creating users, grant and revoke privileges on database projects as per the user’s request.
• Experience using Bulk processing, ETL operations, implicit and explicit cursors, Ref Cursor, collections, DBMS packages.
• Implement the developed code, test along with the Java Developers by pointing their local to the required Database Object and deploy accordingly.
• Writing and reading PL/SQL Packages to reduce context switching.
• Ability to write complex queries including inline sub queries and correlated sub queries and against very large data sets as per the business requirements
• Analyze and resolve data issues and also recommend and implement solutions to prevent recurrence. 
• Collaborated with the Core team and facilitate them to run database objects in Unix environment and involve in any further trouble shooting.
• Used UTL FILE package to manipulate the data from files before insertion into the database.
• Interacted with the DBA team for Performance Tuning and database issues.
• Tuned the SQL statements using explain plan for quick data retrieval involving complex joins.
• For Optimization Process actively involved in creating views, materialized views, partitioning tables etc.
• Created parallel hints to parallelize operations and indexes for avoiding full table scans and disks sorts, and improved the performance and tuned the oracle queries.
• Experience with SQL*Plus, SQL*Loader, Data Pump, Exp/Imp, TKPROF, Oracle scheduler, Advanced Queues, Object management.
• Experience with building BI models for standard andadhoc reporting, analysis and risk dashboards.
• Used Concurrent Version System (CVS) plug in along with Eclipse tool so that all the developed scripts are checked in, checked out accordingly for any future production.
• Worked as a Scrum Master in agile environment in the absence of my Boss in Scrum meetings.

Environment: Oracle 11g, SQL*Plus, SQL*Loader,UNIX, Toad, Agile, CVS Eclipse, Web services, Java.

Confidential, Newyork, NY

Database Developer

Responsibilities:

• Understand the Business requirements and convert them into technical specification.
• Designed, developed and maintained database objects such as Tables, Views, Indexes, Stored Procedures and Materialized Views in Oracle, PostgreSQL and MySQL.
• Created Custom Triggers on Application tables to keep track of changes for Auditing in AOMA application.
• Experienced with DBA activities like creating users, granting and revoking privileges on database objects as per the user’s request.
• Implement various advanced features of Oracle such as Table Partitioning, Indexing strategies, DBMS Scheduler according to the requirement.
• Involved in Performance tuning and query optimization using SQL Trace, Hints, TK Prof, and Explain Plan.
• Research production issues and provide documented analysis and sizing required to fix the issue.
• Detailed understanding and implementing of coding design and documentation protocol as well as unit testing, change management and release procedures.
• Creating scripts to Migrate data between different databases like Oracle to Postgres and Postgres to netezza, vice versa using enterprise migration tool kit and Unix scripts.
• Developed scripts in Postgres, required for the different versions of production build or deployment and coordinated with the java team to execute them as per the set up.
• Used Concurrent Version System (CVS) Plug in along with Eclipse tool so that all the developed scripts are checked in, checked out accordingly for any future production build so that different developers can work simultaneously on different parts of the same project while tracking changes and ensuring that the project as a whole remains functional.
• Created SQL Loader scripts and External tables to load the data from flat files and validated the data with PL/SQL procedures.
• Written complex SQL’s using joins, sub queries and correlated sub queries in Oracle to generate business reports accordingly.
• Developed few ad hoc reports on demand basis. The output results were exported in different formats i.e. Excel, CSV and fixed length.
• Collaborated with team on   Automatic Database Diagnostic Monitor (ADDM) which analyzes data in the Automatic Workload Repository (AWR) to identify potential performance bottlenecks .  
• Extensive experience in creating reports by extracting targeted data, transforming it to fit operational needs and loading it into the data warehouse. 
• Carried out knowledge transfer sessions to other members of team and provided training to users within the department.

Environment: Oracle 11g, PostgreSQL 9.0, MYSQL 5.6, Netezza, UNIX, PL/SQL Developer, PGAdmin III, Razor SQL, Aqua Data studio, Migration tool kit, Jira, CVS Eclipse, Datastage, AWR, ADDM.

Confidential, Tampa, FL

Production Support Analyst

Responsibilities:

• Analyze different issues in the Production environment and finding out the root cause followed by an efficient solution in the EMM (Electronic Mobile Measurement) application.
• To Lead Technical discussion on business rules applied or used for the current production cycle and clarify the questions (File missing, incorrect format, spike in data and other data issues) raised by Ops team during their BizQC meetings or data processing stages.
• Worked with Panelists data retrieval using correlated sub queries and nested sub queries.
• Worked extensively with XML files in the production environment.
• Create and debug SQL procedures by effective exception handling by creating user defined errors using pragma exception init and raise application error for the ease of debugging and displaying the error messages and scripts used as part of production cycle run.
• Acquainted and done reverse engineering of the PL/SQL Procedures, Functions, Views and Complex SQL scripts to find out the business requirement.
• Extensively worked with development  of Business reports by pulling the data from the new archive data base and on reports for technical assistance such as asking for a SQL extract or technical input for a design document.
• Sorted issues of long time taking queries by using dynamic SQL statements like Execute Immediate and DBMS SQL.
• Developed the PL/SQL Procedures, SQL Scripts and Complex SQL Queries to prepare the Key Performance Indicator (KPI) Vendor Metrics and calculated the Churn rate and Retention rate of the Panelists as a part of analyzing the trend of Business accordingly.
• Interacted with the DBA team for Performance Tuning and database issues.
• Tuned the SQL statements using explain plan for quick data retrieval involving complex joins.
• For Optimization Process actively involved in creating views, materialized views, partitioning tables etc.
• Created indexes for avoiding full table scans and disks sorts, and improved the performance and tuned the oracle queries.
• Created SQL Loader scripts and External tables to load the data from flat files and validated the data with PL/SQL procedures.
• Worked on loading data from excel into Oracle Table using external tables.
• To support proactively like decisive on the database or application services, whenever required.
• Monitor the common queue in CCM.Net tool and resolving the tickets as per the business requirement.
• Hosted calls to facilitate and lead the meeting for any incidents, defect triage, Root Cause Analysis and troubleshooting for any monitoring alert scripts by coordinating with Command center or monitoring tools team and coordinating closely with App Dev, Operations and external Vendors.
• Good Understanding in implementing and utilizing JQuery.
• Worked on Parameterized SQL statements to avoid   SQL injection   attacks in VB Environment.
• Involved in organizing production environment for different warehouse projects and documentation of complete project for maintenance purposes.
• Worked closely with various DW Analyst/Developers working on specific data marts, multiple business units to identify key information that will enhance business decision-making.
• Responsible for extensive data validations, feeding of live data and user acceptance for each module.
• Received Client recognition award for my commitment and dedication in the Project.

Environment: Oracle 11g, Toad, SQL Server 2008, SQL Server Management Studio, Perforce, Putty, Perl, Web logic, CCM.Net, JQuery.

Confidential, Beaverton, OR

Application Engineer

Responsibilities:

• Worked as an application Engineer in the Production Support in the Planning Department dealing with GFPDM application.
• One of the major roles is to monitor the jobs as the GFPDM data gets updated on a daily basis through Batch jobs.
• Understanding the Business requirements from the Business Analysts and converting them into technical specifications, Where the user interface application works on SAP ABAP Environment and the backend is ORACLE 10G.
• Acquainted and worked on reverse engineering of the PL/SQL Procedures, triggers, Views and Complex SQL scripts to find out the business requirement.
• Optimized critical queries to eliminate full table scans using Explain plan, TKPROF.
• For Optimization Process actively involved in creating views, materialized views, partitioning tables and creating indexes etc.
• Created SQL Loader scripts and External tables to load the data from flat files and validated the data with PL/SQL procedures.
• Extensively worked on reports for technical assistance such as asking for a SQL extract or technical input for a design document.
• Responsible for making enhancements to the existing database.
• Created database tables/views for designing the database using primary keys and foreign keys.
• Worked with different kintana’s that comes to production and fix them as per the business requirements.
• Handle the complex supply planning application catering toapparel, Footwear and Equipment business by converting the Business requirements into technical specifications.
•  Work on enhancements of the Developed modules in the Production by cross checking the Performance of the PL/SQL Stored Procedure, Functions, Packages, Triggers, Views and complex SQL Queries that are part of that module.
• Responsible for handling and owning complex modules
• Interaction with client on regular basis for capturing enhancement requirement.
• Writing and enhancing PL/SQL Stored Procedure, Packages, Triggers and Views on the Back End for the requirements in the production.
• Worked with Toad  which is a   software application   for development and   administration   of various   relational databases   using SQL .
• Used a tool called Autosys or Work Control center (WCC) to monitor the Batch on day to day basis.

Environment: Oracle 10g, SQL*PLUS, SQL*Loader, Toad, Autosys, Unix, Microsoft Visual Source safe, Informatica, SAP ABAP.

Confidential, Cincinnati, OH

Senior Oracle Developer

Responsibilities:

• The project involved checking eligibility and assigning members to the Health Care Policies within a designated zip code.
• Collected and collated appropriate data for use in databases and conduct related research.
• Coordinated with Business Analysts to convert Functional Requirements into technical Specifications.
• Performed the automation process to assign members to Health Insurance Policies.
• Extensively wrote Custom packages, stored procedures, triggers, materialized views, functions using PL/SQL.
• Used Ref Cursors in the New Member Packages for faster retrieval of information.
• Used Pipelined functions to return large result sets.
• Developed triggers and indexes for efficient data management.
• Modified existing Interfaces using PL/SQL procedure, triggers and functions in the Human Resources module.
• Used DBMS SCHEDULER to automate the regular tasks and improve time-constrained performance.
• Tuned SQL statements using Explain plan, TKPROF for maximum efficiency and performance.
• Responsible for requirement Analysis, Coding, Testing and Implementation of various modules.
• Developed control files for SQL*Loader and PL/SQL programs for loading    and validating the data into the interface tables from the Legacy system.
• Used UTL Files to transfer data out of Oracle Database.
• Worked on data warehousing environments with star/snowflake schemas that includes multi-dimensional design and OLAP processing.
• Extensively worked on reports for technical assistance such as asking for a SQL extract or technical input for a design document.
• Performed Data Validations, Data Conversions for bringing the data from legacy system to Interface Tables.
• Performed SQL Tuning of existing procedures, packages and functions for faster query execution using Hints, TK Prof and Explain Plan utilities.
• Developed Dynamic SQL code for runtime query execution.
• Performed automation using UNIX/KORN shell scripts.
• Extracting data from Teradata, and analyzing data and loading it into Oracle.
• Interacted with the DBA team for Performance Tuning and database issues.
• As a part of a team, successfully completed the design, development and implementation of the system.
• Support re-design and re-engineering of Oracle forms system interfaces, applications, stored procedures, database tables, system design proof of concept, and system implementation.
• Worked on production support, bug fixing and enhancements.

Environment:Oracle 11g, SQL*PLUS, SQL*Loader, TOAD,Ms Excel, .Net, SQL*Navigator, Business Objects, TeraData, shell scripting (Korn).

Confidential, CHICAGO, IL

Oracle Pl/ SQL Developer

Responsibilities:

• Designed complex UNIX scripts and automated it to run the workflows daily, weekly and Monthly.
• Developed mapping parameters and variables to support SQL override.
• Setting up Batches and sessions to schedule the loads at required frequency using Power Center Workflow manager.
• Implemented recovery solutions by writing stored procedures and cursors using Sybase SQL to undo mistakes made by traders.
• Created mappings/workflows to extract data from SQL Server, Sybase and Flat File sources and load into various Business Entities and Transaction Data Sets.
• Created complex SQL, PL/SQL, stored procedures, functions.
• Insured that all enterprise procedures are followed such as system testing, change management, project prioritization, promotion to production, time entry, etc
• Draft, institute and continually refine required processes. Actively participated in user acceptance and sign-off process. Worked effectively with assigned project managers.
• Experience performing application development work using Oracle Application Express to design and maintain web applications.  
• Participated in the review and maintenance of data security standards to protect information assets.
• Provided reliable, timely support of integration, performance and user acceptance testing processes.
• Experience performing development work using Oracle Report Builder on a database system which maintains historical data.  
• Designed and developed complex aggregate, join, look up transformation rules (business rules) to generate consolidated (fact/summary) data identified by dimensions using Informatica ETL (Power Center) tool.

Environment:Informatica Power Center 7.1, Oracle 8i/9i, MS SQL Server 2008/2005, XML, Oracle Application Express, Oracle Report Builder, Web Services, Sun Solaris 2.6 and Windows NT.

Confidential, Morris Plains, NJ

Oracle PLSQL Developer

Responsibilities:

• Involved in data modeling, development and enhancement of various modules.
• Involved in all phases of SDLC from requirement, design, development, and testing.
• Normalization of the database following the first, second and third normal forms to eliminate redundant data and reduce the database size.
• Wrote packages, stored procedures for storing the client information in providing the services of cloud computing and email applications using PL/SQL.
• Created database objects such as tables, views, synonyms, indexes and sequences.
• Created views based on multiple tables and performed data changes using Instead of triggers for the underlying tables.
• Created changes in the database according to new requirements (new tables in the existing database and fields in the existing tables).
• Setup run time environment, creating and maintaining shell scripts to run stored procedures, packages to populate the valid data in staging tables and invalid data into error tables which will be sent back to sender notifying the errors.
• Constructed the required data involving complex JOIN statements, including outer-joins, intersect and union all.
• Worked with Collections and improved the performance of multi-row queries by using Bulk Collect and Bulk binds.
• Used DBMS SCHEDULER to automate the regular tasks and improve time-constrained performance.
• Tuned SQL statements using Explain plan, TKPROF for maximum efficiency and performance.
• Wrote SQL, PL/SQL programs to retrieve data from data repository using cursors and exceptional handling.
• Experience performing application development work using Oracle Application Express to design and maintain web applications.  
• Provided reliable, timely support of integration, performance and user acceptance testing processes.
• Experience performing development work using Oracle Report Builder on a database system which maintains historical data.  
• Performed the uploading and downloading flat files from UNIX server using FTP.
• Created PL/SQL Procedures, Functions, Triggers and Packages to meet the business requirement of the project and avoided mutating table errors using Compound triggers.
• Used Global Temporary tables to access the repeated data within a session and improved the performance.
• Coordinated with front end team working on Ruby with rails and provided them the required procedures and packages and necessary insight into the data.
• Used SQL loader for importing the flat files which consists of several records of clients’ information into the different tables in the database.
• Used UTL FILE package to manipulate the data from files before insertion into the database.
• Worked with creating, maintaining, and implementing oracle forms application enhancements and reports that interact with an Oracle database.
• Generated various statistical reports using Oracle Reports for the review of Management.
• Created matrix type reports for reporting to the end users.
• Unit testing the PL/SQL code.

Environment: Oracle 9i, SQL, PL/SQL, TOAD 8.6, Oracle Reports, Oracle Application Express, Oracle Report Builder, Oracle Forms and Reports, UNIX.

Confidential

Oracle Developer

Responsibilities:

• Participated in meetings with users, Business analysts in understanding the business requirements
• Involved in Developing and handling the PL/SQL Packages, Procedures and Database Triggers.
• Developed and maintained the reusable codes as Common Library routines.
• Involved in fixing the bugs at the runtime.
• Involved in preparing program flows and test plans.
• Involved in writing the UNIX shell scripts to automate Oracle jobs.

Environment: UNIX, Windows NT, Oracle 9i, SQL, PL/SQL, SQL * Plus, Toad.