Rex J. Miller
***** ******** **** 720-***-****
San Diego, CA 92126 acut2c@r.postjobfree.com
COMPUTER SKILLS
OS
Windows 7/8/10, Windows Server 2003/2008/2012, Hyper-V Server 2012, Citrix and Linux
Software & Applications
Microsoft SQL Server Management Studio, Reporting Services (SSRS), SSIS, T-SQL, CTE, Database Views, Visual Studio 2010 - 2013, ASP.Net, MVC 4/5, C#, Entity Framework, SharePoint, Crystal Reports, Microsoft Project/Visio 2003/2010, Office Professional 2010/2013, Outlook, Lotus Notes, and Cisco WebEx.
Server Administration
Microsoft 2003/2008/2012 Enterprise Server, Microsoft 2008/2012/2014 SQL Server, IIS, and Active Directory
Database
Microsoft Access 2003/2007/2010/2013, Oracle 11g, FoxPro 9.0, and SQL 2008/2012/2014 Administrator
Programming Languages
VB, C#, SQL, T-SQL, XML, ADO.Net, ASP.Net 3.5/4.0/4.5, AJAX, CSS, JavaScript, jQuery, HTML, PowerShell, and VBScript
Strongest Skill Set
System development using various platforms such as: Microsoft SQL, Access, ASP.Net, MVC, VB, C#, and XML. Windows workstation support, server administration and troubleshooting, hardware and software installation, Microsoft SQL database design and administration, Sarbanes-Oxley IT controls, system infrastructure installation, project and risk management. I have excellent oral and written communication skills, plus detail orientated.
WORK EXPERIENCE
Delta Design (Poway, CA) 01/2016 – Present
Data Analyst
Scrubbing/cleaning text files from semiconductor test machines from global companies before creating metrics reports using Microsoft Access.
Performed data analysis, graphs, charts, pivot tables, pivot charts, and Macros using Excel. Retrieves, collects, cleanses, manipulates, summarizes, interprets customer data. Identifies, analyzes, and interpret trends in large data sets.
Creating KPI reports using SQL Server 2014 Reporting Services.
Kaiser Permanente (San Diego, CA) 03/2015 – 12/2015
SQL Developer / Data Analyst
Importing/exporting data between Oracle/Access/Excel/SQL using SSIS and Bulk Copy Program.
Generating complex Stored Procedures, Triggers, User-Defined Functions, CTEs, and using SSRS for building stakeholders Ad Hoc, and parameterized reports.
Developed Kaiser Permanente’s membership reporting system using SQL Server to automate the importing of Excel, csv, text files and Oracle query results while building Excel reports sent to the SharePoint server. I created SQL error checking procedures that sent alert emails to clients and staff.
Programmed using C# code and Visual Studio to build robust Excel spreadsheets with pivot tables.
Utilized C# programs and Power Shell script to verify the Meta file data before importing.
Created an automated task scheduler using SQL Service Broker to run various SQL jobs.
Develop and implement data collection systems for Kaiser Permanente that optimizes statistical efficiency and data quality by creating analytical reports in Microsoft SQL, Access and Excel using pivot tables and charts. Designed and built web pages to help manage their membership activities.
Created PowerShell scripts to automate the collection of data sets and the Healthcare reporting process used by the Business Intelligence Services department.
Ameriprise Financial (Minneapolis, MN) 10/2014 – 12/2014
Microsoft Access Developer
Developing advanced database tools for the management and segmentation of data, providing metrics on project ROI, employee performance and leveraging these tools for decision making.
Optimized coding and standardized the workflow for the management team through use of performance metrics to enhance overall efficiency, productivity and profitability.
Developed & maintained department databases to support production, quality & reporting needs.
Oracle, SQL, Visual Basic 6.0, VBA were extensively used in creating MS Access databases and MS Excel Applications/Utilities. Created Spreadsheets in Excel using VBA for Data migration/validation.
iGate Technologies, Inc. (San Diego, CA) 03/2014 – 09/2014
Technical Lead
Migrating data from a Sybase database to the Microsoft SQL Server database for LPL Financial which uses the Portia system to manage its investment portfolios.
Preparing the test environment by programming all test functions, documentation and troubleshooting the Portia system using Microsoft Access 2010, SQL and VBA programming.
Kaiser Permanente (Denver, CO) 08/2013 – 01/2014
Benefit Systems Data Analyst
Developed ad hoc & ongoing reports for Benefit Systems & other internal departments/stakeholders for Kaiser Permanente utilizing data via VB, SQL, DB2, Oracle and Microsoft Access/Excel.
Created matrices, tracking, and reporting management systems utilizing SharePoint and MS Access.
Developed & maintained department databases to support production, quality & reporting needs.
Developed QA queries & reports to support department production & quality processes.
Prepared monitors & regularly reports department metrics.
Maintained/updated relational databases to support products, benefits/contract administration data.
Worked with the business/end users to improve/automate business processes and reporting database needs.
Maintained system security processes for benefit & contract systems in alignment with SOX controls.
Independent Consultant (Phoenix, AZ / Irvine, CA) 01/2009 – 06/2013
System Development (SQL & Access) / System Administrator
Developed a system in MS Access for the State of Arizona to manage children’s status and creating pie chart reports to better track agencies assigned to the children.
Created new and the migration of existing reports from MS Access to SQL Server Reporting Services.
Enhancing an insurance company's client quotation and reporting system using MS Access 2003.
Installed and configured a Dell PowerEdge server using Microsoft Virtualization platform running Windows Server 2012; including AD/DHCP/DNS/IIS management and Microsoft SQL Server 2012.
Developed a multiuser loan repayment monitoring application system using MS Access 2010 for a financial title/loan company to allow customer service agents to track borrower’s payments as they come due while reminding them to make payments on time. I utilized external tables stored in Microsoft SQL/FoxPro.
Analyzed the Maricopa County Attorney’s Office’s People-Trak system written in MS Access/SQL.
Prepared a written recommendation report to management detailing several options to implement.
Developed reports and a job maintenance system in MS Access 2010 and SQL Server 2008 for a Metal & Ceramic Coating Services company.
Created class and instructor forms/reports for a school system utilized in China using Access 2010.
Upgraded a financial investment system for a Non-Bank Holding Company. Developed an LLC management module and various reports designed in MS Access 2010.
Modifying an existing job processing system for a solar and thermal spray metal company using Microsoft Access 2010, VB and Microsoft SQL Server 2008. Customizing maintenance modules and specialized reports to meet their client needs.
Enhancing a reporting system using Microsoft Access/Excel 2003, VB and Microsoft SQL Server 2005 for a mortgage company. Created SQL stored procedures, while developing an Access database with an ODBC link to the SQL 2005 back-end server. Interacted with MS Excel spreadsheets to cross check data integrity.
Created an automated system to send out PDF attached statements to the company’s investors.
Developed an automotive repossession system using MS Access 2007, VB and SQL Server 2008.
Responsible for testing and documenting the automotive remarking tracking system.
Upgraded/Converted an accounting MS Access 2003 database to MS Access 2007 including MS Excel utilizing macros.
United Auto Credit Corp. (Irvine, CA) 05/2007 – 04/2008
Network Systems Manager
Project coordination of all cooperate and branch office network activities, managed branch office infrastructure implementations, analyzed, designed solutions, presentation of the projects to higher management, develop and documentation of project plan including durations and costs.
Direct responsibilities included setup, administration and support activities for networking components for SAN storage, backup technologies and various Windows servers.
Additional technologies include: EMC storage, Barracuda Spam, Net Screen and web firewalls, etc.
Prepared SOX audit reports for auditors regarding the company’s network access and security.
Developed a database to control IT Assets, software licensing, and network IP Address resources.
EDUCATION
University of Phoenix
Master of Business Administration, December 2008, GPA 3.93
San Diego State University
Bachelors of Science Degree, Major in Business Administration/Information Systems
OTHER
Language Skills: Intermediate Japanese