SEARCH

Database Analyst Resume Example

Resume Score: 80%

Love this resume?Build Your Own Now
DATABASE ANALYST
Summary

Rahul Singh has 8+ years of experience in Data Integration , ETL development ,Database Administration and Data Engineering roles with expertise in Migration of various Databases and ETL work flow to Teradata . He has been working on Teradata Database from last 8 years and has been exposed to various projects which required quick learning and analytical skills. Having worked as both Database administrator and ETL developer in the later half of his career he is meticulous in administering the Database and understanding the business requirement and implementing the technical solutions. He is also skilled in reporting tool like Tableau and scripting tool like unix shell scripting. Having more than 6 + years of experience in client facing roles he is well versed in leading and taking ownership of projects with deligent customer delivery.

Skills
  • Teradata Database (Teradata 12- Teradata 16.10)
  • TPT , BTEQ, TTU, Teradata Stored Procedures
  • ETL & Datawarehousing
  • Project Management
  • IBM Information Server (Datastage)
  • Informatica
  • Tableau Dashboard and Reporting
  • SQL and Advanced SQL
  • Amazon Web Services
  • Big Data
  • Unix shell scripting
  • Control M , Autosys
  • DB2 , SQL Server , Oracle
  • Erwin Data Modeler
  • Hue
  • Apache Hive , HiveQL
  • Pig Latin
  • Cloudera
  • Performance Tunning
  • SAS Procedure and Macros
Experience
Database Analyst | 03/2020 to CurrentWells Fargo - Charlotte, NC
  • Working on the Encryption of all the Sensitive and Non Sensitive customer data using third party encryption Algorithm in Teradata.
  • Determined changes in physical database by studying project requirements and characteristics such as location, amount of space and access methods.
  • Well-versed with ER & Dimension modeling.
  • Design Data Models using ERwin Data Modeler tool.
  • Manipulated data using pivot tables, pivot charts and macros in Excel.
  • Architect the ETL, ELT process and database standards and created source to target mapping documents for Development team.
  • Extensive Experience in using Fast Load, Fast Export, TPT, TPump, Multi Load and BTEQ to load/extract data into Teradata warehouse. Well versed with Teradata Manager Suite & Teradata Analytical Suite, Performance Monitoring (PMON) & View Point, Statistics and Alert management. Worked on Teradata Virtual APP Node servers.
  • Produced statistical reports documenting business efficiency and performance.
  • Extensive Experience in database design (Teradata, Oracle and SQL Server). Strong understanding of Star and Snowflake schemas. Extensive experience in creating database objects, including Triggers, Cursors, Stored Procedures and Materialized Views etc.
  • Used data to create models depicting trends in customer base.
  • Directed development of project scope, including estimates, budgets and schedules.
Lead Teradata Consultant | 06/2017 to 03/2020CGI - Lafayette, LA
  • Configuring Teradata Database for Customer Messages and Storing the Healthcare Information in Teradata Table.
  • Capturing the User responses and storing the same in Teradata Tables.
  • Developing Complex code using various Analytical function based on user responses and interaction ,making changes to generate user stories and customer reports to send new opportunities .
  • Responsible and involved in Setting up the Teradata database, users, Roles and Profiles.
  • Worked on giving Access Rights to users on Insert and Select on Database and also used Teradata Administrator for finding out different Rights held by the user.
  • Development of complex business OLAP sql queries for reporting and creating Dashboards using reporting tools like Tableau.
  • Designing and Deploying Teradata Customer Interaction Manager jobs (CRM) through Control M scheduler based on their dependency.
  • Running the scheduled Control M jobs based on source to target dependency and meeting the SLA provided .
  • Performance Tuning using the Teradata Viewpoint and Teradata Active System Management to filter the bad running queries .
  • Performance Tuning of long running queries to improve their performance without changing the underlying basis of the code.
  • Knowledge and worked on Backup and Recovery on TARA Server.
  • Worked on Code Review by using Teradata Statistics wizard.
Technical Consultant | 05/2012 to 05/2017Teradata Corporation - Mumbai, Maharashtra
  • Worked Closely with Data Integration team to develop ETL solutions using various ETL tools like (Informatica , Data stage and Teradata tools Utilities) .
  • Migrating DB2 Data Marts and Subject area codes in Teradata Environment using Datastage ETL and Teradata Database.
  • Designing and Deploying Datastage jobs in Control M scheduler based on their dependency.
  • Worked on Migration of complex cursor based Oracle Stored Procedures into Teradata and converting cursor based procedures as set based to hit parallelism.
  • Developing BTEQ mappings and workflows based on requirement,unit testing and supporting the testing in other environments, understanding functional Requirement and taking the queries to the business and get it clarified.
  • Loading and unloading Teradata tables using Mutlioad , Fastload , Fastexport and BTEQ export utilities scripts .
  • Worked on Migration of legacy SQL server to Teradata and loading files generated from SQL server into Teradata using Multiload and Fastload scripts .
  • Migrated SAS procedures to Teradata for statistical reporting.
  • Worked on tuning the SAS code and convert the same in Teradata SQL.
  • Write SAS reports in BTEQ and analyze the reports for business users.
  • Performance tuning for 22 BTEQ running within time window SLA given by the client and successfully achieving the same.
  • Creating Semantic Layer views based on multiple source tables and deploying the same in QA and Production for generating Microstrategy reports .
  • Loading tables from Oracle to Teradata using Fastclone tool.
  • Worked on development and testing of replicating file writing oracle stored procedures functionality in Teradata using a mixture of Teradata Stored procedure , Teradata Parallel Transporter and unix shell scripts which enabled file writing.
  • Worked on Migration of Teradata 13.10 to Teradata 14 database .
  • Scheduling Jobs in Autosys based on box numbers given and running the same
  • Generate weekly , monthly and quarterly spaces , CPU and i/o reports for the client and perform backup and restore activities .
  • Perform basic DBA activities like create users , roles and profiles .
  • Collect stats on Teradata Tables based on recommendations.
  • Grant and revoke privileges for users in case of unsolicited activities if reported.
  • Support User Acceptance Testing and Pre-Production support activity.
  • Responsible for managing the Data Mover Jobs.
  • Installed Teradata Query Grid to unload and load data from HDFS to Teradata.
  • Monitoring the Database through Teradata View point.
Education and Training
Mumbai University - - Mumbai | Bachelor of ScienceInformation Technology, 06/2011
Activities and Honors
  • Awarded as Employee of the Quarter 2015 in Teradata.
  • Client Appreciations email on supporting Black Friday sales activities
Certifications
  • Teradata Certified Professional.
  • Teradata Certified SQL developer
  • Teradata Certified Specialist
  • Amazon Web Services Solutions Architect
Personal Information

Father's Name : Jayprakash Singh

Date of Birth : 4th Sept 1989

Sex : Male

Nationality : Indian

Marital Status : Married

Interests

Playing Table Tennis

Cricket

Soccer

Listening to Music

Languages

English, Hindi, Marathi

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

Companies Worked For:

  • Wells Fargo
  • CGI
  • Teradata Corporation

School Attended

  • Mumbai University

Job Titles Held:

  • Database Analyst
  • Lead Teradata Consultant
  • Technical Consultant

Degrees

  • Mumbai University - Mumbai | Bachelor of Science

Similar Resumes

View All
Database-Analyst-resume-sample

Database Analyst

ORACLE Corporation RMAN Task Force

Pittsburgh, Pennsylvania