Buisness Intelligence Developer

Sal Giacalone

858-***-**** adctmx@r.postjobfree.com

.

Skills

•Microsoft SQL Server (SSMS)

•SSRS Power BI Cognos

•SQL Server Integration Services (SSIS)

•SQL Server Analysis Services (SSAS)

•Oracle PL/SQL

•Advanced Microsoft Excel

•Data warehousing design and implementation.

•Performs quantitative and qualitative analysis of data to produce business solutions.

•Agile (LeanKit/Jira) and Waterfall Methodology

•Reviews, evaluates, and implements requests from clinical user departments

•Worked with multiple source control products (SVN, TFS)

Work Experience

BI Analyst

BREG Carlsbad, CA SEP 2019 -

Breg provides premium, high-value sports medicine products and services that advance patient orthopedic care.

Audits raw data brought in from Oracle ERP into SSMS and SSAS Tabular cubes.

Designs and delivers standard report to across multiple departments such as Sales, Finance, and Supply Chain.

Converted and decommissioned reports from Cognos to SSRS and Power BI.

Works and writes reports from multiple data sources. (SSAS cubes, SQL Server tables, Oracle PL/SQL)

Audits long running and inefficient report to be re-written and resource friendly.

Works hand BI Architect and DBAs on daily basis.

Meets with internal report users on weekly scheduled meetings to prioritize and evaluate new requests.

BI Developer (Consulting)

ITAV Solutions San Diego, CA SEP 2019 - MAY 2020

ITAV operates nationwide and helps hospitals manage their 340B program administrator.

Developed and maintained SSRS report and Databases

Provided self-serve reports to sales and operations teams.

Data Analyst

SUNRx San Diego, CA JAN 2015- MAY 2019

SUNRx operates nationwide and helps hospitals manage their 340B program administrator.

Provided complex reporting to Account Management, Sales Team, and Leadership.

Created Pricing Models to solve issues between customer and client.

Used TSQL to write ad hoc queries to provide for business needs.

Created databases, tables and SQL jobs for application development and maintenance.

Created self-serve reporting internal and external use to solve business needs.

Served as Configuration management (CM) for 2 year.

Created, monitored, and scheduled SSIS packages to be loaded into SQL Server. These packages were used to report on via multiple BI tools. ( i.e. Power BI, SSRS) Also used for SQL development for invoicing clients. As well, as experience manually loading files for ad hoc reporting.

Associate, Business Process Management

MedImpact Healthcare Systems, San Diego, CA JAN 2014-DEC 2014

MedImpact Healthcare Systems, Inc. a Pharmacy Benefit Management (PBM) company.

Accounting Processes, Management Documentation.

Implementing Compliance 360 (document management repository for policies procedures, job roles and guidelines definition)

Education

California State Sacramento University 2009-2014

BA, Public Relations

Certifications: Webucator SQL Server Reporting Services 2012 for Report Writers

Contact this candidate