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.
• 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.
• Worked with Panelists data retrieval using correlated sub queries and nested sub queries.
• 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.
• 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.
• 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).
• 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.