Sql Server Information Technology

Education

COLEMAN UNIVERSITY– SAN DIEGO, CA

Master of Science in Computer Information Systems Management 2012- (2014)

Bachelor of Science in Computer Information Systems 2007-(2008)

Bachelor of Science in Computer Applications Networks 2000-(2003)

PROFESSIONAL SUMMARY

Over 15+ years of experience in IT, 10+ as Database Engineer, 8+ years Software Engineering, and Administrator and configuring application and database servers in Windows, UNIX, and Linux environment’s

Extensive hands on experience in designing relational and OLAP databases in several VLDB in Multi-Country Enterprise Environment for the U.S. Military.

Worked hand in hand with Business/Systems Analysis to design and implement Enterprise Planning to extend and improve system performance by implementing new solutions and testing deployment thoroughly before implementation

Extensive ability to use .NET code using C#.NET for creative and effective problem solving task using different platforms and architectures models.

Proficient in conducting research into different software and data solutions in order to come up with a new or improved design to improve or extend existing systems

Adapt to any new object model and API when necessary with a high learning curve

Knowledgeable in planning and implementing Database/Software/Systems Security Models and Determine policy for roles and Permissions.

Highly motivated individual with strong analytical and trouble shooting skills.

Flexible, enthusiastic and project oriented team player with solid communication skills with the ability to develop creative solution for challenging client needs.

SOFTWARE KNOWLEDGE

Operating Systems

Windows NT/2000/XP/2003/2008/2012, Solaris, Linux

Databases:

MS SQL Server, Oracle, Teradata, MySQL, MS Access, other propriety databases and ERP systems

ETL Tools:

SQL Server Integration Services(SSIS), ODI

Database /Utility Tools:

Visual Studio, SQL Profiler, SQL Query Analyzer, Management, DTS Import/Export, Backup Server, Replication server, SQL Alerts, SQL Jobs, Visual Source Safe, TFS.

Languages:

C #.NET, Java, SQL, T-SQL, C++, C, ASP.NET,

Reporting Tools:

SQL Server Reporting Services (SSRS), Crystal reports, Infopath, MS Excel and MS Access.

Certifications:

MCPD- SharePoint 2010 Developer, MCITP -SQL Server 2008, - Database Administrator, Database Developer, Business Intelligence Developer, and Security+, Oracle 11G associate, Also ITILv3 foundation, MCSE

EMPLOYMENT HISTORY

10/2016 – Current Centurum Information Technology San Diego, CA Enterprise Architect

Centurum Information Technology provides critical products and services that support the Navy. I am aiding in the planning and designing of the system and the migration into the current production environment in order for it to meet the ATO specifications provided by the DOD. I provided Enterprise support some of my duties included:

Primary Responsibilities: (Security Clearance)

Carefully review the STIG’s for the servers involved.

Provided an initial review of the IT Control’s involved

Revised and adapted plans according identified problems

Carefully listen to feedback from major stakeholders/included into plan

Given alternative solutions with pro’s and con’s for each scenario

Provided high level review of current business process in ATO

Broke down processes into Low Level components that can be addressed

Provided a logical sequence based on both priority and Logical Order

Identified and provided a viable solutions to items not resolved in initial process

Aided junior administrator in the installation database’s and web applications

Environment:

SQL Server 2008R2, ASP.NET, SharePoint, Visual Studio 2013/2015

12/2015 – 09/2016 TCTI, Monterey, CA Data Architect/Programmer V

22nd Century Technologies provides critical products and services that support the Army. I work with the application development team in order fully migrate into a new SharePoint 2016 environment. It provides redesigning and reengineering of existing applications in order to integrate into SharePoint. I provided Enterprise support some of my duties included:

Primary Responsibilities: (Security Clearance)

Work with Business Analysis and domain experts to clarify existing systems

Provide a detailed data/program analysis on targeted business processes.

Designed and implemented several ETL processes including data cleansing

Worked with SME on high priority items to help rapidly identify critical issues

Worked with other team members to brainstorm possible solutions

Review process to remove specific items from system to meet new regulations

Initial design of architecture of merging two external sources into new DB/System

Plan and trained others to implement all complex database activities

Identified areas of dirty data and poorly defined processes for future development

Environment:

SQL Server 2008R2, 2012, ASP.NET, SharePoint 2013,2016, Visual Studio 2013/2015

08/2014 – 08/2015 Alutiiq, San Diego, CA Computer Senior Systems/Program Analysis

Alutiiq LLC provides critical products and services that support the NAVY. It provides Operational and Maintenance duties for the Navy Technology Department. The primary duties are supporting an enterprise application called TMAPS. TMAPS is a web based system that is an authority resource of services for its genre. I provided Enterprise support some of my duties included:

Primary Responsibilities: (Security Clearance)

Provided Web Application, Database Development and Administrative Task continued to monitor and adjust systems based on physical, logical, and management requirements

Review all documentation concerning business processes and policies related to varies parts of system. Interviewed stake holders for clarification of key processes and for work flow and data flows of end users to ensure that system is meeting the needs of all. Created different diagrams in Visio for items that have not been documented.

Troubleshoot different database and application errors when applicable

Created code modules to support team environment in and all hands

Worked independent on own modules that were assigned

Summited improvement ideas to management for approval based on stake holder interviews and current limitations of database

Defined and Re-engineered the business process and database for Critical Module System to migrate to .NET 4. Planned the entire migration process

Planned to extend Critical Module system with external sources using WCF and XML

Aided in the Research for the application of Lucene

Aided team into troubleshooting coding and crawling issues of documents

Aided in Testing other developers programs before final deployment

Environment:

SQL Server 2008R2. ASP.NET, Visual Studio 2008/2010

05/2011 – 06/2012 ITT, Kuwait KM/SME/ Software and Database Engineer

IIT Systems provides critical products and services that support the government at home and abroad. It provides Operational and Maintenance duties for the U.S. Army in the South West Asia region. It supports all three enclaves: Classified Unclassified, and NATA networks. While working at the Theatre Network Operations Center (TNOC’s) provided Enterprise support some my duties included:

Primary Responsibilities: (Security Clearance)

Provided SharePoint and Database Development and Administrative Task continued to monitor and adjust systems based on physical, logical, and management requirements

Provided a point of escalation for Enterprise Systems Engineers (ESM) for any complex issues within the enterprise, usually database replication or cluster errors

Created and designed Reports, Document libraries, list, any other data repositories needed by management to resolve any process implementation needed for any new military procedures utilizing sand box solutions and an isolated development environment before implementing on the production network.

Developed and designed the Knowledge base and resource libraries for each department in the TNOC’s using SharePoint 2007 and 2010.

Defined and Re-engineered the business process for Reporting System, ITIL standards

Aided any junior DBA on different database platforms issues when needed with complex queries and database theory and application integration problems

Created web services as means to export XML data between systems and cross domain

Provided a point of escalation for Enterprise Systems Engineers (ESM) for any complex issues within the enterprise, usually database replication or cluster errors

Provided additional Support for ESM and NE for any high priority tickets that need immediate attention and all hands on for rapid resolution in VMware ESXi 4.1

Aided Department managers with custom forms and excel files by implementing complex code in order to upload updatable items into the SharePoint portal

Environment:

ESXi 4.1 VMware, with MD3000, MS 2003 server and 2008 server using Dell Power Edge R710, MD3000’s, and Cisco 3750 Catalyst Switches Visual Studio 3.0

02/2004 – 01/2010 Dave Hrycyszyn Enterprises, San Diego, CA, IT/IS consultant

David Hrycyszyn Enterprises was a company I owned and operated: There were several companies I conducted business with: ICEEL, CCS Global Tech, Brahma Holdings, and Trango Broadband are just a few of my major projects. There are other projects not listed.

01/2009 – 01/2010 ICEEL, Riyadh, Saudi Arabia Business Systems Analysis

ICEEL is the International Company for Education and E-Learning. The company was starting its takeover of the daily instruction of classes and management at King Suad University. My role on the project was more of a business analysis than a data analysis part of their contract was to modernize their existing system in the confines of their already existing infrastructure to meet the global educational institutions standards of the world.

Responsibilities

Performed System Study and Requirements Analysis, prepared Data Flow Diagrams, Entity Relationship Diagrams, Table Structures, with a lot of interaction with the client.

Involved in Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL and C#.NET to filter data within the legacy system from multiple data sources using SSIS and designed Middle Tier Application architecture.

``Designed Data Model of the project to accommodate business logic and dynamic nature of the front end application first using application then using ASP.NET.

Participated and helped to conducted several JRD sessions with the stakeholder’s for requirements gathering and definitions within the existing company protocols.

Developed a series of prototype applications to demonstrate proof of concept and to further design the final product specifications after each iteration additional features were added to meet the company expected needs and end results.

Involved in business requirements gathering, Technical Design documents, business use cases, and work flow diagrams

Environment:

.NET 3.0, MS SQL Server 2005 and 2008R2, Windows server 2003/2008R2

07/2006 – 12/2008 Trango Broadband, San Diego, CA Applications Engineer II

Trango is the leading provider of high-speed fixed wireless solutions for broadband Internet access; Enterprise wireless backhaul, telecom and carrier licensed microwave backhaul; municipal and government wireless networks; and wireless video surveillance security systems.

Project required implementation of warehouse for their products’ sale transactions and their geographical locations using Analysis Services and ETL using Integration Services. Reports needed to be generated using Reporting Services

Responsibilities

Designed Data Model and implemented changes in the earlier phase of the project to accommodate business logic and dynamic nature of the front end application.

Developed database objects like Tables, Triggers, and Indexes using T-SQL Management Studio.

Configured packages for Testing and Production environments using hand written code to debug the process at the middle tier application.

Configured the SSIS Package for run time Parameters and Configuration file

Developed documents for Logging/Error Handling for SSIS Packages

Integrated SSIS package, converting all existing DTS packages of MS SQL 2000 to 2005 by adding extra SSIS task.

Performed T-SQL tuning and optimizing queries for Reports which took longer time in execution.

Developed interface and reporting stored procedures, views, UDF for efficient data storage and manipulation

De-normalized database using Stored Procedures for a single row feed to legacy system.

Created dynamic SQL in Stored Procedures to support the dynamic nature of the front end application.

Handled the errors during data moving and Sequencing the task as per requirements.

Developed SSRS Reports like drill throw reports, drill down reports, linked reports and parameterized reports.

Deployed SSRS reports to the reporting server and assisted in troubleshooting deployment problems.

Optimized reports buy optimizing the embedded queries, or optimized the stored procedures that generate them.

Formatted reports by applying parameters, and assigned parameter defaults and data types.

Extended reports as well as invoked embedded functions and integrated assemblies using expressions.

Extracted XML result set from Stored Procedures to create custom XML file for third party data export.

Environment:

.NET 3.0 and 2.0 SSAS, SSIS, SSRS, MS SQL Server 2005, Windows server 2000/2003

09/2004 - 06/2006 Brahma Holdings, San Diego, CA .NET/ETL Developer

Project was implemented for a staffing and consulting client of Brahma Holdings, which provides highly skilled consultants to their esteemed clients. Project initially involved maintenance of their existing Consultant and Skill matrix database on SQL Server 2000. During August 2005, a new project was underway to warehouse their staffing and consulting operations on Analysis Services.

Contact this candidate