SUMMARY:

Experience architecting and delivering end to end data solutions with an emphasis on leveraging MS Data Tools and Power BI to develop advanced analytics and visualizations to meet strategic and tactical business priorities.

TECHNICAL SKILL:

Skills: Power BI / SSRS reports, financial and product performance dashboards, operational and analytical reporting, visualizations, requirements gathering, SSIS/ETL, data modeling, data analysis, data warehousing, data cleansing, agile methodology, solution testing, performance tuning, change management, data governance, active directory, backup/restore, FTP, virtualization, and administrative tasks automation

Analytics: Power BI, MS Excel 2013 / 2016, Power Pivot, Power Query, Power Map, SSRS / SSIS / SSAS, Tableau, MicroStrategy Web, R / Rstudio / RGUI

Databases: SQL Server 2008 R 2 / 2012 / 2014 / 2016 , Teradata

Systems/Software: Windows Server 2008 / 2012 R2, Visual Studio 2013 / 2015, MS Office 2013 / 2016, MS Office 365, MS Project, MS Visio, MS SharePoint, Dynamics CRM 2013

Languages: SQL, T - SQL, M, MDX, DAX, DMX, R, Python, SAS Proc SQL, XML, HTML, VB.NET

Cloud: Azure, Amazon Web Services, GitHub, Git

Tools: Team Foundation Server 2012/2015, SQL Compare, LiteSpeed

CAREER DEVELOPMENT:

Confidential, Addison, Texas

Business Intelligence Developer

Responsibilities:

• Partnered with product owners, finance, accounting and collections teams to develop SSRS operational and financial reports to support new product features and enhancements with design emphasis on accuracy and scalability for future product feature releases and enhancements
• Architected new SSRS deployment model with TFS to facilitate automated report deployments to increase productivity and reduce manual intervention
• Lead developer on the SSRS to MicroStrategy conversion project for external bank financial reporting. Architected the new MicroStrategy reports to leverage advanced dashboard and visualization capabilities to highlight credit risk insights, customer acquisition strategies performance and default predictions

Confidential, Denton, Texas

Senior SQL Developer

Responsibilities:

• Partnered with marketing team to develop marketing trend analytic reports needed to assess the current market strategy performance for customer loyalty program
• Architected new SSIS ETL infrastructure standard for existing back-end data integration processes and database architecture for migration from SQL Server 2005 to 2012, leveraging knowledge of SQL Server database upgrade best practices and I-Series integration. Instrumental in engaging key stakeholders to approve a platform upgrade from SQL Server 2005 to 2012 instead of 2008 R2
• Subject matter expert for marketing department’s business intelligence initiatives on the functionality of customer loyalty system for integration with vendor tools and applications
• Provided DBA/Developer production support for a 6TB+ database and optimized ETL processes with performance tuning to reduce execution times and failures
• Designed a new process to track daily missing store sales transaction data used for customer loyalty rewards program to alert store operations of missing XMIT transmissions to increase accurate assignment of customer rewards

Confidential, Richardson, Texas

Data Architect

Responsibilities:

• Delivered critical IT projects and initiatives that reduced costs of operations, increased revenue and operational efficiencies: Enterprise Reports conversion from Business Objects Crystal Reports to SSRS, monthly billing transaction processing overhaul, SQL Server 2005/2008 R2 to 2012 upgrades, migration of existing BI to Microsoft platform
• Developed data solutions for system modifications and enhancements to support the execution of new marketing products, programs and promotions for the marketing team to generate new sales and business growth opportunities within target deadlines
• Developed data governance processes that enhanced collaboration with internal business partners and promoted consistent business data definitions and data management

Confidential, Dallas, Texas

SQL Server Database Administrator

Responsibilities:

• Successfully helped company to recover from a major hardware failure where transaction log file had to be rebuilt
• Designed a new disaster recovery plan to scale with business growth and data storage maintenance to recover faster from any future disasters
• Implemented a robust script to combat high index fragmentation and increase query execution speeds by 30%
• Evaluated 3rd party backup and restore tools to determine which tool met our business needs with consideration of scalability
• Redesigned scripts for application data archive automation across production database tables that reduced query execution times by 10%
• Coordinated successful production databases migration to new server while successfully minimizing company down time

Confidential, Jacksonville, Florida

SQL Server 2008 R2 Report Developer Intern

Responsibilities:

• Actively contributed to team effort of designing numerous simple to complex T-SQL statements, stored procedures with parameters to query Sales Force database according to business requirements. Evaluated table relationships to determine the most efficient query designs to return requested results
• Designed impressive SSRS reporting solutions according to user specifications to bring meaning to the data and solve complex business requirements using maps, sparklines, data bars, drill downs, subreports, indicators, and gauges
• Configured Reporting Services Configuration Manager and Report Manager and deployed reports for End-User access
• Created new databases, database backups/restores, and migrated existing tables into the newly created databases using Restore Database T-SQL syntax.
• Completed in SSIS training workshop in Wisconsin

Confidential, Milwaukee, Wisconsin

SQL Server 2008 BI Developer/DBA Trainee

Responsibilities:

• Employed best practices in designing numerous simple to complex reports in SSRS involving data imported from relational, multidimensional and XML-based data sources using SSIS and analyzed in SSAS cubes per business requirements while ensuring optimal performance
• Implemented several new enhancements in SSRS such as drill downs, drill through, sparklines, data bars, and maps
• Created numerous simple to complex queries involving joins, correlated sub-queries, common table expressions and XML techniques per business requirements. Tuned and optimized queries by altering database design, analyzing different query options, and indexing strategies
• Employed best practices in creating a complete schema including tables, relationships, stored procedures, views, clustered and non-clustered indexes and triggers, and implemented the import and export of data using XML and SSIS
• Implemented numerous backup and recovery plans based on data availability requirements and the potential impact of data loss after considering and analyzing different backup and recovery strategies. Designed database maintenance plans to set up core maintenance tasks to make sure that the database performs well, and is regularly backed up in case of system failure and is checked for inconsistencies
• Employed the database Engine Turning Advisor to analyze the performance effects of workloads and implemented its recommendations wherever appropriate. Analyzed different high availability solutions and implemented log shipping, database mirroring and replication
• Utilized tools such as SQL Server Profiler, Query Analyzer, Configuration Tools, Activity Monitor, Performance and Reliability Monitor, Data Collector, Policy-Based Management, Resource Governor, and Event Notifications to configure, monitor and ensure optimal performance of SQL Server