Nikunj Patel
Power BI & Crystal Reports

Nikunj Patel

Senior DB/BI developer at Workforce Logiq.
Work with Nikunj Work with a Power BI & Crystal Reports

About

Nikunj Patel is a Power BI and Crystal Reports expert with over 10 years of experience in ETL, business intelligence, data warehousing, database application development, and database administration. He has expertise in generating on-demand and scheduled reports and dashboards for business analysis and management decisions. At Workforce Logiq, he serves as a BI developer responsible for structuring problems, identifying appropriate data sources, extracting data, and developing ETL as delivery solutions. He also worked at Cygnet, where he handled clients across different domains such as transport and tax. His technical skills include SQL Server 2012-14, SSIS, SSAS, SSRS, Sisense, Power BI, and Azure, among others.

Employment

3 roles
Apr 2019 - Present 7 years 1 month
Senior DB/BI Developer
Workforce Logiq

As a database developer:

  • Served database administration tasks, including configuration management, backup/recovery, high availability, performance optimization, and space management.
  • Handled performance tuning of SQL Queries and stored procedures.
  • Performed database deployments and provided support for production release.
  • Assisted application developers with MS SQL Server issues and questions.
  • Set up various alerts and notifications to warn if any failure in SQL Server.
  • Helped team make application database to Azure compatible.

As a BI developer:

  • Worked with cross-functional teams to structure problems, identify appropriate data sources, extract data, and develop ETL as delivery solutions.
  • Played key roles in projects as data modeler and data architect.
  • Designed, developed, tested, deployed, and maintained various solutions like audit, archive and change tracking, and sanitization process.
  • Worked on creating Azure Data Factory (ADF) for moving and transforming the data.
  • Developed Elastic cube designed and modeling in Sisense.
  • Created rich dashboard in Sisense and PowerBI with proper format and look for business users.
  • Completed Informatica cloud data integration (IICS) training.
  • Developed Azure pipeline for data migration and SQL jobs.

Client: US-based product (vendor management domain).

Project: Vendor management system.

Technologies: SQL Server 2012-14, SSIS, SSAS, SSRS, Sisense, PowerBI, and Azure.

Sep 2016 - Mar 2019 2 years 6 months
Senior BI Developer
Cygnet Infotech
  • Utilized technological analysis and design principles to formulate detailed application plans and processes.
  • Involved in requirement analysis, estimation, system design, development, troubleshooting, performance optimization, client communication, deployments, and team-leading for existing and new development.
  • Designed and deployment of reports for the end-user requests using web interface and SSRS.
  • Designed and developed complex ETL processes for data warehouse.
  • Involved in Tabular data warehouse for SSAS 2012 OLAP databases.
  • Handled performance tuning of SQL Queries and SSIS and SSAS components.
  • Developed the business dashboards to present to CXOs.
  • Involved in SQL development.
  • Prepared the required unit test cases for the code that is developed and perform self-review for unit and integration test cases.
  • Client: UK-based client (transport domain).
  • Project: Passenger information and transport
  • Technologies: Microsoft SQL Server 2012, SSIS, SSAS, SSRS, C# 4.0, and XML.
Jan 2012 - Sep 2016 4 years 8 months
Database & Business Intelligence Developer
SPEC India
  • Involved in creation/review of functional requirement of project specifications and supporting documents for business systems and developed detail and scalable database design.
  • Developed programming tasks like stored procedures, triggers, and views using SQL Server 2012/2014 with T-SQL.
  • Created data flow, process models, and E-R diagrams for easy to understand flow of application.
  • Used SQL Profiler for performance monitor to resolve deadlocks and long-running queries by checking appropriate transaction isolation levels and query execution plans.
  • Analyzed complex business issues and generated solutions.
  • Designed overall architectural flow and structures of ETLs using SSIS to populate data warehouse.
  • Involved in installation, configuration, development, and deployment of drill down, drill through, and matrix reports using SSRS.
  • Extensively involved in production issues.
  • Performed data modeling of Star and Snowflake schemas.
  • Involved in planning, designing and developing SSAS 2012 Cubes, and building attribute relationships for optimal MDX query performance of hierarchies and fact dimensions.
  • Created user role-based security for cubes and measure groups.
  • Monitored and debugged ETLs in case of failure.
  • Managed SQL jobs and maintenance tasks.
  • Client: USA-based client (healthcare domain).
  • Project: Document management process – ACS, Chart Acquisition Tool (CAT), Secure Drop Box (SDB), Member Outreach (MO), In-Home Care (IHC), and billing application.
  • Technologies: Microsoft SQL Server 2012, SSIS, SSAS, SSRS, and Tableau C# 4.0.

Education

Sep 2011 - Jun 2013 1 year 9 months
Master of Science in Information Technology, -
VNSGU
Sep 2008 - Jun 2011 2 years 9 months
Bachelors of Science in Information Technology, -
VNSGU

Portfolio

1 item