Power Bi Business Intelligence

Gregory J Siegrist

***** *. ***** ******* 913-***-****

Olathe, KS 66061 ad5d4o@r.postjobfree.com

Business Intelligence Analyst

Innovative and resourceful professional with many years of IT experience and delivered a reputation for delivering success in resource constrained environments. Extensive knowledge of Power BI, Power BI Paginate Reports, SQL, ETL, SSMS, SSRS, SSIS, Word, Excel, Visio, Access, PowerPoint, SharePoint, Erwin, JIRA and learn new things quickly. Gather information from the business using various modeling techniques like Agile, Waterfall, Scrum and knowledge of Azure DevOps. Have been a liaison between the business and technical teams and create business and technical documents in the coordination of projects and be detail oriented. Ability to identify and analyze data and interpret the data. Responsible for helping create and recording test cases, test scripts and testing results and defect tickets during the testing to make sure all the requirements set forth by the business are being tested. This helped increase the growth and profitability in a dynamic, fast paced environment by using written and verbal communication skills. As a business analyst developed an understanding of the process and possess a wide range of skills to help increase the growth of profitability of the company by working on small to large projects as a team member or individual. Able to manage multiple projects while maintaining and supporting projects through impactful analysis, coding and testing. Possesses insightful skills to understand the big picture and how the system and its applications will affect other areas of the company resulting in success.

Summary of Qualifications

Power BI Power BI Paginate Reports Data Analysis

Agile/Waterfall/Scrum Project Management Organization

Building Relationships Communication Skills Decision Making Process

Professional Experience

City of Overland Park May 2023-Present

Business Intelligence Analyst

Responsibilities included working with the Police and Fire Department gathering information to create Power BI models, Power BI Paginate Reports, updating existing models and ETL. Used SQL knowledge when required to help send Ad Hoc reports to them. Worked with the Police and Fire Department using verbal and written communication skills to determine and understand the process. I have been the Project Lead on many projects and am able to manage the time effectively.

Created the PD Legacy RMS in Power BI and Power BI Paginate Reports to create PDF reports for the Police Department. This had high visibility as these reports were to be used on cases for the Police Department. SQL was used to help analyze the data. It was created using Power BI, Paginate Reports, SQL, SSRS and ETL. The business requirements were created in Microsoft Word. The Agile Methodology system was used for this.

Created the PD Officers Data in Power BI Reports for the Police Department. This was to let the captain know what officer’s durations were daily for events they were reported to. SQL was used to help analyze the data. It was created using Power BI, SQL, SSRS, Excel and ETL. The business requirements were created in Microsoft Word. The Agile Methodology system was used for this.

Helped create the Datawarehouse using the Snowflake schema with Fact and Dimension tables. Created the ETL to describe where the data was coming from, transformations and what table the data will be loaded. The business requirements were created in Microsoft Word, Excel and SQL.

Yellow Logistics Oct 2020-May 2023

Business Intelligence Analyst

Responsibilities included working with the business gathering information to create Power BI models and updating existing models. Used SQL and Excel knowledge also when required to help send Ad Hoc reports to the business. Worked with the business using verbal and written communication skills to determine and understand the process. I have been the Project Lead on many projects and am able to manage the time effectively.

Create a Variable Compensation Power BI model to help determine the Variable Compensation amount to pay to Representatives who are booking loads for the company. This had very high visibility all the way to the VP and Directors. It was created in Power BI, SQL, ETL, Microsoft Word and Excel.

Create Executive Summary Report in Power BI model to track how much Variable Compensation the Representatives received from current and previous months. This had very high visibility all the way to the VP and Directors. It was created in Power BI, SQL, ETL, Microsoft Word and Excel.

Responsible for utilizing general business acumen and the ability to analyze the transportation industry to provide business improvement recommendations. This involved working with different departments. Model and documentation were in Power BI, SQL, ETL, Microsoft Word and Excel.

Assist the YELLOW Audit Team when auditing the system and provide information to them to arrive at a successful Audit of the Power BI models. Also needed to do research in SQL, Microsoft Word and Excel.

Lead interaction with business users and analyze user requirements to design, develop and produce actionable insight reporting. This involved using Power BI, SQL, ETL, Microsoft Word and Excel when necessary.

CSC Nov 2017–Oct 2020

Business Data Analyst

Responsibilities included working with the business gathering information to create Power BI models and updating existing models. Created business documents, inspecting the data, creating testing cases, test plans, and business rules for Cotton Online Processing System (COPS). Worked with the business using verbal and written communication skills to determine and understand the process.

Worked with the business to create the Rate Renewal process for the users to enter data for the current crop year to be approved by Kansas City Commodities Office. The business documents, test cases, and business rules documents were created in Microsoft Word, Excel, Visio, PowerPoint, and Power BI. Used SQL to analyze the data.

Gathered information to create the Business documents and test multiple releases in CERT to a successful implementation by making sure that all requirements set forth by the business were created and tested before going to PROD. The test cases and test results and defects were recorded in HP ALM and JIRA. Used RTM to make sure of the completeness of the testing and record the results. Used SQL to analyze the data. The screen was created using Power BI. The business document and test cases were created in Microsoft Word, Excel and Visio.

Helped with creating the Catalog Sales process in COPS by creating the business documents, test cases, and business rules for the business and development team. Used RTM to make sure of the completeness of the testing and record the results. The screen was created using Power BI. The business documents were created in Microsoft Word, Excel, Visio and PowerPoint. Used SQL to analyze the data.

Waddell and Reed Apr 2010–Nov 2017

Data Analyst

Responsibilities included working with the business and management gathering information to determine the process, create the business and technical documents. Helped with the test scripts to make sure all the requirements were being met. SQL, ETL and Erwin were used to interpret and analyze the data. Used

verbal and written communication skills while working with business to determine the process and understand the big picture. On multiple projects was the Project Lead.

For the creation of the new funds need to work with the Client Services team to document business information and business rules from them to give to the development team as needed to make sure that all the processes included these new funds. This had a very high visibility all the way up to the CEO of the company. ETL and SQL were used to help analyze the data. Erwin was used to determine the tables to use. Business requirements were created in Microsoft Word and Excel. Created testing scripts in Microsoft Word and Excel to make sure the new funds were being tested. The Agile Methodology system was used for this.

The Mutual Funds Accounting team wanted to modify the Bloomberg process. Needed to document business information and business rules from them to give to the development team. This required identifying the process that will be affected and improving on the process that was already in place. ETL and SQL were used to help analyze the data. Erwin was used to determine the tables to use. Created the Business Requirement in Word, Visio, Excel and PowerPoint. The Agile Methodology system was used.

Gather information from the business to decrease the running time of the Invest1 nightly process as it was taking a long time to run. Needed to document business information and business rules to create the business document and the test cases. Created the technical document for the development team to make the correction. Responsible for creating the testing documentation to make sure the data was correct. Streamlining the process to reduce the run time from four hours to less than two hours. Used SQL and Erwin to analyze the data. The requirements were created in Microsoft Word, Visio, Excel and PowerPoint.

Languages/Software/Systems

POWER BI, POWER BI PAGIENAT REPORTS, SQL, EXCEL, T-SQL, PL/SQL, SSMS, SSIS, SSRS, TERADATA, MICROSOFT OFFICE TOOLS, MICROSOFT WINDOWS, DB2, ORACLE, JIRA, ERWIN, INFORMATICA, JAVA, COBOL, MICROFOCUS COBOL, VSAM, HTML, JCL, SYNCSORT, FILEAID, EASYTRIEVE PLUS, VISUAL STUDIO

Education

Bachelor of Science, Computer Science

Southern Illinois University, Carbondale, IL

Contact this candidate