SEARCH

Sr. Data Warehouse Consultant Resume Example

Resume Score: 90%

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 CurrentOppenheimerFunds, IncDenver, CO
  • 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 ColoradoDenver, CO
  • 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 ColoradoDenver/Harrisburg, CO/PA
  • 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 MichiganLansing, MI
  • 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 anyfunctional 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 TexasDenton, TX
  • 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 TexasDenton, TX
Bachelor of Technology: Computer ScienceJawaharlal Nehru Technological University Hyderabad, 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.

Resume Overview

Companies Worked For:

  • OppenheimerFunds, Inc
  • Deloitte/State of Colorado
  • Deloitte/State of Michigan
  • Center for Media Production, Univ. of North Texas

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

Similar Resumes

View All
Data-Warehouse-Manager-resume-sample

Data Warehouse Manager

NYC Department of Health and Mental Hygiene (DOHMH)

Monmouth Junction, New Jersey