Business Intelligence Data Analyst Resume

SUMMARY:

3 years of extensive experience with Tableau and SQL. Developed interactive and dynamic dashboards using parameters, calculations, and filters to dig deeper into underlying data.
Strong foundations in EDA, Statistical Modeling, Machine Learning: Linear Regression, Logistic Regression, Clusters, Classification, Neural Networks, Artificial Intelligence and Support vector machines using R, Python, SAS, and Tableau.
Excellent understanding of Data modeling (Dimensional & Relational) on concepts like Star - schema, Snowflake schema using fact and dimension tables and relational databases (Oracle).
Extensive knowledge in various reporting objects like Facts, Attributes, Hierarchies, Transformations, filters, Calculated fields, Sets, Groups, Parameters, etc., in Tableau.
Academic study and coursework in Innovative Health IT, BI-Healthcare, Statistics, BI, DBMS and IT project management.
Professional experience in Business Intelligence - identifying trends, evaluating results using a variety of statistical analysis techniques, constructing advanced visualizations and communicating actionable insights using Tableau.
Formulated complete marketing and sales campaign strategy with specific goals, tactics and evaluated global digital marketing initiatives to critique the current state of the website and presented to IRP e-commerce, Ireland.
Strong understanding of project life cycle and SDLC methodologies including RUP, RAD, Waterfall and Agile.

TECHNICAL SKILLS:

PROFESSIONAL EXPERIENCE:

Confidential

Business Intelligence Data Analyst

Responsibilities:

Produced the Agile development for the organization building Business and Operational Intelligence using Tableau to help small businesses increase their profitability
Analyzed various data sets to identify trends, enable correlative insights, construct dashboards, determine statistically significant issues and present strategic business solutions to both start-up and established organizations
Extracted data from established reports or raw data from operational or transaction processing from Production, Supply Chain, Complaint Handling or Technical Service information systems.
Cleaned, categorized, standardized, normalized and integrated data collected into meaningful and accessible reports by product, period as required
Conducted detailed statistical analyses to describe the history, characterize behavior, and identify trends to support corrective actions, improvements, and comparative analyses
Established and maintained databases that contain information to support quantitative and qualitative product performance analyses as well as process depiction and improvement projects
Developed, implemented and improved data collection systems, insight repositories and other strategies that optimize efficiency and data quality for the company
Handled multiple projects simultaneously
Built productive customer relationships by taking responsibility for customer satisfaction and loyalty of our clients

Confidential

Product Marketing and Research Intern

Responsibilities:

Implemented marketing and competitor analysis for determining brand perceptions and evaluating market penetration on an underperforming line of cosmetic for an international cosmetic company based in Spain.
Gathered information to properly measure the effectiveness of marketing activities.
Designed marketing and pricing strategies to compete with other competitors; resulting in a strategic pricing change for an essential product.
Designed, created, and analyzed reports, using Excel and Tableau, for promotions, sales, and marketing trends.
Coordinated with doctors to gather, analyze and report specifications for a product; and developed quality product recommendations accordingly.

Confidential

Marketing and Sales Intern

Responsibilities:

Conducted market research and analysis on an underperforming line of cosmetic products
Recognized project strengths and weaknesses and advocated areas of improvement
Analyzed data in Excel and provided recommendations to increase profitability
Interviewed doctors to assess their needs for the product and made product recommendations accordingly
Communicated requirements and changes to development team

Confidential

Business Intelligence (Tableau, SQL)

Responsibilities:

Build interactive dashboards on Tableau utilizing parameters, calculated fields and table calculations, user filters, sets to handle views more efficiently, and multiple charts like Stack bars, bar graphs, scattered plots and heat maps
Collaborated efforts with technical staff and subject matter experts to establish the technical vision of the product and analyze triple constraint tradeoffs
Analyzed the performance of various hospitals using HCAHPS (Hospital Consumer Assessment of Healthcare Providers and Systems), extracted data from My Rounding Application and developed strategies to improve performance and HCAHPS scores

Confidential

Responsibilities:

Extracted Ebola Virus, Cholera virus and other historical disease data from CDC, and WHO using R
Performed data cleaning, data transformation and data-mining tasks on the West African region-wise spread of infections.
Developed a strategy to deploy vaccine for Ebola which was developed by Confidential .
Designed surveys to extract answers to specific marketing questions
Analyzed survey data to measure opportunities which enhance conversion rates, cost per click and profits, identify new channels and plan targeted campaigns
Conducted audits and developed marketing strategy to penetrate new markets