PROFESSIONAL SUMMARY:

• Primary Role: Solutions Architect with emphasis on Business Analytics and Service delivery (ITSM) . Role is backed by over 25 years of professional experience gaining insight into business culture and aiding in the definition of targeted goals.
• Heavy hands - on experience in: gathering and analysis of business, security and infrastructure requirements (needs vs desire), discovery and documentation of available resources (hardware/software/network/personnel), evaluation of suggested upgrades/migration and potential risks, research on alternative solutions with associated benefits/costs/risks, presentation of suggested solution (architecture, road maps, timelines) and support plans (defining SLA); definition, design, test and implementation of coded logic, supporting data structure (backend) and system configuration (Development/Test, Proof-of-Concept and Production environments) assistance/cooperation with buy-off, providing post-launch client support including ffering recommendations for potential improvement as technology and/or the client’s needs grow. the design, development and deployment of properly structured data warehouses and cubes including creating measures, KPI’s, charts, matrices, hierarchies, pivot tables, dashboards, partitions, perspectives, mining models and security roles.

TECHNICAL SKILLS:

Frameworks: ITIL, SOA, Zachman, TOGAF, DoDAF, DoDAF2, FEAF, Kimball, Agile. BPM

Methodologies: SDLC, XP, Scrum, Inmon, RAD, RUP, Waterfall, Spiral

Modeling Tools: SSMS, TOAD, InfoSphere, System Architect, Erwin, Visio, ER/Studio, UML

Systems: Windows (NT3.5 - 2012R2), UNIX (HP, Solaris, Sparc), Linux (RedHat, Mandrake), Android, MAC, MVS/VMS

Cloud: Private/Public (Hybrid) MS AZURE, Hyper-V; (researching AWS Lambda, Oracle)

Middleware: J2EE, JMS, JVM, Oracle Application Server, Apache Tomcat

Management Systems: Visual Studio (TFS/Data Tools/BIDS), OBIEE, ServiceNow, JDeveloper, Eclipse

RDBMS: SQL Server (6.5 - 2016), Oracle (7 - 12g), Informix, DB2, MySQL, FoxPro

Code: C/C++, C#, Java, VB, Delphi, CoBOL

Scripting: T-SQL, PL-SQL, PERL, Java, VB

Discovery: SCCM, ServiceNow Discovery, Citrix

Analytics: SSAS, Informatica, PowerPivot, SAP Business Objects, DataStage (Warehousing/Cubes Multidimensional/Tabular)

Presentation: SharePoint, PerformancePoint, Tableau, Power View (various Web, Desktop and Office Tools)

Big Data: Exposure to HDInsight/Hadoop(MapReduce, HIVE, HBase, HDFS, STORM, PIG, Spark, R Server, Data Lake)

PROFESSIONAL EXPERIENCE:

Confidential,TX

Data Architect/Developer

Responsibilities:

• Was appointed Manager of and Drafted the Charter for the Data Architecture group
• Managed/Developed SharePoint site for the Data Architecture group
• Assisted in vendor interviews and tool selection to support the Confidential Service Delivery (ITSP) project.
• Selected (Oracle 12g) as the RDBMS platform for ServiceNow
• Attended ServiceNow Kick-Off Sessions, ongoing Stakeholders meetings, Wargaming and ITIL Process Sessions
• Used SQL Server, to create connections, procedures and data stores to replicate, validate, monitor and extend modeling of the ServiceNow database and associated processes. (Linked server via ODBC)
• Drafted architecture to showcase the workflow behind ServiceNow’s Change Management process.
• Designed Architecture for merging third party software with ServiceNow.
• Built Azure proof-of-concept for hybrid cloud. (SQL Azure, SharePoint, VMs and Visual Studio Team Integration)
• Scripted and ran data analysis to provide an in-depth breakdown of the NIST SP 800-53’s
• Above work performed to support the Risk Management team’s role in acquiring FedRAMP approval of ServiceNow.

Environment: ServiceNow, SQL Server, BIDS, Oracle 12g, Azure, SharePoint, Excel, ITSM, ITIL, CMDB, System Architect

Confidential, San Antonio

Data Architect\Developer

Responsibilities:

• Created data tools to support decomposition of various object and data models (MHS, FHIM) (extract)
• Translated, built data stores for and migrated (loaded) those models into Confidential . (SQL Server 2012 & 2016)
• Translated the HL7 Federal Health Interoperability Resources (FHIR) data and case models into IBM System Architect
• Discovered and documented contributing data sources and primary storage areas (CHCS, AHLTA, CIS).
• Drafted Architecture to illustrate Confidential subject area conversion into service delivery. (ServiceNow)
• Continued work with MS Azure architecting/configuring/developing SQL Azure for hybrid cloud integration.
• Provided detailed CCI (800-53) decomposition to highlight specific tech area responsibility and the system control’s relationship to ITIL. (Excel, SQL Server, T-SQL, Visio)
• Wrote SQL script to decipher data structure and app management under System Architect’s Enterprise Manager.

Environment: ServiceNow, InfoSphere, SQL Server 2016, BIDS, MSVS, Visio, Excel (PowerPivot), Azure, SharePoint, C++, SEMOSS

Confidential, Houston, TX

BI Architect / Developer

Responsibilities:

• Met with development team to assess project scope and needs (Requirements)
• Installed and configured SQL Server 2012 with Data Tools and Power BI xl 2010 (Power - Pivot, View, Map, and Query).
• Created Data Marts, Cubes and Web Reports to show progress of and issues with Enterprise Migration to Windows 8
• Identified and Documented Dimensions, Facts, Metrics and Key Performance Indicators (KPIs).
• Created Dashboards displaying: Application Compatibility, Short/Long Term Remediation Plan, and Usage Statistics on Person / License / Installations (Tableau)

Environment: SQL Server, DB2, SharePoint, Excel, Power Pivot, BIDS, Visual Studio and Tableau 8.2

Confidential

EDW/BI Programmer/ Architect

Responsibilities:

• Met with Stakeholders/Governance Team, Documented Major/Minor Issues and led meetings to Determine Priorities
• Discovered and Documented Existing Systems, Applications and Data Structures.
• Drafted High Level Architecture, Road Maps, Data Models and Conceptual Presentations
• Defined, Developed and Documented Data Marts, Staging Area and ETL. (SQL Server 2012 and Oracle/OBIEE)
• Built , Configured and Managed Confidential Server and Software (Windows 2012R2 w Hyper-V) for Hybrid Cloud Proof of Concept - (Azure <-> Hyper-V; SQL Server Azure, SharePoint, Mobile Devices)

Environment: Azure, Windows Server 2012R2, Hyper-V, SQL Server, Tableau, Data Tools, SharePoint 2013, Visual Studio, Project

Confidential, Addison, TX

Data Analyst / Programmer

Responsibilities:

• Wrote, Scheduled, Monitored, Prioritized and Optimized ETL moving data from homogenous source systems into offline storage for viewing and analysis by multiple Lines of Business (LOB). (DB2, SQL Server)
• Scripted stored procedures for data auditing, user auditing, performance analysis and network connections.
• Provided support for SSAS, SSRS and SSIS LOB On-Boarding including deployment and troubleshooting of cubes, packages and reports. (roughly 15 - 20 terabytes of data moving daily)
• Integrated with team via SharePoint 2010 / VPN

Environment: SQL Server 2012 / 2008 R2, DB2, SharePoint 2010, T-SQL, BIDS* (SSIS, SSAS, SSRS), Visual Studio 2010

Confidential, Austin, TX

BI Analyst / Architect

Responsibilities:

• Created staging areas, ETL and an Analysis DB to support a business conceptual model provided by SAS
• Created a second model/Analysis DB to support AMDs Just-In-Time delivery system.

Environment: SQL Server, Business Objects, BIDS* (SSIS, SSAS, SSRS), Visual Studio, SharePoint 2010, Oracle

Confidential

Java Programmer / Data Analyst

Responsibilities:

• Programmed J2EE using Oracle JDeveloper. 10g (SOA)
• Analyzed raw data in effort to create logical data models
• Merged and manipulated (staged) data using Informatica, DataStage, Designer, TOAD.
• Created and loaded warehouse models (Star) and cubes (SSAS and OBIEE)
• Created SharePoint BI sites for Collaboration and Analytics (PerformancePoint Services)
• Managed XML configuration files.
• Assisted DBAs with installation, backup, restore, security, performance optimization and new software acquisition

Environment: Oracle, PLSQL, Toad, Informix, Informatica, OBIEE, SQL Server, JDeveloper, SharePoint 2010, PerformancePoint, Java, Oracle Application Server (OC4J), Team Foundation Server, MKS Integrity

Confidential

BI Analyst / Data Warehouse Developer

Responsibilities:

• Review Business Principals, System Architecture and Data Flows
• Help Formalize Requirements document by suggesting naming conventions, best practices, most effective software for specific purposes, diagraming operational
• Develop Templates in BIDS and SSMS to assist internal development
• Mentor Data Developers on Warehousing Concepts (Star Schema, Building Cubes)
• Install, configure and develop reports for SharePoint PerformancePoint, ProClarity and MicroStrategy
• Developed data warehouses using SSAS and OBIEE.

Environment: SQL Server 2008/2008R2, T-SQL, BIDS (SSIS, SSAS, SSRS), Visual Studio 2008, C# .Net 3.0/3.5, SharePoint, PerformancePoint, ProClarity, Visio Architect, MicroStrategy

Confidential

Data Warehouse Analyst/Programmer, San Antonio, TX

Responsibilities:

• Provided Data Analysis, Warehouse and Cube Creation, Designed Reports
• Performed Data Analysis and Maintained, Optimized and Added Structures for the FEMA database
• Created IIS Sites and Web Reports (aspx, html, XML)

Environment: SQL Server 2005/2000, T-SQL, BIDS, Visual Studio .Net 2005, IIS, HTML, ASP, ASP.Net, Cold Fusion