We provide IT Staff Augmentation Services!

Business Data Analyst Resume

San Jose, CA

SUMMARY

  • A highly skilled & efficient business data analyst experienced in handling 6 projects with 7+ years of experience in a highly dynamic work environment and with superb customer satisfaction record in client management and SDLC process, self - managing and leading cross-functional teams through agile process in a matrix environment, toward the most efficient attainment of business goals across diverse markets such as Finance, Banking and Insurance.
  • Experience in Data Analysis, Feed Analysis, Data Mapping, Data Modeling, Data Reconciliation, Data Entity Relationship Diagram, Normalization and strong understanding of Relational DBMS.
  • End to end project management from Kick off through all phases of Agile development methodology until Go-live and Maintenance Support.
  • Extensive experience in analyzing and documenting business requirements and system functional specifications including use cases.
  • Cross functional team management both onsite and offsite, facilitating SCRUM meetings.
  • Worked in the capacity of a Scrum Master facilitating all scrum ceremonies - Daily Scrum, Sprint Planning, Review and Retrospective Meetings. Coordinated teams in different time zones while actively maintaining a healthy velocity.
  • Involved in installation of Tableau desktop 8.0, Tableau server Application software and also in server migration from 8.3 to 9.0.
  • Multi-project management in a fast-paced workflow, with strategic planning and prioritization based on project schedules, monitoring dependencies with constant evaluation and decision-making.
  • Key contributor in establishing and driving process initiatives and officiating the PMO (Project Management Office), in collaboration with Tech Leads and other Business Analysts.
  • Experience in working with SDLC methodology and project life cycle.
  • Strong communicator and creative problem-solver, skilled at analyzing business needs and transforming them into technical designs, applying technical skills and business knowledge to achieve sound results.
  • Proficient in creating Use Cases, Sequence Diagrams, Collaboration Diagrams
  • Comprehensive experience and knowledge in using Data Modeling and Business Intelligence tools, TABLEAU DESKTOP, MS Visio, UML, SQL (SSRS, SSIS, SSAS) etc.
  • Highly expertise in tracing requirements throughout the development process and verifying adherence to Requirement Traceability Matrix (RTM).
  • Significant experience in reviewing Test Procedures and creating Test Cases
  • Excellent analytical and problem-solving skills in designing, developing, and implementing innovative business processes and providing system solutions using advanced approaches, technology, and training
  • Excellent work ethics coupled with excellent communication, written and interpersonal skills describing a committed team player.
  • Certified Scrum Master (CSM) and Facilitated Scrum Ceremonies - Daily Scrum, Sprint Planning, Review and Retrospective Meetings. Maintaining scrum reports - Burn Up/Burn down Charts, Velocity Chart, Impediment list, Sprint Report, Focus Factor.
  • Proficiency in gathering SMART (Specific, Measurable, Attainable, Realistic, Timely) requirements and transforming them into functional and non-functional specifications.

TECHNICAL SKILLS

Methodologies: Waterfall, Agile- SCRUM, Scrum-Waterfall Hybrid, SAFe.

Operating Systems: Windows, Mac OS

Database/ ETL: MS Access, Oracle DB, SQL Server

Data Warehousing: Data Modeling, Data Marts, OLTP, OLAP, Data Mining, Slicing/Dicing, Roll Up/Drill Down, Pivot

Process Modeling Tools: MS Visio, Balsamiq, Rational Rose, Mock Ups

Business skills: Change Management, Impact Analysis, Risk Analysis, Cost-Benefit Analysis, ROI Analysis, JAD Sessions, SWOT analysis, Financial Reporting, Valuation and Pricing, Budgeting

Reporting/ BI: Tableau, Ms. Excel

Language: HTML, SQL, Visual Basic

Project Management Tools/ Methodologies: MS Project, MS SharePoint, Waterfall, Agile Scrum, Hybrid (Waterfall - Scrum), Kanban, SAFe

PROFESSIONAL EXPERIENCE

Confidential, San Jose, CA

Business Data Analyst

Responsibilities:

  • Intensive knowledge of Credit Card Transaction Lifecycle, Card holder managementLifecycle and Credit card dispute resolution process and Understanding of PCIDSS.
  • Conducted workflow, process diagram and GAP analysis to derive requirements for existing systems enhancements.
  • Liaison with the business community to define business requirements by conducting JAD sessions and one on one interview and provided input towards technical solutions in the form of BRD and FRD.
  • Prioritized new features and functionality based on business needs.
  • Performed Data Analysis, Data Validation and Data Mapping by writing complex SQL queries using SQL workbench
  • Developed SQL scripts for generating daily, weekly and monthly business reports and automated them using crescendo and Databricks.
  • Performed Data Analysis to make sure that the data is loading correctly into relational database.
  • Developer code using Big Data software Technologies (Spark, AWS, Databricks) to conduct the analysis of billion customer records.
  • Developed python scripts and API to extract the data from databases like Teradata, Redshift and Snowflake.
  • Generated rich data visualizations to communicate complex ideas to costumers or company leaders using Birst Software.
  • Developed shell scripts that run python code, save the .CSV file on s3 bucket and load the data into Amazon Redshift database and Snowflake.
  • Involved in migrating scripts from Teradata to Redshift and Snowflake.
  • Developed and implemented processes and tools for requirements gathering, analysis, planning, tracking and delivery using Microsoft Visio.
  • Designed and developed use case diagrams, activity diagrams, sequence diagrams, and class diagrams.
  • Involved in creating Entity-Relationship diagrams for the design of the database.
  • Analyzed data warehouse requirements and supported data ETL plan, data staging, and data quality plan.
  • Assisted QA Team in writing test cases, test plans and tested the final application to verify whether all the user requirements were catered to by the application.
  • Collaborated with the QA team to ensure adequate testing of software both before and after completion, maintained quality procedures and ensured that appropriate documentation is in place.
  • Supported in conducting Conference Room Pilot & User Acceptance Testing.
  • Conducted user interviews for requirements gathering, analysis, and design.
  • Communicate project status, current activities, risks, dependencies and achieved milestones to stakeholders.
  • Collaborate with cross functional teams and build schedules and plans, Identify and manage dependencies with other internal or external teams to align deliverables.
  • Improved team velocity and leveraged tools like burn downs and capacity modeling to ensure that the teams are efficient and productive and facilitated discussion, decision making, and conflict resolution.
  • Helped to prioritize user stories using MoSCoW and Planning Poker techniques.

Environment: Scrum, CA agile, MS Office Suite(2016),SQL, MS Project(2016), MS Visio(v16.0), JIRA, UML, My SQ, Python

Confidential, Boston, Massachusetts

Business Data Analyst

Responsibilities:

  • Understood state of art processes by interacting with stakeholders and documents analysis and performed GAP analysis to assist Product Owner and Project Manager in planning the transition.
  • Used Agile software development methodology in defining the problem, gathering requirements, development iterations, business modeling and communicating with the technical team for development of the system.
  • Facilitated JAD sessions as Moderator and conducted interviews with various Subject Matter Experts (SMEs) and stakeholders, process reviews and policy & procedure reviews to elicit requirements.
  • Prepared Business Requirement Document (BRD/HLD) and assisted preparation of System Requirement Specification (SRS). Analyzed, modified and validated these documents.
  • Created Use Cases and built Use Case Diagram and Activity Diagram using MS Visio.
  • Managed and tracked requirements using HP ALM through Application Life-Cycle.
  • Worked with QA team to design and develop Test Plan and Test Cases to perform User Acceptance Testing (UAT), Functional Testing and Regression Testing.
  • Assisted Data modeling process by creating conceptual and logical ER diagrams and designing database schemas to help development of an accurate Data Warehouse Structure.
  • Assisted in increasing Data Integrity by performing Data Normalization and adding Data Verification and Validity to maintain accuracy and effectiveness of data
  • Performed Data Mining to find correlation and pattern in existing data and constructed SQL queries.
  • Was involved in using Tableau for effective reporting to provide Business Intelligence (BI) to facilitate expenditure tracking using various matrices critical to decision making.
  • Involved in implementation by assisting in the preparation of training module. Helped the end users getting accustomed to the system by live demonstrations and system tutorials.
  • Timely tracked progress and reported it to Project Manager
  • Evaluate Provider level data to assess provider data quality, profiling the data and building data quality reports using DQ analyzer, SQL server, MS Excel.
  • Reviewed basic SQL queries and edited inner, left and right joins in Tableau Desktop by connecting live and extract datasets, VLOOKUP in Excel.
  • Building models in spark using python.
  • Used Microsoft Office suit to develop the documents such as Visio for creating wireframes, Word, Excel and Power Point for creation of Business Requirement documents.
  • Prepared the UML Use Cases using Rational Rose.
  • Reviewed Test Plans that contains test scripts, test cases, test data and expected results for the User Acceptance testing.
  • Facilitated all scrum ceremonies such as Sprint Planning, Daily Scrum, Sprint Review, Sprint Retrospective and Backlog Grooming.
  • Used JIRA to create and manage sprint and product backlogs, to track issues, trace requirements
  • Created Sprint Burndown and Release Burndown Chart to keep track of the team’s velocity and sprint progress for forecasting.
  • Shielded the team from various impediments and assisted the Product Owner in forecasting release plans by tracking the Team’s Velocity

Environment: Scrum, SAfe, MS Office (MS Word, MS Excel, MS PowerPoint), Tableau, MS Visio, Mock-Up Screens, SharePoint,AGILE, UML, Python

Confidential, Chevy chase, Maryland

Business System/Data Analyst

Responsibilities:

  • Assisted PM in creating work breakdown structure and project charter using MS Project.
  • Conducted extensive GAP analysis by identifying AS-IS and TO-BE process models and process flows, where, how and in turn help product owner to plan how to bridge the gap.
  • Elicited requirements involving vast set of interactions with various stakeholders using JAD Sessions, Structured Interviews, Process Analysis and Business Rules Analysis.
  • Analyzed feasibility of business requirements and defined scope, found out dependencies by interacting with Management Business Analysts, other Subject Matter Experts, Product Owner, Project Manager and Technical Lead.
  • Created a Macro Document incorporating components of Business Requirement Document and System Requirement Specification incorporating business, functional, non-functional, data and GUI requirements which would in turn serve as the centerpiece of the project.
  • Created Use Case Diagrams and Use Case Narratives and incorporated them in Macro Document.
  • Performed extensive prototyping using Mock-Up Screens and Tableau, Mock-Up Screens
  • Handled requirement churn during the project by performing Impact Analysis by checking the feasibility in maintaining the triple constraint and discussing them in daily Scrum.
  • Used JIRA for allotting tasks, user story writing, backlog management, issue tracking, user story management and forward and backward requirement traceability.
  • Defined Acceptance Criteria for User Stories to perform User Acceptance Testing. Designed Test Cases, Test Plans and Test Scenarios to perform Functional Testing, Smoke Testing and Regression Testing and logged down defects and systematically managed them in JIRA.
  • Used Tableau for generating reports.
  • Created SQL Queries for Portfolio Drill Downs to pull necessary data from data sources.
  • Considered change requests and documented issues, risks, gaps and impact. Provided business owner with information, documents and recommendations to take decision.
  • Supported for analysis and evaluation of data mining, data modeling and data sourcing in a data warehouse environment which included data quality, data controls, data design, database architecture, metadata, data marts and data governance in oracle environment.

Environment: MS Visio, MS Project, IDE, MS (Power Point, Excel, Word), SharePoint, Oracle 11g, Informatica, Tableau

Confidential

Business System/Data Analyst

Responsibilities:

  • Facilitated collection of requirements from system users and preparation of Business/Functional requirement documents utilizing UML to provide appropriate scope of work for technical team to develop prototype and overall system.
  • Analyze and prioritize requirements and use them to outline timeline for completion of goals.
  • Performed GAP Analysis with system functionality and existing Business Processes.
  • Used various UML diagrams for productivity in communicating specifications to design & development team. Analyzed and designed Use Case Diagrams using UML/Visio.
  • Managed scope and requirements throughout the project life cycle.
  • Responsible for resolving errors, generating client payment data, transmitting data to clients and ensuring conflict resolution utilizing MS Access, MySQL, Perl scripting and other various tools.
  • Worked extensively on SQL querying using Joins, Alias, Functions, Triggers, and Indexes.
  • Discuss and propose conversion / interface solutions with the clients and users.
  • Performed Functional Testing, Integration Testing, System testing and Regression testing.

Environment: Waterfall, SQL, MS Visio, MS PowerPoint, MS Excel, MS Word, MS Project, SharePoint, Tableau

Confidential

Business System/Data Analyst

Responsibilities:

  • Aligned information technology solutions to business initiatives and operational procedures
  • Translated manual business processes into automated processes
  • Conducted local and international training sessions on new procedures
  • Evaluated and revised executive compensation, allowance programs, fleet inventory, and international price books to correlate with business strategy
  • Lead internal teams to develop management reports defining problem, evaluation and solution
  • Develop yearly strategic projects development plans recommendations and spearhead development of Scope of Work,
  • Administered highway planning, construction, and maintenance, and reviewed and recommended and approved contracts and cost estimates
  • Arranged with the Enterprise Project Management Organization to define the project scope, funding approvals, and align
  • Using Salesforce in integrating departmental and brand-wise data to improve the efficiency of data analysis and reporting

Environment: Waterfall, MS Visio, MS PowerPoint, MS Excel, MS Word, MS Project, SharePoint, Salesforce

Confidential

Business System/Data Analyst

Responsibilities:

  • Involved in identifying the problem definition as part of continuous process improvement using Define, Measure, Analyze and Improve to support the business continuity of the organization.
  • Engaged in the migration analysis project with both business and IT stake holders
  • Engaged in defining business process on migration
  • Validate the process with subject matter experts and Business owners to ensure risks and impacts are well understood
  • Assembled a trained a team comprising of onshore and offshore resources for verification and validation of the site
  • Conducted requirements gathering session using elicitation techniques like user observation, brainstorming, client interviewing, document analysis and JAD Sessions with various stakeholders and project team.
  • Prepared Requirements Traceability Matrix (RTM) to trace the completeness of requirements.
  • Developed high-level and low-level documents like Business requirementsdocuments (BRD) and System requirements specification (SRS).
  • Defined frameworks for Operational data store (ODS), Brokerage data warehouse (BDW), Central file distribution (CFD) and Data Quality (DQ) and created functional data requirement (FDR).
  • Proficient in Data Analysis, Data Validation, Data Lineage, Data Cleansing and Data Verification
  • Developing appropriate documentation for various user and technical functions and using requirements for informative communication throughout the project life cycle.
  • Involved in enhancements and maintenance activities of the data warehouseincluding tuning, modifying of stored procedures for code enhancements.
  • Coordinated with the Business Objects developers in building universes and developed various reports like Cross Tab, Master Detail and different charts including Line, Column, Area, and Pie Charts for analysis.
  • Conducted Business workflow analysis, process analysis, SWOT analysis,cost-benefit analysis and Gap analysis to know the condition of the current process in use.
  • Used Unified Modeling Language (UML) to prepare Use Cases diagrams, process flow diagrams, sequence diagrams from the gathered requirements and created diagrams using MS Visio.
  • Created SQL-Loader scripts to load legacy data into Oracle staging tables and wrote SQL queries to perform Data Validation and Data Integrity testing.
  • Used various SQL commands like Create, Delete, Update, and Inner, Outer, Left, and Right Joins to update the database and retrieve data for data analysis and validation.
  • Involved in Data Mining, dimensional Modeling, ETL process, OLAP operations like rollup, drill down, slicing/dicing, pivoting using BI tools and Business Intelligence Reporting using Tableau.
  • Involved in Project Management activities like defining/managing project scope, schedulemanagement

Environment: Waterfall, Windows 7/Vista/8, MS Office Suite (Word, PowerPoint, Excel, Outlook), MS Project 2010, Visio, UML, SharePoint 2010, SQL Informatica, SQL server

Hire Now