JAMES E. MILLER
Lake Arrowhead, CA
Phone: 818-***-**** ad3ltk@r.postjobfree.com
QUALIFICATIONS
Dynamic and accomplished computer software developer, who is capable of leading, mentoring, managing, and project managing. Accomplishments of Data Migration with many years of ETL work along with Data warehousing development and reporting. 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 primarily with SSRS, SSAS Cubes, and KPI reporting.
SQL Server Architect designing over 100 systems incorporating front-end applications or reporting structures using SSRS, Power BI, and Crystal Reports attaching to the database systems. Databases developed could be over 500 tables within one database on an average with database designs used to incorporate integrity with database systems. Tables created with keys and indexes both clustered and non-clustered indexes for performance.
Used Visual Studio in some aspects of creating databases, deploying changes to existing databases for both development and production systems. This incorporated adding new keys, indexes, and columns.
Lead developer on several accounts for both development in SQL server and BI development work.
CAREER ACHIEVEMENTS
Peraton (previously Perspecta, DXC Technologies, Hewlett Packard Enterprise)
Data Migration Expert: hands-on management of upgrading SQL Server 2000 databases to SQL Server 2012, 2016, and 2019 including the modification of incorporated ETL processes using SSIS, and development of SSRS reports.
Academy of Motions Pictures Arts & Sciences
Developed the Executive Dashboard for voting: incorporating information from a third-party provider and Microsoft Dynamics CRM 2011, and CRM Reports in SSRS.
Providence Health Services
Mentor: Increased efficiencies in SQL Server Report development, increased data T-SQL processes in the development of reports and saved $8,000 per month with archived system.
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.
EDUCATION AND TRAINING
UNIVERSITY OF PHOENIX, Culver City, CA Master’s 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
Implementing a SQL Data Warehouse, training
Automating Administration with Windows PowerShell, training
Developing ASP.NET Core MVC, 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, C#, PowerShell
PROFESSIONAL EXPERIENCE
Maersk (Damco, and Performance Team) Aug 2022 - Present
Senior Data Engineer
Develop ETL processes with imports and exports using SQL Server Integration Service (Visual Studio 2019).
Developed documentation for the building of SSIS packages, and deployment in mentoring developers and DBAs.
Write EDI reports from data housed in SQL Server using SSIS and Store procedures.
Operation of Agile projects in the Jira software management tool.
Develop SSIS package in Visual Studio 2019 using TFS.
Perform modification to existing .NET applications as necessary.
Peraton May 2015 – Aug 2022
(previously Perspecta; DXC Technologies; HPE;) (County of San Diego, Contract)
Data Migration Expert / BI Developer
Upgrade existing SQL Server databases to newer versions (2000 to 2012 transferring DTS to SSIS); 2012 to 2016 and 2019.
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). Code written to check if existing files are in specific folders to process or pass without error in SSIS packages.
SSIS development with data conversions, derived columns for incorporating data uploads.
Lead on Team Foundation Server (TFS), mentor and developer of reporting system; and lead BI developer with the financial billing system and operations to the using SSRS, Power BI and Crystal reports.
Use of PowerShell to pull data from ancillary systems including Microsoft Portal.
Lead the development of a few .NET applications to provide the user’s an ability to update information on the database.
ACADEMY OF MOTION PICTURES OF ARTS AND SCIENCES Nov 2013 – Dec 2014
Senior Report Analyst / SQL Developer
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.
Facilitated and developed Share Point solutions in the sharing of documents, projects, and report dashboards.
Some of the incorporated reports utilized .NET with the CRM tool.
PROVIDENCE HEALTH SERVICES Oct 2012 – Nov 2013
Senior Report Analyst / SQL Developer
Took over the development of the DKD system to incorporate intricate changes to the existing SQL Server system providing updates to data types for efficient reporting purposes. Designed the SSIS packages, incorporated the changes, architected the SQL database system providing indexes and keys to increate report development retrieval.
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.
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 (Contract)
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, and documented the 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.