TECHNICAL SKILLS:

Languages: SQL, HiveQL, Python, R

Tools: Tableau 10.5, PowerBI, HUE, Jupyter Notebook, SAS Enterprise Miner 14.2, SAP BusinessObjects 4.1, Microsoft ExcelMicrosoft Visio, Erwin, Netbeans 8.1

Databases: Oracle 11g, Hive, Cassandra, MS SQL Server

Technologies: Cloudera, Hive, Oozie, Sqoop, Hadoop, HDFS, MapReduce, Google Analytics

Functional: Quality Assurance, STLC, Defect Management and Lifecycle, Business Analysis, Project Management, A/B TestingLeadership, Banking & Financial Services, ERP, High - Tech, Healthcare, Agile

WORK EXPERIENCE:

Confidential

BI Analyst and Project Lead

Technologies: Tableau, SAP BW, SAP BO 4.1, Visio, Erwin

Responsibilities:

• Contributed BI strategies, reduced overhead costs of NXP semiconductors production and optimized monthly costs by 25%.
• Performed data wrangling from ERP and SCM systems for ETL process and identified prominent KPIs for Tableau reporting.
• Developed Dashboards using maps and geocoding based on client requirement to identify territorial business across country.
• Scheduled data refresh on Tableau Server for weekly and monthly increments based on business change and ETL purpose to ensure that the views and dashboards were displaying the changed data accurately.
• Involved in reviewing Business Requirements and analyzing data sources and databases for design, reports, and analysis.
• Generated reports using SQL queries in Tableau and published them to users in online through Tableau server for management, business team and customer for further decisions.
• Developed interactive dashboards using Actions (filter, highlight and URL) on dashboard and stories to make appealing to a user.
• Designed and developed analytical reports from multiple data sources by blending data on a single worksheet in Tableau.
• Utilized advanced features of Tableau software like to link data from different connections together on one dashboard and to filter data in multiple views at once.
• Developed marketing dashboards, reports, and visualization that track key performance indicators and calculating return on investment for presentations to marketing teams, as well as executive leadership team
• Utilized advance features of Tableau software like to link data from different connections together on one dashboard and to filter data in multiple views at once.
• Performed generating Daily/Weekly Sales & Finance trending reports using Tableau by identifying the dimensions, measures, measure values and level of details for Business Analytics & Top Executives to give an overview current Trends.
• Created some calculated fields to achieve Confidential and Confidential growth, and Percentage of the total to analyze the performance.
• Developed storytelling dashboards in Tableau Desktop and published them on to Tableau Server which allowed end users to understand the data on the fly with the usage of quick filters for on-demand needed information.
• Creating basic calculations including string manipulation, basic arithmetic calculations, custom aggregations and ratios
• Worked with QA and stakeholders to audit functional requirement documents for systems design and imparted business inputs.

Confidential

Data Analyst

Technologies: Big Data Hive, Tableau, Oracle11g, MS SQL Server, HUE, Visio, Erwin

Responsibilities:

• Extracted customer data to analyze type of products used, frequency and payment modes to help Product and Marketing team for further efforts in streamlining payment structure and customer reachability.
• Worked with various middleware systems to track payment process and report loopholes in the system components to ensure 100% ETL process.
• Optimized SQL queries in Hive by indexing, partitioning, bucketing, vectorization, unit testing, sampling, and map joining.
• Wrote complex SQL analytic functions for report analysis using Ranking, windowing, lag, lead and moving average.
• Gathered data from Hive data warehouse schema directories and loaded data to Tableau to create different visualizations.
• Tested dashboards to ensure data was matching as per the business requirements and if there were any changes or migrations to the underlying data.
• Created ad-hoc reports in Tableau Desktop by connecting various data sources, multiple views and associated reports.
• Designed aggregate SQL queries on partitioned and bucketed tables improving the query response by 188 seconds.
• Designed SQL queries in Hive data warehouse for source to target testing, data accuracy testing, completeness, data transformation, data quality, and incremental testing.
• Verified Source to Target mappings in Hive by checking process IDs in Hive and validate data entries improving coverage by 18%.
• Enhanced customer experience from Tableau reporting and conceptualized campaigning user stories for paperless bill adoption.

Capstone Project Manager

Confidential

Responsibilities:

• Managed the team, coordinated meetings with customer and advisor ensuring 100% delivery and informed decisions.
• Gained an understanding of business requirements and devised major problems the training center if experiencing.
• Explored the data by wrangling occupation and industry data to analyze growing trends relevant to a vocational course.
• Proposed an average billing system to eradicate their year-end losses resulting from previous budget planning.
• Performed competitive analysis of vocational training courses offered by other Career and Technology centers and extract the common courses and uncommon courses to evaluate business strategy.
• Recommended popular vocational programs common in other vocation training centers by visualizing the heatmap in Tableau.
• Hypothesized market segments for IoT integration to Autonomous vehicles and IoT data will help make decisions in real-time.
• Devised disruptive methods the trucking industry can utilize for revenue generation and seamless delivery to customers.
• Cleaned and manipulated unstructured data sources and wrangled data using Python pandas toolkit for further visualization.
• Used new clean data sources and created various visualizations of driving factors, road conditions, and distractions.
• Analyzed the visualizations using geospatial, heatmap and bubble charts observing accident-prone zones and their severity.
• Created a project blueprint in Visio and designed the ER diagram for tables based on normalization methodology.
• Modeled the database and validated check constraints, primary key, and foreign key constraints maintaining data integrity.
• Designed complex SQL queries in Oracle for join operations, subqueries, windowing and analytics functions on large datasets.
• Created Pivot tables using DECODE, ROLUP, CUBE and GROUPING SETS to create reports for total sale of vehicles from each branch, year, month, quarter and supervisor.
• Utilized SQL Analytics functions to prepare data from BI reporting point of view to help a owner as a decision maker.