Calvin L. Mouton, Jr.

adye4c@r.postjobfree.com

314-***-****

Professional Summary:

Senior Software Developer with over 30 years of full life-cycle development and conversion of client/server applications. Expertise includes requirements gathering, design, development/ code conversion, testing, implementation, and maintenance of enterprise systems. Possesses experience developing enterprise applications with Microsoft technologies, including C#, Win Forms, WPF Forms, C#.NET, and VB.NET, Visual Basic 6.0, MS SQL Server 2000/2005/2008, Visual Studio 2000/2005/2008/2010, .NET and MS Windows. Recent experience includes C#.Net development with four years experience converting Visual Basic and VBA applications to the C#.Net framework. Extensive data and reporting experience with SQL Server SSRS and SSIS, SQL Scripting (new tables, columns, triggers, views, and defined user groups), development of SQL Stored Procedures, data mapping, data conversions, large data file transfers, and data migrations. EPIC certified w/ training in linked Crystal Report processes and Data Extraction techniques/services for over eight years. Possesses polished written and verbal communications skills and the ability to work independently, part of a team, or to deliver presentations to business owners and clientele.

Technical Summary:

Languages:

Reporting:

Tools / Software:

C#. Net

SSIS

MS Visual Studio Ultimate

VB.Net

SSRS

.NET Framework

VB 6.0

Crystal Reports

Windows Forms

ASP

Tableau

SQL

Architecture:

WPF Forms

UNIX Shell Scripting

Design Patterns

MS Visual Studio 2010

Databases:

OO Design

C#.Net Performance Analysis

SQL Server 00/05/08/2010

N-Tier Application Design

Rational ClearCase

SSIS Packages SQL

Methodologies:

Team Foundation Server

DTS Packages

Rational Unified Process

FTP Protocol/File Transfer Mgt

MS Access 2003/2007

SDLC, Waterfall

MS SQL Server Mgt

Oracle

Iterative

Appworx/UC4

Stored Procedures

Linux Backup Servers

SQL Server 2017/2018

MS Power BI

Tortoise SVN

Professional Experience:

Insight Global (Charter Communications, St. Louis, MO 08/29/2022 – 06/16/2023

SQL Developer IV

As a SQL Developer IV assigned to work at Charter Communication - COMDESK, I contributed to and helped validate the technical systems that support the availability of data and analytics solutions built and maintained for all IVR POC (Interactive Voice Response) project systems that will replace their old Call Tracker system.

Duties/Responsibilities included:

Understand business requirements communicated by senior developers and upper management to translate them into technical solutions that support scalable analyses

Function as a subject matter expert across the entire IVR POC system to provide data viability and possible solutions based on staff inquiry

Work on system ticket requests and provide solutions with either data or report.

Based on SSRS ticket requests, provide solutions in SSRS formats

Provide various UAT testing of CommDesk internal dashboards and systems to report discrepancies

Provide query review and analysis on current code and update to make more efficient

Create solutions/pull data to provide UAT team descriptive analysis in making decisions based on system data

Review/Identify methodologies to make improvements in process efficiency

Deliver technical and scalable analytic solutions

Contribute to the expansion of the analytic capabilities

Technologies used:

MS SQL Server

SQL Queries

MS Visual Studio

oSSIS packages

oSSRS Report Facility

MS Office Suite 2016

MS Power BI

Tableau

ASP.net

Navvis, St. Louis, MO 10/2020 – 03/2022

Senior Data Operations Analyst

As a Senior Data Operations Analyst, I contribute and help organize the technical systems that support the availability of data and analytics solutions built and maintained for all business verticals at Navvis.

Duties/Responsibilities included:

Understand business requirements communicated by stakeholders and translate them into technical solutions that support scalable analyses.

Function as a subject matter expert across the enterprise on attribution, claims loads, reconciliation, and lead efforts with stakeholders to resolve discrepancies.

Work with Market Analysts to provide scalable analytic solutions

Drive effort to understand trade-offs and prioritize deliverables.

Build and QA required data tables for scalable reporting

Promote new scalable reports into production environments

Act as a Data Steward on the Data Governance Committee

Clearly identify and mitigate data risks

Deliver technical and scalable analytic solutions

Contribute to the expansion of the analytic capabilities

Technologies used:

MS SQL Server

SQL Queries

Visio

MS Visual Studio

oSSIS packages

oSSRS Report Facility

MS Office Suite 2003/2007

MS Access

MS Power BI

Sisters of Mercy, St. Louis, MO 10/2012 – 10/2020

Epic Data Analyst III

Working within Sisters of Mercy on the Mercy Technology Services team, I was responsible for translating and programming vast amounts of data into understandable, relevant and actionable information. Interfacing with internal hospital departments across the organization and with external hospital systems, I used my expertise to provide business insights, design and deliver reports, and drive self-service reporting capabilities across external and internal organizations. Actively engaged in developing and promoting effective data governance through documentation and adherence of standards to assure that the information produced and provided by the Data Extraction team is accurate and trusted as the source of truth.

Duties/Responsibilities included:

Responsible for identifying, understanding, acquiring, merging, and transforming data from a centralized data warehouse

Partner with business unit teams to understand their operational needs, recommend solutions, assure compliance with standards

Translate data needs of the business and work with data engineers or architects to build processes and tools that help automate effective data delivery and reduce resource utilization and redundancy

Engage in the overall data governance of the organization and take an active role in the development, documentation and on-going maintenance of a data governance operation

Develop effective auditing and validation processes between the source systems and the centralized data warehouse to assure accurate and timely availability of data

Develop, test, and deliver reports and extracts from the centralized data warehouse using appropriate BI tools

Monitor, schedule and deploy data extracts functions as needed to transfer data to end receiving clients

Constantly look for better ways of solving technical problems and designing the solution, not afraid of challenging the status quo

Mentor and coach the broader Data Extracts Delivery team

Be hands on and engage in coding to help the team to develop his / her solution and solve all surfacing problems at hand

Technologies used:

MS Office Suite (Word, Excel, PowerPoint, Visio)

Stored Procedures

MS Visual Studio 2008

Department SDLC practices

Oracle Database

T-SQL

SQL

Appworx/UC4 Job Scheduler

Linux archive servers

Tortoise SVN

EPIC EHR System

Crystal Reports

Key projects included:

Project 1: “Cancer Patients List” (SQL Query System)

Scope of project – Identify all diagnosis for cancer patients and criteria to pre-determine treatment processes for each patient

Provided new code to perform necessary functions and adjustments explained in cancer patient treatment requirements

Liaise with business line, manager and Mercy department of Oncology

Provided preliminary test plan after following company SDLC

Technologies used:

Oracle Database

SQL Queries

Appworx/UC4 Scheduler

Linux Archive Servers

MS Office Suite

EPIC EHR System

Project 2: “CHI Data Warehouse” (SQL Query System)

Scope of project – Collect CHI(Catholic Health Initiative) data from Mercy based EPIC EHR database to provide client with means to build their Data Warehouse

Provided new code to perform necessary functions and adjustments explained in business requirements

Develop/schedule Appworxs jobs to FTP data collected by category

Liaise with business line, manager and QA Testers

Provided preliminary test plan after following company SDLC

Technologies used:

Oracle Database

SQL Queries

Appworx/UC4

TortoiseSVN

MS Office Suite

EPIC EHR System

Technisource Consulting Services

US Bank, St. Louis, MO 4/2012 – 8/2012

Prgrmr/Appl Systems Anlyst I

Assigned by Technisource to assist the BTSS Group (Business Technology System Support) at US Bank in completing a myriad number of development projects using Visual Basic 6 with the possibility of converting to Visual Basic .NET. I also had to be able to work/understand business requirements, provide development and testing phases of the typical software development life cycle and perform SQL Server development using stored procedures to support the development created in VB6.

Duties/Responsibilities included:

Develop new and/or upgrade/maintain legacy in house desktop applications testing phases of the typical software development life cycle (SDLC)

Liaise/assist business analysts and managers to gather business requirements and provide solutions for projects requested by the department line of business (LOB)

Provide project documentation and written test plans

Ability to understand and learn the business processes involved

Develop new or enhance databases using SQL Scripting as per project requirements which includes new tables, columns, triggers, views and defined user groups

Technologies used:

MS Office Suite (Word, Excel, PowerPoint, Visio)

Stored Procedures

MS Visual Studio 2008

Department SDLC practices

MS SQL Server Management Studio 2008

VB .NET

VB6

T-SQL

SQL

Extra Extreme (Screen Emulator)

Lotus Notes

Tortoise SVN

Key projects included:

Project 1: “CardsDesktop” (Application Enhancement in VB6)

Scope of project – Disallow fee waivers unless the customer is put on a

hardship or workout program

Provided new code to perform necessary functions and adjustments explained in business requirements

Liaise with business line, manager and QA Tester

Provided preliminary test plan after following company SDLC

Technologies used:

MS SQL Server 2008

SQL Queries

MS Visual Studio 2008

VB6 with TortoiseSVN

MS Office Suite 2003/2007

Project 2: “CardsDesktop” (Application Enhancement in VB6)

Scope of project – Correct the way the Collections System updates the Hogan mainframe

with current information since this is not done currently

Provided new code to perform necessary functions and adjustments explained in business requirements

Enhanced the application to allow users to select a particular customer profile from a list of multiple profiles that may be displayed for that customer.

Liaise with business line, manager and QA Tester

Provided preliminary test plan after following company SDLC

Technologies used:

MS SQL Server 2008

SQL Queries

MS Visual Studio 2008

VB6 with TortoiseSVN

MS Office Suite 2003/2007

Bank of America, St. Louis, MO 06/2006 – 09/2011

Applications Programming Analyst

As an Applications Programming Analyst, I served as a member of the Process Solutions team. Responsibilities include providing clear, concise and timely processing solutions for a myriad number of issues and systems within the Overdraft Recovery Services department.

Duties/Responsibilities included:

Developed new C# code and/or upgrade/maintain legacy VB.Net in house desktop applications using department full system development life cycle (SDLC).

Served as a liaison between Development and Business Analysts to gather business requirements and provide feasibility studies for projects requested by the department line of business (LOB).

Provided project documentation and data/process mapping specifications to include both High Level and Low Level designs.

Created new or enhance data feeds required by project specifications.

Developed new or enhanced databases using SQL Scripting as per project requirements which include new tables, columns, triggers, views and defined user groups.

Performed data mapping and entity diagrams for table and database creation.

Provided deployment of new/enhanced deliverables to end users.

Provided security access to end users through SQL data manipulation or direct data changes to security tables per application requested.

Designed new SQL Server databases as required.

Incorporated new/enhanced SSIS Packages per application as indicated by project specifications.

Incorporated new/enhanced SSRS Reporting per application as indicated by project specifications.

Utilized the Team Foundation Server while developing new or enhanced solutions.

Monitored/Supported solutions in accordance with SDLC.

Served as the first POC for end users to provide temporary/permanent solutions reported by end users via in house performance improvement effort and issue tracking.

Liaised with collection vendor managers to provide data feed management of all department data feeds required by our collection affiliates.

Provided procedural documentation for all new/enhanced desktop applications.

Provided SIT and UAT tests for all new/enhanced applications.

Created/Scheduled all UAT tests and create test plans/scripts for the line of business.

Attended department manager’s meetings to provide updates on current projects.

Ran daily file import processes for our IT group.

Assisted with data conversions, data file transfers, supporting 3270 terminal emulator applications, maintaining all legacy department applications and supporting users at remote locations.

Key projects included:

Project 1: “In House Project Tracker” (new development in C# .NET)

Scope of project – Create a new application in C# .NET to replace the existing MS Excel spreadsheet used by IT manager in order to more efficiently track and assign IT projects

Built a new database for the application

Designed/created all user interfaces

Coded all data layers, event calls in C# .NET in addition to all data queries to the new database

Technologies used:

MS SQL Server 2005/2008/2010

SQL Queries

MS Visual Studio Ultimate 2005/2008/2010

C# .NET 4.0 with TFS (Team Foundation Server)

MS Office Suite 2003/2007

Project 2: Conversion of Non-Credit Loss (NCL) application to C# .NET

Scope of project – Convert all existing processes, reports and functionality of MS Access application to C# .NET

Provided analysis with documentation of process maps

Followed each aspect of the department’s System Development Life Cycle process

Converted all application functionality from MS Access to SSRS reporting facility

Technologies used:

MS SQL Server2005/2008/2010

SQL Queries

Visio

MS Visual Studio Ultimate 2005/2008/2010

oSSIS packages

oSSRS Report Facility

C# .NET 4.0 with TFS (Team Foundation Server)

MS Office Suite 2003/2007

Project 3: Conversion of Reclamations Inventory Process System (RIPS) application to C# .NET

Scope of project – Converted report process module of MS Access application to C# .NET using SSRS Report facility to automate and deepen legacy report functionality

Provided analysis with documentation of process maps

Followed each aspect of the department’s System Development Life Cycle process

Converted all report functionality from MS Access to SSRS reporting facility

Technologies used:

MS SQL Server2005/2008/2010

SQL Queries

Visio

MS Visual Studio Ultimate 2005/2008/2010

oSSIS packages

oSSRS Report Facility

C# .NET 4.0 with TFS (Team Foundation Server)

MS Office Suite 2003/2007

Technical Environment: C# .NET (Windows and WPF forms), MS Visual Studio Ultimate 2010, MS SQL Server Management Studio, TFS (Team Foundation Server), VB .NET, SSRS Reporting, SSIS and DTS Packages, MS SQL Server Job Agent, Stored Procedures, SQL Database Scripting, SQL, FTP protocol and file transfer management, Crystal Reporting, Crystal Reports, MS Access 97/2007, and MS Office Suite (Word, Excel, PowerPoint, Visio, Outlook)

Operations Analyst – ATM Network Support 06/2006 – 05/2007

Provided analysis, servicing and research for over 16,000 bank ATM’s and their Networks at a technical level.

Monitored all ATM functions via GASPER monitoring software and initiated software upgrades using Tivoli.

Utilized MS Office products (including MS Access) to provide reporting of service calls, service scheduling and technician responses.

Technical Environment: MS Office Suite (Word, Excel, Outlook), MS Access 97/2007, GASPER ATM Monitoring software, and Tivoli Software .

Sons Mouton, INC., St. Louis, MO 06/2003 – 06/2006

Property Manager

Started my own business by providing property management to 7 self-owned properties and 17 tenants. Acquired a Missouri Real Estate license to assist in procurement of properties and worked with the following agencies: Mary King & Associates and McAvoy Realty.

Provided the following services for business/management:

Scheduled and coordinated maintenance according to timelines.

Managed a team of eight employees on an operation and project level.

Created and maintained property management software using MS Access.

Performed business critical Account Receivable, Accounts Payables, and payroll functions.

Technical Environment: MS Office Suite (Word, Excel, Outlook)

A.G. Edwards & sons, St. Louis, MO 06/2000 – 06/2003

Senior Programmer/Analyst

As a Senior Programmer Analyst was assigned to the Visual Basic Utility support group to participate in the company’s 32 bit conversion of all desktop applications utilizing Visual Basic 6.0 SP 4 in a Sybase, Crystal Reporting environment. Desktop applications included: 5498 Corrections, Stage2, Branch Banking, Periodic Purchase Plan, 1099 Reports, among others.

Provided support for various systems that used Honeywell mainframe JCL, Cobol, Unix and peripheral systems.

Created a “Rational ClearCase” quick start manual now used throughout the department.

Provided mentorship for several co-workers making the leap from mainframe development to client server.

Visual Basic 6.0 SP 4 in a Sybase, Crystal Reporting environment.

Education :

United States Air Force Academy

Major: Mechanical Engineering - 66.5 hours completed

University of Southwestern Louisiana

Major: Mathematics/Computer Science - 20 hours completed

Fontbonne College

Major: Mathematics/Computer Science - 27 hours completed

*Currently pursuing completion of BS degree

References provided upon request*

Contact this candidate