Developed spreadsheets, data warehouse and report design, SQL scripts

• SQL scripting/analysis/trouble shooting, Stored procedures, User Defined Functions• SSAS development/modification• SSIS development/modification• Assisted with PowerBI development. Utilized aggregate, logical, filtering, text and statistical DAX functions.

Providing additional functionality and modifying existing SQL/MDX code utilizing the company's proprietary Medecreate tool in the continued development and modification of client product.Participated in daily scrum meetings to discuss technical issues involving workload within a two week sprint framework.Created documentation to provide guidance for new BI engineers in handling various development issues.

• Created TSQL scripts, queries and stored procedures for data clean up and reports• Conducted user acceptance testing and data verification to ensure reports functioned properly and accurately• Worked independently and collaboratively in the matter of SQL stored procedure and table function development, indexing and query optimization• Worked in DevOps and Azure environment• Developed and troubleshooted SSRS and PowerBI reports/dashboards. Utilized aggregate, logical, filtering, text and statistical DAX functions.

Created TSQL scripts, queries and stored procedures for ETL processesConducted user acceptance testing and data verification to ensure ETL processes functioned properly and accuratelyWorked independently in the matter of SQL development, indexing and query optimizationDeveloped SSIS packages.Engaged in client tech and support calls.

• Created TSQL scripts, queries, indexes and stored procedures for SSRS reports. (SQL Server 2012)• Created and modified reports using Report Builder/Designer, SSMS and SSRS• Collected the requirements for data collection and reporting design from external and internal customers• Conducted user acceptance testing and data verification to ensure reports functioned properly and accurately

Creating TSQL scripts, queries and stored procedures for Power BI/SSRS reports. (SQL Server 2012, SSMS, Visual Studio 2015).Creating SSIS Packages (encapsulated within scheduled SQL jobs) that import data from Excel spreadsheets into SQL database tables and then populating related normalized tables utilizing stored procedures for reporting and metric purposes. Creating scripts to generate results for state requested measure reports.

• Created TSQL scripts, queries and stored procedures for SSRS reports. (SQL Server 2012)• Created and modified reports using Report Builder/Designer, SSMS and SSRS• Collected the requirements for data collection and reporting design from external and internal customers• Conducted user acceptance testing and data verification to ensure reports functioned properly and accurately• Worked closely with other SQL DBAs in the matter of sql development, indexing and query optimization

• Created TSQL scripts, queries and stored procedures for ETL and reports. (SQL Server 2012)• Created and Modified SSIS packages for ETL processes• Created and modified reports using Report Builder/Designer and SSRS• Queried against data housed in Data Warehouse and created SSAS Cubes• Created and modified .Net web pages using VB.net, JQuery, embedded SSRS reports• Worked within a complex multi database, tera byte sized environment.• Met frequently with management, administrators, developers and teachers to collect and refine requirements for web pages, database/table design and front end functionality• Assisted and collaborated with development team concerning ETL, web and reporting issues.• Conducted user acceptance testing and data verification to ensure reports, cubes, and web pages functioned properly and accurately

• Created TSQL scripts and stored procedures for data scrubbing and reports. (SQL Server 2008 R2)• Created and Modified SSIS packages for ETL process and uploading/updating data into MS CRM• Created and modified reports using Report Builder/Designer and SSRS• Queried against data housed in Data Warehouse and SSAS Cube• Interacted and loaded data into MS-CRM and utilized advanced finds• Interfaced daily with MS SharePoint• Assisted and collaborated with development team concerning ETL and reporting issues.• Frequently consulted with management and account managers to specify additional and revised requirements for report development and data collection.

• Designed, created and maintained a nationwide web application that generated reports, captured and stored data. (ASP.Net, C#, Javascript)• Served as Team Leader in RCS Data Center to coordinate and track projects and tasks. • IT and Web security issues and solutions involving encryption, network and server controls.• Complex business logic problem solving, TSQL queries, cube reporting and data issues.• Designed and developed reports and dashboards to measure severity of clinical data, frequency of visits, and the type of care provided. • Designed and implemented cube reporting (3 Dimensional data) which indicated trends, performance key indicators, frequencies and thresholds. (SSAS, ProClarity)• Extracted and downloaded data from RCS databases (SQL Server and MS Access), MS Excel spreadsheets from a variety of other sources within the VA, and financial data from the information center in Austin, TX to generate reports and analysis of Vet Center program and staff.• Extensive consultation and communication with Regional Directors and Chief Officer in the matter of additional web form and report development as well as quick generation of ad hoc reports.• Team based development environment in small data center located in Golden, CO, serving 250 Vet Centers around the country, 7 Regional Offices and Central Office in Washington, DC.