SUMMARY

• 7+ years of professional work experience as Data Analyst, working with Excel, Tableau and SQL
• Experienced process - oriented Data Analyst having excellent analytical, quantitative, and problem-solving skills using SQL, Tableau, Big data (SQOOP, HiveQL and Spark SQL), Advanced Excel, Python and R.
• Expertise in Data Warehousing concepts including Metadata and Data Marts.
• Experienced working as a part of EDG, EDW and EDL teams.
• Experience in data analysis techniques using Python libraries like NumPy, Pandas, SciPy and visualization libraries of Python like Seaborn, Matplotlib.
• Experience in creating control flow, data flow and transformations using the ETL tool SSIS.
• Knowledge in statistical concepts Descriptive & Inferential statistics (hypothesis testing, mean, median, mode, variance, standard deviation)
• Hands on experience on Tableau Desktop versions 7/8.2.
• Experience writing complex SQL queries like analytical (rank, dense rank, rownumber) and windowing functions (lag, lead).
• Skilled in visualizing, manipulating, and analyzing large datasets and has ability of designing and developing effective reports. Proficient with MS Office Applicants, Excel (Pivot Table, Lookups, PowerPivot, Index, Match, CountIf, dashboards, etc.)
• Manipulating, cleansing & processing data using Excel, Access, and SQL.
• Experience working in agile environment with agile tools like JIRA.
• Knowledge on cloud technology like AWS & Azure.
• Experienced creating dashboards and user story to meet business requirements in Tableau.
• Built dashboards using techniques for guided analytics, interactive dashboard design, and visual best practices.
• Participated in cross-functional teams to reengineer and improve business processes.
• Extensive experience in developing SQL scripts to validate the databases tables and reports data for backend database testing.
• Strong Analytical, Interpersonal, Communication skills and excellent team player.
• Self-motivated with the ability to work both independently and in a team.
• Strong organizational skills. Ability to work well under pressure. Self-motivated and able to work on my own initiative.

TECHNICAL SKILLS

Database: Oracle, MS Access, SQL Server, MySQL, Azure, Teradata.

Visualization: Tableau, Power BI, Visio.

Statistics: Descriptive Statistics, Inferential Statistics, Sampling Distribution, Central Limit Theorem, Hypothesis Testing.

Statistical Packages: NumPy, pandas, matplotlib, seaborn & scikit-learn.

Analytic Tools: Python, R, T-SQL, PL/SQL, Excel (Power Pivot, Pivot tables, lookup function) & VBA.

Big Data Tools: Hadoop (Map Reduce), HDFS, SQOOP, Hive, Spark.

Business Intelligence Tools: SSIS, SSAS, SSRS.

Modelling Techniques: Regression, Clustering and Classification.

Cloud Technology: AWS, Azure

Programming Language: C, C++, Java.

Scripting Language: HTML, XML.

Methodology: Agile, Scrum, Waterfall.

PROFESSIONAL EXPERIENCE

Confidential, Tennessee

Data Analyst

Responsibilities:

• Extracted package shipment and customer contact information data globally from multiple source systems by segmenting customers into six clusters in Teradata to survey customers for every quarter using clustering techniques.
• Studied and analyzed sentiments of low hanging customers and derived strategies to convert passive customers into promoters using customer experience management programs that increased profits by 6%.
• Prioritized problems faced by customers for each quarter and compared with baseline incidence and observe the frequency of each issues. Brainstormingproblem resolution strategy for the most serious issues and observer a 2% decrease in problem frequency over a period of two years.
• Determined statistically significant volume of customer to be invited for survey to ensure random sampling based on customer segment population by considering 95% confidence interval, 4% margin of error and estimated response rate as parameters in Excel.
• Determined root causes of clearance cases in EDW database to allocate and train human resources based on the requirement that cut human resources by 5%.
• Determined cost to company on calls and cases by regions and service types using SQL.
• Determined the action triggered and evaluate customer sentiments prior to vs consequence of sending notifications to healthcare customers during natural catastrophe for medical packages shipped in the affected regions by observing case and call volumes from specific customers.
• Performed data analysis on customer and shipment data using Python Pandas.
• Perform descriptive statistics on the given data like mean, median, mode, variation, central tendency for a given data set in Excel.
• Perform demographic analysis on given customer data by age, sex, region and so on in Excel.
• Perform hypothesis testing to determine if sample size is statistically significant with respect to the population for customer segments in Excel.
• Created presentation in PowerPoint to present to C-level management that are used for decision making.
• Designed decision driving dashboards, used by program managers for showcasing the markets performances &revenue generation.
• Extract data from Teradata by segments of business type as small business and Ecommerce and determine the package volume and profits generated using SQL.
• Performed data exploratory analysis using python pandas.
• Created histograms, pie charts, bar charts, state maps in Tableau to determine profit generated by states, categories, sub-categories, price.
• Created different KPI using calculated key figures and parameters
• Developed Tableau data visualization using Cross tabs, Heat maps, Box and Whisker charts, Scatter Plots, Geographic Map, Pie Charts and Bar Charts and Density Chart.
• Provided Production support to Tableau users and Wrote Custom SQL to support business requirements.

Confidential, Portland

Data Analyst

Responsibilities:

• Prepared the ETL mapping specifications to extract data from the multiple source systems to the target system.
• Combining data from multiple source system and performed data flow and data transformation using SSIS.
• Data analysis using SQL, data quality validation, data governance (business processes, policies)
• Maintained data consistency and database integrity and attended team meetings to identify requirements for data loading and reporting.
• Involved in extensive DATA validation by writing several complex SQL queries and Involved in back-end testing and worked with data quality issues.
• Wrote Test Plan and created Test cases and scenarios for the JIRA items based on business requirements.
• Prepared/Reviewed weekly testing status and reports and performed regression testing in all the environments - DEV, QA, UAT and production using excel, power pivot and power query.
• Performed testing by consuming data from API and comparing with backend relational database.
• Performed data testing once every week over all the environment using SQL and Tableau.
• Generated data extracts in Tableau by connecting to the view using Tableau MySQL connector.
• Created complex Calculations in extracted Tableau data with parameter.
• Using tableau to run complex correlation analysis to identify relationships between measures.
• Combined data from multiple source systems like Excel, oracle, SSMS, MySql to a common staging database using SSIS data flow and control flow tasks.
• Performed various SSIS transformation on the data present in the staging database like data conversion, conditional split, copy column, merge join, derived column transformation and so on.

Confidential

Technology Analyst

Responsibilities:

• Assisted professor by guiding and teaching the other fellow students on topics from SQL, RDBMS & Data analytics.
• Independently supervised class of 90 students and conducted interactive discussions weekly 2-3 times to assist them with their assignments and projects resulting in improvement in their grades.
• Provided study materials, lesson plan/structure, assignments that averaged a 92% completion rate.
• Maintained records of 75 students and created grade sheets to track individual performance and overall class performance.

Confidential

Data Analyst

Responsibilities:

• Pre-processed the dataset that came with duplicate rows, multiple data formats, null values, etc.
• Visualized the data into pie-charts, bar graphs, histograms, scatter plots and performed analysis.
• Performed prediction analysis on classification models like logistic regression and KNN means.
• Worked on libraries like Scikit Learn, Pandas and NumPy.
• Using statistical R-packages and R-programming for Factor, quantitative Analysis, and k-means clustering.
• Experienced with A/B tests on the web

Confidential

Business Analyst

Responsibilities:

• Played a significant role in designing the road map of the One Point system integration project that integrated and streamline three systems customer identity, sales, and services together into one system by extensively communicating with internal customers and clients.
• Followed SDLC Agile methodology in implementing requirements of One Point into Sprints.
• Participated in functional design sessions, created, and executed SQL test scripts to address data issues.
• Written SQL scripts to test the mappings and Developed Traceability Matrix of Business Requirements mapped to Test Scripts to ensure any Change Control in requirements leads to test case update.
• Involved in extensive DATA validation by writing several complex SQL queries and involved in back-end testing and worked with data quality issues.
• Assisted in defining business requirements for the IT team and created BRD and functional specifications documents along with mapping documents to assist the developers in their coding.
• Developed regression test scripts for the application and Involved in metrics gathering, analysis and reporting to concerned team and Tested the testing programs