SUMMARY:

• choosing and implementing Tortoise SVN as a first - time repository system for the company.
• Developed Sales and Forecast Analysis in a grid view format with selection options for specific customer, product line, location, division, item number or grouping requirements for same selections. Written in C# and ASP.net, 4.5 Framework.
• Rewrote the majority of all programs in company intranet website changing the logic from a four-company business to one company with four divisions, combining 4 databases into one, accessing each division thru a user defined field inserted in each sales, inventory, purchasing, invoicing child tables.

TECHNICAL SKILLS:

Database Infrastructure: SQL Server 2000/2005/2008/2016, SQL Scripts & Stored Procedures,Oracle, PL/SQL, ODBC, and IDOL-IV.

Application Development Tools: Visual Studio 2003/2008/2010/2015, Visual Basic.Net, C#, HTML, ASP.Net,Ajax, VBscript, Bootstrap. 3.5/4.0/4.5 . Net Framework. AJAX Control ToolkitTelerik, DevExpress 13.2, JavaScript, Tortoise SVN, PlanetPress 7.6, EDI, Agile.

Report Development Tools: DevExpress, Telerik, Crystal Reports, Cognos Impromptu, Jet Report, SSRS.

PROFESSIONAL EXPERIENCE:

Confidential

.Net Developer

Responsibilities:

• Responsible for choosing and implementing Tortoise SVN as a first-time repository system for the company.
• Developed Sales and Forecast Analysis in a grid view format with selection options for specific customer, product line, location, division, item number or grouping requirements for same selections. Written in C# and ASP.net, 4.5 Framework.
• Rewrote the majority of all programs in company intranet website changing the logic from a four-company business to one company with four divisions, combining 4 databases into one, accessing each division thru a user defined field inserted in each sales, inventory, purchasing, invoicing child tables.

.Net Developer

Responsibilities:

• Developed and maintained Care Plan Request Portal with master page, login page, with selection process, approval process, editing, updating capabilities, all driven with rights hierarchy. Written in C# and ASP.net, 4.0 Framework.
• Care Plan Request Portal used by hundreds of Care Managers and Supervisors across Florida to manage the Diversion program, then modified to work with the new Statewide Medicaid Long-Term Care Managed Care (LTCMC) program. Also, used by an ADA staff of 50 people at headquarters to edit and approve or communicate with care managers working in the field.
• Modified and maintained VBscript which translated, the care plan requests once approved to finalized status level, and updated existing Care Plan system used to manage Diversion program, then modified for Long Term Care Managed Care program.
• Developed and maintained Provider Portal with master page, login page, with member selection process and options to either enter claims manually or download EDI file for their claims to be process. A return EDI file acknowledging their download received, automatically sent to providers. Written in C# and ASP.net, 4.0 Framework.
• Developed sections of new Member Management System, which combined all information websites into one location. This new website was written in VB.net, Dev Express and PlanetPress.
• Programmed SQL stored procedures for the backend to gather the information on all .net controls.
• Programmed file conversions for EDI forms 834, 835, 837, 997.

.Net Developer

Responsibilities:

• Developed company Portal with Master page and Panel bar accessing Settlement, Lottery, Annuity, Marketing, CRM, Mail, Reports, Administration sections with input new records, modify, viewing and analysis capabilities.
• Programmed in every sections of Portal, either creating new front-end pages, controls, reports, or modifying existing pages, controls or reports, or correcting bugs and malfunctions.
• Portal sections driven by user rights for ability to view or access.
• Most pages, controls provided information in a grid style with popup windows while providing filters to either present the grids differently or columns filters to reduce down information.
• Programmed SQL stored procedures for the backend to gather the information on the grids.

Database Analyst II, .Net Developer

Responsibilities:

• Developed Reports and Insurance Forms in 3-tier architecture (Models, BLL and DAL) with a user interface written in HTML with code behind in Visual Basic .Net, and the DAL accessing a SQL Stored Procedure, with final output produced by Crystal Report either in a PDF format or Excel Spreadsheet.
• Only Developer to have mastered the Reports 3-tier architecture in Boca Raton.
• Developed Cognos Impromptu Reports with output either in PDF format or Excel Spreadsheet.
• Developed daily, weekly and monthly Reports for Executives, underwriting, marketing, loss control, claims and accounting analysis.

Database Analyst, Reports and Inventory Control

Responsibilities:

• Programs in Jet Report and Excel formulas in automating Inventory of Jewelry, Gold, Platinum, Diamonds and Precious Stones. Provide end of month total value of Inventory including WIP for financial statement.
• Developed Production Reports for beginning of day and day-end wrap-ups.
• Developed Customer, Sales Analysis, Salesmen, Sales Lines, Purchasing and Commission Reports.
• Cut down Inventory processing from 1 month to 1 week.
• Cut down Commission Reports from 1 week to half a day.
• Cut down Purchasing Process from a day to a half hour.

Call Center Senior Technician

Responsibilities:

• Provide Technical Hardware and software support to users for Gateway products, on Win95/98/Nt/Me/2000/Xp.

Programmer Analyst

Responsibilities:

• Provided troubleshooting, system analysis, fixes, patches and retrieval of information interfacing with several systems, in Thoroughbred Basic IDOL-IV on SCO UNIX.
• Retrieved and repaired corrupted 3-year history sales files and rebuilt indexes. Made data accessible to company staff by way of inquiry screens.
• Designed and installed customer invoice forms and summary reports in Crystal Reports.

Programmer Analyst / Network Administrator / IT Support

Responsibilities:

• Designed & implemented new manufacturing Labor and Material Entry System.
• Improved accuracy, increased work efficiency and system performance while reducing 3 UNIX sessions to 1 for every user accessing those entry screens. Added functionality and features transforming 3gl to 4gl programs. Cut down licensing fees by thousands of dollars.
• Designed & implemented costing system used in setting up list price; trimmed down cost, and improved profit margin.
• Designed & implemented commission system, increased accuracy and prevented over payment; saved company excessive expenditure.
• Designed sales analysis screens and reports. Improved marketing’s ability to make decisions, increased company profitability.
• Implemented automated sales order system editing processes, which eliminated several errors by omitting hardware, parts, shipping or special instructions. Achieved accurate quantities and combinations of products; saved company a high dollar value of inaccurate shipments and unwanted returns.
• Managed and led 4 outside contract programmers. Improved employee and company performance
• Designed and implemented reports from EMS using Crystal Reports and ODBC. Provided shipping department with scheduler and combined picking ticket. Saved department time in gathering products. Eliminated errors and increased on-time shipments.

Programmer Analyst / Network Administrator / IT Support

Responsibilities:

• Designed and implemented new invoicing update program interfacing with accounting, inventory, commission, sales analysis, rebates and sales history systems. Critical update made bullet proof in case of system crash or user cancellation. When restarted, program kicked off exactly where it stopped, saving company precious time and money in recuperating lost or corrupted information.
• Reduced process time from 11 hours to 4 hours. Saved company time and money and freed system resources.
• Redesigned and implemented entire physical inventory system (I.e. entry screens, lookups, editing, recounts, update, reports, slot location), in utmost pressured situation. Enabled 4 branches across Florida and Puerto Rico and 400 employees in performing the physical inventory over a 4 day company shutdown, avoiding massive losses.