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, India06.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 WorkLocation Preference
RemoteHybridOn-SiteTimeline
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