Sql Server Microsoft

Rex J. Miller

*** *. ****** ***** ** Road 619-***-****

San Marcos, CA 92078 **********@*****.***

COMPUTER SKILLS

Platforms

Windows PCs 10/11, Windows Server 2000 - 2022, Microsoft SQL Server 2005 - 2022, Hyper-V Server 2012-2016, and IBM AS/400

Software & Applications

Microsoft SQL Server, Reporting Services (SSRS), SSIS, Visual Studio 2008 - 2022, ASP.Net, C#, SharePoint, Office Professional 2008 - 365, Outlook, GoToMeeting, and Microsoft Teams. Server Administration

Microsoft Enterprise Server 2000 - 2022, Microsoft SQL Server 2005 – 2022, Microsoft Exchange 2003 – 2010, Active Directory, DHCP, DNS, and IIS.

Database

Microsoft Access 2000 - 2021, Oracle 11g, FoxPro 9.0, Microsoft SQL Server 2005 - 2022, and SQLite Programming Languages

SQL, T-SQL, VBA, Visual Basic, C#, XML, ASP.Net, MVC 5, ASP.Net 3.5 - 4.8, ASP.Net Core 5.0, AJAX, CSS, JavaScript, jQuery, HTML, RPG/400, PowerShell, and VBScript. Strongest Skill Set

System development using platforms such as: Microsoft SQL Server, Access, C#, Visual Studio, ASP.Net, ASP.Net Core, VBA, Visual Basic, and XML. Writing complex SQL/Access queries and subqueries, SQL Window Functions queries, Excel Modules/Functions with VBA code for different business environments. Over 5 years’ experience in utilizing ETL tools, including SSIS, and ETL Package design. Experience in maintenance and administration of SSIS by creating Jobs, Alerts, SQL Mail Agent, and schedule SSIS Packages through scheduler using SQL Server Agent. Windows workstation support, server administration and troubleshooting, hardware and software installation, MS SQL database design and administration, Text/HTML/XML parsing of files, Sarbanes-Oxley IT controls, system infrastructure installation, project, and risk management. I have excellent oral and written communication skills, plus detail orientated. WORK EXPERIENCE

Tyler Technologies (Carlsbad, CA) 03/2018 – 6/2024 Sr. Software Engineer

Created complex Stored Procedures, Views and functions and other statements for various applications, maintained referential integrity and implemented complex business logic.

Created Tables, Views, Indexes based on the requirements.

Performance tuning of SQL queries and Stored Procedures using SQL Profiler and index tuning.

ETL (SSIS) to develop jobs for extracting, cleaning, transforming, and loading data into target tables.

Effectively used Advanced Programming concepts like CTE's, Windows Functions, Apply Operators, Pivot, Dynamic SQL, etc.

Developed system modifications using SQL server for the county assessor tax system application.

Experience in SSIS script task, look up transformations, data flow tasks using T-SQL and C# scripts.

Troubleshooting and resolving SQL database performance/data issues for our county clients.

Performed documentation for several kinds of reports, processes, DTS and SSIS packages.

Created several SSRS reports to monitor assessor’s performance.

Developed RESTful web services to exchange JSON format tax assessor data and photos.

Provided support for county senior management with assisting to select the best sales properties to be used in determining the accurate homeowner’s tax.

Developed a MS Access system that provide tax assessor’s various tools to pick sold properties used to determine the homeowner’s property taxes.

Dudek Engineering (Encinitas, CA) 08/2016 – 11/2016 Sr. Software Developer

Developed various system modifications using SQL server for the Deltek Vision system application.

Created a PowerShell script that scanned the network providing statistical data used in an Excel report for senior management to better manage network resources.

Programmed using T-SQL a process that created an XML file with payroll data for accounting.

Developed a MS Access system that was used to verify and maintain asset information.

Built complex Functions using VBA code working with SQL Statements to manipulate data.

Conducted detailed reverse engineering activities as source code was not available. Delta Design (Poway, CA) 01/2016 – 06/2016

Data Analyst & Microsoft SQL/Excel Developer

Text/HTML/XML parsing, scrubbing/cleaning files from semiconductor test machines from global companies before creating metrics reports.

Creating alarm Pareto charts for Quality Assurance management using Microsoft Access and Excel.

Develop interfaces using Open Database Connectivity (ODBC) to connect to SQL Server.

Retrieves, cleanses, manipulates, summarizes, analyzes, and interpret trends in large data sets.

Created Excel applications (VBA, Macros) to import historical data which include multiple databases and perform various statistical analyses, charts, and graphs.

Creating KPI reports using Microsoft SSRS, Microsoft Excel, C#, and VBA code.

Created and used stored procedures and views for enhancement of performance while retrieving data and exported the reports in MS Excel format for further analysis or processing.

Developed user manuals, training guides and other materials for end user training. Kaiser Permanente (San Diego, CA) 03/2015 – 12/2015 Data Analyst / SQL Developer

Importing/exporting data between Oracle/Access/Excel/SQL using SSIS and Bulk Copy Program.

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. Developed SQL error checking procedures that sent alert emails to clients/staff.

Automated the creation process of Excel reports such as performance matrix report and membership activity report on weekly/monthly and YTD basis and sending them as an email attachment using Access/VBA Function.

Created an automated task scheduler using SQL Service Broker to run various SQL jobs.

Created a stored procedure to send email alerts, notifications, and attachments through Outlook. These emails were automatically sent after detecting any errors during the automated processes.

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.

Created PowerShell scripts to automate the collection of data sets and the Healthcare reporting processes used by the Business Intelligence Services department. Ameriprise Financial (Minneapolis, MN) 10/2014 – 12/2014 Microsoft Access/VBA 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.

Imported data from Oracle and exported data for metrics.

Developed & maintained department databases to support production, quality & reporting needs.

Oracle, SQL, VBA were extensively used in creating MS Access databases and MS Excel Applications/Utilities. Created Spreadsheets in Excel using VBA for Data migration/validation.

Developed Access/VBA based financial scraping programs utilizing financial reports from Oracle.

Responsible for gathering requirements from investment managers, designing, implementing, and managing the development of applications.

Analyzed and tested systems. Provided on-site support and training for new users. LPL Financial (San Diego, CA) 03/2014 – 09/2014

Microsoft Access/SQL Developer

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.

Assisted with automation of finance department’s manual processes by writing VBA code and using macros and formulas to speed processes and maximize accuracy.

Developed user defined functions to calculate performance attributions, ratios, and various other functions to evaluate investment managers and department’s performance.

Preparing the test environment by programming all test functions, documentation and troubleshooting the Portia system using Microsoft Access, SQL, and VBA programming.

Translating cell formulas in Excel into VBA code and using Excel-based VBA to design, analyze, and deploy programs for finance users.

Created requirement details documentation, implementation documentation, user acceptance testing documentation, support documentation, user manuals and technical documentation throughout the application development.

Kaiser Permanente (Denver, CO) 08/2013 – 01/2014

Data Analyst & Access VBA Developer

Developed ad hoc & ongoing reports for Benefit Systems & other internal departments/stakeholders for Kaiser Permanente utilizing data via VBA, SQL, DB2, Oracle and Microsoft Access/Excel.

Created metrics, 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 monitoring tools & produced automated reports regarding department metrics.

Developed modules to export the data to Excel for creating charts and graphs.

Maintained/updated relational databases to support products, benefits/contract administration data.

Worked with the business and 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 Microsoft SQL/Access/VBA Developer & System Administrator

Developed an automotive repossession system using MS Access, VBA, and SQL Server.

Responsible for testing and documenting the automotive remarking tracking system.

Created an Access database for the Arizona Department of Gaming to record, track and resolve casino incidences.

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.

Enhancing an insurance company's client quotation and reporting system using MS Access.

Installed and configured a Dell PowerEdge server using Microsoft Virtualization platform running Windows Server, including AD/DHCP/DNS/IIS management and Microsoft SQL Server.

Developed a multiuser loan repayment monitoring application system using MS Access 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.

Upgraded a financial investment system for a Non-Bank Holding Company. Developed an LLC management module and various reports designed in MS Access.

Modifying an existing job processing system for a solar and thermal spray metal company using Microsoft Access, VBA, and Microsoft SQL Server. Customizing maintenance modules and specialized reports to meet their client needs.

Enhancing a reporting system using Microsoft Access/Excel, VBA, and Microsoft SQL Server for a mortgage company. Created SQL stored procedures, while developing an Access database with an ODBC link to the back-end SQL 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.

General desktop support, AD/Exchange server administration. Developed technical procedural documentation.

Constructed an Access database to better manage IT assets and network resources. United Auto Credit Corp. (Irvine, CA) 05/2007 – 04/2008 Network Systems Manager

Project coordination of all corporate 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.

Managing and configuring the Cisco routers, switches with vlans, and wireless devices for 100+ branch offices.

Administration, monitoring, and optimization of Microsoft Server.

Direct responsibilities included setup, administration, and support activities for networking components for SAN storage, backup technologies and various Windows servers.

Migrated 800+ Exchange 2003 users to the Exchange 2007 environment with OWA access.

Implemented a FACSys server for a desktop faxing solution at the corporate office.

Administration of additional technologies includes EMC Clariion, SAN storage, Barracuda Spam, Net Screen and St. Bernard-Iprism web firewalls, etc.

Automated a process using VBScript to scan Active Directory for users whose accounts were expiring soon and send them an alert email to remind them to change their user logon password.

Responsible for documenting the company’s network configuration and work procedures.

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. Ceridian (Fountain Valley, CA) 11/2005 – 05/2007

Network Analyst / Security Compliancy Administrator

Built, migrated, and administered various Microsoft Windows servers: including AD/DNS/DHCP management.

Microsoft Exchange Server Administrator supporting 650+ users.

Migrated all 650+ domain users to Active Directory and setting up security policies in Active Directory.

Provided Network Level III Troubleshooting support and configured Cisco switches and routers.

Project managed the Dell workstation and Hewlett-Packard printer refresh.

Maintains secure network infrastructure and ensured the optimization performance of gateways, switches, routers, and connectivity issues.

Consulting with SOX auditors. Preparing several reports using MS Access/Excel for the SOX audits.

Assessed business process controls, identified risks, and provided remediation and SOX compliancy as part of the audit process. Tested IT controls and generated documentation for external auditors.

Created disaster recovery and business continuity plans, Microsoft SQL & Microsoft Windows Server system hardening, documentation and implemented client security policies.

Part-time consulting for People-Support as a Sarbanes-Oxley & Security Compliancy Administrator doing network security remediation for their client Allstate. EDUCATION

University of Phoenix

Master of Business Administration, GPA 3.93

San Diego State University

Bachelor of Science Degree, Major in Business Administration/Information Systems Interface Technical Training

Cisco Certifications, Major area of study in Routing / Switching / WAN / Voice over IP / Network Security OTHER

Language Skills: Intermediate Japanese

Contact this candidate