We provide IT Staff Augmentation Services!

Business/data Analyst Resume

Elsegundo, CA

SUMMARY:

  • About 6 years of experience in Software Application Analysis, Design, Development and implementation of web applications.
  • Experience as a Business Analyst and Reporting tools (Tableau, SSRS, Power Pivot).
  • Experience in Managing and Implementing Agile methodologies and Software Development Life Cycle utilizing Jira, Rally.
  • Experience in Confidential Analytics and Confidential Tag Manager. Suggested improvements for tracking, reporting and analysis of performance.
  • Assessing the effectiveness of User Stories implemented and updating the plan on the go using problem solving techniques based on the availability of the team.

SKILL:

Agile and Waterfall: Rally and Jira

Databases and Query Languages: Oracle, Confidential Big Query

Graphical User Interface Tools: Visual Studio, ASP.NET

Programming and ObjectOriented Languages: Java, Perl, VB.NET

Reporting Tools: Tableau, SSRS, Power Pivot, Microstratergy

Analytics Tool: Confidential Analytics and Confidential Tag Manager

EXPERIENCE:

Confidential, ElSegundo, CA

Business/Data Analyst

Responsibilities:

  • Provide analysis and reporting around all the Financial and accounting data using various tools (SQL, SSRS, and Tableau.
  • Manage monthly accounting close efforts, including revenue and deferred revenue account reconciliations, financial audit support etc.
  • Define reporting requirements for new business verticals and translate into technical requirements
  • Support Confidential Analytics and Confidential Tag manager requests
  • Support brand specific adhoc requests
  • Provide quarterly audit support for accounting
  • Assisted the manager on product backlog by documenting the user stories
  • Assisted in providing with cross - functional knowledge to developers and business users
  • Developed end user modules for the user about the new system

Environment: SSIS, SQL Server, Tableau, Power BI, Snowflake, Confidential Analytics, Microstratergy, SSRS

Confidential, Long Beach, CA

BI Developer

Responsibilities:

  • Created ad-hoc queries and reports as requested and provide on-going analytical support and maintenance for these requests
  • Creating and maintaining SQL Server Analysis Services tabular models and SQL Server Reporting
  • Services reports in addition to other BI technologies within the full Microsoft SQL Server stack environment
  • Work with the business and team to design dimensional models and architect data warehouse enhancements
  • Developed parameterized reports and dashboards through Reporting Services from a variety of transactional and data warehouse data sources including Analysis Services Cubes and prepare for online deployment
  • Determine testing needed to assure the functionality and integrity of reporting solutions, create test plans, and evaluate testing results taking corrective action as necessary
  • Converting existing legacy reporting products and tools to a standardized reporting infrastructure using SQL and Microsoft products
  • Created Business Intelligence (BI) dashboards, scorecards and other visualizations using multiple technologies including Microsoft Power BI, Power View, Power Pivot
  • Analyze fact, dimensional and hierarchical data to meet appropriate drill down, drill through and decomposition requirements
  • In conjunction with data owners and department managers, developed data models and protocols for analyzing production databases to produce advanced, meaningful, and actionable business insights
  • Support the transfer of knowledge to team members as appropriate

Environment: Visual Studio, SQL Server, Tableau, Power BI, MS Office Suite (Word, PowerPoint, Excel, Outlook)

Confidential, Alexandria, VA

BI Developer

Responsibilities:

  • Coordinated with the DW architects and developers to identify appropriate dimensional modelling, measures and sizing.
  • Used various SQL commands like Create, Delete, Update, and Inner, Outer, Left, and Right Joins to update the database and retrieve data for data analysis and validation.
  • Used Unified Modeling Language (UML) to prepare Use Cases diagrams, process flow diagrams, sequence diagrams from the gathered requirements and created diagrams using MS Visio.
  • Extensively used Tabadmin and Tabcmd commands in creating backups and restoring backups of Tableau repository.
  • Organized the Software Design Document and Operational Guide made changes and updates.
  • Developed insightful dashboards, and delivery of solutions adhering to BI industry best practices.
  • Organized the SDD and Operational Guide made changes and updates
  • Assisted the Quality Assurance Lead in the execution of reports and data integrity testing.
  • Designed and implemented basic SQL queries for reports / data validation
  • Utilized advanced features of Tableau to link data from different connections together on one dashboard and to filter data in multiple views to analyze the status of the tickets

Environment: MS Office Suite (Word, PowerPoint, Excel, Outlook), MS Project, Visio, UML, SharePoint, Tableau Desktop 9.3, Tableau Server 9.3, Oracle 12c

Confidential, Sunnyvale, CA

BA/BI Developer

Responsibilities:

  • Organized the Project Plan Document made changes and updates
  • Developed Business Process Models to document existing and future business processes and requirements, using Rational Rose
  • Performed extensive requirement analysis including Data Analysis and Gap analysis
  • Performed User Acceptance Testing (UAT), tracked and managed defects via Quality Center and ensured full signoff from users following the successful completion of the UAT
  • Utilized advanced features of Tableau to link data from different connections together on one dashboard and to filter data in multiple views to analyze the status of the tickets
  • Designed and deployed rich Graphic visualizations with Drill Down and Drop-down menu option and Parameterized for calculating the Time Measurements for each group/queue

Environment: Agile, MS Project/Visio/Access, Rational Rose, Requisite Pro, UML, Tableau 8, Tableau 9, Confidential Big Query, Toad, SQL, Flash 4.0, Quality Center.

Hire Now