Business Analyst
Resume:
DANIELLE PAQUIN
********.******@*****.***
TECHNICAL SUMMARY
Microsoft Office Suite, including: PowerPoint, SharePoint, Microsoft Project and Microsoft VISIO, SQL, ER diagrams, Erwin, DTS (Data Transformation Services), data mappings and conversions.
EDUCATION AND CERTIFICATIONS
Master of Arts, Mathematics, Portland State University, Portland, Oregon -- June 1994
Bachelor of Arts, Mathematics, Portland State University, Portland, Oregon -- August 1991
Microsoft Certified Systems Engineer, MCSE certification -- May 3, 1999
Microsoft Certified Database Administrator, MCDBA certification -- Jan. 31, 2001
PROFESSIONAL EXPERIENCE
Business / Data Analyst and Reporting Analysis (contract)
Microsoft, West Redmond, WA June 2008 – December 2008
Business Analyst and Project Manager for the Media Trust tool for Microsoft Web Advertising. Performed Data Analysis, SQL Analysis, Logging Issues, and Investigated Errors. Defined, processed, and created reports to sustain application. Managed new releases of the Media Trust tool and performed User Acceptance Testing (UAT). Contract ended due to budget cuts for the team. Excellent reference.
Data Analyst (contract)
AT&T, Redmond, WA April 2008 – May 2008
Retrieved data, generated reports, performed report analysis and data validation. Worked with various teams gathering information to perform data mapping, data cleansing, data migration and integration of information. Provided executive summary of internal reports to executive level. Ran reports from Business Objects. Provided Scorecard and Metrics. Contract ended because project was merged with another group.
Data Analyst (contract)
Safeco, Seattle, WA January 2008 – February 2008
Worked on data call reporting for the Statutory Reporting group and the Statistical Reporting group. Used homegrown systems to do retrievals for the groups. Reporting Analysis, Documentation, Specifications.
Short contract: finished work earlier than expected.
Data Analyst (contract)
HouseValues.com, Seattle, WA September 2007 – October 2007
Marketing Data Analysis. Worked with SQL, MS EXCEL pivot tables, MS ACCESS to analyze data from different sources. Automated weekly and monthly dashboards to show effects of marketing campaigns. Project ended early because of budget cuts due to decline of Internet housing market for Realtors.
Business Analyst (contract)
Microsoft, Sammamish, WA August 2007 – September 2007
Performed design analysis and data mapping on data warehousing applications. Worked with the business to understand requirements and translate them into detailed functional specs that development can consume. Sound business related skills including excellent problem solving, team building, judgment and decision making skills. Cross-group collaboration. Project outsourced to India.
Business Analyst (contract)
Wells Fargo, Frederick, MD October 2006 – March 2007
Worked with definitions of requirements for point-to-point translations using tools like data dictionaries for validations. Managed relationships surrounding 40-50 points in the automated decision model of mortgages. Inputs, outputs, and translations were the go-to for requirements, conveying technical information to IT developers, and test scripts to assure accuracy of translations. Performed User Acceptance Testing (UAT) that lead to the final acceptance of the solution. Used Microsoft Project to keep the testing part of the New User Interface program on time and on budget. Moved from Maryland to Seattle because of my husband’s work.
Business Analyst
Merkle, Inc., Lanham, MD October 2004 – April 2006
Key member of the Proctor and Gamble application software and database team automating cross company, multi-brand, data warehouse and datamart solutions. Worked closely with business analysts, programmers, project managers, project leaders and client representatives to assure on-time delivery and data reliability using Microsoft ACCESS, VBA, Transact SQL, Microsoft SQL Server and Microsoft Project.
Developed scope of work, functional specifications and requirements for a quantitative marketing database for P&G. Project manager for the reporting mart for the solution. Results: Accurate daily, weekly and monthly reports from the data mart published to the P&G SharePoint Portal and posted in a timely manner delivering critical business information to users.
• Developed production control metrics for the daily production activities including Availability and Capacity Management, Processing Update, Warehouse Update, Epiphany Updates
• Performed User Acceptance Testing (UAT) and releases acceptance
Marketing Data Manager
Massini Group, Inc., Columbia, MD October 2003 – September 2004
Primary, day-to-day responsibility to work with the group’s client marketing database ensuring its effective utilization in the direct marketing solutions implemented by the Massini Group client teams. Through frequent consultations with the client and campaign manager, rapidly internalized client database requirements including the direct marketing objectives of the approved projects. Designed, developed, and implemented marketing databases that were effectively utilized to meet client objectives. Working with the client database typically involved using SQL programming, Microsoft ACCESS, VBA and DTS packages including:
• Consolidation of the client data (clean, standardize, de-dup, grade, attribute) from multiple data sources
• Report status (market coverage, data completeness, data quality, relationship)
• Select/suppress for marketing programs
Business / Applications Systems Analyst (Contract)
Jantzen, Inc., Portland, OR April 2003 – June 2003
Communication liaison between management and IT ensuring satisfaction of Business IT-related needs and expectations. Analyzed business processes to determine appropriate technical solutions. Facilitated delivery of application and support services to address immediate needs. Developed special programming projects. Designed, wrote, and implemented a Bill of Material database application interface between Microsoft Access and Essentus, a supply-chain management solution program. Kept the project on schedule with MS Project.
Programmer - Visual Basic and Visual Basic for Access (Contract)
InfoGroup Northwest, Beaverton, OR January 2003
Contract for Alaska Tanker. Modified and added new features to a current Visual Basic application.
Marketing Database Analyst
NetIQ, Portland, OR March 2002 – September 2002
Coordinated and delivered multiple projects, within multi-database environments in a demanding, results-driven business environment. Developed and implemented procedures to increase productivity, and the quality of deliverables including customer and prospect campaign lists, using T-SQL. Data cleansing: Performed analysis, prepared programming specifications, and build extraction and cleaning processes for data extraction and loading. Monitored data quality and validated business scenarios for a new marketing database. Performed ad-hoc T-SQL queries for Access reporting from the Siebel database and the new Marketing Database Warehouse.
Database Analyst / Programmer (Contract)
Nike – Global Footwear Planning, Portland, OR February 2001 – August 2001
Developed, programmed and implemented several databases to automate data extraction from ORACLE data warehouses using PL/SQL, T-SQL, DTS and Visual Basic for Microsoft Office Suite. Designed database application to track global products and shipping dates. Developed, coded and tested “New Models New Colors” report at Nike. Analyzed production Oracle database data model and PO system and developed new applications. MS Access applications, BRIO reports and Excel spreadsheets with Pivot tables were created automatically using VB & VBA to increase productivity. Converted old Access reports to BRIO. Light use of Business Object to work on smaller databases.
Manager, Information Services
Westwood-Swinerton Construction, Portland, OR 1987 – 2001
Managed daily administration of Novell network for 80+ users. Designed, programmed and implemented several database applications using Microsoft Access, VBA and SQL Server 7 with T-SQL. Planned, designed and implemented job costing and inventory control system. Designed a database application to track all computer inventory, established fee schedules, produced monthly invoices for rental/purchases. Supported the I.S. department as a profit center and improved efficiency in the marketing, safety and finance departments. Project Manager and Team Leader for several network and software program conversions. Used MS Project to keep project on schedule.
Contact this candidate