Business Data Analyst Resume
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