- Spearheaded the enhancement of the ETL pipeline, resulting in a 35% reduction in data processing time through effective
- Utilized Python libraries such as Pandas and NumPy for statistical analysis of healthcare data, supporting evidence-based
- Conducted comprehensive analysis of electronic health records utilizing SQL queries to uncover patterns and correlations
- Developed and deployed interactive Tableau dashboards tailored for visualizing healthcare metrics, enabling real-time
- Implemented SQL scripts to extract and cleanse data, ensuring compliance with HIPAA regulations and maintaining an 18
- Devised a dynamic sheet selector to accommodate various chart types, such as Panel charts, Bullet charts, and Stack bars, within a single dashboard using parameters
- Collaborated with OLAP tools including ETL, Data Warehousing, and Modeling, leveraging Informatica and SSIS for seamless extraction, transformation, and loading of data from SQL Server to Oracle databases
- Designed and executed A/B tests to evaluate the effectiveness of new healthcare interventions, resulting in a statistically
- Collaborated closely with healthcare professionals to define key performance indicators (KPIs) and implemented tracking
- Extracted data from diverse heterogeneous databases, including Oracle, Access database, DB2, and flat files, and loaded it
H
HCL Technology
Data Analyst
Hyderabad, IN-TG, IN
June 2019 - December 2021
H
HCL Technology
Data Analyst Intern
Hyderabad, IN-TG, IN
April 2018 - May 2019
Skills
A/B TestingAgile MethodologyAlgorithmsAlteryxAmazon Elastic Compute CloudAmazon S3Amazon Web ServicesAnalysis of Variance (ANOVA)Analytical ThinkingApple IOSAssociation Rule LearningAutomationBitbucketBullet (Software)Business Process ImprovementBusiness RequirementsCloud ComputingCluster AnalysisCodebaseCommunication SkillsConfidence IntervalsDashboardsData AnalysisDatabasesData CleansingData CollectionData InfrastructureData IntegrityData MiningData ProcessingData QualityData ScienceData TransformationData VisualizationData WarehousingDecision Making SkillsDecision TreesDelivery of ProjectsElectronic Medical RecordsExtract Transform Load (ETL)Forecasting SkillsGitGithubGoogle AnalyticsHealth CareHealth Insurance Portability and Accountability Act ComplianceIBM DB2Information TechnologyIntelliJ IDEAJIRAJupyter NotebookKey Performance IndicatorsKnowledge of EngineeringKnowledge of StatisticsLinear AlgebraLinuxLogistic RegressionLookup TableMachine LearningMarketingMarket ResearchMarket SegmentationMatplotlibMedical RecordsMetricsMicrosoft AzureMicrosoft ExcelMicrosoft SQL ServerMicrosoft Visual StudioMicrosoft WindowsModelling SkillsMongoDBMySQLNumPyOnline Analytical ProcessingOperational SystemsOracle ApplicationsOracle DatabasesPandasPerformance ManagementPerformance TuningPivot TablesPlotlyPostgreSQLPower BIProgramming LanguagesPython (Programming Language)Regression AnalysisResearch MethodologiesSalesSAP ApplicationsSAS (Software)Scikit LearnSciPySecurities ResearchSoftware Version ControlSQL DatabasesSQL Server Integration ServicesSQL Server Reporting ServicesStakeholder ManagementStatistical Hypothesis TestingStorytellingStrategic ManagementStrategic ThinkingStreamlineSubversionSuccess Driven PersonSystems Development Life CycleTableau (Software)Team WorkingTechnical SkillsTensorflowTime SeriesWorkflows