Mario Bonifacio Email and Phone Number

• Worked across departments with heads of operations, growth, product, tech, and customer service to coordinate analytic needs and products• Used Tableau, Python, R, databricks with Spark SQL, Google Cloud, and other tools to solve data science problems and create data visualization products

• Built Tableau dashboards, data sources, and workflows into reports for executives, media content, sales, and partnership teams• Used R to build supervised machine learning tools using random forest and logistic regression models to project finance and viral media content• Supplied end-user requirements to build a relational database from scratch suited for analytics• Used Python to scrape web-based data

• Contracted to major financial services firm in coordination with moving several databases to the cloud• Gathered and elicited requirements by partnering with marketing and results users to design software solutions to risk analysis, marketing materials, data products, and compensation decisions• Produced and maintain business requirement documents for agile projects• Interpreted financial data and portfolio results using data aggregation, regression analysis, and data mining• Used Alteryx, Tableau, R programming, SQL, JIRA, JSON and other software to integrate and analyze data

• Partnered with users and subject matter experts, and managed developers and quality acceptance analysts to design software solutions to financial regulations and create market data products, in accordance with stakeholder goals for the software development lifecycle (SDLC)• Compiled user specifications into business requirement documents (BRD) for agile projects and managed projects using the agile methodology to produce a project plan• Used SQL queries, Tableau, and R graphics to deliver business intelligence reports and charts to system owners and the operations team• Used R, SQL, Excel, Metadata Hub for data analytics, data architecture analysis, and business process analysis, and to mock up changes• Use JIRA, ServiceNow to document project plans, risk, dashboards, and reports, and manage required changes from business users, quality acceptance testing, and user acceptance testing (UAT)• Used JIRA for documenting agile user stories, properly formatted with a single feature that included user, user need, and user vision, and assigned to sprints• Gathered technical requirements to produce a technical requirements document (TRD) to integrate business application data with inbound and outbound systems, including data from external vendors of financial data, Salesforce, and market data customers• Worked with sales team to design market data products• Designed interfaces for inbound and outbound system owners to submit and download data, including by REST API in HTML, JSON, and XML formats• Used Balsamiq to mock up user interfaces (UI)• Gathered business requirements and technical requirements for IT security that were verified by the firm’s dedicated IT Security team or its audit team• Implemented password requirements and encoding, permissioned users at the modular and application levels, white-listed external user IPs, limited administrative access to internal IP, limited stack trace error codes to devlopment users, and verifying approvers for new users

Worked with compliance employees and developers, to design systems that ensured companies listed on the Exchange followed Securities and Exchange Commission laws and Financial Industry Regulatory Authority rules

Worked on a team to complete a political economy analysis of banking transparency reform in the United States

Managed as many as 29 U.S. soldiers, advised Iraqi military officers; foreign assignments included Japan, Australia, and a combat deployment to Kuwait and Iraq.

Analyzed data measuring effectiveness of U.S. aid to developing nations in Eastern Europe and Eurasia, along economic, social, and political metrics

Prepared policy memos for pending legislation which analyzed economic impact to the member's congressional district and the U.S. at large. This analysis included laws related to fiscal stimulus, financial regulatory reform, health insurance, and housing reform.