Profile and Experience:

Sameer Aneja has total 4.6 years of IT experience in Data warehousing. Currently working as a TERADATA SR DEVELOPER with HCL TECH. based in Singapore.
Primary Area of expertise and Role

• Good knowledge in designing and developing of software applications related to DWH. For clients like Sabre, Telenor, OCBC Bank
• Domain Experience in Insurance ,Financial , Telecom and Travel sector’s
• Handling various modules independently and providing support to various applications.
• Developed ETL for Campaign application for client.
• Developed ETL for Single View of Customers for End User Analytics
• Developed various applications on TERADATA 12, ODI 10.3.5.
• Implemented best coding practice to deliver high performance ETL.
• Applied Query optimization in various project, to bring down the ETL time
• Currently Leading 5 Teradata developers in current project.
• Daily dealing with client regarding the project activities.

Awards , Achievements and Education:

• Awarded with Mercury award for Excellence Contribution to the Sabre TDW project.
• Awarded with Director Merit List Award At Graduation Level.
• Master of Computer Application
• Bachelor of Computer Application

Skill Sets:

RDBMS:

Teradata (SQL PROGRAMMING, FSLDM, CLDM), Oracle, Microsoft SQL Server 2005.

ETL TOOLS:

Oracle Data Integrator10.1.3.5.6, Informatica 8.1

Operating System:

Windows Server, UNIX

Professional Experience Summary

CURRENT ORGANIZATION: Confidential,SINGAPORE Jun 11 till date

Project Name: PEGASUS
Description: A data warehousing project for Oversea-Chinese Banking Corporation Limited .OCBC Bank is one of the Singapore\'s leading local banks, with group assets of more than 224 billion SGD. It has one of the highest bank credit ratings in the region. The project is to provide a complete solution to OCBC for integration of Legacy systems from one of Subsidiaries Great Eastern Holdings\' into the existing Data warehouse made on Teradata FSLDM with the help Unix and ELT tool ODI. The involvement with the client includes project management, design, development and architecture of database, and ETL.

Tools Used: Teradata/ Microsoft SQL Server 2005 /Oracle Data Integrator/ UNIX/ Perl/ Jython/ Windows.
Team size: 28
Role: Sr.Software Engineer (Teradata FSLDM SQL Programming)

Achievements & Contributions: As a Teradata lead in the project, I have solved many complex problem for my current client .With legacy system as source I am able to achieve Complex data transformation of rows to column data with Teradata sql programming without using any ETL tool. Guided my team how to develop code with high performance sharing my experience about best coding standards learnt so far.

As a Sr. Software Engineer, I am responsible for:

• Involved in the requirement study, design and development
• Integration of Different source systems (Legacy systems, Oracle and Sql Server) into Datawarehoue.
• Developing Code, and then Test and code review at peer level.
• Making Ad hoc quires for the client.
• Support document preparation for handling the code.
• Supervising the Code done in Teradata and ODI.

ORGANIZATION: Confidential, Mar ’10 till Jun 11

Project Name: Confidential,
Description: A data warehousing project for Uninor. Uninor is a partly-owned subsidiary of Telenor, the Norway-based communications provider, which is providing Mobile Phone Service in more than 7 major circles of India. The project involved managing the development, support and maintenance using agile methodologies. The project was to provide a complete solution to Uninor for its Data Warehouse. The involvement with the client included project management, design, development and architecture of database, ELT and reports.

Tools Used: Teradata/ Microsoft SQL Server 2005 /Oracle Data Integrator/ UNIX/ Perl/ Jython/ Windows.

Team size: 42
Role: Analyst Programmer (TERADATA CLDM)

Different projects I have worked for client Uninor:

CAMPAIGN

In any growing mobile communications market, gaining customer attention is key .Every time a prepaid balance runs down, a provider stands to gain or lose that account. Promotions that attract new business and keep its subscribers

DMS (Distribution Management System) Distribution Management System, which simplifies and manages each phase of distribution chain from customers, ordering, delivery, payment, inventory, and right through to services management. The complete information can be accessed on your screen which enables you to automate the business processes and take real-time critical decisions...

POS
Point of sale(POS) (also sometimes referred to asPoint of purchase(POP) orcheckoutis the location where atransactionoccurs. A "checkout" refers to a POS terminal or more generally to thehardwareandsoftwareused for checkouts, the equivalent of an electronic cash register.

Achievements & Contributions:
As an Analyst Programmer for Uninor I contributed to the Campaign project with complex report of Campaign Effectiveness of nature Daily, M TO D and Y to D with level COUNTRY->SATE->CITY->REGION which was used by the end user marketing and sales team of Uninor for checking Campaign Effectiveness.
In DMS AND POS I designed the whole ETL for checking the performance of Dealers across the country .

As an Analyst Programmer, I was responsible for:

• Involved in the requirement study, design and development
• Integration of Different source systems (CRM, Oracle and Sql Server) into Datawarehoue.
• Developing Code, and then Test and code review at peer level.
• Making Ad hoc quires for the client.
• Support document preparation for handling the code.
• Supervising the Code done in ODI.

A 50-member team is involved in the development of data warehouse on Teradata, UNIX, ODI, OBI and SAS

ORGANIZATION: Confidential,Jan \'08–till Mar ‘10

Project Name: SABRE – Travel Data Warehouse

Description: A data warehousing project for Sabre. Sabre is a USA based major airlines solution provider. The project involved managing the development, support and maintenance using agile methodologies. The project was to provide a complete solution to Sabre for its Data Warehouse. The involvement with the client included project management, design, development and architecture of database, ELT and reports.
Tools Used: Teradata/ Oracle Data Integrator/ Cognos/ Unix/ Perl/ Jython.

Role: TDW Developer

Different projects I have worked for client Sabre USA is:

• Rate Assured – RA processes are automated processes that run daily or weekly according to a predefined schedule. Their sole task is to load data from file/tables/views to tables, apply Business Logic ,identifying which properties are in parity and which are out of parity, generating non-compliance report and create E-hotel files from the database and FTP them to desired folder.
• Air vision –Air vision process are automated process that run daily/weekly/monthly Their sole task is to identify the booking/cancellations that were made on previous day, and load them into the tables. Cognos reports were developed to view the summarize data
• Emquest –– Emquest extracts are automated processes that run daily or monthly according to a predefined schedule. Their sole task is to identify the booking/cancellations that were made previous day, summarize them for each country/agencies, send it to the customer, and archive them. To accomplish this each extract performs several steps each time it runs.
• CDD extracts – CDD extracts are automated processes that run daily, weekly or monthly according to a predefined schedule. Their sole task is to extract the data from the database, send it to the customer, and archive it on the tmddev.sabre.com server. To accomplish this each extract performs several steps each time it runs. A simplified list of steps may look like this:
• Connect to the TDW database;
• Select some data;
• Pack it into files;
• Encrypt the files;
• FTP the files over to customer site;
• ARCHIVE the files to tmddev ftp server.
• Smartflow –Smartflow process are classified in two categories
• Loads: Loads are automated process that runs every hour, receives file from Revenue Integrity team, and loads the data into the database using T-pump, Fast Load. The main purpose of loads was to identify the fictitious bookings, Restricted credit cards, fictitious ticket numbers, restricted passenger, ACTV etc
• Extracts: Extracts are automated process that runs every 2 hours, extract the data from database and ftp the files to Revenue Integrity Team. the main purpose of extracts was to identify the fictitious bookings, duplicate Passenger names ,duplicate segments, Restricted credit cards, fictitious ticket numbers/restricted passenger ,ACTV etc
• Revenue Summary: Revenue Summary is the project specially built for Kingfisher and Jet Airways which want to known about Revenue on particular segment. For this we created the Fact table from our summary table, applying the business logic according to the requirements.

Achievements & Contributions:
SABRE was the starting point of my career in IT Industry, I worked for this client for more than 2 years Dealing with complex system SmartFlow where we used to receive information about fraud credit cards and to check in the data of about 15 airline that these credit card not being used in any future and current bookings of Air ticket. Another tough job I achieved here was the checking of Restricted Passengers, We used to get the information about passengers that should not travel together in Airplane on any route from the Federal agency of USA, Used to load this information every hour and check if such bookings are there and sent back list to the Federal Agency. In Revenue Summary project I created the summary reports for the respected airlines stating on which segments they got profit and on which they got loss and why .This information was used by the marketing and sales teams.

As a TDW Developer, I was responsible for:

• Involved in the requirement study, design and development
• Integration of Different source systems mainframe systems files, files from CRM system, files from different GDS into Datawarehoue.
• Developing Code, and then Test and code review at peer level.
• Making Ad hoc quires for the client.

A 30-member team is involved in the development of data warehouse on Teradata, Unix, ODI, and Cognos.