SUMMARY:

• Experienced information systems professional with excellent understand concept of full project life cycle and problem solving skills.
• Excellent team player, intelligent, quick learner, and detail oriented individual with strong communication and analytical skills.

TECHNICAL SKILLS:

MS: Project, MS Office Suite, Visio, Excel, PowerPoint, Visual Capture, Catalyze

Visual Basic: Net, Visual Basic 6.0, 5.0, C#, C++, MFC, C, Access, Crystal Reports, HTML, XML, ASP, Windows 2000, Excel, CONNX, SQL Server2000, SQL server7.5, Oracle, Sybase,UNIX, Shell Script, EMCO MSI package builder

PROFESSIONAL EXPERIENCE:

Confidential, New York

Application Support

Responsibilities:

• Provide front office and back office support for Credit Derivative and Securitized Product Group, Credit Prime Brokerage and Equity business, users such as trader/ trader assistant, risk team, accounting team, etc.
• Provide timely and accurate resolutions and prioritize workload.
• Monitoring the technology platform by using ITRS Geneos to make sure the trading platform stable. Effectively perform root cause analysis of issue.
• Provide Level 1 support to developer and plan teams by assisting migration of all the existing Credit PB ABX/CMBX trades. So that the trades are mapped to Same CCYOIS funding curve correctly. Assisted with AD to test Erebus job and create store procedures for the credit EBC - MIS-EXRACT report on UAT system. Assisted developer for UAT testing.
• Created reports and scheduled to run via FCI server by using SQL scripts. Improved efficiency of the developer process.
• Created the functions on internal website by using shell scripts on UNIX box which allow users to run the reports or run the scripts by themselves.
• Perform in-depth research and identify sources of production issues. Pushed developer to make the necessary corrections. And assisted developer for UAT testing and the fix released on time.
• Work closely with business in managing day to day issues, resolve user queries. Worked with different upstream and downstream teams to resolve any feed issues by checking the log files on UNIX.
• Notified and ensured the ADs to provide fixes for the issues such as the duplicated cash flow that is generated for over 3000 deals etc.. Provided the rolled backup solution for the release bug. Avoid paying the duplicate fees.
• Ownership and participation in the Incident and problem management processes.
• Coordinated with different regions operate teams to assist the global issues.
• Worked with users to replacing the non existing marketers with the valid and present marketers and Originators at once. Reduced the manual backend update time.
• Pushed developer to improve process such as xml feed which cash flow not feed down to downstream system.
• Provided the L2 support, such as perform daily health checks of the application job schedules and infrastructure supporting the application. Develop scripts to automate repeatable manual tasks. Participate in Disaster Recovery events and Major Event Changes.
• Build and foster relationships across multiple organizations.
• Drive weekly status meetings with key stakeholders including trading, product development, and operations
• Documented all procedures for fixing incidents and problems and share with team members to ensure future incidents can be resolved effectively.

Application Support/ Technical Analyst

Responsibilities:

• Provide front office support for all the Prime Brokerage business users such as Sales/Traders, Operations, Client Reps, etc.
• Ensure that the Global Prime Brokerage Applications are available and supported in line with the defined system requirement.
• Support the needs of traders and developers in creating a stable and profitable trading environment.
• Use the understanding of the business of Prime Brokerage from a global perspective, to provide hands-on technical support for both internal and external client.
• Work with software developer to resolve software run time issues such as aborts and critical error messages.
• Work with development leads across trading products to in corporate new features into the electronic trading stack.
• Work with the broader electronic trading team to deliver on technology strategy, including but not limited to data center build outs, market data adoption, and connectivity
• Monitor processes and reports that run on UNIX and Window platform to ensure availability.
• Work with global users from different countries to resolve trade issues.
• Coordinate the application changes and be the gatekeeper of all changes to production environment.
• Understand and analyzes global user business applications, package business application according to corporate standard. Test the packaged business applications in simulated user environment accordingly such as terminal server, window 2000, and window XP. Document testing steps and results. Test vendor software functionally according to user’s requirements. Promote packaged and approved applications to production environment.
• Review functional requirements and design specifications and construction of all aspects of UAT testing. Work with business clients from initial contact through documentation and validation. Document the technical problem and review it with the user. Analyze business requirement, develop test case for validating software requirement. Execute test base on a predetermined testing schedule and document results. Document and track test results for each task and publish and share with team member.
• Provide excellent customer support and troubleshoot existing application package. Interact with global users and software developers to understand their requirements and problems. Troubleshoot and solve their software problems and package the solution and distribute in a timely manner. Document all procedures and know how for each solved problem and package.

Business Analyst/Programmer Analyst

Responsibilities:

• Successfully developed the Profit and Cost Accounting System. The application is rewritten from QBasic to Visual Basic6 and SQL sever 2000 as database. Meet with users to understand and analyzes their business needs. Create documentation of the all business functions and technical requirements of the new system. Identify reporting needs of the management to keep track of performance of each product. Create and report data in format that can be shared by different departments. Develop test cases, scenarios, scripts and expected results to QA accounting functionality, operational reporting and client statement generation. Recommend and define system enhancements.
• Perform DBA duties such as schedule backup of Database, analyses user queries, SQL performance tuning and tables space allocation. Normalize tables if necessary.
• Design new tables base on user specification for new projects. Assist developers with SQL performance issues. Work with developers to identify potential issues relate to Database.
• Added the new users to the Oracle database and created the tables and store procedure and create the DTS package to generate the table to the Excel file and email the Excel file to the users of the DTS package in the SQL Server.
• Created the new Traveler System. The application created the label bar code, so the users can use the scanner to scan the information into the system. The data updated two different systems between Alpha system and Window system.
• Created the new Weight System. This system using communication port to send the data from the user’s computer to scanner to calculate the total of quantity for the part, if the data over six months the system would remain the user.
• Developed the Profit Loss System. The application is rewritten form Metafile to DHTML Visual Basic 6 and Oracle 9i.
• Upgrade the POS system, QA system, Property Control system, and Raw Material Inventory system, Socket Assembly Production System, Injection Molding and Stamping System from Access2 to Access97.
• Translate the DIBOL in the Open VMS to C