SUMMARY

• 8+ years of experience in data analysis, decision support, data mining, data integrity and process improvement. Database queries, dashboard creation, pivot tables, VLOOKUPs, charts, graphs
• Experience in system conversion, implementation, manual testing, and SQL Server database tools. Extract, Transport, Load (ETL) process
• Experience in software and hardware asset management, auditing, documentation (Servers - Physical/Virtual, POS systems, ATMs, software licenses)
• Contract administration (risks, software licenses, maintenance, renewals, service level agreements, contract liability, warranties, patent, etc.)

TECHNICAL SKILLS

• SAS Financial Crime Suite
• Salesforce
• HP Asset Manager
• EPIC
• EPSi
• Allscripts
• Tableau
• CDCD Tracker
• Business Objects Info View
• Optum CAC Professional - LaunchPad
• Visual SourceSafe
• SAP
• SQL
• Oracle 10G
• SharePoint
• CRM
• MS Access
• MS SQL Server Management Studio
• Excel 2013
• Word
• PowerPoint
• Outlook
• Manual Testing
• Bug Tracker
• QA Director
• A/S 400
• Lotus Notes
• Lexis Nexis database
• Global Vision's Patriot Officer (GVPO)

PROFESSIONAL EXPERIENCE

Analyst

Confidential, Irving, TX

Responsibilities:

• Execute data cleanup and data manipulation tasks using Salesforce Data Loader, Access
• Implement membership data maintenance in Salesforce (adding, deleting, updating account info)
• Analyze enrollment form and validate data (COT, HIN, region, territory, network association, parent, etc.)
• Verify DEA (Drug Enforcement Agency) number information on DEA website for members
• Run Access reports and provide analysis and results

Confidential

Systems Analyst

Responsibilities:

• Worked on short-term assignment with the Bank Secrecy Act (BSA) Department to complete a data migration.
• Assisted in system conversion from Global Vision Patriot Officer system (GVPO) to SAS Financial Crime Suite system for AML (Anti-Money Laundering) activities. Uploaded SAR (Suspicious Activity Report) filings. Created pivot tables, VLOOKUPs. Utilized Power Point and Excel.
• Extracted monthly SAR/MTM alert decision files, Enhanced Due Diligence (EDD) and Customer Due Diligence (CDD) files, credit documents, negative news, and correspondence documents. Reviewed and uploaded current Annual High Risk Review documents, account statements, wire transfer details, transaction histories and check images. Performed data analysis on documents.
• Created folders for documents to be uploaded into SAS FCS system
• Created weekly/monthly Excel status reports. Worked on large data sets. Validated data
• Load (ETL) processes. Updated corresponding spreadsheets (SAR/MTM)
• Prepared Currency Transaction Report (CTR) batch spreadsheets
• Validated CTR data in GVPO for deposits, withdrawals, transaction date, transaction type, type of business, TIN, entity name. Verified Currency Transaction Report (CTR) historical files in SAS
• Confirmed exempt customers in SAS, closed CTR cases in SAS. Updated CTR spreadsheets

Data Analytics Consultant

Confidential, Atlanta, GA

Responsibilities:

• Worked in the Enterprise Intelligence Department, preparing daily audit reports (Payment & Adjustment Audit, Charge Audit) from EPSi database. Monitored variances. Ensured the integrity of the data.
• Responsible for producing Power Point reports and presentations.
• Tracked records read-errors generated in audit report. Provided key trends of patient data analytics
• Produced ad hoc data analytics to support hospital operational needs
• Used Excel to build pivot tables, flat files, trends, graphs for Patient Satisfaction Survey
• Pulled EPIC reports (Revenue, Discharges, Census, CATH, Emergency Department Visits and Surgery). Generated a LOS (Length of Stay) Rule Verification report. Utilized VLOOKUPs within Excel.
• Joined as a short-term contractor to work in the Network Engineering Department, monitoring and tracking project’s progress and handled any issues that arise.
• Hosted weekly project status conference calls in the South region for pending and new nodes status update. Executed and distributed project status meeting minutes
• Communicated with team members (construction group, field technicians, management) on nodes status. Tracked construction and capacity split, drop- ins
• Analyzed nodes split data in Tableau (i.e. target dates, delays, split type, grade rank, Video on Demand, High Speed Data, location/site, installation issues, design completion date, HFC, modem count, bandwidth, etc.) Identified and researched missing data
• Responsible for analyzing large datasets. Extracted data from Tableau and exported to Excel for data analysis.
• Performed data cleansing. Created ad hoc and weekly reports using VLOOKUPs, pivot tables charts and graphs
• Produced executive level reports. Input Parent/Child nodes in CDCD database.

Confidential

Quality Assurance Data Analyst

Responsibilities:

• Implemented the database migration testing process from ICD-9 to ICD-10. Responsible for Manual ICD-10 testing for implementation. Verified data completeness and transformation rules
• Analyzed code validation for the billing export and filter program
• Reviewed documents specification in VSS. Code validation
• Executed SQL queries in MS SQL Server Management Studio. Performed Backend database testing to validate the data using SQL queries. Deployed and installed database change scripts, provider configuration, billing rules
• Analyzed and compared data in ICD9 to ICD10 database. Created events in CRM. Updated business rules spreadsheet in SharePoint. Captured requirements from data. Created source data files
• Tested/validated CPT codes, Document IDs, Billing IDs, Provider IDs, Payor Codes, Payor Class
• Worked with development team to resolve defects, testability issues. Recorded test results, indicated pass/fail. Documented and communicated defects, failures, status updates, etc.