SUMMARY

• 4+ years of experience in Statistics, Data Analysis, and Machine Learning using R and Python.
• Strong with SSIS (ETL), SSAS, SSRS, Data warehousing, Data Store and Data mining concepts.
• Strong grasp of SQL and creation of relational database models.
• Experienced in creating cutting edge data processing algorithms to meet project demands.
• Experienced in SAS with detailed knowledge of statistical analysis of financial data.
• Expertise in relational databases - Oracle, SQL Server, PostgreSQL, MySQL, Teradata; NoSQL database - MongoDB.
• Experience in creating different visualizations using bars, lines and pies, maps, scatter plots, Gantts, bubbles, histograms, bullets, heat maps and highlight tables.
• Involved in troubleshooting, performance tuning of reports and resolving issues within Tableau server and Tableau desktop report.
• Applied different filters like normal filters, quick filters, context filters, sharing filters, and use as filters, user filters.
• Good understanding of relational data modeling, data profiling methods to analyze data sources.
• Involved in creating database objects like tables, views, procedures, triggers, and functions to provide definition, structure and to maintain data efficiently.
• Excellent experience in creating indexes, indexed views in observing business rules and creating effective functions and appropriate triggers to assist efficient data manipulation and data consistency.
• Proficient in extracting, transforming and loading (ETL) data using various tools such as SQL Server Integration Services (SSIS).
• Resolved logical disparity among heterogeneous data sources and destinations like Access, Excel, flat files using connectors, tasks and transformations provided by SSIS.
• Able to effectively partition time and prioritize tasks to consistently complete projects in accordance with specifications and on time.
• Leveraged data science libraries in Python and R to develop regression, classification, clustering, and neural network models.
• Worked with packages like ggplot2 in R to explore data and develop visualizations.
• Worked on Tableau to create dashboards and visualizations.
• Worked with python libraries like Matplotlib, NumPy, Pandas, Plotly, SciPy, Scikit-learn, TensorFlow, Keras, Bokeh, Pydot, Beautiful Soup.
• Designed and implemented supervised and unsupervised machine learning algorithms.
• Expertise in analyzing data using big data technologies (Hadoop, Hive, Pig, Mahout, Spark).
• Identified problems and provided solutions to business problems using data processing, data visualization and graphical data analysis.
• Developed predictive models using Decision Tree, Random Forest and Naïve Bayes concepts.
• Worked with clients to identify analytical needs and documented them for further use.
• Developed predictive models using Python & R to predict customers churn and classification of customers.
• Solid knowledge of mathematics and experience in applying it to technical and research fields.

TECHNICAL SKILLS

Programming Languages: SQL, JAVA, .NET, R-Studio, Python, C++, Scala

Tools: Tableau, Microsoft Project, IBM SPSS, WEBI, DESKI Designer, IDT, CMC, BI Launchpad, Infoview, ggplot2, Power BI

Database: Oracle 10g/9i, MS SQL Server 2000/2005/2008 , MS Access, MongoDB, PostgreSQL

Business Analysis: JIRA, Business Requirements Gathering, User Interviews, Process Flow Diagrams, Data Flow Diagrams, Data Analysis, Requirements Analysis, Design Functional and Technical specifications

Big Data: Hadoop, Map Reduce, Spark and Hive.

Machine Learning: Logistic Regression, Linear Regression, Decision Tree, Random Forest, Nearest Neighbor classifier, K-Means Clustering, Principle Component Analysis, Support Vector Machine, Naïve Bayes, Gradient Boosting, Auto Regression and Moving Averages, RFM Analysis, SMOTE, Lasso and Ridge Regression, Weight of Evidence and Information Value (WOE & IV)

PROFESSIONAL EXPERIENCE

Confidential, Houston, TX

Data Analyst

Responsibilities:

• As a member of the Analytics Team, support advanced analytics projects to meet the needs of business partners.
• Wrote a python-based SQL generator that helped speed up a weekly reporting from several days effort to just running the automation and getting the report done in a few hours.
• Investigate existing and emerging technologies to explore analytics solutions for business partners and make recommendations for enterprise-wide implementation.
• Maintained SQL scripts to create and populate tables in data warehouse for daily reporting across departments.
• Worked on a data set that predicts the length of stay in dentist office based on claim records
• Created, coded, tested, modified and installed programs for a host of application
• Use SQL, cluster analysis, and text analytics methodologies to investigate account data,
• Including client interaction, to anticipate client dissatisfaction and determine statistical patterns that could be precursors closing or diminishing accounts, and to discover a relationship between client interaction and fraud.
• Perform data extraction, sampling, advance data mining and statistical analysis using linear and logistic regression, time series analysis and multivariate analysis within R and Python.
• Discover and visualize patterns in Tableau.
• Examine customer feedback and activity for use in detecting or confirming fraud, using a combination of text analytics, statistical modeling, and classification.
• Used SQL language to write queries inside the SQL server database.
• Experience with Microsoft servers 2005, 2008, 2012
• Developed predictive models using Decision Tree, Random Forest and Naïve Bayes.

Environment: s: Google Analytics, Tableau, SPSS, SQL-Server, Spyder, Microsoft servers, Scala

Confidential, Columbus, OH

Data Analyst

Responsibilities:

• Collects, cleans, transforms and validates data as a process for arriving at conclusions
• Performs audit on all data for the purpose of business development resolution
• Converted data into actionable insights by predicting and modeling future outcomes.
• Utilized MS SQL, data warehousing programs, Tableau and other visualization tools for data intelligence and analysis.
• Successfully interpreted data in order to draw conclusions and strategy.
• Maintains and updates all data archives
• Conducts periodic internal audits

Confidential

Data Analyst

Responsibilities:

• Develop and maintain KPI and benchmark that support the business goals through the digital channels.
• Track key metrics of website performance: unique visitors, page views, time spent, and conversion metrics
• Develop reporting dashboards and monitor key metrics daily, weekly and monthly to communicate trends with the appropriate teams
• Support the collection and integration of data across various sources and systems.
• Analysis of visitor behavior generating heatmaps, funnels, recordings to track and analyze conversion.
• Product/content analysis, user behavior analysis (path/site navigation), A/B testing, multivariate testing analysis.
• Implementing tag and lead data collection process.
• Provides data reporting via reports, dashboards/visualizations
• Help establishing clear processes, standards, and documentation for all aspects of the work of data analytics
• Answer business question by providing meaningful data and analytical insights
• Proven ability to prioritize and handle multiple projects at the same time
• Analyzing online customer behavior and trend using deep dive survays. Makes actionable recommendations to management.
• Advanced Excel knowledge including pivot tables. Proven experience in data manipulation.
• Provided assistance for data visualization and reporting with Tableau and Google Analytics.
• Designed stunning visuals and maintained web pages and sites.
• Followed JIRA Scrum methodology, met the challenges and produced a value-added Tableau Product.
• Advocate the use of Tableau solution and help educate business users to facilitate early adoption of the tool.

Environment: Google Analytics, Tableau 10, JIRA, Infusionsoft, Truconversion, VWO, Wicked Reports

Confidential

Data Analyst

Responsibilities:

• Worked with BTEQ to submit SQL statements, import and export data, and generate reports in Teradata.
• Involved in defining the business/transformation rules applied for sales and service data.
• Document, clarify, and communicate requests for change requests with the requestor and coordinate with the development and testing team.
• Worked on metadata clean-up and processing at regular intervals for better quality of data.
• Involved in data load/export utilities like BTEQ, Fast Load, Multi Load, Fast Export and UNIX/Mainframes environments.
• Responsible to build and maintain well-managed data solutions and deliver capabilities to tackle business problems.
• Partner with the business to provide consultancy and translate the business needs to design and develop tools, techniques, metrics, and dashboards for insights and data visualization.
• Drive an understanding and adherence to the principles of data quality management including metadata, lineage, and business definitions.
• Work collaboratively with appropriate Tech teams to manage security mechanisms and data access governance.
• Build and execute tools to monitor and report on data quality.
• Answering the technical queries, driving the product initiatives and metric collection and analysis.
• Generate daily, weekly and monthly reports as per the specifications/requirements by business users.
• Discuss business solutions with client business team, resolving existing problems and improving the report quality.
• Performed Source to Target data analysis and data mapping.
• Created SQL queries to validate Data transformation and ETL Loading.
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.