SUMMARY

• 7+ years of experience in database management, data analysis, data mining, and predictive analytics
• 3+ years of Experience in Tableau and wif latest version 2020.4(Desktop, Server) as a developer. End to end involvement in designing and deploying data visualizations and creating Calculations, Formatting using Tableau Desktop
• An innovative analytics developer wif experience in analyzing various types of data. Worked wif datasets from Automotive, Finance, Marketing, Health Care and Service Industries
• Skilled in interpreting business requirements and creating various analytical reports and dashboards to help businesses identify prominent KPIs and facilitate strategic planning in the organization.
• Adept at data administration, analyzing data and working closely wif departmental managers to create useful and elegant reports using the data visualization software tableau.
• Proficient indata visualization, Reporting, Analysis, Pie Charts, Bar Charts, Cross Map, Scatter Plots, Geographic Map, Density Chart, Sankey Chartand other making use of actions, other local and global filters according to the end user requirement
• Expertise in designing and creating variousanalytical reports and Dashboardsto help users to identify critical KPIs and facilitate strategic planning in the organization
• Sound statistical noledge to interpret and diagnose models and make valid conclusions from volumes of data and present it to non - technical teams
• Knowledge of advanced concepts of MS Excel such as pivot tables, graphs and advanced functions VLOOKUP, IFELSE, etc. and Macros
• Experience in data preparation for various statistical modeling, which includes data cleansing, descriptive statistics, missing data analysis, data validation and preliminary data reporting
• Performed predictive Modeling, Pattern Discovery Market Basket Analysis, Segmentation Analysis, Regression Models, and Clustering
• Strong skills in Data Analysis, Data Requirement Analysis, and Data Mapping for ETL process
• Extensive experience to handle Large Teradata for Data Cleansing, Data Profiling and Data Scrubbing
• Analysis, Decision Tree, Trend and Pattern Analysis, Classification models, Neural Networks
• Experienced in statistical analytical methods like Correlations analysis, ANOVA, t-tests, market basket analysis, etc.
• Hands on experience in SAS programming for extracting data from Flat files, Excel spreadsheets and external RDBMS ORACLE, Teradata tables using LIBNAME and SQL PASSTHRU facility
• Well versed wif BI tools like Tableau, SPSS, SAP, SAS, Micro strategy.
• Highly motivated, detail oriented, proven ability to work independently
• Excellent Technical, Analytical and Leadership skills in motivating others
• Excellent Interpersonal, Presentation and Communication skills wif problem abstraction and ability to work TEMPeffective.

TECHNICAL SKILLS

Programming Languages: Python, Base SAS, C, Visual Basic, SAS 9.1 Programming, SAS/Stat, SAS Macros

Web technology languages: HTML, XML ASP.NET, CSS, JavaScript, XHTML

Project Management: MS project 2010, Base Camp

Reporting tools: Microstrategy, Cognos, and ESRI, Tableau, Altryx

Statistical Tools: SPSS IBM Modeler, Rapid-miner, SAS enterprise miner 14.3, JMP 10, SAS Forecast Server, MS Excel, Tableau.

Operating System: Microsoft Windows 98/2000/XP/2010/7, UNIX, LINUX, MAC OS X

Database Systems Tools: SQL server, MS Access, DB2

PROFESSIONAL EXPERIENCE

Confidential, Fountain Valley, CA

Analytics Consultant (Tableau)/ Data Scientist

Responsibilities:

• Gathered business requirements from teams to build predictive models for HMA and Genesis Motor America (GMA)
• Extracted data from different data sources and prepared the datasets for predictive modeling.
• Developed Genesis as second car predictive model, Genesis upgrade predictive model, Initial Quality Survey predictive model in python.
• Data blending implemented on SQL Server database and generated interactive dashboards.
• Created ad-hoc reports to users in Tableau by connecting to various data sources.
• Prepared dashboards using calculated fields, parameters, calculations, groups, sets and hierarchies in Tableau.
• Created sheet selector to accommodate multiple chart types in a single dashboard by using parameters.
• Created and maintained issue log where business users enter their feedback by working on dashboard in test environment. Implemented the feedback and incorporated the necessary changes.
• Performed Parallel Testing or Production Testing, which ensures that the new system will perform correctly in a production environment and interface correctly wif other production systems.
• Made complex chart like Spider chart and Sankey chart to better visualize the data.
• Generated Dashboards wif Quick filters, Parameters and sets to handle views more efficiently.
• Published Workbooks by creating user filters so that only appropriate teams can view it.
• Analyzed the source data and handled efficiently by modifying the data types. Used excel sheet, flat files, CSV files to generated Tableau ad-hoc reports.
• Generated tableau dashboards wif combination charts for clear understanding.
• Created the reports using charts like Pie, Bar, Line etc. Charts are used in making reports user-friendly in analysis purposes.

Confidential, Palo Alto, CA

Data Engineer/Tableau Developer

Responsibilities:

• Involved in publishing various kinds of live, interactive data visualizations, dashboards, reports and workbooks from Tableau Desktop to Tableau servers.
• Involved in conducting trainings to user on interact, filter, sort and customize views on an existing visualization developed in Tableau desktop.
• Created Advance connections, join new tables, create & manage Extract and Monitor Queries using SQL Developer.
• Developed parameter and dimension based reports, drill-down reports, matrix reports, charts, and Tabular reports in Tableau Desktop.
• Created Tableau scorecards, dashboards, Heat maps using show me functionality.
• Created complex data Views Manually using multiple measures also used sort, Filter, group, Create Set functionality.
• Published Reports, workbooks & data source to server and exporting the reports in different Formats
• Good experience in using URL's, Hyperlinks, Filters for developing Complex dashboards
• Worked creating Aggregations, calculated Fields, Table calculations, Totals, percentages using Key Performance Measures (KPI) and Measure.
• Created Views, Stored Procedures and validated data for the Performance.
• Developed various types of complex reports like Standard reports, Group reports, Detail and Summary reports, Crosstab reports, Graphical reports, drilldown reports, on Demand and Linked sub reports using crystal reports, tables, views, business views.
• Provided daily production support and administration of portal operations, such as problem resolution.
• Worked closely wif Data Modelers in designing various data warehouse schema techniques.
• Worked on the data provider that forms the basis of the ad-hoc analysis.
• Extensively involved in identifying and solving the problems by coordinating wif senior managers in emergency and normal issues to meet the goals.
• Participated in Preparing Detailed technical documents from the functional specifications.
• Executed and tested required queries and reports before publishing dashboards.
• Extensively participated in translating business needs into Business Intelligence reporting solutions by ensuring the correct selection of toolset available across the Tableau BI suite.
• Functional Lead role in defining the dashboard requirements and providing the best practices/approach to perform ETL and publish data to the reports/dashboards.
• Extensively involved in identifying and solving the problems by coordinating wif senior managers in emergency and normal issues to meet the goals

Confidential, SF, CA

SAS analyst/BI Analyst

Responsibilities:

• Conducted statistical analysis such for clustering the customer database.
• Identified segments and TEMPeffectively used it for direct marketing campaigns.
• Forecasted impact of direct market campaigns for acquiring, developing and retaining customers.
• Undertook data or record collection, data cleansing and coding, data aggregation and validation, model development and scoring, predictive analysis and postmortem analysis of the model using R, SAS and Excel.
• Used SAS Stored Processes to deliver content to the portal and used SAS Web Report Studio to deliver the same through the SAS Management Console.
• Integration of Data from MHS Source Systems Claims/Service Lines/ Members
• Used SAS Stored Processes to deliver content to the portal and used SAS Web Report Studio to deliver the same through the SAS Management Console.
• Generated customized reports using SAS/MACRO facility, PROC REPORT, PROC TABULATE and PROC SQL.
• Data processing and validations were done extensively on the SAS datasets using edit check programs.
• Performed model validation through k-folds Cross-Validation, Leave-One-Out-Cross Validation LOOCV in SAS environment and partition of data into training and testing data or sets prior to the commencement of model development.
• Developed advanced multivariate statistical methodologies like regularized multinomial logistic regression, discriminant analysis, TEMPprincipal component, cluster analysis etc.
• Retrieved the data from flat files received from the vendors and converted to SAS data sets using DDE functions for analysis using SAS/STAT procedures such as PROC MEANS, PROC SUMMARY, PROC REG, PROC UNIVARIATE and PROC ANOVA.
• Generated plots and used the visualization tools like Tableau.

Confidential

SAS Analyst/Data Analyst

Responsibilities:

• Generated highly customized reports in the form of listing, HTML, RTF and PDF using SAS ODS, PROC REPORT, PROC TABULATE, and PROC SQL.
• Involved in discussions wif business users and data architects to define metadata for tables to perform ETL process.
• Extracting data from the database using SAS/Access, SAS SQL procedures and create SAS data sets.
• Worked to increase the client base of the company through market analysis, PCA and logistic regression of existing customer data using SAS Enterprise Miner, which was immensely helpful for the company's sales and marketing campaigns.
• Modifying data using SAS/BASE, SAS/ MACROS.
• Presenting data using graphs, tables, charts wif data visualization tools like Tableau.
• Fitting various statistical models such as Generalized Estimating Equations GEE, Generalized Linear Model GLM, Mixed models, Non-linear mixed models, Analysis of Variance ANOVA, Regression models, etc.
• Worked using various SAS report generating procedures such as PROC FREQ, PROC MEANS, PROC TABULATE, PROC ANOVA, PROC SUMMARY, PROC REPORT, PROC SQL, PROC MIXED, PROC GENMOD, PROC NLMIXED, PROC GLIMMIX, PROC UNIVARIATE, PROC TRANSPOSE, and PROC GLM.
• SAS Programmer /Analyst at Symbiosys Technologies,

Confidential

SAS Analytics Consultant

Responsibilities:

• Used the SAS system to design and implement a general analysis system for data entry, statistical analysis, graphical presentation, and report generations.
• Extracted and integrated data from different sources Primary and Secondary, used tools like Oracle and Teradata and text files using SAS/Access, SAS SQL procedures and created SAS datasets.
• Extracted data from the database by SQL PASS THROUGH FACILITY and LIBNAME facility.
• Created reports in RTF, PDF, Excel and HTML formats using ODS statements.
• Conducted research and developed financial analytics performed ad hoc model development specific for high level quantitative analysis using SAS. Created Workflow Diagrams, UML diagrams, Activity Diagrams, Use Cases, Swim Lanes, for incorporating design changes.
• Documented the developed macros explaining the functionality of the macro and the macro parameters defined for future reference.
• Created Summary tables using procedures like PROC TRANSPOSE, SORT, FREQ, MEANS, SUMMARY, UNIVARIATE, AND TABULATE.
• Gave presentations on different courses of statistics such as Introductory Statistics, Probability, and Multivariate Data Analysis to other team members.