Data Analyst Resume Boston, MA - Hire IT People

SUMMARY

Data Analyst wif proven competencies in Statistical analysis,Data profiling, Data Visualization, and Identifying trends in large data sets and patterns coupled wif business acumen. Proficient in gathering useful business insights by analyzing data
Proficiency in multiple databases/relational Databases like Teradata, Snowflakes, MySQL, ORACLE,MS SQL Server, spread sheets, text files.
4+ years of experience using office 365 suite. Advanced Excel(functions, formulae, sumifs, pivot table, v - lookups, VBA)
Extensive experience in creating scripts in python for Data Analysis, Data science, Data cleaning, Data mining,Data Visualization and Report generations.
Strong experience in interacting wif stakeholders/customers, gathering requirements through interviews, workshops,and existing system documentation or procedures, defining business processes, identifying, and analyzing risks usingappropriate templates and analysis tools.
Strong experience in cloud technologies like AWS(S3, sage maker, EC2), Azure
Strong experience working in Agile/Scrum methodology
3+ years of experience using Data visualization platforms such as PowerBI, Tableau
Proficiency in writing complexSQLQueries (SELECT, JOIN, CREATE, GROUP BY & HAVING, WHERE clause, Sub-quires, Triggers, Functions, stored procedures) using T-SQL, Programming in SQL, aggregating functions(sum, count, average, min, max), and retrieve data from data warehouses.
Expertise in Data warehouse and business Intelligence tools complex SSIS, SSAS Tableau, Power BI.
Good understanding of Relational Database Design, Data Warehouse/OLAP concepts and methodologies

TECHNICAL SKILLS

Certification: IBM Data ScienceProfessional Certificate, Advanced Google Analytics, Tableau Data Scientist

Programming Languages: R, Python (Pandas, NumPy, Matplotlib, Seaborn, Scikit-Learn, SciPy, Plotly), SQL, VBA

Machine Learning: Linear Regression, Logistic Regression, K-NN, Clustering, Classification, Decision trees, Neural Networks, Time-Series Analysis

MS Office: Word, Excel, PowerPoint, MS Excel

Software & Analytical Tools: Azure, Tableau, R shiny, Power BI, MS Excel, Power BI, SSAS, MATLAB, Google Analytics

Database / ETL: SQL Server, MySQL, MongoDB, Oracle, SSIS, SSRS

PROFESSIONAL EXPERIENCE

Data Analyst

Confidential, Boston, MA

Responsibilities:

Design, develop and maintain dashboards, reports in SQL, Google Analytics and Tableau to drive key business decisions.
Improved KPI’s like traffic, conversion, website behavior, User Behavior etc. by 10% by formulating actionable insights
Acted as a liaison between marketing team, team leadership and all key stakeholders to increase social media reach
Developed Data pipeline to create weekly, monthly reports to evaluate performance of marketing channels and initiatives using python, Tableau, Google Data studio
Collaborated wif various stakeholders on business procedure, user requirement and ensure quality of data
Built custom dashboards inPower BI and Tableau to visualize trends, patterns, and anomalies in vendor data by analyzingmultidimensional Environmental, Social and Governance (ESG) data using SQL, Python, Advanced Excel (VBA)
Developed process for transforminglarge unstructured ESG data into Flat Files using python
Increased database size by 15% (1mil rows) by developingFuzzy matching algorithm in Python and SQLto map securities wifcompanies
CreatedStored procedures, Functions in SQL to update daily market data into respective back-end Microsoft SQL Server datawarehouse

Data Analytics Intern

Confidential

Responsibilities:

Increased revenues by 10% of 7000 Customer Service Points (CSPs) by analyzing their revenue trends and business strategies usingAdvanced Excel
Analyzed customer behavior pattern, KPIs and discovered potential opportunities by collaborating wif 105 CSPs
Improved operational efficiency by acting as a liaison between all key stakeholders and developing relationships
Presented to all key stakeholders on best industry practice for revenue generation by performing competitive intelligence on competitor banks and creating detailed report using MS Office (Word, Excel, PowerPoint)
Designed and developed organizational database in SQL, Excel and MS Word
Analyzed customer patterns, KPIs and discovered potential opportunities using Advance Excel (Pivot table, VLOOKUP)
Generated market intelligence and competitive intelligence report for polyurethane insulated panels
Design, develop and maintain dashboards, reports in MS Word and MS Excel (Pivot table, VLOOKUP, Functions, VBA)

We provide IT Staff Augmentation Services!

Data Analyst Resume

Boston, MA

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship