RESUME

David Murotake

** ***** **** ** *******, CA 94930 Home: 415-***-**** Mobile: 415-***-****

Skills / Job Tasks:

** ***** ****, ****, ***, SSRS,COBOL, AS400, CL, JCL

Lead Programmer Analyst in Bi Reporting Group - Development, production maintenance of SSRS production Daily, Weekly, Monthly Reports.

Development of Data Marts TSQL ETL SSIS of various sources into centralized, consolidated data marts.

• Development of TSQL ETL SSIS of various sources into centralized, consolidated Data warehouse for BI Reporting and Analytics (Actuary, Claims, Accounting)

• Monthly report jobs reconciliation and validation post publication, SSIS job package scheduling, automation, and configuration, documentation, flowcharting of job dependencies, reconciliation of output tables and reports, development to production, change control, project life cycles

Reports include:

Agency Experience - premiums, exposure, loss statistical pivot triangles Agency Policies Profiling – loss ratios, Frequencies, Retention, Persistency, Attrition Agency Contingencies -- calculation profitability and commission rate calculations BI Analytics & Dashboards to Excel, tableau: Technical reports (Insurance related statistical analytics) Bureau data calls Ad hoc reporting and queries SAS conversion to SQL

• Development and Production support in: SSIS Visual Studio 2008 ETL processes to consolidate multiple in house user data (work with stakeholders and business analysts - underwriting, agency, accounting) and external data sources (ACH, EFT, subsidiary companies policy, premium and loss data) into a web based property and casualty enterprise system (ISCS)

• Design, analysis, coding, testing, business stakeholders requirements analysis, documentation of data dictionaries, workflow dependencies flowcharts, reconciliation of results, maintenance of continuing data integrity and management, life development cycle, agile scrum.

• Conversion and migration of AS400 mainframe DB2 database and COBOL Reports from legacy property and casualty system (WINS Wheatley) to a fully web based system (ISCS).

Conversion consisted of creating ETL jobs using SSIS 2008 to migrate 3rd party data and internal user data into weekly conversion updates into new web based system. ETL input would consist of flat files, text parsing, Excel, AS400 DB2, output to XML and SQL.

Work Experience:

Civil Service Employees Insurance Co 2121 N California Walnut Creek, CA Lead Programmer Developer Analyst Dec 1994 to current Education: Washington State University BS Computer Science Minor in Math