Data Analyst Power Bi

Summary

Experienced Data Analyst, with years of successful Software / ETL deployments at large companies, on many platforms / technologies. Able to leverage both my expert IT development capabilities, also my IT Security knowledge (CISSP certification) for better overall outcomes!

Performing actual software development (all phases of SDLC) has been a constant theme throughout my career. Each role involved understanding data, developing software to effectively utilize the data, carefully unit and system testing all proposed solutions, working with users to gain approval for production, implementing to production, and production support when and where required. The past 10+ years have largely been focused on developing ETL automation pipelines, to either achieve systems integration and/or reporting according to client requests and expectations.

Always willing to do whatever necessary (on my own time, as needed) for mastery / certification in new technologies.

Professional Experience

Ecolab, Inc., St. Paul, MN July 2012 – Present

Lead IT Security Engineer

Returned to Ecolab. Technical systems analysis, infrastructure analysis, process analysis, and troubleshooting to accomplish the following:

BI Security Dashboards 2016 – Present

Designed, constructed and implemented significant data integration solutions (using PowerShell and/or Python ETL automation pipelines) to export security-related data into a central database:

40+ automated processes now feed data from multiple external vendor APIs/Ecolab databases, into a Risk Management. database. This database currently has 800+ tables, supporting both Azure apps, and multiple Power BI Workspaces. Many Dashboards and reports have also been created, to provide creative and insightful visuals, into major areas such as those shown below:

oCDS Security, OT Security, Global Supply Chain, PhishMe Campaigns (Proofpoint), Internal Audit, Security Register, Legal Hold, ServiceNow data, Assets and Vulnerabilities (Qualys), 3rd Party Vendor Reviews.

ETL Development: I’m an expert data analyst, using various tools like Excel, file comparison software, data dictionaries, etc. to analyze and organize business data. Big data has its own set of rules, however with smaller datasets (i.e.: < 1 million rows) I look to build relational tables out of the data. Where possible, will focus on more densely populated attributes and look to organize data to 3rd normal form, meaning 1) Atomic data, 2) One Primary key per table, and 3) Any secondary primary keys (and dependent data) to child table. After creating table definitions and performing various tests for data veracity, it’s time to develop programming to populate the table definitions at the correct granularity with the correct consolidation and/or filtering as needed.

ELT Development: For some Big Data / No SQL systems, load the data first, then look for patterns after loaded, and bring it together based on families of data – roughly similar to tables. I had some experience with this as a student at University of St. Thomas (while working at Ecolab). I also had experience with ELT during a previous role, where we loaded data into a relational database (with RI turned off), executed transformations to sanitize the data, then turned RI back on.

Python Capabilities: Became an expert in PowerShell during my time building these ETL processes and central database for Ecolab. Although most were written in PowerShell, some were also written in Python. In my experience, I haven’t had much difficult navigating between PowerShell and Python. Both have objects, dot navigation, programming libraries, and can encapsulate code in functions. In my opinion, the real expertise is having a programming background, and development mindset, which is my background.

Azure Capabilities: Worked on Azure on a frequent basis to support the following functions: VM (virtual servers for automation processing), SQL Server DBs (PaaS), web apps (deployed to web slots), Entra ID (app registration for membership rolls, SSO), and blob storage contained with an Azure Resource Group, under an Azure subscription (using Azure Storage Explorer to contain images for web facing apps).

SSMS expertise: Worked on SSMS on a daily basis, in the process of building out the central database mentioned above. Import / export wizards to help sanitize data, Design mode for table design, etc. Used all parts of SSMS needed to create and manage an enterprise database.

Complex SQL queries: I’m an expert with writing complex SQL queries, as I’ve been administering the MS SQL database for the IT Security department of Ecolab. This database has over 800 tables. I’ve been the main administrator for this database for the past 10 years, which involves adding / removing users, GRANTing / removing permissions, and table access, creating DB Triggers, and occasionally stored procedures. Not only am I the administrator of the database itself, but also created all the daily / ETL processes (in PowerShell) pulling large amounts of data from SaaS vendors.

Power BI Capabilities: Have been using Power BI for data visualization, creating interactive dashboards and reports for 10+ years, while building out the central security database at Ecolab. I am able to make effective use of spacing and color on interactive PBI images, telling an effective story, allowing multiply filters, links to other website pages, etc., even drill-downs as needed. Using Direct-query mode, which allows immediate access to the SQL table data.

Postman Capabilities: Used Postman frequently. Postman is a popular API automation development tool, allowing developers to design, build, test, and document APIs. You can save all your basic API calls, and with the click of a button write them in just about any scripting language desired.

Excel skills: We often find ourselves converting Excel sheets into SQL tables, to it’s mandatory to be able to use Excel functions to compare between different sheets with tools like VLOOKUP, etc. to tie them together, and control the views for ease of presentation.

Symantec Endpoint Protection (SEP) 2012 – 2015

Server support, including SEP11 maintenance and support, and later SEP12 upgrade across multiple divisions. Expand SEP infrastructure to DMZ for outside reporting.

Delta Airlines July 2006 – July 2012

Senior Programmer/Analyst at MLT Vacations, Inc.

Build-out MLT’s extranet for Car and Hotel processing:

External Car Functionality: External car inventory functionality Added to MLT’s reservation system (via xml-based interfaces for Enterprise rent-a-car brands).

External Hotel Functionality: External hotel inventory functionality added to MLT’s reservation system (via xml-based interfaces for Outrigger Hotels), accessing 3rd party HBSi Hotel reservation system (Replicational model).

Back-office Automation: Developed/deployed new software to automate back-office data entry processing needed to add external hotel properties to MLT's reservation system (saving thousands of man hours/year).

Websites: deltavacations.com/unitedvacations.com/worryfreevacations.com/worldagentdirect.com

Ecolab, Inc., St. Paul, MN. August 2005 – July 2006

Programmer/Analyst – Sr. Consultant for Keane, Inc.

Returned to Ecolab (as consultant) to maintain and provide enhancements for Ecolab’s core IT systems. COBOL, Data Warehouse, Informatica.

Implemented CAS ERP system to service entire Ecolab supply chain.

Multi-year process: my expertise was in the Cost Accounting module.

Education

Master of Science in Data Analytics – Big Data

Univ. of St. Thomas, St. Paul, MN

Bachelor of Science in Computer Science and Business Administration

Minnesota State University – Mankato, Mankato, MN

Certification

CISSP - Certified Information Systems Security Professional, 2015

Technical Skills

Databases: Oracle, MS SQL, Db2, Db2/2 (Long history of SQL Dev)

Applications: Power BI Dashboards/Reports, Tableau Stories/Dash/Wks., Salesforce Admin/Automation, SAS Enterprise Miner, Symantec Endpoint Protection, Juniper, RSA, Retina, NCircle, Informatica

Platforms: Server/Azure Admin, Linux, Unix, VMS, Windows, Mainframe

Languages: VB.NET, C#.NET, VB 3,4,5,6, MF Cobol, Cobol, Perl, PowerShell, Python, R

Other: ASP Runner, XML/CSS/HTML

Contact this candidate