SUMMARY:

• Confidential has over 20 years experience providing leading edge solutions to Fortune 500 Companies as hands - on solutions architect, information architect, cloud infrastructure architect, database designer, and strategic planning of large-scale information systems. He has successfully led and/or participated in multi-terabyte business intelligence and analytics, ERP, CRM and Healthcare software implementations over large-scale network deployments. His experience base includes VLDB and multi-terabyte environments with immense clustered platforms and Cloud implementations with increasing responsibilities. Robust background in Microsoft SQL Server, Oracle, and MySQL with implementations on AWS and Azure.
• Data warehouse (DW) and EDW builds with ETL, OLAP, data modeling, database design, normalization, star and snow flake schema design, dimensional modeling (Inmon, Kimball), crystal reports, business objects. Strong background in providing technical, functional and project supervision to BI teams and working with business stakeholders to identify functional requirements for data warehouse or master data management including quality assurance, ITIL v3 foundation certified.

PROFESSIONAL EXPERIENCE:

Consulting DBA, MS SQL Server

Confidential, Los Angeles, CA

Responsibilities:

• Creating Database, Schemas, snap shots, planning, creating and optimizing indexes in SQL Server, implementing data integrity by using constraints and triggers, creating, implementing XML schemas, indexes, creating, retrieving and shredding
• XML data, XQuery, creating, managing & optimizing performance for views, procedures, triggers, table & functions, query performance optimization - execution plans, exception handling, • optimizing distributed transactions and locks.
• Used SSMS, SCOM for monitoring and diagnostics with T-SQL coding support. Backup and Restore (full). Continuous replication between connected servers. Supported MS SQL Server 2014 SP2. Supported SSRS, SSAS, and SSIS packages for ETL. Report writing using Power BI.

Lead Consultant DBA

Confidential, Windsor Mill, MD

Responsibilities:

• Subject matter expert SME3 as DBA, data architect, analytics. Hands-on and lead a team of DBA's and data modelers (CA/Erwin), analytics report writers. Supported and directed efforts in Tableau and Power BI implementation running off of MS SQL Server databases. High pressure rapid development environment using Agile with daily SCRUM stand-ups. DDL implementation and rotation through the SDLC (dev, test, validation, prod), performance tuning of stored procedure SQL queries. Supported MS SQL Server 2008 R2, 2012 SP3, and 2014 SP2 in use in 64-bit production environment with failover clustering and log shipping support. Deployed SQL Server 2016 in sandbox for validation and checkout. Supported replication (merge, transactional) and clustering for high availability. Supported creation of least privilege replication setup. Worked on feasibility of making database setup look like Azure (e.g.
• Always-on) and no budget as of 09/26/2016. Subscribe SQL Server Azure Cloud Services. Create Database(s) on SQL AZURE. Setup SQL Azure Firewall. Create, manage SQL Server AZURE Databases. Setup Connection Strings and connect SQL Server AZURE Databases from locally Installed SQL Server Management Studio (SSMS) for Developers. Supported monitoring of databases using SSMS, SCOM, Idera SQL Diagnostic Manager, Safe Backup, and Virtual Database.

Senior Consultant DBA

Confidential, Windsor Mill, MD

Responsibilities:

• Provided database administration support including modeling and design, DDL implementation and rotation through the SDLC (dev, test, validation, prod), performance tuning of stored procedure SQL queries, 24X7 support with on-call duty on rotation weekly.
• Installing & Configuring SQL Server Analysis Services on clustered environment, Memory Management for SQL Server Analysis Services, Cube Deployment, OLAP / CUBE database (s) synchronization,Database Backup Restore Strategy design and Implementations for OLAP Database, Logging, Monitoring, and Optimizing an Analysis Services Solution, Backing Up and Restoring an Analysis Services Database (OLAP),Install and Configured Integration Services on Clustered Environment for High Availability, Troubleshooting and Optimizing SSIS package performance, Deployed and Scheduled DTS | SSIS
• Packages, Installed and Configured Reporting Services on Clustered Environment for High Availability, Created basic Reports to meet Ad hoc business requirement, Publishing / Deploying Report on multiple Report Server, Managed Shared Data sources and permissions, Configured Reports Snapshots, Report Caching for reporting performance, Created and managed subscriptions for Reports, Assigned report level permissions to Secure business information, Upgraded / Migrated SQL Server reporting services, Created Subscription for Reports, Configured Backups for Reporting Services

Team Lead

Confidential, Westwood CA

Responsibilities:

• Senior analyst in DBA, Data Warehouse, business intelligence. Led a team of Information Management Professionals in solution delivery for multi - site Hospital System. Participated in migration to Epic from home grown DB2 z/OS and IMS based solution. Supported data management and related infrastructure from inception to deployment, performance and capacity planning. Trained/certified on ITIL for managing change, continuous improvement, with 24X7 coverage (UCLA provided support cell, pager, and laptop). Involved in full project life cycle (SDLC). Core DBA functions include support for COTS and locally developed MS SQL Server applications up to 2008 R2. Supported failover cluster.
• Supported MS SQL Server 2000 and 2005. SQL Server Management Studio, and Quest Spotlight for monitoring and diagnostics. Microsoft SCOM. Supported SSRS, SSAS and SSIS ETL while we were building the Clarity environment. Supported MySQL database with replication. Supported Oracle databases 10g and 11g R2 with RMAN backups, RAC, and RAC 1 Node on DEV. Upgrade of databases, patch applications.

Consulting Systems Engineer

Confidential

Responsibilities:

• Sub - Contractor to Cook Systems Intl for Fedex Project Leader, ERP, DB2 on z/OS Responsible for installation & migration of Peoplesoft HCM. Install, configure and Migration of DB2 z/OS V7.1 to V8.1 supporting Peoplesoft HRMS, Payroll. Responsible for upgrading of PeopleSoft HRMS and Payroll People Tools ; Application from 8.3 to 8.9 with application supporting over 87,000 employees, vendors.
• Responsible for Data Architecture, troubleshooting, performance tuning and capacity planning. Responsible for establishing/streamlining extracts of HR data from mainframe to develop analytics including headcount, turnover, time to fill position; scorecards and dashboards. Track and manage issues (local and vendor) to resolution. Weekly status report to management. Responsible for designing partitioning of the data for proper placement of table spaces to enhance performance and allow for modular DBA maintenance. Provided scripts for modifying odd crlf characters during conversion (PS had indicated migration to 822 tools first but customer chose not to) to correct char representations. Responsible for data migrations using Unicenter Migrator. Also coded up DB2 Cross Loader (XLOAD) to support data migrations.
• Responsible for performance tuning and capacity review of CPU, DASD utilization, Buffer Pools, Parallel Sysplex data sharing CF Buffer utilization. Assist with DB2 Connect connectivity issues, load balancing to data sharing members. Monitor using CA Insight for DB2, IBM Candle Omegamon MVS and Omegamon DB2. Run batch Omegamon DB2 and MXG reports against SMF data. Coded several REXX routines one of which utilizes DSNACCOR stored proc to automate space extensions and REORG, Runstats. REXX routine to auto calculate space (inconvenient to call SpaceCalc routine in Unicenter) Helped developers with SQL tuning. Visual Explain and Plan Analyzer used. Also downloaded schema to alternate platform to utilize DB2 estimator and design advisor, Index advisor for heuristic analysis of z/OS environment, offline.