Anthony A. Rodriguez

Developer.

Creator.

Innovator.

Analyst.

About Me.

Hi, I'm Tony.

I was born and raised in Miami, FL and I currently live in Portland, OR. I attended Florida International University and Florida State University where I earned a Bachelor of Arts, a Master of Business Administration, and a Master of Science in Finance. I'm employed as a Senior Business Intelligence Analyst at Blue Harbor Senior Living where I work at the intersection of technology, data, and finance.

I love technology.

Not only do I use technology (SQL, SSRS, SSIS, C#, Python, VBA, Visual Studio, Git) in my daily workflow as a Sr. Business Intelligence Analyst, but I also use it in my spare time as a hobby. I continuously strive to expand my skillset and I'm always looking for cool projects to sink my teeth into. Most recently, I coded an HTML5 Space Shooting game using Phaser.js. Check it out!

I'm a lifelong learner.

I have a passion for learning new things. It could be something as small as a new Excel formula or something as big as a new programming language, I never stop learning. Currently, I'm studying for the MCSA: SQL 2016 Database Development certification through Microsoft to help further develop my skills in SQL development. I plan on working towards the MCSE: Data Management and Analytics certification in the future.

Experience.

Sr. Business Intelligence Analyst
Blue Harbor Sr. Living
Aug. 2016 - Present

Responsibilities:
• Gather & define user requirements to understand data needs of internal stakeholders
• Develop, test, and deploy database applications using SQL, SSRS, and SSIS
• Create reports in SSRS using financial, accounting, and operational data
• Work with general ledger data to create monthly variance reporting
• Plan, document, and implement ETL flows using SSIS and C#
• Promote sound data governance and policy as primary data steward

Accomplishments:
• Design ad-hoc queries and analyses to support key business decisions
• Mapped the relationships of our ERP's data model, which does not have a data dictionary
• Developed automated report using SQL and SSRS to track occupancy of senior living facilities which saved over 10 hours a week of manual work
• Developed automated commissions report using SQL and SSRS that replaced a fully manual system

Environment: Visual Studio, MS SQL Server 2016, SQL Server Management Studio (SSMS), SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), C#, Microsoft Excel

Sr. Investment Associate
Northern Trust Corporation
Oct. 2014 - Aug. 2016

• Developed custom reporting solutions using Excel, VBA, and internal business intelligence tools
• Analyzed client financial data using quantitative and statistical functions in Excel
• Created custom VBA scripts to organize, clean, and automate reporting process
• Verified investment returns and correct any discrepancies affecting performance reporting
• Developed custom dashboards in Excel to monitor investment performance
• Created ad-hoc cash flow and balance sheet analyses to support key decisions
• Extracted and analyzed data sets of client financial data to find and correct errors
• Created custom client presentations using PowerPoint, Adobe Pro, and Business Objects
• Provided superior customer service to both internal and external stakeholders

Investment Associate
SunTrust Investment Services
Aug. 2008 - May 2012

• International and domestic client relationship management
• Formulation of asset allocation strategies and long term financial planning and analyses
• Coordination of monthly investment seminars
• Awarded the 2009 Investment Associate of the Year award
• Selected by central management to be the Investment Associate training officer for new hires

Projects.

Education.