OBJECTIVE:

To obtain a position of data/report or research analyst

SUMMARY:

• Provide business process, data analysis and research, make reports and pivot - tables for program performance and payments control;
• Manage data integration, check data consistency, design database structures and tune query performance;
• Have statistics and cohort data analysis, presentation, tutor and technical writer experience.
• Have excellent root cause analysis skills;
• Installed and administrated OS (Windows server and workstation, Windows 9x/2000/XP);

TECHNICAL SKILLS:

Develop and support applications, utilizing next products and technologies: KNIME Analytical Platform, MS-SQL 2014 & SSIS, T-SQL, MS-Excel 2016(Microsoft/Power Query)/MS-Access, ODBC/JDBC, MS-Visio, Navision, VBA, PowerBuilder, FoxPro, Informix RDBMS & Toolkit, NewEra, Btrieve, ADABAS/NATURAL, ERwin, ProcessAnalyst;

EXPERIENCE:

Confidential

Sr. Data Analyst of Compliance

Responsibilities:

• Being a part of Compliance Department report to AVP of Regulatory and Accreditations on department activity (number of audits, coding errors distribution, failed audits, so on); providers compliance and automate non-compliance detection process.
• Help to make future audit schedules and statistics based on audit data.
• Support Conflict of Interest web application on data management and reporting.
• Extract providers records, access logs to support compliance or HIPAA investigations.
• Provide raw data, rule based or fuzzy match detection and reports for ongoing as well as periodic department audit and data mining activity.
• Analyze physicians schedules, prescriptions, labs and coding dynamics to reveal practice issue or improvement.
• My reports support CPT codes and diagnosis analysis, E/M codes utilization in comparison to the CMS Medicaid data, peer comparisons, allowed CPT codes combinations and sequences analysis, claims analysis, RVU based analysis, incident to billing, modifiers utilization, double billing and so on.
• Provide statistics on physicians activity (overage number of visits per day, labs, schedule II drugs prescriptions per patient, number of returned patients per month, controlled substances self or family members prescriptions, providers billing after termination so on).
• Department automation environment implemented utilizing SQL 2014, MS-Office 2016 and KNIME Analytical Platform. This allows avoid manual data processing, reporting and monitoring compliance parameters in short time with minimal errors.
• Configured EMR data sources for NextGen, Allscripts/IDX and Epic/Clarity/Caboodle databases.
• Parameterized reports are pivot-tables or banded reports based on data marts from production DB or data mart looking up local reporting DB supported by some ETL processes. Providers Audit DB is implemented as MS-Access application.
• KNIME applications for data blending, million rows sources processingand statistics calculation (ex. Annual Conflict of Interest analysis based on CMS payment report; identification of hit and run billing tactics with Z-score ; breaking glass setup control using fuzzy search).

Confidential, Brooklyn, NY

Systems Analyst Manager of Operations / DBA

Responsibilities:

• Responsible for on time delivery and automation of company internal and external weekly and monthly outcomes and performance reports, staff performance scoreboard, ICD9 outcome reports, Confidential, cohort data analysis and other analytical and statistical reports for Confidential program.
• Also, make research and root cause analysis on company data by different services, periods of time, locations, client demographic, seasonality and report to Deputy Directors, CFO or Executive Director.
• Provide operation reporting tools for heads of departments based on Access / Excel 2010 drill-down pivot-tables or reports with parameters.
• Support company weekly payment reconciliation process and milestone achievement/earning verification.
• As needed coordinate data exchange structure with HRA, CAS, AllSector and other partners.
• Take part as project manager for internal software development to automate clients job retention process.
• Automate / program and support all FTP / ETL data feeds utilizing Stored Procedures, BCP, SSIS, Access and linked servers.
• Design and maintain company MS-SQL / Access based data mart and data feeds. Collect projects requirements. Utilize Visio to document data flow and database structure.
• Set end user security and authentication profiles and ODBC data sources. Cooperate and coordinate with IT department on analytical server support.
• Take part in company initiative on training personal to analyze data using Access / Excel with ODBC data sources. Prepare printed instructions and conduct classes.
• Redirected company spreadsheet data collection tradition towards of automation and BI principles.
• Converted manual reports to refreshable pivot-tables, substantially improved reporting time and accuracy. Added numerous operations analytics reports for daily, weekly and monthly business control.
• Provided historical company outcome numbers to make company 2011 contract.
• Under supervision of Operations Deputy Director I wrote and deployed automated payments control including offline billing report generation and reconciliation applications for company’s Wellness and SSI departments.
• My research of SSI department payments from 2005 revealed outstanding amount of about $1 million.
• Together with HR and Accounting departments automated company quarterly incentive bonus plan.
• Transferred company MS-Access/SQL 2000 data marts and DTS packages to MS-SQL 2008 platform.

Confidential, Mt. Vernon, NY

Support Programmer and DBA

Responsibilities:

• On a daily basis control corporate data base (more then 300 GB), terminal servers and Navision application performance.
• Write Navision sales / warehouse statistics reports and data ports using C/SIDE, T-SQL, Access and Excel as needed.
• Provide data exchange between proprietary company application, other mergers and Navision.
• Map and load ADP payroll records for company and mergers to departments GL accounts.
• Support Helpdesk requests resolving slow performance, locking, advice on errors and other problems. Take appropriate actions on problems or report to senior programmer or contractors.
• Set Navision user roles/permissions and SQL Server security.
• Load / Extract data from/to Navision and directly against SQL Server using different tools (Batch Queries, stored procedures, SSIS, Linked Servers, ODBC) and sources (Excel, CSV, ADP payroll files).
• Regularly check scheduled jobs on Navision and SQL SSIS packages.
• Regularly collect statistics on table’s fragmentation and reindex/update statistics on them.
• Was part of upgrade Navision project from version 4 to 5.
• Advice to management necessary changes on configuration or purchase of servers, stations and software.
• Install service packs, updates and make necessary configuration on SQL Server 2005, Reporting Services, Analytical Services and Integration Services.

Confidential, New York, NY

Programmer Analyst and DBA

Responsibilities:

• Analyze company business processes (manufacturing / inventory / accounting / EDI) to maintain and support applications and databases in correspondence to business changes and its effectiveness.
• Integrate different projects by data, support ETL operations and data transfers by DTS and FTP.
• Provide support and bug fixing for Navision 3.6 based manufacturing project from 2004.
• Helped to transfer style design, production orders tracking, inventory control, EDI and invoicing to Navision.
• Make complex AR, Inventory, capacity planning, work in progress and tracking reports.
• Use MS-Visio to make process charts, MS-Access, MS-Excel, PowerBuilder 6.5/PFC and MS-SQL Server 2000, transact-SQL, DTS to develop and support applications and reports.
• Make strategy for validation of data, logical and physical integrity. Clear data errors
• Maintain lookup tables, indexes and database logs. Resolve locks.
• Periodically analyze SQL Server and applications performance by SQL Profiler.
• Optimize applications by transferring code to stored procedures, user functions, triggers.
• Change databases structure. Upsize MS-Access databases to MS-SQL.
• Make backup/restore of company databases, create and schedule DTS packages.
• Provide data bases and Navision security, set user accounts, access level and rights.
• Manage corporate antivirus server (Symantec corporate) and clients. Daily check security risk and spam.
• Prepare pictures for company web site and presentations in Photoshop.
• Install and support client / desktop applications and OS (Win 2000 / XP).
• Configure and administrate company Windows NT based LAN, Internet/DSL connections and user’s E-mails (TCP/IP, DHCP, Exchange/Outlook, backup/restore, user’s accounts).
• Install and setup equipment (PC, NICs, hard drivers, HP laser printers, print servers, scanners, hubs, wireless access points, cameras) and applications (Navision, GE Desktop EDI, ASN Plus).
• Clone PC by Symantec Ghost.
• Help over PC and peripherals troubleshooting and equipments acquisition.

Confidential, New York, NY

Programmer Analyst and Systems Analyst

Responsibilities:

• Optimized and add new functionality to Jewelry and Accounting projects utilizing FoxPro, PowerBuilder and SQL Anywhere.
• Migrated project from Foxpro 2.0 to Foxpro 2.6. Solved year 2000 problem.
• Transferred databases from NetWare to Windows NT server. Optimized databases structure. Provide third-party applications support. Updated company’s Web site information and ASP code.
• Provided non-typical users informational requests by direct connection to databases utilizing SQL, FoxPro, MS-Access and MS-Excel.
• Configured and administrate company Windows NT server, LAN and Internet/DSL connections (TCP/IP, DHCP, Proxy Server, IIS, PC Anywhere, backup/restore, user’s accounts).
• Installed and setup equipment (PC, NICs, hard drivers, printers, scanners, cameras) and applications.
• Provide PC and peripherals troubleshooting.

Confidential

Windows NT and Network Administrator

Responsibilities:

• Installed and administrated all Windows NT servers and workstations, LAN equipment and applications (TCP/IP, DHCP, backup/restore, user’s accounts; antivirus, MS-Office, Interbase, bank applications, 3Com equipment, HP network printers, scanners).
• Administrated Web-based Client-Bank system (RAS, IIS, appl.) and worked up end-user’s documentation.
• Administered corporate mail, Telex, Internet and FTP connections.
• Provided technical support for MS-Office and applications esp. Client-Bank, Excel accounting, MS-Access reporting and MS-Outlook.
• Troubleshot PC and peripherals.

Confidential

Windows NT and AS/400 System Operator

Responsibilities:

• Installed and supported Windows NT workstations and applications (SNA clients, MS-Office, Interbase, bank applications, antivirus).
• Controlled SWIFT outputs through SNA connection.
• Fulfilled duties of end of day operator.
• Provided technical assistance for MS-Office, printing and applications, and worked up user’s documentation.
• Troubleshot PC and peripherals.

Confidential

Programmer Analyst

Responsibilities:

• Designed and implemented Accounting and ETL applications on Excel, VBA, FoxPro, NewEra 2.12 and ODBC library, PowerBuilder 5 including DBs design for Informix DS 7.2 RDBMS.
• Administrated Internet and E-mail (Wingate Proxy Server; Novell ManageWise, MS-Outlook).
• Consulted end-users (Win95/NT, MS-Office and applications).
• Worked up technical and user’s documentation.
• Troubleshot PC and peripherals.