We provide IT Staff Augmentation Services!

Business & Data Analyst Resume

4.00/5 (Submit Your Rating)

San Jose, CA

SUMMARY

  • Around 5 years of experience as Business & Data Analyst with hands on experience in Analysis, Testing, Implementation, Performance tuning and Maintenance of Data Warehousing Projects.
  • TERADATA Certified Application Developer.
  • Well versed in creating refreshable charts, dashboards and pivots using Microsoft Excel.
  • Experienced in problem solving analysis, data issues and computing KPI metrics.
  • Familiar with ETL methodology for supporting data extraction, transformation and loading process, using Ab Initio.
  • Experienced in SQL, Teradata & familiar with Oracle.
  • Worked extensively on developing dashboards for SEM channel.
  • Worked extensively as a Data Warehousing consultant in one of the leading online marketing sector (Client - Confidential & Confidential ) for almost 5 years.
  • Efficient team player with excellent communication skills and good interaction with users.
  • Result oriented approach for task completion and desire to accomplish everything with perfection and within the stipulated timeframe.

TECHNICAL SKILLS

Databases: Teradata V2R12, Oracle, MS Access

ETL tools: Abinitio

Programming: C, SQL, VBA

Operating systems: Windows NT/95/98/2000/XP, DOS, UNIX

Applications: MS Word, Excel, Outlook, MS Access and PowerPoint

Tools: /Utilities: SQL Assistant, UC4,Business Objects, Micro Strategy, Visio, Tableau

PROFESSIONAL EXPERIENCE

Confidential, San Jose, CA

Business & Data Analyst

Responsibilities:

  • Product analyst gauging the performance of a product
  • Helped in D4A (design for analytics) process.
  • Create a playbook for deep dive analysis and anytime go to solution centre. Involves a bit of VBA coding.
  • Communicating between product team and data management team.
  • Ad hoc a/b testing.
  • Competitor Analysis

Confidential, San Jose, CA

Responsibilities:

  • Data Analyst to develop dashboards for consumers.
  • Gather business requirements, understand the flow and suggest optimal solutions
  • Create a normalized database to gather data from all disparate sources.
  • Provide and automotive solution to maintain weekly and monthly dashboards.

Confidential, San Jose, CA

Responsibilities:

  • Being the data analyst and point of contact for a particular marketing channel.
  • Analysing the business requirements and understanding the user’s requirements.
  • Ad-hoc & refreshable reports were developed using SQL and MS Excel.
  • Automatically refreshable Pivot charts and tables were developed.
  • Create visualized reports using Tableau.
  • Driving insights from the data pulled.
  • Report management.
  • Worked with performance tuning and optimization of queries.
  • Interacting with various teams across Confidential for various reports.

Confidential

Responsibilities:

  • Analysing the business requirements and understanding the working process of the system
  • Get a depth understanding of the affiliates and ad network model
  • Identifying situations for fraudulent clicks and revenue calculation.
  • Parallel testing during development phase.
  • Involving in preparation of ERD’s.
  • Created an automated tool for identification of fraudulent clicks.
  • Created bteq scripts, ab initio graphs, test cases, test plan and captured test logs.
  • Providing production support for the first day to identify missed fraudulent behaviour.
  • Also managed an onsite-offshore model.

Confidential

Responsibilities:

  • Analysing the business requirements and understanding the user’s requirements.
  • Ad-hoc & refreshable reports were developed using SQL and MS Excel.
  • Automatically refreshable Pivot charts and tables were developed for trend analysis.
  • Business forecasting was also handled.
  • Developing ad-hoc reports using Microstrategy and publishing them to a common sharepoint.
  • Worked with performance tuning and optimization of end-user queries.
  • Interacting with various teams across Confidential for various metrics and definitions.
  • Worked in an onsite-offshore model.

Confidential

Responsibilities:

  • Analysing the business requirements and understanding the user’s requirements.
  • Involved in design document and data modelling.
  • Developed BTEQ scripts and prepared units test cases and test bed for unit testing.
  • Production move

We'd love your feedback!