Business Intelligence Data Analyst

DOMINGO ANTHONY DURAN - “Tony”

Contact 401-***-**** (401-DEV-HELP), Warwick, RI

*******************@*****.***

Objective Experienced IT professional with a strong background in data analysis, business intelligence, and database management. Seeking a Data Analyst or BI Analyst role to leverage expertise in SQL queries and data pipelines. Proven ability to develop and optimize data solutions, create impactful reports, and support strategic decision-making. Attained a security clearance, demonstrating trustworthiness and commitment.

TECHNICAL SKILLS

Database Management: SQL Server, Oracle, PL/SQL, T-SQL, SSMS, MySQL, MS Access, SQL Developer, TOAD Business Intelligence: Data Analysis, Data Pipelines, Financial Reporting, SharePoint, Visio, PowerPoint Programming Languages: C#, VB.NET, JavaScript, Java, Perl, HTML, CSS, XML, JSON, REST Tools & Technologies: Visual Studio, SSIS, SSRS, TOAD, Excel, Access, Word, Git/GitHub, Notepad++ Development & Design: .NET Framework, MVC, ASP.NET, Razor Pages, Agile methodologies, HTML, AngularJS Languages: Fluent in verbal Spanish, intermediate in written Spanish PROFESSIONAL EXPERIENCE

Database Architect

TISTA Science & Technology (Contractor for the VA) September 2023 – Present

• Assisted in the consolidation of SQL Server databases, designing a master data dictionary to optimize data integration, improving data accessibility and performance across multiple systems.

• Conducted thorough reviews of database security settings, including user and group permissions, ensuring data security compliance.

• T-SQL and Excel used to perform schema and stored procedure comparisons, identifying opportunities for system optimization.

• Presented observations and recommendations at leadership meetings to improve database and system documentation practices.

Sr. .NET Developer

TISTA Science & Technology (Contractor for the VA) August 2021 – September 2023

• Enhanced and supported VB.NET code for the VA’s workers compensation information system, and extended the contract based on system improvements.

• Managed large-scale data imports into an Oracle DB, creating accurate reports with custom-made Importer application, Toad for Oracle, and Excel.

• Successfully upgraded a legacy application from VB6 to VB.NET 4.8 and Oracle 19c, significantly improving system performance and maintainability.

• To improve data security successfully conceived, proposed, developed, and implemented a data masking application for test Oracle DB environments.

• Obtained and maintained security clearance, demonstrating a high level of trust and responsibility in handling sensitive data.

Sr. Programmer Analyst

Narragansett Bay Commission

June 2015 – January 2021

• Modernized the water pretreatment system, transitioning it from classic ASP to ASP.NET, and developed dozens of custom reports and letters to support operational efficiency.

• Spearheaded the implementation of a new Content Management System (Umbraco) for the Narrabay.com website, improving content delivery and user experience.

• Developed interactive dashboards and visualizations using Telerik Kendo, replacing outdated Silverlight technology and providing real-time data insights with animated gauges.

• Actively managed and supported multiple systems, including delivering SSIS data extracts and resolving tickets to support organizational operations.

System Design Analyst

Narragansett Bay Commission

March 2010 – June 2015

• Maintained and enhanced .NET C# systems, including customer service, billing, and lab data entry, ensuring seamless operational continuity.

• Led the creation of a Purchasing section for the company’s website, integrating with SharePoint for document management.

• Took full responsibility for IT programming after the senior developer left, successfully handling all coding, support, and enhancement requests for a year, while training new hires and building a successful team.

Web Developer

Freelance Consultant

January 2009 – March 2010

• Developed a multipage online reporting system for consulting clients, integrating custom web forms and MySQL databases, improving data collection and reporting capabilities.

• Optimized a local business website using JavaScript, HTML, and CSS, creating a dynamic and user- friendly interface to improve customer engagement and data collection accuracy. Programmer Analyst

Putnam Investments

June 1997 – January 2009

• Worked on the Prime Money Market Portal as part of a Java development team, creating advanced financial reporting tools.

• Led the database design and implementation for the Product Information Conversion project, ensuring seamless data migration and enhanced reporting.

• Managed and optimized Perl SQL scripts for a net tracking application, improving data processing efficiency and reporting accuracy.

EDUCATION & PROFESSIONAL DEVELOPMENT

University of Rhode Island

Computer Science Major - Kingston, RI

• Associate degree; gained extensive practical experience beyond formal education. Relevant Certifications & Training

• SAFe Scrum Master 6, SAFe Scrum Master 6, SAFe for Teams 5.1

• JIRA, SharePoint, Informatica PowerCenter ETL, Kendo UI, MVC, ASP.NET, HTML

• Visual Studio, Umbraco, Bootstrap, Java 2 SDK, CICS, VB6, Telon Batch/Online Additional Professional Development

• Participated in various workshops and seminars on advanced data analysis, business intelligence, and emerging technologies.

• Continuously updated skills through online courses and self-study to stay current with industry trends.

Contact this candidate