Analyst 2, Data and Systems Automation Resume Boston, MA - Hire IT People

SUMMARY

Over 5 years of progressive experience as DataAnalystto 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 andPowerBI.
Highly proficient in Data analysis, Design, data management, databases and data visualization.
Proficiency with advanceddatatools and methods includingR(Machine Learning), SQL, and GIS.

TECHNICAL SKILLS

Software: Tableau, Power BI, ArcMap, Arc GIS Pro, Weka, SPSS, R Studio, Google Analytics, Qualtrics, Salesforce, 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, Boston, MA

Analyst 2, Data and Systems Automation

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 entity relationship diagrams for the database schema using UML.
Working closely with cross-departmental stakeholders to deliver resources that meet business requirements.
Troubleshooting tickets raised by the client on priority basis.

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
Inserted graphics, figures and tables in studio
Added reference links to graphics, tables and figures
Compared engineering project to engineering order
Created monolithic pdf for engineering project
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.