Oracle Developer, SQL Server, MS Office, Excel, Word, Access
Resume:
KEVIN K. WADA
** ******* ****** 973-***-****
North Haledon, New Jersey 07508-2625 **********@*****.***
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
**********@*****.***
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