SUMMARY

• Oracle professional with over FIFTEEN years of experience in software analysis, design, development, testing, deployment and support.
• Experience in School, Utility, Media entertainment, P & C Insurance, pharmaceuticals, telecom and ERP domain.
• Experience in Microsoft SQL Server 2012/2008/2008R2/2005, Microsoft SQL Server Integration Service (SSIS), Microsoft SQL Server Analytical Services (SSAS), Microsoft SQL Server Reporting Services (SSRS).
• Experience in Suite (Oracle 11g/10g/9i/8i, OWB (Oracle Warehouse Builder), Forms 6i, Reports 6i, Forms 10g, Reports 10g, SQL, PL/SQL, MySQL, SQL*Loader, Oracle Export/Import) on Windows platforms.
• Good experience in client/server technology, GUI design, Relational Database Management Systems (RDBMS), and Rapid Application Development methodology using Oracle.
• Designed the high - level Entities and then complete Data Model using Erwin.
• Data modeling: normalization, physical database design, relational models etc.
• Data mapping to existing data sources.
• Excellent knowledge of using variables and expressions in packages of SSIS.
• Worked with Flat Files, Excel Files and SQL Server OLEDB destination for loading data.
• Experience in evaluating and performance testing the database applications. Implemented indexes on tables for better performances on data retrieval from Oracle.
• Expertise in Designing logical and physical model using Relational data Model.
• Expertise in SQL query writing, creating views, table indexing and also in Oracle installation and database creation.
• Experience in writing queries using SQL Server Analysis Service (SSAS).
• Involved in designing data warehouse system based on Star Schema.
• Developed unit test case to perform unit testing of the application.
• Expertise in PL/SQL Procedures, Functions, Packages, Triggers using iSQL*Plus, SQL*Plus.
• Experience in optimization of code and tuning SQL queries for performance.
• Excellent communications and interpersonal skills.

TECHNICAL SKILLS

Operating Systems: Windows 95/95, WINNT, MS-Dos, Linux.

Database: Oracle 7.3/8i/9i/10g/11g, SQL Server 2008/2008R2/2012, MySQL.

Data warehousing Tool: Microsoft SQL Server Integration Services (SSIS), Microsoft SQL Server Analysis Services (SSAS), Oracle Warehouse Builder (OWB).

Languages: T-SQL, SQL, PL/SQL.

Front End Tools: Developer 2000 (6i), Forms 10g, Visual Basic (VB 6.0).

Report Designer: Microsoft SQL Server Reporting Services (SSRS), Oracle BI, Report Builder (Oracle Report 6i), Reports 10g, Crystal Reports.

Version Control: Microsoft VSS, Rational.

PROFESSIONAL EXPERIENCE

Confidential, Orlando, FL

SSIS/SSRS/OWB Developer /Oracle Warehouse Builder

Responsibilities:

• Design, Development and support of new databases, tables, jobs, SSIS packages and other database objects.
• Created new reports for student system using SSRS.
• Developed and deployed SSIS packages for vendor extracts and transfer of files internally.
• Rebuilding indexes as a part of performance tuning.
• SSIS transformations like Aggregate, split, join, merge, derived column, multicast, term extraction and data conversion of SQL Server Integration Services (SSIS)
• Understanding ETL process as that needs to be modify after implementing new Student Information System (FOCUS).
• Developing Materialize View, Procedures, Functions and Triggers for the application.
• Involved in migration activity from SQL Server 2008 to SQL Server 2012.
• Deploying SSRS reports from Dev and test environment to Production.
• Discussion on database design for ODS (Operation Data Source).

Environment: MS SQL Server Management Studio 2008/2012, MS SQL Server Integration Services (SSIS), MS SQL Server Reporting Services (SSRS).

Confidential

Senior Consultant

Responsibilities:

• Understanding, Drafting Business requirements with help of Business development team
• Designing database on the basis of business requirements
• Drafting respective Artifacts & Document
• Following Development Process with artifacts
• Design, Development and support of new databases, tables, jobs, SSIS packages and other database objects.
• Created new reports for student system using SSRS.
• SSIS transformations like Aggregate, split, join, merge, derived column, multicast, term extraction and data conversion of SQL Server Integration Services (SSIS)
• Creating tables, views, indexes for the database.
• Involved in writing generic PL/SQL programs, stored procedures.

Environment: MS SQL Server Management Studio 2008/2012, MS SQL Server Integration Services (SSIS), MS SQL Server Reporting Services (SSRS).

Confidential

Database /Team Lead

Responsibilities:

• Understanding, Drafting Business requirements with help of Business development team.
• Designing database on the basis of business requirements.
• Drafting respective Artifacts & Document.
• Following Development Process with artifacts.
• Application Development with Web Service Interface.
• Managing database Development Team and closely working with PHP and Android Development Team.
• Maintaining Project Plan up-to-date and regular meeting with stakeholder for status.
• Releasing application version, Demo application to Marketing Team, maintaining Repository up-to-date with artifacts etc.
• Creating tables, views, indexes for the database.
• Involved in writing generic PL/SQL programs, stored procedures that take cares from database creation.
• Communicating with client.
• Understanding Business requirements.
• Designing database on the basis of business requirements.
• Drafting respective Artifacts & Document.
• Following Development Process with artifacts.
• Application Development with Web Service Interface.
• Managing database Development Team and closely working with PHP Team.
• Maintaining Project Plan up-to-date and regular meeting with stakeholder for status.
• Releasing application version, Demo application to Marketing Team, maintaining Repository up-to-date with artifacts etc.
• Creating tables, views, indexes for the database.
• Involved in writing generic PL/SQL programs, stored procedures that take cares from database creation.

Environment: PHP, MySQL, Apache, Windows, Linux (Ubuntu), Android.

Confidential

Project Lead

Responsibilities:

• Creating tables, views, indexes, and synonyms for the database.
• Involved in writing generic PL/SQL programs, stored procedures that take cares from database creation to partitioning of the database.
• Involved in writing Highly Optimized SQL.
• Involved in writing complex queries to generate ad-hoc reports as per user request.
• Responsible for writing unit and integration test cases.
• Involved in developing and testing of the ETL (Extract, Transform and Load) strategy to populate the data from various source systems (flat files and databases) feeds using ODI and PL/SQL.
• Created DB triggers, procedures for automating the application flow & to enforce the business rules.
• Involved in database designing based on Star Schema.
• Involved in developing application in ODI using Designer, Topology and Security.
• Creating Projects, Model in ODI.
• Developed Knowledge Modules in ODI.
• Developed modules, interfaces, procedures, packages and scenarios for data transformation on ODI.
• Involved in Project planning.
• Requirement gathering from Client and preparing meeting notes.
• Involved in preparing SMD based on meeting notes.
• Project estimation.
• Involved in preparing change request document based on SMD.
• Created Documentation of the all the development codes and the test cases involved.

Environment: Windows XP, Oracle 10g, SQL* PLUS, TOAD, Form 10g and Reports 10g.

Confidential

Senior Programmer / Analyst

Responsibilities:

• Creating tables, views, indexes, and synonyms for the database.
• Involved in writing generic PL/SQL programs, stored procedures that take cares from database creation to partitioning of the database.
• Involved in writing Highly Optimized SQL.
• Involved in writing complex queries to generate ad-hoc reports as per user request.
• Responsible for writing unit and integration test cases.
• Involved in developing and testing of the ETL (Extract, Transform and Load) strategy to populate the data from various source systems (flat files and databases) feeds using ODI and PL/SQL.
• Created DB triggers, procedures for automating the application flow & to enforce the business rules.
• SQL Tuning using Stats packs, tkprof, explain plan.
• Involved in database designing based on Star Schema.
• Involved in developing application in ODI using Designer, Topology and Security.
• Creating Projects, Model in ODI.
• Developed Knowledge Modules in ODI.
• Developed modules, interfaces, procedures, packages and scenarios for data transformation on ODI.

Environment: Oracle 10gr2, SQL * PLUS, SQL, PL/SQL, TOAD, Oracle Data Integrator (ODI), Visual Basic (vb), HP UNIX, Windows, VSS.

Confidential, Burlington, MA

Oracle Developer/DBA

Responsibilities:

• Installed OWB on Windows and UNIX environments.
• Actively involved in the database design for data warehouse.
• Created the development databases, setup the init.ora tuning parameters.
• Created tables, views, indexes, and synonyms for the database.
• Involved in writing generic PL/SQL programs, stored procedures that take cares from database creation to partitioning of the database.
• Granted roles and privileges to the application users to access the database objects.
• Involved in partitioning the tables, indexes and management of the schema objects.
• Involved in writing Highly Optimized SQL, and extensively used BULK BINDING techniques.
• Involved in writing complex queries to generate ad-hoc reports as per user request.
• Involved in developing and testing of the ETL (Extract, Transform and Load) strategy to populate the data from various source systems (flat files and databases) feeds using OWB and PL/SQL.
• Developed staging jobs where in using data from different sources (both from database and flat files) to cleansed, summarized and aggregate and transform data in to data warehouse.
• Designed the high-level Entities and then complete Dimensional Data Model based on Star Schema.
• Developed mappings using filter, splitter, de-duplicator, lookup, sequence, constant operators.
• Responsible for creating process flow to execute mappings with the dependencies.
• Responsible for writing scripts to control the execution of process flows.
• Responsible for writing unit and integration test cases.
• Created end-to-end process flows for the ETL.
• Created DB triggers, procedures for automating the application flow & to enforce the business rules.
• Involved in SQL tuning using Stats packs, tkprof, explain plan.
• Provided the data purging functionality for purging the archived data.
• Involved in installing application on Oracle 11g and OWB 11g.
• Involved in developing application in ODI using Designer, Topology and Security.
• Created Projects, Model in ODI.
• Developed modules, interfaces, procedures, packages and scenarios for data transformation on ODI.

Environment: Oracle 11g/10gr2, Oracle Warehouse Builder 11g/10g, Oracle Process Flow, Oracle Data Integrator, OEM, SQL * PLUS, SQL, PL/SQL, SQL Loader, TOAD, SQL Developer, PL/SQL Developer, ANT Scripting, TCL Scripting, Sun Solaris, HP UNIX, Red Hat Linux, Windows, VSS.

Confidential

Module Leader (Sr. Consultant / System Analyst)

Responsibilities:

• Worked in the direct interaction with the End Users and implemented reviews of the application.
• Study, analyze, and recommend solutions for complex Client/Server application.
• Extensively worked in Normalization of the database.
• Created new database objects like Sequences, Procedures, Functions, Packages, Triggers, Indexes, Cursors and Views in Development and Production environment in PL/SQL and SQL*Plus.
• Worked in writing SQL Queries (Sub queries and Join conditions, correlated sub queries).
• Involved in back end development of Oracle PL/SQL objects for report creation.
• Developed Database Triggers to enforce Data integrity and additional Referential Integrity.
• Created SQL reports, data extraction and data loading scripts for different databases and schemas.
• Created impromptu SQL queries for data verification and analysis.
• Created and manipulated Nested and Index-By tables (i.e. PL/SQL Tables).
• Worked in creation of Views for hiding of actual Tables and Queries.
• Handled the Performance tuning of stored procedures.
• SQL Tuning using Stats packs, tkprof, explain plan.
• Wrote Ad-Hoc SQL queries for data analysis and Testing.
• Coordinated with the DBA for Table creation, user creation and other administrative activities.
• Used PL/SQL Procedures and Functions to manipulate and sort data for the Reports specifications.
• Created Documentation of the all the development codes and the test cases involved.
• Involved in testing the Data Integrity of the new tables.
• Involved extensively in Database Performance tuning.
• Fine-tuned the logic in Procedures, Functions and Triggers for optimum performance.
• Also provided 24/7 production support for the batch/production jobs.
• Resolve production support issues. Support ongoing production processes.
• Worked in the direct interaction with the End Users and implemented reviews of the application.
• Involve leading the team and development of 7 claim installation.
• Study, analyze, and recommend solutions for complex Client/Server application.
• Created new database objects like Sequences, Procedures, Functions, Packages, Triggers, Indexes, Cursors and Views in Development and Production environment in PL/SQL and SQL*Plus.
• Worked in writing SQL Queries (Sub queries and Join conditions, correlated sub queries).
• Involved in back end development of Oracle PL/SQL objects for report creation.
• Developed Database Triggers to enforce Data integrity and additional Referential Integrity.
• Created SQL reports, data extraction and data loading scripts for different databases and schemas.
• Created impromptu SQL queries for data verification and analysis.
• Worked in creation of Views for hiding of actual Tables and Queries.
• Handled the Performance tuning of stored procedures and queries.
• Wrote Ad-Hoc SQL queries for data analysis and Testing.
• Used PL/SQL Procedures and Functions to manipulate and sort data for the Reports specifications.
• Created Documentation of the all the development codes and the test cases involved.
• Involved in testing the Data Integrity of the new tables.
• Involved extensively in Database Performance tuning.
• Fine-tuned the logic in Procedures, Functions and Triggers for optimum performance.
• Also provided 24/7 production support for the batch/production jobs.
• Resolve production support issues. Support ongoing production processes.

Environment: Windows XP, Oracle 9i, SQL* PLUS, TOAD, PL /SQL developer, VSS, Rational Clear Case.

Confidential

Oracle Developer

Responsibilities:

• Created new database objects like Sequences, Procedures, Functions, Packages, Triggers, Indexes and Views in Development and Production environment in PL/SQL and SQL*Plus.
• Developed Database Triggers to enforce Data integrity and additional Referential Integrity.
• Extensively worked in writing SQL Queries (Sub queries and Join conditions, correlated sub queries).
• Created impromptu SQL queries for data verification and analysis.
• Wrote Ad-Hoc SQL queries for data analysis.
• Handled the Performance tuning of stored procedures and queries.
• Wrote Ad-Hoc SQL queries for data analysis and Testing.
• Created Documentation of the all the development codes and the test cases involved.
• Resolve production support issues. Support ongoing production processes.
• Created new database objects like Sequences, Procedures, Functions, Packages, Triggers, Indexes and Views in Development and Production environment in PL/SQL and SQL*Plus.
• Developed Database Triggers to enforce Data integrity and additional Referential Integrity.
• Extensively worked in writing SQL Queries (Sub queries and Join conditions, correlated sub queries).
• Created impromptu SQL queries for data verification and analysis.
• Wrote Ad-Hoc SQL queries for data analysis.
• Handled the Performance tuning of stored procedures and queries.
• Wrote Ad-Hoc SQL queries for data analysis and Testing.
• Created Documentation of the all the development codes and the test cases involved.

Environment: Windows XP, Oracle 8i, SQL* PLUS, TOAD, Developer 2000 (Form 6i and Reports 6i).

Confidential

Developer

Responsibilities:

• Extensively worked in writing SQL Queries (Sub queries and Join conditions, correlated sub queries).
• Created SQL queries for data verification and analysis.
• Wrote Ad-Hoc SQL queries for data analysis and Testing.
• Created Documentation of the all the development codes and the test cases involved.
• Extensively worked in writing SQL Queries (Sub queries and Join conditions, correlated sub queries),
• Created SQL queries for data verification and analysis.
• Wrote Ad-Hoc SQL queries for data analysis and Testing.
• Created Documentation of the all the development codes and the test cases involved.
• Extensively worked in writing SQL Queries (Sub queries and Join conditions, correlated sub queries).
• Created SQL queries for data verification and analysis.
• Wrote Ad-Hoc SQL queries for data analysis and Testing.
• Created Documentation of the all the development codes and the test cases involved.

Environment: Windows XP, Visual Basic, SQL Server.