Data analysis and ETL data procurement, building and enhancing Excel dashboards as well as utilizing SQL, SSIS, and Power BI to produce dashboard solutions for management business analytics

• Power BI: Build reports/dashboards, develop time-based measures and logic, troubleshoot data models, conduct data analysis in Power BI• SQL: Write queries and stored procedures, schedule and process jobs• Help design analytical and technical solutions using a rigorous hypothesis-based approach• Coordinate with business function leads to understand and break down problems and develop respective analytical solutions• SharePoint administration, managed wiki page and documentation repositories• Azure Active Directory user management• Azure Synapse used to access Azure Data Lake storage.

Data analysis and ETL data procurement, building and enhancing Excel dashboards as well as utilizing SQL, SSIS, and Power BI to produce dashboard solutions for management business analytics

Utilized SQL, SSIS, and Power BI to produce dashboard solutions for management business analytics. Innovative thinking and customer services provided to best support production needs.- Worked with Contractors and vendors to manage customer needs while providing business dashboards (Microsoft Power BI) to be used for data analytics- Managed Customer feedback with the ability to provide solutions for assisting management achieve better business decisions- Used SQL Service Integration Services (SSIS) package, Windows Scheduled tasks, and Batch file language for scheduled ETL processing

Utilizing SAS programming, SQL report analysis, SharePoint and other automation utilities to make the business process more efficient. Innovating and adding value with the best available research.- SAS, Python, and Batch command language all used for ETL processing- Reporting Dashboards developed with SharePoint- SharePoint Development with reporting and automation

- Troubleshooting proprietary database automation scheduling software (JobAgent), including log analysis and filemanipulation to help with Export, Transformation, and Load processing from flat files to database importing- Working with MSSQL database 2016 technology, including Microsoft SQL Server Reporting Services (SSRS) 2014building reports for KPI and management purposes- SharePoint 2016, Maintaining central documentation repository- Python utilized for ETL processing and data analysis.- Documenting critical software and built Team SharePoint dashboard / wiki solutions- Accessing client systems remotely with Citrix

Primary role: Business Automation (VBA); SQL Reporting; Documentation; SharePoint Data Management

Experience with RDBMS and basic SQL skillsExperience with website hosting, including IIS and/or ApacheApplication administration/configuration experience on Windows Server 2003 through 2012RHEL platformsHL7 experience desired but not requiredKnowledge of computer hardware and networksKnowledge of scripting and programmingPast experience working as a software developer or systems admin

Experience with RDBMS and basic SQL skillsExperience with website hosting, including IIS and/or ApacheApplication administration/configuration experience on Windows Server 2003 through 2012RHEL platformsHL7 experience desired but not requiredKnowledge of computer hardware and networksKnowledge of scripting and programmingPast experience working as a software developer or systems admin

Supporting user base of 130+ users- MSSQL 2008, 2012 analysis- Troubleshooting Software and Hardware- Created Crystal reports, MS Excel macros for automation1. Analyzes and resolves problems associated with existing application systems. Detects, diagnose and reports related problems.2. Responsible for adding new functionality to existing systems.3. Coordinate outsourced network and software support.4. Provide updates, status and completion information on outstanding helpdesk tickets to manager and/or users, via voice mail, email or in person communication5. Troubleshoots, identifies, evaluates and corrects software and/or procedural problems.

- Fleet Management Software- Fuel Optimization

- Adolescent Development- Supported Troubled Youth- Teaching Life Skills