SUMMARY:

• Experienced data professional with over 8 years in business/data analysis, reporting analysis, and project management.
• Strong analytical, quantitative, and problem - solving skill sets.
• Demonstrated excellence in strategic thought leadership, stakeholder management, customer service, change management, and building productive partnerships at project level.
• Easy going personality with ability and get along well with people from various backgrounds.

EXPERTISE AREA:

• Requirements gathering
• Quality assurance
• Training manual development
• Database design
• Ad-hoc data queries
• Production report creation
• ETL
• Query and report generation
• Production report implementation
• Data feed monitoring
• SQL familiarity
• Data dictionaries
• Data mapping
• Relational Databases
• ER diagrams
• Data conversions
• Analytical projects
• Data Transformation Services
• Data cleanup
• Technical and user documentation
• Master of Arts in Mathematics
• Data set updating
• Report mart functional specs
• Bi-lingual: French and English
• Data Set maintenance
• Troubleshooting and bug identification
• Word, Access, Excel, PowerPoint, Project, and VISIO

PROFESSIONAL EXPERIENCE:

Business Analyst, Reporting Analyst, Project Manager

Confidential, WA

Responsibilities:

• Requirements gathering experience.
• Wrote business requirements and technical specifications to bridge the gap between management and the technical team.
• Did Gap Analysis to show the comparison of actual performance with potential performance.
• Reports were developed in Access and Excel tables.
• Customer service experience with clients.
• Did Data conversion between the old and the new database.
• Provided Metrics.
• Manipulated large customer’s lists for marketing campaigns.
• ETL (Extract, Transform and Load) data.
• Direct Marketing
• Processed insurance claims from patients against Confidential .
• I interacted with the accounts receivable team to monitor the progress we were making with our New Personnel database.

Business Analyst, Reporting Analyst, Project Manager

Confidential, Redmond, WA

Responsibilities:

• Collaborate with business stakeholders to identify and document business needs.
• Requirements gathering experience.
• Coordinates upgrades and rollouts of projects
• Did Gap Analysis to show where the business was compared to where it wanted to go in the future.
• Wrote business requirements and technical specifications to bridge the gap between management and the technical team. Expert problem-solving and time management to keep the project on time and on budget. Support multiple projects using Confidential Office tools.
• Write and execute user acceptance test plans and cases.
• Prepared and obtained approval of system documentation, followed standard practices and procedures in analyzing and researching data and generating reports.
• Support activities related to development, distribution, and analysis of forecasting & related Metrics Reporting at a national level and managed releases of new software as necessary.
• Customer service experience with clients all over the world.
• Reports were developed in Access and Excel pivot tables, a standard set of queries against SQL Server databases, creating and formatting Excel/Access reports.
• Proficiency in office tools like PowerPoint, Word, Excel and experience in documenting processes and procedures and creating training manuals, collecting requirements by engaging with business owners and providing support to end users of tools/processes.
• ETL
• Manipulated large customer lists for marketing campaigns.
• Worked in the procurement department and worked on the current Confidential PO system assigning permissions and rights to new/current employees. I also help at the help desk to resolve issues with the PO system (access, permissions, content…) and escalated issues to higher levels if necessary.
• Performed Work Flow Analysis and Infrastructure Designs using VISIO.

Project Manager, Business Analyst

Confidential, Seattle, WA

Responsibilities:

• Project Management / Business / Data Analysis on the Utility Pole Inventory project.
• Quality control, Data Analysis and verification, database updates.
• SQL queries, reports and matrices for various departments, using Excel, Access.
• Tracking issues and resolving discrepancies between the data from the field and the data in the current database.
• Wrote all documentation for the Utility Pole Inventory project.
• Experience in data manipulation, data entry, data scrubbing and sleuthing around to solve various data mysteries, ETL.
• Customer service experience with clients outside of Confidential .
• Did Data conversion between the old and the new inventory database.
• Used VISIO to show relationships between field database and in-house database.
• ETL (Extract, Transfer and Load)
• Manipulated customers lists for marketing campaigns.
• I also interacted with the accounts receivable to monitor the progress we were making with the new Utility Poke Inventory project. It was very profitable.

Business/Data Analyst and Project Manager

Confidential, Redmond, WA

Responsibilities:

• Business Analyst and Project Manager for the Confidential tool for Confidential Web Advertising.
• Performed Data Analysis, Marketing and SQL Analysis, logging Issues, and investigated errors.
• Provided customer support for the Confidential company users and Confidential employees.
• Defined, processed, and created reports to sustain application.
• Managed new releases of the Confidential tool and performed User Acceptance Testing (UAT).
• Customer service experience with clients from Confidential .
• Work Flow Analysis and Designs.
• Developed functional specifications.

Business Analyst

Confidential, Redmond, WA

Responsibilities:

• Retrieved data, generated reports, performed report analysis and data Analysis and validation using SQL and Access.
• Worked with various teams gathering information to perform data mapping, data cleansing, data migration and integration of information. Performed Work Flow Analysis and Designs.
• Provided executive summary of internal reports to executive level. Ran reports from Business Objects.
• Provided Metrics.

Data Analyst

Confidential, Seattle, WA

Responsibilities:

• Worked on data call reporting for the Statutory Reporting group and the Statistical reporting group.
• Used homegrown systems to do data retrievals for the groups. Also used Excel & Access.
• Reporting Analysis, Documentation, Specifications.
• Performed Work Flow Analysis and Designs.

Data Analyst, Project Manager

Confidential, Seattle, WA

Responsibilities:

• Marketing Data Analysis. Worked with MS Excel pivot tables, MS Access to analyze data from different sources.
• Automated weekly and monthly dashboards to show effects of marketing campaigns.
• Performed Work Flow Analysis and Designs.

Business Analyst, Marketing

Confidential, Sammamish, WA

Responsibilities:

• 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 could consume.
• Sound business related skills including excellent problem solving, team building, judgment and decision making skills. Cross-group collaboration.
• ETL
• Direct Marketing
• Manipulated large customers’ lists for marketing campaigns.

Business Analyst, Project Manager

Confidential, Frederick, MD

Responsibilities:

• Worked with definitions of requirements for point-to-point translations using tools like data dictionaries.
• Managed relationships su rrounding 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 Confidential Project to keep the testing part of the New User Interface program on time and on budget.

Project Manager, Business Analyst

Confidential, Lanham, MD

Responsibilities:

• Key member of the Procter and Gamble application software and database team automating cross company, multi-brand, data warehouse and data mart solutions.
• Customer service experience with over 25+ products from Procter & Gamble.
• Worked closely with business analysts, programmers, project managers, project leaders and client representatives to assure on-time delivery and data reliability using Confidential Access, ETL, Project and Visio, SQL.
• Did Data conversion between the old and the new marketing database.
• Developed scope of work, functional specifications and requirements for a quantitative marketing database for P&G. Developed work flow analysis and designs using Visio.
• Performed Data Analysis to validate the data before uploading in data warehouse.
• 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 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 using Confidential Word & Excel.
• Did copy editing for the materials that went out to the client.
• ETL
• Managed customer lists
• Direct marketing for the marketing campaigns.
• Responsible for data preparation, data analysis, campaign execution, Data Center, customer segmentation and campaign management.
• Coordinated data feeds and updates.

Marketing Data Manager, Project Manager

Confidential, Columbia, MD

Responsibilities:

• 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 Confidential 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 ETL, SQL. Confidential Access, VBA and DTS packages.
• 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.
• ETL
• Direct Marketing
• Manipulated large customer’s lists for marketing campaigns.

Business / Applications Systems Analyst

Confidential, Portland, OR

Responsibilities:

• 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.
• Designed, wrote, and implemented a Bill of Material database application interface between Confidential, Access and Essentus, a supply-chain management solution program.
• Kept the project on schedule with MS Project.

Programmer

Confidential, Beaverton, OR

Responsibilities:

• Contract for Alaska Tanker. Modified and added new features to a current Visual Basic application.

Marketing Database Analyst

Confidential, Portland, OR

Responsibilities:

• 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.
• 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 SQL queries for Access reporting from the Siebel database and the new Marketing Database Warehouse.

Database Analyst, Programmer

Confidential, Portland, OR

Responsibilities:

• Update, validate, and evaluate capacity models with the latest internal information to ensure accurate reporting.
• Developed, programmed and implemented several databases to automate data extraction from Oracle data warehouses using ETL, DTS, Access and Visual Basic for Confidential Office Suite.
• Designed database application to track global products and shipping dates.
• Developed, coded and tested "New Models New Colors" report at Confidential . Big “Win”.
• Analyzed production Oracle database data model and PO system and developed new applications.
• Converted old Access reports to Brio.
• Light use of Business Objects to work on smaller databases.

Manager, Information Services

Confidential, Portland, OR

Responsibilities:

• Managed daily administration of Novell network for 80+ users.
• Accounts Payables Manager for hundreds of subcontractors. (Liens). Also did Accounts Receivables.
• Designed, programmed and implemented several databases applications using Confidential Access.
• Planned, designed and implemented job costing and inventory control system.
• Designed a database application to track all computer inventories, established fee schedules, and produced monthly invoices for rental/purchases of computer equipment.
• Supported the 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 MICROGRAFX Designer to create a floor plan of the building showing all the walls, network connections, phone extensions…. (Very similar to Visio).