We provide IT Staff Augmentation Services!

Business Data Analyst Resume

3.00/5 (Submit Your Rating)

San Leandro, CA

SUMMARY:

  • Over 9 years of experience as a Business Analyst with exposure to various domains such as Finance, Health & Safety, Telecommunications and Banking.
  • Motivated Business Analyst with the technical expertise and business acumen necessary to translate business requirements and objectives into scalable, highly resilient and successful system solutions.
  • Professional experience in working on web development technologies.
  • Experience in working with various SDLC methodologies like Waterfall, Agile (Scrum).
  • Good understanding of data models, ETL, metadata, data mapping and data flow process.
  • Perceptive and logical data analyst with the proven ability and experience in Business Data profiling, Data Cleansing, Data Analysis, Data validation and creation of reports.
  • Proficient in interacting with stakeholders, Requirement gathering through interviews, workshops, and existing system documentation or procedures, defining business processes, identifying and analyzing risks using appropriate templates and analysis tools
  • Experienced on business and systems requirements, data validation and process improvement.
  • Experience in conducting GAP Analysis between the "As - Is" and the "To-Be" process.
  • Proficient in drawing UML Diagrams like Use case, Activity, Swim-lane and Data flow diagrams using MS Visio.
  • Experienced in developing User Stories, Wireframes/Prototypes and Data mapping .
  • Proficient in creating Business Requirements Documents ( BRD ) and Functional Specifications Document ( FSD/FRD ).
  • Experienced in writing SQL queries to extract data and perform data verification and validation.
  • Created Requirement Traceability Matrix (RTM) to trace requirements and manage Change Requests.
  • Expertise in developing Test plans, Test cases, analyzing defects, performing User Acceptance Testing (UAT).
  • Experience in providing training and production support to end users for new and enhanced applications.
  • Conducted demo session, walk through and tackle with change management process.
  • Created reports using pivot tables and templates using MS Excel and VB Macros.
  • Good understanding with Defect and change management process.
  • Ability to coordinate effectively between onsite and offsite teams across all phases of the project.
  • Excellent leadership skills and team building with good knowledge in scheduling meetings, resource allocation, and maintaining the project schedules.
  • Not afraid to fail, played multiple roles, good inter-personal skills, liaison between business and tech team
  • Enjoy making quilts and various sewing projects

TECHNICAL SKILLS:

Database: MS SQL Server, Oracle, MySql

Analytical Tools: MS Excel, VBA, Tableau, Toad, Workbench, SQL Server Management Studio, Google Analytics, SAP EPM

Languages: SQL, VBA Macros, C# .Net, Swift, HTML, XML, Apex (Salesforce)

Modeling Tools: MS Visio

Wireframing tools: Balsamiq, Axure, JustinMind, PowerPoint

Source safe tools: VSS, SharePoint, Documentum

Quality/ticketing tools: HP ALM

PROFESSIONAL EXPERIENCE:

Confidential, San Leandro, CA

Business Data Analyst

Responsibilities:

  • Development of Business rules using SQL and Infomatica.
  • Performed extensive data discovery and data analysis tasks to identify invalid, missing and inconsistencies in data.
  • Conducted data quality activities such as analyzing the data, understanding data models
  • Supported the data warehouse team to solve inconsistencies and anomalies in source data as part of ETL process
  • Comparing and identifying data problems using excel functions and techniques.
  • Defining visualization models in Tableau
  • Determining Business impact of the data quality issues and communicating it the end users.
  • Logging data issues and maintaining Product Backlog
  • Co-ordination with Tech, QA and Prod support to concur on backlog item priorities.
  • Liaised with business to understand loan processes and customer/borrower data
  • Conducted user interviews, gathered requirements.
  • Reviewed and suggested ways the team could reduce efforts and work efficiently.
  • Setting up UAT activities, documenting test cases and training business users on logging UAT results
  • Tracking defects for priority and solution to be achieved
  • Designed dashboard mockups and reporting models
  • Helped identify root cause of defects and suggested corrective action.
  • Conducted validation of SQLs scripts

Environment: Asp.Net, Oracle SQL developer, MS SQL Server Management Studio, MS Excel, MS SharePoint, HP ALM, Ab Initio, Informatica, Tableau

Confidential, Walnut Creek, CA

Business Solutions Analyst

Responsibilities:

  • Used SharePoint to introduce process automation which eliminated manual tasks & ensure that users adhere to deadlines for timely delivery of Leadership reports.
  • Developed dashboards with key sales KPI’s like EDI Sales Performance, Invoice Sales Performance
  • Developed Templates to gather actual & estimated expenses for each department which would automatically create Budget Vs Actual Report.
  • Conducted Data collection and analysis for Operational Expenses reporting
  • Reconciled Sales data extracted from different sources and build level dashboards to measure performance of individual distributors
  • Performed data Analysis using SAP EPM for Microsoft platform for Excel.
  • Identified opportunities to improve process efficiency of sales reporting by improving communication by setting up automatic alerts in SAP between Sales department and Finance department.
  • Organized requirements meetings and data mapping sessions with end users to understand business needs for new Performance dashboards
  • Migration and testing of reports to Tableau interactive reports.
  • Created and standardized on-boarding process and training documentation for Finance department.
  • Led UAT, setup the UAT environment, gathered necessary approvals, trained end users to document test results, created UAT training material.

Environment: Oracle JD Edward, SAP, MS Excel, MS Visio, MS SQL Server Management Studio, Tableau

Confidential

Web Analyst

Responsibilities:

  • Certified in Google Analytics
  • Configured Google Analytics to receive customer visit information
  • Provided data and reports for various customer behavior transactions
  • Helped provide data insights for improving user experience, convert to a sale ratio, etc.
  • Provided WordPress tool support for fixes as required

Confidential

Business Analyst

Responsibilities:

  • Implemented Value Added Processes (VAP) to improve data transformation.
  • Requirement gathering and Documentation of Reporting process for HS&E (Health, Safety & Environment) for 25 functional groups of Confidential .
  • Created data mapping for moving data to data warehouse
  • Good understanding of data flow and ETL process
  • Coordinated with client and end users for understanding and standardizing key KPIs.
  • Defined key metrics for charts related to Safety incidents and action items
  • Identified, defined and assessing the feasibility automation.
  • Improved process efficiency by 33%
  • Provided detailed analysis and trends for key KPIs to support new global projects and initiatives.
  • Played key facilitation role between Confidential Brisbane office and all locations of Confidential corporate offices spread across the world.
  • Responsible to document requirements for Incident Management and GHG reporting modules in the EHS solution
  • Responsible for creating FRD, User stories, Wireframes and requirement walk through sessions.
  • Developed reports for key metrics like AIFR (All Injury frequency rate), LTIFR (Lost time Injury Frequency Rate), Near misses.
  • Administered and trained users of HSE Management portal.
  • Software developer and module lead, worked on creating web applications.

Environment: SAP, Oracle, Asp.Net, C#, MS CCF, MS SQL, Asp.net, MS Excel, Tableau

We'd love your feedback!