| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidate Candidate's Name
Data Warehouse Architect ( Power-BI / Azure / SQL-Server / Oracle )
Street Address
Email: EMAIL AVAILABLE / Phone: PHONE NUMBER AVAILABLE
Summary
Expertise I am typically brought on to projects for the design, development,
Reporting and automation of back-end Data Warehouse systems & front-end
Power BI Developer; DAX Reporting solutions supporting ERP, CRM, BI, HR, Finance, Payroll,
SSRS ( SQL Reporting Services ) & Sales that require some-or-all of the following deliverables:
Tableau / QlikView - Analytics
Crystal-Reports/Business Objects Gathering of requirements from business users and stake-holders for the generation of
Excel / Power-Pivot / Jet-Reports detailed specifications to determine project scope, materials, timelines, and resources.
Cognos / Dev-Express Reporting
Design, development and automation of the data warehouse and reporting solution life-
Database cycle from conception on through to full-scale automated production.
Azure Data-Factory Pipelines Design, development and administration of Azure / SQL-Server databases, models,
Azure Logic Apps; RESTful/SOAP schemas, tables, indexes, constraints, views, functions, stored-procedures and related
Azure SQL-MI / SQL-Server processes to automate and optimize data warehouse performance.
Oracle PL/SQL; SQL*Loader; OWB
Design of automated ETL processes for importing/cleansing/export of transactional
MySQL / MariaDB / SQLite
database records to/from the data warehouse via a combination of Azure-Data-Factory
Microsoft Access / VBA Pipelines, Azure-Logic-Apps, SSIS/DTS packages, RESTful-API & feed-files (SFTP - PGP/SSH).
ETL = SSIS / Informatica / Mirth
SSAS Multi-Dim & Tabular Cubes Design of data warehouse dimensions, fact tables, and KPI measures necessary for
ERwin / DBSchema Data-Model automated processing of business intelligence cubes and reporting objects.
Design of automated Business-Intelligence Reports using a combination of Power-BI, SSRS,
Application Crystal-Reports, Access, and/or Excel sourcing dedicated Data-Mart(s) / Report-Mart(s).
Azure Web/Function Apps
Design and development of automatically refreshed/delivered SSRS reports that include
Azure DevOps (CI / CD Pipelines)
cascading-parameters and drill-down/drill-through sub-reports.
Visual Studio ( C# / VB / C / C++ )
Windows .Net Development Automation of database administrator tasks related to database backups, SSIS-package
Web ASP.Net Development scheduling, performance-tuning, storage-optimization, replication, and mirroring.
Android Studio Development Design of Win & Web based Apps / API s using combinations of C#, MVC / ASP.Net, Azure
GIT; JSON; Powershell; Python Functions / Web-Apps versioned via GIT & Azure-DevOps CI-CD Build/Release pipelines.
Miscellaneous
Sales-Force CRM / Sugar-CRM Score Card
Azure SFTP with PGP / SSH
Visio; Power-Apps; Office-365 Skills Years Exp.
Sharepoint ( Online / Classic ) Database: Azure SQL-MI / SQL Server ( T-SQL / Data-Tools / BIDS ) 25+
SAP / JD-Edwards / MS Dynamics
Database: Oracle / Oracle Warehouse Builder ( PL-SQL / Unix Shell ) 13
Infragistics; Redgate Tools
UNIX ( PERL / C / Bourne / Korn ) ETL: Azure Data-Factory Pipelines / Azure Logic-Apps / Dev-Ops 6+
ETL: Microsoft SQL-Server Integration Services ( SSIS ) 19+
Education Analytics: Microsoft SQL-Server Analysis Services ( SSAS ) 18+
RIT - Comp. Sci. ( 1986 - 1987 ) Reporting: Microsoft Power-BI Business Analytics Reporting 12+
ECC - Comp. Sci. ( 1983 - 1986 ) Reporting: Microsoft SQL-Server Reporting Services ( SSRS ) 19+
Alden High School ( 1983 )
Application: Win/Web based App Development (C# / MVC / ASP.Net) 25+
Candidate's Name - Data Warehouse Architect ( Power-BI / Azure / SQL-Server / Oracle )
Email: EMAIL AVAILABLE / Phone: PHONE NUMBER AVAILABLE
LinkedIn: LINKEDIN LINK AVAILABLE
Experience
DTS Consulting Services, Inc. ( Independent Consultant ) Sep 1993 - Present
I am typically brought on to projects as a consultant to work with an existing team of
developers to implement part-or-all of the above summarized duties based on project
need. Past projects include Timesheet-Entry and related Payroll systems, End-to-End
Data-Warehousing processes, ERP Systems, Power-BI / SSRS / Crystal-Reports Reporting
systems, as well as Order-Entry, Manufacturing-Assembly, Just-In-Time Inventory, and
Shop-Floor-Control systems implemented with the following companies:
Lewis Tree Service, Inc. ( Utility Provider ) ( Full-Time ) Jan 2021 - Oct 2023
InstantIT.biz, Inc. ( S-A-A-S Provider ) ( Contract-C2C ) Jul 2019 - Dec 2020
AMLI Residential ( Real-Estate ) ( Contract-C2C ) Jan 2019 - Jun 2019
Travel Leaders Group ( Travel Agency ) ( Contract-C2C ) Dec 2017 - Dec 2018
Family Health Network / CCAI ( Healthcare ) ( Contract-C2C ) Oct 2014 - Nov 2017
CME Group ( Finance ) ( Contract-C2C ) Jul 2013 - Sep 2014
Rotella Capital Management ( Finance ) ( Contract-C2C ) Feb 2013 - Jun 2013
Closerlook ( Pharma Analytics ) ( Contract-C2C ) Aug 2012 - Jan 2013
Publicis Group ( Media Analytics ) ( Contract-C2C ) Oct 2011 - Jul 2012
Attain Capital Management ( Finance ) ( Contract-C2C ) Jan 2011 - Jul 2012
Nuveen Investments ( Finance ) ( Contract-C2C ) Apr 2009 - Dec 2010
William Blair & Company ( Finance ) ( Contract-C2C ) Apr 2008 - Mar 2009
CGI Digital ( Advertising ) ( Contract-C2C ) Oct 2006 - Mar 2008
Xerox / EDS ( Office Solutions ) ( Contract-C2C ) Sep 1993 - Feb 2007
Bio-Optronics, Inc. (Manufacturing/Engineering Consulting) Apr 1988 - Aug 1993
I worked as a consultant to Kodak / Xerox / Perkin-Elmer / Rochester-Housing-Authority
in the design and development of Shop-Floor-Control & Embedded systems that
combined data acquisition hardware with process control software to generate
statistical quality control reports used for increase production throughput. I was
responsible for the design, development and deployment of DOS / Windows / Sun-
Solaris based applications, device-drivers, and reports necessary for process control
automation. Projects included development of device-drivers interfacing with Allen-
Bradley PLC s, Zebra Barcode printers, Xerox Magnetometers, HVAC systems, and Opto-
22 sensors used for data acquisition and monitoring of film batch emulsions.
DOS/Windows software development spanned Microsoft C/C++/VB and Turbo Pascal.
Candidate's Name - Data Warehouse Architect ( Power-BI / Azure / SQL-Server / Oracle )
Email: EMAIL AVAILABLE / Phone: PHONE NUMBER AVAILABLE
LinkedIn: LINKEDIN LINK AVAILABLE
|
