SUMMARY

• 7+ years of experience as a Data Analyst with various statistical models and software’s.
• 7+ years of experience indatagathering,dataanalysis, forecasting and prediction.
• 6+ years of experience in analyzing large volumes of blended, unstructured and noisy data.
• 6+ years of experience in making pivot table, making dashboards and macros in Excel.
• 5+ years of experience in R programming.
• 3+ years of experience in Python programming.
• 1 year of experience of Machine Learning.
• Expertise in designing and developing dashboards using Tableau 9.x/8.x/7.x (Desktop/Server) usingdatafrom multiple sources like Oracle, SQL Server, Teradata, DB2 and Flat Files.
• Extensive experience in text analytics, generatingdatavisualizations using R,Pythonand creating dashboards using tools like Tableau.
• Experience with statistical modeling, machine learning,datamining and natural language processing.
• Worked extensively onDataProfiling,Datacleansing,DataMapping andDataQuality
• Use JavaScript and D3.js to implement interactive visualizations of data sets in JSON and CSV format.
• Extensive experience in using Tableau functionalities for creating different Requests, Filters, Charts, Interactive Dashboards with page and dashboard Prompts.
• Worked on creating reusable charts with D3.js.
• Experience in LargeDataprocessing and transformation using Hadoop - Hive
• Outstanding knowledge in writing complex SQL queries, Stored procedures, database tuning, query optimization and resolving key performance issues,
• Designed thedataconversion strategy, development ofdatamappings and the design of Extraction, Transformation and Load (ETL) and EDA routines for migratingdatafrom non-relational or source relational to target relational.

TECHNICAL SKILLS:

• Oracle 9.x/10.x
• MySQL
• MS SQL Server
• Scala
• Python
• R
• Tableau 9.x/10.x
• D3.js
• HTML
• CSS
• Javascript
• Google Analytics
• Visio
• Looker
• Matlab
• Geckoboard

PROFESSIONAL EXPERIENCE:

Sr. Data Analyst

Confidential, San Francisco, CA

Responsibilities:

• Worked with Confidential to analyze data for Bike Sharing programs in USA like Bay area Bike Sharing (BABS), Capital Bikeshare, Hubway.
• Translated business needs intodataanalysis, business intelligencedatasources and reporting solution for different types of Clients.
• Develop SQL queries for extracting tables.
• Analyzed different types ofdatato derive insights about relationships between locations, statistical measurements and qualitatively assess thedatausing R/R Studio
• Performed analysis on implementing Spark using Scala and wrote spark sample programs using PySpark.
• Designed algorithm to tokenize words from a sentence and retrieve its parts of speech.
• Created External and Managed tables inHiveand used them appropriately for reporting.
• Involved in assimilating different structured and unstructureddataand using Pig/Hivequeries to clean aggregate and transformdatarequired for reporting.
• Engaged in a number of natural language processing tasks and activities
• Worked on Natural Language Processing with NLTK module of python for application development for automated customer response.
• Used twitter APIs to analyze the demographics of customer base using Tableau.
• Conducted a price elasticity test on the products of Confidential using R.
• Developeddatavisualization reports and online dashboards with Tableau, and D3.js
• Created word cloud of top words used by people when describing Confidential on social media.
• Developed models to analyzedatausing R, MATLAB, and Excel
• Utilized Python libraries of Pandas, Numpy, Matplotlib and D3JS technologies.
• Developed Pythonscripts fordatacollection/dataanalysis
• Developed functions for extracting valuable information from large datasets utilizing Excel and R.
• Performed Text Mining for Customer Complaints using R.
• Implemented action filters, parameters, calculated filed and set for preparing dashboards and worksheets inTableau.
• Extended algorithm to retrieve tweets from different users around the globe using the tweepy library in python to access the twitter API.
• Given the user’s keyword, different tweets were pulled and stored and the sentiment attribute of the analysis variable of each string was calculated using the TextBlob natural language library.
• Initiated ETL process to transfer rawdatafrom Flat files into SQL Server
• PerformedDataCleansing widely during the ETL's Extraction and Loading Phase by analyzing the rawdatacreatingConditional Splits.
• Performed sentiment analysis to get an understanding of what people think about
• Analyzed customers’ behavior using Linear Regression, Logistic Regression in gretl and Stata by implementing various predictive analysisalgorithms.
• Used Pythoncoding to createdataprocessing workflows
• Filtered and Loadeddatafrom different formats ofdatasources into Database Tables.
• CreatedTableauscorecards, dashboards using Stack bars, bar graphs, scattered plots,
• Performed troubleshooting, fixed and deployed manyPythonbug fixes of the two main applications that were a main source ofdatafor both customers and internal customer service team.
• Developed dashboards inTableauDesktop and published them on toTableauServer that allowed end users to understand thedataon the fly with the usage of quick filters for on demand-needed
• Worked with large data sets, created Dataevaluation/Visualization reports and KPI reports using Tableau to ensure data accuracy, integrity and consistency.

Technology used: SQL, R, Python, Tableau, Hive, Excel, API, Matlab, D3.JS, Scala.

Data Analyst

Confidential, NJ

Responsibilities:

• Manipulated and analyzed data in a variety formats (SQL, Access, Excel) and from various sources.
• Used Advanced Excel techniques like Pivot tables, vlookup to slice and dice data from various angles
• Partnered with business users to understand their data needs and data use cases.
• Involved in migration of various objects like stored procedures, tables, and views from variousdatasource toSQLServer.
• Used the Boruta feature selection to identify the resources that contribute the most to the output in R using the Caret package.
• Web scraping using regular expressions and the XML library
• Implemented several models to predict the loss value (loans) based on hundreds of categorical and continuous features.
• Imported the customerdatainto Python using Pandas libraries and performed variousdata analysis - found patterns indatawhich helped in key decisions for the company
• Performeddataanalysis anddataprofiling using complex SQL on various sources systems
• The XGBoost had the best accuracy among logistic regression, random forest, and a neural net.
• Updated and manipulated content and files by usingpythonscripts.
• Generated comprehensive analytical reports by running SQL queries against current databases to conductdataanalysis.
• Generated queries usingSQLto check for consistency of thedatain the tables and to update the tables as per the Business requirements.
• Worked on theSQLquery development for the testing of the different Dashboards and Analysis
• Created Unit test cases for Analytics reports and Analytics dashboards and executed manually
• Created Databases, Schemas, Tables, Cluster/Non-Cluster Indexes and other database objects.
• Created and Modified T-SQLstored procedures/triggers for validating the integrity of thedata.
• Provided ad-hoc reporting and data analysis to the financial advisors using Tableau 10.x.
• Modified database schema to optimize performance and data integrity.

Technology used: Python, SQL, R, Tableau, Excel.

Data Analyst

Confidential, NY

Responsibilities:

• Used Agile Methodologies, Scrum stories and sprints experience in a Python based environment, along withdataanalytics and Exceldataextracts.
• Performed data analysis and provided data integrity verification.
• Provided various reports on inventory and forecasting using complicated SQL queries.
• Created dashboards, charts and presented Adhoc requests to support stakeholders.
• Built dashboards for monitoring economic KPIs using Excel and Marco.
• Designed and developed weekly, monthly reports by using MS Excel Techniques (Charts, Graphs, Pivot tables) and Power point presentations.
• Strong Excel skills, including pivots, Vlookup, conditional formatting, large record sets. Includingdatamanipulation and cleaning.
• Utilized KPIs like AR turnover rate to show areas of improvement, which initiated actions to bring aging AR from 65% to 98% current, and to collect 2% interest income according to the contract.
• Created timesaving applications, ad-hoc reports, and dashboards using MS Excel, Access, and Tableau. These solutions allowed the end-users to focus on analytics and process improvement.
• Automated monthly reports generation process to integrate data, and to produce results.
• Exported data to spreadsheets for reporting, summarizing, created pivot tables, bar graphs and charts.
• Produced automated reports to track inventory of development and production equipment.
• Developed and conducted training programs for employees to facilitate and improve productivity and performance.

Environment: SQL, Python, Excel, R and TubuleDatabase Analyst, Data Analyst May 2010- July 2012

Confidential

Data Analyst and Database Analyst

Responsibilities:

• Researched and analyzed data related high-profile clients ‘background, positions, demographics,
• Document the complete process flow to describe program development, logic, testing, and implementation, application integration, coding.
• Used R to develop algorithms to analyze large data sets
• Analyzed data to find patters of consumer behavior.
• Used Tableau for Ad hoc Reporting.
• Used Excel to present and analyze data charts etc.
• Gathered, analyzed, formatted and keyed mission critical information.
• Worked with developers on database design, test and automation tasks.
• Trained organization’s junior staff to do data research and input.