System Analyst Power Bi

Neha Kumari Singh

Business System Analyst

SUMMARY:

Over 10+ years of experience in design, development, implementation and administration of Business System Analyst and expertise in implementing various functionalities of Data Warehouse; designed stunning visualizations and dashboards using Tableau Software.

Expert experience in Tableau Desktop, Tableau Server, Tableau Reader, Public and Mobile in various versions of Tableau 2021/2020/2019/10/9/8

Proven record of collaborating with cross-functional teams to deliver high-impact projects.

Excellent communication and project management skills.

Proficient in Power BI Desktop and Power BI Service for building interactive dashboards, reports, and visual analytics.

Strong Business Analysis experience on Data Analysis, Business Requirement Documents, Data Migration Documents, User Requirement Gathering, User Requirement Analysis, Gap Analysis, Physical and Logical design, Resource Planning, Data Cleansing, Data Transformations & Impact Analysis.

Proficient in data visualization, Reporting, Analysis, Pie Charts Bar Charts, Cross Map, Scatter Plots, Geographic Map, Page Trails, Density Chart and other making use of actions, other local and global filters according to the end user requirement.

Expertise in designing and creating various analytical reports and Dashboards to help users to identify critical KPIs and facilitate strategic planning in the organization.

Successfully upgraded Tableau platforms in clustered environment and performed content upgrades.

Experience in creating different visualizations using Bars, Lines and Pies, Maps, Scatter plots, Gantts, Bubbles, Histograms, Bullets, Heat maps and Highlight tables.

Extensive knowledge in different reporting objects like Facts, Attributes, Hierarchies, Calculated fields, transformations, filters, Sets, Groups, prompts, Parameters etc. in Tableau.

Expert in creating Calculations (LOD, Cube Calculations, Creating/using Parameters, Table Calculations, Totals) and Formatting (Annotations, Layout Containers, Mark Labels, Rich Text Formatting, Shared Encoding) using Tableau Desktop.

Experience in Trouble Shooting, Performance tuning of reports and resolving issues within Tableau Server and Reports.

Experience on Configuring installation and managing Tableau Server with large data volumes like Setting up Tableau data sources. Filters, blending, join for optimum performance and Trouble-shooting issues.

Expert in Data Extraction, Transformation and Loading (ETL) using SQL Server Integration Services SSIS/DTS.

Involved in Trouble Shooting, Performance tuning SQL Server and resolving issues within Tableau Server and Reports.

Experience in Data Conversion and Data Migration from earlier versions to current SQL server using SSIS and DTS services across different databases like Oracle, MS access and flat files.

Experienced with SQL Server and T-SQL in constructing triggers, tables, views, stored procedures, user defined functions, indexes, user profiles and relational database models with data integrity.

Utilized advanced Tableau features and functionalities to create interactive visualizations and dynamic reports that effectively communicate complex data trends and patterns.

Implemented best practices in Tableau dashboard design to ensure user-friendly navigation, data interactivity, and visual clarity for enhanced data interpretation.

Experienced in working with different data sources like flat files and Excel to source data in SSIS and proficient in creating SSIS packages from scratch and deploying them.

Experience in creating Jobs, Alerts, SQL Mail Agent, and schedule ETL Packages.

Experience in PL/SQL and SQL and in performance tuning SQL queries in TOAD.

Highly Proficient in Agile, Scrum and Waterfall software development life cycle.

Excellent verbal and written communication skills combined with strong interpersonal and conflict resolution skills and possess strong analytical skills.

TECHNICAL SKILLS

BI/ETL Tools

Tableau (Tableau 2021, 2020, 2019, 10X, 9X, Tableau Desktop, Tableau Server, Tableau Reader), Power BI, Power BI Desktop, SSIS, SSRS, DTS & Data stage

Databases

SQL Server, Oracle, MS Access, MS excel, Teradata

Modeling Tools

MS-Visio

Reporting Tools

SQL Server Reporting Services

Languages

T-SQL, SQL, PL/SQL, C, C++, JAVA, VB, MS ACCES, Python

Operating Systems

Windows 8/7/XP/2003 & Unix

Methodology

Agile Methodology, Scrum Model, Water fall method.

Office Tools

Microsoft Office 2003 / 2007 / 2010 / 2013

EDUCATION:

Master of science, Kanpur university, India 2010

Bachelor of science, Paranuchal university, India 2007

EXPERIENCE

Meta/ HCL America December 2024-Till Date

Sr. Business System Analyst

Description: Experienced Data Engineer with a strong background in designing and developing scalable data pipelines using the DataSwarm platform. Skilled in end-to-end data processing including ingestion from diverse sources (APIs, databases, flat files), data transformation, and loading into lakes, warehouses, and analytics platforms. Proficient in managing workflow orchestration, ensuring data quality and consistency, and supporting cross-functional teams in data governance and reporting initiatives. Adept at delivering reliable, efficient, and scalable data solutions to meet business intelligence and operational needs.

Responsibilities:

Designed and developed scalable data pipelines using the DataSwarm platform for end-to-end data processing.

Performed data ingestion from multiple sources including APIs, databases, and flat files.

Led and supported the migration of public-facing websites from an on-premises SharePoint environment to the Adobe Experience Manager (AEM) cloud platform.

Implemented robust data transformation logic to cleanse, standardize, and enrich datasets.

Loaded processed data into target systems such as data lakes, warehouses, and analytics platforms.

Built Power BI dashboards and reports to track content readiness, migration status, and QA results across multiple departments and sites.

Integrated Power BI dashboards into SharePoint and Teams for seamless organizational access.

Improved decision-making by delivering data-driven insights through interactive visuals, slicers, and drill-through capabilities.

Applied strong business analysis skills to elicit and document content requirements, prioritize features, and align technical migration tasks with business needs.

Managed workflow scheduling, monitoring, and error handling using DataSwarm’s workflow features.

Ensured data quality and consistency through rigorous data integration and validation practices.

Collaborated with cross-functional teams to support data governance, scalability, and reporting needs.

Environment: Data transformation, and loading into lakes, warehouses, and analytics platforms. Tableau, Power BI, SQL, Python

Sunflower Lab, Somerset, NJ June 2021 –November 2024

Business Data Analyst

Description: ExpensWise – The objective of this bill management dashboard was to help the finance department and the approval managers to have the detailed information about the expenses incurred on a particular activity/project and to understand the investment and returns. Dashboard will help the approval managers to reduce the costs if it is going beyond the budget allocated.

Responsibilities:

Created data connections and performed data cleansing and manipulation using Tableau Prep.

Created visually appealing and intuitive user interfaces, optimizing user experiences.

Collaborated with stakeholders to gather requirements and define project scopes.

Managed project timelines, budgets, and resources to ensure successful implementations.

Used tableau as the reporting and dashboard tool to have a clear overview to the users about the expense bill which is spending on different projects.

Conduct user acceptance testing UAT to validate dashboard accuracy, functionality, and usability, ensuring a seamless user experience.

Collaborated with stakeholders to define and improve site navigation, menus, and information architecture in alignment with usability best practices.

Integrated Tableau with big data platforms to create visualizations and reports on large and complex datasets

Design and develop Big data pipelines to ingest and transform raw data into formats suitable for analysis

Utilized Power BI to track and visualize migration progress, content readiness, and site-level performance metrics for stakeholders.

Conducted regular performance tuning and optimization of Tableau workbooks and data sources to improve dashboard responsiveness and efficiency.

Developed and deployed interactive Power BI dashboards to visualize key business metrics, sales trends, and operational KPIs.

Design and develop ETL processes to extract data from various sources, transform it into a usable format, and load it into Tableau for reporting and visualization

Collaborated with business users and data analysts to gather requirements and translate them into effective Tableau solutions that meet specific business needs and objectives.

Strong knowledge of Macros and Excel functions to automate tasks and streamline data processing.

Developed and implemented data governance policies and procedures to ensure data integrity and compliance with regulatory requirements.

Utilize Tableau Prep to clean, transform, and integrate data from multiple sources for analysis.

Created views in Tableau Desktop that were published to internal team for review and further data analysis and customization using filters and actions.

Created Heat Map showing current service subscribers by color that were broken into regions allowing business user to understand where we have most users vs. least users.

Projected and forecasted future growth by developing reports to show in detail.

Converted charts into Crosstabs for further underlying data analysis in MS Excel.

Providing training and support to end users on utilizing Tableau and AWS services for data visualization and analysis.

Collaborated with IT and business teams to define data governance standards and guidelines.

Developed story telling dashboards in Tableau Desktop and published them on to Tableau Server which allowed end users to understand the data on the fly with the usage of quick filters for on demand needed information.

Scheduled data refresh on Tableau Server for weekly and monthly increments based on business change to ensure that the views and dashboards were displaying the changed data accurately.

Tested dashboards to ensure data was matching as per the business requirements and if there were any changes in underlying big data.

Collaborate with development team on data approach for coding Understand data guidelines, and understand data sources available, what is new based on requirements, and how the project will impact common data stores

Participated in meetings, reviews, and user group discussions as well as communicating with stakeholders and business groups.

Environment: SQL server, Data Visualization Tableau 8x Desktop and Server, Power BI, MS Excel, AWS

Sumitomo Mitsui Banking Corporation – SMBC Group, Brooklyn, NY March 2020 – May 2021

Tableau Developer

Description: The client is a banking client who provides personal banking products and survives, as well as investment, brokerage, wealth management and insurance products and services. The project goal was to deliver Tableau reports supporting customer service team to analyze the agents and financial products performance.

Responsibilities:

Interacted with the customer service team; reviewed and analyzed the business requirements and various data sources in order to design, develop, test and produce the reports in Tableau Desktop and Sever

Created reports of customer profile analysis, customer satisfaction rate, product profile performance report to support the customer service team analysis

Assisted in conducting end-user training sessions and UAT for new dashboard implementations.

Assume accountability for the integrity, accuracy, and timeliness of reporting generated from these applications.

Experience in handling large datasets, relational databases, and distributed systems.

Write complex SQLs to perform data analysis activities.

Experience using analytical skills, tools and techniques to investigate information and to draw conclusions.

Analyze data across disparate data sources to support requirements, identify data integration requirements to support the build.

Actively identified, documented, and communicated defects and issues found during UAT sessions, working closely with development teams to ensure timely resolution.

Performed data-lineage/traceability/reconciliation activities as required to support user inquiries.

Prepare runbooks, methods of procedures documents and present the same to business teams.

Collaborate with data engineers to automate and optimize ETL workflows to ensure efficient data integration and preparation for Tableau visualizations

Implementing data security best practices in Tableau and AWS environments to comply with industry regulations and protect sensitive data.

Automated data processing tasks using Macros and Excel functions to improve efficiency and accuracy.

Conducted research and data collection to support data governance initiatives.

Created heat map by color, broken into age groups, salary groups, job category groups, etc. allowing business analysis team to understand customer groups difference

Develop and maintain data connections in Tableau Prep to ensure data accuracy and consistency.

Performed calculated fields, mapping and hierarchies to design the report

Created users filter to show the specific customer or specific product performance

Developed a dual-axes bar chart with multiple measures, and have created donut charts and pie charts for better visualization

Utilize SQL Database to extract, transform, and load data from relational databases into Tableau for reporting and visualization purposes

Collaborating with business stakeholders to understand their data visualization needs and provide strategic recommendations for leveraging Tableau and AWS effectively.

Conducted Tableau server upgrades and installations, as well as monitored server performance and scalability to support growing data visualization needs.

Developed story telling dashboards in Tableau and published them on Tableau Server allowing business users understand data and constructed quick filter for on demand needed information

Created comments and captions of the analysis to better explain the reports

Designed and maintained complex Excel spreadsheets with advanced formulas and functions to analyze large datasets and generate insightful reports for management decision-making.

Deployed the reports to report server in time to ensure the efficiency of the analysis

Environment: Tableau, SQL Server Reporting Services (SSRS), AWS, T-SQL, Advanced Excel, MS Office Suite

PEAC Solutions, Mount Laurel, NJ

Tableau Developer December 2018 –February 2020

Description: Real Pro – The objective of the dashboard was to smoothen the reporting process for property management, internal strategy, sales and pipeline forecasting and agent revenue report generation.

Responsibilities:

Implement data quality checks and data cleansing techniques within the ETL process to ensure the accuracy and reliability of data used for Tableau reporting

Participate in the full lifecycle of BI development, from requirements gathering to end-user support

Collaborate closely with business stakeholders, analysts, and data engineers to translate requirements into effective insights via reports and visualizations

Lead the design, development, and maintenance of business intelligence solutions, leveraging data warehousing, and analytics architecture principles

Develop reports, complex dashboards, analytical and predictive models using Tableau, SSRS, SQL, R, Python and SAS.

Developed and maintained financial dashboards using Tableau to provide real-time insights and support strategic decision-making.

Collaborated with business stakeholders to understand their requirements and translated them into technical specifications.

Utilized SSIS and SSRS for ETL processes and report generation, ensuring data integrity and accuracy.

Conducted data analysis using SQL Server, Oracle, and Teradata to identify trends, patterns, and anomalies.

Created complex calculations, parameters, and sets in Tableau to enable dynamic and interactive reporting.

Implemented Agile methodologies and participated in Scrum meetings to ensure timely delivery of projects.

Created and optimized SQL queries, stored procedures, and triggers to support data analysis and reporting.

Developed reports and dashboards using SQL Server Reporting Services (SSRS) to meet business requirements.

Collaborated with cross-functional teams to gather requirements and provide technical solutions.

Provided support and maintenance for existing BI solutions, ensuring their optimal performance and reliability.

Designed and executed SOQL queries in Salesforce to retrieve and analyze CRM data directly from the platform, providing valuable inputs for Tableau visualizations.

Participated in training sessions and workshops on data governance best practices.

Combined views and reports into Interactive Dashboards in Tableau Desktop

Designing, creating and publishing customized interactive reports, dashboards, and scheduling using Tableau Server.

Conduct data quality checks and troubleshooting in Tableau Prep to ensure data integrity.

Created action filters, sets, parameters and calculated sets for preparing worksheets and dashboards in Tableau.

Performed Tableau type conversion functions when connected to relational data sources.

Environment: Tableau, SQL, ETL, Big data, BI, SSIS, Oracle, Python, AWS, Advanced Excel, MS Office Suite

NeenOpal Inc., Newark, NJ July 2017 - November 2018

Tableau Developer

Description: The objective of the project “Opertx” was to maintain effective operational cycle. The entire cycle from request to quotation to order to invoice to Receivables for multiple clients can be challenging, so the project aimed at identifying and removing bottlenecks to ensure smooth end to end operational cycle. When implemented, application will collect finance and subscriber’s data, calculates KPIs and aggregations, and make the resulting data available to downstream systems for further processing and reporting.

Responsibilities:

Created Dashboards by connecting to different data sources and databases.

Worked on creating interactive, real-time dashboards using drilling downs and customizations.

Monitor server activity/usage statistics to identify possible performance issues/enhancements

Published Tableau dashboard on Tableau Server and embedded them into portal.

Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.

Conduct data modeling and schema design in SQL databases to support Tableau reporting requirements and ensure data integrity

Implement data governance and security measures to protect sensitive information within the big data environment

Perform ETL performance tuning and optimization to enhance the speed and efficiency of data processing for Tableau dashboards

Collaborated with the data engineering team to design and implement data pipelines for data ingestion and transformation in PySpark

Train and support end-users in using Tableau Prep for data preparation tasks.

Conducting data modeling and schema design in AWS databases to optimize data storage and retrieval for Tableau visualizations.

Present the analysis to internal and external teams and Explain data from a business perspective and relevance to Key Performance Indicators.

Created Tableau models, architectures, and strategies based on business requirements.

Analyzed and troubleshoot technical issues related to reporting.

End to end BI implementation of Data Visualization, ETL and Data Warehousing.

Creating Data Visualizations as per customer requirements.

Monitoring and analyzing Tableau Server and AWS usage metrics to identify trends, performance bottlenecks, and opportunities for improvement.

Integrated CRM systems with other business applications to ensure seamless data sharing and a unified view of customer interactions.

Collaborated with data engineers to prepare and clean data for analysis using Tableau Prep.

Elicit customers to understand their business processes, at both micro and macro levels.

Create and setup technology-based solution architecture for proper functioning of BI.

Client achieved 23% increase in efficiency within a quarter of implementation.

Collaborate with database administrators to ensure data stored in SQL databases is structured and organized for effective use in Tableau visualizations

Environment: Tableau Desktop, ETL, Tableau Server, Big Data, Advanced Excel, MS Office Suite, AWS

Indium Software, Princeton, NJ August 2016 – June 2017

Tableau Developer

Description: F1Zilla is the project to analyze the service to the customers who raise the tickets. We prepare the analyses using fact tables and deferent dimension tables. Create bar charts for number of tickets resolved and not met by user group and create total count of tickets raise in a week, assigned to department, category wise analysis, region level severity and time taken to resolvea ticket.

Responsibilities:

Involved in analyzing the user requirements and transform them into Tableau Dashboards and Reports.

Write complex SQL queries and optimizing them to pull the required data in an effective way and handle the performance issues.

Utilized views, stored procedures and custom SQL queries to validate data from spreadsheets and MySQL to Tableau.

Implement data cleaning and transformation processes in Tableau Prep to standardize and enrich data for analysis.

Developing and maintaining documentation for Tableau and AWS configurations, processes, and workflows to facilitate knowledge sharing and training.

Created interactive reports and dashboards by making use of LOD expressions, actions, local and global filters, calculated fields, groups, sets, hierarchies and parameters in Tableau.

Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps and used data blending feature in Tableau.

Troubleshoot data issues and discrepancies in SQL databases to ensure the accuracy and reliability of data used in Tableau reports

Involved in Tableau Server and Desktop Installation, Configuration, Creating Users, Groups, Projects and Assign Privileges etc., in a multi-server environment.

Created tables, views and adding/changing tables for data load and transformation, and data extraction.

Distilled complex information from given database by performing SQL queries such as Joining several data tables.

Stay current on emerging trends and best practices in big data analytics, Tableau, and data visualization to continuously improve skills and knowledge

Importing/exporting data by developing SQL queries against SQL Server database into Excel for analysis and reporting.

Practiced data analysis workflows from SQL to Excel and created effective visualizations that delivers essential information.

Work closely with data engineers and data scientists to integrate Tableau Prep workflows into the overall data pipeline.

Engaging in continuous improvement initiatives to enhance data visualization capabilities, optimize resource utilization, and drive innovation in Tableau and AWS environments.

Increased efficiency by 24% in time management while delivering services and resolving tickets.

Environment: Tableau Desktop, Tableau Server,,ETL, Big Data, SQL, My SQL, Python, Excel,AWS

Kellton Tech Solutions Ltd (KTSL), Lucknow, India March 2014- December 2015

Data analyst/Tableau Developer

Description -Collect and clean data from various sources. Conduct data analysis and create insights using Python and Excel. Develop interactive data visualizations using tools like Power BI. Prepare and present findings to the teamAssist with ad-hoc analytical tasks

Responsibilities

Conduct research on a specific topic or industry.

Collect and analyze data.

Summarize findings and present results to

Input and organize data into databases or spreadsheets.

Ensure data accuracy and consistency.

Assist in data cleaning and validation.

Contact this candidate