Rajalakshmi Email: xmyrfn@r.postjobfree.com
Mob: 91-994*******
Objective:
To pursue a responsible and challenging career as professional in a reputed organization where I can contribute for the development of the organization and also to improve my skills.
Professional Summary:
o Having 4.4 years of experience in IT industry as a Software Engineer in implementation of Data warehousing projects.
o Having around 3+ years of experience in Teradata.
o Having around 1+ years of experience in Data stage.
Provided great contribution in all the offshore projects, and provided great assistance to onsite.
Extensively worked on Teradata application utilities like BTEQ, MultiLoad, Fast Load, Fastexport, Tpump.
Worked with ER, UV and WT tables in error handling at various situations.
Worked with sub queries, views, joins, triggers, functions, Stored procedures OLAP functions extensively.
Extensive experience in extraction, transformation and loading from source to target.
Good exposure to Sales, Banking and Insurance Domains.
Good knowledge about Teradata Architecture.
Involved in testing.
Familiar with complete Data warehousing development Lifecycle.
Well acquainted with all functionalities of client components like Designer, Manager, Director and Administrator of Data Stage.
Strong ability to work individually and constantly in challenging environment.
Ability to lead and problem solving the team towards to achieve project targets.
Ability to produce high quality work at high professional level and complete tasks accurately on schedule.
Self - motivated team player capable of quickly learning and delivering solutions with strong technical and analytical skills and attention to detail.
Professional Experience:
Period Organization Designation
Mar-10 to till date IBM Application Developer
Jan-07 to Feb -10 Venture SoftTech Software Engineer
Technical Skills:
Areas of Expertise
ETL Tools and Scripting Languages Teradata Utilities (BTEQ, FastLoad, Tpump, Fexport, Queryman), Data stage 8.
RDBMS Teradata 12.0,DB2
OLAP Cognos
Operating Systems Win95/98/NT/2000,Unix
Trainings
• Had trained other associates in Teradata at IBM and got “good” rating.
Educational Qualifications:
Title Of Course University/Institution Percentage
B.E – Computer Science & Engineering (2001-2005) ANNA UNIVERSITY/Chennai 76
Diploma in Electronics & Communication (1998-2001) DOTE 87
SSLC (1998) Dept of Govt Examinations 80
Achievements:
• Had trained other associates in Teradata at IBM.
PROFESSIONAL EXPERIENCE:
Project Sales Performance dashboard
Role Teradata , ETL Developer and Cognos ReportsTester
Client IBM Intranet Application
Environment Teradata 12,Datastage ,Cognos
Duration March’10 – Till Date
Description • This Project involved in maintaining a Data Warehouse for Sales Performance Dashboard. Main objective of Sales performance dashboard is to Analysis sales information. Business Data was Extracted, Transformed and loaded into Data Warehouse. All corporate and software systems data are kept in SWG Repository. SWG Repository ETL tool used is Data stage and Database is Teradata.SWG BI is used for sales operations,SWG marketing, SWG finance, SW Geo and Brand Executives, Business unit advisors and sales managers. Increase SW Sales by delivering cognos dashboard that provides actionable information. On the sales force, territory assignments, pipeline and revenue. Rich repository of integrated sales data, identify actionable issues impacting revenue growth. Work of this project is to load weekly data to data warehouse and develop new functionalities to get sales dashboard information.
Responsibilities: • I developed BTEQ SQL scripts for loading/unloading data by applying the transformations as per business rules.
• Implemented SCD Type2 Effective Date range as part of history in MLOAD and TPUMP.
• Performance tuning, SQL query enhancements, code enhancements to achieve performance targets using Explain Plans
• I prepared several types of documents required for the project.
• Used stages like joins, copy, transformer, sort, etc
• I involved in Cognos reports testing in UAT and Production.
• I monitored chevelle test environment.
• I participated in weekly status client meeting calls and updated progress task details.
Project Name #2 Financial Services for ECB
Role Teradata Developer,Cognos reports tester
Client European Central Bank (ECB), Frankfurt, Germany
Technology Teradata 12, Datastage,cognos,unix
Duration Nov ’08 to Mar ‘10
Description • European Central Bank (ECB) is a major participant in the strongest, most vibrant capital markets in the world, operating across various businesses and geographies. They are leading global financial services firm with assets of $742 billion. The firm is a component of the Dow Jones Industrial Average. Major functional areas of European Central Bank are Investment Bank, Research, Private Equity, Investment Management, Private Banking, Treasury and Securities Services and Middle Market. By integrating disparate data sources into a single enterprise-wide warehouse while maintaining consistently high data quality, which tightly integrates capabilities for data modeling, data quality, and data transformation into a complete, end-to-end solution. Built upon a platform of shared services including enterprise Meta data management, any-to-any connectivity, and a parallel processing framework, this solution provides the performance and scalability to address the massive data volumes and real-time/right-time delivery of data required by today's information intensive enterprises.
Responsibilities: • I worked on loading of data from several flat files sources to staging using Teradata FLOAD, Tpump.
• Sometimes I answered adhoc requests of clients by using OLAP functions.
• Involved in query tuning and performance for some existing queries built for reports.
• I used various UNIX commands while working with UNIX files and executing scripts.
• Conducted Unit testing.
• I worked and Analyzed with Error tables, UV tables and provided required support to Work table and Log tables.
Project Name #3 Insurance Data Marts
Role Developer
Client Axa Corporate Solutions Assurance, France.
Environment Teradata V2R5, Data stage, cognos
Duration Feb ’08 to oct ‘08
Description AXA Corporate Solutions is a leading global provider of financial protection especially dedicated to large multinational companies. Dedicated to providing Insurance Solutions to large European Companies for their Property & Casualty risk exposure and to Marine & Aviation client companies worldwide. The primary objective of the project is to develop Data Warehouse system making extensive use of Data marts
Responsibilities: • I worked on exporting data to flat files using Teradata FEXPORT.
• I Developed Fast Load, MultiLoad, and BTEQ SQL scripts.
• Involved in Query Optimization.
• Involved in providing better performance approaches considering structural changes like PI consideration based on data demographics, collect statistics and EXPLAIN plan.
Project Name #4 Catalog Sales Analyses
Role Developer
Client DViCO
Environment Teradata V2R5/R6, Data stage, DB2
Duration Feb ’07 to Jan ‘08
Description • The project is basically a transformation of the existing data warehouse into a new architecture. The ETL tool used is Data stage and Database is Teradata. This Project involved in creating a Data Warehouse for Sales Analysis System. Data from ODS was Extracted, Transformed and loaded into Data Warehouse. Extract data from heterogeneous systems, transform and load into Data Warehouse system for the decision making for their in depth business process.
Responsibilities • As a developer I Created, manipulated many scripts such as BTEQ, FASTLOAD and MULTILOAD.
• Participated in analysis, development, review, maintenance of database and data models including dimensional (star /snowflake) as well as transactional RDBMS.
• Involved in creation of different stages like Copy, Aggregator, Sort, join and Filter.
• Involved in unit testing and preparing test cases.
• I worked with sub queries, set operations on a Teradata database.
Rajalakshmi.VR