Business Data Analyst Resume Wilmington, DE - Hire IT People

PROFESSIONAL SUMMARY

5 years of experience working in IT, Education and Finance industry as a Business Analyst/ Data Analyst
Experienced in preparing detailed documents and reports while managing complex internal and external data analysis responsibilities
Extensive experience in the Data Manipulation using SQL for the retrieval of data from the Relational Databases
Experienced in data Cleansing and analysis of clients' expenditure data With Excel, using pivot tables, formulas (v - lookup and others), data validation
Created visually impactful interactive dashboards in Tableau and Excel for data reporting by using pivot tables
Strong Leadership skills in handling multiple teams and Offshore teams and ability to effectively communicate with senior management, third party vendors, technical staff, stakeholders and Business users

TECHNICAL SKILLS

Programming Languages: C, C++, PHP, HTML, Python, R programming

Database: MS SQL Server, MySQL, Microsoft Access, VBA

Application Software: Tableau, Advanced MS Excel, IBM Watson Analytics, IBM SPSS, Stat Tools 7, MS PowerPoint, MS Word, MS Visio, MS Project, MS Dynamics, Asana, QlikView, Informatica, SharePoint, Jenkin, SAS, ServiceNow, Google Sheets, Google Analytics, JIRA, UAT, GIT, SVN RapidMiner

WORK EXPERIENCE

Business Data Analyst

Confidential Wilmington, DE

Responsibilities:

Involved in Gap-Analysis for the proposed functionalities to understand the changes required and documented those changes
Analyzed raised workflow and technical issues to halp Project manager and sales team in decision making
Communicated key insights and findings to product team
Organized large data sets into concise and readable formats, usually using Microsoft Excel
Utilized analytical, reporting/ Business Intelligence tools in designing and creating reports, scorecards and dashboards to provide the appropriate detail information to diagnose reasons for performance issues and opportunities for improvement using R and Tableau
Experienced in data modelling including data validation/scrubbing and operational assumptions
Good experience in data transformation, data mapping from source to target database schemas and data cleansing
Created segments, goals, and dashboards in Google Analytics covering the cost per click, conversion rate and other KPIs
Experience in implementing Data warehousing solutions involving Dimension modelling and Snow flake schema implementation (3 NF)
Retrieved user-related data through SQL queries followed by predictive analysis to estimate users' affinity to purchase different product types using MS Excel
Drew upon full range of Tableau platform technologies to design and implement proof of concept solutions and create advanced BI visualizations
Created segments, goals, and dashboards in Google Analytics covering the cost per click, conversion rate and other KPIs

Student Analyst

Confidential New York, NY

Responsibilities:

Performed data analysis for the existing data warehouse and changed the internal schema for performance
Extensively used SQL for accessing and manipulating database systems
Created visual reports and dashboards in Tableau to analyze data and to discover and interpret trends, patterns, and relationships
Responsible for developing reporting tools which can be used to query the database and produce information in tabular and graphic formats
Created ETL workflows through which records were loaded daily, also to other data resources such as Excel, Access, flat file, and XML in order to create and maintain a centralized data warehouse

Business Analyst

Confidential

Responsibilities:

Acted as a liaison between departmental end-users, stakeholders, technical analysts, information technology analysts and consultants in the analysis, design, configuration, testing and maintenance of case management systems to ensure optimal operational performance
Developed FRS and SRS with halp of developers and architects and created mock-ups and wireframes
Worked on large sets of structured and unstructured data, and analyzing it to draw meaningful conclusions
Created visually impactful dashboards using Tableau and Advanced excel like Pivot tables, VLOOKUP and slicers
Provided data modelling support for numerous strategic application development projects
Assisted in development of data formatting and cleaning criteria from various data sources
Experience in using Risk Analysis, GAP analysis (As-is and To-Be), Root cause Analysis, Cost benefit Analysis, SWOT Analysis and other Analysis Techniques as needed

We provide IT Staff Augmentation Services!

Business Data Analyst Resume

Wilmington, DE

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship