SUMMARY:

• Over 5 years of experience in Information Technology as Data Analyst, Business Analyst, Data Quality Analyst, ETL/SQL Developer and Teradata Developer.
• More than 3 years experience in data quality tools like Data flux and Ab Initio DQE/Express>IT.
• Good knowledge in designing and executing data quality rules.
• Experience in gathering the business requirements, data profiling, data analysis, Development and testing.
• Extensively worked with Teradata utilities like BTEQ, Fast Export, Fast Load, Multi Load to export and load data to/from different source systems including flat files.
• Hands on experience using query tools and reporting tools like TOAD, SQL Developer, PLSQL developer, Teradata SQL Assistant and Tableau.
• Proven experience in planning, building and managing successful large - scale data warehouse and decision support systems.
• Comfortable with both technical and functional applications of RDBMS, Data Mapping, Data management, Data transportation and Data Staging.
• Created/Enhanced Teradata Stored Procedures to generate automated testing SQLs.
• Experience in writing complex SQL queries to implement business rules, extract and analyze data.
• Developed BTEQ scripts to load data from teradata staging area to data warehouse, data warehouse to data marts for specific reporting requirements. Tuned the existing BTEQ script to enhance performance.
• Strong knowledge in data quality development and data governance principles.
• Developed design documentation and implementation proposal for extraction of data from data warehouse.
• Expertise on Star Schema, Snowflake Schema, Fact Dimension Tables and Slowly Changing Dimensions. Interacting with both clients and users as well to know their requirements.
• Worked on python scripts for data analysis.

TECHNICAL SKILLS:

Database: Oracle, Microsoft SQL, Netezza, Teradata, Toad

Tools: SAS, Tableau, Cognos, Qlikview, Talend, MS office, Ab Initio

Programming Language: C, Python

Web Technologies: HTML, CSS

BI/Data warehousing: ETL Informatica, SSIS, SSRS

Teradata Tools: BTEQ, Fast Load, Fast Export, Multi Load, TPump, Teradata SQL Assistant

PROFESSIONAL EXPERIENCE:

Confidential, Charlotte, NC

Data Quality Analyst

Responsibilities:

• Worked with ABDO team to know the rule requirements.
• Performed Data profiling, Data analysis, Data validation for all the data quality rules.
• Implemented many data quality rules in Ab Initio as per the rule specification workbook.
• Worked with data controls team to discuss the business rules on data elements and write SQL’s.
• Execute the rules and publish results to EME (Enterprise Metadata Environment) and EMH (Enterprise Metadata Hub).
• Performs End-to-End testing for all the test cases after developing business rules in Ab Initio.
• Generates DQR (Data Quality Rule) results report from EMH to End-to-End package for business verification.
• Peer reviewing the development of business rules and data results of other team members to ensure right data quality rules are implemented.
• Worked on analyzing and preparing rule specification documents.
• Co-ordinated with domain analysts for rule suggestions for each data element.
• Worked on many application domains like Commercial Lending and Traded Products.
• Identify data defects and remediate data issues with appropriate insights on time with high quality.

Environment: Ab initio, Oracle 12c/11g, flat files, Salesforce, MS SQL Server, PL/SQL, UNIX Shell Script

Confidential, Charlotte, NC

Teradata Developer

Responsibilities:

• Participate in active discussions with team members and users to understand the business requirements.
• Design, develop, implement and support new as well as existing data integration jobs using Teradata stored procedures.
• Experienced in troubleshooting, diagnosing and resolving data quality and performance issues.
• Worked with slowly changed dimension and dimension modelling concepts.
• Created tables, views and stored procedures according to the requirements.
• Designed star schema and snow flake schema.
• Worked on performing Data profiling, Data Analysis and performing End-to-End production implementation.
• Developed SQL join indexes to solve tactic queries.

Environment: Teradata 14, Teradata-BTEQ, Viewpoint, Oracle 9i, PL/SQL, MS Access, Visual Studio (2008, 2012)

Confidential, Las Vegas

Teradata Developer

Responsibilities:

• Extracted data from source, applied transformations and loaded in to Teradata data warehouse.
• Developed Fast Load, MultiLoad and Bteq scripts for loading data from flat files into tables.
• Created many mapping documents from source to target.
• Identifying the root cause of failure jobs in logs and fixing it.
• Worked on many complex SQL queries based on requirements.
• Query tuning by going through the EXPLAIN PLAN and analyzing the reason for the long-time consumption of the query.
• Loaded data into Teradata database from multiple source systems by using Data Stage tool.
• Generated DDL’s and used Teradata best practices to implement Physical data model.
• Worked on the analysis of data by using base python scripts.
• Involved in Coding SQL Scripts for Insert, Update and Delete Scripts for data movement from Source to Staging and from Staging to Targets.
• Applied Transformation logic in various complexities in transforming and transferring the data into downstream Teradata.
• Worked in converting logical data models to physical database designs in Data warehousing Environment and in-depth understanding in Database Hierarchy, Data Integrity concepts and Data Analysis.
• Worked on tables (Set, Multiset, Derived, Volatile and Global Temporary), Views and procedures using SQL scripts.

Environment: Teradata 14, Unix, Korn Shell, Teradata - BTEQ, Fast Load, Multi Load, Fast Export, Viewpoint, Oracle 9i, PL/SQL, MS Access

Confidential, Charlotte, NC

Data Analyst

Responsibilities:

• Maintained corporate treasury data quality rules and measurement and control plans.
• Provided Data Profiling, Data analysis, Data Visualization, Data Forecasting, Data Validation and Post- production validation for all the implemented data quality rules.
• Interacted with data stewards to know the requirements as the data quality rules are implemented in production.
• Generated business reports using reporting tools like tableau and SAS.
• Created regular expressions in data flux for validating the numeric or alpha numeric data.
• Created many complex case statements, Joins and Sub- Queries in Oracle database.
• Extensively worked on many tools like SAS Data flux, SQL Server and Tableau.
• Implemented data quality rules process by using additional tools like Excel VBA and macros.
• Worked on executing SQL case expressions in Netezza/Toad database for the required date range.
• Worked on writing many data quality rules which are tested in Netezza database to ensure accuracy, completeness and timeliness.
• Involved in designing, developing and understanding the test methodologies from project definition to post-deployment documentation.
• Involved in the requirements gathering, design and development of the data models.

Environment: Teradata 14.0, Teradata SQL, Unix, Netezza, Exadata, Oracle 10g/11g, MS

Confidential, Richmond, VA

ETL/SQL Developer

Responsibilities:

• Created complex joins and sub-queries involving multiple tables.
• Used Informatica power center tool to extract, transform and load the data from disparate sources into enterprise data warehouse.
• Designed Star schema (identification of facts, measures and dimensions) and Snowflake schema.
• Created Database Objects like Tables, Views and Stored Procedures.
• Extensively worked on designing reports using SQL Server Reporting Services (SSRS) and used SSIS to move data from text files to SQL Server.
• Worked on RDBMS concepts, Data warehousing concepts, OLTP & OLAP.
• Created Databases, Tables, Cluster/Non-Cluster Index, Unique/Check Constraints Views, Stored Procedures, Triggers, Rules and Defaults.
• Deployed packages from development server to production server and scheduling jobs.
• Worked on many complex dashboards by using calculated fields, Action Filters, In & Out of sets and Global Filters.
• Worked on optimization and performance tuning of complex queries on large volumes of data for analysis and extraction.
• Designed and Developed Stored Procedures, Packages & Functions using PL/SQL and SQL scripts.
• Created interactive dashboards, visualized customer reports and improved statistical data using Tableau and Qlik view tools.
• Developed Tableau workbooks from multiple data sources using Data Blending.
• Built summary reports using PROC SUMMARY, PROC MEANS, PROC FREQ and GCHART.
• Worked on loading the data from different flat files to data warehouse.

Environment: SQL Server 2005, SQL Server 2000, XML, MS Access, SQL Query Analyzer, SSIS, SSRS, SSAS, Exadata, Oracle 9i, Teradata 14, HTML, Visual Studio, Excel, T-SQL, XML

Confidential, Pittsburgh, PA

Teradata Developer

Responsibilities:

• Created tables, views and stored procedures according to the requirements.
• Created many Bteq, Multiload and Fast Load scripts to load data into teradata database.
• Developing many primary and secondary indexes to solve strategic queries.
• Worked on many Teradata load and unload utilities like Fast Load, Multi Load, Fast Export and TPump to communicate with Teradata database.
• Generated many ADHOC reports as per the Client requirements.
• Created many Set and Multiset tables to load bulk data in the form of inserts and deletes.
• Created indexes, joins on tables as per requirements.
• Build tables with UPI, NUPI, USI and NUSI.
• Created various types of temporary tables such as volatile and global temporary tables.
• Worked with collect statistics and join indexes.
• Used SQL pass through facility to process high volumes of data.
• Worked on Teradata view point to check the status of system.
• Worked on query monitor and query spotlight to check for the performance of individual queries before implementing in to production.

Environment: Teradata 14, Unix, Korn Shell, Teradata - BTEQ, Fast Load, Multi Load, Fast Export, Viewpoint, Oracle 9i, PL/SQL, MS Access, Visual Studio (2008, 2012)