Nishant Patel Email & Phone Number

Palatine, Illinois, United States

Greater Chicago Area

www.iSetTech.com

Greater Chicago Area

• Architecting reporting requirements into technical design and development. • Created Info Providers & BEx queries to simulate/validate results achieved from design Studio reports.• Created Info objects, DSO’s and Cubes & Multi providers as per data model. • Defined several transformations as per the need. Optimized BW cubes for HANA purpose. • Managed Client BW environment to co-ordinate development, testing and transports to Production. • Experienced with data modelling views such as attribute, analytic, calculation based on business requirements.• Migration of objects from one to another (BW to HANA) based on requirements.• Involved in creating decision tables and performed calculation using function provided by HANA.• Developed multiple reports/dashboards using Dual Axes charts, Histograms, Filled map, Bubble chart, Bar chart, Line chart, Tree map, Box and Whisker Plot, Stacked Bar etc. • Created Server Monitoring workbook views and a custom workbook to see ‘My activity’ on Tableau Server using Tableau Server Repository Database (Postgresql).• Created various highly interactive dashboards and data visualizations reports for Ad Sales and Program Finance departments.• Created users, users groups and maintained user access rights in Tableau.• Connected Tableau to various databases and performed Live data connections, query auto updates on data refresh etc.• Developed MapReduce programs to parse the raw data, populate staging tables and store the refined data in partitioned tables.

Greater Chicago Area

• Designed a database in MySQL reflecting the client's needs.• Documented and maintained database system specifications, diagrams and connectivity charts. • Worked with internal and external clients for import and normalization of third-party data. • Provided ongoing technical troubleshooting and support.• Assisted in planning, managing, and implementing network security to protect client’s data. • Assisted in diagnosing any software or hardware problems and replace as requested.• Provided ongoing technical troubleshooting and support.• Assisted in planning, managing, and implementing network security to protect client’s data.• Configured and set up routers, hubs, computers and printers to meet businesses’ needs.• Created backups, servers, file transferring and upgrading systems.• Worked with accessing computers and servers remotely.• Took systems off-site as needed for major repairs/rebuilds.• Assisted in diagnosing any software or hardware problems and replace as requested.

United States

• Managed and maintained all technical equipment, including POS registers, ISP systems and eLearning computers.• Conferred with technology vendor SEI to resolve escalated technology issues.• Diagnosed problem, ordered, and replaced necessary part on the eLearning computer that eliminated need for new computer. • Diagnosed and resolved connectivity problems.• Trained new members and help them learning their work.• Consistently provided professional, friendly and engaging customer services.