Navneet Kaur

289-***-****

adltcn@r.postjobfree.com

PROFILE HIGHLIGHTS

Experience in working with relational database and SQL Server

Strong math, problem-solving, and troubleshooting skills

Ability to lead a team of analyst and driving projects

Excellent knowledge of data management, and data analysis

Excellent interpersonal, communication and presentation skills

TECHNICAL EXPERTISE & EXPERIENCE

Strong knowledge of Databases (Microsoft Access, SQL Server)

Java, Visual Basic, SharePoint, JavaScript, VBA

Knowledge of HTML and PHP

TCP/IP, DNS, Network Programming and troubleshooting

Web Planning and Design (CSS, Templates, Scripts)

Ability to work with several operating systems including Windows, Mac OSX, and Linux.

Advanced knowledge of MS Office (Word, Visio, Outlook, Project, Excel, PPT and Access 2010/13)

Software Development Lifecycle Methodologies and Quality Assurance

Experience with documentations and QA methodologies

Basic knowledge of video conferencing tools (WebEx and Lync)

PROFESSIONAL EXPERIENCE

International Credit Experts Woodbridge, Ontario

Data Analyst Feb 2018 - Present

Use Python to create scripts for generating excel files

Work with all python libraries for generating data

Work closely with the product manager in assisting his day to day data analysis and reporting needs.

Created daily, weekly, monthly, and adhoc reports for business units using SQL queries and Microsoft Excel.

Manipulate data using advanced SQL queries including Aggregate Functions, Sub-Queries, Joins, Group Functions and Single Row Functions.

Write SQL queries for complex business scenarios joining multiple client databases and retrieving client attributes from multiple application systems.

Gather data from various upstream systems (data source) and create reports based on business needs.

Proficient in working with large datasets, exporting SQL query results into excel sheet, organizing and cleaning data in a clear, concise format to be easy readable and understandable by business users.

Use Microsoft Excel formulas (V-lookup and Aggregate Functions) and VBA macros to organize, clean up and format various data sets into required format and structure for use by business stakeholder

Concentrix Hamilton, Ontario

Data Clerk March 2017 – June 2017

Responsible for updating and maintaining the data repositories of the organization

Required to communicate with the various departments to gather user requirements and execute standard operational procedures

Ensure the stability and reliability of data access and data quality across the organization via ongoing database support and maintenance

Develop and deploy end-user practices and tools for data extraction, queries, and data manipulation in accordance with business processes

Import and/or export data between different kinds of software

Mentor Punjab, India

Intermediate .Net Developer Jan.2016 – March 2016

Responsible for updating and maintaining the data repositories of the organization

Designed and developed technical solutions for .NET applications

Extracted, complied and tracked data and analyzed data to generate reports

Import and/or export data between different kinds of software

Reviewed codes and made recommendations for improvements

Developing new systems according to client needs

Maintaining existing system

Providing external and internal user support

VOLUNTEER WORK

International Volunteer Mohawk College

oThe Spring Orientation Sep 2017 - Dec 2018

oInternational Student Orientation

oAn International Dinner Event

Universal Children & Youth Day celebration

EDUCATION & CERTIFICATIONS

Computer System Technician - Software Support Mohawk College

Hamilton, ON, - Jan 2017 to Dec 2018

Majoring in Programming languages & Database and Project Planning & Requirement Analysis

Crucial Conversations Certification Vital Smarts

Toronto, ON, Aug 14 2016

Higher Secondary Certification Guru Hargobind Sr. Secondary

Sidhwan Khurd, Punjab – Mar 2011 to Mar 2013

Graduated with an overall in 8.4 grade in Chemistry, Physics, Mathematics and Computers

REFERENCES

References available upon request

Contact this candidate