SUMMARY

• Around 8 Years of experience in Software design, development and implementation of Oracle, SQL, PL/SQL applications.
• Excellent knowledge in Oracle SQL and PL/SQL.
• Experience in Relational Data Base Management Systems (RDBMS).
• Extensively worked in Client - Server application development using Oracle Forms 9i/6i, Reports SQL, PL/SQL.
• Experience in writing SQL queries, functions, packages, cursors and stored procedures, database triggers using PL/SQL in Oracle.
• Expertise in distributed query performance tuning by using EXPLAIN PLAN, SQL Trace and TKPROF Utilities, hints provided by oracle.
• Proficient in designing, modeling, creating and maintaining oracle database.
• Involved in query performance of slow SQL statements by implementing Index, using FORALL and BULK COLLECT.
• Experience with DBA activities like creating users, granting and revoking privileges on database objects and taking backups.
• Well versed with Cloudera Hadoop and associated tools i.e. Map Reduce, PIG, HIVE, Sqoop, HBase.
• Experienced in working with utilities like SQL * loader, External tables, import, export to extract large volume of data.
• Configured Report Server to generate reports through SSRS SQL Server.
• Expert in Oracle database and GUI design and development of high performance technical solutions to meet the challenging business demands to the clients.
• Expert in Creating PL/SQL procedures, packages, functions, database triggers and other database objects like to generate back-end and front-end reports.
• Experience in Application Development using Forms, Reports and Discoverer.
• Strong experience in Oracle Workflows.
• Extensively worked with MVC Architecture using spring, Hibernate, Apache Struts.
• Creating custom reports using BI tools such as Jasper Reports, Oracle Reports Builder and Power.
• Experience in application development using various advanced features of Oracle like Collections, Table Functions, Dynamic SQL, Object types and Records.
• Installation, maintenance of databases. Query to data dictionary.
• Extensive experience in data migration techniques using Core Oracle External Tables, SQL* Loader, Import/Export, bulk and batch processing.
• Excellent Java development skills using HTML, CSS, Java Script, Core Java,J2EE, Groovy, Grails framework.
• Experienced in data analysis, data modeling, development, testing and documentation of projects
• Has good experience with Object-Oriented Design, application design and development using SQL (SQL*Reports, complex queries, views, group queries, tree queries, nested query, sub queries), PL/SQL (Functions, Procedures, Triggers, Packages and Oracle inbuilt packages.
• Excellent working and conceptual knowledge of PL/SQL, VB. NET, JAVA, HTML and XML Technologies.
• Knowledge of Database design, E-R diagrams.
• Experience in Software Development Life Cycle (SDLC) including analysis, logical design, Resource Planning, code development, testing, implanting and maintenance
• Experience in UNIX shell scripting.
• Worked on ETL- extraction, transformation and load.
• Possess good communication skills.

TECHNICAL SKILLS

RDBMS/DBMS: MS-SQL Server 7.0/2000/2005/2008 R2/2012, Oracle7.x/8. i, SQL Server BIDS, SSMS, SSIS/Oracle 10g, 11i.

Reporting Tools: SQL Server Reporting Tools (SSRS), Crystal Reports XI

Database Tools: Enterprise Manager, Query Analyzer, SQL Profiler, Data Transformation, Replication, Upgrade Wizard, Jobs, and Task creating scheduling

Operating Systems: Windows Server 2003, Windows XP/2000/95NT

Web Technologies: ASP.Net, IIS, HTML

Programming Languages: C, C++, PL/SQL and T-SQL

PROFESSIONAL EXPERIENCE

Confidential, IL

Oracle PL/SQL Developer

Responsibilities:

• Worked on extracting, transforming and loading data using SSIS Import/Export Wizard.
• Created Tables, Stored procedures and defined functions. Created SQL scripts for tuning and scheduling.
• Developed physical data models, data warehouse models and created DDL scripts to create database schema and database objects
• Migrated all DTS packages to SQL Server Integration Services (SSIS) and modified the package according to the advanced feature of SQL Server Integration Services.
• Provided Full Reporting Life Cycle support using SQL Server Reporting Service 2008.
• Worked with T-SQL to create Tables, Views, Triggers and Stored Procedures.
• Created complex joins and implemented Constraints on tables for maintaining Data Integrity.
• Frequently used to connect to the health care data marts at different locations using C#.Net and ADO.Net for scheduling jobs.
• Designed and developed custom .NET components and user controls using ASP.NET
• Wrote VB Scripts to create custom SSIS transformations, in addition to using built-in SSIS transformations.
• Involved in creating high level ETL architecture for overall data transfer to OLTP, ODS with the help of SQL Server 2005, 2008 Integration services.
• Involved in relational database modeling like, designing the tables, algorithmic diagrams for the input data (entity diagrams), indexes etc.
• Created complex SSIS packages using appropriate control and data flow elements with SSIS Standards like error handling, logging and working with package config files.
• Exporting the database from Local server to the remote server and importing the current running database from remote server to the local DB Server using SSIS.
• Created Tablix reports, Tabular/Matrix reports based on requirements.
• Created Dashboards using SSRS.
• Reduced the overall ETL time by SQL Query performance Tuning. Discussed with user interface and external interface teams over the performance issues and provided solutions.
• Created databases, tables, and fields for data entry, performing database capacity planning.
• Enhanced and deployed the SSIS packages from development server to production server and scheduled jobs.
• Supported the production team when issues rose in the packages.

Confidential

Oracle PL/SQL Developer

Responsibilities:

• Worked on migrating reports from legacy environment to new environment
• Developed reports in SSRS for enforcement of DBMS standards.
• Actively supported business users for change requests.
• Responsible for creating the reports basing on the requirements using SSRS 2008 and Crystal Reports XI.
• Identified the database tables for defining the queries for the reports.
• Optimized queries, tuned to improve performance using function, stored Procedures.
• Transformed the DTS/SSIS database package loads into an automated, self-managed and monitoring solution that streamlined the process by incorporating a script - estimated Time saving 160hrs/ Month.
• Writing reports using Crystal Reports 9.0 and Business Objects.
• Mentored new employees with the existing code and development practice.
• Wrote complex stored procedures, queries, triggers, transactions and cursors.
• Developed reports using efficient data retrieval techniques.
• Developed DTS packages for complex daily migration of data from operational to reporting environments.
• Debug and implementing packages to improve performance.
• Developed SQL scripts and stored procedures for backup file maintenance and other tasks.
• Rotated primary on-call duty for all reports from stake holders, and first-contact support for reporting issues.
• Worked on C# to monitor daily reports has been successfully posted in clients URL. If any files got stuck in outbound Folders, email alerts will be sending to Help Desk, this application has been scheduled using Atomic scheduling software for every 15mins.

Confidential, Plano, TX

Oracle PL SQL Developer

Responsibilities:

• Gather Business rules from the end users
• Created new databases from scratch, refreshed databases for DEV/UAT environments.
• Implemented Database security via User Profiles, Roles and Grants.
• Developed and optimized database design for new applications.
• Data residing in the source tables have been migrated into staging and then final tables.
• Implemented FLASHBACK recovery feature and recovered STANDBY Databases.
• Wrote PL/SQL Procedures, Functions, and Packages for Insert, Update and Delete transactions and optimized for maximum performance.
• Created TRIGGERS to Audit the changes to data in main Tables.
• Created Cursors and Ref cursors as a part of the procedure to retrieve the selected data and present it to the Front-End Team.
• Worked on Database Links to Access data from remote Database.
• Extensively worked on BULK COLLECTS, BULK INSERTS, and BULK UPDATES & BULK DELETES for loading, updating and deleting huge data.
• Worked extensively on Oracle SQL/PLSQL and Hadoop Hive query optimization.
• Work Closely with DBA team during Database and Performance issues.
• Scheduled the Jobs for loading data using DBMS SCHEDULER.
• Implemented external tables and dynamic partitions using Hive.
• Utilized tools like SQL Navigator during development of the application.
• Utilized the DEBUGGING Tool of SQL Navigator to monitor the execution Process of the procedures, functions and packages.
• Enhanced and optimized product Spark code to aggregate, group and run data mining tasks using the Spark framework.
• Designed and developed several complex database procedures, packages. Extensively used features like Cursors, autonomous transactions, distributed transactions, exception handling, Dynamic, pl/sql tables, bulk load methods, optimizer Hints, Cursor variables and returning of multi record set from procedures and functions
• Partitioned Tables using Range Partitioning, List Partitioning and created local indexes to increase the performance and to make the database objects more manageable
• Performed SQL and PL/SQL tuning to improve the performance with the help of SQL Trace, Explain Plan, Indexing and Hints.
• Involve with Business Analysts and Front-End (JAVA) users to develop the Application and fix the bugs.
• Created PROCEDURES & FUNCTIONS by making use of UTL FILE to read and write data to the Database.
• Created VIEWS for generating reports and restricting data access to different users.
• Worked on MATERIALIZED VIEWS with COMPLETE, FORCE refreshes to improve the Performance of the application by making local copies of remote Tables.
• Performance Tuning of complex SQL queries using Explain Plan to improve the performance of the application.
• Extracted data from Flat files using SQL*LOADER.
• Developed Unix Shell Scripts for loading data into the database using SQL* Loader.

Environment: Oracle 11g, SQL Navigator 6.5, SQL Tuning, SQL*Loader, UNIX Shell Scripting, Oracle forms, MS Excel, MS Word.

Confidential

PL SQL Developer

Responsibilities:

• Worked with the Business analysts and the DBA for gathering, business analysis, testing, and implementation.
• Involved in logical modeling and physical modeling of database application and Developed Stored Procedures, Functions, Packages using PL/SQL.
• Involved in creation of Conceptual Modeling covering all the business requirements.
• Loaded the data into database tables using SQL*loader from flat files.
• Developed SQL scripts, cursors, tables, views, materialized views as per the business requirements.
• Performed SQL and PL/SQL tuning and Application tuning using various tools like Explain Plan, Tk-prof and Auto trace.
• Developed Procedures for efficient error handling process by capturing errors into user managed tables.
• Part of a development team for creation and maintenance of custom apps/reports.
• Experienced with bulk collections and for all operations on tables to improve the performance of manipulation language statements.
• Coordinated with DBA in creating and managing tables, indexes, table spaces, auditing and data quality checks.
• Developed UNIX Shell scripts to automate table creation, execute procedures using dynamic SQL statements.
• Worked on Data schema modeling and designed Database Schema using ERWIN tools and implemented Normalization on relational modeling.
• Developed data conversion procedures in PL/SQL. Involved in maintaining batch processing PL/SQL procedures for data extraction for feed creation.
• Developed Shell scripts to automate execution of SQL scripts to check incoming data with master tables, insert the valid data into Customer Management System and invalid data into error tables which will be sent back to sender notifying the errors.
• Extensively used Database Query tuning and performance tuning of reports.

Environment: Oracle 10g/9i, SQL, PL/SQL, SQL*Loader, MS Access, UNIX Shell script, TOAD, Oracle Forms 10g, Reports10g, Perl, UNIX, Windows XP/2000.owb 10g

Confidential, Danville, PA

Developer

Responsibilities:

• Analyzed the business requirements for the enhancements needed in the contract administration application and related policy modules.
• Documented the detailed requirements and prepared DLD for the new enhancements.
• Performed several DDL, DML and TCL operations.
• Created huge database packages with related functions and procedures.
• Created views by joining multiple cash flow tables to show output as a report to the user.
• Extensive PL/SQL programming including Development of new backend packages, procedures and functions to in corporate advanced modules.
• Worked on BULK COLLECT for bulk loading the data into various transaction tables.
• Used UTL FILE to load the data into oracle tables from FLAT, CSV and Text files.
• Added database triggers to some history tables of the database.
• Used file handling in Oracle to read and write into files associated with the modules.
• Implemented various automated UNIX shell scripts to invoke PL/SQL anonymous blocks, Stored PROEDURES/FUNCTIONS/PACKAGES using SQL PLUS session in silent mode.
• Refresh the development and test databases using export/import utilities.
• Worked on inline and correlated sub queries based on business context.
• Implemented various customized Oracle reports using different techniques in Oracle SQL/PL-SQL.
• Extensive and in-depth analysis of the problem tickets to dig out the root cause for the problems.
• Worked with the development team to design, develop, test and implement the application.

Environment: Oracle 10g, 11g, 12c PL/SQL, ETL, SSIS, SSRS, SQL*Plus, SQL*Loader, SQL Developer, TOAD, Crystal reports, Agile, Jasper, UNIX, Tableau, UNIX Shell Scripts