SUMMARY:

• Technology Leader of Infrastructure, Solution Development - Architecture, Data & Business Intelligence
• Contributing and Leading small business teams, large enterprise teams of Infrastructure, Data and Technology Asset Management, and Software as a Service in support of ongoing operations, operational readiness and disaster recovery.

CORE COMPETENCIES:

Identifying & providing solutions to business problems, IT goals and objectives alignment to business imperatives. identifying a realistic IT budget that aligns to business direction. IT and Business User relationship bridging. Business Intelligence conceptualization to realization.

TECHNICAL SKILLS:

Database Management Systems: SQL Server 2000, 2005, 2008(r2), 2012, 2014, 2016, Oracle 9i, 10, 11, 12G

Server Platforms: Windows 3,7,8,12, 16 Ubuntu/Linux

BI Sources: MSAS, MongoDB, MSSQL R Services, MS Visual Studio R Studio

BI Reporting: Tableau, Crystal Reports Business Objects, Microsoft SQL Server Reporting Services (SSRS)

Web Platforms: IIS(6, 7, 8), Apache, Tomcat

Development Platforms: OutSystem, SalesForce - Heroku, Mendix, MS Visual Studio, Eclipse

Development Languages: .ANSI SQL II, T-SQL, .Net C#, .Net Visual Basic, SQL Reporting Services, Crystal Reports, Java Script, Java EE (SE)

ELT/DTS Packet Management: DTS, SSIS, Informatica Power Center 7 & 8

ERP Systems: SAP, IFS, DBA and Oracle MRP systems

PROFESSIONAL EXPERIENCE:

Confidential

Senior Database Administrator

Responsibilities:

• Now exists with three tiers, and eight line of business dichotomies as well as three universal topics.
• Upon arrival ticketing system (Service Desk) had over 1,500 open tickets that were 90-days or older. Now has no open tickets over 30-day, critical tickets have a consistent 6-hour closure time, all other tickets now conform to the 36-hour service level agreement.
• All servers have been virtualized. Only remaining non-virtualized hardware are considered vendor managed appliances, for example phone SIP trunk to phone system. Mitigating the risk of hardware failure, minimized the resources necessary to provide maintenance and support.
• All SQL servers have been consolidated to two host clusters to mitigate unnecessary licensing cost.
• Staging database servers now are hosted on a three-cluster host, all non-production (QA - Development) are now hosted on a two-cluster host saving the organization 1.5 million in unnecessary licensing cost.
• Formalize the Organizational Business Intelligence definition.
• Established a three-year road map to contemporary BI.
• Created a Business Intelligence database server for the sole purpose of generating reports. This has removed the negative impact to our operational systems: Call Center Performance improvement allowing call center to make organizational goals of calls per agent. Created the Operations, Finance and Supply Chain data marts. Continued to build Operational Dashboards in Tableau. Utilized SQL Server 2016 R Services, and Visual Studio 2017 R to craft a population and distribution model for our URAC Accreditation.
• Defined a development process that aligns with contemporary development methodologies. This has helped in completing custom development of enterprise applications to meet the defined business needs, in method that allows for maintenance, and growth.

Confidential, Phoenix AZ

Responsibilities:

• All servers have been virtualized. Mitigating the risk of hardware failure, minimized the resources necessary to provide maintenance and support.
• Structured to support all the layers of support necessary to run the organization. This also includes a configuration management tracking system. This was a significant step in the ITILL accreditation process.
• Introduced a process to manage custom solution development.
• Lead the effort to assess the 3 - 4 K MS Access applications that were being used for enterprise processes.
• Created RFE, BRD and System Definitions in advance of having the platforms converted to modern applications.
• Formalized the approach to the Hospitals business intelligence needs. This included the identification and development of Clinical Analytics outside of the hospitals EMR ( Confidential ). Visualized dashboards, and clinical analytics in Tableau.

Confidential

Consulting Database Administrator - Developer

Responsibilities:

• Worked with client to improve performance of their internal systems.
• The clients system had reached a point where their systems were negatively affecting their revenue.
• Repaired system (Database and Web-Application) that was causing their 100 + fleet of vehicles to not be bookable.
• Create a three-year plan to Virtualize their platform, load balance applications and update application topology from two tiers to a Service Oriented Architecture.
• Worked with client to identify a roll-out plan to achieve a virtualized infrastructure and a disaster recovery and business continuity plan.

Confidential

Responsibilities:

• Established a departmental road map that would answer the near term operational needs and long-term growth needs.
• This allowed the company to grow volumetrically over my three-year tenure.
• Virtualized all the legacy servers and hardware.
• This allowed us to create an IT budget that would meet the near-term needs, and long-term expansion.
• Defined the solution development method, as well as participated in the development process: Solution Architecture, Project Planning, and Story and Sprint planning and execution.

Confidential

Senior Database Administrator and Application Development Team member

Responsibilities:

• Participated as a member of this team where we established the organizational DR and BCP plans. In the three years we successfully performed our DR and BCP annual testing.