Jan. 2021 - presentScrum Master/Team Lead for Professional Services Reporting Team in a federal Azure cloud. Proposed metadata driven data factory architecture and shareable databricks folder structure to streamline development. Manage team of 11 developers/testers/business analysts. Present technology solutions and reviews to management using powerpoint on monthly basis. Manage monthly deployments to production of data ingestion pipelines and Power BI published datasets.Jul. 2020 - Dec. 2020Scrum Master/Team Lead for large nationwide credit union. Managed 3 teams including AI, ML Ops, and Power BI reporting teams for a total of about 15 members. Primarily focused on leading the reporting team and the AAS development. Developed Azure Logic Apps to perform scheduled AAS model refreshes. Proposed using tumbling window data factory windows to allow for dependent pipelines being triggered based on success or failure of prior pipelines. Managed biweekly deployments to production by completing security assessments and coordinating deliverables between my teams and associated data engineering teams.Nov. 2019 - May 2020Azure Data Engineer Lead to a major healthcare provider.Developed data factory pipelines for 3 use cases and various data sources, such as SQL server on prem tables and delimited text files from a file system. Incorporated both data flows and Databricks using Scala and SQL for transformations using passed in parameters as variables. Created triggers to automate these pipelines. Managed all the code in GIT and visual studio.Developed ETL and error handling framework in SQL server for dynamic ingestion of close to 100 tables using different incremental pattern types.Led and trained a team of client data engineers in the development of these pipelines.Utilized both Logic Apps and Alerts to send success and error emails to the support team.Developed a Covid-19 rapid response Azure Data Factory pipeline.

Created data factory pipelines to move data from relational databases and flat files to an Azure Data Lake. Modified Power BI dashboards. Created Wherescape ETL processes and jobs from an Oracle database into a Snowflake data warehouse. Created a data model using SQLDBM for Point of Delivery (POD) data. Wrote t-sql code to move the XML POD data to the sql tables I designed. Performed production support for a client whose SQL reporting was in error. Developed a recommendation document for a client on how to prepare for a SOX audit on their azure and on premise SQL server environments.

SQL developer and database designer