SUMMARY

• Over 5 years of IT experience in System Analysis, Design, Development, Maintenance and Support using Oracle Database 9i/10g/11i/11g,SSMS,SSRS Reporting, SSIS Packages, SQL, PL/SQL, SQL * Loader, Query Optimization, Performance Tuning, and Trouble Shooting and support experience in Unix, Linux and Windows.
• Providing assistance in logical/physical data modeling using ERWIN.
• Experience with multiple RDBMS including Oracle 11i/10g/9i/8i/8.x, SQL server 2008 databases on UNIX, Linux and Windows enterprise platforms.
• Effectively made use of Table Functions, Indexes, Table Partitioning, Collections, Analytical functions, Materialized Views, Query Re - Write and Transportable table spaces.
• Created Tables, Views, Constraints, Index (B Tree, Bitmap and Function Based).
• Developed Complex database objects like Stored Procedures, Packages, Triggers and functions, ref cursors using SQL and PL/SQL.
• Experience in usingSSIStools like Import and Export Wizard, Package Installation, and SSIS Package Designer.
• Experienced in working with utilities like SQL*Loader, External Tables, Import, and Export to extract and load large volume of data.
• Expertise in Dynamic SQL, Collections and Exception handling. Partitioned large Tables using range partition technique.
• Good knowledge of key Oracle performance related features such as Query Optimizer, Execution Plans and Indexes.
• Experience in writing Test Plans, Defining Test Cases, Developing and Maintaining Test scripts.

TECHNICAL SKILLS

Databases: Oracle 8i/9i/10g/11i/11g, MySQL 5.6, SSMS R2 2008

Languages: SQL, PL/SQL, Unix Shell Script

Tools: TOAD 8.5/8.0, SQL-Developer, PL-SQL Developer, SQL*Plus, SQL*Loader, Import and Export, Explain Plan TKPROF, Agile Methodology, Erwin & ER Studio (data modelling), MS Visio

Reporting Tools: BIDS(SSRS,SSIS), Pentaho

Operating Systems: Windows, UNIX, Linux

PROFESSIONAL EXPERIENCE

Confidential, Atlanta GA

Sql/PLSQL Developer and Data Analyst

Responsibilities:

• Primary responsibilities includeData extractionandData analysis for the application Affordable care Act (ACA) Product.
• Extracting data from multiple operational sources, transforming, cleansing, and filtering the data, and finally loading the data into one or more target databases.
• Process individual client configurations in web based application totrack labor hours, determine benefits eligibility, and alert client to potential compliance risks and penalties under the ACA.
• Loading master and reference data, and transaction data into normalized tables. And loading the fact, dimension and bridge tables in a dimensional model.
• Advanced creation of complex SQL queries, and stored procedures in order to validate data imports, diagnose issues, and produce analytics for client feedback.
• Worked to create test plans, project plans and test scenarios. Developed complex SQL queries to query data.
• Developing batch files to load test files and automate the scheduling process.
• Involved in Data mapping, Column mapping and maintain data dictionaries and Data models.
• DesignedSSIS packages (2008/2005)to import and transform data between databases and external data sources and conversion of DTS à SSIS packages
• Involved in providingLogging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.
• Experience in Performance Tuning in SSIS packages by usingRow Transformations, BlockandUnblock Transformations.

Environment: SSMS R2 2008, eThority, UNIX-Shell Scripts, Windows.

Confidential, CHICAGO, IL

Sr. Oracle PL/SQL Developer

Responsibilities:

• Created database objects like Tables, Sequences and Constraints as per the business requirement.
• Extracted data from the source views by writing the procedures to load the data into staging tables.
• Created database views and materialized views and database triggers based on requirements.
• Developed stored functions, packages based on requirement.
• Automated Quality Check tasks by creating PL/SQL procedures, cursors, functions and dynamic SQL. Enhanced it with creating exceptions for error handling.
• Involved in creating Logical and Physical data modeling using ERWIN.
• Modified and debugged several PL/SQL programs for performance tuning using techniques like EXPLAIN PLAN, TKPROF and DBMS PROFILER
• Written complex Oracle SQL queries with complexity using Inner/Outer joins, Union All, Intersect& Minus set operators
• Created indexes on tables and optimized procedure queries.
• Maintained Database security by authenticating users, using logon triggers.
• Running explain plan for tuning the SQL queries.
• Used Exception Handling extensively for the ease of debugging and displaying the error messages in the application
• Created test scripts documentation for all the procedures that I have created.
• Involved in production support, like monitoring the performance of the Unix jobs.

Environment: Oracle 11i, SQL*Plus, PL/SQL Developer, Toad, SQL * Loader, UNIX, Shell Scripts, Erwin, Windows, Linux, SSRS

Confidential, Bridgewater, NJ

Oracle PL /SQL Consultant

Responsibilities:

• Involved in creating Database Design (Physical and logical) as per the requirement given by business
• Worked on Erwin Data Modeler for mapping both user-defined and default data types
• Developed PL/SQL packages, procedures, functions, materialized views, SQL Scripts and triggers to populate the historic data in the tables applying business logic
• Worked on sequences, functions, synonyms, indexes, triggers, packages, stored procedures, roles and granting privileges on OLTP server.
• Involved in Creation of tables, Partitioning tables, Join conditions, correlated sub queries, and nested queries, views for the business application development.
• Created temporary tables and developed SQL*Loader control files to load the legacy data into the temporary tables.
• Wrote Materialized views and complicated queries using SQL.
• Involved in writing SQL queries (Sub queries and Join conditions), PL/SQL programming.
• Used the advanced features of PL/SQL like collections, nested table, array & Dynamic SQL.
• Wrote SQL sub-queries with join conditions and PL/SQL scripts
• Involved in performance tuning of SQL queries and Created indexes on tables and optimizing Stored procedure queries
• Design and developed the scripts to create table, views, indexes and sequence.
• Extensively involved in tuning the queries and applying hints for faster and better performance of the SQL queries.

Environment: Oracle 10g, SQL* Plus, SQL * Loader, TOAD, Erwin, SQL Server 2008, UNIX.

Confidential

Oracle PL/SQL Developer

Responsibilities:

• Created data mapping to map the data from different sources to Oracle.
• Involved in implementing the data integrity validation checks through constraints and triggers.
• Developed and modified packages, functions and stored procedures for data conversions
• Developed PL/SQL procedures to create database objects dynamically based on user inputs.
• Wrote SQL, PL/SQL, SQL*Plus programs required to retrieve data from the Data repository using cursors and exception handling.
• Created indexes on tables to improve the performance by eliminating the full table scans.
• Created views for hiding actual tables and to eliminate the complexity of the large queries.
• Created Records, Objects, Collections to store ordered group of elements for faster assessment of tables
• Created Error Handling to handle run-time errors in the PL/SQL code.
• Used Oracle Hints and explain plan to fine tune the queries.
• Increased performance tuning by rewriting some of the Queries.
• Designed and developed Oracle forms and reports according to user specification.

Environment: Oracle 10g, Oracle Forms and Reports 6i, SQL, PL/SQL, Erwin, UNIX, Windows, TOAD.

Confidential

Oracle PL/SQL Developer

Responsibilities:

• Prepared program Specification for the development of PL/SQL procedures and functions.
• Created Custom Staging Tables to handle import data
• Created custom triggers, stored procedures, packages and functions to populate different database
• Developed SQL* loader scripts to load data in the custom tables
• Run Batch files for loading database tables from flat files using SQL*loader
• Created UNIX Shell Scripts for automating the execution process
• Created indexes on tables and Optimizing Stored Procedure queries
• Design, Development and testing of Reports using SQL*plus
• Created Indexes and partitioned the tables to improve the performance of the query
• Involved in preparing documentation and user support documents
• Involved in preparing test plans, unit testing, System integration testing, implementation and maintenance

Environment: Oracle 9i/10g,PL/SQL, SQL*Loader, SQL*Plus, UNIX, Windows

Confidential

Oracle Developer

Responsibilities:

• Involved in the complete life cycle of the product from requirements gathering to end of system testing.
• Created PL/SQL Packages, Procedures, Function and Triggers.
• Worked on developing a financial application system to handle all the bank transactions.
• Used SQL*Loader to load the database from flat files.
• Performed SQL performance tuning using Explain plan, Trace utility & TKPROF.
• Designed and developed data validation, loading and testing process using PL/SQL Stored Procedures, Functions and Database Triggers.
• Worked on Table Partitioning (Range and List) and deploying Local Indices on partitioned tables.
• Implemented Performance Tuning by creating Indexes, executing EXPLAIN PLAN on SQL Scripts and using Optimizer Hints if necessary for faster retrieval.
• Performed the uploading and downloading flat files from UNIX server using FTP. .

Environment: Oracle 9i, SQL, SQL*Plus, PL/SQL, SQL*Loader and Reports 4.5i, UNIX, Windows XP.