Yury Michael Andreev, Mba Email & Phone Number

Madison, Al, Us

Madison, Al, Us

Amarillo, Texas, Us

Deerfield, Il, Us

Empowered analysts with workflow optimizations – provided access and familiarized analysts with existing reporting capabilities that enabled them in research, development, testing and quality assuranceProvided positive influence on the team's ability to work with and manipulate data – conducted training sessions for analysts on use of Excel Power Query and pivoting to allow each member access to the original data to achieve better communication during the cross-function work processesTimely addressed changes to stack of reports "Specialty Business Review"Took advantage of arising opportunities to streamline data flow – researched and delivered new data sources to allow the team to advance its reporting capabilities, and ease the effort of QA and exploration of new dataTeradata and Oracle SQL – developed necessary skillset to write efficient, effective and easy-to-read server specific SQL code to simplify and streamline the data acquisitionSQL Server Integration Services – wrote extensive set of data transfer and manipulation commands to timely access new data sources, efficiently manipulate and transfer information in a primed for data analytics formatDatabase Design and Setup – designed and developed a complex yet simple-to-use data structure for storing, maintaining and reportingEngaged key stakeholders in setting up new server environment, worked with cross-functional teams following proper channels of approval to answer and resolve regulatory and security concernsGathered information on existing data sources used in reporting to compare against the new sources and ensure that the current data questions can be efficiently answered, while providing room for additional research in the futureCollected Reporting Team's input on the future state of reporting and delivered the vision on how it can be achievedDesigned the database structure and data load processes to assist the team in data discovery and research

Savannah, Georgia, Us

Continuously identified opportunities for improvement of technical skills to produce better deliverables to always exceed customers’ expectations and provide the best user experience. Built multifaceted, multi-database, interactive, and responsive dashboards with SQL and SSRS.Utilized C# and created a multi-file parser to convert CSV files into HL7 messages.Built Continuity of Care Document (CCD) XML file from flat files using SQL (for xml)Automated workflows with Boston Workstation scripting to assist staff with reducing manual work, saving EFTs across the organization, assisting departments such as MM in keeping their dictionaries up-to-date across testing rings, Patient Accounting in updating thousands of visit records, etc.Built capacities to automate and streamline data flow between databases, ftp servers, and other files with SSIS and (batch files) scripting. Utilized Cloverleaf Engine to translate and route HL7 messages as part of Accountable Care Organization project.Proposed, obtained leadership's approval for the usage of, and developed Report Request Form (RRF), to facilitate and streamline reporting team's efforts when working with end users. Through the use of RRFs, vendor’s specifications files, and other communications with the internal and/or external stakeholders produced deliverables within scope of each project, and on time.Collaborated with teammates on projects spanning system wide EMR upgrades; engaged individuals in delivering projects such as electronic delivery system integration involving EMR support, outside vendor support, and a number of local stakeholders. Led multiple teams’ efforts during EMR major updates, coordinating communications and work necessary to prepare, validate and deploy the changes.Supported customers during and after implementations of new technologies used in user-centered deliverables. Assisted other programmers in development and delivery of their projects.

Savannah, Georgia, Us

Utilized SQL to build reliable, complex, fast, high quality SSRS reports and other deliverables.Trained end users, and conducted teaching sessions for colleagues, on topics including SQL programming, Report Writing/Designing, Microsoft Office products, EMR functionality etc.In a timely manner researched and resolved, when possible, issues in the supported applications in Meditech 5.66-6.15 (Report Writing/Desiging, AP, MM, GL, Access Provisioning), and provided assistance to others whenever necessary, considering the implications of resolutions on other stakeholders and/or systems. Escalated and followed up on issues requiring involvement of other modules and/or outside support. Through extensive report writing experience identified and reported various points of concern to applications specialists for review of issues including inconsistent dictionary entries, unreliable forms of documentation on custom queries, etc.Created multiple deliverables that are utilized by mid- and upper- level management in strategic planning, for example, a report used in troubleshooting statistics in revenue generating departments to identify shortfalls causing budgetary concerns in staffing.Documented daily operations and performance, for the review by leadership. Setup a process and developed capabilities for leadership to review reporting team's performance based upon a number of key indicators. Provided insights into practices that warrant strengthening of patient safety, increasing patient satisfaction, and providing quality care.Supplied information used in establishing compliance with regulatory agencies.

Savannah, Georgia, Us

• Conducted cost-benefit analysis of current/proposed pricing identifying cost saving opportunities • Solicited, negotiated and reviewed pricing agreements, contracts and bids• Analyzed annual product usage to establish accurate par min/max levels • Communicated problematic orders’ details to user departments ensuring their needs are met • Resolved problems with purchasing, delivery, receiving and billing determining source of issue and taking appropriate corrective actions• Assisted in performing annual inventory and reconciliation• Maintained accurate vendor and product related data in MEDITECH• Utilized Visio to create process maps for Lean Six Sigma initiatives

Jacksonville, Florida, Us

• Managed the department that accounted for over 65% of all in-store sales• Increased sales by 5% through inventory management and Out-Of-Stock prevention • Forecasted, prioritized, purchased and managed appropriate levels of inventory • Lead, trained, and evaluated performance of 5 employees• Fostered an environment to sustain high levels of customer and associate satisfaction

Kobbegem, Be

• Assisted in reducing shrinkage by 20%, down to the company average • Upheld company guidelines, policies and standard practices• Maintained a productive relationship with customers • Sustained a department that is conducive to selling

Statesboro, Georgia, Us

• Utilized Visio to create existing School of Accountancy website structure to identify and engage Stakeholders• Co-managed SOA website content reconstruction - extensively communicated with professors to gather new information; composed, redacted, and organized all material for uploading• Reconciled professors’ travel expense statements with school’s expense budget• Designed and coded professional website for business law professor with Adobe Photoshop, Illustrator, Dreamweaver in clean HTML and CSS• Designed School of Accountancy’s posters with Adobe CS• Learned and applied project management skills to ensure project completion (Website content reconstruction)

• Initiated online marketing campaign to introduce a new product to English speakers• Created database of metal detector stores, clubs, etc. through market research• Established contact with various international metal detector dealers • Created marketing materials with Adobe CS• Revised, optimized (SEO) and configured website and tracking services• Utilized social media to develop brand awareness that resulted in generation of new sales in some English speaking countries• Translated, prepared and composed marketing materials in English, Spanish and French

• Proposed local marketing initiatives to use ad boards, flyers, and coupons• Improved accounting system - organized data for easy tracking and decision-making• Assumed leadership of staff meetings, reviewed and set performance objectives• Managed personnel of up to 3 people and finances in absence of the general manager

Masters, Master Of Business Administration

Bachelor Of Science, International Trade

Minor, Spanish For Business