Manoj Sahoo Email & Phone Number

Hyderabad, Telangana, India

Bengaluru, Karnataka, India

•Orchestrated end-to-end Extract, Transform, and Load (ETL) processes, seamlessly integrating source systems withAzure Data Storage services using Azure Data Factory, T-SQL, Spark SQL, and Azure Synapse Analytics.•Managed data ingestion across Azure Services such as Azure Data Lake Storage Gen 2 and Azure SQL DataWarehouse, leveraging Azure Databricks and PySpark for efficient processing and analysis..•Designed and implemented robust ELT/ETL Pipelines within Azure Data Factory, incorporating Linked Services,Datasets, and Pipelines to extract, transform, and load data from diverse sources including Azure SQL Data Warehouseand Azure Blob storage .•Addressed unique business requirements by developing custom User-Defined Functions (UDFs) in Azure Databricksand PySpark, ensuring optimized data processing and analytics..•Engineered Delta Tables, External/Internal, and Managed Tables in Spark & Databricks, optimizing data storage andretrieval mechanisms for enhanced performance and scalability.

Bengaluru Area, India

Bengaluru Area, India

•Develop and maintain SSIS packages for data extraction, transformation, and loading operations, ensuring dataaccuracy and completeness..•Design and implement SSRS reports and dashboards to visualize key performance indicators (KPIs) and support datadrivendecision-making processes..•Create and manage SSAS cubes and data mining models to facilitate multidimensional analysis and forecasting.•Optimize SSIS packages, SSRS reports, and SSAS cubes for performance, scalability, and reliability.•Provide technical support and troubleshooting assistance for BI solutions, resolving issues and optimizing processes asneeded.•Conduct data quality assessments and implement data cleansing and enrichment techniques using SSIStransformations.•Design and implement security measures to ensure data privacy and compliance with regulatory requirements in BIsolutions.

Gurgaon, India

•Implement SSIS package logging, event handling, and error handling mechanisms for monitoring and alertingpurposes.•Perform ETL testing and validation to ensure data accuracy, consistency, and integrity across BI solutions.•Design and implement data warehouse schemas, including star schemas and snowflake schemas, to support reportingand analysis requirements.•Writing down various Stored Procedures, Views , Triggers ,Functions to encapsulate different business requirement.•Developing and optimizing OLAP cubes in SSAS for multidimensional analysis, including designing aggregations,partitions, and calculated members to support complex analytical queries and reporting needs.•Stay updated with the latest SQL Server features, best practices, and industry trends to continuously improve databasedevelopment processes•Collaborate with cross-functional teams to design and implement data warehousing solutions, including dimensionalmodeling and ETL processes.

Bhubaneswar, Odisha, India

•Writing down various stored procedures and views to handle all the business requirements•Designing and implementing ETL processes using SSIS to ensure seamless data integration from diverse platforms suchas Oracle, SQL Server, and CSV files into a centralized data warehouse.•Designing and implementing interactive and insightful SSRS reports to provide stakeholders with actionable businessintelligence, leveraging advanced features like drill-downs, interactive parameters, and custom expressions.•Performing data profiling, cleansing, and transformation using advanced SSIS components like Lookups, ConditionalSplits, Derived Columns, and Fuzzy Lookups to maintain data quality and accuracy.•Collaborate with DBAs to implement database maintenance plans, monitor database health, and ensure highavailability and disaster recovery solutions for mission-critical databases.•Document database designs, data dictionaries, technical specifications, and change management processes forknowledge sharing and compliance purposes