Qualifications Summary

• Experienced, professional IT Developer with 10 years of PL/SQL, NET, and VB6 on Oracle and SQL Server databases.
• Fluent understanding of all stages of SDLC process as well as expertise in design and development using Oracle 10g/9i/8i in developing stored procedures, functions, database triggers, packages, objects and collections and other database objects using PL/SQL and writing complex SQL Queries.
• Expert in the design, development and implementation of complex multi-tier component based applications.
• Extensive experience in backend development using PL/SQL with sound knowledge in Relational Database Management System.
• Solid track record in collaborating with DBAs on Database Design Tables, Views, Constraints, Indexes, Privileges, Sequences, Synonyms, DB Links and Performance Tuning Using Explain Plans.
• Designed and developed client server n-tier architecture using Visual Studio.NET, and Visual Basic 6.0.
• Expert communication, interpersonal, and organizational skills.

Skills

• Languages Technologies: Oracle PL/SQL, VB.NET, C , Visual Basic, ASP.NET 2.0 AJAX, VBScript some JavaScript , HTML, DHTML, ActiveX, Windows API, MS Access, MTS and COM , C, COBOL II, Windows 95/98/NT/2000/XP, DOS, UNIX.
• Databases: Oracle 7.3 10.2 on Solaris, SQL Server 7, DB2
• Software: Visual Studio.NET Enterprise, PL/SQL Developer, SQL Navigator, SQL Server Management Studio, T.O.A.D, Microsoft Visual InterDev 6.0, SyncSort, ActiveReports, SourceSafe, Beyond Compare, OpalisRobot, MS Office 97/2003, LotusNotes 4.x.

Professional Experience

Confidential

Senior Web Specialist

• Translated and developed business and functional requirements into a C ASP.NET 2.0/MS SQL multi-tier web-based solution utilizing GridView, FormView, UpdatePanel and UpdateProgress. This application processes expenditure data for New York City's state and federal reimbursement claims, as well as:
• Categorization of expenditures according to agency-appropriate level of detail.
• Detailed budgeting capability as per regulation requirements
• Tracking of expenditure data by geographic areas and the maintenance of data for specific programs.
• Built a custom version of the GridView control to user specifications with specialized paging and sorting options distributed and utilized company-wide .

Confidential

Senior Developer/Technical Lead

• Worked as a lead programmer and developed Oracle stored procedures, optimized queries and indexed tables to support advanced billing program in VB.NET for generating weekly bills for targeted customers. Program generates customers' weekly statements summarizing CDR usage behaviors and associated charges. At month's end, all customers are billed for total monthly usage plus specific fees/credits where applicable.
• Wrote stored procedures and queries featuring database links to support a complex web-based C program utilizing .NET framework for maintaining an intricate hierarchy of wholesale telecom service providers enabling users to facilitate proper billing of IDT's wholesale clients via assignment of parent/child and service/rate relationships to individual and groups of accounts.
• Altered the data design for resolution of differences in informational structure and billing practices.
• Extended and modified existing PL/SQL packages and procedures to accommodate the varied layouts.
• Designed and optimized complex PL/SQL queries for use in detailed reports running in Brio and off of Web pages.
• Created and maintained PL/SQL modules to support billing reconciliation process by providing details surrounding miscellaneous credits, call detail records, and rejected PIN requests.
• Wrote custom PL/SQL procedures to load summarized daily call data in staging tables for load into Oracle Financials billing database.
• Monitored jobs and updated various teams for data discrepancy in other interfaces. Resolved issues related to imports of data from other interfaces.
• Worked as a lead programmer and designed various approach documents of PL/SQL Modules based on the requirement specification.
• Wrote complex front-end queries to display data on front-end screens.
• Interfaced with Business users for better understanding the reporting requirements. Responsible for interfacing with the client as part of the requirements engineering team to finalize the project scope.
• Coordinated with users to determine requirements for data extractions and prepare analytical reports.
• Created various indexes that improved the performance of the modules.
• Utilized performance tuning for PL/SQL programs in Oracle 9i to reduce the runtime and to increase efficiency.
• Developed packages and stored procedures and triggers in Oracle PL/SQL to enable the smoother execution of complex data.
• Involved in design and project analysis including, user interaction and preparing Technical Specification Documents.

Confidential

Senior Developer

• Built, designed and deployed numerous Visual Basic COM objects to extend and enhance QuickSell Commerce, an award-winning merchandising and inventory control software application subsequently acquired by Microsoft that employs a SQL Server 7 back-end, Windows DNA architecture, and customizable Active Reports. Expanded system's functionality using complex unions, joins, and innovative programmatic design to create, expand, populate and update the database tables.
• Enabled dynamic, custom display messages on cashier screen using SQL, HTML, VbScript, and JavaScript.
• Designed and created custom graphical receipt templates in XML format to facilitate application integration, data sharing, and Web access.

Confidential

Developer/Analyst

• Played a major role in the team that designed, constructed, deployed and supported a comprehensive web-based international system used by 400 customer service agents on local and remote sites for maintaining customer information, billing, call detail records, fraud protection, reporting, and executing financial transactions. Lightweight, end-user deployment-free application featured scalable and robust n-tier configuration with business rules and processing encapsulated into COM DLL libraries in VB back-end tier comprised of a complex data schema accessed by PL/SQL stored procedure packages and a web-based presentation tier utilizing a combination of DLLs, ASP Pages, HTML, CSS, and DHTML.
• Maintained and expanded the forerunner to the multi-tier web-based application. Converted complex user specification details into working software designs with extensive use of PL/SQL stored procedures and triggers and a Visual Basic front end with packaged DLLs. Responsibilities included:
• Implementation of a plan for pre-allocation of a restricted number of free minutes on accounts.
• A Customer Security Question/Response to replace passwords for enhanced security.
• An automated Charge Back system.
• Designed, implemented, and maintained a highly optimized wholesaler batch management system to input sales personnel's specifications, arrange requests in prioritized queues, and allocate system resources to process customer information expeditiously. Functioned as Technical Lead on this project.
• Guided the creation of a scheduled program to request a single consolidated message in place of redundant, standard email requests triggered by transactions executed on the same day. Innovated unique logic with optimized SQL for selecting the appropriate replacement message based on the combination of primary requests in the database for each account. Revamped mass email program with batch capabilities for more efficient dispatch of static/dynamic messages, documentation of retried and discarded failed messages, and timely personnel notification on the status of various jobs system-wide.