SUMMARY

Programmer Analyst, Developer experienced in SDLC, C , VB.Net, ASP.Net, Web Based, Windows Forms, Class Library and Console Applications, Web Services, XML, DevExpress, Scan Imaging EMC Captiva, SQL Server, T-SQL, Oracle 9.2 11g, PL/SQL, FileNet, upgrading from VB6 to .Net. Currently Junior level experience in iOS, Objective-C. Experience in Manufacturing, Banking, Healthcare and e-Commerce IT.

SKILLS

.NET Framework 4.5, 4.0, 3.5, 2.0, 1.1 , C , VB.Net, XML, VBScript, JavaScript, DevExpress, Crystal Reports, Web Services, Web Based and Windows Forms applications, MVC 5, Bootstrap, VB, EMC Captiva 7.1, Access, MS SQL Server 2005, 2008 R2 , Oracle 9.2-11g , Windows Server 2003 R2 , Web Server 2008 , Windows XP, 7. Junior level: iOS, Objective-C. Tools: Visual Studio 2003, 2005, 2008, 2010, 2012 and 2013 , Team Foundation Server, Visual SourceSafe, Erwin, System Architect, Rational Rose, Visio, Adobe Acrobat.

EXPERIENCE

Systems Analyst

Confidential

• Visual Studio 2010, 2012, VB.Net, VBScript, EMC Captiva 7 and 7.1, SQL Server 2012, SQL Server 2008, WinSQL Professional 9.0, ChangeMan DS Client 5.7
• Designs and develops Captiva 7 and .Net Medicare Documents Capture Systems. Designs and implements .Net Classs Libraries that add complex functionality to the Captiva Imaging Flow Systems.
• Rewrites Process Flows from VBA based Process Developer module to .Net based Designer versions, rewrites VBA to .Net. Learned EMC Captiva 7 an 7.1 OCR and workflow software while working with it.

Consultant Developer

Confidential

• Visual Studio 2005, VB.Net, ASP.Net, SQL Server 2008, WinSQL Professional 9.0, SQL Query Analyzer 8.0, FileNet IDM 4.0, Crystal Reports for Visual Studio 2005, ChangeMan DS Client 5.7
• Extended a console application in VB.Net to handle workflow routing Medicare batch documents from FileNet and Solutions Suite through an additional path as well as obtain serial numbers from a new dll to assign to the documents. Added new functionalities to a Windows Forms application and its Crystal Reports. Created dynamic controls that are added to forms based on lookup data retrieved from SQL database, modified Crystal Reports.

Consultant Developer

Confidential

• Visual Studio 2008, ASP.Net, VB.Net, JavaScript, SQL Server 2008
• Analyzed existing Excel tool for handling security documents, gathered business requirements, translated these requirements into a Web Based VB.Net application. Designed and developed SQL database, wrote queries and stored procedures, designed and developed main functionalities and applied some of the existing standard components to some pages.

Programmer III

Confidential

• Visual Studio 2012, 2010, 2008, 2005, C , ASP.Net, VB.Net,JavaScript, HTML, TFS, SQL Server 2005, 2008 R2, Oracle 9.2-11g, Toad 6
• Corrected issues and implemented changes requested by users on bank Intranet which included: asp, html pages, asp.net applications, SQL databases and ASP data from ASP / XML / VB / SQL applications, Active Directory. Programmed new Web pages for a Commercial Loan Web Based C / SQL application. Made changes to VB programs reading data from Oracle Data Warehouse and remote Mainframe using ActiveHeat over Telnet technology. Rewrote an ASP / XML / VB / SQL / Mainframe application in Windows Forms C , SQL and Oracle Data Warehouse. Redesigned SQL database. Rewrote Oracle packages. Replaced MS .Net Data Provider for Oracle with Oracle Data Access Components with Visual Studio Tools and configured Oracle Database Access provider for .Net. Trained in WCF Web Services development at Core BTS. Began writing Web Service to replace ActiveHeat Mainframe data writing functionality.

Systems Developer

VB.Net, VBScript, XML, Visual Studio 2005, 2008, 2010, SQL Server 2005 and 2008, MSMQ, Web Server 2008, EDI Programmed e-Commerce solutions that output international commercial documents in English and Chinese from data transactions in AS/400 and SQL Server 2008. Wrote and modified stored procedures in SQL against SQL, DB2 and Oracle tables. Modified existing .Net class library programs to meet foreign language and culture requirements and multiple language output of EDI transactions in SMTP e-mail, html, PDF attachments and XML format. Modified, upgraded to .Net Framework 4.0, extended and installed Web Services. Configured Web Server 2008 and IIS. Corrected HomeStore Replenishment program. Supported EDI transactions. Translated commercial documents terms from English to Chinese for e-Commerce solutions testing.

Developer / Systems Analyst

Confidential

VB.Net, DevExpress, JavaScript, SQL Server 2005, Visual Studio 2005 and 2008, SVNRepaired, enhanced and supported .Net Windows Forms Applications. Wrote SQL queries, stored procedures and triggers. Developed and supported Web Based application that replaced Power Builder solution. Developed and supported .Net Windows Service that manipulates data between AS/400 and SQL Server 2005. Developed a Web Based .Net Supplier Reject Application that replaced Windows Forms application. Developed Web Based automated Customer Service Order Confirmation Application that sends confirmation reports with graphical images by fax and e-mail to customers and Customer Support Department. Validated Active Directory users in Web Based applications and configured Active Directory Groups and Users. Trained users. Supported Automated Manufacturing and Manufacturing Material Optimization applications as needed. Defined best practices for new Web Based technology. Provided on call support for AS/400 RPG applications.

Consultant Developer

MS SQL, Access, Systems Analysis

Wrote stored procedures in MS SQL to extract data according to NCQA HEDIS Healthcare Effectiveness Data and Information Set standards and Quality Measurement, created auxiliary tables, documented processes and results for a HEDIS Compliance Audit. Rewrote Access queries as SQL stored procedures. Researched ICD-9 codes. Cleansed data.

Confidential

Extended Investigation Case Management System Web Based package software for law enforcement agencies. Extended SQL Server database, wrote queries, programmed new pages that support business rules with more complexity. Redesigned SQL 2000 database in SQL 2005, normalized it, provided higher level of detail and complexity according to business rules. Researched the industry standards and included code sets used in the industry in the system. Created design diagrams used by Sales. Recommended ways to increase software flexibility and data display options. Wrote Administrator and User Guides. Programmed new functionalities in Casino Security and Surveillance and Check Cashing software.

Software Developer

To solve Inventory and Sales Order quantities and quantity tracking problem in existing applications:Analyzed Production and Inventory bar coding system, Sales Order Processing and Invoicing system with interfaces to Production and Accounting systems. Analyzed manufacturing processes and defined new user and business requirements. Designed and developed improvements and streamlining features to the operations, processes and to each enterprise subsystem according to Lean Manufacturing principles. Analyzed and compared technical specifications and industry standards of all product lines. Designed a relational database for creating, modifying and matching products and specifications and for their usage in operations. Designed new enterprise solution architecture with subsystems: Manufacturing Production and Inventory bar coding for multiple departments based on product lines, Scheduling, Shipping and Receiving and Order Assembly. Designed and developed databases and software to facilitate information flow across departments and processes and integrating subsystems into a compact solution. Automated or eliminated superfluous manual processes. Increased enterprise system efficiency in Production, Sales Order, Shipping and Invoice Processing systems by 40 . Supported 30 workstations in plants and office with a superior, assisted with administration of MS Small Business Server, MS Exchange and Active Directory.