SUMMARY:

• Strong database server - side development experience utilizing SQL Server and Oracle.
• 15+ years of hands on experience developing applications utilizing C#, VB.NET, VB6, VBA, and Perl.
• Working knowledge of PowerBuilder, Perl and TIBCO Spotfire.
• Extensive experience developing HL7 messaging systems which include segments ADT, ORU, ORM, SIU, MDM etc.
• Excellent IT experience in the finance, mortgage, medical, manufacturing, oil and gas industries.
• Extensive knowledge and experience with accounting (cost, financial, managerial, governmental, oil and gas, and taxes)
• Extensive experience utilizing reporting tools such as Crystal Reports, Active Reports, and Ultipro.
• Hands on experience translating business requirements into creation of database objects: Tables, Indexes, Constraints, Triggers, Stored Procedures, Packages, Views etc.
• Extensive experience in business analysis, design, development, testing and implementation of software applications.
• Solid experience with SQL Plus, Oracle TOAD, Query Analyzer, Enterprise Manager, and SQL Developer.
• Solid experience with various Oracle versions (8i, 9i, 10g, and 11g).
• Strong experience using Oracle DBLinks, Synonyms and Materialized views.
• Solid experience developing COM.
• Very solid experience with GUI design and using third-party ActiveX controls such as those from Infragistics, Sheridan, FarPoint, etc.
• Working knowledge of Bootstrap, JQuery, AngularJS, CSS, and Entity Framework.

PROFESSIONAL EXPERIENCE:

VBA Macro Developer

Confidential, Raleigh, North Carolina

Responsibilities:

• Wealth Planning Questionnaire
• Goal Profile Questionnaire
• Goal Level Performance
• Investment Suitability (Product FIT)
• Executive Services Report Generator.

Environment: Web Services, Agile, JIRA, SharePoint, EDMS, VB6, VBA, .NET 4.5, JSON, SQL Developer, and Oracle TOAD.

Software Developer

Confidential, Houston, Texas

• Maintaining Wells Cost Tracking Tool which is an ASP.NET application used by Cost planners and Drilling Engineers.
• Gathering user requirements and adding new functionalities to Wells Cost Tracking Tool.

Technologies: Microsoft .NET Framework v4, ASP.NET with Ajax extensions, C#, Oracle 11g, Aspose.Cells, TIBCO Spotfire

Environment: Oracle 11g, Oracle ODP.Net, Stored Procedures and Packages, Landmark EDM, ASP.NET, C#, Ajax, Aspose.cells, ADO.NET, COM, Visual Source Safe, TFS, Agile, Citrix, TCP/IP, Web Services, MVC (Model View Controller)

Visual Basic Developer

Confidential, McLean, Virginia

• MPS Cash Management System (CMS) which has subsystems Cash, Journal, Wire, and 104S.
• MPS Multifamily Asset Management Operating System (MFAMOS).
• MPS Multi-Suite Investment Reporting (MSIR).
• MPS Accounting Changes.
• MPS Underwriting.
• MPS Purchase Changes.
• MPS Ledger Interface.
• MPS Fee Tracking Changes.
• MPS GLIMRS.
• Daily activities included translating functional specifications into technical design and efficient code, developing documentation for design, testing and deployment. Participation in design meetings code and peer review sessions. Rewriting Visual Basic and Microsoft Access legacy applications to C#.

Environment: VB6, Rapid SQL, IBM Rational ClearCase, IBM Rational ClearQuest, Sybase, SQL Server, Oracle, MS Access, Visual Basic, VB.NET, Perl, JavaScript, Autosys, ADO, ADO.NET, COM, Crystal Reports, Cognos, Citrix, TCP/IP.

Software Engineer

Confidential, Houston, Texas

• Developed an HL7 engine consisting of a set of applications (HL7 Manager and DigiHL7) from scratch including both the back-end processing and GUI end-user interface. This HL7 engine has been tested and validated by the US Veterans Administration and currently in use at several major health care facilities. It handles many HL7 message types including ADT, ORM, ORU, MDM, SIU etc.
• Developed DV Player and Remote Player applications that play patient study images.
• Developed securekey.dll used for applications licensing.
• Maintained and added functionalities to Rolodex application which handles fax transmissions, emailing and print jobs. Added functionality to Rolodex to interface with both MS Fax and RightFax APIs.
• Developed application named Gateway Monitor which monitors CPU usage of applications and processes that run unattended. It has functionality to shut down and restart applications and processes based on user-configured settings regarding CPU usage.
• Migrated VB6 applications to VB.NET.
• Test planning and execution, support for user-testing and implementation, application enhancements based on user-requests, documentation and drawing out proposals for new functionality enhancements, gathering requirements from customers, resolving issues, updating knowledge-base with issues and resolutions, and working with other programmers in a team environment to develop systems for business processes, monitoring and maintaining database objects, installing and trouble-shooting software and constantly interacting with clients and Customer Care Department in enhancing software as well as resolving application related issues.

Environment: SQL Server, Access, VB6, Visual Studio, VB.NET, ADO, ADO.NET, COM, Crystal Reports, Visual Source Safe, Citrix, TCP/IP.

Visual Basic Developer

Confidential, Houston, Texas

• Maintained and customized FBO Manager Visual Basic application which handled POS transactions (mostly Fuel transactions) for the Aviation industry.
• Created and maintained data link libraries upon which FBO Manager relied for proprietary and Bank Card processing.
• Maintained and customized PRIZM which is a Visual Basic application used to run all ConocoPhillips branded FBO locations.
• Maintained and customized Concierge Monitor application used for catering, hotel reservations, car rentals, flight reservations etc.
• Maintained and customized VeederRoot application for aircraft fueling and defueling.
• Maintained and customized FuelMaster application for fuel inventory management.
• Maintained and customized CC Settle and Settle66 applications for daily or periodic settlement of credit card transactions between Banks and FBO locations.

Environment: SQL Server 2000, Oracle 9i, Access, VB6, Visual Studio 2003, VB.NET, ADO, ADO.NET, COM, Remedy, Test Directory, Manvel, COGNOS, Crystal Reports XI, Data Dynamics Active Reports, and Visual Source Safe.

Confidential, Sugarland, Texas

VB6 Developer /Ultipro Administrator

• Customized, maintained and added new functionalities to Hour Pay application which was designed to handle payroll processing for employees on offshore rigs located both in USA and Overseas. It made extensive use of SQL triggers and stored procedures as well as batch processing and transfer of financial data to COGNOS applications.
• Responsible for maintaining NICS application which was designed to handle all aspects of inventory control for tools and heavy equipments used on offshore oil rigs. This application applied various accounting rules and standards for inventory valuation and depreciation. It relied on SQL Server 2000 and Access 2003 as backend.
• Developed Merge Excess application which handled transfer of surplus inventory from one oil rig platform to another. This application was developed using VB.NET, SQL 2000, Access 2003, Crystal reports, ADO.NET, and WinForms.
• Created corporate reports using Cognos Impromptu, Ultipro P1, US Explore P1 and US Admin. (These are reporting, human resources, and payroll management tools from Ultimate Software Corporation).
• Other responsibilities included creating Crystal Reports for the Human Resources and Payroll departments.

Confidential

Visual Basic Developer

• Interacted with clients over the phone and email during daily customer support calls.
• Created and designed workflow documents and documentation.
• Developed new Visual Basic applications, enhanced existing ones and managed complete applications from user requirements to their full development cycle.
• Created database objects such as tables, triggers, indexes, stored procedures etc.

Confidential, Sugarland, Texas

Senior Systems Analyst/Developer

• Redesigned and migrated existing Access and old-versioned VB applications to VB6.
• Effectively supported production engineers by developing and maintaining major Visual Basic applications.
• Developed QC2000 application (used for quality control on electronic components including circuit boards).
• Developed QC2000Viewer application (used to document and report results of quality tests).
• Developed Print DMR (which was a VB6 application that integrates Crystal Reports and/or Data Dynamics Active Reporting tools to deliver quality management reports via print).
• Developed LH2000 which was a VB6 application that was useful in every manufacturing aspect of circuit boards, cables, harnesses, chips, and various electronic components.
• Worked as Team Lead during development and deployment of RMA Tracker (a corporate-wide application that handled all aspects of RMA functions for every client regardless of size or unique needs).
• Analyzed with the Business Administrators, Engineers and Customer Service Agents collectively while gathering user-requirements, creating work-flow documents and middle tier components which enclosed the individual components of Data Access.
• Created sequence of mathematical algorithms completely encapsulated in VB objects for production Turn-Around-Time (TAT) calculation and reporting.
• Created sequence of objects such as Tables, Views, Stored Procedures, and Triggers.
• Developed and deployed ToolMaster application (used by production engineers to handle tool disbursement and schedule tool calibration).
• Developed and deployed Applied Lean Pull (a console VB6 application which ran constantly unattended handling data transfer between Confidential and its major customers such as Applied Materials Corporation).
• Developed and deployed Emulex Data Console (another console VB6 application) that handled data transfer and CSA communication between Suntron and Emulex Corporation.

Environment: SQL Server, AS400, Oracle. Access, VB6, COM, ADO, RDO, DAO, Oracle 9i, Oracle Discoverer, ASP, PeopleSoft, Crystal Reports, Data Dynamics Active Reports, SQL Query Analyzer, SQL Enterprise Manager, SQL Navigator, and Visual Source Safe.

Confidential, Natick, MA

VB6 Developer

• Worked in a team environment and involved in the design and development of Deal Builder and Deal Manager Applications which is a set of an integrated equipment lease/loan portfolio management and accounting system designed for use within the leasing industry.
• Assisted a group of professionals to efficiently and effectively move proposals from inquiry to being accepted, and becoming active leases/loans.
• Involved in the development of upgrades to Deal Builder, Deal Manager, and Deal Analyzer applications.
• Worked with Business Analysts in development of modules, functions and stored procedures for Lease/Loan Maintenance, Billing/Invoicing, Accounts Receivable Processing, Collections Management, Debt Management, Accounts Payable Processing, Revisions and Terminations, Sales/Use Tax Processing, Fixed Assets, Equipment Sales, Securitization Processing, General Ledger and Archiving for the Deal Manager application.
• Developed data link libraries used by Deal Manager which resulted in effective computerized and streamlined lease system and thus resulted in more effective control and analysis.
• Designed and developed stored procedures under ORACLE to handle the sequence of business transactions like Cash posting, Billing/Accounts receivable.
• Deal Builder and Deal Manager were designed using n-tier architecture with the usage of sequence of DLLs written in Visual Basic and ActiveX controls and display the presentation screens using HTML viewer controls.

Environment: VB6, ADO, XML, HTML Viewers, COM/DCOM, VS Flex Grid, Win Forms and Oracle 7, JAVASCRIPT, VB SCRIPT.

Confidential

Visual Basic Instructor

• This was a part-time (2 hours a day) teaching assignment that involved teaching students Visual Basic 6.0 programming techniques.