SUMMARY

• Over 8+ years of programming Lead experience as an Oracle PL/SQL Developer in Analysis, Design, Data Modeling and Implementation of Business Applications using the Oracle Relational Database Management System (RDBMS).
• Good knowledge on all phases of SDLC (Strategic System Planning, Designing, Programming, Testing, Documentation and Presentation) management and implementation.
• Expertise in applying Data Access Technologies Entity Framework and ADO.NET
• Experience in writing complex SQL queries using sub queries, joins and inline views to retrieve data from database.
• Development was done using C#.NET, WPF for .NET 4.5, PRISM 5, Unity as DI Container along with MVVM.
• Profound knowledge and ability to write stored procedures, temporary tables, views, indexes, triggers when required and complex queries including correlated queries and queries with complex joins and aggregate functions.
• Involved in the development, Enhancement and Maintaining of applications in Oracle 9i/10g/11g using SQL, PL/SQL in windows and UNIX environments.
• Strong experience in SQL Development, ETL development using Microsoft SQL Server Integration Service (SSIS), Business Intelligence delivery using Microsoft SQL Server Analysis Service (SSAS), and Reporting Solution using Microsoft SQL Server reporting services (SSRS).
• Extensive experience utilizing programming languages and technologies including ASP.NET, C#.NET, ASP.NET, VB.NET to build analytical applications.
• Solid Expertise in writing UNIX Shell Scripts (korn shell), SQL/PLSQL queries, Procedures, Functions, Packages.
• Reports in different patterns like Group Left, Group Above, Matrix, and Tabular are created by using Oracle APEX.
• Excellent technical and analytical skills with clear understanding of design goals of ER modeling for OLTP and dimension modeling for OLAP.
• Experience with multithreading high performance GUI trading system design using C#.NET.
• Worked on all activities related to the development, implementation, administration and support of ETL processes for large - scale Data Warehouse using SQL Server SSIS.
• Expertise in using tools such as SQL*Plus, SQL Navigator, TOAD, SQL Developer and SQL*Loader.
• Experience in creating data flow diagrams and Entity relation modeling using ERWIN tool.
• Highly experienced in SQL performance tuning and debugging of existing ETL process.
• Good experience in working with PL/SQL Packages, Procedures, Functions, Database Triggers.
• Strong experience in Data warehouse concepts, ETL.
• Knowledge of different schemas (Star schema and Snow-Flake schema) to fit reporting, query and business analysis requirements.
• Strong debugging skills in n-tiered ASP.Net/C# web application.
• Experienced in Dynamic SQL, PL/SQL Collections and Exception Handling.
• Knowledge of working with the Oracle Application server for the Forms and Reports application in various projects.
• Experience with Database Query Optimization and Performance Tuning using Explain Plan, TK-PROF oracle utilities and creating relevant system and user’s documentation.
• Expertise in using Oracle 11g/10g/9i databases.
• Experience in loading data from other databases and text files into Oracle Database using SQL* LOADER.
• Highly skilled in Design, Development, Implementation and Testing of business applications.
• Well experienced working with Waterfall and Agile Methodologies.
• Expert in database skills using SQL, TOAD for debugging applications.
• Experience in designing and developing various reports using Oracle Reports.
• Ability to program UNIX shell scripts in applications that schedule, validate flat file data, execute SQL, archive files or FTP files.
• Experience in creating Materialized Views and DBlinks.
• Worked on several Oracle provided packages such as UTL FILE and DBMS JOB.
• Extensively worked with various SQL scripts for relational databases.
• Excellent communication, analytical, interpersonal and presentation skills.

TECHNICAL SKILLS

RDBMS: Oracle 9i/10g/11g, Forms 6i/9i/10g, Reports 6i/9i/10g, Amazon Redshift

Platforms: Windows 2000/NT, Win XP, Win Vista, Win 7, UNIX

Languages: C, C++, SQL,C#, VB.NET, PL/SQL

Web Technologies: HTML, XML, ETL, C#. NET ASP.NET, ADO .NET

Database Tools: PL/SQL Developer, SQL* PLUS, TOAD

ETL Tools: SQL* LOADER, Oracle ODI

Networking: TCP/IP, FTP

PROFESSIONAL EXPERIENCE

Confidential, Palm Bay, FL

PL/SQL Lead Database Developer

Responsibilities:

• Developed PL/SQL Packages, Procedures, Functions with Business Requirements.
• Extracted data from various databases and loaded into Oracle Database on a monthly basis using SQL* LOADER utility.
• Developed the user interface using ASP.NET, C# .NET and designed UI using CSS, HTML, and JavaScript.
• Developed Flash based Charts using Oracle Apex for various kinds of Dashboards for different type of user Roles.
• Uploading of data from flat files into databases and validated the data with PL/SQL Procedures.
• Designed various Interactive Report and IR based Forms using Oracle Apex.
• Design and development of user interface using ASP.NET, VB.Net, HTML, and JavaScript.
• Coordinating with the front end design team to provide them with the necessary stored package and procedures and necessary insight into the data.
• Designed and developed UNIX shell scripts as part of the ETL process, automate the process of loading, pulling the data.
• Used Amazon Redshift to manage very large datasets and support high-performance analysis and reporting of the data.
• Designed and implemented Data access layer using ADO.NET to connect and retrieve or manipulate database information.
• Responsible for creating and running the batch jobs (korn shell scripts) in UNIX through CRON tab facility.
• Responsible to tune ETL mappings to optimize load and query performance.
• Involved in creation of table spaces, users, privileges, indexes, constraints, triggers and synonyms roles in order to facilitate and upload new products.
• Created ASP.NET User Controls to reduce the complexity of user interface design.
• Created scripts to perform DDL operations for new enhancement in the application using TOAD.
• Used Bulk Collection for better performance and easy retrieval of data.
• Created indexes on the tables for faster retrieval of the data by eliminating the full table scans.
• Involved in production support, like monitoring the performance of UNIX jobs.
• Performed performance tuning using EXPLAIN PLAN, AUTOTRACE.
• Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application.
• Involved in full development cycle of Planning, Analysis, Design, Development, Testing and Implementation.

Environment: Oracle 11g, Toad, TOAD, SQL* LOADER, UNIX, ETL, ASP .NET, C# .NET, Apex, Windows.

Confidential, Houston, TX

PL/SQL Database Lead Developer

Responsibilities:

• Designed local and physical data models for star and snowflake schemas using Erwin.
• Developed and modified Packages, functions and Stored Procedures for data conversions and PL/SQL procedures to create database objects dynamically based on user inputs.
• Involved in new development and enhancements to existing web applications using ASP.NET, ASP.NET MVC, Silverlight, WPF, WCF services and EDGE legacy system.
• Created and modified SQL* PLUS, PL/SQL and SQL* LOADER scripts for data conversions.
• Wrote SQL, PL/SQL, SQL* PLUS programs required to retrieve data using cursors and exception handling.
• Created UNIX shell scripts to automate data loading, extraction and to perform regular.
• Analyzed the requirements and framed the business logic for the ETL process.
• Created UNIX Shell script for sending email to alert users for erroneous records.
• Developing the real time reports for summarizing the integrated data to evaluate the Call center Agents performance and Sales statistics using ASP.Net, C#, Silverlight, WCF and Oracle 10g.
• Developed and maintained REST based web service using ASP.NET WEB API to provide Seminar information.
• Developed data model, SQL Queries, SQL Query Tuning process and Schemas.
• Generated server side PL/SQL scripts for data manipulation and validation and materialized views for remote instances.
• Created scripts to create new tables, views, queries for new enhancements in the application using TOAD.
• Wrote heavy stored procedures using dynamic SQL to populate data into temp tables from fact and dimensional tables for reporting purpose.
• Performed optimization using ROWID pseudo column to speed up data access from the data warehouse.
• Created partitioned tables, partitioned indexes for manageability and scalability.
• Involved in SDLC gathering requirements from end users.

Environment: Oracle 11g, SQL* PLUS, TOAD, Asp .NET, C# .NET, Perl, UNIX, SQL* LOADER.

Confidential, Warren, NJ

Oracle PL/SQL Developer

Responsibilities:

• Created heavy stored procedures for financial transaction by using procedural parameters & worked with packages, blocks & exception handling.
• Designed and Developed Oracle database Tables, Views, Indexes, and Synonyms with proper privileges.
• Developed PL/SQL packages for generating various feeds from oracle database using UTL FILE utility in the client’s secure data transmission server.
• Developed UNIX scripts for transmitting files from the secure server to the customer specified server, using various FTP batch processes.
• Used SQL*Loaders to download the data into database from the text files and spread sheets.
• Extracted data from the XML files transmitted to the bank and loaded them efficiently into oracle temp tables for day to day customer financial transaction reconciliation.
• Developed UNIX scripts for sending mails to the bank and the business team, when the external feeds to the bank are received.
• Involved in supporting/fixing production defects and day to day business transaction issues.
• Used SQL Navigator, a popular tool which increases user productivity and application code quality with rich features to manage database objects, develop and debug PL/SQL and create, execute and optimize SQL queries.
• Designed and implemented client-server application using Oracle Forms 10g.
• Involved in the generation of User Interface using oracle forms by extensively creating forms as per the client requirements.
• Developed various new reports from scratch utilizing Oracle Reports 10g for day to day validations.
• Created various adhoc reports as of when required for the production analysis and bug fixing.
• Converted reports to browser supportable XML format.
• Extensively utilized TOAD for performance tuning by generating explain Plans.

Environment: Oracle Database 11g, UNIX, Windows XP, SQL * Loader, TOAD, SQL Navigator, Oracle Reports, Oracle Forms, Discoverer, PL/SQL, UNIX, Perl, XML.

Confidential, St. Louis, MO

PL/SQL developer

Responsibilities:

• Involved in development of SQL Scripts, Stored Procedures, Functions, Database Triggers and Packages using SQL and PL/SQL as per the document requirements to in corporate the changes.
• Used SQL* Loader to load data from external system and developed PL/SQL programs to dump the data from staging tables into base tables.
• Created Materialized Views and Views according to the requirement.
• Written complex SQL statements using joins, sub queries and correlated sub queries.
• Performed the requirement analysis, process and data flow analysis, functional specifications, data modeling, physical database design, forms design and development, data conversion, performance analysis and tuning.
• Used Autosys job scheduler to schedule, run and maintain batch jobs.
• Developed several reports using Reports 10g to meet the client requirements and necessities.
• Developed ER diagrams/ Dimensional diagrams for business requirements using ERWIN.
• Created various database objects like Tables, Sequences, Functions and Indexes.
• Made enhancements with the existing packages for better performance and providing on-going support to existing applications and troubleshooting serious errors when occurred.
• Involved in the complete life cycle of the product from requirements gathering to end of system testing.
• Generated PL/SQL reporting and Unix Scripts to notify process failure/success.

Environment: Oracle 10g, SQL* PLUS, ERWIN, Toad, SQL* LOADER, Forms 10g, Reports 10g, UNIX Shell Scripting, Autosys, Windows XP.

Confidential 

Jr. Oracle Developer

Responsibilities:

• Developed PL/SQL Packages, Procedures, Triggers, Functions, Indexes and Collections to implement business logic using SQL Navigator.
• Generated server side PL/SQL scripts for data manipulation and validation and materialized views for remote instances.
• Created database Tables, Views, Stored Procedures.
• Involved in migrating database from Oracle 9i to 10g database.
• Executing and maintaining the data warehouse extract transform load (ETL) process.
• Developed UNIX Shell scripts to automate repetitive database processes.
• Involved in designing of Data Modeling, Design Specifications and to analyze Dependencies.
• Generated reports and worked extensively in developing, deploying and testing Oracle Forms and Oracle Reports using Oracle.
• Tested new enhancements and bug fixes before deployment into the production environment.
• Documented technical as well end user manuals.

Environment: Oracle 9i/10g, Oracle Forms 6i, Oracle Reports 6i, SQL Navigator, UNIX.