| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidateCandidate's Name
MCP, MCSD, MCDBAEXPERIENCE SUMMARYMr. Augustiniak holds a BS in Computer Science. He has over 32 years of professional IT experience, including 14 years of tenure at Deloitte, as a SQL developer and DBA. He has strong experience in SQL development, SSIS, SSAS and SSRS, ETL and T-SQL. Familiar with OLAP & Data warehouse concepts, reporting, tables, views, triggers, stored procedures, querying, joins, indexes. He has strong experience designing Access-driven databases and automating the Microsoft Office suite. TECHNICAL SUMMARY Strong experience in MS SQL Server 2005-2016 with Business Intelligence in SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS) and SQL Server Reporting Services (SSRS) Experience in migration of Data from Excel and Flat files to an MS SQL Server by using BCP and DTS (SQL 2000) utility and automating imports with SSIS (SQL 2005/2016) Knowledge of Various SSIS Objects such as Dataflow Components, Control Flow Elements, Connections Managers, Runtime Events, Log Providers etc. Developed and implemented Jobs, Alerts, SQL Mail Agent and scheduled SSIS Packages Worked with OLAP and Data warehouse application and worked with star schema, snowflakes schema dimensions and worked with implementing SSAS, and SSRS to support large Reporting needs for Tax practice Expert in handling parameterized reports, formatting report layout, sub reports using global variables, expressions, functions, sorting the data, defining data source and subtotals for the reports using SSRS 2005/2016 Worked extensively on designing and maintaining data cubes using ODBC to access data from heterogeneous databases including Excel and flat files Experienced in creating the cubes and dimensions (SSAS) and also hands on MDX(Multidimensional Expressions) Experience in developing web-based applications using T-SQL Programming (DDL, DML and DCL) Experienced in creating and managing database objects Tables, Views, Triggers, Cursors, Stored Procedures, user defined data types and Functions Excellent T-SQL Experience in Performance Tuning and Query Optimization Experience with SQL Performance tuning and transactions analysis, thorough understanding of indexes and statistics Experienced in dealing with Relational Database Management Systems, including Normalization, Stored procedures, Check Constraints, Querying, Joins, Keys, Indexes, Data Import/Export, Triggers and Cursors Extensive work using SQL data with Access, Excel and PowerPoint front end SKILLS SUMMARYDatabases: SQL Server 2000, 2005, 2008R2, 2012, 2014, 2016 and MS Access Candidate's Name PAGE 2Tools: SSAS, SSIS, SSRS, TSQL, MS Office (MS Excel, MS Access, Word, PowerPoint) Languages: T-SQL, HTML, VBScript, JavaScript, VBA, C#, App Script Systems: Windows 2000, XP, Vista, Windows7, Windows 10 PROFESSIONAL EXPERIENCEHTC / Ford November 2020 May 2024VBA Programmer / SQL Developer Support and development of the Global Regulatory Tool (GRT) for North America. Developing Vehicle Audit application adding additional graphic displays. Development of Weight Efficiency Metrics (WEM) for Ford engineers. Development of the Procedure Extractor to support GRT and other scripted programs. Developing testing system for GRT. Developed SSIS Packages in preparation to move GRT to a SQL database from MS Access. Using ETL to extract data from MS Access database and Excel spreadsheets. Developing system for fuel fill audits. Developing system for handling DCV data. Developing system for graphic display of Breakpoint data. Aided in the further development of GRT for China. Scripting of various ad hoc assignments as requested. TEKsystems October 2019 June 2020Database Developer/ Programmer Supporting online provisioning systems for Ascension Health Technologies. Adding new features and provisioning request systems. Provisioning for COVID 19 to relocate staff to remote support Supporting 35 ministries country wide maintaining two online systems. All backend coding is in C#. Database servers are SQL 2016. Source code is managed by GitHub. My projects are managed with JIRA. Development work done in SSMS and Visual Studio 2019. NuTechs May 2019 July 2019Database Administrator/Programmer Converted SQL databases from Enterprise to Developer editions with a cost saving of $245,000 Upgraded SQL 2000 through 2008 R2 to SQL 2016 in development and QA environments. Corrected permissions bringing them to the proper access level. Established development and QA structures for existing SQL servers. Corrected SQL database structures to conform to company standards. Removed unused replication and corrected replication to point to proper sources for each environment. Gathered, stored, and analyzed many different types of SQL Server data sources. Analyzed databases for data migration and upgrades. Candidate's Name PAGE 3 Created Stored Procedures to encapsulate data reuse. Performance tuning of queries.Genesis10, Troy, MI Mar 2016 Mar 2019SQL Programmer/ VBA Programmer Provided database programming expertise for Bank of America Developed and automated project tracking system using SQL backend and an Access Automated Excel reports drawing data from SQL and processing using VBA Designed and automated PowerPoint Presentations using SQL data, creating views, stored procedures and VBAGenesis 10, Troy, MI Nov 2012 Nov 2015Systems Database Administrator III/SQL Programmer Provided database programming and administration expertise for Bank of America Developed and automated stored procedures and SSIS packages to facilitate and track the removal of Not Permitted Technology. Providing analysis of both TEM and Tivoli data developing reports to be consumed by management Developed database to track conversion from Windows XP to Windows 7 Designed tables, views, stored procedures and automating all processes using SSIS Designed and automated an MS Access front end solution for manipulating MS SQL data Designed and maintained Access-driven data repository to store and track data Self Employed, Troy, MI Apr 2010 Nov 2012Technician/ConsultantProvided technical services for individuals and small business Installed and maintained hardware and software for visually impaired clients through Life Solutions LLC Developed website development for personal and business use for Life Solutions LLC maintaining under lying database. Data imports using DTS and OLAP tools including ETL SSIS packages Deployed hardware, software, network and internet access for computer school lab in Chilmari and Ulipu, BangladeshDeloitte, Detroit MI Jul 1995 Feb 2010SQL Programmer/ Database AnalystProvided programming expertise for Detroit Tax and Audit office Designed and automated a Tax Revenue Analysis application with Business Intelligence in SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS) and SQL Server Reporting Services (SSRS) Worked extensively on designing and maintaining data cubes using ODBC to access data from heterogeneous databases including Excel and flat files Implemented and modified stored procedures to extract raw data from the Helpdesk database Generated reports using SSRS with data from the Helpdesk database Automated and maintained Human Resources Master Data Repository with SSMS and stored procedures and SSIS Developed reports for the Managing partner in the New York office using SSRS 2005/2008 handling parameterized reports, formatting report layout, sub reports using global variables, expressions, functions, sorting the data, defining data source and subtotals for the reports Experience in developing web based applications using T-SQL Programming (DDL, DML and DCL)Candidate's Name PAGE 4 Designed The Waterfront, a web based Human Resources on-boarding system; totally automating all processes using SQL stored procedures and dynamic HTML using MS Access as the data repository Implemented Graphics department document retrieval system (Docs Open) in a nation-wide deployment Designed automated Excel spreadsheets using VBA to track client tax forms Loral Aerospace, Dearborn, MI Sep 1991 - Jul 1995Technician/ConsultantPC technician assigned to the Ford Campus and Ford World Headquarters in Dearborn Maintained PC hardware in Ford Danou Tech Center, Chesterfield Trim Plant, and Basic Oxygen Furnace in Allen Park Provided on-call support to trim production system, resolving hardware, software and network communications problemsEDUCATIONWayne State University, Detroit, MichiganBachelor of Science in Computer ScienceCERTIFICATIONSCertifications MCP, MCSD, MCDBAControl Data Institute, Southfield, MI Earned a certificate in by completing 800 hours of self-paced individualized training in computer maintenance and repair |
