Resume

Business Intelligence Ms Sql

Location:

Lenexa, KS

Salary:

120-140k/yr

Posted:

August 28, 2023

Contact this candidate

Resume:

Marty Cline

Business Intelligence (BI) & Robotics Process Automation (RPA) Solution Architect/ Manager with Security Clearance

BI & RPA Solution Developer, Technical Lead, Architect & Manager

20+ years of IT experience in various roles (Robotics Process Developer and Architect, Business Intelligence Developer & Architect, Database Developer, Database Administrator, Business Analyst, Program Management, Solution Architect, and Management).

Led multi-year strategic programs and projects for Engineering, Operations, Finance and IT departments. Formed specialized group (Decision Analytics Group) that identified alternate means and technologies to solve business problems.

Architected, developed, and managed Numerous BI Solutions & RPA projects for various departments.

EDUCATION:

Bachelors Degree in Business Management (3.8 GPA) from Friends University, 2100 University, Wichita, Kansas 67213, Graduated with High Honors and Deans Honor Roll. Degree completed in 2001. (Pursuing an MBA)

WORK EXPERIENCE:

Main Sail/Accenture Federal Services (Consulting) - Department of Defense - Naval Support Activity Mechanicsburg – BI/RPA Solution Architect (Sept, 2021 – Aug. 2023)

Provided Process & Technical (Solution) Architecture guidance for Robotics Process Automation (UiPath)

Created Process Definition Documents, Solution Design Documents, SOPs, forms and instructional documents for Code Reviews, Deployment & Coding Checklists, Deployment Change Requests & Promotions

Applied best practices at every opportunity when guiding other developers and the client

Automations (Team delivered over 54 automations, versions updates, and enhancements to production)

The following list details the software and technologies used;

UiPath 2021

Azure (Dev Ops)

Microsoft Office Suite (Outlook, Visio, Excel, Word, PowerPoint, Skype)

Microsoft Teams

22nd Century Technologies, Inc. (Consulting) - Department of Defense – BI Solution Architect/Developer (Nov, 2020 – Jul, 2021)

Provided Business Intelligence Architecture guidance for MS Power BI application

Developed Business Intelligence solutions on several reporting platforms (Tableau & MS Power BI)

Developed Database objects, processes and schemas for Business Intelligence projects

Created SOPs, forms and instructional documents for Code Reviews, Deployment & Coding Checklists, Deployment Change Requests & Promotions for several reporting platforms (Tableau & MS Power BI) and database development

Applied Business Intelligence best practices at every opportunity when guiding other developers and the client

The following list details the software and technologies used;

Management Studios (SSMS) 2014

Power BI 2.93.981.0

Tableau 2021.1.0

Microsoft Visual Studio 2019 16.10.1

TFS/Azure

Microsoft Office Suite (Outlook, Visio, Excel, Word, PowerPoint, Skype)

Microsoft Teams

WinSCP 5.11.3

Cognizant (Consulting) – City National Bank – Associate Director, Client Side: RPA Solution Architect (Nov, 2019 – Aug, 2020)

Worked with Business Analysts to ensure existing processes were documented in the Process Design Documents (PDD) where generated correctly for all processes

Created the Solution Design Documents (SDD) for all processes

Created Future State Flow Diagrams for all processes

Worked closely with the off-shore developers and guided them through potential development issues

Worked closely with the client to ensure deadlines were achieved

Created Code Checklists

Pushed best practices when guiding developers

The following list details the software and technologies used;

UiPath Robotics Process Automation (RPA) 2019.10.4

Microsoft Office Suite (Visio, Excel, Word, PowerPoint, Skype)

Management Studios (SSMS) 2014

Tableau

HNTB Corporation (Full Time) - Senior Business Intelligence Solutions Architect/Developer (Dec, 2012 – Oct. 2019)

Created a development copy of all databases to be used as a research and development environment

Managed a team of developers called the Decision Analytics Group in a research and development environment providing solutions to the business by solving problematic issues of various scales with various software tools (see “Applications” listing)

Managed several projects for Financial Service using RPA

Created the in-house Center of Excellence (CoE) documenting standards, best practices and approved development methods

Served as a Business analyst gathering requirement for projects, while understanding systems and processes

Served as a Database & BI Developer on projects using a wide selection of various tools and evaluating tools for purchase if we did not have a current license for the right tool

Served as a Project Manager guiding the development lifecycle of projects interfacing with the business and the developers

Served as a Solution Architect for Robotics Process Automation (RPA) for end clients ensuring solution designs conveyed the proper design elements for successful Robotics Process Automation deployments

Identification of the Automation opportunities (RPA, RDA, ML, OCR)

Process assessments of potential RPA candidates

Exposure to multiple tools to enable Automation (UIPath, Automation Anywhere, Workfusion, BluePrism,)

Complexity estimating of Processes

SOX compliancy

Created Business Intelligence solutions, dashboards and reporting methods using various tools sets

Operated in Information Technology, Engineering, Operations and Finance departments

Promotion of solutions through all environments (Development, Quality Assurance & Production)

The following list details the software and technologies used;

Automation Anywhere Robotics Process Automation (RPA) 11.3

UiPath Robotics Process Automation (RPA) 2018.x

Management Studios (SSMS) 2014

Visual Studios (SSVS) 2015

Integration Services (SSIS)

Reporting Services (SSRS)

Analysis Services (SSAS)

Report Builder (SSRS)

Power BI Desktop

Tableau

Data Query (legacy Software)

Excel Services

VBA & macros

PerformancePoint

PowerPivot

SharePoint

SQL Databases - (development & reporting)

Oracle Databases - (reporting)

Microsoft Office (Outlook, Word, Excel, Access, PowerPoint, Visio, OneNote, InfoPath, Publisher, Skype)

Object Technology Solutions Inc. (OTSI) (Consulting) - Erricson - Business Intelligence Architect/ Developer (May, 2012 – Nov, 2012)

These duties included the following brief description:

ETL - Design, development, deployment, and administration of ETL using MS SQL Integration Services version 2008 R2, SQL Server Management Studios 2008 R2, Visual Studios 2008 R2, & Excel 2007

Reporting Services (SSRS) version 2008 R2

Reverse engineering of Access reports

Data profiling

SQL & Oracle Databases

Business Intelligence

MegaForce (Consulting) - Quest Diagnostics - Business Intelligence Developer (Sep, 2011 – Apr, 2012)

These duties included the following brief description:

ETL - Design, development, deployment, and administration of ETL using MS SQL Integration Services version 2008 R2, SQL Server Management Studios 2008, Visual Studios 2008, TOAD for Oracle 9.1, TortoiseSVN 1.6.15, TaskFactory 2.0, Data Profiling, Subversion Tortoise Subversion Source Control Management (SVN) 1.6.15, Visual SourceSafe 8.0 & Excel 2003 SP3

Reporting Services (SSRS) version 2008

Data profiling

SQL & Oracle Databases

Tortoise Subversion Source Control Management (SVN) 1.6.15

Business Intelligence

Tek Systems/HP (Consulting) - USDA - Business Intelligence Developer (May, 2011 – Sep. 2011)

These duties included the following brief description:

ETL - Design, development, deployment version conversion, and administration of ETL using MS SQL Integration Services version 2008, SQL Server Suite 2008, Visual Studios 2008, Excel 2007 & DataStage Ver. 7.5.1

Reverse engineering of DataStage ETL packages

Putty Ver. 0.60

Integration Services Packages (SSIS)

Business Intelligence

Anita Anderson & Associates (Consulting) - DynCorp International - Business Intelligence Developer (Jun, 2010 – Nov, 2010)

These duties included the following brief description:

Reporting - Design, development, deployment version conversion, and administration of reports using MS SQL Reporting Services version 2008, SQL Server Suite 2008, Visual Studios 2008 & 2010, Excel 2007, Access, VBA & Team Foundation Server

Reverse engineering of Access reports

Integration Services Packages (SSIS)

Tables, Views, Stored Procedures, Functions, Queries, Optimizing & Data modeling

MV Transportation Inc. (Full Time) - Business Intelligence Developer (May, 2009 – Jun 2010)

These duties included the following brief description:

Reporting - Design, development, deployment version conversion, and administration of reports using MS SQL Reporting Services version 2005, SQL Server Suite 2005, Visual Studios 2005, Dundas Charts, Excel 2007, Crystal, Access, VBA & Team Foundation Server

Reverse engineering of Crystal reports

Tables, Views, Stored Procedures, Functions, Queries & Optimizing

J. M. Neil & Associates, Inc. (Consulting) - Highland Community College - Business Intelligence Developer (Mar, 2009 - May 2009)

These duties included the following brief description:

Reporting - Design, development, deployment version conversion, and administration of reports using MS SQL Reporting Services version 2005, MS SQL Server Suite 2005, Visual Studios 2005

Integration Services Package (SSIS)

Tables, Views, Stored Procedures, Functions, Queries & Optimizing

Paige Technologies/EMC (Consulting) - Chesapeake Energy Corp.- Business Intelligence Developer (Jun, 2008 - Mar 2009)

These duties included the following brief description:

Reporting - Design, development, deployment version conversion, and administration of reports using MS SQL Reporting Services version 2005, MS SQL Server Suite 2005, Visual Studios 2005, Excel 2007, Access, VBA & Team Foundation Server

Integration Services Packages (SSIS)

Tables, Views, Stored Procedures, Functions, Queries & Optimizing

Premier Tech, Inc. (Consulting) - Mediware Information Systems - SQR Developer (May, 2008 - June 2008)

Located at 11711 W. 79th Street, Lenexa, KS 66214. These duties included the following brief description:

Reporting - Design, development, deployment and administration of reports using SQR version 6, Excel 2003

Miscellaneous DBA work such as Integration Services Packages (SSIS) (DTS) & ETL

Paige Technologies (Consulting) - Kansas City Life Insurance Co.- Business Intelligence Developer (Nov, 2007 - Apr, 2008)

These duties included the following brief description:

Reporting - Design, development, deployment and administration of reports using MS SQL Reporting Services version 2005, MS SQL Server Suite 2005, Visual Studios 2005, Excel 2003, VBA

Reverse engineering of Crystal reports

Tables, Views, Stored Procedures, Functions, Queries & Optimizing

Tech. Partners/EMC (Consulting) - Chesapeake Energy Corp.- Business Intelligence Developer (Jun, 2007 - Nov, 2007)

These duties included the following brief description:

Reporting - Design, development, deployment and administration of reports using MS SQL Reporting Services version 2005, MS SQL Server Suite 2005, Visual Studios 2005, Excel 2007, VBA & Team Foundation Server

Integration Services Packages (SSIS)

Tables, Views, Stored Procedures, Functions, Queries & Optimizing

BalancePoint (Consulting) - Service Management Group - Business Intelligence Developer (Jan, 2007 - May, 2007)

These duties included the following brief description:

Reporting - Design, development, deployment and administration of 60+ reports using MS SQL Reporting Services version 2005, MS SQL Server Suite 2005, Visual Studios 2005, Excel 2003

Miscellaneous DBA work such as Integration Services Packages (SSIS) (DTS) & ETL

Reverse engineering of Access reports

Tables, Views, Stored Procedures, Functions, Queries & Optimizing

ECCO Select (Consulting) - Embarq - Business Intelligence Developer (Nov, 2006 - Dec, 2006)

These duties included the following brief description:

DBA - Design, development and administration of an Access data warehouse database for a department’s reporting needs between the timelines of several system upgrades and miscellaneous work such as SSIS (DTS) & ETL, Excel 2003

Tables, Views, Stored Procedures, Functions, Queries & Optimizing

Advantage Tech (Consulting) - Security Benefit Corp - Business Intelligence Developer (Aug, 2006 - Nov, 2006)

These duties included the following brief description:

Reporting - Design, development and administration of 50-60 reports using MS SQL Reporting Services version 2005, MS SQL Server Suite 2005, Visual Studios 2005, Oracle (TOAD 8.6) & Source Safe

Tables, Views, Stored Procedures, Functions, Queries & Optimizing

American Crane & Tractor Parts (Full Time) - Business Intelligence Developer (Apr, 2005 - Aug, 2006)

These duties included the following brief description:

DBA - Design, development and administration of several Access databases and one SQL data warehouse while currently functioning as a database analyst among 7 other MS SQL databases and miscellaneous work such as Integration Services Packages (SSIS) (DTS) & ETL

Reporting - Design, development and administration of 30-40 reports using MS SQL Reporting Services, Visual Studios 2005

Reverse engineering of Crystal reports

Reporting analysis – Aiding decision makers in interpreting, action item setting, planning next steps, setting criteria & defining additional datasets all the way to the executive level

Process analysis – Fine tuning and standardizing of all reports, reporting processes, delivery systems and Data Transformation Services (DTS), queries and stored procedures

Business Intelligence

Delivery Systems – Designed and administrated automatic subscription services for the reporting program through MS SQL Reporting Services

Proposals and presentations – To all phases of sales staff and management (PowerPoint, Visio, Excel)

Training programs, materials and documentation - Methods and procedures (M&Ps), advisories and standards (Word, Visio, Excel, PowerPoint)

Network Administration – Active Directory, Mail Marshall, firewall, Symantec, Citrix

Help Desk – Supporting 150 users with all types of trouble tickets to resolve their issues (Hardware & Software)

Tables, Views, Stored Procedures, Functions, Queries & Optimizing

Sprint LTD Service Operations (Full Time) - Service Operations Planning Manager III These duties included the following brief description:

Management - Project, labor (20+ persons), and contract management

DBA - Design, development and administration of an Access database and fine-tuning SQL queries accessing several MS SQL databases and miscellaneous work such as SSIS (DTS) & ETL

Business Intelligence

Reporting - Design, development and administration of 10-15 reports using Excel, MS Query and Crystal

Process analysis – Fine tuning and standardizing of all reports, reporting processes and Data Transformation Services (DTS), queries and stored procedures

Training programs, materials and documentation - Methods and procedures (M&Ps), advisories and standards (Word, Visio, Excel, PowerPoint)

Vendor & Contract Management

Tables, Views, Stored Procedures, Functions, Queries & Optimizing

Sprint BLN National Deployment Planning (Full Time) - Senior Network Design Engineer These duties included the following brief description:

Project management – Manage several small projects surrounding the Metropolitan Service Area (MSA) Access database

DBA - Design, development and administration of an Access database serving several Broad Band Local Networks (BLN) departments while functioning as a database analyst among 2 other MS SQL databases (additionally worked with Oracle, Arc Info, MapInfo)

Business Intelligence

Reporting - Design, development and administration of 50-60 reports using Access, Excel, Word and a few in Crystal

Reporting analysis –Interpreting, action item setting, suggesting next steps, setting criteria & defining additional datasets for management

Process analysis – Fine tuning and standardizing of all reports, reporting processes, delivery systems and Data Transformation Services (DTS), queries and stored procedures

Training programs, materials and documentation - Methods and procedures (M&Ps), advisories and standards (Word, Visio, Excel, PowerPoint)

Deployment Documents Production – MSA database would be used to calculate and produce cross-connect schematics, deployment documents and advisories for each site Integrated On-Demand Network (ION) was to be deployed

Training programs, materials and Documentation including M&Ps, advisories and standards (Word, PowerPoint)

Vendor & Contract Management

Tables, Views, Stored Procedures, Functions, Queries & Optimizing

Option One (Consulting) - Sprint BLN - Database/Reporting Manager These duties included the following brief description:

Project management

Design, development and administration of databases, data warehouses and data mining techniques (Access, SQL, Oracle, Arc Info, MapInfo)

Design, development and administration of reporting, analysis, proposals and presentations (Crystal, Excel, PowerPoint)

Training programs, materials and Documentation including M&Ps, advisories and standards (Word, PowerPoint)

DecisionOne (Full Time) - Major Accounts Administrator These duties included the following brief description:

Project, labor (5 persons), and contract management

Design, development and administration of databases, data warehouses and data mining techniques (Access, SQL)

Design, development and administration of reporting, analysis, proposals and presentations (Crystal, Excel, PowerPoint)

Training programs, materials and Documentation including M&Ps, advisories and standards (Word, PowerPoint)

Vendor & Contract Management

Tables, Views, Stored Procedures, Functions, Queries & Optimizing

I have extensive experience and technical abilities in a wide range of both technical and general software and computer hardware. The following is a sample of some of the software programs I am experienced in:

Technical/Software:

Automation Anywhere Robotics Process Automation (RPA), UiPath Robotics Process Automation (RPA), TSQL, Visual Studios, SSRS, SSIS (DTS), SSAS, Dundas, Team Foundation Server, Source Safe, Power BI, Tableau, AutoCAD, Microstation, GIS, Geopak, Arc View, Arc Info, Micrographics Designer, Corel Draw, PhotoShop, Illustrator, Page-Maker, Publisher, Cartegraph Signview, Novell, DOS, Unix, Visual Basic, Visio, Photo Editor, Harvard Graphics, Quark, Crystal reports, Access, PowerPoint, Quicken, Project, Oracle, Citrix, Active Directory, Exchange, Mail Marshall, firewall, Symantec

General Office/Software:

Windows – Versions 3’s/95/98/2000/ME/NT/XP Home/XP Pro/Vista/7/7Ultimate/10, Microsoft Office 2007 – 365 – (Outlook, Word, Excel, Access, PowerPoint, Visio, OneNote, InfoPath, Publisher, Skype), Email Systems – (Outlook, Microsoft Exchange), Internet – (Netscape Navigator, Netscape Communicator, Microsoft Internet Explorer, Chrome, web page authoring)

Organizations and Certifications:

American Public Works Association (APWA), Institute of Transportation Engineers (ITE), American Traffic Safety Services Association (ATSSA) Worksite Traffic Technician & Traffic Supervisor, Kansas Association for Uniform Traffic Control (KAUTC), The Microstation Community (TMC), Cardiopulmonary Resuscitation and Emergency Cardiac Care Provider (CPR)

REFERENCES: (In order of most recent)

1.Joe Cabral – Main Sail Group

Director, Programs & Operations (Previous Handler)

Cell Phone: 717-***-****