Comprehensive knowledge and experience of MS Access, SQL, Visual Basic and database reporting. Experience with design, development, implementation and troubleshooting of application software in multiple programming languages. Solid credentials in data mining, data analysis and data query in a large data environment Strong ability to perform both business and technical analysis and provide innovative and effective solutions. Experience with analyzing complex business processes. Strong analytical and problem-solving abilities.
Education and Training
B.S : Computer Information System, Business System AnalysisCalifornia Polytechnic University － Pomona, CAComputer Information System, Business System Analysis
MS Office Suite, MS Access, MS Excel, MS SQL, MS SQL Server Reporting Services, MS SQL Server Integration Services, Crystal Reports, Visual Basic and Windows.
accounting, Streamline, Ad, budgeting, business analysis, business processes, business systems, Crystal Reports, customer service, data analysis, data mining, database applications, databases, Database, direction, senior management, General Ledger, information systems, Access database, MS Access, MS Excel, Excel, MS Office Suite, Windows, month-end closing, needs analysis, payroll, quality assurance, reporting, research, sales, scripts, specification, MS SQL Server, MS SQL, SQL, tables, technical assistance, training materials, troubleshoot, Vendor Management, Visual Basic, workflow
Senior System Consultant January 2006 to CurrentKaiser Permanente Downey － Rancho Cucamonga, CA
Created and executed SQL statements in both SQL production and development environments.
Design, write and implement application database code objects, such as tables, views, functions, store procedures.
Developed SSIS packages to transform data for data analysis and extraction.
Maintained and translated reports from MS Access into SSRS Design and develop Access database applications including Check Posting Database, Lockbox Reconciliation Database, Vendor Management Database, Rework Database, and Cost Containment Overpayment Recovery Database.
Perform business analysis, business area assessment, user needs analysis and business systems design for major projects.
Develop and perform queries independently and at direction of management.
Perform technical and analytical work.
Analyze and enhance various complex business processes for retro contract, check posting and Rework.
Develop and produce monthly reports including cost containment, recovery scorecard, retro contract, and provider dispute for senior management.
Provide Ad Hoc analysis and reports to management and various departments, analyzed and researched discrepancies from reporting data.
Streamline data gathering and distribute reports to various data users.
Senior Reporting Analyst May 2005 to January 2006United Healthcare － Cypress, CA
Maintained and enhanced existing database applications.
Automated and developed reporting applications and databases.
Performed data mining for claim cost containments.
Built complex queries to analyze patient member information between claim system and other membership information systems.
Provided Ad Hoc analysis and reports to senior management and various departments, analyzed and researched discrepancies from reporting data.
Created and produced monthly reports for management.
Financial Analyst January 1999 to January 2004IQ InfoQuest Computers, Inc － Fremont, CA
Designed and maintained database program via MS Access and Excel.
Developed and performed queries independently and at direction of management.
Created and enhanced reports for payroll, sales, operations and budgeting.
Analyzed and consolidated month-end and quarterly reports.
Performed technical and analytical work.
Proactively work on various research projects.
Accounting Manager January 1995 to January 1999IQ InfoQuest Computers, Inc － Fremont, CA
Managed and oversaw daily accounting procedures.
Responsible for General Ledger administration and month-end closing.
Implemented and enforced accounting polices and procedures.
Managed various special accounting projects.
Business System QA Analyst January 1993 to January 1995Wells Fargo Bank － San Francisco, CA
Created and executed quality assurance reviews, test plans and test scripts.
Analyzed, tested and certified application-specific software.
Performed user acceptance testing and troubleshoot systems-related operational issues Provided technical assistance in identifying and resolving complex test problems.
Logged, tracked and verified resolution of software and specification defects.
Assisted ongoing production and workflow improvement efforts.
Managed small projects and small segments of larger projects.
Developed procedures and training materials to maximize efficiency and customer service.