Data Manager
Resume:
Girish P
**********@****.***
SUMMARY
Interested in designing and implementing successful solutions while working with a team of earnest people. I am looking forward for a challenging position where I can get a chance to implement something new and innovative. My Passion for Operation Research along with my unquenchable curiosity towards this field made me choose this field as my career.
Holding Masters in Industrial & Systems Engineering with specialization in Operation research, data analysis, with a strong focus, passion on Statistics (Descriptive, Inferential, and Prediction) and Reporting. Able to use advanced data analysis Tools like SAS, SPSS, CPLEX and Tableau, qlikview for advanced predictive modelling (Machine learning techniques) skills.
Excellent skills in Data mining and Data Modeling techniques which includes Linear Regression, Neural Network, Logistic Regression, Clustering, Segmentations, Decision Trees, RFM models, K-mean Clustering out-performing skills in using tools to Clean, Modify, Transform and Visualize Data using tools like Tableau, Qlikview, SAS Enterprise Guide, Enterprise Miner, IBM SPSS Modeler.
SKILLS
Analytical/Data mining tools/Statistical tools
SAS Forecast studio 14.1, SAS Enterprise Miner 14.1, SAS Enterprise Guide 7.1, SAS Rapid Predictive Modeling for Business Analysts, SPSS modeler 18.0, SAS/ETS software, Minitab.
Statistical techniques
One sample T-test, two sample T-test, Paired T-test, one proportion Z- test, two proportion Z-test, chi Square Test, N-way Anova Test, Correlation analysis, Regression test.
Visualization tools
Tableau, Qlikview.
Optimization tools
IBM Cplex optimization studio.
RDBMS
Teradata, Oracle SQL, MS Access.
Languages
C, C++, Java, SQL.
Applications
MS Office 97/2000/2007/2010 (Excel, PowerPoint, Word).
Design Skills
Auto-CAD, Solid Works, Ansys, Catia and ARENA.
Industrial Methodologies/Processes
DMAIC, Kaizen, FMEA, PDCA, SPC, 5S Methodology, Gage R&R.
Work Experience
Analyst Dec’2015 – Present Chicago, IL.
PEGASUS KNOWLEDGE SOLUTIONS. (SAS Version 9, SAS enterprise miner version 9, SAS Studio, SAS enterprise guide).
Pegasus Knowledge Solutions provides customized Business Intelligence solutions for customers in Insurance and Banking domain. During my tenure with Pegasus, worked for multiple clients. As part of building/delivering customized solutions work involved building models, dashboards and competitive intelligence. Serves as the primary support and go-to person for most of the periodic, ad hoc reporting and analysis and removing their dependence on the IT.
Project: EARLHAM BANK (IOWA). Sep’16 – present.
Operations Research engineer (IBM CPLEX).
Main keyplayer for their final decision maker, engaging broadly with organization to identify, prioritize and structure complex, hard core structures problems where advanced quantitative models and analytic solutions.
Design, Code, Test and debug Complex optimization software and models using Operation Research Technologies.
Perform projects assigned by manager in management and operations problems of compnay.
Concentrate on collecting and analyzing data and developing decision support model.
Work closely with team members such as Information system anlyst, Market research analyst, accountant to ensure information flow process are aligned with business, finance, payroll and personnel needs; researches and improves database management ; develops and reviews standards and procedures regarding business, finance, payroll and personnel Information systems; trouble shoots and resolve issues and customer.
Managed multiple modeling development and analytic projects simultaneously and producing good qulaity solutions with meeting project deadlines.
Building, documentation, Implementing and maintaining complex quantative models and analytic solutions.
Identifying and communicating the challenges and all opportunities associated with each business problem to an ecutive managers, top management to inform the final decison-making process.
Make recommendations to improve the design and qulaity of existing optimization Engines, Components.
Performed Applied Research, Design and develop New algorithms and methodologies.
Worked closely with product management, developers, delivery, testing in Cross- Functional teams .
Prepare Data Requirements, BRDs, Analytical Reports, and presentation.
Selected Projects:
Enhanced Intelligent video Analytics (IVA) solution: Mathematical model that Optimally builts new video analyitcs routing all periodical,Maintenance costs.
Prtotype, code, Test and Debug the product in C++ Language.
Worked with Developers, Product Management teams.
Customer Assignment model: Using current and savings account data for current transactions model to maximize profit.
Improved the profit of existing model by 1% for the usage of transactions model.
Used java to Debug the customers and conduct Regular follow ups with customer accounts to maintain their relationship.
Environment: IBM ILOG Cplex optimization studio, Java/C++ scripting, Oracle SQL.
Project: EARLHAM BANK Apr’16 – Sep’16
Data Analyst (SAS, SQL).
Analyzed fraudulent account behavior/transactions to determine root cause of losses and perform analysis on customer’s accounts to identify potential fraudulent rings and reports this to the strategies/analytics teams for review.
Solved Manual data formulas using complex SQL Statements.
Worked on KYC(Know your client), AML (anti-money laundering) and regulatory compliance standards with private Banking data sets.
Utilized SAS to gather, analyze, and interpret data from several sources including transactions, authorizations, Financial data, Transaction codes, Master loans, sold loans, G/L transactions, DDA, credits, Savings and ready reserves.
Evaluated transactions to look for layering activities as they related to AML requirements on all client accounts as they are related to AML Requirements.
Worked on SQL and SAS current state database scripts, then constructed future state requirements.
Extensive knowledge with AML/ Compliance systems including SAS based programs.
Built the forecasted models for all financial transactional data (including AML/KYC datasets) and predicted fraudulent transactions with SAS enterprise guide.
Used SAS Visual analytics for client end/Stake holders for building dashboards to build Products in terms of business growth (CD Analysis, SVG Analysis, LNS Analysis, DDA Analysis).
Segmented the transcational data by mapping the fields with ACH payments, mobile, Internet and Branch by customer ID, Account number.
Constructed table of customers with top customers, Cash inflows (open CD’s), cashed outs and most favourable products.
Environment: SAS Version 9.13/9.2, SAS Enterprise Miner/Guide 14.1, SAS Visual analytics, SAS/ETS, Oracle SQL.
Project: TOKIO MARINE (Tokio Marine America Insurance Company, NY.) DEC’15- April’16
SAS Analyst.
Claim is an important segment in Insurance business. This reporting set is to analyze global claims to support management in setting the organization’s global business goals and strategies. Part of this reporting project was to cover different correlated business segments and strategic reporting for client, in areas like Client review, Global Time Tracking, Policy Tracking, and Global Client Account Profitability.
Have meet the clients and discussed the business requirements to solve by building the predictive models and prepared the daily, weekly, yearly dashboards, reports for the clients.
Build use cases for property causal insurance claims (includes car dealerships).
Collected past data claim history and weather conditions data (includes wind speed and flooding with rainfall)
Build use case for Individual claims: Models takes claims weather predicts/computes fraud risk score scale (1-10).
Type of construction for building constructions with concrete building, claim amount, distance travelled by 3rd party.
Prepared Self-Review Checklist and Standards for report development.
Created SAS datasets from Teradata tables using SAS/CONNECT and SAS/ACCESS
Ran SAS report programs and downloaded results in excel for data analysis.
Modularizing the complex legacy environment and migrating it to the SAS EG and finally loading the data into final data sources of generating reports in various formats such as Excel, pdf, graphs etc.
Built regression models and neural networking model to analyze relationships between operational variables and performance of factors.
Wrote SAS macros to extract required datasets from database (SSIS).
Mapped fields, performed data validation, and fulfilled other adhoc data manipulation requests.
Producing CSV, xls, HTML and PDF formatted files using SAS.
Reporting the dashboards, stories Using Tableau to the clients (stakeholders).
Environment: SAS Version 9.13(PC), SAS Enterprise Miner 14.1, SAS Forecast Studio 14.1, SAS Enterprise Guide 7.1, Tableau 10.0.
Data Analyst(SPSS) August 2013-December 2014 Hyderabad, India.
Bajaj Alliance. (Auto-Insurance client)
As a data analyst I was responsible for maintaining and administering the data base, write simple to complex SQL queries to answer daily user and business requirements. Developed macros to reduce duplicate data entries and created Dashboards using Pivot tables and VLOOKUP formula in Excel. Understood the new business requirements and plan the facilitation of data marts. Used SPSS to build models to identify definite patterns and suggest business with possible problems and feasible solutions. Identify requirements for new possible business flows. Data consolidation for operational weekly and monthly business reports, effective and efficient solutions to deal with large data sets. Part of team responsible for the overhaul of existing manual windows based forbearance reporting system to an automatically executed, secure UNIX based system for more than 400 reports to the client’s management.
For Auto insurance industry worked for local clients with their claims data to predict claim amounts and fraudulent Claims.
Interacted the local clients for their business development with increasing their sales.
Performed data analysis using IBM SPSS Statistics Software (i.e. normality tests, probability tests, clearing outliers).
Used the basic statistical techniques (T-tests, f-test, ANOVA Test) to clean outliers and validate the data for modelling.
Extracted data from SQL Files from SPSS modeler and filtered, sorted the variables using filter node.
Build Predictive models on identifying fraud in auto industry that includes linear regression models, neural networks models using Auto numeric node.
Created tables of results output by connecting to table node and analysis table by analysis node.
Scored the models to get the fraud claims in the new data sets using score node.
Predicted the fraud claims and prepared a detailed report.
Familiar with SPSS statistical algorithms. Build the Partial Least Squares module for SPSS. Researched Kernel learning and implemented a prototype of the Least Squares Support Vector Machine. Participated in design reviews of SPSS modules including: Programmability Extension, Partial Least Squares, Missing Value Analysis, Complex Samples, Generalized Linear Models, and Two-Step Cluster (BIRCH).
Wrote a Visual Basic program (SAS MACROS) to collect and store call tracking information in an Access database in BASE SAS 9.2.
For client and stakeholders reporting, built dashboards with Power BI Pro version (SSIS, SSAS, and SSRS).
Environment: IBM SPSS Statistics Software, BASE SAS 9.2, SPSS Modeler 18.0, UNIX, Power BI Pro version.
Worked as Treasurer for IIE chapters.
Worked as accountant for holding all financial records of all activities conducted on and off campus.
Advertised IIE chapters within campus by giving many presentations and designed some flags for IIE chapters.
Collected some funds for IIE chapters from outside campus by promoting the IIE chapters.
PRIOR EXPERIENCE-ACADEMIC PROJECTS
Graduate projects:
OPERATION RESEARCH – Vision Corporation:
Build linear programming (simplex method) for Vision Corporation: Production Planning and shipping to maximize profit for all constraints. Has done sensitivity analysis to increase their inspection capacity, extra machine hours and demand using excel solver parameters, sensitivity analysis reports, post-optimality analysis.
Incorporated linear programming using simplex method to maximize profit for all constraints in excel.
Applied Assignment model for reducing shipping cost.
Using excel solver parameters, have done sensitive analysis and obtained optimal solution (To increase inspection capacity, extra machine hours & increase demand).
DATA ANALYTICS & PREDICTION MODEL – US Home Health Agency:
Have done Performance Analysis of U.S. Home Health Agencies by Business Analytics methods, identified statistical characteristics of successful home healthcare agencies.
Collection of recent data (about factors affecting health agencies) from online websites for home health agencies state wise.
Cleaned the data using excel (including log transformation into percentage & outliers).
Plotted the probability test, normality test and kruskal-wallis test (non-parametric test) using SPSS statistics 23 software.
Built MLR (multi linear regression models) with six prediction models which predicts in identifying factors with home health agencies using IBM SPSS statistics 23 software.
SYSTEM SIMULATION – Dunkin Donuts:
Built and simulated Arena Model for reducing the long wait times per customer, improve the service time for Small Business by using Arena Simulation Software.
Data collection (Inter-arrival and arrival times, service time) from the Dunkin-Donuts location is drawn into excel sheets for multiple days.
Performed data analysis (Normality test, probability test, and One-way Anova test i.e. parametric test.)
Cleared outliers and carried out system analysis with arena simulation arena.
Built a Model with inflow of customers into dunkin-donuts to improve service time and reduce the long wait times of customers.
Used PAN for process analyzer to find best Scenarios for number of Cashiers and workers in the store.
Performed OPT quest to reduce cost for optimal number of cashiers and workers.
QUALITY ANALYSIS:
Analyze the stock markets using quality tools. Collected Walmart and Yahoo market stock market price from the online stock broker site used moving average charts and process capability tools for market analysis using Minitab 17 statistical software.
Collection of data from online stock market brokerage sites.
Conducted normality & probability test.
Data cleaning (cleared outliers), and examined One-Way ANOVA test (parametric tests).
Built moving average charts using Minitab 17 statistical software.
Used control charts, to assess whether it is in control or not.
Done capability analysis in Minitab 17 statistical software and check whether the capability charts with upper and lower limits.
EDUCATION
M.S. INDUSTRIAL & SYSTEMS ENGINEERING UNIVERSITY OF NEW HAVEN, CT.
GPA 3.5/4.00
Related Coursework: Data Analytics & Prediction Model, Operation Research, Supply Chain Management, Human Engineering I, Engineering Economics and Cost Estimation, Design of Experiments, Value Engineering and Design, Quality Analysis, System Simulation, Enterprise Resource Planning & Procurement, Achieving Optimal Operations, Applied Stats - Quality & engineering Management, Probability theory, Descriptive & Inferential Statistics.
Certifications/Licenses:
IBM CPLEX Optimization Studio certified.
SAS® Certified Base Programmer for SAS 9
SAS® Certified Statistical Business Analyst Using SAS 9: Regression and Modeling
SAS® Rapid Predictive Modeling for Business Analysts (EM 7.1)
SAS® Enterprise Guide®: ANOVA, Regression, and Logistic Regression (EG 5.1)
SAS® Programming 2: Data Manipulation Techniques.
Applied Analytics Using SAS® Enterprise Miner(TM) (EM 12.1)
IBM Intelligent Video Analytics Technical professional v1.
References: Only Email them, call them when required (please do know their free time to talk i.e. before reaching/contacting them).
Mr. WASIM
Manager.
Pegasus knowledge solutions, Inc.
*****@****.***
Mr. Pani Koduru
CAO (Chief Analytics Officer).
Pegasus knowledge solutions, Inc.
*******@****.***
Mr. Vishwa Prakash
Manager, Deloitte, PA.
610-***-****, ********@*****.***
Mr. Srujan obulreddy
Sr. Financial Analyst, Lending club, San Francisco, Bay Area.
203-***-****, *-*******@***********.***
Contact this candidate