SUMMARY

Motivated and results-driven Data Analyst with proven track record in providing analytical solutions and report generation. Over 10+ years of professional experience and ability to identify business reporting needs and develop reporting solutions with high accuracy and efficiency. Possess outstanding client interaction and relationship management skills with excellent Communication and Presentation skills

PROFESSIONAL EXPERTISE

•In-depth knowledge on SDLC, Waterfall and Agile development frameworks.

•Extensive experience in creating Business Requirement Documents(BRD), Functional Requirement Document(FRD) and Use Case Documents.

•Created and maintained Responsibility Assignment Matrix and Requirements Traceability Matrix (RTM).

•Report Generation - Oracle Financials, Business Intelligence, MS Office(MS Word, Excel, Powerpoint and Access)

•Tableau - to create Dashboard

•Data quality assurance processes & Data Validation in Oracle Financials tool(ERP)

•Worked on reporting and quality analysis: data integrity, test design, analysis, validation, and documentation.

•End to end testing. Functional and non functional testing includes SIT & UAT.

•Data extraction and analysis using SQL queries on Teradata, Snowflake

•Project Management(PMO)

•Interpersonal communication

•Defect Tracking

•Proficient in using MS Word, Excel, PowerPoint for managing documents electronically.

•Strong Interpersonal Skills in interacting with SME's, Stakeholders and Senior Management

BUSINESS DATA ANALYST, WELLS FARGO,

FREMONT — MAY 2023 – SEP 2023

•Lead project or systems documentation and monitor and manage project schedules and deliverables.

•Collaborate and consult with business and technology teams to provide comprehensive technological solutions for complex business problems.

•Ensure communication and information flow between business and technology teams.

•Lead and execute pre-production and production testing for new releases.

•Proactively identify risk issues and work with relationship managers and senior risk officers to develop, document, and implement action plans.

•Ensure complete, accurate, and timely documentation of customer data within the customer risk management system.

•Stakeholder Coordinator: Coordinates with data stakeholders to gather the datasets required for analysis

•Engaged Communicator: Communicates analysis results in terms of business insights and leverages them for team decisions

•Analyzes, validates, and documents business processes and system requirements using standard Business Analysis tools and methodologies for the development or procurement of software systems.

•Develops and maintains data for measuring current operations, including designing queries and developing reports.

•Supports the development and distribution of ad-hoc reports, ensuring appropriate data documentation and preparation.

•Identifies queries and reports to assist in managing operations, analyzing data for validity concerns and communicating findings.

ToolsUsed: MS Office, Google Suit, SQL, Tableau, Confluence, Jira

BUSINESS DATA ANALYST, BERKELEY LABS,

BERKELEY — MAR 2022 – MAR 2023

•Analyze data and work on problems of diverse scope and provide detailed, through well documented reports.

•Identifying trends and patterns, data-driven decisions, Finding correlations and relationships, Detecting anomalies, Improving performance, and Predictive modeling

•Support the evaluation and analyses of inconsistencies of reported system problems by assisting division staff with problem solving and resolution.

•Supports the design and analytical aspects of reports requested by division staff, leadership teams and external customers.

•Uses databases to run reports and run queries using SQL or other Oracle tools.

•Acquire data from primary and secondary data systems (i.e., Maximo, Data Warehouse) and provide users with detailed information needed to support business needs.

•Create reports for internal teams and/or external clients to include the visualization of data that is used to support divisional goals and objectives.

•Create KPI metrics to track the status of business process.

•Work with functional staff and IT to ensure major enhancements and re-engineering initiatives are effectively launched and executed to meet expectations.

•Monitor Facilities Systems performance; troubleshoot complex business processes and system issues to ensure business operations are minimal impacted.

•Support the development and execution of test plans to ensure systems changes conform to design, coordinate.

•User acceptance, testing, and maintain testing issues log.

•Create custom business requirements and reports in order to support the business system team with goals and objectives.

•Work with IT to apply, test and verify fixes/patches to support facilities systems.

ToolsUsed: MS Excel, MS Word, MS Power Point, MS Access, Google Suit, SQL, Maximo

BUSINESS DATA ANALYST, FIRSTTECH FEDERAL CREDIT UNION BANK,

SAN JOSE — JUN 2021 – DEC 2021

•Worked in the EDA – COE team on the EDW Data Migration project.

•Involved in the end-to-end process, starting for requirement gathering and planning, support throughout the development process, User acceptance testing, and post-production support.

•Worked on Testing and documenting several UAT tickets assigned using Jira.

•Worked on several Business stories related to Post Production KTLO Support.

•Worked very closely with the Product Manager to set new standards and documentation for the EDW system.

•Liaison between the business and technical teams in terms of assisting the translation of business requirements in an agile method of development .

•Created Various Source to Target Mappings for Tableau Dashboard.

•Performed Gap Analysis between the EDW system and Tableau Dashboard after the end of each sprint and created mappings to close the same.

•Used the Agile Methodology for the Software Development Life Cycle (SDLC).

•Worked on the data quality project to ensure consistency across the EDW system.

•Extracted the data from a data warehouse (Snowflake) to create ad-hoc reports and graphs according to Business needs.

•Data mapping, logical data modeling, and used SQL queries to filter data in databases such as Snowflake.

•Performing ad-hoc deep dives into our data to analyze data quality issues and present meaningful insights and Visualizations.

•Provide analyst support during all phases of the Software Development Life Cycle including development and testing (unit/system) phases.

ToolsUsed: Ms Excel, MS Word, MS Power Point, MS Access, Snowflake, SQL

BUSINESS DATA ANALYST, BLOUIN ART-INFO,

NEW YORK, US — JUL 2017 - FEB 2021

•Acquire data from primary or secondary data sources and maintain databases/data systems Validate the data and maintaining into database.

•Managing Sales data of all auction houses across US and other countries.

•Preparing Sales targets and metrics dashboards.

•Collaborated with multiple stakeholders/vendors to implement a new project management system. Led the requirements gathering process and worked closely with the vendor's development team to ensure the system met our needs.

•Hands-on experience developing and documenting process flows, methodologies, and analytic techniques; ability to guide and train others in those processes, methodologies, and techniques.

•Provided guidance to all support teams within the project and technical teams.

•Worked with the business and functional users to analyze client’s requirements. Identified challenges within the project and devised solutions in conjunction with technical staff.

•Automating reports in excel using different functions and lookups.

•Accurately analyze and collect data for various types of business reports.

•Support the improvement of the data collected by making sure issues and problems are communicated and worked through.

ToolsUsed: Ms Excel, MS Word, MS Power Point, MS Access, Rally (defect logging and Agile board), Sharepoint, draw.io, My SQL

BUSINESS DATA ANALYST, ACCENTURE - NAB,

BENGALURU — FEB 2009 - SEP2015

•Manage day-to-day aspects of a formal Agile/Scrum process, including leading Agile meetings (backlog, planning, review, retrospectives, and daily stand-ups).

•Provided actionable insights for executive stakeholders on Top selling insurance products.

•Quality analysis on Data integrity and validations, monitor ETL jobs.

•Produced yearly, quarterly, monthly, weekly and daily reports using advanced Excel spreadsheet functions.

•Created dashboards using excel and tableau. Presented the finding to the business stakeholders and identified the areas of process improvements.

•Recommended report standardization and prepared run books for producing reports.

•Interpret data from primary and secondary sources using statistical techniques and provide ongoing reports.

•Worked with collaboration tools like Sharepoint, Confluence

•Extracted, compiled and tracked data, and analyzed data to generate reports.

•Data Quality & Maintenance

•Management Reporting/Funds flow reports - Sales forecasting for goal setting, using past data and indicators.

•Provided support in triage, troubleshooting, root cause analysis and resolution including reporting and monitoring.

•Change Control, User Acceptance testing & Prioritization of Enhancements.

•Analysis, Data cleansing, Storage management, System Reconciliations (confirms completeness & accuracy of deliverables).

•Problem analysis, Prioritization, Resolution

•Scheduling (Eg. Month end timetable, daily operations), Configuration & Maintenance, user access security & Provide user training.

•Provide input & participate in testing Business Continuity Plan.

•Aptitude for understanding business environment and translating business requirements to technical solutions

ToolsUsed: Oracle Financials, Ms Excel, MS Word, MS Power Point, MS Visio, PLS (problem logging system), Radar (incident management), Sharepoint, Confluence, Teradata SQL, BI reporting tool

PMO, ACCENTURE - WACHOVIA (WELLS FARGO),

BENGALURU — OCT 2007 - FEB 2009

•Top Projects Report – Project & Resource Management.

•Quality Check and Reports Delivery.

•Prepare Standard Operating Procedures and Templates in Sharepoint.

•CIMS is a group of monthly reports used to gather and analyze current & evolving information to improve service, customer satisfaction & reduce unit costs.

•Time Entry non compliance reports – Weekly, monthly & yearly - this report is sent to the employees who have not logged time reminding them to submit the timesheet to the managers to approve it.

•Playbook is a monthly compilation of reports such as Dashboards, Org Charts, Headcount Rosters, Financials, and Capacity Plans.

•Metrics Reporting is a monthly compilation of reports such as Resource Allocation and Utilization, Forecasted Spend and Budget Variance, Customer Satisfaction Survey, Headcount Roster using cognos.

•Maintain and update project status dashboard & Project resource tracking system

ToolsUsed: Ms Excel, MS Word, MS Power Point, MS Visio, Sharepoint, Cognos Reporting tool

TECHNICAL SUPPORT ENGINEER, SITEL,

BENGALURU — FEB 2007 - SEP 2009

•Providing technical support on Connection and Browsing issues on internet to US clients.

•Maintain composure and patience with difficult customer interactions.

•Focus on Monthly SLA and CSAT Targets & Participated in all the team activities.

•Researched and documented issues on various computer systems and databases to solve complaints.

EDUCATION

•Bachelors in Computer Science, Bangalore University - 2000 - 2003.

SHILPA BALARAJ

408-***-**** ad3n5l@r.postjobfree.com Fremont, CA

Contact this candidate