SUMMARY:

• Dynamic leader of software development teams with active DoD Top Secret (TS) clearance offering more than 10 years of experience including managing mission critical projects.
• Proven to be skilled in all phases of the system development lifecycle (SDLC); adept in translating business requirements into technical solutions; and fanatical about quality, usability, security and scalability.
• Strengths include: SQL Server programming and administration; relational database architecture design and implementation; and complex business, data, and systems analysis inclusive of cyber security and risk mitigation.

TECHNICAL& SKILLS

• SQL Server DBA, SQL Architect, SQL Server performances tuning (SSIS, SSRS and SSAS) including scripts, stored procedures, triggers, etc.
• MySQL programming and scripting
• Oracle Programming and scripting
• Cognos Framework Manager and Report Studio
• Knowledge of iDirect, SatManage, NMS, Remedy and Navision
• Knowledge of SPOT, TOPSS and JAMMS
• Advanced Level LogiXML
• Write complex SQL codes to support multi - tier applications
• Perform Logical codes’ reviews to peers or team members.
• Perform analysis using advanced Excel functions and database scripting

PROFESSIONAL EXPERIENCE:

Confidential

Sr. SQL Server DBA / Developer - Cyber Security Analyst

Responsibilities:

• Built and maintained SSIS packages to extract, transform and load (ETL) cyber security data from multiple sources such as SMS, ePO and NeuralStar to support the Department of State (DoS) internal risk scoring application (iPOST)
• Analyzed and built database algorithms to correlate host and user account information from various sources (FoundStone, SCOM…) and assigned a score to each identified security weakness based on multiple categories directed by the Office of Information Assurance (IA)
• Provided near-real time technical vulnerability reports to senior management with the emphasis of reducing cyber security risks
• Re-configured database instance features to optimize system performance including memory utilization
• Fine-tuned SQL Server objects which reduced the execution time by over forty percent
• Developed an automated database Security Technical Implementation Guide (STIG) configuration eliminating the need of manual interventions
• Pro-actively monitored database health and SQL Agent jobs reducing down time and minimizing the impact to mission objectives
• Re-created supporting objects and coded elements to support the migration of iPost security information into a new architecture

Oracle and Cognos Developer

Responsibilities:

• Supported the United States Secret Service (USSS) Oracle data warehouse, storing the agency’s accounting, financial, budgeting, travel expenses and procurement information
• Maintained current and created new Business Intelligence (BI) objects such as models, reports and dashboards using Cognos Framework Manager and Report Studio
• Performed data analyst and architecture in preparation for the Oracle R12 upgrade
• Converted and redesigned BI Cognos objects in conjunction with the upgrade

Sr. SQL Server DBA & BI Developer & Data Analyst

Responsibilities:

• Gathered and specified front and back ends’ requirements of a Financial Report System for the Confidential (DVA)
• Designed, built a Data Warehouse/DataMart using SQL Server 2012 database to store and integrate data from a SAAS Veterans Financial Management System (FMS)
• Designed and implemented data transfer engine and objects such as Stored Procedures, Views etc. to support the report data retrieval
• Built financial report(s) using SQL Server Reporting Services (SSRS) published on the VHA and VBA SharePoint sites
• Delivered a four-month projected deadline of the report in a month and half
• Specified, designed and built DVA Financial Dashboard to display the daily, monthly and yearly financial fluctuations

Sr. SQL Server DBA & Data Analyst

Responsibilities:

• Analyzed and Converted an existing MS Access database structure into a scalable MS SQL Server 2008 R2 for Congressional Census reporting
• Analyzed, architected and developed a SQL Server RDBMS to support Congressional reports using T-SQL and MS Excel formulas based on DoD rules and restrictions
• Formulized Congressional Census reporting processes and User Guides
• Participated in NIPR (unclassified) and SIPR (classified) databases deployments’ activities
• Created and delivered On Demand Ad hoc reports to DMDC and PMO personnel
• Proposed Solution for ETL on Cluster environments
• Fine-tuned SQL Objects for performance (Stored Procedures to make them run less than 5 minutes from 100 minutes)
• Developed faster, more manageable and better databases’ standards and procedures to control access and deployments
• Support System Maintenance -Resolved deployment applications’ tickets such as SPOT, TOPSS and JAMMS
• Analyzed, Built and Released GAO (Government Accountability Office) Report

Sr. SQL Server DBA & Data Analyst

Responsibilities:

• Setup Backup maintenance plans and alert notifications for all SQL server environments. Defined hardware requirements based on applications needs
• Configured SQL Server memory allocation and control
• Automated custom Traces Audit for Customer environments
• Performed server and database performance analysis
• Setup server and database roles for access control for production and non-production environments
• Analyzed and identified parent company Call Detail Records (CDR) formats, traffic, services etc. to convert into affiliated formats and requirements
• Architected and developed the CDR processing to collect, store and process satellite traffic and resolve services for billing
• Analyzed and identified parent system interface (BSS DPI: Business Support System for Distributor Partner Interface) to architect and develop the backend database that allows the communication between parent and local systems for BGAN, FBB, SBB and GSPS SIM card activation, deactivation, change services etc.
• Verified, applied and responded to Security Technical Implementation Guides (STIGs) processes on security servers’ scans.

Director of Strategic Projects

Responsibilities:

• Supported the company Chief Technology Officer (CTO) to deliver strategic sales presentations to France Telecom (FT Orange), AT&T, American Movil, etc. through the use of SQL Server, MS Power Point, and live demos to secure approximately $30 million dollars in business
• Generated demonstrable data (CDRs, MOS etc.) to support CTO and sales department for demonstrating multiple scenarios such as VOIP, SMS, etc.
• Managed cross functionally to design and develop a custom integration application (ETL) using Excel formulas, VBA, MS Linked Server, and SQL Server with a minimum company resource to enable new Confidential clients to extract, transform and load (ETL) their legacy data onto the iXTools platform; transformed the initialization process of the Company deployment to 20x faster and significantly saved the company delivery resources
• As the Solution Architect, I managed a cross functional team of 5 members to develop, deliver, and implement Asia region projects to Taiwan Mobile (TWM) and China Mobile Incorporated (CMI)

BI and SQL Server Administrator Team Lead

Responsibilities:

• Managed, developed, tuned and maintained web based and data driven reporting application (iXReport - SSRS) including multi-dimensional reports using mathematical dimensions Stored Procedures model and XML technologies with LogiXML using SQL Server 2000 to facilitate decision makers ( Confidential clients) to retrieve almost real-time information (Data mart & Data warehouse)
• Managed, developed, and maintained the web based system administration module (iXAdmin) that controls and administers users’ access to integrate the Company’s various products
• Led the design of the Company’s products Graphic User Interface (GUI) and iXTools using Cascading Style Sheet (CSS) and Photoshop 7/CS to simplify reporting system

Web and API developer, SQL Server DBA & QA Lead

Responsibilities:

• Developed web based interfaces for international telecommunication routing (iXRoute) to efficiently record and track cost and revenue using SQL Server, XML, and VB.Net
• Developed and maintained web based in-house applications such as Time Sheet Entry system and report, as well as Version Control system using aforementioned Microsoft technologies
• Developed APIs (Application Programming Interfaces) for the systematic transfer of data to and from various client systems using SQL Server Stored Procedures
• Built and maintained APIs technical documents to match client requirements
• Performed SQL Server DBA role including Microsoft SQL Server versions’ upgrades, SQL Server Agents tuning and monitoring (SSIS, SSAS) as well as configured the company web-base to enable the system that automatically integrates, stores, backs - up the Company various products across multiple servers, platforms, and inter-departments
• Designed and implemented the first test-plans and cases for the Quality Assurance Department

System Analyst & Web and Database Developer

Responsibilities:

• Developed a Budget Execution Application using PowerBuilder 5.0/7.0 and Informix 7.22/9.21 for a US Navy Yard project
• Built an Excel VBA 6.0 and Microsoft Access application to retrieve discrepancies between US Navy Food Supply Receipts and Billing
• Developed and maintained the Defense Security System (DSS) for US DoD using Visual Basic 6.0, Cristal Report 6/8, SQL Server 7.0 and Oracle 8.0
• Used UML to document Technical Specifications for Object Oriented applications