Data Analyst Resume Costa Mesa, CA - Hire IT People

SUMMARY:

Results - oriented programmer / analyst with experience in data analysis, ETL development, and data modeling.
Proficient in relational and analytical database design with knowledge of predictive analytics.
Collaborates with peers in both business and technical areas to deliver optimal business process solutions in line with corporate priorities.
Strong background in creating support documentation.
Known for persistence in problem solving, ability to communicate effectively with technical and non-technical audiences, and consultative approach.

TECHNICAL SKILLS:

Language: C#, Java, Java script, XML, Visual Basic, R

Data Bases: Oracle 9i, Access, SQL Server 2012

Application: Word, Excel, Visio

Analytical Tool: Alteryx, Microsoft Azure

BI: Tableau, OBIEE, Micro Strategy

PROFESSIONAL EXPERIENCE:

Confidential, Costa Mesa, CA

Data Analyst

Responsibilities:

Collaborated to develop Sales Data Warehouse, leading to cleaner data and efficient reporting.
Analyzed Sales, Inventory, and Demand Planning Data and created dashboard and reports in Tableau, supporting sales and supply chain team.
Integrated internal data sources with external data sources like DNB data, providing relevant information for decision making.
Optimized SQL queries by creating indexes as required to improve reporting dashboards and other related applications.
Created and mapped documents for data transformation with business and transformation rules, facilitating change management and teaching team members how to use and interpret data.
Resolved issues by analyzing data quality issues and collaborating with other data analysts.

Confidential, Pasadena, CA

Data Analyst

Responsibilities:

Updated programs by writing complex stored procedures, solving performance issues, and fine-tuning queries and stored procedures.
Set up consistent operations by creating scheduled process and training group members.
Created SSIS packages, enabling data loading, data cleaning, and reporting.
Performed disaster recovery procedures by backing up and restoring databases.
Ensured accurate data by monitoring data quality issues and identifying and correcting problems.
Maintained technical documentation by writing technical documents in support of projects and creating database designs using Visio.

Confidential, Los Angeles, CA

Junior SQL DBA

Responsibilities:

Developed database structures, stored procedures, views, triggers and user-defined functions in SQL Server, effectively organizing database to provide information for internal users.
Transferred data and database objects between servers, facilitating web development in program rollouts.
Resolved issues by collaborating with application developers and release team.

Confidential, Encino, CA

Developer

Responsibilities:

Built structure of online automobile insurance comparison of provider quotes by translating analyst generated specification into table with associated logic and modifying and creating new VB6 class codes.
Drove quality control by keeping track of change requests and creating deployment documents.
Performed developer testing, collaborating with analysts and using automated tools to find and fix bugs.
Merged new codes to base line codes in visual source safe, facilitating change management.
Secured stable production system by compiling, releasing, and testing VB6 code modification into development environment before releasing to QA and production environments.