Senior Data Analyst Resume

Candidate Pitch:

• Over 9 years of experience as a Senior Data Analyst and Business System Analyst, Expertise in data modeling, business requirements gathering, database design to support informed business decisions. • Specialized in Data Warehousing, ETL development, Quantitative Analysis, data governance Data Mining, Reporting, and BI application development. • Experienced with reviewing and writing BRD, FRD, Technical Specification document. • Knowledge of healthcare standards and guidelines such as HL7, HIPAA, Meaningful Use, and hands-on experience with their implementation. • Solid experience in using, HTML, Python, Tableau, MATLAB, Excel and AWS. • Excellent knowledge of UAT testing and working on defects using band Quality Center and Application Lifecycle Management ALM software. • Experience in Data Profiling using SQL Server and SAS tools and Root Cause Analysis (RCA) on the defects. • Extensive experience in Excel, Word, PowerPoint, MS Project, MS Visio, Rational Suite, and SQL. • Experience aggregating data and configuring reports from different sources using data blending. • Expertise in Agile Scrum Methodology to implement project life cycles of reports design and development. • Good hands-on experience testing inquiry screens to support EDI transactions. • Experience in using Tableau for data visualization by connecting it with Oracle and MySQL databases. • Experience in using Jupyter Notebook in Anaconda an open-source distribution for Python programming. • Established processes for data tracking, moni toring, and trend analysis to ensure data accuracy and integrity. • Addressed Business Questions by tracking Key Metrics surrounding marketing initiative and supplied recommendation to drive business strategy. • Conducted an exploratory data analysis (EDA) & Statical analysis to Identify trends & Patterns & anomalies in Data. • Executed SQL DML & DDL queries to ad hoc reports requests to draw insights and make data-driven recommendations. • Constructed engaging Tableau Stories, featuring interactive Tableau dashboards & Monitored Key Performance Indicators (KPIs) through data-driven evidence, delivering valuable insights to technical and non-technical stakeholders. • Proficient in resolving issues, problem-solving skills and technical research. • Extensive experience in designing databases using ER modeling and Normalization. • Excellent analytical, problem-solving, communication and time management skills. United Healthcare, New York ( Remote ) May 2022 - Continues Sr. Data Analyst / Business • Conducted Exploratory Data Analysis (EDA) using Python and visualized complex data patterns with Matplotlib and Seaborn, delivering actionable business insights. • Designed and implemented Tableau dashboards showcasing key performance indicators (KPIs), trends, and data-driven insights to enhance stakeholder decision-making processes. • Validated data accuracy and generated statistical reports using Excel tools, including VLOOKUP, Pivot Tables, and statistical tool packs, transforming raw datasets into meaningful narratives. • Developed efficient data cleansing and transformation workflows using Python, automating repetitive tasks to improve productivity and data quality. • Created reproducible and collaborative data analysis workflows with Jupyter Notebooks, combining detailed code, visualizations, and documentation. • Applied Statistical Inference methods to uncover trends, outliers, and predictive insights for strategic business planning. • Executed complex SQL queries to extract and transform data from relational databases such as MySQL and SQL Server, enabling detailed reporting and analysis. • Maintained robust data pipelines leveraging GCP ensuring seamless integration of cloud-based solutions for scalable analytics. • Ensured compliance with HL7 and HIPAA standards in handling sensitive healthcare data, maintaining data security and regulatory adherence. • Authored and updated comprehensive Business Requirements Documents (BRD) and Functional Requirements Documents (FRD) to align technical deliverables with business objectives. • Actively collaborated with Agile teams using Jira, facilitating sprint planning, task tracking, and iterative project development. • Led JAD sessions to elicit, analyze, and refine project requirements, ensuring clear alignment between stakeholders and development teams. • Performed descriptive statistics to summarize data distributions and supported organizational decision-making with comprehensive visualizations. • Developed advanced Excel dashboards featuring dynamic functionalities like Get Pivot, VLOOKUP, and conditional formatting for real-time data reporting and analysis. • Contributed to data integration and transformation projects involving NoSQL and SQL, handling diverse datasets effectively. • Employed Agile and Waterfall methodologies to manage end-to-end project lifecycles, ensuring high-quality deliverables within timelines. • Conducted workshops and training sessions for business users to interpret Tableau dashboards and leverage advanced Excel features effectively. • Delivered professional and visually engaging presentations using the MS Office Suite (Excel, Word, PowerPoint) to convey analytical insights and strategies to stakeholders. Key Achievements: • Automated data cleansing workflows using Python, reducing processing time by 40nd improving data accuracy by 25 • Designed interactive Tableau dashboards adopted by 100 stakeholders, significantly enhancing decision-making efficiency across multiple departments. • Improved the accuracy of statistical reporting by developing advanced Excel models, reducing manual errors by 20nd enabling real-time analytics. • Identified critical trends and anomalies in healthcare data using EDA and statistical inferences, driving a 15mprovement in operational efficiency. • Streamlined data compliance processes for HL7 and HIPAA standards, achieving a 100uccess rate in internal audits over two consecutive years. State of Texas – TX - Data Analyst/Business Feb 2019 - Apr 2022 Project: Root Cause Analysis for Corporate Business, Brokerage, Claim Management • Collaborated with process owners, SMEs, and marketing teams to understand complex business challenges and streamline claim and policy management. • Extracted and processed sales leads, brokerage, declarations, and claims data from ERP & CRM system ‘SAIBA,’ leveraging Python for advanced Exploratory Data Analysis (EDA) and descriptive statistics, providing actionable insights. • Designed and implemented a data warehouse framework using fact and dimension tables, enhancing data integration and retrieval efficiency. • Executed complex SQL queries across MySQL and NoSQL databases to evaluate data quality, identify trends, and resolve inconsistencies. • Utilized Tableau to create dynamic dashboards and visualizations (using LOD expressions, line charts, bar charts, and pie charts) to monitor KPIs, analyze brokerage collections, and assess claim management effectiveness. • Conducted root cause analysis on data discrepancies, fraudulent claims, and operational inefficiencies, utilizing statistical inferences to recommend system optimizations. • Leveraged GCP platforms for secure data storage and analytics, ensuring compliance with HIPAA and HL7 standards. • Streamlined workflows using MS Office Suite tools (Excel Functions, PivotTables, and VLOOKUP) to prepare detailed reports and analysis summaries. • Documented BRDs and FRDs while managing project lifecycles through Jira in both Agile and Waterfall environments, facilitating JAD sessions to gather and refine requirements. Key Achievements: • Enhanced report accuracy and reduced claims delays by 15y applying advanced statistical methods and improving data validation techniques. • Improved data-driven decision-making processes, boosting stakeholder satisfaction by 30hrough interactive Tableau dashboards and actionable insights. • Reduced data discrepancies by 25hrough effective data ingestion, cleansing strategies, and strategic updates to the ‘SAIBA’ reporting system. • Achieved a 75ncrease in vendor satisfaction by optimizing brokerage collection workflows and enhancing the transparency of business operations. Georgia department of human service- GA Data Analyst Feb 2016 - Mar 2019 • Used Python and Jupyter Notebook for data wrangling, cleaning, and manipulation to prepare datasets for analysis and reporting. • Conducted Exploratory Data Analysis (EDA) using Matplotlib and Seaborn to identify trends, patterns, and anomalies in business data. • Designed and maintained interactive dashboards in Tableau, providing visual insights into operational KPIs for stakeholders across the organization. • Utilized Excel (statistical tool packs, pivot tables, VLOOKUP, Sum IF) to analyze financial data and develop reports on performance metrics. • Created and automated SQL queries in MySQL and NoSQL databases to extract and transform data for business intelligence needs. • Worked with AWS, Azure, and GCP to implement scalable cloud solutions for secure data storage and processing. • Defined and tracked KPIs (e.g., loss ratio, expense ratio, customer retention rate) and provided actionable recommendations to improve business strategies. • Collaborated with cross-functional teams (Operations, Finance, Marketing, and Sales) to optimize account plans based on data insights. • Presented findings and recommendations to senior management, enabling data-driven strategies for growth and operational efficiency. • (PG Program) Data Science & Data Management Systems, University of Texas at Austin, Dec -2023. E-Portfolio - https://eportfolio.mygreatlearning.com/sushiladevi-l--Khatik • Master of E-business (Business Administration & Computer Science), Sardar Patel University (India), Mar-2007. • Data Science Tools: Python (Pandas, NumPy), Jupyter Notebook • Data Visualization: Tableau, Matplotlib, Seaborn, Excel , PowerBI. • Statistical Methods: Statistical Inferences, Descriptive Statistics, Exploratory Data Analysis (EDA) • Database Languages: SQL, • Cloud Services: GCP • Programming & Scripting: Python, Korn Shell Scripts, HTML • Data Governance & Healthcare Standards: HL7, HIPAA, Meaningful Use • Office & Documentation Tools: MS Office Suite (Excel, Word, PowerPoint, Project, Visio), Rational Rose, Get Pivot, VLOOKUP in Excel