We provide IT Staff Augmentation Services!

Business Intelligence Developer/analyst Resume

North Reading, MA

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.

Hire Now