Experience

Rali
• United States
• Software Development
• 1 - 100 Employee
• Database Architect

  • Oct 2021 - Present

Hisestate Technologies LLC
• Managing Partner

  • Feb 2018 - Present

Centers for Disease Control and Prevention
• United States
• Government Administration
• 700 & Above Employee
• Database Developer

  • Feb 2018 - Oct 2021


Leading the Way

• Database Manager

  • Jul 2014 - Feb 2018

  Manage CRM database Support CRM application Create reports using SSRS, T-SQL Create ETL routines and processes Create SQL Scripts and UAT test cases for data import Implement Enterprise Power BI reporting solution Facilitate migration to SQL 2016 Manage CRM database Support CRM application Create reports using SSRS, T-SQL Create ETL routines and processes Create SQL Scripts and UAT test cases for data import Implement Enterprise Power BI reporting solution Facilitate migration to SQL 2016



Booz Allen Hamilton

• United States
• IT Services and IT Consulting
• 700 & Above Employee

• Senior Consultant

  • Jan 2014 - Jul 2014

  Develop T-SQL scripts for GIS applications for the CDC Create databases Create stored procedures, views, tables for custom GIS applications Develop T-SQL scripts for GIS applications for the CDC Create databases Create stored procedures, views, tables for custom GIS applications



Emergint

• United States
• IT Services and IT Consulting

• DBA

  • Jun 2006 - Sep 2013

  Acted as team lead for four members of the data management team Delegated tasks and assignments to the data management team Acted as a liaison between the CDC customer and the contracting company Facilitated regular team meetings to improve team efficiency, encourage team communication, and to keep the team informed of data management team status Created, enhanced and maintained SSRS reports including dashboard reports packages, and database changes to systems supported by the Office of Information Systems (OIS) Configured column-level SQL database encryption to protect sensitive data Coordinated implementation and deployment of Web applications, SSRS reports, SSIS ETL Developed standard operating procedure for deployment and implementation of new and existing systems throughout all stages of the development lifecycle for OIS supported systems Evaluated and implemented scripts for new and altered stored procedures, functions, roles and database users in production environment Created status report in SQL Server 2005 Reporting Services to query database team resource request system Installed and configured SQL Server databases Coordinated implementation of SAMS authentication process for external facing secure applications software Configured development and sandbox web environments for small applications Installed, configured, and administered Axosoft and VersionOne bug tracking systems for different application development teams Created database synchronization scripts using Redgate Software tools Created and implemented database archive process for retired systems Created metadata databases used to track databases and corresponding solutions, user id’s, and servers Set up and maintained SQL Server merge replication solution Utilized SQL Profiler for performance tuning Created and implemented database migration process for upgrade to SQL Server 2005, 2008 and 2012 for OIS supported databases



Centers for Disease Control

• United States
• Government Administration
• 1 - 100 Employee

• Database Administrator

  • 2006 - Sep 2013

  Acted as team lead for four members of the data management team Delegated tasks and assignments to the data management team Acted as a liaison between the CDC customer and the contracting company Facilitated regular team meetings to improve team efficiency, encourage team communication, and to keep the team informed of data management team status Created, enhanced and maintained SSRS reports including dashboard reports packages, and database changes to systems supported by the Office of Information Systems (OIS) Configured column-level SQL database encryption to protect sensitive data Coordinated implementation and deployment of Web applications, SSRS reports, SSIS ETL Developed standard operating procedure for deployment and implementation of new and existing systems throughout all stages of the development lifecycle for OIS supported systems Evaluated and implemented scripts for new and altered stored procedures, functions, roles and database users in production environment Created status report in SQL Server 2005 Reporting Services to query database team resource request system Installed and configured SQL Server databases Coordinated implementation of SAMS authentication process for external facing secure applications software Configured development and sandbox web environments for small applications Installed, configured, and administered Axosoft and VersionOne bug tracking systems for different application development teams Created database synchronization scripts using Redgate Software tools Created and implemented database archive process for retired systems Created metadata databases used to track databases and corresponding solutions, user id’s, and servers Set up and maintained SQL Server merge replication solution Utilized SQL Profiler for performance tuning Created and implemented database migration process for upgrade to SQL Server 2005, 2008 and 2012 for OIS supported databases



AirTran Airways

• Airlines and Aviation
• 700 & Above Employee

• Database Administrator

  • Aug 2005 - Jun 2006

  Performed Database Administration duties for Microsoft SQL Server 2000 and 2005 databases and (as the CTO described it) "other duties as needed". Performed Database Administration duties for Microsoft SQL Server 2000 and 2005 databases and (as the CTO described it) "other duties as needed".



AIG

• Egypt
• Oil and Gas
• 1 - 100 Employee

• Database Administrator

  • 2000 - 2005

  Worked with financial department and outside consultants to design and implement Great Plains accounting package in SQL Server environment and corresponding OLAP reporting component using Essbase reporting tool Created, scheduled, and maintained data integrations and load routines for monthly updates of accounting data using Microsoft Integration Manager for Great Plains and Microsoft DTS packages for SQL Server Developed installation for nationally distributed Windows based insurance rating application using InstallShield Led version control efforts for simultaneous releases of insurance rating application Created OLAP Essbase applications used for corporate data analysis Formulated procedure for recording, prioritizing, and tracking report requests Created and enhanced ad-hoc and scheduled database reports for various corporate departments using Crystal Reports and Seagate Info Assisted in optimizing transaction queries using SQL Profiler Utilized SQL Server DTS Packages for data integrations Set up database replication using log shipping to create reporting version of production OLTP database Provided sole support for 24X7 OLTP SQL Server database used to generate $1 to $3 million revenue daily Migrated SQL Server databases from Windows NT to Windows 2003 Cluster environment Established maintenance plans including nightly hot backups for all production SQL Server databases Established disaster recovery process for production SQL Server databases