About Me
Driven and collaborative data analyst with a proven track record of enhancing understanding through insightful reports and presentations. Eager to advance in the realm of data science, committed to ongoing learning, and …
Driven and collaborative data analyst with a proven track record of enhancing understanding through insightful reports and presentations. Eager to advance in the realm of data science, committed to ongoing learning, and dedicated to delivering impactful analytical solutions that contribute positively to diverse industries.
Experience
Data Analyst
Work with the programming team for optimal SQL server behavior using query tuning and lock checking.
Monitor jobs, perform scheduling, troubleshooting, backup, recovery, and system upgrading.
Design and build a Tableau dashboard to communicate business insights effectively.
Help the strategy team get the required data from the data warehouse and Snowflake by writing complex queries and creating optimized views.
Collaborate with cross-functional teams to streamline data validation processes, reducing manual errors by 20% and improving overall data.
Spearhead the design and implementation of updates and programming modifications for data pipelines, repositories, and models.
Execute and oversee ETL solutions with a focus on automating operational processes and maintaining high data quality standards.
Collaborate closely with a global team comprising Data Scientists, developers, and Product Managers.
Create JSON scripts for the deployment of pipelines in Azure Data Factory.
Estimate cluster size, monitor, and troubleshoot Spark Databricks clusters.
Demonstrate proficiency in error handling, debugging, and providing production support within SSIS.
Fine-tune Spark applications for optimal performance.
Design, establish, and manage Azure SQL Database, Azure Analysis Service, Azure Data Factory, and Azure SQL Data Warehouse.
Evaluate the effectiveness and accuracy of new data sources and collection methodologies.
Engage in Agile teams and contribute to Test-Driven Development practices.
Develop and deploy SSRS reports and dashboards.
Data Analyst
Work with the programming team, for optimal SQL server behavior using query tuning and lock checking.
• Experience in monitoring, job scheduling, troubleshooting, Backup, recovery, and system upgrading
• Design and build a Tableau dashboard to communicate business insights in an effective manner.
• Helped the strategy team get the required data from data warehouse
• (Snowflake) by writing complex queries and creating optimized views.
• Collaborated with cross-functional teams to streamline data validation processes, reducing manual errors by 20% and improving overall data
• Spearhead the design and implementation of contemporary updates and programming modifications for data pipelines, repositories, and models.
• Execute and oversee Extract, Transform, Load (ETL) solutions, with a focus on automating operational processes and upholding high data quality standards.
• Collaborate closely with a global team comprising Data Scientists, developers, and Product Managers.
• Create JSON scripts for the deployment of pipelines in Azure Data Factory.
• Assume responsibility for estimating cluster size, monitoring, and troubleshooting Spark Databricks clusters.
• Demonstrate proficiency in error handling, debugging, and providing production support within SQL Server Integration Services (SSIS).
• Apply hands-on expertise in fine-tuning Spark Applications for optimal performance.
• Design, establish, and manage Azure SQL Database, Azure Analysis Service, Azure Data Factory, and Azure SQL Data Warehouse.
• Evaluate the effectiveness and accuracy of new data sources and collection methodologies.
• Engage in Agile Teams and contribute to Test-Driven Development practices.
• Develop and deploy SQL Server Reporting Services (SSRS) reports and dashboards.• Work with the programming team, for optimal SQL server behavior using query tuning and lock checking. • Experience in monitoring, job scheduling, troubleshooting, Backup, recovery, and system upgrading • Design and build a Tableau dashboard to communicate business insights in an effective manner. • Helped the strategy team get the required data from data warehouse • (Snowflake) by writing complex queries and creating optimized views. • Collaborated with cross-functional teams to streamline data validation processes, reducing manual errors by 20% and improving overall data • Spearhead the design and implementation of contemporary updates and programming modifications for data pipelines, repositories, and models.
Data Analyst
Conduct ETL operations from source systems to Azure Data Storage services using Azure Data Factory, T-SQL, Spark SQL, and U-SQL.
Execute proof of concepts for SOAP and REST APIs.
Resolve database-related issues such as data loading and migration.
Apply data modeling and statistical analysis to note trends and draw conclusions.
Generate weekly and monthly dashboard reports, detailing findings and advising recommendations for strategic decision-making.
Create Excel documents to pull metrics data by data cleaning, mapping, data validating, and presenting information to stakeholders.
Design and execute ETL packages using SSIS to integrate data from diverse sources.
Work with the technical lead to design, develop, and maintain ETL data pipelines to automate data extraction, transformation, and loading processes.
Produce reports using Power BI and implement role-based security in SSAS.
Develop relational data models, tables, and views in databases and write complex SQL queries to fetch desired outputs.
Ingest data from data sources using SQL, Google Analytics API, and Salesforce API using Python to create data views for BI tools.
Work closely with quality assurance analyst and business analyst.
Maintain awareness of emerging technologies and industry best practices to foster innovation and efficiency in data engineering processes.
Contribute to data analyst projects while working closely with more experienced professionals, fostering growth and learning in the role of Junior Data Engineer within a mentorship-driven environment.
Craft database objects using T-SQL and create interactive reports and dashboards with Tableau.
Establish best practices for Tableau report development and administer Tableau Server.
Conduct execution and testing of queries and reports before publication.
Collaborate with designers to construct clean interfaces and intuitive user experiences.