Data Analyst Resume San Rafael, CA - Hire IT People

SUMMARY:

Data analyst and programmer with 5 years’ experience in analysis, design, development and testing in SAS, SQL, EXCEL, SPSS,MARCO.
Abundant background in performing business analysis like Customer behavior, Marketing Campaign, Risk Management, Project Planning, Unsecured Loan and E - business.
Sufficient skills in Data Processing, Data Management, Data Quality, Data Modeling and Data Analyze.
Rich experience in SAS Marketing Research and Business Analytics through data mining, optimization, and decision tree etc.
Extensive knowledge and experience in MS Excel for data extraction and manipulation to evaluate programs, analyzing trends and history in order to provide the team with business insights and findings. Support the team with ad hoc analyses and other operational
Highly motivated, organized with excellent analytical and communication skills in establishing effective task priorities as a team player with result oriented attitude.

TECHNICAL SKILLS:

Software: SAS, SQL, R, Excel, VBA,SPSS, Tableau, Access

Skills: Data Analyst, Project Management, Business Analyst, Bank Lobby Manager, Statistical Analyst/Programmer

WORK EXPERIENCE:

Data Analyst

Confidential, San Rafael, CA

Responsibilities:

Analyze large volumes of data and perform analysis requested.
Analysis includes data quality, company structures, metrics reporting and data enrichment
Run SQL queries and output result set to Excel for various analyses
Coordinate with Sales Operations and Finance in planning, executing and delivering account hierarchies that meet the team*s yearly goals of completeness and accuracy
Analyze large volumes of customer records and perform analysis requested. Analysis includes data quality, company structures and business, metrics reporting and data enrichment. Make decisions based on data review and/or web research and company policies
Assist the report/visualization developers and statistical modelers in filtering, tagging, joining, parsing, and normalizing data sets for use in reports & analytical models
Support customer hierarchy data management team with review, validation, and build activities to support global Sales organization.

SAS Analyst

Confidential, Princeton, NJ

Responsibilities:

With PROC SQL, extracted, arranged and labeled account samples from data warehouse, eliminated duplicates in raw data using distinct option, applied required format onto certain variables.
With given requirement, established segmentation for the behavior of customer with PROC FORMAT based on their credit score.
Applied this segmentation on all selected data sets.
Analyze business requirements and profile data sources to develop conceptual data model, data flow diagrams and ETL process models.
Do a significant test for every sample to show the result is useful or not with SAS/GLM
Involve in discussions with business users and data architects to define metadata for tables to perform ETL process.
Derive trends from data and provide actionable recommendations to further define or revise decision making and strategies.
Involve in developing, testing, and writing programs and reports in SAS according to specifications as required.

Data Analyst

Confidential

Responsibilities:

Maintain or modify existing Geographic Information Systems (GIS) databases.
Review existing or incoming data for currency, accuracy, usefulness, quality, or completeness of documentation
Design forms for receiving, processing, or tracking data
Supervise the work of data management project staff.
Write work instruction manuals, data capture guidelines, or standard operating procedures. .
Analyze data across multiple segments and provide strategic recommendations based on the project objectives including trends, alumni/member engagement, campaign performance, marketing mix informed by the data
Responsible for the proper documentation and validation of programs/macros/procedures to produce the standardized data displays.

Business Analyst

Confidential

Responsibilities:

Operate telephone switchboard to answer, screen, or forward calls, providing information, taking messages, or scheduling appointments.
Transmit information or documents to customers, using computer, mail, or facsimile machine.
Provide information about establishment, such as location of departments or offices, employees within the organization, or services provided.
Collect, sort, distribute, or prepare mail, messages, or courier deliveries.
Analyze data to determine answers to questions from customers or members of the public.
Acquired the information for completion of market analysis and data mining projects, and in which the databases were accessed and modified accordingly.
Creating documentation including run books/system specifications/process flow and test plan.
Wrote Koran-Shell Scripts performing various automation steps like running a SAS code, emailing the output files, removing and copying files, archiving files for historical data and zippiup files to send to external locations as attachments in emails.