Tejaswinee Thakare
Associate System Analyst
Summary
Data Analyst with 3.5+ years of experience utilizing SQL, Power BI, SSRS, SSIS, and ETL to drive data insights and support decision-making. Proven expertise in creating visually compelling dashboards and reports using Power BI to enhance data visualization for effective communication. Proficient in advanced SQL techniques and skilled in designing efficient ETL processes with SSIS for streamlined data integration and transformation. Capable of generating comprehensive reports with SSRS for task automation, data manipulation, and custom data analysis models.
Overview
3
3
years of professional experience
5
5
years of post-secondary education
1
1
Certification
Work History
MS Associate Systems Analyst
Altera Digital Health
03.2022 - Current
- Designed and developed interactive Power BI dashboards and reports, providing stakeholders with real-time insights and enhancing data-driven decision-making
- Implemented advanced DAX queries in Power BI desktop, providing detailed insights and enabling performance
- Developed new Power Bi dashboards and Modifying existing Power Bi Dashboards as per requirement
- Implemented row-level security (RLS) in Power BI to restrict data access based on user roles, ensuring data confidentiality and compliance with organizational policies
- Created dynamic reports with advanced features like drill-through, tooltips, and slicers to enhance data exploration and user interaction
- Built efficient and scalable data models using Power BI's data modeling features, including relationships, calculated columns, and measures to transform raw data into actionable insights
- Used Power Query Editor for ETL (Extract, Transform, Load) processes to clean, transform, and shape data from diverse sources such as SQL, Excel, and APIs
- Applied advanced DAX (Data Analysis Expressions) functions to create complex measures, calculated columns, and custom KPIs, enabling deeper analysis of business data
- Developed optimized DAX queries to improve report performance and ensure high-quality analytics
- Published and shared Power BI reports and dashboards via Power BI Service, ensuring real-time data access and collaboration among teams
- Automated data refresh schedules in Power BI Service to maintain up-to-date reports and dashboards, ensuring real-time insights
- Imported data from SQL Server DB, Excel to Power Bi to generate reports
- Optimized Power BI report performance by applying techniques such as query folding, reducing data volume, and creating aggregate tables to improve loading times
- Configured security roles and managed permissions using Power BI Service and Power BI Desktop
- Imported data from SQL Server DB, Excel to Power Bi to generate reports
- Develop, modify and optimize stored procedures, functions and SQL scripts as per requirement
- Created and managed ETL processes using SSIS to integrate and transform data from multiple sources, improving data accuracy and accessibility
- Utilized SQL Server Integration Services (SSIS) to develop, deploy, and manage ETL packages for data integration and transformation tasks
- Implemented data cleansing techniques using SSIS transformations (e.g., Data Conversion, Lookup, Aggregate, Conditional Split) to ensure data quality and consistency
- Developed and deployed SSRS reports, delivering comprehensive data analysis and meeting varied reporting requirements
- Performed data cleaning, validation, and preprocessing to ensure accuracy, completeness, and consistency of datasets before analysis
- Providing technical expertise in data storage structures, data mining, and data cleansing
Database Developer
SpidoSoft Technologies
08.2021 - 03.2022
- Designed and implemented relational database schemas, tables, indexes, and relationships to optimize data storage, retrieval, and query performance
- Developed and maintained robust database systems, ensuring high performance, availability, and security
- Designed and optimized SQL queries and stored procedures to enhance data retrieval and processing efficiency
- Develop, modify and optimize stored procedures, functions and SQL scripts as per requirement
- Implemented ETL processes to extract, transform, and load data into data warehouses, supporting accurate and timely reporting
- Creating SSIS packages using Control Flow tasks (e.g., Execute SQL Task, Data Flow Task, File System Task) and Data Flow components (e.g., Source, Destination, Transformation)
- Automated the scheduling of SSIS packages using SQL Server Agent and monitored ETL job execution, ensuring data loads are timely and accurate
- Implemented logging, error handling, and notification mechanisms to ensure smooth and error-free execution of SSIS packages
- Created and managed database schemas, tables, and indexes to optimize data storage and retrieval
- Developed and modifying stored procedures by creating various clustered and non-clustered indexes
- Designing, developing, and maintaining reports using SSRS based on business requirements and specifications
- Developed and optimized Stored Procedures, User Defined Functions (UDFs), Views, including dynamic queries, subseries, complex joins, and Triggers to support various business operations and reporting requirements
- Designed and implemented interactive Power BI dashboards and reports, providing actionable insights and facilitating data-driven decision-making across various business units
- Integrated diverse data sources into Power BI, including SQL databases, Excel spreadsheets enabling comprehensive analysis and visualization
Education
Bachelor - Electronics and Telecommunication
Amravati University
01.2014 - 01.2019
Skills
Microsoft Power BI
Certification
Microsoft Certification, PL-300: Microsoft Power BI Data Analyst (4730B3-6E66XA)
Timeline
MS Associate Systems Analyst
Altera Digital Health
03.2022 - Current
Database Developer
SpidoSoft Technologies
08.2021 - 03.2022
Bachelor - Electronics and Telecommunication
Amravati University
01.2014 - 01.2019
Similar Profiles
Doyle GatesDoyle Gates
Senior Quality Engineer/QA Lead at Altera Digital Health/Northwell HealthSenior Quality Engineer/QA Lead at Altera Digital Health/Northwell Health
Marty CullenMarty Cullen
Associate Service Desk Analyst at Altera Digital HealthAssociate Service Desk Analyst at Altera Digital Health
George KiserGeorge Kiser
Systems Engineer at Altera Digital Health, IncSystems Engineer at Altera Digital Health, Inc