3 years of experience working as a Data Scientist, proficiency includes Data modeling, Data cleansing, Data Validation, Data mapping identification & documentation, Data Extraction and Load Process from multiple Data sou…
3 years of experience working as a Data Scientist, proficiency includes Data modeling, Data cleansing, Data Validation, Data mapping identification & documentation, Data Extraction and Load Process from multiple Data sources, Data verification, Data Analysis, Transformation, Integration, Data import and Data export. Passion for learning and implementing new technologies and techniques.
As a data scientist, responsibilities include analyzing large datasets to uncover trends and patterns, building predictive models using statistical techniques and machine learning algorithms, and interpreting findings to inform business decisions. Additionally, data scientists are tasked with designing experiments, cleaning and preprocessing data, and effectively communicating insights to stakeholders through visualizations and reports.
Created and maintained database objects like complex stored procedures, triggers, indexes, functions, views, tables, and SQL Joins.
Implemented design setup and supported HADR environments by using clustering, mirroring & AG Technologies.
Created complex T-SQL Queries, Stored Procedures, Functions, Indexes, CTE's, Views, Joins and Triggers.
Responsible for user access and identity management in Power BI online.
Participated in the design and development of the Data Warehouse.
Created the workflows for Daily, Weekly and Monthly SSIS package and scheduled the jobs as per the requirements.
Extensively worked on Feature Engineering with Python and data governance to maintain data quality.
Created and implemented database design and architecture for Sales Analysis and deployed in AWS RDS.
Collected requirements for different executive dashboards, analysis and model flows from various sources to integrate into Tableau Dashboard.
Analyzed, designed and built modern data solutions using Azure PaaS service to support visualization of data.
Extracted, transformed and loaded data from source systems to Azure Data Storage services using Azure Data Factory, T-SQL, Spark SQL and U-SQL Azure Data Lake Analytics.
Performed data ingestion to Azure Data Lake, Azure Storage, Azure SQL and Azure DW and processed the data in Azure Databricks.
Created and used complex stored procedure in SSRS to generate reports for identifying the Daily Error Logs on the servers.
Worked with Angular and Java to embed reports and connect APIs with Power BI.
Designed KPIs, Filters, Reports, Scorecard and Dashboards reports using Power BI.
Worked on Agile methodology with ticket system using JIRA and Confluence.
Used JIRA as defect tracking system and configured various workflows, customizations and plug-ins.
Integrated, combined, and transformed different data sources from Excel, databases and data lakes for daily report analysis.
Worked on Hudson, Jenkins, and Bamboo for continuous integration and end-to-end processes.
Managed and maintained application databases using T-SQL scripts and created various kinds of SSRS reports like Drill Down, Drill through, Sub Reports and Dashboards.
Generated Power BI Dashboard for the Daily CPU Usage and the Log usage of the Server.
Extracted data from the Transactional System and loaded it into Data warehouse with SQL Server Management Studio and BCP.
Improvised Sales Analysis by leveraging Automation, Centralization and developing Automated Sales Analysis System using Python and Power BI.
Worked on ETL tasks that includes bulk loading of data from transactional tables to master tables of ODS.
Created SSRS dashboards using charts, gauges, indicators and data bars.
Deployed SSRS reports in native and SharePoint mode.
Experienced in working on DevOps/Agile operations process and tools area including code review, unit test automation, build and release automation, environment and services.
Built CI/CD pipelines for various applications including Java, NodeJS and .NET.
Created mappings for various sources like MS-SQL Server, MS-Access, Excel, Oracle, and ERP packages to load and integrate the instrument level details to warehouse.
Optimized and tuned mappings for better efficiency.
Written PL/SQL subprograms such as procedures and functions for value calculations.
Used IN to pass by reference, OUT and INOUT to pass by value to the procedures.
Worked on various sources to pull data into Power BI such as SQL Server, SAP BW, Oracle and SQL Azure.
Generated dashboards in Power BI Desktop and Power BI Service using slice and dice and modern data visualization features.
Designed and developed new ETL/SSIS package that load data from OLTP into existing Data Warehouse based on technical specifications and business requirements.
Designed dimensional data model of the OLAP database using Erwin.
Created SSIS packages for extracting data from SQL, MySQL, JSON, Flat files and Excel and load those data into destination tables in SQL Server.
Worked on version control systems like Subversion and Git and used source code management client tools like GIT bash, Github and other command-line applications.
Worked with Infrastructure automation and tools including GIT, JIRA, Azure DevOps, Terraform, Artifactory, Azure SQL, MySQL and Cosmos DB.
Designed and developed continuous deployment pipeline, integrating Jenkins across geographically separated hosting zones in AWS.
Designed and created ETL packages with different transformations for loading data from heterogeneous sources into target data.
Assisted Lead in improving business reports using SAP and Power BI using automated ETL procedures.
Responsible for creating and modifying T-SQL stored procedures and triggers for validating the integrity of the data.
Presented design, implementation and maintenance for custom reports and quarterly reports as bar charts for management using data filtering, interactivity and deploying reports to report server using SSRS.
Created SSRS Data Model projects using Microsoft Visual Studio 2008 and Report Builder for report server to create reports.
Implemented a GIT mirror for SVN repository, which enables users to use both GIT and SVN.
Used Azure IaaS virtual machines and Cloud services into secure VNets and subnets, designed VNets and subscriptions to conform to Azure Network Limits.
The AI-first Recruitment Operating System that unifies and automates the entire hiring lifecycle for modern enterprises worldwide.
Dr Job FZ LLC. 2026 © All Rights Reserved
