Frank Samstag Email & Phone Number

Azure Data Engineering Stack, Azure Synapse Analytics SQL, Data Warehouse Architect, Advanced Power BI for a large and varied user base in Distribution Center operations and maintenance.

Houston, Texas, Us

Consolidate and Globalize data from multiple, international ERP systems as the source for new and improved Data Warehouse. Business Intelligence Design, Implementation, and Support. IBM DataStage for ETL development. Cognos Framework Manager. Cognos Analytics 11.1 Report Development. SQL Server Analysis Services for OLAP and Cube Development. Visual Studio 2017 (SSDT). Power BI for creating a Database Performance Monitoring Report. Created executive dashboard of Sales trends and KPI using Power BI. Coach and mentor junior developers. Write new documentation and update existing documentation.• SQL Server 2008 and above Database Technologies Stack• Design and develop ETL packages utilizing SSIS and DataStage• Review and repair existing ETL packages for accuracy, quality, and performance• Report Development using SSRS, Power BI, and Cognos• Extensive use of T-SQL skills for managing Stored Procedures, DML, DDL, Views, and Query Performance Tuning• Occasional use of database design and data modelling

SQL Server 2016, 2012, 2008 R2, 2005, 2000: Production database administration, Oracle Hyperion Administrator, Dynamics CRM Administrator, SAP Concur Administrator, Data Warehouse Architect, and Business Intelligence Developer. Power BI Pro Developer and Administrator. Halo BI Developer and Administrator. Frequently used the full SQL Server BI toobox: SSRS, SSIS, SSAS, SSDT, SSMS.

Houston, Tx, Us

Provide support to customers (mostly DBAs) who are using the Idera suite of database administration software products: SQL Diagnostic Manager, SQL Compliance Manager, SQL Safe, SQL Defrag Manager, SQL Secure, SQL Admin Toolset, integrating Idera products with Reporting Services. Duties include installation and configuration help and troubleshooting, debugging and fixing problems, answering questions, and offering recommendations for best usage. SQL Server 2005/2008 SSMS, SSRS, SalesForce CRM for case tracking. Provide accurate and timely technical support to customers via telephone, email and chat. Manage support issues of a complex and technical nature with varying degrees of priority. Address incidents within predetermined service levels, requiring the ability to multi-task and prioritize. Insures that needs of customers are met. Supervise Level 1 support engineers.

Austin, Texas, Us

This company specializes in supplying and servicing complete gas compression units for the natural gas industry on a contract basis. Used SSMS and T-SQL for database administration: Implemented best practices for data security, change management, source control, reliability, and availability. Upgraded SQL Server 2005 to 2008. Advanced Crystal Reports and SSRS development. Participated in designing and ensuring SOX compliance. Provided technical support for various software for accounting systems: Exact Macola, EBA, Event Manager. Performed query tuning, database integrity analysis, replication, disaster recovery preparation, log shipping, preventive maintenance, and capacity planning. CLR development using C#. Demonstrated outstanding customer service by exceeding expectations and proactive follow-up. Rapid response to troubleshooting requests. Used SSIS for various systems integration and automation projects, including extracting data from text, spreadsheet, or XML files, transforming and validating it, then loading it into the database for use in customer queries through a Web interface. Used SSAS to create cubes for an OLAP project. Participated in software development teams. Wrote documentation for new and existing systems and used SharePoint 2007 to create & maintain a knowledgebase for documentation.

Peachtree Corners, Georgia, Us

This company specializes in mystery shopper and pricing surveys. Used SQL Server 2005 Business Intelligence Development Suite (Integration Services, Analysis Services, Reporting Services) for a variety of OLAP projects to automate, migrate, and integrate business processes. Built data cubes from a data warehouse, for which I designed the dimensions, facts, aggregations, and KPIs. Built SSIS packages to load data from flat files (ETL). Designed and deployed SSRS reports and report models to a Website for customers to easily access and display information. Used SSMS and T-SQL for database administration: Responsible for backup/recovery operations, log shipping, replication, change management, maintaining indexes, optimizing performance, reliability, database integrity, security, and server configuration in a highly dynamic and demanding data management environment. Designed and wrote documentation for several processes to move incoming files from an FTP site to an import directory, then extract the data, convert and validate the data, then insert it into a database. Required lots of communication with user community as well as other IT professionals. Provided high quality customer service and troubleshooting, even after hours and weekends.

Design new reports that eliminate manual calculating and errors, improve customer relationships, and reveal new business opportunities using SQL and Crystal Reports XI, running against DB2. Supervised computer operators and technicians. Install and administer SQL Server 2000 for data warehousing project based on a star schema design, including T-SQL, stored procedures, performance tuning, triggers. Wrote scripts for extracting and loading data using XML and VB.NET. Crystal Enterprise for Web-based distribution and scheduling. Crystal Reports 7, 8, 8.5, 9, 10, XI.

Build/implement/maintain/support database applications for business clients: analysis, requirements, documentation, testing. Database development for n-tier client-server networks. Oracle RDBMS design and modeling. Used Tivoli monitoring and Tivoli service request manager to log and track programming changes and troubleshooting. Implemented a Web-based CRM on a Linux server.