summary of skills

Ten years of extensive experience in database development and web applications development for enterprise applications.

Extensive experience in

• Client-Server application development using Oracle PL/SQL and SQL PLUS, Oracle Forms and Oracle Reports.
• Oracle Database, Oracle Developer Suite.
• Writing SQL queries, PL/SQL programming.
• Writing packages, stored procedures, database triggers, exception handlers, collections, cursors, and cursor variables.
• MS Access and VBA for enterprise as well as private, non-enterprise solutions over 4 years .
• MS SQL Server as a developer

Good understanding of -

• Web Application Design and Development using PHP, ASP
• Unix Shell Scripting and SQL Loader
• Object Oriented Programming in C , Java
• Mod-plsql
• SQR, Crystal Reports
• Excellent Communication and Interpersonal / People skills
• Experienced in encouraging and delivering Quality performance
• Organized, self-motivated and detail-oriented problem solver
• Customer Focused

Technical Skills

• Databases : Oracle 11g/10g/9i/8, MySQL, MS SQL Server 2000/7.0/6.5
• Languages : SQL, PL/SQL, Java, VBscript, ASP, PHP, JavaScript, JQuery, AJAX, XML, SQR
• Developer Tools : SQL Plus, SQL Loader, SQL Navigator, TOAD, SQL Developer,
• Oracle Developer Suite, Crystal Reports
• Case Tools : MS Visio, Oracle Designer
• Reporting Tools : Crystal Reports, Oracle BI Publisher
• Operating System : Windows, Unix

Training

• Technical : Oracle BI Publisher, Software Testing,
• Use-case diagramming
• Professional : The 7 Habits of Highly Effective People

professional Experience

Confidential

Oracle Application Developer

At ESPN, the technology group I was part of, built and maintained the scheduling application suite which was an integral part of the on-air production services providing TV-programming information across various work groups that both produced and consumed this data. As such, the application suite's availability and accuracy was vital for the day-to-day functional needs of many work groups and had wide visibility. The application suite was completely written in Oracle Forms that had become very complex with multiple reference forms, several layers of stacked canvases, extensive use of tabbed canvases and multi-node navigation across these various screens. Moreover, since it used large historical, current and reference data-sets, the optimal performance of SQL queries and Oracle forms during runtime was vital.

Responsibilities:

• Design, develop, build new and maintain several complex Oracle forms as application screens.
• Maintain dependencies across referenced forms modules and consolidate internal code modules in reference forms.
• Maintain and develop several old and new Oracle reports and update the access control system.
• Develop stored procedures, functions and packages using PL/SQL implementing core business rules.
• Enhance old and develop new SQL queries feeding data to several informational screens and reports.
• Maintaining clear communication with the Team developers about assignments and inter-dependencies.
• Unit and regression testing and technical documentation of all deliverables.
• Preparedness of delivering as per production cycles following all procedures and obtaining required sign-offs.
• Prepare detailed documentation of modules/work done that is to be moved to production and work closely with the QA team to ensure accuracy of desired results.

Technologies: Oracle 11g, SQL, PL/SQL, Oracle Forms and Reports 11g

Confidential

Web Application Developer

Confidential took on an in-house development project for their client, Diamond Resorts International DRI and put together a web development team to build specific modules in collaboration with DRI's own development team. The project was to revamp an old reservation system to accommodate the growing needs and new practices of DRI. The modules that we were working with were to be operated by DRI's reservation specialists who would assist the guests in securing their reservations using this system this was in parallel to a guest-operated online reservation system being developed simultaneously by DRI's own team. There were several overlaps between the old system which was still in use as well as in the new systems being developed by the various teams hence it was of utmost importance to look-out for existing code as well as to build all-inclusive, extendable components when developing new. The biggest challenge was to avoid stepping on another developer's toe since parallel development effort was happening across the board.

Responsibilities:

• Requirements analysis and needs refinement in daily stand-up meetings with the client's Business Analysis BA group.
• Determination and conveying scope and timeline of deliverables updated every day.
• Validation of deliverables in conferences with the Quality Assurance QA and BA teams.
• Providing production support of various kinds including break-fixes, small/med/large enhancements, infrastructure and application/product upgrades.
• Developing stored procedures, functions and packages using PL/SQL implementing core business rules finding and reusing or revamping existing code or writing new code.
• Build new interactive web pages using Mod-plsql, JavaScript and JQuery, employing existing CSS templates and AJAX for dynamic data calls as well as common core business-logic in PL/SQL for inventory and accounting rules.
• Apply patches to the existing reservation system to accommodate high-priority new rules and practices.
• Maintaining clear communication with team leader and fellow developers about assignments and progress of common widgets and source control.
• Unit and regressing testing and test and technical documentation of all deliverables.

Technologies: Oracle 11g, SQL, PL/SQL, Mod-plsql, JavaScript, JQuery, AJAX, CSS, HTML

Confidential

Programmer / Analyst

At Confidential, I worked in the Information Technology Services ITS /Enterprise Systems ES for Yale School of Medicine sub-divisions in the order listed. This group caters to the custom application needs of various departments at Yale and particularly the Med School where I maintain existing software applications that may be developed in-house or purchased from a vendor or an open-source solution that we implemented.

Responsibilities:

• Providing production support of various kinds including break-fixes, small/med/large enhancements, infrastructure and application/product upgrades.
• Providing team support for infrastructure and core-technology upgrades and migrations.
• Fulfilling daily/periodic data requirements across systems handling loads, feeds and notifications.
• Requirements analysis and needs refinement.
• In-group interactions to influence design and research code reuse opportunities.
• Developing stored procedures, functions and packages using PL/SQL implementing business rules.
• Oracle Forms and Reports development for various administrative and reporting modules.
• Mod-plsql modules for public-facing Training Management System used university-wide.
• Communication-hub for major database upgrades from 9i to 10g to 11g and migration of data and applications testing to UTF-8 modifying the build environments to support the new versions.
• Unix shell scripts and Windows batch scripts for a variety of automated/scheduled data-loads, error-checking and logging between systems.
• Supporting enterprise applications in Microsoft technologies like MS Access, ASP and SQL Server 2000 DTS and Crystal Reports for the Yale Medical Group.
• Responsible for solution documentation, unit testing and integration testing.
• Trained in Oracle BI Publisher, Software Testing, Use-case diagramming.

Technologies: Oracle 11/10/9, SQL, PL/SQL, Oracle Forms Reports, Mod-plsql, Unix Shell Script, ASP,

Crystal Reports, JavaScript, MS Access, VBA, VBScript

Confidential

Database and Reports Developer

confidential is an IT company that develops software products for the financial industry with Credit Unions and small Banks making up for most of their customers. I work in the Custom Solutions group that cater to the various back-end processing and reporting needs of OSI's customers using the structure and data provided by the core application. The nature of operation of this group required me to work on a case-to-case basis and invariably involved me in multiple phases of a project from requirements analysis through post-delivery support.

Responsibilities:

• Requirements analysis and client interaction for needs refinement.
• In-group interactions to research code reuse opportunities.
• Developed stored procedures, functions and packages using PL/SQL implementing business rules.
• Developed programs using Structured Query Reporter SQR the language of choice at OSI to generate reports that are run in batch mode or on-request mode. Reporting functions varied from updating of certain customer accounts through creating data extracts to send to third-party agencies.
• Responsible for solution documentation, unit testing and integration testing.
• Occasionally added and modified core product functionality.
• Version control using PVCS, client delivery and support.

Technologies: Oracle 10g, SQL, PL/SQL, SQR

Confidential

Database Applications Developer

I was brought into this Oracle Reports project as a Project Manager Developer. The project requires developing several reports to be used by Chiefs, Kernels, Majors and other administrative staff to look at summarized data covering various aspects of the officer's activities.

Responsibilities:

• Solely responsible for all stages of the development lifecycle.
• Requirements gathering, analysis and design of the reporting systems and the individual reports.
• Development and testing of various Reports and associated Forms using Oracle Developer Suite 10g.
• Created several views, pivot-views etc. for maintainable developer objects.
• Optimized report queries resulting in reduced loading time of complex reports.
• Created Developer's Documentation and User's Manual.
• Debugging, optimizing and integration of reports that were already in place.

Technologies: Oracle 10g, SQL, PL/SQL, Oracle Developer Suite 10g

Confidential

Database Developer

The project was, in its entirety, a huge set of data transformation and hygiene modules that clean-up Kodak's customer data being fed from various sources. The data was destined for Kodak's proprietary database system where data-mining and reporting processes will be run. I was brought in during the last-leg of the project. This was a high-speed development environment.

Responsibilities:

• Primarily responsible for debugging existing PL/SQL code that was written by others.
• Developed stored procedures, functions and triggers using PL/SQL implementing business rules.
• High-speed development with 5 co-developers, business analysts and project manager.
• Responsible for integration of new and fixed packages with existing packages.
• Responsible for unit testing and integration testing

Technologies: Oracle 9i, SQL, PL/SQL

Confidential

Database Developer

confidential was a full service web-based application for real-time Rating, Quoting, Submission, Underwriting, Proposal Generation, Policy issuance. Being an Internet-based solution it was easily customizable, reliable, scalable secured solution for Underwriters, MGAs, BGAs, and Wholesalers.

Responsibilities:

• Participated in requirements gathering, analysis and data modeling.
• Designed schema, normalized design, created indexes, constraints and views.
• Developed stored procedures, functions and triggers using PL/SQL implementing business rules.
• Designed and developed Reports and associated Forms using Oracle Developer Suite.
• Responsible for unit testing and integration testing
• Participated in data loading using SQL Loader and created Unix Shell Scripts.
• Helped in performance tuning and optimization.

Technologies: Oracle 9i, Forms and Reports 9i, SQL, PL/SQL, Unix Shell Scripting

Confidential

University Assistant Contract Developer

Design, development and consulting on various projects On several projects I was the acting project manager solely responsible for all phases of the development life-cycle.

Responsibilities:

• Design and development of databases in MySQL and MS SQL Server to meet various application needs mostly web applications.
• Automation and execution of data transformation scripts and data uploads in Unix shell and Windows batch scripts.
• Consulted in web application design and development
• Visualized and built web-front-ends written in PHP, ASP, XML, JavaScript, VBScript, HTML, DHTML and CSS.
• Designed and developed the web application RapidForms using PHP, MySQL, Apache as a Contract Developer.
• Created several applications in MS Access complete with tables, queries, forms, reports, macros and substantial VBA program modules.
• Consulted on SCSU's ePortfolio initiative involving MS SQL Server 2000 and XML and migration from MySQL to SQL Server 2000. Installed MS SQL Server 2000 and set up users and databases.
• Consulted on SCSU's Grants department's initiative for paperless office and document routing solutions involving MS SQL Server, ASP.NET and proposed BizTalk server.
• Unit testing and documentation of the applications and co-ordination with design team and test groups.

Technologies: Oracle 9i, Forms and Reports 9i, SQL, PL/SQL, MS SQL Server, MySQL, .NET, XML, MS Access, VBA, Unix Shell Scripts

Confidential

Web Application Tester Intern

The project involved end-to-end business communication and information service solutions between the client, its associates and its customers. The objective of the Facworld project was to provide online account access, enabling users to exchange information about their re-insurance needs, available coverage and billing info.

Responsibilities:

• Involved in studying Conceptual and Logical data designs that meet business requirements.
• Developed several Forms and Reports MS Access.
• Involved in database tuning suggestions like Index management, SQL tuning, Roll back segment management according to the customer requirements.
• Exposed to data warehousing and data mining.
• Involved in Unit testing, Integration testing, System Testing and Stress Testing for testing the Application.
• Before the implementation of the Lotus Notes suite by the company, I designed and developed a bug tracking system in MS Access complete with several forms, sub-forms, reports, macros and substantial VBA program modules. The application was deployed as a two-tier system.
• Participated in release testing.
• Participated in automated testing.
• Obtained training and certification on Rational performance testing suite.

Technologies: Oracle 8i, SQL, PL/SQL, Java, MS Access, VBA

Confidential

Computer Lab Assistant Tutor

I was hired as a Lab Assistant. During my term there, I applied my learning to cater to the application needs in my department. I designed and developed an electronic sign-in system using MS Access and VBA. This did away with the paper-based sign-in system and greatly simplified and enhanced the reports that were generated.

I was also hired as a Tutor between September 2000 and July 2001 in the subjects of Mathematics, Physics and Computer Programming.

Responsibilities:

• Performed Lab Monitoring.
• Offered computer systems help to users of the computer labs.
• Developed an electronic sign-in system using MS Access and VBA which was in use till at-least June 2005.
• Tutoring in Mathematics up to Pre-calculus level, Physics, C Programming, VB Programming and Database Design.

Technologies: MS Access, VBA