Data Analytics Resume

SUMMARY:

Dynamic BI and analytics consultant with 7+ years of experience in developing analytics solutions while helping company take effective data driven decisions and derive business value.

SKILLS:

Reporting Tools: Tableau 8/9, Qlikview, Qlik Sense, BOBJ Xcelsius, SSRS, Power BI

Languages: Python, PL/SQL, MS VBA Marco, Java Script, Shell Scripting

DB & ETL Tools: Hadoop Hue 3.8, MS SQL Server SSIS, Oracle 10g, Talend, Alteryx

Statistical Tools: SAS EG 5.1 & 4.2, SAS E - Miner, Rapid Miner, SPSS

EXPERIENCE:

Data Analytics

Confidential

Responsibilities:

Derived key metrics to identify customer search & buying behavior by developing Tableau dashboard and MS SQL Server.
Performed comparative analysis of customers making same day booking in terms of average price, time and distance and top destinations in Tableau dashboard.
Kroger - Developed big data analytics dashboard for Kroger to identify customer footfall behavior.
Worked with 2 TB database containing 3.5 billion transactions in Hadoop environment from 109 stores in Ohio.
Analyzed customer groups using K-Means clustering technique with count of visit, standard deviation of visit hours, total amount spend, amount spend per visit, discount percentage and spending habits.

Confidential

Senior Lead

Responsibilities:

Developed complex dashboard providing complete portfolio analysis in single view; helping financial advisors in providing better investment solutions to customers.
Applied understanding of dimensional data modeling and SQL optimization capabilities in developing daily sales redemptions across investment solutions.
Delivered dashboard from scratch start from setting up Tableau server, maintaining server activities, user activity, customized views on Server Analysis, development & publishing of dashboard in agile environment in 2 months.
Used SSIS to perform ETL activities before data can be shown in the dashboard.
Created Batch Stored Procedures for in the Report Scheduler according to the monthly, weekly or daily.
Respobsible for user acceptance testing, Project documentation, access management and refresh scheduling.

Confidential

Senior BI Analyst

Responsibilities:

Designed dashboard for sales programs, sales process strategy, across multiple product lines.
Developed monthly reports, sales planning and strategy development.
Extensive knowledge in Tableau reporting objects like Facts, Attributes, Hierarchies, Transformations, filters, prompts, Calculated fields, Sets, Groups, Parameters
Expertise in designing and creating various analytical reports and dashboards to help users to identify critical KPIs and facilitate strategic planning in the organization.

Confidential

Senior BI Marketing Analyst

Responsibilities:

Designed analytics for pricing study, product positioning & benchmarking in Oil & Gas and Power sector.
Developed and maintained a clean transactional database for four sectors with pricing analytics, revenue and gross margin reports, and basic quantification of business decisions.
Used SQL & SSRS to publish monthly pricing reports; and produced pricing dashboard during pricing studies.

Confidential

Senior Process Associate

Responsibilities:

Involved in creation of Reports and presentations as per user requirements using Webi, Xcelsius 2008.

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship