Post Job Free

Resume

Sign in

Data Engineer

Location:
Center City West, PA, 19101
Posted:
November 19, 2020

Contact this candidate

Resume:

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



Contact this candidate