Sai Rakesh Email & Phone Number

Brossard, Quebec, Canada

Expertly configuring and overseeing package parameters and expressions to imbue SSIS packages with unparalleled flexibility and adaptability during execution. Participating in data migration initiatives, transferring data from legacy systems to new databases while ensuring data accuracy and completeness. Collaborating closely with database administrators to optimize database performance and scalability using SSIS, thereby improving the overall system efficiency. Crafting and implementing backup and restoration solutions for cryptographic keys in Azure Key Vault to ensure data resilience and continuity. Establishing and scheduling automated SSIS ETL processes to facilitate timely and precise data updates, streamlining workflows. Designing and implementing efficient Power BI data models for data analysis. Collaborating with cross-functional teams to connect databases with external systems and applications through APIs or data connectors. Implementing strategies for data partitioning and indexing to enhance data retrieval performance within the data warehouse (DWH). Developing and executing SQL scripts for database migration testing, ensuring data integrity and consistency during migration. Conducting comprehensive database performance testing and analysis to identify and address performance bottlenecks in the role of a DBA.

Mumbai, Maharashtra, India

Designing and creating visually engaging reports and dashboards using Power BI's intuitive and powerful features. This included selecting appropriate visualizations, implementing interactive filters, and creating dynamic data-driven visuals. Implementing Azure Key Vault to securely manage cryptographic keys, certificates, and secrets, safeguarding sensitive information and meeting compliance requirements. Ingeniously configuring and overseeing package deployment and execution within the SSIS catalog, efficiently deploying packages and deftly managing their execution. Developing custom SSIS components and tasks using languages like C# or VB.NET to enhance and tailor SSIS capabilities as per specific project requirements. Developing and maintaining OLAP (Online Analytical Processing) cubes for multidimensional analysis. This involves designing cube structures, defining dimensions and measures, and processing cubes to enable fast analytical queries. Developed and maintained data enrichment and data transformation routines for advanced data analytics Creating and managing SSIS package configurations using environment variables, allowing for dynamic and flexible package configurations based on specific environments. Collaborated with business stakeholders to design and implement SQL queries for data analysis and reporting. Collaborated with data scientists as a DBA to design and optimize database structures for data analysis and prediction.

Hyderabad, Telangana, India

Implemented data virtualization techniques for real-time data access and analysis. Actively engaged in database design and architecture reviews, collaborating closely with data architects and stakeholders to craft optimal data models. Developed and maintained SQL scripts for anonymizing and masking sensitive data, ensuring data protection. Conducted data profiling and data cleansing to identify and rectify data quality issues within the data warehouse (DWH). Configured and managed Azure Service Bus for reliable messaging and event-driven communication. Designed and executed SSIS ETL (Extract, Transform, Load) processes to seamlessly transfer and transform data from diverse sources to target systems. Skillfully configured and managed data flow sources, transformations, and destinations in SSIS, precisely pinpointing data sources, orchestrating transformations, and defining target destinations. Leveraged data visualization and formatting techniques in SSRS to elevate information presentation, enriching reports with engaging visual elements. Collaborated with data analysts and business users to design and implement SQL queries for ad-hoc data analysis and reporting.