Learn Data Skills
Beta
Giniya Gupta

Giniya Gupta

Instructor

Senior Analyst

Mastercard

Data whisperer, decoding the language of numbers with finesse.

Authored Curriculum

Take a look at the content that I created on DataCamp.

My Most Recent Course

Case Study: Analyzing Fitness Data in Alteryx

3 hours4 Videos20 Exercises26 Learners

My Certifications

These are the industry credentials that I’ve earned.

Other Certificates

Alteryx Designer Advanced Certification

My Work Experience

Where I've interned and worked during my career.

Mastercard | Jan 2023 - Present

Senior Analyst ( Analytics & Automation team)

• Identify, design and implement data and process automation solutions to support GBSC Operations and the global organization • Develop new queries and Alteryx flows for extracting, transforming and analyzing data to address project requirements • Develop dashboards and reports that adhere to the visualization best practices and communicate a story • Build and support an infrastructure to enable effectively working with large sets of unstructured and structured data • Create Python scripts to automate repetitive tasks
Show More

Bayer Crop Science | Dec 2020 - Jan 2023

Data Visualization Engineer

• Develop and support global data visualizations to enable prescriptive operations and optimize pipeline processes and transparency through increased data visibility • Leverage diverse technology platforms to refine and automate data sources, harmonize data points, and model "what if" scenarios that can be used to evaluate and predict the impact to performance • Use ETL tools e.g. BIOVIA Pipeline Pilot and Tableau Prep to perform data modeling and apply appropriate logics to allow smooth data flow to BI tools in appropriate format to optimize performance • Work with APIs to retrieve required data. Use Postman to get insight into the features of API, understand data model and test connection with API Flavors of Cross-Validation - The motivation behind using cross- validation Tableau - Design, develop, conduct unit testing, and maintain complex Tableau reports for scalability, manageability, extensibility, performance, and re-use - Determine the best implementation that will meet the design of the architect - Resolving any data or performance issues related to workbooks and data sources Spotfire - Develop reports in the Spotfire environment applying existing standards and processes - Use Iron Python scripting language to create action buttons on the Visualization - Continuously monitor the environment and reports to ensure maximum accuracy and reliability - Exercise continuous process improvement to keep the environment up to date by constantly reviewing standards and processes used by the development team - Respond to change requests to keep reports in compliance as business requirements evolve - Create reporting tools that facilitate quality of results, maintenance of reference data, and operational insights - Document results to facilitate business continuity and audit compliance Google Cloud Platform/ Big Query - Work with complex SQL datasets and building SQL scripts using Big Query Syntax - Create data views to be used in various data visualization tools e.g. Tableau, Google Data studio

Maryville University of Saint Louis | Jan 2019 - Dec 2020

Data Science Student (Masters)

• Data Visualization and Reporting: Tableau, Power BI, Spotfire, Visual Studio, ggplot, Matplotlib, Seaborn, R shiny and Pipeline Pilot • Languages: Python (Pandas, Numpy, Scikit-Learn,Keras , Tensorflow), R, Relational Database – SQL and Oracle • Statistical Modeling and Machine Learning: Predictive Modelling, Linear Regression, Logistic Regression, CNN • Proficient with MS Office, including MS Excel, MS Word and MS PowerPoint

TD Ameritrade | May 2020 - Aug 2020

Platform Engineering Intern

• Worked with DevOps team and used Unix/Linux, Jenkins, Version Control System (Bitbucket, Git bash, SourceTree), intelliJ, Gradle to create and modify Jenkins file, perform package releases and ensure the CI/CD and change management process follows • Updated Jenkins file to ensure the required Python environment is properly configured on Jenkins nodes/agents • Worked as JIRA admin and created team specific Agile process flow in JIRA to move tasks from one activity to another • Creating Jira confluence pages for organizing and creating documents and discussing projects • Using Kanban (Agile) board to track and visualize task progress Project(s) Automate addition of servers to Zabbix for monitoring servers’ health - Created and deployed reusable YAML script to automate the process of adding Content Intelligence Platform servers to Zabbix using Ansible, which resulted in reducing manual effort, errors, helped saving time by pushing updates to servers automatically - Authenticated Jenkins and Jira synchronizing Ensure appropriate Python environment is configured on Jenkins nodes and agents - Troubleshooted new Jenkins enhancements for new environment’s configuration and customization - Updated Jenkins file to ensure the required Python environment is properly configured on Jenkins nodes/agents - Created Jenkins job and modified build.gradle file to create gradle task to run pip command to pull appropriate python module

Barry-Wehmiller Design Group | Feb 2020 - May 2020

Data Science Intern

PowerBI - Used various sources to pull data in PowerBI such as SQL server, SAPBW, Oracle, SQL-Azure - Expertise in writing complex DAX function in PowerBI and Power Pivot - Wrote calculated columns, measure queries in PowerBI Desktop to show good data analysis techniques - Worked on all kind of reports such as yearly, quarterly, monthly and daily - Wrote SQL queries to pull data into Power Pivot Model - Filtered bad data using derived columns and conditional splits - Created drill down reports, drill through reports by regions - Used Microsoft Teams and SharePoint to coordinate with Team Mates and keep track of project progress Project (KACE ticketing system) - Designed data models using DAX, SQL queries and power query to analyze data from KACE ticketing system to assess performance (KPI) of IT technicians - Created strategic, tactical and operational Power BI dashboards and Scorecards (KPI) for visualizing IT ticket creation and resolution - Created data visualization capable of granularity varying from hourly to annually and across regions.

SSM Health St. Louis | Oct 2015 - Present

Physical Therapist

N/A

Kindred Healthcare/ Rehabcare | Dec 2013 - Jun 2019

Physical Therapist

N/A

My Education

Take a look at my formal education

Master of Science in Data Science - MS, Data Science  · (JanuaryMaryville University of Saint Louis | 2020
Guru Nanak Dev University

About Me

Giniya Gupta

Giniya is a Senior Analyst at Mastercard, where she focuses on converting data into insights using Tableau, Alteryx, SQL, and Python. Previously, she worked as a Data Visualization Engineer at Bayer. Giniya holds a Master's degree in Data Science.

Powered by

  • Curriculum
  • Certifications
  • Experience
  • Education
  • About Me
  • Create Your Data Portfolio for Free