Summary:

Over ten years of experience as a Business Intelligence Developer/Analyst architecting, developing, deploying, and managingglobal 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, PowerPivot, 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

Business Intelligence Developer/Analyst

• 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 modelsto 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.
• DevelopSSAS cubes, tabular models, MDX/DAX queries, Performance Point, Power View, Power Pivot reports and dashboards.
• Implementand manage Tableau data analytics environment. Create data extracts, connections, and dashboards. Provide administration and training. Develop and maintain Total Operating Performancedashboard 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

Business Intelligence Developer Contractor

• 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

Business Intelligence Developer Contractor

• 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 usingBusiness 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

Business Intelligence Developer Contractor

• 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

Business Intelligence Developer Contractor

• 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

Business Intelligence Developer

• 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.