Nakul Soni

• Created pipelines, and data flow in Azure data factory to connect data source to Azure storage container
• Created Azure synapse link to move data from power apps to Azure blob storage
• Create triggers in Azure data factory to run pipelines
• Set up alerts in ADF to ensure failure of pipeline
• Developed code in Pyspark for data transformation, data cleansing, and ETL process
• Perform source system data analysis to manage source-to-target data mapping.

• Implement Machine learning technique that will detect text from image document
• Apply Bounding box technique to draw box on features
• Apply RBG method in Python to check whether black-and-white document is original
• Extract features and match them with source feature
• Optimize current image falsification process and make current process more efficient in detecting false image
• Improve model accuracy and make it more efficient in detecting text information from image documents
• Automate process of document collection and storage
• Define and test approach to handle classification errors.

• Automated moving of Data from FTP and loading them into the database using SSIS and scheduled it as a daily job
• Created an SSIS package for loading the data and used multiple transformations in SSIS to extract data from various sources
• Move data from the old server to the new server using SSIS Packages in Business Intelligence Development Studio
• Build reports in Power BI to change the data format or add new reports in the existing dashboard of the Power BI desktop
• Connect Power BI to SQL server to fetch user insurance information and to check for which treatment users are insured
• Create Power BI reports to convert medical codes into explanations and then combine them with other data to generate user-specific reports for the hospitals
• Design, create, automate, and maintain sophisticated programs that extract, convert, and load data.
• Utilized data visualization tools to effectively communicate business insights.

Created SQL Server objects such as tables, views, stored procedures, functions, triggers along with other SQL developers

• Created and Modified tables, views, Indexes, User Defined Functions, Stored Procedures, cursors in SQL Server 2016
• Designed Logical and Physical models of Relational Database
• Created indexes and views, stored procedures to enhance database/application performance
• Created stored procedures to extract data and stored in the data warehouse
• Involved in Performance Optimization of Queries & Stored Procedures by exploring Query Plans, blocking queries, Identifying missing indexes etc
• Monitored query using query optimizer and tuned queries and procedures to boost database performance.

• Designed and developed (ETL) packages to extract, transform, and load data from CSV files or FTP systems to the data warehouse
• Build SSIS packages to match users’ information and then extract their primary and secondary information from the Database
• Match the user’s information with the Melissa data component in SSIS, to check the authentication of the users
• Create match rules in SSIS to match the user’s information with the database information
• Proposed solutions to improve efficiency and reduce expenses
• Applied transformation rules to change the data types of the fields
• Perform the ETL process to produce clean and transformed data for the stakeholders.