Jason Auw
Huntersville,NC
Summary
Specializing in utilizing SQL, Python, and Power BI to drive insightful business decisions, with a proven track record of optimizing data processes, streamlining operations, and enhancing overall efficiency. Excels at translating complex data into actionable insights and collaborates seamlessly with cross-functional teams to achieve strategic goals. Passionate about applying analytical acumen and data-driven solutions in a dynamic organization, dedicated to delivering impactful results.
Overview
15
15
years of professional experience
Work History
Sr Pricing Analyst
HONEYWELL
09.2023 - Current
- Automating pricing processes results in 80% reduction in manual errors and a 50% decrease in pricing turnaround time.
- Utilize SQL, Python, and Power BI to analyze pricing data and trends, providing insights to senior management for strategic decision-making.
- Streamline pricing processes and procedures to improve efficiency and accuracy.
- Provide training and support to team members on pricing tools and techniques.
Sr Analytics Professional
HONEYWELL
09.2020 - 01.2023
- Transformed audit process by strategically automating previously manual procedures, yielding 80% enhancement in accuracy and 90% reduction in data entry time.
- Recognized by management as pivotal contributor to project's overall success, demonstrating commitment to efficiency, accuracy, and impactful contributions.
- Revamped audit process through automation, achieving 80% improvement in accuracy and 90% reduction in data entry time.
- Analyzed complex data sets using SQL and Python to identify areas for process improvement and implemented efficient systems for data quality enhancement.
- Collaborated on successful implementation and adoption of automated audit processes, showcasing strong project management skills.
- Built prototype in ServiceNow for transitioning from PowerApps and Power Automate Flow, enabling efficient and streamlined audit workflows.
- Proven ability to develop and implement creative solutions to complex problems
Data Analyst II
DUKE ENERGY
05.2018 - 05.2020
- Achieved significant cost savings for the company, including reducing duplicate payments to vendors by 98%, resulting in hundreds of millions of dollars in annual savings, and improving real-time demand data, resulting in an 88% reduction in late payments, showcasing a strong ability to leverage data-driven insights for significant business results
- Achieved significant cost savings, reducing duplicate payments by 98% and improving real-time demand data, demonstrating a strong ability to leverage data-driven insights
- Created and deployed PowerApps, Power Automate flows, Power BI, and SharePoint for streamlined business processes and workflow management
- Performed business and data analysis using SQL, Business Objects, and other reporting/data mining tools.
EHR Data Analyst
SPECTRUM MEDICAL INC
08.2015 - 01.2018
- Led the successful development of EHR programs by selecting appropriate SDLC methodologies, creating requirements, and ensuring traceability through testing
- This resulted in high-quality, fully functional EHR systems that met business needs and regulations
- Customized SQL databases and maintained software to ensure optimal performance and reliability of systems
- Produced ad hoc reports using SQL Server, Oracle, Excel, and Access, providing timely and accurate data to stakeholders
- Utilized Data Loader to extract and load data from CSV files into Salesforce objects, improving data accuracy and efficiency
- Implemented preventative measures to maintain data quality within Salesforce, ensuring accurate reporting and decision-making.
Systems Implementation Analyst
MEDFLOW, INC.
11.2013 - 08.2015
- Proved ability to identify risks and issues pre-deployment through strong operational skills and stakeholder collaboration for successful implementation
- Promoted to Business Analyst lead for healthcare software implementation
- Assisted Medflow Business Intelligence with data architecture and models for database design
- Migrated SQL database from regional to global, and established consistency across three HUBs
- Reviewed and analyzed data quality using T-SQL and Excel
- Utilized VMWare to create and configure Medflow applications and virtual workstations.
Systems Integration Analyst
TOLT SERVICE GROUP
01.2009 - 11.2013
- Ensured timely billing cycles by coordinating and managing the process from start to approval, handling any rejects and reruns as needed to meet service level agreements
- Coordinated and managed the billing process to ensure timely cycles, handling rejects and reruns as needed to meet SLAs
- Led IT infrastructure projects using Agile/Scrum and traditional Waterfall methodologies to ensure timely and successful delivery
- Directed the distribution of desktop software in a 45,000-managed thin client environment, as well as mobile handset provisioning, to support business operations.
Education
Master of Science in Computer Science -
COLORADO TECHNICAL UNIVERSITY
COLORADO SPRINGS, CO01.2024
Bachelor of Science in Computer Science - undefined
COLORADO TECHNICAL UNIVERSITY
COLORADO SPRINGS, CO01.2020
Skills
- Software Applications
- Testing and debugging
- Code reviews
- HTML and XML
- Software Development Life Cycle (SDLC)
- Code Development
- JIRA
- Scripting Languages: PHP, Python, Javascript
- SQL
- Database Management
- DevOps Integration
- Data dashboard design
- Data Visualization
Timeline
Sr Pricing Analyst
HONEYWELL
09.2023 - Current
Sr Analytics Professional
HONEYWELL
09.2020 - 01.2023
Data Analyst II
DUKE ENERGY
05.2018 - 05.2020
EHR Data Analyst
SPECTRUM MEDICAL INC
08.2015 - 01.2018
Systems Implementation Analyst
MEDFLOW, INC.
11.2013 - 08.2015
Systems Integration Analyst
TOLT SERVICE GROUP
01.2009 - 11.2013
Master of Science in Computer Science -
COLORADO TECHNICAL UNIVERSITY
Bachelor of Science in Computer Science - undefined
COLORADO TECHNICAL UNIVERSITY