KEVIN K. WADA

** ******* ****** 973-***-****

North Haledon, New Jersey 07508-2625 acwei2@r.postjobfree.com

COMPLAINTS ANALYST

Technical and detail oriented analyst adept at analyzing and adjudicating client claims at Express Scripts. Created Excel VLookups and Pivot tables extensively for reporting results. Wrote numerous Excel macros to format spreadsheet reports. Strong knowledge of Oracle and several other databases, writing complex queries, extracting and integrating data, creating views, cleansing data. Served as primary liaison with business stake holders, elicited business requirements, transformed them into technical requirements. Highly analytical and strong problem solver. Established track record of improving productivity, providing accurate and timely data, and effectively responding to users.

PROFESSIONAL EXPERIENCE

Boehringer Ingelheim, Ridgefield, CT January 2016 – March 2016

Oracle PL/SQL Developer

Performed fuzzy matching between a standardized customer file against a non-standard customer file. Utilized data munging.

Maintained PL/SQL changes on DDD Outliers.

Interpret SQL scripts into data flow documentation.

Express Scripts, Inc., Franklin Lakes, NJ June 2014 – March 2015

Financial Analyst

Analyze and reconcile variances between intended and actual payments for claim level data, utilizing Access and Excel (VLookups and Pivot tables extensively).

Utilize Excel macro/BI tools to retrieve, upload and export datasets from DW.

Pearson Inc., Upper Saddle River, NJ June 2013 – March 2014

Database Analyst / Developer

Extracted and analyzed international monthly sales data from Oracle database.

Liaison with oversees offices. Received and processed international orders and sales to pay royalties and commissions.

Qualcare Inc., Piscataway, NJ January 2012 – May 2012

Business Objects Developer

Designed customized SQL Server stored procedures for Crystal reports for medical insurance claims, cost analyses - by patient, by ICD-9 classification of diseases, by procedure. Performed Business Objects administration – scheduled reports via Launch Pad (Infoview), promoted reports to appropriate folders.

FYI Business Solutions, Parsippany, NJ April 2010–September 2010

Consultant / Database Developer

Sirius XM Radio

KEVIN K. WADA

acwei2@r.postjobfree.com

973-***-****

PAGE TWO

Converted SQL procedures from Oracle and SQL Server to Teradata as part of database conversion

Citigroup, Warren, New Jersey February 2004-December 2008

AVP / Technical Specialist

Supported and maintained Essbase environment of 70 cubes for Database Management Group (GDMG). Substantially improved Essbase environment productivity by improving UNIX scripts and optimizing cube performance. Served as primary liaison for OLAP environments.

Saved 12 man-days per month or 86% by streamlining UNIX shell scripts (ksh) reducing monthly load allowing business users more time to analyze information.

Implemented new Essbase environments by simultaneously upgrading existing environment of 70 cubes and 100+ users to version 6.5.5 and migrating to scalable Solaris SunFire 480 server.

Designed, managed, and documented workflow processes and administration procedures in SharePoint 2007 MOSS. Created team sites and assigned permissions.

Maintained Excel chargeback spreadsheet. Included V-Lookup, pivot table, formulas.

Pearson Education, Upper Saddle River, New Jersey June 1983-February 2004

Transitioned to Pearson Education as a result of several acquisitions and mergers

Business Systems Analyst January 1993-February 2004

Developed expertise on Business Objects, Oracle databases, Essbase, Extract, Transform, and Load (ETL) tool Informatica, and UNIX scripting. Maintained and developed secondary and higher education datamarts that supported 2,000+ users. Served as primary liaison with business stake holders. Elicited, analyzed and documented business requirements from stakeholders.

Designed several applications from gathering requirements to technical solutions using Oracle and UNIX. (E.g. CIMS, elementary education feed, Higher Education / College data feed and universe, Essbase sales cube feeds).

Designed and maintained Informatica data mappings and UNIX shell scripts to populate K12 and Higher Ed Oracle datamarts.

Designed numerous Business Objects reports.

Programmer Analyst June 1983-January 1993

TECHNICAL SKILLS

Database: Oracle, SQL Server, Teradata, MS Access, DB2

Software: Microsoft Office, Excel, Word, UNIX Shell Scripting (ksh), Autosys, Microsoft Office SharePoint Services 2007 (MOSS); SQL*Plus, SQL Loader, Toad, FTP.

BI Tools: Essbase, Informatica, Business Objects, Crystal Reports

EDUCATION

B. S., Mathematics, cum laude, Tufts University, Medford, Massachusetts

Contact this candidate