PERSONAL SUMMARY:

• A bright, talented and self - motivated Big Data Analyst, who has excellent organizational skills, is highly efficient and has a good eye for detail.
• Has over 4.7 years of extensive experience with exceptional knowledge in the area of Telivision and Digital Audience Measurement using big data and product analysis.
• Assisted Data science team in making informed and quality methodologies.

CORE COMPETENCIES:

Business Intelligence

Data Analytics

Data warehousing systems

OLAP

Reporting

Data Sources Extraction ETL

FUNCTIONAL AREAS

Content Measurement

CampaignMeasurement

Audience Measurement

TECHNICAL COMPETENCIES:

Hive

Impala

Netezza

Oracle SQL/PLSQL

Python

TIBCO Spotfire

Tableau

DB Visualizer

MS Office

Hue

PERSONAL SKILLS:

Analytical

People skills

Leadership

WORK EXPERIENCE:

Confidential, Tampa, Florida

BIG DATA ANALYST

Responsibilities:

• Collecting, collating and carrying out complex data analysis in support of Management and Data Science Teams.
• Also involved in reporting statistical findings to Project Managers and senior managers.
• Responsible for taking Data Research Requests from Managers and Data Science team satisfying those requests by the deadlines
• Analyzed and Provided Data Reports helping management and Data Sciece team to take and make key decisions
• Analyzed raw data, drew conclusions and developed patterns
• Presented data in charts, graphs, tables, designed and developed relational databases for collecting data
• Visualized and Summarized data to provide multidimensional view across multiple dimensions
• Presented Data in an understandable format like in the form of Scorecards, Dashboards with KPIs enabling managers to monitor and take immediate actions
• Assisted in mining data from the SQL database that was used in several significant presentations
• Attention to detail & ability to work in a time sensitive environment.
• Experience running complex and high volume business processes.
• Exposure to data warehouse applications/concepts.
• Data validation from providers for sense, consistency and accuracy.
• Strong Knowledge in Hadoop Impala,Hive & Netezza
• Automating the Analaysis scripts
• Good at preparing adhoc Utilities for Data Analysis using Unix & Python

Big Data Analyst

Confidential, FL

Responsibilities:

• Involved in the definition of complex business rules for extracting and transforming the data across multiple source systems in order to provide independent as well as integrated view of the data.
• Import and exportdatabetween the environments like Netezza, HDFS for internal usage monitoring performance of solution.
• Working on data valdiation strategy by analyzing the data architecture, data ingestion framework and Hadoop information architecture
• Performed data profiling of sourcesystems and defined the data rules for the extraction and integration of the same.
• Responsible for presentation of the Insights to the Business users utilizing compelling visualizations on Spotfire.
• Carrying out specified data processing and statistical techniques.
• Provide predicative and statistical analysis of data retrieved from “Hadoop” which will ultimately produce new and creative analytic solutions
• Analyze source system data and data flows, working with structured data
• Manipulate high-volume, high-dimensionality data from varying sources to highlight patterns, anomalies, relationships and trends
• Analysing Provider’s raw data & aggregated data, drawing conclusions & developing recommendations
• Maintenance of data importing scripts using Hive and impala jobs
• Develop and maintain several batch jobs to run automatically depending on business requirements.

Environment: Cloudera Hadoop, Tableau

Data Analyst

Confidential, FL

Responsibilities:

• Worked closely with Business users to define the Analytic needs afflicting the campaign performance.
• Involved in the definition of complex business rules for extracting and transforming the data across multiple source systems in order to provide independent as well as integrated view of the data.
• Prepare Daily, Monthly and Ad-hoc reports, including key business metrics reports, performance reports, and dashboards using SQL and spotfire.
• Performed data profiling of source systems and defined the data rules for the extraction and integration of the same.
• Wrote complex SQL queries on varying levels of granularity for the Analysis dimensions and provide Business Insights to the users enabling guided decision making and what - if Analysis.
• Responsible for presentation of the Insights to the Business users utilizing compelling visualizations on Spotfire.
• Advising on the suitability of methodologies and suggesting improvements.
• Supplying qualitative and quantitative data to colleagues & clients.
• Analysing raw Provider data, drawing conclusions & developing recommendations

Environment: Cloudera Hadoop, Oracle, Netezza, Spotfire

Data Analyst

Confidential, FL

Responsibilities:

• Worked closely with Business users to define the Analytic needs afflicting the Panellists Intab function.
• Involved in the definition of complex business rules for extracting and transforming the data across multiple source systems in order to provide independent as well as integrated view of the data.
• Prepare Daily, Monthly and Ad-hoc reports, including key business metrics reports, performance reports, and dashboards using SQL and spotfire.
• Performed data profiling of Panel data systems and defined the data rules for the extraction and integration of the same.
• Wrote complex SQL queries on varying levels of granularity for the Analysis dimensions and provide Business Insights to the users enabling guided decision making and what - if Analysis.
• Responsible for presentation of the Insights to the Business users utilizing compelling visualizations on Spotfire.

Environment: Netezza, Oracle 11g, Spotfire.

Data Analyst

Confidential, FL

Responsibilities:

• Responsible for frequently importing, cleaning, transforming, validating or modeling data with the purpose of understanding or making conclusions from the data for decision making purposes.
• Presented data in charts, graphs, tables, designing and developing relational databases for collecting data
• Wrote Data Definition Language or Data Manipulation Language SQL commands; be responsible for improving data quality and for designing or presenting conclusions gained from analyzing data using statistical tools like Microsoft Excel, DB Visualizer and others.
• Designed and generated Business Reports providing options to drill-down the data from one hierarchy to another hierarchy.
• Visualized and summarized data to provide multidimensional view across multiple dimensions.
• Presented Data in an understandable format like in the form of Scorecards, Dashboards with KPIs enabling managers to monitor and take immediate actions.

Environment: Netezza, Oracle 11g, Spotfire.

Data Analyst

Confidential, FL

Responsibilities:

• Responsible for frequently importing, cleaning, transforming, validating or modeling data with the purpose of understanding or making conclusions from the data for decision making purposes.
• Presented data in charts, graphs, tables, designing and developing relational databases for collecting data
• Wrote Data Definition Language or Data Manipulation Language SQL commands; be responsible for improving data quality and for designing or presenting conclusions gained from analyzing data using statistical tools like Microsoft Excel, DB Visualizer and others.
• Designed and generated Business Reports providing options to drill-down the data from one hierarchy to another hierarchy.
• Visualized and summarized data to provide multidimensional view across multiple dimensions.
• Presented Data in an understandable format like in the form of Scorecards, Dashboards with KPIs enabling managers to monitor and take immediate actions.

Environment: Netezza, Oracle 11g, MS Office