Arpan Parikh work email
- Valid
Arpan Parikh personal email
Arpan Parikh phone numbers
Over 5+ years of extensive experience in Database development and Business Intelligence Analyst that includes design, development, implementation of complex data delivery systems using MS SQL Server, SQL Server data tools, Oracle PL/SQL, data visualization tools, BI and reporting toolsGood experience in SDLC (Software Development Life Cycle) stages like gathering requirements, design, development, implementation and testing of applicationsExpertise with Relational Database Management Systems including Normalization, Stored Procedures, Functions, Triggers, Cursors, Constraints, Joins, Keys, Indexes in Oracle, MS SQL Server and MySQLExperience on Logical Data Modeling, Data warehouse design, Dimensional Modeling using Star, Snowflake, Normalized and De-Normalized SchemasExcellent knowledge of Database normalization theory techniques, Data flow diagrams, Data dictionary, Entity relation diagrams, Data modeling and design techniquesInvolved in Query Optimization and Performance TuningExtracted, 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 SSISExperience in Data Analytics - Data Cleansing, Data Mining, Data Relationships, Data Mapping, Data Transformations, Systems Integration, Analysis and ReportingExpertise in Client-Server application development using Oracle PL/SQL, SQL *PLUS and SQL *LOADERExperience with SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS)Experienced in data import and export, data migration between heterogeneous system using Data Transformation Service (DTS) Packages, Bulk Insert and Bulk Copy command (BCP)Experience in configuring AWS EC2, RDBMS, S3, RDS, MemCache and developing cloud applicationsExperience in Knowledge and hands-on experience in processing large datasets using Hadoop MapReduce programs
-
Configuration EngineerUptake Sep 2020 - Oct 2020Mississauga, Ontario, Canada -
Application ProgrammerSemper Feye Solutions, Inc. Feb 2019 - Jun 2020Austin, Texas -
Sr. Oracle DeveloperGb Tech Aug 2017 - Feb 2019Austin, 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. -
Sql Server Developer / Bi DeveloperTata Consultancy Services Jan 2014 - Jul 2015Mumbai 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 -
Pl/Sql DeveloperTata Consultancy Services Jun 2012 - Dec 2013Mumbai 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
Arpan Parikh Skills
Arpan Parikh Education Details
Frequently Asked Questions about Arpan Parikh
What is Arpan Parikh's role at the current company?
Arpan Parikh's current role is Business Intelligence Developer.
What is Arpan Parikh's email address?
Arpan Parikh's email address is ar****@****eye.com
What is Arpan Parikh's direct phone number?
Arpan Parikh's direct phone number is +168230*****
What schools did Arpan Parikh attend?
Arpan Parikh attended The University Of Texas At Arlington, Parul Institute Of Engg. And Tech., Limda, Vaghodia 037.
What are some of Arpan Parikh's interests?
Arpan Parikh has interest in Social Services, Children, Gaming, Education, Poverty Alleviation, Science And Technology, Arts And Culture, Singing, Action, Movies.
What skills is Arpan Parikh known for?
Arpan Parikh has skills like Java, Mysql, Pl/sql, Oracle Applications, Java Enterprise Edition, Postgresql, Javascript, Html5, Angularjs 2, Msbi, Stored Procedures.
Not the Arpan Parikh you were looking for?
-
Arpan Parikh
Tech Lead At Capgemini | Senior Java Developer | Aws Cloud Practitioner CertifiedGlasgow1capgemini.com -
2jll.com, ap.jll.com -
Arpan Parikh
Senior Technology Architect - Digital Transformation, Food And Drug Administration (Fda) At AkimaFranklin Park, Nj4yahoo.com, gmail.com, deloitte.com, deloitte.com2 +197360XXXXX
-
Arpan Parikh
Atlanta, Ga -
Arpan Parikh
Mumbai
Free Chrome Extension
Find emails, phones & company data instantly
Aero Online
Your AI prospecting assistant
Select data to include:
0 records × $0.02 per record
Download 750 million emails and 100 million phone numbers
Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.
Start your free trial