Nandhini Ramanujam

Project - WMS-CoSaCS Integration

Client: Unicomer

Environment: Windows Server 2012 and SQL Server 2012

Role: Database Developer

Team Size: 10

• Responsible for the analyzing and designing of the software development life cycle.
• Responsible for the designing the advance T-SQL queries, procedure, cursor, triggers, scripts.
• Facilitated in developing data modeling and E-R design of the systems.
• Studied the requirements and system specifications.
• Involved in Physical Database designing, Performance tuning of queries.
• Understand the current systems, coding, testing and provide enhancements to the current application based on the client's requirements. Execute and obtain reports from the production server.

Project: Silver Blade 2.0 Product - Silver Blade 2.0 (SQL Version) is a credit Bureau product. This Project is for processing bulk data into database and fetching credit reports.

Client: Dun and Bradstreet

Environment: Windows Server 2012 and SQL Server 2012

Role: Database Developer and DBA

Team Size: 40

• Responsible for the analyzing and designing of the software development life cycle.
• Responsible for the designing the advance T-SQL queries, procedure, cursor, triggers, scripts.
• Facilitated in developing data modeling and E-R design of the systems.
• Studied the requirements and system specifications.
• Involved in Physical Database designing, Performance tuning of queries.
• Involved in developing SSRS and Crystal Reports.
• Understand the current systems, coding, testing and provide enhancements to the current application based on the client's requirements. Execute and obtain reports from the production server.

Project 1: ECihan - The Cihan University has online Admission, Academics, Fee Management, and Hostel Management tool.

Client: Cihan University

Environment: Windows Server 2012 and SQL Server 2012

Role: Database Developer

Team Size: 15

Project 2: eUKH -The Kurdistan University has online Admission, Academics, Fee Management, and Hostel Management tool.

Client: Kurdistan University

Environment: Windows Server 2012 and SQL Server 2012

Role: Database Developer/Production DBA

Team Size: 15

• Responsible for the analyzing and designing of the software development life cycle.
• Responsible for the designing the advance T-SQL queries, procedure, cursor, triggers, scripts.
• Facilitated in developing data modeling and E-R design of the systems.
• Studied the requirements and system specifications.
• Involved in Physical Database designing, Performance tuning of queries.
• Involved in developing SSRS and Crystal Reports.
• Understand the current systems, coding, testing and provide enhancements to the current application based on the client's requirements. Execute and obtain reports from the production server.

Project 1: Stock Monitoring Tool - The Zylog system having treasury department, which is doing online trading in stock market, the same debit, credit, buying and selling transaction it happens through bank and financial institutions. The same information gets through online statement from corresponding banks and stock financial institutions. This module will produce MIS report but the system expects inputs from user. So the user will input to system so that system will have total track on all information's and various MIS reports can be generated.

Environment: Windows Server 2003, 2008 and SQL Server 2005, 2008

Role: Database Developer/Production DBA

Team Size: 8

Project 2: Zee tools - This tool has the Employee details, Appraisal, Projects and their clients, Payroll Processing, Tax Calculation, Attendance Reporting System modules. Finance Department has been facilitated by Revenue Reports.

Environment: Windows Server 2003, 2008 and SQL Server 2005, 2008

Role: Database Developer/Production DBA

Team Size: 8

Project 3: Timesheet Management Tool - Timesheet Management Tool has been developed to track the employee's daily activities. This software facilitates the approver and reviewer to have an overview of their subordinate's daily activities.

Environment: Windows Server 2003, 2008 and SQL Server 2005, 2008

Role: Database Developer /Production DBA

Team Size: 3

• Responsible for the analyzing and designing of the software development life cycle.
• Facilitated in developing data modeling and E-R design of the systems.
• Studied the requirements and system specifications.
• Understand the current systems, coding, testing and provide enhancements to the current application based on the client's requirements. Execute and obtain reports from the production server.
• Checking daily backups full, differential and T-Log within the first few hours of failure.
• Installation of SQL Server 2005/2008.
• Performing SQL server daily health check and preparing a report based on it.
• Handling creation of new SQL Server databases as per request.
• Responsible for the designing the advance SQL queries, procedure, cursor, triggers, scripts.
• Handling Incidents/Change requests as per the SLA metrics defined.
• Managing Logins, users and object level permissions.
• Managing all Jobs, Alerts and Maintenance plans.
• Worked on space issues like TempDB and log files.
• Managing the Backup and restoring the databases.
• Applying Service Packs and Security patches for the servers as released/requested.
• Managing the high availabilities options being used in servers Log Shipping, Clustering and Mirroring.
• Have understanding of clustering environment and monitoring through cluster administrator.
• Reviewing SQL Server and SQL Server Agent Error Logs.
• Handling blocking/locking incidents if any.
• Troubleshooting connectivity issues raised by Application users.

Project: In house Implementation - This tool has the Employee details, Performance Appraisal, Development Appraisal, Payroll Processing, Tax Calculation, Attendance Reporting System modules.

Environment: Windows Server 2003, 2008 and SQL Server 2005, 2008

Role: HR Technical Support

Team Size: 11

Project 2: Loan Organization System - This project was done for multibillion-dollar regional bank in USA, which provides a diversified portfolio of financial services. The solution provided to the bank automated the entire Loan Origination process starting from lead generation to closing and booking of the loan in the system. The solution comprised of handling various stages of the Loan origination process like Opportunity management, financial analysis, Loan packaging, Negotiation, Ordering, reviews, approvals and counter offers, document preparation, Loan closing execution and Loan set up and booking in the system. The solution helped in Automation of manual tasks, increased productivity, better interfaces and streamlining of existing business processes.

Client: Commerce Bank, USA

Environment: Windows Server 2003, 2008 and SQL Server 2005, 2008

Role: HR Technical Support

Team Size: 40

• Responsible for the analyzing and designing of the software development life cycle.
• Responsible for the designing the advance T-SQL queries, procedure, cursor, triggers, scripts.
• Facilitated in developing data modeling and E-R design of the systems.
• Studied the requirements and system specifications.
• Understand the current systems, coding, testing and provide enhancements to the current application based on the client's requirements.
• Execute and obtain reports from the production server.