SUMMARY

• 7+ 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.
• 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.
• 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 viceversa.
• 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.
• Excellent team player and can work on both development and maintenance phases of the project.
• Highly skilled in providing instantaneous and workable solutions to business problems.
• Efficient team player with excellent communication skills and good interaction with users.

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, Visio, MS Source Safe, 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, Data mining, Data Cleansing, Data Profiling.

XML Technologies: XML, HTML.

PROFESSIONAL EXPERIENCE

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, 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.
• Written complex SQL’s using joins, sub queries and correlated sub queries in Oracle accordingly.
• Developed few ad hoc reports on demand basis. The output results were exported in different formats i.e. Excel, CSV and fixed length.
• Documented the work by creating various reference manuals for reference by future testers and users.
• 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.

Confidential, Tampa, FL

Senior 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.
• 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.
• 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 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.
• 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.
• Troubleshooting for any monitoring alert scripts by coordinating with Command center or monitoring tools team.
• Worked extensively with XML files in the production 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.
• A good team player by coordinating closely with App Dev, Operations and external Vendors.
• 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, Perl, Web logic, CCM.Net.

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.
• 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 to apparel, 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 andadministrationof variousrelational databasesusing SQL.
• Used a tool called Autosys or Work Control center (WCC) to monitor the Batch on day to day basis.

Environment: Oracle 10g, Toad, Autosys, Unix, 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.
• 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.
• Worked on production support, bug fixing and enhancements.

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

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.
• 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, Ms Excel, SQL*Navigator, Power Builder, shell scripting (Korn ).

Confidential, CHICAGO, IL

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.
• 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.
• 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, Web Services, Sun Solaris 2.6 and Windows NT.

Confidential, Morris Plains, NJ

Oracle 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.
• 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.
• 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, 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.