Data Analyst Business

SKILLS

Programming Skills: SQL, Python, SSIS, SSRS, SSAS, Power BI, Java, C#, PowerShell, Oracle, Access, Excel, Word

Software Tools: T-SQL, PL/SQL, Visual Studio, PostgreSQL, MS Access, Azure, Visual Basic, VBA, C#, Crystal Reports, Jira, Oracle, .NET, ASP

Theoretical Knowledge: ETL, SSIS, EDI, SCCM, Azure, AWS, Snowflake, Databricks

Education: University of Phoenix Major MBA GPA: 3.89 Graduation Date: 2009

University of Phoenix Major BS in IT GPA: 3.99 Graduation Date: 2007

EXPERIENCE

THENTIA Oklahoma City, OK

Data Migration Specialist July 2024 – October 2024

Integrated and customized customer data into the platform, adhering client specifications.

Configured new platform components and tracked progress using Jira.

MAERSK Downy, CA

SQL Server Developer August 2022 – February 2024

Boosted SQL server efficiency by 30% through meticulous code reviews and implementation of targeted solutions to eliminate delays and errors.

Streamlined development processes and reduced error rates by 40% by creating innovative SSIS packages for on-premises and Azure SQL Servers.

Enabled smooth cloud transitions by assessing, testing, and migrating SSIS packages to Azure, tailored to diverse customer requirements.

PERATON San Diego, CA

BI Developer/ SQL Server Developer May 2015 – August 2022

Led teams in executing data migration strategies, developing Power BI models, and implementing ETL processes, including rewriting existing DTS packages into new SSIS for seamless transitions.

Achieved a 50% increase in revenue and a significant reduction in support costs by upgrading SQL Server (2000 to 2019) and integrating it with Azure and AWS through T-SQL.

Optimized a $15M–$20M monthly invoicing process by designing a data warehouse and reporting solutions, delivering enhanced operational insights.

Enhanced reporting accuracy and efficiency by migrating data from Access to SQL Server, incorporating ServiceNow workflows, and converting Crystal Reports to SSRS.

Built a comprehensive data warehouse to store invoice information, enabling archival reporting through SSRS and Power BI.

GUZMAN CONSTRUCTION Lake Arrowhead, CA

Business Operations Manager / Bookkeeper January 2020 – December 2022

Managed financial operations for the construction company.

Handled bookkeeping with QuickBooks Online, including estimates, invoices, and financial reports.

Set up and managed timekeeping via TSheets integrated with QuickBooks, ensuring scheduling and coordination for employees and contractors.

Integrated payroll and online payments through QuickBooks and Intuit Payment Center.

Delivered month-end reports, including 1099s and tax documentation.

ACADEMY OF MOTION PICTGURE OF ARTS AND SCIENCES. Los Angeles, CA

BI Developer November 2013 – December 2014

Converted raw CRM data into executive-level reports aligned with strategic goals and integrated with SharePoint, enhancing strategic insights.

Optimized database performance with SSRS, reducing report generation time and boosting accuracy while mentoring developers to improve website features and engagement.

PROVIDENCE HEALTH SERVICES Burbank, CA

Senior Report Analyst / SQL Developer October 2012 – November 2013

Conducted data analysis across multiple databases, generating actionable reports and ensuring HIPAA compliance using SSIS and SSRS.

Optimized financial report processes by migrating data to SQL Server, reducing monthly fees by $8K and accelerating report generation by 90%, while mentoring developers in SQL and SSRS best practices.

MONARCH HEALTHCARE Irvine, CA

Senior Report Analyst / SQL Developer June 2011 – October 2012

Designed and developed BI reports with SSRS, seamlessly integrating data from diverse systems to support finance, claims, and operational functions. Leveraged JavaScript to enhance navigation and add advanced functionality, utilizing a centralized data warehouse as the source.

Integrated KPIs and data warehouse models into BI reports, enabling effective monitoring and highlighting of critical business activities.

VALENTINE GROUP LA Los Angeles, CA

Bookkeeper January 2011 – October 2012

Managed financial operations for the Public Relations organization using QuickBooks.

Set up QuickBooks accounts linked to the organization's banks.

Created and sent invoices to clients, primarily via email.

Monitored and managed timely client payments through QuickBooks Online.

Used QuickBooks to track and report time for clients and employees, training staff to log project hours accurately for payroll.

Developed reports to track project timelines and year-end financial performance.

Prepared statement reports detailing payments, completed work, and additional requested information for clients.

Automated expense allocation in QuickBooks for client reimbursements.

Set up contractors in QuickBooks for 1099 reporting, distributing year-end statements via email or hard copy as preferred.

PROJECTS

Catalog Billing 2017-2018

(Developed at PERATON)

Spearheaded the development of the catalog billing process integrated into monthly invoicing. This initiative encompassed procurement, end-user requests, software usage, and updates from the procurement system. The process was successfully redesigned to reduce manual labor from two weeks to just 30 minutes.

End-User Assets 2017-2019

(Developed at PERATON)

End-User Assets are managed by another team, with data captured in ServiceNow. A process was established to extract this information into a Data Warehouse, simplifying data processing. The Data Warehouse enables the generation of reports and activity tracking for each asset through an ETL process. This workflow supports the monthly creation of billing expenses, forming the third interaction in end-user asset management.

Employee Database Application 2005-2007

(Developed at Time Warner Cable)

Directed the development of an internal and external web application designed to manage supplementary information for both regular and temporary employees, supporting performance-related reporting. This application centralized data storage, enabling the organization to efficiently maintain and access this information. The application integrated seamlessly with multiple departments, including Human Resources and Security, to streamline onboarding processes.

Contact this candidate