SUMMARY:

Over ten years of experience as a Business Intelligence Developer/Analyst architecting, developing, deploying, and managing global enterprise business intelligence solutions in various industries including Manufacturing and Healthcare.

FUNCTIONAL SKILLS:

Project Management, Business Analysis, Systems Analysis, Data Analysis, Data Modeling, DBA, Database Development, ETL Development, Report Development, Data Visualization, Programming, Testing, Training

TECHNICAL SKILLS:

SQL Server: Business Intelligence Development Studio - SSIS, SSRS, SSAS, T-SQL, MDX, DAX, VB, Visual Studio, Agile/Scrum, SharePoint, Performance Point, Power View, Power Pivot, Excel Services, Access, Visio, PowerPoint, Project, InfoPath, Business Objects, Crystal Reports, Qlikview, Tableau

Applications: SAP ERP, Infor Syteline ERP, SalesForce, Jira, Agile, IDX, Epic, TriZetto, Elite Systems

EXPERIENCE:

Confidential, North Reading, MA

Business Intelligence Developer/Analyst

Responsibilities:

• Manage all phases of business intelligence projects from conceptual design to implementation and training.
• Design and configure SharePoint site for Business Intelligence Reporting Services, Performance Point, Excel Services, and Power Pivot applications.
• Create and manage all business intelligence site content, reports, dashboards, analytics, forms, workflows, libraries, data sources, and security.
• Responsible for elicitation and documentation of requirements for the development and enhancement of data warehouse, reports, dashboards, business applications, and business process initiatives.
• Create data models to document and define data requirements, business rules and system integration efforts.
• Create SSIS packages migrating data from various data sources and applying various data transformations.
• Create and manage Visual Studio Data Warehouse project staging, development and production environments.
• Schedule jobs for executing SSIS packages and Pre-Post Office processes to function orderly and smoothly in multi user environment.
• Create SSRS Tabular, Matrix, Chart, Linked, Sub, Drill-down, Drill-through and Parameterized Reports for Finance, Manufacturing, Supply Chain, Technical Operations and Customer Services departments.
• Develop SSAS cubes, tabular models, MDX/DAX queries, Performance Point, Power View, Power Pivot reports and dashboards.
• Implement and manage Tableau data analytics environment. Create data extracts, connections, and dashboards. Provide administration and training. Develop and maintain Total Operating Performance dashboard providing easy navigation to key metrics.
• SQL Server Performance Tuning, Query Optimization, using Performance Monitor, SQL Profiler and other related monitoring and troubleshooting tools.

Confidential, Boston, MA

Business Intelligence Developer

Responsibilities:

• Work with business users to document data requirements and translate into technical design and development tasks.
• Perform ETL from several data sources for loading, updating and maintaining data warehouse.
• Create complex queries, views and stored procedures for reporting and analysis.
• Provide analyses of healthcare data related to health services delivery, healthcare costs, quality of care, insurance coverage, and access to care from a variety of sources including medical and pharmacy claims data, hospital inpatient/outpatient data, quality measurement data, and other resources.
• Support Business Analysts and end users in their development of reports and queries.
• Identify areas of improvement in existing and new initiatives.

Confidential, Billerica, MA

Business Intelligence Developer

Responsibilities:

• Gather data warehouse and report requirements from business users and translate into technical design and development tasks.
• Create data models, ETL packages, and databases for newly developed systems and enhancement of existing systems, and system integration efforts.
• Create complex queries, stored procedures and views with multiple disparate data sources using MS T-SQL and Oracle PL/SQL.
• Create and maintain reports, dashboards, KPIs and BI site using Business Objects, Reporting Services, Analysis Services, Performance Point, and SharePoint.
• Perform data analysis, validation and testing for data warehousing and reporting.
• Interact with the business users to confirm that service-level expectations are being addressed.

Confidential, Boston, MA

Business Intelligence Developer

Responsibilities:

• Develop energy billing analysis reports for Harvard University using Microsoft Reporting Services and Analysis Services.
• Create complex queries, views and stored procedures with multiple disparate data sources using MS T-SQL and Oracle PL/SQL.
• Create data models, databases, cubes, and data integration packages.

Confidential, Cambridge, MA

Business Intelligence Developer

Responsibilities:

• Work with business users to document report specifications and define data requirements.
• Enhance data model and databases, perform ETL, create complex views and stored procedures.
• Create, test and deploy MS Reporting Services reports and SharePoint sites.
• Develop processes for creating and managing data warehouse, SQL code, report specifications, reports, and report sites.
• Provide users with training and technical support regarding report creation.

Confidential, Boston, MA

Business Intelligence Developer

Responsibilities:

• Work with business users to document report specifications and define data requirements.
• Create complex reports and universes using Business Objects Enterprise, Universe Designer, Crystal Reports and Epic Clarity.
• Provide users with training and technical support regarding data analysis and report creation.
• Implement Crystal Enterprise services to automate report generation and delivery.