Data Solutions Adviser Resume Ft. Lauderdale, FL - Hire IT People

SUMMARY:

For the past five years I have contracted or worked for internal I.T. Departments, with duties ranging from Application Development to Business Intelligence.
Lately I have been applying my Windows .NET experience to the Microsoft Business Intelligence Stack, developing Dashboards/Reports and ETL processes to supply meaningful data to the Business and its various Stakeholders.
I just completed a CRM project with Confidential, my responsibilities ranged from writing Ad - Hoc SQL Queries to managing our AWS Cloud Operations.
Currently I am seeking long term employment at an Organization where I can apply my knowledge of Business Intelligence, AWS Cloud Operations and Data Solutions.

TECHNICAL SKILLS:

WORK EXPERIENCE:

Confidential, Ft. Lauderdale, FL

Data Solutions Adviser

Responsibilities:

Providing the CEO with morning briefings, concerning our KPI metrics for sales reps, analysis of our various cloud systems and detailed progress reports regarding Savage CRM.
Managing all Development Operations via AWS Management Console.
Developing UML process flows of current systems that need to be integrated with Savage CRM.
Developing Dashboards in Excel Power Pivot and Tableau to display Savage CRM data and progress.
Appraising and developing a comprehensive budget for Software Licenses and Cloud Operations.
Modeling SQL Server Database that will be integrated with Savage CRM.
Configuring Microsoft SQL Data Tools, Analysis(OLAP), Integration and Reporting Services.
Configured AWS Cost Explorer and CloudWatch to set alarms on our various services and provide reporting on Cloud Operation Costs.

Confidential, Kendall, FL

Data Analyst

Responsibilities:

Developing SQL Scripts to fulfill Data Request from Business Users.
Report Automation using VBA and Excel OLEDB and ODBC Connections.
Developing Access VBA Client Applications for the Collections Department.
Responsible for developing and managing Script Tasks for Report Automation.
Developing comprehensive Dashboard with drill down functionality for Collections Department.

Confidential, West Palm Beach, FL

Software Developer

Responsibilities:

Set in place standards and UML documentation of process flows for e-commerce transactions.
Configuring and managing AWS cloud instances.
Customizing preexisting e-commerce administration portal.
Reporting on AR, inventory and sales data using Power Pivot and Tableau.

Confidential, Doral, FL

Business Intelligence Analyst

Responsibilities:

Analyzing and developing T-SQL Scripts to fulfill data requests from Business Users.
Creating Dashboards thru Power BI to gain funding from Upper Management for future BI projects.
Developing ETL processes using both SSIS and T-SQL Stored Procedures.
Creating and Managing SQL Server Agent jobs (mostly for ETL).
Developing and deploying SSRS reports to SharePoint and SSIS packages to SQL Server 2008 R2.
Revamping preexisting SSRS reports and tuning T-SQL scripts for maximum performance.

Confidential, Ft. Lauderdale, FL

Business Intelligence Developer

Responsibilities:

Developing SQL Scripts in a large Windows Enterprise Data-warehouse Environment (Snowflake Typology).
In charge of report automation in Visual Basic for Applications (VBA).
Creating reports off the Data-warehouse in Tableau, SSRS and Power Pivot.
Responsible for administrating the company KPI’s hosted on SharePoint.
Responsible for maintaining our Job Stack of Power Pivot Reports thru VBA Macro’s or SSRS Subscriptions.

Confidential, Miami, FL

Business Intelligence Developer

Responsibilities:

Creating and altering T-SQL Scripts and Stored Procedures for SSRS Reports.
Developing C# and VBA Scripts to automate ETL and Reporting processes that were heavily dependent on unstructured data sources (i.e. 837 and 835 Medical Billing Claims).
Developing SSRS Dashboards with drill down functionality (i.e. links to reports at lower granularity) for the sole purpose of our annual audit.
Ad-Hoc reporting and analysis with Microsoft Power Pivot.
Managing and creating SQL Server Agent Jobs.