Power Bi Sql Server
Resume:
**************@*****.***
***, ****** ******, **********,
NJ - 08854
C O N T A C T
S K I L L S
E D U C A T I O N
W O R K E X P E R I E N C E
Oracle PL SQL PROGRAMMER
Tableau Desktop / Power BI
Microsoft Office tools
SAP Crystal Report / BI Reporting Tool
Bachelor of Science with Chemistry
Gujarat University
1994-1997
Post Graduate Diploma in Electronics Data
Processing and Computer Management
Bhartiya Vidhya Bhavan
2001-2002
L A N G U A G E S
English
Hindi
V R A J E S H S H A H
Nirma University - Examination Section
Maintained spreadsheets of data across multiple systems. Generated reports covering details about data, system operation and error monitoring.
Ensured smooth workflow through effective coordination with other IT professionals on projects and tasks.
Reacted calmly during times of highly stressed or emergency situations.
Improved system efficiency by monitoring computer performance and troubleshooting issues as they arose.
Automated repetitive tasks, freeing up developer time for more complex and impactful project work.
Contributed to project success by collaborating with IT departments to implement new technology solutions. Design and developed Summary reports, Parameterized report in Crystal Report for University Examination Section
Design and developed analytical reports in Tableau for Strategic Planning and Decision making for the Management.
Achieved high levels of data accuracy by performing verification tasks.
Trained and supported end-users with software, hardware, and network standards and use processes.
Produced basic runbooks for end-user troubleshooting and desktop support.
Analyzed user requirements and developed solutions to meet needs with the help of IT team.
Ability to create ETL specifications, unit, and system integration test cases using Tableau
Experience with Tableau design and development
Design and implemented a Tableau Dashboard for University Class Room Management resulting 25% increases of resource usage.
Design and implemented a Tableau Dashboard for University Result System to resulting to improve course result. Trained and educated end-users on how to use Tableau dashboard effectively.
Developed in-house applications using Tableau Desktop, Crystal Report designed for University needs.
Assist IT team in testing the reports using SQL queries in SQL Developer, SQL Server and advise them with necessary changes. Schedule batch files using Windows Scheduler.
SQL Server DBA
Project : NUMIS (Nirma University Management Information System) Front End : Visual Studio Back End : SQL SERVER
Reporting : Crystal Report Analytical : Tableau Desktop 2019 - Continue
Data Architect / Data Analytics
Assisted in the preparation of Examination Section related reports, providing essential data analysis that informed strategic decisions. Maintained accurate records of Examination Section for student's result tracking and reporting purposes.
Safeguarded sensitive information through proper documentation handling, data entry, and record maintenance procedures. Assistant / Data Entry Operator
Nirma University - Examination Section
1998 - 2005
Database Administrator
2005 - 2012
Project : Grading System (Examination Section, Nirma University) - Version -1 Front End : Visual Studio 6 Back End : Oracle 10g Reporting : Crystal Report Implemented database back up and recovery processes, reduced system downtime and improved overall system reliability.
Based on User requirements, create parameter driven reports to restrict the volume of data.
Developed Multi Group Reports, Cross Tab reports and Multi Section reports in Crystal report to help end-users not to format and generate reports in Excel repeatedly.
Optimized queries to run efficiently,
Developed database connections, SQL joins, loops, views. 2012 - 2019
Project : Gradeing System (Examination Section, Nirma University) - Version -2 Front End : Visual Studio Back End : Oracle 10g Reporting : Crystal Report Design and implemented data quality and integrity processes, resulting increased in data accuracy and productivity.
Expert in generating Sub Report, Cross Tab Report, Graph Report, Multi Column Report in Crystal Report.
Deep understanding of using shared and global variable in Crystal Report Designed Complex Crystal Report like Ad hoc report, Summary Report, Grouping Report
Developed various PL/SQL stored procedure, views, functions and temporary tables for input data to the crystal report Used Crystal viewer to export report in different format like Excel, PDF, Word
Contact this candidate