CAREER OBJECTIVE:

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

TECHNICAL SKILLS:

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

Software Tools: R Studio, MySQL, SQL Server, Netezza, Informatica, Google Analytics, Tableau, Hadoop, ArcGIS, SSIS/SSRS

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

PROFESSIONAL EXPERIENCE:

Data Analyst/Modeler

Confidential, Cincinnati, OH

Responsibilities:

• Serve as a Data Analyst/Modeler across Merchandising and Customer Experience Platform (CXP) Agile Release Trains working on projects of establishing an enterprise data warehouse for multiple customer communication channels, for further analysis with data science algorithms for next gen marketing.
• Involved with querying the Prod and Stage Databases using Aginity Amp, Netezza and SSMS to create Data Marts for performing Exploratory and Inferential statistics.
• Work closely with stakeholders and management from Confidential and 8451 (Data Science subsidiary of Kroger) to gather requirements, identify process implementation and evaluate process related issues.
• Explored existing Cassandra NoSQL rings to understand the structure and get familiarized with non-relational Databases on an enterprise scale for potential future migration.
• Performed Data mapping and modelling using Erwin and Visio for ETL. Involved with writing technical ETL documentation for DB migration from MS Access to SQL server.
• Involved in performing end-end manual testing of Planogram and Floorplan changes through CAO activation across multiple downstream systems using SQL and Informatica Data Quality for data integrity.
• Extensively used Tableau Desktop and Advanced Excel to create business intelligence visualizations for sprint reports and ad-hoc requirements.

Database Analyst

Confidential, Bethesda, MD

Responsibilities:

• Serve as a Database Analyst within the Research Department, involved in consolidating reports by analyzing external and internal data, perform ETL, data modelling, statistical modelling 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.
• Serve as a Database Analyst and develop complex data extracts, applications, and ad-hoc queries as requested by internal and external customers using SSMS, SSIS and Excel.
• Troubleshoot data issues impacting extract delivery and perform data profiling and analysis on client data.
• Work closely with stakeholders to understand requirements regarding solutions, ensure data quality and match-back to online touch results used by Com’s.
• Explore existing data repositories to explore the existing architecture created by third-party vendor and leverage the data using BI tools to create reports, dashboards and other analyses.

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 to target them with offers.
• 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.
• Extensively used VBA/Pivot tables/MS Excel add-ins for automating tasks and to perform data/risk analysis

Data Analyst Intern

Confidential, Washington, DC

Responsibilities:

• Worked in marketing, advertising healthcare analytics field and my responsibilities include extract and analyze intelligence reports using data imported from google analytics to provide insights about our client's website performance and KPI which drives the visitors to increase the conversion rate and site traffic.
• Conducting workforce analysis and statistical testing of health care practitioner and health care organization demographics and relevant parameters information using SQL, Analytical solver in Excel, SPSS and Tableau.
• Track open rate and click through rate of all business partners and help them in improving their advertising campaigns.
• Generated google analytics acquisition reports which helped the clients to know more about the website traffic, popularity and viewership patterns across various services and provided recommendations for improving revenue generation.
• Prepared and assisted in documenting the quarterly and half yearly reports of the Healthcare provider clients.

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
• 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.

Confidential

Data Analyst

Responsibilities:

• Document the findings and present the reports to senior research management.
• Analyze the survey structure and recommend changes to collect more intelligence from responses by introducing concepts of sentiment analysis, pairing models, and assigning weights to the options using R and Python.
• Respond to ad hoc requests for special reports, presentations and administrative tasks including scheduling and project management.