SUMMARY:

• IT Professional with more than 19 years in Design, Development and Systems Analysis.
• Experienced with major databases: SQL Server, Oracle, Informix, DB2;
• Comprehensive training in Confidential, SQL Server, C#, .NET Framework, ADO.NET, ASP.NET
• More than 10 years of hands - on programming experience with UNIX operating systems.
• Led/facilitated RAD/JAD sessions.
• Knowledgeable of all phases of the Software Development Life Cycle (SDLC).

SKILL:

Databases: Microsoft SQL Server, Sybase SQL Server, Oracle, DB2 and Informix.

Platforms: HP UNIX, SCO UNIX and VAX.

Languages: SQL, PL/SQL, ESQL/C C#, .NET Framework, ADO.NET, ASP.NET, C/C++ languages, Unix C & Unix Shell Script, Visual Basic for Applications (VBA).

Software: Sybase Confidential, Confidential Foundation Class (PFC), .NET, ClearCase, Requisite Pro, ClearQuest, Erwin Case modeling tool, PVCS, Microsoft Access, Project and Source Safe, TOAD (Tool for Oracle Application Developers), Sybase EA Server, and XML/XLST.

PROFESSIONAL EXPERIENCE:

Confidential, Chicago, IL

Sr. Application Developer/Programmer

Environment: Sybase Confidential 12.5, UNIX OS and shell programming, Informix database stored procedures/triggers, middle-tier components, web services, JIRA, Agile

Responsibilities:

• I am working remotely as a developer with an Agile process on stories in multiple sprints of a project on a hotel reservation system.
• I’m working with Business Analysts and management to define changes, create mockups that are approved by users then I design, develop and document the changes that will be mirrored in the other clients.
• In cross-functional and off-shore groups we’re upgrade existing Spirit and Maintenance programs by replacing a third-party process with an in-house version in a very compressed time frame.
• I am also modifying many existing windows and user objects to add new or changed features.

Confidential, Boise, ID

Sr. Developer/Programmer

Environment: MS SQL Server, SQL Server Management Studio, Sybase Confidential 11.5 with PFC, Oracle 10, PL/SQL with new database tables, triggers, and packages, web services

Responsibilities:

• Worked on different Stories in Sprints as the company transitioned to an Agile environment.
• Converting Oracle Confidential AESOP program to EQAI program on Microsoft SQL Server database. Adding enhancements after Gap Analysis identified areas needing change. Made many client changes and created MS SQL Server stored procedures for new reports.
• Working on new projects and production support of the AESOP Powerbulider program. Creating lots of Oracle database triggers, packages and tables for a database audit program. Also adding new functionality to the Confidential PFC program to use the audit feature.
• Creating an interface to an external industrial scanner. Used web services to query scanner system and native Confidential code to retrieve/decipher JSON results and save to database.
• Also working on the Coversheet workflow project which gives a one-page view/approval of a complex process. This includes new Confidential user objects, windows and new database tables, triggers and packages.

Confidential, Chicago, IL

Sr. Developer/Programmer

Environment: Sybase Confidential 12.5, UNIX OS and shell programming, Informix database stored procedures/triggers, middle-tier components, web services, JIRA

Responsibilities:

• Working remotely as a developer on a hotel reservation system.
• In cross-functional, multiple-time zone groups we’re upgrade existing Reserve and Maintenance programs to meet new business needs.
• I’m using web services to convert credit cards to tokens.
• Also creating/modifying many existing windows, datawindows, and user objects to add new or enhanced features.

Confidential, Orange, CA

Sr. Developer/Programmer

Environment: HTML, JavaScript, jQuery, Cascading Style Sheets, Chrome Dev Tools, DreamWeaver Visual Studio

Responsibilities:

• Created/modified website with HTML, JavaScript, jQuery and Bootstrap highlighting jQuery, JavaScript and HTML elements.
• This site sells jewelry and promotes classes conducted by the proprietor.

Confidential, Jacksonville, FL

Sr. Developer/Programmer

Environment: Sybase Confidential 11.5, UNIX OS and shell programming, Oracle database stored procedures/triggers, TOAD, SQL Developer, ClearCase, HP Application Lifestyle Management.

Responsibilities:

• Created or modified windows, database tables, stored procedures, package headers/body and triggers on three Diamond projects.
• Enhanced the Diamond Confidential application to support Qualified Health Plans on the Exchange. This is done by making changes to the Benefit Rules and Benefits windows.
• Made changes to support the individual grace period Hold, Deny, Reinstate requirements for Health Plan Services members on the Exchange.
• Modified claims processing to accept claims with either ICD9 or ICD10 diagnosis and procedure codes with service dates after the ICD10 mandate date.
• Used TOAD and SQL Developer to retrieve and extract data.

Confidential, Salt Lake City, UT

Sr. Developer/Programmer

Environment: Sybase Confidential 12.5, UNIX OS and shell programming, Informix database stored procedures/triggers.

Responsibilities:

• Worked remotely on a project to create database stored procedures that remove duplicate data from several database tables.
• Business rules were provided -- programs would preserve the original row, identify the duplicate row and delete it from all related tables.

Confidential, Salt Lake City, UT

Sr. Developer/Programmer

Environment: Sybase Confidential 12.5, UNIX OS and shell programming, Informix database stored procedures/triggers.

Responsibilities:

• Worked on the Confidential program -- a Court Case Management System that handles Courtroom, Calendar, Exhibits, Warrants, Bail, and Reporting functions for Civil, Criminal, Trust and Traffic cases. Job duties include analysis of user requirements, design of new development, coding, Unit Testing, User Acceptance and Integration testing.
• Created new windows, database tables, columns and stored procedures. Changed windows to comply with new laws and improve existing windows and reports. Used the UNIX operating system for shell programming and other host activities.
• Reports were generated in a UNIX environment using Telnet, VI and Make tools. Converted long-running reports into XML files that were consumed by external agencies and vendors. Other reports were created using stored procedures to add page headers, pagination and other report attributes.

Confidential, Charlotte, NC

Sr. Developer/Programmer

Environment: Sybase Confidential and PFC, ClearCsse, ClearQuest, Oracle database stored procedures/triggers.

Responsibilities:

• Added new features to the Confidential (Enterprise Collection and Recovery) Confidential program.
• Created new windows, datawindows, and custom non-visual user objects.
• This work was needed when integrating external bankruptcy accounts into the Confidential program.
• Worked on several projects and cross-functional teams consisting of Dev Lead, Business Analyst, and developers. Standard SDLC procedures were used and included Design, Technical and code reviews.
• Team members are distributed in different regions and time zones; most meetings with them were conducted online.

Confidential, Pawtucket, RI

Sr. Developer/Programmer

Environment: Sybase Confidential and PowerDesigner, SQL Server 2008 R2, database stored procedures/triggers and Microsoft Access.

Responsibilities:

• In the Quality Assurance group new functionality was added and corrected errors in the Confidential program used with vendor inspections. Users are in USA, Hong Kong and the UK.
• Created and updated windows to add/change/delete user profiles and control program security. Added search feature to a main window. Created report wizard for flexible user reports.
• In the Field Services group’s Hastrak program, created a database in SQL Server 2008 and migrated a Confidential application, corrected application, database connection and client/server compatibility issues.
• Migrated the Returns Confidential application from SQL Server 2000 to SQL Server 2008.
• Modified the Chemicals of Concern, TestLab, Standards and Chemical Composition Confidential applications by adding user management windows, researched database replication issues, prepared the programs for migration to a new testing system, and corrected programming bugs.
• Reports were created using SQL Server Management Studio to extract the data. Report formats were Confidential Tabular, N-up, Crosstab or composite reports.

Confidential, Orange, CA

Sr. Developer/Programmer

Environment: HTML, JavaScript, jQuery, Cascading Style Sheets.

Responsibilities:

• Created website with HTML, JavaScript and jQuery to create pages with jQuery picture viewer, slider and other features highlighting jQuery, JavaScript and HTML elements.

Confidential, Orange, CA

Sr. Developer/Programmer

Environment: Oracle 10g, SQL, T-SQL, SQL Developer, TOAD, database stored procedures and triggers, Confidential 11.5.

Responsibilities:

• Worked on the Vision program, a Court Case Management System that handles Courtroom, Calendar, Fiscal, Person, Records, Exhibits, Warrants, Bail, Appeals and Reporting functions for Felony and Traffic cases.
• Job duties include analysis of user requirements, design of new development, coding, Unit Testing, User Acceptance and Integration testing, mentoring seasoned developers and training new developers.
• Oracle products used include Oracle databases, TOAD (Tool for Oracle Application Developers) for Oracle, SQL Plus, and Oracle SQL Developer.
• Microsoft products/technologies used include Microsoft Visual Source Safe, SQL Server Management Studio, SQL Server database, Visual Studio, .NET Framework, ASP.NET, ADO.NET, and SharePoint Developer.
• Added new features to the VISION Traffic Citation and Felony program. Modified existing windows and corrected bugs.
• Created and modified database stored procedures, tables and functions to add functionality to the program.
• Mentored junior programmers daily in all phases of software development

Confidential, Cypress, CA

Sr. Developer/Programmer

Environment: UNIX, Autosys, Informix 10, SQL, database stored procedures and triggers, 4GL, HTML, Confidential 10.5.1.

Responsibilities:

• Created database stored procedures, triggers, and 4gl programs in an Informix database. I also created new windows for existing applications.
• Helped to convert a semi-automatic Warehouse Management System to a fully-automatic diverter system and new Warehouse Control System.
• Modifications included adding database support for Relay Picking, Single Line Orders, and changes to route picking logic.
• Hand-held terminals were modified in HTML, scripts and database stored procedures.

Confidential, Irwindale, CA

Sr. Developer/Programmer

Environment: Oracle 9i, Sybase and SQL Server, Visual Studio, ASP.NET, ADO.NET, C#, Confidential 11, TOAD, Advanced Query Tool (AQT).

Responsibilities:

• Helped to identify/define requirements to convert an application to SAP on an ERP/Legacy interface project.
• Created multi-tier website in ASP.NET and performed production support for the Total Reconciliation Solution and Unclaimed Property Compliance System.
• Modified Oracle Stored Procedures, Functions and Packages.
• These programs help Confidential comply with state regulatory Escheatment (unclaimed revenue) requirements.

Confidential, Parsippany, NJ

Environment: Visual Studio, ASP.NET, ADO.NET, C#, SQL Server.

Responsibilities:

• Received intensive training from a Microsoft certified training partner.
• The .NET Developer Master’s Program included training in .NET Framework, C#, ADO.NET, ASP.NET.
• This training was used to develop a series of projects that ranged from Console apps to n-tier Windows Forms and ASP.NET applications.
• Other technologies used were XML, HTML and CSS.

Confidential, Orange, CA

Environment: C#, ASP.NET, Visual Studio, Microsoft SQL Server 2005 database.

Responsibilities:

• Responsible for software development and website maintenance and enhancement.
• Enhanced master page and repaired database on website.
• Modified cascading style sheets to improve website theme.
• Modified XML web sitemap and web pages.

Confidential, Carlsbad, CA

Sr. Developer/Programmer

Environment: MS SQL 2000 databases, SQL, stored procedures and triggers, Confidential V10.5, PFC, MS Sourcesave Version Control.

Responsibilities:

• Added enhancements and corrected errors in the WinRetail Point of Sale (POS) application program.
• Worked in the Inventory, POS, Data Warehouse, Vendor, Purchase Order, and Sales modules.
• Fixed bugs where WinRetail exchanged SQL Server database data with the TradeWind POS application program.