Center Specialist Application Analyst

Ja'el Johnson

************@***.*** • 216-***-****

LinkedIn • OH, US

Accomplished and result-oriented professional with proven track record of performing complex data analysis tasks, including data cleaning, transformation, and aggregation. Exemplify extensive background in utilizing analytical applications and languages to identify trends and relationships between different pieces of data, drawing appropriate conclusions and translating analytical findings into business strategies or analytics software. Skilled in creating visually appealing and informative reports, dashboards, and presentations using tools such as Tableau, Power BI, and Excel. Demonstrate expertise in managing and organizing large and complex data sets using database management systems like SQL Server, MySQL, and Oracle. Exhibit ability to write complex SQL queries to extract data, perform joins, and manipulate data, ensuring data accuracy and completeness. Craft ETL Processes to source and link data in preparation for algorithm development. Possess solid understanding of business operations and ability to identify data-driven solutions to complex business problems.

Areas of Expertise

Databases

Data Transformation

Project Management

Process Improvement

Data Analytics

Business Operations

Data-Driven Solutions

Training & Development

Teambuilding & Leadership

Technical Skills

Crystal Reports Active Directory Essbase Active Reports Microsoft Office Suite Peregrine Salesforce Visio VBA Macros Visual Basic SSRS SSIS Microsoft Sequel Server MRI Software Salesforce Tableau Power BI POS SharePoint CRM McKesson Horizon VMware Analyzer ADP Windows Server Citrix ServiceNow Python Advanced Excel Advanced Access Pivot Tables VLOOKUP POWER APPS POWER Automate

Professional Experience

Technology Innovation Consulting, Cleveland, Ohio Sept 2020 – Present

IT Consultant

●Collaborate with businesses to identify and evaluate existing technologies, determine solutions for existing problems, and develop implementation plans that streamline processes and improve efficiency for financial, healthcare and governmental organizations.

●Identified and implemented technology solutions that streamlined customers processes and improved efficiency for businesses.

●Optimized electronic medical records and ensured compliance with industry regulations during EMR/EHR upgrades and workflow changes.

●Developed reports with actionable recommendations for improvement based on analysis of performance metrics and trends.

●Migrated data from end-to-end with minimal downtime and ensured data integrity.

●Developed and implemented complex SQL queries and stored procedures to improve data accuracy and reduce processing time.

●Manage multiple data warehousing and analytics development projects, working with cross-functional teams to ensure accurate and timely delivery.

●Utilize data visualization tools to develop reports that are easy to understand as well as visually appealing.

Asurint, Cleveland, Ohio Jan 2017 – Jul 2019

SSRS Developer

●Successfully eliminated a backlog of 1500 SSRS reports in under 6 months.

●Utilized analytical skills to identify relationships among complex pieces of information and developed valuable conclusions that provided insights to management and other stakeholders.

●Collaborated with all levels of the organization to report and analyze data.

●Developed complex T-SQL queries and stored procedures to extract data from various databases.

●Cataloged database customizations for seamless testing upgrades to ensure uninterrupted business processes.

●. Evaluated and recommended technologies to streamline processes and increase efficiency.

Greater Cleveland Regional Transit Authority, Cleveland, Ohio Apr 2015 – Dec 2016

Senior Applications Analyst

●Oversaw the implementation of PCI Compliance guidelines across the entire organization,

●Hastus System Administrator, administered upgrades, user access, and troubleshooting technical issues to ensure uninterrupted service.

●Improved ETL processes by developing and maintaining SSIS packages, resulting in reduced processing time and enhanced data accuracy.

●Utilized Excel and Visual Basic to create real-time dashboards for tracking key performance indicators (KPIs) and supporting informed decision-making by business stakeholders.

●Streamlined workflows and increased efficiency by redefining business processes.

●Extracted data from various databases and improved data accuracy while reducing processing time by developing complex T-SQL queries and stored procedures.

●SSIS development/Microsoft Power BI/ Sisense

Vision Computer Concepts, Cleveland, Ohio Dec 2009 – Jun 2018

IT Business Consultant

Collaborated with clients to establish project scope, budget, and timeline, ensuring projects delivery on time and within budget. Created informative dashboards to reflect organizational trends and provide valuable insights for data-driven decision-making. Spearheaded EMR/EHR upgrades for Epic, Clarity, Allscripts, Horizon, and other systems, ensuring smooth transitions with minimal impact on daily operations. Established KPIs, operational requirements, and system goals to align IT initiatives with business objectives. Guided organizations in adopting process improvement and collaborative approach to project management, leading to improved project outcomes and increased stakeholder satisfaction.

●Examined, improved, and documented business processes, pinpointing opportunities for streamlining and automation, resulting in increased efficiency and cost savings.

●Utilized SQL SERVER expertise to develop and maintain stored procedures, ad hoc queries, and complex relational database designs, improving data management and analysis capabilities.

Additional Experience

SQL Developer, Philips Healthcare, Cleveland, Ohio

Acting Director of IT Senior IT Reporting Application Analyst, Visiting Nurse Association of Ohio, Cleveland, Ohio

Financial Report Analyst, The Cleveland Indians (Guardians), Cleveland Ohio

SQL Developer, Intuit, Highland Heights, Ohio

Education

Bachelor’s Degree in Computer Information Systems

University of Phoenix, Phoenix, Arizona

Associates of Applied Business

Cuyahoga Community College, Highland Hills, Ohio

Contact this candidate