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) | September 2019 – 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.
• 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.
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.