Data Warehouse Manager Resume Example
Love this resume?Build Your Own Now
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
Tiaa – Durham
Tiaa – Durham
- 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
Microstrategy – Chicago
Microstrategy – Chicago
- 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) – City
NYC Department Of Environmental Protection (DEP) – City
- 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
Merrill Lynch
DISCLAIMER
Resumes, and other information uploaded or provided by the user, are considered User Content governed by our Terms & Conditions. As such, it is not owned by us, and it is the user who retains ownership over such content.
How this resume score could be improved?
Many factors go into creating a strong resume. Here are a few tweaks that could improve the score of this resume:
Resume Strength
- Completeness
- Formatting
- Word choice
- Length
- Measurable results
- Strong summary
- Typos
Resume Overview
Job Titles Held:
- Data Warehouse Manager
- Sr. Certified Applications Developer - IV
- Consultant
Similar Resumes
