Data Scientists Resume Saint Louis, Mo - Hire IT People

SUMMARY

I am a data expert interested in data modeling, data analytics, and data engineering.
I has a strong passion for process improvements, data definition, SQL performance tuning and optimization.
I has been successful in setting up IT teams for projects involving data quality, reporting and analytics.

TECHNICAL SKILLS

Systems: Windows 9X/NT/2000/XP/ME/2K3/7, SQL Server 2008 - 2019, Report Server 2012 - 2016

Databases: SQL Server 2008R2 - 2019, SQL Azure, Oracle, Microsoft Access, Data warehouses (Tabular and Cube)

Languages: T-SQL, HTML, CSS, C++, Python, Dax, PowerShell, R

Software: MS Project, MS Visio, MS Office, SQL Server 2008 R2 - 2019, SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), PowerShell, Red Gate SQL Developer’s Tool Belt, Visual Studios SQL data tools, Power BI, R Studio, PyCharm, Shiny

PROFESSIONAL EXPERIENCE

Confidential - Saint Louis, Mo

Data Scientists

Responsibilities:

Create best practice documentation for SQL development, SQL Database security, SQL Database patching and updates, and SQL Server Installation
Lead the development of reports with SSRS.
Mentor and lead other junior report developers
Development SQL for financial reports and risk analysis
SQL Server Database and Query Optimization
Model data for ETL, Data Warehouse, ODS layer, and Reports
Create a BI environment for the top leaders using Power BI
Maintain SQL Server database integrity
Restructure Database Backup and maintenance strategies
Prepare data for machine learning and predictive analytics.
Create machine learning models using a number of different algorithms.
Voted top 5 most impactful employee of 2018

Confidential - Saint Louis, MO

Database Administrator Engineer

Responsibilities:

Monitor and repair databases in a high availability 24X7 environmentEnsure all databases are up and running, performance tuned and accessibleAssist in installation, upgrades, migration and maintenance of SQL software and environments
Consult on database design, including table design, security design, impact analysis and table modification
Prepare, review, and maintain effective procedures and documentationCreate procedures to effectively manage, monitor and report on system status and health
Develop processes and standards for I.S. Network Operations technicians to monitor systemDesign automated data integration systems between internal applications
Perform other ad-hoc DBA dutiesModel data for ETL, Data Warehouse, Data Marts, and analytics reporting

Confidential - Creve Coeur, MO

Database Administrator\BI Architect

Responsibilities:

Develop and maintain approximately 200 reports with SSRS across many different systems.
Lead the reporting team in development of reports and skills
Develop T-SQL for reporting.
Design a dimensionally modeled data warehouse from the ground up.
Extract, transform, and load (ETL) with SSIS.
Develop Merge statements
Develop and maintain SQL Server Agent jobs.
Develop and maintain SSIS packages.
Installation and configuration of SQL Server version 2008 R2 to current
Backups and Recovery with and without Maintenance Plans across multiple time zones.
SQL Server tuning:
Index tuning and maintenance on database tables.
Store Procedures
Table/Data type page sizes
SQL installations
Memory Usage
Parallelism (MaxDOP and Cost Threshold)
Develop replication on production databases for faster reporting and maximizing production performance.
Design dashboards with Power BI.
Implement database security by enforcing custom database roles for role based security.
Instill best practices for SOX and PCI compliance.
Troubleshooting Service Broker errors.

We provide IT Staff Augmentation Services!

Data Scientists Resume

Saint Louis, MO

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship