SUMMARY:

• Possess over 6.8 years of experience and proficient knowledge in Data mining, Text mining, Statistical modelling, Big Data, Data warehousing development, migration and support projects in Manufacturing, Insurance, Energy and Healthcare domain.
• Core expertise on Advance Analytics, Data Mining, Text Mining and Statistical applications using Base SAS, SAS E - Miner, SAS E-Guide, SAS Text Miner, R, SPSS Modeler, Rapid Miner.
• Expertise on data warehousing development and support applications using Microsoft Business Intelligence (SSIS, SSRS) and SQL Server 2008/2005.
• Experience on Big data technologies, Hadoop, Hive, Impala, Vertica.
• Exceptional ability to quickly master new concepts and capable of working in group as well as independently with excellent analytical and communication skills.

TECHNICAL SKILLS:

Analytics Tools: SAS E-Miner, SAS E-Guide, SAS Text Miner, Rapid Miner, SPSS Modeler, SSAS

Programing Language: R, Python, Base SAS

ETL Tool: SSIS

Database: SQL Server, MS Access, Confidential Vertica, Oracle 11g, Teradata

Big Data Technologies: Hadoop, Hive, Impala

Visualization Tool: Qlikview, SSRS

PROFESSIONAL EXPERIENCE:

Confidential

Data Analyst

Environment: Hadoop, R, Python, Confidential Vertica, SSIS, SQL Server, Oracle 11g

Responsibilities:

• Understanding project requirements and current architecture.
• Analyze data source and design data mining capabilities.
• Design ETL to automate data extraction and manipulation.
• Implement the logic to consolidate and summarize data for business decision making in various formats.
• Descriptive statistical analysis, Trend and Loyalty analysis of the printer management fleet data across different model types, functions based on customers’ business environment, usage type, geography, granularity till cartridge level.
• Develop tools for complex reporting, data validation and manipulation techniques.
• Leveraging expertise in WJA, JAC, Printer domain etc. in data acquisition and data quality
• Prepare infrastructure library to be integrated with Data Processing Pipeline
• Presenting insights to higher management.

Confidential

Data Analyst

Environment: Base SAS, SAS E-Miner, SAS E-Guide, SAS Text Miner, SQL Server

Responsibilities:

• Data source analysis, a view on feasibility of data extraction and integration.
• Data extraction, preprocessing and establishing analysis data mart.
• Information extraction from various reports like cause, source, location of the damage, damaged items using Text Miner.
• Analyze the relationship between the variation in cost, duration and number of interactions with variation of input variables came from structured and unstructured data using many data mining techniques.
• Profiling the claims using decision tree.
• Frequent pattern mining.
• Preparing analysis finding reports and other related documents.

Confidential

Data Analyst

Environment: SPSS Modeler

Responsibilities:

• Generated text mining model to extract concepts and types.
• Wrote regular expressions to extract terms.
• Categorized extracted concepts and types.
• Loaded the extracted terms in database.

Confidential

Data Analyst

Environment: R, MS SQL Server 2008, SSIS, Teradata

Responsibilities:

• Created taxonomy trees for Alert (Error events) and Break-Fix (Repairs) for each model.
• Generated several inter-mingled sequences containing alert + break-fix events.
• Fixed length / variable length Sequences
• Sequences ending in / staring with Break-fix events
• Used SSIS ETL package to extract data from Teradata DB, create maps andgenerate sequences.
• Analysis: Event Sequence Clustering, Frequent Subsequence Mining (find most frequent patterns), Markov Model.

Confidential

Data Analyst

Environment: MS SQL Server 2008, SSIS, Rapid Miner, R

Responsibilities:

• Creating SSIS package for Incremental Data Load.
• Writing complex SQL queries and stored procedures.
• Automating the functions using SSIS.
• Analyzing & Understanding the unstructured data and formatting to structured data.
• Create Text mining package using Rapid Miner.
• Drawing conclusion to the existing process and proposing new model which improves the efficiency in lesser time.
• TTF Analysis.
• Business intelligence report that contains analysis and a set of recommendations.

Confidential

Data Analyst

Environment: MS SQL Server 2008, SSIS, R

Responsibilities:

• Data Integration, Removal, profiling.
• Creating SSIS Package.
• Writing Complex queries.
• Attrition Confidential .
• Preparing Reports

Confidential

Developer

Environment: Citrix XenApp, MS SQL Server 2005, SSIS

Responsibilities:

• Create and deploy SSIS packages.
• Jobs monitoring.
• Analyzing errors.
• Creating fixes.
• SSIS Package Optimization.
• Creating and Scheduling Jobs.
• Writing test cases.

Confidential

Data Analyst

Environment: Citrix XenApp, MS SQL Server 2008, SSIS

Responsibilities:

• Understanding the existing application and new business rules.
• Create and deploy SSIS packages.
• Add BPC task in ETL.
• Develop SQL scripts and stored procedures.
• Creating Configuration files.
• Creating and scheduling the jobs.
• Package Optimization.
• Perform Unit Testing

Confidential

Data Analyst

Environment: Windows XP/2000, MS SQL Server 2008, SSRS, SSIS, SSAS

Responsibilities:

• Create and deploy SSIS packages.
• Automate the functions using SSIS.
• Develop SQL scripts and stored procedures.
• Design, deploy and schedule SSRS Reports.
• Develop Report Model and create Ad-hoc report
• Write distributed queries to extract data from different server.
• Create user defined function in SSRS using VB.Script.
• Perform Unit Testing

Confidential

Developer

Environment: Windows 2000/XP, MS SQL Server 2005, SSIS, SSAS, SSRS

Responsibilities:

• Change the existing reports and generate the new reports.
• Create stored procedures and views.
• Create and Deploy SSIS packages.
• Develop Report Model and create Ad-hoc report.
• Perform Unit Testing.