A .pdf Etl Developer

Dash, Subhasmita . +91 9663384898 . [email protected] Page 1 of 4 Profile . Around 3 year of focused experience in Information Technology on Development and Support projects with a strong background in Data Warehousing concept, in ETL process; presently I am working as ETL Developer for CGI Information System, India. . Primary Skill set Oracle, Unix shell script, Data warehouse concept, Data stage 7.5 Server Jobs, Teradata . Experience in developing Extraction, Transformation and Load (ETL) processes for Data Warehousing and Data Migrations projects using Unix, Oracle, Data Stage 7.5 Server jobs from wide variety of source systems like SAP, Oracle Applications and AS400 . Sound background in Data stage 7.5 Server jobs, Oracle, SQL,PL/Sql,Tera Data and Scripting . Hands on experience in writing UNIX Shell Scripting. . Implemented calling external program like oracle objects, Java objects, and Data stage objects in side UNIX scripting. . Created Data stage server jobs using various data stage stages, link partitions, IPC, Sequential stages, OCI stages, Hash file, Sequencers etc� . Writing of PL/SQL stored procedures and functions, Packages, oracle Collections and Cursor that enhances the functionality of an application. . Hands Experience on Teradata for sql and PL/Sql. . Used various objects in Teradata like in Fast load, Multi Load, BTEQ, First Export, TPUMP, Macros. . Used various tools like Hummingbird BI Query application for supporting OLAP application in Bell Canada. . Experience on Ticketing Tools like Heat, Remedy. . Team player with good interpersonal skills and high level of energy and enthusiasm. Technical Skills ETL Data stage 7.5 Server job, Oracle Pl/SQL BI Tools Humming Bird BI Query Language PL/SQL Scripting Shell Script, SQL Script Version Control Tool SVN, Harvest FTP Tool WinScp, SSH RDBMS Oracle 9i, Teradata 7.5 Tools Toad, Sql Developer, Putty, Cygwin Remedy Tools Heat, Remedy

Dash, Subhasmita . +91 9663384898 . [email protected] Page 2 of 4 Current Employment Details Organization Duration CGI Information System, Bangalore 15th June ,2009 to till date Tyco Electronics Corporation, Bangalore 2nd July 2007 to 29th May 2009 Project Summary Project Name Client Duration Environment Domain Enterprise Data warehouse(EDWCMF) Bell Canada 15th June,2009 To till date Oracle 10g,Sql,PL/Sql, Data Stage, Teradata ,Unix, BI Query Telecom Tyco Electronics Data Warehouse(TED) Tyco, US 1st Aug 2007 to 29th May 2009 Oracle 9i,Sql,PL/Sql, Data Stage, Unix Shell Scripting Manufacturing Bell Canada DWH: Enterprise Data Warehouse Bell Canada Client Bell Canada Period 15th June 2009 to till date� Tools/Platforms Teradata, Unix Shell Scripts, Data stage 7.5,Heat,Humming Bird BI Query Role ETL Developer Bell Canada, commonly shortened to "Bell", is a major Canadian telecommunications company. Including its subsidiaries such as Bell Aliant, Northwestel, T�l�bec, and NorthernTel, it is the incumbent local exchange carrier for telephone services in most of Canada east of Manitoba and in the northern territories, and a leading competitive local exchange carrier (CLEC) in the western provinces. Bell Canada EDW is built to support Bell�s one vision and long term goals which enables Bell Canada to take strategic decision and also support day to day business run. Bell Canada EDW � CMF is built to support Bell�s one vision and long term goals which enables A better customer account matching and in turn enables the creation of a holistic view of the customer. CMF is an application which manages the customer data. The customer master file data store provides a view of the customer information Sourced from the Enterprise Data Warehouse. The Customer Master File is single repository of Consumer enhanced customer and household/legal entity information spanning across BCH. Additionally, it activates links to

operational systems to keep customer information and product ownership current. Roles and responsibilities: . Develop the ETL jobs to pull data from various source systems using DataStage server jobs, Oracle, Teradata and UNIX shell script. . Involved in Various application like CMF, BI Query, Common Ground . Creation and debugging of Jobs which will use Joins, database levels, Transformers, Sequential files, look-up and other utilities. . Preparing New Jobs or feed for populating the DWH.

Dash, Subhasmita . +91 9663384898 . [email protected] Page 3 of 4 . Created Data stage server jobs using various data stage stages, link partitions, IPC, Sequential stages, OCI stages, Hash file, Sequencers etc� . Writing of PL/SQL stored procedures and functions, Packages, oracle Collections and Cursor that enhances the functionality of an application . Written Various Shell script and schedule the job on Crontab . Deployed the code on production whenever requirement is there for Production deployment. . Involved in Monthly Server Maintenance. TED DWH: Tyco Electronics Data Warehouse Client Tyco Electronics Corporation Period 10th Aug 2007 to 29th May 2009 Tools/Platforms Oracle, Unix Shell Scripts, Data stage 7.5 Role ETL Developer This is a data warehouse which contains all the information related to Tyco products from manufacturing to shipment information. � TED is a collection of enterprise wide data into a single database � TED consists of various applications which collect, cleanse and store data from TE companies all around the world � TED currently has subject areas available such as Sales, Finance, Purchasing, Inventory, Quality,� for daily, weekly & monthly reporting � TED info is available thru � data marts �, which offer � efficient reporting performance � data mart refresh within target time window � reporting for specific business area, function or region TED is used for the following purpose: � Global BU Reporting � Cross Functional Reporting � Managed Standard Reporting � Historical Reporting � Analytical Reporting � Master Data Roles and responsibilities: o To Extract data from different source system and load it to the database after cleaning or validating. o Preparing various reports for the need of enterprise data management team using sql script o Preparing New Jobs or feed for populating the DWH. o Created Data stage server jobs using various data stage stages, link partitions, IPC, Sequential stages, OCI stages, Hash file, Sequencers etc� o Writing of PL/SQL stored procedures and functions, Packages, oracle Collections and Cursor that enhances the functionality of an application

Dash, Subhasmita . +91 9663384898 . [email protected] Page 4 of 4 o Written Various Shell script and schedule the job on Crontab. Summary of Qualifications Certification . OCA certification Professional Qualification Institute Eastern Academy of Science and Technology University Biju Patnaik University of Technology, Rourkela, Orissa C.G.P.A. 7.2 Branch Electronics & Telecommunication Year of passing 2007 Personal Details Passport # H4977433 Present Address No 364/2, 4th Cross, Cauvery Nagar, Air Port Road, Bangalore 560017 (India) Permanent Address Bhubeneswar, Orissa Mail id [email protected] Mobile # 91-9663384898 DOB 24th May 1984 Marital Status Single _________________________________________________________________________ Place: Bangalore Date: 07-Oct-2009