About

Arpan Parikh is a Business Intelligence Developer with over 5 years of extensive experience in database development and business intelligence analysis. He has expertise in designing, developing, and implementing complex data delivery systems using MS SQL Server, SQL Server data tools, Oracle PL/SQL, data visualization tools, BI, and reporting tools. Arpan has good experience in SDLC stages like gathering requirements, design, development, implementation, and testing of applications. He has expertise with Relational Database Management Systems including normalization, stored procedures, functions, triggers, cursors, constraints, joins, keys, indexes in Oracle, MS SQL Server, and MySQL. Arpan has experience in logical data modeling, data warehouse design, dimensional modeling using Star, Snowflake, Normalized, and De-Normalized Schemas. He has excellent knowledge of database normalization theory techniques, data flow diagrams, data dictionary, entity relation diagrams, data modeling, and design techniques. Arpan has been involved in query optimization and performance tuning. He has extracted, transformed, and loaded (ETL) data from various data sources and destinations like Text files, MS Excel, CSV, Oracle using connectors, tasks, and transformation techniques provided by SSIS. He has experience in data analytics - data cleansing, data mining, data relationships, data mapping, data transformations, systems integration, analysis, and reporting. He has expertise in client-server application development using Oracle PL/SQL, SQL *PLUS, and SQL *LOADER. Arpan has experience with SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS). He is experienced in data import and export, data migration between heterogeneous systems using Data Transformation Service (DTS) Packages, Bulk Insert, and Bulk Copy command (BCP). Arpan has experience in configuring AWS EC2, RDBMS, S3, RDS, MemCache, and developing cloud applications. He has knowledge and hands-on experience in processing large datasets using Hadoop MapReduce programs. Arpan is currently working as a Configuration Engineer at Uptake. He has previously worked as an Application Programmer at Semper Feye Solutions, Inc. and as a Sr. Oracle Developer at GB Tech. At GB Tech, he integrated Oracle database with Pega 7 application, interacted with users, developers, project managers to understand the business process, identified enhancements, and gathered business requirements. Arpan has a Master's degree in Computer Science from The University of Texas and a Bachelor's