Jivin John
511 Colfelt Court,PA
Summary
Analytically and creatively keen to expand beyond traditional tools and techniques to advance both internal business goals and data analytics pursuits. Derives excellence from personnel by providing exemplary leadership and technical expertise. Skilled creator of cohesive, productive teams exploiting every bit of available data.
Overview
9
9
years of professional experience
Work History
Data Scientist
PayPal
Remote
09.2020 - Current
- Translated business requirements into data-driven solutions, providing value-added insights that directly contributed to the organization's strategic goals.
- Developed custom data analytics solutions, leading to improved operational performance and strategic planning.
- Extracted and assessed data from databases to drive improvement of product development and business strategies and processes.
- Utilized advanced querying, visualization and analytics tools to analyze and process complex data sets.
- Optimized business processes for increased efficiency through detailed data analysis using visualization tools.
- Streamlined data collection methods to improve quality control measures and minimize errors in analysis results.
- Cleaned transformed, and analyzed large datasets to uncover hidden trends and patterns for actionable insights.
- Discovered stories told by data to present information to business stakeholders
- Presented complex findings in a clear, concise manner using visualizations that informed executive decision-making processes.
- Implemented advanced statistical techniques for accurate predictive modeling and forecasting of business metrics to increase productivity.
- Managed and mentored team members in best practices for data mining, analysis and fostering a culture of continuous improvement.
- Ensured compliance with industry regulations and data privacy standards, mitigating risks associated with sensitive information handling.
- Participated actively in interdisciplinary team's work integrating domain knowledge from marketing, sales or finance departments into the analytical process.
- Automated repetitive tasks using scripting languages such as Python or R, saving time during the analytical process significantly.
- Worked with stakeholders to develop quarterly roadmaps based on impact
- Identified, measured and recommended improvement strategies for KPIs across Global Merchant Lending team.
- Evaluated emerging technologies to assess potential applications within the organization's existing infrastructure or future projects.
- Conducted feature engineering efforts to enhance model performance by creating new relevant variables from raw input data sources.
Business Analytics Lead
Qurate Retail Group
07.2019 - 09.2020
- Create tables and BI views using Teradata
- Advance Analytics using Python
- Working closely with business partners to understand the requirements to build analytical tools to achieve business goals
- SQL Scripting to create BI views for better performance
- Manage complex project to completeness acting as Liaison with business and technology team
- Automating manual reporting for informative and timely use of Insights
- Build Visualization for business in Tableau and Power BI
- Creating various reporting objects in Tableau (Hierarchies, Sets, Groups and Calculation Fields) Create Prompts, customized calculations, and Filters for specific business need
- Extensive use of data blending feature in Tableau
- Power BI experience in creating DAX formula in tabular data model (All DAX data type) visualizations in Power BI
- Build Ad-hoc report for internal teams, Build reports and insights on large datasets
- Create strategic deep dive analysis and Insights to identify business areas, process to be efficient
- Consult with business partners to be a lead in providing strategic data solutions to achieve business goal
- Liaison with EDW team to bring meaningful data for operations and creating useful FC level KPI
- Partner with cloud team to migrate data into cloud environment.
Data Modeler/ Data Evangelist
Lincoln Financial
07.2017 - 07.2019
- Develop impactful reports and dashboards using Microstrategy Developer and web
- Assist on production updates, Microstrategy upgrades, project rollouts, schema related modifications
- Build schema in Microstrategy Developer for new business analytics purpose (During M&A)
- Support business in providing application support on IT –related issues in Microstrategy reporting area
- Work closely with the product owner to make sure consistent and seamless solutions are provided
- Work with the Microstrategy team to reduce the cube run time process
- Create new attributes and metrics as per business reporting needs relating to retirement, pensions
- Automate reports in Microstrategy web and mobile from data that is manually provided and generated from product owners
- Trained officially to be MCMA (Microstrategy Certified Master Analyst)
- Point of contact for >1000 Financial Advisors to customize Salesforce.com Account Contact, Activity, Advisor designed profiles, permissions, roles, and performed QA, UAT on custom user interface using Visualforce
- Design and integrate various financial and reporting application for Single-Sign-On enablement in Salesforce.com and build environment for QA with development team to implement solutions.
SAP Business Objects Consultant
Sallie Mae
03.2017 - 07.2017
- Participate in project planning sessions with project manager, technical architects, and business analyst to gather and analyze business requirements
- Create and manage universes and implementing row level security
- Design and build universes, classes and objects
- Export universes to repository to making resources available to the users
- Create reports for various portfolios using universe and scheduling those reports for daily use to business
- Design SAP dashboard for the executive team.
Data Analytics Analyst
S&T Bank
03.2015 - 02.2017
- Analyze high complex and massive data sets, perform ad-hoc analysis for senior management
- Manage and maintain SAP BusinessObjects Business Intelligence (BI) Platform by preparing data streams to facilitate the monthly database refresh process
- Develop Crystal reports to specification for Current Deposits
- Build Financial Analysis & Modelling
- Modify T-SQL code, Create and modify Stored Procedures based on business needs
- Perform predictive modeling for Retail Products, customer retention, utilizing SPSS Statistics
- Develop and analyze reports based on internal customer and external economic factors in order to make recommendations for marketing opportunities
- Use Data mining tool to extract data from human readable report files for analysis
- Monarch (Software)
- Create reports and lead follow-up research on customer defection trends, new business, and retention analysis
- Perform ROI Analysis on Marketing Campaigns for product managers
- Build Monthly Scorecards (Consolidate data of 63 Retail Branches)
- Track on-going Marketing Campaigns
- Ad-hoc analysis as required by senior executives.
Education
Master of Business Administration - Market Research (Quantitative), Analytics
Indiana University of Pennsylvania, Eberly College of Business & IT
Indiana, PA05.2013
Bachelor Information Technology And Commerce - Computer Science
Bangalore University
Bangalore, Karnataka06.2010
Skills
- SQL Programming
- Python Programming
- Statistical Analysis
- Google Analytics
- Advance Business Intelligence (Tableau, MicroStrategy, SAP Business Objects)
- Large dataset management
- Business Forecasting
- Analytical Thinking
- Advanced data mining
- Verbal and written communication
- Time Management
- Team Leadership
- Strategic Planning
- Project Management
Languages
English
Native or Bilingual
Hindi
Native or Bilingual
Timeline
Data Scientist
PayPal
09.2020 - Current
Business Analytics Lead
Qurate Retail Group
07.2019 - 09.2020
Data Modeler/ Data Evangelist
Lincoln Financial
07.2017 - 07.2019
SAP Business Objects Consultant
Sallie Mae
03.2017 - 07.2017
Data Analytics Analyst
S&T Bank
03.2015 - 02.2017
Master of Business Administration - Market Research (Quantitative), Analytics
Indiana University of Pennsylvania, Eberly College of Business & IT
Bachelor Information Technology And Commerce - Computer Science
Bangalore University
Similar Profiles
Scot GlasgowScot Glasgow
Business Performance Analyst at PayPalBusiness Performance Analyst at PayPal
Cecile CanningCecile Canning
Fraud/Customer Service at PayPalFraud/Customer Service at PayPal
Venkatesh MaligireddyVenkatesh Maligireddy
Member of Technical Staff 2 at PayPalMember of Technical Staff 2 at PayPal
Swapna PeduguSwapna Pedugu
Cyber risk Analyst at PayPalCyber risk Analyst at PayPal
Emma HancockEmma Hancock
Young Women’s Class President and 2nd Counselor at The Church Of Jesus Christ Of Latter-day SaintsYoung Women’s Class President and 2nd Counselor at The Church Of Jesus Christ Of Latter-day Saints