RATANA KONKANKIT

Northridge, CA ***** 818-***-**** ad4chc@r.postjobfree.com linkedin.com/in/ratana-konkankit-0491a76 SUMMARY

A meticulous analyst with a strong commitment to accuracy and consistently delivering high-quality results within project deadlines.Proven track record of efficiently analyzing the development and improvement of reporting techniques using SQL scripting,aiming for report automation in the current environment with responsiveturnaroundtimes.Proficientinmanagingmultipleprojectresponsibilitiesconcurrently,prioritizing tasks,and effectively addressing technical emergencies.Demonstrates expertise in assessing and testing applications,creating user test data,and devising test case scenariostovalidateprocessworkflows,identify bugs,and document defects.Adaptable to new applications,capable of successful collaboration across all organizational levels,andadeptatworkingwithinteamstructures.Aresponsible,self-motivatedprofessional with a strong work ethic,dedicated to achieving the highest quality in every project.Willing to travel.US citizen.

AREAS OF EXPERTISE

Program Management Business Analysis Process Improvement Relationship Management Attention to Detail Dependable Resourceful Goal-oriented Customer Service Oral and Written Communication Root Cause Analysis Problem Solving

TECHNICAL SKILLS

SQL SQL Server Management Studio Tableau Prep SAP Crystal Report Writer Cognos Reporting Salesforce.com Adobe Acrobat Professional Microsoft applications: Outlook Word Excel PowerPoint Access PC/Mac web browsers CARE Quest Laboratory System KNIME Analytics Python Data Lake PROFESSIONAL EXPERIENCE

QUEST DIAGNOSTICS, West Hills, CA July 2018 - April2023 Data and Reporting Analyst, Customer Solutions

Partneredwithandworkedcross-functionallywithOperations,CommercialandFieldServices,IT,andCustomerSolutions Teams (internal clients and customers) to drive efficient solutions through the use of tools and systems.

● CreatedoperationalefficiencyonsimpleandcomplexautomatedprocessprojectsfromKnimeAnalytictoTableau Prepplatformbydesigningprocessesandauthenticatedset-upswithproject-specificinassessing,evaluating,and monitoring projects to be in compliance; process time reduced by more than 90% manual hours.

● Subject Matter Expert in a facilitated discussion and provided technical trainingtonon-technicalindividualsand groupsaboutproject-specificbusinessneeds,andtranslatedthemintobusinessrequirementsforpatienthistorical search; created clear, concise, and organized Standard Operating Procedures for the intended audience.

● Developed,tracked,andsharedmetricsfortheCustomerSolutionSpecialists'teamonTableaudashboardshosted on the Tableau server;implemented folder securitymeasures,adheredtouseraccessguidelines,andeffectively identified and resolved incident issues.

● Implementedandmanagedprojects,compiledandanalyzeddata,appliedtechnicalinformation,paralleledtestsfor data accuracy and efficiency of existing and new processes,addressed audit findings,resolved application and program issues, and continuously monitored data integrity for process improvement projects and other initiatives.

● WrittenStandardOperatingProcedureoutliningstep-by-stepdetailsofQuestLabSystemconnections,workflows, and interaction of ticket assignments for the Customer Solutions Team.

● Assistedinevaluatingthequalityassuranceandqualitycontrolprocesseswithinthehealthcaredeliverysystemby reviewing procedures and documentation and collaborating with various teams to gather input and insights.

● Developed and created quality improvement by eliminating manual keystrokes and automatingmonthlyreports processes that compilemultiplesourcefiles(Labsystem,Salesforce,andCognos)forclientdemographicandstat reports, reducing processing time by 90% manual hours. Ratana Konkankit ad4chc@r.postjobfree.com Page Two

● Managedsupportservicesforproficientutilizationofdatamanagementtools(suchasAccess,Excel,TableauPrep) to analyzeandextractinnovativeinsightsfromdiversedatasourcesandplatforms,presentedandcommunicated complex concepts effectively to facilitatecomprehension,therebycontributingtoimprovedinternalandexternal decision-making.

● Extracted raw data from Quest Lab System and performed analytical and statistical techniques to identify and interpret providers’ patterns and trends based on historical data;displayed tables,charts,and graphs to help determine relevant business impact.

● Created,maintained,and parallel tested a recovery backup process using Access and Excel for the DailyTestIn Questions/Test Not Performed by automatically connecting to the Quest Lab System (ODBC)and initiating the workflow processes.

● Conductedprojectdataanalysis,includingtaskssuchasdatadiscovery,collection,cleaning,androotcauseanalysis, and worked with established, proposed, and diverse data sets from various sources and Excel formats.

● Determined the root cause and resolved the problem by assessing the program workflow and lab System connection, and recommended alternatives for the new development.

● Experienced in Excel automation using VBA,macros,and functions such as xlookup,vlookup,countifs,sumifs, iferror, pivot tables, slicer, and charts.

● Participated in providing technical data management assistance and collaborated with the IT team in a large hospital's Secure File Transfer Protocol Interface Project. CHILD CARE RESOURCE CENTER, Chatsworth, CA May 2017- July 2018 Information Systems Analyst II

Proficiently pull out and merge agency-related data using Access, Crystal Reports, and SQL from CARE, MIP, and LRS systems to generate reports for agency staff, government entities, and outside agencies.

● EfficientlydeliveredanalysistoexistingMSAccessdatabasequeriestodevelopandenhancereportingtechniques using SQL scripting with an end goal of automating delivery reports.

● ParticipatedandcollaboratedwiththeteamonProjectArchived;adataarchiveprocessbystrategiesforgathering, reviewing,analyzing findings,andcreatingSQLscriptstodrawoutpossibleissuesviathebackendandtoresolve front-end errors for the CARE application.

● Adept at SQL queries by executing the scriptandtestplans,recordinganddocumentingdefects,andpresenting findings to the software vendor.

VERTICAL MANAGEMENT SYSTEMS

RETIREMENT REVOLUTION,Pasadena, CA February 2013- July 2016 Business Analyst / Manual Tester / Quality Assurance (Consultant in 2016) Successfullyassessedandtestedapplications(front-endandback-end)bycreatingusertestdataandtestcasescenarios to validate process workflow, identify bugs, and document defects.

● Proficiently reviewed,recommended workflow improvements,and collaborated with software developers to correct issues before deployment.

● Efficiently conducted website User Acceptance Testing of newly developed GUI’s according to Business Requirements Document.

● Expertly audited modified reports to verify data quality due to reports specification changes from On-line Transactions Processing to On-line Analytical Processing/data warehouse.

● Assisted the Conversion team in payroll data testing,and participant census data automation and validations through an in-house web-based application.

● Performed website User Acceptance Testing in the Development, QA, and Production environments.

● Conducted compatibility testing across multiple web browsers(Chrome,InternetExplorer,andFirefox)toensure functionality, visibility, and content accuracy.

EDUCATION

Bachelor of Science, BS in Business Administration West Coast University, Los Angeles, CA

Contact this candidate