- Expert in applying
- Agile methodologies for seamless project execution, fostering adaptability in dynamic data
- Designed and upheld MySQL
- Processed metrics for A/B testing, creating dashboards in Tableau to monitor test processes, analyzing test results
- Created comprehensive dashboards in Tableau to track Key Performance Indicators (KPIs) and product performance
- Integrated data from a wide range of sources, including Microsoft Excel spreadsheets, AWS S3 for scalable storage, AWS
- RDS (Relational Database Service), AWS Redshift for data warehousing, and data in JSON and XML
- Developed Python scripts to automate data validation and cleaning processes, such as deduplication and data consistency
- Leveraged Pandas and Apache Airflow, you have streamlined these processes, improving efficiency and data quality
- Collected data from internal sources using SQL and performed data cleaning and aggregation for reporting and further
- Experienced in data analysis techniques using Python libraries like NumPy, Pandas, SciPy, and visualization libraries of Python like Seaborn, and Matplotlib
- Imported data from multiple data sources into Excel workbook, created relationships between heterogeneous data
- Power Pivot skill
U
Uber KS
Data Analyst Intern
January 2023 - May 2023
T
Trigent
Data Analyst
IN
December 2019 - November 2021
Skills
A/B TestingActive DirectoryAdaptabilityAgile MethodologyAirflowAmazon Elastic Compute CloudAmazon RedshiftAmazon S3Amazon Web ServicesAnalytical ThinkingApache HTTP ServerAttention to DetailAutomationBusiness Process ImprovementCausal InferenceCloud ComputingCommunication SkillsConfidence IntervalsCritical ThinkingCryptographyCustomer Data ManagementDashboardsData AnalysisDatabasesData CleansingData CollectionData DeduplicationData Import/ExportData IntegrityData MiningData ModelingData ProcessingData QualityData Storage TechnologiesData ValidationData VisualizationData WarehousingDecision Making SkillsDelivery of ProjectsDemonstration SkillsDevOpsDynamic DataElearningExtensible Markup Language (XML)Extract Transform Load (ETL)Functional DesignGap AnalysisInformation TechnologyJSONKey Performance IndicatorsKnowledge of StatisticsLookup TableMatplotlibMetricsMicrosoft AzureMicrosoft ExcelMongoDBMySQLNoSQLNumPyPandasPivot ChartsPivot TablesPower BIPredictive ModellingPresentationsProblem SolvingProject Management Life CyclePython (Programming Language)Regression AnalysisRelational DatabasesRequirements AnalysisR (Programming Language)SalesSciPyScrum MethodologySQL DatabasesSQL Stored ProceduresStakeholder ManagementStatistical Hypothesis TestingSystems Development Life CycleTableau (Software)Unstructured DataUser ExperienceVba Programming LanguageVirtual MachinesVisualizationWeb Applications