Alicia King Email & Phone Number

Cincinnati, Oh, Us

Cincinnati, Oh, Us

Chicago, Illinois, Us

Chicago, Il, Us

* Led a team of engineers who developed, maintained & supported 20+ applications with 25+ API/DB connections in multiple languages and frameworks.* Implemented standard agile processes resulting in team-wide increase in output of up to 200% per team member.* Proactively addressed team member issues resulting in 125% increase in team confidence and 150% increase in team efficiency.* Implemented targeted upskilling & cross-training resulting in 3 additional hours of training per quarter, per team member & improving work distribution by 200%.* Developed & implemented coding standards, review procedures & application taxonomy to track & monitor code lines & data connections, resulting in 2x resolution of defects year-over-year.

Chicago, Il, Us

* Developed & maintained applications for global teams over 2000+ users for valuation of commercial real estate assets, generating over $50 million dollars in revenue.* Quickly learned complex application codebase of 20+ tools, documenting requirements & constructing flowcharts for 140k+ lines of code in multiple languages.* Coordinated with 3rd party solution vendors & global stakeholders to gather requirements and resolve issues resulting in 3x increase in application update frequency.* Identified & resolved defects in multiple systems including API connection, data ETL & reporting enabling increase of $2.26mm in revenue in 3 months.* Implemented team-wide agile processes, development tools & customized dashboards to track & communicate progress resulting in nearly 2x increase in user satisfaction and 20% increase in efficiency.

Atlanta, Georgia, Us

* Implemented automated solution of Tableau Hyper API, reducing load time from 2+ hours to ~5 minutes. * Designed & developed Selenium & Python automation to validate Tableau dashboards.* Maintained SQL Queries & views utilizing GCP BigQuery. Deployed and maintained data extracts.* Coordinated with business teams to gather requirements for development of new Tableau dashboards.* Communicated business needs to developers of dashboards and datasets; wrote, refined & groomed user stories in Jira. * Validated changes to dashboards, including layout, function & data integrity. Collaborated with development teams to resolve issues.

Dayton, Oh, Us

* Automated data mining/modeling, analysis and business intelligence gathering, cutting runtime by 75%.* Automated testing of systems performing complex data analysis, identifying gaps or incorrect data. * Analyzed and validated the correction & transformation of health (PHI/PII data) and provider data for >1 million members, utilizing Excel, PowerQuery & SQL Server.* Reviewed functional requirements for data modeling, generated user stories & acceptance criteria.* Coordinated product releases with deployment teams, implemented a standard deployment framework.

Cincinnati, Oh, Us

* Designed and implemented new framework for testing automation, saving >50 hours of work per week.* Developed and maintained automated scripts with VBA, utilizing Visual Studio / UFT.* Introduced improved workflows, eliminating 3-month backlog and increasing delivery efficiency by 75%.* Developed and refined user stories from business requirement documents (BRDs) as member of agile team. * Provided Excel reports and status dashboards concerning sprint backlog, timing, schedule and results.* Trained, directed and coordinated offshore testing, automation and integration teams in various time zones.* Collaborated with deployment teams, developers and business users to establish bi-weekly release schedule.

Cincinnati, Oh, Us

* Redesigned and maintained Excel-based insurance models, spreadsheets with 1000s of formulas and multiple pivot tables using VBA/Python, improving run-time and efficiency by 95%* Learned and optimized a complex data process on Day 1 – cutting run time from 5 hours to 4 seconds.* Automated over a dozen manual processes end-to-end, including data mining - web scraping, document scraping, database querying; ETL; and system input / output; saving 1000s of hours of work.* Automated procedures to collect data and transform data, identifying inconsistencies in 50% of cases.* Researched new technologies for and improved multiple projects at a time, ranging in complexity and size. * Led development team, provided training and monitored output to maintain compliance and meet deadlines.* Gathered requirements from multiple stakeholders. Documented new processes and trained end-users.

Cincinnati, Ohio, Us

* Designed and developed new automation framework, identifying manual processes capable of automation.* Automated processes to collect, transform and compare data across multiple web, legacy and mainframe systems improving speed and efficiency by 85%.* Automated process to validate data and report rejected/incorrect data, cutting process time in half.* Created dashboards in Excel and IBM Business Intelligence using PivotTables and lookup formulas.

Boston, Ma, Us

* Designed, developed and debugged work reporting application for department of 100+ individuals.* Automated bi-monthly data collection and reporting task – cutting process time from 2 days to 20 minutes.* Collaborated with stakeholders to identify requirements and research/recommend solutions.* Produced technical documentation and training materials, provided technical support.

Us

Supported Specialists and General Managers at large Ohio manufacturing corporation. Received, distributed and responded to customer quality problems for three manufacturing plants. Maintained extensive hard-copy and electronic database of external quality issues and company responses. Prepared weekly reports for General Managers and Vice Presidents on quality situation. Arranged domestic travel and completed travel/expense forms for several departments. Controlled changes to interdepartmental policies, documents, forms and procedures. Maintained and updated company intranet. Drafted and typed correspondence, memos and policies. Handled special projects.

Medford, Massachusetts, Us

Supported Vice President and Directors of communications office in large non-profit organization. Organized meetings, events and presentations: reserved and set up conference rooms, tele- and video-conferencing equipment and internet meeting software. Arranged domestic and international travel and accommodations; prepared VP and Directors for travel and engagements with documents/binders. Completed travel/per diem and expense reports. Managed calendars, performed internet searches, sorted mail, maintained electronic and hard-copy filing system. Managed special projects including external publications and brand materials. Trained and supervised junior-level staff and replacement.