Data Warehouse Architect Resume
2.00/5 (Submit Your Rating)
Jacksonville, FL
SUMMARY:
- Resolved business process issues to reduce cuts and cancels and increase efficiency and visibility in supply chain
- Partnered with third party logistic (3PL) and third party decoration (3PD) providers
- Widened range of Confidential documents supported for greater flexibility with business partners
- Developed roadmap for implementation of a new order management system and retirement of problematic legacy software
- Built application portfolio to help with privacy and compliance
- Researched and advised enterprise on privacy laws ( Confidential )
- Defined and instrumented business process events for domain design and analytics
- Implementation of new integration platform to connect our financial, order management, inventory, warehouse management and front end systems
- Model enterprise software engineering skills and lead architecture, design, automation, efforts across the enterprise
- Create and extend enterprise architecture standards
- Collaborate with business partners, developers, quality engineers, technology / operations leadership and peers to ensure common architecture and capabilities
- Collaborate with third - party vendors and internal teams to develop and keep current technology roadmaps
- Mentor development team members and proactively help resolve difficult technical issues
- Generate and maintain appropriate support documentation
- Learn and introduce new concepts and technologies
- Build prototypes with hands on development based on the project and team needs
- Act as subject matter expert on multiple enterprise domains
- Manage a team of FTE and Consultants
- Plan, assign and track work
- Set and measure team goals
- Review design and code of reports and peers
- Design integration platforms
- Design and develop canonical models for business events
- Design and develop APIs
- Provide after hours and weekend support
PROFESSIONAL EXPERIENCE:
Confidential, Jacksonville, FL
Data Warehouse Architect
Responsibilities:
- Manage five developers (Manager)
- Direct seven developers (Architect)
- Plan and review budgets, schedules and staffing
- Plan, assign and track work
- Set and measure department goals for the team
- Set and measure individual goals for professional development
- Review design and code of reports and peers
- Interact with business to clarify requirements and priorities
- Interact with other technical team members to establish requirements
- Improve efficiency of processes by process rework, query tuning, scheduling and index analysis
- Establish new steps in the software development lifecycle
- Analyze incoming data and source system to understand data structures, definitions, integration points and anomalies
- Organize lunch and learn sessions monthly for internal training
- Provide after hours and weekend support
Confidential, Jacksonville, FL
Database Administrator
Responsibilities:
- Analyzed the source systems within the enterprise to understand their data structure, definitions, integration points and anomalies
- Audited the instance and database information on a scheduled basis
- Designed, developed and maintained the physical and logical database models
- Developed and maintained coding standards, service level agreement, templates and checklists
- Directed team members on projects and assignments
- Interacted with customers as needed to better define and understand the data needs
- Interacted with other technical team members to establish requirements
- Mentored team members on business processes and knowledge as well as all aspects of SQL Server and the SQL Server BI Stack
- Provided 24x7 support on all database applications within the enterprise
- Researched and implemented new technologies and the use of existing technologies to improve efficiencies for database and integration applications within the enterprise
- Reviewed, documented and optimized the integration points between systems
- Reviewed database object and scripts for promotion