Alan-D Arico
BI Practitioner using R, SQL, SSRS, Excel VBA at Zurich Services, Risk Engineering
Retired from gainful employment; previous position: Consulting Data Analyst at Zurich Services, Risk Engineering
Data Analyst, Power BI, R, VBA, SQL developer with a passion for data intelligence to secure and accelerate business goals.  Daily use of Power BI Desktop, R Studio, SQL Server Management Studio and self-service Excel BI tool development.   Demonstrated collaborative abilities and team work skills with the ability to accomplish tasks under minimal direction and supervision; ETL and data quality monitoring automation initiatives. Interest in building on current data analytic skills.

Specialties: Power BI, ETL, R, VBA, Transact SQL; SQL Server Reporting Services; Databases: Microsoft SQL Server; Operating Systems: Windows; Software: SQL Server Management Studio, Excel, other MS Office Apps, PowerPivot, R, PowerShell 

Certifications:  
Microsoft Certified Technology Specialist | SQL Server 2005—Implementation and Maintenance
Zurich Services, Risk Engineering
https://www.linkedin.com/company/zurich-north-america
Performing phased data inquiry, validation, integration migration, and ETL of multiple business data sources including Dynamics CRM; complex reporting with SSRS 2012 and customized Dynamics CRM reporting based on complex SQL queries; performance monitoring using Tableau and R. Automation of star models for PowerPivot importing. This is a Data Analyst contract postion through DISYS.com / Axcess
Schaumburg, IL
https://media-exp1.licdn.com/dms/image/C4E0BAQGFevAP0io5Kw/company-logo_100_100/0/1646767818327?e=1655942400&v=beta&t=2QILMH0JozPFtuTYbVej6H987DovnFrVa4r6JytaV18
BI Practitioner using R, SQL, SSRS, Excel VBA
NAVTEQ
https://www.linkedin.com/company/navteq
• Import large amounts of XML traffic feed data using ETL SSIS, powershell, and stored procedures (shred & load) into a normalized SQL Server database schema for querying and data integrity analysis
• Designed full relational schema with T-SQL build and maintenance scripts; package to convert 4+ terabytes of XML data into two databases of 150 gigabytes each.  
• SSIS package to run at scheduled times for automatic input of new data.
XML Database & Query Developer
SetFocus
https://www.linkedin.com/company/setfocus
Education combined w/ professional experience; designed to provide 2-3 years experience in 1 quarter.
•  Created numerous complex queries involving self joins, correlated subqueries & XML techniques for diverse business rqmts. Tuned & optimized queries by altering db design, analyzing different query options, & indexing strategies.
•  With team, analyzed business rqmts & systematically designed a db for online-movie (DVD/Blu-Ray) rental company. Empl'd best practices to create complete schema of tables, relationships, stored procs, views, clustered & non-clustered indexes & triggers, & used XML and SSIS to import & export data. 
•  With team, created various reports according to business rqmts for movie rental company. Individually authored, installed, deployed & managed reports using SQL Server 2005 Reporting Services for a library DB. 
•  Designed bank application according to business rqmts, & implemented robust stored procedures, functions, & triggers to implement rqr'd functionalities. 
•  Developed backup & recovery plan based on data availability rqmts of the library & on potential impact of data loss on the business after considering & analyzing the different backup & recovery strategies.
•  Designed db maintenance plans for core maint. tasks to ensure the DB performs well, is regularly backed up if system fails & is checked for inconsistencies. 
•  Employed Database Engine Tuning Advisor to analyze the performance effects of workloads & implemented recommendations where appropriate. 
•  Used SQL Server Profiler tool to monitor performance of SQL Server – to analyze performance of the stored procedures.
•  Analyzed different high availability solutions & implemented database mirroring & replication.
•  With team, established security policy using windows domain accounts & implemented a security strategy to protect against threats and attacks.
•  Familiar w/ Service Brokers, enabling HTTP support & establish Notification Services.
https://media-exp1.licdn.com/dms/image/C4D0BAQHFymcYktfOSA/company-logo_100_100/0/1519856162141?e=1655942400&v=beta&t=KGiM6vDg0X2ei00Utx94_mIFMmIXpY5Sp_PDp0FdPUw
SQL Server Master's Program
Amana Property Services w/Charles Rutenburg of IL
• Data analysis of on-market property for selection that maximized potential cashflow—eight properties procured. 
• Managed 9 properties: maintenance and tenant issues; developed repeatable process for tenant selection, contract handling, property preparation, move-in/out reporting; monthly financial statements.
• Software: QuickBooks, MS Office applications, property price analysis, rental market and sales analysis.
RE Consulting
Lucent Technologies
https://www.linkedin.com/company/nokia
Software Quality Engineer: 
•  Identified process execution baseline through personal and group interviews and focus groups
•  Collected, analyzed, and reported In – Process metrics for 200+ developers
•  Identified process improvement areas, implemented corrective actions, and transitional trials to test
•  Supported external quality audits
•  Delivered standardized training to multiple organizations for quality and development teams.

Vendor Manager: 
•  Orchestrated product realization, development, system testing, and customer teams of approximately 50 inter-organizational persons.
•  Initiated and established relationships with internal and external suppliers
•  Organized and scheduled system integration and delivery plans with regular reports to management
•  Managed architecture, engineering, design, delivery, and related transitional issues, that accomplished pull-through sales in millions of dollars
•  Used Unix operating system interfaced with MS Windows NT and daily use of MS Office applications Excel, Word, Outlook; used Unix K-Shell, SCCS to develop supporting work tools for managing issues under change control.
https://media-exp1.licdn.com/dms/image/C4D0BAQG0nzntznSIQg/company-logo_100_100/0/1539073820398?e=1655942400&v=beta&t=QKVD82_uEEukyZ8JJtElrMytmxhV105vKw-KKUi3_SU
Member Technical Staff
AT&T
https://www.linkedin.com/company/att
Software Process Engineer:

•  Led teams in software process management initiatives using the PQMI methodologies and ISO-9001 standards, resulting in ISO-9001 registration and attained Level 3 process maturity defined by SEI maturity model.  This attainment established client awareness of the company's commitment to quality deliverables.  Communicated business directives for quality improvement initiatives to management teams and process users using MS PowerPoint, and on-line web-based documentation.
•  Collected software life-cycle fault data through a web-based application using a proprietary Object Oriented language called FIT, Unix, KSH, and MS Office applications.
•  Led teams in Quality of Work Life and Business Excellence initiatives.

System Test Developer: 

•  Part of a three person team that developed a one of a kind programmable synchrous test that greatly reduced intervals of systems and regression testing.  Developed in the C-language to program in an interpreted Basic language using the Unix tools of YACC and LEX.
•  Applied structured testing methodologies to streamline testing of synchronous and asychronous product lines for the IT industry.
•  Developed a C language path analyzer to assist testers to ensure their test plans and test cases were complete, using Unix tools YACC and LEX..
https://media-exp1.licdn.com/dms/image/C560BAQE6Wr9RUG3OuA/company-logo_100_100/0/1533066385525?e=1655942400&v=beta&t=l5j2bQTjt4nOW0PcpT6DoXTIU4snEIfhvwD4qeMfjIQ
Member Technical Staff
Masters
Computer Science with emphasis on Computer Languages
Computer Science / Information Technology
https://media-exp1.licdn.com/dms/image/C4E0BAQGefZGT9-Ru5g/company-logo_100_100/0/1524682710462?e=1655942400&v=beta&t=7K86glpB6xqklfVnx0lG4pqzz-1NQO5VB96q2ahh5HU
DePaul University
https://www.linkedin.com/school/depaul-university/
DAMA Chicago
Administrative tasks and support of Chicago board activities and programs that educate the data management community.
Secretary
LinkedIn
www.linkedin.com
HTML Essential Training
https://www.linkedin.com/learning/html-essential-training-4
LinkedIn
www.linkedin.com
Visual Studio Code for Python Developers
https://www.linkedin.com/learning/visual-studio-code-for-python-developers
https://www.linkedin.com/in/phillip-jay-lukowicz-298b0722
St Charles, MN
Phillip Jay Lukowicz
Supplier Quality Engineer
https://www.linkedin.com/in/benjamin-schulz-1a770a6
Palatine, IL
Benjamin Schulz
Program Manager
https://www.linkedin.com/in/amy-nelson-96319555
Greater Chicago Area
Amy Nelson
Talent acquisition consultant
https://www.linkedin.com/in/eileenschrot
Greater Minneapolis-St. Paul Area
Eileen Schrot
Marketing & Business Analytics Student at UMN Carlson School of Management
https://www.linkedin.com/in/barbara-lietzau-abb17647
Columbus, OH
Barbara Lietzau
RETIRED Cytotechnologist
https://de.linkedin.com/in/josh-j-huang
Munich
Josh Huang
Climate Risk | Sustainable Development | Risk & Decision Analysis
https://www.linkedin.com/in/mike-besso
Mount Prospect, IL
Mike Besso
Enterprise Data Specialist,
Assistant Vice President, Zurich Risk Engineering
https://cn.linkedin.com/in/yijia-kimberly-pan-7659465a
Shanghai, China
Yijia (Kimberly) Pan
Actuarial Consultant at Sunlight Consulting
https://www.linkedin.com/in/daniel-towle-55055748
Fullerton, CA
Daniel Towle
My own boss at Towle Ministry
https://www.linkedin.com/in/keithcowing
New York, NY
Keith Cowing
Product Leader. Entrepreneur. Coach
https://www.linkedin.com/in/bradley-fry-rt-r-mr-6014aa8a
De Kalb, IL
Bradley Fry RT (R)(MR)
MRI Supervisor at OSF St. Anthony’s Medical Center
https://uk.linkedin.com/in/agnes-poon-970344157
Cambridge
Agnes Poon
Birth and postnatal doula
https://www.linkedin.com/in/harrisoncarolyn
San Francisco Bay Area
Carolyn Harrison
Principal Clinical Systems Analyst at Stanford Hospital & Clinics at Stanford Health Care
https://www.linkedin.com/in/susie-justus-8b855176
San Diego, CA
Susie Justus
Inside Clinical Specialist
https://www.linkedin.com/in/kaushalalmola
Irving, TX
Kaushal A.
Senior Business Intelligence/ETL/Data Warehouse/SQL Server Database Professional
https://www.linkedin.com/in/danielthedba
Exton, PA
Daniel AG (MCDBA and Microsoft Certified Trainer )
Enterprise Database Manager at Confidential (In stealth mode)
https://www.linkedin.com/in/rajuchhana
Dunedin, FL
Raj Uchhana
Power BI Architect & Azure Solutions
https://www.linkedin.com/in/syedislam
Edison, NJ
Syed Islam
Business Intelligence Architect at GS1 US - (Azure SQL | Azure Data Factory | Azure Data Lake | SSIS | Power BI | Data Analytics | Data Warehousing | ETL | BI | Alteryx)
https://www.linkedin.com/in/mistydba
Tulsa Metropolitan Area
Misty Collins, M.S.
SQL Server DBA
Robert Witkowski
      
          



            
              
        
              
  

    
        To Whom It May Concern:

It is my pleasure to provide a recommendation for Alan Arico .  Graduating from the SetFocus Master’s Program, Alan Arico excelled in an intense, integrated, in-depth, full time, 3 month SQL SERVER 2005 Training Program.  
I was impressed by his ability to work with many technologies during his time with SetFocus.  He has gained experience with the latest Microsoft Technologies, including but not limited to:

•	Installed, authored, and managed reports using SQL Server 2005 Reporting Services.
•	Evaluated and employed best practices in creating a complete schema including tables, relationships, stored procedures, views, clustered and non-clustered indexes and triggers
•	Employed the Database Engine Tuning Advisor to analyze performance
•	Used the SQL Server Profiler tool to monitor the performance of SQL Server
•	Used C# to implement CLR stored procedures and functions in SQL Server 2005
•	Established security policy using windows domain accounts
•	Designed database maintenance plans to set up core maintenance tasks

 I found his work ethic was demonstrated by his ability to work in an environment with firm deadlines, very large workloads, and complex specifications.  He is able to work within teams on assigned projects.

I recommend Alan Arico as a solid addition to your staff.  If you would like more information, I’d be happy to provide it.  

Sincerely,

 

Robert Witkowski
Dean of Students
rwitkowski@setfocus.com
SQL Server Developers
https://media-exp1.licdn.com/dms/image/C4D07AQEXuCXD-lUk8A/group-logo_image-shrink_200x200/0/1631357511900?e=1647694800&v=beta&t=motOIVIqDLQazJYWniwhNRwY8SpvmVQIGYP-PeNCARw
https://www.linkedin.com/groups/86080
SetFocus MP Alumni and Hiring Companies
https://media-exp1.licdn.com/dms/image/C4D07AQFlLQiTqxR7pg/group-logo_image-shrink_200x200/0/1631357017777?e=1647694800&v=beta&t=GieOYkcGyCqcPvXRRevm8Ss36v3ZbZpZSfohgp5bOFg
https://www.linkedin.com/groups/3553
Data Analytics, Data Science, Business Analytics, Business Intelligence, Data Scientist & Analyst
https://media-exp1.licdn.com/dms/image/C4D07AQG4zXl2UK6YnA/group-logo_image-shrink_92x92/0/1634298211206?e=1647694800&v=beta&t=y9iOkC4G8V67ID6ppGSiJndKUwdGUqT2n4iSJy1KOO8
https://www.linkedin.com/groups/2064830
SQLSERVER User Group
https://media-exp1.licdn.com/dms/image/C4D07AQFrmcdUhtYvjQ/group-logo_image-shrink_200x200/0/1631361823615?e=1647694800&v=beta&t=PjXn-a9AcRQWFry6Qf94r30Qzq2n047OyafnsPw8JPU
https://www.linkedin.com/groups/129602
CareerLink Network
https://media-exp1.licdn.com/dms/image/C5107AQEcR1Olg16g8w/group-logo_image-shrink_200x200/0/1631435392389?e=1647694800&v=beta&t=tCH8SRQHecQVPIi8leBTGhutUkgnR7JJuy6SidEPdq4
https://www.linkedin.com/groups/599
Project: Get Hired!!
https://media-exp1.licdn.com/dms/image/C4D07AQGJJ4Nrr83Bog/group-logo_image-shrink_200x200/0/1631358871054?e=1647694800&v=beta&t=_FwIpBfhlZd9ViQXynNX6e3Ta8f7S4OU6JFyApnqowA
https://www.linkedin.com/groups/1816556
Machine Learning and Data Science
https://media-exp1.licdn.com/dms/image/C5607AQFB7YeCihMhmw/group-logo_image-shrink_92x92/0/1631002216279?e=1647694800&v=beta&t=gg9qeeqKScjfshjZuJPJwURn4jWqqtZOued0zcQ6GHY
https://www.linkedin.com/groups/4298680
Microsoft Certified Technology Specialist
https://media-exp1.licdn.com/dms/image/C5607AQFVQqIYHqAz-Q/group-logo_image-shrink_200x200/0/1631400034239?e=1647694800&v=beta&t=bAD9pISJrze0_MIMJxr6UucEYSVZ7fUyKg8D9HYctE0
https://www.linkedin.com/groups/48426
DISYS Chicago
https://media-exp1.licdn.com/dms/image/C4E07AQELD6ES8OTOGA/group-logo_image-shrink_200x200/0/1631375108957?e=1647694800&v=beta&t=OUBhdsLqTmcwopRWpZIZiHEFn_VbO6D1w0JVcWVsP2w
https://www.linkedin.com/groups/3959302
DePaul University Alumni Relations
https://media-exp1.licdn.com/dms/image/C5607AQHJTZZntkNy9g/group-logo_image-shrink_92x92/0/1631005699439?e=1647694800&v=beta&t=3O2D6jOsUN8cs6eoMLZvxqhhFzW02ovTlig5umOwLd4
https://www.linkedin.com/groups/52749
Chicago Technology Network
https://media-exp1.licdn.com/dms/image/C5107AQHbuPFIf5b2hg/group-logo_image-shrink_200x200/0/1631420874839?e=1647694800&v=beta&t=-gtW0YWNlK-QZgCpxwSjLwVCeclm8dmlTWMLOm2Asec
https://www.linkedin.com/groups/52751