Business Intelligence Ms Sql
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-***-****
Email: *******@*************.***
2.Paul Twenter - HNTB, Decision Analytics Group, Associate Vice-President (Previous Manager)
Cell Phone: 816-***-****
Email: ********@****.***
3.Brent Mason - HNTB, Decision Analytics Group, Solutions Developer (Peer)
Cell Phone: 913-***-****
Email: ***********@*****.***
4.Vince Veach – HNTB – Data Services (Peer)
Cell Phone: 816-***-****
Email: ******@****.***
5.Rob Alford – HNTB, Data Services (Peer)
Cell Phone: 602-***-****
Email: *************@*****.***
6.Dionne Minkler – HNTB, Data Services (Peer)
Cell Phone: 816-***-****
Email: ********@****.***
7.Garret Brumley – Quest Diagnostics/ExamOne - Sr. Software Developer Mgr. (Previous Manager)
Work Phone: 913-***-****
Cell Phone: (913)
Email: ******.*.*******@*******.***
8.Kevin Parker – Quest Diagnostics/ExamOne - Data Architect (Previous Manager/Peer)
Work Phone: 913-***-****
Cell Phone: 913-***-****
Email: *****.*.******@*******.***
9.Rob Lyons – Quest Diagnostics/ExamOne - Sr. Programmer Analyst (Peer)
Cell Phone: 816-***-****
Email: ******.*.*****@*******.***
10.Linda Ensign – Quest Diagnostics/ExamOne - Data Warehouse Engineer (Peer)
Work Phone: 913-***-****
Cell Phone: 913-***-****
Email: ***********@*****.***
11.Steve Garey – Quest Diagnostics/ExamOne - Development Engineer (Peer)
Work Phone: 913-***-****
Cell Phone: 913-***-****
Email: ******@*********.***
12.Paul Leslie – HP/USDA - (Peer)
Work Phone: 816-***-****
Cell Phone: 913-***-****
Email: ****.******@***.****.***
13.Wade Nelson – DynCorp - Sr. IT Manager, Financial Applications (Previous Manager)
Work Phone: 817-***-****
Cell Phone: 817-***-****
Email: ****.******@***-****.***
14.Rodney Dixon – DynCorp - Financial Applications (Peer)
Work Phone: (817)
Cell Phone: 817-***-****
Email: ******.*****@***-****.***
15.Ben Greene – MV Transportation Inc. - Director of Corp Reports (Previous Manager)
Work Phone: 707-***-****
Home Phone: 417-***-****
Cell Phone: 417-***-****
Email: *******@*********.*** or ********.******@*********.***
16.Trina Wright – MV Transportation Inc. - Network and E-Mail Administrator (Previous Manager)
Work Phone: 707-***-**** x3131
Home Phone: 480-***-****
Email: *******@*********.*** or *****.******@*********.***
17.Robert Wilson – MV Transportation Inc. – Corp IT Programmer/Analyst (Peer)
Home Phone: 904-***-****
Email: *******@*********.*** or *********@*******.***
18. David Prior – EMC/Geniant - Senior Technology Consultant, PMO (Previous Manager)
Cell Phone: 405-***-****
Email: ******@***.*** or ******@*******.***
19. Shane Collins – American Crane & Tractor - IT MGR (Previous Manager)
Cell Phone: 816-***-****
* *****.*.*****@*****.*** ( 913-***-**** In http://www.linkedin.com/in/martycline H Kansas City Metro
Contact this candidate