Uploaded File
add photo
Alan
fisheralef@gmail.com
919-985-5029
300 Old Mill Vilage Drive
Apex, NC 27502
Senior Technical Lead
14 years experience W2
0
Recommendations
Average rating
38
Profile views
Summary

15 years as a Technology professional with various technical expertise in Data Visualization, Power BI, Tableau, SQL & Python. Involve in a Financial Industry for more than 5 years and Lead a team and project for 10 years.

Core skills & Training:

  • Data Analysis using Programming Statistical (R statistical software)
  • Mathematical Methods for Data Analysis (MATLAB software)
  • SQL Server 2012
  • Jaspersoft BI Suite, Jaspersoft, San Francisco, CA
  • Microsoft Cluster Training, Peopleclick, Raleigh, NC
  • Oracle DA I and II, Wake Tech, Cary, NC
  • Oracle PL/SQL, Wake Tech, Cary, NC
  • DB2 Administration for Experts, Jack Morton, Durham, NC
  • Writing Queries Using TSQL, New Horizons, Morrisville, NC
  • Maintaining A SQL Server 2005 Database, New Horizons, Morrisville, NC
  • DB2 Administration for UNIX, Jack Morton, Durham, NC
  • SQL Server 2000 Administration, Global Knowledge, Cary, N.C.
  • MySQL Database Performance and Tuning, MySQL AB, Raleigh, NC
  • CISSP Prep Course, New Horizons, Morrisville, N.C.
  • Perl Level I&II, North Carolina State University
  • Network Security II, Global Knowledge, Cary, N.C.
  • Network Security I, Global Knowledge, Cary, N.C.
  • XML Level1, North Carolina State University
  • PHP/MySQL, North Carolina State University
  • R/S Plus, BD Technologies, RTP, N.C.
  • CLARA Robotics Management Software Training, Caliper, Braintree, MA

Certifications:

  • Advance Match for Quantum Computing
  • Quantum Computing: Theory to Simulation and Programming
  • Quantum Computing & Quantum Physics
  • Architecture, Algorithms, and Protocols of a Quantum Computer & Quantum Internet
  • Certified Machine Learning A to Z Hands-on with Python and R
  • Certified Spark and Scala for Big Data and Machine Learning
  • Certified Deep Learning: Hands-on Artificial Neural Networks
  • Certified Neural Networking Using MATLAB Programming
  • Certified Hadoop, Hive, Pig, MapReduce Administration, and scripting
  • Certified Advance R for Statistical Analysis

Experience
Senior Technical Lead
Information Technology
Oct 2021 - present
  • Assigned to Internal Audit/Fraud Data Analytics Team
  • Used Impala/Hive to validate and create code that assesses risk and mitigates potentially illegal funds transfers.
  • Writes queries through Hue and IntelliJ IDE for submission
  • Uses Git for version control and code repositories associated with JIRA tickets.
  • Trains junior members on analytic methods and procedural matters related to code development and deployment.
  • Uses Control-M, Azure Data factor, and Amazon Lambda and Terraform for job automation.
  • Used PowerBI and Tableau, R, Python, and SQL for Data Anomaly Visualization
Version Control Terraform Tableau SQL Python MS Azure Internal Audit impala IDE Hive Git ETL Data Visualization BMC Control-M Auditing Analytics Actor JIRA
Remove Skill
Senior Application Architect
Healthcare
Mar 2019 - Oct 2021
  • Part of Data Governance and Data Quality Initiative at Veradigm, to provide quality data and rules surrounding ingestion and delivery of data to and from customers.
  • Utilize SQL, R, and Python for Data Analysis of EHR for data lake project.
  • ETL Developer using SQL for transferring data from SQL Server 2014 to YellowBrick/PostgreSQL
  • In process of migrating from PostgreSQL YellowBrick in AWS to Snowflake in Azure.
  • Talend MDM, DQ, DA, and Big Data Administrator and Developer
  • Informatica Server, Client Power Center, MDM and DQ installer, Big Data administrator, and developer.
  • Inject large data sets using Hadoop and work with Horton Works/Spark SQL installer.
  • Perform data analysis, set up data governance, and Informatica to connect data from both AWS and Azure cloud.
  • Utilize Azure Data Factory to establish large data sets consisting of patient health records and electronic payments.
Talend Studio Tableau SQL Server Spark SQL Spark Snowflake Python PostgreSQL MS Azure Informatica Powercenter Informatica Hadoop ETL Developer ETL EMR Data Visualization Data Lakes Data Governance Data Analysis Big Data Azure Data Factory AWS Applications Architecture Analysis Actor SQL
Remove Skill
Technical Architect / Big Data - Contract
Banking/Financial
Dec 2018 - Mar 2019
  • Lead projects to add new Tableau and PowerBI reports to banking dashboards.,
  • Data Quality Analyst for data entering and being stored in CDW and Data lake
  • Primary Technical Advisor for migrating Data from legacy SQL Server to PostgreSQL Data Warehouse with Advanced Analysis Capabilities
  • Architected a Big Data Solution using Hadoop and Spark SQL to handle analytical dashboard needs.
  • Installed, configured, and wrote test protocols for Analysis, Data Storage, and Workflow Software.
  • Wrote SQL, R, and python Alteryx scripts for QA of data transferred to the new schema
  • Administered Tableau Server kept in off-site as well as desktop setup
  • Alteryx Consultant for Daily Sales and Historical Sales Dashboards.
  • Authored Best Practices Documents for use of new Data Warehouse
Tableau Server Tableau SQL Server SQL Spark SQL Spark Sales Quality Assurance Python PostgreSQL Hadoop ETL Data Warehousing Data Visualization Data Lakes Big Data Banking Analysis
Remove Skill
Data Scientist - Contract
Professional/Consulting Services
Oct 2018 - Dec 2018
  • Stood up and administered SparkScala/mlib/R cluster using Hadoop as big data storage.
  • Main contact for Analytics and Data Management and cleanup and optimization of legacy and production systems with MySQL, PostgreSQL, and SQL Server.
  • System Administrator on Mac, Ubuntu, and Windows Server for configuration and troubleshooting on ETL and analytics projects.
  • Stood up PostgreSQL, Pentaho, Kettle, JasperServer, and Knowage environment for Analytics POC
  • Performed Data Mining and created active dashboards for legacy and active data analysis.
  • Mentored junior DBA in advanced MySQL, Pentaho, and SQL Server connection, performance tuning, and data warehouse creation.
Windows Server Windows Ubuntu System Administration SQL Server SQL Scala Problem Solving PostgreSQL Performance Tuning Pentaho Tableau OPTIM MySQL MLib Jasper Reports Hadoop ETL DBA Data Warehousing Data Visualization Data Science Data Mining Data Analysis Big Data Analytics Data Management Spark
Remove Skill
Data Manager / Financial Analyst
Healthcare
Oct 2017 - Aug 2018
  • Worked in the Internal Audit Department as a Data Manager, Financial & IT Analyst
  • Administered SQL Server 2012, 2014, and 2016 instances
  • Developed Dashboards in PowerBI and Tableau for Bank Dashboard publication.
  • Communicated with various data stewards to obtain data for internal audits.
  • Understood the needs of each individual auditor and applied business knowledge to design solutions for data acquisitions
  • Established policy and security for PII and other types of data in IA environments.
  • Data sources included Excel.csv and tab-delimited, as well as Oracle, DB2, Hadoop, and Netezza databases, schemas, and tables.
Tableau SQL Server Oracle Netezza Microsoft Excel Internal Audit Hadoop Financial ETL DB2 Data Visualization Data Management Auditing SQL
Remove Skill
Senior Data Analyst / Research
Banking/Financial
Mar 2017 - Oct 2017
  • SME for SQL Server and Oracle
  • Level 4 -5 Support for Financial COTS and Application Developer Scripts
  • Reviewer and Controller of Change Management Content and Approver of Environment alterations in production.
  • Storage Optimization and Environment Adviser
  • Tableau Administrator and Development of Audit Dashboards

Tableau SQL Oracle OPTIM Financial ETL Data Visualization Data Analysis Change Management Auditing SQL Server
Remove Skill
Senior System Analyst
Information Technology
Dec 2016 - Mar 2017
  • Level 3 Support for Oracle/SQL Server.
  • Architected new database model implementations and wrote TSQL, BASH, and Perl applications for database automation
  • ETL Process Coordinator, Administrator, and Troubleshooter, using stored procedures, triggers, and functions.
Triggers Tableau System Analysis Stored Procedure SQL Server Perl Oracle ETL Data Visualization BaSH SQL
Remove Skill
Senior Database Architect / Data Analytics
Professional/Consulting Services
Jan 2015 - Oct 2016
  • Led SQL Server and DB2 Data Architecture for the storage and archiving of current and past clinical research data and materials.
  • Primary contact for performance tuning issues including hardware, OS SQL engine, and query tuningdb2 systems running on Windows Server, AIX and RHEL, Mac OSX, Query Tuning, Performance Tuning, System Architecture, Security Compliance to HIPPA.
  • Technical Lead on Optim and PureScale deployment projects in test, QA, and production environments.
Windows Server Windows Tableau System Architecture SQL Server SQL RHEL Quality Assurance PureScale Performance Tuning OPTIM Mac OS ETL DB2 Database Architect Data Visualization Data Architecture Compliance Clinical Research Analytics AIX HIPAA
Remove Skill
Senior Database Analyst
Information Technology
Mar 2013 - Aug 2015
  • Designated Subject Matter Expert for SQL Server and MySQL, through the IBM Global Technology Services
  • Lead Data and System Architect for Chrysler and Toyota accounts
  • Data Analyst for DB2/Oracle/SQL Server-based ticketing, backup reports, and data migration.
  • Responsible for Knowledge Transfer, including training, to on and offshore personnel for IBM and Chrysler.
Training Tableau System Architecture SQL Server SQL Oracle MySQL ETL DB2 Database Backups Data Visualization Data Migration Data Analysis
Remove Skill
Conversion Consultant
Professional/Consulting Services
Nov 2012 - Mar 2013
  • Responsible for determining data to be transferred from legacy to new Oracle-based Data Warehouse environment for NCDOR, based upon agreed-upon Business Rules by coding new solutions.
  • ETL Process Coordinator, writing PL/SQL packages and scripts to transform and load data
  • Data Analyst and Quality Auditor
  • PL/SQL debugger and coder for stored procedures, triggers, and functions.
Triggers Tableau SQL Oracle ETL Data Warehousing Data Visualization Data Analysis Auditing Stored Procedure
Remove Skill
Chief Technology Consultant
Professional/Consulting Services
Jul 2010 - Dec 2011
  • Main technology advisor for startup Intellectual IP consulting firm implementation of legacy and new applications to support CRM, Patent Search, FDA Regulatory, and NIH grants
  • Responsible for reviewing aspects of technology consultation for novel and patentable hardware and software inventions to determine their viability for funding and marketing.
  • Designed, implemented, and maintained back-end database instances needed for novel and open-source application packages
  • MySQL and PostgreSQL database designer based on PHP form data collection from clients and consultants
  • Web designer and Webmaster for all Company websites
Webmaster Tableau SQL PostgreSQL PHP MySQL Marketing FDA ETL Data Visualization CRM Application Support
Remove Skill
Statistical Data Analytics
Professional/Consulting Services
Dec 2010 - Jun 2011
  • Providing advice to System and Database Architecture efforts to optimize storage of company data PostgreSQL environment.
  • Design of database tables, file structure, DDL, and DML packages of production data to be fed to the statistical group for further analysis and data mining.
  • Assisting Statistical and Clinical programmers with analysis of requested data.
  • Writing Ad-Hoc SQL queries to retrieve requested data from IVR, Outbound Calling, and reports databases for CEO and VP.
  • Wrote R code to query databases, retrieve and package data for statistical analysis
  • Authored iReports for internal business customers and submitted to web administration application for scheduling and established offline databases for reporting purposes.
Web Administration Tableau Statistical Analysis SQL R Code PostgreSQL OPTIM IVR ETL Data Visualization Data Mining CEO Analytics Analysis
Remove Skill
Oracle DatabaseAnalyst
Professional/Consulting Services
Oct 2008 - Dec 2008
  • Oracle 9i and 10g DBA responsible for account creation, security, tuning, database cloning, and environment refresh for Wake County Public School Systems main datacenter.
  • The administrator of Jasper Server and iReports generation.
  • Created Database Monitoring schemas and installed software for all Oracle instances.
  • Oracle Application set-up, Administrator on Solaris 9, 10, and AIX, and Microsoft Server.
Tableau Solaris Oracle Microsoft Server Jasper Reports ETL DBA Data Visualization Data Center Cloning AIX SQL
Remove Skill
Edit Skills
Non-cloudteam Skill
Education
Bachelor's in Mathematics
North Carolina Central University
Minor: Computer Science

Magna Cum Laude

Skills
Data Visualization
2022
10
ETL
2022
10
SQL
2022
10
Tableau
2022
10
SQL Server
2021
8
Data Analysis
2021
6
DB2
2018
4
MySQL
2018
4
Oracle
2018
4
PostgreSQL
2021
4
Actor
2022
3
Analysis
2021
3
Big Data
2021
3
Hadoop
2021
3
MS Azure
2022
3
OPTIM
2018
3
Python
2022
3
System Architecture
2016
3
Analytics
2022
2
Applications Architecture
2021
2
Auditing
2022
2
AWS
2021
2
Azure Data Factory
2021
2
Data Governance
2021
2
Data Lakes
2021
2
Data Migration
2015
2
Database Backups
2015
2
EMR
2021
2
ETL Developer
2021
2
Informatica
2021
2
Informatica Powercenter
2021
2
Snowflake
2021
2
Spark
2021
2
Spark SQL
2021
2
Talend Studio
2021
2
Training
2015
2
AIX
2016
1
Application Support
2011
1
Clinical Research
2016
1
Compliance
2016
1
CRM
2011
1
Data Architecture
2016
1
Data Management
2018
1
Database Architect
2016
1
FDA
2011
1
Financial
2018
1
HIPAA
2016
1
Internal Audit
2022
1
Mac OS
2016
1
Marketing
2011
1
Performance Tuning
2018
1
PHP
2011
1
PureScale
2016
1
Quality Assurance
2019
1
RHEL
2016
1
Webmaster
2011
1
Windows
2018
1
Windows Server
2018
1
Banking
2019
1
BaSH
2017
1
BMC Control-M
2022
1
CEO
2011
1
Change Management
2017
1
Cisco
0
1
CISSP
0
1
Cloning
2008
1
Data Center
2008
1
Data Mining
2018
1
Data Science
2018
1
Data Warehousing
2019
1
DBA
2018
1
Git
2022
1
Hive
2022
1
IDE
2022
1
impala
2022
1
IVR
2011
1
Jasper Reports
2018
1
JIRA
2022
1
Machine Learning
0
1
MapReduce
0
1
Matlab
0
1
Microsoft Excel
2018
1
Microsoft Server
2008
1
MLib
2018
1
MS Power BI
0
1
Netezza
2018
1
Network Security
0
1
Neural Networks
0
1
Pentaho
2018
1
Perl
2017
1
Pig
0
1
Problem Solving
2018
1
R Code
2011
1
Robotics
0
1
RTP
0
1
Sales
2019
1
SAN
0
1
Scala
2018
1
Scripting
0
1
Simulation
0
1
Solaris
2008
1
Statistical Analysis
2011
1
Stored Procedure
2017
1
System Administration
2018
1
System Analysis
2017
1
Tableau Server
2019
1
Terraform
2022
1
Triggers
2017
1
Ubuntu
2018
1
UNIX
0
1
Version Control
2022
1
Web Administration
2011
1
XML
0
1