SUMMARY:

• Well - versed in administering all facets of a project’s lifecycle, from initiation and planning through to monitoring and closure. This is inclusive of SDLC and Agile methodologies.
• Strong Communicator: Adept at building strong bridges of understanding between product owners, technical developers, stakeholders and non-technical end-users.
• Excellent Business Analyst: Proficient at data gathering, cost/benefit and root cause analysis, business case development and data modeling.
• Skilled Data Manager: Accomplished at development of reporting databases and dashboards that combine data from any number of different sources, then mining the aggregated data to provide insightful recurring and ad hoc reports to clients.
• API Developer: Oversaw the development and successful implementation of APIs - allowing for automated data interchange between multiple applications.
• Core skill set: Professional-level experience with Power BI, Tableau, Confluence, Sisense, Oracle BI Enterprise Edition, SQL Developer, Google Data Studio, Azure, Jira and Microsoft Office (Excel, Access, PowerPoint).
• Methodologies: Solid experience with SDLC, Waterfall and Agile mythologies.

PROFESSIONAL EXPERIENCE:

Confidential, NC

Business Analyst

Responsibilities:

• Provided gap analyses to assist with standardization of data collection and reporting across multiple global business units.
• Worked directly with stakeholders to develop reports and dashboards, primarily utilizing Power BI and Tableau.
• Utilized Jira to develop user stories, organize sprints (via Agile methodology) and collaborate with senior management on project deliverable timelines.

Confidential

Business Analyst

Responsibilities:

• Provided gap analyses to assist with report and data ETL migration across multiple servers and platforms.
• Mapped source data to final migration layer.
• Adapted source report SQLs to accommodate source-to final migration layer mapping.
• Wrote official technical and end-user documentation for a variety of business procedures and tools.
• Worked directly with stakeholders to develop reports, primarily utilizing Oracle Business Intelligence Enterprise Edition, Azure and SQL Developer.
• Utilized Jira to develop user stories, organize sprints (via Agile methodology) and collaborate with senior management on project deliverable timelines.
• Worked closely with offshore developers to coordinate on technical deliverables and timelines.

Confidential

Business Analyst

Responsibilities:

• Provided gap analyses to assist with report and data ETL migration across multiple servers and platforms.
• Wrote official technical and end-user documentation for a variety of business procedures and tools.
• Worked directly with stakeholders to develop reports, primarily utilizing Oracle Business Intelligence Enterprise Edition and SQL Developer.

Confidential

Business Analyst

Responsibilities:

• Provided data-driven business insights and collaborative business transformation practices by developing, implementing and expanding a variety of new data resources used throughout the company and client base:
• Identified organizational efficiencies achievable through process automation and drove these through to completion in partnership with business leadership, IT partners and subject matter experts.
• Worked in conjunction with organizational leaders and client focus groups to identify key data-driven business needs, particularly business insights and KPIs.
• Identified key resources - technical and human - needed to achieve these specified goals
• Worked with strategic business partners - chiefly IT and subject matter experts - to develop a project framework and successfully drive it to completion
• Provided metrics after implementation to make certain the new data resource was successfully meeting organizational expectations.
• Developed and provided recurring and ad hoc reporting/analytics to the company President, senior executives and all organizational departments. Responsibilities included data collection, aggregation and normalization across multiple departments (e.g. Merchandising, Ecommerce, Marketing, Finance, Accounting) and third-party vendor partners. Initially served as the sole provider of such reporting and analytics as it pertained to multi-departmental aggregation and data mining, and later as an analyst / project manager working in conjunction with the IT department.
• Created company’s first multi-vendor reporting database, comprised of sales data from roughly one hundred vendor-partners (e.g. Whirlpool, GE, Electrolux, LG, Serta). Served as project manager for this database for all stages - initiation to closure - and served as the database’s subject matter expert. This database - launched in 2015 - continues to serve as the backbone of corporate reporting today.
• Created the company’s first marketing data warehouse - comprised of coupon, circular, targeted web ad, vendor rebate and finance promotional data - which aggregates and normalizes data from nearly one hundred vendor-partners and data providers. Served as project manager for this database for all stages - initiation to closure. First created in 2011, this database still serves as the core of promotional reporting for the company.
• Served as the project engineer, developer and chief subject matter expert for the company’s data visualization strategies. Provided web-based dashboard analytics that included client-facing, vendor-facing and internal-facing solutions. These dashboards were primarily developed using either Microsoft’s Power BI platform or Sisense’s platform, with Google’s Data Studio being incorporated in 2020.
• Created company’s first product reporting database combining sell-in data from manufacturers (e.g., Whirlpool, GE, Serta) and sell-out (point-of-sale) data from our client dealers. Allows for analysis of product margins and sales velocity from a single SKU to various product mix combinations, by zip, region or country. Currently this database is being utilized by the company’s Merchandising department to provide insights that are unique to the industry.
• Served as the first point of contact and trainer for many business applications. Responsible for ongoing troubleshooting and maintenance for the applications, processes and dashboards described above.
• Created and delivered business proposals regarding business application development both internally (to the executive board) and externally (to vendor partners and affiliated business). These presentations comprised both written and oral components and were delivered in a multitude of settings - formal and informal. Examples would be board meetings, trade shows and conference calls.

Confidential

Business Analyst

Responsibilities:

• Developed and implemented successful custom-tailored promotional marketing programs for a variety of clients (e.g., Republican National Committee, National Geographic, John McCain, West Point Military Academy, Pepsi Bottling Group).
• Established and maintained excellent relationships with both clients and industry suppliers, resulting in increased referrals, preferred-customer status with regard to pricing and job-order prioritization.
• Managed nearly all back-office facets of an $800,000 per year promotional marketing firm, including purchase order and quote-tracking systems, client and supplier case histories, and industry/product research.
• Administered and improved system interfaces for all PBG payroll, encompassing two countries, 40,000 employees and $2 billion in annual gross pay.
• Automated systemic validation of vendor interfaces, cutting Operations processing time by 75% and ensuring compliance with the Sarbanes-Oxley Act.
• Saved Operations twenty-four hours per week by automating payroll balancing processes.
• Managed team of twelve subject matter experts in implementing five large-scale PeopleSoft payroll system tax updates, impacting 35,000 Pepsi employees.
• Designed the automation and systemic delivery of accounting and financial reporting utilized by Pepsi Bottling Group financials nationwide.
• Served as an organizational technical trainer for both U.S. and Canadian PBG employees for such products as PeopleSoft, Microsoft Office, Business Objects and Mercury Test Director.
• Designed federal Medicare compliance reporting application, saving Medicare department $50,000 annually in outsourcing costs.
• Recognized as primary source of organization’s Medicare data analytics.