We provide IT Staff Augmentation Services!

Business Intelligence (consultant) Resume

SUMMARY:

A Business Intelligence Analyst with diverse industry experience in finance, healthcare, supply chain & Agriculture. Professional expertise includes Big Data Analytics, Data Visualization (Tableau & Spotfire) & ETL, Tibco Data Virtualisation & Master Data Management (Golden Record) . Experience in team handling, coaching & mentoring the fellow members. Familiarity & Knowledge of Big Data solutions (Hadoop ecosystem).

TECHNICAL SKILLS:

Big Data Analytics & Profiling Master Data Management & Data Integrity MS Vision (Proficient) Data Governance & Survivorship Data Migration & Imaging Software Report Manager Microsoft Visual Studio (Some knowledge) Microsoft Access & Excel (Proficient) Visual Basic for application (Proficient) Microsoft Office Suite ( Including Visio & Project) ) Data Watch (Monarch Pro) Structure Query Language (Intermediate) SSIS Business Intelligence Familiarity & Knowledge of Hadoop Ecosystem & Big Data solution.

WORK EXPERIENCE:

Confidential

Business Intelligence (Consultant)

Responsibilities:

  • Agriculture Sales & Marketing data analytics support with BI, ETL & Data Modeling
  • Utilize Alteryx to Prepare, blend and analyze all your data using a repeatable workflow
  • Utilize SQL to run ad hoc data analysis via Toad for Oracle
  • Alteryx workflows creation, Alteryx ETL, Data Science & Data Preparation
  • Support Sales & Marketing with data visualization and making a data tell a story & discovery
  • Replicate Excel Reports in Spotfire Visualization.
  • Created reports in Spotfire with different type of properties like chart controls, filters, Interactive Sorting, Maps, Dashboard Export to Spotfire Server, Create KPI, Spotfire LOD & Interactive Waterfall Charts.
  • Utilize Tibco Advanced Data Services (Tibco Data Virtualisation & Spotfire)
  • Create connections to physical data environment from multiple data sources in Tibco Data Virtualisation studio
  • Blend multiple data sources into single level view via common field relationship (Physical, Business & App views)
  • Published final views to web services or physical databases (Data Visualization tools pick up or business use)

Confidential, Las Vegas, NV

Business Intelligence Analyst

Responsibilities:

  • Supply Chain data analytics support with Procurement categories & factors
  • Utilize Alteryx to Prepare, blend and analyze all your data using a repeatable workflow
  • Run predictive, spatial and statistical analytics in one intuitive interface in Alteryx
  • Alteryx workflows creation, Alteryx ETL, Data Science & Data Preparation
  • Bonfire bid analysis, project creation, analysis & reporting
  • Uses Metadata to deep dive into reporting data to analyze & profile compliance data that will give information about the overall picture of the entire reporting and use that data to tell a story to managers & leaders via Tableau Visualization graphs & charts.
  • Created reports in Tableau with different type of properties like chart controls, filters, Interactive Sorting, Parameters filters, Data Filtering, Extract filters, Context filters, Dimension Filters.
  • Utilize Tibco Data Virtualisation Across client data warehouse to create single view for Tableau
  • Create modules connection, physical, business & app view.
  • Published view to web services (Business Users) & Physical database (Tableau & Data Analyst)

Confidential

Sr. Business Intelligence Analyst

Responsibilities:

  • Alteryx workflows & ETL Processes
  • Defining and recommending metrics, measures, reporting and solutions for Tableau Visualization
  • Create Big Data ETL process for visualization process
  • Uses Metadata to deep dive into reporting data to analyze & profile compliance data that will give information about the overall picture of the entire reporting and use that data to tell a story to managers & leaders via Tableau Visualization graphs & charts.
  • Created reports in Tableau with different type of properties like chart controls, filters, Interactive Sorting, Parameters filters, Data Filtering, Extract filters, Context filters, Dimension Filters.
  • Complete User Acceptance Testing with client for both ETL & Tableau visualization processes.
  • Coordinate (and participate in) production support, Tableau dashboard troubleshooting and deployment to Tableau Servers for multiple usability & create extract schedules via Server.
  • Data Governance Processes, Policies & Framework for Tableau Dashboard & Data Source

Confidential, Eden Prairie, MN

Consultant (Data Analytics)

Responsibilities:

  • Work extensively with Big Data Analysis & Profiling (MDM) as well as Data Governance & Survivorship.
  • Work with SMEs to identify and define attributes from source table to be profile.
  • Created basic Tableau Dashboard to visualized trend & record counts to management & team.
  • Utilize Tableau Server & created basic Data Filters, Parameters & Calculated fields to visual MDM trend & record counts from previous month & current month.
  • Create Survivorship rules for data governance & mapping.
  • Review Data Dictionaries and select target attributes to be mapped to the Master Data Management Repository.
  • Review Data Model and select target attributes to be mapped to the Master Data Management Repository (MDM).
  • Utilize Teradata to connect to client source database and pull sample data
  • Utilize DB Visualizer to connect to client source database and run Basic SQL queries
  • Utilize Aginity for data store connection & analytics purposes
  • Create high quality reporting visualization in tableau
  • Create Survivorship and User Stories in Rally (CA)
  • Utilize Global ID for Data Profiling & Enterprise Ecosystem
  • Utilize IBM Info Analyzer for Profiling
  • Familiarity of Data Lake and Tenant
  • Familiarity of Data Fabric and Tenant
  • Knowledge of Hadoop Ecosystem (nodes, rack, cluster, MapReduce jobs)
  • Knowledge of Pig scripting & HiveQL
  • Utilize Data Visualizer to connect to client source database and pull sample data

Confidential, Minneapolis, MN

Data Consultant

Responsibilities:

  • Created & pushed multi file type to Oracle IPM via FTP and CMD prompt.
  • Modeled & manipulated data spec to successfully push FTP file.
  • Managed Batch Files Process and data connection between SSMS & Oracle IPM Applications.
  • Utilized Windows remote servers and analyze FTP logs.
  • Managed Batch Processor & analysis of metadata for Oracle IPM.
  • Utilized work center, save search & application search in Oracle IPM
  • Configured ODS & RCDS data source
  • Create Select, Update, Insert & Delete T - SQL queries in SSMS for reporting purposes
  • Create Index files and Business Objects via dialogue
  • Coordinate imagining work and file conversion via dialogue
  • Validate Data Type and metadata in SQL Server Management Studio tables via queries and script

Confidential, Minneapolis, MN

Lead Data Analyst /Systems Analyst

Responsibilities:

  • Utilize Metadata to get information about COG KPI Metrics & AML Compliance monthly reports.
  • Troubleshoot Microsoft Access & Excel using Visual Basic for Application.
  • Data Analytics & Reporting lead
  • Data Reporting, System Configuration and General Technical assistance.
  • Create ad hoc reporting and queries via SQL, VBA and Oracle.
  • Create Tables, Queries, Micros and Modules in Microsoft Access & SSMS.
  • Utilize WS FTP and UNIX.
  • Financial Reporting including utilizing KPI Metric and SOX Compliance.
  • Investigate and trace data from source to destination.
  • Created dashboards using Calculated Fields, Filters, and Parameters, groups, sets and hierarchies in Tableau.
  • Used VBA & Basic SQL to import & scrape data from data storage to DBMS.
  • Summarize data in Excel, Access & SSMS via VBA & Basic TSQL.
  • Create Intranet site for business lines, enhanced reporting process and utilize web focus queries.
  • Develop entire Access Database from start to finish.
  • Import and Export Data from Excel, Access & SMSS.
  • Train and lead teammates on VBA, SQL and Access applications.
  • Some EDI practice for Data Interchange via Intranet and FTP.
  • Work with developers & business line regarding SDLC (Analysis, Design, Implementation, and Maintenance & Planning).

Confidential, Las Vegas , NV

Technical Business/Data Analyst

Responsibilities:

  • Act as a liaison between the business unit and technical team.Work with developers & business line regarding SDLC.& creation. (ETL)
  • Business requirement & liaison with partners’ data & information group for solution delivery.
  • Use cases, GUI, screen, interface designs and test cases.
  • Collaborate with developers to establish technical vision & analyze tradeoffs between usability and performance needs.
  • Work independently with user to define concepts.
  • Drive and challenge business units on their assumption of how they will successfully execute their plan.
  • Create Details statuses of files using Excel's hyperlink (link files), tables (fields for data manipulation), sorting and filter for SQL Programing.
  • Communicate and collaborate with business owners and end-users to analyze information needs &functional requirement.
  • Use SharePoint to locate and update resources.
  • Use Pivot table and Visio flow chart.
  • Design specifications for SDLC (Agile Software Development).

Hire Now