- 8 years of experience in SQL, SQL Server/Sybase, Stored Procedures.
- 6 years Web service, one year WCF with service , operation contract methods,VB.NET.
- 2 years of expertise in PL/SQL Oracle, Winform.
- Multithreaded and synchronization.
- Programming AJAX, WVC, SSIS, SSRS, LINQ. JQuery, Cristal Report.
- JAVA, JSP, Java servlet, Java bean.
- Design/Analysis: development experience with Object Oriented experience.
- Skills: C .net, ASP.NET Oracle database, Package functions, jQuery, HTML, CSS style sheet.
- Project: Wealth Management Banking Banker Productivity, depend on user selected
- Bank type: Complex, Team, internal, in C call the Oracle package-function, that return REF CURSOR.
- from ASP.NET to show Report for NND NET NEW DOLLARS-NND YTD, NET NEW LIABILITIES-
- NNL YTD, RANK NND and NNL etc., each type amount total and amount total per Financial
- Advisor. Also use advanced jQuery to make column sort very easier, So when user clicks any
- column to get that column sort Ascending and descending toggle.
- Program use presentation, business logic and data access 3 layers architecture.
- Skills: C , .NET, ASP.NET, XML, XSL FO, WCF Web service method, graphic, image drawing.
- XML Data, creating XSL Style Sheet, BAR Cart , PIE Chart of Report, include common Template.
- Project 1, CRCFO Report, the report get Goals and Assets data from XML to create reports with 3 parts,
- 1, Goal Funding Status- GFS, Over view with Vertical Bar Chart. 2, Goals Based Balance Sheet.
- 3, Details with Horizontal and Pie Chart. Using C .NET code to make these bars, pie charts.
- Project 2, Wealth Outlook Client Review Center by the team, my part is Estate and Insurance, that includes
- beneficiary Distribution, credit shelter trust, Life Insurance Trust, charitable remainder trust that established for
- client and spouse. Getting data from XML, create template with XSL Style Sheet, reusable attribute sets, image,
- using C .NET, XPATH data set Read Xml, modify XML database, change program to get better performance.
- Project 3, Risk Allocation and Risk Categories, part of CRC Performance Report that includes Client profile for
- Personal Asset, Personal risk, market Assets, Market Risk, from XML database, creating XSL FO Style Sheet, drawing image to make report, All these reports using C .NET WFC Web service, the service contract, operation contract have the reusable methods, using Cache saving data to get better performance, in C .NET
- using xslt transform, system IO File Stream, Memory-Stream, writing data into PDF file to display the report.
Skills: Visual Studio 2010, VB.Net, C , ASP.Net and SQL Server, Oracle PL/SQL, stored procedure, as data transform. Projects used for Verizon products sales grouped by location area, in South, West, North and East, inventory management, files load, update, backup, Extensively used VB Script to update data and data processing.
- Project 1, AISPQ- Alternative Investment Solutions PreQualification used for Portfolio manager to review,
- Approve qualified client for investment in financial assets such as Real Estate, Private equity and hedge funds.
- Project 2, SCANPROSPECTS: Scan SQL Server AISPQ Table for certain forms to get the form's Primary-GCI,
- then for each form's GCI, Scan the DB2 PACE Table, if found any account matches, email to Develop manager or
- portfolio manager using web-services, the email address, subject and body messages get from configure file.
- Project 3 MIP ORGHIERINFO Load Netezza database, Merge with SQL server view in left outer join by the
- subs of s4dot-field, optimize data processing, writing the merged Account data from both database into Excel file.
- Project 4/ 5/6, UNLPACEPM/ LOADPACEPM/CLEARLOADLOG, scan DB2 table by certain condition, writing
- the data into Flat file Load data from flat file into SQL server make load log, clean the load table to keep history.
- Project 1: Transfer of a web application written in .Net version 1.0 over to .Net v.2.0, with WCF, AJAX,
- Included a re-write of the attribute codes, trouble shootings and fixed all the errors.
- Project 2: Enhancement for project WebEFT Electronic Fund Transaction , created new web-pages for
- agency users and internal Guardian employees, included: data delete, add new and edit, using .net2.0
- new features for 3 tier services architectures, Created Agency reports and SQL2005 stored Procedures.
- Project 1, Lost Certificate -Maintenance and enhancement, check and process for investment of customers
- who hold stock but lost stock Certificate using C , ASP.NET, SQL Server 2005, stored Procedures.
- Project 2, Rejects, Project 3, Unsecured, check and process customer's stock that was rejected/unsecured.
- All projects are for financial investment trading: the Securities, Fund Family Items using Crystal
- report for various Summary of trading listed by Cusip/ symbol, Agent, brokerage, Security type
- using XML, Xpath to process XML Element/Attribute using .NET2.0 new features including
- ObjectDataSource, XMLDataSource, the three tier architecture in web applications include CSS
- Style sheet in Presentation tier for Client, ASP.NET, ADO.NET in BLL and DAL middle layers for
- business logic, using Sybase12, Oracle9, SQL Server 2005, stored procedures Database in back end.
- Project: 1, RLSU Regulatory List Screening Utility of web application, work for the maintenance, technique
- support, trouble shooting, debugging, using XML, ADO, SQL database processing. The project is for Admin-
- Enterprise groups, basses on Business Unit and Business system type to get Entity Summary and detail, input
- data entry to database, output data to report or Excel.
- Project 2, Web service maintenance using C , ASP.NET, CSS style sheet, XML, WSDL, SOAP.
- Project 3, Enhancements and support services for the merge between Merrill Lynch and the Black Rock
- Mutual Funds Company, data transition, add/modify user for business Group, Unit, System and role.
- Project 4, Add/Modify Online Log and Batch Log option depend on Business Unit and Business System.
- Projects 1, Quick Planning, collect family's Bank/ Loan/Mortgage/Investment information to make the
- children's Education, insurance, Long term care etc, planning for family's finance analysis and plans.
- Project 2, Lock Manager, component for C or vb.net web applications using web service to get
- Group/Agent/ Client, check out to lock a client for edit/update, and check in to unlock this client.
- Project 3, Asset Allocation, from the Portfolio/Cash saving information and selected Income/Diversified
- /Balanced Equity etc., calculating percentage, and then making pie chart for the Asset Allocation.
- Project 4, Simply Money, reading data from XML, save these data to PDF file, display report in Adobe.
- Project 5: eCommerce applications for products/vendor information lookup/report, programs get user data in Web
- Skills: Visual Basic, SQL Server/Sybase, DTS, Excel, MS Access, Crystal Report, ASP, VB6.
- Projects:1. Advantage Data Transfer from Amtrust, SQL Server7 Stored Procedures: combine lot of
- tables on complicated relations/requirements, transfer to another new Advantage system.
- Project 2. Advantage Daily running, Stored Procedures: from multi complicated tables, make Add/Update files,
- save the change into flat data file, optimization data processing, create financial report,.
- Project 3. JERSEY and NASSAU PIC/Trust weekly AUM Increases/ Decreases Balances, Take data from
- different database: MS Access, Sybase Rapid SQL and T-SQL, combine to reports in Crystal report or Excel
Project 4. Application maintenance and data optimization, stored Procedure used in web application using ASP.
- Skills: MS SQL Server, Visual Studio InterDev, ASP, VB6, COM, ADO,
- Project: SIR web Application, Data processing for Trading, Financial Reports using Crystal Report,
- Database Management including Stored Procedures, Optimize Data Processing and Improve Application.
- Skills: VB, ADO, SQL sever, Crystal Report, HTML, VBScript, ASP, VSS, Oracle, PL/SQL, Sybase,
- Project 1. e-commerce web site for the product sales, designed web site to provide customer register/login page, store product catalogs, products display page, customer select-purchase add/remove page, order list etc.
- Project 2. Order Processing System, Design and development, using VB, MS Access, Excel, The system
- provides users powerful industrial warehouse management, purchasing, shipping, sales, accounting, reports.
- Project 3.The Small Business Accounting SBT is used for computers Purchase Orders, Accounting, Reports,
- Billings, Warehouse Inventory, Enhancement of SBT as well as UPS shipping, RMA management etc.