Chinnayachari.K Mobile No: 9704437869

Chinnayachari.
chinnayachari.datastage1@gmail.com Mobile No: 9704437869
PROFESSIONAL SUMMARY: 3+ years of Experience in the information technology industry, Expertise in the development Data warehousing applications using IBM DataStage7.5x2 as ETL tool. Experience in developing Server jobs & Parallel Jobs with DataStage. Good knowledge and experience of different phases of software development life cycle (SDLC) including analysis, design, development, testing and maintenance. Expertise in database concepts for data warehousing Well versed in working with RDBMS like Oracle Excellent analytical and communication skills, ability to work independently and good team player. PROFESSIONAL EXPERIENCE: Working as a software Engineer in Fortech Soft (India) Ltd, Hyderabad from NOV 2007 to till date. ACADEMIC PROFILE: B.Sc (ComputerScience) from Ideal College of Art Science under A.U. TECHNICAL SUMMARY: Programming Languages Operating Systems known Databases ETL Tools : C,C++ & C#.net Asp.net : Windows 2003 Server, XP, UNIX. : Oracle 9i, 10g. : Data stage 7.5X2 and Knowledge on : IBM Infosphere DataStage V8.0
PROJECT DETAILS PROJECT#1 Project Name: SBC Communications Client: SBC, San Antonio, Texas, USA Team Size: 24 Environment: IBM DataStage 7.5x2, Conges, Windows 2003 Server, Unix & Oracle 10g Duration: Dec2009 to till date. Description: SBC Communications was a regional holding company that specialized in local, Wireless, internet service in the United States and internationally. Originally named Southwestern Bell Corporation it was changed in 1995 to SBC Communications. Originally holding only one local provider, the Southwestern Bell Telephone Company, over the years the corporation took over various others including Pacific Bell, Ameritech, SNET, and Nevada Bell. Southwestern Bell Corporation was officially transferred full ownership January 1, 1984, they had three subsidiaries: Southwestern Bell Publications, Inc., a directory publisher; Southwestern Bell Mobile Systems, Inc., in the business of mobile telephone service; and Southwestern Bell Telecommunications, Inc., focusing on marketing phone equipment to business customers. The holding companies new president was Zane Edison Barnes. Responsibilities: Understanding the client requirements by studying functional documents. Involved in File set stage, Data set stage, Lookup file sets & transformer stages. Worked with Local and Shared Containers. Preparing the technical specifications and Test script documents. Involved in Peer review of the DS Job Designs
Involved in using the File stages like Sequential file stage, Dataset stage, FileSet stage, Lookup FileSet stage, Processing stages like Aggregator stage, Change capture stage, Filter stage, Funnel stage, Copy stage, Join stage, Lookup stage, Merge stage, Sort stage, Surrogate Key Generator stage, Transformer stage, Modify stage, Pivot stage, Remove
Duplicate stage. Applied some Performance tuning techniques for optimizing the performance of the DataStage jobs.
Designed DataStage Job Sequencer to automate the whole process of data loading.
PROJECT#2 Project Name: COLT Telecom Online Billing Client: COLT Telecom Group, London, England, United Kingdom Team Size: 37 Environment: IBM DataStage 7.5x2, Conges, Windows 2003 Server, Unix & Oracle 10g Description: Colt was founded in 1992 by Jim Hynes with funds provided by Fidelity Investments as City Of London Telecommunications. The company began to construct a Telecoms network in London. In 1993 it was awarded a license to compete with British Telecom and Cable and Wireless in voice and data transmission. It was first listed on the London Stock Exchange in 1996. The group later expanded into Europe, building networks in major European cities over the next 10 years. In 2001 Fidelity Investments helped the Company to raise a further 400m to finance its future activities. Colt specializes in providing Data, Voice and Managed Services to major enterprises, small and medium sized businesses and wholesale customers. Colt operates a 25,000km network that includes Metropolitan Area Networks (MANs) in 34 major European cities with direct fiber connections into 16,000 buildings and 19 Colt Data Centers as well as connecting a further 85 cities including New York, Boston, Newark and Chicago in the USA. Colt has operations in the following countries: Germany, United Kingdom, France, Spain, Italy, Switzerland, The Netherlands, Belgium, Austria, Sweden, USA, Denmark, Norway, Portugal, Ireland, and Finland. The Company is headquartered in Luxembourg, but its main centre of operations is based in the United Kingdom. Responsibilities: Extracted data from various sources like Oracle, Flat file. Created Reusable Transformations using Shared Containers. Customized Data stage applications, Managed Data Stage Jobs and Job Sequences. Used Row generator and Peek stage while testing the job designs.
Involved in Peer review of the DS Job Designs.

Worked with Local and Shared Containers. Used Row generator and Peek stage while testing the job designs Written Custom Routines to satisfy the customer requirements
PROJECT#3 PROJECT#1 Project Name : EDW for VIVO Telecom. Client : VIVO Telecom, Brazil. Role : Data Stage Developer. Team Size : 8 Environment : Accentual DataStage7.5x2, Busin Objects, Oracle, and UNIX.
Description: Vivo Telecom is one of the largest Telecomunication companies in and it is controlled by the groups Portugal Telecom and Telefonica, is the mobile. Telecommunication Company that offers best quality in phone call according to anatal. The qualities that differentiate vivo from its competitors include the search for excellence in its services as well as in its relationship with customer, a large portfolio of services, especially innovative services of voice and data transmission, like access to mobile broadband internet, video transmission and other on-line communication formats This project involves Data Warehouse Development with integrated Data Marts spanning VIVO Core Enterprise Business processes to leverage trends and patterns hidden in the histarical information on customers, service demand and revenue. By using this project the help of multi dimensional analysis feature. This project is mainly divided into three categories. Data modeling, data extraction transformation loading, report generation. My part is to implement the data acquisition process. In the present Data Warehouse we have around 25 dimension and fact tables. After loading the data into warehouse system data will be loaded into various data marts. The warehouse data again classified into four subject areas. Those are customers, usage, revenue, subscription. 4
Responsibilities: Understanding the client requirements by studying functional documents. Implemented many transformation activities in DataStage Used DS Designer, DS Manager, DS Director Client components. Involved in Peer review of the DS Job Designs Performed in Unit Testing of the job designs based on the test script document

Chinnayachari.K Mobile No: 9704437869

Uploaded by

Copyright:

Available Formats

Chinnayachari.K Mobile No: 9704437869

Uploaded by

Document Information

Original Title

Copyright

Available Formats

Share this document

Share or Embed Document

Sharing Options

Did you find this document useful?

Is this content inappropriate?

Copyright:

Available Formats

Chinnayachari.K Mobile No: 9704437869

Uploaded by

Copyright:

Available Formats

Chinnayachari.

chinnayachari.datastage1@gmail.com Mobile No: 9704437869

Involved in Peer review of the DS Job Designs.

You might also like