ABHAAS KATIYAL
Austin,Texas
Summary
An analytical and strategic professional boasting over 7 years of expertise in business intelligence, data analysis, pattern recognition, and converting intricate data into actionable insights. Demonstrated success in improving business processes and decision-making with data-driven approaches that reduce losses and boost business and sales efficiency. A highly driven individual eager to embrace new challenges and provide outstanding analytical perspectives, whether working independently or leading a team. Possesses robust work ethics, adaptability, and excellent interpersonal abilities.
Overview
9
9
years of professional experience
1
1
Certification
Work History
Senior Consultant/Manager
Visa Inc.
Austin, Texas
10.2022 - 06.2024
- Own execution: Define creative, high-quality roadmaps supporting the BI vision, consistent with team priorities, partner team planning, and existing tools capabilities; work closely with engineering teams across Visa to deliver on the roadmap, including collaboration with partners to drive necessary changes to Fraud and Risk Analytics dashboards; lead development of new BI Dashboards or processes
- Design, develop and establish KPIs to monitor analysis and provide strategic insights to drive growth and performance for DPS clients
- Collaborated with Sales team to create BI dashboards which enhanced sales funnel
- Created reports and analyzed data to bring up the lead’s generation to sales conversion ratio up by 15%
- Designed analytics reporting models to analyze 83+ RA clients Fraud data, Authorization, MCC and country data
- Collaborated with executive leadership to align analytics projects with business objectives, influencing a key shift in strategic focus
- Continually improve ongoing reporting and analysis processes, automating or simplifying self-service support for secondary datasets
- Recognized and awarded by Visa for contributing to process optimization and positively influencing their operational procedures.
- Provide technical guidance and coaching and expertise to team members, colleagues and/or customers
- Automated the process of daily monitoring fraud data using automation anywhere, macro automation and tableau which reduced the time preparation by 70%
Data Specialist
Nokia of America Corporation
Dallas, Texas
09.2020 - 10.2022
- Initiated and led cross-functional teams that delivered a customer analytics platform, increasing customer retention rates by 15%.
- Prepare design document and report document to help end user to understand report architecture
- Identify key performance indicators with clear objectives and consistently monitor those on Power BI reports
- Delegated with different teams like service now and database team to get different data from different source and build multiple reports using DAX queries and calculations
- Perform monthly publication of SharePoint reports to Power BI to provide KPI data to different stakeholders in Nokia
- Participate in quality or process improvement activities, including regular reviews of systems and technology
- Design and implement modifications or improvements, based on those activities
- Reporting of key insight trends, using statistical rigor to simplify and inform the larger team of noteworthy story lines
- Successfully integrated CRM data with ERP and migrated data into SQL to enhance customer interaction and increase sales proficiency by 10%
- Addressed data retention issue in database and established data policy rules for data retention to increase database performance by 40%
BI Consultant
Fusion Consulting Inc
Farmers Branch, Texas
07.2020 - 08.2020
- Developed Tableau data visualization using cross tabs, Heat Maps, Box and Whisker Charts to visualize healthcare data for multiple stakeholders
- Integrated tableau and juptyer to analyze the sales forecasting trends and charts
- Prepared presentations summarizing findings from data analysis projects
- Analyzed user requirements to design custom BI solutions for clients
- Designed models, algorithms and visualizations to distill insights from huge volumes of data.
- Performed exploratory analysis on large datasets using SQL and Python libraries such as Pandas, NumPy, Scikit-Learn, and Matplotlib.
Enterprise Technology Solution
OCC
Coppell, Texas
01.2020 - 05.2020
- Acted as liaison between the Business Stakeholders and Developers to discuss business requirements, created user stories in JIRA in with defined metrics and unambiguous acceptance criteria leading to 10% development time
- Collaborated with IT Compliance, Information Governance team to streamline the annual review process in ServiceNow that eliminated the need for 3 disparate systems (email, excel, word), improving efficiency by 30%
- Conducted analysis on Procurement data in ServiceNow and Oracle, identified discrepancies and provided recommendations to modify Asset Build workflow to harmonize data in ServiceNow and Oracle
Healthcare Analytics Consultant
NTT DATA SERVICES
Plano, Texas
07.2019 - 12.2019
- Collaborated with business partners and sales teams to understand, improve business and sales process, formulated solution needs, created healthcare product feature-process documentation to enhance sales pipeline
- Created new improved business intelligence solutions, SQL queries, Tableau or mode analytics reports, dashboards to provide visibility into the healthcare data in the healthcare pipeline in-transit to enhance customer response time 7%
- Attended professional conferences and workshops related to current trends in healthcare delivery systems.
- Designed and implemented data models, database structures, data mining algorithms, and ETL processes for healthcare analytics projects.
- Supported scrum teams in agile ceremonies including backlog grooming, sprint planning, daily scrum, led sprint reviews and attends sprint retrospectives
- Championed the adoption of a tailored data governance strategy, enhancing data quality and accessibility for analytics purposes
- Researched emerging technologies related to healthcare analytics and made recommendations accordingly.
- Created reports for senior leadership utilizing advanced analytics techniques.
Lead Programmer Analyst
Cognizant Technology Solutions
Kolkata, West Bengal
12.2015 - 07.2018
- Managed a team of 4 data analyst to implement the use of Excel functions (VLOOKUP, Pivot Table) and PowerBI reports to help Underwriters in making premium decisions based on Customer data.
- Drove advanced analytics projects at Cognizant which increased clients' operational efficiency by an average of 30% through Analytics and data visualization techniques.
- Cultivated a culture of continuous improvement by mentoring analytics personnel, leading to a 50% increase in the team's productivity and output quality at Cognizant.
- Facilitated multiple training sessions on implementing best practices for SDLC, data integrity, data quality process and agile methodologies for the incoming new hires in Cognizant Technology Solutions.
Education
Masters - Information Technology & Management
The University of Texas at Dallas
05.2020
Bachelors - Computer Engineering
Institute of Engineering & Technology, DAVV India
05.2015
Skills
- Python
- SQL
- R
- AWS
- Tableau Desktop/Server
- Power BI
- Alteryx
- CRM - ServiceNow
- Salesforce
- Data Robot
- VS code
- Data Analytics
- Business Analysis
- Project Management
- Data Visualization
- Database Design
- Statistical Analysis
- Analytical Thinking
- Strong Communication and Interpersonal Skills
- Strong presentation skills
Affiliations
- I am a elite Fashion Model
- I am a dancer
Languages
English
Full Professional
Hindi
Full Professional
Certification
- Alteryx
- Google Analytics
- Python Linkedln Learning
- SQL Linkedln Learning
Timeline
Senior Consultant/Manager
Visa Inc.
10.2022 - 06.2024
Data Specialist
Nokia of America Corporation
09.2020 - 10.2022
BI Consultant
Fusion Consulting Inc
07.2020 - 08.2020
Enterprise Technology Solution
OCC
01.2020 - 05.2020
Healthcare Analytics Consultant
NTT DATA SERVICES
07.2019 - 12.2019
Lead Programmer Analyst
Cognizant Technology Solutions
12.2015 - 07.2018
Masters - Information Technology & Management
The University of Texas at Dallas
Bachelors - Computer Engineering
Institute of Engineering & Technology, DAVV India