.Net Developer Sql Server

Jyoti Prakash Sahoo

Mobile: +91-996*******, Email: ***********@*****.***

Professional Synopsis

•Total 17+ years of experience with Microservice Architecture, SOA Architecture & Development experience in C#.Net and Web Technologies.

•Strong experience in Client-Server Systems using Object Oriented Analysis and Design patterns.

•Extensive SDLC and Agile SCRUM experience including Requirement Analysis, Preparations of Technical Specifications Document, Design and Coding, Application Implementation, Unit testing and System Testing, Documentation, Production Support, Functional and Regression Testing.

•Proficient in programming with developing .NET applications using .Net Framework 4.5,.Net Core,WCF, ASP.NET, ASP.Net MVC4.0.React Js,Powershell, Devops,Angular JS

•Excellent understanding of relational databases involved in application development using RDBMS like MS SQL Server 2014, Oracle

•Good Knowledge in developing SQL server reporting services (SSRS) & Crystal Report.

•Experience in implementing Infragistics Controls enabled web pages.

•Expert in debugging an application using the debugging tools provided by the Visual Studio.Net 2019 and 2022 IDE.

•Excellent analytical, problem solving and interpersonal skills. Ability to learn new concepts fast.

•Consistent team player with excellent communication skills.

•Around 1 yr of client side experience at UK (from 2008 to 2009).

•Around 1.5 yrs experience at Malaysia

•Domain Experience in P&L, Reconciliation and Financial Derivative

Technical Skills

•Operating Systems: Windows 9x/NT/2K/XP

•Programming Languages: .NET, JavaScript, VBScript

•Databases: MS SQL Server 2000/2005/2008, Oracle, SSIS, SSRS, Aerospike

•Microsoft Technologies: C#, ASP.Net 4.5,React JS, Devops, Jenkins Pipeline, ADO.Net, WCF, WPF, LINQ,EntityFramework,AJAX,ASP.NET MVC, Multithreading, Task Parallel Library,React JS, JavaScript,.Net Core,Microservice

•Reports: Crystal Reports 8.5/9, Business Objects, SSRS

•Source Control: VSS, Subversion, Perforce

•Third Party Controls: Infragistics Controls

Career Summary

CREDIT SUISSE, Pune

.Net Full Stack Developer, Aug 2021 – Till Date

Job Profile

•Designed Applications services and databases thereby improving performance.

•Analyzing business requirements, coding, developing, and testing of various modules.

•Managing and guiding a team, handling different modules of software development.

•Interacting with the onsite team and responding to changing requirements.

•Follow up on the released work items in UAT as well as Production.

•Ensuring that the work is performed in accordance with the company policy, deadlines, and resources.

Select Project

Title: Global Locate Service\Global Availability Service

Client: UBS

Duration: DEC 2023 – DEC 2024

Team size: 10

O/S used: Windows 10

Tools used: C#.Net 2019, Oracle 11g, Git, Multithreading, TIBCO EMS, WPF,Java,Shell script,React JS, Jenkins Pipeline, Gitlab, Devops, Microsoft Azure, Angular JS

Details:

Global Locate Service used for getting locate requests from external sources and allocated based on the conditions.

Global Allocation Services is used for getting the availability of locates from different sources in the form of email, feed, ftp etc, which can be Allocated to clients as per request.

Role: .Net Full Stack Developer

Responsibilities:

•Worked with business analysts in identifying requirements, risks and developing Risk Management Plans.

•Development of UI Application, services and Database side

•Resolving production issues in L3 Support

•Involved in preparing release documents, release preparation, creating Change requests and also releasing the changes in to production

(Please refer other projects mentioned in the Annexure)

Previous Assignments

TeamsWare Solutions, Pune

Software Engineer,Apr 2020-August 2021

Nityo Infotech, Pune

Tech Lead, July 2017 – Mar 2020

Mphasis Limited, Pune

Delivery project Lead, May 2016 – January 2017

ISCISTECH Business Solutions SDN BHD, Kuala Lumpur Malaysia

Senior Software Engineer (Team Lead), July 2014 -December 2015

L&T Infotech, Pune

Project Lead, Aug 2007 – Sep 2013

CMC Limited, Mumbai

IT Engineer, Jul 2006 – Jul 2007

Affiliated Computer Services, Bangalore

System Development Associate, Apr 2005 – May 2006

Education

•M.C.A, Utkal University, Bhubaneswar, 2001

•B.Sc. (Physics), Sambalpur University, 1996

Personal Details

•Date of Birth: 29th Apr 1976

•Languages Known: English, Hindi, Oriya

•Passport No.: J9279308

Annexure

Project Details

Title

FID-PSP & FID-PSPEQ

Client

CREDIT SUISSE

Duration

JUNE 2021 –NOV 2023

Team Size

4

Tools used

: C#.Net 2019, Oracle 11g, Git, Multithreading, TIBCO EMS, .Net Core, WCF Service, WEBAPI,WPF,Jenkins Pipeline, Transporter Deployment, Liquibase, React JS,Devops, Jenkins Pipeline, Angular JS

Details

FID-PSP (Fixed Income Derivative-Primary and Secondary Platform) is used for trading of Fixed Income Securities, especially Bonds By Switzerland based Trading Desk.

Role

.Net Full Stack Developer

Responsibilities

•Worked with Business Analysts in identifying Requirements, Risks and developing Risk Management Plans.

•Designing & Developing the FIDPSP and FIDPSPEQ application.

•Created the Jenkins Plan for FIDPSP Automation Build

•Written The transporter Build to deploy it to different Environment

•Created Technical Specifications and Functional Requirements

•Using Git Repo to Manage the code

Title

Boothrops

Client

CREDIT SUISSE

Duration

Apr 2020 – JUNE 2021

Team Size

5

Tools used

: C#.Net 2019, Sybase, Git, Multithreading, Microservice, React JS,Antd, Loadash, Typescript, .Net Core 2.1,

Details

This is a Web application which is used by the Credit Suisse which is developed from the scratch to meet the client requirements. It also contains the Migration of Sidewinder Application and some other services.

Role

.Net Full Stack Developer

Responsibilities

•Designed and Developed the Microservice .

•Designing & Developing UI for Bothrops using the ReactJS

•Created Technical Specifications and Functional Requirements

•Written the Jenkins Build for the Application(React JS and Microservices)

•Managing and reviewing code for team members.

Versioning Strategy using Git.

Title

Prime Finance Swaps

Client

CITI BANK

Duration

July 2017 – Mar 2020

Team Size

6

Tools used

: C#.Net 2015, SQL Server 2014, TFS, Multithreading, Batch Jobs, Autosys, DEVEXPRESS, Angular Js, JavaScript, HTML, CSS,.Net Core

Details

This is a windows application which is used by the Citibank for creating Swap Trades. The Project Purpose is to Migrate the whole project from Sync fusion Control to the DevExpress Control. It includes Calculations for trade allocations; Synthetic position building and cashflow generation. It is used for generating various Reconciliation Reports for the Client.

Role

Team Lead

Responsibilities

•Worked with Business Analysts in identifying Requirements, Risks and developing Risk Management Plans.

•Designing & Developing the PFS application.

•Created Technical Specifications and Functional Requirements

•Managing and reviewing code for team members.

Versioning Strategy using Perforce.

Title

Money Move Service

Client

Charles Schwab

Duration

May 2016 – January 2017

Team Size

6

Tools used

C#.Net 2013/2015, SQL Server 2012, Windows Service, Web API, TFS, Aerospike, Multi-threading, Task Parallel Library

Details

This is a Service Application. This application is used to do the Future Transactions at various Level. This Application receive the Future account info from the OX System. After receiving the info to do the Money Move from one account to other account. It calls various services, generates the MoneMove Recon File for other system, Getting info from NOSQL database(Aerospike) & Update info the Aerospike.

Role

Team Lead

Responsibilities

Direct interaction with Client regarding the requirement gathering

Analysis of user the requirement.

Implementation of the service.

Involved in design and develop service Application

Followed the Agile methodology to implement the Project

Title

Data Quality Metrics

Client

ISCISTECH

Duration

January 2015 - December 2015

Team Size

5

Tools used

C#.Net 2010/2013, SQL Server 2008R2, Oracle, ASP.Net, TFS,ASP.NET MVC, TFS

Details

Data Quality Metrics is a Web Application. It is used to track the Quality of the Oil Well data for different Data Types. There are various Business Rules Created to measure the data in different manner like Data Completeness, Timeliness, Validity, Consistency, Integrity etc. Data Quality is displayed I different reporting format in DQM Dashboard

Role

Team Lead

Responsibilities

Direct interaction with Client regarding the requirement gathering

Analysis of the user requirement.

Implementation is DQM & IQM application.

Involved in design and develop application using ASP.Net MVC

Followed the Agile methodology to implement the Project

Title

MachineTraders

Client

ISCISTECH

Duration

November 2014 - December 2014

Team Size

5

Tools used

C#.Net 2012, SQL Server 2008R2, JQuery, HTML5, CSS3, Entity framework, ASP.Net MVC 4.0, TFS

Details

Machine traders is an ecommerce website to sell heavy machinery, Old heavy machinery across the globe. It is having different modules like Product Maintenance, User maintenance, Payments, User cart maintenance etc.

Role

Team Lead

Responsibilities

•Requirement gathering& Analysis for the Machine trader’s application.

•Involved in design and develop application using ASP.Net MVC 4.0

•Creation of LINQ queries for the application.

•Directly interact with business users and getting requirement and implement the modules.

•Followed the Agile methodology to implement the Project.

Title

Learning Management System

Client

PETRONAS (Oil & Gas Company)

Duration

Jul 2014 - November 2014

Team Size

5

Tools used

C#.Net 2010, SQL Server 2008R2, JavaScript, LINQ2SQL, ASP.Net 4.0, SSRS, TFS

Details

Learning Management System (LMIS) is a Web Application. It is used to automate the management of the Program administration and Learning Resources facilitation for short courses conducted or organized by PLC and INSTEP. This Application is developed using the MVP architecture. It is having different modules like Program Management, Administration, Billing and Master Data maintenance etc.

I was generally involved in Master Data maintenance & generation of Credit\Debit Note generation for the existing invoices & Implementation of the GST applicable for each of the billing according to Govt. of Malaysia. It also Includes various report generation for the billing purpose.

Role

Team Leader

Responsibilities

•Requirement gathering& Analysis for the LMIS application.

•Involved in design and develop application using ASP.Net 4.0.

•Creation of stored procedures, Views and LINQ queries for the application.

•Directly interact with business users and getting requirement and implement the modules.

•Followed the Agile methodology to implement the Project.

Title

First Party Application

Client

Travelers

Duration

Mar 2013 - Sep 2013

Team Size

10

Tools used

C#.Net 2010, SQL Server 2008, Infragistics Controls, JavaScript, Entity Framework, ASP.Net MVC 3.0, Crystal report

Details

TRAVtest is a Windows Application. It is used to automate the Testing of all the Travelers Applications. Testing team creates test cases for each page of the application based on the events and validations for the page. Once test cases are created, Testers run the Test cases against the Application to get the Test results as passed and failed and accordingly updated to the respective developers

Timesheet is Web application which is used to be used by the Travelers First party group to Submit the Timesheet on regular basis. This Application is to track the daily activities of the group members. Its features involved in generating various reports like Monthly, yearly, Project wise etc for Analysis purpose

Role

Team Leader

Responsibilities

•Requirement gathering& Analysis for the Timesheet & TRAVtest application.

•Design and develop application using ASP.Net MVC 4.0 and HTML.

•Creating stored procedures and Views for the application.

•Directly interact with business users and getting requirement and implement the modules.

•Followed the Agile methodology to implement the Project.

Title

FIAT Trading

Client

Barclays Capital

Duration

Jan 2011 – Feb 2013

Team Size

20

Tools used

.Net 2005/2008/2010, C#.net, SQL Server 2005/2008, Perforce, Batch jobs, WCF, Entity framework, WPF, SSIS, SSRS, Autosys

Details

This is a Web application which is used by the Barclays Capital for tracking the Trades. It is strategic Platform Catering for P&L Analysis, Aggregation and Reporting. Fiat Trading Functionality includes FOBO reconciliations & P&L Explain reporting, Adjustments & Hierarchy- Based P&L reporting. Allows Manual & Auto Adjustments for positions,Prices and P&Ls when there is a break between FO & BO Used By Product controllers to Validate & Report P&L.

Role

Module Leader

Responsibilities

•Requirement gathering& analysis for the FIAT application.

•Implementation of UI of the application

•Creating stored procedures & Views.

•Involved in the Database Performance optimization.

•Worked in Report module of the application.

•Implemented WCF services

•Tracking the Batch jobs

Title

Prime Finance Swaps

Client

Citi Bank

Duration

Jun 2008 – Dec 2010

Team Size

20

Tools used

C#.Net 2005/2008, SQL Server 2005, Perforce, Multithreading, BatchJobs, Autosys

Details

This is a windows application which is used by the Citibank for creating Swap Trades. It includes Calculations for trade allocations; Synthetic position building and cashflow generation. It is used for generating various Reconciliation Reports for the Client.

Role

Module Leader

Responsibilities

•Worked with Business Analysts in identifying Requirements, Risks and developing Risk Management Plans.

•Designing & Developing the PFS application.

•Created Technical Specifications and Functional Requirements

•Managing and reviewing code for team members.

• Versioning Strategy using Perforce.

Title

Capital Market Application Security

Client

BNP Paribas

Duration

Aug 2007 – May 2008

Team Size

2

Tools used

C#.Net 2005, ASP.Net 2.0, SQL Server 2005

Details

This is an intranet application used for assessment of all the projects and application running for the BNP Paribas. Projects are fetched in to this application from the Project Register (Core Database) and Applications are added from BAM plus Database.

Application Assessment is initiated by Project/Application Security Manager. The PCAQ (Project Criticality Assessment Questionnaire) is filled by the project manager. Based on the questions rating, application criticality is derived by the system. Project security manager then revalidates this suggested rating and recommends actions. The application has a work flow component to handle this assessment transaction.

Role

Senior Software Engineer / Module Leader

Responsibilities

•Involved in requirement gathering for CMAS application

•Designed the Application and the Database

•Managing and reviewing the code for team members.

•Handled application deployment in development and staging environment.

Title

Insurance Policy Tracker

Client

ICICI Lombard General Insurance

Duration

Feb 2007 – Jul 2007

Team Size

30

Tools used

C#.Net 2005, ASP.Net 2.0, SQL Server 2000

Details

It was an Intranet application used by the ICICI Lombard general insurance team to generate new policies for Motor, Engineering, Fire and Marine. The application had facilities to manage the entire life cycle of the policy right from proposal creation payment entry, to policy generation.

Role

IT Engineer

Responsibilities

•Involved in prototype creation using the Genesis configuration tool.

•Wrote stored procedures to implement business logic.

•Involved in Performance testing of the Accounts Module.

•Create Classes to generalize the code using C#.Net

Title

Proposal Management System

Client

Nortel (Tata consultancy Services)

Duration

Jul 2006 – Jan 2007

Team Size

6

Tools used

C#.Net 2005, ASP.Net 2.0, SQL Server 2000, Windows XP

Details

This was a Migration Project, to automate the Proposal Management System with New Technology. This Application had Admin, Proposal Configuration, Review Queue, B-Form Configuration, Product Maintenance and Report Modules.

Role

IT Engineer

Responsibilities

•Involved in development of B-Form & Proposal Configuration Pages

•Created of Database Objects

.

Title

DH Online Reports

Client

Affiliated Computer Services India Pvt Ltd

Duration

Aug 2005 – May 2006

Team Size

7

Tools used

C#.Net, ASP.Net, IIS 5.0, SQL Server 2000, Windows XP

Details

This involved on line application development for ACS to monitor all the business activities of the organization. The main purpose of this application was to analyze the growth in the business for current week, month, year and previous weeks, months, years. Data Head Reports showed forecasting, achievements and over view of the business of the particular departments.

Role

System Development Associate

Responsibilities

•Involved in UI Designing & development of Attrition report

•Involved in creating Tables, Stored Procedures and Views

•Involved in Unit Testing.

Title

Customer Care Online Report Retrieval System

Client

Affiliated Computer Services India Pvt Ltd

Duration

Apr 2005 – Aug 2005

Team Size

8

Tools used

VB.Net, SQL Server

Details

This was a legacy project developed for ACS. The project was previously developed in VB.Net with SQL Server200 as back end. The application maintained the information regarding the call centers and the main aim was to convert the legacy application to C# and maintain a Centralized Database.

Role

System Development Associate

Responsibilities

•Involved in GUI Designing, Validations

•Created stored procedures and Views.

Contact this candidate