SUMMARY

• Around 8 years of IT experience in the Analysis, Design, Development, Testing and Implementation of business application systems for Health care, Pharmaceutical, Financial, Insurance, Banking.
• 7 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, XML, XSL, PL/SQL, SQL*Plus, SQL*Loader and Developer 2000, 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 WinSQL, TOAD (Tool for Oracle Application Developers)
• Proficient in Analyzing Business processes requirements and translating them into technical requirements.
• Design, develop, and execute Spotfire - based reports and visualizations.
• Expertise in complex SQL queries and store procedures and integration with Spotfire.
• 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 reportsthat interact with an Oracle database.
• Experience in Supporting, re-design and re-engineering of Oracle formssystem 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.

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, ETL Informatica, ETI, Data marts, Star Schema, Snowflake Schema, Data mining, Data Cleansing, Data Profiling.

XML Technologies: XML, HTML.

PROFESSIONAL EXPERIENCE

Confidential, Jacksonville, FL

Sr. Oracle PLSQL Developer

Responsibilities:

• Worked as a Lead 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 objects 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 contextswitching.
• 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.
• 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 SQL*Plus, SQL*Loader, Data Pump, Exp/Imp, TKPROF,Oraclescheduler, Advanced Queues, Object management.
• Experience with building BI models for standard and adhoc 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 program reports using SQL scripts by understanding the business requirements.
• 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, Tampa, FL

Lead Oracle Consultant

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 developmentof 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.
• Involved in organizing production environment for different warehouse projects and documentation of complete project for maintenance purposes.
• Design, develop, and execute Spotfire-based reports and visualizations.
• Expertise in complex SQL queries and store procedures and integration with Spotfire.
• Worked with Oracle Discovererforad hocquerying, reporting, data analysis, and Web publishing for theOracle Database environment.
• 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, Spot fire, Oracle Discoverer 11g.

Confidential, Cincinnati, OH

Sr. 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.
• Worked with Oracle Discovererforad hocquerying, reporting, data analysis, and Web publishing for theOracle Database environment.
• Scheduled workloads on a daily, weekly or monthly interval using control M scheduler.
• As a part of a team, successfully completed the design, development and implementation of the system.
• Support re-design and re-engineering of Oracle formssystem 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), Oracle Discoverer 11g, Control M.

Confidential, Illinois, IL

Senior Pl/Sql Developer

Responsibilities:

• Creating and Debugging of Packages and Procedures & Functions.
• Responsible for requirement Analysis, Coding, Testing and Implementation of various modules.
• Gathered and translated business requirements into detailed, production-level technical specifications, new features, and enhancements to existing technical business functionality.
• Developed PL/SQL procedures and functions to migrate data between Oracle Databases.
• Extensively used PL/SQL Developer for creating database objects, running the command scripts for inserting the configuration data items.
• Used Oracle Forms to create new forms and also maintain existing forms.
• Automated data loading, extraction, reports generation using UNIX Shell scripting.
• Loading data by using SQL* Loader to custom tables.
• Troubleshoot jobs using the debugging tool.
• Worked on materialized views, DBMS SCHEDULER for scheduling jobs and UTL MAIL to send mails using oracle 10g.
• Involved in reverse engineering of the application using Erwin.
• Used Erwin to transform data requirements into data models.
• Analyzed business process workflows and developed ETL procedures for moving data from source to target systems.
• Worked on load data from excel into Oracle Table using PL/SQL.
• Designed Web-based Internet applications linked to firm-wide SQL databases.
• Conducted performance tuning of applications through tuning pack and SQL*Navigator, SQL*TRACE, TKPROF utilities.
• Implemented shell scripts for trouble shooting Oracle Errors with the help of trace files and scheduled them.
• Configured database performance tools such as Oracle Enterprise Manager, SQL Navigator and used them for tuning of applications.
• 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.
• Worked with creating, maintaining, and implementing oracle forms application enhancements and reportsthat interact with an Oracle database.
• Experience performing development work using Oracle Report Builder on a database system which maintains historical data.
• Used Oracle Enterprise Manager, TOAD for developing and managing pl/sql scripts.

Environment: Oracle 11g, Pl/Sql, SQL *Plus, TOAD, Oracle Forms 6i, Oracle Reports 6i, Oracle Report Builder,Ms Excel, SQL*Navigator, Business Objects, Power Builder, 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 reportsthat 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.