We provide IT Staff Augmentation Services!

Senior Technical Data Analyst Resume

SUMMARY

  • 14+ years of Industry experience as Senior Technical Data Analyst and Teradata ETL Developer in Banking, Retail and Telecom domain.
  • Experienced in Data Warehousing projects, including Business requirement gathering, Development, Enhancement, Testing, Production support and Data profiling.
  • Extensive experience in writing of Business Requirements Document (BRD) and Functional Specification Document (FSD), Technical Requirement Documents and testing document.
  • Extensive experience on Enterprise Data Management Project for Data Lineage, created various ETL Data Mapping documents, Data Transformations, Metadata, Data Flow and Process Flow Diagram, Conceptual and Physical Data Model.
  • Excellent knowledge in Data Analysis, Data Validation, Data Cleansing, Data Profiling and Data Mining.
  • Excellent knowledge of Teradata architecture.
  • Outstanding in generating UML diagrams for Business Process Modeling like Use Case Diagrams (UCD), Activity Diagrams (AD), Sequence Diagrams (SD), Data Flow Diagrams (DFD), and Flow Charts (FC).
  • Expert in writing SQL queries and optimizing the queries in Teradata, Oracle, Microsoft SQL Server database.
  • Good knowledge of Star Schema/Snow flake schema, FACT & Dimensions tables, Physical & logical data modeling.
  • Extensively worked on Teradata SQL Assistant and Teradata Utilities like FASTLOAD, MULTILOAD, BTEQ, FASTEXPORT and TPT.
  • Strong experience in TERADATA SQL, Teradata Indexes, Subqueries, Indexes, Stored Procedures, Macros, Views, TERADATA OLAP.
  • Strong experience in data warehousing projects dealing with ETL (extraction, transformation and load) Ab Initio (Express IT), Informatica, Datastage8.0 ETL tool.
  • Extensively worked on Metadata tool Abi Initio - Enterprise Metadata Hub and Data Profiling Tool Data Discovery.
  • Extensively worked on analyzing relational databases using Tableau and creating spreadsheets and then of graphs.
  • Good knowledge of Python Identifiers, Indentation, Line Structure, Python data types, Tuples, operators Identifiers, operators .
  • Hands on experience in SAS ODS 9.2, Informatica PowerCenter 8.6, Mainframe, Data Quality (IDQ).
  • Proficient with Business Intelligence technologies and methods using Cognos8.
  • Excellent verbal, presentation and written communication skills.

TECHNICAL SKILLS

Database: Teradata, Oracle, SQL Server, DB2, MS Access

Data Modeling Tool: Sybase Power Designer 15

ETL/ELT Tools: Oracle Data Integrator (Sunopsis V4), Ab Initio(Express IT, Enterprise Metadata Hub), Informatica PowerCenter, IBM Datastage, Alteryx, SQL Developer

TERADATA- Tools & Utilities: Teradata SQL Assistance 13, SQL Developer, BTEQ, FASTLOAD, MULTILOAD, FASTEXPORT, TPT

BITool/Reporting Tool: Cognos8-Report Studio, MS Excel, MS Power Point, Tableau

Data Flow Diagram: Microsoft Visio 2010, ERWin

Business Skills: SDLC,Scrum/Agile Development Methodologies, Project management, Requirement Gathering, Process Documentation, Compliance data, Credit Risk data.

Data Mining Skills: Data Analysis, Data Profiling, Data Validation, Data Quality, Metadata

PROFESSIONAL EXPERIENCE

Confidential

Senior Technical Data Analyst

Responsibilities:

  • Extensively involved in Developing Data Management strategies for data lineage/metadata, data control data defect/issue.
  • Involve in data analysis, data profiling, metadata management, data governance in enterprise environment.
  • Involved in designing and building data quality implementation, monitoring and reporting.
  • Creating a complex SQL code, developing configuration, joins, filter criteria for data quality rules using Ab Intio Express IT and load data into Enterprise Metadata Hub.
  • Analyze and validate that the Enterprise Data Governance policy and implement the rules as per data quality dimensions for business requirements and propose alternatives where appropriate identifying data mismatch using complex SQL on various sources systems database Oracle.
  • Involved into coordinating with business partners to capture the business requirements and implement rules on core data elements.
  • Involved into data defect analysis into production environment.
  • Importing the EME Datasets and Data Profiler results having Issue code, Business Description, Technical Description, Total Record counts from EME to Technical Repository to show up the results in the Enterprise Metadata Hub.
  • Involved in Data Quality dimensions rules for completeness, accuracy, consistency and uniqueness.
  • Create various Data Mapping, configurations, rules transformations using Ab Initio Express IT tool.
  • Involved into Data lineage using Collibra Data Dictionary.
  • Involved in JIRA agile methodologies user case, ticketing system.

Confidential

Senior Technical Data Analyst

Responsibilities:

  • Creating, maintaining, and updating Customer Master Data for enterprise operations and marketing, reporting, and analytics purposes.
  • Involved into single interface for all adds/updates of customer information which involves the implementation of data quality assessment, data quality monitoring and the data rules involved in data analysis including data mapping, data modeling and data validation.
  • Queried relational databases using SQL in Teradata and DB2 database to resolve operational issue.
  • Developed a complex SQL code and parameterized it to use in the common code approach to avoid writing several SQL scripts for different source table/file formats.
  • Extracted data from DB2 database into different flat files, MS Excel, MS Access and transformed the data using Altreyx ETL tool and loaded into Teradata database for data analysis.
  • Involved into data warehouse strategies, design and data standards, data analysis, validation, cleansing, verification and identifying mismatch using complex SQL on various sources systems including Db2 and Teradata.
  • Worked on Teradata complex SQL using joins,index,subqueries, CSUM function and indexing PPI,UI,SUI.
  • Queried relational databases using SQL in Teradata and MS Access database on a daily basis to resolve operational Issues.
  • Developed various Dashboards using objects Tableau such as Chart Box (Drill Down, Drill up & Cyclic Grouping), List, crosstab reports.
  • Provide root cause analysis for defect remediation.
  • Provide and elicit business and technical requirements for projects that require Customer Master Data integration.
  • Create data flow diagrams, data dictionary, database normalization theory techniques, entity relation modeling and design techniques.
  • Created visually impactful dashboards in Excel for data reporting by using pivot tables and VLOOKUP.
  • Involved in Physical and Logical Data models using fact and dimension modeling for Suppression Data logic in Data warehouse.
  • Involved in Unit testing to check whether the data is loading into target, which was extracted from different source systems according to the user requirements.
  • Hands-on experience on Mainframe, JIRA.

Confidential

Technical Data Analyst

Responsibilities:

  • Designing, developing, expanding or modifying system to serve new purposes or improve work flow. Modify and customize applications, providing support using XML and SQL Queries.
  • Involved in testing, maintaining and monitoring computer programs and systems, including coordinating the installation of computer programs.
  • Developing system design procedures, test procedures as per the quality standards.
  • Responsible in suggesting data models changes at all levels including conceptual, logical, and physical for both relational and dimensional solutions.
  • Suggesting entities, attributes, and their inter-relationships and dependencies changes in 3N (3rd Normal Form) and dimensional formats.
  • Provide root cause analysis for defect remediation.
  • Provide and elicit business and technical requirements for projects that require Customer Master Data integration.
  • Create data flow diagrams, data dictionary, database normalization theory techniques, entity relation modeling and design techniques.
  • Involved into data warehouse strategies, design and data standards, data analysis, validation, cleansing, verification and identifying mismatch using complex SQL on various sources systems including Oracle and Teradata.
  • Doing analysis of for data lineage using Teradata Bteq, SAS Jobs/Scripts and XML.
  • Working on Information Analyzer for Column Analysis, Primary Key Analysis and Foreign Key Analysis. Performance tuning of SQL (Explain plans, Collect statistics, Primary and Secondary indexes).

Environment: GSMOS Tool, XML, MS Access 2010, Microsoft Excel, Microsoft Visio, Cognos Reporting

Confidential

Business Systems Consultant

Responsibilities:

  • Acts as a Compliance consultant between client area and technical organization by planning, conducting, and directing the analysis of the most complex, strategic, corporate-wide business problems to be solved with automated systems.
  • Provides technical expertise in identifying, evaluating, and developing systems and procedures that are cost effective and meet business requirements.
  • Applies knowledge of industry trends and technology to drive organizational change and position Confidential for the future.
  • Works with Global Sanction scanning groups to provide training, resolve questions, assess user needs, and recommend changes.
  • Participates in transforming strategic enterprise architecture and design principles into specific Teradata system requirements and specifications.
  • Recommends and initiates systems testing. Acts as the highest-level internal consultant within Teradata technology and business groups by re-engineering technical processes for greater efficiencies with significant impact to the business.
  • Working with Global Sanction Scanning Group as a compliance consultant.
  • Analyze gathered requirements data, verify requirements and create business requirement document (BRD).
  • Worked closely with project managers, business users and technical team to gather requirement and create functional specification document (FSD).
  • Involved in understanding of Sanctions rules (Vessel Rules, Word Combo etc.) for the application.
  • Supported Unit Testing and System Integration Testing (SIT) based on business requirements, Technical specifications and/or product knowledge.
  • Created tables, views in Teradata, according to the requirements.
  • Used Teradata Utility Fastexport for doing analysis of data.
  • Queried relational databases using SQL in Teradata and MS Access database on a daily basis to resolve operational Issues.
  • Learned terms compliance terms and worked on Watch list, alerts, Blocking, Rejecting, and Restricting Accounts, Account, Relationship or Transaction Screening.

Environment: Teradata 12, Oracle 10g, Microsoft Visio, Sybase Power Designer, Microsoft Excel

Confidential

Computer Programmer Analyst

Responsibilities:

  • Working on Enterprise Data Management project for EDM Standards & Policies with Anti Money Laundering(AML) group.
  • Interacting with business and technical staff and SME's of the various applications to understand the business and process flow.
  • Interacting with the Business Users for creating metadata of KBE’s, Technical Metadata such as server details and Definitional Metadata such as business name, data size etc.for various applications.
  • Analyzing data into Teradata Database verifies the KDE against prioritized KBE (Business definition)
  • Importing Data Linage documents, Metadata documents into standard InfoPortal template.
  • Doing analysis of data alterations using Teradata Bteq, SAS Jobs/Scripts and XML Files from system to system and creating Data Lineage mapping documents, transformation logic documents.
  • Interacting with application owners for data movement and creating Process and Data flow diagram using Microsoft Visio 2010 to show source/target systems, frequency of data, method of transformation etc.
  • Experience in translating business requirements into Conceptual and Logical Data Models using Sybase power designer 15.
  • Designed & Created Teradata SQL Queries in SQL Assistant and Oracle SQL in TOAD for data profiling.
  • Unit Test Cases (UAT) based on the KBE’s and verified the data quality rules.
  • Conducting Business Review meeting and IT SME review meeting.

Confidential

Senior Technical Consultant

Responsibilities:

  • Interacted with the Business Users to analyze the business requirements and transform the business requirements into the technical requirements.
  • Generated business requirement document, mapping document, technical specifications document, data quality reports, developed ad hoc reports.
  • Constructed context diagrams and data-flow diagrams based on a description of a business process.
  • Worked on Teradata FSLDM having Credit Risk data.
  • Loading data from Flat Files into the Staging area using Teradata BTEQ scripts.
  • Developed new FASTEXPORT scripts to generate the files that feed the upstream systems.
  • Worked with Informatica Data Quality (IDQ) on data quality for data cleansing, robust data, remove the unwanted data, correctness of data.
  • Performed in creating tasks in the workflow manager and exported IDQ mappings and executed them
  • Worked as Data Analyst, by gathering requirements related to designing of report and overall functionalities to be included. Made changes to the report based on the feedback given by the user.
  • Used advanced Excel functions for data analysis including, Excel pivot table, pivot charts, macros, logical statements.
  • Involved in data quality requirements in terms of data analyze, consistency, accuracy, referential integrity, cleanse, and consolidate data before loading into data warehouse.
  • Developed Test Plan, Test Scenarios and wrote SQL plus Test Scripts for execution on converted data to ensure correct ETL data transformations.
  • Prepared reports for presentations using Access, Excel, and Microsoft Power Point.
  • Responsible for training people on Teradata and knowledge transfer in project work.

Confidential

Technical Consultant

Responsibilities:

  • Worked as a Team lead.Interacted with the Business Users to analyze the business requirements and transform the business requirements into the technical requirements.
  • Generated business requirement document, mapping document, technical specifications document, data quality reports, developed ad hoc reports.
  • Identified project activities to be completed before transition can start.
  • Involved in data loading using Teradata BTEQ scripts.Converted a multi-level and redundant SQL process into one simplistic BTEQ script.
  • Developed new FASTEXPORT scripts to generate the files that feed the upstream systems.
  • Developing shell script, wrapper in UNIX.
  • Working on Teradata SQL to build complex queries on Warehouse tables.
  • Extensively used IBM Info Sphere Data Stage Manager, Designer and Director for creating and implementing and managing Data Stage jobs.
  • Developed ETL processes using Data Stage designer to load data from Flat Files (Fixed Width) to staging database Teradata and from staging to the target Teradata Data Warehouse.
  • Used Data Stage stages namely Aggregate, Sort, Datasets, Join, Lookup, Change Capture, Row Generator stages in accomplishing the ETL Coding.
  • Used Quality Stage to coordinate the delivery, consistency, removing data anomalies and spelling errors of the source information.
  • Experience in Data profiling, standardization, matching and survivorship using Quality Stage. Worked with Information Analyzer for Column Analysis, Primary Key Analysis and Foreign Key Analysis.
  • Performance tuning of SQL (Explain plans, Collect statistics, Primary and Secondary indexes).
  • Involved in data quality requirements in terms of data analyze, consistency, accuracy, referential integrity, cleanse, and consolidate data before loading into data warehouse.
  • Developed Test Plan, Test Scenarios and wrote SQL plus Test Scripts for execution on converted data to ensure correct ETL data transformations and controls.
  • Involved in analytical reporting using Advanced Excel Pivot tables and charts, macros, vlookup.

Confidential

Offshore project coordinator, Teradata Developer

Responsibilities:

  • Worked on individually assigned task such as Sybase to Teradata code conversion.
  • Worked on performance tuning of Teradata query, PI, SI,PPI Indexing, use of compression of columns, stats collection, checking sub queries with IN/NOT In and try to replace with Joins.
  • Developed Test Plan, Test Scenarios and wrote SQL plus Test Scripts for execution on converted data to ensure correct ETL data transformations and controls.
  • Attending Meetings and Conference calls with client for further necessary actions and status.

Hire Now