Quality Assurance Sql Server

Mariel G. Aseron

**** ********* **, *******, ** *0033

407-***-**** (c) ******.******@*****.***

SUMMARY

IT professional with three years of experience in consulting and nine years of computer programming. Self-motivated,

team-oriented, and easily adapts to environment. Possess a sound understanding of relational and de-normalized

databases. Extensive experience in data mining and analysis on very intensive data sets from various ERP and

accounting systems. Able to handle multiple projects simultaneously, learns quickly, and enjoys knowledge sharing.

Accomplishments include:

- Directed cost cutting efforts relevant to IT consulting fees on audit engagement by

identifying alternative solutions for system generated reports, easing the audit process,

decreasing hours spent on data analysis, and resulting in an estimate of $59k savings in

consulting fees.

- Researched and developed a standard test procedure specific to a system conversion of

an accounting sub-ledger, ensuring completeness and accuracy of data migration.

PROFESSIONAL EXPERIENCE

PricewaterhouseCoopers, LLP Atlanta, GA 8/2006-11/2009

Advisory-Technology, Senior Associate

Data Management and Analysis:

- Designed and developed dynamic dashboard on effective tax rate for retail client using Business Objects

software solution, Xcelsius, transforming data to actionable data and providing trends analysis over time

- Analyzed data dump files from several general ledger systems, validating completeness and data integrity of

client transactions with analytical software (ACL, Oracle, MS SQL Server), confirming record count with report

generated or client provided totals, reconciling balances, and tying to team reviewed reports

- Utilized data mining tools, such as Monarch Pro, transforming scanned and/or system generated reports to

flat files and exporting to MS Excel for editable information

- Assessed clients data records based on defined audit risks that impacts the client’s financial position,

reporting and documenting results for management review

- Executed standard MS SQL stored procedure scripts for retrieving required data set for sampling purposes

- Tracked budget to actual, each team members rates, and work progress, through the duration of all client

engagement, as well as, communicating information during status meetings

- Designed and developed MS Access db, tracking inventory of purchased MSDN software and book library

Forensics:

- Maintained collected hardware and loose media devices identified by legal council on a preservation project,

storing information in a designed and developed normalized database in MS SQL Server

- Executed SQL queries on collected data to create statistical reports to be provided to legal council

- Managed and utilized e-Discovery tools, performing image processing of hardware and loose media

- Extracted a client's systems’ data definition due to a data security breach, using internally developed Excel

Macro & SQL queries to review potentially compromised PII

- Performed Quality Assurance reviews on processed images to ensure completeness of deliverables

IT Risk Assessment:

- Performed web application security assessments on static/dynamic websites, identifying data security risks,

documenting findings, level of security threats, and recommended remediation.

- Developed a dynamic executive summary report, using MS Excel, providing statistical information on PII

vulnerabilities, registrant domain statuses, & applications inventory for client CIO and Chief Marketing Officer

- Maintained understanding of PCI Compliance with knowledge of PCI DSS, PA DSS, and PED

Windows/Web Application Development:

- Designed and developed project management tracking web application for management reporting

- Developed a web application used as a repository for standard citations/qualifications collected by the

Business Intelligence team

- Designed and developed a domain WHOIS lookup tool for pulling defined registrant information

Mariel G. Aseron

1113 Arbordale Dr, Decatur, GA 30033

407-***-**** (c) ******.******@*****.***

UF College of Education Gainesville, FL 1/2005-5/2006

Graduate Assistant

- Maintained department web applications, designing web pages with consistent layout

- Developed and tested web forms used to ensure user authentication and error checks were in place

UF Admissions Office Gainesville, FL 8/2000-12/2004

Network Administrator

- Configured IBM workstations with required hardware specifications

- Formatted PCs with Windows 2000/XP and ghost images (Symantec) onto hard-drives

- Provided support to NERDC's GATA Users, assisting with any technical issues encountered

U.S. Biomedical Information Systems Gainesville, FL 4/2004-8/2004

Tech Support/Installer Developer

- Assisted users of all USBMIS products with software issues by phone or email

- Assisted in the development of handheld PDA device installers for Thompson’s Rheumatology, Sanford

Guide, and Tarascon Pharmacopoeia using InstallShield and Microsoft Visual Studio .NET

- Released BETA versions to customers, documented errors reported, and then maintained installers for new

release

CRS Technology Cape Coral, FL 5/2003-8/2003

IT Intern

- Designed and developed an MS Access db for hours & billing tracking used by a team of System Engineers

- Maintained company website, modifying functionality of web forms based on Supervisor requirements

TECHNOLOGY CAPABILITIES

Databases: SAP, Hyperion, SQL Server 2000/2005, Oracle 8i/10g, MySQL, MS Access

Languages: T-SQL, P/L SQL, ACL, C++/C, .NET (ASP, C# and VB), Java, JavaScript, PHP, HTML, XML

Text Editor/OCR Solutions: Ultra Edit, Readiris Pro, Able2Extract

Applications: MS Visual Studio .NET, MS Office Suite, Xcelsius 2008, Visual Mining, Monarch Pro

Forensics Applications: Encase v5.05, Ultradock v4, USB write block, Helix

EDUCATION

M.S. Decision and Information Sciences, University of Florida, May 2006

B.S., Cum Laude, Computer and Information Sciences, University of Florida, August 2004

Contact this candidate