SEARCH

Senior Technical Data Analyst Consultant Resume Example

Resume Score: 100%

Love this resume?Build Your Own Now
SENIOR TECHNICAL DATA ANALYST CONSULTANT
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.
  • Programming Languages: PL/SQL, SQL, C++, Java, UNIX, Visual Basic.
  • Database: Teradata, Oracle 8i/9i/10g/11g, SQL server 2003/2005/2008, SAS, MS Access.
  • Scripting: Python.
  • Reporting tools: Hyperion, Brio, Omniture, JMP, Tableau, SAS and Excel.
  • ETL tools: Teradata FastLoad, Teradata FastImport, SQL Server, SAS Enterprise Guide.
  • Other tools: TOAD, SAS Enterprise Guide, SAS Enterprise Miner, Putty, Cygwin, Filezilla, WinSCP.
  • Web Technology: HTML, XHTML, XML
  • Design Methodologies: MS Visio, Erwin
Work Experience
Company NameAugust 2011 to CurrentSenior Technical Data Analyst Consultant
City, State
  • 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.
Company NameJune 2008 to July 2011Senior Marketing Data Analyst Consultant
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.
Company NameMay 2007 to April 2008Data Analyst Consultant
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.
Company NameJanuary 2007 to April 2007Business Data Analyst Consultant
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
Institute of Technology (SUNY)December 2008M.S: Computer ScienceCity, StateComputer Science
Mumbai UniversityMay 2004B.S: Computer EngineeringCity, IndiaComputer 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
Build Your Own Now

DISCLAIMER

Resumes, and other information uploaded or provided by the user, are considered User Content governed by our Terms & Conditions. As such, it is not owned by us, and it is the user who retains ownership over such content.

Resume Overview

School Attended

  • Institute of Technology (SUNY)
  • Mumbai University

Job Titles Held:

  • Senior Technical Data Analyst Consultant
  • Senior Marketing Data Analyst Consultant
  • Data Analyst Consultant
  • Business Data Analyst Consultant

Degrees

  • M.S : Computer Science
    B.S : Computer Engineering

Similar Resumes

View All
Senior-Technical-Solutions-Consultant-resume-sample

Senior Technical Solutions Consultant

San Francisco, California