Khushbu D
Data/BI Analyst
About
Having 5+ years of experience in Business Intelligence, Business/Data analysis, ETL Development, making reports, dashboards and leading in Project Management/development. Highly analytical and process-oriented Data Analyst with in-depth knowledge of database/Datawarehouse systems (MySQL, MS SQL, Netezza, Snowflake), business intelligence methodologies like data reporting, data cleaning, data analysis, manipulation, visualization etc.
Skills & Expertise (29)
Work Experience
Sr. Data Analyst
TCS- USAA
Jul 2022 - Feb 2025
Participated in defining project scope, developing analytical strategies, managing timelines and resources, leading junior analysts, communicating progress and findings to stakeholders, and ensuring the project delivers high-quality, data-driven business insights to guide strategic decisions. Collaborated with different departments and teams for the data development process for dashboard development. Collecting the project's requirements in collaboration with stakeholders and business leaders. Develop analytical approaches, structuring data, querying data, and apply filtering methodologies to find patterns using SQL or Hive. Serve as a key point of contact for project stakeholders, communicating progress, challenges, and findings. Facilitate meetings and deliver presentations to clearly articulate complex data insights to various audiences. Translate raw data and complex analysis into clear, actionable business recommendations with data visuals like graphs, charts, etc. Writing efficient DAX formulas to reduce report load times and enhance query performance for large datasets. Used Tableau, Power BI, and Adobe Analytics Business Intelligence tools to track and report with multiple data challenges like data blending, data integration, data sourcing, etc. Performed data mapping using MS SQL Server, Netezza, MySQL Server, Snowflake, and Hadoop. Integrate developed data and results from Query editor tools to data visualization tools while applying ETL (Extract, Transform, Load) technique for creating a dashboard/Scorecard. Creating/updating dashboards for Website Traffic Management, Web analytics, scorecards, and providing key detailed Insights as per Business development. Tracking website traffic/data to redefine product page analysis and that increased retention rate by 3% and engagement by 7% using Adobe Analytics, Hive, and Tableau for large datasets.
Business Intelligence Analyst
TCS- USAA
Feb 2019 - Jul 2020
Collaborate with client stakeholders to gather complex business requirements by defining the business problem and data requirements. Discuss with senior managers/stakeholders to understand the process flow to support requirements. Exploring data warehouses, data structures, and data trees with managers/independent to start working on requirements. Analyzing/Exploring historical data and current data structures to understand the data dependencies, structures, and details, making decisions on data strategy, and communicating complex data findings to non-technical audiences. Filtering the data, handling missing values/errors, and preparing the dataset for analysis, using imputation techniques to ensure accuracy and relevance. Assist in the implementation of successful software solutions and product developments that run, manage, and optimize customers’ key business processes, utilizing methods, etc. Extracting data from a variety of sources like MetricStream, MS SQL, MySQL, Hadoop, websites, internal portal systems, Azure, SAS, Salesforce data tools, and organizing it. Using DAX to create calculated columns, tables that enrich the data model for better reporting. Performing Data cleansing, Data mapping, Data management, performing queries, filters, analysis, and transforming to Business Intelligence tools like Tableau, Power BI, Business Objects, SAP, etc. and reduced manual reporting time by 70% with automated reporting systems. Brainstorming sessions with users, team members for technical requirements, KPI calculations, inclusions/exclusions, data sources, and automation process. Creating dashboards for Monthly Invoices for different Vendors (Healthcare/Medical), Billing Systems, Insurance, Financial terms (Bank, Investments), Website Traffic Management, Web analytics, scorecards, and providing key detailed Insights as per Business development. Also, I have experienced writing Jira API Tools and ASANA to auto-move Service Desk tickets of one issue type to a project.
Trainee - Data Analyst/Developer
CBL Solutions
Aug 2017 - Jan 2019
Collecting information/data for certain sets of questions, goals, challenges, hurdles to understand the needs/priorities for an impactful Output/Report/Dashboard. Reviewed customers’ requirements, reported for scope, task requirements, gaps, task allocation, completion, new errors and updated overall goal of the project with team consensus. Responsible for translating business requirements into technical requirements. Making large and/or complex data more accessible, validate data and make it understandable and usable by using MS. Excel and SQL. For powerful features of MS Excel like-pivot tables, what-if analysis, VLOOKUP used for analyzing statistical data. Integrate developed data and results from Query editor tools to data visualization tools while applying ETL (Extract, Transform, Load) technique for creating dashboard/Scorecard. Implement the calculations for certain KPIs to measure accurate output to support requirements and preferable options to track. Data visualization demo to team, involves clients, stakeholders, managers to identify some information, relations among data variables to examine the data. Performed migration from different databases (i.e., Oracle, MYSQL).
Web Developer
TEKSUN Cultivating Technology
Jun 2012 - Jul 2014
Making development of websites as online management of society (housing colony), where each member of society was able to perform their responsible tasks as paying maintenance check, managing activities, festivals, camps etc. Utilized MS Visio to manage functionality of the website in more effective way by implementing User Interface development by giving them a clear vision of flow. Experienced in WAMP (Windows, Apache, MYSQL, PHP) and LAMP (Linux, Apache, MySQL, Python/PHP) Architecture. Created websites that address the phases of SDLC (software development life cycle). Worked in team of, using JavaScript for development, HTML and CSS for designing, reporting API, Java & PHP for back-end and My SQL database, developed website. Update existing applications to meet the security and functionality standards as outlined in the company’s website policies and upheld quality control, data validity. Assist in updating application development policies to ensure that all future applications meet the latest technical requirements.
Education
Master of Science in Information Technology Management - Campbellsville University
2020 - 2022 · Afghanistan
Master of Science in Information Systems specializing in Big Data analysis - California State University Los Angeles
2015 - 2017 · Afghanistan
Bachelor of Engineering in Computer Engineering - Gujarat Technological University
2010 - 2014 · Afghanistan
Certifications
No certifications added yet