Business Intelligence Data Analyst II Resume

TECHNICAL SKILLS:

Programming Skills: SQL, SAS, R, PostgreSQL

Tools: /Framework:: Tableau, PowerBI, Toad, PgAdmin ETL, Qlik Sense, Advanced Excel (VBA, Macros, PowerPivot), SAP Business Objects, Linux

Analytical Skills: Data Mining, Data Analysis, Classification and Regression Models, Data Visualization, Business Analysis Statistical Analysis, Business Modeling, SEO, Microstrategy

Databases: Greenplum, MS - SQL Server, Microsoft Access

PROFESSIONAL EXPERIENCE:

Confidential

Business Intelligence Data Analyst II

Excellent experience with the company’s digital marketing and advertising campaign data.
Analyzed data from hundreds of automotive dealer websites to strategize for future advertisement and to measure campaign effectiveness.
Created and developed dynamic and automated reports using Tableau and R.
Responsible for mining data from Greenplum platform using Postgresql, R and Python to create ad hoc reports and to answer on demand questions from internal teams, client and stakeholders.
Worked closely with data warehouse team, SEO team, consultants, client and agency partners to understand requirements and deliver data driven solutions.
Worked on customer segmentation project and analyzed potential campaign effectiveness in terms of advertising spending and website traffic.
Extensive working experience with analytics and data mining tools such as Tableau Desktop and Server, R, Microstrategy, Power BI and PostgreSQL.
Provided web analytics solutions using quantitative and qualitative data along with automation of deliverables.
Provided Tableau training to new recruits and consultants.

Confidential

Business Intelligence Analyst

Analyzed data to save losses of about $100k spent on promotions programs.
Mapped functional requirements to technical flow documents & performed business processes to check data quality.
Single handedly served as a bridge between client & offshore team for business reporting.
Analyzed promotion programs leading to 15% increase in customer billing by evaluating products sold using regression and forecasting methods.
Developed business reports using Tableau to showcase sales and buying patterns of customers across various lines of businesses.
Helped identifying the KPIs for the upgradation of current billing system.

Confidential

Data Analyst Intern

Conducted background research on Ford Telematics Market Share, Government guidelines, customer pricing and market potential.
Single handedly started, analyzed and managed data to develop strategies for better implementation of Telematics hardware in vehicles.
Determined metrics and measurements to find potential customers for our product line.
Cleaned and prepared dataset containing more than 1 billion customer datapoints which made the data relevant for analysis, which was in then used for effective target marketing.
Presented a detailed report on key findings, issues, solutions and suggestions to internal teams and client.
Worked extensively on analytic tools such as SAS, QlikView and SQL.

Confidential

Senior Test Engineer

Single handedly managed all phases of Software Development Life Cycle (SDLC) from gathering requirements; coding; testing in local, SIT & UAT; deployment and support as being the only team member in the project.
Handled software test planning, execution and defect tracking, primarily functionality and performance.
Followed agile methodology to keep track of software and database bugs ensuring each sprint is successfully completed.
Served as a bridge between client and team for requirement analysis.
Mentored and trained new recruits in the project team.

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship