SUMMARY:

• Results oriented professional with extensive technical and business experience (25+ years), adept in Microsoft technologies, having worked in the following capacities:
• Developer, Programmer Analyst
• Database Developer
• Business Intelligence/Report Developer
• Microsoft Office Automation/VBA Programmer
• Process Flow and Automation
• Technology Application/Implementation and Integration
• Data Analyst/Data Management/Data Migration/Data Integration
• Workflow/Efficiency/Productivity and Performance Analyst
• IT Business Analyst
• Business Systems Analyst
• Systems Integration and Migration
• Remote IT Services

SPECIALIZED SKILLS:

SQL Server 2005/2008R2/2012/2014, MCTS (Microsoft Certified Technology Specialist) SQL Server 2005 Development, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), T - SQL, Sybase, MySQL, Microsoft Office 97-2016, Excel VBA, Access VBA, ActiveX Data Objects (ADO), Data Access Objects (DAO), Microsoft Office automation with backend database integration, Windows XP/7/8.1/10, Windows Server 2003/2008/2012 R2 Visual Studio 2005/2008/2010/2012/2015 , VB.NET, VB6, C#, ADO.NET, ASP.NET, SharePoint, Cloud Computing, VMware Workstation 12

EXPERIENCE:

Confidential, Chicago, IL

IT Consultant

Responsibilities:

• Custom Development of an Office Integration automated solution utilizing extensive Microsoft Outlook 2016, Microsoft Access 2016 and Microsoft Excel 2016 VBA programming.
• The new automation system will replace Confidential ’s current Excel based database and reporting system that tracks and reports on Military, Law Enforcement and Fire Fighting procurement processes.
• The project requires ground up Access database design; data analysis, cleansing, consolidation and migration of a Microsoft Excel based database and reporting system. Perform requirements gathering, systems and software analysis. Consults on systems integration and migration (from MS Excel based data storage and reporting). Provides remote, offsite technical support, database development, desktop application and more as requested.

Confidential, Falls Church, VA

Remote IT Consultant

Responsibilities:

• Custom Development of a Microsoft Access 2010 based ‘Call Quality Assessment’ database and reporting system that required data migration and consolidation of 1450+ Excel workbooks. Performed requirements gathering, systems and software analysis.
• Consults on application usage and software upgrades.
• Consults on systems integration and migration (from MS Excel based data storage and reporting).
• Provides remote offsite technical support, database development, desktop application .
• Extensive Access 2010 and Excel 2010 VBA programming.

Confidential

Principle - SQL Server, Microsoft Office, Technology Consultant

Responsibilities:

• Develop custom data management and reporting systems that utilize SQL Server 2005/2008/2012 , and Microsoft Office products.
• Consults on and manages all software and hardware upgrades.
• Consults on systems integration and migration. Performs software installations and upgrades for Windows based applications and all proprietary software.
• Provides onsite and offsite technical support, database development, desktop application .

Confidential, Pittsfield, MA

IT Business and Systems Analyst

Responsibilities:

• Provide high level interface between the IT Applications Development team, IT Infrastructure team and Business Analysts/Relationship Managers
• Apply an IT/Business perspective to identify and prioritize opportunities for improvement across all systems.
• Assessed problems and solutions from a business perspective with a focus on what the customer really needs.
• Supported and enhanced existing systems, developed new ones and defined business requirements.
• Serve as technical liaison between Corporate Systems and outside vendors
• Ensured that the IT Technical Development team provides cost effective, high quality solutions to meet the defined business requirements.
• Provided technical and programmatic assistance for the implementation of the IT Asset Management module in Peoplesoft, which required the creation of linked server communication between test and production environments.
• Technical Lead on the Mobile Banking Initiative
• Lead all data migration and data integrity checking for database refresh tasks between SQL Server 2008 R2 test and production environments.
• Provide administration, maintenance and development for the following technologies:
• Peoplesoft w/SQL 2008 R2 backend database
• SharePoint 2010 w/SQL Server 2008 R2 backend database
• MS Access 2010 Used for document storage tracking by the Compliance department (requiring VBA programming as needed)
• Corporate Referral web site - An ASP.NET 2.0 intranet site using a MySQL backend database and extensive C# coding

Confidential, Richmond, VA

IT Consultant

Responsibilities:

• Business Intelligence Project developing customized SQL Server 2008 SSIS Packages that will be used to replace data mining and extraction functionality that was previously executed using Monarch Pro 11, a reporting analytics application from Datawatch, used to extract data from text files.
• Monarch Pro extraction models are being used as a basis for C# programmed SSIS script components, for data sourcing, that extract text data from vendor supplied text files and then export the data into SQL Server 2008 tables.
• Stored procedures written in T-SQL are also being revised for post processing functionality after data acquisition.
• Providing follow-up data analysis to ensure overall data quality and integrity of sourced data once migrated to SQL Server 2008. Current working environment: SQL Server 2008 R2, Visual Studio 2008, Windows Server 2003 and Monarch Pro 11.

Confidential, New York, NY

IT Consultant - SQL Server 2005 Database Design and Implementation, Data Analyst

Responsibilities:

• Analyzed all current production systems to identify problems with data integrity, workflow and usability.
• Performed business analysis to acquire an understanding of what data was being captured and how it was used by the Confidential .
• Extensive data analysis and data mapping for the purpose of data migration into the new system.
• Worked with Confidential SQL Server DBA and performed a thorough systems analysis to acquire an understanding of all legacy systems involved to insure efficient data migration, with an eye on future portability.
• Held weekly meetings with management and staff for the purpose of requirements gathering and agreement on new system design.
• Designed and developed a SQL Server 2005 database solution that involved the consolidation of data spread across SQL Server 2000, SQL Server 2005, Oracle 10g and Microsoft Access 2003 database systems.
• Developed SQL Server Integration Service packages for extraction of data from legacy systems into new SQL Server 2005 databases.
• Development included design, normalization and creation of all tables, views, stored procedures and user defined scalar functions.
• Developed a MS Access 2003 Project front end user interface that executed all reading and writing (inserts, updates and deletes) through ADO.
• Extensive T-SQL and MS Access VBA coding. Served as the technology liaison between the Prevention and Renewal departments and the Office of IT, ensuring that the technology needs of the client were met. Provided all user on new system and technical documentation.

Confidential, New York, NY

IT Consultant - SQL Server 2005 Database Design, Development and Implementation, Data Analyst

Responsibilities:

• Redesign and conversion of Excel VBA based Service Level Agreement (SLA) Reporting System to an automated Global System based on SQL Server 2005 and T-SQL. Project involved the design and development of all system functionality and all Server objects (tables, complex stored procedures and functions) used in the system.
• System development required in depth knowledge of temporal data processing (date time mathematics)
• Reviewed server configuration and worked with Confidential DBA and CS technical staff to effectively communicate requirements for the new system.
• Worked with Confidential Business Operations Manager to insure reporting accuracy and system integrity.
• Provided data analysis for data retrieved from new Remedy system for in corporation into the new SLA Reporting System.
• Provided system documentation.

Confidential, New York, NY

Data Analyst, MS Office Developer Programmer/Analyst, Design Consultant

Responsibilities:

• Management, development of enhancements and maintenance of the Peacekeeping Troops database and Accounts Payable database using Microsoft Access and Microsoft Excel, which includes programming in VBA, ADO for data access, interface development and enhancements, Access reports development and enhancements
• Provide design consultation for the development of a new .Net based Troops and Accounts Payable system that is being developed using SQL Server 2005, C#, ASP .Net and Crystal Reports 11, for enhanced data gathering functionality that includes online data gathering and processing.