SUMMARY:

• Ten+ years of extensive experience in database development and web applications development for enterprise applications.
• Oracle Database, Oracle SQL, PL/SQL (10 years)
• Oracle Developer Suite Oracle Forms (6 years)
• Web Application Design and Development (3 years).
• MS Access and VBA (4 years).
• Good understanding of -
• Database Development
• Batch Programming
• Object Oriented Programming
• Reporting
• 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, VBscript, ASP, PHP, JavaScript, JQuery, Json, XML, HTML, CSS

Developer Tools: Oracle Developer Suite, MS Access

Reporting Tools: Oracle Reports, Crystal Reports, SQR

Batch Tools: Unix Shell Scripting and SQL Loader

Operating System: Windows, Unix, Linux

PROFESSIONAL EXPERIENCE:

Confidential, OH

Oracle Developer

Responsibilities:

• Requirements analysis and needs refinement.
• In-group interactions to influence design and research code reuse opportunities.
• Developing new reports in BI Publisher.

Technologies: Oracle 12c, SQL, Oracle BI Publisher

Confidential, CT

Oracle Developer

Responsibilities:

• 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.
• Basic Unix shell scripting.

Technologies: Oracle 11, SQL, PL/SQL, Unix Shell Scripting

Confidential, CT

Oracle Developer

Responsibilities:

• Provide production support including troubleshooting, manual process & new plan implementation support
• Support full life cycle- design, development, and testing
• Review and edit requirement specifications, business processes and recommendations related to proposed solution(s)
• Evaluate routine operations to identify opportunities to automate
• Develop stored procedures, functions and packages using PL/SQL implementing health-check automation needs
• Liaise & communicate with global technology/infrastructure/business teams
• Manage resources in accordance with project schedule
• Communicate and apply project standards
• Implement internal framework and business process for reporting tool - Develop and maintain custom reports
• Other job related responsibilities as required

Technologies: Oracle 11g, SQL, PL/SQL

Confidential, CT

Oracle Application Developer

Responsibilities:

• Design, develop, build new and maintain several complex Oracle forms as application screens.
• Maintain dependencies across d forms modules and consolidate internal code modules in 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, AZ

Web Application Developer

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, Json, AJAX, CSS, HTML

Confidential, CT

Programmer / Analyst

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 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, ASPCrystal Reports, JavaScript, MS Access, VBA, VBScript

Confidential, CT

Database and Reports Developer

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, IA

Database Applications Developer

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, CT

University Assistant

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 a home-grown web application RapidForms using PHP, MySQL, Apache on Linux that allowed faculty and staff to create forms and questionnaires, post on the web and collect response data via a simple to use WYSIWYG interface without having any technical form-development skillset.
• 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, CT

Web Application Tester (Intern)

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 and on Rational performance testing suite.

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

Confidential, CT

Computer Lab Assistant + Tutor

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