BI Analyst and Azure Developer Internationally Applicable Resume

A BI Analyst and Azure Developer resume should emphasize proficiency in data analytics, cloud computing solutions, and software development on the Azure platform. Highlight skills in translating complex data into actionable insights and developing scalable cloud applications. Tailored for professionals aiming to excel in global data-driven environments.

Get a Resume just like this

Text Content of Resume

ABHISHEK BOTIKAR

Contact: +1-xxxx xxxxx | Email: mail@gmail.com

PROFILE SUMMARY

  • Dedicated BI Analyst with over 5 years of experience specializing in cutting-edge BI, data, and cloud technologies, driving transformative insights for informed decision-making.
  • Proficient in designing and implementing BI solutions leveraging Azure platform, SQL Server, and Power BI, resulting in scalable data models and efficient ETL processes.
  • Certified Azure Data Engineering Associate with a track record of employing advanced analytics techniques, including Bayesian optimization and data masking, to optimize model parameters and protect sensitive data.
  • Skilled in collaborating with stakeholders to elicit data integration requirements and comprehend business needs, ensuring harmonious data compositions within Azure Data Factory and other cloud-based platforms.
  • Experienced in implementing robust data governance frameworks, including data privacy measures and compliance with regulatory requirements, ensuring data security and integrity across various environments.
  • Adept at conducting comprehensive testing and performance optimization of BI solutions, ensuring accuracy, reliability, and scalability in dynamic environments.
  • Proficient in utilizing a wide range of BI tools and technologies including SSRS, SSIS, SSAS, Power BI, AWS, Databricks, Azure Synapse, and Google BigQuery, among others.

TECHNICAL SKILLS

  • Operating Systems: Windows, Linux, Ubuntu
  • Methodologies: SDLC – Waterfall, Agile/Scrum
  • Reporting & BI Tools: SSRS, SSIS, SSAS, Power BI
  • Database: SQL Server 2019, Azure SQL
  • Source Control: Git, Visual Studio
  • Cloud & Data Tools: AWS, Databricks, MS Azure, Azure Data Factory, Azure Data Lake, Azure Synapse
  • Programming Language: Python
  • Data Skills: Data Analysis, ETL Development

EXPERIENCE

Senior BI Analyst and Azure Developer | IATA, Montreal, QC | Oct 2022 – Present

Project Overview: Developed and implemented a BI solution on the Azure platform, leveraging database development skills to create a scalable data model and ETL processes for efficient data ingestion and transformation.

  • Engineered and optimized ETL scripts in Python with AWS Glue, ensuring high performance and scalability for large-scale data processing tasks. Executed data cleansing and normalization techniques to ensure consistency and accuracy of data.
  • Utilized data visualization libraries in Python such as Matplotlib or Seaborn for creating static and interactive visualizations during data analysis. Developed and maintained SSAS calculations and measures to support business analysis needs.
  • Employed Azure Purview’s data lineage documentation to support regulatory compliance audits and data lineage tracing.
  • Formulated advanced queries and calculations using the Data Analysis Expressions (DAX) language to derive insights and perform complex calculations in Power BI.
  • Implemented data encryption and data-at-rest security measures on Azure Data Lake to ensure the highest level of protection.
  • Facilitated dynamic report delivery in SSRS based on specific data conditions or criteria by designing and implementing report subscriptions with data-driven delivery.
  • Enabled data confidentiality and security through the design and implementation of SSRS report security and access controls, safeguarding sensitive information. Developed and maintained SQL scripts for database performance analysis and query tuning.
  • Utilized Git submodules to efficiently manage external dependencies, facilitating the integration of third-party code.
  • Designed and implemented ETL processes using Redshift Spectrum to seamlessly query and analyze data stored in Amazon S3, reducing data transfer costs and improving query performance.
  • Optimized query performance in Google BigQuery through partitioning, clustering, & indexing strategies, improving query speed and cost efficiency. Enabled auditing and monitoring in Azure Synapse to track and analyze security events and potential threats.

Data Engineer – Business Intelligence | TATA Consultancy Services, Mumbai, IN | Nov 2020 – Sep 2022

Project Overview: Led a data engineering project to design and implement an end-to-end BI solution, utilizing Azure services for data storage, processing, and visualization, resulting in improved decision-making processes.

  • Developed & maintained SSIS project configurations, parameterizing package execution for dynamic configuration adjustments.
  • Implemented SQL server database auditing and compliance features, generating audit reports and logs for regulatory and internal audits. Integrated Snowflake with BI tools like Tableau and Power BI for seamless data visualization and reporting.
  • Leveraged Redshift’s COPY command for efficient data loading into Redshift tables from various sources, ensuring data integrity.
  • Streamlined data asset onboarding/offboarding using Azure Purview and Azure Data Factory’s seamless integration with Azure Logic Apps. Enforced stringent package security and access controls in SSIS, ensuring data encryption and access restrictions.
  • Designed and built OLAP cubes for multidimensional analysis capabilities, integrating NLP and sentiment analysis within Power BI and MSBI solutions. Configured data lake integration with Azure Application Insights for application performance monitoring.
  • Implemented data masking policies and collaborated with security teams for advanced threat protection in Azure Blob Storage.
  • Led the implementation of data governance metadata repositories & designed data partitioning strategies for improved query performance. Applied survival analysis techniques for data analysis tasks, enabling insights into temporal data trends.

Datawarehouse Engineer | Future Generali Life Insurance, Pune, IN | Mar 2019 – Nov 2020

Project Overview: Collaborated with cross-functional teams to develop and deploy ETL pipelines using Azure Data Factory, ensuring timely and accurate data delivery for reporting and analytics purposes.

  • Implemented and managed event handling and notifications in Power BI to respond to specific events during execution and notify stakeholders.
  • Configured and oversaw package connections to various data sources and destinations in SSIS, establishing vital links for data extraction and loading.
  • Implemented SSRS report caching and snapshot functionality, enhancing report rendering speed and overall performance.
  • Designed and maintained a comprehensive repository of SSIS package units and integration tests, ensuring package functionality and dependability. Developed and integrated Azure Stream Analytics for real-time data streaming and complex event processing.
  • Designed and optimized database schemas and tables to support efficient ETL processing and data warehousing.

EDUCATION

  • Bachelor of Information Technology | SRM Institute of Science and Technology, Chennai, India

CERTIFICATIONS

  • Certified Azure Data Engineering Associate