Klaudyna Routt, Mba, Meng, Ea Email & Phone Number

Edmond, Ok, Us

Oklahoma City, Oklahoma, United States

Oklahoma City, Oklahoma, United States

 Conduct highly sensitive and confidential analyses on Leadership’s request, and reported findings directly to the Chief of Police. Create multiple MS PowerBI dashboards that allow users to derive value regarding police fleet, emergency events, 911 calls, gun casings, inspections, personnel, staffing, etc. Develop ArcGIS projects, dashboards, surveys, data collections, and simplified processes for multiple bureaus. Utilize SQL Server Management Studio, MS Forms, Power Automate, SharePoint, and PowerBI to streamline data collection and analysis.

Oklahoma City, Oklahoma Area

- Author bid proposals. Results: Clients granted contracts, i.e.: law enforcement training contracts worth $1.5mil+, a polygraph contract for $80k, etc.- Provide small business consulting and analyses to progress efficiency and effectiveness of operations. Results: Labor costs of a client B decreased by 11%.- Perform accounting, including effective pro forma financial statements. Results: Client C offered a $3.6 million SBA loan.- Implement electronic solutions within clients’ workflow, such as project management applications, timesheets, e-signatures, electronic fund transfers, QR codes, etc. Results: Labor costs decreased by 11%.- Prepare individual tax returns, address existing IRS and Oklahoma Tax Commission issues.- Digital marketing campaigns for small businesses with customer base of 31,000+.- Utilize Intuit ProSeries & QuickBooks Online for Accountants (QBOA), Campaign Monitor, MS Office 2016.

 Managed Citizen Data Scientist Program, which helps companies build data specialists within organization while using their own team. The program teaches companies about their Data Activation, Data Infrastructure, Data Analytics, Data Visualizations, Data Mashups, and Data Automation.  Oversaw Digital Maturity Assessment - qualitative and quantitative measurement of company's place on a digital maturity model using Qualtrics survey and Excel scorecards.  Developed winning digital strategies.  Helped clients identify the weaknesses in their skills, processes, business culture, or infrastructure, and then assist in closing those gaps.  Studio production.  Worked with Clients such as: Express Professional Employment, Sport Clips, Devon Energy, Nextep, Cam Sky, Jasco, John Deere.

Oklahoma City, Oklahoma

 Spearheaded, developed, and implemented an interactive and Business Intelligence based Marijuana Growers Mapping for OBN Marijuana Missions, which allowed the OBN Agents to access the map from an aircraft during Marijuana spotting to determine legality of the observed growth. Results: Streamlining of OBN Marijuana Missions objectives, bringing Digital Transformation to the OBN Enforcement. Developed a technique allowing OBN to easily access SyTech ADACS 4.2 wiretap intercept data; with analysis based on raw data rather than standardized but incorrectly written queries provided by the vendor SyTech. Conducted technical analysis and evaluations of intelligence data and/or criminal activity. Reviewed, selected, evaluated, and consolidated incoming intelligence data and related information, and ensured that follow-up actions are initiated; collected additional data to fill gaps; disseminated action items to the responsible enforcement federal, state, and local entities. Gathered intelligence from other local and state law enforcement professionals regarding drug trends and drug related crimes trends.  Utilized ACISS for intelligence input as well as back-end data exports if needed for cases. Collected, analyzed, and evaluated criminal intelligence data, suspicious activity reports, and open-source information.  Analyzed telephonic communications, including intercepted Title III communications, various jail call, messaging, and video chat systems.  Analyzed wire transmitters in the State of Oklahoma. Designed and maintained integrity of the OMMA Registrants db for the purpose of Marijuana Growers, Dispensers, and Processors mapping. Expert in analysis and presentation using charts, graphs, or tables, for the management and for the court proceedings. Utilize: ACISS, MS Power BI, ArcGIS, IBM-i2, ACISS, JSI VoiceBox, SyTech ADACS 4.2, Cellebrite, PENLink, FinCEN, SWBTRAC, CLEAR, Accurint, Whooster

Oklahoma City, Oklahoma Area

 Conducted data quality evaluations on >90 million records located within 4 relational databases, each database had a different schema and different variables which required an additional level of effort. Results: Dirty Data qualified within 0.6% margin (industry standard >5%). Spearheaded the initiative of retrieving all OBN PMP data from the vendor who was capturing the data to their cloud on Amazon S3, but not providing the full access to the OBN. Prepared drug trending data reports, compliance metrics, user access and usage statistics, reporting and error compliance records, PMP outcome results, evidence-based analytics, and other analyses which enhanced or demonstrated deficiencies in the PMP system, customer service, or delivery of PMP information. Results: system usage by law enforcement doubled.  Developed a method of data mining which resulted in discovering of specific violators of the State Uniform Controlled Dangerous Substance Act: Title 63 through a series of direct and indirect ad-hoc queries. Results: OBN conducted several cases based on these findings alone. Worked directly with agents of OBN on cases where PMP resources were requested. Including, but not limited to the creation of investigative profiles, analytics, and reports within the PMP database. Monitored, tracked and maintained a record of dispensers who are out of compliance with PMP policies and state law, including, but not limited to: dates, times, documentation of the issue, and resolution. Developed, maintained and revised policies, procedures and processes for the PMP in coordination with the PMP administrator concerning compliance with PMP reporting requirements defined by state law. Testified as “Keeper of the records”. Utilized: SQL Server Management Studio, Tableau, Power BI, Jasper Analytics, MS Office 2013 with emphasis on Excel.

Oklahoma City, Oklahoma Area

- Administered Automatic Vehicle Locator (AVL) system and device replacement project for 1,200 vehicles located statewide. Results: The project was 2 months ahead of schedule, which generated time and cost savings for the division.- Trained State Agencies in utilizing Automatic Vehicle Locator (AVL) solution as well as Compressed Natural Gas (CNG) trainings. Results: Increased utilization of CNG from 0.25% to 6% of the fleet by improved customer confidence in CNG fueled vehicles. - Trained State Agencies in utilizing AVL web-based Business Intelligence services.- Performed data analysis re: purchasing, leasing, managing, and sale of 1,200 vehicles (inventory of $23mil+).- Presented Compressed Natural Gas training to State Agencies.- Maintained various databases in MS Excel and cross-referenced with other Business Intelligence tools.- Created databases in MS Excel, generated ‘just-in-time’ ad-hoc queries, such as exception reports, and validated relational databases.- Utilized: SQL based AssetWorks FleetFocus M5, NetworkFleet, MS Office 2010.

Greater Poland District, Wrzesnia County, Poland

• Captured market opportunity to develop a privately-owned publicly-financed healthcare clinic• Handled accreditation, deliverables, and contracting with national healthcare institution• Accountable for public funds allocated for operations of 6 different specialty divisions• Translated the needs of patients into TQM goals through application of services of all 6 divisions• Supervised medical staff of 9 doctors, 2 nurses, and 2 other medical personnel• Responsible for the organization’s supply chain and inventory control• Managed a budget of PLN 1,000,000+• Responsible for day-to-day activities including financial transactions, inventory, and cost forecasts• Consulted with divisions regarding scheduling of particular services• Established relationships with inventory suppliers• Outsourced highly specialized tests and established relationships with providers

Yukon, Oklahoma Area

• Computed corporate and personal taxes in accordance with Federal and State taxation laws for 1,500+ clients• Maintained and reviewed corporate financial statements for 130+ clients• Conducted cost and revenue forecasts, and advised on strategic planning for $100,000+ profit corporations• Carried out payroll computation, reporting, and payments through EFTPS, OESC, and OTC for companies exceeding $240,000 in payroll annually• Prepared and submitted Sales Tax returns and payments for clients with $200,000+ in sales monthly• Reconciled general ledger accounts• Resolved client’s payroll tax penalties and interest of $54,000+ assessed by the IRS• EasyAcct, ProSeries, MS Excel

Master Of Business Administration (Mba), Mba

The program included courses in strategic implementation and alignment, transformational leadership, finance & accounting, enterprise.

Master Of Engineering (Meng), Commodity Science

Activities and Societies: Academic scholarship 2003-2004, elected the Student Council in the years 2003-2005.The program included courses.