Vee Cherdsuriya Email & Phone Number

Orange, Ca, Us

Orange, Ca, Us

• Develop and design various database objects such as stored procedures, triggers, functions, tables, and views.• Analyze and apply proper indexes to ensure maximum efficiency in a database. Use of performance turning tools such as SQL Profiler and actual/estimated execution plans.• Provide technical recommendation base on systems performance.• Analyze and evaluates various errors between systems using SQL Profiler and trace.• Analyze business processes and provide recommendation for an effective solution.• Manage contracts and statement of work for various projects and ensure schedule, budget, and cost are met.• Conduct review of project and perform testing to ensure project requirements are met.• Design, architect, and deliver product/services to clients and business partners in the areas of application installation and integration.• Consults with clients to analyze and understand functions to be automated, client needs, objectives, desired features, and input and output requirements. • Analyzes, defines, and documents system requirements for data, workflow, logical processes, hardware and operating system environment, interfaces with other systems, internal and external checks and controls, and outputs.• Develop various automation scripts to save time, reduce errors, and enhance product usability.• Develop various reports using SSRS.• Knowledge of various financial systems and ERPs such as SAP, Sage, Epicor, and Microsoft Dynamics.• Heavy use of VMware, VMware Workstation, Critix, and Terminal Services.

• Develop and design various database objects such as stored procedures, triggers, functions, tables, and views.• Analyze and apply proper indexes to ensure maximum efficiency in a database. Use of performance turning tools such as SQL Profiler and actual/estimated execution plans.• Provide technical recommendation base on systems performance.• Analyze and evaluates various errors between systems using SQL Profiler and trace.• Analyze business processes and provide recommendation for an effective solution.• Manage contracts and statement of work for various projects and ensure schedule, budget, and cost are met.• Conduct review of project and perform testing to ensure project requirements are met.• Design, architect, and deliver product/services to clients and business partners in the areas of application installation and integration.• Consults with clients to analyze and understand functions to be automated, client needs, objectives, desired features, and input and output requirements. • Analyzes, defines, and documents system requirements for data, workflow, logical processes, hardware and operating system environment, interfaces with other systems, internal and external checks and controls, and outputs.• Develop various automation scripts to save time, reduce errors, and enhance product usability.• Develop various reports using SSRS.• Knowledge of various financial systems and ERPs such as SAP, Sage, Epicor, and Microsoft Dynamics.• Heavy use of VMware, VMware Workstation, Critix, and Terminal Services.

Orange County, California Area

• Develop various database objects such as store procedures, triggers, functions, tables, and views.• Analyze and applied proper indexes to ensure maximum efficiency in a database.• Analyze complex data structures to generate business insight for upper and executive management.• Support Business Development in creating Business Intelligent reports to analyze site traffic, financials, performance of products, etc. Create reports in SQL Server Reporting Services, SAP Business Object using Infoview, and Crystal Reports Enterprise XI.• Assist Data Sales team in delivering data to customers using data matching algorithm and automation in SSIS.• Assist Data Quality team in identifying data issues by trending and benchmarking.• Recommend and implement data solutions to enhanced levels of transparency to business clients.• Strong analytical and problem solving skills.• Coordinate mass newsletter email mailings to members and partners.• Experience in bi-weekly deployment using Agile Software Development Life Cycle.• Work closely with other project team members to understand business, design and functional requirements that drive quality technical solutions.• Review and test various database objects before deployment into production.• Create Excel PowerPivot 2010 and administer on SharePoint 2010. Created dashboards to analyze customers and website performances.• Manage and mentor junior database developer.

Orange County, California Area

• SQL Server 2005 Database Developer including developing and designing tables, relationships, store procedures, triggers, functions, views, diagrams, certificates, etc.• SQL Server 2005/2008 Database Administrator: backups, restores, mirrors, failover clustering, shrink, indexing, roles, permissions, tuning/optimization, etc.• Generate report using SQL Server Reporting.• Gather, compile, and analyze information regarding technology processes and systems.• Document business processes, develops design and functional specifications.• Utilized Dermacia’s Software Development Life Cycle practices.• Communicate to project team members verbally and in the form of written and electronic documentation.• Understand the business implications of technology solutions.• Participate in Testing and Quality-Assurance of applications.• Code debug, code maintenance, testing for C#, ASP .Net web pages.• Resolve various problems, questions, and/or situations.• Windows Server 2000/2003/2008 Administrator: Dell/IBM/Compaq Server, active directory, cluster, Group Policy, File Transfer Protocol (FTP), IIS, SMS, Security Updates, RAID configuration, etc.• Network Administrator: DNS, DHCP, firewall, anti-vius (eg. Panda), Routers/Switches, TCP/IP, Subnets, VPN and VPN policy, remote access tools, Blackberry software, wireless access point, etc.• Knowledge of Microsoft Hyper-V and VMWare

• Developed various web-base application using VBScript and JScript.• Develop databases in SQL Server 6.x/2000 and DB2.• Apply software development life cycle to various projects including analysis, design, development, test, implement, and review.• Manage scope, schedules and risk.• Project planning in MS Project. Diagrams and work flows in MS Visio.• Interact with clients and provide project guidance on their needs and goals.• Work closely with other project team members to understand business, design and functional requirements that drive quality technical solutions.• Assist in researching and interpreting complex data.• Provide best solutions for giving timeline and budget.• Participate in testing and implementation activities to ensure attainment of desired Business-Systems outcomes (in accordance with established requirements).• Ensure project follows company’s methodology in development life cycle and coding standards.

Bachelor Of Science (Bs), Computer Information Systems

Activities and Societies: MISSA (Management Information Systems Student Association)

Education record