Chaithanya M. Email & Phone Number

Canada

Quebec, Canada

•Implemented Python's JSON and pickle modules for data serialization and deserialization.•Addressed Azure Data Lake issues for continuous data availability.•Developed ETL process documentation for traceability and data governance compliance.•Configured Azure Data Factory for efficient data orchestration through partitioning and parallel processing.•Coordinated cryptographic key rotation in Azure Synapse for consistent updates.•Managed key version retention policies in Azure Key Vault for historical auditing.•Developed and maintained SSRS for timely report distribution.•Configured package variables and expressions in SSIS for adaptable package behavior.•Integrated Azure Logic Apps Enterprise Integration Pack for advanced B2B and EDI integration.•Created SQL scripts for database data aggregation to support business intelligence.•Utilized Azure Cosmos DB's integrated diagnostics for performance analysis.•Collaborated with developers to integrate Azure Blob Storage into applications for data storage.•Established high data quality standards for accurate decision-making.•Implemented dynamic package configurations in SSIS for agile data mapping.•Utilized meticulous tagging in Azure Purview for organizing and managing data assets.•Implemented CI/CD pipelines using Git and Azure DevOps for continuous integration.•Created visually appealing reports and dashboards in Power BI with various visualizations.•Designed Power BI scorecards and dashboards to track Key Performance Indicators (KPIs).•Implemented data masking and anonymization techniques.•Wrote SQL queries, optimizing database performance for speed and efficiency.•Implemented and tuned machine learning models in Azure Databricks for valuable insights.•Managed drill-through actions and reporting in SSAS for detailed data navigation.•Utilized advanced SSRS capabilities to create diverse report types with rich visual representation.

Toronto, Ontario, Canada

•Implemented and optimized data lake integration with Azure Stream Analytics for real-time processing.•Developed efficient SQL queries, emphasizing execution plans, index usage, and avoiding common pitfalls.•Implemented SQL Server database partitioning for enhanced organization and management.•Established data lineage and impact analysis in the data warehouse (DWH) to trace data and assess changes.•Developed custom SSAS components and tasks, extending functionality using SSAS object model, .NET, or other languages.•Managed data refresh schedules for reports and dashboards.•Utilized SSRS subscription features for automated report delivery, ensuring timely insights dissemination.•Set up Git worktree with the --quiet option for streamlined removal.•Harnessed Azure Data Factory's integration with Azure Data Explorer for real-time data ingestion and analysis.•Designed and implemented data partitioning and optimization in Azure Databricks for enhanced performance.•Implemented synchronization for secure sharing of cryptographic keys in Azure Synapse.•Conducted data analysis and profiling as a DBA to identify patterns and anomalies.•Collaborated with BI teams, integrating SSIS packages seamlessly with reporting and analytics for data-driven insights.•Created Power BI visualizations, reports, and dashboards for effective communication and decision-making.•Developed and maintained Power BI reports with custom data export and printing options.•Integrated SSIS packages with external systems and services using APIs for seamless data exchange.•Configured and managed OLAP cube aggregations for optimized query performance.•Utilized Blob Storage versioning for maintaining previous data versions and enabling data rollback.•Designed and implemented report filters and data-driven filtering in SSRS for interactive exploration.

Delhi, India

• Collaborated with stakeholders to ensure data integrity and informed decision-making in financial operations.• Optimized processes using tools like SSIS, Qlik Sense, Crystal Reports, Snowflake, Microsoft Access, and VBA.• Shaped efficient data models and designs based on stakeholder input.• Utilized SSIS for precise data extraction, transformation, and loading.• Implemented validation, error handling, and data-mining techniques to enhance insights.• Established monitoring protocols in SSIS and utilized Power BI, Domo, Crystal Reports, Snowflake, MongoDB, and Microsoft Access for reporting and analysis.• Maintained thorough documentation, conducted unit testing, and performed data quality checks to ensure accuracy and consistency.• Demonstrated proficiency in ERD, Data Models, Stored Procedures, Views, Indexes, and Database Normalization to uphold data integrity.• Led ETL testing efforts to ensure accurate and complete data transformations, validating mappings, transformations, and business rules.• Confirmed process resilience through thorough testing of error-handling mechanisms.