Data Warehouse Manager Resume Example NYC Department Of Health And Mental Hygiene (DOHMH)

DATA WAREHOUSE MANAGER

Professional Summary

15 years of diversified IT experience in database administration and management, data warehouse development and implementation, building software systems to improve functionality, productivity and consistently meeting critical requirements.

Skills

Strong SQL Server Database Administration, Data Warehouse development and Implementation.
Strong hands on experience using ETL tools such as SSIS, SSAS and SSRS.
Conversant with all phase of Software Development Life Cycle (SDLC) involving Systems Analysis, Design, Development and Implementation.
Expertise in Logical and Physical Database Design and Development, Normalization, data Modelling, Metadata and data quality management.
Strong T-SQL skills, trouble shoot and resolve slow running Queries, performance tuning and SQL Server functionality.
Excellent problem solving abilities in diagnosing and resolving critical issues.
Excellent communication and Team leading Skills.

Technologies

MS SQL Server 2012/2008/2005/2000, Visual Studio (BIDS/Data Tools), SSIS, SSAS, SSRS, .Net Framework, ASP.Net, ASP, SharePoint, MS Project Server, ChartFx, Web Services, ASP.Net Charts and ArcGIS, C#, VB.Net, VB, ASP, VBScript, Java Script, JQuery, HTML, XML, XSLT, DHTML, T-SQL, Share Point Designer, Info path Designer, Crystal Reports, Visio, FrontPage, Arc Catalog, My SQL, DB2, UDB

Professional Certifications

Microsoft Certified Solutions Associate (MCSA) for SQL Server 2012.
Microsoft Certified Application Developer (MCAD) for .Net.

Education

Post graduate diploma in computer applications, National Institute of Information Technology, India.

BS in Mechanical Engineering, Bangalore University, India.

Project Management Certificate, Middlesex county college, NJ.

Work History

Data Warehouse Manager, 07/2011 to Current
NYC Department of Health and Mental Hygiene (DOHMH) – NYC

SQL Server Database administration and data warehouse development.
Implement HQIN data warehouse of clinical and claims data for data driven interventions of NYC population .
Develop analytical capabilities and reporting systems for disease prevalence, quality of care, statistical analysis on key areas of NYC health care system.
Monitor SQL Server performance, diagnose and troubleshoot issues using Query execution plans, Perfmon, Activity Monitor, SQL Server Profiler and Database engine tuning adviser to increase efficiency.
Establish and maintain database backups and recovery policies, perform time to time restores.
Ensure system and data availability and integrity through preventive maintenance and upgrades.
Implement policies, technical procedures and standards for preserving integrity, security and encryption of data, reports and access.
Design and develop databases and analytical infrastructure.
Design and develop ETL processes in SSIS to import and export data from multiple sources in various formats. Prepare data for bulk load processing.
Design and develop analytical cubes using SSAS.
Create and deploy SSRS reports.
Develop and optimize complex queries, indexes, stored procedures, functions and triggers.
Create and set up SQL Server jobs, alerts and notifications.
Coordinated with system partners in requirements gathering and business rules analysis to creating physical and logical data models.
Develop and maintain data dictionaries, documentation and standards.
Consistently met project deadlines and requirements.

Sr. Certified Applications Developer - IV, 04/2007 to 06/2011
NYC Department of Transportation (DOT) – NYC

Implemented Data Warehouse for Taxi Trip data for traffic studies and analysis.
Implemented Sharepoint portal for inter-agency collaboration and business process. Designed master pages and page layouts, served as agency's main SharePoint support for all technical complications.
Implemented a customized MS Project server for agency wide project management tool.
Managed and Administered SQL Server, Sharepoint and Project Server.
Developed and maintained complex internet and intranet applications.
Implemented company policies, technical procedures and standards for preserving the integrity and security of data, reports and access.
Provide continued maintenance and developemnt of bug fixes and patch sets for existing applications.
Coordinated with systems partners to finalize designs and confirm requirements.
Created Technical design, project plans, estimations, preparing Work Breakdown Structure (WBS)
Developed complex Stored Procedures and identifying best practices.
Implemented SSIS Packages to integrate data from various data sources and Data Migrations from DTS to SSIS.
Developed and deployed reports using SSRS.
Successfully integrated maps in asp.net application Arc GIS.
Worked closely with DOITT in setting up public facing applications on DMZ for inter agency collaboration on various initiatives.

Sr. Certified Applications Developer - IV, 04/2001 to 03/2007
NYC Department of Environmental Protection (DEP) – NYC

Developed and implemented complex intranet windows and web applications on multiple platforms.
Provided continued maintenance and development of bug fixes and patches for existing web and client server applications.
Worked as a technical lead and lead developer using VB.Net, .Net Framework 1.1/2.0, ASP.Net, ASP, VB, COM, VS2003, DB2, UDB, Web services.

Created common framework for data access, business and presentation layers in .Net and classic ASP for rapid application development.
Converted classic ASP applications into ASP.Net Designed and Developed console applications in VB and VB.Net for batch processing.
Designed and developed a data warehouse solution for financial reporting system.
Developed management reports using complex SQL queries to produce financial reports.
Evaluated the impact and scope of proposed requirements on the existing systems and prioritized the requirements.
Responsibilities extended to production support, troubleshooting production problems and maintenance of the system, training and research work for the team.
Consistently met project deadlines and requirements.

Consultant, 12/1999 to 03/2001
Merrill Lynch

Resume Overview

Create a job alert for [job role title] at [location].

About About

Help & Support Help & Support

Languages Languages

Customer Service Customer Service

Data Warehouse Manager Resume Example

Resume Score: 70%