AREAS OF EXPERTISE:

• Project Management
• Team Management
• Requirements Analysis
• CMMI Processes
• ASP.NET / VB.NET/MVC
• SQL Server DBA and Programming
• SQL Server Reporting Services (SSRS)
• SQL Server Integration Services (SSIS)
• IIS Servers
• ColdFusion
• Team Foundation Server (TFS)
• Visual Studio
• SQL Server Analysis Services (SSAS)
• SQL Master Data Services (MDS) and Data Quality Services (DQS)

TECHNICAL SKILLS:

SOFTWARE: ASP.NET, VB.NET, Dev Express .NET Controls, SQL Server, Team Foundation Server, SQL Server Reporting Services, SQL Server Integration Services, SQL Server Analysis Services, Master Data Services, Microsoft Project, Visual Studio, ColdFusion, JavaScript, Flash, Dreamweaver, Adobe Photoshop, Adobe Illustrator

PROFESSIONAL EXPERIENCE:

Senior SQL Business Intelligence Developer

Confidential

Responsibilities:

• Implementation of SSIS packages to perform ETL process to load financial data from excel documents. Process involves for each loop containers, sequence container, splits, data flow tasks, conditional splits, parameters, variables, and SQL script tasks. Long term objective is to create data warehouse and data cubes.
• Implementation of a series of SSRS parameter driven reports involving planned and actual reimbursable reports for fund centers.
• Implementation of additional TFS metric reports involving dashboards and agile project comparative reports for burndown rates.
• Implementation of MDS for contract data to assist with proof of concept to business for data stewardship.

Program Contractor Lead

Responsibilities:

• Implementation of a SSIS and SSAS process to load and process web logs from three IIS servers. The ETL process uses data from delimited text files and loads them into a data warehouse. The data warehouse is processed into Online Analytical Processing ( OLAP) cube to create web activity metrics. The SSIS process involves a series of condition, parameters, variables, SQL script tasks, for each loop containers, and error logging.
• Creation of a series of automated parameterize data driven SSRS report subscriptions. Reports range from page activity, user activity, and file down loads. Excel and PDF files are stored to file shares, as well as, sent to customers.
• Creation of SSRS dashboard reports for web portal to display frequency of access of programs’ systems and software.
• Implementation SQL Server 2012 Sematic Search as search engine for web portals to index content and render results. Further, created SSIS package to load portal files into the Semantic Search shares to add and remove content as needed.
• Add enhancements to site to allow users to set content filter preferences when accessing the site.
• Implementation of new security model for accessing web portals by replacing Active Directory (AD) with forms and token authentication. Involved migration of existing AD accounts to SQL database to support new authentication. Created backend too to manage user accounts, roles, and permissions to sites.
• Added new geographic display functionality to site to allow users to access information that is associated to specific products and regions.
• Redesign of AWSSSP portal that incorporates three portals under one unified umbrae as air and ground systems. Portal content is rendered dynamically from data stored in a SQL databases. New site will reduce the need for support and maintenance of static web pages because of data driven content.
• Migration of the CREW portal to a content management application where portal content is rendered dynamically from data stored in a SQL databases.
• Created automate scheduled SQL Server tasks to notify users by email that their password was expiring.
• Created administrative tools to management mission data and automate email notifications for significant portal posting. Both tasks significantly reduced the work load of staff and reduced the response time to implement tasks.
• Leveraging new technologies to assist business in reaching its goals including virtualized servers and workstations, Dev Express web development controls, SharePoint, Map Suite, jQuery, Team Foundation Server, and WebTrends.
• Implementation of CMMI level 3 process improvements for the ARAT - OC.

Senior Analysts

Confidential

Responsibilities:

• Implement the use of SQL Enterprise for data driven subscriptions for SSRS.
• Design, create, and maintain application that automates the creation of a provider director database used by marketing to assist members in selecting practitioners in their area.

Senior Project Manager/SQL DBA/Programmer Analysts

Confidential

Responsibilities:

• Designed, developed, and supported AIMS WEB application that manages product, customer, and sales forecast information. Further, application involves multiple data imports and exports of customer, product, and SAP data. Application employs the use of ASP.NET, VB.NET, SQL 2005, SSRS, and SSIS.
• Designed, developed, and manage product information sheet WEB application that allows the business to review, approve, track, and publish changes of product information sheets. SQL 2005, ASP.NET, VB.NET, and SSRS are used in the application.
• Database administrator and developer for department. Managed and supported seven SQL servers for department involving replication, security, SQL Integration Services, maintenance plans, DTS, database design, table constraints, schedule jobs, SQL mail, SQL trace, SQL tuning, SQL migrations from 7.0, 2000, and 2005. Experienced with programming including stored procedures, triggers, views, functions, cursor, joins, dynamic queries, execution plans, etc.
• Proficient with SSRS. Support over 60 department reports. Experienced with administration, subscriptions, report design, matrixes, tables, graphs, and parameters.
• Wrote proposal that implemented the use of virtual servers for IT department as QA and development environments.
• Designed, developed, and managed R&D study WEB application that allows business to track the progress of studies. Application allows business to manage documents associated to studies and email notification process for study contacts when changes occur to the study’s status. Application uses ColdFusion and SQL 2000.

Webmaster

Confidential

Responsibilities:

• Designed, developed, and supported IT Request WEB application to manage IT projects resources. Application uses ColdFusion and SQL 2000.
• Designed, developed, and supported HR WEB application for job postings, recruiting, and hiring. Application uses ColdFusion and SQL 2000.

Programmer Analysts

Confidential

Responsibilities:

• Supported the financial applications for the Curtis Bay plant. In addition, was the Y2K transition project plant manager.