SSRS Developer Data Analyst Business Analyst

Summary

• Deep understanding of relational database structure, including primary keys, foreign keys, and table normalization

• Detail-oriented and highly skilled SSRS Developer with 12 years’ experience in designing, developing, and deploying interactive and highly efficient reports using SQL Server Reporting Services (SSRS) and Power BI

• Adept at analyzing complex business requirements, creating custom reports, optimizing performance, and ensuring high-quality reporting solutions.

• Demonstrates extensive experience bridging the gap between business stakeholders evaluating and improving business processes, as well as identifying and implementing reporting solutions

• Collaborates with leadership and technical teams to gather, define, and document requirements, ensuring the voice of the stakeholder is well-represented to ensure timely delivery

• Partners with business users in troubleshooting and issue resolution, ensuring comprehensive user training, to include process documentation, where applicable

• Comprehensive background spanning various industries including (but not limited to) transportation, and insurance benefits administration

• Ability to manage multiple projects and deadlines Education

• 2008 – Bachelor of Arts in Business, Murray State University, Murray, KY Skills & Training

• Experience using analytical Tools such as PowerBI, Snowflake, and SQL /

• 2017 - 2019 – IA Health & Life Insurance License

• 2016 – Six Sigma Black Belt Training, Ruan Transportation, Des Moines, IA

• 2014 – Microsoft SQL Training, New Horizons, Des Moines, IA Professional Experience

• Senior Business Analyst/Data Analyst/SSRS Developer Ruan Transportation 2019 – present Des Moines, IA

• Primary Responsibilities:

Work closely with business users to gather reporting requirement, translating into technical specifications

Design, develop, and deploy dynamic reports and dashboards using SSRS to align with organization needs, delivering real-time, actionable insights to stakeholders

Write complex SQL queries and stored procedures to extract data from various relational databases (SQL Server, Oracle, Snowflake) for report generation

Optimize the performance of reports, queries, and data retrieval processes to ensure efficient and fast report generation

Use parameters, expressions, and custom functions to create interactive and parameterized reports, improving end-user experience

Create process documentation (for SSRS report development) and end user release notes (for new/updated reports)

Experienced in a variety of analytics tools such as SQL Server Reporting Services, SQL Server Management Studio, and Power BI

• Significant Accomplishments:

Received Extra Mile Award (2x) for Mileage (Data Validation) Project (2020) and Significant Cross-Teaming

(2023)

• Client Services Analyst Businessolver

2016 – 2019 West Des Moines, IA

• Primary Responsibilities:

Responsible to provide health, life, and ancillary benefit support (3rd party administration) for enterprise clients (having more than 5,000 employees) with a high degree of competency and attention to detail

Responsible to lead projects, utilize insurance knowledge/understanding along with analytical abilities to perform root-cause analysis - determining financial impact, process gaps, and making recommendations for system configuration changes

Utilized extensive payroll experience in performing payroll and benefit analysis and reconciliations between disparate systems

Created customer-specific reporting, training end users, as needed

• Significant Accomplishments:

Guide and mentor team members, providing training on best practices to ensure data accuracy across the team

Professional Experience (continued)

• Benefits Accountant/Systems Analyst Merit Resources 2011 – 2015 West Des Moines, IA

• Primary Responsibilities:

Perform benefit data analysis, interpreting trends and identifying benefit discrepancies

Utilized data analytics and querying skills to complete quality testing for SQL Server Reporting Services paginated reports

Evaluate data from disparate sources, capturing data for validation and root-cause analysis

• Significant Accomplishments:

Collaborated in developing SQL Server Reporting Services reporting tool, simplifying benefit reconciliation process

• Controller Lafferty & Sons

2004 – 2008 Clarksville, TN

• Primary Responsibilities:

Responsible for managerial and financial accounting to include reporting and analytics

Evaluate cost measurements, identifying and implement cost-reduction measures

Demonstrated capacity for leading and training staff to perform accurate accounting and insurance auditing functions

Managed payroll process to ensure adherence to wage standards and compliance to government contracts

• Significant Accomplishments:

Developed database for warranty tracking, simplifying method to evaluate gaps in construction process

• References supplied upon request

Contact this candidate