We provide IT Staff Augmentation Services!

Business Data Analyst Resume

Irving, TexaS

SUMMARY

  • Certified Tableau Developer & Business Data Analyst with 7+ years of IT experience in Data analysis, Business analysis, Business intelligence, Implementation and Maintenance of Database & Reporting applications and Data warehousing with following Certifications.,
  • Expertise in end to end Business Intelligence (BI) implementation including loading data to Datawarehouse and Create Tableau Reports and Dashboards
  • Highly proficient in Test Driven, Data driven, Iterative, Agile - Scrum, RUP and Waterfall methodologies of Software Development Life Cycle (SDLC)
  • Scheduled data refresh on Tableau Server for daily, weekly and monthly increments
  • Expertise in implementing Object level security and User level security to restrict data access in Tableau
  • Extensive knowledge on Tableau Desktop, Tableau Server, Tableau Online, Tableau Prep, Tableau Conductor, Power BI and working knowledge of Alteryx
  • Highly proficient in Design and Development of Prototype Reports/Dashboards in Tableau during the Requirement Gathering phase to visualize the reports and clarify requirements
  • Extensive experience in working with Time series, Aggregation, Filters, Joining and Blending data, Groups and Sets
  • Thorough understanding of Python basic concepts like Lists, Strings, Indexing, Slicing, Tuples and Dictionaries and familiarity with NumPy, Pandas and Matplotlib
  • Developed, identified, designed, built, tested, optimized, and maintained a Data Warehouse and OLAP Cube using the entire Microsoft BI Stack with emphasis on, but not limited to, SSIS, SSAS, SSRS and SharePoint Server.
  • Proficient in preparing Business Requirement Documents (BRDs), Functional Requirement Documents (FRDs), Use Case Documents (UCDs), creating Prototypes, User Stories, Requirement Traceability Matrix (RTM), Tableau Reports and Dashboards.
  • Experience in creating various visualizations such as Scatter plots, Box plots, Maps, Dual axis charts, Donut chart and Trendlines
  • Expertise in Creating Animations, Table calculations, Advanced dashboards and Storytelling in Tableau
  • Expertise in Performance Tuning Tableau Dashboards and Reports built on huge Data sources
  • Analyzed data from stores in SQL Server and provided reports to senior managers and cross-functional teams
  • Good working experience using SQL, PL/SQL in writing Stored procedures, functions and using Triggers
  • Strong understanding of Data Warehouse concepts, Star Schema, Snowflake Schema, Physical and Logical Data modelling
  • Experience in creating Unified Modeling Language (UML) diagrams for Business Process Modeling like Use Case Diagrams (UCD), Activity Diagrams (AD), Sequence Diagrams (SD)
  • Experience in Evaluating and Improving Existing Tableau Reports that are in place and collaborate with business to integrate new data points to streamline workflow and company processes
  • Experience in working with QA team in generating test plans, test scenarios, test cases and managed complete defect tracking life cycle using JIRA and HP ALM Quality Center
  • Actively participating in Post-Production Validation (PPV), production support and handling of issues
  • Handling Change Management by conducting Impact Analysis & facilitating Change Control Board (CCB) meetings
  • Flexible, Enthusiastic and Project-Oriented Team Player with excellent communication and leadership abilities to develop creative solution for challenging requirement of client.

TECHNICAL SKILLS

Reporting Tools: Unify, Tableau Desktop, Tableau Server, Tableau Online, Tableau Prep Builder, Tableau Conductor, Power BI, SSRS

Methodologies: RUP, Waterfall, Agile

Languages: SQL, UML, XML, Python

Business/Data Modeling Tools: Power Designer, MS Visio, SSIS

Project Management Tools: MS Project, MS Excel, MS Word, Lotus Notes, GIT

Defect Management Tools: HP ALM/Quality Center, JIRA

Database: AWS Redshift, MS SQL Server, MS Access, Teradata

PROFESSIONAL EXPERIENCE

Confidential, Irving, Texas

Business Data Analyst

Responsibilities:

  • Owned Data as a Product's Customer Insights platform adoption and consumption, for assigned user groups, in order to drive high platform usages and stickiness to improve decision-making; leading to customer retention, trips and basket upsell opportunities
  • Revenue pursuit responsibilities, initially and on-going, to support internal Merchant needs for Supplier meetings that focus on subscription to DaaP Customer Insights Portal
  • Delivered the DaaP implementation (initial and on-going), customer product support needs, and overall adoption best practices into assigned user groups within Merchandising/Marketing/Digital product teams
  • Provided guidance and case studies to assigned user groups that demonstrate real, high-value insights that they should present to assigned Merchants, often vetting Supplier users analysis prior to sharing with Merchants
  • Partnered with assigned user groups to act as the voice of the customer to help drive SEI customer-centric sales and marketing strategies for Supplier's products, including coaching assigned Merchants on the Suppliers' opportunities
  • Delivered internal customer success processes, including customer onboarding, ongoing support strategies
  • Delivered ad hoc project analytics and presentations, as needed, to support complex external user needs and selected external Suppliers' commercial projects
  • Helped define metrics for measuring DaaP program impact, customer satisfaction, product usage, and assigned user groups growth / productivity
  • Delivered implementation and on-boarding process for each Internal User, working with Partner Vendor; provided reporting and visibility to program status on an on-going basis, and scheduled and delivered final readout with trainings and on-going support expectations
  • Developed strong partnerships with client user groups, develops change champions to drive focus on program objectives and milestones
  • Continuously reviewed market and customer trends to improve the user experience, drive operational excellence, and drive user skills and innovative approaches among assigned user groups, leveraging our Partner Vendor Governance
  • Presented weekly implementations, operations, usages and internal monetization status to Director, Business Analytics and team

Environment: Unify, Tableau Desktop 2019.1/2019.4 , Tableau Server, Tableau Prep Builder 2019.1/2020.2 , Tableau Online, Agile, JIRA

Confidential

Tableau Developer/BI & Data Analyst

Responsibilities:

  • Provided data visualizations to support the customer in decision making and to improve the process effectiveness and efficiency
  • Understand how customers perceive the Enterprise Operations Center’s services and improve customer satisfaction using KPI’s
  • Provide visibility into IT Operations control and event management and help customers in gaining unique insight into their daily operations
  • Identify metrics and KPI’s as part of requirement gathering process
  • Assisted EOC groups in creating and monitoring KPI’s and metrics that track the status of a specific business process
  • Translated project requirements into functional and non-functional specifications for Business Intelligence (BI) reports and applications.
  • Used predictive analytics to examine and determine patterns in data that can be used to predict and understand customer behavior, such as ticket raising trends
  • Created dashboards using Tableau Desktop and Power BI to administer customer satisfaction survey program after their tickets were resolved and completed and published the tableau visualizations to Tableau Online for other users to provide recommendations
  • Used query editor and modelling in Power BI to clean, shape, transform data and build relationships among data sets for easy slice and dice
  • Written Python script to automate a daily report to take screenshots of the manual process
  • Worked with various Python libraries mainly Pandas, Numpy, Scipy, Matplotlib, NLTK and Pytables
  • Developed mockup reports to address challenges in new visualization requests by customers
  • Modified existing visualizations to identify and rectify errors in advance calculations in the dashboards
  • Collaborated with relevant dashboard owners to implement changes across various visualizations
  • Performed quality checks, data verification, data validation and code review of visualizations
  • Identified data sources and performed data modelling using Tableau Prep Builder and scheduled prep flows using Tableau Conductor
  • Added users to Tableau Server group memberships and determined their site role based on their security clearance to access information
  • Performed testing of dashboards upon addition of new fixes and wrote test cases for the same
  • Assessed options to effectively integrating new features in existing dashboards after conducting analysis of data sources and dashboards
  • Documented disaster recovery options in case of an unforeseen event and how to test the data once it has been restored
  • Created SQL queries for Data Analysis and Data Validation.
  • Created data dictionary for data sources and dashboards to track the fields across various data sources
  • Submitted knowledge articles for troubleshooting tableau dashboard issues
  • Reviewed visualizations to suggest improvements to improve the dashboard navigation, usability and customer experience
  • Performed weekly dashboard maintenance activities as part of release configuration management to incorporate changes in the dashboard outside of business hours so that the users don’t get affected
  • Performed trend analysis through visualizations
  • Provided operational metrics to management, PMO and support teams on aging tickets, stalled tasks and to highlight bottlenecks as well as identifying opportunities to increase efficiencies
  • Set targets for improvements based on SLA and OLA metrics

Environment: Tableau Desktop 2019.1/2019.4 , Tableau Server, Tableau Prep Builder 2019.1/2020.2 , Tableau Conductor 2019.1, Tableau Online, Power BI, Agile, SQL, JIRA, GIT, Python, Business Intelligence

Confidential

Business Data Analyst/Tableau Developer

Responsibilities:

  • Responsible for the discovery and documentation of functional and system requirements, communication and validation of those requirements with key stakeholders
  • Created Mockup reports in Tableau and Power BI for client valuation and offshore reference
  • Involved in publishing of various kinds of live, interactive data visualizations, dashboards, reports and workbooks from Tableau Desktop to Tableau servers
  • Worked on Performance tuning of the tableau dashboard and reports at various levels including database, data sources and workbooks
  • Blended data from multiple databases into one report by selecting primary keys from each database for data validation
  • Handled Tableau admin activities like granting access and managing extracts
  • Effectively used Data blending feature in tableau. Defined best practices for Tableau report development
  • Prepared reports pertaining to logistics business in the areas of supply chain effectiveness, transportation management, industry/KPI benchmarking, growth opportunities, continuous improvement and value quantification
  • Data acquisition, cleansing, harmonizing and maintenance of customers POS data
  • Prepared reports for forecasting, supply chain planning, logistics and service operations
  • Prepared reports to better understand and manage the Inventory, Expense and productivity of their supply chain
  • Worked extensively with the QA team for designing Test Plan and Test Cases for the User Acceptance Testing
  • Have extensively used Tableau functions like Data Blending, Custom SQL, Interactivity, and Chart types, Navigation, Images and Parameters
  • Tableau advanced charts using geo maps, Gantt charts, Pareto charts, scattered plots for providing multidimensional views
  • Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps, Trend Lines, Statistics, and Log Axes, Groups, Hierarchies, sets to create detail level summary report and dashboard using KPI's
  • Created shell scripts using Python language and libraries such as NumPy and Panda
  • Coordinated with Crew scheduling team/schedulers in loading and build trips and legs for Pilots bidding process
  • Conducted JAD sessions and captured meeting minutes for staff/client meetings and distributed meeting notes
  • Used SQL and MS Excel using macros for all Data validation based on the Business Rules
  • Experience in writing SQL, PL/SQL-Stored Procedures, Functions and Triggers
  • Developed Use Cases and Scenarios and visualized them using UML diagrams
  • Worked with data scientists to analyze Teradata and develop insightful data visualization and also created various visualizations such as Scatter plots, Box plots, Maps, Dual axis charts, Donut chart and Trendlines
  • Worked with clients to better understand their needs and present solutions using structured SCRUM approach
  • Involved in data Extraction, Transformation and Loading (ETL process) from source to target systems using SQL Server Integration Services (SSIS)
  • Created UAT plans with several test cases for each project to ensure that the system runs smoothly after the proposed enhancements or changes have been made
  • Used Quality Center for updating the status of all the Test Cases & Test Scripts that are executed during testing process
  • Involved in testing applications on various generations and versions for iOS, Android, Blackberry and Windows platforms
  • Involved in Data Warehouse design for the integrated data using Data warehouse concepts like Star schema, Snowflake Schema
  • Performed extensive Requirement analysis and developed and designed Use Cases, Activity Diagrams, Sequence Diagrams and Swim lane diagrams

Environment: Tableau Desktop 10.2.x./2018.x, Tableau Server 10.x./2018.x., Power BI, Agile, UML, XML, MS Office, MS Excel, MS Visio, MS SQL, PL/SQL, Oracle SQL, HP ALM QC 10, Python

Confidential

Business Data Analyst/Tableau Developer

Responsibilities:

  • Conducted Joint Applications Development (JAD) and Joint Requirements Planning (JRP) sessions to gather technical requirements and validated the needs of the business stakeholders
  • Translated the gathered requirements into User stories by detailing in the functional and non-functional requirements based on interactions with the Product Managers and SME’s who gave the customer’s real-time feedback
  • Performed Requirement Analysis and developed Use Cases, Activity Diagrams using Rational Rose
  • Experience in Multi-Channel Fulfillment & Warehouse Management, Multi-channel and Omni-channel retailing operations
  • Good knowledge of Order Management and Content Management System
  • Decomposed business benefit into high level use cases to illustrate the major function of different system modules
  • Employed UML in behavioral, structural and architectural modeling, created Business Process Model and Notation (BPMN) and other major function diagrams
  • Led daily Scrum meetings and sprint planning, story review, sprint review and retrospective meetings and provided daily status to Project Manager
  • Created use case scenarios and documented User Interface specifications (UIS)
  • Analyzed data from stores in SQL Server and provided reports to senior managers and cross-functional teams
  • Developed Test Plans with QA team and executed User Acceptance Testing
  • Created and troubleshoot defect tickets in JIRA before assigning them back to development
  • Facilitated Data Mapping, logical Data Modeling and used SQL queries to filter data
  • Performed data cleansing to reduce Data Redundancy thereby optimizing Data Quality
  • Provided ad-hoc queries on Key performance metrics (KPI) and other data metrics to business users
  • Analyzed complex data sets, performing ad-hoc analysis and Data Manipulation to support retail Campaigns
  • Involved in publishing of various kinds of live, interactive data visualizations, dashboards, reports and workbooks from Tableau Desktop to Tableau servers
  • Developed reports that summarized sale and marketing critical to making key business decisions
  • Created custom E-Commerce solutions for clients and then monitored client progress
  • Analyzed complex data sets, performing ad-hoc analysis and Data Manipulation to support Retail Campaigns
  • Collaborated with developers in implementation & optimization of interactive Tableau Desktop dashboards for Retail & Online operations
  • Build the eCommerce metrics roadmap by collecting and analyzing various data sources
  • Tracked and reported key performance metrics, traffic behaviors and campaign performance using Google Analytics
  • Monitored and reported on the influence of social media marketing with the help of Google Analytics

Environment: Tableau Desktop 9.x./10.x., Agile, UML, Power Designer, MS Visio, MS Office, MS Excel, MS SQL Server, PL/SQL, Oracle SQL developer, JIRA

Confidential

Business Data Analyst/Tableau Developer

Responsibilities:

  • Tableau advanced charts using geo maps, Gantt charts, Pareto charts, scattered plots for providing multidimensional views
  • Handled Tableau admin activities granting access, managing extracts and Installations
  • Creation of tableau users and testing with different security levels for web authorization and authentication
  • Build and publish Tableau reports utilizing Data Blending, multi-level hierarchy, Table Calculations, Parameters, Graphs and Actions
  • Integration of tableau reports with web application and viewing reports online
  • Defined best practices for Tableau report development
  • Worked on Apple Pay and Samsung Pay projects where I had to do a thorough analysis of the existing functionality that Confidential had and to compare it with the requirements given by Apple and Samsung so that both the functionalities would be in sync without any issues or code failures. Some of the features were built from scratch while some were taken from the existing ones that Confidential already had
  • Worked on Cyber Security project for credit card fraud protection by scratching c-cards using Cobol which included confidential information to be handled in a discreet manner
  • Worked on IDCAMS Encapsulation Project as the single point of contact from India by merging the database through DB2 and COBOL which could be accessed by Credit Card department globally
  • Analyzed requirements and used systematic approaches to implement and document the tasks
  • Recommended and executed plans to improve development tools and processes
  • Oversaw deployment and documentation procedures
  • Handled a Global Fix Repository where I used to issue Fix Tags after analyzing the requirements of the functionalities of projects
  • Involved in QA phase and wrote test plans, implemented Unit testing
  • Creating Test Plans and Test Cases in HP ALM for system integration testing and running the test cases against the database to validate the data in both materialized views and on the dashboard
  • Preparing Production migration documents, Functional documents, Technical designs solutions and business rules for each sprint release and work with production team during migrations
  • Gathered Business Requirements, interacted with the Users, Project Manager and SMEs to get a better understanding of the Business Processes
  • Prepared project reports for management and assisted the project manager in the development of weekly and monthly status reports, policies and procedures

Environment: Tableau Desktop 9.x./10.x., Tableau Server 9.x./10.x., COBOL, MS Office, MS Excel, MS Word, MS PowerPoint, HP ALM QC 10, IBM Lotus Notes

Confidential

Software Developer

Responsibilities:

  • Continuous improvement efforts through differentiated process improvement, optimizing tools & technology & metrics management in Business Operations department
  • Collaborated with the Web Development group & Business Intelligence to identify automation requirements
  • Responsible for collecting, assimilating, and converting raw data into a useable format for operational decision-making
  • Modified existing report formats, created & interpreted customized reports, integrated data. (Formula creation, Pivot Tables, database creation, complex query creation, etc.)
  • Provided counsel to the Manager and key internal stakeholders in implementing objectives and business goals
  • Prepared reports pertaining to Retail banking and wealth management in the areas of Retail Supply Chain effectiveness, transportation management, industry/KPI benchmarking, growth opportunities, continuous improvement and value quantification
  • Financial reporting, Forecasting & Planning system to accommodate internal customer requests
  • Applied Information Analysis & Solution Generation Knowledge: utilized computer-based analytical & information management tools to perform routine analysis; documents approach & findings
  • Applied Database Knowledge: Demonstrated basic knowledge of Database Design principles; identified users’ requirements; demonstrated a basic understanding of the importance of maintaining & updating databases
  • Responsible for daily communications to management and internal organizations regarding status of all assigned projects and tasks
  • Translated the gathered requirements into user stories by detailing in the functional and non-functional requirements based on interactions with the Product Managers and SME’s who gave the customer’s real-time feedback
  • Performed requirement gathering and knowledge extraction about the financial services through interviews, audio/video conferencing and JAD sessions
  • Identifying and gathering business requirements from different groups, end users for developing reports
  • Created and manipulated various management reports in MS Excel for sales metrics using VLOOKUP and Pivot tables
  • Created Process Workflows for the end-to-end solution, Functional Specifications, and Project Initiation documents along with Review of Existing Scope document

Environment: HTML, CSS, JavaScript, XML, PL/SQL, MS Office, MS Excel, MS Word, MS PowerPoint, HP ALM QC 10, IBM Lotus Notes

Hire Now