• Dashboard
  • Resumes
  • Cover Letters
  • Resumes
    • Resumes
    • Resume Builder
    • Resume Examples
      • Resume Examples
      • Nursing
      • Customer Service
      • Education
      • Sales
      • Manager
      • View All
    • Resume Search
    • Resume Templates
      • Resume Templates
      • Microsoft Word
      • Professional
      • Modern
      • Traditional
      • Creative
      • View All
    • Resume Services
    • Resume Formats
      • Resume Formats
      • Chronological
      • Functional
      • Combination
    • Resume Review
    • How to Write a Resume
      • How to Write a Resume
      • Summary
      • Experience
      • Education
      • Skills
        • Skills
        • Hard Skills
        • Soft Skills
    • Resume Objectives
  • CV
    • CV
    • CV Examples
    • CV Formats
    • CV Templates
    • How to Write a CV
  • Cover Letters
    • Cover Letters
    • Cover Letter Builder
    • Cover Letter Examples
      • Cover Letter Examples
      • Customer Service
      • Marketing
      • Sales
      • Education
      • Accounting
      • View All
    • Cover Letter Services
    • Cover Letter Templates
    • Cover Letter Formats
    • How to Write a Cover Letter
  • Questions
  • Resources
  • About
    • About
    • Reviews
  • Contact
  • jane
    • Settings
    • Help & Support
    • Sign Out
  • Sign In
Member Login
  • LiveCareer
  • Resume Search
  • Data Warehouse Manager
Please provide a type of job or location to search!
SEARCH

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
  • 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
  • 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
  • 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


Build Your Own Now

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:

51Fair
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

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

×

Advertisement

Similar Resumes

View All
Data-Warehouse-Manager-resume-sample

Data Warehouse Manager

Tiaa

Las Vegas , NV

Data-Warehouse-Developer-resume-sample

Data Warehouse Developer

22Nd Century Technologies

Oklahoma City , OK

Data-Warehouse-Engineer-resume-sample

Data Warehouse Engineer

Armanino Mckenna Certified Public Accountants & Consultants

Folsom , CA

  • About Us
  • Privacy Policy
  • Terms of Use
  • Sitemap
  • Work Here
  • Contact Us
  • FAQs
  • Accessibility
  • EN
  • UK
  • ES
  • FR
  • IT
  • DE
  • NL
  • PT
  • PL
customerservice@livecareer.com
800-652-8430 Mon- Fri 8am - 8pm CST
Sat 8am - 5pm CST, Sun 10am - 6pm CST
  • Stay in touch with us
Site jabber winner award

© 2022, Bold Limited. All rights reserved.