We provide IT Staff Augmentation Services!

Business Data Analyst Resume

0/5 (Submit Your Rating)

Philadelphia, PA

SUMMARY

  • 6 + years of multi - faceted work experience in IT, ecommerce and Distribution/Retail Industry.
  • Experienced in the areas of Data Analysis, Business Analysis and IT development.
  • Degree in Master of Science in Business Intelligence and Analytics.
  • Experience in managing and analysing large data sets to drive analytical-based decision making.
  • Experienced in gathering requirements, creating Use-Case design and analysis.
  • Specifications, Scenarios, Workflow diagrams, process flows and technical.
  • Documentation, using Unified Modelling Language (UML).
  • Experienced in SQL programming and creation of relational database models.
  • Exceptional ability to maintain and build client relationships, frequent meetings one on one with clients, able to comfortably converse with all facets in the client’s organization.
  • Good knowledge in ETL tools, ORACLE & SQL Server.
  • Experience in dealing with different data sources ranging from Flat files, SQL server, Oracle, MySQL, MS Access and Excel.
  • Strong understanding of Data Modelling in data warehouse environment such as star schema and snow flake schema knowledge of Supply Chain analysis.
  • Exceptional ability to maintain and build client relationships, frequent meetings one on one with clients, able to comfortably converse with all facets in the client’s organization.
  • In-depth knowledge of creating statistical models in Python using Pandas, NumPy, Scikit learn.
  • Work individually, as well as in team environment, to achieve project quality goals.

TECHNICAL SKILLS

Programming Skills: SQL, Python, R, SAS, JAVA, VBA

MS-Office Package: Microsoft Office (Windows, Word, Excel, PowerPoint, Visio, Project)

Database: SQL Server, Oracle 9i, MySQL, Hadoop

ETL tools: SSIS, SSAS, SSRS

Visualization Technologies: Tableau, Power BI, Matplotlib, Seaborn, ggplot2, JMP, Minitab, Google Analytics

Machine Learning Algorithms: Logistic Regression, Linear Regression, Decision Tree, Random Forest, Nearest Neighbor classifier, K-Means Clustering, Principle Component Analysis, Support Vector Machine, Naïve Bayes

Others: Agile Methodology, Waterfall Methodology, SDLC, Windows, Mac, LINUX

PROFESSIONAL EXPERIENCE

Confidential, Lake Forest, IL

Content Data Analyst

Responsibilities:

  • Performed initial client assessment and analysis to begin research process for the Search & Select project.
  • Worked in conjunction with senior management in preparation of making decision trees, ad-hoc reports and business reports.
  • Part of creating, managing and implementing business processes.
  • Liaison between the product management team and the stakeholders - departments.
  • Manage projects to meet business needs while staying within scope and on time.
  • Generated bi-weekly reports and metrics to track trends, changes in team's performance.
  • Performed Data Analysis and developed Data Mapping documents.
  • Performed Count Validation, Dimensional Analysis, Statistical Analysis and Data Quality Validation in Data Migration.
  • Attended category workshops and predicted the chances of customers buying a product from a category based on the attributes in the category.
  • Extractdatafrom heterogeneousdatasources, transform as per business requirements and loaddatawarehouse tables fordatavisualization.
  • Analysed over 300,000 items at once to determine if the item belongs to a category using predictive model.
  • Conducted research to determine the reasons why customers are inclined to competitive organization's websites.
  • Created Macros to make the product management process simple using VBA in Excel.
  • Identified 10% products in a category are of elevated risk of loss and created reports to convey the statistics to the product managers.

Environment: SQL, MS Excel (data analysis, data mining, pivot tables, charts & V-lookup, macros), VBA, Tableau, MS Access, Requirement gathering, SAS.

Confidential, Philadelphia, PA

Business Data Analyst

Responsibilities:

  • Involved in gathering requirements from Business users.
  • Used SSIS, SSRS for solving business problems and creating reports in organization.
  • Elicited and gathered requirements by conducting stakeholder meetings, interviews and discussions.
  • Identified use cases, created UML diagrams including use cases diagrams, activity diagrams, process maps, sequence diagrams, and data flow diagrams.
  • Helped business and technical people in prioritizing wish list and managing the small change Requests.
  • Developed workflow, screen mock-ups and conversion requirements for all transaction related activities.
  • Used Microsoft Excel and Microsoft Access for Data Analysis and Reporting.
  • Created documentation for training and Help Desk teams.
  • Worked with SQL queries for data manipulations.
  • Developed ad hoc report as per managers requirement.
  • Created Tableau dashboards/reports for data visualization.

Environment: MS Excel, SSRS, SSIS, SQL, R, Python, Tableau.

Confidential

Data Analyst

Responsibilities:

  • Extracted, organized and translated business requirements into functional requirements.
  • Incorporated various statistical techniques anddatamining tools such as Python (matplotlib, NumPy) andExcel (Clustering, Regression, ANOVA, Chi-Square) to transform rawdatainto actionable insights.
  • Trained and tested third party ecommerce companies (Flipkart, Amazon)datausing linear model to evaluate the number of views and brand following per month.
  • Implemented Logistics regression with an accuracy of 0.79 (Confusion Matrix) to predict the customer who are more likely to buy the productbased on age, area income, daily time spend on the website.
  • Based on the customer analysis suggested marketing strategies to attract high scale of customers.
  • Developed reports/dashboards with different analytic views (Pivot table, charts, Column selectors, view selectors) for analysing monthly sales.

Environment: Excel, SQL, Python, Google Analytics.

Confidential

Business Data Analyst

Responsibilities:

  • Responsible for coordinating software development projects and the activities of developers.
  • Liaison between development team and clients.
  • Gathering requirements from various sector clients.
  • Facilitate requirement Joint Application Development (JAD) sessions with stakeholders to elicitbusinessand systems requirements.
  • Prioritized requirements to be developed according to functional requirements using agile methodology.
  • Created and maintained client information using Microsoft Access.
  • Developed several Tables, Stored Procedures, functions and views to loaddatafrom the SQL server.
  • Worked closely with QA and Developers to clarify and understand functionality, resolve issues and provided feedback to nail down the bugs.
  • Work with QA team to design test plans and cases for User Accepted Testing (UAT).
  • Analysed web traffic and tracked site behaviour KPIs.

Environment: MS Excel, MS Visio, MS Project, SQL, Jira, Balsamiq, Python.

Confidential

Analyst Intern

Responsibilities:

  • Collected and stored the data using SQL queries.
  • Analysed the database collected using statistical methods on weather conditions which affects the flight departure and arrival.
  • Statistically analysed data to assess airline quality and customer satisfaction.
  • Analysed datausing advanced Excel functions such as Pivot Table, Charts, Graphs and Macros.
  • Worked across departments to identify and understand key business questions, and standardize key metrics and measures.
  • Learned how to extract reports using SSIS packages.

Environment: SQL, MS Excel, SSIS

We'd love your feedback!