Data Analyst Resume

SUMMARY:

Over 5 years of progressive experience as Data Analyst to assist the multiple departments by simplifying the spreadsheets with Macros.
Well - versed with all stages of Software Development Life Cycle (SDLC), and QA Methodologies like Agile, Scrum Waterfall, and Iterative process.
Hands on experience in the field of Data insight, Data Analysis and Data Visualization.
Core experience in developing data analytics products, which includes requirement gathering, analysis, design, data Validation and Data Visualization.
Strong in writing Complex SQLs queries in RDBMS to Analyze large amount of data; Good knowledge in OLAP and Aggregated tables concept; Hands on Expertise in building Complex tableau dashboards to provide insight to the data.
Worked on creating client and custom reports and dashboards (On demand, Ad-hoc Reports, Frequency reports, Summary Reports, Sub, Charts, Filters, Drill-down, Drill-through, graphical reports etc.) using SQL and PowerBI.
Highly proficient in Data analysis, Design, data management, databases and data visualization.
Proficiency with advanced data tools and methods including R (Machine Learning), SQL, and GIS.

SKILL:

Software: Tableau, Power BI, ArcMap, Arc GIS Pro, Weka, SPSS, R Studio, Google Analytics, Qualtrics, Salesforce,JIRA, Rhiza

Programming language: SQL, VBA Scripting, R programming, Java

Database technologies: SQL Server, MS Access

Office Tools: MS Excel, MS Word, MS Project, MS Visio, MS PowerPoint

PROFESSIONAL EXPERIENCE:

Confidential

Data Analyst

Responsibilities:

Working on building automation framework for several reports to reduce department s reporting time.
Responsible for analysing, preparing and distributing monthly revenue report and quarterly historical performance report using IBM Cognos and Tableau.
Collaborating with Marketing and Business Insights teams on focused analytics including sales target development key insights on market and share, and business planning and forecasting.

Confidential, Boston, MA

Analyst

Responsibilities:

Responsible for designing and implementing ETL processes for market research data analytics.
Analyzed research data and developed market specific dashboards for sales team within Confidential Spotlight organization using Tableau, SQL, ArcGIS Pro and MS Excel.
Responsible for creating and maintaining stored procedures and Excel macro automation (VBA Scripting) to help speed up department’s reporting processes.
Created complex SQL queries for managing geographic database that feeds various tools used in Corporate Marketing for Confidential Spotlight across the country.
Developed and implemented statistical models to predict lead generation strategies.
Designed Snowflake schema for developing Data Marts using ER Studio.
Working closely with cross-departmental stakeholders to deliver resources that meet business requirements.
Worked on JIRA to create tickets and kept track of their progress.

Confidential, New Jersey

Data Analyst

Responsibilities:

Utilized tools such as R, Excel, and SQL to clean company’s marketing and sales data.
Conducted quantitative analysis to derive actionable insights for marketing team.
Performed data visualization and presented findings to senior management in form of intuitive dashboards using Power BI to make informed and quick decision.
Diagnosed complex data issue and provided recommendation for resolution to ensure optimal work flow.
Optimized online revenue performance in terms of revenue, ROI and other KPIs.
Developed model for forecasting ROI for marketing team based on historic lead performance metrics in order to optimize monthly marketing spend.

Confidential, Charlotte, NC

Data Analyst

Responsibilities:

Typed work instructions from engineering order into work cards
Extensively worked on Tableau for visualization &a forecasting
Created team specific Agile process flow in JIRA to move tasks from one activity to another.
Provided timely and thorough communication to the team of engineers on the status of tasks and projects.

Confidential

Business Analyst Intern

Responsibilities:

Conducted complex reporting analytics and created complex SQL queries to maintain company’s database.
Interacted with clients to understand their business requirements.