Data Engineering Machine Learning

Wendy Dorsey

Data Warehousing, Data Engineering, Data Quality, Data Governance, BI, ML/AI

************@*****.*** 770-***-**** https://www.linkedin.com/in/wendy-dorsey-42234b3

Summary

A dynamic and results-driven executive with nearly 30 years of experience in the IT data space, including 20 years in senior leadership roles. Currently Head of Data Analytics Practice with a global team of 85 employees at OSI Digital, Inc. Expert in large-scale Data Warehouses, Data Engineering, Enterprise Reporting (BI), and Machine Learning/AI projects. Renowned for industrializing centers of excellence, fostering data-driven cultures, and delivering comprehensive data management and analytics services with proper security.

Proven track record in strategic data analytics assessments, custom data warehousing platforms, data integration, data engineering, data governance, data literacy training, data visualization dashboards, and advanced enterprise performance management systems. Adept at developing robust data architecture plans, including master data management and Machine Learning/AI, to drive better decision-making, operational efficiency, revenue growth, and competitive advantage.

Recognized for effective and ethical leadership, promoting collaboration and trust among team members, clients, and stakeholders. Extensive consulting experience with large corporations, mastering diverse management methodologies, development styles, and implementation procedures. Skilled in end-to-end Agile project management, consistently delivering on time and within budget.

Hands-on experience across all aspects of data management and business intelligence, from database administration to data warehousing, data engineering ETL/ELT processes, and data solutions architecture to BI reporting and data analytics. Committed to data governance, ensuring data integrity, accuracy, reusability, and security, and establishing a single source of truth that enhances data quality and team capabilities.

Skills:, Strategic Thinking, Cross-functional Team Leadership, Team Management, Team Motivation, Business Initiatives, Customer Success, Client Development, Data Management, Contract Negotiation, Agile Delivery Methodologies, Business Strategy, Technical Project Delivery, Project Management, Foster Relationships, Statistical Data Analysis, Business Process Improvement, Manager Management, Operational Improvement, Request for Proposal (RFP), Requirements Gathering, Negotiation, Business-to-Business (B2B), Business-to-Consumer (B2C), Professional Services, Data Modeling, Data Management, Business Case Preparation, Compensation, Workload Prioritization, Project Estimation, Project Planning, Capacity Planning, Workload Prioritization, Multitasking, Cloud Applications, Consultative Approach, Requirements Analysis, Build Strong Relationships, Business Insights, Data Governance, KPI Dashboards, Database Development, Resource Management, Consulting, Thought Leadership, Account Management, Budgeting, Executive Management,, Workflow Applications, Data-driven Decision Making, Solutions Engineering, Software as a Service (SaaS), Tableau Desktop, Tableau Cloud, Power BI, DAX, Microsoft Fabric, Qlik Sense, Qlik Data Catalyst, Domo, Oracle, Oracle BI (OBIEE), Oracle BI Publisher, OBIA - Data Engineering with Informatica, Oracle EBS, NetSuite, Oracle CRM, Salesforce, Shopify, Oracle BRM, Oracle CCA, ODS, Google Cloud, AWS, Snowflake, Amazon Redshift, Azure SQL, Teradata, SQL Server, MySQL, NoSQL, WebLogic, Informatica, DAC, ODI, Talend, Boomi, Azure Data Factory, Hyperion/BI, SQR, Postgres, PeopleSoft, DB2/UDB, Siebel, Essbase, WebCenter, JavaScript, Visual Basic, Cold Fusion, Visio, ErWin, ER Studio, SharePoint, Nintex, ServiceNow, SaaS, SQL, KPI’s, APIs. IoT, Python, R, Microsoft Project, Azure DevOps, Jira, Confluence

Experience

Director of Data and Analytics Practice Head

OSI Digital, Inc. - Calabasas, CA, USA 02/2022 – 08/2024

Remote Director of Data & Analytics Practice Head of a global consulting firm that provides purpose-built business and technology solutions that optimize performance to enable data-driven outcomes and insights to Drive Better Business Outcomes for our customers in all industries.

-Led a cross-functional team of 85 architects, engineers, product managers, developers, designers, and testers to deliver a scalable data platform, improving operational efficiency to 98% and enhancing stakeholder and customer satisfaction with excellent communication and presentation skills.

-Creating and enhancing enterprise data warehousing, data integration, data engineering, data governance, data science, data visualization/BI, and Machine Learning/AI capabilities for our customers.

-Implemented successful cloud data warehouse solutions, including Snowflake, Amazon Redshift, Google BigQuery, Oracle, and Microsoft Azure, partnered with top ETL and BI tools.

-Provided overall leadership and management to the Data and Analytics global teams, setting professional services standards for Center of Excellence service delivery, ensuring service quality, client satisfaction, and revenue/cost projections were met.

-Conducted client assessments of Current State vs Future State roadmap services to bring digital transformation to businesses in all industries.

-Accelerate digital transformation by offering integrated solutions that capture, develop, secure, integrate, analyze, and optimize data.

-Involved in immediate troubleshooting platform and software issues while driving long-term modernization and applying best practices in SDLC CI/CD using Agile methodologies.

-Provide leadership in the design of client solutions and be responsible for delivery activities.

-Recommend change management to technology, policies, and procedures to establish standard procedures to improve operational efficiency and best practices.

-Implement robust security measures and compliance certifications to protect client data. This includes encryption, access controls, and compliance with GDPR, CCPA, and HIPAA regulations, ensuring that data remains secure and compliant.

-Negotiated and wrote contracts such as SOW, RFP, MSA, NDA, project charters, project plans, and budgets.

-Developed and managed training curriculum & webinars to advance skill sets and cross-train staff and clients to meet emerging technology for future business demands and needs.

-Establish and foster customer, vendor, and stakeholder relationships with excellent communication and presentation skills.

Director of Business Intelligence Solutions

iParametrics - Alpharetta, GA, USA 06/2019 – 01/2022

-Experienced leader-built team from the ground up and managed the BI Architect, BI Developers, Data Engineers, Data Scientists, Geo Engineers, QA Analysts, and Data Analysts team members and applications of advanced analytics, visualizations, machine learning, and AI techniques.

-Unlock business value through structured analytic work streams to client projects to provide guidance and strategic analytics to boost customer satisfaction and lower the cost and time for data and reporting needs.

-Executes leadership disciplines involving but not limited to project and task management, performance evaluation, goal setting, and staff supervision.

-Plan and manage department roadmaps, projects’ timelines, deliverables, resources, and budgets.

-Created and executed data governance and data acquiring process flow policies to industry standards and procedures.

-Establish and foster customer, vendor, and stakeholder relationships with excellent communication.

-Establish documented data governance policies, standard business rules, data cleansing, data transformations, data dictionaries, metadata, and data lineage.

-Responsible for website, AWS environments, AWS Security, all network domains, and servers.

-Project planning with Agile methodologies utilizing Azure Dev/Ops, Trello, and Microsoft Projects.

-Responsible for the creation of data model architecture, Business Intelligence (BI) development, ArcGIS, Machine Learning, LLM, and AI for Homeland Security, Department of Defense, Federal Government Grant Programs, and disaster recovery projects for FEMA throughout the USA.

-Responsible for data source review, data preparation, data cleansing, data mapping, ETL/ELT, REST APIs, and data architecture for relational and dimensional data modeling utilizing Qlik Sense Enterprise, Microsoft Power BI, DAX, and Qlik Data Catalyst along with the MySQL, Postgres and SQL Server databases on-premise, AWS and Azure SaaS cloud hybrid environments.

Senior Solutions Architect-Contractor

Cox Enterprises – Atlanta, GA, USA 07/2014 – 06/2019

-Significant experience with data architecture, developing and managing the implementation of Business Intelligence solutions to include OBIEE 11g and 12c, OBIA - Data Engineering with Informatica, ODI, Oracle BI Publisher, WebLogic, Tableau Desktop version 10.5, Tableau Prep, and Tableau Server, and APEX.

-My focus and specialty were the configuration and custom development of OBIEE and BI Applications (OBIA - Data Engineering with Informatica and ODI) for Financials, Procurement and Spend, Supply Chain, Project Management, Marketing, and Call Center Analytics, and Human Resources.

-Created new and customized existing ETL mappings in Informatica and ODI to load data into Oracle Data Warehouse/Financial Data Hub.

-Customized BI repository (RPD) to fit the customers' needs by adding new Facts, Dimensions, dimension hierarchies and level-based measures, data models, subject areas, variables, Usage Tracking, and security to include Single Sign On (SSO) from EBS.

-Responsible for custom OBIEE and Tableau development of BI visualizations, data model repositories, complex SQL queries, reports, and dashboards using sources such as Oracle EBS, Oracle Data Warehouse, Enterprise Data Warehouse, WebCenter, PeopleSoft or ODS.

-Involved in immediate troubleshooting platforms and software while driving long-term modernization and applying best practices in SDLC, CI/CD, and Agile methodologies and Dev/Ops.

-Working knowledge of WebLogic application installation, server administration, and monitoring.

CEO

Strategic Business Innovations – Marietta, GA, USA 01/2001 – 12/2015

The primary objective will be to ensure the success of the Technology Services business line, measured by revenue growth, pipeline health, and gross margin. As the single accountable owner for the business P&L, I worked to optimize supply and demand for the business and balance driving the top line while achieving operational efficiency. As the CEO and Owner of a consulting firm, it has allowed me to work with many amazing large corporations and learn different management methods, development styles, and implementation procedures. Which has allowed me to grow and develop my creative thinking skills. Provide guidance and strategic enterprise data and analytics to boost customer satisfaction and lower the cost and time for business objectives.

-Specializing in Data Warehousing, Data Engineering with Informatica ETL tools/architecture/data modeling in large environments with experience with BI Dashboard visualizations to include Business Intelligence tools.

-Configuration and custom development of OBIEE and BI Apps (OBIA - Data Engineering with Informatica ETL) for Financials, Procurement and Spend, Supply Chain, Project Management, Marketing, Call Center Analytics, and Human Resources.

-Created new and customized existing ETL mappings in Informatica to load data into the Data Warehouse with the proper data security.

-Customized BI repository to fit the customers' needs by adding new Facts, Dimensions, dimension hierarchies and level-based measures, data models, subject areas, variables, Usage Tracking, and data security to include Single Sign On (SSO).

-Responsible for custom OBIEE, Hyperion, and BI development of BI visualizations, data model repositories, complex SQL queries, JavaScript and reports and dashboards using sources such as Oracle EBS, Oracle Data Warehouse, Enterprise Data Warehouse, SQL Server, Teradata, DB2, WebCenter, PeopleSoft or ODS.

-Involved in immediate troubleshooting platforms and software while driving long-term modernization and applying best practices in SDLC and full life cycle development and maintenance support.

-Worked with client issue tracking ticket systems such as ServiceNow or Remedy.

-Expert knowledge of WebLogic application installation, server administration, and monitoring.

-I have a strong track record of bottom-line pricing, responsibility for project launch and initiatives through full life cycle development to maintenance of various architecture solutions, and always deliver on time and to key stakeholders’ and subject matter experts’ satisfaction.

-Using industry-standard AIM (Application Implementation Methodology) Documents, such as Business Requirements, Technical Requirements, and installation steps prepared by the programmer for the code migration for successfully managing implementation projects and delivering documentation such as Data Dictionaries and Data Linages.

-I have done all aspects of data analytics from creating data warehouses to ETL to Business Intelligence to Data Solutions Architect to Executive. Knowing all the working pieces of the whole picture to make better management decisions.

-Managed projects and development teams of large and small along the way depending on client needs.

-Work closely with clients to demonstrate functional and technical knowledge to ensure that the products and deliverables are of the highest caliber to ensure client satisfaction while keeping industry standards and best practices.

-Negotiated contracts such as SOW, MSA, NDA, Project Charters, and project plans and budgeting.

-Multiple contract renewals and repeat business from building customer relationships with such clients as Cox Enterprises, Cox Media Group, Cox Communications, UPS, Norfolk Southern, Verizon, Oldcastle APG, The Home Depot, Dell Technologies, and IBM.

Team Lead and Data Architect-Contractor / Cox Media Group - Atlanta, GA, USA 09/2011 - 11/2015

-Led configuration and custom development of OBIEE 11g and BI Applications (OBIA - Data Engineering with Informatica) for Financials, Procurement & Spend, Human Resources, and Revenue on Oracle Analytics Cloud Services (OACS).

-Executed leadership responsibilities including project and task management, performance evaluations, goal setting, and staff supervision.

-Customized and designed BI repositories (RPD) to align with customer requirements by adding new Facts, Dimensions, dimension hierarchies, level-based measures, data models, subject areas, variables, and Role and Row-based security.

-Designed and developed custom OBIEE repositories, reports, and dashboards leveraging Oracle Data Warehouse and Hyperion Essbase cube data sources.

-Implemented Usage Tracking to monitor and improve system usage and performance across BI applications.

Senior OBIEE Developer-Contractor / Cox Enterprises - Atlanta, GA, USA 07/2011 - 12/2011

-Served as Senior OBIEE/OBIApps Developer creating custom business intelligence solutions to enhance data insights and decision-making for Cox Enterprises.

-Configuration and custom development of OBIEE and BI Apps (OBIA - Data Engineering with Informatica ETL) for Financials, Procurement and Spend, Supply Chain, Project Management, and Human Resources.

-Created new and customized existing ETL mappings in Informatica to load data into the Data Warehouse with the proper data security.

-Developed advanced OBIEE reports and dashboards tailored to enterprise requirements, optimizing data visualization and accessibility.

-Customized and configured OBIEE repositories (RPD) to support complex data engineering ETL and data integration and reporting needs across multiple departments.

-Collaborated with cross-functional teams to implement best practices in data governance, security, and performance optimization.

-Executed comprehensive testing and troubleshooting of OBIEE applications to ensure high performance, data accuracy, and reliability.

Senior OBIEE Developer-Contractor / Cox Communications - Atlanta, GA, USA 11/2010 - 07/2011

-Designed and developed customized OBIEE dashboards and reports, enhancing data-driven insights for Cox Communications' business operations.

-Implemented and optimized OBIEE RPDs, ensuring data integrity and streamlined access across various organizational functions for Financials, Procurement and Spend, Supply Chain, Project Management, and Human Resources.

-Led data visualization efforts, transforming raw data into actionable insights for improved decision-making.

-Collaborated with IT and business stakeholders to align OBIEE solutions with strategic goals and operational requirements.

-Conducted performance tuning and troubleshooting to maximize OBIEE application efficiency and reliability.

Project Lead and Data Architect-Contractor / Chick-fil-A - Atlanta, GA, USA 08/2010 - 01/2011

-Led BI and data architecture projects, designing solutions that aligned with Chick-fil-A's business objectives.

-Architected data models and data engineering ETL processes to support reporting and analytics, enhancing data accuracy and usability.

-Managed cross-functional teams, ensuring seamless integration of data solutions with Chick-fil-A's enterprise systems.

-Configuration and custom development of OBIEE and BI Apps (OBIA - Data Engineering with Informatica ETL) for Financials, Procurement and Spend, Supply Chain, Project Management, and Human Resources.

-Created new and customized existing ETL mappings in Informatica to load data into the Data Warehouse with the proper data security.

-Developed custom OBIEE reports and dashboards, enabling data-driven insights across various departments.

-Oversaw data governance policies, implementing best practices for data quality, security, and compliance within the organization.

Senior OBIEE Developer-Contractor / Boar's Head Provisions - Sarasota, FL, USA 04/2010 - 08/2010

-Developed and optimized OBIEE dashboards and reports tailored to Boar's Head Provisions' operational needs, improving data accessibility and decision-making.

-Configuration and custom development of OBIEE and BI Apps (OBIA - Data Engineering with Informatica ETL) for Financials, Procurement and Spend, Supply Chain, Project Management, and Human Resources.

-Created new and customized existing ETL mappings in Informatica to load data into the Data Warehouse with the proper data security.

-Customized data models and data engineering ETL mappings to integrate multiple data sources, enhancing reporting accuracy and depth.

-Collaborated with stakeholders to define reporting requirements, ensuring data solutions aligned with business objectives.

-Implemented security protocols, including role-based and row-level security, to safeguard sensitive company information.

-Monitored and refined Oracle performance metrics, driving efficiency in reporting processes and reducing data latency.

Senior Manager of Business Intelligence / Verizon - Atlanta, GA, USA 02/2009 - 04/2010

-As the Senior Business Intelligence Manager for the entire data warehousing and BI team, I developed ETL, queries, reports, and dashboards using Oracle Business Intelligence Enterprise Edition (OBIEE).

-Executes project and team leadership disciplines involving but not limited to project and task management, performance evaluation, goal setting, task timelines, and staff supervision.

-Responsible for the installation, configuration, administration, and providing technical guidance regarding Oracle Business Intelligence Applications (OBIA data engineering with Informatica) such as Financials, Human Resources, Sales, Supply Chain, Marketing, and Call Center Analytics.

-Responsible for the Repository (RPD), Data Warehouse Console Administration (DAC), and Informatica in the Development and Production environments.

-Created and maintained all Informatica ETL from four different data sources (EBS, CRM, BRM, and CCA) into the Data Warehouse (OBAW) for OBIEE monitored and scheduled through DAC.

Senior Reporting Developer-Contractor / Cox Enterprises - Atlanta, GA, USA

01/2008 - 01/2009

Senior Hyperion Developer-Contractor / Oldcastle APG - Atlanta, GA, USA

11/2006 - 01/2009

Senior Manager of Reporting-Contractor / MediaWhiz - Roswell, GA, USA

11/2007 - 05/2008

Hyperion Intelligence Instructor-Contractor / Social Security Administration - Baltimore, MD, USA. 09/2006 - 12/2006

Team Lead and Senior BI Developer-Contractor / Norfolk Southern - Atlanta, GA, USA 01/2005 - 09/2006

Senior BI Developer-Contractor / The Home Depot - Atlanta, GA, USA

02/2004 - 01/2005

Senior BI Developer-Contractor / UPS - Atlanta, GA, USA

09/2003 - 02/2004

Senior BI Developer-Contractor / Norfolk Southern - Atlanta, GA, USA

01/2003 - 09/2003

Senior BI Developer-Contractor / IBM - Atlanta, GA, USA

07/2002 - 12/2002

Team Lead and Senior BI Developer-Contractor / Norfolk Southern - Atlanta, GA, USA 08/2001 - 07/2002

Senior Manager of Reporting Data Warehouse-Contractor / Cigna Healthcare - Hartford, CT, USA 10/2000 - 08/2001

BI Developer-Contractor / Dell Technologies - Round Rock, TX, USA

07/2000 - 10/2000

Team Lead and BI Developer-Contractor / UPS - Atlanta, GA, USA

04/1999 - 06/2000

Database Developer Contractor / Various Contracts

05/1997 - 04/1999

Education

University of Phoenix, Bachelors, Business Administration/Management

Certifications

Snowflake Sales Professional Accreditation, Snowflake Technical Sales Professional Accreditation

Qlik Sense Business Analyst Certification

References

Jagadeesh Malina Practice Manager at OSI Digital, Inc.

I got the opportunity to work under Wendy, and it has been an incredible experience. She's a fantastic leader and has a very cheerful personality. She always inspires & guides the team and sets a positive ecosystem within the team. One thing that really stands out about Wendy is her exceptional ability to solve complex problems and she has been the absolute favor of customers. Wendy always pays great attention to detail, making sure every project is thoroughly planned and executed. Her strategic insights and proactive approach have helped us identify and seize new opportunities time and again. Working with her has been a privilege. Overall, I highly recommend Wendy for her exceptional leadership, problem solving skills and a commitment to excellence.

Muthulakshmi Muthusamy Sr.Tableau Developer at OSI Digital, Inc.

I have had the pleasure of working with Wendy at OSI, and I can confidently say that she is an exceptional leader and a remarkable professional. Her expertise in leadership, data warehousing, data engineering, machine learning (ML), and artificial intelligence (AI) is unparalleled. Wendy's leadership skills are truly inspiring. She has a unique ability to motivate and guide our team towards achieving our goals, always maintaining a positive and encouraging attitude. Her deep knowledge and experience in data warehousing and data engineering have significantly contributed to the success of our projects, ensuring that our data infrastructure is robust and efficient. Moreover, Wendy's proficiency in ML and AI is impressive. She has a keen eye for innovative solutions and has implemented cutting-edge technologies that have propelled our team forward. Her insights and strategic thinking in these areas have been invaluable. Wendy's positivity and motivational approach create an empowering work environment, fostering collaboration and high performance. She is not just a Director but a true leader who leads by example and brings out the best in everyone around her. I highly recommend Wendy for any leadership role, especially where expertise in data warehousing, data engineering, ML, and AI are essential. She is an asset to any team, and I am grateful to have had the opportunity to work with her.

Micah Kirkpatrick Director of Data Science at iParametrics

Wendy's excellent task management and experience was essential to critical project delivery capabilities. Her management abilities and leadership shine through her project planning and she is an amazing mentor to junior colleagues. She works very well with many different types of people and is incredibly technically and administratively competent. She doesn't shy away from difficult projects and takes the necessary effort and time to ensure plans are executed efficiently and on time. Any organization would be lucky to have her.

Dan Murphy Director, Business Intelligence at Cox Enterprises

Wendy has worked with my team at Cox Enterprises on a number of different projects. Wendy has always been professional, capable, and great at working collaboratively with any team she has been a part of. Wendy has a strong mix of business functional understanding, especially in finance, and technical capabilities. This is critical when working directly with business customers and IT partners. Wendy's skills with OBIEE and the Oracle BI Apps go above and beyond most people you can find in the marketplace. She has in-depth knowledge of Oracle EBS tables, strong SQL skills, the ability to create data models both in a database and Oracle BI (RPD), and she has strong OBIEE Reporting skills. Best of all, Wendy is focused on delivering solutions that exceed customer expectations.

Contact this candidate