•Conduct data cleansing and remediation to enhance data quality utilizing SQL, Stored Procedures, Linked Servers, SSIS and SQL Server Management Studio•Gather Requirements for modernization and movement of systems to Azure Cloud MS SQL managed instance•Design Database Solutions for consolidation and modernization of Databases within Azure Cloud•Support and Build Data Architecture for Azure Cloud MS SQL Server and Salesforce•Build and modify Stored Procedures for improving data quality, collection and reporting•Support Agile Development and sprint deployments and utilize Jira for task and Sprint tasking.

Gather requirements for modernization and migration of revenue system to Azure Cloud/Azure SQLPrepare Conceptual, Logical and Physical Data models for cloud Prepare migration documentation for CloudPrepare Data Management Plan for Cloud for CMMI Level 4 compliancePrepare and coordinate on DHS required documents for new revenue systemResearch low-code and no-code solutions for use in cloud environmentPresent to senior management findings and Data Management Plan, Data Models, governance documents.work with government personnel to refine requirements and capture all processes for data collection, bill processing and interfaces.

Gather Requirements for Biometric data management and resolution managementPrepare Data Quality Analysis and documentationUpdate Data Management PlanSetup working groups for Data Management and Governance BoardCoordinate with contracting firms for data quality and security for structured and un-structured data for meeting mission requirements

US Department of the Army:Perform data modeling for Analytic and Business Intelligence VisualizationsBuild and maintain Visualizations on monthly reportingMaintain Dashboard for Visualizations for PEO Soldier HQPresent bi-weekly to Sr Executive Army Major General and his staffWork on Data Governance of data Department of Defense, Secretary of Defense (OUSD A&S)/ASD(A)/DASD(AE)/AAP/AD • Manage team to support government requirements for Analytic reporting for DAVE system.• Redesign and implement database structures for the data science analytic system • Improve queries and stored procedures to access data for reporting requirements for Senior Leadership and Congress.• Manage Microsoft SQL Server 2016 and provide support for data science team• Business requirements gathering to support Data reporting• Data Modeling for Data reporting requirements for Senior Leadership• Provide SME Database expertise in best practices for analytic environment• Manage team of Data Science Developers, perform goal setting, touch base, mid-term reviews, annual reviews

Senior Database Administrator/Architect/Lead Analytics Manager for PEO SoldierBuilding Data Analytic visualizations in O365 Cloud environment utilizing Agile methodologyCo-Managed Center of Excellence group for Governance within PEO SoldierWorked as SME for Database Administration for OSD to support Data Scientist for OSD Acquisiton Analytic Reporting

Supported The IRS for its Big Data Greenplum team• Support Greenplum environment for IRS Analytic Database Support System• Run test and production queries • Run health checks on Greenplum database and hardware checks• Respond to ticket assignments to run queries in test and production• Perform Greenplum database backups and restoresOffice of Financial Research - Washington DCAdminister and manage multiple OFRAE database servers supporting SQL Server, Postgres, Hadoop Hive and Impala databases. Provide database design, management, tuning, operations support and meta-data support in support of big data warehouse for research and analytics of financial data supplied from multiple independent sources. • Provision access to SQL Server databases and files shares. Setup membership in groups in Active Directory. • Planned and implemented database migration to new releases of Microsoft SQL Server in OFRAE database environment. • Created stored procedures to monitor usage of RDBMS for monthly reporting.• Develop solutions on Hadoop to collect and maintain database statistics utilizing Scoop, Impala, Hive and Oozie. • Provide SDLC guidance to ETL process to ingest data into OFRAE databases. • Work with researchers to improve performance via query tuning, view and index creation. • Coordinate with teams to ensure security and reliability of databases infrastructure.• Document procedures for Data Management group. • Monitor and manage 20+ Terabytes of data in SQL Server Databases and file shares. • Supported, planned and implemented DR/Coop exercises within OFRAE.• Provide monthly reporting on user access, space usage and other required stats to senior management• Support Analytical environment tool set of Microsoft SSIS, SSRS, SSAS, Tableau, Hive, Impala, Scoop• Utilize Cloudera Manager, Cloudera Navigator, Solorwinds, Spotlight tools to monitor environments.

SQL Server Database Administrator supporting the National Children's Study. Perform day to day operations, developer support, performance management, security and backup and recovery processes.

Performed the day to day tasks to implement and maintain the table structures in Development, Testing, Quality Assurance, Production and Training environments in compliance with Customs and Border Protection (CBP) System Development Life Cycle (SDLC) supporting CBP requirements for US-Visit, Primary Inspection, Secondary Inspection and Watch List applications. Planned and coordinated with Application Teams, Middleware, Storage Management, MVS and CICS to prepare production jobs for scheduled maintenance and emergency outages. Developed RDBMS processes, utilizing CBP standards and procedures, Conducted tests, authentication and verifying vendor remediation. Provided support during business hours, after hours and on an emergency basis to provide continuous and consistent 99.9% system availability. Managed 23 Terabytes of data in production.• Provided technical recommendations and support to application staff related to the design, modification of table structures and proper key design and usage.• Participated with project staff on modernization of current systems to new technologies.• Maintains system performance by partnering in the tuning of application DBMS requests.• Provided continuity of service from a remote location by initiating a standby and replacement DBMS during the semi-annual Disaster Recovery Exercises and monthly maintenance.• Facilitated the Database System Support Staff identification and resolution of CA-Datacom production issues or errors utilizing monitoring tools, CA-Sysview, T-Mon for MVS and DBMS utilities.

Built Oracle and CA-Datacom database schemas, maintaining and supporting the databases for commercial, in house transactional and warehouse written applications. Managed the space configurations for all database schemas and indexes utilizing Oracle Enterprise Manager, SQL, SQL-Loader, ERWIN and TOAD. Provided resolution of performance issues for applications and systems staff. Implemented upgrades and maintenance and testing of database releases and patches. Worked with Applications and end users on SQL queries, and tuning issues to maintain system performance. Instituted security administration for users and programming staff. Provided documentation to University and Legislative auditors, ensuring security procedures and maintaining all security protocols.• Designed and implemented the Oracle Database schemas and CA-Datacom structures for Student Registration, Student Records, Personnel systems, and warehouse and decision support systems.• Developed Oracle database schemas and wrote the application code, utilizing ColdFusion and Dreamweaver software for billing of internet hosting services provided by the university.• Designed and conducted system analysis and design for the Project Tracking Application.Implemented Database structures for COTS software supporting Financial Payroll System