Summary
Overview
Work History
Education
Skills
Work Preference
Timeline
Generic
Open To Work

Nimeshbhai Patel

Data Analyst
Edison,NJ

Summary

Dynamic and results-driven IT professional with over 15 years of comprehensive experience in system analysis, design, development, testing, and deployment of commercial client-server, ETL, cloud, and BI applications. Highly skilled in utilizing analytical tools such as Power BI, SSRS, and Tableau to deliver impactful insights. Strong analytical, communication, and interpersonal skills enhance collaboration and foster effective teamwork in diverse environments.

Overview

16
16
years of professional experience

Work History

Senior Business System Analyst

CCC Intelligent Solutions Inc
Edison, NJ
06.2023 - 01.2026
  • Assisted in developing customized reports for auto insurance companies across all states for 1st and 3rd party casualty claims. Collaborated with team members to address reporting requests and create automated or ad hoc reports using SSRS platform. Supported better management by creating reusable code applicable to various clients. Developed reports in Power BI for clients to access real-time data through a user-friendly application.
  • Achieved successful project completions through effective team leadership and resource management. Drove project timelines and budget adherence by implementing strategic planning and execution practices. Cultivated strong stakeholder relationships to enhance project outcomes and team performance.
  • Created intricate reports leveraging SSRS, Power BI, and SQL Agent tools to support organizational insights and performance tracking.
  • Created and maintained dynamic dashboards in Tableau and Power BI, facilitating real-time insights into key performance indicators across the organization.
  • Refined SQL queries and ETL workflows, significantly reducing data retrieval times within SQL Server environment.
  • Analyzed and refined data model iterations in Power BI, focusing on achieving superior performance results.
  • Directed teams of analysts in generating innovative reporting requests and ensuring timely delivery of essential reports.
  • Collaborated in daily scrum and weekly meetings with client account manager to effectively address project requirements and meet deadlines.

Senior SQL Server BI Developer

Auto Injury Solution
Edison, NJ
03.2015 - 05.2023
  • Designed and developed E-Billing application for processing the automobile insurance company medical bills into Medflow database. E-Billing application has all functionality in SSIS package to load xml files from FTP server to Medflow tables based on client config. 1st party client implementation project involves design and develops new client setup which involves rule-based workflow, E-billing setup, PPO workflow and Adjuster driven config. New client implementation has SQL based config to create for Crystal report PDF report generation. Both applications written using T-SQL, .NET CORE and SSIS package, SSRS and the backend database using SQL server 2019.
  • Responsibilities:
  • Created Stored Procedures, Triggers, Bulk Load and Views in SQL and effectively used within the application and developed complex SQL queries for Data Automation project.
  • Involved in the complete Software Development Life Cycle (SDLC) including Analysis, Design, Implementation, Testing and Maintenance with Agile Methodology.
  • Developed various types of complex reports using SSRS.
  • Created SSIS package to inject medical data from outside vendor into medical flow database which cover multiple tasks like connecting to FTP server, unzip files, load each xml files after XSD validation into stage tables.
  • Used Azure DevOps for version control of code, automated build for release code and release to production.
  • Experience in continuous integration and continuous deployment (CI/CD pipeline) using Jenkins command in Azure.
  • Participated in daily Scrum and weekly meetings with the project manager and architects to meet expectations and deadlines.

Programmer Analyst

Core Education and Consulting Solutions Inc.
Princeton, NJ
07.2010 - 02.2015
  • Designed and developed Bill review management and Adjuster Desktop application for processing the automobile insurance company medical bills. Bill review management defines a rule-based workflow engine allowing documents to be routed electronically to the appropriate review resource. Adjuster Desktop allows online review by the adjuster so that the result is completely synthesized with the adjuster's file. The adjuster desktop provides online access to medical bills, records, and Explanation of Reviews before the final EOR is sent and can communicate with us real-time. Both applications written using C#.NET, ASP.NET and VB.NET and the backend database using SQL server 2005.
  • Responsibilities:
  • Design and Describe application using UML Modeling Techniques like Use case, Class, Object, State and Sequence Diagram.
  • Involved in UI Designing and Coding of Web Forms using HTML, CSS, JavaScript, ASP.NET and C#.NET
  • Used LINQ to query cached list of objects on server side while paging and sorting.
  • Involved in building flexible UI, more user interactive and user-friendly web pages using AJAX and JavaScript for client-side validation.
  • Experience using .NET Generic Collections like List (of T) & Dictionary (of T) for type-safe collections in 2.0 Framework.
  • Implemented new ASP.NET 2.0 feature like master pages, login control, membership and profile objects.

Education

Bachelor of Engineering - Information Technology

L. D. College of Engineering
Gujarat, India
06.2004

Skills

Expert in SQL and Advanced Excel

Data visualization tools like Tableau or Power BI

Familiar with Python or R for analysis

Report preparation

Stakeholder relations

Project management methodologies like Agile or Scrum

Work Preference

Work Type

Full TimeContract Work

Location Preference

RemoteHybridOn-Site

Timeline

Senior Business System Analyst

CCC Intelligent Solutions Inc
06.2023 - 01.2026

Senior SQL Server BI Developer

Auto Injury Solution
03.2015 - 05.2023

Programmer Analyst

Core Education and Consulting Solutions Inc.
07.2010 - 02.2015

Bachelor of Engineering - Information Technology

L. D. College of Engineering
Nimeshbhai PatelData Analyst
Want your own profile? Build for free at MyPerfectResume.com