SUMMARY:

• 15+ years of programming experience in a client/server system supported environment.
• 12+ years of programming experience in Visual Basic.
• 10+ years of programming experience in Microsoft Access.
• 7+ years of programming experience in SQL querying /scripting in VBScript
• 8+ years of programming experience in Confidential for MS Access and Excel
• 3+ years of web base development experience in PHP, MySQL, CSS, Python, JavaScript and HTML
• 7+ years of experience developing and enhancing SDLC and Agile software systems in a client/server environment.
• 3+ years of programming experience developing SSIS packages for in - hous and 3rd party appliccations in a HealthCare environment.
• 5+ years of d Confidential base design, reporting and admin expence with Crystal Reports & SSRS
• 6+ years of d Confidential base design and development experience in SQL Server and Microsoft Access in a multi-tier environment.

TECHNICAL SUMMARY

Operating Systems: Windows 3.1/95/98/2000/ NT/XP/7, DOS, Android, iOS6, Linux, Ubuntu UNIX on Sun Solaris 2.6/2.7, NT4.0/2003 Server/Workstation

Languages: Visual Basic, MS Access, FoxPro, Visual C#, Python and Shell Script

Network Protocols: TCP/IP and NetBEUI, UDP, SSH, SSL, POP, SMTP, HTTP, Confidential

Internet/System tools: IE6/8/9/11, HTML, ASP, Visual Studio 2008, VBScript, JavaScript, PHP

D Confidential bases: Microsoft SQL Server 7.0/2000/5/8, DTS, SSRS, Sybase SQL Server 12Oracle 8i /11g, PL/SQL, MySQL, SSIS, Trizetto Facets, Opus Acctg Tool Visual FoxPro 3/5/6/8, 9, DB2, and Microsoft Access 97/2003/07/10/13

Software: Visual Basic.NET, Microsoft Office 10/13/365, SVN, Visual SourceSafe JQuery, Infragistics, Crystal Reports, Github, VMWare, RD/ Remote Admin SAP, Team Foundation Server

PROFESSIONAL EXPERIENCE:

Confidential

Web Developer

Responsibilities:

• Designing, coding, and testing of front-end / back-end ASP.NET, SQL Server, Entity Framework, PHP, JavaScript, WordPress, Laravel, and C# web driven applications.
• Creating user friendly JavaScript single-page-applications in Confidential & MVC styles using Backbone, Knockout and jQuery for healthcare provider (HCP), disease awareness and medical platforms.
• Developed and released SSIS packages into production and investigate reporting issues.
• Analyzed and modified SSIS package d Confidential flow requirements.
• Create Back-end modules in C#& PHP for Automation processes.
• These processes automatically updates Excel workbooks, encompassing VB.NET DLL's, .NET Classes, program modules and external SQL Server queries.
• Create department prototypes of specifics gathered from business leads that determine the scope of the projects.
• Convert legacy reports in Crystal Reports and Access 2013 reports of complex expressions and aggragate functions for online web report processing.
• Developed SharePoint virtual development environment to create test web sites to allow the business and endusers access to custom reports and other Collaborational featues such as Team-sites, Site Libraries and Group Work Sites.
• Developing enterprise responsive Confidential systems.
• Used JavaScript, HTML5, and ASP.NET to create custom master web-parts, list and workflows in SharePoint 2016.
• Conversing with customers and end-users to analyze their needs.
• Investigating, fixing, and debugging software defects.
• Maintained MS Access /SQL Server legacy d Confidential bases developed plans to migrate into latest approved versions.

Environment: C#, Confidential, SQL Server 2012, T-SQL, ACCESS 2010, 2013, Visual Studio, Visio 2013, SharePoint, ASP.NET

Confidential

Applications Developer/ Reporting Analyst

Responsibilities:

• Optimize SQL queries and d Confidential base objects to meet and facilitate new application deployment and bug free fixes.
• Convert Access 2010 & 2013 Forms to Webforms in VB.NET Web applications using ASP.NET/SQL Server for testing /Oracle for deployment and javascript for live video streaming of new Confidential system for presentation and purposes to business stakeholders and end-users of the system.
• Analyzed and modified SSIS package d Confidential flow requirements.
• Create Back-end modules using C# & Python and Access 2016 for Confidential Automation processes.
• These processes automatically updates Excel Confidential workbooks, encompassing VB.NET DLL's, .NET Classes, program modules and external SQL Server queries.
• Develop GUI interfaces using Open D Confidential base Connectivity (ODBC) & ADO.NET to connect to MS Access 2010 and SQL Server 2008 (RDBMS) Relational D Confidential base Management System.
• Convert legacy reports in Crystal Reports and Access 2003 and 2007 reports of complex expressions and aggragate functions for online SSRS web report processing.
• Migrated d Confidential tables from multiple platforms and d Confidential bases {i.e. DB2, Oracle, Terad Confidential } into SQL Server via Confidential command line process to transfer files and ETL processes to be deployed on the SharePoint site.
• Developed SharePoint virtual development environment to create test web sites to allow the business and endusers access to custom reports and other Collaborational featues such as Team-sites, Site Libraries and Group Work Sites.
• Transfered, import/expoorted Provider Enrollments/Claims d Confidential info from 150 Access 2007, 2010 and 2013 d Confidential bases to SQL Server for report processing by creating and consuming webservices.
• Create Analysis Services multidimensional Cubes, SSRS reports utilizing MDX Query Designer, OLAP, and create d Confidential models in PowerPivot.

Environment: VB.NET, Confidential, SQL Server 2008, 2012, T-SQL, ACCESS 2010, 2013, Visual Studio, Visio 2010, SharePoint

Confidential

Service Engineer / Developer

Responsibilities:

• Developed SharePoint web / test sites to allow endusers to test features of the software.
• Uploading new contents and learning materials to the web server
• Designed UI & workflows with master pages, CSS, JavaScript, SharePoint Designer, .wsp files and features.
• Create and program responsive SharePoint website designs with master pages, page layouts, themes, display templates, JavaScripts, jQuery, Bootstrap, CSS, Adobe Photoshop, illustrator and SharePoint designer.
• Coding (MS ACCESS, Confidential, ASP, HTML, VBScript, ASP.NET) and Bug fixing.
• Created d Confidential base tables, queries, triggers using T-SQL
• Utilized Microsoft Dynamics ERP to integrate Crystal Reports XI R2 & Excel spreadsheet documents to implement custom
• Dashboards to standardize business processes specified by management.
• Develop forms, applications, and workflows within SharePoint using InfoPath and SharePoint designer.
• User interface design, front-end web development & branding of SharePoint sites.
• User, conducting requirements gathering sessions with end users and user testing.
• Developed WebForms using VB.NET, C#, PHP, ASP.NETand MySQL for department.
• Used AJAX in some webforms.
• Used third party macros to implement new chart functionalities in crystal reports
• Translated end user requirements for custom crystal reports into design documents.
• Interacted with users in resolving the Help Desk Tickets (Remedy Tickets, Service Now) .
• Migrated reports from version Crystal XI to Crystal 2008 .
• Work with inverstments groups / end users to uprade custom MS Access applications created in Access 2003 converted to Access 2010 to be uploaded to MS SharePoint 2007 server.
• Create and Support Test environments for sales, and investment groups for current and new application developments.
• Worked on exporting / importing reports to Excel from Oracle DB to create DASHBOARDS via Confidential command line process and using Confidential .

Environment: Confidential, ASP.NET, VB.NET, SQL Server 2008, T-SQL, ACCESS 2007, 2010, Visual Studio .Net, Citrix

Confidential

IT Consultant

Responsibilities:

• Developed Desktop Configurations, Media tracking and Sales Automation module in Visual Basic. NET for the Point Of Sale Management System.
• Utilization of the following was done to meet specifications:
• Developed variety of batch scripts, VBScripts and Javascripts to automate server administration and to rollout security settings throughout the enterprise
• Report Designer - Used to create 25 Standard and complex reports involving multiple stored procedures calls from SQL Server and Oracle d Confidential bases.
• This also included automation function calls to Crystal Reports ver.10.
• D Confidential base Designer Used to create the new Media tracking and Sales Automation System
• Implemented ODBC, OLE and DTS for accessing SQL Server 2005 tables from the Confidential environment.
• Developed a web application utilizing ASP and SQL to post automated test results stored in a MS SQL Server 2005 d Confidential base.
• Created web site and back end SQL d Confidential base to track server inventory and application configurations
• Support Active Directory user administration: (Windows Server 2003) Confidential remote locations using VMWare.

Environment: Operating Systems: Windows XP/7, Windows 2003 and 2008 Server

Confidential, Bridgeview, IL

Programmer / Developer

Responsibilities:

• Development and installation of Confidential programs for various clients around the state.
• Documentation for testing, implementation, debugging, user manual, troubleshoot guide and FAQ's
• Developed a utility module for d Confidential conversion and exporting to Excel workbooks and Confidential programs simultaneously using Confidential and ETL processes.
• Designed and wrote the automation code for d Confidential base queries and resolution.
• Created link based module to enable automatic updates for excel workbooks.
• Created automated mail trigger for reporting any unusual modification to critical files as well as deals above a specified limit
• Assisted in the development and maintenance of d Confidential base and system migration modules.

Confidential, Chicago IL

IT Support Analyst

Responsibilities:

• Created Transact SQL scripts that transform d Confidential to be used on other platforms {UNIX/.NET}.
• Created Stored procedures, triggers, tables, indexes, rules, etc; to use in Batch processing
• Implemented ODBC, ADO.NET and BCP for accessing SQL Server 2005 tables from the Confidential environment.
• Plan, installed and configure major releases and migration of Microsoft SQL server/MS Access
• Identified key features of SQL Server versions and took advantage of those that are focused on the d Confidential base engine, and worked with Development to propagate those that could be advantageous for the application environment.
• Identified differences among SQL server / MS Access versions and work with the Development staff to resolve the effect on applications.

Environment: Operating Systems: Windows 2000, Windows XP, Windows 2000, 2003 Server