Teradara Analyst

RIAZ ALI

Richmond, TX

Tel: 210-***-****

E-mail: ****.***.*@*****.***

SUMMARY

●Over 14 years of professional software development and data warehousing data analytical experience.

●Proven experience in Data Warehousing concepts and designs.

●Proficient in database application development and SQL writing in an analytical setting.

●Experienced in providing solutions for major industries in retail, banking, hotels and manufacturing sectors.

●Certified Teradata Professional and SQL Specialist.

SKILLS

Category

Skills

Years

Database Systems

Teradata and Teradata Utilities

14

Oracle

6

DB2 UDB

4

Languages

SQL

Visual Basic 6.0, MS Access

12

9

SQL, PL/SQL, ODBC

8

ASP, JavaScript, HTML/DTHML, XML

6

ASP.NET, VB.NET, Java, AJAX

2

Softwares

MS Excel, MS Word, MS Office

14

Operating and Network Systems

Windows

12

EXPERIENCE

BI DEVELOPER Sept 2019 - Present

Cigna - Remote from Houston

· Project: Business Intelligence development and data reporting and analysis for Cigna HealthSpring Healthcare products.

· Work: - Writing with multiple database systems to develop complex business intelligence solutions.

- Provide Data solutions to various users of Cigna’s databases mainly in data warehouse space in Teradata and SQL Server.

- Create data objects and stored procedures for various business needs within BI group.

- Investigate data issues and check data quality and integrity.

- Explore solutions to complex problems through technology and business knowledge exploration.

- Provide subject matter expertise in data matters and as well as BI developments.

· Skills: SQL, Teradata, Oracle, MySQL, PostgreSQL, stored procedures, PL/SQL.

Tableau, Looker, SAS, Excel, Active Batch, Confluence, Jenkins, GitLab, uDeploy, DevOps

Sr. DATA ANALYST Dec 2006 – Aug-2019

AT&T/GroupO (Home Solutions)

Sugar Land, TX

· Project: Data Analysis and Reporting on Oracle and Teradata data warehouse environment.

· Work: - Writing complex SQL queries for in-depth data analysis for customer and prospects campaigns for AT&T products.

- Designing and building databases and objects to support GUI List management teams in Oracle and Teradata.

- Monitoring and cleansing databases to provide high quality marketing data to List Management teams.

- Extracting data from in-house and third-party and creating objects in databases for various analysis and tasks.

- Working with DBAs and Managers to tune the databases for optimum performance and delivery.

- Generating reports for executives to better understand marketing scope and current customer base.

- Helping various teams to move data between systems and creating processes to implement data on platforms.

- Participation in strategic data planning and development for Consumer marketing prospects and acquisitions.

· Skills: SQL, Teradata, Oracle, tables, views, indexes, triggers, stored procedures, PL/SQL.

MS Access, Word, Excel, PowerPoint, Windows

Sr. APPLICATION DEVELOPMENT ANALYST Jan 2001 – Nov 2006

Teradata DCM, A division of NCR

Toronto, Canada

· Project: - Web-based Enterprise application known as Teradata Demand Chain Management Solution.

· Work: - Written complex SQLs using Teradata SQL extension and analytical functions to provide solution for critical

business queries within DCM solution.

- Analyzed, Designed and Developed web-based enterprise DCM Data Warehousing application suite for

Forecasting, Promotions, Profiling and analyzing data for major retailers worldwide.

- Designed and developed middle-tier business logic using Visual Basic 6.0 and SQLs and front-end using

ASP, Javascript, Vbscript, HTML and DHTML and data access layer using Teradata, Oracle and DB2.

- Migrated MS Access 2000 based DCM solution to Web-enabled enterprise application.

- Designing and developing Java based application to upgrade current Microsoft based application.

- Analyzed and created reporting mechanism within web solution to provide efficient DCM reports.

· Skills: Teradata and Utilities, Oracle, DB2, SQL Server databases, MS Access.

Databases tables, views, indexes, triggers, stored procedures, ETLs, PL/SQLs and SQLs.

Visual Basic 6.0, ASP, Vbscript, Javascript, XML, HTML, COM, ADO, .NET, Java, Active Reports.

Windows, UNIX.

EDUCATION

· BACHELOR IN COMPUTER SCIENCE (1995) - University of Karachi. Pakistan.

· DIPLOMA IN COMPUTER SCIENCE (1995) - Academy of Business Computers, Karachi, Pakistan.

CERTIFICATION

· TERADATA CERTIFIED PROFESSIONAL V2R4, V2R5 (2002, 2004) - Teradata, Toronto, Canada.

· TERADATA CERTIFIED SQL SPECIALIST (2003) - Teradata, Toronto, Canada.

Contact this candidate