Senior Systems/Database Analyst, Data Warehouse Resume Waynesboro, VA - Hire IT People

WORK EXPERIENCE:

Confidential, Waynesboro, VA

Senior Systems/Database Analyst, Data Warehouse

Responsibilities:

SSIS packages (data to and from multiple sources including DB2, Oracle, flat files, SQL Server, MS Access)
SSRS reports (including subscriptions)
SSAS cubes (multidimensional and tabular. Integration with SSRS reports)
SSMS (databases, stored procedures, views, functions, jobs)
Performance tuning of stored procedures against multiple databases which contain approximately 4.5 billion rows apiece. Implemented the ColumnStore Index available in 2012 against a large fact table for use in ad hoc querying.

Environment: SQL Server 2005/2008/2008 R2/2012 Reporting Services 2005/2008/2012 (SSRS) Integration Services 2000/ 2005/2008/2012 (Visual Studio 2010) (SSIS) Analysis Services 2008/2012 (SSAS) ASP Subversion Active Directory Services

Confidential, Richmond, VA

Data Analyst/Programmer

Responsibilities:

Development of a translation layer for importing multiple data sources into the Confidential Enterprise data warehouse
Created a mapping database in MS Access for use by the data analysts. Data was imported from and exported to MS Excel through the use of OLE Automation
After completion of the merger, moved into Analyst position.
Performance tuning
Database design (requirements gathering to physical design)

Environment: SQL Server 2000 (databases, stored procedures, views, functions, jobs, Query Analyzer) SQL Server 2000 DTS packages Access 2000 & XP Excel 2000 & XP Visual Source Safe

Confidential, Washington, DC

Database Analyst/Programmer

Responsibilities:

Development and support of the Department of Defense Computer/Electronic Accommodations Program (CAP), a fully Section 508 compliant client - server application. The CAP system was comprised of three separate SQL Server 2000 databases
Acquisitions database - OLTP design
Financials database - OLAP design
Marketing database - OLTP design
Moved data to and from the CAP website, a portal in which DOD and Federal employees with disabilities could request assistive technology
Designed and built a custom security layer for the CAP program to receive DoD DITSCAP accreditation
TMA’s Resource Management (RM) Directorate: Provided Web Intelligence Business Object support to RM’s WebI server.
CITPO Integrated Database: Responsible for the conversion of the RISK and LLD databases portion of the Tricare Management Activity’s (TMA) Clinical Information Technology Program Office (CITPO) Integrated Database (IDB) from MS Access 97
Performance tuning
Database design (requirements gathering to physical design)

Environment: MS Access XP Visual Basic 6.0 C# MS Excel XP SQL Server 2000 (databases, stored procedures, views, functions, jobs, Query Analyzer) SQL Server 2000 DTS SQL Server 2000 OLE automation 3DES encryption Active Directory Services CDOSYS Visual Source Safe

Confidential, Richmond, VA

Database Analyst/Programmer

Responsibilities:

Developed a system tracking $250 million of Medicaid payments integrated with program information for 4000+ MR Waiver recipients for the Department of Mental Health and Mental Retardation.
Database design (requirements gathering to physical design)

Environment: Access 2000 SQL Server 7.0 (ETL Layer, stored procedures, views, jobs) VB 6.0 HP3000

Confidential, Denver, CO

Help Desk/Trainer

Responsibilities:

Data conversion from existing legacy systems (COBOL, Revelation, PASCAL) into Spectrum’s HR Systems developed in Access 2.0, ’95, and ’97 and SQL 6.5.
Billable yearly quota of $120K (exceeded)
Supervised twelve-member help desk team providing end-user support to 500+ clients, as well as 100+ internal company users.
f internal and external clients on Access 2.0/95/97 and SQL 6.5
Key contributions included the development of two additional upper level courses and the redesign of the of new team members to allow for more hands-on with senior team members. New team members were able to begin and provide active help desk support in four to five weeks as opposed to four months. This also was applied to any new members of the client services consulting team.

We provide IT Staff Augmentation Services!

Senior Systems/database Analyst, Data Warehouse Resume

Waynesboro, VA

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship