Merging new database with current database from different source. Identifying PII data and masking it. Analyzing data and providing business solution to various issue in database. Creating Reconciliation jobs using Intellimatch Tool. Data Modeling using MS SQL. Creating JIL Files to create task server jobs and use Autosys to execute them.

Data related to Property Tax from mainframe dumped into SQL tables. All transaction of customer related to property tax is calculated. Creating reports using SSRS, SP, functions, views, LLD Doc, Data Modeling using MS SQL. Creating web based application using C#, JavaScript, AJAX, HTML.

Fetching real time data from API and filtering out the relevant data from semi-structured data in JSON format. Sending the result using Python streaming services like Socket Streaming, Kafka Streaming & Text File Streaming and Displaying using FLASK in website.

Transforming the data to fetch max matches based on the input from the chase system(third party system) and Starbuck system using Spark SQL, Alteryx, PySpark on databricks platform.

Customer data related to everyday purchase of FMCG products. Preparing FSD after receiving requirement from client. Tracking, analyzing and provide support for post-production. Data Modeling the SQL databases design. Debugging the application in VBA code and providing fixes for defect.

Customer data related to trade done purchase & sell of the automobiles and its parts is analyzed. Providing support for the post-production issue. Debugging the Dot Net code application and providing fix for the defect.

Data related to real estate prices and trends of prices over period of time is stored into Oracle tables. Analyzing requirement and creating doc like RCD as per requirement. Developing Dot Net application & SP using Oracle PL/SQL.

Role : Data Analyst & Business Analysts Duration : Oct, 2020 – Present Technologies : TeraData, Excel, Hadoop, Hive, Datalake, Agile Responsibilities:  Analyse data in the upstream system from business point of view  Writing query to extract required details from upstream system  Purging the old data after analyzing the data

Technologies : Python, PySpark, Kafka Streaming, Hadoop, Big Data, Putty, Docker, Javascript Responsibilities:  Create data streams using Kafka  Consuming data streams in python for Flask dashboard  Consuming data streams in Tableau for dashboard and in .Net for custom real time dashboard  Storing Kafka data in Hive for historical data reporting  Data manipulation and calculations using pandas in Python and then emit data using kafka  Fetching data from API and displaying data in HTML table using Flask.

Technologies : Spark SQL, T-SQL, PySpark, Alteryx Responsibilities:  SQL queries and Stored Procedures in Oracle PL/SQL or Databricks  PySpark using Databricks platform for coding  Using Alteryx to fetch data into tables from different sources  Filtering out relevant data from semi-structure data

Technologies : Microsoft SQL Server 2008, T-SQL, Excel Macros, VBA, SSIS Responsibilities:  Preparing FSD after receiving the requirements from the client  SQL queries and Stored Procedures in SQL Server 2008 for enhancement tasks  Debugging the application in VBA code and providing fixes for the defects

Technologies : Microsoft SQL Server 2008, T-SQL, Dot Net, Application Support & enhancement Responsibilities:  Tracking, analysing and provide support for post-production issue  SQL queries and Stored Procedures in SQL Server 2008 debugging for fixing various defects  Debugging the Dot Net Application and providing fixes for the defects

Technologies : Microsoft SQL Server 2008, SQL Jobs, SSIS, T-SQL, Application Support Responsibilities:  Customer engagement to gather requirements and prepare a high-level end-to-end solution  Queries and Stored Procedure in SQL Server 2008  Developing SSIS Packages in BIDS 2008  Developing SQL Jobs to execute SSIS packages

Technologies : Microsoft SQL Server 2008 R2, SunGard’s Intellimatch Tool, Customer Management Responsibilities:  Customer engagement to gather requirements and prepare solution after analyzing the business requirements  SQL Server 2008 queries and development using Perl  Creating Reconciliation jobs using Intellimatch Tool  Creating JIL Files to create task server jobs and use Autosys to execute them

Technologies : Dot Net, Oracle PL/SQL, AJAX, HTML, JavaScript, Preparing POC & RCD, Testing Responsibilities:  Creating Web based applications using Dot Net  Stored Procedure, Function, Views using Microsoft SQL Server  Unit Testing as per business requirement  Analyzing the requirement and creating document like RCD as per requirement  Conducting POCs for upcoming Business Requirements