IT Consultant Resume

SUMMARY

Experienced business analyst and software developer. Skilled in formal project control, programming, database management and managing staff to complete a project. Recognized for resourcefulness, reliability, excellent organizational skills and attention to detail.
IT Professional with over 20 years’ experience in MS SQL Server (2008 R2, 2012R2, 2014, 2016, 2017, 2019).
Extensive experience with Infor Fourth Shift ERP Solutions
Expertise in utilizing ETL tools, including SQL Server Integration Services (SSIS) Data Transformation Services (DTS), Power BI Toolset &BI PowerPivot
Proficient Build Master for Data Architecture Team using Team Foundation server 2008, 2010,2013
Oracle Database development 9,10,11 utilizing PSQL Developer & Toad
Web and WinFormClient Development using Microsoft .NET technologies
Data Warehousing utilizing Microsoft Master Data Service and Tubular SSAS
Exceptional background in analysis, design, development, customization, and implementation of software applications.
Expertise in database design, data modeling and entity relationships.
Excellent technical, analytical and troubleshooting skills.
Strong SSRS report, SSIS & SSAS Cube development Tabular Modeling.
MS Office interoperability - VBA, Macros, VB Scripting, DAX Scripting, MDX
ASP.NET,ADO.NET,LINQ, Tableau, Microsoft M .Microsoft PowerAPP & Flow

TECHNICAL SKILLS

PROFESSIONAL EXPERIENCE

IT Consultant

Confidential

Responsibilities:

Confidential

IT Consultant

Responsibilities:

Confidential

IT Consultant

Responsibilities:

IT Consultant

Confidential

Responsibilities:

SQL Database Developer

Confidential

Responsibilities:

Create SSIS Packages
Create a data extraction process to pull insurance claim data from a SQL Server data repository, transform data into xml messages, for upload into PeopleSoft for payment
Create SSRS Reports
Created a suite of complex financial reports delineating earning, Loss reserves, administration and Brokers fees
Modify Existing Crystal Reports
Utilize Microsoft TFS Auto Build and deploy (Team Foundation Server)
Utilize MS DBPRO ( Microsoft Database Pro)
Create database transformation scripts to promote Development TSQL code to QA and production.

System Consultant

Confidential, Fox River Grove, IL

Responsibilities:

Performed business process improvement for Asset Audit Company. Designed, developed and implemented new processes that took advantage of document imaging technology, bar coding and automated document indexing. When implemented, the improvements reduced processing effort by over 80%.
Implemented Great Plains Small Business Manager for governmental agency. Performed requirements, system selection, system configuration and data conversion. Trained users in the use of the new system. Integrated Great Plains to additional systems.
Performed requirements, developed RFP and performed vendor selection for new data and voice communications network for $6 billion bank with 55 locations. Selected solution saved customer over 50% on their costs.