Lee Peterson

SUMMARY

Information Technology professional with over 20 years industry experience related to systems architecture & integration, project management, analysis, Management information design, data-modeling, High Availability, development, deployment, and maintenance of batch, transactional, and database applications in both mainframe and micro-based distributed environments. Developed or enhanced software in following related industries exposure includes Accounting, Financial, Healthcare, Human Resources, Banking, State Government, Insurance (Life, Private Health, Property/Casualty, Medicare, Medicaid, Federal), Medical Practice Management. Specializes in Microsoft technologies including .NET languages and architecture. Has excellent communication skills and interfaces effectively with management and project staff.

LEADERSHIP ROLES/SKILLS

Database Administrator: Managed a team to handle the needs of Dental select. Developed a commission module, customer server faxback capabilities. Primary Programmer: Mentored many developers to develop leadership and skills and technical abilities. One of my team members succeeded me in my role when I left.

TECHNICAL SKILLS

Databases: Microsoft SQL Server 2014/2012/2008 R2/2005, AZURE SQL, Data Governance, Master Data Management, Data Quality

Database Technologies: SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS)

Languages: C#.NET, VB.NET, ASP.NET, T-SQL, PL/SQL, HTML

Development Tools: Visual Studio, SQL Server Management Studio, Business Intelligence Development Studio, Red Gate Suite, SVN, TFS

EXPERIENCE

Dental Select, Murray, UT

Senior Database Administrator 2013-Present

•Highlights: Administration of Databases; High Availability; restructuring of Data Warehouse. Log shipping Migration to newer version of SQL Servers. migration to Cloud server (IaaS). SSIS import packages development and performance. use of BCP. SSRS. SharePoint administration. gaining business knowledge and technical knowledge of Vendor Supplied Data Warehouse via Log shipping. Microsoft Dynamics GP Database tuning and administration for this site. trained and supporting on Quest Analytics

•Documented, and co-developed original commissions framework implementation

•Technology: Azure SQL, Windows Server 2008 R2. SQL SERVER 2005, SQL Server 2008 R2 64-bit, Redgate software, Quest Analytics, RDBMS DATA MODELING, BIME, Quest Analytics

Ceridian, West Jordan

Export and Import Data Analyst 2012-2013

Highlights: Integration with multiple internal and external data sources.

Handled up to 12 corporation’s payroll, 401K, insurance enrollment

Develop 834, Payroll, FSA and other Exports

Creation and maintenance of Export Schedules,

Technologies: Pervasive Data Integrator. CF3, Redwood Explorer, Sharepoint

CBIZ, Salt Lake City, UT 2009-2012

EDI C# Developer

Highlights: developed 834 EDI delivery system, Integration with multiple internal and external data sources.

Developing EDI system and Procedures to Create, monitor and Submit ANSI 834 and 820 Transactions Via Web. Latest Task to development methodology to consider Consideration of Companion guide rules in Creation of 834.refining open enrollment.

Introduced 3rd party 64 bit .net EDI Software in order for this organization to produce HIPAA compliant transactions.

Technology: C#, ASP.NET, Window Server 2003 64-bit, SQL SERVER 2005(SQL Stored Procedures), SQL Server 2008 R2, Visual Studio 2008, Visual Studio 2010

Health Connect, Cottonwood Heights, UT

Lead Software Engineer 2007-2009

Managed team of local database developers and contractors including near shore, outsourced engineers.

Reverse analysis on 3 systems (VB 6, VB.Net, C++)

Introduction of new network, and complex business rules

Supported e-commerce system database growth and enhancements through tremendous growth. Query optimizations, data restructuring, refined indexing, data access design, using SQL Server 2008 R2.

Provide Technical Software support for Western Rehabilitation Network & Mountain Land Rehabititation.

Support Web based Practice management system, Windows based Practice Management System, ANSI translation System, provider Credential software support

Skills/technologies utilized: Reverse engineering, analysis, data mining, RDBMS DATA MODELING, X12 EDI Development, WEB DEVELOPMENT for eBUSINESS / eCOMMERCE, PROJECT MANAGEMENT, VB6, VB .Net, ASP, Window 2003 Server, Windows Vista, Windows XP, Windows 2000, Windows 98SE

Regence BCBS of Utah, SLC, UT

Senior Developer 1996-2007

Maintenance/development of a commercial object-oriented Medical Billing application that produces numerous HIPAA compliant ANSI X12 EDI transactions and is installed in over 1100 Healthcare provider sites in Utah.

This application interfaces with over 50 different Practice Management vendor applications and is deployed with a SQL Server 2000 Relational Database and VB6.

Used Installshield installation processes of desktop Applications

- Development and Maintenance for Utah Claim Process System.

Maintenance of DRG Pricing subsystem Aided in Implementation and augmentation

Maintenance of DRG Pricing subsystem of APG pricing subsystem

Mainframe environment: Also Maintained and enhanced Regular business, Federal Claim, Medicaid systems

Utilizing TOS/ISPF, CICS, SuperBMS, BMS, OS390 COBOL, Easytrieve Plus, JCL/MVS, Endevor, Viasoft, ACF2, Top Secret

Skills/technologies utilized, CHANGE CONTROL/QUALITY ASSURANCE, AUTOMATION, YOURDON ANALYSIS AND DESIGN,, PROJECT MANAGEMENT, data /Program Analysis, Data mining, X12 EDI Development, VB6, VB .Net, SQL, MS SQL server, Datacom/DB, Window 2003 Server, Windows Vista, Windows XP, Windows 2000Analyzed, Used considerable T-SQL, SSIS and SSRS in all projects with SQL Server 2008/2008 R2.

Contact this candidate