SUMMARY

• Innovative leader of business intelligence, infrastructure architect, designer and developer with over 34 years’ experience, offering extensive hands - on and team management experience in enterprise class projects within the Healthcare, Banking, Aerospace, State Government, Electric Power and Automotive (logistics) industries.
• Proven ability to leverage the corporate vision into line of business and tactical objectives.
• Deliver results beyond the strategic roadmap.
• Latest skills listed below in big data, virtualization / visualization, web services, Cloud (Azure, AWS), communications and consumer technologies.
• Expertise with a wide variety of computer hardware, development platforms and software applications.
• Provides thought leadership on architectural designs and methods, business alignments, component- based development and the use and/or development of common frameworks resulting in the creation and deployment of enterprise-class solutions.
• Proven developer of relational/non-relational databases within a healthcare, finance, and manufacturing environments.
• Possess excellent verbal communication and programming skills.
• Proficient in Agile, Scrum, Iterative, and Waterfall methodologies:
• Demonstrated expertise in resolution management, exemplary leadership, and positive goal-directed communication skills.

TECHNICAL SKILLS

Programming: AWS (EC2, S3, RDS), HQL, VQL, WPF, WCF, J2EE, MDX, DAX, Jscript, C#, R and RStudio Statistics, VB.Net, Java, PHP, PERL, HTML, ASP, T-SQL, PL-SQL, VBScript, SOQL some F#, Python, Jython, PG-SQL and Micrsoft Azure.

Platforms: Microsoft Windows (all versions), Windows Server 2012, AWS w/ EC2, S3, RDS and ElasticSearch, Postman, Splunk, Cloudera, Hadoop, Sun Solaris, UNIX, Linux, DOS, MVS, OS/2 and Linux Redhat.

PROFESSIONAL EXPERIENCE

Confidential

Business Intelligence Lead, Architect and Data Modeler

Responsibilities:

• Led the Business Intelligence team in designing a cloud based solution for the Data Analytic group. This includes setting up and configuring Tableau Server, DynamicNav, and PowerBI.
• Coordinated efforts for server setup with our infrastructure team for new virtual servers in the I/O Data space.
• Initial scope was to externalize operational reporting from Salesforce as a reporting platform to a cloud based analytic platform.
• Worked with the Infrastructure team to identify vulnerabilities such as; Untrusted domain and ACL issues between the business segments.
• Created a virtual Staging environment in AWS EC2 and RDS (Oregon Region) due to cost limitations in the IO data space.
• Coordinated the SSIS creation and deployment initiative for the Data Governance team to ensure Data continuity from the landing zone through the Operational Data Store and subsequent Bounded Context (CQRS) to support the event - driven architecture.
• Trained, setup and guided the team in proper use of JIRA from an Agile Methodology (Cafe).
• Led the estimation planning efforts for the BI team to ensure we kept on track for our biweekly sprint burndowns and to keep the backlog health inline.
• Coordinated the review and technological direction of the current infrastructure from dedicated DC servers and began the initiative for moving to a cloud-based solution.
• Coordinated with Cox Enterprises shared services team and other BU’s to create service -level accounts to resolve the domain trust issues by using other BU’s as a hop to/from Cox.
• We delivered sourcing obj ects to support the data analytic team for proceeding descriptive, prescriptive and predictive analytics. Worked with and designed Tableau dashboards using the new Provider source.
• Thought leader in designing, implementing, and configuring departmental infrastructure, Database structure, and good security practices.
• Lead the development team in agile whiteboard design sessions. Helped define User Stories,Work Items, Tasks, Issues/Bug fixes to better track the design iterations (i.e. burn downs, etc.).

Tools: and Technology: AWS (EC2, S3, RDS), ElasticSearch (Event-driven architecture), Postman, Windows Server 2012, MSSQL Server 2016/2014, BI Stack, Tableau 10.x, JIRA, Team Foundation Server, VS Suite (2015), MS Office Suite (2013), O365, PowerBI, Adobe Analytics, PowerBI, Microsoft Project, Salesfore, and Agile (Epics, Stories, etc.).

Confidential

DW Manager, EDW Architect and Sr. Data Modeler

Responsibilities:

• Led the Enterprise Data Warehouse team for the Veterans Administration Provider Services.
• Created the SSIS ETL Framework (via BIML) and lead the effort for the Data Governance team to ensure Data continuity from the landing zone through the Operational Data Store and subsequent EDW (Star Schema).
• Trained, setup and guided the team in proper use of Team Foundation Server from an Agile Methodology. I led the tea shirt size estimation planning efforts. Setup and assisted the EDW Manager and Director about the Agile lifecycle.
• I setup a POC Trello Collaboration to ensure a cohesive coordination of the teams during the system development lifecycle.
• I created numerous SDLC template documentation to further assist both TriWest and the transitioning IBM team in further documenting the "what" and "how" of the existing process.
• We delivered on the slice of the Provider Services EDW for predictive and descriptive analytics. Worked with and designed Tableau dashboards using the new Provider source.
• Designed, implemented, and configured several departments IT Infrastructure, Database Administration, Infrastructure and Engineering.
• Lead the development team in agile whiteboard design sessions. Helped define User Stories, Work Items, Tasks, Issues/Bug fixes to better track the design iterations (i.e. burn downs, etc.).

Tools: and Technology: MSSQL Server 2008R2/2012, SQL Server BI Stack, Tableau 9.3/10.0, Team Foundation Server, VS Suite (2012), MS Office Suite (2013), PowerPiviot/PowerView, CA ERWin, BIML, Microsoft Project, and Agile (Epics, Stories, etc.).

Confidential

Sr. Program/Project Development Lead

Responsibilities:

• As a member of the Program Leadership I provided input and direction to the executives regarding the technology approach.
• Designed several semantic layers in both virtualization tools such as Denodo and visualization toolsets like Tableau, PowerQuery, PowerMap, PowerPivot, and Business Objects to deliver enterprise class predictive, prescriptive, and descriptive analytics.
• Designed several MDOLAP, OLAP SSAS cubes (with asdatabase deployments), SSIS (with biml\ispac deployments) and SSRS reports. Expert in MDX and DAX for cubes and BIM s (tabular).
• Designed and aligned the 64 bit development platform with 64 bit tools, integrations to Oracle 10g/12c and SQL Server 2012.
• Created high level designs for our project to interact with the vendor product through web services (SOAP, REST, WSDL, etc.) using insurance industry standards of ACORD XML and XSDs
• Designed several semantic layers in both virtualization tools such as Denodo and visualization toolsets like Tableau, PowerQuery, PowerMap, PowerPivot, and Business Objects to deliver enterprise class predictive, prescriptive, and descriptive analytics.
• Designed, implemented, and configured several departments IT Infrastructure, Database Administration, Infrastructure and Engineering.
• Extracted from multiple data sources into our development environments (via Sqoop (SQL + Hadoop)). Also worked in the HDFS and created Hive queries.
• Lead the development team in agile whiteboard design sessions. Helped define User Stories, Work Items, Tasks, Issues/Bug fixes to better track the design iterations (i.e. burn downs, etc.).
• Coordinated and organized the Informatica PowerCenter/Data Quality training, 9.5 to 9.6 migration and new repository builds, and Informatica client tool upgrades plus server and local connectivity’s.

Tools: and Technology: SQL Server 2012, SQL Server BI Stack, Tableau 9.6, OLAP/OLTP, Team Foundation Services, VS Suite (2012), BigInsights/Sqoop, MS Office Suite (2013), PowerPiviot/PowerView, MDX-DAX, SharePoint and Microsoft Project, Agile 6.2 (Epics, Stories, etc.), SCRUM

Confidential

Sr. BI DM and EDW Designer/Developer

Responsibilities:

• As a member of the Proj ect Leadership I provided input and direction to developers and the architects regarding development and technological approaches.
• Designed and developed Tabular Analytic Models (BIM's), KPIs, Dashboards which met the business needs.
• Designed and created technical analysis for pending KPIs from existing Dimensions and Fact tables.
• Lead the development team in agile whiteboard design sessions. Help define User Stories,
• Work Items, Tasks, Issues/Bug fixes to better track the design iterations (i.e. burn down reports).
• Designed. Developed, and managed the West Coast Container (WCC) ports and coordinated with the East Coast ports on shipping schedules and GPS coordinates.
• Designed and developed the WCC and Procurement SSIS ETL packages for several marts.
• Designed and aligned the 64 bit development platform with 64 bit tools, integrations to Oracle 10g/12c and SQL Server 2012.
• Designed and developed Tableau reports and dashboards from both the BIM and relational structure.
• Setup and designed Team Foundation Server for development and deployment of our BI stack.
• Created burn down reports and trained the team to properly manage their project branches and BI deployment packages.
• Worked in debugging source code developments to Tier 3 troubleshooting.
• Completed detailed management-level PowerPivot / PowerView reports, outputs in VS 2012 and deployed them to the SSRS Reporting Server.

Tools: and Technology: SQL Server 2012, SQL Server BI Stack, Tableau 8.1/8.2, OLAP/OLTP, Team Foundation Services, VS Suite (2012), MS Office Suite (2013), PowerPiviot/PowerView, MDX-DAX, SharePoint and Microsoft Project, Agile 6.2 (Epics, Stories, etc.), SCRUM

Confidential, Nashville, Tennessee

Software Architect - Database Design, DW, DSS and BI Solutions Expert

Responsibilities:

• As a member of the Leadership team I provided input and direction to designers and developers regarding the technological approaches.
• Designed and created new technical analysis for KPI from statistical models for the Executive Dashboard(s).
• Developed and reviewed technical and business artifacts which define the architecture of the solution. Database design best - practices (SQL Server), implement agile methodologies.
• Developed SSIS packages and automation deployments as well as Informatica ETLs (Big- data connectors). Implemented SOA principals and initiatives to re-design the CORE schema and created integrations with SFDC and Oracle financials.
• Designed and created new technical analysis requirements (documentation) for query optimization. On-going quality improvements to optimize existing and new database designs.
• Considered a technical subject matter expert in SQL Server and Powershell administration for the CORE/Vigor application.
• Created their operation data store, materialized views, and functional fact tables, analytics using MDX and DMX.

Tools: and Technology: SQL Server Reporting Services (SSRS), SQL Server Management Studio (SSMS), SQL Server Integrated Services (SSIS), SQL Server Analysis Services (SSAS), R Console, VB scripting, Microsoft Visio, OLAP/OLTP, Visual Source Safe 2009/TFS, VS Suite, MS Office Suite, and Microsoft Project