BI Developer( Tableau) /Data Analyst (SwiftLearn IT Solutions, LLC)
BUSEY BANK (TELECOMMUTE CONTRACTOR)
Skills
reporting tools, Tableau, SAS, MicroStrategy, PowerBI, SDLC, Waterfall, Agile, Win XP, Vista, 7, Windows Server 2003, 2008, X32, X64, Unix, MS SQL Server 2005/2008/2012, MySQL 5.2, 5.7, Oracle 9i, 10g, 11g, DB2, ETL, Other, Alteryx, SAS Base 9.x, SAS Enterprise Guide, SSIS, Erwin Data Modeler, ER Assistant, SQL Management Studio 2008/2012, SQL Plus, SQL Developer, Querying language SQL, PL/SQL, TSQL BI, Tableau 9.1, 9.2, 9.3, 10.2, 10.4, 2018.2, Excel, PowerPivot, SSRS, Crystal Report, Excel file, SQL Server, Oracle databases, Tableau Server, data visualization tools, visualization, Oracle and SQL Server, physical data model, data model, Erwin tool, Gantt, SQL queries, data quality, SQL, aggregate functions, MS SQL server, coding, Python, database triggers, stored procedures, factor analysis, Oracle
Project history
08/2014
-
02/2016
Validated information by creating several complex SQL queries, performing back-end testing, and
determining data quality issues. Developed complex SQL queries while utilizing advanced SQL
concepts, such as aggregate functions. Utilized Joins, sub-queries and explain, stats, cast and
volatile tables on SQL server to write queries. Produced filters, quick filters, table calculations,
and various views in Tableau. Performed ad-hoc reporting analysis and manipulated complex data on MS
SQL server. Revised coding to SAS and Python application upgrades and extensions.
* Created views and database triggers, stored procedures and functions using SQL such that
information entered by a certain WM can make appropriate changes to the respective tables.
* Examined and reduced errors in data to present inter-departmental communication and monthly
reports.
* Resolved business problems while applying statistical techniques such as regression, cluster
analysis, factor analysis, time series forecasting, experimental and design.
* Contributed in extraction, transformation, and loading of data from various source systems, such
as flat files, Excel, Oracle and SQL Server.
determining data quality issues. Developed complex SQL queries while utilizing advanced SQL
concepts, such as aggregate functions. Utilized Joins, sub-queries and explain, stats, cast and
volatile tables on SQL server to write queries. Produced filters, quick filters, table calculations,
and various views in Tableau. Performed ad-hoc reporting analysis and manipulated complex data on MS
SQL server. Revised coding to SAS and Python application upgrades and extensions.
* Created views and database triggers, stored procedures and functions using SQL such that
information entered by a certain WM can make appropriate changes to the respective tables.
* Examined and reduced errors in data to present inter-departmental communication and monthly
reports.
* Resolved business problems while applying statistical techniques such as regression, cluster
analysis, factor analysis, time series forecasting, experimental and design.
* Contributed in extraction, transformation, and loading of data from various source systems, such
as flat files, Excel, Oracle and SQL Server.
Local Availability
Only available in these countries:
USA
I can work in any time zone.
