Michelle Potts
Jefferson City,Missouri
Summary
- 18+ years Data Warehouse and Business Intelligence Development (Inmon and Kimball Architectures)
- 18+ years Dimensional Data Modeling
- 25+ years Enterprise Data Modeling and Development
- 18+ years ETL Engineering and Development
- 18+ years Data Modeling for OLTP systems
- 25+ years Report Development and Modeling
- 24+ years Database Administration, Data Management and Architecture expertise
- 24+ years Business Analysis and Documentation
- 18+ years HTML Web Development Authorized to work in the US for any employer, no visa needed.
Overview
18
18
years of professional experience
Work History
Senior Data Warehouse Developer
Central Michigan University
06.2011 - Current
- Responsible for the development of the SAP BW/BI system to support SAP ECC system
- Responsible for development, monitoring, maintenance, and improvement of API and ETL Integration using Boomi, SSIS, Powershell, AWS, REST, GraphQL, and more
- Responsible for integration services from internal and external systems
- Aid in development of MS SQL Server databases and reporting interfaces
- Work with IT and university resources to gather business requirements and drive functional and technical designs for CMU’s data warehouse
- Be accountable for the overall design of the data warehouse (DW) environment
- Update standards including naming standards, cube design standards, security standards and design principles
- Provide technical governance of solutions and ensure that technical standards are met
- Translate user requirements into design specifications
- Ability to quickly understand complex technical and conceptual information; identify key issues, details, and present understandable alternatives to both technical and business audiences
- Validate programming, data modeling results and review with team and users for acceptance testing
- Create test case scenarios and conduct user acceptance testing sessions
- Design and deliver training materials, user training and provide technical support, as necessary
- Conduct jobs duties and responsibilities according to the organization’ business systems development and its SDLC methodology
- Act to champion BI benefits across the organization, promote BI usage to relevant departments and offices
- Works in conjunction with the systems support team, maintain, and support centralized database servers
- Prepares well-defined project statements and project timelines
- Assists with purchasing specifications for database development and integration hardware and software
- Analyzes present systems and procedures, recommends changes or improvements
- Performs related tasks as necessary.
Lead Data Architect
Missouri, Natural Resources
11.2008 - 06.2011
- Develop a data architecture that maximizes progress towards organizational objectives by providing actionable, integrated data and improve productivity through disciplined management of data;
- Define, document and maintain the data architecture through working with business analysts and through reverse engineering of existing data systems and uses;
- Develop Conceptual, Logical and Physical Data Models;
- Develop and apply database naming conventions and database standards of all Data Modelsthroughout organization;
- Facilitate and document business rules with respect to appropriate data and its usage;
- Ensure all data architecture and model components are properly integrated and implemented;
- Provide support and verify quality through all stages of implementation;
- Develop innovative ideas and lead others in the pragmatic business application of those ideas;
- Work closely with the Project Managers, Business Analysts, Database Administrators, Application Developers and QA to coordinate product and system releases, data structure evolution, capacity planning and forecasting;
- Play a key role in designing the transactional reporting infrastructure for various products and systems.
Business Intelligence Team Lead
Missouri Department of Natural Resources
11.2008 - 06.2011
- Months)
- Collaborate with Project Managers, Executives and Business Leads to define data management needs and set priorities;
- Define scope of each Data Warehouse release and establish project schedule based on scope;
- Work directly with Business Analysts and Subject Matter Experts to gather business user requirements;
- Lead Business Analysts and Subject Matter Experts in the translation of business user requirements into technical architecture vision and implementation plan;
- Build user friendly DB2 de-normalized dimensional model based on defined reporting requirements;
- Define ETL process based on dimensional data model and generate Extract Specification
- Develop data flow tasks that will populate the data warehouse and schedule jobs to run nightly;
- Lead Data Warehouse team in development and implementation of all documentation, ETL processes and quality assurance testing;
- Develop and distribute data mart specification and data dictionary for Data Warehouse;
- Supervise Data Warehouse Project;
- Administrate reporting solutions;
- Play key role in defining reporting methodology and implementing reporting architecture;
- Mentoring and developing ITSD staff in Dimensional Modeling and ETL processes;
- Train technical and business staff on using data warehouse and developing reports against the Data
- Warehouse and OLAP cubes;
- Design, develop, implement, and supervise data gathering techniques and standards;
- Design, develop, implement, and supervise data management techniques and standards;
- Design, develop and implement the Analytical OLAP Cubes for all data warehouse projects;
- Oversight of Data Warehouse software tool evaluation and selection;
- Hardware recommendations, sizing, and configuration;
- Oversight and/or coordination of system testing phase;
- Problem and issue resolution;
- Participation in proposal development and business presentations
- Develop Data Warehouse Disaster Recovery Plan
Business Intelligence Specialist
The Missouri Department of Mental Health
09.2006 - 11.2008
- Months)
- Develop, Maintain and Administrate Databases in Data Warehouse in SQL Server Environment
- Extract, Transform and Load Data Warehouse in SQL Server Environment
- Data Modeling and Architecture
- OLAP Cube Design and Maintenance
- SSIS Package Design and Maintenance
- Develop Stored Procedures, Functions, Views and Ad hoc Queries
- Develop Reports in SQL Server Reporting Services, Microsoft Access, Visual Studio, Strategy Companion Analyzer and various other software
- Database and Code Documentation
- Create Project Reports and Documentation
- Work closely with Business Users to troubleshoot problems with Data Warehouse
- Provide Training for Data Warehouse and other projects associated with Data Warehouse
- Backup and Restore Databases.
Skills
- NET
- Agile
- Analytics
- APIs
- AWS
- Azure
- Big data
- Business analysis
- Business intelligence
- Business requirements
- CI/CD
- Cloud infrastructure
- Communication skills
- Computer science
- Crystal Reports
- Data analytics
- Data collection
- Data management
- Data modeling
- Data science
- Data structures
- Data warehouse
- Database design
- Database development
- Databases
- DAX
- DB2
- Dell Boomi
- Design patterns
- Disaster recovery
- Distributed systems
- EDI
- Enterprise architecture
- ETL
- Forecasting
- Git
- HTML5
- Information management
- Inmon
- Java
- JavaScript
- Jira
- JSON
- Kanban
- Management
- Master data management
- MDX
- Metadata
- Microsoft Access
- Microsoft Report Builder
- Microsoft SQL Server
- Middleware
- MySQL
- NoSQL
- Oracle
- Performance tuning
- PL/SQL
- Postman
- Power BI
- PowerShell
- Project management
- Python
- Redshift
- Relational databases
- Requirements gathering
- Research
- REST
- Root cause analysis
- S3
- SAP
- SAP BusinessObjects
- SAP BW
- SAP BW 4HANA
- SAP ERP
- Scripting
- SDLC
- Server management
- SQL
- SQL Server Management Studio
- SSAS
- SSIS
- SSRS
- Statistics
- Supervising experience
- System testing
- Tableau
- Technical support
- Test automation
- Test cases
- T-SQL
- Unit Testing
- User acceptance testing
- Visual Studio
- Waterfall
- Windows
- XML
- Michelle Potts - page one
Timeline
Senior Data Warehouse Developer
Central Michigan University
06.2011 - Current
Lead Data Architect
Missouri, Natural Resources
11.2008 - 06.2011
Business Intelligence Team Lead
Missouri Department of Natural Resources
11.2008 - 06.2011
Business Intelligence Specialist
The Missouri Department of Mental Health
09.2006 - 11.2008