Kelly Ann Antalek Email & Phone Number

Pittsburgh, Pa, Us

Pittsburgh, Pa, Us

Remote

● Program Manager for various customer services tools responsible for workflow management and operations.○ Authored Monthly and Quarterly Business Review documents.■ Shared team highlights/lowlights.■ Reported up to date summary and status of all team goals.■ Identified areas of assistance needed.■ Collected metrics for team defects and trending over time.■ Sourced statistics on application usage of all team products.■ Presented these documents in leadership forums with peer teams.○ Managed team Sprints (daily Scrum sessions, sprint planning, sprint updates, backlog scrubbing).○ Responsible for project escalations and other communication to leadership on sprint and project status/issues/risks.○ Analyzed stakeholder requirements, translating them into technical requirements for the team.○ Facilitated deep dive sessions between international, cross functional teams to improve customer experience, and drive autonomous, testable requirements.○ Leveraged data to drive trade off decision making between short-term fixes and long-term goals.○ Reformatted the weekly team meeting for efficiency and learning.

Remote

● Lead Campaign Manager on various campaigns contacting up to 700K customers.○ Reviewed requirements from the business for completeness, autonomy, and testability.○ Worked with stakeholders to refine requirements as needed.○ Responsible for communication to upper management on project status/issues/risks.○ Developed complex handwritten Oracle SQL to gather base audience for campaigns and apply suppressions.○ Developed campaigns in Unica based on requirements. ○ Worked directly with vendors on new campaign set-up and launch.○ Preformed ad-hoc data analysis and research to diagnose data issues.

-- Lead Systems Analyst on a project to develop a documentation repository for all of the (approximately 50) data mart subject areas used by the marketing teams for campaigns.--- Analyzed the data using SQL via toad to interrogate the subject areas on the Teradata platform.--- Used GitHub to review currently deployed code to enhance documentation.--- Designed a Confluence site to house the documentation about the data structures.--- Standardized and organized the documentation within the site, creating a structure that would be simple for various audiences (both business and technical) to traverse.--- Facilitated discussions with stakeholders (business, developers and BAs) of the data mart to ensure documentation met the needs of all.-- Lead BA on a project identifying the best sources of Guest Age data by performing preliminary analysis using SQL via Toad on the existing age data housed in Teradata and their sources to gather metrics.--- Analyzed the Guest Age metrics in order to present suggestions to stakeholders, other analysts and developers to resolve discrepancies, bad data, and the confidence of sources of data.--- Finalized requirements after stakeholder meeting and handed off to development for coding and performed QA on the solution.-- Senior Quality Management Data Analyst in an Agile-like methodology to thoroughly test data mart changes prior to deployment by reviewing requirements for test cases that were then written as SQL scripts on the Teradata platform via Toad.--- Interviewed stakeholders and BAs for additional test cases.--- Worked collaboratively with the team to resolve issues found in testing.

Pittsburgh, Pennsylvania

-- Lead BA for various projects, engaging in business, functional and UI requirements gathering, KPI identification with stakeholders, validation of derived requirements with appropriate business/technical teams.--- Performed preliminary analysis of current state and future state request in project charter to formulate BA effort for the projects.--- Facilitated requirements discussions with senior leaders.--- Functioned as the liaison for the data warehouse team with regards to changes to the upstream data source and the changes being proposed.--- Worked collaboratively with other BA team members to aggregate business, functional, and technical requirements into a single requirements document on large projects under an aggressive timeline using Agile-like methodology.

Celebration, Fl

-- Leader with two direct and one dotted line report, meeting regularly 1:1 with direct reports to provide task prioritization and obtain status updates – open door policy.--- Diligent to ensure barriers reported by direct reports were identified and collaborated on plans to remove them.-- Senior member of the Marketing Business Analysis team responsible for the work assignment distribution to fellow BA and PM resources supporting a multi-hundred-terabyte Teradata big data platform.-- Lead BA on various projects specializing in preliminary analysis, business and functional requirements gathering, ensure requirements comply with any applicable laws, KPI identification with stakeholders, deriving data requirements, validation of derived requirements with appropriate business/technical teams and interrogation of the data on the Teradata platform by running SQL scripts via Toad, change request analysis and task estimation for the project and providing leadership when project manager was unavailable. -- Pioneered a new project management process and methodology for the technical team by partnering with core technical team to identify gaps in the existing project management flow, refined prioritization of those gaps, then communicated the new process to the department, resulting in more efficient project execution.-- Point of contact for external vendor team for their implementation and touch points to the internal solution, responsible for contracts ($10K-$300K in value) and partnership with internal procurement team.-- Liaison to the partner corporate data warehouse team, redefining that relationship so that information on status from the external team was pushed to the Marketing technical team rather than being pulled.-- Led the BA team in creation of a presentation for senior executive leadership to give updates on team progress, changes and enhancements made to processes, documentation and relationships both internal and external.

Lake Buena Vista, Fl

-- Senior member of the data warehouse Business Analyst delivery team supporting a multi-hundred-terabyte Teradata platform.-- Managed preliminary estimation of all data warehouse and data mart internal program/projects as well as external upcoming project work for entire Data Services team based on scope documents provided by associated technical and business teams. -- Lead BA engaging in all BA responsibilities including preliminary analysis, business and functional requirements gathering, ensure requirements comply with any applicable laws, KPI identification with stakeholders, deriving data requirements, validation of derived requirements with appropriate business/technical teams and interrogation of the data on the Teradata platform by running SQL scripts via Toad, change request analysis and task estimation for the project and providing leadership when project manager was unavailable. --- All projects were the data warehouse “arm” of a larger corporate project, often working under aggressive timelines, often under budget.--- Projects were both big (multi-year) and small (few weeks).--- Functioned as solo BA (and sometimes PM as well on smaller projects) and/or Lead BA as needed--- Served as main external point of contact for external team program BAs.-- Introduced data warehousing team data mapping tool in conjunction with a developer.-- Frequent contributor to special projects with new and emerging technology. -- Stabilized the data warehouse BA team for various projects by joining the team mid-project and engaging in all BA responsibilities to ensure that the project was back on track when timeline was slipping.-- Customized and created the standard for Disney IT standard templates for project documentation, tailoring the new version of the templates for a data projects.-- Documentation review lead for the data warehouse deployment BA team, responsible for reviewing all documentation for all projects produced by the team and providing feedback.

Lake Buena Vista, Fl

-- Documentation review lead for the data warehouse deployment BA team, responsible for reviewing all documentation for all projects produced by the team and providing feedback. -- IT “Buddy” for many new team members, responsible for team introductions, workplace tours and serving as a personal Disney “point person” for the new hire/consultant/intern.

Seattle, Wa & Celebration, Fl

-- Designed, coded and deployed technical solutions, data feeds and data fixes to fulfill business requests for the online data warehouse using MSSQL Server DTS packages, written in SQL.-- Technical lead for software engineering teams for data issues and responsible for reviewing and designing new schemas, indexing strategies and data migration efforts for both OLTP and OLTP and Data Warehouse/Data Mart initiatives.-- Authored and taught training and online help documentation materials for template creation for these systems.-- Designed and executed test plans.