Ray Cochrane Email & Phone Number

02019

• Several years of IT experience in the use and development, design, support and migration of Microsoft SQL Server 2017/2014/2012/2008R2/2008/2005 databases • Expert in Microsoft Business Intelligence technologies like SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), and SQL Server Analysis Services (SSAS)• Logical and Physical Database design, development, Normalization and Data modeling• T-SQL for developing complex stored procedures, triggers, tables, user functions, user profiles, relational database models and data integrity, SQL joins and query writing • Design and develop using Business Intelligence Development Studio (BIDS) and Visual Studio Data Tools • Extract and transform and load (ETL) data using SSIS. Import/Export Data from various sources, via Bulk Insert, BCP and SSIS Packages • SQL Server Reporting services (SSRS) - design, development and deployment of different kinds of reports: simple, parameterized, drill-down, ad hoc, linked, snapshot, Cross-tab, sub reports using local and Global variables, Expressions and Filters• Design SSIS Packages from multiple data sources like MS SQL Server, Oracle Database, Excel, XML & Flat files to SQL Server• Query optimization & performance tuning, Using SQL Server Profiler, Execution Plan, Performance Monitor, DBCC and Data Management Views • Build Cubes, Facts and Dimensions for Business Intelligence • XMLA, MDX and DAX Languages used for Operations & Cube Queries/Calculations • Experience in OLTP/OLAP, data warehouse, Star and Snowflake schemas used in dimensional and multidimensional modeling• Use various SSIS transformations like Derived column, Lookups, Conditional split to cleanse the data and used stored procedures for effective data transfer. • Use Data Quality Services within SSIS 2012 for data Cleansing and data profiling • Use Power view, Powerpivot, Excel Services, Proclarity and Tabular and Multidimensional datasets for Sharepoint BI Portal presentation

Smithfield, Rhode Island, United States

Data Warehousing Microsoft Stack

Hopkinton, Ma

BI Architecture• Several years of IT experience in the use and development, design, support and migration of Microsoft SQL Server 2014/2012/2008R2/2008/2005 databases • Expert in Microsoft Business Intelligence technologies like SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), and SQL Server Analysis Services (SSAS)• Logical and Physical Database design, development, Normalization and Data modeling• T-SQL for developing complex stored procedures, triggers, tables, user functions, user profiles, relational database models and data integrity, SQL joins and query writing • Design and develop using Business Intelligence Development Studio (BIDS) and Visual Studio Data Tools • Extract and transform and load (ETL) data using SSIS. Import/Export Data from various sources, via Bulk Insert, BCP and SSIS Packages • SQL Server Reporting services (SSRS) - design, development and deployment of different kinds of reports: simple, parameterized, drill-down, ad hoc, linked, snapshot, Cross-tab, sub reports using local and Global variables, Expressions and Filters• Design SSIS Packages from multiple data sources like MS SQL Server, Oracle Database, Excel, XML & Flat files to SQL Server• Query optimization & performance tuning, Using SQL Server Profiler, Execution Plan, Performance Monitor, DBCC and Data Management Views • Build Cubes, Facts and Dimensions for Business Intelligence • XMLA, MDX and DAX Languages used for Operations & Cube Queries/Calculations • Experience in OLTP/OLAP, data warehouse, Star and Snowflake schemas used in dimensional and multidimensional modeling• Use various SSIS transformations like Derived column, Lookups, Conditional split to cleanse the data and used stored procedures for effective data transfer. • Use Data Quality Services within SSIS 2012 for data Cleansing and data profiling • Use Tableau, Powerpivot, Excel Services, Proclarity and Tabular and Multidimensional datasets for BI Portal

Pawtucket, Ri

Business Intelligence Developer• Architect & maintain a Sales, Surveys and Finance data warehouse using SQL Server 2008/R2, 2012, SSIS, SSRS, ETL, TSQL, DAX, MDX for multiple subject areas using Kimball Methodology.• Used various SSIS tasks such as Conditional Split, Derived Column etc., which did Data Scrubbing, including data validation checks during Staging, before loading the data into the Data warehouse.• Extracted and reviewed data from heterogeneous sources like (Excel, CSV, SQL, flat file, Text Format Data) using SQL Server Integration Services (SSIS) from OLTP to OLAP• Create the structure of OLAP Data sources in ETL and designed Cubes in MS Analysis Services (Multidimensional and Tabular) • Implemented MS Analysis Services setup, tuning, cube partitioning, dimension design including hierarchical and slowly changing dimensions.• Created calculated measures and dimension members using multi-dimensional expressions (MDX), mathematical formulas, and user-defined functions.• Migrated All components of Warehouse from SQL Server 2008/R2 to SQL Server 2012 • Support SQL,OLAP, SSRS & SSIS application servers and process workflows through DEV, SIT, UAT and production environments• Design Schemas, Change Data Capture, TSQL, SSIS Packages, Jobs, and Stored Procedures, Views and Functions to support Warehouse Reporting Environment• Assist in the physical maintenance and performance tuning of warehouse

Designed and implemented numerous databases, tables and requisite relationships and stored procedures to support security issue tracking and management reporting.• Developed SQL Server Integration Services ETL packages to extract, cleanse, validate and consolidate data from mainframe, oracle, flat file and other external database back ends. • Designed and developed numerous T-SQL scripts, stored procedures and user defined functions to gather and prepare data sets for the many authored reports. Parameterized reports use T-SQL queries to populate parameter lists. • Developed numerous daily, weekly and monthly summary and detail reports to support management reporting requirements and to improve timely and accurate reporting utilizing SQL Server Reporting Services and a centralized Report Server. Created scorecard reports using report parts and sub reports. • Reporting requirements include parameterized, cascading parameter, drill down and drill through reports. Many reports were set up to use subscriptions for automated execution and delivery. • Maintained SQL Server databases and DB permissions; maintained all Report Server objects and permissions.

Canton, Ma

Develop, design & support a SQL Server & Reporting Services environment for financial and manufacturing reporting.

Mass Department Of Transportation

Project planning and scheduling; Gather feedback from business users and understand requirements.Database modeling and design. Design and maintain OLAP cube models and Business Intelligence presentation tools.Author complex TSQL stored procedures, triggers, functions, views and SQL Jobs.Develop, maintain and deploy DTS and SSIS packages.Assist DBA staff with the debugging and optimization of SQL queries and stored procedures.Adhoc reporting• Dashboards and Scorecards• Bidirectional integration with Excel Pivot Tables• Integration with SharePoint• Ability to drill down by customer• Backend financial analysis for use in modelsBI Toolset• SQL-Server 2000/2005/2008/2008 R2• SSIS (SQL-Server Integration Services) - ETL development• SSRS (SQL-Server Reporting Services) - Standard, Multi-Tab, Drill-Up/Down reporting• SSAS (SQL-Server Analytical Services) - Dashboards, Data Visualization, Cubes• SSMS (SQL-Server Management Studio)• BIDS (Business Intelligence Development System)• Proclarity/Performance Point

• Develop & support a SQL Server SSIS, SSAS & SSRS environment for ODS & MDR merchandising system• Assist in supporting a database & OLAP solution to handle multi-tier, multi-server, multi-division BI application of over 50 Terabytes of merchandising sales and inventory data • Develop ETL processes using SSIS for 5 divisions enterprise file extracts and DB2 data connections• Assist in the design of OLAP databases, SQL Queries, SSIS & DTS Packages, Jobs, and Stored Procedures• Responsible for SQL 2005, Cognos BI 8 Installation, reporting, configuration, maintenance & administration• Examine business requirements to construct complex Cognos & SSAS data models & procedures• Assist production DBAs handling database deployment, maintenance, indexing strategy, daily processing jobs, performance tuning, as well as report and SQL query optimization• Assist in the design and performance tuning of reports and OLAP cubes

Team member in worldwide corporate financial data warehouse. Microsoft stack.

Greater Boston Area