Priyanka Jain

Priyanka Jain Email and Phone Number

Data Analytics | Tableau Designer & Developer | Tableau Prep | ETL | Alteryx | SQL @ American Airlines
Priyanka Jain's Location
Fort Worth, Texas, United States, United States
Priyanka Jain's Contact Details

Priyanka Jain personal email

n/a
About Priyanka Jain

Seasoned Data Analyst with + years of experience with a Master’s degree in Management Information Systems striving to leverage substantial experience in Data visualization, SQL and Data Prep/Warehousing.TECHNICAL SKILLS• Data Analytics/ Data Visualization Tools: Tableau, Tableau Prep, Infogram, MS Excel and MS Access • Web Analytics / Market Research: Google Analytics, Google Trends • Database: Teradata, Amazon Aurora, Oracle, MS SQL and MySQL• Data Lifecycle processes: CRSIP-DM (Business & Data Understanding, Data Preparation, Modeling, Evaluation & Deployment)• Advanced Analytics: Cluster Analysis, Text Analytics, Sentiment Analysis, Regression Analysis• Requirement Management Tools: MS Office Suite, MS Project, JIRA, IBM Rational• Data Modeling: IBM Rhapsody, Oracle Designer, MS Visio• Methodology: Agile (Scrum), Waterfall• Enthusiastic to learn: Python, R Programming, Hadoop/ Big Data and NoSQL8

Priyanka Jain's Current Company Details
American Airlines

American Airlines

View
Data Analytics | Tableau Designer & Developer | Tableau Prep | ETL | Alteryx | SQL
Priyanka Jain Work Experience Details
  • American Airlines
    It Business Intelligence Developer
    American Airlines Sep 2020 - Present
    Dallas-Fort Worth, Texas, Us
  • American Airlines
    Sr. Data Analyst, Learning Analytics
    American Airlines Dec 2019 - Sep 2020
    Dallas-Fort Worth, Texas, Us
    • Developed multiple dynamic dashboards, scorecards, and reports for an enterprise-wide upskilling platform called Degreed to deliver actionable insights on utilization and engagement of the team members to managers, learning influencers, and executive leaders • Successfully delivered various adhoc reports and dashboards on request from executive leaders to fulfill urgent business needs. Dashboards were made using Tableau and Infogram. • Led the initiative of upgrading the data feed from Degreed to AA from FTP to API Integration. Conducted due diligence for data requirement from Degreed API for ETL process.• Initiated Learning Measurement Dashboard which reflected a well-understood structure of the business with actionable insights to advocate learning hub compliance, data integrity and process governance.• Facilitated various brainstorming sessions to understand the business problem that can be solved with data reporting.• Created automated data flows to consolidate survey data for various training and classes from different data sources for calculating overall learning KPI’s.• Leveraged Tableau Prep to perform ETL processes. Used functionalities like Data roles, Group & Replace, Aggregation, CTE's, SQL joins & Wildcard unions to summarize the data as required for Data visualization.• Performed data mining on LMS (Learning Management System), Datawarehouse and HRIS database to establish a relationship between key measures, drivers, and available actions for Learning Admin and Learning Solution team.• Used various data exploration techniques like Outlier detection, missing value treatment, Variable Identification, Variable transformation & creation, Cluster size analysis, etc.• Conducted testing sessions with various product owners & SME’s from the various department in the testing and validation sessions using• Facilitated Dashboard Demo’s for more than 100 participants to enhance dashboard engagement and get constructive feedback.
  • Acceleratron
    Contributor
    Acceleratron Aug 2020 - Present
    Pune, In
  • United Airlines
    Business Data Analyst
    United Airlines Sep 2017 - Dec 2019
    Chicago, Il, Us
    • Analyzed enterprise data from legacy systems to identify abnormal data patterns, process faults and data discrepancies.• Developed a database tool to compare monthly level pilot pay data from the new pay system and the old system to check the accuracy in pay.• Worked on extracting data of various business processes on request from different business groups.• Analyzed data flow between the integrated system to understand the mapping schema – tools used are SQL, RDBMS, Mainframes, Couchbase queries.• Exported test data from the legacy system for end-to-end testing.• Defined JSON services structure after analyzing the UI requirements, current data model and business rules.• Authored detailed data service requirement document & data mapping sheet for the development team.• Used Postman, Rest API calls to test the communication of services between UI and backend.• Participated in detailed discussions to develop data elements and data specification for data mapping sheet • Reviewed, analyzed, and evaluated business rules and worked on automating business processes. • Facilitated UAT sessions and extracted test data for data validation. Conducted brainstorming sessions with business to map out business rules.• Work closely with testing team to build test case and perform manual testing.• Trace the ongoing issues/tasks and set follow-up meetings with relevant stakeholders to complete the task.• Communicate new business rules and modifications with vendor’s business analysts and development team.
  • The University Of Akron
    Graduate Research Assistant
    The University Of Akron Aug 2015 - Aug 2016
    Analyzed 1 million rows of data with information on 6,000 lighting products of a firm and to develop geographical pricing and discount strategy.• Deliverables: Provided business insights to improve sales and revenue based on data analysis and visualization using Tableau. Also, CRSIP-DM detailed report covering: Business Understanding and Data Understanding.• Worked on Data Preparation, Modeling, Evaluation and Recommendations and fully annotated knime workflow.• Developed relevant patterns based on graphs with geography and discount rates as focus areas.• Worked on collaborating, extracting, cleaning and blending the data from multiple platforms.• Created dashboards and reports with graphs and recommendations to increase their market share.• Excelled the skill of visualization, statistics and data mining techniques to empower business strategy.• Identified, Analyzed, interpreted the trends/patterns and presented the story of data.• Tools and Technology: Tableau, MS Excel, MS Access and MS Word
  • Unisys
    Business Intelligence Analyst
    Unisys Nov 2013 - Nov 2014
    Blue Bell, Pennsylvania, Us
    • Worked with the Business Intelligence Team to deliver BI visualizations to satisfy business needs using Tableau and communicated them effectively to non-technical audiences.• Spearheaded and engineered SWOT analyses, Cluster Analysis, Regression Analyses and guided operational teams to pro-actively leverage recommendations from us and to meet business goals and objectives in timely manner.• Utilized variety and diverse tables/views on DB's like Teradata, SQL Server, Google Analytics, Oracle and IBM DB2 for harnessing the data to improve Quality, Accuracy and usefulness of Metrics/KPI's.• Remodeled Customer Access Savings visualizations using Master Data for Executive leadership and Product owners for them to quantify dollars saved and time saved by implementation of Self-Service website for clients.• Served as a team member of Data team for Service ART Train working in SPRINTS and used Scaled Agile Framework to work with stakeholders on Analytical Data projects, data maintenance and data acquisition needs.

Priyanka Jain Skills

Ms Access Python Microsoft Office Ibm Db2 Data Analysis Data Governance Sql Microsoft Excel Business Intelligence Tools Teradata Data Warehouse Pl/sql Oracle Designer Rhapsody My Sql Developer Tableau Ms Excel Infogram Databases

Priyanka Jain Education Details

  • The University Of Akron
    The University Of Akron
    Management Information Systems
  • Gyan Ganga Institute Of Technology Sciences
    Gyan Ganga Institute Of Technology Sciences
    Information Technology

Frequently Asked Questions about Priyanka Jain

What company does Priyanka Jain work for?

Priyanka Jain works for American Airlines

What is Priyanka Jain's role at the current company?

Priyanka Jain's current role is Data Analytics | Tableau Designer & Developer | Tableau Prep | ETL | Alteryx | SQL.

What is Priyanka Jain's email address?

Priyanka Jain's email address is pr****@****ted.com

What schools did Priyanka Jain attend?

Priyanka Jain attended The University Of Akron, Gyan Ganga Institute Of Technology Sciences.

What skills is Priyanka Jain known for?

Priyanka Jain has skills like Ms Access, Python, Microsoft Office, Ibm Db2, Data Analysis, Data Governance, Sql, Microsoft Excel, Business Intelligence Tools, Teradata Data Warehouse, Pl/sql, Oracle Designer.

Free Chrome Extension

Find emails, phones & company data instantly

Find verified emails from LinkedIn profiles
Get direct phone numbers & mobile contacts
Access company data & employee information
Works directly on LinkedIn - no copy/paste needed
Get Chrome Extension - Free

Aero Online

Your AI prospecting assistant

Download 750 million emails and 100 million phone numbers

Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.