Arpan Parikh Email & Phone Number

Mississauga, Ontario, Canada

Austin, Texas

Austin, Texas Area

• Integrating Oracle database with Pega 7 application• Interacting with Users, Developers, Project Manager to understand the business process, identify enhancements and gather Business Requirements.• Use RDB-List, RDB-Open, RDB-Save depending on the business rules in the project• Designing the SQL connector to get data from the external database.• Involved in creating activities, activity step methods, when rules and decision rules.• Testing and debugging using tracer and rules inspector• Analysis, Design and implement the data migration process• Implementation of PRPC components like Decision tables, Decision Maps, Declarative Expressions, Constraints and Indexes etc.

Mumbai Area, India

• Created multiple processes to verify and validate correct data transfer and communication between Oracle database and SQL Server ERP system• Involved in complete Software Development Life Cycle (SDLC) process by analyzing business requirements and understanding the functional work flow of information from source systems to destination systems• Designed and developed various aspects of database solutions: database model, stored procedures, SSIS packages, ETL• Used Normalization to improve the performance. Involved in ETL code using PL/SQL to meet requirements for Extract, transformation and loading of data from source to target data• Embedded SQL queries in Crystal Reports which reduced 70% efforts of billing team and automated monthly report generation process• Generated Reports using Global Variables, Expressions and Functions• Designed SSIS Packages to extract data from various data sources such as Access database, MS Excel and loaded data into destination databases for Data Analysis and Reporting• Used Data Conversion, Conditional Split, Merge and Union all data flow transformations in SSIS• Monitored performance and optimized SQL queries for maximum efficiency• Using SQL server reporting services (SSRS) delivered enterprise reports to draw content from a variety of data sources• Involved in complete SSIS life cycle in creating SSIS packages, building, deploying and executing the packages in UAT and Production environments• Applied various data transformations like Data Conversion, Multicasting, Conditional Split, Derived column in SSIS• Re-designed, re-coded, and deployed data extractions using SSIS, designed and produced documentation of data transformations for all extractions• Involved in code documentation for understandability• Organized knowledge sharing sessions for technical understanding among team members

Mumbai Area, India

• Created Databases, Tables, Cluster and Non-Cluster Indexes, Unique and Check Constraints, Views, Stored Procedures, Triggers to transform business logic into database design• Managed performance and tuning of SQL queries, fixed the slow running queries in production with utilities like Explain, Trace, and Stored Outlines• Created Databases, Tables, Cluster/Non-Cluster Index, Unique/Check Constraints, Views, Stored Procedures.• Implemented PL/SQL procedure and Oracle apps interface to generate monthly billing report for Level 1 support team• Performed Batch monitoring, Import/Export, Backup, Database Monitoring and Application support• Created logical and physical database design, database structures, primary key, foreign key and implemented large databases• Designed and implemented stored procedures and triggers for automating tasks• Modified database structures as directed by developers for test/develop environments and assist with coding, design and performance tuning• Provided back-end support for functional testing and performance testing• Developed materialized views for data replication in distributed environments • Involved in Normalization and De-Normalization of existing tables for faster query retrieval• Designed logical and physical database for reporting tool, generating various monthly financial & end user reports and send them to the traders and end users• Using PostgreSQL, designed database system for integrated Workforce Management System module• Created SQL queries & reports against Oracle database for statistical, analytical & external reporting• Reduced number of incidences raised by client by 60% providing L2 level support

Master'S Degree, Computer Science, Gpa 3.67/4

Enrolled courses : Database Systems, Data Mining, Cloud Computing, Algorithms, Machine Learning, Mobile App development

Bachelor'S Degree, Computer Engineering, 3.76/4

Activities and Societies: Member of web development team of a national level placement program called "JOBMELA"​ under the main event.