Abhinav Kumar
Waterloo,ON
Summary
- Proficient in creating and deploying solutions using Azure Logic Apps and Functions to streamline workflows.
- Skilled in building and managing CI/CD pipelines with Azure DevOps for efficient application deployment.
- Experienced in building and delivering customized reports with SSRS and Power BI.
- Knowledgeable in implementing advanced security features including role-based, row-level, and dynamic security.
- Proven experience in conducting seamless data migrations and integration tasks.
- Expertise in utilizing SQL scripts for ETL processes, enhancing database performance, and optimizing SQL queries.
- Proficient in using SSIS, SSRS, and SSAS for building ETL pipelines, reports, and analytical models.
- Familiar with Agile frameworks and proficient in project management using Azure DevOps.
- Comprehensive knowledge of data modeling, warehousing, and visualizations with advanced proficiency in Power BI.
- Skilled at crafting cloud-based BI architectures on Azure for secure and scalable solutions.
- Strong team collaboration skills to develop complete end-to-end BI solutions aligned with organizational objectives.
- Hands-on experience with implementing and managing AI and machine learning models using Azure services.
Overview
8
8
years of professional experience
1
1
Certification
Work History
Senior Azure Data Engineer
Choices Markets
05.2024 - Current
- Familiar with utilizing Azure Security Centre and Identity & Access Management to ensure cloud infrastructure security.
- Hands-on experience throughout the project lifecycle, including analysis, requirement gathering, development, testing, and documentation.
- Expertise in creating robust data pipelines capable of handling diverse data sources and increasing complexity in enterprise environments.
- Skilled in designing scalable Azure Data Pipelines, leveraging triggers to automate data refresh based on user-defined requirements.
- Proficient in moving and copying data between sources such as BLOB Storage, SQL Server, and Azure Data Lake using Azure Data Factory.
- Experienced in crafting detailed technical specification designs and application interface documentation to align solutions with business needs.
- Enabled data reuse and governance through tools like Azure Data Catalogue, metadata management, and Azure Search.
- Implementing Power BI's integration with Microsoft Azure Logic Apps for data integration and data flow.
- Integrating Power BI with Azure Data Factory to orchestrate data movement and transformation activities across various data sources and destinations.
- Utilizing Power BI's machine learning capabilities to perform predictive analysis and data forecasting for business insights.
- Developing and maintaining Power BI report usage metrics and auditing for performance evaluation.
- Skilled in processing and managing diverse file formats like XML, CSV, Excel, ORC, and Parquet for structured and unstructured data integration.
- Proficient in managing Azure cloud services such as Azure Data Factory, Data Lake, and Azure Functions for comprehensive data handling.
- Expertise in designing and maintaining data storage systems, including SQL Server, Azure SQL, Azure Data Warehouse, and Data Lake Store.
- Skilled in developing SSIS packages and working with various transformations to enhance ETL workflows.
- Hands-on experience extracting and transforming data from Azure BLOB Storage and ADLS using Databricks to enable efficient data workflows.
- Proficient in creating analytical solutions using Azure Stream Analytics, Azure Analysis Services, and SSAS for business intelligence.
- Proficient in configuring error handling mechanisms, logging frameworks, and email notifications within Azure Data Factory Pipelines.
- Experienced in designing data streaming, transformation, and integration processes using technologies such as Azure Data Factory, SSIS, and HDF.
- Utilized Azure Data Factory Pipelines for efficient data extraction and loading, handling both historical and incremental data.
- Proficient in building batch processing and streaming data solutions to enable real-time and scheduled data integration.
BI and Cloud Engineer
KINAXIS
02.2022 - 05.2024
- Migrated SSIS packages from on-premises to Azure, integrating them with Azure Data Factory (ADF V2) and Azure-SSIS Integration Runtime.
- Skilled in designing logical and physical databases, normalization techniques, and data modeling using tools like ERWIN and SQL Server Enterprise Manager.
- Designed interactive, visually appealing, and user-friendly dashboards and reports by identifying and tracking key metrics and KPIs.
- Oversaw end-to-end development of business intelligence projects, ensuring successful execution and delivery.
- Maintained comprehensive database documentation, including data dictionaries, ER diagrams, and schema diagrams.
- Skillfully implementing and managing data integration with data modelling and warehousing tools, creating a harmonious composition of efficient data organization and storage within Azure Data Factory.
- Develop and maintain data models using DAX and other data modeling tools in Power BI.
- Pioneering machine learning solutions using Azure Synapse, leveraging its capabilities to unlock valuable predictive and prescriptive insights.
- Utilizing Power BI's custom visuals and custom themes to enhance report aesthetics and branding.
- Developing and maintaining Power BI dashboards for real-time monitoring of key business metrics and performance indicators.
- Developing and implementing row-level security in Power BI to restrict data access based on user roles and permissions.
- Implementing advanced analytics features in Power BI, such as forecasting, clustering, and outlier detection, to provide deeper insights into data.
- Crafting comprehensive data lineage documentation to facilitate compliance audits within Azure Purview.
- Creating and managing tables, views, and partitions on Azure Databricks for efficient data querying and analysis.
- Designing and implementing database normalization and denormalization techniques, organizing data in a way that minimizes redundancy and improves efficiency.
- Skilled in optimizing the performance of SSIS packages for improved efficiency.
- Developed and maintained BI data backup and recovery procedures to safeguard data integrity.
- Effectively troubleshooting and resolving issues related to Azure Data Lake and associated services, ensuring uninterrupted data access.
- Implementing Azure Load Balancer to distribute incoming traffic across multiple resources for improved application performance.
- Secured databases by implementing robust access controls and managing data privacy and integrity.
- Collaborated with stakeholders, analysts, and developers to prioritize and address database-related tasks effectively.
- Extensive experience in ETL development using tools like SSIS, Azure Data Factory, and other cloud-based ETL platforms.
- Proficient in fine-tuning SSIS packages for optimal performance and resource utilization.
- Developed ETL workflows to extract, transform, and load data from various sources into target systems.
- Implemented database backup strategies and disaster recovery plans to safeguard organizational data.
- Participated in database performance tuning initiatives to optimize query execution and system performance.
- Defined project scopes, created detailed project plans, and managed timelines and budgets to ensure successful delivery.
- Developing and maintaining SSAS data mining projects for advanced analytics, managing and enhancing data mining projects to extract valuable insights from data.
- Innovatively integrating interactive elements into SSRS reports, such as hyperlinks and drill-through actions, enhancing user engagement and empowering them to explore data deeper.
- Imposing strict package security and access controls in SSIS, safeguarding sensitive data with encryption and access restrictions.
- Seamlessly deploying SSIS packages across multiple environments using automated deployment scripts, ensuring a smooth and hassle-free deployment process.
- Facilitating dynamic report delivery based on specific data conditions or criteria by designing and implementing report subscriptions with data-driven delivery in SSRS.
- Delivered high-quality project outputs within the agreed-upon timeframes, meeting stakeholder expectations.
- Partnered with business stakeholders and team members to drive successful project outcomes and optimize workflows.
- Stayed current with emerging trends and advancements in BI development and database technologies through continuous learning.
- Designed and implemented data models to support effective analytics and decision-making processes.
- Maintained high data quality and ensured the accuracy of reports and dashboards through proactive monitoring.
- Worked with database administrators and data engineers to cleanse, transform, and load data into data warehouses.
- Addressed data quality issues and monitored quality metrics to maintain reliable datasets for analysis.
- Created and optimized logical and physical data models, designed data warehouses, and developed ETL processes for seamless data integration.
- Partnered with business stakeholders to gather requirements and refine data models to support reporting and analytics needs.
- Built analytical reports, dashboards, and scorecards using business intelligence tools like Power BI.
- Proficient in leveraging Microsoft Power BI features, such as Power Pivot, Power Map, and dashboards, for data visualization.
- Supported application developers by assisting with SQL query optimization and writing efficient procedures.
- Improved database performance by modifying its structure to better align with organizational requirements.
Data and BI Developer
State Bank of India, SBI
03.2019 - 01.2022
- Designed interactive dashboards and reports in Power BI and SSRS to support organizational decision-making.
- Enhanced data quality through validation checks and comprehensive monitoring processes.
- Collaborated with cross-functional teams to develop scalable data warehouses and document ETL pipelines.
- Created and fine-tuned T-SQL scripts, functions, and triggers to streamline database operations.
- Designed and implemented robust ETL processes using SSIS to enable seamless data integration into data warehouses.
- Developing and maintaining Power BI reports with custom measures and calculations for unique business requirements.
- Demonstrating expertise in data deduplication and data cleansing techniques within Azure Data Factory, improving data accuracy and reliability
- Implementing and managing integration with Azure Active Directory for secure user authentication and access control in Azure Data Bricks.
- Configuring Azure Synapse managed private endpoints for secure access to data stores.
- Proactively staying abreast of the latest SSRS features and enhancements, seamlessly integrating them into report development processes for maximum impact.
- Skillfully crafting ad-hoc and on-demand SSRS reports that precisely cater to user requests, providing timely and valuable insights to support critical decision-making.
- Thoughtfully crafting and executing package execution strategies and scheduling in SSIS, intelligently determining the how and when of package execution.
- Optimizing SSIS packages for enhanced performance, employing parallelism and source/destination-specific optimizations.
- Designing and developing SSAS cubes, including multidimensional models, hierarchies, and measures to facilitate comprehensive data analysis and reporting.
- Exercising meticulous control over user permissions and access privileges within Azure Purview to maintain data confidentiality.
- Conducted BI system capacity planning to ensure scalability and performance.
- Designing and developing Power BI reports with custom aggregations and summarizations to meet business requirements.
- Configuring and managing data lake integration with ETL and data integration tools, ensuring smooth data flow and transformation within Azure Data Lake.
- Implementing Azure Storage solutions for reliable and scalable data storage, including Blob storage, File storage, and Azure Disk Storage.
- Implemented data synchronization and replication systems for data consistency and availability.
- Worked extensively on data visualization tools like Tableau and SSRS to generate dynamic, user-focused reports.
- Automated ETL workflows using scheduling tools such as SQL Server Agent and Autosys to ensure timely execution.
- Strengthened data privacy by applying advanced security protocols and adhering to compliance standards.
- Leveraged MS SQL Server expertise to troubleshoot and optimize ETL and database configurations.
- Participated in the development of BI standards and guidelines to maintain consistency in analytics projects.
- Built relational database models and conducted performance tuning to support analytical needs.
- Developing and maintaining Power BI reports with custom tooltips and data labels for enhanced data insights.
- Created technical documentation and delivered training sessions to end-users for effective BI system adoption.
- Improved BI solutions by optimizing queries and enhancing the scalability of data models.
- Performed unit testing on ETL pipelines to ensure seamless integration and consistent performance.
- Managed and maintained large datasets, ensuring accuracy through data profiling and cleansing activities.
- Authored advanced T-SQL statements for the efficient handling of large data volumes.
- Collaborated with analysts to translate business requirements into technical solutions for data integration.
- Monitored the performance of BI systems and addressed any identified bottlenecks or issues.
- Designed ETL workflows to ensure accurate and timely data movement across systems.
- Applied expertise in SSRS, SSIS, and SQL to deliver high-performance BI solutions for complex datasets.
Junior BI Developer
Reliance Nippon Life Insurance Company
02.2017 - 03.2019
- Implemented database partitioning and indexing strategies to optimize data organization and retrieval.
- Collaborating with data security teams to implement data access controls and encryption.
- Controlling the storage and retention of report snapshots for performance and archival purposes by configuring and managing report snapshots with caching and expiration in SSRS.
- Developing and maintaining data governance policies and procedures for Power BI and MSBI solutions.
- Collaborating with business stakeholders to understand database requirements and provide data solutions to support their needs.
- Artfully designing and implementing data flow tasks within SSIS packages, formulating a logical and systematic approach to data transformation and manipulation.
- Assisting in SSIS data migration projects, ensuring that data is accurately transferred between systems and legacy data is seamlessly integrated. Orchestrating data migration efforts, minimizing data loss and ensuring data consistency.
- Designing and developing data-driven decision support systems using OLAP cubes, empowering business users with valuable insights.
- Adeptly managing package events and notifications in SSIS, leveraging event handlers to promptly respond to distinct events and execute corresponding actions.
- Developed and maintained SQL scripts for database data migration and transformation between different database platforms, ensuring seamless data migration.
- Strengthening data source security in SSRS by creating and managing report data sources with data source credentials, securely storing and managing access credentials.
Education
Bachelor of Technology -
JAWAHARLAL NEHRU TECHNOLOGICAL UNIVERSITY
HYDERABAD, INDIASkills
- Azure Analysis Services
- ETL development
- Cloud computing
- Report design
- Data warehousing
- DevOps principles
- Business intelligence tools
- Data modeling
- Data pipeline design
- SSAS
- Predictive analytics
- SQL expertise
- Real-time analytics
- Parquet
- BI strategy development
- Data migration
Career Objective
Experienced Azure & BI Engineer with 8 years of expertise in designing, developing, and optimizing business intelligence solutions and cloud-based data platforms. Skilled in leveraging Microsoft Azure technologies to build scalable data pipelines, data warehouses, and analytics solutions that enhance data-driven decision-making. Proficient in Azure Data Factory, Power BI, SSIS, SSRS, and SQL Server, with expertise in ETL development, data modelling, cloud migration, and database optimization. Experienced in managing end-to-end BI projects, implementing data governance policies, and ensuring cloud security through Azure Security Center and Identity & Access Management while delivering high-performance, enterprise-grade BI solutions.
Certification
Associate Certified Analytics Professional (ACAP)
Key Skills
Database & BI Development Skills
- Proficient in building business intelligence solutions, including data warehousing, ETL processes, data visualization, and reporting, leveraging MSBI tools and Power BI.
- Expertise in designing and developing databases, with strong skills in data modeling, schema design, and SQL scripting.
- Skilled in managing database and BI development projects from planning through execution, monitoring, and reporting.
Cloud & Azure Expertise
- Knowledgeable in Azure services, including Azure SQL Database, Azure Data Factory, Azure Analysis Services, Azure HDInsight, and Azure Stream Analytics.
- Familiar with cloud architecture and best practices for developing scalable and secure cloud-based database and BI solutions.
Data Analytics & Problem Solving
- Experienced in data analytics techniques, including statistical analysis, predictive modeling, and machine learning.
- Strong problem-solving abilities, capable of analyzing complex issues and developing innovative solutions for clients and organizations.
Communication & Collaboration
- Excellent written and verbal communication skills, facilitating effective collaboration with team members, stakeholders, and clients.
Continuous Learning & Development
- Committed to continuous learning, staying up-to-date with emerging technologies and industry trends in database and BI development, particularly within the Azure environment.
Timeline
Senior Azure Data Engineer
Choices Markets
05.2024 - Current
BI and Cloud Engineer
KINAXIS
02.2022 - 05.2024
Data and BI Developer
State Bank of India, SBI
03.2019 - 01.2022
Junior BI Developer
Reliance Nippon Life Insurance Company
02.2017 - 03.2019
Bachelor of Technology -
JAWAHARLAL NEHRU TECHNOLOGICAL UNIVERSITY
Similar Profiles
Balwinder KaurBalwinder Kaur
Cashier at Choices MarketsCashier at Choices Markets
Ryoko DottoRyoko Dotto
Head of Bakery at Choices MarketsHead of Bakery at Choices Markets
Mustafa TariqMustafa Tariq
Administrative Assistant/Production Worker at Choices MarketsAdministrative Assistant/Production Worker at Choices Markets