SUMMARY

• Around 11 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 activities like 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.
• Extensive experience in working with Open Source Databases like Postgres and understanding its architecture.
• 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.
• Experienced in Migrating the data from Sybase to Oracle.
• 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 12c,11g/10g/9i/8i/7i, PostgreSQL9.0, MS SQL Server 2008, MYSQL 5.6, Sybase ASE 15.7, 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, SSRS, Qlik View 11.

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, Irving, TX

AWS Data Migration Developer

Responsibilities:

• Design and develop software solutions meet the business requirements.
• Provide technical solutions to the problems to transform the application.
• Implement and maintain database code in the form of functions, scripts, queries, views.
• Work with Oracle to PostgreSQL migrations to evaluate alternative solutions and/or workarounds.
• Created complex SQL, PL/SQL, PL/pgSQL stored procedures, functions.
• Insured that all enterprise procedures are followed such as system testing, change management, project prioritization, promotion to production, time entry, etc.
• Mentoring the team in application development support activities including database design, optimizing SQL queries, building complex SQLs, dynamic SQLs and triggers effective binding of packages and plans, concurrency planning, data refreshing and database objects migration across regions.
• Worked with DB links by creating a DB link extension and foreign data wrapper to connect to foreign server in Postgres environment so that the team can access the database objects in different databases in Postgres as well as cross databases like Oracle and Sybase.
• Extensively worked in creating Postgres functions, triggers, anonymous blocks, views, materialized views, writing complex SQL’s by joining multiple tables, using subqueries, WITH and ON DEMAND CONFLICT clause in Postgresql.
• Guided the team in creating Postgres functions by using cursors and capture the ouput as a XML Format file by using different XML functions like XML Content, XML Concat, XML Element, XML Forest, XMLpi, XMLagg, XMLRoot and XML Predicates in Postgres environment in order to meet the business requirement.
• Worked extensively with Cursors and Refcursors while creating Postgres Functions.
• Modified the existing Oracle compatible Shell Scripts such that they run in Postgres environment.
• Designed, tested and debugged external and Postgres native stored procedures working with remote stored procedure calls.

Environment: Oracle 11g, PostgreSQL 9.0, Sybase ASE 15.7, UNIX, Toad, SQL Developer, PG Admin IV, Razor SQL, AWS Cloud.

Confidential, Miami, FL

Sr. Oracle PLSQL Developer

Responsibilities:

• Understand the Business requirements, create the technical design document and convert them into technical specifications.
• Automated the process of sending emails in excel format creating Oracle packages and scheduled them in Endevor, a source code management and release managementtoolfor mainframe computersusing JCL.
• 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 bjects as per the user’s request.
• 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.
• WroteSQL, PL/SQL, SQL*Plusprograms required to retrieve data using cursors and exception handling.
• Creatingindexeson 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 usingOracle 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 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 Microsoft Visual FoxPro a database development system is a powerful tool for quickly creating high-performance desktop, rich client, distributed client, client/server, and Web database applications.

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

Confidential, Jacksonville, FL

Performance Tuning Consultant

Responsibilities:

• Worked as a Database Developer and involved in Developing and tuning the Performance for 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 bjects 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.
• 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.
• 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 ofOracle 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.
• Collaborated with the Sybase team to migrate the data from Sybase to Oracle database by capturing the source database using online capture, convert the captured database using Oracle SQL developer tool and generating the Oracle database and migrating the data accordingly.
• For migrating the data from Sybase to Oracle used both Online Data Move by creating a connection from within Oracle SQL Developer to Sybase source database and migrate the data and also Offline Data Move to export the data from Sybase. SQL Developer which will create a series of BCP and sqlldr files that can be run from a batch file.
• 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.
• Worked on data conversion to convert the data from Oracle to Postgres Database using the Migration tool kit and migrate the data between the databases accordingly and viceversa.
• 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.
• Integrated data sources and databases with QlikView, and designed and developed data models and backend queries for presenting data.
• Created data queries and reports using QlikView, Visual Studio, SQL Server Management Studio, SSRS, and Excel. Created custom queries/reports designed for quality verification and information sharing.
• Developed few ad hoc reports on demand basis and 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, Sybase ASE 15.7, UNIX, PL/SQL Developer, SQL Developer, PG Admin III, Razor SQL, Aqua Data studio, Migration tool kit, Jira, CVS Eclipse, Datastage, AWR, ADDM, Qlikview11, SSRS.

Confidential, Tampa, FL

Production Support Lead

Responsibilities:

• 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 Biz QC 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.
• Good Understanding in implementing and utilizing JQuery.
• Collaborated with Spark team who provides aninterface for programming entire clusters with implicitdata parallelism andfault tolerance .
• Collaborated with Hive data warehouse team which is on top ofApache Hadoop for providing data summarization, query, and analysis.
• Worked on Parameterized SQL statements to avoidSQL 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, Spark, Hive.

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 Toadwhich is asoftware application for development andadministration of variousrelational 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 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.
• Worked on HL7 standards for transfer of clinical and administrative data between software applications used by various healthcare providers.
• 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 thesystem.
• 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).

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, DB2 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.
• Expertise in DB2 in application development support activities including database design, optimizing SQL queries, building complex SQLs,dynamic SQLs and triggers effective binding of packages and plans, concurrency planning, data refreshing and database objects migration across regions.
• Designed, tested and debugged external and DB2 native stored procedures. Worked with remote stored procedure calls.
• 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, DB2, Sun Solaris 2.6 and Windows NT.

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.