Puja Pachchigar Email & Phone Number

San Francisco, Ca, Us

Montreal, Quebec, Canada

Innovation: 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.

Montreal, Quebec, Canada

Student 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

London, Ontario, Canada

Philosophy 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.

London, Canada Area

Client: 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).

Pune Area, India

Client: 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

Bangalore

1. 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.

Pune Area, India

1. 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.

Bangalore

1. 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

Surat

Project: 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.

Master Of Science - Ms, Experimental Surgery, 4.0

Activities and Societies: Mentor ship program- Menteeing Undergraduate students for their career choices and life

Honors In Philosophy And Artificial Intelligence, Philosophy, Comp Science, 3.9

Activities and Societies: Member of AI development club, Philosophy of AI club, Philosophy of Consciousness Club

Master Of Science - Ms, Information Technology