PROFESSIONAL SUMMARY:

• Over 17 years of experience IT Database/BI Management, Data Warehouse Architect, BI ETL Developer MS Data Tools, Informatica Data Solution Provider.
• Managed EMR system Epic Clarity and Cogito Data Warehouse (Star, Caboodle) Certified supported Clarity Console, Hyperspace and Data Warehouse Console by Epic.
• Managed Health Catalyst Data Warehouse ELT, Qlikview application (ACO Explorer, BCBS, Cohort Builder, Comorbidity Analyzer, KPA, Population Explorer, Risk Model Analyzer)
• Upgraded DTS SQL 2000 to SSIS package in SQL 2005 to 2017 Reporting Services and Crystal Report XI, BusinessObject 4.1 single signOn, WebI. Experienced with Administration and Implementation MS SQL Server 2017, 2016, 2014, 2012, 2008 R2, 2008, 2005, SSIS, SSAS, SSRS both on Physical and Virtual Environment, Managed servers on Cloud AWS RDS and EC2 Stand Alone Server, Setup Clustered Server in the Amazon Cloud, Application Migration to Cloud such as CRM, Office365, SharePoint, Clarity, Dynamics,...etc. Replications, Database Mirroring, Log Shipping, and Data Compression. Configured/Administered Clustered (HA) with Replication. Configured Failover Clustered High Availability Group.
• Administered and developed databases in MS SQL Server including design, data schema, maintenance, optimization, and backups, documentations. Experienced with creating stored procedures for SQL Server using transact - SQL and generating ad-hoc reports. Work closely with Developers and Outsourcing Consultant to ensure data integrity, securing Database and troubleshoot to deploy applications successfully.

TECHNICAL SKILLS:

BI tools: Qlik, Domo, Power BI, Tableau, Informatica

Database Sources: SQL Server Database,Access Database,SQL Server Analysis Services Database, Oracle Database,IBM DB2 Database,IBM Informix database (Beta), IBM Netezza (Beta) MySQL Database,PostgreSQL Database, Sybase Database,Teradata

Database: SAP HANA Database,SAP Business Warehouse server, Amazon Redshift, Impala, Google BigQuery (Beta), Snowflake

Data File Formats: Excel, Text/CSV, XML, JSON, FTP/SFTP Files

Computer Languages: Windows PowerShell, T-SQL, C/C++, Java, Javascript, Html, XML Visual Basic, VB .Net, C# .NET, VBA, Assembly, Ada95, Lisp, Prolog.

Training: SQL Server Administration and Implementation at Glendale Community College, Certificate of Completion - Sun Java Training

Operating Systems: Windows Server, MS-DOS, UNIX, Linux, Macintosh

Database: SQL Server 2000 to 2017, XML-QL, DRC, TRC, T-SQL, KB-SQL, Oracle PL/SQL

Reporting: Crystal Reports XI, BusinessObject 4.1, SQL 2005 to 2017, SSRS, SSIS, Visual Studio 2005 to 2017.

SQL Server Tools: Idera Diagnostic Manager, SqlSearch, Toad, SqlPlanExplorer

Service Desk tools: Heat, ServiceNow, SolarWinds, CRM

Software: MS-Project, MS-Office, Access, Visio, PhotoShop, Logic Design, AutoCAD Knowledge of Network system, Protocols, TCP/IP, Routers, ISDN, DSL, LAN/WAN, Exchange Server, External Hardware Devices Printer, Scanner, Cable Modem, Wireless Router Driver Configurations and Setups Windows Server Application, Microsoft Server Products, Terminal Services, SQL Server, Citrix and HEAT Knowledge of Project Management including requirements gathering, design, implementation planning, documentation and project completion, Microsoft Project 2007, MS Project 2010

Case Tool: RUP and OOD-- Requisite-Pro, Rational Rose, UML (certificate of completion Technical Training), PVCS Tracker and Source control, CVS/CCM/VSS version control manager

PROFESSIONAL EXPERIENCE:

Confidential

Senior IT Database Manager

Responsibilities:

• Data Migration, Application Migration using Informatica PowerCenter
• Managed QlikView Analytic apps (ACO Explorer, BCBS, Cohort, Population Explorer, Risk Model Analyzer, KPA, Comorbidity Analyzer within Health Catalyst Data Warehouse latest binding methodologies
• Install, update, and troubleshoot the Clarity Console.
• Install, update, and troubleshoot the CDW Console.
• Performed DBA on SQL Server 2014, 2016 on backups, restores, recovery models and clustering.
• Performed DBA on replication, mirroring and log shipping.
• Monitored/verified the Clarity ETL process daily
• Troubleshoot and resolve errors that may occur during the ETL process.
• Monitored the Cogito Data Warehouse(CDW) is loaded daily
• Troubleshoot and resolve errors that may occur during the ETL
• Performance Tuning on Clarity database to ensure optimal performance and integrity.
• Keep track of SP updates are applied to the Clarity Console and CDW Console servers.
• Modify the ETL process, Performed Clarity Compass upgrades as necessary release by Epic.
• Work with report analysts and/or the Epic build teams to identify and resolve possible discrepancies between Cache and Clarity.
• Updated technical operational support documentation
• Performed quality assurance and change control functions through CAB between environments
• Worked incident tickets troubleshooting, root cause analysis and document knowledge base
• Certification and professional compliance such as HIPAA
• Worked closely with IT Team to address all aspect of system to ensure optimal data warehouse functionality.
• Complied Health Personnel policies and procedures and Safety guidelines.
• Provide 24x7 night and weekend on-call coverage

Confidential

IT Technical Manager

Responsibilities:

• Managed Amazon Cloud Servers RDS and EC2 both Clustered and Non-Clustered Environment
• Setup Clustered server on AWS EC2 in the Cloud
• Analyzed current on site servers to migrate to Amazon Cloud from Network, Security, Capacity Planning, Licensing, etc...
• Data migration to Cloud Server on Clustered SQL Server 2012R2
• Supporting BI team, Reporting Team, SSRS, Crystal Report XI
• Created ETL using SSIS package for various sources such as SQL Server DB, Oracle DB, MySQL.
• Documenting SQL Server from Network to Data Architect
• Compliance with State Level Security Management on IRS, Lottery System
• Assisted on Planning Webhost Applications to the Cloud migration
• Performed all DBA routine tasks Cloud Servers on EC2 and RDS servers
• Configured architecture overview on Disaster Recovery on different AWS Regions
• Create new instances on Cloud Amazon for DEV, QA, STAGING, UAT Test and Production Deployment
• Trained Data/Client Analyst to manage routine tasks on uploading and downloading data from Cloud Servers
• Data migration projects such as SharePoint, CRM, Clarity13, Lottery, Office365, Dynamics, etc…
• Assisted on BREEZE project for the State on SQL Server architecture
• Performed various test cases for Disaster Recovery on the Cloud Servers
• Worked with CommVault to apply agent on AWS EC2 servers
• Scripted custom monitoring PowerShell scripts to monitor SQL Servers on Amazon Cloud such as disk space usage, services down, long running query, clustered and replication. Automated notification for failure by sql agent job through sql mail
• Support routine change management and enhancement for various application
• Developed all stages from requirements gathering through user’s acceptance test, deployment, wrote user’s manual, change management, maintenance software applications.
• Provided 24/7 on-call support

Confidential, Phoenix, AZ

Senior Database Manager

Responsibilities:

• Built & Support BI Developer, Data Warehouse ETL Development, Informatica
• Support Healthcare System DB, NextGen and Clinical Applications backend
• Managed Database team of 10 Database Administrators and Technical Lead
• Administered SQL Server 2000 to 2008 DTS, SSIS, SSAS, SSRS on various client server applications
• Red-Gate Backup tools and Symantec Backup Exec
• DB Mirroring, Replication DR and Implemented Report Servers
• Performance Tuning and Validated Data Integrity
• Performed routine maintenance on Physical and Virtual Environment on SAN
• Maintenance on File Servers and Documented Change Management
• Optimized resource intensive query based on Execution Plan
• Data Compression on all Backups
• Supported Software Team and BI Team on various projects (Data Warehousing, Data Mart DB)

Confidential, Scottsdale, AZ

Technical IT Manager

Responsibilities:

• Managed both SQL Server DBA team and Oracle Administrator team to fulfill organization’s vision regarding database management and availability on 24/7 critical system from planning to disaster recovery.
• Administered, Implemented critical Databases and BI Data Warehousing, ETL, Cubes including Production, Testing and Developing Database
• Implemented and Maintained Database Mirroring, Log Shipping DR, Clustered Environment
• SQL Server 2005, 2008 SSIS, SSAS, SSRS with full Microsoft Tools
• Red-Gate Backup tools and Symantec Backup Exec
• Data Migration from SQL Server 2005 to Oracle 11g, utilized SSIS, Oracle/PLSQL
• Automated Tasks and Scripts for preventive Maintenance
• Validated Data Integrity and Data Manipulation to help BI Team on DataMart DB and BI Projects
• Performed Daily, Weekly, Monthly DBA tasks to support all Databases aspect
• Worked with Consultant to ensure data integrity and Optimization
• Setup Log Shipping in a Clustered Environment both on Physical and Virtual Server VMWare
• Utilized mRemote tool for Servers Management in a multiple supported protocols (RDP, VNC, ICA, SSH, Telnet, RAW, Rlogin and HTTP/S)
• Implemented Mirroring for Disaster Recovery
• Updated Data Dictionary, Documented User’s Manual and Supported Software Team and Analyst Team

Confidential

Senior SQL Server DBA/Client Server Developer

Responsibilities:

• Created DB Schema, Tables, Views backend for Global Network DB tracker
• Requirements gathering, Designed, Developed WebApps using VB .NET, Performed User-Acceptance-Test, Deployed
• Generated reports using Reporting Services and Crystal Report XI
• Wrote User’s Manual and Data Dictionary

Confidential, Phoenix, AZ

Senior Database Administrator

Responsibilities:

• SSIS, ETL Data Warehouse supported BI Team
• Created Data Schema, Store Procedures, Views and Reports
• Migration SQL Server 2000 to 2005, Setup DB Mirroring/Backup
• Develop reports using SSRS, Crystal Reports XI
• Upgrade DTS SQL 2000 to SSIS package in SQL 2005
• DB Mirroring Disaster Recovery Plan
• Utilized Idera Diagnostic Manager, Check DB/Log Backups, Check the Server Event Logs and the SQL Server Error Logs
• Check the DB Size and Transaction Logs, Space Available within Data File Running database integrity checks
• Updating database statistics, Reorganizing database indexes, Performing database backups
• Cleaning up database historical operational data, shrinking a database
• Cleaning up leftover files from the maintenance plan, Executing SQL Server jobs
• Cleaning up maintenance tasks, Check on the Status of SQL Agent Scheduled Tasks
• Check Other Server Management Logs check that all required SQL Server services are running.
• Check Daily Backup logs for success, warnings, or failures; Check the Windows Event logs for errors.
• Check the SQL Server logs for security concerns such as invalid logins, Conduct full or differential backups.
• Conduct Transaction Log backups on databases configured with the Full or Bulk-Logged recovery model.
• Verify that SQL Server jobs did not fail; check that adequate disk space exists for all database files and transaction logs.
• Monitor processor, memory, or disk counters for bottlenecks.

Confidential, Phoenix, AZ

SQL Server Database Administrator

Responsibilities:

• Experienced administration of SQL Server 2005. Secondary administration of SQL Server 2000 environments.
• Application of database architecture, relational database diagrams, integrity constraints, user/database/application level database security
• Use of advanced features such as replication, mirroring and resource governing
• Performance tuning using performance monitor and profiler and understanding of performance related metrics
• Backup, restore and disaster recovery activities using integrated SQL Server tools
• Debugging and troubleshooting of RDBMS related issues such as Deadlocking and Blocking
• Created stored procedures for SQL Server 2000 using Transact-SQL.
• Assisted with program requirement definitions and customer training.
• Managed team project and individual tasks in a team of seven developers
• Managed change management on current and existing client server applications
• Forecasted tasks and timeline to allocate appropriate resources to meet deadlines
• Developed, tested, implemented, and maintained web-based applications in an intranet environment.
• Researched and analyzed new technology
• Experienced use of SSIS, SSAS, SSRS, and DTS platforms
• Providing 24X7 system support
• Utilization of MS DBMS tools for SQL Server
• Use of ODBC, OLEDB and TCPIP for interface connectivity
• Use of TSQL, CLR, and PowerShell for database level programming such as triggers and procedures
• Microsoft Project, Visual Interdev and ASP in a source-safe environment with HTML, DHTML, VB Script, Java Script, COM +, Visual Basic, IBM MQ Series programming, Microsoft .NET technologies, Transact-SQL, IIS 5.0, Crystal Reports 8.5, XI, -TTX style, and MS SQL Server 2000.

Confidential, Scottsdale, AZ

Programmer Analyst

Responsibilities:

• Managed Requirements, Change Management, Version Control, Allocated Resources, Mitigated Tasks among Stakeholders from the Analysis phase through Deployment and Training phase
• Supported Health System Application on Client Server System SQL Server 2000 backend DB
• Evaluated, Analyzed third party Web-Applications based on user’s requirements
• Managed, Organized, Documented “Jury Duty Selection Application” using Microsoft Project followed UML Iterative Development Approach
• Analyzed, defined, and documented business requirements for software specifications
• J2EE, OOAD, N-tier Architecture, Model View Controller (JSP/HTML, Databean, Handler, Requestbean, Service, SQL Server 2000 DB backend)
• Java2SDK 1.4, Jboss-3.2.6, Tomcat, apache-ant-1.6.2, Eclipse 3.0 IDE, IBM VisualAge for Java
• Enterprise Version 3.5, Visual Source Safe 6.0
• Administered and developed databases in MS SQL Server including design, maintenance, optimization, and backups (as a backup DBA)
• Designed and developed database applications in Office 97, 2000 and Visual Basic 6.0 using ADO
• Created a browser based ad-hoc reporting tool using IIS, ASP, and Crystal Reports.
• Worked programming staff for business analysis, design and implementation of projects
• Provided installation, training, support, and troubleshooting of custom database applications