Brian Milby

Brian Milby

About

Detail

Sr. Data Engineer
Philadelphia, Pennsylvania, United States
Contact Brian regarding: 
work
Full-time jobs
Starting at USD3k/month
Flexible work
Starting at USD18.7/hour

Timeline

work
Job
school
Education

Résumé

Jobs verified_user 0% verified
  • Mindset
    Senior Data Engineer
    Mindset
    Aug 2023 - Current (3 years)
    • Develop AI chat bot API utilizing Python, Flask, SQL, LangChain, OpenAI, and AWS AppRunner/Lambda/Pinpoint/SNS. This chat service allows leads and claimants to ask questions via SMS regarding their Supplemental Security Income and Social Security Disability Insurance claims without having to speak to a representative unless necessary. • Create Microsoft Sharepoint connector to allow extraction of raw list data and documents into our data warehouse. • Create ETL process for importing Sharepoint data, facilitating the storage of Social Security Administration documents in claimants' online profiles.
  • AVER
    Senior Data Engineer
    AVER
    Mar 2023 - Aug 2023 (6 months)
    • Develop ETL solutions for the Cybersecurity and Infrastructure Security Agency (CISA) utilizing AWS, PySpark, DBT, Dremio, and Dagster for efficient pipeline orchestration. • Create processes to ingest data from APIs, structured and unstructured data files, perform transformations to convert data into standardized JSON format, and store the data assets in an S3 data lake, enabling accessibility through various means. • Implement a data anonymization process using Microsoft Presidio to identify personally identifiable information (PII) data within files and replace it with anonymized values, ensuring data privacy and security. • Design and establish a DevOps process using AWS CodeCommit, CodeBuild, and CodeDeploy to enable seamless and
  • Grubhub
    Senior Data Engineer
    Grubhub
    Apr 2018 - Jan 2023 (4 years 10 months)
    • Designed and built Extract-Transform-Load (ETL) data processing jobs using PySpark on AWS EMR clusters to extract meaningful information from high volume click stream data sources to create multiple performant and highly available data pipelines around diner sessions for internal analytics to help drive improvements for end user products. • Developed ETL jobs to summarize millions of records into structured format as required for KPI reporting and analysis. • Collaborated with business (Finance, Marketing, Product) stakeholders to understand reporting and analytics requirements. • Lead team-wide meetings, assign tasks and workloads to onshore/offshore employees, and foster collaboration among teams and across departments. • Managed of
  • Cotiviti
    RCA Data Engineer
    Cotiviti
    Aug 2017 - Mar 2018 (8 months)
    • Worked with the internal audit team to understand their business information needs, gather requirements, design and build reporting solutions via MS SQL Server. • Developed, optimized and tuned SQL queries, stored procedures and functions to enhance accuracy in healthcare payments and maximize audit site productivity. • Developed and delivered complex ad hoc SQL reports to assist the audit teams reporting analytical needs. • Developed PowerShell scripts to automate data exports to csv and excel files. • Worked effectively and efficiently on multiple tasks and deadlines, while producing high quality results in a fast-paced environment.
  • eMoney Advisor
    Software Engineer (Data Services)
    eMoney Advisor
    Apr 2015 - Aug 2017 (2 years 5 months)
    • Responsible for building and maintaining C# integration code between the aggregation engine and third parties. This includes enhancements, maintenance and availability. Coordinate with third parties and internal stakeholders to receive and distribute data from third parties to internal applications at eMoney and from eMoney to third parties via data extracts. • Performed extensive investigation to determine how websites work using Fiddler to examine POST/GET request, cookies and other http headers, JavaScript, JSON, and XML responses; to login to clients financial institution and navigate site to retrieve all pieces of customer account data using XPath expressions. • Implemented new connections and extracts based on business requirement
  • G
    Programmer Analyst II
    Genomind
    May 2013 - Apr 2015 (2 years)
    • Developed internal ASP.NET MVC web portal and C# Windows system tray application to automate printing and faxing of patient genetic reports. The tray application allows for the user to automatically print reports from the browser to the printer on their machine utilizing ASP.NET SignalR hub which is hosted in the web portal. • Developed laboratory information system (LIS) with Salesforce data integration and synchronization utilizing Salesforce APIs and C# Web Services. • Customized Salesforce application to meet new business requirements for the LIS; creating custom Visualforce pages, Apex classes, triggers and workflow rules. • Developed custom order and order fulfillment functionality within Salesforce with barcode scanning integrat
  • S
    Senior System Developer I
    Sep 2009 - May 2013 (3 years 9 months)
    • Developed Web and Interactive Voice Response (IVR) systems to manage clinical drug trials. OO design using .NET, C#, XML, XSLT, JavaScript and Entity-Attribute-Value (EAV) databases implemented in SQL Server 2000 & 2008. Includes auditing, session management and logging. • Created custom C# and JavaScript functions to perform validations and logic checks. • Designed and developed Microsoft T-SQL stored procedures to parse and generate XML for transaction based data storage. • Created custom Fax/Email transaction confirmations for users using SQL, XML, and XSLT. • Performed thorough reviews of the User Requirements Specification (URS) prior to attending URS review meeting and participated in review with the project team by suggesting d
  • A
    System Developer I (New Products & Services)
    Almac Clinical Technologies
    Sep 2007 - May 2013 (5 years 9 months)
    • Developed software as designed and directed by project Technical Lead to support Production IT Interactive Voice Response (IVR) systems. • Reviewed user requirements and assisted in developing functional requirements. • Reviewed application needs and assess level of effort (estimates), identify risks, and promote continuous improvement in concert with the project team. • Performed maintenance on existing software applications. • Created stored procedures to return data to a third party help line tool. • Developed Windows Service (C#) to synchronize data between a third party clinical trial drug supply system and Almac's IVR study database. This service receives a message from a third party via MSMQ containing drug supply data, the da
Education verified_user 0% verified
  • Temple University
    Bachelor of Science
    Temple University
    Sep 2004 - May 2007 (2 years 9 months)