SUMMARY

• Professional qualified Data Scientist/Data Analyst with over 4 years of experience in Data Science and Analytics including Machine Learning, Data Mining and Statistical Analysis along with IT experience as a data analyst including profound expertise and experience on statistical data analysis such as transforming business requirements into analytical models, designing algorithms, and strategic solutions that scales across massive volumes of data.
• Around 4 Years of experience in Web Application Development & Designing. Expertise in Object Oriented Concepts, Object Oriented Design (OOD), Object Oriented Analysis (OOA) Programming.
• Having experienced in Agile Methodologies, Scrum stories and sprints experience in a Python based environment, along with data analytics, data wrangling and Excel data extracts.
• Proficient in developing Web Services (SOAP, RESTful) in Python using XML, JSON. Developed web - based application using Django framework with python concepts.
• Experience working in various Software Development Methodologies like Waterfall, Agile SCRUM and TDD.
• Involved in all the phases including data extraction, data cleaning, statistical modeling and data visualization with large data sets of structured and unstructured data.
• Strong experience in Business and Data Analysis, Data Profiling, Data Migration, Data Conversion, Data Quality, Data Governance, Data Integration and Metadata Management Services and Configuration Management.
• Strong skills in statistical methodologies such as A/B test, experiment design, hypothesis test, ANOVA.
• Solid ability to write and optimize diverse SQL queries, working knowledge of RDBMS like SQL Server 2008, NoSQL databases like MongoDB 3.2.
• Have also done some database work regarding Confidential platform and hands on EC2, S3, Redshift, Snowflake, Databricks. Worked with NoSQL Database including HBase, Cassandra and MongoDB.

TECHNICAL SKILLS

Languages: SQL, Python, PL/SQL, T-SQL.

Packages: ggplot2, caret, dplyr, Rweka, gmodels, RCurl, tm, C50, twitteR, NLP, Reshape2, rjson, plyr, pandas, Numpy, seaborn, SciPy, matplot lib, Scikit-learn, Beautiful Soup, Rpy2.

Web Technologies: JDBC, HTML5, DHTML and XML, CSS3, Web Services, WSDLData Modelling

Tools: Erwin r 9.6, 9.5, 9.1, 8.x, Rational Rose, ER/Studio, MS Visio, SAP Power designer.

Big Data Technologies: Hadoop, Hive, HDFS, MapReduce, Pig, Kafka.

Databases: SQL, Hive, Impala, Pig, Spark SQL, Databases SQL-Server, My SQL, MS Access, HDFS, HBase, Teradata, Netezza, MongoDB, Cassandra.

Reporting Tools: MS Office (Word/Excel/Power Point/ Visio), Tableau, Crystal reports XI, Business Intelligence, SSRS, Business Objects 5.x/ 6.x, Cognos7.0/6.0.

ETL Tools: Informatica Power Centre, SSIS, Oracle Data Integrator (ODI), Cognos Data Manager, Pentaho Data Integration, QlikView Expressor, Ab Initio, Pentaho.

Project Execution Methodologies: Ralph Kimball and Bill Inmon data warehousing methodology, Rational Unified Process (RUP), Rapid Application Development (RAD), (JAD).

BI Tools: Tableau, Tableau server, Tableau Reader, SAP Business Objects, OBIEE, QlikView, SAP Business Intelligence, Amazon Redshift, or Azure Data Warehouse.

Operating System: Windows, Linux, Unix, Macintosh HD, Red Hat.

PROFESSIONAL EXPERIENCE

Python Developer

Confidential, Mountain View, CA

Responsibilities:

• Involved in Design, Development and Support phases of Software Development Life Cycle (SDLC). Performed data ETL by collecting, exporting, merging and massaging data from multiple sources and platforms including SSIS (SQL Server Integration Services) in SQL Server.
• Wrote and executed various MYSQL database queries from python using Python MySQL connector and MySQL dB package.
• Working on various Integrated Development Environments like PyCharm, Anaconda Spyder. Experience with application servers and webservers including WebSphere, Tomcat and drop wizard.
• Wrote python scripts to parse XML documents and load the data in database. Proficient in developing Web Services (SOAP, RESTful) in Python using XML, JSON.
• Experienced in working with various Python IDE's using PyCharm, PyScripter, Spyder, PyStudio, Pydev, Eclipse, NetBeans, Sublime text.
• Used Confidential Redshift, S3, Spectrum and Athena services to query large amount data stored on S3 to create a Virtual Data Lake without having to go through ETL process.
• Experience in implementing and working on the python code using shell scripting. Performed troubleshooting, fixed and deployed many Python bug fixes.
• Developed web-based applications using Python, Django, XML, CSS, HTML, JavaScript, AngularJS and jQuery. Implemented REST APIs using Python and Django framework.
• Worked on WAMP (Windows, Apache, MYSQL, Python/PHP) and LAMP (Linux, Apache, MySQL, Python /PHP) Architecture.

Python Developer

Confidential | Houston, TX

Responsibilities:

• Developed web applications and RESTful web services and APIs using Python, Django and PHP. Experience with Django, a high-level Python Web framework.
• Automated Confidential S3 data upload / download using Python scripts. Automated JIRA processes using Python and bash scripts.
• Created Python and Bash tools to increase efficiency of application system. Developed Merge jobs in Python to extract and load data into MySQL database.
• Analyzed client needs and developed software tools to assist dynamic site content creation (Python, wxPython). Responsible for setting up Python REST API framework using DJANGO.
• Developing Python Framework using Django to perform scan software unit monitoring. Built various graphs for business decision making using Python library.
• Involved in Confidential Data Migration Services and Schema Conversion Tool along with Talend ETL tool. Create, modify and execute DDL in table Confidential Redshift tables to load data.
• Responsible for setting up Python REST API framework using Django. Implement code in python to retrieve and manipulate data.
• Created entire application using Python, Django, MySQL and Linux.
• Developed a fully automated continuous integration system using Git, MySQL, Jerkins, and custom tools developed in Python.
• Worked in RDBMS implementation using, SQL, PL/SQL, DB2, MySQL on Oracle database. Worked on Python OpenStack APIs and used Numpy for Numerical analysis.
• Worked on server-side applications with Django using Python programming. Utilized standard Python modules such as csv, itertools and pickle for development.

Python Developer

Confidential | Houston, TX

Responsibilities:

• Worked on development of backend services using Python, SQL and Linux. Created many API's for Scrum project which involves creating and maintaining projects in an organization.
• Managed datasets using data frames and MySQL, queried MYSQL database queries from python using Python-MySQL connector MySQL dB package to retrieve information. Development of real-time multi-tasking systems using Python.
• Designed and developed components using Python with Django framework. Implemented code in python to retrieve and manipulate data. Developed HTML, Swing and JSP pages for user interaction and data presentation.
• Used Python & Django creating graphics, XML processing of documents, data exchange & business logic implementation between servers.
• Involved in Requirement analysis, design and Implementation applying the Water fall model. Wrote Servlets programming and JSP scripting for the communication between web browser and server. Integrate the Oracle BPM with the Spring Framework in the enterprise layer.
• Involved in packaging, deployment and upgrade of different modules of SAS on JBoss App Server. VB code Analysis and Sybase store procedure converted into SQL.

Data Scientist

Confidential

Responsibilities:

• Performed Multinomial Logistic Regression, Random forest, Decision Tree, SVM to classify package is going to deliver on time for the new route. Performed data analysis by using Hive to retrieve the data from Hadoop cluster, Sql to retrieve data from Oracle database.
• Application of various machine learning algorithms and statistical modeling like decision trees, regression models, neural networks, SVM, clustering to identify Volume using Scikit-learn package in python, MATLAB.
• Utilized Spark, Scala, Hadoop, HBase, Cassandra, MongoDB, Kafka, Spark Streaming, MLlib, Python, a broad variety of machine learning methods including classifications, regressions, dimensionally reduction etc.
• Developed Spark/Scala, Python for regular expression (regex) project in the Hadoop/Hive environment with Linux/Windows for big data resources. Used clustering technique K-Means to identify outliers and to classify unlabeled data.
• Evaluated models using Cross Validation, Log loss function, ROC curves and used AUC for feature selection. Analyze traffic patterns by calculating autocorrelation with different time lags.
• Performed Multinomial Logistic Regression, Random forest, Decision Tree, SVM to classify package is going to deliver on time for the new route. Performed data analysis by using Hive to retrieve the data from Hadoop cluster, Sql to retrieve data from Oracle database.
• Used MLlib, Spark's Machine learning library to build and evaluate different models. Implemented rule-based expertise system from the results of exploratory analysis and information gathered from the people from different departments.
• Used Python to perform ANOVA test to analyze the differences among hotel clusters. Implemented application of various machine learning algorithms and statistical modeling like Decision Tree, Naive Bayes, Linear Regression using Python to determine the accuracy rate of each model.
• Performed Data Cleaning, features scaling, features engineering using pandas and Numpy packages in python. Developed MapReduce pipeline for feature extraction using Hive.
• Used Python, R, SQL to create Statistical algorithms involving Multivariate Regression, Linear Regression, Logistic Regression, PCA, Random forest models, Decision trees, Support Vector Machine for estimating the risks of welfare dependency. Used Graphical Entity-Relationship Diagramming to create new database design via easy to use, graphical interface.
• Designed Tableau bar graphs, scattered plots, and geographical maps to create detailed level summary reports and dashboards. Developed hybrid model to improve the accuracy rate.
• Worked with data analysis using ggplot2 library in R to do data visualizations for better understanding of customers' behaviors. Visually plotted data using Tableau for dashboards and reports.
• Implemented statistical modeling with XGBoost machine learning software package using R to determine the predicted probabilities of each model. Delivered the results with operation team for better decisions.
• Created multiple custom SQL queries in Teradata SQL Workbench to prepare the right data sets for Tableau dashboards. Used R and python for Exploratory Data Analysis, A/B testing, ANOVA test and Hypothesis test to compare and identify the effectiveness of Creative Campaigns.
• Perform analysis such as regression analysis, logistic regression, discriminant analysis, cluster analysis using SAS programming. Used Meta data tool for importing metadata from repository, new job categories and creating new data elements.