Wendy Dorsey

Remote Competency Head and Director Of Data & Analytics Practice of a consulting firm which 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

• Manage and develop team of 85 employees globally for enterprise data warehousing, data integration, data engineering, data governance, data science, data visualization/BI and Machine Learning/AI
• Choosing the right cloud data warehouse involves understanding the pros and cons of each option popular cloud data warehouse solutions, with dozens of success stories of implementation including Snowflake, Amazon Redshift, Google BigQuery, Oracle and Microsoft Azure partnered with the top ETL tools such as dbt, Talend, Informatica, ODI, Azure Data Factory with top BI tools such as Tableau, Power BI, Qlik Sense, Looker, Domo, Machine Learning, LLM, NLP, and GenAI
• Conducting assessments of Current State vs Future State roadmapping services to bring digital transformation to your business
• Accelerate digital transformation by offering integrated solutions that capture, develop, secure, integrate, analyze and optimize data
• Supports pre-sales activities to grow OSI’s business, provide leadership in the design of customer solutions, responsible for delivery activities, manage practice resources and foster their professional growth, maintain customer and vendor relationships
• Implement robust security measures and compliance certifications to protect data
• This includes encryption, access controls, and compliance with regulations such as GDPR, CCPA and HIPAA, ensuring that data remains secure and compliant
• Negotiated contracts such as SOW, RFP, MSA, NDA, Project Charters and estimated project plans and budgeting
• Provide overall leadership and management to the Data and Analytics global teams and set professional services standards for Center of Excellence service delivery
• Assess and monitor the Agile Delivery work provided to clients from initiation to delivery to ensure service quality, client satisfaction and revenue/cost projections are met
• Involved in immediate troubleshooting platforms while driving long-term modernization and applying best practices in SDLC, CI/CD and Agile methodologies
• Provide guidance and leadership regarding staff development and career paths
• Develop or manage training curriculum & webinars to advance skill sets and cross-train staff and customers to meet emerging and future business demands and needs
• Oversee and conduct regular quarterly and yearly performance reviews
• Resource and project forecasting for sales and hiring
• Recommend change management to policies and/or establish standard procedures to improve operational efficiency and best practices
• Work with other executives for cross functional calibration and project deliveries
• Establish and foster customer, vendor, and stakeholder relationships with excellent communication and presentation skills.
• Developed high-performing teams by providing mentorship, guidance, and opportunities for professional growth.
• Enhanced team collaboration through regular communication, goal setting, and performance evaluations.
• Established a culture of continuous improvement by fostering open communication channels and empowering employees to voice their ideas.
• Managed budgets effectively to ensure optimal use of resources while maintaining financial stability.
• Implemented innovative solutions to solve complex problems, resulting in increased productivity and streamlined operations.
• Improved project efficiency with strategic planning, resource allocation, and time management practices.
• Transformed organizational culture to embrace continuous improvement, leading by example and mentoring teams.
• Led cross-functional teams to exceed benchmarks for SLA delivery, staying on top of challenging schedules with multiple competing timelines.
• Cultivated and strengthened lasting client relationships using strong issue resolution and dynamic communication skills.
• Negotiated price and service with customers and vendors to decrease expenses and increase profit.
• Reduced financial inconsistencies while assessing and verifying billing invoices and expense reports.
• Proactively identified potential risks and implemented mitigation strategies to minimize negative impacts on projects or business operations.
• Improved team morale and productivity by implementing comprehensive professional development program.
• Achieved remarkable turnaround of underperforming divisions through strategic leadership and restructuring.
• Increased company revenue by streamlining processes and implementing cost-saving measures.
• Pioneered adoption of sustainable practices, leading to industry recognition and awards.
• Fostered culture of innovation, encouraging development of cutting-edge solutions.
• Spearheaded successful product launches that resulted in increased brand visibility and customer acquisition.
• Tracked trends and suggested enhancements to both challenge and refine company's product offerings.
• Secured key partnerships that contributed to the company''s overall growth strategy and market reach.
• Observed each employee's individual strengths and initiated mentoring program to improve areas of weakness.
• Cultivated a positive work environment that fostered employee engagement, increased retention rates, and boosted overall team morale.

• Built team from 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 budget
• Created and executed data governance and data acquiring process flow policies to industry standards and procedures
• 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 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 API's, 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.
• Spearheaded the implementation of a scalable business intelligence infrastructure, supporting rapid company growth and expansion.
• Championed the adoption of agile project management principles within the Business Intelligence function leading to improved efficiencies in project delivery and resource allocation.
• Designed and developed data pipelines to acquire, clean and process data.
• Developed data mining algorithms to identify and classify patterns in data.
• Developed and implemented data governance policies and procedures.
• Developed and maintained data warehouses and data marts to support business operations.

• 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 and Human Resources
• Created new and customized existing ETL mappings in Informatica or 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.
• Developed comprehensive documentation for technical specifications, project plans, and user guides, streamlining communication across teams.
• Evaluated emerging technologies to stay current on industry trends, making informed decisions for technology adoption.
• Broke down technical ideas and issues into non-technical terms for business executives.
• Promoted collaboration between cross-functional teams by serving as a liaison between developers, product managers, and stakeholders during all phases of projects.
• Reduced time-to-market by automating deployment processes using CI/CD pipelines.
• Bridged gaps in legacy systems with modernized solutions that increased overall efficiency while maintaining compatibility with existing workflows.
• Championed a culture of continuous improvement by conducting code reviews and providing constructive feedback to peers.
• Managed project timelines effectively while juggling multiple priorities, consistently meeting deadlines without compromising quality.
• Contributed heavily to product development lifecycle of both back-end and customer-facing solutions.
• Managed project scope, schedule, status and documentation.
• Supervised deployments and provided troubleshooting and user support.
• Worked with customers or prospective customers to develop integrated solutions and lead detailed architectural dialogues to facilitate delivery of comprehensive solution.
• Guided and influenced existing partners on recommended upgrades and enhancements to integrated solutions.
• Managed multiple projects simultaneously while maintaining strict adherence to deadlines and budgets.
• Established long-term relationships with clients, resulting in increased repeat business.

• 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
• Most companies hire me to 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 and Human Resources
• Created new and customized existing ETL mappings in Informatica to load data into 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
• By using industry standard AIM (Application Implementation Methodology) Documents, such as Business Requirements, Technical Requirements and installation steps prepared by programmer for the code migration for managing implementation projects successfully and delivering of documentation such as Data Dictionaries and Data Lineages
• I have done all aspects of data analytics from creating data warehouses to ETL to Business Intelligence to Data Solutions Architect to Executive
• Having the knowledge of all the working pieces of 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 estimated 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.
• Achieved company growth by implementing strategic plans and streamlining operations.
• Managed partnerships and strategic business relationships by negotiating contract terms and handling conflicts.
• Cultivated forward-thinking, inclusive, and performance-oriented business culture to lead industry in innovation and push progress.
• Led successful turnaround efforts for underperforming divisions or subsidiaries, restoring profitability within tight timeframes.
• Secured advantageous partnerships and collaborations to co-develop cutting-edge technologies and solutions.
• Fostered culture of continuous improvement, encouraging innovation and rewarding exceptional performance.

• 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.
• Promoted a positive work environment by fostering teamwork, open communication, and employee recognition initiatives.
• Served as a role model for the team by demonstrating commitment to excellence, professionalism, and adherence to company values at all times.
• Coached team members in techniques necessary to complete job tasks.
• Enhanced overall team performance by providing regular coaching, feedback, and skill development opportunities.
• Collaborated with other department leads to streamline workflows, improve interdepartmental coordination, and achieve business goals collectively.
• Influenced positive change within the organization through strategic thinking, innovation, problem-solving abilities, and consistent leadership style.
• Led cross-functional teams for successful project execution while maintaining strong collaboration among team members.
• Helped meet changing demands by recommending improvements to business systems or procedures.
• Incorporated cloud architecture into new facility planning, reducing need for on-site equipment and technical support personnel.
• Led successful database conversion projects that resulted in significant improvements in processing speed without compromising on accuracy or integrity.
• Optimized resource allocation by analyzing system utilization patterns and recommending infrastructure adjustments accordingly.
• Standardized metadata management across systems for improved consistency in reporting and analytics.
• Evaluated emerging technologies to maintain cutting-edge knowledge in the field of Data Architecture.
• Designed and maintained comprehensive system documentation for easy reference by internal teams, ensuring smooth knowledge transfer during staff transitions.
• Spearheaded cloud migration initiatives for enhanced scalability, security, and cost-efficiency in managing vast amounts of enterprise data assets.
• Identified opportunities for process improvement through regular monitoring of system performance metrics, driving continuous optimization efforts.

- Served as Senior OBIEE 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 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.

• 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
• 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.

• 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 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.

• 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 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.

• 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.