Harshad Mahajan Email & Phone Number

Richardson, TX

• Create new & modify existing views & stored procedures in SQL server to complete reporting requirements
• Create plan for index maintenance to dynamically rebuilt the fragmented index
• Create dashboards for revenue, budget & churn rate in tableau using data from salesforce, SQL, & QuickBooks
• Automate tableau report using tabcmd, filter actions & parameters
• Analyze existing schema & performed Data Audit & Data Mapping to build new data warehouse
• Create & maintain pipeline to migrate data from SQL to MongoDB to create a new data warehouse

Richardson Texas

• Extract data in XML format from tableau server by creating excel macro & parsed the XML file using SQL queries to create structured data source.
• Develop ‘Report Repository’ for new ‘Corporate Performance Management’ tool for external reporting using tableau & linked this repository to tableau server using URL & Filter action.
• Create a centralized master database in SQL to fulfill companies reporting requirements.
• Create governance report, savings report & sales report for client using tableau desktop.
• Develop internal version of Corporate Performance Management using tableau for internal reporting.
• Build Interactive project management tool using tableau

India

• Successfully worked on testing project for client named “Genworth” where we tested different application used at client’s end.
• Assigned lead for a module for one of the modules in our project.
• Performed Functional and regression testing.
• Involved in tasks such as Requirement Analysis, Test Case Design, Test Case Execution, Test Script Execution using a tool named “HP Quality center 10 and 11”.
• Involved in automating and executing test scripts using automation tool called QTP.
• Used “Bugzilla” as a defect management tool for reporting defects.

Master Of Science (Ms), Management Information Systems, 4.0

Bachelor Of Engineering (Beng), Information Technology, First Class

Activities and Societies: • Head of Sponsorship cell • Organized Industrial visit for two consecutive years • Organized LAN gaming during.