Puja Pachchigar Email and Phone Number
I am currently pursuing my Masters in Experimental Surgery - Surgical Innovation, where I am applying cutting-edge technologies such as Artificial Intelligence and Business strategy to bring innovation to the healthcare industry and at Neurosurgical Simulation and Artificial Intelligence Learning Center. Alongside this, I am participating in the District 3 Innovation - Validation program, where I am developing my skills in validating Business ideas, Financial models, marketing strategies, and revenue models. My strong analytical and critical thinking abilities have been honed by my background in Philosophy, while my industry knowledge and computer engineering skills have been refined through my 7+ years of experience as a DBA and my Masters in Computer Engineering. Additionally, I am an active volunteer, participating in mentorship programs such as the Scientista program at McGill and conducting research for the London Middlesex Food Policy Council
-
Msc Candidate- Experimental Surgery - Surgical Innovation - NeurosimMcgill University Jul 2022 - PresentMontreal, Quebec, CanadaInnovation: Innovating various areas using Artificial Intelligence.While also creating Business model, Prototype, Revenue model, Marketing Strategy, Pitch Development.Customer service, Market research,Data AnalysisResearch Thesis: Main role is to use Artificial Intelligence techniques to asses Virtual Reality simulator's data. Main objectives are 1) find most important performance matrices to distinguish Senior, Junior and Consultant surgeons. 2) objectively classifying the performance of the subjects analysing those performance matrics. -
District3 Validation Program StudentDistrict 3 Innovation Jan 2023 - PresentMontreal, Quebec, CanadaStudent at District 3 Validation Programme, Honing skills related to Product management- Business model canvas, Market strategy, Revenue modeling, Fincial Projection, Market Research, Pitch Development, Presentation, Customer Relations, Rapid Prototyping, Leadership -
Honors Specialization Philosophy, Artificial IntelligenceWestern University Sep 2018 - Apr 2022London, Ontario, CanadaPhilosophy Specialisation: Philosophy of Science, Artificial Intelligence, Neuroscience, Mind, Psychology.Research Assistant at Early Modern Philosophy site.Artificial Intelligence: Specialised in Applied Artificial Intelligence, Brain Inspired AI, Computational Neuroscience.Mur Lab: 1) Comparative analysis of the resemblance of Alexnet, Restnet18, Resnet50, VGG16 and GoogleNet with the human visual cortex’s Inferior Temporal (IT)cortex using fMRI data of humans performing the visual perception task.2) Simulated Cntnap2 knockout rat cortical firing using LIF, STDP and SNN computational models. Created the computational LIF neuron model for wildtype and Cntnap2 gene knockout rats and compared it with the biological experimental data. Jacob Morra Lab: 1) Performing Tumor segmentation using UNET archietecture, Performance Parameter Tunning and Increasing the Segmenting Accuracy.2) Classification benchmarking of SVM, ANN, Logistic regression, Naive Bayes, Decision Tree for Stellar Classification. -
Database AdministratorAutodata Solutions Mar 2018 - Nov 2018London, Canada AreaClient: AutoDataProject: Platform to provide database services Role: DataBase AdministratorTeam size: 7Technologies and Skills: MSSQL 2012, 2014, MYSQL 3.0 to 5.7, Postgres 9.0, Oracle -9i, 10G, 11G, Mongo DB 9.3 - windows, shell scripts-I was leading the benchmarking module to take major decision for migration between database platforms that were PostgreSQL, MS-SQL and MySQL-Responsible for researching the performance difference between the aforementioned database platforms and come up with empirical analysis of which DB platform performs best in what scenario.To do that I developed and implemented the module using shell scripts, migration toolkit (designed for table migration inter platform) and performance recorder (using docker app).-As the end result, we found that migration from MySQL to PostgreSQL doesn’t affect much performance and in some cases performance improved. However, MSSQL to PostgreSQL migration affect the performance to some extent and it wont be advisable to perform the migration (the nature of application was a confounding variable here). -
Senior Consultant - DbaCapgemini May 2017 - Nov 2017Pune Area, IndiaClient: ATOC – RTG Rail service Europe ( https://www.rtggroup.co.uk/ )Project: Platform to provide database services Role: Senior Consultant - DBATeam size: 6Technologies and Skills: MSSQL 2012, 2014, MYSQL 3.0 to 5.7, Postgres 9.0, Oracle -9i, 10G, 11G, Mongo DB 9.3 - windows, shell scriptsResponsibilities:• 24* 7 Production support for business critical cases and Resolving P1,P2 in defined SLAs. • Providing permanent solutions queued tickets and new cases.• Monitoring and resolving MSSQL replication issues.• Co-ordinate with the server team for any new procurement and getting it implemented before the specified time.• Implementing and Maintenance of Database availability with Clustering ,Always on,• Database Mirroring, Log shipping, Replication.• Scheduling the maintenance for Re-Indexing, Update Statistics.• Setting up maintenance tasks such as database backups, consistency checks and database optimizations.• Co-ordinating with the server team during patch installation or upgradation process and accordingly move the nodes therefore getting the activity smoothly done without any delays and problem.• Designing, implementing and supporting the Tandem refresh project for MSSQL and MYSQL platform.• Performance monitoring and tuning for MSSQL and MYSQL.• Managing Database Users and security for MSSQL, MYSQL and Maria DB. • Hands on two node cluster.• Performing restore Drill for the various backups.• R&D and implementing different integration technologies for cross platform data transition.• Change Request support and user support in terms of Bonita ,Opium, BMC, JIRA
-
Database AdministratorIntrolligent Inc Apr 2013 - Oct 2017Bangalore1. Client: Apple Inc.Project: Platform to provide Mysql database solutionsRole: Sr Database Administrator (Individual contributor for Mysql)Team size: 10Technologies and Skills: MYSQL 3.0 to 5.7, Mysql galera cluster,Oracle -10G,11GResponsibilities:• 24* 7 Production support for business critical cases and Resolving P1,P2 in defined SLAs. • End to end support for the Mysql galera cluster and Mysql • Configuring Zenoss monitoring for mysql server.• Performing Backup Integrity checks.• Creation of clones of the Mysql servers• Performing Failover and switch over at the time of disaster.• Database Migration on the request of users.• Analyzing and developing the checks to prevent hacking on the database like SQL injections.• Upgradation of Mysql instances..• Development of shell script for Automizing the manual checks like replication monitoring.
-
System Analyst- DbaTech Mahindra Oct 2014 - May 2017Pune Area, India1. Client: Orange – Belgium TelecomProject: Platform to provide database services Role: Sr Database AdministratorTeam size: 7Technologies and Skills: MYSQL 3.0 to 5.7, MSSQL 2012- 2014Postgres 9.0, Oracle -9i, 10G, 11G, Mongo DB 9.3 - windows, shell scriptsResponsibilities:• 24* 7 Production support for business critical cases and Resolving P1, P2 in defined SLAs. • Leading the MYSQL DR-site creation project as a Database Architect• Leading POC project for the Oracle to Postgres migration • Configuring and managing MSSQL Backup jobs.• Upgrading MSSQL from lower to higher version with approvals and test cases.• Supporting regular maintenance for MSSQL indexing and Query performance. • Managing User and security by creating the user policies in MSSQL.• Installing and decommissioning MSSQL for orange MES environment.• Upgradation and Migration for Obsolete Mysql and Postgres Versions.• Develop Migration model for DR and HA• Configuring replication topology for Orange • End to end strategy planning for the DR and presenting it to a client.• Restore Drill for the various backups.• Backup methods upgradation.• Monitoring Tool R&D and implementing it for additional monitoring.• End to end support for the mysql and postgres from installation to decomminisioning.• Change Request support and user support in terms of Bonita ,Opium, JIRA,peoplesoft.2. Client : Club Mahindra Project : Mhril Mysql environment support Role : L3 support for troubleshooting Mysql critical issues Team size : Level 3 Individual contributor Technologies and skills : Mysql 5.1 Responsibilities:• Provide expert solution for L3 issues like performance bottle neck at the crucial holiday booking time.• Performance Tunning, data clean up and storage engine trouble shooting. -
System Engineer - Ims DbaMindtree Ltd. Oct 2012 - Apr 2014Bangalore1. Client: AOL Inc.Project: Platform to provide database services Role: Sr Database AdministratorTeam size: 7Technologies and Skills: Oracle -9i,10G,11G, MYSQL 3.0 to 5.7, MSSQL 2012, Postgres 9.0, MongoDB, shell scriptsResponsibilities:• 24*7 Production support for business critical cases and resolving incidents in defined SLAs. • Handling approximately 1400 Mysql Instances having approximately 500 GB sized each for AOL Mail application.• Peforming Upgradation of Mysql from Mysql 5.1 to Mysql 5.5.24.• Performing Migration of Mysql Hosts to VM Host. • Performing Switchovers when in case of the maintenance.• configuring MSSQL replication and mirroring for High availability of AOL MSSQL servers.• Troubleshooting replication issues for MSSQL servers.• Performance monitoring and tuning on MSSQL servers.• Installing QARs on MSSQL servers of AOL.• Performing Failover in critical situations when the primary is having issues.• Configuration of the Replication(uni,Bidirectional).• Backup Configuration, Management & Backup Integrity checks.• Monitoring , performance Tunning , Troubleshooting issues of the server.• Syncing Master and slave if slave become out of sync.• Data transfer through dump for the requirement of users.• Nagios monitoring configuration.• Argus and Toga graph configuration for the performance monitoring.• QAR installation• Hetrogeneous services implementation & Management of Inter server Data Flow.• Migration of Oracle Database for Better Performance.• Configured ORACLE RMAN backups.• Installation and configuration of the MongoDB on the cluster.• Configuration of the SHARDS for load balancing.• Configuration of the Replicat sets for High avalibility.• Switchover for node maintainace.• Failover for Disaster Recovery of Mongo[Forcing the Member to become primary].• Resyncing the nodes after disaster or for rebuilding after failure.• Upgradation of the mongo instance -
Assistant Manager - DbaNj Technologies [ Finlogic] Dec 2009 - Oct 2012SuratProject: Platform to provide database services Role: Trainee, Assistant DBA , Sr DBATeam size: 5Technologies and Skills: Oracle -9i,10G,11G,MYSQL 3.0 to 5.5, Infobright, shell scriptsResponsibilities:• ORACLE DBA activity for OLTP, Staging servers(DW) and Data marts• Capacity planning and Growth trend analysis• Heterogeneous services setup, user access policy, performance tuning etc.• High availability setup using manual data replication and data guard• Backup & Recovery• Ensuring compliance with ORACLE License policy• Establish and manage data access policy • Data importing in MSSQL servers.• Backup and restore MSSQL databases as per the user requirements.• Instance sizes were between 200GB to 2TB, 5 Servers including dev, QA and Prod environment • MySQL DBA activity for OLTP and Data Mart servers. Included 10+ instances of MySQL and Infobright columnar database.Sizes of same are between 80GB to 300GB, 7 Servers including dev, QA and Prod environment. Covers activity like• Tracking and tuning slow queries• Replication setup• Defragmentation, user access policy, performance tuning.• High availability setup using Replication.• Backup and Recovery • Design and development in Core Java and PHP• XML structure and Database design• Mentoring and guiding team of 4 people • SQL & PL-SQL development and review in ORACLE and MySQL.• Review ETL-Jobs & transformation in Pentaho KETTLE.• Review Cube & Schema designed using schema workbench and Pentaho BI-Server.• Interface design for cross-tab, analysis view, list report, analyzer report etc.
Puja Pachchigar Education Details
-
Information Technology
Frequently Asked Questions about Puja Pachchigar
What company does Puja Pachchigar work for?
Puja Pachchigar works for Mcgill University
What is Puja Pachchigar's role at the current company?
Puja Pachchigar's current role is Msc Experimental Surgery- Surgical Innovation Candidate at McGill University.
What schools did Puja Pachchigar attend?
Puja Pachchigar attended Mcgill University, Western University, Veer Narmad South Gujarat University, Surat.
Not the Puja Pachchigar you were looking for?
-
3yahoo.com, finlogicindia.com, finlogicindia.com
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