Senior Data Analyst Resume Examples

senior data analyst

  • Responsible for analyzing ETL requirements, interpreting data and creating mapping specification between source and target systems
  • Responsible for designing, developing and implementing extraction jobs, transformations to load data from different sources to a data warehouse
  • Responsible for testing and validation of data flows to ensure it conforms to the business requirements and design specifications
  • Making Enhancements to the existing mappings and reports by applying business rules as required by the client
  • Performing data quality testing and performance testing to get it validated from code perspectives before delivering it to business
  • End to End loading, analyzing the existing code and solving data issues reported by the customer
  • Define RDBMS models and schemas. Work in performance tuning of database schema, migrations and slowly changing dimensional databases 

senior data analyst

  • Creating databases of prospects to target for campaigns who are compliant is most important. My job profile is very critical and consists of the following day-to-day tasks:
  • Understanding the need for the customer and appropriately creating a corresponding target database.
  • Each campaign is time-bound and the data must be available at a moment’s notice, needless to say, my role requires me to have superior typing skills with precision along with proficient usage of the computer and basic applications.
  • Extensive knowledge of MS Excel 2007 and above. Can handle the execution of most formulas and functions.
  • Analyzing the data from multiple sheets for errors along with reporting and rectifying.
  • Accurately entering information into various company in-house programs and databases.
  • Keeping sensitive customer or company information confidential is our key to success; at Paperpicks we ensure the data is secure. 

senior data analyst

  • Interacting with business stakeholders to understand their decision making parameters, analyzing the available data to build Tableau Dashboards and managing the delivery.
  • Translated business logic from one system (Excel, Teradata etc.) into Alteryx in a quick and accurate manner.
  • Built dashboards using techniques for guided analytics, interactive dashboard design and visual best practices.
  • Done Tableau server multi-node upgradation from 10.2 to 2018.1
  • Involved in troubleshooting of performance issues, which were associated with tableau reports.
  • Extensively used Tabadmin and Tabcmd commands in creating backups and restoring backups of Tableau repository.
  • Extensively used REST API to create a connection between Alteryx and Tableau Server

senior data analyst

  • Senior Data Analyst in Mortgage Integrated Data Environment Team for CORE and Loan Processing System application.
  • Automated release validation process involving manual effort, automation sends notification of any code deployment failure with annual savings of $8980.
  • Primary developer for project preventing loan purchase by parties on exclusionary lists published by GSE.
  • Developed an automation process for daily batch monitoring which sends hourly notifications of batch run status to concerned developers.

senior data analyst

  • Analyse,modify,process Airway bills.
  • Interact with clients from Thailand & China via voice & blended process.
  • Management disputes .
  • Quality assurance.
  • Profecient with International & Domestic aviation softwares like IATA, PING, TIFFA.

senior data analyst

  • Performed data extraction, loading, data cleaning, data preparation, data imputation & data visualization. 
  • Computed tests like chi square test & T test.
  • Identified KPI of Call Centers to measure individual performance and reduce cost of calling. This effort also reduced the need for manpower resulting in significant cost savings
  • Conducted Recency Frequency monetary (RFM test) using Cluster Analysisto segment the customers into (1) Willing to pay & able to pay (2) Willing to pay & unable to pay (3) Not willing to pay & not able to pay.
  • Using machine learning algorithms , decision tree and neural networks , the team reduced the calling costs up to 15%
  • Generatedsentiment analysis,to compute the polarity between positive, neutral & negative response from customers. 
  • Worked on Twitter Analysis, to know about the customer background, his spending likes & dislikes, and other behaviours.

senior data analyst

  • Investor Reports – Reports holistic figures to founders and create intricate data such as retention and activation cohorts for the investors.
  • API Integration & Calls –  Using Python Requests library, created scripts to call various network API to make validations operations smoother and fast.
  • Response Code Checker- Created a tool to validate landing page for vouchers using Python Requests library.
  • Data Extraction (MySql) – Developed custom Procedures to extract data according to the data needs of marketing teams.

senior data analyst

  • Restricted data for particular users using Row level security and User filters.
  • Extensively used Alteryx for data preparation which includes data cleansing, data manipulation to create TDE (Tableau Data Extract) for data visualization and created reports using Alteryx designer.
  • Created macros in Alteryx designer to make a connection between tableau server and Alteryx using REST API to pull all the reports, dashboards, data sources from Tableau server to convert into PDF formats to send to the end users.
  • Created macros in Alteryx designer to convert the reports and dashboards from tableau server to PDF format using 3rd party batch files.

senior data analyst

  • Lead and supervise project operations and customer success team.
  • Evaluate customer requirements, sales campaign feasibility, analyze campaign performance data, and dynamically optimize campaign structure.
  • Coordinate with Engineering, Sales and Customer Success team to provide streamlined customer experience.
  • Identify the need for initial or supplemental project resources.

sr. data analyst

  • Understand business processes to build scalable and sustainable data platforms
  • Complex Data Modelling, Data Warehouse Design & Performance Optimization
  • Techno-functional solutions for different business applications in BI & Data Warehousing space
  • Created batch scripts to trigger the Alteryx workflows on a daily and weekly basis.