Data Analyst
Resume:
SUSAN SIEGEL
Atlanta, GA
SUMMARY:
• Business Intelligence Business Analyst
• 16 years of Business Intelligence in Enterprise Data Warehouses and Reporting experience including 4 years of MicroStrategy; has been using SQL for 15 years
• Extensive experience with business and functional requirements gathering and gap analysis utilizing one-on-one interviews and group interviews/sessions
• Skilled at creating mock-ups
• Has worked with both canned and ad-hoc reporting.
• Experience includes User Acceptance Testing and Project Coordination
EDUCATION:
University of Georgia, Athens, GA
BBA/MIS (Management Info Systems)
CERTIFICATIONS / TRAINING:
• Guru Software Services: Course in Oracle Data Base Administration including Oracle Developer 2000 (Forms 5.0, Reports, and Graphs), PL/SQL and SQL
• Microsoft Technical Education Center: TCP/IP for WINNT 4.0
• Ohio Certification Lab: Certified in the installation of all Brio products
• On-line Data Modeling course, University of Texas in Austin, Info Technology Services, Windows Services
• Querying and Reporting using SAS Enterprise Guide – Introductory course to using the analytical Windows application for data access, analysis and reporting
• 2011 Microsoft SQL
PROFESSIONAL EXPERIENCE:
Comet Global Consulting 08/2015 – Present
Business Intelligence Analyst
• Analyze data that is captured from Pega Software from Verizon Call Centers for predictive analytic purposes.
• Use Teradata to write SQL scripts for pulling offer and disconnect data into Excel spreadsheets.
• Create pivot tables and charts to analyze Verizon’s data in Excel.
• Analyze statistical findings on Call Center results for offers presented by agents to save potential disconnect customers.
• Present insights to Verizon by summarizing findings in PowerPoint.
• Modify the values of the algorithm in the ‘Prioritization Template’ to reorder the ranking of offers presented to customers by Verizon retail and care centers based on interactive history with customers.
Carter’s 03/2014 – 08/2015
Business Intelligence Analyst
• Involved with the Canada Business Enablement project to consolidate all the reports from current Oracle Discoverer Plus and Business Objects platform to a more functional MicroStrategy/Netezza platform.
• Edited and ran new MicroStrategy reports and compared to existing to ensure the functionality matches the requirements for Canada.
• Updated JIRA tickets to match evolving business requirements and to assign tickets back to developers with fix requests or approvals as reports are tested.
• Analyzed and resolved user Supply Chain reporting issues and defects as they are assigned.
AutoTrader 06/2013 – 03/2015
Business/Data Analyst – Contractor
• Met with enterprise business owners to understand and document their reporting needs.
• Analyzed, prepared and presented business and functional requirements documents for technical details that explain how the business requirements will be satisfied using MicroStrategy reporting.
• Created tagging specifications that identify Autotrader.com website components and help to track site activity such as click counts, impressions, referring and request pages, unique visitors, etc.
• Built reports and demonstrated attributes, filters and metrics that the business user will use to satisfy functional requirements.
• Created User Acceptance Test plan by documenting use cases and demonstrating reporting steps in MicroStrategy to receive business owner approval for deliverables.
• Liaison between project team including Data Architect, Quality Analyst, MicroStrategy Developer, ETL Developer, consumer site and business to ensure the team understands the requirements and delivers what the business expects.
• Orchestrated meetings and technical reviews to keep the project moving and ensure all team members are on the same page.
• Created and ran SQL statements in Oracle using PL/SQL and Netezza using Aginity Workbench to understand table relationships and document where the metrics will be sourced from.
AT&T Retail Sales Operations 10/2012 – 02/2013
Sr. Data Analyst – Contractor
• Data Mining and Data Analysis
• Created complex Teradata SQL queries to analyze data and answer business questions.
• Presented business anomalies and daily sales operations analysis to management using Excel reports.
• Produced PowerPoint presentations that outline new processes and systems for data management.
The Weather Channel 12/2011 – 10/2012
Data Integrity Analyst – Contractor
• Tested the implementation of a new Operations Management System called Operative to ensure that data files passed correctly from the application through Staging and Target tables in the ODS via the Talend ETL tool.
• Ensured that transformations in Talend from the source data result in the expected data changes in the target tables and meet the specified business requirements.
• Utilized backward engineering from Talend to write mapping documents that capture the source and target fields, data types and transformations that occur on all jobs to ensure the mappings match the data results.
• Reported defects via the JIRA tool for discrepancies between source and target or any issues that do not match expected results.
• Documented all test results in Quality Center including use cases for new and updated records, record reconciliation and mapping queries that compare source to target fields as well as processes that show counts and rejects for inserts, updates and deletes.
Northrop Grumman 01/2006 – 12/2011
Data and HL7Analyst
• Responsible for the integrity of the data and processes within BioSense, a national system and repository for Bio-surveillance, Bio-Terrorism and early detection of disease for public health situational awareness.
• Assumed responsibility for smooth data flow processes and accurate reporting within the Public Health Information Network (PHIN) and Common Data Store (CDS) at the Centers for Disease Control and Prevention (CDC).
• Developed an expertise in the HL7 health industry language used by hospitals and laboratories to enable centralization of disease specific data from around the country.
• Assisted with the documentation of data specifications, data mapping, data exception handling and minimal data requirements for presentation and implementation purposes.
• Created Use Cases in SQL Server to ensure that data has processed and passed all test scenarios between the data warehouse and marts.
• Checked data brokering processes within Web Logic and Rhapsody to reconcile transactions between source and target.
• Completed data mapping and gap analysis from HL7 message segments to a Common Data Store warehouse for various diseases including Tuberculosis, Hepatitis, and Lead.
• Compared counts and analyze data in SQL Server Management Studio for HL7 messages transported by the Data Message Brokering (DMB) database and received by the Common Data Store (CDS) warehouse.
Coca-Cola Company 03/2004 – 12/2005
Data Analyst – Contractor
• Responsible for the data integrity and technical support of POS retail link data from Wal*Mart within a Data Warehousing environment to be used in CARS (Customer Analysis Reporting System), a MicroStrategy backend software product with a Vision Chain front end tool.
• Identified and cleaned-up Wal-Mart data relevant to packages, products, brands and brand owners for Coca-Cola and competitive beverage categories from 10 countries.
• Developed SQL scripts to update, delete, insert and create records on the production Oracle database for CARS using TOAD and Queryman.
• Used Access to import data and create tables from Excel spreadsheets and link to tables on the CARS database for inserting and updating purposes.
• Created and maintained technical documentation for the data quality process.
• Created and sent detailed spreadsheets to nine countries to receive feedback on package and geographical hierarchies as well as data identification for specific products.
• Communicated with and supported CARS users from other countries for data integrity issues and troubleshooting.
• Tracked and improved data quality by creating and running reports via CARS.
• Performed quality assurance testing activities.
• Developed, wrote and maintained test plans, test cases and test data.
• Identified defects as a result of testing.
BellSouth 06/2002 – 02/2004
Data Analyst – Contractor
• Ensured the data integrity of incoming and outgoing data for reporting via the Brio and Business Objects reporting tools with views into Teradata data marts.
• Defined the data requirements from various BellSouth data sources that are necessary to fulfil BellSouth business requirements.
• Validated data and created data mappings in Excel from the source to the client's target entities and attributes on both Oracle and Teradata databases using SQL*Plus, Queryman or Brio tools.
• Defined the Transformation Logic in Excel using SQL for the developers to extract and load data from the source database to the tables in the target database on both Oracle and Teradata.
• Updated Logical Data Models and data flow charts in Erwin and Visio to include new entities and attributes.
• Created Logical Data Models and data flow charts in Erwin and Visio to be translated into physical data marts.
• Analyzed, gathered and interpreted data from Oracle and Teradata via SQL*Plus, Queryman, and Brio tools to satisfy reporting requirements.
• Participated in pre-production application QA of reporting data on Business Objects.
Brio Software 06/2000 – 04/2002
System Consultant
• Installed and demonstrated the analytical application software and business intelligence tools for pre-sales consulting and support on targeted strategic accounts and partnerships.
• Identified customer requirements and appropriate data sources for extracting, cleansing and loading data (ETL) for demo purposes.
• Performed gap analysis between the customer’s source data and Brio’s staging data requirements.
• Aided in data modeling, database development, and software configurations for IBM Proof of Concept.
• Participated in the documentation of technical processes and requirements for implementation and use of various software modules in Brio Performance Builder.
• Developed partner relationships by demonstrating Brio’s portal and reporting software live and over the World Wide Web.
ChoicePoint Inc. – eCommerce Division 08/1999 – 06/2000
ETL Specialist / Jr. Oracle DBA
• Responsible for integrity, cleansing, transformation and loading of data as well as updates, inserts and deletions on development, quality control and production databases.
• Updated and modified production databases that could be viewed on the Searchpointe Website for customer investigation of doctors and chiropractors.
• Participated in the installation and support of the MicroStrategy DSS Tools used to load the eCommerce Data Mart and automate faxes and emails to the Federal Government via the Broadcaster Tool.
• Analyzed and successfully reloaded rejected data records into the database.
• Administered Oracle on Sun Solaris UNIX platforms.
• Created Oracle instances, control files, rollback segments, table spaces, tables, indexes, primary and foreign keys and triggers based on specifications.
• Created users, passwords, public synonyms, assigned roles, and granted connectivity rights to the databases.
• Maintained and updated Oracle data models within the Erwin Data Modeling tool.
Contact this candidate