LiveCareer-Resume

senior business analyst resume example with 7+ years of experience

Jessica Claire
  • Montgomery Street, San Francisco, CA 94105 609 Johnson Ave., 49204, Tulsa, OK
  • Home: (555) 432-1000
  • Cell:
  • resumesample@example.com
Links
  • https://www.linkedin.com/in/Jessica-Claire/
  • https://github.com/Jessicabhave
  • https://public.tableau.com/profile/Jessica#!
Professional Summary

Senior Business analyst and outstanding performer in business intelligence and data science within Finance industry. Proven success in leadership, operational excellence and organizational development with keen understanding of elements of data engineering and business systems. Recognized for inspiring management team members to excel and encouraging creative work environments.

Skills

Business intelligence Tools: Tableau, Qlik Sense, Qlikview, Data Studio, PLX, Power BI, Looker, MS Excel, Google sheets, Data Studio

  • Reporting Tools: SSRS, Crystal Reports, BIRT Report Designer, PLX,
  • Agile Development tools: GIT, SVN
  • ETL Tools: Informatica PowerCenter, Pentaho, SSIS, Oracle
  • OS: Linux, Unix, MacOS, Windows, ChromeOS
  • Data Modeling: Oracle SQL Developer Data Modeler, ER/studio, Erwin Data Modeler
  • Languages: Python, JavaScript
  • Databases: Oracle, MS SQL Server, ANSI SQL, Google BigQuery
  • IDE Tools: SQL developer, Toad, Eclipse, Visual Studio Code
  • Key Areas: Data Analysis, Business Intelligence, Strategic Planning, Predictive Modeling, Data Modeling, Data Mining, Data Warehousing, OLAP, Data Science, Forecasting and Planning, Business Process Mapping, Competitive analysis, Technical writing, Analytical Problem Solving, Software Engineering, Software Development, Business Analysis, Strategic Planning, Critical Thinking, Customer Service, Communication Skills, Written Communication, Analytical Skills
Work History
Senior Business Analyst, 06/2019 to Current
UnisysNewark, DE,
  • Translate business needs to technical specifications and compose the SQL queries to mine the essential data from the data warehouse.
  • Lead the ETL development team to modify pipelines for data extraction of entities if required.
  • Support the creation of single source of truth for performance monitoring leveraging agreed upon data definitions, create a common data foundation, and semantic layers to be consumed by business.
  • Deliver highly available, reliable, innovative large-scale data warehousing solutions to facilitate data induction, build optimized aggregates and building reporting solutions.
  • Provide leadership and expertise to define solutions architecture and strategies at all layers, for next generation reporting platform with high performance and scalability.
  • Unleash data trends and provide useful insights to the business users by developing various statistical reports and dynamic dashboards using BI tools like Tableau, Data Studio, PLX.
  • Improve the timeliness for product delivery by following Agile product development methodology.
  • Assigned tasks to associates, staffed projects and updated all involved parties to enhance optimal business flow.
  • Synthesized current business intelligence data to produce reports and polished presentations, highlighting findings and recommending changes.
  • Plan, review and support process and systems change configurations and customization requests
  • Technologies Used: Standard SQL (Google BigQuery), Tableau, Data Studio, PLX, Google sheets, Clarinet, Pentaho.
Business Analyst, 08/2015 to 05/2018
Western Alliance BancorporationBoston, MA,
  • Capturing and documenting requirements, understanding business impacts and tradeoffs, conducting interviews and workshops, proposing solutions, documentation and process mapping, etc.
  • Lead developers mine, cleanse, transform data from Oracle database and other static data sources.
  • Normalize and manage data storage in a data warehouse.
  • Regulate extraction, transformation and loading processes on data to automate data flow from data source to data warehouse and from data warehouse to the end user reports.
  • Optimize the ETL process with use of bulk inserts, indexes, query hints and other performance tuning techniques.
  • Identify patterns, attribute hierarchies and data relationships and organize into data dictionaries, create standardized definitions for metrics and critical metrics.
  • Implement predictive analytics and linear regression using python to uncover meaningful data insights
  • Highlight data analytics trends and KPIs by developing and designing visually appealing dynamic dashboards using Tableau and Qlikview.
  • Reduce dashboard response time by working on optimization techniques to improve availability of dashboards and reports.
  • Technologies Used: Tableau, Oracle, Erwin Data Modeler, Tableau Prep, GIT, Python, SQL developer.
Business Intelligence Engineer, 04/2014 to 07/2015
Amazon.Com, Inc.Smithfield, RI,
  • Work with product owners for requirement gathering. Analyze and validate the business requirements and create Business requirement documents.
  • Develop Informatica ETL workflows and transformations for data extraction from relational database to reporting and analytical tools.
  • Deep dive the extracted data and list down the statistical KPIs to be included in analytical reports and discuss with management to effectively add them in upcoming dashboards.
  • Evaluate and improve existing reports to reduce end user response time.
  • Lead ongoing reviews of business processes and develop optimization strategies.
  • Provide technical guidance, direction and problem solving to engineering team members. Drive technical excellence in software development and solution design.
  • Improve development methodologies over time. Engage with architects, engineers, BI developers across regions and departments to deliver the program.
  • Researched, designed and implemented scalable applications for information identification, extraction, analysis, retrieval and indexing.
  • Technologies Used: Tableau, Qlikview, Informatica Power Center, Oracle, SQL developer, MS Excel.
Data Engineer, 04/2012 to 04/2014
Apex SystemsAustin, TX,
  • Partner with business users for requirement elicitation and gain functional knowledge of the insurance industry.
  • Architect the data model for new schema and design the schema for data science requirements.
  • Develop ETL using oracle PL/SQL packages, procedures to extract data into data warehouse.
  • Optimize the SQL code by analyzing the explain plan and using query Hints to change default query execution plan.
  • Develop various statistical and analytical dashboards which focus on major business KPIs and help to establish insights and forecast trends of data over a time period.
  • Assessed platform statistics to create customized, data-intensive BI analytics.
  • Design Qlik Sense dashboards and manage Integration of dashboards across different projects.
  • Define and drive programs and projects relevant to the delivery of BI, reporting, and analytics capabilities.
  • Monitored assessment software for performance, security and database availability throughout lifecycle.
  • Technologies Used: Qlikview, Qlik Sense, Oracle, SSRS, Crystal Reports, Toad, SQL Developer Data Modeler.
Education
Bachelors: Computer Engineering, Expected in 06/2011 to Mumbai University - ,
GPA:
Certifications
  • Oracle Certified Associate
  • ALMI- Level-1 Insurance Domain Certification
,

By clicking Customize This Resume, you agree to our Terms of Use and Privacy Policy

Your data is safe with us

Any information uploaded, such as a resume, or input by the user is owned solely by the user, not LiveCareer. For further information, please visit our Terms of Use.

Resume Overview

School Attended

  • Mumbai University

Job Titles Held:

  • Senior Business Analyst
  • Business Analyst
  • Business Intelligence Engineer
  • Data Engineer

Degrees

  • Bachelors

By clicking Customize This Resume, you agree to our Terms of Use and Privacy Policy

*As seen in:As seen in: