Sql Server Data
Resume:
MELISSA KWOK VILLEGAS
**** *** **** ***** ***#*** ~ El Paso, Texas 79936 ~ 909-***-**** ~
abk1sx@r.postjobfree.com
EXPERIENCE
*/**** - ******* ********, ********** & Client Services
ACT Litigation Services, Valencia, CA
* Web hosting responsibilities included data verification, manipulation,
and loading through proprietary as well as industry leading legal review
web applications (iCONECT, Relativity); creation/maintenance of user
accounts and technical support for internal project management handling
all cases and clients; troubleshooting and issue resolution serving as
the liaison between ACT and the vendors on application and network
issues.
* Streamlined tracking documentation of department processes (billing,
license management, user accounts, policy and procedural documentation).
* Technical and troubleshooting tool support for offshore attorney review
teams in the Philippines/India.
* Demo of service/product offerings to potential/existing clients through
web/phone presentations.
8/2005 - Senior Associate, Technology and Forensic Analysis
5/2008
PricewaterhouseCoopers LLP, Los Angeles, CA
* Analyzed large/complex data sets, particularly in Oracle/SQL Server
using matching algorithms/reconciliation procedures to address client
issues related to financial analysis, business interruption (i.e.
mergers/acquisitions), and investigative litigation disputes (i.e. stock
options, general fraud, money laundering activity, class action lawsuits)
in various industries.
* Performed detailed electronic reconciliation of revenue, accounts
receivable, and invoice data for the creation of AR balance trending
analysis reports and monthly AR audit support documentation for clients.
* Ensured consistent data quality through data cleansing procedures on
relevant customer, vendor and employee data in order to perform and
produce fraud detection analysis reports.
* Produced detailed stock options and grant reporting on the
reconciliation between various financial reports and data sets for
clients.
* Compared fee billing data and information from various client data
source applications in order to understand and explain the driving
factors behind each source.
* Trained/led teams to provide restored, processed, and converted
electronic files to clients in corporate/industry standard review
environment.
* Conducted/managed projects requiring forensic acquisitions of
electronic evidence (i.e. desktops, laptops, servers, memory devices) and
discovery of electronic files (i.e. email, common user files) to support
internal audit committees, SEC investigations, and a variety of other
litigations.
* Interacted/supported review teams (internal staff/external clients and
their legal representation) on a daily basis in utilizing the review
tools and to perform data searches as needed.
* Headed/executed quality testing and validation procedures on
firm-developed customer risk rating methodology aimed to more effectively
monitor money laundering in a high profile bank corporation.
* Planned/led internal west coast SQL Server and technical analysis
training for interns/incoming associates.
* Built strong client relationships through direct interaction on each
engagement.
3/2004 - Business Systems Analyst Intern
2/2005
Capital Group Companies, Brea, CA
* Worked with primary users to identify fixes & generate minor
enhancements to a firm-developed tool.
* Created & executed regression test scripts, and maintained the tool's
online help.
* Headed a systems analysis project to replace the current defect
tracking tool used by the team.
1/2002 - Webmaster/Database Designer - Volunteer
12/2007
Chinese Grace Baptist Church, Monterey Park, CA
* Planned, designed, integrated, and launched new website for the church
(www.chinesegrace.com).
* Involved in design, coding, and update of church financial management
database system.
* Troubleshoot and maintained up-to-date quality information provided by
church staff at on-going basis.
EDUCATION California State Polytechnic University, Pomona, CA
2000 - 2005 Major: Computer Information Systems, CIS GPA: 4.0 Cumulative GPA: 3.85
(Summa Cum Laude)
2006 EnCase Intermediate Computer Forensics II Private Sector Training,
2009/2010 Guidance Software, Pasadena
iCONECT Administrator Certification, iCONECT, Redondo Beach
Relativity Administrator Certification, KCura, Chicago
SKILLS Database management systems such as Oracle, SQL Server, MS Access
Data modeling tools such as Erwin, Rational Rose, Together, Visio, UML
Computer forensics and discovery tools: EnCase, OutIndex, Concordance,
iCONECT/nxt/ext, Relativity
Graphic/Web Design Tools: FrontPage, DreamWeaver, Flash, Premiere,
Photoshop, Paint Shop Pro
Operating Systems: Microsoft Windows/NT/XP based platforms
MS Office (Project, Word, Access, Excel, PowerPoint, Visio)
Confident and strong ability in analyzing and problem solving
Possess proven leadership/teamwork, organizational and effective
communication skills
Fluent in Cantonese (spoken)
ACHIEVEMENTS Individual 'We Recognize Great Performance Award' spot bonuses for
excellent efforts and
contribution on specified engagement teams 2006, 2007, 2008.
Contact this candidate