• 8 years of IT experience in the Analysis, Design, Development, Testing and Implementation of business application systems for Health care, Pharmaceutical, Financial, Insurance, Banking.
• 8 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.
• 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.

Confidential

Sr. Oracle PLSQL Developer

• Description: Confidential is the third largest rail road company in Confidential headquartered at Confidential
• Responsibilities:
• Worked as an Oracle Developer being a part of development of the application JWDS Joint Wayside Diagnostic System , an equipment monitoring platform from its inception.
• 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
• 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 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 Ansi 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, Oracle scheduler, Advanced Queues, Object management.
• Good Understanding in implementing and utilizing JQuery.
• Worked on Parameterized SQL statements to avoid SQL injection attacks in VB Environment.
• 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.
• 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

Database Developer

• Responsibilities:
• Description:Confidential Music Entertainment also called SME or Confidential Music is the second-largest global recorded music company of the big three record companies and is controlled by Sony Corporation of America, the United States subsidiary of Japan's Sony Corporation. Worked with AOMA application and migrated the data from Oracle to Postgres database, besides the regular Production Support and Development activities.
• Written complex SQL's using Ansi joins, sub queries and correlated sub queries in Oracle to generate business reports accordingly.
• Created Custom Triggers on Application tables to keep track of changes for Auditing in AOMA application.
• 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.
• 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.
• Developed few ad hoc reports on demand basis. The output results were exported in different formats i.e. Excel, CSV and fixed length.
• 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.

Confidential

Production Support Analyst

• Responsibilities:
• Description: Confidential is a publicly held global information and media company, and is one of the world's leading suppliers of marketing information. Worked with Electronic Mobile Measurement EMM Application and supported the Application in the Production phase.
• 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.
• Sorted issues of long time taking queries by using dynamic SQL statements like Execute Immediate and DBMS SQL.
• 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.
• Worked with Panelists data retrieval using correlated sub queries and nested sub queries.
• 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.
• To Lead Technical discussion on business rules applied or used for the current production cycle
• 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.
• Worked extensively with XML files in the production environment.
• 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.
• Interacted with the DBA team for Performance Tuning and database issues.
• Created SQL Loader scripts and External tables to load the data from flat files and validated the data with PL/SQL procedures.
• Created indexes for avoiding full table scans and disks sorts, and improved the performance and tuned the oracle queries.
• For Optimization Process actively involved in creating views, materialized views, partitioning tables etc.
• Tuned the SQL statements using explain plan for quick data retrieval involving complex Ansi joins.
• 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.
• Responsible for extensive data validations, feeding of live data and user acceptance for each module.
• 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.
• Involved in organizing production environment for different warehouse projects and documentation of complete project for maintenance purposes.
• 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

Application Engineer

• Acquainted and worked on reverse engineering of the PL/SQL Procedures, triggers, Views and Complex SQL scripts to find out the business requirement.
• 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.
• Description: Confidential is a major publicly traded sportswear and equipment supplier based in the Confidential. The company is headquartered near Confidential, which is part of the Confidential metropolitan area. It is the world's leading supplier of athletic shoes and apparel and a major manufacturer of sports equipment. Worked as an application Engineer for Production Support team in the Planning Department with GFPDM Global Footwear Planning Datamart application.
• 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.
• 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

Senior Oracle Developer

• Extensively worked on reports for technical assistance such as asking for a SQL extract or technical input for a design document.
• Worked on data warehousing environments with star/snowflake schemas that includes multi-dimensional design and OLAP processing.
• Tuned SQL statements using Explain plan, TKPROF for maximum efficiency and performance.
• Used DBMS SCHEDULER to automate the regular tasks and improve time-constrained performance.
• Modified existing Interfaces using PL/SQL procedure, triggers and functions in the Human Resources module.
• Developed triggers and indexes for efficient data management.
• Used Pipelined functions to return large result sets.
• Used Ref Cursors in the New Member Packages for faster retrieval of information.
• Extensively wrote Custom packages, stored procedures, triggers, materialized views, functions using PL/SQL.
• Performed the automation process to assign members to Health Insurance Policies.
• Coordinated with Business Analysts to convert Functional Requirements into technical Specifications.
• Collected and collated appropriate data for use in databases and conduct related research.
• The project involved checking eligibility and assigning members to the Health Care Policies within a designated zip code.
• Responsibilities:
• Description: Confidential. is the largest health benefits company in terms of commercial membership in the Confidential. Through its nationwide networks, the company delivers a number of leading health benefit solutions through a broad portfolio of integrated health care plans and related services, along with a wide range of specialty products such as life and disability insurance benefits, pharmacy benefit management, dental, vision, behavioral health benefit services, as well as long term care insurance and flexible spending accounts.
• 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.
• 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.
• Extracting data from Teradata, and analyzing data and loading it into Oracle.
• Performed automation using UNIX/KORN shell scripts.
• Developed Dynamic SQL code for runtime query execution.
• 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

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.
• Automated data loading, extraction, reports generation using UNIX Shell scripting.
• Used Oracle Forms to create new forms and also maintain existing forms.
• 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 reports that 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

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.
• Worked with Actimize for its use of analytics and modeling techniques to uncover anomalous financial transactions, like fraud, money laundering and market manipulation.
• 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, Actimize, Oracle Report Builder, Web Services, Sun Solaris 2.6 and Windows NT.

Confidential

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 Ansi 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

• Description: This Project is basically developed for Confidential for building a data mart and OLAP reports for order management, strategic testing and tactical call center/customer relationship Management. This data mart stores historical information about Local, Long Distance, Voice Mail, and Pager Services. This system extracts data from order management system database OLTP .
• 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.
• Developed Complex join queries using Ansi join statements including outer-joins, intersect and union all.
• 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.