Senior Data Analyst, People Analytics

• Oct 2019 - Present

Senior Data Analyst, HR Reporting and Analytics at AbbVie

• Apr 2019 - Oct 2019

• Design and create adhoc custom reports based on the Business user requirements in Workday• Creating matrix reports in Workday using calculated fields to meet business requirements• Using Tableau and PRISM Analytics to analyze HR data , get meaningful insight and presenting it to HR leaders as ongoing or adhoc dashboards

Data Analyst(People Insight)

• Mar 2018 - Mar 2019

• Created ‘enterprise human capital dashboard’ with headcount, turnover, movement, talent and performance metrics, using Alteryx for ETL and Tableau for visualization, which reduced individual data analysis requests by 70%• Developed data prep and data enrichment workflows in Alteryx - defined data cleansing rules, table joins, unions and other SQL-related processes to support data analysis requests by various functions• Preparing dashboards and stories in Tableau developer and publishing on Tableau server using calculations, parameters, calculated fields, groups, sets and hierarchies to find trends and patterns that support business decision making.• Joined, prepared and cleaned data from various internal and external sources to develop a turnover predicting statistical model using R and Alteryx• Providing the Security while publishing dashboards to the Tableau Server. Show less

Data Analyst Intern

• May 2017 - Feb 2018

• Performed SQL query tuning and provided performance tuning recommendations for time consuming reports which were frequently used for contracts renewals, resulting in performance improvement by 50% • Developed reports/KPI dashboards using Tableau, Alteryx and excel by pulling out data from SAP databases , which identified the pattern of incoming commission cases in a month • Created ad-hoc reports and dashboards for client requirements, created clear and illustrative story points in Tableau and presented the insights of the analysis to stakeholders. • Worked with cross functional teams for gathering data on various processes, cleaned it using tools like MS Excel /R and created visualization using Tableau to depict the pain areas in the process • Analyzed historical data from SAP and other applications , came up with a monthly and quarterly pattern and presented my findings by creating views on Tableau , which helped optimize resource allocation process Show less

Consultant

• May 2015 - Dec 2015

• Engaged with client, functional consultants to gather requirements and understand business rules to ensure alignment with the development team • Preparing data and enforcing row level data security using Alteryx for multiple Tableau dashboards published on the server • Involved in dashboard creation using Tableau for different business units which helped them in better resource allocation • Engaged with client, functional consultants to gather requirements and understand business rules to ensure alignment with the development team • Preparing data and enforcing row level data security using Alteryx for multiple Tableau dashboards published on the server • Involved in dashboard creation using Tableau for different business units which helped them in better resource allocation

SYSTEMS ENGINEER

• Sep 2011 - Apr 2015

Client-Honeywell (Aerospace & Manufacturing) • Did troubleshooting and root cause analysis for the issues arising in the PLM (Product Lifecycle Management) application of the client with no SLA violations • Developed dashboards using alteryx and Tableau to show the status of support tickets and overall health of the project Client-GE Oil and Gas (Oil and Gas) • Rolled out SAP ERP for the France unit of the client. Made changes in standard reports, SmartForms and other SAP objects to fulfill the custom requirements of the unit • Automated the process of printing specification plates on newly built turbines. Created report to pull out specification data from SAP and used process integration to feed data into the printing machine through FTP server Client-Applied materials (Semi-Conductor & Manufacturing) • Analyzed data and drawings from SAP and Teamcenter PLM for spare parts of semiconductor manufacturing tools and decided their price & target margin based on factors like quality of material, functionality,etc. Show less