SUMMARY:

• Over 15 years of experience working with end users and across multiple teams to define requirements, processes and future state goals, produced requirements documentation, timelines and milestone measures. Analysis of complex databases, data sets, software root cause analysis, solutions development and process improvement.
• Extensive SSRS, SSIS T - SQL and SQLPlus query development, stored procedures, triggers, SQL agent jobs, SSIS package development. Extensive ad hoc and reoccurring report development with SQL Server, Oracle, MySQL and Ingres databases. Hands on experience with Crystal Reports, SSRS, SSIS, SSAS and Excel.

TECHNICAL SKILLS:

• SQL Server
• Oracle
• Power Query
• Power Pivot
• Excel
• Informix
• Ingres
• Sybase
• SSIS
• SSRS
• SSAS
• TFS
• Jira
• Procedural manuals bug reports installation guides
• Step by step procedures enhancement proposals and post-mortem write-ups.

PROFESSIONAL EXPERIENCE:

Data Analyst

Confidential

Responsibilities:

• Report development using SSRS, Cognos, AS-400, Excel and/or Powerpoint. Monitor mainframe and Cognos jobs on an on-call basis for failures and restarts.

Technology - SSMS, SSRS, SSIS, SSAS, Cognos, AS-400 Excel, TFS, OneNote, Teams

I.T. Business Analyst

Confidential

Responsibilities:

• Developed quality metrics and reports using Microsoft’s SSAS, MDX, Excel and SSRS.

Technology - SSMS, SSRS, SSIS, SSAS, MDX, Excel, PowerPivot, PowerQuery, Power BI, Sharepoint, Teams

Business Analyst

Confidential

Responsibilities:

• Tasked with developing complex reports using in house and Oracle products for use in managing Confidential ’s Seller Support workforce globally.

Technology - Oracle, SQLPlus, PL/SQL, Excel, Power Query, OBIEE

Data Quality Analyst / SQL Developer / Reports Developer

Confidential

Responsibilities:

• Provided analysis, SQL, SSIS development and report development as a contract SSRS analyst with Confidential, a large healthcare company specializing in Medicare and Medicaid health insurance products and services.

Technology - Excel, T-SQL, SSRS, SSIS, Sharepoint

Data Quality Analyst

Confidential

• Focused on data quality analysis and ETL development. Tasked analyzing data sets for accuracy, compliance standards and missing data as part of annual HEDIS (Healthcare Effectiveness and Data Information Set). Working primarily with Excel based data sets.

Technology - Excel, T-SQL, Inovalon Indices, Sharepoint

Database Specialist

Confidential

Responsibilities:

• Brought in to work on backlog project deploying and configuring massively complex enterprise software suite using SQL Server backend. Work includes using T-SQL to modify customer code, DBA skills, Windows Server skills and customer relationship savvy.

Technology - SQL Server 2000, 2005, 2008. SSIS, Windows Server 2008 R2, 2012, Sharepoint, Access, Oracle

SQL Developer

Confidential

Responsibilities:

• Responsible for SQL development as part of the data validation team developing complex customized T-SQL scripts and ETL processes to fix multiple data quality issues for Corvel Inc. in downtown Portland. Issues that are being addressed include inconsistent data patterns based on business rules and business logic, duplicate data, missing data, and other issues related to poorly implemented data capture processes.

Technology - SQL Server 2000, 2005, 2008. SSIS, SSRS, Excel, TFS, Sharepoint

Report Developer / DBA

Confidential - Everett, WA

Responsibilities:

• Short term role as both a SQL Server DBA and report developer. Created reports for Compass Health’s patient tracking system being switched over from “Raintree” to “PsychConsult.”
• Performed basic DBA duties including moving a production databases to a new server along with the SSIS packages and stored procedures.

Technology - SQL Server 2000, 2005, 2008. SSIS, SSRS, Excel, TFS, Sharepoint

SQL Technical Analyst (Contract)

Confidential - Bellevue, WA

• Contract technical analyst for Confidential . Instrumental in the company’s migration.

Technology - SQL Server 2000, 2005, 2008. SSIS, SSRS, Excel

Data Analyst / T-SQL Developer

Confidential - Beaverton, OR

Responsibilities:

• Developed ad hoc and / or reoccurring reports for daily, weekly and monthly usage using SSRS and/or Excel.

Technology - SQL Server 2000, 2005, 2008. SSIS, SSRS, Excel, TFS, Sharepoint

Email Migration Consultant

Confidential- Tigard, OR

Responsibilities:

• Provided support services to end users at New York Presbyterian Hospital in New York City during large scale email migration from Thunderbird to Outlook Web Access.

Technology - SQL Server 2000, 2005, 2008. SSIS, SSRS, Excel, TFS

Data Analyst

Confidential - Portland, OR

Responsibilities:

• Developed ad hoc, weekly and daily reports, analyzed reported data problems and developed ways of fixing reported data related issues.

Technology - Oracle 10, SQLPlus, Toad, Excel and Crystal Reports.

Technical Support Engineer

Confidential - Portland, OR

Responsibilities:

• Researched reported data and software problems. Developed ad hoc and reoccurring reports for management. Wrote and deployed complex batch scripts for problem resolution.

Technology - Access, SQL Server, T-SQL, Crystal Reports, SSRS, Excel, MS Word, batch scripting, Fiddler, HTML, XML, C#, ASP.Net, JavaScript., Sharepoint

Text Application Analyst

Confidential - Franklin, TN

Responsibilities:

• Performed root cause analysis at the code level, dissected stored procedures, created stored procedures, triggers, SQL jobs.

Technology - SQL Server, T-SQL, Access, Excel, Visio, Fiddler, Remedy, UltraEdit, Python, XML, HTML, XML, C#, ASP.Net, JavaScript, VB Script, Sharepoint