Business Intelligence Analyst Resume
Mountain View, CA
SUMMARY
- Business Systems Analyst/Data Analyst with experience in banking and tech industry with demonstrated track record of consistently combining financial leadership and technical skills with sound business practices to position companies for long - term growth and profitability.
- Skilled in determining system requirements and specifications for complex application development projects.Past experiences of leading and interacting with business teams, programmers and technical staff at all levels.
- Experience working with Tableau Desktop, Tableau server, Tableau online and Tableau reader.
- Knowledge in the ETL (Extract, Transform and Load) of data into a data warehouse/data mart and Business Intelligence (BI).
- Experience in design and creation of database and database schema.
- Experience building dashboards and visualizations using bars, lines and pie charts, maps, scatter plots, bubbles, histograms, bullets, heat maps and highlight tables.
- Proficient in trouble shooting and performance tuning of reports within Tableau server.
- Excellent Knowledge of Software Development Life cycle (SDLC) and ability to work as a liaison between business users and developers.
- Hands on experience writing SQL Queries for Data Validation and Data Integration.
- Extensive experience with Data Analysis on Data warehouse system for various reporting systems within an organization.
- Strong domain/ functional knowledge of the Financial/ Banking. In addition, have outstanding business communication skills.
- Skilled in developing Use Case diagrams, Sequence diagrams, State Chart diagrams, and Class diagrams.
- Strong ability to elicit, document, validate and transform business requirements at different stages of software development life cycle.
TECHNICAL SKILLS
Databases: Oracle (8i, 9i, 10g), Access, SQL Server, Teradata
Modeling Tools: MS Visio, Rational Rose, Enterprise architect
Management Tools: Requisite Pro
Operating systems: MS Windows, UNIX, Linux, Ubuntu
Reporting Tools: Tableau (10.2, 10.3, 10.4)
Project Management Tools: MSProject, SharePoint, MS Office Suite, MS Visio, Jira, Rally
Languages and Methodology: HTML, SQL,Agile, Waterfall, RUP, Scrum
Testing tools: Quality Center, QTP
Software: MS Office Suite (Word, Excel, Access, PowerPoint and Outlook), Confidential Spreadsheets and Slides
PROFESSIONAL EXPERIENCE
Confidential - Mountain View, CA
Business Intelligence Analyst
Responsibilities:
- Investigate a multitude of issues pertaining to GSX deliverables, identify trends, and resolve root causes.
- Automate manual processes by creating workflows and dashboards for reporting.
- Pulled data from various sources like Excel, Redshift, MySQL, SQL Server and Oracle to build dashboards.
- Developed different visualizations using bars, lines, scatter plots, bubbles and histograms based on the requirements.
- Simultaneously supporting various products by providing analytical insight and performance analysis.
- Worked on groupings to rollup products to their specific lines of business for reporting.
- Worked closely with UX and the business teams to deliver the desired functionalities for the reports.
- Present new process and process improvement proposals to management.
- Create sales summary reports and data quality reports to provide management teams with clear insights into drivers of business, risks and opportunities.
- Automated the deployment process, software backup and provided extract failure alerts to the production support teams.
- Responsible for product assortment by ensuring that product data is configured with accurate information.
- Monitoring and removing any products that violate policy or that cannot be fulfilled due to logistical constraints.
- Develop analysis/tools to track business growth for the products to better understand the drivers of that business growth.
- Drive visibility into business performance and resource planning decisions; and manage the respective teams’ results, including development and maintenance of datasets and dashboards.
Environment: Goobuntu (Linux distribution based on Ubuntu), Tableau Desktop, Tableau Server, Dremel, Confidential Cloud SQL, F1 SQL Server, Spreadsheets
Confidential - San Francisco, CA
Business Systems Consultant
Responsibilities:
- Acting as a liaison between client areas and the technical organization, responsible for planning, conducting and directing the analysis of highly complex business problems requiring automated solutions.
- Defining and documenting technical requirements, system and process documentation along with the creation and execution of test plans and scripts for both applications and processes.
- Designing system tests by partnering with technical and business resources to ensure that project requirements are fulfilled on properly. Extensive use of Teradata SQL assistant as an integral software in data gathering, data analysis, data validation reporting.
- Involved in data blending for pulling the required data for reporting
- Worked on analyzing the Tableau server at site, workbook, and user level. Developed reports regarding usage of different workbooks by the users for various sites in the Tableau server.
- Connected the Tableau server to publish dashboards to a central location for portal integration.
- Connected the Tableau server with the sharepoint portal and setup auto refresh feature.
- Use SQL querying to analyze the data in the automated system for activities like requirements management and testing.
- Monitoring the daily data flow batch through the systems by inspecting the extract tables and views through SQL query.
- Ability to gather information and create both business and technical requirement documentation, as well as drive the requirements process with both technical and business partners.
- Build small databases in Teradata to support prototyping, analysis, data management and reporting.
- Demonstrated experience with project management.This includes the ability to create project plans and manage deliverables against timelines.Organization, planning and meeting management experience are required.
- Demonstrated experience working with ambiguity and building new procedures and programs from the ground up utilizing best practices from various areas and applying consistent solutions.
- Demonstrated successful written and verbal communication skills.This includes the ability to synthesize data to present information to senior level management.
Environment: Teradata, Tableau Desktop, Tableau Server, SQL Assistant, Clearquest, CIM (Customer Interaction Manager), ME (Marketing Exchange), MS-Visio, MS Project, MS Office, ETL.
Confidential - New York, NY
Senior Business Systems Analyst/Data Analyst
Responsibilities:
- Involved in gathering Business Requirements from users and used Requisite Pro for documenting the requirements.
- Prepared custom reports and performed SQL query, data analysis and verification on MS Access.
- Prepareddashboardsusing calculations, parameters, calculatedfields,groups, sets and hierarchies in Tableau.
- Foundefficientways to make tables and graphs which were visually easy to understand and at the same time maintaining the accuracy of the core content.
- Created complex store procedure and views for several reporting services report and scheduled procedure through SQL agent jobs as per the data requirement.
- Utilized a variety of reporting tools such as SQL and ACCESS for querying underlying database tables and resolve data issues.
- Involved in data blending for pulling the required data for reporting
- Worked on analyzing the Tableau server at site, workbook, and user level. Developed reports regarding usage of different workbooks by the users for various sites in the Tableau server.
- Worked with the Subject Matter Expert for Data warehouse in Banking Space.
- Utilized a variety of reporting tools such as SQL and ACCESS for querying underlying database tables and resolve data issues.
- Extensively involved to deliver Ad hoc reports to various departments and clients.
- Prepared status summary reports with details of executed, passed and failed test cases.
- Responsible for the development and maintenance of the Gap Analysis documentation utilized by the entire Project Team to define the scope of work and create the functional specifications from the business requirements.
- Created test plans, test cases and scripts, managed the full testing life cycle including Integration, Regression, and Database testing.
- Actively trained Business Users involved in User Acceptance Testing (UAT) and helped them understand UAT procedure.
Environment: Oracle, SQL, UML,Tableau Desktop, Tableau Server, Rational Requisite Pro, SQL Navigator, MS-Visio, MS Project, MS Office, ETL, Informatica Power Center
Confidential - Hayward, CA
Business Data Analyst
Responsibilities:
- Analyzed User Requirement Document, Business Requirement Document (BRD), Technical Requirement Specification and Functional Requirement Specification (FRS).
- Interacted with the executives and development team to liaison the business requirements to ensure that the proposed upgraded application complies with the business requirements.
- Conducted JAD sessions with SME including business owners, sponsors and analysts.
- Utilized a variety of reporting tools such as SQL for querying underlying database tables and resolve data issues.
- Built templates and dashboards for customized views of the data specific to each group and line of business.
- Managed Requirements, Test Plans, and Test Cases using Test Director/Quality Center.
- Performed ad hoc reporting for special requirements and demands.
- Participated in the Logical and Physical Design sessions and developed Design Documents.
- Designed and implemented basic SQL queries for QA Testing and Report / Data Validation.
- Partnered with the Technical Areas in the research and resolution of System and User Acceptance Testing.
- Develop User Manuals, and Training Manuals as per Project Specifications and timelines.
- Responsible for providing analytical support in the Design, Development and Implementation of Project.
Environment: SQL/Server, Oracle 9i, MS-Office,Teradata, Informatica, ETL, ER Studio, XML, Business Objects