Summary
Overview
Work History
Education
Skills
Timeline
Generic

Jerry Abe

Olathe,KS

Summary

Motivated and skilled SQL/Power BI Developer with 6 years of experience in designing, developing, and optimizing database solutions. Proficient in SQL Server versions 2019, 2014, 2012, and 2008R2/2008, ETL processes using SSIS and DTS, reporting with SSRS, and data visualization with Power BI. Adept at collaborating with cross-functional teams to deliver high-quality solutions that meet business requirements. Data Analyst and BI Developer with 6 years of extensive experience in Power BI, SSIS, SSRS, and ETL processes, driving data-driven decision-making for diverse industries. Proficient in designing and implementing complex ETL workflows using SSIS, ensuring seamless data integration and transformation from heterogeneous sources to data warehouses. Skilled in creating interactive and visually engaging reports and dashboards using Power BI, providing actionable insights to stakeholders at all organizational levels. Strong expertise in SQL and T-SQL, proficiently querying and manipulating data to extract meaningful information for analysis and reporting. Proven ability to optimize database performance through index tuning, query optimization, and database design enhancements, resulting in improved system responsiveness. Experienced in designing and deploying SSRS reports, delivering crucial information in a concise and visually appealing manner to key business users. Data-driven mindset with a keen eye for data quality, conducting data validation and profiling to ensure accuracy and reliability in reporting and analysis. Collaborative team player, working effectively with cross-functional teams to gather business requirements and deliver data solutions that align with organizational goals. Strong analytical skills, capable of interpreting complex data sets and providing actionable insights to guide strategic business decisions. Excellent communication and presentation abilities, capable of effectively conveying technical information to non-technical audiences.

Overview

6
6
years of professional experience

Work History

SQL/BI Developer

American Express
09.2022 - Current
  • Lead development and implementation of SSIS packages for extracting, transforming, and loading data from various sources into data warehouse, reducing data integration time by 25%
  • Design and maintain Power BI dashboards, enabling real-time monitoring of key performance indicators and facilitating data-driven decision-making for sales and marketing teams.
  • Collaborate with business analysts and stakeholders to gather requirements and translate them into actionable reports and visualizations using SSRS and Power BI
  • Conduct comprehensive data analysis to identify trends and insights, contributing to a 15% increase in revenue and operational efficiency.
  • Implement data quality checks and data profiling to ensure data accuracy and consistency across organization, improving data reliability for reporting purposes.
  • Provide technical expertise in SQL and T-SQL to optimize complex queries and stored procedures, resulting in 20% reduction in query execution time.
  • Work closely with IT team to streamline ETL processes and automate data workflows, enhancing data delivery and overall system efficiency.
  • Lead training sessions for business users on Power BI and SSRS reporting tools, empowering them to leverage data for independent analysis and reporting needs.
  • Act as subject matter expert for data governance and best practices, ensuring compliance with data security and privacy regulations.
  • Collaborate with data architects to design and maintain data models, providing a strong foundation for accurate and efficient data analysis.

SQL/Power BI Developer

Citizens Financial
08.2019 - 08.2022
  • Develop and maintain complex SQL queries, stored procedures, functions, and views to support data retrieval and manipulation for various applications and reporting needs
  • Design and implement ETL processes using SSIS to extract, transform, and load data from heterogeneous sources into data warehouses and data marts
  • Collaborate with business analysts and stakeholders to gather and analyze requirements, ensuring data solutions align with business objectives
  • Create interactive and visually appealing reports and dashboards using Power BI, providing key insights for business decision-making
  • Optimize database performance by conducting query tuning, index optimization, and database performance analysis
  • Conduct data validation and ensure data integrity across systems and databases
  • Develop and maintain automated PowerShell and VBScript scripts for automating routine tasks and data management processes
  • Provide technical support and troubleshooting for database-related issues to internal teams.

SQL Developer

Home Depot
06.2017 - 07.2019
  • Developed and maintained SQL Server databases, managing database security, backup, and recovery procedures.
  • Designed and implemented data integration solutions using SSIS to synchronize data between various systems and databases.
  • Assisted in migration of databases from SQL Server 2008 to SQL Server 2014, ensuring data consistency and minimal downtime.
  • Created and scheduled reports using SSRS, enabling business users to access real-time data insights.
  • Conducted data analysis and profiling to identify data quality issues and implemented corrective measures.
  • Collaborated with software developers to optimize SQL queries in application code.

Education

Bachelor of Science - Computer Science

Microsoft Certified: SQL Server Database Development Associate - undefined

Skills

  • Skill Summary:
  • Database: SQL Server 2019, SQL Server 2014, SQL Server 2012, SQL Server 2008R2/2008
  • ETL Tools: SSIS, DTS, BCP
  • Reporting: SSRS (SQL Server Reporting Services)
  • Data Visualization: Power BI, MS Excel
  • Programming: SQL, T-SQL, PowerShell, VBScript
  • Operating System: Windows Server 2016, Windows 2010, Windows 2008R2, Windows 2008
  • Tools and Software: MS Office, Visual Basic

Timeline

SQL/BI Developer

American Express
09.2022 - Current

SQL/Power BI Developer

Citizens Financial
08.2019 - 08.2022

SQL Developer

Home Depot
06.2017 - 07.2019

Bachelor of Science - Computer Science

Microsoft Certified: SQL Server Database Development Associate - undefined

Jerry Abe