Ryan Mccarthy Email & Phone Number

Hedgesville, Wv, Us

Hedgesville, Wv, Us

New York, Ny, Us

-Performing ID resolution for IP Host data.-Conducting morning Scrum meetings.-Providing analytics for in-house databases.-Troubleshooting data discrepancies and testing against a PROD environment.-Leveraging Microsoft Excel power pivot, VLOOKUP, COUNTIF, CONCATENATE, SUMIF, MATCH formulas.-Monitoring, updating, testing SQL schemas.

Boston, Massachusetts, Us

-Migrating a data cleaning process from Tableau Prep to a Python pipeline.-Performed manual testing and supporting documentation for various data cleaning Python pipelines.-Responsible for managing a corporate audit board’s performance data and funneling records into a Power BI dashboard.-Leveraging Power Apps/Power Automate to automate manual data gathering processes.-Utilizing Microsoft Excel and creating visual basic macros and power pivot to automate data grooming.-Gathering requirements from business partners and improving/creating new logic for data gathering.-Using Risk Management Assessment tools such as MetricStream, and Archer to export reports into a live audit plan dashboard.

Vienna, Va, Us

-Ensuring reliable data by setting standards, identifying anomalies, and helping to resolve issues.-Managing metrics using Python Pandas library, Advanced Excel formulas.-Automating extraction process using Microsoft Edge’s Selenium tool.-Cleaning large data sets pertaining to workforce management, in-house made business applications and participation metrics. -Identify and remedy defects within the production process.-Compile and analyze statistical data using Power BI, Tableau and Excel.-Ensure that user expectations are met during the UAT/smoke testing process.-Drafting DBM procedures and process flows. -Investigating customer complaints and data issues.-Providing metrics pertaining to ARB/DRB security metrics and gap analysis. -Providing survey metrics via Qualtrics Analytics tool.

Baltimore, Maryland, Us

-Managing several databases including AWS Connect, Verint, and Microsoft Access.-Performing ETL to manage WFM metrics.-Developing Snowflake SQL data warehouse.-Cleaning data on a daily basis using Excel, Power Query, and Python Pandas library. -Leveraging Power Automate and Python to automate report downloads, and ETL process. -Constructing visuals using MatPlotLib, Plotly, Tableau, and Tableau Prep.-Interpreting data and relaying insights to business partners.

Columbia, Maryland, Us

-Reviewed and approved all data documentation issued to customer and system users.-Provided project-independent analysis and interpretation of evidence to validate compliance to established plans and processes in support of CMMI assessment activities.-Managed project’s metrics through sprint/initiative/program increment measurements.-Followed an Agile focused workflow using various business tools such as Confluence, Microsoft Office, and JIRA.-Built JQL, SQL filters, dashboards, and reports, generate data pulls using SQL syntax.-Analyzed data using aggregate functions, table joins, database comparisons.-Ran complex queries using MySQL, logical operators, string functions, and SQL joins for large datasets.-Used Python Pandas library to perform ETL.-Designed complex database schemas.-Used MySQL to store/track dates and times for data.-Developed macros to automate PIs using Python, Visual Basic, and Jupyter notebooks.-Ran/organized several scrum teams.-Experienced with Selenium/Selenium Webdriver and multi-browser execution.-Knowledgeable with Python data driven framework using Excel.-Experienced with Amazon Quicksight and Tableau.

Columbia, Maryland, Us

-Performed substantive, line, and copy editing of responses to Requests for Proposals, Requests for Information, and Sources Sought Notices in accordance with best practices, government requirements and company style. -Collaborated with the project manager, engineers, analysts, and the proposal manager under tight deadlines to guarantee all technical information is conveyed clearly. -Provided edits for other documents as needed (e.g., the employee handbook, policy manuals, brochures, and flyers); and have contributed to and edited content for meetings and various conferences regarding project status and future services.-BusinessObjects and 508 Compliance certified. -Had a Public Trust security clearance for Centers of Medicare and Medicaid (CMS)/Personal Identification Verification (PIV) Card.-Technical Writer for "One PI project." -Provided technical writer and 508 compliance review for training manuals, meeting minutes, user guides, proposals, status reports, and projects management release. Also responsible for compiling meeting minutes for a variety of conferences regarding project status and future services. Other qualifications are as follows:-Analyze business and IT requirements to determine types of documents needed. -Gather, analyze, translate, and compose technical information into clear, readable documents to be used by technical and non-technical personnel. -Collaborate with systems and development staff to collect and interpret technical information to create and maintain various project artifacts and end user documentation; including design documents, user guides and manuals, technical specifications, training materials, user policies and proposals.-Support development, review, and editing of new and existing documentation/artifacts for final delivery, publication, or dissemination.-Edit documentation from development and IT staff for a unified and consistent support.*Employee of the month April 2017.

Landover, Md, Us

-Consulted property owners on custom built closets, garages, home offices, kitchen pantries, and other storage units.-Scheduled free consultations and sold thousands of dollars’ worth of interior remodeling products.-Conducted a series of property searches in order to qualify property owners.-Negotiated price quotes, contracts, discounts, payment and budget plans.-Performed a variety of marketing tactics through inbound and outbound calls, internet, radio marketing, and direct mail.-Responsible for contacting future business clients and qualified over 600 future prospects.-Managed and trained new employees.

-Taught over 50 students ranging from age 6 to 60 to develop martial arts skill and values.-Motivate students to develop good health, discipline, self-defense, confidence, and humility. -Manage junior staff with teaching responsibilities.-Responsible for conducting private lessons, and renewal evaluations for students on a monthly basis.-Work within a team of instructors to conduct beginner and intermediate classes.

Chester, Pa, Us

-Helping Maryland, Virginia, and D.C. homeowners remodel the exterior of their home.-Identifying problems, and prescribing a solution for a variety of malfunctions on the exterior of a homeowner’s house.-Scheduling appointments for an in-home exterior remodeling estimate, and selling thousands of dollars’ worth of products.-Preparing and configuring financial documents, credit check slips, product documentation, and sales agreements.

-Created the “Alternative Dispute Resolution Program” for criminals who had committed small crimes.-Handled and analyzed evidence.-Provided input on the credibility of different witnesses on twenty different misdemeanor and federal court cases.

-Researched statistics and wrote over thirty different articles about UMBC sports teams. -Collaborated with a team of editors for article production on a weekly basis.

-Wrote detailed reports on a variety of information technology projects.-Constructed computer hardware in different Hubble Telescope offices.-Organized department’s equipment room.

-Head cell phone technician at age 16. -Repaired and replaced defective cell phone batteries, LCD screens, antennas, buttons, and speakers. -Installed flashing batteries, antennas, and keyboards. -Wrote a step-by-step guide on how to repair different cellular phones.

English, History, Sociology, Political Science

High School Diploma