• Building a framework so robust, it notified when datasets were late and/or erroneous, in turn allowing time to automate over 80% of the ingestion flows currently in production.• Led migration of all ingestion processes from SSIS to Airflow and Python.• Designed, implemented, and debugged SSIS data flows in MSSQL/Snowflake/Redshift environments.• Wrote internal Python data ingestion library to allow for plug and play for multiple different types of ingestion of datasets.• Implemented QA tests to identify validity and effectiveness of ETL processes.• Created database schemas to implement data ingestion process for any new vendors and corresponding datasets.• Led team in performing migration of two servers onto one, which included but was not limited to reducing costs, increasing efficiency, and validating permissions for portal use along with internal storage use.• Validated all data that fed into internal portal that maintained reports for various teams.• Created, operated, and maintained large-scale data infrastructure in production (performance, reliability, and monitoring).

• Initiated and led team in data cleanup of new product offering encompassing over 3 billion records.• Collaborated with quantitative analysts and team to re-write stored procedures, changing calculations, which benefited clients downstream. • Mentored, trained, and led data specialists in company best practices as well as explanation of nightly flows.• Sought quick and thorough resolution to issues and prevented business interruptions via modification of scripts on ad hoc basis to implement specific use-cases for customers (batch/python scripts). • Evaluated how changes to functionality could have impacted user experience, data integrity, business rules, and system workflows and provided feedback to management during testing.• Directed onboarding process for several new hires to provide training on internal processes (nightly stored procedures) as well as understanding data architecture.

• Enforced data integrity upon uncovering inaccurate parsing of options expirations by researching, assessing, and resolving more than ten years of data (1,000,000+ records).• Implemented backfill of missing options data for ten years’ of data (4,000 records for an index) due to inaccurate loading while enlisting engineering and quality assurance teams to verify data integrity.• Discovered errors in linking of options throughout older data for thousands of records and create stored procedures to find and fix these inaccuracies (40,000 records).• Optimized quality assurance reports by re-writing outdated procedures to circumvent new vendor data loading process.

• Increased productivity by revising claim calculation report and similar processes, saving $1,000,000 in 2014.• Created and served as head of change committee established to allow employees’ ideas to flow directly to chief operating officer and other senior managers.• Liaised with clients and internal users to create mockups and wireframes for overseas team to implement case websites.

• Examined and confirmed various changes to system requirements specifications and functional requirements documents and ensured zero scope creep. • Conducted primary analysis and fostered resolution of complex business issues with cross-functional implications to support introduction of RFID technology.

• Coordinated with programmers overseas by drawing use case, class, and sequence diagrams for designs to present to clients.

Provided detailed reporting of network issues and individual PCs by performing root-cause analysis. Fixed computer hardware issues related to monitor, network connectivity, and any hard drive speed problems.

Installed essential software, including anti-virus and several tax tools, and trained users on efficient usage. Assisted in cash allocation of several high-profile clients. Filed tax returns for several accounts.