Christopher Tan Email & Phone Number

San Antonio, Texas, Us

Bank Operations Analytics: Consumer Lending Operations Information StewardDevelopment, execution, and supervision of Data Management/Governance activities such as Report Certification, Information Sensitivity/Classification, Data Quality, Lineage, Delivery, Sharing, Privacy, Retention, Architecture, Metadata/Reference Data Management, and Model Risk Management.Partnership with IT, Data Governance, Business, Engineering, AML, Fraud, Credit Risk, Legal, Product and various teams and stakeholders to identify, manage, monitor, and proactively control risks associated with business data operations and technology.Tools used include Snowflake SQL/NoSQL (Cloud RDBMS), Python, SAS, Oracle, Excel, Tableau, JIRA, dbt, Hadoop, Kafka, Information Governance Catalog (IGC), Alation and other big data cloud RDBMS and Data Governance / Catalog / Reporting / Data Engineering tools to query, model, and manage structured, semi-structured and unstructured data and build tools for automation.

Indianapolis, Indiana, Us

Commercial Risk AjustmentBusiness data analysis, revenue & data submission cycle management, data governance, stewardship, and process improvement of risk adjustment opportunities in highly collaborative Agile-Scrum team utilizing data science methodology, cloud RDBMS, and Big Data tools including Teradata SQL, Informatica, SAS Enterprise Guide, MS SQL Server, MS Access, JIRA, IBM DB2, and more to realize RA value of multi-million dollars annually within the HHS-HCC Risk Adjustment model across 19+ HIOS’s (legal entities).Querying, programming, development and reporting of enrollment, medical, and pharmacy claims & encounter data (prospective and retrospective) in Enterprise Data Warehouse (EDWard), Risk Management Database (RMDB), and numerous Anthem source systems (ISG, WGS, Decare etc.) maintaining compliance with Anthem business rules, CMS (ie. EDGE server business rules), HIPAA privacy regulations, and third-party audit requests (ie. Sarbanes-Oxley audits).Other tasks include maintenance and design of SAS programs, RADV (audit), ETL, UAT, managing metadata, vendor management, scripting, and bridging gaps between IT and Business users to manage Agile sprints & user stories (with Product Owner) while collaborating with Actuarial Analytics, Coding Teams (ICD-10), Health Information Manager, Data Warehouse Consultants, Tech/Engineering Leads, and Kanban teams.

Indianapolis, Indiana, Us

EDI Reconciliation & Data Analytics• Created databases to track and resolve payment and enrollment discrepancies, perform data mining/cleaning, summarize statistics, analyze, QA, A/B test, automate and report using SQL, RDBMS’s such as MS SQL Server, MS Access, Excel, SharePoint, MS Office• Created ad hoc reports, managed various system roles, and expert level functions in Anthem billing and data management systems including ISG/Mainframe, WEM, BPM, Facets, Solution Central, JIRA, PEGA, BPM and more• Health care data analytics of capitation, reconciliation, and work flow with 834 enrollment/disenrollment, 820 premium payment transactions (federally mandated ASC X12 standard) ensuring HIPAA compliance in coordination with business and IT stakeholders.Select Achievements• Exceeded expectations in the Innovative category of 2020 Performance Review• Proposed and supported business initiative in line with department goals to increase department efficiency of issue resolution through data analysis, A/B testing, team collaboration and operational experience• 2020 Self Learning: 22 Credit Units in B.S. Data Management and Data Analytics + 3 SQL industry certifications: MTA Database Fundamentals, MCP Querying with T-SQL (70-761), Dataquest.io SQL Fundamentals earned within a calendar year

Indianapolis, Indiana, Us

Manual Reconciliation (EDI ASC X12 834 Benefit Enrollment, Maintenance and 820 Payment Order/Remittance transactions)• Responsible for providing technical direction, guidance and resources to claims, customer service, reconciliation, audit, and membership associates on a day-to-day basis in support of recon and data analytics team• Complex case research and resolution. Reviews, interprets and maintains records of service level, quality, accuracy, and productivity• Facilitated multi-team meetings and provided operational training and mentorship• Reviewed department policy and procedure manuals for accuracy; worked with training department to ensure procedures and policies were accurate and completeSelect Achievements• Served as SME: played key role driving and supporting adoption, training, deadlines, and manual maintenance of multi-million dollar EDI data reconciliation project in collaboration with multiple teams and functions.• Exceeded Expectations Overall on 2019 Performance Evaluation• Created a repository of policy and procedures that were maintained and regularly referred to by multiple teams including analysts, auditors, membership, billing, reconciliation and retro maintenance team leads improving collaboration and communication department-wide across over 65 individuals.• Identified and closed gaps in processing by collaborating with technical teams, documentation, and project management platforms such as JIRA Biz

Indianapolis, Indiana, Us

Membership Rep I,II & III (Senior)Enrollment, Billing, Maintenance and ReconciliationAnthem, Inc. (Woodland Hills, Thousand Oaks, Work-at-Home) October 2013 – August 2018• Increasing responsibility in various functions of enrollment and billing including exchanges reconciliation, auditing, 834 policy maintenance, complex research and resolution, system testing, and clean up reports• Positioned as a lead rep for California 834 Maintenance in company transformation to Lean Agile with responsibilities such as monitoring workflow, assigning, auditing, assisting associates, and making recommendations to drive process improvementSelect Achievements• Received a VIA Award (Values in Action) in June 2018 for training initiatives and process automation in ISG/Mainframe• Represented team as Open Enrollment Ambassador• Project support, data analysis between IT and Business departments in maintenance of ANSI/EDI 834 Enrollment Implementation and Transactions• Consistently promoted (4 times) from Data Entry Temp, to Rep I, II & III, and Operations Expert• 2014 Above Target & 2015 Exceeded Expectations in Overall Annual Performance Reviews

Hanover, Maryland, Us

• Enrollment, Billing, & Reconciliation on WellPoint (now Anthem) Mainframe and web based systems in support of Individual line of business.Select Achievements• Completed training as top of class in exam scores out of 175+ new hires and temp agents

• Door to door residential sales for Verizon FiOS• Trained associates on best practices and sales processes• Exceeded weekly sales quotas

• Drove inbound sales and phone calls via web based ads• Presented Unified Communications and Data Center Technology Solutions• Top salesman for 4 months• Opened and managed accounts throughout the United States in CA,TX, FL, & KS

• Outside B2B and B2C sales of flooring and remodeling• Warehouse inventory management with Excel (15,000 sq ft warehouse, 3 installation teams working 6-7 days per week)• Learned how to install and quote project estimation costs for various types of hardwood and laminate flooring• Drove trucks delivering multi pallet wholesale orders across the LA area maintaining business relationships and sales

• Negotiated and built relationships with whole-sellers at the Philadelphia Wholesale Produce Market and farmers in Southern NJ• Supervised logistics, stock, display, road signs, and pricing• Accounted for expenditures using Excel

• Data entry, general office duties, insurance quotes, and customer service

Bachelor Of Science - Bs, Data Management/Data Analytics

Wgu - Data Analyst Nanodegree