Jay Patel Email & Phone Number

Greater Chicago Area

Cloud 9 is working on cloud based technologies by envisioning, architecting, developing, implementing and managing cloud systems. Responsible for development on various Cloud 9’s client projects using Power BI (Desktop/Services/Embedded), SSRS, SSIS, ASP.NET, SQL Server 2014-2016, T-SQLResponsibilities: • Involved in the process of analysis, design, development, testing and deployment of the application.• Actively participated in daily SCRUM meetings to produce quality deliverables within time.• Involved in writing user stories and tasks for development of project using Visual Studio Online.• Used views, procedures and functions to create Datasets and fetch data• Developed a Data Model to work with different Power BI reports.• Developed Paginated Reports using SSRS to display simplified summary of the assets managed for different customers.• Designed and developed paginated reports in Power BI using existing and custom visuals to display Interactive reports.• Used Microsoft SQL Server 2016 to develop and manage data source such as tables, stored procedures and views.• Analysed SSRS reports and fixed bugs in Stored Procedures.• Worked with Measures and Calculated Columns for Power BI reports.• Worked on applying Row Level Security in Power BI• Implemented Time Intelligence using DAX to compare data over time• Reviewed and tested packages using Business Intelligence Development Studio.

Waltham, Ma

The main scope of the project is to build dashboards and several reports on customer relationship management database. The developed dashboards is consists several charts for the business discovery and other advanced features were used.• Excellent report creation skills using Microsoft SQL Server 2014/2012 Reporting Services (SSRS) with proficiency in using Report Designer as well as Report Builder.• End to end automation to build Power BI Dashboard to show critical KPIs • Created SQL Server Reports based on the requirements using SSRS 2012.• Created Power BI reports to analyze user engagement based on different measurements and areas to take business decisions. • Involved in analysis of Report design requirements and actively participated and interacted with Team Lead, Technical Manager and Lead Business Analyst to understand the Business requirements.• Created Database Objects like Tables, Stored Procedures, Views, Triggers, Rules, Defaults, user defined data types.• Experience in working on Cube structure optimization for MDX query performance in Analysis Services 2012/2014 (SSAS) and Created complex reports which involve more number of groupings and multi-value parameters.• Created an alternate work flow for Data stage ETL process using SSIS.• Generated Drilldown, Drill trough Cascaded, Ad-hoc reports using SSRS 2012.• Using SSIS, building high performance data integration solutions, including extraction, transformation, and load (ETL) packages for data warehousing.• Configured SQL Server2014 and SSRS using IIS and troubleshooting performance issues and fine-tuning queries and stored procedures.• Created SSAS Tabular Semantic model in Direct Query mode with multiple partitions, KPI's, hierarchies and Calculated Measures using DAX as per business requirements.

India

The project is related to Energy and resources industry. The development efforts of the project majorly focus on tracking the details of all the employees as well as the hardware equipment related to each employee. The aim was to develop a web application for a US based client to store information of the employees in database and generate reports.• Involved in the analysis and profiling of source data, creating prototypes and sample reports to help with requirements and design.• Used Subqueries, Joins, CTE’s and Analytical Functions for data retrieval for reporting needs.• Generated Reports using Global Variables, Expressions and Functions for the reports using SSRS 2012.• Created many Ad-Hoc Reports, Summary Reports using SSRS.• Designed SSRS reports with sub reports, dynamic sorting, defining data source and subtotals for the report.• Created Parameterized reports and Linked reports and possess thorough knowledge of report serving architecture using SSRS.• Scheduled reports for daily, weekly, monthly reports for executives, Business analysts and customer representatives for various categories and regions based on business needs using SQL Server Reporting services (SSRS).• Designed and developed efficient SSIS packages for processing fact and dimension tables with complex transforms.• Extracted large volumes of data from various data sources and loaded the data into target data sources by performing different kinds of transformations using SQL Server Integration services (SSIS).• Created SSIS packages for Uploading of different formats of files (Excel, Access, dbf) and databases (SQL server, Flat files) into the SQL Server database using SQL Server Integration Services (SSIS).• Automated the SSIS jobs in SQL scheduler as SQL server agent job for daily, weekly and monthly loads.• Written complex T-SQL queries and created Stored Procedures, Triggers, Functions and Views.• Created data driven subscriptions for different users using Report Manager.

India

Nirvana Technolabs was an IT-Hub for providing outsourcing services. This Internship project was about agriculture product management and displaying reports for state firm’s agriculture products and other resources using SSRS. This Internship increased a level of SQL Server Development and Reporting with SSRS.Responsibilities: • Co-ordinated with the team to understand requirements and transform them into detailed design of project.• Involved in all phases of application development including design, analysis, development and testing.• Extensively worked on querying and debugging SQL scripts including base tables, stored procedures, table valued functions, triggers and views.• Created SQL Server Agent Jobs and monitored the scheduled SSIS packages. • Troubleshoot SSIS packages and migration procedures and Document complex SSIS packages and migration procedures.• Created categorical and trend analysis visualizations on different segments using tables, charts, graphs and Gauge of SSRS.• Tracked and closed the bug tickets as per priority and severity using TFS.• Participated in daily stand-up meetings and knowledge sharing sessions.