SUMMARY

• 5 Years of experience in employing R Programming, MATLAB, SAS, Tableau and SQL for data cleaning, data visualization, risk analysis and predictive analytics
• Hands on experience with data mining techniques such as Decision Trees, Regression Analysis, gradient boosting
• Hands on experience in building user defined R functions for optimizing the code.
• Well versed with statistical inferences concepts - Hypothesis Testing, t-test, Chi-square tests, ANOVA, Bootstrapping
• 2 years of experience in the field of Data analysis, ETL Development and Data Modeling
• Extensive experience in writing Complex Transact SQL (T-SQL) Queries, Sub queries etc.
• Expert in Data Conversion, Normalization, Multi-Dimensional Modeling and involved in creation of Fact Tables, Dimension Tables, Star Schema and Snowflake dimensional schema using Erwin Tool.
• In-depth knowledge of RDBMS concepts with expert knowledge of constructing Relational Database according to business requirement.
• Strong experience in Business Analysis, Data Profiling, Data Migration, Data Conversion, Data Quality, Data Integration.
• Experience in providing Logging, Error handling by using Event Handler and Performance Tuning in SSIS packages by using Row Transformations, Block and Unblock Transformations.
• Experienced in whole cycle of DTS/SQL server integration services (SSIS 2005/2008) Packages (Developing, Deploying, Scheduling, Troubleshooting and monitoring) for performing Data transfers and ETL Purposes across different servers.
• Experienced in performing Incremental Loads and Data cleaning in SSIS.
• Transformed data from one server to other servers using tools like Bulk Copy Program (BCP), and SQL Server Integration Services (SSIS) (2005/2008).
• Experience in creating Jobs, Alerts, SQL Mail Agent and scheduling DTS Packages.
• Good understanding of Microsoft Reporting Service (SSRS) with Report authoring, Report management, Report delivery and Report security
• Expert in Data Conversion, Normalization, Multi-Dimensional Modeling and involved in creation of Fact Tables, Dimension Tables, Star Schema and Snowflake dimensional schema using Erwin Tool.
• In-depth knowledge of RDBMS concepts with expert knowledge of constructing Relational Database according to business requirement

TECHNICAL SKILLS

Data Analytics Tools: R Programming, Tableau, MATLAB

Business Intelligence Tools: SSIS, SSAS, SSRS, Informatica IDQ, Visual Studio

Languages/Tools: Python, SQL, T-SQL, SQL Server, C, C++, JAVA, HTML

Project Management Tools: Microsoft Project, Visio, Microsoft Excel, VBA, PowerPoint and MS Office suite

Database Skills: Microsoft SQL Server 2008,Oracle 11g, Teradata13.1, Hive

PROFESSIONAL EXPERIENCE

Data Scientist Consultant

Confidential, Woonsocket

Responsibilities:

• Data mining and analysis for ad hoc projects include: exploratory data analysis, predictive analytics, data visualization, data and performance reporting for the campaigns
• Develop insightful dashboards that management can use to produce informed business decisions and enhance the current campaign performances
• Responsible for developing advanced predictive models to measure the effectiveness of key selling and marketing tactics, and constructing marketing mix models for optimization
• Participates in cross functional team environments and handles a variety of concurrent projects
• Build in depth analysis, translate the analysis into marketing insights, presenting business opportunities for strategic action, while using analysis and data to support concepts
• Utilize supplied primary data and mine secondary data to better support business efforts and discover opportunities in the market
• Participate in the team development of targeted marketing campaigns and is responsible for data extraction, list or lead generation and proper test design to ensure that test methodologies are in line with analytical methods
• Collaborate with several Campaign Program Development Managers in preparing the Campaign Specification Documents with the help of insights found from the Predictive Models to improve the Campaign performance
• Interacting with a group of vendors and credit agencies (Trans Union, Experian etc) to discuss the Operational files and strategies
• Develop and execute multi-channel contact strategies across customer segments touch point channels (email, direct mail, social and direct marketing on site), with the goal of engendering loyalty and driving revenue from existing and prospect customers
• Document and communicate campaign strategy and work with campaign execution team and project manager to establish timeline and schedules for implementation and measurement

Confidential, Charlotte

Responsibilities:

• Used ggplot2 plotting system library for generating plots for exploratory analysis
• Build user defined R functions for handling complex calculations.
• Used dplyr functions such as filter(), arrange(), mutate() for managing data frames.
• High Level Designing of ETL DTS Packages & SSIS Packages for integrating data using OLE DB connection from heterogeneous source by using multiple transformations provided by SSIS.
• Discovered interesting patterns such as Bankers performance saturated as they reached silver club, most of them couldn’t move to higher clubs as the sales target was set high.
• Identify new fraud patterns and trends via interaction with different fraud risk teams and analyzing the data using different statistical analyses and case studies.
• Performing Data validation on OLAP cubes by running MDX Scripts and T-SQL Scripts
• Worked with Data Modelers to create a Physical DataModel from the Logical DataModel using Erwin tool

Confidential, Peoria

Responsibilities:

• Predicted failures of C175 mining trucks using supervised machine learning algorithm
• Used R Programming, Matlab for data extraction, mining & statistical analysis
• Automated daily reporting alerts to a website using JSON script, MATLAB, SQL
• Generate visualization reports on performance of mining trucks using MS Excel, Tableau.
• Provided inputs to development team in performing extraction, transformation and load for data marts and data warehouses.
• Developed statistical models to predict the critical variables leading to vehicle down time.
• Developed scripts to detect High exhaust temperature, bellow leak in mining trucks
• Summarizing engine performance data for various engineering teams using database tools (SAS, Tableau, SQL)
• Worked extensively in documenting the Source to Target Mapping documents with data transformation logic.

Statistical Data Analyst

Confidential, Oklahoma

Responsibilities:

• Identified the business metric from the data collected by client
• Recommended business process changes that helped client to increase revenues and restore profitability
• Analyzed experimental data and provided statistical analytic solutions for heat flow projects.
• Helped improving the overall sales and margin performance to assist the business in meeting financial goals
• Define the list codes and code conversions between the source systems and the data mart.

Research Assistant

Confidential, Oklahoma

Responsibilities:

• Used Analytics in analyzing effect of Silane coupling agent on mechanical properties of Single Glass rod-Epoxy Composite
• Exploratory analysis using Tableau to find out optimum percentage of Silane to be used in composites
• Built Multi variable regression models for calculating estimated tensile strength in the composite.
• Interpreted force curves and images obtained from Atomic Force Microscopy
• Developed and presented weekly presentations for further improvements of thesis work

Data Analyst

Confidential

Responsibilities:

• Provided database support. Handled data collection, data analysis, data sizing, design, and creation of database structures like tables, views, and indexes.
• Restructured and cleaned up current SQL 2000 installation.
• Restructured backups of all systems, including Exchange 5.5/2000 & SQL 7.0/2000. Resolved help desk issues.
• Developed new stored procedures, database table, triggers and indexed data.
• Migrated the data from Oracle 8i/8.0, Flat File to MS SQL Server 2000 using ETL tools.
• Managed database files, transaction log and estimated space requirements.
• Analyzed, designed and written functional and technical specifications and also developed test plans and program enhancements for new releases.
• Involved in implementation of user logins, roles and profiles as a part of security policies for various categories of users.
• Developed complex stored procedure using T-SQL to generate Ad hoc reports using SSRS.
• Scheduled the Reports to run on daily and weekly basis in Report Manager and also email them to director and analysts to review in Excel Sheet.