Human Resources Medical
Resume:
Medical Data Analyst
Seth Margoshes
**** **** ********* *****, ***. 1133 Denver, 80230
***********@*******.***
Scientific and Medical Knowledge
. Particle Physics / Quantum Electrodynamics / Quantum Chromodynamics
. Chemical Bonding / Molecular Orbitals
. Nucleic Acids / Genetic Code / Biological Macromolecules
. Eukaryotic Gene Expression / Transcription / Translation
. Developmental Genetics
. Cell Organization / Structure / Cell Division
. Microbiology / Immunology
. Anatomy / Physiology
. Cognitive Neuroscience
. Pathologic Basis of Disease
. Care of the Medical Patient
. Cardiology
. Emergency Medicine
. Essentials of Surgery
7/2008 - 12/2008
Data Specialist - Advancement Services ('Central Records')
Yeshiva University Institutional Advancement Department
. Part of a small team responsible for processing, tracking and
maintaining the integrity and reliability of all philanthropic funds
and associated information pertaining to donor relations; using
Access, Excel and SunGuard Banner.
. Primary responsibility was insuring the accuracy of data integrity for
18 Colleges and Schools, including the Albert Einstein College of
Medicine.
4/2006 - 4/2008
Medical Data Analyst, Medical and Radiation Oncology (On Staffing
Assignment)
Montefiore Medical Center (The university hospital for the Albert
Einstein College of Medicine).
1. Programming: Development of Radiation Oncology and Medical Oncology
"Data Integrity and Tracking" Access database applications.
2. Medical Data Analysis & Interpretation: Creation of comprehensive
tools.
3. Assisted with the Fiscal 2007 and 2008 Budgets for a $100 million
business.
4. Using programming, created several "fully automated" applications to
facilitate an analysis of information spread across various hospital
databases. A comparison of line item data contained in VARIS, IDX,
and Eagle Billing was able to identify many millions of dollars worth
of unbilled CPT 'transactions'.
5. Studies using Precision BI / IDX to evaluate CPT trends and
characteristics intrinsic to treating Med Onc and Rad Onc ICD-9
disease sites.
6. Physician and Practice Performance CPT/RVU Matrix.
7. Study of the departmental relationships over time of physician
referrals, identifying opportunities to increase regional market
penetration in important target areas such as Breast, Prostate, Head
and Neck, and GU.
8. Created a full spectrum of financial tracking products to monitor and
analyze invoices, evaluate line item flow details, track collections,
and perform transaction/denial analysis.
9. Benefited from having an office as follows:
Department of Oncology Administrative Offices, - Medical
Oncology
Radiation Oncology Administrative Offices, - across from
"Residents Office"
Radiation Oncology Administrative Offices, - across from
"Medical Physics"
Department of Oncology Coding and Billing
10. Creation of a very comprehensive Head and Neck Clinical Database.
Tracking Tumors (Histology, Stage, etc.), Surgery (Dissection, Post
Op, etc.), Therapy (Radiation, Chemotherapy, etc.) and Outcomes
(Current Tumor Status, Quality of Life, etc.).
11. Responsible for collecting and analyzing medical and financial data
from multiple sources and
developing comprehensive reports and statistical information to be
used by management.
12. For a retreat by senior hospital management, prepared a detailed
report on all key clinical and financial trends taking place in the
Med Onc and Rad Onc practices during the prior ten years. Here is an
e-mail from the then Director of Medical and Clinical Oncology: "This
package is AMAZING! Thank you so much for your thoughtful and thorough
presentation and analysis of our business. I am eager to share this
information with the Cancer Center leaders to guide and drive
strategic planning discussions and stimulate ACTION for improvements
in day-to-day practice, operations and revenue cycle management. I am
tremendously grateful and appreciative of the energy, passion and
competence you bring to the department, our faculty and ultimately,
the services and care that we deliver to patients."
2/2000 - 1/2006
Coordinator of Office Services/Programmer Analyst A.T. Kearney
(Management Consulting)
. Managed the extensive New York Office Web Site using Microsoft Visual
InterDev, Active Server Pages, SQL, and HTML.
. Created "Tracking" and "Data Transformation" databases for consultant
projects.
. Handled Human Resources On-boarding for all new hires, in an office of
250 people.
1997 - 2/2000
Access Database Developer (On Assignments for Leading Staffing
Services)
. Acting "Database Operations Manager" at The Magazine Publishers of
America's Media Credit Association (MCA). Prepared the MCA Delinquent
Summary Report of Advertising Agencies and Direct Accounts reported
past due (totaling $600 million) using Data Junction, Access and
Microsoft SQL Server.
. Five months building extremely comprehensive Human Resources
Applications covering every aspect of HR functionality for Internet
information provider Medscape Inc.
. Seven months designing, maintaining, automating and documenting Access
databases at AT&T's World Headquarters. In a letter of "personal
thanks", AT&T managers said "Seth's technical skills in applying
database management and networking savvy were instrumental in ensuring
the integrity of our Access databases. We commend Seth's commitment
and know he will be a great asset as part of any organization."
. A year managing and documenting important Access databases at Credit
Suisse First Boston's World Headquarters in the Information Technology
Division.
. HTML Programmer at Prudential Securities in the Investment Banking
Division.
. Five months as an Access Programmer/Developer at SUNY Downstate Health
Science Center in the Human Resources Department migrating legacy
databases into fully automated Microsoft Access applications.
Prior to 1997
Vice President Institutional Research for four years at Copeland,
Wickersham, Wiley.
. Oil and Gas Investment Bankers. Assistant to the Chairman.
. Testimony to the Senate Committee on Energy and Natural Resources,
Washington, D.C.
. Selected by the Political Economy Research Center's Lecture Series for
Young Scholars (sponsored by the Liberty Fund, Washington, D.C.) to
participate in a series that "exposes highly promising young scholars
and intellectuals to internationally significant senior scholars."
Held at Lone Mountain Ranch, Big Sky, Montana.
. Study and Speech to the conference "The Future of Energy and U.S.
National Security", Washington, D.C.
. Speech to the Annual Meeting of the Independent Petroleum Association
of America, Dallas, Tex.
. Member of the National Association of Petroleum Investment Analysts
and the Petroleum Exploration Society of New York. Associate member
of the Society of Petroleum Engineers.
Research Analyst for eight years at Lehman Brothers Kuhn Loeb.
. Expert on Electric, Gas, Telephone and Alternative Energy industries.
. Consultant to State and Federal regulatory authorities, rating
agencies, the Edison Electric Institute, the American Gas Association
and the Independent Telephone Association.
. Founding member of Lehman's Public Utilities Regulatory Analysis
Service and LBKL's Public Finance Banking's Alternative Energy
Financing Team.
. Investment Banking.
Education
New York Institute of Finance
. Financial Accounting, Financial Analysis / Portfolio Management,
Corporation Finance, Money and Banking, Investment Banking, The Bond
Markets, Risk Arbitrage / Mergers and Acquisitions, Fed. Watching and
Interest Rate Projecting, Financial Futures, Yield Curve Analysis, and
Fixed Income Portfolio Management.
Programming
. Knowledge of C#, Visual Basic, Visual InterDev, SQL, C, C++, Java,
XML, XPath, XSLT 2.0, XQuery, ASP .NET, Web Services, JavaScript, and
Assembly.
. Knowledge of the Healthcare Data, Messaging, and Transport Standards
Stack (such as HL7, ASC X12, SOAP, and WSDL).
Lehman Brothers Kuhn Loeb six month long LBKL Management Training Program
(Sales/Trading/Corporate Finance).
B.A. from Hobart College
. Triple major in Economics, History and Philosophy.
Williston Academy (Easthampton, Mass.)
Lenox School (Lenox, Mass.)
Contact this candidate