About Me
Nitesh is a Database expert with 10+ years of experience in providing solution to complex project and delivering projects across the globe Working experience on MS SQL, SSRS, Python, Pyspark, Alteryx, Teradata, Hadoop, Big Data, Data streaming usi...
Show MoreSkills
Web Development
Data & Analytics
Software Engineering
Programming Language
Database
Operating System
Others
Portfolio Projects
Company
Investment Banking
Description
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.
Show More Show LessCompany
Property Tax Management System
Description
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.
Show More Show LessSkills
SSRS C Sharp JavaScript AJAX HTMLCompany
Real Time Streaming
Description
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.
Show More Show LessSkills
Flask Apache-Kafka JSON PythonCompany
Retail Chain Management System
Description
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.
Show More Show LessCompany
Automobile Dealership Management
Description
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.
Show More Show LessSkills
.NET CoreCompany
Real Estate management system
Company
Morgan Stanley – Investment Banking
Description
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
Show More Show LessSkills
Teradata MS Office Hadoop Hive Agile MethodologyCompany
Kafka Streaming For CryptoCurrency
Description
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.
Show More Show LessCompany
StarBucks
Description
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
Show More Show LessCompany
TESCO
Description
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
Show More Show LessSkills
SQL Server 2008 R2 T-SQL VBA SQLCompany
STR (Automobile Dealership Management)
Description
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
Show More Show LessSkills
SQL Server 2008 R2 T-SQL SQLCompany
ICBC Standard Bank, U.K.
Description
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
Show More Show LessCompany
Barclays - Investment Banking
Description
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
Show More Show LessCompany
General Electric
Description
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
Show More Show Less