SUMMARY:

• Data Warehouse Developer
• Database Developer with extensive experience in support of Data Modeling; performing, planning and implementing data architecture on SQL Server 2000/2005/2008/2014, designing data flows between applications, reducing redundant data flows or data stores, and standardizing data definitions across organizational boundaries. Solid JAD session experience skills and a proven ability to gather data requirements and data design information.
• Extensive experience in Database Application Development, (ETL) Extract, Transform and Load techniques, Client/Server Development, Data Conversion/Migration/Analysis, Legacy System Integration, SQL Server Stored Procedures & SSIS Packages for ETL, Business Analysis/Requirements Identification, Reporting Services Report Development, Reports Generation, Report Linking and Report scheduling. Full Life Cycle Application Development.
• Extensive Business Intelligence Development experience using and SQL Server Business Intelligence Development Studio and Microsoft, SQL Server Reporting Services.
• BI Analytics and reporting - SSAS (SQL Server Analysis Services), SSRS {SQL Server Reporting Services), SSIS (SQL Server Integration Services) Microsoft Power BI.

TECHNICAL SKILLS:

Software: SQL Server Analysis Services, SQL Server Management Studio, SQL Server Business Intelligence Development Studio, SQL Server Integration Services, SQL Server Analysis Services, Data Warehouse, Process Automation (SQL Agent)

Languages: T-SQL, OLAP, ADO, DAO

Databases: SQL Server 2000/2005/2008/2014

PROFESSIONAL EXPERIENCE:

Confidential,Minneapolis,MN

Developer

• Gather specifications for and create new database systems
• Gather specifications for and create new BI Systems which include Reports, analytical systems and data warehouse
• Create complex stored procedures
• Optimize, repair and rewrite legacy stored procedures
• Create SSRS Matrix (crosstab) Reports
• Create SSRS reports with stored procedures
• Create functionality within Stored Procedure to accept parameter in list form for multi-select option in SSRS reports
• Create schedules (SQL Agent) to automatically email reports rendered in Excel format to managers in Texas, I also taught this concept to the Data services team at Confidential
• Train Data Services team to replace datasets emailed from SQL Server stored procedures with reports scheduled in SSRS for automatic delivery via email, rendered in Excel format
• Work with network techs on specifications for new SQL Server hardware (server)
• Manage SQL Server databases through multiple product lifecycle environments, from development to mission-critical production systems.
• Configure and maintain database servers and processes, including monitoring of system health and performance, to ensure high levels of performance, availability, and security.
• Apply data modeling techniques to ensure development and implementation support efforts meet integration and performance expectations
• Independently analyze, solve, and correct issues in real time, providing problem resolution end-to-end.
• Refine and automate regular processes, track issues, and document changes
• Assist developers with complex query tuning and schema refinement.
• Provide 24x7 support for critical production systems.
• Perform scheduled maintenance and support release deployment activities after hours.
• Share domain and technical expertise, providing technical mentorship and cross-training to other peers and team members.
• New SQL Server installations and configurations
• Install and configure SSRS
• Create SQL Agent jobs and schedules to automate critical processes
• Create, maintain and schedule SQL Server database Backups, this also includes fully restoring databases from backups when necessary
• Monitor and Maintain several SQL Servers

Confidential,Maple Grove,MN

Senior SQL Server Developer, Analysis Services

• Train Data Services team to replace datasets emailed from SQL Server stored procedures with reports scheduled in SSRS for automatic delivery via email, rendered in Excel format
• Create web application to allow users from various sites to enter project down time hours into central SQL Server database.
• Create ETL process to import sales data from Excel file
• Create aggregations for sales reporting
• Design and create the ETL Database “Cretex MG DW.” This is the data collection point and staging database, where data is Extracted, Transformed and Loaded into Dimension and Fact tables for the Receiving DW (DIVA) Data Mart.
• Cretex MG DW provides the core data and is the foundation for the Cretex Data Warehouse.
• Design and create the Cretex MG DW multidimensional Data Mart
• Design and create procedures and SSIS jobs to automate the Extract, Transform and load process for the transactional database as well as refreshing the multidimensional Data Mart.
• Work with network techs on specifications for new SQL Server hardware (server)
• Manage SQL Server databases through multiple product lifecycle environments, from development to mission-critical production systems.
• Configure and maintain database servers and processes, including monitoring of system health and performance, to ensure high levels of performance, availability, and security.
• Apply data modeling techniques to ensure development and implementation support efforts meet integration and performance expectations
• Independently analyze, solve, and correct issues in real time, providing problem resolution end-to-end.
• Refine and automate regular processes, track issues, and document changes
• Assist developers with complex query tuning and schema refinement.
• Provide 24x7 support for critical production systems.
• Perform scheduled maintenance and support release deployment activities after hours.
• Share domain and technical expertise, providing technical mentorship and cross-training to other peers and team members.
• New SQL Server installations and configurations
• Install and configure SSRS
• Create SQL Agent jobs and schedules to automate critical processes
• Create, maintain and schedule SQL Server database Backups, this also includes fully restoring databases from backups when necessary
• Monitor and Maintain several SQL Servers

Confidential,Minneapolis,MN

Senior SQL Server Developer - Consultant

• Create SQL Server database to report on client sales
• Create ETL process to import sales data from Excel file
• Create aggregations for sales reporting

Confidential,MN

Senior SQL Server Developer

• Move/Recreate SSIS packages from retiring server to new server.
• Move/Recreate SSRS Reports from retiring server to new server.
• Design and create the ETL Database “(CIMS) - Consolidated Information Management System” which replaces the legacy database on the AS400. CIMS SQL is a data collection point and staging database.
• Insurance policy data is imported into the database from text files downloaded from the Governments RMA website.
• Auditing scripts within each stored procedure reports the result of each delete and insert statement.