Programmer/Analyst

Mikhael S. Brown

Oakhurst, California

Phone 559-***-****

*******@*****.***

SUMMARY

In-depth software design/development, MS SQL, Data Mining, Data translation, Analysis and report creation experience. Skilled at transforming a sea of daily data chaos into a meaningful and intuitive, easy to understand, dashboard.

Software and web design expertise from the Infrastructure up through the business rules to the application layer.

Comprehensive hands-on experience with the following selected skills.

SELECTED SKILLS

Data Analysis ASP.Net ADO.Net

C# C/C++ Visual Basic

Visual Studio ETL Applications T-SQL

Oracle SQL DTS/SSIS Packages Tableau

SSRS Business Objects Java Script/HTML

PROFESSIONAL EXPERIENCE

Sentinel Peak Resources, Bakersfield, Ca, through Avadine -Bakersfield, Ca (April 2018 to Dec 2018)

SQL Programmer and Data Analyst

Created, deployed and supported stored procedures and SQL scripts.

oCreation of data transformation tables, scripts and views.

oCreation of data warehouse tables and triggers.

oTransformation and Loading of raw SCADA data for data warehouse

oData Quality monitor SQL Scripts

SSRS report creation and support.

Madera Community Hospital, Madera, Ca, Through TekSystems – Fresno, Ca (Mar 2018 to April 2018)

DBA

Database administrator for hospital databases.

oCreation of maintenance plans

oData movement scripts (ETL)

oCreation to test databases for evaluation

oRecovering 10 TB database that lacked backups

oMigration of existing databases from older 2000, 2005 and 2008 versions to 2016 and 2017 versions as needed.

Supported and maintained SSRS reports and SSRS server.

Aera Energy LLC, Bakersfield, California, through Avadine –Bakersfield. Ca (Feb 2013 to Feb 2018)

Information Specialist

Created, deployed and supported reports for Midway, San Ardo and Coalinga field operations.

oSSRS

oTableau

oBusiness Objects

Field operations DBA support and administration.

SSIS and data movement script creation and support (ETL).

Created and supported data warehouse (Microsoft SQL Server) for field sites

Data Analysis and mining for Midway, Coalinga and San Ardo Field operations.

Created application for dispatch H2S paging warning system and reporting.

Supported Midway websites for Midway teams.

Data extractions for SAS application analysis.

Pandol Brothers, Delano, California (Oct 2012 to Jan 2013)

Programmer/Analyst

Created, deployed and supported in-house desktop application for shipping manifest data import and export to Famous Software, as well as data archiving and analysis.

DBA for local company MS SQL databases.

SSIS Package creation and script implementation to synchronize the famous Oracle data with an MS SQL database used for reporting and data validation for the import application that was created for them.

Syzen Design, Oakhurst, California (May 2011 to Oct 2012)

Software Consultant

Consulting for database driven applications and web design.

Web backend design and implementation

Web application creation and support

MS Office macro and VB programming

General website design and implementation.

Sebastian (Kerman Telephone), Kerman, California (Dec 2007 to May 2011)

Programmer/Analyst

Created and supported in-house desktop and web applications for software integration.

SharePoint intranet development and administration.

ETL/DTS/SSIS package creation for data warehouse applications and support.

Data mining/analysis for company business needs.

DBA for Company MS SQL databases

Data base design and support, versions 2000, 2005 and 2008.

MS SQL server administration (Versions 2000, 2005 and 2008).

Report creation using MS Reporting Services and Crystal Reports.

Provided Telecom Regulatory (FCC, CPUC) support through requirements review, data mining and report creation.

Creation, support, security and maintenance of corporate Intranet (SharePoint).

Integration Software development, integrating various OSS/BSS and support packages (Minerva Networks, MASterMind, Telesphere, Composite, CHR and Sage products).

Consulted and supported Innovative Systems during the implementation of new OSS/BSS software with backend database support, domain knowledge and report creation.

EDUCATION

BS Physics, University of Washington, Seattle, WA

Metallurgical Engineering Studies, University of Washington, Seattle, WA

PROFESSIONAL DEVELOPMENT/HONORS

UCSC Extension: Professional Sequence Award Certificate in C#.NET programming.

UCSC Extension: Object Oriented C++ Certificate

Besser Associates: RF Circuit Fundamentals, RF and High Speed

Circuit Components & Wireless System Design.

Santa Clara University: Network analysis, E&M theory, Semiconductor Physics and device theory

Stanford University, Palo Alto CA: Computer science, device physics and modeling, and semiconductor electronics.

Member Mysterium Society

Contact this candidate