Priyank Dharani

Business Intelligence Developer @PCMI

Park Ridge, IL, US

Created reports using OLAP Cube integrated with SSRS using MDX query, to represent the data in Matrix and Chart form• Increased the stored procedure performance from 15.13min to 2.20 min for more than records.• Compose solution blueprints, sample report extracts and prototypes to produce up to 25 diverse statistical reports• Automate the process of creating new role for reports, which help developers to reduce manual load by 8% • Create reports to determine which zone is generating more revenue by comparing with other buckets for specific time frame using Power BI• Develop SSIS packages and schedule jobs to move data/files from disparate sources into FTP/SQL server and vice versa• Manage user access and security roles across multiple BI reporting environments

SVKM's Narsee Monjee Institute of Management Studies (NMIMS)

Bachelor of Engineering - BE, Electronics

Illinois Institute of Technology

Master's degree, Information Technology and Management