Resume

Sign in

Data Warehouse Manager

Location:
Lake Arrowhead, CA
Posted:
September 24, 2018

Contact this candidate

Resume:

JAMES E. MILLER

Lake Arrowhead, CA

Phone: 818-***-**** ac65xp@r.postjobfree.com

QUALIFICATIONS

Dynamic and accomplished manager, project manager, software developer and Business Intelligence (BI) developer offering expertise in delivering products that are designed and communicated to provide detailed or summary information. Accomplished business, systems analysts, and manager providing detailed information using Visio, Word, PowerPoint, Project, and analysis to communicate complex, critical applications effectively. Creation of BI Reports using SSRS with fact and dimension tables, SSAS cube, with SSRS with KPI’s, and Microsoft CRM. Aspect in development of Innovative team player and strategist, instrumental in supporting visions and strategies within organizations. Outstanding mentor and leader of profitable project solutions. Known for implementing policies and procedures and increasing reliability and speed of development. Confident facilitator and communicator, skilled in collaborating with executives, stakeholders, and clients; also, an accomplished instructor and trainer. Expertise includes:

Project Management Budget Oversight Process Improvements System Integration Training / Mentoring Productivity Specialist

Documentation Processes Team Building/Leadership BI Developer

CAREER ACHIEVEMENTS

Perspecta (previously DXC Technologies, Hewlett Packard Enterprise)

Data Migration Expert: hands-on management of upgrading SQL Server 2000 databases to SQL Server 2012 including the modification of incorporated ETL processes using SSIS.

Incorporated BI Structure: created, deployed and trained individuals in the development of SSRS reports into a structured report management system; incorporating new processes of reviewing and managing data.

Academy of Motions Pictures Arts & Sciences

Developed the Executive Dashboard for voting: incorporating information from a third-party provider and Microsoft Dynamics CRM 2011.

Developed CRM Reports: Dashboard development and reports using BI Tools using the SSRS extensions to support business functionality.

Providence Health Services

Mentor: Increased efficiencies in SQL Server Report development, increased data T-SQL processes in the development of reports.

Data Transformation: Saved $8,000 per month with the archived ERP system incorporated into SQL Server for patient reporting.

Reliance Steel & Aluminum

Developed Security Control Reports: Analyzed and developed security control reports for the existing ERP system using SSRS, SSIS with SQL Server 2005.

Modify Existing DBMS Systems: Redesign several Microsoft Access Databases to use SQL Server 2000/2005 with SSIS and SSRS technology while upgrading database schemas and architectures.

Time Warner

Bi-Weekly Invoicing Implementation: Created and instituted a standard bi-weekly invoicing system for third-party contractors and saved $6M in the first year.

Illicit Services Identification Software: Introduced software to identify customers acquiring services illicitly and eliminated misappropriations. Increased revenue by $3M annually.

Streamlined Communications: Restructured internal and external applications and instituted companywide web-based reporting system. Conducted 2-day training for analysts and developers in Microsoft Report Services eliminating 50% of email delivered reports.

Policies and Procedures: Instituted formal project management methods for developers, analysts, and technical writers, and incorporated policies and procedures for developing new software applications. Increased reliability of new applications and decreased the time needed to develop applications and reports by 50%.

Order Entry System: Developed an order entry program to identify demand and connect client requests with company services. Improved corporate sales through the system 50%.

Facilities Management System: Project Manager in the design and implementation of the product that facilitated information from the employees to the facility management team that incorporated more efficiency in daily processes.

Employee Database Management System: Project manager and designer on the software implementation of the Employee Management System that facilitated communication to all departments within the organization for effective reporting delivery.

EDUCATION AND TRAINING

UNIVERSITY OF PHOENIX, Culver City, CA

Master in Business Administration

UNIVERSITY OF PHOENIX, Gardena, CA

Bachelor of Science, Information Technology

SQL Server 2005/2008 Course

Installation and Deployment in Microsoft Dynamics CRM 2013

Customization and Configuration in Microsoft Dynamics CRM 2013

Performance Management: Objective Setting and Coaching, training

Understanding Your Role & Establishing Credibility, training

The Momentum Workshop, training

DISC: Relationship Management, training

Project Management Certification, training

COMPUTER SKILLS

Software Packages: MS Office Suite (Word, Excel, PowerPoint, Visio) MS Project, Oracle, JavaScript, FTP/SFTP, VPN, Remote Server Access, Crystal Reports (Business Objects VII), MS Reporting Services, Visio, SharePoint 2007/2010, CRM 2011/2013, TFS, VSS

Platforms & Systems: Windows 2000/2003/XP/VISTA/Windows 7, AS400, MS DOS, MAC

Databases & Tools: SQL Server 7.0/2000/2005/2008/2008R2/2012/2014/2016, MS Access 97/2000/2003/2007/2010/2013, Oracle, DB2

Development Languages: Visual Basic, VBA, Visual Studio.Net 2003, ASP.NET, VB.NET, ASP, FrontPage 2000/2003, OLAP, XML, JavaScript

PROFESSIONAL EXPERIENCE

Perspecta (previously DXC Technologies; HPE) (County of San Diego, Contract) May 2015 – Present

Data Migration Expert / BI Developer

Primary role is upgrading existing SQL Server 2000 databases to SQL Server 2012 using integration of SQL 2008 for the transformation between servers.

ETL processes in migration of DTS packages to SSIS packages incorporating ftp transfer and file manipulation with flat files and 64bit Microsoft Office files (Excel and Access). Checking of existing files in a package using functions and archival of data files to minimize failed packages.

Incorporate Integration Services Catalogs for the deployment of the packages.

Lead on Team Foundation Server (TFS) as the code repository of files used in development.

Second primary role is the lead BI developer with the financial billing system and operations to the contracted organization using SSRS; converting of Access and Crystal Reports to SSRS; creating Power BI dashboards.

Data warehouse developer creating fact and dimension tables (Star Schema) as a precursor to the development of SSAS cubes.

BI development of SSRS reports with fact and dimension table; and incorporating SSAS cubes for the development of Excel pivot tables; data analysis and the use of Power BI to create dashboards.

SQL Server mentor directing the development of upgrading a SQL Server database from 2000 to 2012.

Documentation expert on all aspects of data manipulation, business rules and training documentation.

Data transferred using SFTP/FTP using code on existing servers and some AutoSys experience and the continued replications of Enterprise solutions into SQL Server database management systems.

ACADEMY OF MOTION PICTURES OF ARTS AND SCIENCES Nov 2013 – Dec 2014

Senior Report Analyst / SQL Developer

Primary role of identifying a database architect for a data warehouse with ETL processes constructed in SSIS.

Developed CRM reports with SSRS extension which are deployed to SSRS and impeded into CRM.

BI developer using SQL 2008 R2 SSRS to incorporate information from CRM and a data warehouse for reporting dashboards.

Incorporating T-SQL, stored procedures, functions while combining data from multiple databases to incorporate dashboard capabilities into Share Point with SSRS integration.

Incorporation of JavaScript in SSRS development for calling of other reports and programming functionality.

Worked with existing business analysts, project managers and management in the development of new reports for the organization.

Facilitated and developed Share Point solutions in the sharing of documents, projects, and report dashboards.

PROVIDENCE HEALTH SERVICES Oct 2012 – Nov 2013

Senior Report Analyst / SQL Developer

Developed BI reports and ETL processes using SQL SSIS containing multi-split of information with variables for vendors in SQL 2005 and 2008 R2 utilizing views, stored procedure, and functions to mimic processes from existing ERP systems.

Built SSRS and Crystal reports with graphic and drill-down capabilities to provide reports necessary for finance and member services with stored procedures and functions to mimic existing macros in related ERP Systems, CAMIS and Magic that is part of Meditech software.

Introduction to EPIC programming with development of Crystal Report solutions.

Extracted and QA’d processes from existing ERP systems, CAMIS and Magic using SSIS as the exporting feature.

Supported existing Microsoft Access applications for all medical services.

Incorporation of JavaScript in SSRS development for calling of other reports and programming functionality.

ETL and report development process on the DKD data transformation in conjunction with updating reports in completion of the archival project, saved $8,000 per month on service fees.

Mentored co-workers on the development of SQL queries, stored procedures, and SSRS reports, including SSRS deployment, subscriptions, and user access for users.

MONARCH HEALTHCARE Jun 2011 – Oct 2012

Senior Information Analyst (Report Analyst)

Developed BI reports using SSIS and SSRS to provide reports necessary for finance, claims, operations and other aspects at the organization from three ERP database systems, EZCAP, Practice Connect and Provider Resource Maintenance systems.

Incorporation of JavaScript in SSRS development for calling of other reports and programming functionality.

Incorporated KPI’s in many BI reports for the demonstration of business activities.

Report development consisted of complicated queries using Star Schema data warehouse (fact and dimension tables), matrix writing and sub report generation per business needs.

Consistent HIPAA regulations on practiced with annual certifications taken for compliance.

Mentored coworkers on existing SQL processes, including functions for the development of reports.

BANK OF AMERICA Feb 2011 – Jun 2011

SQL Developer / Programmer (Contract)

Developed reports using SSIS and SSRS to provide security auditing for existing ERP applications and general ledger reports and develop documentation and procedures.

Updates Access databases to use SQL Server and Oracle DBMS systems in support of our existing ERP system and management intermediate processes in SharePoint.

Managed SharePoint lists, incorporated individual and group access within SharePoint. Archived data and compacted database size for continue productivity within SharePoint.

LENDER PROCESSING SERVICES Nov 2010 – Feb 2011

Business Analyst/ Software Developer / Project Lead

Interviewed existing business teams and gather requirements effectively to determine processes and procedures used to conduct business at different levels in the organization.

Constructed a report request form to simulate ease in requesting new reports.

Interpreted business needs related to the gathering of data into a DBMS system preferably Microsoft Access or SQL Server, building forms and incorporating project management methods.

Identified, documented and communicated findings related to the existing processes and provide direction for enhancements to the DBMS systems on the outlined projects.

Developed and managed BI reports using SSRS and SSIS with SQL Server 2008 / 2010.

Upgraded existing UI Microsoft Access database systems and completed the process of moving the data to SQL Server.

RELIANCE STEEL & ALUMINUM CO Mar 2009 – Nov 2010

Sr. Systems Analyst / Project Lead

Managed third party application to facilitate the payment of company vendors domestically and internationally using a tool created by the organization Bottomline.

Modified existing data replication from the ERP System from Oracle and Connex database systems to SQL Server using DTS and SSIS and upgraded existing database schemas and database architecture.

Developed reports using SSIS and BI Tools SSRS to provide security auditing for existing ERP applications and general ledger reports and developed documentation and procedures.

Incorporation of JavaScript in SSRS development for calling of other reports and programming functionality.

Updated Access databases to use SQL Server and Oracle DBMS systems in support of existing ERP functionality.

Lead the incorporation of Active Directory as a security procedure in the applications and reports.

IS CONSULTING JOBS Nov 2007 – Feb 2009

Project Manager (Nov 2007 – Feb 2008)

Analyzed the existing project management systems, processes with SDLC incorporated.

Wrote policies and procedures for managing projects and made recommendations as to which systems to use in project management.

Researched and reviewed two project management systems: Microsoft Project Server and SharePoint for Project Management.

Develop several projects using Microsoft Project and SharePoint.

SQL DBA and Developer (July 2008 – Mar 2009)

Supported diverse clients and projects in various roles.

Reviewed existing SQL Database environment for an existing home building organization to enhance the research and development department.

Designed and upgraded DTS packages to SSIS packages for processing data on a regular basis.

Developed new TSQL statements, indexes, stored procedures and views in SQL Server 2005.

Utilized MS Reporting Services and SQL Server 2005 to create reports. Incorporated stored procedures and views.

TIME WARNER CABLE, (previously COMCAST CABLE), El Segundo, CA Feb 2000 – Jul 2007

Software Development Manager / Project Manager (Aug 2004-Jul 2007)

Directed a staff of five software developers and technician to develop software applications.

Created team and integrated applications for sales and marketing, technical operations, business operations and HR using VB.Net, SQL Server, ASP.Net and other Microsoft technologies.

Managed over 12 software applications incorporating SDLC for the Sales Leads Applications, Sales Order Entry, and Retention Database using VBA, VB.Net and SQL Server.

Analyzed QA release notes, reviews and training documentation; supervised remedial actions, and oversaw release of application development into production systems.

Streamlined creation of multi-tier reporting by training analysts and report writers in SQL Server skills.

Developed business process for end-users and managers to define new application projects regards to scope, task lists, and timelines.

Provided technical support to SQL DBAs regarding table indexing, T-SQL statements, stored procedures, triggers, DTS and SSIS packages downloading data from Oracle databases.

Conducted personnel assessments, identified skill sets and conducted / instituted training to increase skill levels.

Software Developer (Feb 2000-Aug 2004)

Developed software and managed development to produce internal and external reporting services.

Designed user reports and created web tools utilizing Access 97/2000/2003, SQL Server 7/2000, FrontPage 2000, ASP, VB.NET and ASP.NET technologies incorporating SDLC project methods.

Created and maintained on-line reporting system for data sources that included daily uploads from Oracle database and an AS400 system to SQL Server using DTS and SSIS technologies.

Mentored and trained business analysts in SQL Server to develop enhanced database design applications using DTS packages for downloading information to SQL Server.

Designed applications to manage customer/employee related data using VB.Net, ASP.Net and SQL Server.

Provided programming guidance to SQL DBA, which included stored procedures with T-SQL queries, views, databases, tables and indexes to optimize query performance on the SQL server.

Utilized IIS 5.0/6.0 with FrontPage 2000 to design/publish ASP, VB.NET and ASP.NET with DTS and SSIS.



Contact this candidate