SUMMARY

• Experienced IT professional with more than three years of expertise in Analytics and Data Science.
• Proven skills in qualitative and quantitative analysis, problem solving, ETL processing, predictive modelling, strong analytical and statistical modelling, good understanding of SDLC, manipulating and mining large datasets, ad hoc analyses, meeting deliverables by multi - tasking and assessing priorities, excellent technical writing, verbal and presentation skills.

TECHNICAL SKILLS

Programming: R, SQL, PL/SQL, HiveQL, Python, SPSS, C/C++, MATLAB, VBA

Tools: R Studio, MS/MySQL, Hive, Teradata, Informatica, Google Analytics, Tableau, Jira, Hadoop, ArcGIS, Visio, SSIS/SSRS

Applications: V Tiger CRM, .NET, Banner ERP, MS Office (Excel-Advanced, Power BI, SharePoint, Access, etc.)

PROFESSIONAL EXPERIENCE

Database Analyst

Confidential, Bethesda, MD

Responsibilities:

• Serve as a data analyst within the Research Department, involved in consolidating reports by analyzing external and internal data, perform ETL, automation, data modelling, statistical modelling on AACOMAS and AAMC MCAT data sets.
• Analyze the data set for trend/pattern analysis to find the correlation between fields, to conduct root cause analysis.
• Act as a data steward for key Confidential data sets to collect, maintain and report the data in compliance with Confidential, applicable federal, IRB policies and procedures.
• Gather business requirements, analyze data/workflows and develop complex nested SQL subqueries for extensive data quality checks on outbound files and inbound files, data migration, analysis, and validation.
• Involved in data profiling and cleansing and provide input to resolve data limitation and constraint issues.
• Review client information from various data sources to validate data integrity issues and ensure preservation of the most accurate records for migration into one consolidated Access DB.
• Summarize data sets by respective fields and utilize data visualization charts such as Tree maps, Geo maps and Pivot charts to present the analysis and results.

Data Analyst

Confidential, Elk Grove, CA

Responsibilities:

• Served as a data analyst by using Data Visualization tools like Tableau, Microsoft Power BI and R studio on large data sets to perform interactive reporting and analysis of the dashboards.
• Identified the data risk and compliance for credit cards by monitoring customer behavior and their credit score before targeting them with offers.
• Analyzed heavy spenders on our card portfolio and provided them cash-back categories on the most used ones, so we can retain them and acquire their trust.
• Used R and SPSS for predictive analysis of complex datasets for various products.
• Performed SQL database operations to ensure quantity and quality of data and translated the data into reports.
• Used Google analytics to identify popularity and viewership patterns across various products and provided recommendations for improving revenue generation.
• Used analytical features like functions, parameters, calculations, trend lines, forecasting etc. in Tableau reports.
• Experienced in working with VBA Macros for automating tasks and performed data and risk analysis using Pivot tables and Analytical solver in MS Excel.

Data Analyst

Confidential, DC

Responsibilities:

• Designed & Created Test Cases based on the Business requirements.
• Involved in Data mapping specifications to create and execute detailed system test plans. The data mapping specifies what data will be extracted from an internal data warehouse, transformed and sent to an external entity.
• Involved in extensive DATA validation using SQL queries and back-end testing
• Used SQL for Querying the database in UNIX environment
• Developed separate test cases for ETL process and reporting
• Involved with Design and Development team to implement the requirements.
• Developed and Performed execution of Test Scripts manually to verify the expected results
• Design and development of ETL processes using Informatica ETL tool for dimension and fact file
• Creation Involved in Manual and Automated testing using QTP and Quality Center.
• Conducted Black Box - Functional, Regression and Data Driven. White box - Unit and Integration Testing (positive and negative scenarios).
• Defects tracking, review, analyzes and compares results using Quality Center.

Data Analyst,

Confidential

Responsibilities:

• Served as Data and Reporting Analyst, involved in forecasting data of sales and marketing focusing on product specs.
• Developed and implemented SQL scripts for automating data processing to create daily sales views.
• Used statistical techniques for hypothesis testing to validate data and its interpretations.
• Conducted root cause research to identify process breakdowns within departments and augmented data sets using reference functions in Excel such as Lookups, Index match, and data merges using IF statements
• Imported and exported data from text files used database functions and stored procedures to transform and extract data into Excel worksheets. Further fine-tuned these worksheets using Pivot Tables, Macros, and VBA.
• Created solution driven dashboards by developing different chart types including Crosstab's, Heat/Geo/Tree Maps, Pie/Bar Charts, Circle Views, Line/Area Charts, Scatter Plots, Bullet Graphs, and Histograms in Tableau and R studio.
• Responsible for tracking requirements using Rally and Jira, conducted Gap analysis and created As-Is workflows to better understand the mechanics of the existing system/business process using Visio.