SUMMARY:

• Around 7 years of experience in retail, banking and insurance domain, software applications augmented by a strong post - secondary background in technology, data analysis, software life cycle and project management
• Experienced in Big Data analytics, agile methodology, Process Improvement, Business Intelligence, RDBMS technology like SQL, problem troubleshooting and fix, job monitoring, Performance Management, Training and Development People Management, and Strategic Planning
• Worked on end-to-end Data projects with widening scope from the core analysis to techno-functional role
• Implemented project roadmaps with SOP’s and documentations and worked on an onsite-offshore model and provided weekly updates to management
• Good understanding of software development best practices including source control, coding standards and testing frameworks.
• In-depth knowledge on Tableau Desktop and Tableau Server.
• Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop-down menu option and Parameterized using Tableau.
• End to end experience in designing and deploying data visualizations using Tableau
• Worked on an onsite-offshore model and worked closely with team on technical issues related to the development of complex, large-scale systems
• Designed and coded application components in an agile environment utilizing a test-driven development approach.
• Worked on BI Tools (Tableau and Rapid miner) focusing on best practices, standards and effective visualizations
• Experience in creation of test plans and test cases and testing of Business Intelligence BI tool-based Reports.
• Experience in creating/reviewing Requirement Specification & Design documents.
• Experience of working at Client Location and interacting with business partners in requirements gathering and processing requirements
• Responsible for Gathering requirements and Coordinating with Offshore team, creating Model, creating different types of reports, performance tuning and trouble-shooting of reports, scheduling the reports, and Creating project supporting documents.
• Creative and innovative thinker with effective resources management and goal setting abilities combined with superior leadership, team building, communication, interpersonal, and presentation skills
• Self-motivated with the ability to excel in a fast-paced environment; communicate effectively at all levels; manage competing priorities; and adapt readily to new challenges

TECHNICAL SKILLS:

Programming Language: Hive, Ambari, Python, Shell script, S QL, PL/SQL

BI Tools: Tableau 10.0/8.1/8.0

Data Visualization tools: Tableau - Desktop, Server, Prep, Rapid miner, Decision Trees

Analytics tools: Minitab, Query editor, Risk Optimizer, Dbeaver

Database: DB2, SQL SERVER 2008

Processes: Quality Management concepts, Metrics & measurements, Business Intelligence, predictive modeling, Lean Six Sigma, Data Analysis, Share Point, OneNote, SIM Project, SPSS

Microsoft Tools: Excel (Pivot tables, V-lookup), Word, Access, MS-Project

PROFESSIONAL EXPERIENCE:

Confidential, Bloomington

Senior Data Analyst

Roles and Responsibilities:

• Worked on analytical modeling technique applied to solve decision problems and risk situations faced by analytics team - hands on experience on @risk excel using Monte Carlo simulation, risk optimizer and precision tree software
• Used Tableau desktop as a decision-making tool for identifying the appropriate business model to initiate a customer risk analysis project, the flow of the project monitored through Gantt charts made using Tableau and MS project schedule
• Determined business objectives, assessed the decision situation and determined data analytic goals as part of the data analytics project
• Demonstrated specific steps in data understanding including initial data collection, data description, data exploration and data quality verification for the customer, policy and billing data.
• Analyzed the data to develop an understanding of customer behavior, demographics and life cycle that helped to guide decision making for organization
• Created visually impactful dashboards in Excel and Tableau for data reporting with respect to customer, policy information and analyzed to identify the key metrics
• Conducted data preparation tasks that includes data selection, data cleansing, new data construction, data integration and formatting using Hive and Ambari.
• Created analytics modeling technique including Correlation, Linear regression, cross validation, decision tree, k-means clustering, built the model and assessed its effectiveness as part of project deliverable for customer 360 project
• Evaluated the analytics modeling results for the customer experience with respect to business success criteria and developed plans to deploy outcomes within organization
• Worked on creating Business plan, revenue models, market segmentation strategies, Data encryption, Web designing and hosting as part of customer 360 project
• Experience in data models and reporting packages and ability to analyze large datasets

Environment: Hive, Pig, Tableau Desktop 10.0, Tableau server / Administrator, SQL, Rapid miner, Risk optimizer, Dbeaver, MS-Excel, SQL

Confidential, Woodcliff Lake, NJ

Sr Data Analyst

Roles and Responsibilities

• Gathered the business requirements from the Business Partners and Subject Matter Experts.
• Developed data pipeline using Sqoop, Pig to ingest customer behavioral data and purchase histories into HDFS for analysis.
• Responsible for importing and exporting data from different sources like MySQL into HDFS using SQOOP
• Involved in analysis of structured and unstructured data in Hadoop eco system using Hive and Tableau
• Weekly meetings with technical collaborators and active participation in review sessions with data architects and analysts
• Involved in the process of data acquisition, data pre-processing and data exploration from different database systems
• As a part Data acquisition used sqoop to inject the data from server to Hadoop using incremental import.
• Used to manage and review the Hadoop log files, and Responsible to manage data coming from different sources.
• Involved in importing the data from different data sources like Teradata into HDFS using Sqoop and applying various transformations using Hive, Spark and then loading data into Hive tables.
• Created Pig and written Pig Latin scripts for data analysis and reporting.
• Imported data using Sqoop to load data from MySQL and Oracle to HDFS on regular basis for data and marketing analytics
• Created demand forecasting models used for major business initiatives within the organization
• Written Hive queries for data analysis to meet the business requirements.
• Created Hive tables using Hive QL and worked on partitioned tables to improve the query performance.

Environment: Tableau Desktop 10.0, Tableau server / Administrator, SQL, Hive, Ambari, Hue, Cloudera manager, Rapid miner, Risk optimizer, Dbeaver, MS-Excel, Postgre SQL

Confidential

IT Data Analyst-Lead

Roles and Responsibilities

• Gathered user requirements, analyzed and designed software solution and modeling framework for new datasets based on the requirements.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau
• Effectively used data blending feature in tableau and defined best practices for Tableau report development
• Generated graphical representations of financial activities - time series analysis, visual analysis of content and performed some outlier analysis dashboards with tableau
• Provided periodical financial report dashboards of the southern zone to understand the growth of margin with respect to revenue and expenses over time.
• Working on some Anti money Laundering and OFAC related dashboards for our other lines of businesses
• Generated data extracts in Tableau by connecting to the view using Tableau MySQL connector
• Worked on creating visual discovery of customers, accounts and wires and future ability to search across other transactional data sources
• Involved in creating ad hoc analysis and reporting requests in a timely manner for BML Risk related to fraud Approval's, declines daily, monthly and yearly data
• Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop
• Extensively used advance chart visualizations in Tableau like Dual Axis, Box Plots, Bullet Graphs, Tree maps, Bubble Charts, Water Fall charts, funnel charts etc., to assist business users in solving complex problems
• Modeled all the dashboards with appropriate filters for comprehensive analysis by different types of banking products
• Extensively used analytical features in Tableau like Statistical functions and calculations, trend lines, forecasting etc. in many tableau reports.
• Publish the developed dashboard, reports on the Tableau Server so that the end users having access to the server can view the data.
• Responsible for sending weekly reports to the management regarding individual targets.

Environment: Tableau Desktop 8.1/8.0, Tableau server / Administrator SQL Developer, PL/SQL, MS-Excel, MYSQL

Confidential

Data Analyst

Roles and Responsibilities

• Gathered business requirements and converted it into procedures for database specific payroll and benefits project.
• Responsible for designing and developing Tableau BI reports and dashboards including creating and tuning Data Extracts and maximizing performance through SQL performance tuning (analyze data models, data relationships, and dependencies)
• Suggest best visualization choices and display for big ticket merchant reporting systems
• Developed algorithms and logic for measures of data quality, efficiency, and performance
• Worked closely with the Data Team and IS to develop a data environment that enables speed and efficiency in the delivery of data insights
• Implemented project roadmaps with SOP’s and documentations and worked on an onsite-offshore model and provided weekly updates to management
• Worked on Completing financial analyses, including cost/benefit and decision-support analyses, that provide decision-ready information related to product and operational initiatives for reservation and delivery system
• Ensured that data is implemented into analytic environment and data warehouse and is accessible for reporting, analysis, and model development
• Performed preliminary exploratory analysis on new datasets to help identify issues or patterns, as part of preparation for modeling
• Developed data visualization techniques and presented results to research staff or business partners to help highlight areas of interest.
• Created files, views, tables and data sets to support Sales Operations and Analytics teams
• Performed performance-related analysis following implementation of analytics applications to monitor results
• Established and maintained structures and processes for data security and maintenance resulting in efficiency gains
• Worked with back end database administration to provide necessary tables as per requirements
• Worked with end user frequently to resolve various issues in day-to-day activities

Environment: Tableau Desktop 8.1/8.0, Tableau server / Administrator, SQL Developer, QMF, DB2, MS-Excel, SQL 2008