Project Manager Data Management

Jeffrey R. Powell

*******@***-************.*** 916-***-**** Linkedin.com/in/jeff-powell-8a4194 Experienced data and information management professional, provides solutions in Enterprise Big Data Architecture, Cloud Strategy and Operations, Master Data Management, Data Governance, Business Intelligence and Analytics. He enables technology solutions for complex business problems using innovative strategy, process optimization and proven execution methodology.

Leveraging strong interpersonal skills to elicit requirements and document requirements that address business problems through facilitated workshops and interviews. Analytic skills are used to design and develop solutions that solve business problems. Job satisfaction derived from solving problems.

Utilizes his understanding of the business to effectively function as a liaison between all levels within the business and IT.

Domain expertise spans Retail, Insurance, Manufacturing, Public Sector, Consumer goods, Retail, Public Utilities and Energy industries.

Within the database realm experienced in conceptual, logical and physical modeling. Extensive experience in Relational Database modeling for OLTP and OLAP solutions. For Data Warehousing solutions utilizing Star, Snowflake and Tabular model schemas. SUMMARY

Served as Business Analyst providing functional retail expertise to team developing new functionality to improve item return processes and as a product owner within the Agile development process.

Performed a Tool Evaluation for a Reporting, Visualization, and analytic tool for Neiman Marcus Group. Defining Business Requirements, Creating an RFP, evaluating RFP responses, conducting vendor demonstrations, and recommending solution. Prepared a Data Management Strategy for the California High Speed Rail authority and an implementation roadmap.

Managed a team of Data Modelers and Architects directing all of the efforts to architect and design the Data lake (AWS S3) and Data Warehouse (AWS Redshift) for PHEAA one of the largest Student Loan servicing organizations in the US. Defined and implemented a large data warehouse project for a major electronic retailer that brought together data from more than 16 disparate systems into a single business information system designed to be the platform from which to drive all customer analytics and from which to drive targeted marketing. In a call with Wall Street analysts this project was touted as the key to the company’s future. On this project managed the technical development of customer analytics at Best Buy with focus on integrating infrastructure, applications, data and consulting capabilities.

Defined and implemented a large data warehouse project for Best Buy that brought together data from more than 24 disparate systems into a single business information system for services and protection plan data that allowed the company to save more than $13 million in the first year.

Focused on analytics and optimization at several major retailers across the US. Enjoys implementing technology solutions by focusing on customer’s business issues and challenges while driving innovation and providing thought leadership. Extensive experience in Business Analysis, Project Management, Pre Sales, Support and Negotiation. Works effectively with cross-functional teams, managing budgets and delivering projects on time.

Effectively sell ideas to all levels within the organization. Being a Change Agent at several companies he has developed the skills of being very adaptable to change and in building excitement and support for the changes, as well as assisting in the transition process through training and resolving issues.

Functioned in various Agile roles including Product Owner, Scrum Master, and Team Member

(Developer) utilizing JIRA and Confluence.

Develop Data Governance strategy that included Data Governance, Data Architecture, Data Quality, Data Classification, Backup, Recovery, and Retention, Integration of Data Classification with Data Access, Data Security, Data Warehousing, Reporting and Analytics. Work with business stakeholders to define requirements for data warehouse and enterprise business information systems. Strong data modeling, reporting, and ETL experience in a variety of environments.

Manage all aspects of analysis, design, development, installation, testing, implementation and post-implementation reviews.

Project Management including:

• Provide recommendations and direction to the IT Development teams

• Provide direction on technical content for training materials

• Communicate and coordinate project activities with business, technical and IT service organizations ( e.g., project schedules/status)

• Assess projects and identify essential tasks; reprioritize tasks dynamically during the project; perform risk assessments; identify and evaluate alternatives

• Ensure that design, development and implementation phases are consistent with approved standards and methodologies

• Manage direct or indirect project staff assigned to project as needed

• Negotiate and persuade other groups with diverse perspectives to gain cooperation and achieve customer objectives.

• Manage teams of developers and analysts to successfully complete projects on time and within budget.

Participated in a major Business Process Re-Engineering project at a large Food and Drug retailer that transformed American Stores from a holding company to an operating company with 7 operating divisions to centralized procurement, supply chain, WMS and Information Technology. This process included defining core business competencies, new business processes, defining the systems requirements necessary to support the new processes, Make/Buy decisions, RFI/RFP process, development of custom software, implementation and integration of purchased software, Testing and Implementation. SYSTEM SKILLS- PROCESSES

• System Development

Lifecycle

• Structured Methodologies

• Agile /SAFe Agile

• Structured Analysis &

Design

• Data Architecture

• Data Governance

• Process Modeling

• JAD/RAD/FAST

• Use Case

• Data Warehouse

• Lean

• Agile Scrum Master

• Data Analytics

• MDM Master Data

• Data Analysis & Modeling

• Quality Assurance &

Testing

• Requirement

Management

• Integration/ETL

• Reporting & Visualization

• Meta Data Management

SOFT SKILLS

• Consulting • Pre Sales • Leadership

• Facilitation • Negotiation • Budget Management

• Managing for Inspired

Performance

• Communications • Relationship

Management

SYSTEM SKILLS- ERP & Off the Shelf

• AWS Amazon Web Services

• PeopleSoft Human

Resources

• Oracle RMS, RPAS

• Azure

• PeopleSoft Benefits

• PRJ Retail

Information System

• SAP Retail

• PeopleSoft Payroll

• IBS Softsolutions

• JDA Category

Management

SYSTEM SKILLS- Databases

• AWS S3 and Redshift

• Azure Data Storage

• Oracle DBMS

• DB2

• Netezza

• Microsoft Access

• Teradata

• Microsoft SQL Server

• IMS

SYSTEM SKILLS- Reporting & Analytics

• Tableau

• Microstrategy

• QMF

• Unix including Scripting

• SAS

• Cognos

• Incorta

• Azure Power BI

• Crystal Reporting

• ESSBASE

SYSTEM SKILLS- Tools

• SQL

• ERWIN/Power Designer/ER

Studio

• Unix including Scripting

• JIRA

• Rational Requisite

Pro

• Informatica

• Confluence

• Microsoft Project

• FIGMA

• PeopleTools (SQR/SQC)

PROFESSIONAL EXPERIENCE

Cognizant, North Ogden, UT

10/2021– 5/2023 Consulting Manager – BI Solutions

• Served as both Business Analyst and Agile Product Owner responsible for Macys’ Data Collect Repository which houses both Financial and Non-Financial transactions and processes data into several downstream systems including Financial, Clientele, and various Reporting and Analytics. This included writing user stories that captured functional requirements and providing additional detail as needed for the development and testing teams to successfully complete the stories.

• Served as SCRUM master leading daily standups and writing user stories for Ace Hardware UX/UI development work and participating in grooming and planning ceremonies.

• Performed a Tool Evaluation for a Reporting, Visualization, and analytic tool for Neiman Marcus Group. Defining Business Requirements, Creating an RFP, evaluating RFP responses, conducting vendor demonstrations, and recommending solution.

• Led a team preparing and implementing a Data Management Plan for Albertsons focusing on inbound and outbound data and the responsibilities of the Data Governance team. Capio Group, Sacramento, CA

6/2020– 7/2021 Lead Consultant – Data Management

• Led a team preparing and implementing a Data Management Strategy for the California High Speed Rail authority. Proposing the Data Management plan and explaining why each component was important and the value each brings to an organization. Evaluated tools to meet the various needs of Data Management including Data Governance, Data Architecture, Data Quality, Data Classification, Backup, Recovery, and Retention, Integration of Data Classification with Data Access, Data Security, Data Warehousing, Reporting and Analytics. Wipro Technology, Bay Area, CA

02/2015– 1/2020 Lead Consultant – BI Solutions Architect

• Worked with Incorta as WIPRO partnered on value add sales giving demos of the Incorta product. Utilized Incorta a data delivery platform for creating visualizations.

• Business Warehouse Data Architect for one of the largest Student Loan Servicing organizations. Architecting the BI environment as Data Warehouse is migrated to the cloud. This includes creating a BI Reference design that included S3, AWS, Redshift, semantic layer, canonical and data fabric to accommodate reporting and analytic needs for both structured and unstructured data.

• Data Architect and Data Modeler for Large Electric Utility in support of Business Information solution to meet reporting, scorecard and dashboard requirements. Designed to allow a high degree of self service in meeting Ad Hoc reporting and analytic requirements. Providing an understanding of requirements, data profiling, solutioning as well as direction to the development teams. Utilized Tableau for creating visualizations and reports.

• Business Analyst for the Marketing and Customer Insights team within the Marketing organization of Best Buy. The project objectives are to capture and use Audience data, predictive models, marketing campaign data and campaign response data across all vehicles, transactional activity including sales in all channels, brose and click data. This data is used to randomly identify customers for control holdout groups that are representative of the customer universe. Analyze and tune audience selection and model improvement to accomplish specific objectives. This program integrates the Product, Customer and Customer Touchpoint dimensions, Statistical Models and the available fact

(Sales, Adobe Clickstream, Demographic, Abandoned Cart, etc.) information in a Netezza database using SAS to perform statistical modeling functions. The objectives of this project are to perform the following types of optimizations and analysis; Model Tuning, Audience Tuning, Marketing Effectiveness analysis at the Campaign level, Marketing Effectiveness analysis at the Audience level, Content Optimization for Placement/Location, Content Optimization for Personalization, Content Optimization for Creative Elements, Vehicle Optimization, Timing Optimization Deliver/Open, Timing Optimization Time Zone, Augmentation Analysis for recent transactional activity, Contact Optimization, Item Effectiveness Analysis, Promotional Offering Effectiveness Analysis.

• Solutions Architect for Customer Analytic Master program implementing an analytic platform for Best Buy that enables analytics across more than 150 million customers that supports campaign management, as well as advanced analytics and predictive modeling. This program integrates the Location, Product, Location, Customer and Customer Touchpoint dimensions and the available fact (Sales, Adobe Clickstream, Demographic, etc.) information in a Netezza database using the Aginity CIA data model. Utilized Tableau for reporting and visualizations on Customer Analytics.

• Project Manager for Customer Analytic Master program implementing an analytic platform for Best Buy that will allow analytics across millions of customers that will support campaign management, as well as advanced analytics and predictive modeling. Method360, Sacramento, CA

10/2014– 1/2015 Project Manager

• Managing 4 major projects for Raley’s a regional grocery chain. The projects managed were:

o Digital Document Imaging in which we were bringing document Images in through ASG Koufax and making them available through SAP

o BPC which is the budgeting and Planning plug in for SAP which needed to be implemented and integrated with SAP ERP and the Business Warehouse o Plant Maintenance which involves services in Stores including repairs, remodels, preventive maintenance, and Refrigerant usage. Which needed to be implemented and integrated into SAP and Time and Attendance.

o BW which is the SAP Business Warehouse or data warehouse which needed to be migrated from classic to HANA implementation as well as migrating reports from legacy environment into the SAP Business Warehouse. Wipro Technology, Minneapolis, MN

05/2010– 10/2014 Lead Consultant – Data Warehouse Solution Architect

• Solutions Architect for Customer Analytic Master program implementing an analytic platform for Best Buy that will enable analytics across millions of customers that will support campaign management, as well as advanced analytics and predictive modeling. This program integrates the Location, Product, Location, Customer and Customer Touchpoint dimensions and the available fact information in a Netezza database using the Aginity CIA data model.

• Project Manager for Customer Analytic Master program implementing an analytic platform for Best Buy that will allow analytics across millions of customers that will support campaign management, as well as advanced analytics and predictive modeling.

• Defining Business and Functional Requirements for TJX using Interviews and facilitated workshops for RPAS Analytics.

• Conducted a Proof of Concept with Nike using SAS Mark Down Optimization for their US retail operations.

• Created an Enterprise Business Information and Information Governance strategy for Petco.

• Assisted Best Buy in defining their Business Requirements and writing specifications for data to be migrated to the enterprise data warehouse and reports to meet business analytic and reporting needs.

• Managed a team of 15 people spread between two continents.

• Designed, gathered and created requirements for Service Analytics projects.

• Worked with the development team to create data models and design specifications. EDUCATION

Pepperdine University, Malibu, CA, BS Natural Science Pepperdine University Graduate School, Malibu, CA, Standard Teaching Credential CERTIFICATIONS

Microsoft Azure Fundamentals Issued 05/2023 #2A4A99-CAW36E Microsoft Azure Data Fundamentals Issued 06/2023 #26F473-LC4418

Contact this candidate