Andrew Carrara
267-***-**** adhzhy@r.postjobfree.com linkedin.com/in/andy-carrara-9a845412
Data Scientist
Analytics Data Visualization Statistical Research Data scientist specializing in the loading, mapping, and extraction of data from various sources to provide comprehensive analysis to organizational leadership. Expertise in developing reports that contain data analysis findings tailored to facilitating decision making and strategic planning efforts. Adept at managing project teams to plan and deliver analytics used to streamline operations and promote organizational growth.
TECHNICAL PROFICIENCIES
R, SAS, Jaspersoft, Crystal Reports, SSIS, SSRS, Power BI, Tableau, Anaplan, SAP BO/BI, Hadoop, AWS, Oracle, PL/SQL, SQL, PEGA, XML, Java, C, C++, Scala, Python, Bloomberg, Microsoft Visual Basic, Microsoft Office (Access, Excel, PowerPoint)
CAREER OVERVIEW
SR DATA ENGINEER Optum Serve Technology Services – Remote 2020
OSTS implemented this project as part of United Health Care’s Covid-19 response to win federal contracts to set up new testing sites by city and state. Modeled out the budget, supply chain and hiring of staffing needs to set up new test sites.
This project will soon pivot to the vaccine distribution models through OptumRX.
Designed, implemented and maintained lists, modules, line items, hierarchy and versions for Covid-19 response models.
Worked with senior management between multiple subsidiaries to coordinate business requirements.
Automated data loads utilizing Python into Anaplan models to update on a variety of time sequences.
Trained senior to mid-level management, how to use and better utilize the Anaplan platform.
Working across all of United Health Care’s subsidiaries to find opportunities to utilize Anaplan elsewhere. REPORTING ANALYST EDGEWATER FEDERAL SOLUTIONS – Washington, DC 2019 – 2020
As part of support operations for the U.S. Department of Energy, executed data mining, generated analytics on crude oil prices, and maintained quality standards for all.
Gathered and analyzed large data sets in accordance with reporting requirements, delivering accurate and timely findings to the research team and senior management.
Used Jaspersoft and Tableau to developed reports, visualizations and dashboards that tracked the analytics oil survey response rates.
Completed Jaspersoft reporting system installations and upgrades, managing testing and seamless deployments to production with no downtime.
Coordinated project planning, timelines and team collaboration using Agile methodologies to deliver products and services on time.
MORGAN STANLEY – West Conshohocken, PA 2007 – 2019 MIDDLE OFFICE 2017 – 2019
Led a nine-person staff in coordinating money movement and payment authorization activities, as well as trading operations for an investment portfolio with accounts of up to $100 million in assets.
Managed development of an in-house database repository that featured scalable storage for non-normalized data, designing and testing the application in conjunction with the IT department.
Designed SQL reports to monitor key business metrics, ensuring portfolios complied with negotiated terms.
Created analytic roadmaps and measurements, collaborating with investment managers to benchmark strategy types and monitor results.
Onboarded and managed new clients and investment portfolios to ensure growth, adding 30 new clients over a two-year timeframe.
Andrew Carrara 267-***-**** adhzhy@r.postjobfree.com 2
Generated $10 million in potential fee savings by modernizing the redemption system to meet monthly, quarterly, and annual deadlines.
DATA MANAGEMENT and ANALYTICS 2007 – 2017
Directed a five-person team that managed large volumes of data gathered from thousands of hedge funds, indices and portfolios.
Administered a SQL-based exception reporting system, maintaining data point accuracy and daily snapshot reliability.
Conducted time series analyses on hedge fund and portfolio data that led to questioning of Investment managers’ decisions, as well as discussions with Investment committee, in determining whether to invest or redeem capital.
Used Power BI, SSRS and Crystal Reports to design custom reporting across departments, ensuring all information met business requirements and user needs.
Developed internal database to house analysis models, liquidity reporting, and focused analyses, improving ease of access to information for relevant stakeholders and management.
Managed the ETL load processes via SSIS to extract data from various sources (excel, client databases, various internal and external databases, Hadoop, etc.), transform and load data into the database.
Mapped and maintained data model inventory, giving analysts quicker access to data and streamlining the development of key reports.
Automated updating and validation of large data sets to internal databases, which included coordinating with multiple teams to gather stakeholder requirements and business objectives
EDUCATION & PROFESSIONAL DEVELOPMENT
Master of Science, Computer Science, DePaul University 2016
Relevant Coursework: Data Analysis and Regression, Advanced Data Analysis, Time Series Analysis and Forecasting, Social Network Analysis, Data Visualization
Bachelor of Science, Mathematics, St. John’s University 1996 Anaplan - Certified Model Builder 2020
CORE COMPETENCIES
Data Analysis
Forecasting
Competitive Analysis
Risk Management
Data Mining
Process Improvement
Data Warehousing
Project Management
Market Analysis
Quality Assurance
Data Modeling
Business Analysis