Hung Phan Email & Phone Number

Allen, Tx, Us

• Modernized SSRS reports to new cloud based reporting tools such as Looker, greatly improving performance and user experience. • Assisted in conversion of on-premise SQL Server database to cloud based Snowflake database, greatly improving the performance, reliability and flexibility of the reporting abilities.• Troubleshooting and debugging reports with performance problems and fixed inaccurate reporting using data analysis and programming skills, which proved invaluable in maintaining critical reports and data feeds. • Gathered requirements, analyzed large datasets, created mockup reports and delivered multiple Power BI Dashboards such as Dealer Performance Reports allowing key stakeholders to manage their losses and track the performance of various products in different geographical locations.

Dallas, Tx, Us

• Primary resource in charge of design and development of SQL related projects, from Logical/Physical Data Modeling,SQL Object Creation (Table, Views, Procedures, Functions, Triggers) and writing business rules using complex T-SQL Queries.• Increased efficiency and run-time of legacy SQL code, utilizing best-practices and most efficient code possible. • Designed and developed Database backend (Tables, Views, Functions, Stored Procedures) to support Online transaction processing (OLTP) for employees to enter data remotely.Provided expertise and suggestions for problematic code and SQL jobs that were having issues and errors. • Troubleshooting application and report performance, then optimizing using tools like SQL profiler, Activity monitor in SSMS, Query execution plans to analyze where indexes may be needed.

Woonsocket, Ri, Us

• Created new and complex SSRS reports with drill-down/thorough reports and created subscriptions to deliver the reports in a timely manner, making projections more accurate. • Designed and debugged SQL SSIS flows, T-SQL Queries, and Stored Procedures to convert existing SAS which greatly increased the efficiency and reliability of business processes.• Assisted the problematic SSIS flows for other team members improving the productivity of the team, and making the processes run much more efficiently.• Designed and created Tableau dashboards for metrics reports which were critical for management decision making.

Nashville, Tn, Us

• Oversaw databases with over 500M records, ensuring high availability and performance.• Operated as one of the key SQL developers for migration projects to convert large complex Oracle databases to MS SQL Server.• Created, maintained, and optimized complex SQL Scripts, SQL Queries, T-SQL, stored procedures, and functions for migration of data.• Designed templates and complex SSRS Reports improving forecasting and decision-making.• Analyzed, debugged, and designed complex reports on large volumes of data contained in various databases and identified data integrity issues.• Improved efficiency and enhanced existing SQL code that improved the accuracy and runs times of stored procedures and reports.

Dallas, Texas, Us

• Functioned as one of the key designers, coders, and implementers of SSIS that automated the querying, transformation, and transmission of data from LOS systems to financial vendors.• Created and maintained Power BI advanced reports and dashboards for management.• Analyzed and designed complex reports on large volumes of data contained in many large corporate databases and identified data integrity issues.• Executed MySQL Database/AWS conversion to a local SQL Server Database.• Optimized SQL Scripts, SQL Queries, T-SQL, stored procedures, and user-defined functions.• Identified deficiencies in existing data flow and improved the processes and code run times.• Increased data processing efficiency by 25% through optimization of ETL processes.• Developed and maintained ETL pipelines processing over 1TB of data per day.• Designed many invaluable SSRS Reports, used by major departments, such as Operations, Accounting, Marketing, and Risk Management.• Key contact in communication with third party vendors in reporting and troubleshooting various system errors and production issues, thus solving many problems allowing our daily processes to run smoothly and efficiently.

Dallas, Texas, Us

• Architected, developed, and implemented a department Data Warehouse, ETL, and SSRS/Performance Point dashboard solutions using the Microsoft BI stack.• Utilized advanced Stored Procedure/T-SQL coding, performance tuning, and query optimization to create new and enhanced SSIS/ETL processes, stored procedures, and functions.• Implemented the conversion of Scribe Insight DTS jobs to Microsoft SSIS packages, which allowed for much easier maintenance and support of the data synchronization.• Utilized advanced MDX querying skills to significantly increase the efficiency of reporting.

• Performed Business Development / Architecture for sales report per business requirements.• Created key business reports (SSRS) for several client businesses, including Tetra, Greystar, Citizens State Bank, First Southwest, and Safety-Kleen.• Designed reports such as Financial Forecast and Performance Metrics, Consolidated Financial Summary Report, Property Distribution Breakdown, Physical Occupancy Breakdown, etc.

• Designed and implemented OLAP cube to store data for various reporting purposes, allowing management to make better-informed decisions on spending and advertisement costs.• Served as SQL Server database administrator and maintained the MySQL database.• Specialized in SQL querying language as well as SQL Server Integration Services (SSIS)/ETL processes used to facilitate the mining and transformation of data for business purposes.• Created key Marketing/Sales reports, Sales Forecasting reports, Inventory/BackOrder reports, Web Statistics reports, and many others that were vital to the marketing and spending allocation decisions by the company.

•Helped users to customize their reports (Crystal Reports) and troubleshoot problems with connectivity and other errors encountered.•Used DTS packages for month end databases that greatly simplified for management the enormous amounts of data imported and processed over the period. The information was gathered into a Data Warehouse that was used as a repository for our clients to do various high-level reporting on the vast amount of data that was made available to them daily.•Reduced user downtimes by supporting a reconciliation application and administrating a total of eight SQL Server production databases.•Created and maintained stored procedures and triggers that updated key information that sustained the integrity and efficiency of the database.