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 AnalystResponsibilities:
- 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