We provide IT Staff Augmentation Services!

Engineering Tool And Metric Analyst Resume

Rochester New, YorK

SUMMARY:

  • An analytical and problem - solving professional with massive knowledge and experience in Data Visualization, Business Intelligence and Data Science.
  • Good experience on Advance Excel, SQL, BI tools like Tableau and Power BI for developing dynamic reports.
  • Experience in working with Excel Functions, VLOOKUP’s, Pivot Tables and formulas.
  • Experience and Knowledge in Project Analysis, Requirements elicitation such as Business Requirement documents (BRD) and developing Business Use Case.
  • Excellent interpersonal skill and effective communication in verbal and written as well as listening.
  • Able to Multi-task and handle changing priorities in a fast-paced team environment.
  • A Team player and ability to work within time and budget.

TECHNICAL SKILLS:

Analytics Knowledge: Project Management & Business Analytics.

Databases: Oracle, MS SQL Server(T-SQL),HP Vertica

Advanced Excel: Pivot Tables, VLOOKUP, Data Validation & VBA

Data Visualization Tools: Tableau Desktop & Sever-side, Business Object and PowerBI

Programming & Microsoft Office: Python, JavaScript & Word, Excel, PowerPoint & Outlook Knowledge of Machine Learning and Data Science as well as Cloud Computing (AWS).

JIRA: Bug Tracking, Issues Tracking and Project Management.

PROFESSIONAL EXPERIENCE:

Confidential, Rochester, New York

Engineering Tool and Metric Analyst

Responsibilities:

  • Hands on Experience in Designing, developing, testing and deploying Views and Dashboards in Production environment in a Project as well as development environment.
  • Maintaining and validating existing reports, Multiple Workbooks and Multiple Data Sources.
  • Responsibilities include providing analytical support and expertise in data collection and dashboard reporting as well as developing rules for data standardization and cleanliness on Tableau Desktop and Publishing Dashboards on Tableau Server.
  • Strong Knowledge in Tableau Server roles like creating user groups, Site permission, moving data source and working between projects and migrating data sources to different sites and Servers.
  • Wrote complex queries using complex joins, grouping, aggregation and nested queries.
  • Developed Excel Templates, provide timely status reports and metric and created views with SQL.
  • Experience in the use of SQL Server Management Studio in production environment
  • Creating Excel Templates and Provide timely status reports and metric.
  • Using Excel Pivot table to manipulate large amount of data to perform data analysis, operation reporting, ad hoc queries and analysis

Confidential, New York

Business Intelligence Analyst & Tableau Developer

Responsibilities:

  • Team member of Global Tableau Development Team.
  • Strong Knowledge in Tableau Server roles like creating user groups, Site permission, moving data source and working between projects and migrating data sources to different sites and Servers.
  • Experience in tableau Server Installations, Configuration and Upgrading.
  • Ability to Automate and Schedule Tableau Extract in a timely manner and assign roles on Tableau server.
  • Gathering Requirements and Building a Business Use Cases as well as Conducting Stakeholder Analysis from Initiation stage through the closing stage of the Projects.

Confidential, Newark

Reporting Analyst

Responsibilities:

  • Create ad hoc report and time-Series Report on the rate of Fall (Patient falls) per unit in the hospital.
  • Use Tableau to create scorecard on unit basis.
  • Acting as liaison between technical and non-technical people in presentation of technical work to the understanding of business people and non-technical people
  • Involved in data segmentation and targeting to coordinate with Hospital team to raise.
  • Using ETL tool like SSIS and Talend for extracting data from multiple data sources and transforming and cleaning them and loading to Data Warehouse and Data mart.

Confidential, New York

Business Intelligence Analyst & Tableau Developer

Responsibilities:

  • Collect Field Data through Observation, Questionnaire, Formal and Informal meeting for building User Requirement and Analysis.
  • Create different types of charts such as bar and line chart to Compare data Area and Pie Chart to show data Composition, Scatter chart to show Relationship and Histogram to show distribution on Tableau & Power BI desktop.
  • Building Power BI Data models and Validations rules.
  • Used Tableau and Power Bi to create KPI and scorecard to improve corporate profitability.

Confidential

SQL and Excel Developer

Responsibilities:

  • Wrote complex queries using complex joins, grouping, aggregation and nested queries in TSQL and Manual Reporting
  • Apply Custom Data format and Validation and Advanced Conditional Formatting and Filtering
  • Look up data using Function like VLOOKUP.
  • Performance Data Analysis and Business Intelligence with built in Commands like Goal seek, Scenario Manager.
  • data in another Workbook and Protect worksheet.

Hire Now