close
  • 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
  • Sr. Data Warehouse Consultant
Please provide a type of job or location to search!
SEARCH

Sr. Data Warehouse Consultant Resume Example

Love this resume?Build Your Own Now
SR. DATA WAREHOUSE CONSULTANT
Profile

Senior Software Consultant with 9+ years in analysis, design, development, testing and implementation of various web-based applications, data conversion, business intelligence and analytics solutions.


5+ years of experience in Health and Human Services (HHS) industry including Integrated eligibility systems with knowledge of the Case Management, Eligibility and Benefit Issuance and Recovery modules.


2 years of experience in design and development of automated Child Care solution with real time attendance tracking using POS devices


Expertise in implementation of data warehousing, business intelligence and analytics solutions using technologies like Oracle, Cognos and Hyperion Essbase

Core Qualifications
  • Technical and Solution Architecting
  • Data warehousing and analytics
  • Data Conversion and Integration
  • Data Architecture
  • Interface design and implementation
  • N-tier application design and development
  • Project management
  • Agile development methodologies
  • Requirements gathering, analysis and design
Technical Skills
  • Data Integration: Informatica, SQL Server Integration Services
  • Reporting & Analytics: Cognos, Oracle Essbase, SmartView
  • Programming Languages: Java, C, C++, JavaScript, SQL, PL/SQL
  • JEE & Web Technologies: Struts 2, Hibernate, HTML, XML, JQuery, JSON
  • Application Servers: WebSphere, WebLogic
  • Web Services: SOAP, WSDL, RESTful
  • Databases: Oracle, MySQL, SQL Server
  • SCM & Build Tools: Subversion, ClearCase, Harvest, Ant
  • Issue Tracking Tools: JIRA, ClearQuest
  • Operating Systems: Windows, Linux

Professional Experience
Sr. Data Warehouse Consultant01/2013 to Current1-800-Flowers.Com, Inc.TN, State
  • Worked with Finance users to draft user stories, use cases and functional specifications to support Finance Reporting and Analytics environment
  • Led the design and development of Essbase software upgrades and the deployment of new services and products
  • Managed the technical enhancements project aimed at enhancing and stabilizing the reporting and analytics environment
  • Designed and implemented Finance Data Mart and reporting framework
  • Developed and managed project plans while providing status updates to management.
  • Ran focus groups, surveys with users in collaboration with the Enterprise Architecture group.
  • Conducted end user training for new Essbase products
  • Worked closely with QA to develop use cases, review test cases and track feature bugs.
  • Hired and managed 3 software consultants
Deputy Team Lead, CBMS Web07/2011 to 12/2012Deloitte/State Of ColoradoCity , STATE
  • Developed business requirements specifications, system requirements specifications, and system design documents for CBMS web IDE
  • Led design and implementation of various change requests
  • Design the screen mock-ups based on the gathered business requirements
  • Design security framework for the new web based screens which includes security at screen, tab, page and field levels.
  • Integrating the new web-based screens with the middle-tier and data layer of the existing system and testing the end-to-end functionality of the screens.
  • Involved in Quality assurance process which includes code review and promotion.
Data Conversion Manager, CHATS08/2009 to 06/2011Deloitte/State Of ColoradoCity , STATE
  • Interacted with business representatives for requirement gathering and to define business and functional specifications for conversion and Financial Administration modules.
  • Managed Data Conversion which includes conversion planning, creating technical specifications from functional requirements, code reviews, resource allocation, and mentoring of other team members.
  • Subsequently took on the role of Financial Administration team lead, and led various change requests for payment issuance and POS integration.
  • Involved in automation of payroll process and interfacing with third party POS system.
  • Design of conversion mapping documents for automated conversion and gap analysis documents for manual conversion.
  • Worked actively with the client to define the source data extraction strategy and file structure.
  • Managed 6 resources across conversion and financial administration teams
Conversion Technical lead, BRIDGES05/2006 to 07/2009Deloitte/State Of MichiganCity , STATE
  • Involved in requirement gathering and high level design of conversion process from legacy systems to new system.
  • Involved in documenting the system design using story boards, UML activity diagrams, sequence diagrams and use case diagrams and data mapping documents.
  • Functioned as the primary liaison between the business and the technical teams and resolved any functional issues for the technical team.
  • Responsible for technical analysis of data movement, element mappings, formats, data types and development of data movement programs with Informatica Power Center toolset.
  • Analyzed data flow requirements and developed a scalable architecture for staging, transforming and loading data. Translated business rules and functional requirements into ETL procedures.
  • Developed Web based screens to collect applicant's data using JSP, Servlets and EJB and the custom application framework
  • Designed and developed decision tables to implement conversion of income business rules using custom Rules Engine.
Web Developer01/2004 to 05/2005Center For Media Production, Univ. Of North TexasCity , STATE
  • Defined specifications through class diagrams, behavior diagrams (sequence, collaboration)
  • Developed java applications in MVC framework using Struts.
  • Developed JSP pages for presentation of data and to perform validations at Client's side.
  • Documented Unit test case scenarios and performed unit testing of code
Education
Master of Science: Computer ScienceUniversity of North TexasCity, State
Bachelor of Technology: Computer ScienceJawaharlal Nehru Technological UniversityCity, India
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:

72Average
Resume Strength
  • Completeness
  • Formatting
  • Word choice
  • Measurable results
  • Strong summary
  • Clear contact info
  • Typos

Resume Overview

School Attended

  • University of North Texas
  • Jawaharlal Nehru Technological University

Job Titles Held:

  • Sr. Data Warehouse Consultant
  • Deputy Team Lead, CBMS Web
  • Data Conversion Manager, CHATS
  • Conversion Technical lead, BRIDGES
  • Web Developer

Degrees

  • Master of Science : Computer Science
    Bachelor of Technology : Computer Science

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

×

Advertisement

Similar Resumes

View All
Sr.-Application-Developer-/Data-Warehouse-Developer-resume-sample

Sr. Application Developer /Data Warehouse Developer

Bemis Associates, Inc.

City , STATE

Data-Warehouse-Manager-resume-sample

Data Warehouse Manager

Tiaa

Durham , NC

Data-warehouse-Specialist-resume-sample

Data warehouse Specialist

Guide One Insurance

Nashville , TN

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