Summary

Overview

Work History

Education

Skills

Timeline

IDRIS SCREEN

LINCOLN,RI

Summary

Innovative Data Architect dedicated to advancing data acquisition and warehousing protocols to streamline business operations. Experience of 25 years spent enhancing existing layouts as well as designing complete enterprise-class system architectures from ground up. Key areas of expertise include Data Architecture, Data Engineering, Data Analytics, Machine Learning, and Data Modeling. Extremely attentive to details and maintains meticulous records of all projects. Work with and maintain relations with staff and clients on all levels.

Overview

years of professional experience

Work History

Principal Database Architect / Senior Database Architect

ACUSHNET COMPANY/TITLEIST FOOT JOY FAIRHAVEN

06.2009 - Current

Lead design and implementation of Snowflake Data Warehouse
Build Data Models using SQLDBM for Snowflake and SQL Server Data Warehouses
Provide mentoring to junior colleagues and stakeholders who are considered power users
Design and implement ETL solutions for weekly PGA equipment files and API feeds using AWS S3,AWS Glue, and Python
Lead machine Learning initiatives for research and development using AWS S3, SageMaker, and Python
Provide performance tuning and optimization of database views and processes
Build, Implement, and support BI Solutions in Tableau and Qlik
Model, design, and develop R&D Data Warehouse
Create an ETL process to migrate data from several Data Stores to an R&D Data Warehouse
Provide ongoing ad-hoc reporting, and resolve data integrity issues for R&D internal customers
Assist in the written functional specification process of an R&D Project Management application
Researched, purchased, and implemented BI Solutions for R&D
Develop and maintain R&D web and desktop applications written in Visual Basic and C#
Work closely with other IS groups to coordinate current and future activities, including coordination and technical assistance to facilitate specific development projects that involve the coordination of software upgrades and the installation of new products

Sr Business Intelligence SQL Developer

FIDELITY INVESTMENTS SMITHFIELD RI

05.2008 - 06.2009

Develop and schedule stored procedures and ETL processes in SSIS for daily data mart data capture
Develop ETL processes against ORACLE, Siebel, Sybase, Flat Files, Excel, MS Access, and Legacy data sources
Build Analysis Services cube structure based on data mart facts and dimensions
Develop Business Objects and Hyperion Brio automated reporting solutions for associates and senior management
Data Model Fidelity transaction, operations, and customer service legacy and third-party system data into star schema fact and dimension data mart used in Business Objects and Hyperion Brio reporting
Develop and support SQL Server data mart using MS Business Intelligence Development Studio 2005
Design and develop SQL Server 2005 SSIS packages, stored procedures, linked servers, triggers, tables, views, and functions
Responsible for SQL database tuning and optimization
Develop Business Objects and Hyperion Brio automated reporting solutions for associates and senior management
Write standard metric requirements and production object release management documentation
Write use cases and perform QA testing on data mart objects

Technical Lead (Business Analytics/SQL Developer)

FIRST MARBLEHEAD CORP BOSTON

11.2006 - 05.2008

Performed ETL tasks for daily data mart population
Performed data modeling and created naming conventions for originations and Collection of data mart objects
Developed and maintained Business Objects Universes used for production and ad-hoc reporting
Developed and maintained SQL Server Data Marts based on data pertaining to originations, web hits, operations, sales, servicer, marketing, and securities (Used as a data source for Business Objects)
Functioned as a liaison between Finance Business Analysis Team and IT to facilitate technical needs
Utilized TOAD and PL/SQL developer tools in ad-hoc origination data requests
Managed IT release management process for all Performance and Measurement Object Releases
Mentored junior analysts in areas pertaining to source code, product knowledge, and business rules
Coordinated with internal and external clients to write business requirements used to facilitate deliverables
Produced financial, sales, operations, and web analytics for Senior Management
Automate data extraction and manipulation processes, thus increasing time spent on analytics and quality control

Data Analyst

BLUE CROSS BLUE SHIELD

05.2005 - 11.2006

Performed accurate and complete data extraction from Blue Cross Blue Shield data warehouse and Data Marts, including medical, pharmacy, and laboratory data sets, to meet project requirements
Utilized technology to automate reporting for internal stakeholders in Prevention and Wellness using SAS, SQL Server, Oracle, Cognos, Microsoft Office tools, etc
Analyzed disease management and Prevention and Wellness program data regarding ROI, vendor reimbursements, sales, forecasting, program enhancements, vendor data reconciliations, vendor performance, etc
Maintained vendor relationships and managed data exchange processes between Blue Cross Blue Shield and contracted vendors
Designed, developed, and maintained financial, medical, and operational canned and ad-hoc reports for Senior Management
Held responsibility for the implementation of Disease Management and Prevention and Wellness program data elements into the Blue Cross Blue Shield data warehouse and performed QC on data sets to ensure the accuracy of results

Sr Operations Business Analyst

MEDIBANK INC BENEFITS, METEVANTE

08.2004 - 05.2005

Managed MBI operations analytical projects in relation to FSA Accounts, transaction adjudication, TPS claims, substantiation, EDI transactions, MBI card stock inventory, plan year forecasting, etc
Developed complex ETL processes to extract data from flat files, Excel Files, SQL Server tables, and MS Access databases into common data mart format for reporting
Held responsibility for the design, development, and maintenance of SQL Server data mart to support operations analytics based on applications written in C# .NET Framework
Managed process for the development, delivery, and maintenance of ad-hoc and automated reports
Developed process for gathering functional and/ or technical specifications for new or modified business systems: system requirements, operational procedures, test plans, input and output requirements, data scope, usage, formatting, security requirements, instructions, etc
Consulted and coordinated with systems analysts, quality assurance, and programmers to design and develop automated business systems
This includes both high-level and granular system designs