Senior Database Architect Resume
0/5 (Submit Your Rating)
SUMMARY
- Over twenty years of experience architecting, developing and administering database, warehouse and reporting solutions. Experience in the fields of healthcare, insurance and finance.
TECHNICAL SKILLS
- SQL Server 2012 and prior
- SSIS
- SSRS
- SSAS
- MDX
- T - SQL
- VB.Net
- Access
- Excel
- Visio
- Erwin
- ER Studio
- TFS
- TableauMDM - Master Data Management
PROFESSIONAL EXPERIENCE
Confidential
Senior Database Architect
Responsibilities:
- Completed design, development and deployment of a data warehouse including a normalized data store for consolidating data from multiple systems as well as dimensional data marts for loading into multidimensional databases for data analysis.
- Developed ETL packages using SSIS for loading data into the NDS and DDS.
- Created a suite of executive-level reporting from the new warehouse using SSRS.
- Created SSAS cubes for data analysis as well as trained high-end users to navigate and dice the cubes using Excel and PowerPivot.
- Assisted the team with migrating to TFS from Perforce. Developed a document set for common TFS-related tasks and led the training effort.
- Completed four complex reporting projects for the Fraud, Policy Administration Services, Operations and Quality Control units. Many of these reports completely automated manual tasks and contributed to improving departmental efficiencies.
- Developed a framework for mass-generating subscription reports using SQL Server 2008 Standard Edition. The process mimics data-driven subscriptions without the need for SQL Server Enterprise Edition.
Confidential
Director of Data Architecture
Responsibilities:
- Designed and developed a data warehouse for providing unified reporting from over six OLTP databases and the Master Data database. Personally designed the entire database model and the ETL needed for loading and keeping the warehouse current. As part of this project, led the database team and a team of consultants to rewrite numerous of reports from the separate OLTP databases to the collective data from the warehouse.
- Designed and implemented a central repository database for the management of master data including client, member, eligibility, subscribed services, medical plans, documentation and other related information to make available to call center and operational staff. This was key to our Master Data Management solution.
- Designed and built various repository databases for storing data from externally hosted applications, most importantly - the CRM database. Designed and implemented integration packages using SQL Server Integration Services (SSIS) for synchronizing these databases from data feeds. Constructing this integration led to over the development of 200 management and executive-level reports, many of which are now critical to day-to-day operations and executive-level decision making.
- Developed a reporting portal using SQL Server Reporting Services for data shopping from the central repository and other databases. The portal featured various report models which allow end-users to customize their own reports and allowed for report subscriptions to streamline delivery. A key report developed was the Client Utilization report which eliminated 100 monthly resource hours of previously performed manual work.
- Designed and developed a Sales database and application for housing contact information on prospects and sold accounts, as well as for storing and processing contractual information such as contracted services and rates. Data from this database was integrated with the central repository as part of a Master Data Management solution.
- Served as Database Administrator for the SQL servers, implementing security, maintenance, backups and restores, replication and encryption/decryption, migration projects, SQL upgrades and all other DBA functions.
- Recruited, managed, trained and mentored database analysts being the lead technical resource. Architected and reviewed deliverables for team.
Confidential
Database Administrator
Responsibilities:
- Project lead on multiple database system implementation projects.
- Responsible for providing training and direction to developers in advanced programming techniques.
- Evaluation and testing of database auditing software.
- Development of database administration for managing SQL Servers on the enterprise.
- Conversion of Access applications to SQL Server back-ends.
Confidential
Database Administrator/Database Developer
Responsibilities:
- Responsible for migration from SQL Server 2000 to SQL Server 2005 and implementing new SQL functionality including Reporting Services and Integration Services.
- Report creation using SQL Server Reporting Services, Active Reports and MS Access.
- Performance tuning, including query fine-tuning and indexing.
- Creation of the majority of server-side programming objects and functionality including audit trails, alerts, triggers, user-defined functions, stored procedures and the migration of legacy data into the new system.
- Setting up and monitoring advanced replication jobs that supply the data warehouse and the external web site.
- Monitoring SQL Servers in production, maintaining security and optimizing databases.
- In collaboration with a team of developers, developed and implemented the Global Project Management System; a mission-critical system designed for maintaining project, inventory, purchasing, billing and related data.
- Prepared system documentation; trained and supported end-users.
Confidential
Applications Programmer
Responsibilities:
- In collaboration with a team of developers, developing a portfolio management system. Involved in establishing standards for coding in a team environment.
- Develop business components for both the user interface and n-tier application layers using Visual Basic 6. Designing reports in Crystal Reports 8.0.
- Responsible for developing stored procedures, triggers and functions in SQL Server 2000.
- Administer SQL Server database security and database maintenance.
