Data Analyst

Microsoft Certified Solutions Associate in

Business Intelligence and Reporting with 8+

years experience. Skilled in Business Intelligence technology, Data warehousing, Analysis services,

Integration services, Reporting services,

Statistical Data Analysis, Customer Relationship

Management (CRM), Sales Operations, Digital

Marketing, Account based marketing and Market

Research.

P R O F I L E S UMMARY

LAVENDER

CLAUDIUS

LEAD DATA ANALYST

Profound knowledge on Business Intelligence

technologies. SQL server

2008,2012,2014,2017,2019, Database Engine,

Analysis services, Integration services,

Reporting services, SSMS, SSDT, Visual Studio,

Report builder tool, Mobile report publisher

Profound knowledge on ERP and CRM

systems, SAP, Siebel, SFDC, EDW with

proficiency in using technology to enhance

data and Information management

Profound knowledge on Power BI, Azure BI,

Tableau, Excel

Expert level skills involving Analysis services

languages - MDX, DAX, DMX, XMLA, Power

Query

Experience working with Statistical languages

R and Python. Knowledge on data science

toolbox, Microsoft Azure Machine Learning

and SAS

Excellent understanding of machine learning

techniques and algorithms, such as Naive

Bayes, SVM, Decision Forests, Correlation,

Regression, Classification, Cluster analysis,

Parameter estimation, Hypothesis testing,

Factor analysis, Time series, Random forest,

Gradient boosting algorithms, supervised and

unsupervised learning, interactive analysis

and automated reports

S E L E C T E D H I G H L I G H T S

BI DEVELOPER

SQL School Jun 2019 - Present

Implementation and delivery of MSBI platform

solutions to develop and deploy ETL, analytical,

reporting on SQL Server 2012/2014/2017 using

SSAS, SSIS, SSRS.

Create Dimensional Data Modelling, Cube

development and manipulations in SQL Server

Analysis Services (SSAS).Build SSAS Cubes and

Dimensions with different Architectures and Data

Sources for Business Intelligence and writing MDX

Scripts. Create Hierarchies, Aggregations, partitions, calculated members and KPIs in Dimensional

Modeling

Utilize MS SQL, data warehousing programs, Power

BI, and other dashboard/visualization toolsets for Data intelligence and analysis

Consolidate and package up insights, analytic

outputs, and action items into a well-organized,

consumable package with actionable

recommendations and strategies for marketers and

salesforce (MS Excel, PowerPoint, Word, etc.)

MARKETING DATA ANALYST

Netrocon Digital Feb 2017 - Jul 2018

WORK E X P E R I E N C E

Compile data from disparate data sources

leveraging both qualitative and quantitative

attributes to build holistic views of the business Analyzed data to identify trends, generate reports and adjust campaigns as necessary to produce the

most optimal ROI

Analyze marketing metrics to identify cause-effect relationships between marketing levers and

outcomes

Synthesize and translate business data needs into

creative visualizations in Power BI, Tableau and

other visualization tools

Perform advanced analytics tasks, including but not limited to predictive statistical models, customer profiling, segmentation analysis, data analysis and mining, and external data enhancement using SQL,

SAS, R, Python

Account based marketing specialist: Develop ABM

plans and help the client’s marketing and sales

team in new business acquisition, increasing

Mobile: +91-636*******

Email: ****************@*****.***.***

City: Coimbatore, India

F I N D M E H E R E :

Certifications : Power BI – MSCA, Google

Analytics, Insurance- INS 21 Certified - Property

and Liability Insurance Principles

Domain Expertise : Marketing – Traditional and

Digital, IT Sales operations, Managed enterprise

services

Business Intelligence tools : Azure Analysis

services ( ADF, ADW), SQL server

2008,2012,2014,2017,2019, Database Engine,

Analysis services, Integration services, Reporting services, SSMS, SSDT, Visual Studio, Report

builder tool, Mobile report publisher, Business

Objects Web intelligence, EDW (Enterprise data

warehousing), OSRM (Orders, Shipments,

Revenue, Margins

CRM/ ERP/ Sales tools &Applications : SAP, Siebel

6/7/8, Salesforce.com, MDM, Eclipse, Quest, Smart

Quote, Omega, Columbus, SIQP, Tech-direct

Languages : SQL, Visual Basic, JavaScript, Python, R programming, HTML, CSS, MDX, DAX, DMX,

XMLA, Power Query

S P E C I A L S K I L L S

SCDL

Master of Business Administration - Finance

STELLA MARIS COLLEGE

Bachelor of Commerce

S C H O O L S A T T E N D E D

market share and also to nurture /upsell to existing clients. Practice agile marketing techniques to

accomplish goals

LEAD DATA ANALYST

Hewlett-Packard Aug 2009 - Sep 2012

Managed and owned the EMEA Printing and

Personal systems (PPS) business division Enterprise accounts database

Manage SSIS 2008 and SSAS 2008 production, test

and development servers

Evaluate data file submissions and

develop/maintain SSIS packages for ETL processes

Research and evaluate trends, forecasts,

interventions and impacts. Formulate

recommendations for Global programs, and

provide information for decision and project

support

Analyze marketing metrics to identify cause-effect relationships between marketing levers and

outcomes

Analyze every phase of the Sales cycle from Total

addressable Markets for customers and potential

customers of PPS enterprise business, to account

coverage and Quota deployment for the sales force

Perform advanced analytics tasks, including but not limited to predictive statistical models, customer profiling, segmentation analysis, data analysis and mining, and external data enhancement

Prepare Heat maps, analysis, findings and reports

on Go-to-market planning, account intelligence and Sales forecasting and also direct/advice District

Managers and SSP regional leads on Account

coverage and Quota deployment.

TEAM LEAD

Hewlett-Packard Apr 2008 - Aug 2009

Handled a team of 22 FTE’s

Work Prioritization, Allocation and Load balancing of Tickets

Manage the Knowledge management (KM)

Infrastructure and training requirements for Team

members

Track KPI’s for performance metrics and reporting

this on weekly and monthly basis

Get involved in New business opportunities,

provide inputs to gain new business

Innovate, Initiate and Drive team performance to

develop a superior workforce and improve

efficiency of business processes

Contact this candidate