- Use Yellowbrick via DBeaver for PostgreSQL development- Converting SSIS and SQL Server objects to Yellowbrick PostgreSQL- Designed a dimensional model for Claims Analytics in Yellowbrick PostgreSQL, with an SSIS package and a SQL Agent Job that refreshes the data daily- Created partitioned Power BI XMLA endpoint dataset refreshes- Develop SQL in Dev and Uat environments. When a project is ready to be deployed to production, I submit request tickets to a production team for them to implement the additions.- Creating SQL Server scripts for ad-hoc reporting- Automating manual processes using SQL Server, SSIS and SSISDB with SQL agent jobs- SSIS packages using package variables, project parameters, SSISDB environment variables, foreach loops and C# scripting- Automated a manual SharePoint/Power BI process using Power Automate, SSIS and SQL Server tables- Identifying discrepancies between SQL data sources- Syncing projects with DevOps Azure Repos- Familiar with SQL Server: Stored procedures, views, tables, triggers, logging, agent jobs, CTEs, temp tables- Familiar with RedGate SQL Prompt for query formatting- Basic Python 3 and C# scripting

- Develop end-to-end reporting for customers from source systems SAP HANA MM, Fireworks, NetBuild, Oracle, SQL Server, and SFTP- Develop and maintain SSIS ETL packages, SQL agent jobs, stored procedures, tables, and views- Automate downloading SAP Ariba data and inserting into SQL Server tables using Ariba APIs, SSIS, and C#- Automate downloaded FTP/SFTP files to push to SQL Server using SSIS ETL and SQL Agent Jobs- Use temp tables and indexes when necessary to improve stored procedure performance- Utilize best practice techniques to improve data load times- Basic knowledge of C# for SSIS scripting- Support and assist junior developers

- (Parts Harvesting) Track the movement of parts for the purpose of identifying parts that can be re-used instead of purchasing a part as brand new, using the SAP GUI and SAP SQL tables.- Developed and/or automated reports for customers using SSRS, Excel and Tableau

- Automated the waiving of district approved program fees in Infinite Campus application for free and reduced eligible students using SQL Server- Integrated and administrated applications, and provide user support- Uploaded SAT, PSAT, AP, CMAS test scores into Infinite Campus- Developed SQL scripts for data files requested by Equal Opportunity Schools (EOS)- Developed SQL scripts for data files requested by Civil Rights Data Collection (CRDC)- Managed free or reduced student assigned fees eligible for exemption- Provided support for assigned help-desk tickets- Developed ad-hoc reports using SSRS or Excel- Created custom tabs in Infinite Campus- Created an FTP account to allow the transfer of files from a third-party cloud-based reporting application to an employer hosted remote server- Basic knowledge of creating and using batch files- Created a monthly fee balance job that sends student fee balance emails to parents as of the end of the previous monthExperience using MS Excel, SQL Server, SSRS, Infinite Campus, OneRoster, PaySchools, Alio Intelligence (SAP Business Objects), Schoology and TortoiseSVN.

- Developed Excel data validation tool for SSAS source to target cube comparison- Usability testing and navigation testing of business intelligence reports- Structural testing of business intelligence data sources- Performance testing of business intelligence reports- Maintained sales funnel SSIS ETL package and pushed funnel data to production environment every month- Maintained CDN/VYVX/IP/Credits/MOU traffic units SSIS packages- Developed a reporting glossary for all terms and KPIsIn the reporting GUI testing (manual), - Ensured all filters are working correctly and that they are applying to all views, as necessary.- Noted performance times- Ensured hover tooltips are using standardized labels for values- Checked for formatting of values (several times I'll come across currency values that are not formatted with currency signs)- Checked to see that there are not any grammar or spelling mistakes- Ensured attribute names were consistent/normalized across all reports- Ensured all actions work correctly - Checked that links going to webpages actually make it to those webpages - Checked that action filters actually filter other viewsIn the reporting data testing (manual),- Ensured visual data is computing correctly, such as YTD Growth % vs YOY Growth % or add and subtract- Ensured data being displayed ties out to the true data source, using Excel spreadsheets. If the data does not tie out, then I inform the developer where the inconsistencies are at.Experience using MS Excel, SQL Server, Tableau and Essbase Excel Add-In.

- Collaborated with stakeholders, project managers, and software engineers to understand report requirements- Gathered reporting requirements to develop Tableau and SharePoint dashboards for Marketing, Sales, Finance, Proforma and Supply Chain Management- Developed SQL data sets for Tableau and Excel and manually tested for accuracy- Developed and maintained SQL Server tables, stored procedures, views, and functions - Familiar with using temp tables, common tables expressions, sub queries and optimizing queries using execution plan index suggestions- Developed SSIS ETL packages to migrate tables and to run stored procedures using an agent job- Maintained sales funnel SSIS package and pushed funnel data to production environment every monthExperience using Excel PowerPivot, SQL Server, Tableau, and Essbase Excel Add-In.

- Extracted data from retired/decommissioned applications from multiple sources into a SQL Server archive database- Developed, tested and maintained SSRS reports using extracted application data- Maintained Rally reports for application data using Rally Rest API C#- Developed and maintained Microsoft SQL and Oracle SQL tablesExperience using SSRS, SQL Server, Rally, Oracle, SybaseIT Intern - Application Rationalization (Sept 4, 2012 - June 21, 2013)Full-time employee (June 22, 2013 to March 14, 2014)

Installed and troubleshooted electrical equipment for commercial applications.- Sites worked at include Ralph L. Carr Colorado Judicial Center (Denver), 1800 Larimer (Denver), Twitter data center (Salt Lake City), National Renewable Energy Laboratory- Energy System Integrated Facility (Golden, CO), Lone Tree Arts Center (Lone Tree, CO)

- Reconciled cash accounts with the general ledger accounts.- Processed customer invoicing on a daily basis and mail to the customer.- Posted incoming credit card, wire transfers and PayPal cash receipts.- Posted purchase order and non-purchase vendor invoices on a day-by-day basis.- Issued accounts payable vendor payments on an as-needed basis.- Processed customer refunds on a pre-approval basis.

- Manually entered verified invoice data into financial system.- Improved written procedures for invoice imaging and work flow.- Audited expense reports for proper supporting documentation and approvals.- Self-managed daily workload to meet individual metrics and departmental SLAs.- Assisted with sorting and batching received items for proper scanning into imaging.Experience using PeopleSoft and Documentum

- Posted invoice billings and charges.- Reconciled petty cash funds on a monthly basis.- Posted cash receipts into appropriate financial system.- Prepared bank deposits for employer and client accounts.- Audited COBRA checks for client accounts paid by plan participants.- Reconciled bank statements, vendor statements, and credit card statements.- Issue refund checks, and payables checks (as needed), in a timely manner.- Processed FSA claims.Experience using QuickBooks, Crystal Reports, MS Excel