Senior Technical Data Analyst Consultant resume example with 14 years of experience
JessicaClaire
Montgomery Street, San Francisco, CA94105609 Johnson Ave., 49204, Tulsa, OK
Home: (555) 432-1000
Cell:
resumesample@example.com
Career Overview
Senior data analyst with 8+ years experience in Business/Data Analysis, Data Profiling, Data Mining and Reporting. 8+ years in PL/SQL and T-SQL programming. 7+ years experience with Oracle database. 6+ years experience in SQL Server 2005/2008/2012. 4+ years experience with SAS and Teradata Proficient in advance Excel functions, pivot, graphs, vlookup and macros. Knowledge of Big Data Ecosystem such as Hadoop, Hive and HDFS.
Qualifications
Operating System: Windows XP/7/8/10, Ubuntu 12.04, Mac OS.
Other tools: TOAD, SAS Enterprise Guide, SAS Enterprise Miner, Putty, Cygwin, Filezilla, WinSCP.
Web Technology: HTML, XHTML, XML
Design Methodologies: MS Visio, Erwin
Technical Skills
Accomplishments
Work Experience
Senior Technical Data Analyst Consultant, 08/2011 to Present C.H. Robinson Worldwide, Inc. – Orlando, FL,
Involved in requirement gathering, creating Function Requirement Document, Technical Design Document, Process Flow documents, Data Dictionary using MS Words, MS Excel and MS Visio.
Extensive experience in writing SQL, PL/SQL, T-SQL on Teradata, Oracle and SQL Server 2008/2012 and SAS Database Created and maintained Supply chain reporting.
Automated new and existing reports by using Teradata BTEQ batch scripts.
Created reports in SAS 9.2.
Performed ETL from Text/CSV to SAS and SAS to Teradata/Oracle.
Used SQL Server, Teradata FastLoad, Teradata FastImport for ETL Monitor UNIX production jobs through putty.
Experience in UNIX Scripting.
Performed GAP Analysis between processes, data and reports.
Performed UAT on the production and staging database and documented the UAT results for Business.
Provided SAS and SQL training non-technical members of the team.
Experience using business analysis and requirements modeling tools, such as data flow diagrams, relationship data models, XML modeling, business process modelling.
Conduct data analysis in support of applications and projects, including identifying and documenting business rules, data needs and data specifications.
Perform Technical Data Profiling including the development of baselines, statistics and aggregated data attributes.
Senior Marketing Data Analyst Consultant, 06/2008 to 07/2011 Royal Caribbean Cruise Lines Ltd – City, STATE,
Worked as a part of Celebrity Cruises CRM team which maintains 80+ million customer and transactional data.
Created SAS Marketing data models for marketing by using Proc SQL programming in SAS.
This data model helped to predict the probability of what segments of customers would choose type or destination of cruise.
Performed QA and ad-hoc analysis on customer and transactional data in Oracle and SQL Server using SQL,PL/SQL and T-SQL.
Worked with direct marketing team to provide potential customer data for their Email and Direct Marketing campaign.
Worked with 3rd party travel agents to update RCCL customer database by importing customer data in flat files into oracle database.
Provided idea's and strategies to indentify target customers data for a marketing camapigns.
Created reports and analysis on the performance of a marketing campaign by identifying targeted audience for a marketing campaign Vs total bookings achieved from the original data.
Created reports on the Celebrity.com website performance using Omniture site catalyst.
Created Ad-hoc and scheduled reports on customer profiles and behavior, sailing and transactional data.
Supported different teams such as Sales, Air and sea, Customer care with reporting, ETL, Analysis and testing.
Created reports on customer info, cruise sailings, web bookings etc.
Used reporting tools such as Hyperion, SAS, JMP, Brio, Omniture and Excel.
Automated reports in SAS and Hyperion.
Provided basic SAS Training to different teams within Royal Caribbean Cruise lines Created presentations slides, for the senior management.
Data Analyst Consultant, 05/2007 to 04/2008 Choice Point Inc – City, STATE,
Performed Data Analysis and Data Validation by writing PL/SQL Queries on TOAD against the Oracle Database.
Created Data Dictionary, Data Mapping and Used cased documents on various Data sets like Government records, Public Records, Corporate records etc using Excel.
Performed Data Modeling by creating Logical and Physical Data Model of the database system.
Analyzed and created multiple ad-hoc and scheduled reports for users based on User Requirements.
Created ER diagrams, Data Flow Diagrams and Data Mapping documents using MS Visio and words Interacted with users for verifying user requirements, managing change control process, updating existing documentation.
Worked extensively with Flat files such as .txt, .csv, .xml.
Performed Data Mapping and generated reports on the mapping results using Excel.
Developed, tracked and managed Issues Log created during the test phase.
Managed and tracked defects using Quality Center.
Business Data Analyst Consultant, 01/2007 to 04/2007 Snap-On Business Solutions – City, STATE,
Responsible for writing Functional Requirement Specifications and User Requirement Specification.
Interacted with users for verifying user requirements, managing change control process, updating existing documentation.
Wrote standard and complex SQL and PL/SQL Queries to perform Data Validation and Graph validation to make sure test results matched back to expected results based on the user needs.
Involved in QA check on Flat files my importing into SQL Server database and performing quality and volume checks.
Involved in Logical and Physical data modeling.
Created reports as per Business Requirements and developing drill down reporting.
Created process documents, reporting specs and templates, training material and slideshow presentations for the application development teams and managements.
Created and maintained process flow documentations with data flow diagrams.
Education and Training
M.S: Computer Science, Expected in December 2008 Institute of Technology (SUNY) - Utica, NY. GPA: Computer Science
B.S: Computer Engineering, Expected in May 2004 Mumbai University - Mumbai, GPA: Computer Engineering
Skills
Ad, application development, basic, Brio, business analysis, business process, C++, com, CRM, Customer care, Data Analysis, Data Dictionary, Data Modeling, Data Validation, Database, Direct Marketing, Documentation, Email, Erwin, ETL, senior management, XML, Functional, Government, HTML, Hyperion, Web Technology, Java, Mac OS, managing, marketing, MS Access, MS Excel, Excel, Windows XP, MS Words, modeling, Enterprise, Operating System, Oracle, Oracle 8i, oracle database, PL/SQL, Oracle and SQL, predict, presentations, processes, Programming, Python, Quality, QA, reporting, Requirement, Sales, SAS, SAS 9.2, scripts, Scripting, Specification, SQL, SQL Server, statistics, Supply chain, Tableau, Teradata, TOAD, training material, T-SQL, type, UNIX, UNIX Scripting, validation, Visio, Visual Basic, website, XHTML
Any information uploaded, such as a resume, or input by the user is owned solely by the user, not LiveCareer. For further information, please visit our Terms of Use.