Data Analyst Business

Profile: LinkedIn: http://www.linkedin.com/in/jit-bhattacharya

Data Analyst with 15+ years experience in building and managing data analytical processes to solve business problems in multiple domains, including banking, retail, insurance, and, telecommunications.

Increased profitability by 30% for a US bank by completely revamping their credit line strategy with dynamic risk models.

Achieved 40+% ROI on marketing campaigns for retail clients, with predictive models that identified the best prospective customers.

Developed a unique forecasting model to predict short-term bitcoin price with 70-75% accuracy.

Reduced turnaround time by 50+% by automating analytical processes and reports across platforms using SAS, Excel, ODBC and APIs.

Expert in SAS, SAS/Graph, SAS Viya, ODBC, ODS, SQL, Python, JSON API, Excel. Experienced in MVS, DB2, Teradata, Oracle, Unix, Windows platforms.

Functional Expertise:

Credit risk, market mix, segmentation, customer acquisition and retention, customer experience management (CEM), Telecom CDR data, P&C insurance premium rate-making. Managing teams of analysts and cross-functional teams. Very strong written and oral communication.

Statistical Expertise:

Predictive Modeling: Multivariate, Logistic Regression, GLM, Lasso, Ridge, Mixed models.

Machine Learning: Decision Trees, Random Forests, Gradient Boosting, SVM, KNN Clustering, Neural Networks, GNN.

Time Series Forecasting, Monte Carlo Simulation, Markov Chains. Optimization (LP, IP, NLP).

Professional Experience:

Upwork Global Inc. / Remote

Senior Data Analyst (03/2020 - Present)

Responsible for statistical model development, process automation, and project management. Written and oral presentation of findings to clients.

Assets Insight Management: Developed ensemble machine learning models with SAS Viya to predict replacement of infrastructure assets of Vancouver municipality. The models were developed with Network analysis GNN, Random Forests, and, tested using ASE, misclassification and ROC curve measures.

Wells Fargo Bank: Increased profitability by 30%, year-on-year, by redesigning Credit Line Increase/Decrease strategy for small business cards. Completely overhauled, simplified, and automated the strategies with balanced scorecard models. Extracted and transformed data from Teradata Snowflake schema using SQL. Used SAS to automate with macros, call routines, ODBC, and to build scorecard models that created dynamic strategies.

Baird Capital Group: Designed Bitcoin price forecasting models with machine learning and unique algorithm, that give 70-75% accuracy. Designed an ETL system and used SQL, JSON API to extract real-time data for the model. Created a Google Site to show visualizations of results.

Municipality of Hartford: Segmented student risk groups based on survey of students and parents responses for a school district in Connecticut, using SAS KNN clustering procedures.

Tyler Associates: Developed online course content, case studies, and, test material for undergraduate courses of a US university. The courses were Applied Predictive Analysis, and, Advanced Statistics / Statistical Modeling.

Bridgetree Inc, Charlotte, NC (01/2019 – 02/2020)

Senior Statistician

Responsible for analytic project design, predictive model development, reports and Key Performance Indicators (KPI metrics), presentation of findings to clients. Managed a team of 20 analysts.

Developed prospect acquisition models using Logistic Regression and machine learning (RF, Gradient Boost in SAS ) for marketing campaigns of Dish Network Company, and, Cedar Fair amusement park chain. The Models provided ROI of 40%+. Performed ETL using SQL from Oracle database (Snowflake schema).

Identified primary customer segments of a Pet Retail chain using SVM, SAS KNN Clustering. The segments drove the company's marketing strategy to customers.

Built a predictive model using Logistic Regression for a pest control company. The model defined prospective customers to target within a 50-mile radius from company locations. The logistic model provided a lift of 70%. The modeling was done in SAS Studio.

PricewaterhouseCoopers, India (08/2010 – 12/2018)

Data Consultant

Responsible for development of business intelligence (BI) report suites and visualizations, statistical model design / implementation, and, presentation of findings to clients. Mentored team members.

Columbia Asia Global: Developed an operational planning system, (Reports & Graphs), for a healthcare company. Automated the ETL system with SAS stored procedures and Windows job scheduler. Used SAS/SQL to extract data from SQL server with SAS Access libraries.

Telekom Malaysia: Created customer segmentation models using clustering techniques Developed an ETL process with SQL to create an analysis data mart for model development. Used SAS k-means (KNN) clustering to build the model. Identified customer segments for marketing campaigns.

Reliance Communications: Created an intelligent recommendation system for a customer portal. The engine recommended relevant products to individual customers based on user characteristics and actions. The engine was developed with Market Basket Analysis (MBA) techniques in SAS Enterprise Miner.

Kolkata Municipality Corp: Developed a waste collection scheduling system for Kolkata city that eliminates the need for intermediate vat waste sites. Used optimization techniques (IP) with Excel Solver.

CitiGroup: Developed Pre-Post, Share of Wallet, and, Customer Penetration analytical processes with Chi-Square tests in SAS for CPG, using US Affinity card data.

Developed Trade Area algorithms for a Big Box chain, using heuristic optimization techniques and Log-Linear models. Built an automated process to implement the algorithm in production.

HSBC San Francisco, CA / India (01/2008 – 07/2010)

VP, US Cards

Managed a team of 40 analysts and managers of the US Credit Card department. Responsible for the Customer Care, Collections, and Fraud operational domains. Grew the team from 25 to 40 Analysts.

Managed a team of 45 analysts and managers of the US Operations department. Responsible for the Contact Service Delivery domain. Grew the team from 18 to 45.

Palisades Research Inc., Watchung, NJ (04/2005 – 12/2007)

Senior Consultant

Virgin Mobile: Data analysis and reporting on CDR data. Data cleansing and transformations. Telcom customer segmentation to recommend packages aligned to customer activity.

Liberty Mutual Insurance: Performed data analysis to enhance P&C products. Analysis included Pricing Modeling, Loss Triangles, Trend Analysis, CA Sequential Analysis, and, Underwriting selection algorithms.

Developed a churn predictive model for P&C using Decision Trees and Regression. Created Actuarial OLAP data cubes for analysis. Designed a Claims Analytics Mart.

Plymouth Rock Assurance: Completely automated the premium rate-making process and reduced turnover time from 30 days to less than 5 days. Developed the process to automate data extraction, rate determination algorithm, export of results into formatted excel tables for regulatory submission. Created a GUI interface with SAS/AF to run the process based on input parameters.

Developed Territorial Pricing Relativity Models, Customer Tiering Models, and Dislocation Analysis utilities. Used SAS/Macro, SAS/STAT, and, SAS/GIS for analytical reports and graphs.

Education:

MS Decision Science, Drexel University, Philadelphia

MBA Operations Management, Philadelphia University, Philadelphia

Contact this candidate