Jigar Patel

Data Analyst @Wesco

CA

Designed the business requirement collection approach based on the project scope, createdBusiness Analysis using an agile methodology.• Analysed Requirements and created Business Requirements Document (BRD), FunctionalRequirements document (FSD) and Use Case Specifications. Built compelling, interactivedashboards in Tableau that answer key business questions.• Used excel sheet, flat files, CSV files to generated Tableau ad hoc reports.• Worked with data investigation, discovery and mapping tools to scan every single data record frommany sources.• Worked on CSV files while trying to get input from the whole database.• Used MS Office extensively (Word, Excel, PowerPoint) for analysis, presentation, anddocumentation throughout the project.• The building, publishing customized interactive reports and dashboards, report scheduling usingTableau.• Responsible for physical/logical data modelling, metadata documentation, user documentation andproduction specs• Worked extensively on Data Profiling, Data cleansing, Data Mapping and Data Quality.• Generated graphs and reports using MS Excel Pivot tables and creating presentations usingPowerPoint.• Delivered file in various file formatting systems (ex. Excel file, Tab-delimited text, Comma-separatedtext, Pipe delimited text, etc.)• Used and maintained database in My SQL and Postgre SQL to extract the data inputs from internalsystems.• Used Excel in setting up pivot tables to create various reports using asset of data from an SQL query.• Worked on data analysis, data profiling, source to target mapping, Data specification document forthe conversion process.• Used version control systems like GIT for Manage the Source Code.