Sr SAS Developer & Analyst

SAI CHARAN.D

Contact: 099********; E-mail: ******.*****@*****.***

________________________________________

OBJECTIVE

Quest to work in a professional environment which will enable me to keep in line with emerging as well as the latest technologies and provides scope for widening the spectrum of my knowledge.

PROFILE

 A dynamic, result-oriented and accomplished professional offering 1.6years of experience in Data Warehousing

 I acquired a comprehensive grasp on Datastage technology. Expertise in Data warehouse concepts like dimensional modeling, Star Schema, Snowflake Schema, ETL

 Extensively used etl methodology for supporting data Extraction, Transformation and Loading processing in a corporate-wide-etl solutions using data stage 8.0.1

 Worked with different data sources like flat files and databases

 Proficient in developing slowly changing dimensions (type ii) to keep and track of historical data

 Good understanding of data stage architecture, client and server components

 Good knowledge in SQL.

 Knowledge of all phases in software development life cycle(SDLC)

 Knowledge on data warehousing reporting tool-Cognos

 Analytical and able to adapt to new environments and learn new technologies quickly

 Creative problem solver,able to think logically and pay close attention to detail. Good communicator, proficient at gathering user requirements and customizing database solutions as per need

 A strong team leader and motivator, fostering an atmosphere that encourages highly talented professionals to balance high level skill with maximum productivity with exceptional planning, execution, negotiation and interpersonal skills

 Proven, strong project & people management skills. Exceptionally well organized with a track record that demonstrates self-motivation, creativity and initiative to achieve both personal and corporate goals

________________________________________

TECHNICAL SKILLS

Operating System Windows 2000,UNIX,AIX

ETL Tools Datastage 7.5 PX,8.0.1

Database System Oracle 9i, 10g, DB2

Languages C, JAVA,SQL

Management Tools Ms-Word, Ms-Excel and Ms-PowerPoint

Interfacing tool Putty

________________________________________

WORK EXPERIENCE

 Working as Software Engineer for T-SQUARE INFORMATION SYSTEMS PVT LTD ,Hyderabad from Jan 2009.

PROFESSIONAL EXPERIENCE

Project Title : Advantage National Bank Datawarehouse

Client : Advanta National Bank

Role : Datastage Developer

Environment : Datastage 8.0.1,oracle 9i and windows 2000

Project Description:

This project is involved in the development of data warehouse for ANB based on four kinds of data marts such as accounts, loans, credit cards, and insurance. Each data marts represent a collection of data pertaining to a single business process. In loan data mart ANB involved in disbursal of loan amounts for various purposes like: personal loan, educational loan, vehicle loan, housing loan, consumer durable loans, etc. The company requires different level of analysis regarding loan amount, type of loans, type of customers, type of payment schedules, interest rates (variable or fixed), defaulters list and the penal interest calculations, etc. They needed a data warehouse so that they could maintain historical data and central location for integration, analyze business in different locations, according profit areas, which could serve a purpose of a dss for decision makers.

Responsibilities:

 Understanding the Technical specifications and Mapping techs provided by the Client

 Involved in the Design and development of Datastage mappings.

 Developing the jobs according to business logic.

 Involved in Data Extraction from Oracle, Flat files.

 Mapping Data Items from Source System to the Target System.

 Creating the Data Stage jobs using transformations.

 Developed jobs using various stages Transformer, Aggregator, Lookup, and Sequential File

________________________________________

EDUCATION & PROFESSIONAL DEVELOPMENT

POST GRADUATION ( MCA ) 2009

NIET, JNT University, 74%

BACHELOR OF SCIENCE (Maths, Electronics and Computer Science) 2006

Nizam College, Basheerbagh, Osmania University 68%

INTERMEDIATE 2003

Ideal Junior College , dilshuk Nagar, Hyderabad, 86%

SSC 2001

Siddhartha High School, Vanasthalipuram, Hyderabad, 77%

EXTRA CURRICULAR ACCOLADES

 Active participant in sports & other competitions at school and college level.

 Actively participated in Debates and organized parties at college.

 Gave a paper presentation on Nano Technology and got first prize.

________________________________________

PERSONAL DETAILS

Father’s Name: Vishwanatham.D

Date of Birth: 01 October 1984

Martial Status: Single

Language Proficiency: Hindi, English & Telugu

Hobbies: Playing guitar, browsing net, playing volleyball and basketball.

________________________________________

DECLARATION

I here by declare that all the statements in this application made are true and correct to the best of my knowledge. I will be solely responsible for any wrong information made in this form.

Date:

Place: Hyderabad, A.P.

(Sai Charan.D)

Contact this candidate