Post Job Free

Resume

Sign in

Sql Server Management

Location:
Jersey City, NJ
Posted:
February 02, 2014

Contact this candidate

Resume:

SureshKumar AVG

accgux@r.postjobfree.com

201-***-****

Summary

• A skilled and experienced Information Technology professional with a unique combination of creativity,

leadership, teamwork and client services, with over 7 years of experience in production operations

covering US Cash and portfolio Equities Trading Platform.

• Presently working as consultant with Deutsche Bank AG, NY via HCL America Inc.,

• Providing level2 production support for electronic trading desk on the cash and program trading side.

• Experienced on FIX Protocol, UNIX, Oracle, MS SQL Server, VB 6.0, VBA Excel, ASP, COM+, MS Access

and Analysis Manager (OLAP).

• Flair knowledge on VB.Net, ASP.Net, Java, Oracle.

• Provide MS SQL Server DBA support for production and development projects.

• Strengths include analysis and problem solving expertise, good oral and written communications skills.

• Demonstrated ability to quickly master new technologies and to “hit the ground running”.

• Creative thinker with a flair for crafting solutions while staying within project constraints.

• Highly effective team player, consistently helping realize the overall project goals and bringing out the best

from other team members.

• Good team management resulting quality & on time deliverables.

• Identified as on site coordinator for past three projects.

• Obtained very good feedback from the clients.

• Good experience in client/server, internet applications and N tier architecture.

• In depth knowledge in handling end to end development of software projects from inception, requirement

specs, planning, designing, implementation, configuration management, documentation and closure with

cross cultural teams.

Skill set

Windows XP, Windows 7, UNIX, VB.Net, ASP.Net, Java, Visual Basic 6.0, VBA, MS SQL Server, Oracle, MS

Access, ASP, VBScript, Java Script, IIS, XML, XSL, XSLT, FIX Protocol, COM+, MTS, Control M, AutoSys,

TSM Backup, Powerbroker, BI, ETL, SSIS, SSRS, OLAP, DSO, BCP, Crystal Report, Active Reports, MS Data

Reports, Visual Source Safe, Harvest 7.0

Experience

Arina Portfolio Trading Oct 10 – Present

Client: Deutsche Bank AG, US.

Technologies: UNIX, FIX Protocol, Oracle

• Provided Level2 production support for the Electronic Trading Desk which involved troubleshooting

production environment configurations, troubleshooting problematic orders and coordinate with the QA and

Dev teams to release code for new functionality.

• Supported the traders by carefully monitoring all production orders and alerting them of any issues

related to client orders, street wide issues, or ALGO strategy issues that may cause the order to not trade as expected.

• Fielded calls from internal & external clients regarding orders that were problematic.

• Good understanding of the order flow and trouble shoot the issues between OMS and EMS

applications.

• Create and support various reports used for by the traders on their day to day order details.

• Developed scripts for day to day maintenance

• Supported internal and external customers in all environments with any issues related to

application, testing, new release, configuration, connectivity.

• Good understanding of the internal DB processes used for incident management and Change

management.

• Good follow up with users on data that is requested – done in a timely manner with a sense of

urgency.

• Excellent support on adhoc queries, EOD ADP booking, ACT reporting process.

• Investigate and resolve any street break by coordinating with settlement and eSpear teams.

• An ability to look at the workflow and try and implement a technical solution is good.

Intangibles

• Interpret traders request or issues they are facing and pro actively fix issues which are likely to

reccur on a particular situation/instance.

• Can easily identify the root cause of few issues based on the knowledge acquired.

• Verify logs based on the order flow and identify possible resolution and suggest various options on

any new configurations (client, desk, account, user etc,).

• Provide assistance to traders on Algos, Order flow, other alternatives to submit an order, etc,

• Interaction with various exchanges on connectivity issues, order issues (rejections, MOC, overfills,

etc,).

• Interaction with Back office and eSpear(ADP) on any street break & booking/settlement related

issues.

Private Wealth Management May 10 – Oct 10

Client: Deutsche Bank AG, US.

Technologies: UNIX, Oracle, Control M, AutoSys

• Leading the team of 18 member

• Spearheading and assisting the team members on their tasks.

• Ensuring that all the production issues are handled to meet within the SLA.

• Monitor problem trends and perform root cause analysis to provide permanent fix

• Ensure that KEDB and Incidents are logged as per the ITIL standards.

• Review and present the RCA details on the Severity 1 and 2 cases to the client.

• Handling project management activities

Daily Production call with customer,

o

Weekly/Monthly meetings on productivity, Outages

o

• Performing Management Reporting, Utilization, MTTR, and Billing.

• Prepare MI reports and attending the review meetings with client to discuss on achieved productivity and quality.

Retail IT CCAgent and SID Oct 08 – Apr 10

Client: Lloyds TSB (HBOS), UK.

Technologies: VB, CCF, SQL Server, SSIS, SSRS

• Leading 15 member’s team and serviced as an onsite coordinator.

• Prioritizing the issues based on the criticality.

• Performed performance optimization, introduced new features in the application.

• Leading and assisting the team members on their tasks.

• Ensuring that all the production issues are handled to meet within the SLA.

• Providing guidance on handling the failures of SQL Jobs and assistance on re vamping SQL Jobs.

• Ensure all the SQL services are running fine and the Reports are available on time.

• Handling Project Management activities which include Task Allocation, review with customer on productivity,

MTTR, SLA

• Performing QA tasks viz., Management Reporting, Effort measures, Team Meetings, and Team Members

Timesheet Approvals.

• Review meetings with client on achieved Productivity and Quality by the team.

Global Market Risk and Controlling Concentrix Oct 04 – Aug 08

Client: Deutsche Bank AG, UK

Technologies: Visual Basic, ASP, IIS, XML, SQL Server 2000 database, MS OLAP

• Leading 10 member team

• Prioritizing the issues based on the criticality of the issue.

• Leading and assisting the team members on their tasks.

• Ensure that Response and Resolution are provided on time

• Responsible for analysing and development of code fixes.

• Analyzing and managing the ETL optimization.

• Managing the backup and restoration of the Database.

• Assist on Installation and configuration of MS SQL Server.

• Perform the Database & DR server status checks viz., clearing of temp db, allocation of free disk space, etc.

• Database and SQL tuning to improve performance of loads.

• Making structural changes to the databases when application design changed.

• Creation of Data Warehouse database for OLAP Reports.

• Handling Analysis Manager (OLAP) reprocessing.

• OLAP repository backup and restoration

• Defragmentation of tables and indexes.

• Training newly joined team members.

• Handling task allocation to the

o Team Members,

Customer Reporting,

o

Management Reporting,

o

Team Meetings

o

Sentry Collateral Management System Aug 04 – Sep 04

Client: Deutsche Bank AG, UK.

Technologies: VB 6.0, Crystal Reports, Sybase Database

• Conducting requirement study, design and development for enhancements of the system.

• Handling everyday maintenance and support of the system including development of code fixes wherever

required.

• Training of new staff to the team.

• Managing quality control activities for the offshore development team.

www.karvymfs.com Oct 03 – Jul 04

Client: Karvy Consultants Limited, India

Technologies: ASP, Visual Basic, Java Script and VB Script

• Designing the user interface in HTML.

• Developing business objects in COM using Visual Basic 6.0 which are molded as ActiveX components

• Developing reports in Active Reports.

• Handling unit level testing & debugging the module and providing implementation and support.

www.rmfserver.com/rmfnavdefault.htm May 03 – Oct 03

Client: Karvy Consultants Limited, India.

Technologies: ASP, Visual Basic, Java Script and VB Script

• Designing the user interface in HTML.

• Developing COM Components in Visual Basic 6.0 and user reports in Active Reports.

• Performed unit level testing & debugging the module.

UCR (Unit Corpus Reconciliation) Mar 03 – Apr 03

Client: Karvy Consultants Limited, India

Technologies: MS Access, Active Reports

• Being a part of the design discussions and designing the Database tables.

• Developing the complete application and conducting a unit testing.

• Taking the responsibility of implementation and maintenance support.

CCL Administration Apr 02 – Aug 02

Client: CCL, UK.

Technologies: Visual Basic 6.0, Data Reports.

• Developing user interface in Visual Basic 6.0.

• Designing the Reports using Data Reports and conducting unit level testing.

CCL Internet Update Software Nov 01 Feb 02

Client: CCL, UK

Technologies: Visual Basic 6.0, Inet Control, Xceed Zip.

• Developing user interface in Visual Basic 6.0.

• Unit level testing.

CCL – Client Accounts Jun 01 – Oct 01

Client: CCL, UK

Technologies: Visual Basic 6.0, Crystal Reports

• Developing the user interface in Visual Basic 6.0 and Reports using Crystal Reports.

• Conducting unit level testing.



Contact this candidate