gurpreet jassal

* Working as database analyst for Water Chemistry project. Retrieving data queries and creating reports as per the requirement using SQL Server Management. Using Pivot tables to manipulate the data and get the desired output. * Created a website for Lytica using WordPress with embedded payment and Login options. It also lets you upload and download the required documents and join as a customer. * Working for Knowledge Circle (client) to enter data into their WordPress website. * Working to create a sentiment engine in Microsoft Azure and Power BI to get the live tweets and storing them on a data stream and then using PowerBI to generate visual graphs.

Working as data Analyst and handling the back end data for YellowDot in Nigeria. Working in the VAS team and analyzing the data to help increase the revenue of the company and providing solutions to the companies to increase the sale and revenue of their company. The data to be analysed is of IVRs that are run in all over South Africa. The clients are scattered all over South Africa and the back end data is analysed in India.

Worked as Marketing/Academic counsellor for prospect students who are interested in International education. Conducted various seminars in Punjab area and met students and counselled them and suggested them the right course/program for them in Canada. Helped faculty and marketing team with the strategies to retain maximum students and worked on presentations for the seminars. Individual counselling’s and group counselling’s were conducted. Visited various WWICS offices all over India and helped the staff as to how to promote the international education and the positives and negatives as well. Counselled students who were going to take transfer to Canada as to what they need to know about the Canada and how different it is in Canada.

* Utilize knowledge of the food menu, wine & liquor menu, ingredients in specialty drinks to make the perfect recommendation for each customer * Trained new servers on how to create an excellent dining experience and developed restaurant menu * Handled customer complaints and always ensured customers left with a smile * Ensured entire bar area, including bar top, floors, tables, and stools are clean and free of clutter at all times * Performed stocking duties and inventory maintenance before, during, and after every shift * Make a constant effort to become familiar with regular customers and how to meet their needs * Shining silverware & glassware, replenishing station stock and cleaning duties. * Ensure patrons have everything they need to ensure a pleasant dining experience. * Responsible for closing duties, restocking beer/liquor bottles, cleaning and garbage disposing * Maintained clean and professional upscale appearance

Worked as a software designer for their real estate project. Worked on the frontend of the project and making changes to the code according to the client requirements. Created documentation for all the learning undertaken while working on the project. Development environment involves working on PHP and Java programming and MongoDB for the database.

Worked as Technical Analyst in Pricing Department. Developed tools and processes for automating and enhancing various pricing department duties. Created standard and ad hoc reports for pricing and promotional analysis. Debugged/augmented existing processes to tailor project revisions. Ran ad hoc queries for investigations and scenarios to achieve desired results. Analyzed and made design decisions based on progressively changing project requirements. Created Macros for updating pricing information in CICS system and also to update monthly reports for excel sheets and databases.

Worked as a programmer for Hospital Management System at Pulse Engineering, a software company in Mohali, India. Designed a database in MS Access and programmed in Visual Basic.NET.

Worked as a lead software developer for Student Management System. Coded in VB.NET and used MS Access as the backend for database. Documented the full documentation of the project. Learnt ASP.NET to make the software available online for different institutions. Project is still under the coding phase and would be completed in December 2011 as scheduled. Developed Online Quiz software using PHP and SQL. This quiz checks the mental level of student in 3 different areas: aptitude, technical and creativity. Generates random questions for every user and stores the score in a CSV file. Admin is given the access to the full system. Admin can add, delete or edit the questions.

Worked in Finance and Planning Department. Coded macros in VBA for the annual templates for the bank and generated annual reports in excel using pivot tables. Generated queries in MS Access and DB2. Documented the working of the various templates and the ways to extract the data into the excel worksheet using the given set of queries for the users. Developed a query library in Excel for the future references of the basic queries run almost every month. Created a checklist of the steps to create an annual report using the queries.

Graduated. Completed a Computer Systems: Operations & Management diploma in December 2008. Activities and Societies: I have volunteered for many event management plans and setup while studying. I have also volunteered for International day which is the main event in the university. Even done similar volunteering in India as well. Have dealt with customers of all age groups and have a little bit experience in marketing as well. Have an experience of hosting many events in both school and college. Have been an MC in various functions. Have tutored students in university.