Summary
Overview
Work History
Education
Skills
Certification
Timeline
Hi, I’m

ADAM PIRO

Technology Engineering
ADAM PIRO

Summary

Dynamic and results-driven Technical Engineer with a proven track record in data analytics, business intelligence, and information technology. Currently obtaining an M.S. in Business Analytics from Georgetown University, complemented by hands-on experience in data migration, quality assurance, and innovative solution design. Proficient in harnessing the power of data to derive actionable insights and drive strategic business decisions. Adept at collaborating cross-functionally, optimizing data infrastructure, and implementing advanced analytical methodologies. Most importantly, I love what I do!

Overview

1
Certificate

Work History

Bank Of New York Mellon Corp

Information Technology Engineer
Current

Job overview

Data Management / Data Governance team


  • Spearheaded a data migration project, centralizing key operational metrics into an automated, intuitive dashboard hosted on a unified internal hub - achieving annual savings of $5M.
  • Implemented automated data quality checks with rules to the ServiceNow platform, optimizing response times and remediation efforts.
  • Championed data governance standards throughout the data migration process, ensuring the accuracy, consistency, and security of sensitive data.
  • Engaged in close collaboration with software developers to refine source code, enhancing system capabilities for automated data extraction and visualization on the newly designed dashboard.
  • Detected and resolved 10 critical data quality issues, safeguarding the company from potential fraudulent activities and ensuring unwavering trust with clients.

BANK OF NEW YORK MELLON

Technology Business Analyst Intern

Job overview

  • Migrated 8 client applications on legacy Technology infrastructure from Brownfield to Greenfield
  • Extracted company reference data and queried using SQL, Excel, and visualized using Tableau
  • Monitored rotations of applications to different databases, assisted migration project to digital currency
  • Automated risk systems (RAID Logs) to make company data extraction easier
  • Updated lines of back end program code for data structure diagrams within accessible database - TXC (Python)
  • Mapped, cleaned, and scrubbed 52,305 rows of historic data to map to modern platform for FED audit prevention purposes
  • Consulted with stakeholders to analyze, define, challenge and prioritize the business requirements of a new application manual. Created BRD
  • Developed project scope, objectives, constraints and assumptions for a large, strategic, multi-year programs
  • Managed factory projects that were active and delivered reports for timeline

KELLER WILLIAMS

Data Analyst Consultant Intern

Job overview

  • Employed advanced statistical methods to analyze and interpret large data sets, extracting patterns and correlations to provide actionable insights on property market dynamics.
  • Developed Comparative Market Analysis (CMA) reports using advanced analytics to gain granular insights into market conditions and valuation.
  • Utilized machine learning models to predict property values based on zoning statistics, contributing to enhanced decision-making for agents and clients.
  • Managed and curated a large-scale relational database of client and property data, employing Python scripts to automate extraction and reporting processes.
  • Directed data-driven real estate project development, leveraging predictive analytics to optimize returns on investment.
  • Deployed Natural Language Processing (NLP) techniques to assess and enhance social media content, resulting in a 20% growth in Twitter followers and a 15% uplift in Facebook engagement metrics.
  • Collaborated with the marketing team to implement A/B testing strategies, refining social media campaigns and maximizing reach and interaction in a digital-first ecosystem.
  • Visualized complex data sets using tools like Tableau and PowerBI, translating data into comprehensible charts and graphs for stakeholder presentations and decision-making.


Education

GEORGETOWN UNIVERSITY
Washington, DC

Master of Science from Business Analytics
12.2024

University Overview

  • Completed a rigorous curriculum that melded advanced quantitative methods with critical business strategies, enabling a holistic approach to data-driven decision-making.
  • Acquired proficiency in data manipulation and analysis using tools such as R, Python, SQL, AI, Pentaho, and Tableau,
  • Collaborated on multifaceted team projects, where I interpreted complex data sets to provide actionable business recommendations.
  • Mastered techniques in machine learning, predictive modeling, data visualization, and optimization to solve diverse business challenges.
  • Addressed real-world business dilemmas in case studies and capstone projects, utilizing analytical methodologies to develop innovative solutions.

RAMAPO COLLEGE

B.A from Law, Economics, Business Analytics
05.2023

University Overview

  • Cum Laude
  • National Society of Leadership and Success honor society, National Honor Society
  • Founder & President of the Podcast club, Founder & President of the Debate Club, Vice President of Phi Alpha Delta, Lead data analyst (invitation only) Ramapo Law Journal, Member in RFG Investment club
  • Relevant Coursework: Intermediate Microeconomics & Intermediate Macroeconomics
  • Relevant Coursework: Programming | & Data Visualization

Skills

    Analytical:

  • Data Modeling & Analysis
  • Predictive Modeling
  • Data Quality Assurance & Governance
  • Business Intelligence & Reporting
  • Technical:

  • Programming: Python, R, C
  • Data Manipulation: SQL, Excel
  • Data Visualization: Tableau, PowerBI, Denodo
  • Technical Troubleshooting
  • Business Acumen:

  • Business Analytics & Decision-Making
  • Data-driven Business Strategy Development
  • Collaboration & Communication:

  • Team-based Project Collaboration
  • Source Code Revision & Enhancement
  • Effective Data Presentation & Reporting
  • Soft Skills:

  • Problem Solving
  • Critical Thinking
  • Creativity
  • Tech Troubleshooting
  • Effective Communication

Certification

MySQL Bootcamp : Go from SQL Beginner to Expert

Licensed Real Estate Salesperson

Timeline

Information Technology Engineer

Bank Of New York Mellon Corp
Current

Technology Business Analyst Intern

BANK OF NEW YORK MELLON

Data Analyst Consultant Intern

KELLER WILLIAMS

GEORGETOWN UNIVERSITY

Master of Science from Business Analytics

RAMAPO COLLEGE

B.A from Law, Economics, Business Analytics
ADAM PIROTechnology Engineering