SUMMARY:

• Create and modify SSRS reports
• Create and modify T - SQL for SSRS reports
• Data Masking
• 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), Data Masking

Languages: T-SQL, OLAP, ADO, DAO

Databases: SQL Server 2000/2005/2008/2014

PROFESSIONAL EXPERIENCE:

Confidential - Minneapolis, MN

Responsibilities:

• work in an enterprise level environment
• Report Writing using SSRS
• Create and modify T-SQL for SSRS reports
• Create New SSRS Reports
• Data extraction using Optim tool
• Data comparison using Optim tool to insure Teradata database records match SQL Server database records exactly and report the outcomes of comparisons
• Database data-masking
• Create Difference Reports
• Design and create business commercials: Sales, Animated, Whiteboard, explainer and more
• Design and create talking 2D, 3D, and Human Video Spokesperson pop-ups for websites
• Face Book pages and Video Headers
• Internet marketing consultant
• Personal development speaker
• Host of the George Vincent on-line radio show
• 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 Cretex Concrete Products
• 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- 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

Senior SQL Server Developer

Responsibilities:

• 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- 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

Responsibilities:

• 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

Senior SQL Server Developer

Responsibilities:

• 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.
• Imported data is cleaned, transformed and pushed out to the following two enterprise reporting databases:
• CIMS (Farm apps database) SQL Server

Confidential

Senior Systems Analyst

Responsibilities:

• Designed and created the ETL Database “Shipping DW.” This is the data collection point and staging database, where data is Extracted, Transformed and Loaded into Dimension and Fact tables for the Shipping DW (DIVA) Data Mart.
• Shipping DW provides the core data and is the foundation for the Shipping Data Warehouse.
• Designed and created the Shipping DW multidimensional Data Mart (DIVA Data Warehouse).
• Designed and created procedures and SSIS jobs to automate the Extract, Transform and load process for the transactional database as well as refreshing the multidimensional Data Mart.
• Designed and created the ETL Database “Receiving 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.
• Receiving DW provides the core data and is the foundation for the Shipping Data Warehouse.
• Designed and created the Receiving DW multidimensional Data Mart (DIVA Data Warehouse).
• Designed and created procedures and SSIS jobs to automate the Extract, Transform and load process for the transactional database as well as refreshing the multidimensional Data Mart.
• Created SQL Server 2005/Access 2003 ADP client server application to provide web-based, secure ELG10 ledger reports for the Finance department. The ELG10 ledger reports were created using SQL Server 2005 Reporting Services and are used by upper management and the executive branch to track budget Vs actual metrics at the cost center level. The secured web interface will only show those reports that the user has permission to view. The Access/ADP front end allows is also secure and allows authorized Finance personnel to import new data from the Excel ledger and update existing data in the SQL Server database with one button click.
• Designed and Created The ASN Visibility and Receipt Planning Database which combined the three MS Access databases which were currently being used, migrated data stored in the MS Access databases into the new SQL Server database.
• 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- 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
• Project Manager for data migration and consolidation project
• Analyze critical Access databases and create plan for data migration and consolidation on SQL Server
• Work with managers to determine priority order of databases for migration
• Work with Data Services team data consolidation strategies
• Create and Maintain SQL Server databases
• Create new reports using SQL Server Business Intelligence Development Studio
• Maintain existing SQL Server Reporting Services reports
• Maintain existing SQL Server databases

Confidential

MS Reporting Services, Report Developer

Responsibilities:

• Create Linked reports using SSRS to give multiple clients to access the same report suite segregated and secured by Client.
• Create stored procedures for use as report data sources using MS SQL Server 2005
• Create queries for use as report data sources using MS SQL Server 2005 and TOAD For Oracle
• Optimize queries for faster processing
• Maintain existing reports
• Create Reports for Security Benefit, SE2 and external clients: Prudential, Morgan Stanley, Mutual of Omaha, Goldman Sachs
• Deploy Base Report and Link to client folders
• Reports are initially created and deployed on QA Server for testing, once users approve reports they are moved to the Production environment
• Created Report Execution database and reports to allow team to track report failures

Confidential

SQL Server DBA; SQL Server 2000/2005 Developer

Responsibilities:

• Created SQL Server 2005/Access 2003 ADP client server Supply Inventory Application, adjust using transactions with auditing, with all transactions stored and reported on, and all information in the database was available through MS Reporting Services, with no need for table level access.
• Upsized the Access 2000 (SmartYard application) to SQL Server 2005 the SmartYard application is a commercial support application that controls the movement of more than 200 trucks per day from gate to Docks. Created stored procedures, views functions and linked server to the database to replace the ones created in Access and re-create the 43 reports using MS Reporting Services.
• Created SQL Server 2000/staging database, cleaning and transforming data and creating Dimensional Data Marts for shipments, using Analysis Services; creating Excel 2003 pivot table for use as front end.
• Created SQL Server Machine Inventory database with Access 2003 ADP front-end for Operations to track supplies used for warehouse machinery and building maintenance. Created DTS Packages to Extract Transform Load data from Access database into SQL Server.
• Extract Transform Load AS400 into SQL Server-As the SQL Server Database Administrator, am responsible for the management and control of the data resources. Utilize Data Dictionary Software to ensure data integrity and security. Perform Data Recoveries and minimize data redundancy. Perform tuning and performance tuning to improve Database performance. Install, configure, tune and maintain software. Install application database definitions, tables and security software. Participate in the creation and maintenance of application backups, triggers, stored procedures and control scripts.
• Met with company executives as technical advisor for my manager to get the SQL 2000 Servers approved. The new servers will allow us to upsize our Legacy applications to SQL 2000 Server, with Access 2003 and .NET front end.
• Provide internal consultation to internal users regarding performance applications. Install and upgrade SQL Server application tools. Allocate system store and derive plans for future storage initiatives.
• Establish database naming standards and conventions. Design and develop processes and tools to automate tasks effectively. Manage application business rules through approved implementation of database constraints.
• Implement proactive approach to identify, troubleshoot and resolve problems using database monitoring tools. Create database object dependencies from entity relationship diagrams. Implement physical database design strategies.
• Researched hardware, software and license for New SQL 2000 Servers, installing, setting up and administering three Microsoft SQL 2000 Servers for the SmartYard application. Created and Implement Back-up Plan for the SmartYard SQL Setup Log Shipping for production SQL Server Database
• Provide support for critical SQL Server 2000/2005 and Access 2003 client-server databases.
• Best Buy Topeka, KS;
• Technical Services Supervisor
• Provided oversight to technical support initiatives across the retail floor

Confidential

Database / Network Support

Responsibilities:

• Created SQL Server 2000/Access 2000 ADP client server Job Ticket application; the Job Ticket Application is now a core application of the company.
• Contracted with a local vendor to replace three faulty servers with one reasonably priced server that was well suited to our needs. Oversaw and managed the setup and implementation of our current high-speed Internet access capability. Provided all technical support for all employees and built three computers for the company.
• In support of the Denver Specialized Billing Application, created a new billing system Tracking 2.1 using Access 97; the previous system was replaced because of numerous data, maintenance, and reporting problems. Analyzed the previous system and corrected numerous database issues.
• Created relationships between the tables, normalized the database tables, supporting duplication of data and reporting services and supported programming, dealing with system lockups, inconsistent data updates, and the application would not compile.

Confidential

SQL Server Developer

Responsibilities:

• Developed an Access 2000/SQL Server 7/2000 Design Center Application for Richmond American Homes Design Centers. This application will give Richmond a point-of- entry system for a major profit center.
• Captured sales data was moved into existing construction, sales, budgeting, and accounting systems. DTS packages use OLE DB to update millions of records, nightly, from MDCs AS/400 construction and accounting systems. Tight integration utilizing ADO to call stored procedures insures data integrity while the Design Center application records standard selections and upgrades. The standard selections and upgrades recorded from 10,000 annual homebuyers were previously beyond the reach of legacy applications.