Data Warehouse Engineer Resume
3.00/5 (Submit Your Rating)
Baltimore, MD
SUMMARY
- Results - driven data warehousing specialist with extensive experience in manipulation and maintenance of unstructured data and technical operations within the world of healthcare.
- Strong analytical and diversified technical background in leading design, execution, and ongoing support of process improvement initiatives.
- Skilled in managing technical systems development and enabling reporting, analytics, and data sciences efforts across varying business units.
AREAS OF EXPERTISE
- Data Analysis
- Back-end Development
- Defect Management
- Quality Assurance Testing
- Data Flow Design
- Project Management
- Technical Documentation
- Data Warehousing Concepts
TECHNICAL SKILLS
- Informatica PowerCenter
- SQL (Oracle/MS SQL)
- VB.Net | MS Office (Advanced Excel)
- Unix | Python
- SAS | R
- Subversion (SVN)
- TIBCO
- LaTex
- MatLab
PROFESSIONAL EXPERIENCE
Confidential, Baltimore, MD
Data Warehouse Engineer
Responsibilities:
- Spearheaded the execution and implementation of internal data warehouse system improvements while partnering with engineering and business stakeholders to cultivate resolutions to design issues
- Took action with quality, performance, and maintainability to execute the roll out of mission critical warehousing project aimed to improve existing data processes and reduce run times
- Designed and implemented enhanced data flow utilized by over 100 management team members; integrated Informatica, SQL, and business transformation to eliminate unnecessary records and data defects and improve overall data quality
- Performed backend development coding and communicated with internal and external teams to understand data requirements
- Built solution design documents prior to the implementation of coding changes to identify issues prior to project execution and redesign solution
- Elected to lead status calls, monitor project issues, and track milestones to allow for communication of critical information to upper management regarding project status
- Recognized as team’s top contributor and was designated as a key project resource responsible for oversight of 5 associates; generated a reduction of daily system runtime by approx. 15%
Data Warehouse Technician
Confidential
Responsibilities:
- Tested code prior to production implementation using SQL scripts to ensure quality assurance and data integrity for 3 corporate initiative projects
- Overhauled corporate auditing GUl application with no prior VB.Net coding experience resulting in the resolution of 4 critical defects and 9 high status issues
- Utilized DevOps toolsets to collaborate with in-house DBA and operational support teams; integrated usage of Serena Business Manager workflow management system with Subversion source code management tool
- Analyzed relational and dimensional table structures and third-party files by using data dictionaries to identify potential issues prior to starting development coding work
- Ensured that more than 500 system users experienced zero down time while application improvements ensued
- Utilized the opportunity to learn new skills from the team and develop new technical competencies