In My Own Words
Business Intelligence, Reporting and SQL Developer and Back Office Software Engineer with 20 years experience. Detail oriented Information Technology professional with expertise in gathering requirements, designing solutions, developing, testing, and maintaining complex custom applications, business intelligence, reporting, and analytics. Hardworking dedicated team player with excellent proactive, analytical, and problem solving skills translating business requirements and dissimilar data resources into information systems.
Areas of Excellence:
• Transact-SQL (T-SQL)
• Reporting and Analytics
• Business Intelligence
• Star Schemas
• Relational Databases
• ETL
• Data Analysis
• Data Manipulation Skills
• Documentation
• Software Testing
Business Intelligence and Reporting Software: Report Builder, Report Designer, SQL Server Reporting Services (SSRS), Power BI, SQL Server Analysis Services (SSAS), Microsoft Visual Studio 2005, 2013, 2015 and 2017, Crystal Reports 2008, SAP Web Intelligence, SAP Edge Server, Domo, QlikView, BIRT
Database Software: Microsoft SQL Server 2005, 2008, 2012, 2014 and 2016, SQL Server Management Studio (SSMS), SQL Server Integration Services (SSIS), Sybase, Microsoft Access, MySQL, Cyberquery Data Dictionary Manager
Software Languages: T-SQL, ANSI-SQL, DAX, C#, Java, VBA, Cyberquery, Enterprise Cyberquery, VB, Perl
Other Software and Processes: Agile, Scrum, TFS, Apache Tomcat, Bugzilla, Git, TortoiseGit, TortoiseSVN, SilkSVN, Software Development Life Cycle (SDLC), Eclipse, CVS, HTML, JSP, Object-Oriented Programming (OOP), JIRA, Agility (ERP System), Subversion, Microsoft Excel and Word, BInformed (Business Intelligence), UNIX, ETL, ITIL 3.0
Work Experience
Senior Reporting Analyst (Contractor)
EPIQ Systems2017 – Present
Implemented assigned Service Requests (SRs) by reviewing functional requirements, developing T-SQL stored procedures using SSMS, creating SSRS reports using Report Builder and Report Designer, setting up SSIS packages, managing Business Systems Analysts and Client Services informational needs, and preparing deployment instructions for database administrators. Developed query/reports (QR) stored procedures that would display data within the Claims Matrix application. Developed T-SQL scripts that would remove and/or add and/or revise parameters so new or updated parameters would display properly in the Claims Matrix application. Developed stored procedures with dynamic SQL. These stored procedures were designed to handle the addition of new databases on the database server without having to be updated. Trained three new Reporting Analysts. Implemented assigned Data Analyst (DA) mass update tasks. Performed Quality Assurance (QA) tasks on pre-disbursement and payment batches. Performed Business System Analyst (BSA) tasks of creating requirements documentation and the pre-production review of reports.
Data Analyst (Contractor)
Umpqua Bank2017 – 2017
Data Analyst Created and tested stored procedures, views and SSIS packages for bulk data inserts and extract, transform and load (ETL) of Home Mortgage Disclosure Act data. Performed data mapping using the Encompass Data Warehouse Reporting Database and Mapping Tool. Supervised the installation/upgrade of Ellie Mae's Encompass Data Warehouse. 1 of 2 Professional Summary continued Developed and tested views and performed quality control on stored procedures, views and SSIS packages.
Report Developer
Barrett Business Services, Inc2016 – 2017
Developed and tested SSRS invoicing reports using Microsoft Visual Studio 2013 Report Designer with embedded T-SQL code. Exported and imported report test data using SSIS running on SQL Server 2012. Project work completed Q4 2016. Created new and maintained existing DAX measures within a SSAS tabular model solution. Enhanced multiple Power BI dashboard visualizations displaying new and runoff Federal Employer Identification Numbers and insurance claim frequencies for the 360 Dashboard project.
Project work completed Q4 2016.
Reporting Engineer / Software Engineer
Vesta Corporation2011 – 2016
In order to support internal and external users, created, tested and maintained hundreds of stored procedures and reports utilizing SSMS, SSRS, Microsoft Visual Studio, Report Builder, Crystal Reports and Web Intelligence. These reports displayed financial, call center and customer aggregated and transactional data. Resolved production incidents by creating T-SQL repair scripts to clean erroneous data within multiple tables in the reporting databases. Streamlined slow running stored procedures by using multiple techniques including adding indexes with and without included columns, populating temp tables with key columns and reviewing execution plan hints. Responsible for scheduling SSRS to deliver Report Builder reports, SQL Agent Jobs to run T-SQL stored procedures and SAP Edge Server to email and archive Crystal Reports and Web Intelligence reports.
Software Developer II
Bridgewell Resources LLC2010 – 2011
Saved company thousands by performing data migration of the sales agent compensation web based interface from Sybase to MS SQL Server and revising T-SQL stored procedures and Java code. Enhanced the sales agent compensation web based interface by altering tables and revising T-SQL stored procedures and Java code resulting in consolidation of data. Provided critical performance data by designing, developing and testing a new Cyberquery report to track data warehouse run days for calculating average sales and inventory.
Programmer/Analyst II
Bridgewell Resources LLC2001 – 2010
Developed, tested and maintained over 400 operational and financial custom reports and ad-hoc data requests dealing with taxes, accounts receivable and accounts payable. Developed, tested and maintained over 150 Enterprise Cyberquery jobs running custom and Agility (ERP System) Cyberquery reports. Designed, developed, tested and maintained a new Java web application to reduced corporate expenses by localizing and consolidating the employment application process. Automated the process for getting stockholders proxy votes and reduced time obtaining reported vote totals by co-designing, developing, testing and maintaining Java web applications. Co-designed, co-developed and maintained a sales agent application using the QlikView business intelligence system which allowed users to data mine sales, costs and gross margins of sales agents. Designed, developed and maintained VBA code in Access applications addressing accounts receivable, import and export documentation, inventory, deferred stock compensation, carrier tracking and job postings.
Education
BS
National UniversityBS
BS
San Jose State UniversityBS