J. Morgan Smith Email & Phone Number

Gadsden, Al, Us

Remote

Gardendale, Alabama, United States

Montgomery, Alabama Area

• Supervisory - Collaborated with executives to determine product roadmaps in order to set development goals and milestones • Managed and coordinated all aspects of company software projects; including resource assignment, requirements gathering, technical prototyping, design, deployment and maintenance based on changing business priorities and budget constraints • Refined and implemented software development methodologies and best practices • Provided technical mentoring and leadership in the company • Managed cloud-based systems and microsystems for security, cost effectiveness, quality and scalability • Identified and resolved issues • Provided development budget for software, systems and personnel• SQL Server - Designed/developed/implemented database structures (tables, indexes, views, stored procedures, functions, etc.) for new and existing projects • Created and debugged complex stored procedures and user defined functions (UDF) • Tuned new and existing stored procedures, views, triggers and UDFs for performance enhancements using execution plans and index usage • Evaluated index creation/deletion for optimization• Integration Services - Designed/developed/implemented packages for ETL and data migration projects• Azure - Designed/developed/implemented ETL strategies using Azure Data Factory with Azure SQL Databases and Azure Data Lake Gen 2 storage• Power BI - Designed/developed/implemented PBIX files for reports and produced shared datasets using multiple sources including Power BI data flows • Created DAX calculated measures • Developed M code for Power Queries • Conducted training classes • Incorporated server side security for HIPAA compliance• Reporting Services - Designed/created reports for healthcare clients • Used parameters (visible and hidden) for filtering database • Created functions for defaults and to enforce business rules

• SQL Server - Designed/developed/implemented database structures (tables, indexes, views, stored procedures, functions, etc.) for new and existing projects • Created and debug complex stored procedures and user defined functions (UDF) • Tuned new and existing stored procedures, views, triggers and UDFs for performance enhancements using execution plans and index usage • Evaluated index creation/deletion for optimization • Installed stand-alone & High Availability SQL Servers • Incorporated replication, mirroring and Always-On solutions for disaster recovery implementations.• Power BI - Designed and developed Power BI reports to create interactive reporting experiences • Created DAX calculated measures • Conducted training classes• Reporting Services - Designed/created reports for healthcare and financial customers • Created assemblies to augment functionality as needed • Used parameters (visible and hidden) for filtering database and cube data • Created functions for defaults and to enforce business rules • Conduct SSRS classes for training and corporate standards.• Integration Services - Designed/developed/implemented packages for ETL and data migration projects • Created VB.Net and C# script tasks and transformations for advanced data verification and alterations • Created intricate data flows for complex data migrations and transformations • Used Error Handler routines for auditing and tracking.• Analysis Services - Designed/developed/implemented database warehouse structures (dimensions, facts, calculated measures, members, cubes, etc.) for new financial and medical projects • Created MDX statements for applications.• Other - Technical Lead for database and BI projects • Considered to be the top-level database and BI contributor/specialist • Collect and document customer data requirements • Mentor to analysts, developers and DBAs • Former Microsoft Certified Trainer • Use Excel and PowerBI for data analytics

- Provided consultation on complex projects and considered to be the top level database and BI contributor/specialist- Worked with customers to collect and document requirements for BI projects- Designed/developed/implemented database structures (tables, indexes, views, stored procedures, functions, etc) for new projects- Designed/developed/implemented BI structures (dimensions, facts, calculated measures and members, cubes, etc) for new projects- Designed/developed/implemented SSIS packages for ETL (data warehouse) and data migration projects- Created MDX statements for applications- Evaluated index creation/deletion for optimization - Created and debugged complex stored procedures and user defined functions (UDF)- Tuned new and existing stored procedures, views, triggers and UDFs for performance enhancements using execution plans and index usage- Installed multiple clustered and non-clustered Microsoft SQL servers for customers and internal projects

- Technical Lead for departmental database projects- Mentored developers and DBAs - Designed database structures (tables, indexes, views, stored procedures, etc) for new projects- Tuned new and existing stored procedures, views, triggers and UDFs for performance enhancements using execution plans and index usage- Created DTS (2000) and SSIS (2005) packages for ETL projects- Coordinated and migrated existing SQL 2000 stored procedures, triggers, views, functions and DTS packages to SQL Server 2005 and Integrated Services- Created scheduled reports using Microsoft SQL Server Reporting Services- Created and implemented Disaster Recovery procedures- Administered multiple sets of clustered and non-clustered Microsoft SQL 2000/2005 servers for OLTP/OLAP/test/development projects- Created and maintained backup and recovery procedures for production databases - Installed and maintained replication between Microsoft SQL 2000 and SQL 2005 servers

- Administered multiple sets of clustered and non-clustered Microsoft SQL 2000 Servers for production/test/development projects- Implemented and administered Microsoft SQL Server Reporting Services - Created and maintained backup and recovery procedures for production databases- Analyzed and modified existing stored procedures, triggers, scheduled jobs and DTS packages for performance improvement- Modified table and index structures to improve performance and reduce space- Mentored programmers, DBAs and other personnel on SQL Server performance and structure issues- Functioned as SQL Server Subject Matter Expert for new and existing projects- Coordinated with network and server personnel on network and clustered server configuration changes- Tracked space requirements to forecast future growth- Conducted technical interviews for AOL/Time Inc- Championed and conducted the migration of production databases to Microsoft Datacenter on Unisys ES7000

- Design/implement/administer Microsoft databases and data marts/warehouses- As Microsoft Certified Trainer (MCT), trained administrators and executives (throughout USA and Canada) on database and data warehouse implementation, programming, troubleshooting and administration techniques- Designed/programmed database-driven web (.asp) sites- Created help/support web site for launch of Microsoft NetMeeting within BellSouth- For Test lab, implemented/administered Active Directory, Exchange 5.5/2000, Exchange 2000 Active Directory Connectors, Exchange 2000 Conference Server, IIS, FTP,DNS, DHCP and WINS servers- Tested/documented/supported launch of Microsoft NetMeeting within BellSouth- Wrote SQL test questions for BeachFront Quizzer- Contributing author for the following books: - “MCSE: SQL Server 7 Administration Study Guide” - ”MCSE Exam Notes: SQL Server 7 Administration”- Consultant for Microsoft based operating systems- Microsoft Certified Partner