Samuel Rodriguez Email & Phone Number

Saint Petersburg, FL, US

Seattle, WA, US

Tampa, FL, US

• Work closely with the IT to design the AWS development environment of big data architecture for advanced analytics and machine learning to effectively reflect business needs, security requirements, and service level.
• Created a Python package to automate our ETL data validation process reducing the time it takes to validate for data quality dimensions by 400%

Tampa, FL, US

• Created a financial booking and adjustment algorithm to minimize the time to book financial data using AWS big data architecture such as S3, Glue, and Redshift Spectrum and provided insights in Power BI.
• Conducted ad-hoc analyses in SQL and Python using advanced statistical packages such as pyspark, pandas, scipy, numpy, seaborn, and matplotlib in Jupyter Notebooks on an Anaconda environment or AWS SageMaker using EMR.

Tampa, FL, US

• Conducted data wrangling, in-depth analysis, and visualization using SQL, Python, and Tableau to ensure validity and reliability of data before presenting potential savings to the client
• Created Tableau reports for the finance and networking team to support their processes and maintain active communication and healthy relationships with all stakeholders

North Chicago, Illinois, US

• Developed and maintained dashboards designed to identify trends, to allocate resources, and to deliver business intelligence insights to drive impact such as lowering Medicare credit balances by around 96.7% from $15k.
• Developed a data mart designed specifically for the Revenue Cycle collection team to acquire necessary data to answer burning questions about performance, efficiency, quality, and effectiveness minimizing our bad debt.
• Developed automated tools using advanced visual basics for application (VBA) and data analytic expressions (DAX) tailored to department needs to resolve ad-hoc related projects collaborating effectively with other.
• Collected using T-SQL; analyzed using Power BI, Excel, and R; and interpreted and presented revenue cycle data to the executive team
• Analyzed old and created new billing, posting, collecting, and payment processes designed to prevent inefficiencies

GB

• Reviewed and completed workflow of evidence gathering activities to assist the auditor to quickly and easily review workflow assignments, including assignments for tasks related to significant and elevated risk
• Tested details of sales, payment, refunds, write-offs, and adjustment to assist the auditor to detect revenue mismanagement using VLookups and Macro-enabled tools
• Assisted co-workers with complex Excel formulas such as error-handling, nested conditionals, and lookup and reference functions

Tampa, Florida, US

• Lectured a 15-minute breakout session to nearly 100 students about business statistics, including multiple regression analysis, ANOVA, multinomial goodness of fit test, hypothesis testing, chi-square test, second-order.
• Assisted students with statistical concepts, effectively increasing their learning and retaining abilities regarding forecasting, autocorrelation, exponential smoothing, time series components, regression, and model.
• Graded homework and exams and proctored exam sessions to control and prevent misconduct and dishonesty
• Created several study guides/documents to help students prepare for exams

Washington, DC, US

• Planned the second successful Change of Command ceremony within budget and monitored the efforts of 8 military subordinates in reaching our goal to serve around 100 attendants, including military families, enlisted.
• Managed a $100,000 annual budget, including but not limited to on many occasions saving the unit from massive deficits
• Organized financial statements, verified receipts, and reconciled credit card statements to ensure the accuracy of budgets always in compliance with Coast Guard policies and regulations
• Updated standard operating procedures to accommodate to current situations and new management giving a clear direction of responsibilities

Washington, DC, US

• Assisted the planning and overseeing of the first successful Change of Command ceremony within budget and coordinated the efforts of 15 military subordinates in reaching our goal to serve around 300 attendants
• Recognized subordinates for their hard work, using administrative remarks, resulting in more motivated personnel and a friendly environment
• Prepared weekly schedules and covered any position to ease the overloaded staff.
• Maintained a $60,000 inventory and assisted the management of a $360,000 annual budget to support the efficiency of the mission

Data Engineering Nanodegree, Data Modeling/Warehousing And Database Administration

Data Science Nanodegree, Data Modeling/Warehousing And Database Administration

Data Analyst Nanodegree, Data Modeling/Warehousing And Database Administration

Bachelor’S Degree, Finance, Corporate Finance

Associate’S Degree, Accounting