Sr SAS Developer & Analyst

Ravindra Jaladanki

Computer Science Corporation India Pvt. Ltd.

Mob:+91-974*******

mail:********.*********@*****.***

Objective:

• Looking for good career and share my skills/experience on challenging projects involving extensive use of current IT developments to productively contribute towards the growth of the Company thus grow professionally.

Experience Summary:

• Having around 6 years of Experience in developing & implementing reports using Business Objects Intelligence and Data Warehouse applications

• Expertise in Business Objects 6.5 and XIR2/R3 (Administration ,Designer and Reporting)

• Programming expertise in Oracle SQL and PL/SQL.

• Good Knowledge in Data warehousing Concepts

• Good Knowledge on ETL Tool Informatica and Dashboard tool Crystal Xcelsius.

Technical Certification:

• Oracle 1Z0-007: Introduction to SQL

• Informatica 8 Mapping Design Certification

Work Experience:

• Currently working as Software Engineer with CSC India Pvt. Ltd., Bangalore from April 2010 to till date.

• Worked as Associate Consultant with Oracle Financial Services software Ltd. (Formerly known as I-flex Solutions Ltd.), Bangalore from October 2005 to March 2010.

Overseas Experience:

• From May-2010 to Feb-2011 at Doha (Qatar) – Development and implementation of Commercial Data warehouse for Qatar Airways Doha.

• 5 Months at U.A.E (Dubai) – Implementation of Central Bank Reports for Barclays Bank PLC Dubai.

• 6 Months at South Africa (Johannesburg) – Implementation of FLEXCUBE BO Reports (Transaction) for Barclays Bank PLC India

• 5 Months at South Africa (Johannesburg) – Implementation of Internet Banking Application Upgrade and requirement gathering / Implementation of BO reports.

• One month at Uganda (Kampala) – Requirement gathering of Central Bank Reports for Barclays Bank PLC Uganda.

Educational Details

B.Tech (Information Technology), S.V.N.E.C, Tirupathi, J.N.T University, A.P, India (2000-2004)

Technical Skills:

Databases : Oracle 9i, &10g

Other Tools : Business Objects ( 6x, XIR2/R3), Informatica and Xcelsius

Languages : SQL, PL/SQL

Operating Systems : Windows, Unix

Career Profile:

Project#1 : Commercial Data Warehouse(CDW)

Client : Qatar Airways(Onsite in Doha from May 2010 to Feb 2011)

Duration : Apr 2010 to Till Date

Technology : PL/SQL, Business Objects XIR2/R3, Webi, Informatica 8.6

Location : Doha, Qatar and Offshore.

Role

:

Team Lead.

Description (in brief): CDW is a crucial project in commercial department of Qatar Airways, there are many applications and internal processing which provide transactional data. CDW project involves in building data warehouse system with centralized business rules which converts data into useful interpreted information. Various Datamarts are created for each module such as Flown, Budget, Bookings etc. and many reports are created based on user requirement which helps the users in integration of information, consistent interpretation of information, faster decision making, bring down cost ownership.

CDW provides the information on Flown Details for the closed month, Bookings, Ticketed percentage and Forecast for the Current and 6 Forward Months and also provide the Market information with respect to the Agents and Competitors. The information is being analyzed at the Point of sale, Month, Cabin and O&D or Sector level.

Responsibilities:

• Involved in Requirement Gap Analysis.

• Involved in Development and testing of Business Object Universe and documentation of the same.

• Development and Testing of Webi Reports from Datamarts as per the requirement

• Created Procedures and Functions to extract the data from different sources

• Created scripts for data validation from the data extracted from ETL jobs.

• Implemented Security Features of Business Objects like row level, object level and report level to make the data secure.

• Involved in User discussions and understanding the functionality of the modules.

• Performed unit testing, system testing and user acceptances test (UAT) for universe and the data extracted.

Project#2 : Development & Implementation of IFE Upgrade Flexcube corporate and reports

Client : Barclays Bank PLC Uganda.(Onsite for five months for Implementation)

Duration : Apr 2009 to Mar 2010.

Technology : PL/SQL, Business Objects XIR2, Webi, Unix

Location : South Africa and Offshore

Role

:

Team Lead.

Description (in brief): Internet Front End (IFE) is a online banking interface for Corporate customers of Barclays Bank.IFE has been upgraded as there is a change in the requirement from the business of Uganda. There are changes that need to be done in the core Flexcube system and reports related to IFE. This project includes the development and implementation of the IFE changes i.e. corporate customer can book the LC, FT and other transactions related to Flexcube Corporate from IFE.

Responsibilities:

• Developed reports for reconciliation and other MI reports for business to reconcile the data initiated from IFE.

• Involved in preparing the requirement specification for the reports related to IFE.

• Involved in implementation of the changes in onsite for UAT

• Involved in code movement from UAT to production

• Usage of new functionalities related to IFE has been explained to business

Project#3 : Enhancement and Development of Flexcube Reports

Client : Barclays Bank PLC.

Duration : Oct 2008 to Mar 2009.

Technology : PL/SQL, Business Objects XIR2, Webi, Unix

Location : Offshore

Role

:

Team Lead.

Description (in brief): Flexcube implementation for Barclays Bank is done in 5 countries and each country needs different set of reports as part of the enhancement. Based on the client requirements the Central Bank Regulatory Reports are developed from FRS system which will extract the data from both corporate and retail systems.

Responsibilities:

• Development and customization of regulatory reports as per business needs.

• Involved in preparing the Requirement specifications for the new reports and the existing modified reports

• Interacted with users and done Gap Analysis of the existing reports and prepared RS and got signoff from users

• Developed reports are thoroughly tested and sent to onsite for deployment

• Involved in PL/SQL code changes to extract the data as per the business requirement

Project#4 : Reports development from Flexcube

Client : Barclays Bank PLC Uganda ( Onsite for one month to Requirement Study)

Duration : Feb 2008 to Oct 2008

Technology : PL/SQL, Business Objects XIR2, Webi, Unix

Location : Uganda and Offshore

Role : Team Lead

Description (in brief): The bank needs to develop Site-specific Reports, Data Operational Reports, Central Bank Reports and Finance Reports for the modules of Loans, CASA, Term Deposit used by the bank from the FLEXCUBE Corporate and Retail banking software.

Barclays Bank Uganda needs Regulatory Reports which are to be submitted for Central Bank. FRS is a Reporting service which uses data from Corporate and Retail banking applications from which BO reports are generated.

Responsibilities:

• Involved in Requirement gathering for Central Bank reports and Ad-hoc reports from users.

• Design and development of Business Objects Universes, which suits the standard, analytical reporting requirement of the users.

• Involved in the trouble shooting of universe schema with loops, chasm and fan traps.

• Created and tested classes and objects to organize the universe

• Done PL/SQL coding to extract data from the source systems which is useful for developing Regulatory Reports.

Project#5 : Flexcube Data Repository and Bank MI Reports

Client : Barclays Bank PLC UAE ( onsite for 5 months to Dubai )

Duration : June 2007 to Jan 2008

Technology : PL/SQL, Business Objects 6.5, Webi 6.5, Unix

Location : Dubai and Offshore

Role : Team Member Onsite Coordinator

Description (in brief): FLEXCUBE Reporting Services (FRS) Application provides an integrated data repository solution for generating periodic reports and for data interface to external systems required by the bank. The Bank requires generation of various categorical reports at various periodical intervals these periodic reports are based on the snapshot of the data as on the reporting date. The data for these reports are extracted and are processed from FLEXCUBE (FCC & FCR). The FRS will thus be a source of assured data to feed those Reports, which are expected to be generated from the FRS. FRS extracts the data from FCC and FCR into FRS database, which will be used to create Business Objects reports.

Responsibilities:

• Using PL/SQL Code, Data is extracted, transformed and Loaded using ASCII Files from main source tables to Reporting System.

• Developing the Regulatory Reports using Procedures.

• Creation of Ad-hoc Reports for Online Reporting

• Involved in changing the reports as part of UAT

• Created multiple Universe and Document domains to maintain a single repository for multiple countries.

Project#6 : Flexcube Reporting System

Client : Barclays Bank PLC India ( Onsite to South Africa for 6 months )

Duration : August 2006 to May 2007

Technology : PL/SQL, Business Objects 6.5x, Webi

Location : South Africa and Offshore

Role : Team Member

Description (in brief): Flexcube Reporting System (FRS) is integration of Both Flexcube Corporate and Flexcube Retail modules from which the Reports related to Finance and other departments of the Bank will be developed. All the Central Bank reports from FRS and Ad-hoc reports from Flexcube Corporate are developed for Barclays India.

Responsibilities:

• Development of the reports using both universe based and freehand sql Reports.

• Developing and modifying the reports according to business logic.

• Involved in creating the repository in Business Objects.

• Resolved loops by creating Aliases and Context.

• Implementation of Universes, Reports and PL/SQL Packages as per the requirement which includes tuning.

• Developed and created classes with Dimension, Detail & Measure Objects and specified the hierarchies.

Project#7 : Business Objects Report Development

Client : Tachong Bank Taipei.

Duration : December 2005 to June 2006

Technology : Oracle 9i, PL/SQL Business Objects 6.5x, Webi

Location : Offshore

Role : Team Member

Description (in brief): An MIS System, the data is extracted from Flexcube Corporate and Retail Modules. A universe was built on this system to develop the Reports. Data is extracted from FLEXCUBE in the form of ASCII Files. The data is loaded into the data mart using SQL LOADER. Data transformations were built using PL/SQL and the various dimensions and facts are loaded.

Flexcube Reporting Services (FRS) is integration of Both Flexcube Corporate and Flexcube Retail from which all the Reports related to Finance and other department of the Banks will be developed. This FRS includes all the modules from both Corporate and Retail. All the Central Bank reports and Adhoc reports are developed for Tachong Bank.

Responsibilities:

• Development of Business Objects Reports for FOREX and Treasury Modules.

• Involved in debugging of PL/SQL coding.

• Changes in universe were done as per the requirements from the user.

• Involved in end to end testing of reports and universe.

• Delivering the Reports and Universe to onsite team for production release.

• Created filter conditions, prompts and objects as per the user requirement.

Contact this candidate