Led daily support for Fraud Analytics Data Mart operations, migrated cluster jobs to Docker containers, and managed cluster job scheduling using AWS EMR, S3, Lambda, and Snowflake.Maintained the Cequence fraud detection tool, monitoring Spark agents across servers, and developed ETL/ELT pipelines in GCP using Dataflow, Dataproc, BigQuery, and Cloud SQL.Migrated data between AWS, GCP, and SQL databases using Databricks and implemented solutions using Hive, Sqoop, and Spark SQL.• Utilized industry-standard tools and methodologies to develop executive dashboards and scorecards using Power BI and MS SQL Server Reporting Services (SSRS).• Performed Business Intelligence development, data analysis, ETL processes, reporting, and data visualization using MSSRS and Power BI.• Implemented Power BI gateway for various data sources to meet specific analysis criteria and enhance data modeling capabilities.• Developed analytical dashboards in Power BI showcasing key performance indicators (KPIs) with interactive slicers and filters for end-user customization.• Designed data structures comprising multiple facts and dimension tables to support the creation of new reports using SSRS.• Managed daily data loads (full & incremental) into staging and ODS areas, troubleshooting process issues and errors using SSIS 2008/BIDS.• Integrated datasets from multiple sources, including Google BigQuery, for developing advanced data analytics reports using Power BI improving data availability by 35%.• Developed stored procedures with dynamic scripts for data manipulation tasks like Bulk Insert, Insert, and Update to manage data transfer from flat files to SQL server staging tables.• Developed automated ETL workflows using Apache Beam and Dataflow to load data into BigQuery, reducing manual processing by 50% and ensuring accurate, near-real-time reporting.

• Designing and developing OLAP cubes using SQL Server Analysis Services (SSAS), including extending dimensions and data source views.• Expertise in dimensional data modeling, including Star, Snowflake, and Fact Constellation schemas.• Analyzing, building, and testing OLAP cubes in SSAS, incorporating calculations with MDX.• Defining relationships between dimensions and measure groups to optimize cube design.• Employed BigQuery’s user-defined functions (UDFs) to streamline complex transformations, simplifying data pipelines and reducing processing time by 30%.• Optimized BigQuery queries with partitioning and clustering, reducing query costs by 20% and boosting execution speed by 35%.• Extracting data from OLTP to OLAP using SSIS and Teradata BTEQs.• Performing data migration from Teradata to SQL Server using TPT Scripts and BCP.• Optimized SQL queries with advanced indexing and query tuning techniques to improve reporting performance and ETL load times in SQL Server.• Creating and scheduling ESP Jobs to run SSIS Packages for Cube Incremental and Full Build.• Optimizing data models for visualization in Power BI, including creating calculated columns and tables with DAX formulas.• Enhancing ETL architecture for performance improvement and process automation.• Integrating Power BI with SSAS Multidimensional Models.• Developing SSIS packages with error handling and scheduling for automation.• Deploying and monitoring SSAS Cubes, managing full and incremental loads, and providing support.• Migrating Data Mart from Teradata to SQL Server for analysis purposes.• Designed and implemented dimensional models using Star and Snowflake schemas to support optimized query performance and reporting in SSAS.• Creating dynamic SSIS packages with containers, variables, and scheduling.• Utilizing SSAS Tabular models as backend data sources for Power BI solutions.• Experience in altering XMLA scripts during SSAS Cube deployment and synchronization.

• Developed custom Python scripts leveraging Pandas and NumPy for data cleaning, transformation, and analysis, enabling the extraction of key insights from raw data.• Engineered data pipelines using Azure Synapse to integrate, process, and analyze large volumes of structured and unstructured data, ensuring data availability and accuracy.• Implemented data visualizations in Tableau and Cognos, incorporating advanced calculations, parameters, and interactive elements to create dynamic and user-friendly dashboards.• Performed data wrangling and preprocessing using Python, including handling missing values, outlier detection, and normalization, tBio prepare datasets for machine learning models.• Utilized SQL to implement complex business logic through stored procedures, triggers, and views, ensuring efficient data manipulation and consistency across applications.• Conducted time series analysis and forecasting using Python libraries like statsmodels and Prophet, providing actionable insights for business planning and strategy.• Leveraged DAX (Data Analysis Expressions) in Power BI to create advanced metrics, measures, and KPIs, enabling detailed performance tracking and business intelligence reporting.• Implemented role-based access control (RBAC) and row-level security in Tableau and Power BI to ensure secure data access and compliance with data privacy regulations.• Automated data extraction and reporting processes using Python and APIs, reducing manual effort and increasing data processing efficiency by 40%.• Conducted geospatial analysis using SQL Server's geography and geometry data types, visualizing spatial data in Tableau for enhanced location-based insights.• Developed and managed complex ETL processes using Informatica PowerCenter, with capabilities to extend to IDMC for cloud data management.

• Conducted comprehensive data profiling and quality assessments using tools like Talend Data Quality and SQL, identifying and resolving data anomalies and inconsistencies.• Designed and maintained data marts and dimensional models, using star and snowflake schemas to optimize query performance and data retrieval.• Performed cohort analysis using SQL to segment customers based on their behaviors and attributes, facilitating targeted marketing strategies and personalized customer experiences.• Built data visualizations in R using ggplot2 and Plotly, incorporating interactive features like hover effects and clickable legends for enhanced user engagement.• Developed real-time data monitoring and alerting systems using Power BI and SQL Server, ensuring timely identification and resolution of data issues.• Integrated external APIs with BI tools to enrich datasets with additional data sources, enhancing the depth and breadth of business analysis.• Automated the generation of monthly and quarterly business performance reports using SQL scripts and Power BI, streamlining the reporting process and reducing manual effort.• Integrated cloud-based data sources with on-premises systems using hybrid data connectivity solutions, enabling seamless data access and analysis. • Involved in Data Extraction from Oracle, Flat files and XML files using Talend.• Designed and constructed data warehouses, data marts, and business intelligence solutions utilizing multi-dimensional models such as star schema and snowflake schema.• Utilized SSIS to craft comprehensive ETL packages, validating, extracting, transforming, and loading data from diverse sources like Text Files, XML Files, Excel, and Access.• Designed, implemented, and managed database schema, including entity relationship diagrams, data modeling, tables, stored procedures, functions, triggers, constraints, indexes, and views.

• Developed customizations using PLSQL procedures, functions and packages.• Implemented business rules using database triggers.• Loaded data to and from flat files and excel sheets using import/export options in SQL Developer.• Involved in Data migration process from MySQL to Oracle database.• Performed data export/import tasks to move data between different DBs using Data Pump utility.• Performed bulk loading activities using SQL*Loader utility.• Created UNIX shell scripts to automate SQL scripts execution.• Developed business reports using Crystal Reports.• Worked on File Transfer Protocol (FTP) tool to transfer files from one server to another.• Prepared the technical documentation on changes made.