Senior Data-Warehouse Developer/Analyst Resume

EXECUTIVE SUMMARY:

Over 6 years of experience in Data Ware Housing, Report generation, Mainframe SAS and ETL in SAS EG Version 5.1, Base SAS Version 9.4, Ab - Initio.
Proficient in Databases include Oracle, SQL Server, and Teradata.
Core SAS Programmer with experience in SAS tools like Base/SAS, SAS/Macros.
Extensive SAS programming experience in Design, Development, Implementations, Testing, Support & Maintenance.
Extensive experience in Teradata by writing complex queries, BTEQ Scripts, TPT, using utilities such as FastLoad, MultiLoad, TPUMP.
Experience in using analytical Functions in Teradata, and have write Teradata macros.
Exceptional ability in problem solving, data analysis, complex reports generation with macro and data transfer between different environments.
Expertise in transforming data imported from disparate data sources into analysis data structures, using SAS functions, options, ODS, array processing, macro facility, and storing and managing data in SAS data files.
Experience in developing SAS Procedures, Macros, Application’s for data extraction, transformation, data cleaning, reporting and involved in preparing documentation.
Worked with the marketing team and analyzed marketing data using SAS tools to generate reports, tables, listings and graphs.
Experience in BASE SAS (Including SAS SQL, SAS ODS).
Experience in Microsoft Office tools like MS Access, MS Word, MS PowerPoint, and MS Excel etc.
Experience in cleaning and resolving data issues as well as merging data from different sources into a single integrated dataset.
Strong Project coordination including strategic planning, trend analysis, forecasting, variance analysis, database management.
Write, maintain, and support SAS Programs in SAS Base and Enterprise Guide.
Extensively worked with PROC SQL to extract data from Teradata database, load data into database and print sophisticated reports.
Motivate supportive, cooperative and a quick-learner. Strong communication skills and ability to work well in a team.
Extensive experience in Data collection, Design, Analysis and Reports.
Very good team player with excellent communication, analytical and problem solving skills.

TECHNICAL SKILLS:

ETL Tools: SAS EG Version 5.1, Base SAS Version 9.4, Data-Stage, Teradata, Ab-initio.

Programming Languages: Base SAS, Mainframe SAS, Advanced SAS.

Operating Systems: Linux, Windows.

Confidential Technologies: Cloudera CDH5.x, Hive, HBase

Tools/DB/Packages: Sql, Oracle, SAS Base, SAS Macros, Stored Procedures in SAS, Advanced SAS, Teradata, Hive, Impala, Datastage, Teradata

PROFESSIONAL EXPERIENCE:

Confidential

Senior Data-Warehouse Developer/Analyst

Responsibilities:

Creating the Mapping Document from one source to another.
Involved in the Requirement gathering Phase.
Managing and helping associates in extracting data from different sources like Oracle, Teradata etc.
Working on Impact and Analysis (The Only Point of Contact for Client) if there are any Change Requirements.
Involved in Unit Testing and Mapping Documents.
UsedTeradata utilities fastload, multiload, tpumpto load data
Wrote BTEQ scripts to transform data
WroteTeradata Macrosand used various Teradataanalytic functions.
Involved in migration projects tomigrate datafrom data warehouses on Oracle/DB2 and migrated those toTeradata.
Performance tuned and optimized various complex SQL queries.
Wrote many UNIX scripts.
Good knowledge on Teradata Manager, TDWM, PMON, DBQL, SQL assistant and BTEQ.
Have done many optimizations of SQL Codes in SAS.
Very proficient in using SAS EG 5.1, and have used many functionalities such as Joins, Aggregations, Query Builders etc.
Very proficient in using Base and Advanced SAS Version 9.4. Have developed 5 Reports using Base and Advanced SAS.
Very proficient in using PROC SQL, Macros and Stored Procedures.
Module lead: - I have done around 20 Report Executions every month. I have completed around 25 Critical Change Requirements, and 40 Low Critical Change Requirements. I was the only Point of Contact for the IT group Impact and Analysis.

Confidential

Data Engineer

Responsibilities:

Managing and helping associates in extracting data from different sources like Oracle, Teradata etc.
To continuously create and modify Data-stage jobs to Integrate the data of other vendor as well.
Have done many optimizations of SQL Codes.
Module lead: - I have been leading the team of 10 which are located in different locations.
Teradata: - I have developed around 20 complex SQL Queries in my 4 months of tenure in this project.

Confidential

Data Developer

Responsibilities:

My role was to understand all the basic concepts and architecture of Confidential .
Had successfully used Cloudera CDH 5.X to manage the Cloud and Hadoop Applications.
We had used HQL (Hive Query Language) and Impala so that querying can be done efficiently on the application.
We had optimized our Queries by using Partitioning and Bucketing.

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship