We provide IT Staff Augmentation Services!

Data Analyst Resume

Stillwater, UsA

SUMMARY OF QUALIFICATION

  • 2 Years of experience in the field of data mining, analytic and statistical programming.
  • Conversant with Customer Segmentation, Market Basket Analysis, Time Series Forecasting, RFM Analysis and Cluster Analysis.
  • Expertise in analyzing data, generating reports, tables, listings and graphs using Base SAS.
  • Experience in Data Manipulation procedures such as SAS Formats/Informats, Data Merge, Proc Append, Proc Datasets, Proc Sort and Proc Transpose.
  • Expertise in producing reports using various SAS procedures like Proc Print, Proc Report, Proc Means, Proc Freq.
  • Conversant and worked on ANOVA, goodness of fit and experimental design concepts.
  • Proficient in at Model Building techniques such as Regression models, Decision Tree, Artificial Neural Network.
  • Excellent knowledge of the statistical analysis tools like Hypothesis testing, T-tests, Chi-square tests, and correlation.
  • Comfortable working in a wide variety of environments with strong analytical ability, also can work well independently and as a team player.
  • Excellent communication and interpersonal skills.

EDUCATION

Master of Science, Industrial Engineering and Management Bachelor of Engineering, Mechanical Engineering (HONS)

CERTIFICATIONS

  • SAS Certified Predictive Modeler for SAS Enterprise Miner 6.1, May'11
  • SAS OSU Data Mining Certification, May'11
  • SAS Certified Advanced Programmer for SAS 9, Mar'11
  • SAS Certified Base Programmer for SAS 9, Oct'10
  • Lean 101 Certified, Mar'10

TECHNICAL SKILLS

Statistical Tools: SAS Enterprise Miner6.1, SAS Enterprise Guide 4.2, JMP 9.0, MS Excel, SAS/STAT, SAS/BASE, SAS/SQL, SAS/MACROS, SAS/GRAPH, SPSS Databases: MS Access, Microsoft SQL Server 2005/2008, Oracle9i Procs: Proc Sql, Proc Means, Proc Freq, Proc Tabulate, Proc Report, Proc Datasets Programming Language: Base SAS, Advanced SAS, SQL, C, HTML, VBA Packages: SAP, Microsoft Office Designing Packages: Pro/Engineer 3.0, Auto CAD Simulation Software: Simio Financial Forecasting and Optimization Tool: Oracle Crystal Ball

PROFESSIONAL EXPERIENCE

Data Analyst Jan'11- May'11

  • Followed Cross Reference Industry Standard Process for Data Mining (CRISP-DM) to identify customers of a wireless service provider who were more likely to upgrade to new handset.
  • Business Understanding: Focused on understanding the business objectives, requirements from business perspective, terms used by the cellular company and then converting that knowledge into a data mining problem definition.
  • Data Exploration: Used Graph Explore node to explore one way frequency and histograms through the data set and bring important aspects of data for further analysis.
  • Data preparation: Imputation of missing values, data transformation, rejecting the insignificant variables from a large dataset containing 90 variables and cleaning of data for modeling tools.
  • Modeling: Built decision tree, logistic regression, and neural network models and selected the best among them based on training and validation data outputs.
  • Model Comparison: Compared and selected the best model based on the decision rules.
  • Model Scoring and Analysis: Analyzed data to build statistical models to predict customers who were going to upgrade their handsets.

Confidential- Datamining Shootout 2011 May'11-July'11

  • Identified the type of storms impacting Diagnostic Related Groups (DRGs) by merging Admits, Storms and Population tables using SQL inner join in Base SAS programming.
  • Discovered the relationship between storms and DRGs using liner regression.
  • Built a predictive model to predict number of admits based on DRGs, age-group, area code and week.

Information Technology Lab Assistant Feb'10- May'11 Confidential, Stillwater, USA

  • Assisted the user with Hardware and Software problems.
  • Conducted training session to teach and assist students in setting up campus wide ID and email address.
  • Developed a database to keep track of inventory transaction for all 5 labs on campus.
  • Assisted supervisor in purchasing Lab Equipment and Computer Peripherals.

Research Assistant Jan'10 - Mar'10 Information and Nano Technology Based Manufacturing Lab Confidential, Stillwater, USA

  • Designed Micro Assembly Work Cell Components using Pro-E Wildfire 3.0.
  • Performed simulations using programming in Visual C++ with Coin 3D library for virtual reality.
  • ACADEMIC EXPERIENCE

    Database Marketing - Customer Segmentation Nov'10

    • Built a model in SAS Enterprise Guide 4.2 to evaluate the effect of credit card denial on the customer defection.
    • Performed two samplet-test to find the customers who are good to begin with.
    • Multiple Regression was used to analyze the various factors affecting profit andLogistic Regression was used to analyze various factors affecting customer defection.
    • Best model was used to predict the defection rate of customers for the period of 8 months into the future.

    Base SAS Aug'10 - Dec'10

    • Imported 85 variable dataset from excel file into the SAS environment and reduced the number of variables to 13 by variable selection.
    • Proc Freq was used to find the correlation between the target and independent variables using the chi-square values.
    • Data imputation was done on the variable with less than 20% of missing data.
    • Proc Univariate was used to eliminate the extreme observations from the data set.
    • Data classification was done using the if-then-else statements and used SCAN and UPCASE function for data cleaning.
    • Created graphs and reports using Proc Gchart, Proc Gplot and Proc Report.

    Data Process and Object Modeling Jan'10-Apr'10

    • Created an Information System for Earth Element Market and Bakery, Oklahoma using Microsoft Access and System Architect«.
    • Captured detailed requirement of EEIS (Earth Element Information System) using Use Case diagram, UML class diagram and Domain Model.
    • Generated Entity Relationship Diagram using System Architect« and worked on Microsoft Visio to make various UML Class Diagrams.
    • Developed a design blue print for the EEIS software using system sequence diagram, operation contract and interaction diagram.
    • Used queries, functions developed in SQL with relational database knowledge to perform data validation and supportive functions.

    MISCELLEANEUOS

    • Interned at Porwal Auto Components Ltd as a Production Engineer Intern, worked on Improving Overall Equipment Effectiveness of Injection Molding lines.
    • Interned at Supreme Engineering Works Ltd as a Quality Control Intern, worked on Statistical process Control and Six Sigma using Quality Control Charts.
    • Interned at Tata International Ltd as an Engineering Trainee, simulated the steam and water pipelines throughout the plant using Pro/E.
    • Developed IDEF-0 AS-IS and TO-BE Model for SWENT (Manufacturing Carbon Nano Tubes), Norman using AI0 WIN Software and proposed Deign of Experiments (DOE) approach for product quality improvement and to identify faults.
    • Attended SAS Analytics Conference held at Tulsa, April2011.

Hire Now