Data Analyst (Staff Developer) Resume San Francisco - Hire IT People

SUMMARY:

5 years of mobile app analytics experience.
3 years of experience with Hadoop systems.
1 year of experience with Spark streaming /Spark SQL.
Fluency in SQL.
Python project development experience.
Moderate experience with R.
Proven track record of leveraging analytics and large amount of data to drive significant business impact.
Solid understanding of statistical principals and experimentation design.
Self - driven and passionate about data science.

TECHNICAL SKILLS

Oracle DB, Confidential DW.
Hadoop, Hive, Pig, Spark, Spark Streaming, Spark SQL
OBIEE, SAS Enterprise Guide, Confidential, Tableau, Excel/ Excel pivot
SQL,SAS, Python, R, Scala
SAS Business Intelligence Platform Administration, SAS EG,SAS base, SAS Macro, SAS ODS
Mobile App Analytics
Statistical Analysis

PROFESSIONAL EXPERIENCE

Data Analyst (Staff Developer)

Confidential, San Francisco

Responsibilities:

Performed big data analyses to provide insight for product (or feature) design or improvement using tools such as SQL/ SAS/ Excel etc.
Contributed to the company's efforts of building modernized analytical data infrastructure in scrum agile development using tools such as spark streaming/ bash shell/ python / Scala / SparkSQL/

Confidential

SQL

Responsibilities:

Performed security analysis from defining the problem scope, collecting data from different sources, processing data, generating segmented targeting and monitoring campaign progress.
Awarded for outstanding performance.
Provided statistical analysis of the impact of new feature introduction on user engagement, including experimentation design.
Provided automated extensive customer segmentation reports to monitor adoption of the new feature.
Built real-time data pipelines using kafka / spark streaming/ Cassandra.
Created type 2 SCDs ETL in cloud Confidential data warehouse.
Verified new deployments in Confidential and pinpointed causes of data quality issues.
Built python- Flask user authentication web application and responsible for integrating Flask applications of team works.
Built LookML dashboards using Confidential .

Data Analyst (Senior Developer)

Confidential, San Francisco

Responsibilities:

Performed ad-hoc data analyses and data extraction requests using SQL/ SAS / Excel.
Built processes and metrics dashboards to make data more accessible using SQL/ SAS /Excel/
Extracted insights from mobile app behavior data and third-party customer data by statistical analysis, segmentation analysis, cohort analysis to drive engagement, improve user experience and increase revenues.
Developed user analytic data marts to facilitate ad-hoc big data analysis, reducing reporting turnaround time from days to hours and greatly improving business users’ productivity.
Built rich, high-visibility, automated reports / dashboards used by a diverse set of teams across the company.
Refactored code for legacy SAS/ Excel dashboards for external formulary clients, reducing reports’ running time from a week to 2 days and improving accuracy.
Built custom third-party data sharing products for the sales team, increasing sales by 5%.
Developed python MapReduce ETL jobs to ingest common logging event JSON data into HDFS/ Hive using Hadoop streaming.
Earned Confidential ’s annual ‘Extra Mile Award’.

Data Analyst

Confidential, San Francisco

Responsibilities:

Extracted actionable insights from mobile app behavior data and third-party physician datasets by statistical analyses, segmentation analyses, cohort analyses to drive engagement, to improve user experience and to increase revenues.
Performed homescreen click density analysis, leading to the development of 40 million homescreen messaging commercial product.
Improved user account linkage by linking users with associated device, enhancing accuracy of customer analysis.
Provided data extraction for effective and efficient campaign targeting.
Developed monthly NPS (net promotor score) survey stratified sampling algorithm.
Tuned SAS ETL, leading to implementation of daily refresh instead of previous weekly refresh of data marts.
Upgraded SAS Business Intelligence Platform from 9.2 to 9.4.

Postdoctoral Researcher

Confidential