POGIRI DURGA PRASAD

1)Having 6+ years of experience in Microsoft SQL Server .

2)Develop T-SQL Code (Stored Procedures, Functions, Triggers, Transactions, Error Handling, Sub queries, and JOINS etc.) Writing and executing stored procedures, Functions, Complex T-SQL queries.

3)Experienced in programming tasks- DML ,DDl ,TCL and DCL

4)Create stored procedures to generate different kinds of reports. Write complex queries to generate different Kind of reports asked by bank.

5)Handling complex queries to fetch Data from large Database. Administering data from multiple SQL Server databases.

6)Creating Schedule jobs and restoring Database backups in SQL server.

7)Rebuilding / monitoring the indexes at regular intervals for better performance.

8)Experience in using SQL Server Profiler and SQL Server Agent. To analyze long running slow queries and tune the same to optimize application and system performance.

9)Documenting major changes to the SQL Servers. Created indexes, Constraints and rules on database objects for optimization.

10)Design, develop and implement ETL/ELT solutions for data ingestion, cleansing, business rules execution and Data Distribution.

11)Perform design validation, reconciliation and error handling in data load processes.

12)Optimize SSIS Package execution and SQL execution to optimize data load performance.

13)Design SSIS packages using data exchange tasks such as File transfer and Secured File transfer.

14)Have the ability to import and export files from FTP/SFTP.

15) Have Knowledge in SSRS report using Report Builder and Visual studio reporting services.

16)Having Knowledge in Azure services like azure key vault , storage account and service bus.

17) Having knowledge in writing code in C# for WebAPI

1)Involved in developing the new enhancements for the Application. 

2)Involved in Production releases for application and database. 

3)Involved in impact analysis. Involved in effort discussions and effort preparations (WBS) for the new requirement. 

4)Involved in Relational Database using SQL Server  for writing stored procedures, triggers and Configuring SQL Jobs.

5) Playing the team lead role in development.

6) Involving the design for development for the integration services for ETL process

• Date of Birth: 06/16/91
• Gender: Male

1. CHAINtrail

Description:

CHAINtrail is an interparty trust platform build on top of blockchain technology, where individual and institution can Issue Credentials and eSign documents online which are completely verifiable all on blockchain. 

Client : Etilsalat

Technologies : Asp.net with C# and SQL-Server

Role :  Team lead 

2. Attendance Tracking System

Description:

The aim of the project to record attendance register system through synel machine .

Their two type to capture the attendance Facial and Bio- metric .

Client : TATA MOTORS, EMERSON, VEDANTA

Technologies : Asp.net with C# and SQL-Server-2008 R2

Role : SQL Developer

3. Financial Inclusion System

Description:

The access to the Banking Technology at present is restricted only to a certain segment of society. The main aim of this project is extending banking to the rural areas where there are no bank branches, consistent power supply or communication links such as telephones or Internet is a daunting task.

Financial Inclusion System denotes delivery of financial services at an affordable cost to the vast sections of the disadvantaged and low income groups. Instead of opening full blown brick and mortar bank branches in remote districts (an expensive proposition) it is proposed that with the help of modern information technology and managerial capabilities of business correspondents banking functionalities could be extended to remote regions.

Micro ATMs will allow customers to perform basic financial transactions using only their Aadhaar number and their biometric/OTP as identity proof (along with a Bank Identification Number for inter-bank transactions). Unlike an ATM, the cash-in / cash-out functions of the Micro ATM will be performed by an operator, thus bringing down the cost of the device and the cost of servicing the customer. The Micro ATM will support the following financial transactions:

1. Deposit

2. Withdrawal

3. Funds transfer

4. Balance enquiry

5. SHG

6. Insurance

7. Minibalance

Client  :  Bank Of Maharastra

Technologies :  Asp.net with C# and SQL-Server-2012

Role  :  SQL Developer