Driven by Results: The Professional Behind IT SVC LLC.

Meet James Skarda, Owner


A results-oriented professional with extensive experience in data warehousing, business analysis, and programming. With a strong background in SQL Server and Snowflake development, I am passionate about delivering innovative and efficient data solutions. My career is marked by a commitment to excellence and a track record of successfully guiding clients through complex data challenges.

Professional Expertise

My career journey has provided me with a deep understanding of data systems and development:

• IT SVC LLC (Owner) | January 2024 – Present: As the owner, I leverage over 5 years of focused experience in designing and developing scalable Snowflake data solutions, coupled with a strong background in ETL pipelines, data warehousing, and data modeling. My work includes developing validation frameworks, implementing data retention policies, and leading successful migrations to cloud-based platforms.

• Healthpeak Irvine, CA (Contractor) | September 2019 - December 2023: Key participant in developing analytical data warehouses and visualizations, streamlining data integration, and implementing scalable applications for information management.

• Bausch Health - Irvine, CA (Employee) | September 2010 – August 2019: Responsible for the creation and maintenance of company SQL Server databases, administration of Access databases, and generating complex SQL statements and queries.

• Ameriquest - Orange, CA (Employee) | June 2004 – August 2010: Led a large and complex Data Warehouse Project, resolving technical issues across multi-platform environments and providing extensive documentation and training.

• Accumenics - Long Beach, CA (Employee) | August 2003 – May 2004: Restructured table designs, provided on-site training, and assisted with complex financial reporting requirements.

• Deloitte & Touché, LLP - Costa Mesa, CA (Employee) | June 1999 – July 2003: Created and maintained SQL Server Data Warehouses for financial reporting and inventory tracking, and was a key team member in full life cycle implementations.

• Ernst & Young, LLP - Costa Mesa, CA (Employee) | August 1997 – May 1999: Developed a large SQL Server Database for source code housing and a comprehensive Microsoft Access application for a wide user community.

Snowflake Expertise

With over 5 years of dedicated experience in Snowflake, I bring a deep understanding of its powerful architecture and capabilities to your projects.

For more information on the benefits of Snowflake, you can visit the official Snowflake website.

Technical Skills


Hardware: IBM AS/400, Personal Computers

Software: Microsoft Office & Visual Basic/Microsoft SQL Server, SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), SharePoint

Languages: Microsoft SQL Script (Batch & Interactive), T-SQL, DTS, Stored Procedures, Triggers, SQL, Java, Python

ERP: Business Objects, Crystal Reports, Cognos

Utilities: ERWIN/Data Modeling, Quick Test Pro

Education

BS Bachelor of Science in Business Administration: Pepperdine University | Malibu, CA

Associate Degree in Computer Science: Northwest Technical College (NWTC) | Green Bay, WI

Affiliations

Member of OCEAN (Orange County Educational Advancement Network, Inc.) Technical Users Group, Since 1990

Your Next Data Solution Starts Here.