M Vanama Email & Phone Number

Ottawa, Ontario, Canada

>Collaborating with team members by sharing and publishing Power BI reports for easy access.>Incorporating advanced analytics features in Power BI, such as forecasting and clustering, into data analysis.>Utilizing Azure DevOps to gather feedback and insights, enabling continuous improvement in development processes.>Collaborating effectively with cross-functional teams using Azure DevOps, fostering seamless communication and coordination.>Maintaining and optimizing Azure Synapse databases for performance, scalability, and cost efficiency.>Designing and implementing data warehousing solutions on Azure Synapse, using best practices for data modeling and database design.>Integrating data from various sources and performing ETL (Extract, Transform, Load) processes using Power BI>Creating and scheduling pipelines in Azure Data Factory to orchestrate data movement and transformation activities across various data sources and destinations.>Creating and managing access control policies for Azure Data Lake, ensuring data security and compliance with industry standards.>Designing and implementing data models and schema definitions for Azure Databricks tables and databases>Developing, testing, and deploying ETL/ELT pipelines using Databricks Delta and Spark APIs>Skilled in creating and managing custom data connectors in Power BI.>Demonstrated experience in designing and developing OLAP and OLTP databases with a focus on performance and scalability.>Proficient in creating Star and Snowflake Schema models and identifying facts, measures, and dimensions.>Implementing data security measures within SSIS packages.>Configuring and managing Azure Data Lake Storage and ensuring optimal performance.>Implementing change management processes for SSIS package deployment.>Creating and maintaining documentation for SSIS development processes and solutions.>Documenting SSAS database designs, schemas, and data models for easy understanding and future maintenance.

Hyderabad, Telangana, India

>Applying security measures in Power BI to ensure data privacy and control access to Power BI reports and dashboards.>Implementing and managing Azure security solutions.>Planning and executing Azure resource migrations.>Setting up data refresh schedules in Power BI to keep Power BI reports up to date with the latest data.>Customizing the Power BI interface to match specific branding or user requirements.>Designing and implementing data encryption and data masking strategies to protect sensitive data at rest and in transit within Power BI and MSBI solutions.>Collaborating with data scientists to integrate natural language processing (NLP) and sentiment analysis capabilities within Power BI and MSBI solutions.>Designed and implemented efficient data validation processes to ensure data consistency and integrity.>Conducted thorough data analysis and identified discrepancies and data quality issues to maintain data accuracy.>Developed reliable error/exception handling and rollback functionality for ETL/ELT workflows.>Participating in data integration and ETL project planning and estimation.>Identifying and resolving performance bottlenecks in SSIS packages.>Creating and managing workflows using Azure Logic Apps.>Developing and maintaining data quality profiling and data validation frameworks to ensure data accuracy and consistency within Power BI and MSBI solutions.>Creating and managing data governance policies and guidelines to ensure data compliance and data privacy within Power BI and MSBI solutions.>Implementing data deduplication and data consolidation techniques to reduce data redundancy and improve data efficiency within Power BI and MSBI solutions.>Implementing data lineage and metadata management practices within SSIS solutions.

Hyderabad, Telangana, India

>Embedding Power BI reports and dashboards into other applications or websites for wider accessibility.>Monitoring and analyzing Power BI report usage and performance to optimize user experience.>Creating and managing data alerts in Power BI to notify users of important data changes or anomalies.>Created visualizations and dashboards using tools such as Power BI for data analysis and reporting.>Worked on developing Tabular models for dashboards and generating Power View Reports.>Configured SQL mail agent to send automatic emails when an SSIS package failed or succeeded.>Integrating SSIS packages with external systems and services through APIs and web services.>Monitoring and troubleshooting SSIS package execution and performance issues.>Developing and implementing data archiving and purging strategies using SSIS.>Write efficient SQL queries that extract data from databases quickly and accurately.>Understanding the query execution plan, using appropriate indexes, and avoiding common pitfalls such as Cartesian joins.>Responsible for developing and maintaining ETL (Extract, Transform, Load) processes that move data between different systems with a good understanding of data integration tools and techniques.>Create and maintain accurate documentation of the database schema, table relationships, and other key information to enable stakeholders understand the structure and contents of the database.

Bachelor Of Technology - Btech

Postgraduate Diploma, Marketing Research Analytics, A