Data Modeler
2018 - PRESENTBlue Cross Blue Shield NC- Designed and created database models for enterprise-wide projects.
- Created tables and views.
- Performed data analysis.
- Completed R&D for new technology.
Technologies: Star Schema, Entity-relationships Model (ERM), Teradata, Excel 2016, Windows, C#, Tableau, Python, SQLSQL Developer
2019 - 2020McKeil Marine (via Toptal)- Developed a business oriented database on Microsoft Azure from scratch.
- Created all tables based on business needs.
- Created complex stored procedures to meet business requirements.
- Created complex views.
- Created triggers.
Technologies: Entity-relationships Model (ERM), Azure SQL, Excel 2016, Windows, SQLDatabase Developer and Administrator
2010 - 2018CCL- Designed, created, and managed primary objects such as tables, triggers, database links, indexes, and privileges based on a logic design model.
- Developed all the required stored procedures, user-defined functions, and dataset results in reporting services to reduce code complexity and optimize performance.
- Developed applications for manufacturing efficiency improvement.
- Created conceptual, logical, and physical data models for creating the schema using MS Visio and ER/star/snowflake schema for data marts.
- Applied technical skills using SQL, Excel in data collection, data analysis, and reporting to procure data from database structures to report and provide solutions to client requests in a timely manner.
- Contributed to building business dashboards to conduct trend analysis on sales metrics especially relating to driving sales revenue, customer retention, and production.
- Tuned, troubleshot, evaluated, and recommended database hardware and software including support tools to increase performance.
- Provided support to developers for integrating development environment (C#) into databases.
Technologies: MacOS, Software Development, .NET, Microsoft Access, Excel 2016, Microsoft Visual Studio, C#.NET, SQL Server 2016, SQL Server 2014, SQL Server 2008, Windows, Snowflake, Star Schema, Entity-relationships Model (ERM), Visio, Data & Backup Management, Microsoft SQL Server