SUMMARY:

• 25+ years of extensive hands - on experience in all phases of the data warehouse, and software development life-cycles including: proposal, specification/requirements, architecture, logical and physical data model, design, task assignment and management, technical documentation, user documentation, code development, test plan creation, testing, validation, maintenance, and support.
• Innovative problem-solver.
• Hands-on manager, strong team leader, mentor.
• Organized, efficient multitasker
• Excellent written and verbal communication skills.
• Ability to quickly learn new programming languages and tools.
• Agile and Kanban methodologies.
• Strong analytic and mathematical skills.
• Ability to work as team lead, team member, and independently, with all levels of organization.
• S MS SQL Server 2008R2-2016 T-SQL Query Language MS Visual Studio 2005-2015 MS SharePoint 2010 MS VisualBasic.NET MS Team Foundation Server MS Excel 2010 VBA CA Erwin Data Modeler 9.6 Informatica PowerCenter 9.1 MS Team Foundation Server MS ASP.NET MS Visual Source Safe Crystal Reports XI ASP Classic vbscript WCF web service Javascript MS BIDS MS SSRS PL/SQL SQL Developer EDIdEv Framework Oracle 11g ModelRight 4.0 MS C# HTML MS VBA MS SSIS ignificant working experience developing with the following:
• Extensive experience creating and parsing 4010 and 5010 ASC X12 EDI files including 277CA, 820, 835E, 837D, 837I, 837P, 999, and 997.
• Training in Big Data (Hadoop) platform, Talend, AngularJS 2.

PROFESSIONAL EXPERIENCE:

Confidential, Maple Grove, MN

Software and Data solutions consultant

Responsibilities:

• Visual Studio 2017, C#, EDIdEv Framework, ASP.NET, MS SQL Server 2016, MySQL 5.x, AWS, Azure deployment

Confidential, Eden Prairie, MN

Senior Applications Development Consultant

Responsibilities:

• Responsible for leading the development of comprehensive data solutions including solution architecture, design, database architecture, SSIS (ETL) development, SQL database tuning, query tuning, complex T-SQL programming, and technical documentation.
• Also participated in mentoring, hiring, product planning, software application design, testing, deployment, and support.
• Agile methodology and close relationships with end-users.

Solution lead

Confidential

Responsibilities:

• Led successful development and delivery of data solution which the business had previously spent millions of dollars on during past couple of years, with no completed usable solution.
• I completely re-architected and lead the successful development and delivery of successful usable solution in 2 months for under $300K.
• This led to a new request specifically for our group to do the same for Confidential .
• Re-architected and redeveloped existing database and business logic for Prior Authorization Grandfathering tool for OptumRx (pharmacy claim system).
• Customer reports significant improvements comparing negative experience with the original product to smooth Grandfathering season in first year of implementation of new solution.
• This success led to significant plans for expansion, and huge potential for marketable product to external RxClaim system users.
• Reduced daily processing time of critical existing ETL operation by optimizing Oracle PL/SQL queries.
• Many other senior developers had previously tried and failed to reduce run-time to below 24 hrs.

Environment: SQL Server 2008-2014; SSIS 2012; SSRS; Oracle 11g; Toad, PL/SQL Developer; T-SQL, VisualStudio 2005-2015; Team Foundation Server; Azure; C#; WCF Service, CA Erwin.

Confidential, Falcon Heights, MN

Principal IT Analyst

Responsibilities:

• Responsible for architecting, modeling, development, and database administration of brand new enterprise SQL Server 2008R2 Data Warehouse (DW). EDW architecture, EDW design, EDW modeling, and development of ETL processes for enterprise DW.
• Hired and managed DW and Business Intelligence staff. Agile methodology.
• Developed (full life - cycle) interactive Excel VBA applications to produce multi tab billing statements matching customer specifications.
• Developed (full life-cycle) algorithms and Excel VBA applications for tracking customer attrition and sales patterns.
• Developed Excel VBA application to track new customer activity, correspondence.
• SharePoint site development.

Environment: Problem solving/data analysis. Logical and physical data model, SQL Server 2008R2; SSIS 2008; Informatica 9.1; MS Excel 2010/Excel VBA; ModelRight 4.0; T-SQL; P/L SQL; Oracle SQL Developer; SharePoint 2010; Crystal Reports XI; MS BIDS; SQL Server DBA; Agile methodology; end-user support; software maintenance.

Confidential, St. Paul, MN

Director of IT

Responsibilities:

• Responsible for: data warehousing of healthcare data, IT infrastructure, full life-cycle software application development (desktop and web) and support, full life-cycle reporting, hardware support, and hiring of IT staff in a small and highly dynamic health actuarial consulting environment.
• Data warehouse architecture design implementation, and maintenance. ETL development (SSIS), testing, implementation, and maintenance. Business plan creation, proposal creation, and marketing participation.
• Hands-on database and software development (VB 6.0, VB.NET) and maintenance.
• Developed hands-on interactive computative web applications (ASP Classic; ASP.NET).
• Interaction with clients and with state and federal government technical staff.
• Agile methodology.
• Developed and implemented a business plan for the development and submission of state-required EDI file reporting (encounter data submissions) for health insurance companies in the state of MN, enabling Cirdan to enter a new line of business assisting our clients with cumbersome government reporting. Designed and developed the software to produce the reports. This line of business was hugely profitable for both Cirdan and our clients. Data warehousing of health care claims and enrollment data; data ETL, X12 EDI file processing, audit trail, and interactive web reporting tool. After our clients outsourced this reporting function to our group, our clients were, and continue to be, rewarded with millions of dollars of revenue previously withheld by the State of MN and returned due to meeting stringent reporting requirements which were previously unmet.
• SQL Server 2008R2; ASP.NET; ASC X12 EDI files including: 277CA, 820, 835E, 837D, 837I, 837P, 999, and 997. SSIS 2008; ASP Classic; VB.NET; ASP.NET; HTML; javascript; vbscript; SQL Server 2008R2; T-SQL; Crystal Reports XI; Access 2010; Visual SourceSafe.
• Independent Consultant, Maple Grove, MN October 2000-October 2006. Classic web and desktop applications for the health actuarial industry. Full life-cycle software development and support for custom desktop and web applications supporting the health actuarial industry. Database design and stored procedures.
• ASP Classic; SQL Server 2000; Visual Basic 6.0; HTML; javascript; vbscript; VBA programming for MS Excel and MS Outlook.

Confidential, Roseville, MN

Vice President

Responsibilities:

• Marketing, full life-cycle software development and support for several proprietary and custom desktop and web applications supporting the health actuarial industry. Database design and stored procedures.
• ASP Classic; SQL Server 2000; Visual Basic 6.0; HTML; javascript; vbscript.