Michael Smith Email & Phone Number

Atlanta, GA, US

Tampa, Florida, US

Chicago, Illinois, US

Tax & Audit

Chicago, Illinois, US

• Office of Risk Management
• Architected, refactored and integrated existing legacy data apps into Azure services.
• Work in various capabilities in designing, building, transforming and delivering data solutions, using tools: Visual Studio, Azure Data Studio and VS Code.
• Refactored existing production data into operational data stores in Azure.
• Refactored and modernized tables, views and stored procedures to present to PowerBI Semantic models.
• Built new tables, views and stored procedures from new and existing data, code and client requirements.Current Projects and Initiativeso Audit Partner Quality Dashboard, Tax Quality Dashboards - created new schema and.

Chandler, Arizona, US

• Other Clients included
• AWNC (SQL performance dashboard)
• Hilton (Modernization)
• Masco (SQL performance dashboard)
• NCR
• OHIO

Chandler, Arizona, US

• BlackbaudPrincipal Software Engineer Digital Innovation (Data & AI)
• Performed in transit upgrades to managed CRM product, while migrating from on-prem to Azure cloud.
• Migration strategy included 5000 databases, used PowerShell to stage, upgrade and rollup databases
• Performed typical DBA duties

Chandler, Arizona, US

• Principal Software Engineer Digital Innovation (Data & AI)
• Architected, refactored and integrated existing legacy pricing tools into internal Pricing Data warehouse for SCO
• Refactored existing production stored procedures to PowerBI dashboards
• Built stored procedures and views from existing code and client requirements
• Modeled new schema in Analysis Services
• Loaded and served data from AS to PowerBI with nightly refresh

Chandler, Arizona, US

• Tech DataPrincipal Software Engineer Digital Innovation (Data & AI)
• Refactored and architected existing production pricing tool databases, from Microsoft Access to SQL database
• Designed schema based on client model
• Built stored procedures and views from existing code within Access
• Optimized stored procedures
• Worked with stakeholders and business units with implementing code based solutions for defects

Chandler, Arizona, US

• Pontoon SolutionsPrincipal Software Engineer Digital Innovation (Data & AI)
• Architected a horizontally partitioned data warehouse using list methods and Fluent libraries in.Net
• Designed and implemented web front end on Azure Application Services for managing horizontally partitioned databases across multiple servers in the US and EU Azure clouds
• Developed pieces of the entire end-to-end ETL process, from FTP to Azure Data Lake to Azure SQL DB to Azure Analysis Services, using SSIS, Azure Data Factory, Azure Databricks, and T-SQL
• Utilized Azure DevOps to create and maintain ADF pipelines and code repos

Wayne, PA, US

• Carry out the development and implementation of hundreds of standalone, clustered, and multi-subnet fail-over cluster instances from contract to lifecycle support
• Devised and integrated multiple SQL database infrastructures for various cloud platforms, along with SQL database environments for internal tools for the HPe platform
• Initiated the standardization of build documentation, as well as SQL Server implementations, SQL Server monitoring, and support
• Created and spearheaded the application of best practices
• Facilitated training of offshore DBA Team on technical, products, and licensing operations onsite in India
• Trained offshore SME and CSP teams on managed database services products onsite in India

Wayne, PA, US

• Collaborate with project managers, solution architects, engineers and customers on customer design reviews for the new implementation and upgrades of current environments and infrastructure
• Provide level 3 support in administering and maintaining complex SQL Server environments through advanced cluster troubleshooting, failing maintenance plan preparation, performance issues management, advanced query.
• Establish offshore Database Administration (DBA) Team in India, to support “Follow the Sun” model
• Render consultative advice and assistance to internal and external customers in managing SQL Server design and solutions meeting business requirements
• Design technical documentation, change plans, and designs in accordance with clients requirements
• Configuration of SQL Server High Availability and Disaster Recovery (HADR) for SQL

Wayne, PA, US

• Coordinated with sales, management, and customers in creating requirements and specifications for new implementations
• Assisted customer in hosting infrastructure servers, which included Windows 2000/2003/2008R1-R2 and RedHat 5.x
• Guaranteed the security and functionality of all servers and AppSite managed applications
• Executed patching and updated for systems, and hardware driver and firmware updates
• Addressed and resolved all issues from low level to highly technical issues, such as database and application support
• Administered backups through VERITAS NetBackup for the new implementations and decommissions, along with changes to backup policies

Wayne, PA, US

Wayne, PA, US

• I managed a group of monitoring and systems engineers in operational support monitoring.
• I was also responsible for developing an asset management tool for tracking servers and daily operational issues.

Wayne, PA, US

I was responsible for tracking, validating and ticketing of all confirmed monitoring alerts.