Candidates About

 

Mark Bolton

 

PROFESSIONAL SUMMARY Detail

 

Experienced with a variety of Enterprise Software and Applications including Healthcare, mobile, Government, military, Aerospace, Finance, Engineering and data management.

 

Database

Very versed with Data Modeling, Data Sourcing, Data Transformation, and Collection rules, Systems and OLAP, NoSQL databases.

Have strong programming development skills in Object Oriented Concepts.

Excellent DBA skills ranging from traditional RDBMS to NoSQL.

Experience in ETL and Reports

Experience Data modeler

Experienced in writing PL/SQL and T-SQL complex queries

 

Web Applications

Developing application in Asp.net C#, VB.Net

Used Bootstrap and JQuery for rapid web development

Experience creating applications with AngularJS and Knockout

Experience migrating programming languages to newer technologies.

 

Windows Application

 

Designed rich application in Windows(WPF) C#

Created Universal Windows Apps

Created hybrid HTML5 and WPF application with OWIN and Awesomium

Designed multi-threaded process for high performance application

Created Winform applications with VB, VB.Net, C#, Delphi, C++ and C.

Created WCF application

Mobile

Used JQuery mobile and HTML5 to write

Developed Android applications with Android Studio

Developed native Windows Phone applications

Developed Xamarin applications

Knowledge in Oracle Mobile and

 

                                                                                                                               MVVM (MVVM Lite, Caliburn Micro), MVC (Razor, Magellan), Visitor Pattern, Singleton, Factory Pattern, Proxy Design Pattern, Facade Pattern and more

EDUCATION:

Corporate Training                       Certification in Application and Report design, Sybase,

And Certification                          Data warehousing, Oracle EBS (Mfr, Inventory, Project and

                   Supply Chain), Disaster Recovery, TeamCenter, Android

Excelsior College                               Bachelor's emphasis in Computer Science

EXPERIENCE

Skilyne International, Kansas City Kansas(01/15 to present)                                                In house Web and App Developer

Project: Various projects

 

●        Currently studying how to implement the SQL Server 2016/Azure SQL Database NoSQL hybrid approach into the current GoRydz business model to accommodate overlapping application using various sources.

●        Using SQL Server, VB.Net and WPF to write customized application for pest management.

●        Wrote CTE and used Vendor specific SQL languages over general SQL.

●        Wrote business logic and rules into a object relational model that overlaid vendor database.

●        Rewriting Android application to Xamarin to port over to other platforms

●        Writing Universal App for desktop application and Windows Phone with UWP, WPF, XAML in Windows 10 style design

●        Wrote ETL Scripts and integrated SSRS reports into an external website.

●        Helped write GoRydz mobile application in Android and .Net

●        Developed .Net classes and Xamarin to model Android interface.

●        Using VS 2013, .Net framework 4.5, LINQ, Entity Framework and C# on front end.

●        Used NUGET, Github and Team Foundation to share and manage code.

●        Used Android SDK and Studio to develop application.

●        Worked on MVC model of web Application with AngularJS and Bootstrap.

●        Wrote responsive websites with AngularJS, Bootstrap and HTML5 for both mobile and web.

●        Use SQL Server, Node.js, WCF, MongoDB and MySQL for back end

●        Project went from wireframing to workflow to implementation for both mobile and PC.

●        Used Microsoft Typescript and Angular 2 to develop mobile and web application.

●        Working on implementing MVVMCross in a Xamarin application.

 

Technologies:

C#, Android, MVC, WCF, MVVM, Web API, JSON, Java, WPF, SQL Server, MySQL, Angular, Bootstrap, Javascript, Linux

 

OTSI (September 2016 to Mar 2017)

Sr. Windows Developer

Project: WolfCreek

Created a C# WPF and HTML5 user interface application to allow user to navigate through archive of documents and program specifications without typing or entering data. Users were able to process information through computers and touch screen devices with ease.

Used Installshield to deploy the application.

 

Project Health-Outcomes

Working with SQL Server, Power BI, Nodes JS, SSIS, SSAS and SSRS to provide predictive modeling to customers. Worked with SQL Server creating SQL scripts and running jobs and doing backup. Main job was to provide suggestions to an open database architecture design.

 

 

Deloitte and Cerner, Missouri (July 2014 - May 2015)                                                 Senior Consultant (3rd contract position with Deloitte)

Project: Revenue Analytic, provides reports using Cerner proprietary CCL and Oracle for the medical field.

RKV Technologies

Missouri Attorney General Office

Major responsibilities:

●        Create customized CCL scripts for customer enhancements and improvements.

●        Learn the medical field billing and payment systems.

●        Retrieve data from the data warehouse for reports

●        Create efficient PL/SQL scripts for performance

●        Scheduled batch jobs and executed mainframe scripts to populate BI data warehouse

●        Integrated PL/SQL Script with CCL into batch files to provide solutions for healthcare billing and administrative costs that followed established business logic and guidelines.

●        Recommended and implemented the frameworks using SQL, SQL Server and MySQL database to help track and pinpoint fraud claims by medical providers.

●        Reengineered MySQL scripts and database structure to a more efficient model.

●        Involved in requirements gathering and proposals for a data mining applications.

●        Wrote ETL applications in C# to supports insurance vendor’s data to government databases.

●        Used data structures such as CTE and tools like SQL Statistics to properly optimize queries.

●        Designed customize reports in SSRS for to pinpoint irregular activities.

●        Defined the business logic in the database by creating constraints and triggers and stored procs to help define how the data will be interpreted from any source that retrieves it.

●        Designed Windows WPF application for user interface

●        Made usage of SQL design patterns to create more efficient processing.

●        Executed mainframe scripts to populate BI data warehouse

●        Resolving Jira’s created in an Agile environment.

●        Created and Implemented SSIS packages to merge vendor insurance claims detail into data warehouse to trace and detect abnormalities in billing in case of medicaid fraud.

 

Technologies:

C#, ETL, Oracle, CCL, BI, Agile, Scrum MySQL, C#, WPF, SSIS, SSRS, SQL Server, T_SQL

 

Adaptive Solution Overland Park, KS (March 2013 to May 2014)

Development Architect

Project: Hired to architect the legacy VB6 application to C#, Oracle and WPF.                          

●        Directed the implementation of a legacy client server application to a more modern design.

●        Converted VB6 code to C#, WPF LINQ, Entity Framework and Oracle.

●        Converted some code to MVC and then to MVVM model.

●        Create SQL structures (Pipeline function, OOD classes) and objects in Oracle

●        Used Oracle dynamic object's type to simplify code and make it easier to manage and employ changes without major changes to application.

●        Used SQL design pattern for PL/SQL to create more efficient code.

●        Used Github and TFS to reduce development time and resources

●        Used Clickone to deploy the application.

 

 

 

 

Boeing Wichita. KS (October 2012 to March 2013)

Ongoing - Architect (4th time working as a consultant with Boeing)

Project: Rewrote and updated Business project software to new security standards

●        Directed the team on technical design and application solution to meet business needs.

●        Converted some VB6 code and 2.0 .Net applications to 3.5 and 4.0 standards using C#.

●        Modified Oracle Apex scripts for updated business rules in application.

●        Updated JavaScript and HTML scripts to implement a part and supply application.

●        Worked with Oracle SOA suite (OSB) to support interchange among legacy systems.

●        Created efficient T-SQL, PL/SQL queries, CTE’s and packages for heavy populated tables

●        Created customized SSRS reports for various departments

●        Wrote Unix scripts and Pro*C applications to run batch jobs to populate data sources.

●        Resolving Jira’s.

●        Wrote SSIS packages to upload from the AS400 into SQL Server and Oracle databases.

●        Used Oracle Olap to create dimensional cubes and OBI to query for results.

 

Johnson County Tax Assessor Office, Olathe. KS (Nov 2011 / May 2012)

Senior Programmer Analyst (SQL Server and ASP.Net)

Project: Helped customized the Mannitron Tax software

●        Designed, developed new forms and modified existing forms using VB and used C# to build DLL libraries to be used to interfaced the mainframe data to the accounting software.

●        Modified all existing forms to integrate vendor API calls to the Mannitron SDK with customized ASP.Net controls.

●        Designed and implemented the SQL objects to enforce business rules and logic in the database structures to connect with the AS400.

●        Wrote complex SQL Server scripts to speed line the process of calculating taxes from multiple municipalities and ensure applied business logic and regulations.

●        Used SSIS to migrate data from the AS400’s Cobol and RPG files to SQL Server and created batch files to manage file transfer and scheduling jobs.

●        Integrate all changes done by other developers and performed all unit testing before deploying it to QA.

●        Attended team meetings on weekly basis along with manually quantifying results from development code against paper reports.

●        Main designer on enhancing new screens and reports in SSRS from the mainframe.

●        Implemented SQL Server CTE types to reduced complexity of SQL code and make application more manageable.

●        Wrote customized reports in SSRS for various departments.

 

Terracon, Della’s Gifts, Sarah's House                                 March 2007 - June 2011

Programmer Architect

Project: Key major responsibilities:

●        Re-tuned MySQL scripts for increasing performance from hours to minutes.

●        Normalized database to reduce redundancy and increase efficiency.

●        Created ETL scripts for file transfer to Oracle, MySQL and SQL Server 2012 using SSIS.

●        Created .Net scripts to managed improperly formatted files.

●        Provided suggestion to help maintain database and system issues.

●        Created reports in Excel and SSRS

●        Laid out architect to implement a data warehouse

●      Redesigned the payroll system application in C, C++ and UNIX to C#, SQL Server and Oracle.

●      Designed web pages and writing business guidelines to conform to HIPAA regulations.

●        Maintained backups, tuned scripts and scheduled DBA tasks using SQL Server, SQL profiler and SSIS.

●      Was assigned project lead in converting MySQL application to Oracle and Apex development

●      Used legacy Cobol scripts and reports from AS400 to a SQL Server database to work seamlessly with hospital systems.

●        Architect the design methodology on the interface from the Oracle Database to UI.

●        Coordinated the team with instruction how to produce the most efficient and fastest processing of data from each established point.

●        Implemented a standard protocol of of interfacing with packages instead of scripts.

●        Worked with various department heads to gather information and feedback on application solutions.

●        Writing code for HR under Oracle 11i application and Spatial for GPS applications.

●        Used the ANALYZE FUNCTION and DMBS_Stats to analyze performance on indexes

●        Used trcsess utility, DBMS_Monitor and Quest query analyzer to identify and create performance plans to tune SQL Code and N-tier applications.

●        Used Oracle Olap to create a data warehouse for processing data and data mining.

 

Blue Cross/Blue Shield of Kansas Topeka, KS                          Aug 2006 - Feb 2007                Developer/Modeler (Consultant)

●        Prepared project specification and scope document

●        Modeled the design of the customer billings database to be applied to SQL Server and DB2 by integrating the mainframe reports, customer requirements and project plans.

●        Identified critical dependencies in project life cycle and risks

●        Created VB.net and C# applications and class libraries to enhance current applications and provide better performance and extensibility from COBOL script.

●        Reviewed the project status with the customer and implemented feedback suggestions.

●        Modified the Cobol, JCL and CICS script on the AS400 to work with transferring over changes in the new files from the old.

●        Wrote batch script in conjunction with mainframe to populate the database.

●        Wrote SQL language statement to the DB2 access service through a SQL Server RPC.

 

Pearson   Lawrence, KS                                                                 Oct 2005 - Jul 2006            

Developer DBA Architect Government Services/ATG (Consultant)

●        Main responsibilities were to work closely with a team of developer in the involvement of application design to implementation of the Senior Pharmaceutical Discount Applications.

●        Maintained the database and did general DBA duties, designed the data structures and loading strategy for various business components.

●        Gathered business requirements to analyze huge amounts of customer data on mainframe.                   

●        Worked as a SQL Server Development DBA with the Pearson Government Services division on the senior citizen pharmaceutical and medical division.

●        Secondary responsibility was to write VB scripts and ASP.Net pages that interfaced with the database.

●        Wrote new reports to interact with .Net applications against the mainframe using SSRS.

 

 

MedMobile Software Long Beach, CA                                           Dec 2003 – Mar 2005         

Developer DBA (Consultant)

●        In charge of a small startup company IT department that developed an access web based information portal that streamlined medical business processes and HIPAA regulations

●        Configure customized application for pre-sales team to integrate with the client database for customer evaluation. Also, deployed resource strategies with sales team, for key subscribers and other customers that utilizes their feedback and inputs to adjust sales strategies.

●        Responsible for loading customer tables into presales database by using SQL Loader and other ETL procedures from Cobol and RPG data files.

●        Responsible for programming software user interface updates using the following tools: VB6, Delphi, VB.Net, Oracle HTML DB, C#, C, Pro*C, C++ and MFC, Java and SAS.

●        Databases supported Access, Oracle, SQL Server, MySQL and DB2.

●        Created data warehouse using Oracle to support data mining.

 

 

JPL/NASA      Pasadena, CA                                                                       Aug 2001 - Oct 2003

Oracle Consultant

●        Pervasive DBA and Oracle Data Migration and Provision Specialist in charge of maintaining legacy applications (parts distribution, inventory, and Bill of Materials) and migrating data to Oracle 10.7.

●        Worked with the Oracle consulting group in conversion of business rule to data transformations, and document processing using Perl, Pro*C and UNIX scripts.

●        Used Visio to define the process, BRIO for the workflow and data analysis, ERWIN to structure the extraction tables along with Oracle DW Builder 9.2.

EPINS Architect

●        Converted the EPINS (Electronic Parts and Inventory system) from a third party supported system to an in-house application and later directed the architect to be encompassed in the Oracle Parts and Supply Chain module.

●        Constructed the interface for all internet/intranet applications that interfaced with the module in HTML, XML, Oracle Developer and .Net (VB.Net, ASP.NET and C#).

●        Provided guidelines for based in interfaces on accessing the data by outside sources

●        Wrote SAS scripts using PROC SQL to export data to Pervasive Database and Oracle

 

Boeing            , CA                                                    Dec 1999 – Jul 2001

Web developer/Application Architect (2nd time working as a Consultant)

●        Worked on the government C17 project designing for engineers’ front end applications and web pages using Java, JavaScript, Oracle Forms, PL/SQL, VB, Crystal Reports and VBScript.

●        Used Erwin, SQL Server, IIS and Oracle to create the database for the web pages.

●        Wrote SAS script store large dataset to be analyzed and extrapolated to Oracle.

●        Wrote user interface in Oracle HTML DB,

●        Oracle DBA/Developer with the secured government defense division.

●        Major duties were addressing, documenting and correction of Oracle software bugs by filing TARs, administration of table space and extent allocations on a non-secured environment. Also, did backup and recovery, normalized the database structure to 3^rd degree and provide performance tuning.

●        Installed and configured gateways (Oracle Transparent Gateways) and protocols

●        Used EXPLAIN PLAN, TRACE and TKPROF to create more efficient SQL scripts.

●        Other responsibilities was to design Oracle Reports and forms (6i), using PRO*C, C++, Oracle Web server for reports and debug complex PL/SQL code for efficient coding.

 

 

 

 

Other Work Experiences before December 1999

 

Entertainment

Worked as a consultant for companies such as DirecTV, NBC, CBS, Disney and Sony

 

Aerospace

Worked as a consultant for Raytheon, Hughes and TRW

 

Engineering

Worked as a consultant for Odetics and Tops Engineering

 

Healthcare

Worked as a consultant for LA Health Department, Drew Medical School and Pacificare

 

Finance

Worked as a consultant for Wachovia and Dresdner Kleinwort Benson and

HR Block