Medical Billing Sql Server
Resume:
Grigory Tamarkin
Ashland, MA 01721
*******.********@*****.***
SKILLS:
Experience in system and business analysis, database design, data pipelines, ETL/ELT, software development, implementation, and support.
Industry experience in Accounting, Banking, Payroll, Financial Applications, Manufacturing, Airlines, Transportation, HR, Medical billing, Insurance and Healthcare.
Lead creation, development, and support of enterprise management systems: CRM, ERP, ETL.
LANGUAGES: .NET, C#, VB, ASP, SQL, Python (Pandas, NumPy), Visual FoxPro
RELATIONAL MS SQL Server/Azure SQL Server, Redshift, Oracle, DATABASES: MS Access, Visual FoxPro.
OTHER: Web services, XML, HTML, CSS, Crystal Reports, SSRS, SSIS, Excel Automation, VBA, PowerShell, AWS S3, Azure DevOps, Salesforce, Desk.com, Agile/Scrum, Tableau, X12, SaaS, Data Warehouse
PROFESSIONAL EXPERIENCE:
September 2022 – September 2023 CSE Insurance Group Glendale, CA Data Engineer
Member of Business Intelligence Team responsible for:
The development and support of ETL and data integration processes
Loading insurance information into data warehouse
Accounting reports generation and reconciliation.
Redesign of Claim Toolkit application backend including data mapping, data warehouse design and architecture, ETL, data pipelines Tools: MS SQL Server, SSIS, Redshift/AWS, PostgreSQL, DBeaver, VS Code, MS Excel/VBA, Tableau, Python, AWS S3
August 2017 – June 2022 Hayes Management Consulting Wellesley, MA Client Support Engineer/Data Engineer
Member of MDaudit (Medical Billing Audit) Product team responsible for the data integration
(MDaudit and medical billing applications), client support and new client implementation, software updates
Direct support of customer technical issues
Design and develop data integrations
2
Maintain, configure, deploy and upgrade MDaudit client-server software
Develop SSIS packages for ETL processes between customer systems and MDaudit databases
Migrate MDaudit software and databases
New client installation, configuration of databases, SFTP and processes to load medical billing data for SaaS version of MDaudit
Reconciliation reports generation
SSO implementation
Job description
Support client users on the technical aspects of troubleshooting and maintaining product components
* Support interfaces between client data repositories and MDaudit
* Provide support to clients by responding to inquiries and triaging issues
* Provide prompt feedback to clients’ questions and issues as per SLA commitments
* Document all issues and resolutions which are processed through the support area Tools: MS SQL Server 2008 - 2019, SSIS (Visual Studio/Data Tools) 2010 – 2017, Visual Studio 2017/C#, MS Access 2010 – 2016, VBA, PowerShell, Cerberus, Okta, AWS S3, X12 Studio (835, 837I, 837P)
March 2012 – August 2017 IBM/Kenexa Littleton, MA
Professional Service Engineer, Senior Consultant
Developed and supported a variety of BrassRing (Applicant Tracking System, SaaS) integrations with the client’s HRIS and client’s vendors including development and consuming web services and EDI.
Served as a primary client contact on a number of projects as part of complete application life cycle starting from a project kick off and following though all the way to post go-live support
Tools: .NET, C# 3.5, ASP.NET, MS SQL Server 2008, TFS, XMLSpy. November 2010 – January 2012 Monster Worldwide Cambridge, MA Software Engineer
Developed and supported Job Seeker and Employee Seeker applications. Tools: .NET, C# 4.0, ASP.NET, MVC, JavaScript, MS SQL Server 2008, Perforce. September 2005 – June 2010 FundQuest Boston, MA
Software Engineer
Developed and Supported Multiple Investment Portfolio Management Applications.
Provided customization, enhancement, and support for the business-critical multi- component Proprietary Portfolio Accounting system.
Analyzed, Designed, and Created system enhancements for new clients in support of their trading, transaction processing, fees, and performance reporting needs.
Developed and implemented an internal web-based online reporting system. Tools: .NET, C# 3.5, ASP.NET, MS SQL Server 2000/2005, Visual FoxPro 7.0, SQL Reporting Services, MS Visio, JavaScript, Excel/VBA, XML, VSS. 3
October 2004 – August 2005 Teksystems/Hartford Life Insurance Hartford, CT Systems Consultant
Provided support and enhancements for financial applications.
Upgraded multiple financial applications to VFP 8.0.
Provided production support of reconciliation subsystems for General Ledger, Mutual Funds, 401K, 529 College Saving, 529 Prepaid, Offshore, and other products.
Developed enhancements and designed reports for existing business processes.
Lead development of a 403B(7) reconciliation subsystem.
Developed data processing verification utilities for .Net/Oracle conversion. Tools: VB.NET, Visual FoxPro 8.0, Oracle 8, VSS 6.0, Autosys. July 2001– July 2004 Kane Screens Inc. Kane, PA
Systems Manager
Architected and lead the support of ERP, CRM, MRP, and production drawing systems.
Lead the Support of the ERP System.
Suggested, designed, and developed a Report Center for accounting, financial and sales departments.
Architected and developed an MRP system that automated sales order planning and fulfillment.
Architected a CRM and Quoting System and designed it to interface with existing ERP application, Excel Spreadsheets, and up to date expense formulas.
Designed and developed a DB system that simplified production drawings management. Tools: Visual Basic 6.0/.NET, Visual FoxPro 6.0, MS Access 97/2000, Excel/VBA, MS SQL Server/2000, Crystal Reports 7.0/8.0, IIS 5.0, ASP 3.0/.NET, VB Script, HTML, XML. EDUCATION:
Moscow State Technical Univ of Civil Aviation, Moscow, Russia. BS in Automation and Computers
Contact this candidate