Contract with the CDC - BI Development of multiple reports and dashboards

Bi Development of multiple reports and dashboards

• Development of Visualizations to reveal data aggregated from clinical outcome assessments,.• Pushed multiple reports into production for customers to review and use.• Visually, the reports and dashboards were created as templates that I built and became the de facto standard for future report development.• Reports were built from requirements as part of our daily scrum/agile sessions, with two-week turnarounds. • Data sources behind the reports were from multiple SQL Server databases, each designed to work with different customers. The databases were configured along the requirements of Electronic Clinical Outcome Assessments (ECOA/EPRO) and Study Data Tabulation Model (SDTM). platforms and standards• Only PowerBI developer until Verasci was bought out by WCG in 2021.• Reports were maintained in GIT/Azure.Environment – PowerBI, SQL Server and SSMS, Office 365, GIT, Azure

Contract Position – Affordable Care• Short term project, migrate a series of tableau reports into the PowerBI workspace.• Configured reports to match user experience when using Tableau – emulate the reports they currently work with.• Added Measures using DAXEnvironment - Office 365 (Office/Teams), PowerBI, Tableau, SQL Server

I left work at the end of January 2020 to prepare my house for sale. It involved two months of painting, flooring tiling, and overall preparing the house for sale while at the same time looking for employment in the Raleigh/Durham/Chapel Hill Area of NCThis was successful as i moved to Pinehurst NC on 4/19/2020. Ready to take on the world from the East Coast!

Contract Position – Tote Maritime, Inc.• Data Analyst/Report Writer - CargoWise, Cognos, SSRS, Visual Studio• Supporting CargoWise - Add/modify reports created in the CargoWise application system, software used in Maritime/Cargo Shipping.• Add and modify SQL used in reports. using both IBM and SQL Server (T-SQL).• Rapid ramp up with technologies that I had not worked with before (CargoWise, Cognos).Environment -Office 265 (Office/Teams), SQL Server, Visual Studio, SSRS, Cognos, CargoWise,

Dept.: Data Analyst/Engineer - Developer Ecosystem* Provide resources and support to Program Owners for tracking metrics, developing low-to-no-code automation and tools to improve efficiencies of existing processes.* Assist in development of internal tools to track development, retention and addition of users who join the various Technical Organizations and meetings regarding use of Google tools and infrastructure.* Programs IncludeDSC - Developer Student ClubsGBG – Google Business GroupsAll development using Google tools.Environment –Cloud SQL, JavaScript, Data Studio and Google Charts, PLX, AppMaker, MYSQL

• BI Analyst – ISO 37001• Developed a series of BI tools to facilitate gathering of survey data from many countries in regards to ISO 37001 Compliance.• Microsoft Forms – Assisted in development of multiple survey forms used to gather information from Microsoft International ORGS.• Microsoft Excel – Forms only exported data in excel format. Developed Excel workbook apps to gather information from multiple surveys, merge into table format and add series of calculations o Created needed documentation to outline complete application.• PowerBI – Developed a variety of BI Reports to report on the data downloaded from above apps• PowerApps – Built front end used for tracking EGRC (Enterprise Governance, Risk and Compliance) Issues.• Maintained and managed all tools on Sharepoint & Microsoft Team sitesEnvironment –Windows, MS Office 365, PowerBI, PowerApps, Power Query, Sharepoint, SQL Server

Position – Weyerhaeuser • Reporting/Data Analyst/Application Development – Wood Products IT/Manufacturing Applications• Develop new and support of existing BI Solutions, used to track and gather data of wood products manufacturing process, from tree to store. o Report/ BI Development – Reporting Services, PowerApps, Power Bi, Power Query, Power Pivot and Power View)o PowerApps – Reengineered Microsoft Access Databases into PowerApps versions.Backend reporting / BI Data Solutions – SQL Server 2014, Azure DW, Aptean ActivPlant Querybuilder. Development of New Measures as neededo Front end solutions – Aptean manufacturing operations management solutions (Query Builder, VPFlex, VPWeb)o Creation of new data points using in reporting and front end development using Aptean CDC Factory • Support and development of Microsoft Office Solutions, Primarily MS Access and Excel, using VBA.• Front end Testing of new application (RCA – Root Cause Analysis) – Stress, logic and Code testing using ad-hoc and scripted methods. Regular meetings during testing and user training during UAT testing.• Software tracking of changes and scheduling using Microsoft TFS• Ongoing development of 2 C# applications, a Launch form and a replacement of an existing MS Access application, re-engineered into a C# application with SQL Server 2014 back end.Environment –Windows, MS Office, Reporting Services/Report Builder, Visual Studio, PowerApps, Power Bi, Power Query, Power Pivot and Power View, C#, Aptean ERP Suite of Tools, TFS

Contract Position - Microsoft – Redmond• Microsoft Education.• Development of 16 uniquely formatted charts within Excel, used to monitor real time data.• Testing of an excel add-in to process data used in charts above from micro boards, when connecting through USB ports.• Assisted team in miscellaneous preparation for June 2016 International Society for Technology and Education conference in Denver, Colorado.• Investigated feasibility of using Microsoft BI tools as alternate solutions going forward.Environment – Windows 10, Office 365 (VBA), Visual Studio 2015, SQL Server 2014, PowerBI/PowerQuery/PowerPivot

Contract Position - WestRock Pulp And Paper Mill – Tacoma• Power Generation Management.• Enhanced data management and scorecards, tracking power generation data to analyze variances and results, using MS Access, Excel and T-SQL. • SQL Server - Modifications to two data bases used in project, changes to multiple objects.• Re-engineering of GPS application to reduce monitoring intervals of power generated and sold into the public grid, from an hourly basis to 15 minutes. Original source no longer existed. • Replaced previous Power Generation System using Excel, with VBA as the code base to manage real time data. Worked with stakeholders throughout development process, implementation and testing.• Reporting Services - Modifications to SSRS reports as needed used in application, with changes to format, parameters and stored procedures.• Investigated feasibility of using Microsoft BI tools as an alternate solution going forward.Environment – Windows 7, SQL Server 2008r2, Office 2010, SSRS /Report Builder 2012, PowerQuery, Power Pivot

Contract Position - Marcus and Millichap – Seattle• Commercial Real Estate Brokerage – Sales.• SQL Server – modifications/ development of objects used in databases, for reports and data warehouse.• SSIS - Modifications to ETL/Load procedures used for populating data warehouse. • SSRS – Modifications to existing and development of new reports.Environment – Windows 8.1, Visual Studio 2013, SQL Server 2014, SSRS/Report Builder 2012, Office 2013

• Home Loan Refinancing and Bankruptcy Processing.• Started as contract - Robert Half – 8/2012-12/2013 became Full Time Employee - 12/2013• Primary Role – Management of MS Access database named FTS (File Tracking System) used for tracking and processing of private foreclosures/bankruptcies from multiple states, for the purpose of resell; supported multiple local and remote users nationally; Tight deadlines when updating application.• Excel • Maintained quarterly dashboards and development of miscellaneous workbooks as requested • Advanced development using VBA code. • Connectivity to SQL Server, Adobe forms, Word docs, Excel workbooks• Data Analysis/DBA responsibilities • Development, maintenance and support of SQL Server databases used in application • Performance tuning as needed.• Support • Ticket Support (KACE system) with 24 hour turnaround to most cases • User training and presentation as needed. • Projects development – Agile environment.• SSRS – Ongoing maintenance and development of SSRS reports as needed.• Sharepoint – Team site maintenance, security and document management• Adobe – Developed and maintained Adobe documents.• Introduction to PowerQuery.Environment – Windows 7, Office 2010 (All products), Sharepoint 2010, SQL Server 2008r2, Report Builder 2012, PowerQuery

Windows Phone Innovation – Redmond / Bit R&D - Boulder, Colorado – P/T• Site development and ongoing site support – primarily used Sharepoint Designer.• Web Part Development and maintenance.• Maintain metadata and managed terms/term store.Microsoft Advertising, Seattle • Site development and ongoing site support – primarily used Sharepoint Designer.• Site migration from self-hosted to combined MSIT hosted sites.• Security support and maintenance of users and groups • Asset library creation, content branding.• Excel web services implemented.• InfoPath form services implemented with new forms added and existing ones modified.• Workflows added and existing workflows modified.• Transitioned day to day operations to new management when management changed. Environment – Windows 7, SharePoint 2010, InfoPath 2010, SQL Server 2008r2 SSRS, Visual Studio 2010

Contract Position - Amazon – Seattle, WA - Business Analyst/Software Developer • Software development and upgrades of existing application (ARC – Account Receivable Collections Tool). Linked to Oracle Financials and other internal systems.• Development of a new application to track Charge backs against Kindle line (Linked to Oracle Financials). • 3 one-off projects used to validate data from existing financial applications.Contract Position - Microsoft – Small Medium Business, Bellevue - Data Analyst/Software Developer • Worked independently off site• Miscellaneous data requests, analyzing past, present and future trends.• SSIS/Excel – ETL Transform/load of data to excel workbooks, one per customer, each securely stored in Sharepoint site.• Dashboard maintenance to analyze and increase efficiency of performance measures.• Database administration and maintenance including performance tuning. • Miscellaneous projects to automate manual processes coded with VB.Net in Visual Studio.Environment – Windows 7, Microsoft Office 2010, SQL Server 2008/2008sr2, SSIS, SSRS, SharePoint 2007

Microsoft –Bellevue, Project Lead – On Site Team - 4 team members • Migration of servers/applications to Wipro servers from another organization. • Scheduled Sync-ups with Indian Offshore Team to coordinate migration, data validation and Service Requests. Audits developed and run to confirm validity of sales information for compliance purposes.• Team gradually contracted to one person (me) as of 11/2009. The offsite/onsite teams were merged, with my position becoming a hybrid of Data Analysis, Database Administrator and SSIS developer. Environment – Microsoft Office, SQL Server 2000/2005/2008 (SSIS/SSRS), Visual Studio 2008, SharePoint 2007, Windows Server 2008

Contract Position - Pacific Northwest Regional Council of Carpenters (Independent Contract) - Kent • Supported project manager with re-engineering requirements, modifications and new features used to maintaining Profile Information and financial information of multiple union projects. Consolidated data from additional offices. Conversions from single to multi-user.• Data migration from Access to SQL Server 2005 database. Environment – Microsoft Office (Access/Excel), SQL Server 2005

Contract Position - Microsoft – Issaquah, WA - Partner Technical Services/Partner Technical Consultant • Sharepoint 2007 –Sharepoint Training, support and Consultation with Microsoft Partners enrolled in Gold, Certified and Empowered partnerships with different levels of support. Maintaining contract details and encouraged upgrading to higher levels of support. Handled miscellaneous non Sharepoint requests.• Additional support and training to implement InfoPath forms. And MS office implementation.• Data Analysis of department information, using SQL, Excel (pivot tables), VB.Net and Access. Environment – SharePoint 2007, Vista and Windows Server 2008, SQL Server 2005/2008/SSRS, MS Office, Visual Studio 2008 (VB.Net), Clarify, HTML