Experienced business analyst who thrives on learning and demonstrates a history of producing accurate, timely reports, meeting stringent healthcare insurance guidelines over the past sixteen years while acquiring a multitude of skills in program and report development, trending, analysis, process automation, web development, project planning, implementation, EDI, and accounting.
Business Analyst adept at process automation, testing and optimization. Excels in data integration using tools such as SAS, SQL Server, Crystal Reports and Talend Studio.
application development, including coordinating ground-up planning, programming and implementation for core processes.
Flexible and versatile Business Analyst specializing in developing innovative solutions to organizational problems. In-depth knowledge of Talend and asset tracking software.
Crystal Reports 2011
SAP Business Objects
SQL Server 2008
Microsoft Access/Excel/Power Point/Project/Visio/Word
Business process improvement
User acceptance testing
Strong analytical skills
Structured query language (SQL) expert
Strong collaborative skills
Optimizing and performance tuning
Senior Business Analyst May 2008 to CurrentOptumInsight － Phoenix, AZ
process improvement initiative for Departmental Operational Reporting that
entails converting all existing excel reports to Crystal Reports 2011,
optimize existing SAS programs to improve run times by 75%, consolidate 40
Access databases into 6 and then migrate to SQL server, develop jobs in
Talend Studio to run monthly processes on a schedule, which ultimately
resulted in reducing report production time from 25 days to 5.
programs to eliminate the need to generate and manipulate data manually in
TOAD, Access, and Excel.
Involved in analyzing data, developing, testing and
deploying to production after the user approvals.
complicated business reports using Cross-tabs, Drill Downs, Sub reports
and customized conditional formatting within Crystal Reports 2011 to conduct
a deeper analysis and to easily identify anomalies within the data.
analyze monthly client facing reports prior to the service level agreement
deadline to ensure internal systems are functioning properly.
process improvement changes and train co-workers on process changes
process boundaries and determined opportunities to automate processes and
Business Requirement Documents (BRD) for new client implementations and
Conduct User Acceptance Testing (UAT) and Production Acceptance Testing (PAT)
Project Coordinator / Electronic Eligibility Analyst August 2005 to May 2008PacifiCare － Phoenix, AZ
Designed, developed, and delivered an average of four customized health insurance enrollment websites per month as well as coordinated up to ten website renewal modifications for existing clients.
Created and tested system mapping (using 834, QBE, RIMS EMLoad, EDI layouts).
Constructed a 30-60 day timeline detailing the implementation project plan for the client, broker and sales.
Retrieved, tracked, and monitored an average of 25 production files from ftp server daily, uploaded into legacy systems, manually worked fallout, and addressed file layout or mapping issues.
Accounts Receivable Team Lead November 2003 to August 2005PacifiCare － Phoenix, AZ
Supervised 8-12 employees with daily work, assigned job duties, hired and trained new employees.
Allocated funds to general ledger for Mid-Large/National Accounts totaling $5 million per month, analyzed areas of over or under payment on an individual member level and worked the aging for each account.
Gathered and prepared A/R statistics to conduct reserve analysis for month-end close meetings.
Secure Horizons Billing Specialist March 2002 to November 2003PacifiCare － Phoenix, AZ
Maintained and reconciled 50,000+ Medicare member accounts using general ledger and aging reports.
Initiated and completed the customer late payment process on a monthly basis using Microsoft Access.
Contract Administrator April 2001 to March 2002PacifiCare － Phoenix, AZ
Eligibility Associate July 2000 to April 2001PacifiCare － Phoenix, AZ
Data Entry Specialist / Payment Posting July 1999 to July 2000NovaCare, Inc － Phoenix, AZ
Data Entry / Mailroom Team Lead / Claims August 1998 to July 1999Premier Healthcare of Arizona － Phoenix, AZ
Bachelor of Science : Global Business, May 2008Arizona State University － Glendale, AZEmphasis in Finance
Associate of Science : Accounting, August 2004Phoenix College － Phoenix, AZ
Certified Talend Enterprise Big Data Consultant
MongoDB (MongoDB 2.4 - M101JS: MongoDB for Node.js Developers)