Mary T. Phan
VSolvit LLC
Fairfax,VA
30
years of professional experience
Power BI Reports Expert and Knowledgeable SQL Developer with solid background in designing, developing, and maintaining complex SQL databases. Successfully implemented optimized queries and stored procedures, enhancing database performance and reliability. Demonstrated expertise in database design and data modeling, with focus on ensuring data integrity and security.
Work History
Senior SQL Developer at the Drug Enforcement Administration (DEA)
1 Year 6 Months- Created and delivered in-depth Power BI reports that improved decision-making for management and DEA field agents.
- Crafted and optimized SQL scripts for rapid data retrieval to support ad-hoc and on demand data requests and FOIA requests
- Designed and optimized complex SQL queries to enhance report performance and Storage optimization.
- Designed and implemented data marts and analytical models with Power Pivot to support data-driven decision-making.
- Maintain existing SSRS reports.
Senior SQL Developer at the DEA
10 Years 11 Months- Designed and optimized complex SQL queries to enhance data retrieval efficiency.
- Optimized database performance through indexing and query tuning strategies.
- Crafted and optimized SQL scripts for rapid data retrieval, enabling timely responses to business inquiries.
- Designed and implemented data marts and analytical models with Power Pivot to support data-driven decision-making.
- Designed and implemented online reports with SSRS.
- Created and delivered in-depth Power BI reports that improved decision-making for management and DEA field agents.
Senior Database Developer at the Drug Enforcement Administration (DEA)
3 Years 2 Months- Developed reports using SQL Server Reporting Services (SSRS) and Business Intelligence Development Studio 2012 (BIDS), integrating these reports into DEA's Concorde System to support informed decision-making.
- Wrote ETL packages to extract and normalize data from multiple sources into SQL Server and Oracle databases using SQL Server Integration Services (SSIS), enhancing data consistency.
- Created Data Models for Business Analysis, and Dashboard Reporting using Power Pivot.
- Refreshed databases daily on staging, development, testing, and production servers in data warehouse to ensure data accuracy and availability.
Senior Software Engineer
2 Years 10 Months- Developed applications using C#/.Net framework to enhance functionality and user experience.
- Mentored junior engineers, enhancing team productivity and fostering skill development.
- Collaborated with cross-functional teams to define technical requirements and project scope.
Senior Software Engineer
5 Years 3 Months- Developed various applications in web-based and client-server based specialized in Billings, Customer Care, and Rate Plan Analysis applications for the Wireless Industry.
- Executed system installations and deployments at client sites, ensuring seamless integration and minimizing disruption to operations.
- Provided on-site training and support for newly deployed applications, enhancing client proficiency and satisfaction.
Senior Software Developer
1 Year- Designed and developed commission tracking and value check systems to optimize phone service rate plans based on historical calling and payment records.
- Integrated billing and customer care systems to streamline operations and improve service delivery.
- Developed applications for Windows-based and client-server environments utilizing Oracle back-end to meet user needs.
Software Developer
1 Year- Developed and implemented software solutions to enhance mobile service offerings.
- Conducted code reviews to ensure adherence to coding standards and best practices.
- Collaborated with cross-functional teams to define project requirements and deliverables.
- Developed comprehensive reports for marketing, finance, account receivables, fraud, inventory, commission, and activation using Oracle PL/SQL stored procedures and Oracle Developer 2000 to support data-driven decision-making.
Software Developer
1 Year- Developed and maintained mobile applications using Java and Kotlin to enhance user experience.
- Collaborated with cross-functional teams to identify software requirements and deliver technical solutions.
- Led code reviews and provided mentorship to junior developers, fostering knowledge sharing and skill development.
- Extracted data from live production database to data warehouse for reporting and backup, ensuring data availability and integrity.
- Provided consulting services and developed management reports using Oracle PL/SQL stored procedures and Oracle Developer 2000, enhancing decision-making.
Education
Bachelor of Science - Electrical Engineering
Skills
Power BI Report expertise
Data modeling expertise
SQL Server Reporting Services (SSRS) expertise
Advanced in SQL Server
PL/SQL
Oracle Database development
Advanced in ETL process design using SQL Server Integration Services
Proficient in Programming languages: Visual Basic
C++
C#
SQL
PL/SQL
JavaScript
Python
Proficient in Visual Studio
Timeline
Senior SQL Developer at the Drug Enforcement Administration (DEA)
VSolvit LLC
01.2025 - CurrentRead More
Senior SQL Developer at the DEA
Chenega Professional and Technical Services
02.2014 - 01.2025Read More
Senior Database Developer at the Drug Enforcement Administration (DEA)
Complete Data Solutions, LLC
11.2010 - 01.2014Read More
Senior Software Engineer
Free Eagles Technologies, Inc.
01.2008 - 11.2010Read More
Senior Software Engineer
Sentori Billing, Inc.
09.1999 - 12.2004Read More
Senior Software Developer
Aerial Communications
09.1998 - 09.1999Read More
Software Developer
Pacific Bell Mobile Services
09.1997 - 09.1998Read More
Software Developer
Powertel
09.1996 - 09.1997Read More
University of North Carolina
Bachelor of Science from Electrical Engineering
Read More
Clearance Level
DoD Secret