Cydney Johnson Email & Phone Number

Bellevue, Wa

Leverage strong analytical, technical and strategic acumen in managing the North American client BTA credit card reconciliation process for 70 companies through SFTP connections with 3rd-party financial institutions. Supported management on insight into site issues/incidents and analysis. Drive efficiency in processes by working closely with vendors to verify file format, test connections, and set up for production files to be delivered for each client.  Demonstrate analytical problem-solving in troubleshooting SFTP issues, file format, and data quality issues. Formulate confluence documentation for company CC Reconciliation offering from execution to final reconciliation product. Play a key role as an analytic and data expert, delivering effective consulting on global data feeds, data integration, and quality projects. Develop interactive Tableau dashboards for management by gathering and aggregating data from multiple sources (SQL Server, AWS Redshift, Excel, custom SQL) to use in multiple departments, tracking Incidents, Salesforce cases, Jira issues from various data sources, showing rollup of critical metrics with clear performance trends against service goals. Offer analytical, training and ad-hoc support to cross-functional teams.  Analyze reported site issues/incidents aid in determining possible underlying root causes for ongoing improvement efforts. Work with data engineers to operationalize dashboards and ingest new data sources

Bellevue, Wa

Directed a global team’s productivity and workflow to meet quality service goals while providing the team with assistance in resolving data-related problems. Critically analyzed and identified process gaps through detailed analysis; worked across functional groups to troubleshoot issues regarding data integrity and to improve data quality. Conducted rigorous root cause analysis to identify potential deficiencies and implement process improvements, recommending robust changes to enhance productivity within the department.  Collaborated with stakeholders globally to create relevant management reports to support business requirements. Provide recommendations on issues developed during the data gathering process. Worked with and within cross-functional teams to identify appropriate business solutions to challenges. Analyzed key aspects of the business to evaluate results and summary for presentations. Engaged with internal teams to develop and refine data collection, data validation and manage reporting products. Retrieved, manipulated, and compiled third party data to provide global reporting to both internal and external customers. Led 2-week Sprint planning and acted as Scrum master on small to medium projects. Created functional/technical business specifications for projects.

Bellevue

Oversaw and led a global team to provide recurring and ad-hoc reports for account management, supply chain, and leadership while coordinating resources across operational teams to implement changes. Reviewed and documented existing processes, methods, reports to identify problems leading to a reduction of manual work by 23% through the development of data-driven metrics. Formulated complex reports to internal and external customers and leadership to facilitate decision-making. Worked cross-functionally to identify and implement enhancements to reporting and analytics processes and identify important key success metrics for reporting related initiatives.  Drove quality and integrity in data by designing and automating processes and performing comprehensive data audits.

Seattle,Wa

Managed a staff of three North America reporting analysts, assigning and reviewing daily activities while tracking progress and updating stakeholders and clients. Streamlined report request processes by improving intake forms to enhance the customer experience. Created recurring reporting and presentations to internal stakeholders and external partners using MS Excel and SAP Business Objects.  Delivered client facing management reports monthly, quarterly, and annual business reviews.