Alexander Payne
Indianapolis,Indiana
Summary
Hello, I am a data professional with multiple years experience in both analytics and engineering, knowledge of several programming languages, experience working in teams, extensive problem solving skills, and a pursuit of knowledge in the fields of Database Management, Cutting Edge AI, and data-driven app development. Most of all, I possess an unmatched drive to further your organization's data needs.
Overview
2
2
years of professional experience
Work History
Data Engineer
Moser Consulting
Indianapolis, IN
01.2024 - Current
- Managed Snowflake and SQL Server databases while maintaining high data quality standards.
- Developed and managed Azure Data Factory pipelines that integrated data into Snowflake databases.
- Built Python, SQL, Java, and Power FX applications for clients.
- Executed large-scale data migrations to Jira from source websites and databases.
- Trained clients on cutting-edge AI and Data App (Streamlit, Power Apps, etc.). development technologies through working sessions.
- Built and trained AI models using Snowflake Cortex and Azure OpenAI Studio to leverage cutting-edge AI to help clients achieve their data needs.
- Led meetings, managed projects, and communicated with clients via email, Jira boards, ticketing services, etc.
- Co-Led the AI Technology Interest Group, where I gave monthly internal presentations on cutting-edge AI tech.
.
Part Time Data Analyst
Pro Football Focus
Remote
07.2023 - 12.2023
- Gathered and organized statistics from NCAA and NFL games in a timely and accurate manner so that further analysis can be performed.
Data & Analytics Intern
Moser Consulting
Indianapolis, IN
05.2023 - 08.2023
- Built Applications in Power Apps for clients catered to their data needs.
- Created APIs to bridge data storage software to app development programs.
- Manipulated large datasets in Snowflake at the request of clients using SQL.
- Collaborated with IT team to navigate errors in order to meet deadlines.
- Completed technical presentations through demoing applications to leadership and clients.
- Created data driven solutions using the Microsoft Power Platform in conjunction with big data.
Finance Analytics Intern
Impact Financial Group, Ameriprise Financial
Indianapolis, IN
05.2022 - 08.2022
- Worked alongside certified financial advisors to provide financial services for clients
- Used investment platforms to perform stock trading, as well as moved millions of dollars across dozens of clients various investment accounts.
- Analyzed past firm data using statistical techniques to provide recommendations to advisors of how to optimize client onboarding and maximize firm revenue.
- Observed the cash value in investment accounts and recommended action to advisors when necessary.
Education
Bachelor of Science - Statistics
Purdue University
12.2023
Minor - Economics
Purdue University
12.2023
Skills
- Data Engineering using Microsoft Azure, Snowflake, SQL Server etc
- Statistical methods (Hypothesis Testing, Experimental Design, Regression Analysis, Etc)
- Advanced knowledge of Data Visualization tools such as Power Apps, Power Automate, Tableau, and Power BI
- Computer Programming: Proficient in Python and SQL Experienced in R, Javascript, PowerFx, Stata, Minitab, and Matlab
- Application Development (Streamlit, Power Apps, Java-React)
- Experience with money movements and online investment platforms such as Thompson
- Project Leadership and Conflict Management
- Self Sufficiency
Affiliations
- Microsoft Power Platform Fundamentals Certification (PL-900 Exam, Certification ID : A8A91B58EB2AD611 )
- Microsoft Azure Fundamentals Certification (AZ-900 Exam, Certification ID: 557B618ACB5C8CF2 )
- Microsoft Azure Data Fundamentals (DP-900 Exam, Certification ID: 557B618ACB5C8CF2)
- Snowflake Snowpro Core Certification (Credential ID: S65075-240719-COF)
- Snowflake Data Warehousing & Agile Framework Certification
Key Project Experience
1. Large Scale Ticket Data Migration - Moser Consulting (Data Engineer) March 2024-October 2024
- Used SQL Queries to pull and manipulate over 250 thousand rows of data.
- Used Python API logic to further manipulate and send ticket information, user comments, and various attachments from Fogbugz ticketing service to Jira.
- Instituted Concurrent Processing to increase the speed of the migration.
- Built an additional script to link parent and child tickets together.
- Configured each script with logging files to ensure that the Production Migration ran smoothly and adhered to best practices.
2. Cortex Analytics AI Solution - Moser Consulting (Data Engineer) 2024
- Used SnowSQL to build and import a Semantic AI Model to analyze custom data in Snowflake for a client.
- Applied the Semantic Model in a custom Streamlit App I built, which allows users to use Cortex Analytics to retrieve data and ask follow up insights questions to Azure OpenAI LLMs.
- Presented this solution at multiple internal and external conferences to showcase a combination of AI models to form a single application.
3. Slack Work Anniversary Notification Project - Moser Consulting (Data Engineer) 2024
- Pulled Data from an HR source system into a Data Model in Snowflake.
- Developed an 'opt in' Streamlit App that collects data and updates the Snowflake Database with managers choices for notifications.
- Deployed a scheduled Azure Function (python script) that triggers a slack application to send messages to managers (who have opted in) when their reports have a work anniversary
4. Power Apps <-> Snowflake And SQL Server Training - Moser Consulting (Data Engineer) 2024
- Hosted live training and troubleshooting sessions to help clients with their Power Apps and database needs.
- Assisted Clients in connecting Power Apps to Snowflake and SQL server and in using Power Apps widgets to make database updates.
- Used cutting edge Microsoft connectors and Power Automate to allow clients to connect Power Apps to Forms and finally to backend databases.
5. Persona Project - Impact Financial Group (Finance Analytics Intern) May 2022 - Aug 2022
- Performed Statistical Analysis tests (Hypothesis Testing, Regression Analysis, Confidence Intervals) on client data in order to provide the firm with recommendations for future clients.
- Created visualizations using excel and tableau to display data analysis in a formal presentation.
6. Approval App Development - Moser Consulting Inc. (Data & Analytics Intern) May 2023 - Aug 2023
- Designed an application in Microsoft Power Apps to write data to a Snowflake Database.
- Built and Implemented a Python REST API to allow Snowflake to communicate with Power Apps.
- Executed Queries in SQL to ensure the Snowflake Database was written to properly.
Timeline
Data Engineer
Moser Consulting
01.2024 - Current
Part Time Data Analyst
Pro Football Focus
07.2023 - 12.2023
Data & Analytics Intern
Moser Consulting
05.2023 - 08.2023
Finance Analytics Intern
Impact Financial Group, Ameriprise Financial
05.2022 - 08.2022
Bachelor of Science - Statistics
Purdue University
Minor - Economics
Purdue University
Similar Profiles
Anthony Isaac BrisenoAnthony Isaac Briseno
Help Desk Technician at Moser ConsultingHelp Desk Technician at Moser Consulting
Ashley CateAshley Cate
Consultant at Moser ConsultingConsultant at Moser Consulting
Rick ClemonsRick Clemons
Team Manager |Product Owner |Sr. Data Engineer at Moser ConsultingTeam Manager |Product Owner |Sr. Data Engineer at Moser Consulting
Jiger DhillonJiger Dhillon
Dispatcher at G5 Transport LLCDispatcher at G5 Transport LLC
Lisa GainesLisa Gaines
Bartender at Ristorante RomaBartender at Ristorante Roma