| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidateCandidate's Name
Data Analyst / Research AnalystEMAIL AVAILABLEPHONE NUMBER AVAILABLEPROFESSIONAL SUMMARYA Data Analyst, Research Analyst, and a recent Business Analytics graduate dedicated to solving problems and driving positive change globally. Expertise in statistical methods and tools like SQL, Python, and R for data extraction, preparation, analysis, manipulation, and visualization tools such as PowerBI and Tableau. Proficient in data warehousing, and modeling techniques including ETL processes, and star and snowflake schema designs.Skilled in stakeholder management, automation, and ensuring data privacy compliance. Seeking an internship to contribute analytical expertise and learn within a dynamic environment.Experience in business intelligence and BI technologies tools such as OLAP, Data Warehouse, reporting and Querying Tools, Data Mining, and Spreadsheets.Experience in designing and implementing applied research projects, particularly in workforce development, and health sectors.Strong understanding of data governance, compliance, and ethical use of data.Hands-on experience in creating and developing PowerBI, and Tableau Dashboards into the rich lookPerformed Data manipulation, Data Cleaning, and Data Transformation for loading and extraction with Python libraries such as NumPy, SciPy, and Pandas for data analysis and numerical computations.Experience in managing large data sets (both private and public), developing reports, and troubleshooting data issues from single or multiple systems.Exposure to SQL databases like MYSQL ServerInvolved in creating database objects like tables, views, procedures, triggers, and functions using SQL to provide definition, and structure and to maintain data efficiently.Proficient in MS Office, Advanced Excel ( pivot table, VLOOKUP), SQL, R, Python, PowerBI, and Tableau.Experience in various phases of the Software Development life cycleEffective communication and collaboration skills to understand stakeholder needs and deliver impactful insights.Knowledge of various phases of the Software Development life cycle (Agile and Waterfall)Extensive hands-on experience and high proficiency with structures, semi-structured and unstructured data.Experience with Data Analytics, Data Wrangling, Data Exploration, Data Visualization, and Data Modelling.Experience in data visualization using Python, R Programming, Tableau, and SQLUtilizes Tableau, Power BI, and other visualization tools to create compelling and interactive dashboards for data presentation.Completed JIRA Project Certification, demonstrating expertise in project tracking, task management, collaboration, and agile methodologies using JIRA software.PROJECTSTECHTIP24 DATA INSIGHTS - PowerBIUtilized SQL for Data Extraction and Preparation.Designed an interactive dashboard in PowerBI integrating various visual elements such as charts, tables, and slicers.Employed DAX (Data Analysis Expressions) to create calculated columns and measures for key performance indicators (KPIs).Identified and Analyzed sales performance across different dimensions.Conducted thorough Testing and Validation of the dashboard to ensure all data sources were correctly integrated.AIRBNB PRICING DATA INSIGHTS - Tableau PublicDeveloped a Comprehensive Dashboard using Tableau that visualizes Airbnb key metrics across different regions of New York City.Designed informative charts, and maps, enhancing data storytelling through compelling visual narratives.Conducted thorough Statistical analysis of historical pricing trends, including the impact of economic events.TECHNICAL SKILLSProgramming languageSQL, Python, RDatabases & Programming LanguagesMySQL, SQL Server, PostgreSQL, MySQL WorkbenchResearch & AnalyticsData visualization, Data Integration, Data Quality, Quantitative and qualitative research.Business Intelligence ToolsTableau, Power BI, RapidMiner, Crystal Reports, Business Objects, Visual Studio, Minitab, Lucid Charts, Microsoft Excel.Big Data TechnologiesData Warehouse (Snowflake), Data MiningToolsMySQL Workbench, SQL Developer, SSMS, MS Office, SharePoint, Eclipse, Jupyter NotebookStatistical AnalysisA/B Testing, Regression Analysis, Hypothesis Testing, Statistical ModelingProject Management ToolsJIRA, Confluence, Microsoft Teams, SlackFinancial DatabasesThomson One, Perfect Information, US-SEC Filings, Moodys, Merger Market, Dealogic, and S&P Ratings.ERP ApplicationsSAP Business By Design, SAP Eclipse, Tally ERP 9.Other SkillsData Analysis, Data Mining, Business Intelligence, Predictive Analytics, CRM, Data Warehousing, Data ModellingSOFT SKILLSTeamwork & Collaboration, Problem-Solving, Communication, Time Management, Adaptability, Stakeholder Management, Detail-Oriented.WORK EXPERIENCEClient - Technolab Software Inc, New JerseyRole - Data Analyst Trainee July 2023- PresentResponsibilities:Involved in reviewing business requirements and analyzing data sources from Excel/ SQL Server for design, development, and testing of the product.Created Ad-hoc reports by gathering specific requirements from the different users.Monitoring & tuning SQL scripts by performance monitoring.Created and supported upgrade scripts for the production database.Analyzed poorly performing SQL queries to improve application performance.Created calculated financial measures Average Purchase Value KPI measures the average value of each purchase order in your sales team processes.Writing and optimizing SQL queries to extract detailed sales, payments, and summary reports from various databases.Collaborating with team members to refine complex SQL logic for accurate data representation, ensuring queries met business needs.Developing data aggregation queries for Net Sales, Gross Sales, Tips, and refunds across payment types, sales categories, and revenue centers.Conducting JOIN operations to integrate multiple datasets, such as payment details with order and item details, ensuring data consistency.Created visualizations using ggplot2, plotly, and lattice to represent complex datasets.Using CASE statements to dynamically group data based on client-defined criteria, improving the adaptability of SQL code.Assisting with troubleshooting query issues by refining SQL scripts for better performance and accuracy.Implementing COALESCE functions to handle NULL values and improve the reliability of results.Communicating query outputs and refinements effectively with team members to validate and adjust reporting requirements.Creating summary cards for dashboards to visualize key metrics like total sales, discounts, and tips collected.Ensuring proper date range filtering and query logic to provide relevant data for specific periods, such as weekly or monthly reports.Hands-on experience using R for data cleaning, manipulation, and performing advanced statistical analyses like regression modeling, hypothesis testing, and time series analysis.Collaborated with stakeholders to deploy the dashboard within the organization, ensuring it met user requirements and expectations.Client UBS Investment Bank, Verity Knowledge Solutions, Hyderabad, India.Role - Equity Data Research Analyst Nov 2020 Dec 2022Responsibilities:Conducted comprehensive data analysis on broker notes, M&A deals, and critical marketing materials to support over 1500 UBS clients globally.Develop business architecture using requirements such as scope, processes, alternatives, and risks.Created Tableau scorecards, and dashboards using stack bars, bar graphs, scattered plots, geographical maps, and charts using show me functionality during POC.Generated weekly data-driven reports and insights across transportation, healthcare, and financial sectors, providing stakeholders with actionable information.Developed and maintained complex financial models and Public Information Books (PIBs) by analyzing large datasets, ensuring accuracy and alignment with industry standards.Planned, tracked, and managed data, Big Query table contains individual records organized in rows. Each record is composed of columns (also called fields).Developed and reviewed SQL queries with the use of joins clauses (inner, left, right) in Tableau Desktop to validate static and dynamic data for data validation.Expertise in transforming business requirements into analytical models, designing algorithms, building models, developing data mining, and reporting solutions that scale across massive volumes of structured and unstructured data.Integrated SharePoint with Microsoft Teams to streamline data-sharing processes, increasing communication efficiency and document management by 30%.Optimized access to market data sources through data analysis and vendor negotiations, reducing data sourcing costs by 15%.Utilized advanced analytical techniques such as DCF, SOTP valuation, and WACC analysis, ensuring 95% accuracy in data interpretation and reporting.Enhanced data transparency by designing dynamic dashboards in Excel and Tableau, increasing visibility into KPIs and leading to a 25% improvement in decision-making efficiency.Collaborated with IT, QA, and compliance teams to ensure data handling adhered to regulatory standards, resulting in a 15% reduction in compliance issues.Client - Jai Durga Tubes, Hyderabad, India.Role Finance & Operations Manager Aug 2016 Nov 2020Responsibilities:Demonstrate a thorough understanding of professional accounting and bookkeeping practices and support the team in providing exceptional client service.Monitor team member performance by reviewing the quality of work, adherence to protocols, timeliness of deliverables, and adherence to client budgetsStreamlined integration between the finance and operations departments by introducing a unified ERP system (Tally ERP9)Formulated an operational strategy to reduce lead times by implementing just-in-time inventory systems, cutting warehouse holding costs by 15% while maintaining sufficient stock levels.Improved cash flow by optimizing accounts receivable collections, reducing the average collection period from 45 to 30 days, and ensuring liquidity for day-to-day operations.Ensured 100% compliance with tax regulations by introducing a digital GST filing system, reducing audit discrepancies and minimizing penalties.Developed a Tableau dashboard to track key performance metrics (KPIs) such as sales growth, customer acquisition costs, and operational efficiency, improving overall business performance by 18%.Acted as a key liaison between departments and external vendors, organizing monthly strategy meetings to ensure all stakeholders were aligned, which improved project completion rates by 25%.CERTIFICATIONSMicrosoft Certified: Power BI Data Analyst AssociateMicrosoft Learning: Perform Analytics PowerBIGoogle Certified: Google Analytics, Fundamentals of Digital MarketingLinkedIn Certified: Jira CoreData Camp: Certification in Data Analytics using Artificial IntelligenceOthers: Corporate valuation, DCF, and relative valuation, Snowflake(Data Migration).EDUCATIONMaster of Science in Business Analytics. Jan 2023 May 2024The University of Scranton - Scranton, PA GPA: 3.96/4.00Coursework: Data Mining, CRM, Data Visualization, Business Model Forecasting,Business Analytics using Python, Big Data, DBMS, PowerBI, and Business IntelligenceMaster in Business Administration Aug 2018 Oct 2020Osmania University - Hyderabad, India CGPA: 8.70 /10.00Coursework: Marketing, Supply Chain, Accounting, HR, Financial Risk,Investment, and Operations Management. |
