Kate Ervin Email & Phone Number

Independent contractor expanding technical skill set to further enhance product delivery and customer satisfaction.▪ Actively pursuing additional Microsoft Power BI training to gain advanced knowledge of functionality, visualizations, dashboard optimization and development of DAX queries.▪ Successfully achieved Certified ScrumMaster® and Certified Scrum Product Owner® certification through Scrum Alliance, Inc.

Primary Technical Business Analyst supporting the Phase 2 implementation of ServiceNow functionality at Subway.▪ Spearheaded focused workshops and highly-effective requirements gathering sessions to extend ServiceNow IT Service Management (ITSM) Workflows across Franchisee Services and Monetary Compliance business units.▪ Partnered with ServiceNow technical staff and HCL Technologies consultants to analyze HR and Facilities needs for deployment of HR Service Delivery (HRSD) and Workplace Services Delivery (WSD) ServiceNow modules.▪ Successfully identified, investigated and resolved a significant technology risk associated with Azure Dev Ops (ADO) integration into ServiceNow. Uncovered additional technology risks to be added to the project Risk Log.

Paris, Issy-Les-Moulineaux, Fr

Lead analyst for the Daily Order Tracking (DOT) and New Item Tracker (NIT) projects providing daily Flash Report dashboards and Power BI visualizations to Retail Sales and Supply Chain teams, Executives and Senior Management.▪ Elicited and documented requirements for DOT and NIT enhancements developed using Agile Scrum methods to optimize the efficiency and effectiveness of Retail Sales and Supply Chain strategies and performance.▪ Created technical documentation and worked closely with data engineers and system architects to improve Azure Data Factory pipelines, SQL Server views and SQL stored procedures used to automate data transformations on multiple data sources into an Azure Data Lake for consumption in a Retail Sales Data Mart.▪ Recreated portions of the Power BI DOT Dashboard to become more familiar with the business reporting needs.

Lead business intelligence analyst on the Executive Reporting Team in a MicroStrategy reporting environment, delivering Key Operating Metrics and Subscriber Activity reports to corporate leaders.• Provided requirements analysis, business requirements documentation (BRD) and quality assurance testing for new report development and requested enhancements, including the integration of three separate corporate reporting environments into one cohesive system.• Performed daily audits and data validation for reports distributed to the Executive branch of the company.• Collaborated with the Data Quality Management team to gather requirements for automating report audits.

Baar, Zg, Ch

Primary business analyst, project leader and report developer supporting a Grain Forecasting PowerBuilder application using Oracle data and a Cotton Inventory Management system using MS SQL Server data. • Analyzed and defined business requirements, created requirements documentation and provided quality assurance testing for the Agriculture department. Created training materials and led user training for business applications, Business Objects reporting environments and WSI Xceptor tool used for Cotton inventory reconciliation.• Delivered Business Objects reporting solutions to head traders and support staff. Developed reports and universes for business reporting, data analysis and issue resolution.• Created and enhanced MS Excel linked workbooks and VBA macros, wrote SQL scripts for Oracle and MS SQL Server databases, and provided second level support for business applications, reports and data issues.• Spearheaded training programs for Business Objects, a Lotus Notes upgrade and an Outlook migration. Created training materials, organized and led training sessions, provided follow up support and delivered individualized training as required.

Stamford, Ct, Us

Principal business analyst, project leader and report developer for the Business Objects reporting environment. Provided application support and initiated training sessions for Finance, Accounting and Business Support departments. • Gathered and analyzed requirements, produced business requirements documentation, and performed quality assurance testing. Collaborated closely with business users to develop and enhance Business Objects reports and universes accessing Oracle data.• Created training materials and led customized Business Objects training sessions for business users and IT support personnel.• Managed the Business Objects reporting environment as primary systems administrator, scheduled Broadcast Agent nightly reporting jobs and drove the BO 6.5 environment migration to Business Objects XI R3.• Proactively created and maintained a Business Objects Error Log application using MS Access and Visual Basic. Created 900+ knowledge base entries in support of the Business Objects reporting environment.• Participated in on-the-job training in Oracle and Unix Kornshell development in SQL and PL/SQL to broaden knowledge of the reporting environment and data load ETL processes.

Lead business analyst and report developer for EIS/MIS and Operational Support reports using Business Objects accessing Oracle databases. Managed the Broadcast Agent nightly job scheduler. • Analyzed and documented business requirements and processes, developed and tested reporting solutions, and provided application support to the business user community. • Enhanced existing Business Objects Add-ins and macro functionality using Visual Basic for Applications.• Worked closely with the SICS/nt application support team to identify and resolve data discrepancy issues.• Spearheaded Parisian report development efforts during the migration of legacy applications to global implementation of SICS/nt. My French language skills were recognized as vital to the project’s success.

New York, Ny, Us

Reports Development Team Coordinator directing development efforts for reporting solutions and technical requests. Spearheaded a Year 2000 compliance project and an OS/2-Banyan migration to Windows NT.• Provided requirements analysis and business requirements documentation, led quality assurance testing and coordinated project deployment. Prepared training material and led OS/2 training sessions for 200+ users.• Created MIS reports using Clipper, dBase and R&R Report Writer, and developed business applications using MS Excel, MS Access and Visual Basic for Applications. Created a Lotus Notes Reports Catalog and a Help Desk application, and trained Help Desk staff members.

Bachelor Of Science, Mathematics With A Computer Science Concentration; French Minor

Education record