• Lead ETL processes using SSIS, stored procedures, and custom functions to streamline data integration and reporting.• Manage SQL Server environments, including agent job management and migrations from SQL Server 2012 to 2019.• Utilized Azure and Azure DevOps for cloud-based data solutions, enhancing scalability and efficiency.• Implemented Google BigQuery and Databricks for advanced data analytics and big data processing.• Manage Azure Databricks environments, compute, workflows & ETL/ELT development

- Lead a team of eight business analyst executing weekly sprints to complete work for a corporate data warehouse being created in Hadoop and Teradata- Provided data visualizations of metrics around sprint success showing the number of hours, tasks and accuracy of estimated time to complete tasks of user stories by each business analyst allowing management to make timely decisions around the number of individual needed to complete a given project- Provided weekly metrics to scrum masters of burn down and burn up charts for sprints to be presented to executive management around the success and timeline of the corporate data warehouse project- Completed gap analysis for a national data warehouse for Western, Central and Eastern business regions to mitigate reporting risks using Hue for Hadoop, Oracle SQL Developer, Teradata SQL Assistant and SQL Server Management Studio - Wrote test cases/suites to validate data loads with billions of records (big data) moving from regional servers to the national data warehouse using SQL in Teradata, Oracle, SQL Server and Hadoop- Data validation used after ETL processing were source to target primary and natural key counts, transformation logic for date conversions and historical billing amounts, historical field values that were directly moved from source to target and referential integrity on child to parent tables- Lead test case/suite review calls to validate we are executing test cases which will provide the most accurate outcome for the national data warehouse

- Worked with stake holders to gather requirements for dashboards and safety reporting, distributing work to two analysts to be executed during weekly sprints.- Used Logi Analytics to create data visualizations of warehouse safety metrics around forklift impacts & safety checklist rules- Completed custom dashboards with Logi Analytics allowing users to add or remove widgets displaying impact thresholds met for the day, bar charts of passed and failed safety checklist- Managed daily business intelligence initiatives including dashboards, reporting, data dictionaries & all data integrity related operations through the utilization of MySQL 5.6, Logi Info Studio, JavaScript, Java, HTML and CSS to provide cloud or local software to warehouse clients across the United States- Created and maintained JavaScript and MySQL 5.6 stored procedures to apply conditions, increasing website appeal and brand image through language-specific modifications, formatting alterations, and related appeal-based augmentation - Created Java based reporting processes and direct all reporting with Logi Info Studio and MySQL 5.6, providing warehouse management insight into forklift concerns and related impacts to improve company safety- Designed and Implemented MySQL 5.6 Community Edition utilized by a proprietary web-based software application for warehouse management built on Ubuntu Linux, GlassFish server and other open source technologies- Deployed Java based software to a Linux VM, generating and writing Linux commands using putty and WinSCP to support efficacy, while demonstrating enhanced knowledge of software-based utilization and related technological competencies- Used Perl and shell scripting to automate deployment updates for Java based customer databases, reporting and custom warehouse software

- Consolidated and streamlined compliance testing of consumer lending data, through the creation of original SSIS packages- Spearheaded the restructuring and transfer of hundreds of millions of records (big data) across multiple servers to support overall company efficacy, through the mastery and utilization of SQL for (DB2/Teradata/SQL Server/Oracle) and SAS, VBA and C#- Coordinated and interfaced with an abundance of business partners in domestic and international locations, in order to identify and understanding testing needs and expectations- Identified and mitigated business risks and concerns while implementing by implement SQL Server stored procedures to validate data integrity as front-end users completed regulatory testing- Improved and enhanced company efficacy through the streamlining of test sampling procedures, increasing sample delivery by 15 days through the restructuring of test design, test analytics, and testing teams

- Gathered requirements from executive management surrounding litigation data quality and regulatory reporting that I distributed among three analysts for execution- Reconciled and resolved discrepancies within vendor inventory and critical data between internal and vendor systems for Credit Card Litigation Inventory, through the independent drafting of SOPs and approach documents- Created and disseminated consolidated Big Data sets using Terabytes of company data through the utilization of Unix SAS- Requested and acquired appropriated data from Vendor Management and subsidiaries, creating additional datasets to complete reconciliation processes while providing findings and recommending solutions- Championed the development and implementation of new data management strategies, refining customer service excellence in addition to enhancing efficacy related to customer assistance and data security

- Provided monthly executive regulatory reporting utilizing SQL Server, VBA, Access, and Excel- Improved report delivery utilizing SSIS to consolidate multiple sources within SQL Server- Presented findings to executive management utilizing PowerPoint to highlight issues that needed escalation

- Implemented a quality review process through database creation for the sales team and related new customer acquisitions, supporting accurate data solutions through the use of Access, Excel VBA, and SAS Enterprise Guide- Improved member-provider relationships through analytical oversight, enhancement, upgrading, and maintenance- Streamlined and upgraded software processes, internal communications and procedures to improve company efficacy and to resolve arising tech-based issues and supporting deployments from other departments- Identified current barriers to efficacy and crafted on-the-spot solutions to overcome obstacles

- Provided monthly liquidation reporting for charge off recovery efforts utilizing SQL Server, Access, and Excel- Research liquidation trends for general recovery vendors as well as estate and legal- Provided analysis to strategies which lead to the implementation of legal state segmentation- Provide monthly analysis of liquidation to improve recovery efforts and develop new strategies- Hold monthly performance meetings with management to discuss market trends and opportunities for increasing performance- Improved report delivery times by 200% utilizing Access, Excel and SQL Server 2005- Received quarterly award of excellence for process improvements and automation