OBJECTIVE:

• Seeking a challenging role as Reporting Data Analyst

SUMMARY:

• Sound experience with analyzing user data, creating reports using Quick Base, Business Objects (BO), Excel, SQL, Google Analytics, and Flurry Analytics.
• Experience providing data - driven insights for mobile application to Sales, Marketing, and Business Development and generating critical installs and daily performance reports for customers and executive management.
• Sound knowledge of major online pricing models.
• Very strong data analysis skill using Excel and deep knowledge of statistics.
• Experience working with senior management and excellent problem solving, team, and analytical skills.

TECHNICAL SKILLS:

Database: MySQL 5, Access

Database Tools: MySQL Workbench, Toad 6.3 for MySQL, dbForge Studio for MySQL, Business Objects

Analytics Tools and Softwares: Google Analytics, Quick Base, Business Objects, Site Catalyst, Flurry Analytics

Other Apps: Salesforce Chatter, BaseCRM

Microsoft Office: Microsoft Word, Excel, Outlook, and PowerPoint.

OS: Windows (NT, 2000)

Languages: SQL, HTML

WORK EXPERIENCE:

Confidential, Menlo Park, CA

Data Analyst

Responsibilities:

• Improved and maintained weekly, monthly, quarterly dashboard related to number of trials, visitors, gross new subscriptions, churn etc. with end-to-end analytics. In addition, prepared corresponding reports using Business Objects, Google Analytics, QuickBase, and Excel for presentation to the executive management, marketing teams, and external partners.
• Evaluated key KPIs related to conversion, acquisition volume, cost, revenue and attrition.
• Assisted the forecasting and planning process with historical traffic, conversion, unit and revenue trends.
• Maintained an archive of all campaigns, web, and accountant performance reporting.
• Managed ad hoc data analysis requests to drive business performance.
• Created integration between MS-Excel and Business Objects (BO) using Office Live.

Confidential, San Francisco, CA

Sr. Data Analyst

Responsibilities:

• Excel reporting consisting macros and VB Scripting.
• Reporting and data driven Insights using MySQL queries and procedures.
• Provided data-driven insights on target users, target markets, and key campaigns for mobile applications to management, sales, and marketing teams. This had significant impact on company’s bottom line.
• Created alerts and segments based on geography and users’ p using tools like Google Analytics and Flurry Analytics.
• Worked autonomously to analyze, review, translate, and ensure accuracy of user data.
• Met with customers to determine their needs, gathered and documented requirements, managed customer expectations, and resolved issues.
• Responded to all customer inquiries relating to daily reports, campaigns, invoices in a timely manner. Sent daily customer reports covering total number of clicks, total cost, total installs, device ids, time, geo-locations etc. This improved customers’ stickiness and resulted in BAM getting more deals from same customer.
• Participated in sales meetings with customers and internal sales team to review ongoing and new campaigns.
• Performed occasional QA testing of mobile application and provided test results to Engineering team.
• Created reports using Excel and MySQL. Created reports in Excel that utilized Macros, Excel Query, PivotTables, and ODBC.
• Worked with CEO and provided reports using MySQL:
• Monthly report displaying number of installs, CPI(Cost per install), total revenue from each active campaign for the month
• Daily report displaying daily revenue, daily installs by application, daily revenue by campaign, daily top performing apps
• Worked with Sales team and Editors and provided:
• Reports displaying games having rating of 4.5 and with maximum number of installs from our system
• Reports listing games having rating of 4 but not reviewed and rated internally
• In addition, created other key performance reports such as:
• Daily new users/channel, Number of playlists/user, most items added to playlist, Daily active users, unique users and their install and stickiness behavior, Daily install trend, Popular keywords

Confidential, Belmont, CA

Engineering Analyst (Intern)

Responsibilities:

• Clarified project requirements, business needs via meetings with business users and key stakeholders.
• Inputted sensitive data into databases, generated reports, and analyzed critical data via Excel program.
• Worked with location based software and updated GIS maps with various location based data for easy lookup.
• Researched and analyzed data on city permits that were obtained certain yearly ranges. The information was logged in a various databases for follow-ups and reports.
• Prepared project report and detailed transfer of knowledge documentation.

Confidential, Oakland, CA

Data Analyst (Intern)

Responsibilities:

• Worked autonomously on data analysis to analyze, review, update, edit, clean, translate, and ensured accuracy of various agencies’ data.
• Worked extensively on excel and wrote formulas in excel, created queries and scenarios to extract particular rating data, created links between sheets so that data can be easily changed in other sheets while making changes in master sheet, and worked extensively on creating Pivot tables.
• Prepared regional pavement condition reports and displayed key KPIs on dashboard for various cities and counties in and around bay area. As part of this responsibility ran software models to determine various indexes that provided current pavement conditions.
• Responded to all agencies’ inquiries regarding federal grant after running the queries and generating reports.
• Ran functionality tests for each StreetSaver software module in main screen and utilities.
• Updated user database including contact information, pavement inspection data, and jurisdiction financial statistics.
• Assisted in preparation of the funding allocation analysis based on key KPI, i.e., Preventive Maintenance data.
• Supported communication with internal and external clients.
• Ran different scenarios of the Jurisdictions’ road conditions in Excel to predict lives of the roads.
• Frequently performed QA activities on newly released software and communicated change requests/bugs.
• Assisted in marketing and campaign related activities for yearly user week event.
• Updated project stakeholders with timelines, milestones, and issues.

Confidential, Santa Clara, CA

Operational Analyst (Intern)

Responsibilities:

• Supported Confidential ’s Operations Analysis, Reporting & Systems Department in analyzing passenger related data. The data calculated as part of this process was used to get Federal Grant for the Confidential ’s Operations department.
• Promoted various Confidential marketing campaigns and used Excel extensively to analyze the data and prepare reports.