RICK GIBSON

Programmer, BI Developer – Microsoft Technologies

707-***-****

Summary:

●Senior IT professional with 20 years of experience in Requirements Analysis, Workflow Design, N-tiered Development, System integration, Process Modeling, Testing/QA and Database Development.

●Extensive experience in MS SQL Server, MySQL, Oracle, Web Services, OLAP/SSRS/SSIS, CSS/CSS3, jQuery, JavaScript, HTML, C#, .Net framework environment etc.

●Have extensively used CSS, jQuery, Ajax and JavaScript very effectively. Have been taking advantage of the new features of both CSS3 and HTML5. The JavaScript framework that I use is Vue.js

●Experienced working in Microsoft technologies since 1995 starting with MS Access and then Visual Basic using Access as a backend thru MVC and SQL Server 2016.

●Have worked on an OLAP project (SSAS). Used SQL Server Reporting Services (SSRS) since 2005. Used DTS packages to do ETL back in 2000 thru 2004, the precursor to SSIS.

●Certified in MS Retail Management System, and MS Access Application Development

●Have excellent communication and user interaction skills.

Technical Skills Summary:

●Languages: C#, VB.Net, VBA, JavaScript, Vue.js, SQL, XML, PHP

●Recent experience: WordPress, MVVM using Knockout.js, Durandal.js, D3.js, OAuth 2.0, Vue.js

●Web Programming: Asp.Net, AJAX, jQuery, JSON, HTML, CSS, IIS, Web Services,

●Many JavaScript libraries - including Knockout.js, Vue.js, D3.js, DC.js and crossfilter.js

●Additional Software Tools: SQL Server, OLAP (Analysis Services), Visual Studio, MS Office, Oracle, MySQL, SSRS, SSIS, Power BI

●Adept at both data warehouse and RDBMS Architecture design

Education:

●Computer Programming MTI Western Business College Sacramento, CA; 1994

Certifications:

MS Access

Microsoft Retail Management Systems – now Dynamics 365

METRC API

Professional Experience:

Cascade Receivables Management 12-2018 to 5-2019

Programmer Developer

●Created Power Query ETL solutions to replace existing MS Access process.

●Used PowerPivot and DAX to replace old, MS Access Export to QuickBooks feature.

●Modified existing MS Access applications

●Designed and restructured internal databases

●Created data model for Power BI

Environment: SSRS, SSIS, MS Access, Power BI, Excel VBA

Buckley Heat Air and Solar 01-2018 to 04- 2018

Power BI Developer

●Created dashboard, and data exploration application

●Designed data model.

Environment: Visual Studio 2017, SQL Server Management Studio, Power BI

BlueShield of California 08-2016 to 11-2017

Programmer Analyst

●Created daily dashboard that tracked the employee efficiency on work items. I used Vue.js for the front end, and a SQL Server REST API backend. Utilized Chart.js and D3.js for charts and graphs.

●Designed data warehouse and ETL packages for the dashboard and SSRS reports.

●Modified existing Excel VBA applications

●Created data model in Power Pivot

Environment: Visual Studio 2015, SSIS, SSRS, SQL Server Management Studio, Vue.js, Node.js D3.js and Chart.js

LifeMedId, CA 01-2014 to 01-2016

Programmer Analyst

●Redesign of SSRS reporting application

●Using SSRS, constructed a user dashboard, and summarized metrics enabling data mining by drilling in or drill through.

●Built a small reporting OAuth app using Durandal.js, MVC 4.5, jQuery, Bootstrap and Knockout.js.

Also in the same app I implemented DC.js which uses D3.js and Crossfilter.js to do interactive charts.

Environment: Visual Studio 2013, SSIS, SSRS, SQL Server Management Studio, Power-BI, Power Query, Power Pivot

Intel, Folsom, CA 07-2012 to 12-2013

.Net Developer - Heavy on front end

Using Orchard, an open source, MVC, CMS created by Microsoft – I integrated an existing LOB application (Asp.net - web forms). Also, I refactored the LOB application to use jQuery, jQuery plugins, AJAX, and web services. I removed most of the server-side controls, while adding JavaScript/CSS - (Bootstrap) modifications. I created a Dashboard Solution, and reports using SSRS and created SSIS packages that kept summary report data in sync and current.

Environment: Visual Studio 2010, SSIS, SSRS, SQL Server Management Studio

Quest Systems, Sacramento, CA 10-2011 to 3-2012

Programmer Analyst

●Small project to convert a web reporting application to SSRS structure and built SSIS packages to extract data from multiple databases.

●Using SSIS, created daily jobs with SQL Server Management to update the reporting database.

●Using SSRS, constructed a user dashboard with ten high-level, summarized metrics enabling data mining by drilling in or through, along with detailed report generation routines.

Environment: Visual Studio 2010, SSIS, SSRS, SQL Server Management Studio

Ra Software, Glen Ellen, CA 2009 – 2011

.Net Developer

●Created AJAX Framework Library and MVC Web Application Library offering web developers a quick-to-market web application design tool.

●Application was designed in Visual Studio 2010 with C# and SQL Server 2008 backend.

●Launched startup venture, “Winergy,” based on development of iPad and mobile phone applications to be used in wine-tasting rooms.

Academic Senate, California Community Colleges, Sacramento, CA 2000 – 2009

.Net Developer

●Implemented and maintained public and internal web portal to create and track course descriptors, highlighting courses where credits are transferable to the UC system.

●Planned and developed two databases and two separate web-based user interfaces (http://www.asccc.org/ and http://www.statewidepathways.org/), encompassing login control for one site and event calendars for both, as well as an automated e-mail confirmation program and a questionnaire allowing users to collaborate on-line.

●Designed and coded for broad spectrum of advanced programming needs, including server-side DLLS and client-side components.

●Environment: Visual Studio 2005 (C#), SQL Server 2005, Windows Server 2003, Telerik controls, VB6, MS Access, MS Office

California Energy Commission, Sacramento, CA 2004 - 2005

.Net Developer

●300 hour project to enhance existing application to track renewable energy resource concepts by adding change request and issue tracker features, as well as reports from SQL Server Reporting Services.

●Environment: Visual Studio 2005 (VB.Net), SQL Server 2005, Windows Server 2003

Agilent Technologies & Philips Medical Services, Roseville, CA 2000 – 2004

Programmer Analyst/DBA

●As team lead for reporting group, coordinated development of three-tier applications for Agilent, including responsibility for code review, training, QA, and staff management.

●Within an OLAP-like environment, created supply chain and high-level financial management reporting tool available via company intranet and as a download for local use.

●Prior to transfer to Philips, orchestrated data conversion from multiple legacy systems using SQL Server 2000 and ASP, and (locally) MS Web Components.

●Environment: Visual Studio 2003 (Vb.Net), SQL Server 2000, Analysis Services, MS Access, VB6, MS Office, Windows Server 2000

State of California, Department of Consumer Affairs, Sacramento, CA 1999 – 2000

Y2K Consultant

●Part of 14-member team, assigned responsibility for creating and maintaining repository to track the group’s efforts.

●Evaluated, tested, and modified numerous existing software applications used by the State to ensure Y2K compliance.

International Business Systems, Folsom, CA 1998 – 1999

VB Developer

●Developed time accounting management system and database to track hours-to-projects for billing purposes; responsible for reporting to/educating management and training staff.

●Environment: VB6, MS Access, MS Office, Windows NT

Reliant Ventures Inc., Los Angeles, CA 1996 – 1997

Project Manager/Systems Developer

●Designed, developed, and maintained management system with MS Office, integrated with MS Project and Excel via OLE software to track all phases of a wireless network project.

●Traveling to more than ten different remote sites, provided user support and training and created interfaces to allow managers to generate status reports on the fly in real time.

●Environment: VB6, MS Access, MS Project, MS Office, Crystal Reports

PacBell Mobile Services, Sacramento, CA 1995 – 1996

Database Programmer

●Developed and maintained MS Access database for project tracking which interfaced with MS Project to generate scheduling reports.

●Environment: MS Access, MS Project, MS Office, Windows NT

Contact this candidate