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 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
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
- 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
Similar Resumes
