Jigar Shah

• Experience in Data Visualization, Database and ETL package Development, Data warehousing and Web Application development. • Expertise in Data Visualization tools like PowerBI and Tableau. • Created SSIS packages using SQL server integration service to perform ETL tasks and created packages to perform same operation in different databases. • Design databases to support business applications, ensuring system scalability, security, performance and reliability • Sound knowledge of T-SQL development like in stored procedures, functions, triggers, Views etc. • Extensive knowledge in Database design, creating table, constraints and referential integrity to maintain database integrity. • Experience in tuning and optimize stored procedures and queries for performance improvement.

Data warehousing and BI Consultant o Dimensional Modeling using Star and Snow Flake Schema, Identifying Facts and Dimensions, Physical and logical data modeling. o Installation & Troubleshooting of Informatica Powercenter on Windows/Linux. o Stored reformatted data from relational, flat file, XML files using Informatica (ETL). o Installation and Configuration of Oracle E-Business Suite Extensions for Oracle Endeca. o Collecting the Client’s requirements and accordingly configuring the ETL to load data from Client’s ERP database and develop custom Endeca Dashboards on the top of Oracle E-Business Suite Application as per client requirements. o Conducting CRP’s and Key User Training with key business users regarding the functionality of Endeca as a tool and making them understand the reports from EBS prospective. o Preparing several documents such as BR100 software configuration document, TE040 Test Scripts and User Manuals for the client. o Effectively managing crisis, handling issues, resolving conflicts. o Responsible for the timely completion of the project. o Mentoring new team members in learning Endeca suite of products. o Developed and implemented Oracle Endeca solutions as per client requirements. o Performing POCs with the Client, document the suggestions and perform changes if any. o Preparing software installation and configuration document for the Client.

System Analyst · Extensive experience in analytical and reasoning task. · Continuous Research and Development in Electronic Discovery processes. · Ability to learn new software using manuals and being updated with the changes. · Understanding of Database Systems like Ms Access, and SQL Server and scripting language. · Facilitate and cultivate a team environment; commitment to teamwork · Maintain proper documentation per project on SharePoint. · Communicate clearly issues, thoughts, timelines and updates with Senior Engineers and project managers. · Provide suggestions, innovations, make assertive decisions, and take responsibility and accountability for actions. · Work with Senior Engineers and provide necessary details for Project reports. · Demonstrate accuracy, overview quality assurance process of documents/Data load files presented to client. · Ensure that products and services are delivered to the client’s satisfaction on time; · Provides feedback for performance, best practices, and overall development.