Data Analyst Service Desk

SUKHANDEEP KAUR Email: *************@*****.***

** ****** ***** *****: 551-***-****

East Windsor, NJ 0852

PROFESSIONAL EXPERIENCE

Data Analyst - Market Visibility at Novo Nordisk, New Jersey (July 2024 - Present) Tech Stack: SQL, Excel, Jira, PowerPoint, IQVIA

● Reconcile provider and organization data provided by different vendors against inhouse stored data.

● Create/update dashboard reports created in IQVIA highlighting changes in data. These dashboards are used to gain insights into the company’s market visibility.

● Research market changes on google, create reports highlighting the changes and submit for updates. Data Analyst at Fujitsu, Texas (May 2021 - June 2023) Core responsibility – To collect, process, analyze and visualize large sets of data. Client Portal:

Tech Stack: SQL, Excel, Jira, PowerPoint

● Manage client portal for a big food chain company which had stores located in both USA and Canada.

● Wrote quality Sql queries for various charts and web reports such as daily, weekly and monthly incidents, store trend reports in Excel for service desk and field services.

● Export and manipulate data in Excel for monthly reports also generate excel reports for daily fields dispatched as it keeps track of different locations having any kind of problems.

● Managed Jira board for the team to track various client requirements. Created/updated jira tickets, prioritized them after discussing with client and closed them after the task was completed.

● Created a project roadmap to align with the long-term strategic goals of the client.

● Create business proposals for the project funding, gathered ideas form the developers, and gathering estimates from the technology team

● Publish weekly metrics on project status, effort utilization, issue resolution, scope management etc.

● Made report results in a manner which is both statistically rigorous and compellingly relevant.

● Met the client's expectations of the visualization request provided in the reports. Associate Intern, InMobi (Mobile in App Advertising and Monetization Solutions),New York(Jan 2021- March 2021) Tech Stack: SQL, Excel,PowerPoint

● Worked in a project management team. Did market research of InMobi’s key competitors such as Trade Desk, LiveRamp etc. Focused on the key differences such as operating models, technologies, product offerings etc.

● Generate reports for various ad campaigns of different brands using Creative ids(Every Ad campaigns had a separate creative Id) in Clarity app.

● Used SQL and Excel to retrieve Ad campaign data for a particular brand and generate reports. Example: Johnsons and Johsons(J&J) Ad campaigns of shampoos and soaps etc.

● Trend analysis to find how InMobi was different from its competitors and what improvements could be made to make it better in the digital marketing space using Excel.

Data Analyst Intern, Hudson Modern Seating LLC (chairorama.com), New Castle, DE (June 2020 – Dec 2020) Tech Stack: SQL, Tableau, Excel, PowerPoint

● Assist Enterprise Research Team in executing daily Analytics requests, Market Research and Identify Industry Trends.

● Reduced query retrieval time by automating manual tasks using stored procedures, functions, and PL/SQL scripts.

● Applied regression analysis and inferential statistics to forecast sales using R, Tableau Integration with R and Excel. Technology Analyst, Idea Cellular Ltd., Mohali, India(July 2016 – Feb 2018) Tech Stack: SQL, Tableau, Excel

● Implemented data quality checks through ETL testing of source/target databases for validating the migration framework

● Enabled strategic decision making for senior analysts’ by devising SQL and Informatica adhoc queries and reports

● Decreased run time of SQL queries for analyzing 2 million records by 20% using stored procedures

● Led project of devising KPI’s for ETL framework to communicate results with the client using Advanced Excel and Tableau

● Reduced 35% of manual efforts in test preparation phase by scripting VBA macro application

● Conducted ETL, Tableau and SQL, knowledge transfer workshops for a global team of 7 members. Technical Skills

● Database/ETL/BI: MS SQL Server, Oracle 12c, Dynamic SQL, MS Access, Tableau, Amazon Quicksight, Qlik, Power BI

● Tools: R Studio, JMP, Tableau 10.5, Power BI, Qlik, SAS Enterprise Miner, Tableau integration with R

● Programming Languages: Excel, SQL, Python

● Other Skills: Digital Marketing, PowerPoint Google Analytics, Macros, MS Office, Excel Dashboards, Notepad++.

Education

● Master of Business Intelligence and Analytics, May2020 Saint Joseph’s University, Philadelphia, PA

● Bachelor of Information Technology Engineering, May2016 Punjab Technical University, India

Contact this candidate