Data Analyst Resume Los Angeles, CA - Hire IT People

SUMMARY:

Data analyst with ten years of experience, skilled in all aspects of data analysis including storage and presentation.
Seeking to leverage extensive background in data gathering, auditing, storage and reporting in a data - driven environment.
Extremely motivated and eager to contribute to a company's success by delivering impactful reports and ad hoc queries to business partners.
Current career goals are to move into a management position and use my knowledge of data analysis to the Business Intelligence field.

TECHNICAL SKILLS:

Business Intelligence and Data Analysis: Tableau, Excel, Xcelsius and Business Objects

Database and Data Warehouse: Data Modeling, Toad, Alteryx, Teradata, SQL Server, pgAdmin and Oracle

Business Analysis: SDLC, UML Diagramming, ARIS and Data Modeling

Programming: Visual Studio 2008 (VB.net), ASP.NET, VBA

Correlation and Data Mining: SPSS, STATA and SAS

PROFESSIONAL EXPERIENCE:

Confidential, Los Angeles, CA

Data Analyst

Responsibilities:

Developed User Acceptance Test SQL scripts for data warehouse project (Global ZEUS)
Tested ZEUS using HP Application Lifecycle Management - Quality Center (HPQC).
Root caused and documented UAT defects.
Automated Data Quality Monitoring reports.
Developed data mappings for Global ZEUS using Analytix
Tested ZEUS using HP Application Lifecycle Management - Quality Center (HPQC).
Root caused and documented UAT defects.
Automated Data Quality Monitoring reports.

Confidential, Burbank, CA

Business Analyst

Responsibilities:

Confidential, Long Beach, CA

Business and Data Analyst

Responsibilities:

Executed and improved reports.
Planned, designed and executed ad hoc SQL queries using SQL Server in order to root cause data or process problems and provide solutions.
Root caused data and programming problems with the automated engine that processes premiums (Premium Reconciliation Application)

Confidential, Los Angeles, CA

Business and Data Analyst

Responsibilities:

Created process documents for 4 projects.
Planned, designed and executed ad hoc SQL queries using SQL Server in order to understand business problems and develop solutions.
Modeled processes in Visio and ARIS to facilitate process reengineering.
Administered project and program management SharePoint website for 6 initiatives.
Consulted with reporting teams on how to reengineer SQL based data warehouse changes.

Confidential, Los Angeles, CA

Data Processor and Analyst

Responsibilities:

Improved, automated and documented processes using Visio, VBA, Excel and Oracle.
Managed inter-departmental work flow to ensure timely product delivery using Visio and Excel to improve processes.
Planned, designed and executed ad hoc SQL queries using Oracle, VBA and Excel.
Automated all processes related to processing data and creating reports using VBA. The final system automated the creation of clients, studies, training, creation of users and the loading of videos onto the website. Reduced processing time by half.

Confidential, El Segundo, CA

Business and Forecast Analyst

Responsibilities:

Improved and automated holiday forecasting strategy, process and tools using Visio, Excel, VBA and Teradata .
Planned and executed ad hoc SQL queries using Teradata to deliver reports to executives .
Managed Teradata tables using Teradata Multiload and Fastload.
Developed, managed and delivered daily reports to improve business operations using Excel, VBA and ODBC.
Updated system settings for all 6,000 products in 180 stores on a quarterly basis.
Used queries to uncovered and fix data integrity and process problems.

Confidential, Stratford, CT

Data Analyst

Responsibilities:

Produced ad hoc supply chain and revenue reports using Access and Excel.
Developed, managed and delivered daily aftermarket reports for management.
Created a dashboard prototype using Xcelsius for aftermarket. The dashboard was a part of Sikorsky's ACE program (equivalent to Six Sigma).