About Me
A portfolio of my professional experience and work ethic working as a business intelligence analyst and report writer.
I’m Frank pelosi
2010
Jesuit Alumni Volunteer
I am a 2010 graduate of Loyola University Chicago with a degree in Physics and a minor in Mathematics. Currently, I am a QlikView Developer III and System Administrator for FirstEnergy.
Since graduation I have worked in secondary education, executive compensation consulting, and healthcare analytics, filling various technology and analysis needs. Immediately after receiving my degree, I served full-time as a Jesuit Alumni Volunteer (JAV) working at Christ the King Jesuit College Prep. As a technology teacher, I taught Microsoft Office with a focus on Excel, Word, and PowerPoint.
2011
The Delves Group
After completing the JAV program, I was hired as an Associate Consultant at The Delves Group. I created compensation reports to be used by corporate boards when bench-marking their executive’s compensation relative to their peer companies. The Delves Group was acquired by Towers Watson at which point I moved my career to Buffalo.
2013
University Pediatric Dentistry
I began working for University Pediatric Dentistry in 2013. I spent most of my days working with a software called QlikView. My efforts were focused on integrating our various practice management systems and providing finance and operations with all-encompassing reports. The reports I built were used to determine production, forecast revenue, and inform staffing decisions.
2016
FirstEnergy
Currently, I work at FirstEnergy as a Data Modeler. In the past, I worked as an ELT Developer, QlikView Developer, and QlikView System Administrator. At FirstEnergy, I manage a diverse portfolio of dashboards and reporting solutions for multiple business units including:
- Energy Delivery, Executive Leadership Team
- Human Resources, Talent Management and Diversity Initiatives
- IT Project Portfolio Management
- Real Estate
- Real Time Operations, Energy Transmission
Take a look at my resume below for more details.
“I have no special talents. I am only passionately curious.”
Albert Einstein
My Resume
Education
Bachelors of Science, Physics at Loyola University Chicago »
Visit the Department of Physics to review the curriculum.
Work Experience
Data Modeler IV at FirstEnergy
- Works with the business to collect, document, and review requirements for the reporting application
- Makes appropriate technological choices in implementation and integration of components while also giving due consideration to availability, maintainability, recovery, security, performance and governance requirements
- Defines and creates Data Lake and Data Warehousing models for reporting or analytics
- Provides 24/7 support during on-call rotations, ensuring reliability of production systems
ETL Developer IV at FirstEnergy
- Team lead for the Finance business unit during the QlikView to Power BI conversion project
- Developed data integration process flows and data mappings using Informatica PowerCenter
- Collaborated with the Data Modeling and Reporting team to understand and implement load processes for reporting and analytic data structures such as data warehouses, data marts, and data lakes
- Provided 24/7 support during on-call rotations ensuring reliability of production systems
QlikView Developer IV and System Administrator at FirstEnergy »
QlikView System Administrator responsibilities include:
- Supported and monitored production (10 servers), development (5 servers), and test (5 servers) environments
- Provided 24/7 support during on-call rotations ensuring reliability of production systems
- Monitored 1,500+ scheduled jobs for QlikView, NPrinting and Autosys
- Provided user support for 3,100+ dashboard users and developers; trained developers on QlikView best practices
QlikView Developer IV responsibilities include:
- Built dashboards to improve system checks, eliminated manual retrieval of data, and improved the quality and consumption of data
- Developed and maintained dashboards for multiple business units including Real Estate; Real Time Operations, Energy Transmission; Human Resources, Talent Management and Diversity Initiatives; Energy Delivery, Executive Leadership Team; and IT Project Portfolio Management
- Communicated with business clients to define project requirements, scope, and schedule
- Facilitated change-management processes, including user acceptance testing and migration process
Member of FirstEnergy Young Professionals and their Social Committee responsible for organizing and planning events for members
Analytics Coordinator at University Pediatric Dentistry »
From May 2013 to September 2016, I worked for University Pediatric Dentistry which is a dental practice in Buffalo, NY with eight locations and 100,000+ patient visits per year.
- Build and maintain clinical and clerical reports using QlikView Business Intelligence tools.
- Conduct data analyses by extracting data from various practice management systems.
- Interpret results and assist in the presentation of data to colleagues for use in decision making.
- Managed software development of PythonDDS for the University at Buffalo School of Dental Medicine.
Associate Consultant at The Delves Group »
From January 2012 to March 2013, I worked for The Delves Group which is a boutique management and strategy consulting firm in Chicago, Il with with a focus on executive compensation.
- Examined and evaluated executive compensation relative to peer market consensus.
- Conversed with colleagues to determine type of analysis, peer group, revenue scopes, and position matches.
- Collected salary, annual incentive, and long-term incentive data from multiple survey sources.
- Assessed and performed analysis on collected compensation data using analytic tools.
Co-Director, Bank Compensation and Benefits Survey at The Delves Group »
- Published an annual national compensation and benefits survey for community banks and credit unions.
- Designed and implemented Microsoft Access database to house, analyze, and report collected survey data to provide greater control and usability for both participants and The Delves Group.
- Marketing and sales to 1,500+ potential participants and purchasers with $60,000+ in annual sales.
Program Coordinator and Technology Teacher »
- Managed relationships between 18 corporate employers and 72 student interns participating in a work-study internship program.
- Analyzed program performance data, presented results to corporate employers and staff.
- Taught Freshman Technology focused primarily on Microsoft Office Suite.
- Developed performance improvement program for 20 student interns who received borderline internship reviews.
- Coordinated ‘Teacher to Work Day,’ an opportunity for faculty to visit students at their work site.
Professional Development
Masters Summit for Qlik
In November of 2019, I attended The Masters Summit in Washington, D.C.
“The goal of the Masters Summit is to take your QlikView® and Qlik Sense® skills to the next level and help you become a Qlik® master. Through hands-on sessions, we will demonstrate how to use best practices to deploy Qlik® as an enterprise solution and to build maintainable and scalable solutions.”
Data Science Pathway at DriveIT
The Data Science pathway consists of courses that allow experienced developers and database professionals to move into data science roles within their companies.
I have completed the following courses:
- What is Data Science?
- Intro to Relational Databases
- SQL I
- Programming Concepts with Python 1
- Programming Concepts with Python 2
Certified ScrumMaster at The Computer Workshop
In March of 2017, I attended The Certified ScrumMaster course in Akron, OH which is a two-day, entry-level course taught by a Certified Scrum Trainer. The course is designed to cover all the basics of Scrum so you can begin to fulfill the ScrumMaster role.
In the course, I learned about:
- Scrum basics and core values
- How the Scrum framework compares to other methods, such as waterfall
- How to identify when to use Scrum
- A Scrum team’s three roles and responsibilities
- Scrum meetings, including the Sprint Review, Sprint Retrospective and Release Planning
- Sprint Backlog and Product Backlog
- Scrum artifacts, including the Product Backlog, Sprint Backlog and Burndown Charts
Project Management Certificate Program at University at Buffalo, School of Management »
By completing this program, I am able to:
- Generate project requirements and criteria for evaluating project success
- Create a work breakdown structure with specifications
- Design a project schedule with activities, durations and interdependencies
- Delineate, assign and track project resources and associated costs
- Identify and quantify project risk and develop mitigation strategies
- Understand different contract types and their impact on a project
- Identify, capture and analyze metrics used in controlling a project
- Understand the leadership competencies of successful project managers
- Understand how to build successful project teams or deal with issues affecting their performance
- Apply project management tools to avoid some of the most common problems which plague today’s project managers
QlikView Developer Training at QlikTech »
In October of 2014, I attended the QlikView Developer training in Chicago, IL.
“Knowledge of the data model, creation of the proper data connections and scripting fundamentals are critical to creating QlikView documents that provide your organization with powerful business discovery tools. QlikView Developer provides you with an opportunity to learn by doing through a series of lectures and hands on exercises focused on developing QlikView documents. Beginning with the QlikView environment and ending with an introduction to advanced interface design, the Developer course will prepare you to take your QlikView documents to the next level. The course concludes with a new business case where you can practice your skills in building a QlikView document from the beginning using identified key performance indicators.” -QlikTech
QlikView Designer Training at QlikTech »
In October of 2014, I attended the QlikView Designer training in Chicago, IL.
“QlikView Designer is a scenario based course covering the fundamentals required to get started building QlikView applications. The course is a mixture of demonstrations and hands-on exercises which include user interface layout, design fundamentals, how to create a QlikView application with sheets as well as best practices in design. Additionally, the course will take an in-depth look at the different charts and graphs available to developers and business users inside of QlikView applications.” -QlikTech
Legendary Service at The Ritz-Carlton at The Ritz-Carlton Leadership Center »
In July of 2013, I attended the Legendary Service at The Ritz-Carlton training in Orlando,FL.
Visit the Ritz-Carlton Leadership Center for more information.