Gaganpreet Singh Email & Phone Number

Halifax, Nova Scotia, Canada

Canada

Halifax, Canada Area

• Responsible for building SQL queries to prepare the data for Data scientists on AWS Redshift database.• Created the entire AWS infrastructure for the team using Terraform.• Analyzed data in SageMaker’s Notebook instances using python and shared results with the team on regular basis.• Currently working on to migrate the end-to-end database development pipeline built on R to Apache Airflow to make it more robust and fault-tolerant.Tools: AWS Sagemaker, Terraform, Apache Airflow, Redshift, CodeCommit, Jupyter Notebooks(Python and R), EC2, S3

Halifax, Canada Area

IMAGE SCRAPING• Scraped 1M+ websites snapshots of over 10,000 firms over time.• Responsible for storing the data on cloud in structural way.Tools: Python - pandas, Selenium, PhantomJS, Linux - CentosMACHINE LEARNING• Developed Neural network-based machine learning model using transfer learning to predict the company’s environmental violation status from their website snapshots.Tools: Python - keras, pandas, Numpy, Google Colab

Pune, Maharashtra, India

DATA ANALYSIS• Analyzed 5 years of data scraped from ticketing tool consisting for issues received for various applications to gain meaningful insights to streamline the ticket resolution process.• Analysis results in annual savings of 88 hours of support team of the project leading to annual monetary savings of 8067 USD.Tools: HP ServiceNow, Microsoft ExcelPYTHON DEVELOPER• Built a text match system leveraging NLP and fuzzy match criteria to determine Fraudulent profiles.Tools: Spyder, Jupyter Notebook, Python - fuzzywuzzy, soundexSAP CONSULTANT• Master Data replication belong to vendors, Materials, Purchasing Organization, Purchasing groups and plants from SAP R/3 to SRM, IDOC configuration.• Implemented a solution to automate the process of Used Ids mapped to correct Organization Structure.• Team’s efforts ensured the annual savings of 108K USD for the client and 13K USD savings for Infosys owing to reduced incident count.Tools: SAP SRM 7.0

Pune Area, India

Worked in Procurement domain for one the world's largest Consumer product client.Environment – SAP SRM 7.0 , SAP ECC 6.0Role – Functional Consultant• Working as a part of the functional and technical team for Consumers product client with SAP SRM 7.0 and SAP ECC 6.0 version.• Working on P2P(Procure to pay) environment consisting of Classic Scenario with multiple backend systems. • Good exposure to SAP SRM and SAP ABAP with experience in support to many custom applications like MyPurchases, Easy Pricing(EZP), SupplierPortal.• Working on Shopping cart creation process, Purchase order, Purchase requisition, confirmation and invoicing process. • Working on HP Service Now and HPSM(HP Service Manager) ticketing tool on Incident Management, Fulfilment management, problem management, and Change management activities.• Experience of Organizational builds out as per business hierarchy, User profile creation and management, Attribute configuration for users. • Master Data replication belong to vendors, Materials, Purchasing Organisation, Purchasing groups and plants from SAP R/3 to SRM, IDOC configuration. • Resolved various issues related to the Approval level workflow in shopping carts, PO errors, confirmation issues, IDOC Failures.• Familiar with cross-application components such as BADI, BAPI, IDOC. • Handling the Incident/problem tickets coming from various GEOs (Europe, ASIA, USA etc.) • In EBP, configuration mainly in the areas like Organisational Structure mapping, Assigning attributes like company Code, Plant.

Mysuru Area, India

Trainee Management System using SAP ABAPResponsibilities: It was a training completion final project that demanded an automated system for in-house employees since their joining in the company till they are allocated to their project location. Three independent interfaces were made for Training Admins, Trainees & Delivery Team to automate their work. DDIC tables, SAP Script, ALV Grid, ALV Report, Smart Form, BAPI, Dialog Programming using OOPs were used in the project.Environment: SAP R/3 ABAP 6.0

New Delhi Area, India

• Govt of India enterprise responsible for providing broadband and VPN services to Indian Railways.• Learned about various networking areas like OSI model, IP addressing , VLANS etc.• Worked in CNOC(Central Network Operating Center) responsible for handling Query/Complaints regarding data network.• Worked on Cisco Packet Tracer for Configuring Static , RIP, OSPF Routing.• Involved in mini project Information technology Infrastructure Management System(IT - IMS) – responsible for configuring IP routing and inter – VLAN communication

New Delhi Area, India

• Involved in extensive study of working for various units of Power plant .• Regular Visits to site locations of various Power plant units.• Worked in various laboratories and involved in activities in monitoring and reporting of various plant parameters like pressure, temperature, flow etc.

New Delhi Area, India

• Worked as a marketing intern for the website. My responsibility was to promote the website over the social media websites.• We developed pages and blogs for the same over Facebook and Instagram. The aim was to increase number of people visiting it so as to make it popular among people and increase business. • Analyzed other pages and strategies by similar travel and tour agencies via pamphlets, online presence and advertisements. Found points for improving the same.• I was also responsible for talking to tentative clients and assisting them about the company, website, tours offered, amenities included and prices. • Took feedback from people and clients for website and Facebook page to improve the UI and accessibility of various tabs/links to a prospective user. We collected responses and criticism from visitors and sorted them according to feasibility and priority to make a plan on what changes could be done in upcoming weeks.

Master Of Science - Ms, Computing & Data Analytics

Bachelor Of Technology (Btech), Electronics And Communications Engineering

Education record