Ravindra Reddy CH

Merchants Fleet Project

• Merchants has been providing highly customized fleet management and fleet leasing solutions to large businesses, mid-sized companies, governments, educational institutions, and more

Responsibilities:

• Migration of the existing SQL queries into new database as per logic
• Created schema scripts, permission scripts, table scripts, view scripts for the new migrated platform
• Working on enhancement in existing reports which includes change in DB query and adding multiple visualizations
• Responsible for the all-code changes to be deployed and tested in all the environments
• Working on migration changes in SSIS, SSRS, OP-Excel reports connection managers and code changes inside packages
• Technologies using: SQL Server 2012, SSIS, OP-Excel, SSRS

Merchants Fleet Project

• Merchants has been providing highly customized fleet management and fleet leasing solutions to large businesses, mid-sized companies, governments, educational institutions, and more

Responsibilities:

• Migration of the existing SQL queries into new database as per logic
• Created schema scripts, permission scripts, table scripts, view scripts for the new migrated platform
• Working on enhancement in existing reports which includes change in DB query and adding multiple visualizations
• Responsible for the all-code changes to be deployed and tested in all the environments
• Working on migration changes in SSIS, SSRS, OP-Excel reports connection managers and code changes inside packages
• Technologies using: SQL Server 2012, SSIS, OP-Excel, SSRS

Smart Action (Module in SmartRev Product)

Project Description:

• SmartRev is an application which helps agents to manage hospitals and physician’s revenue after
• Patients get discharged
• Smart Action is a module in SmartRev application
• The main goal of this module is to achieve productivity for Agents, by prioritizing the accounts on which the agents have to work
• The Managements implements some business rules through front-end, and the accounts which qualifies for these rules will go into different pools as per their qualification
• Once the accounts get into pools, the agents will start working on them
• Technologies used: SQL Server 2012, SSIS

Roles and Responsibilities:

• Developing stored procedures, Views, Functions, Triggers and writing queries to retrieve the information
• Delivered product changes according to client specifications and requirements
• Production support for Clients to resolve the issues which are reported by clients and testing team
• Preparing the test cases and technical documents for developed objects
• Scheduling SQL Server Agent in SSMS.

Inflow Outflow DataMart

• Data mart created mainly to identify the Channel, Transaction type and bank name for a particular transaction which helped in understanding the various transaction analyses
• Here by applying text mining logic on the Tran particular and remarks column of transaction we are arriving at conclusion that what type of transaction a customer is doing like
• If suppose we found any mutual fund company like Franklin Templeton and LIC etc
• Then we can say that the transaction was for mutual fund
• Like was we are arriving at utility bill, insurance, emi of loans etc
• And it helps to how much Inflow and outflow on daily basis and it will give what type of transaction is happening at channel wise
• Technologies used: SQL server 2012, Sybase 16, SSIS

Roles and Responsibilities:

• Involved in sharing of Transaction information summary to ICICI Business Teams (Loans, Cards and Liability etc.)
• Creating Index, Views, Complex Stored Procedures, User defined functions to implement The business logic
• Creation of database tables and procedures to update and clean the old data
• Interacting with the users and troubleshooting the problems involved with the development of stored Procedures, triggers and problems related to the privileges
• Involved in functions like Rank, Replace, Locate, Length, Charindex, Patindex, Trim, Date time, Right, Left functions etc
• Database creation (DDL, DML, DCL), database tuning, SQL tuning, performance planning
• Involved in Sub-Queries like Nested and Correlated Sub-queries
• Involved in removal of wild card characters from the customer related data

PMSBY/PMJJY- ICICI BANK Ltd

• Ministery of indialLaunched 2 social security schemes viz Pradhan MantriJeevanJyotiBimaYojna (PMJJBY) and Pradhan Mantri Suraksha BimaYojna (PMSBY)
• The objective of the schemes is to move towards creating a universal social security system, targeted especially for the poor and the under-privileged
• PMJJBY / PMSBY is a one year life insurance scheme, renewable from year to year, offering coverage for death due to any reason and is available to people in the age group of 18 to 50 years (life cover of Rs
• 2 lakhs is available for a one year period stretching from 1st June to 31st May) at a premium of Rs.330/-(PMJJY) and 12/-(PMSBY) per annum per member having a savings bank account who give their consent to join and enable auto-debit for every year
• Technologies used: Sql Server 2012, SSIS, SSRS, T-SQL, Sybase 16.2

Roles and Responsibilities:

• Responsible for taking requirements from the various ICICI channels and analyzing them to provide feasible solutions
• Involved in data conversion based on business requirements like removal of frozen accounts, Inactive accounts, closed accounts, dormant accounts, mobile number validation, nominee details validations, address validations, de-duping on account level and mobile number level etc
• And finally prepares consolidated unique data for all channels data
• Involved in sharing of Debit information to ICICI Lombard (Insurance) team after debited required amount from customers by ICICI operations team
• Responsible for optimizing all indexes, SQL queries, stored procedures to improve the quality of software
• Performed T-SQL tuning and optimization of queries for reports that take longer execution time using MS SQL Profiler
• Involved in system analysis & design of the Enterprise data warehouse implementation, Requirements gathering