SUMMARY:

Seamlessly versatile IT professional easily assimilating into multi - paced environments requiring a broad portfolio of skills spanning application development, end user support, training and development, and troubleshooting. Definitive resource for multi-level decision-makers across diverse industries, capably communicating among project management, maintenance support, programming analysis, and product engineering roles. Excels in requirements gathering, testing, and production support along with technical writing, reverse engineering, and documentation.

EXPERT IN:

MS Office and development methodologies.Senior SQL & T - SQL Development SSIS SSRS Data Analyst Business Analyst Systems Analysis/Administration Database Design/Implementation Project Planning Use Case Data Modeling System Troubleshooting User Support Technical Writing Training & Development

TECHNICAL SKILLS:

NET Framework. ADO.NET. Adobe Acrobat Professional. Ajax. ASP.NET. CSS. DAO, ADO ODBC Development Methodologies (Spring Framework, Model View Presenter, OOP. UML. Agile Development. RAD), End User Support and Helpdesk, HTML, Javascript, MS Access with VBA, MS Office (Word, Excel, Outlook, et al), MS Project, MS PowerPoint, SAP PCM (Profitability and Cost Management), Sharep oint, SQL Server, SQL Server Reporting Services, T-SQL, VB.NET, VB6, Visual Studio/Visual Studio.NET

PROFESSIONAL EXPERIENCE:

Confidential, Kalamazoo, MI

Lead Programmer SQL Mgmt Studio/SSRS/ SSIS

Responsibilities:

• Technical Support for COTS class scheduling application. Fixed in-house designed invoicing system and several malfunctioning aspects of software.
• Spearheaded installation of DEV environment for improvement of class scheduling processes.
• Report generation and modification of medical scheduling software using T-SQL and SSRS.
• Automation of and processing using SSIS and stored procedures.
• Advanced SQL processing of PHI data submissions to Confidential .

Confidential, Phoenix, Arizona

Systems Development Sr. Specialist SQL Mgmt Studio/Business Intelligence Solutions

Responsibilities:

• Completed maintenance tasks for the Confidential HR Services’ Advantage Health and Confidential system as the senior technical lead resource using a ticketing system.
• Created stored procedures and SSRS user reports for coverage, eligibility and compliance.
• Created, mapped, refined and updated import/export stored procedures for demographics and vendor/payroll files to and from third parties.
• Designed, created and scheduled automated import/export processes of client data using ActiveBatch and SSIS.
• Employed best practices in development, user acceptance testing, and production deployment while working with offshore teams.
• Monitored emerging design changes on the Confidential HR Services Advantage production for Health and Welfare Administration along with laws and regulations for Human Resources administration.
• Designed, implemented and maintained Affordable Care Act auditing and reporting protocol successfully assisting client in achieving legal compliance with this Federal mandate.

Confidential, Whitehall, Michigan

Project Manager/Support Specialist

Responsibilities:

• Formulated and refined stored procedures, views, indexed views, and table/scalar functions.
• Crafted and assisted with intricate queries using joins, parameters, dynamic SQL, data constraints, inserts, and truncations.
• Produced data objects in support of Visual Studio SSRS presentation reports.
• Using SSIS, designed, created and scheduled automated import of manufacturing, inventory, maintenance, repair and personnel data from third-party systems for integration to SQL database.
• Compiled user requirements, notating SSRS Report solutions by replacing outdated applications and spreadsheets.
• Synthesized company standards to ensure uniform use of color, logos, and presentations.
• Fine-tuned an application with a SQL backend and report generation.
• Reverse-engineered existing applications using SSRS solutions.
• Troubleshot MS Office issues, including Excel with embedded SQL, formulas, Visual Studio applications, VBA, and OLE.

Confidential, Detroit, Michigan

Advanced Programmer Analyst

Responsibilities:

• Improved an application with a Mainframe backend, reverse engineering it a .NET proposed system. Troubleshot and rectified errors.
• Performed technical support, tracking issues for a malfunctioning application.
• Delivered systems to support the vendor through WebEx, SFTP and instructions to correct software problems and errors
• Assisted finance users of the PCM Console Wizard, Databridge, and Model Builder.
• Loaded data and produced designated financial reports for the business by running application specifications.
• Fulfilled user requests for reports regarding litigation and compliance.

Confidential, Hastings, Michigan

Systems Programmer Analyst

Responsibilities:

• Retooled report development procedures using mainframe export data. Formulated reports using Document Direct, MS Access, Excel and Word.
• Equipped marketing representatives with agency information and statistics by devising a marketing tool using MS Access with a SQL backend.
• Supported the development of report templates to extract data from mainframe through ViewDirect interface to MS Excel.
• Drafted VBA routines for data reorganization and refinement.
• Emerged as a Subject matter expert for the Document Direct 4.4 ( Confidential ) data extract tool, originating methodologies to pull, manipulate, arrange, and distribute extracted files.

Confidential, Portage, Michigan

Product Engineer

Responsibilities:

• Coordinated .NET development for the Government Revenue Management (GRM) property tax software product.
• Coded, debugged, and documented Visual Studio .NET C#, and SQL stored procedures and complex query language in a multi-level Object Oriented custom framework.

Confidential, Marshall, Michigan

Systems Programmer Analyst

Responsibilities:

• Supported remote end users in all IT areas, including application and hardware solutions.
• Managed system administration for Windows Server 7 VM.
• Handled four application upgrades, addressed planned and emergency maintenance outages and upgrades, and served as a Logos subject matter expert.
• Served as VBA for Excel data mining, piloted requirements gathering and draft development for a Fleet Management application, and produced intricate calculations for fleet cost of ownership, including by mile.

Confidential, Richland, Michigan

Systems Programmer Analyst

Responsibilities:

• Compiled data and other requirements for a business intelligence application. Installed SQL Server 2005 with Reporting Services and Map Suite and Visual Studio 2008 to support development.
• Imported QB data to Access for analysis, remedied user and system issues, and revamped the company website.
• Accountable for Small Business Server 2003 user accounts, password resets, and email configurations.
• Delivered end user IT support.