Sales Sql

Poppey J Padinjaremuriyil

*********@*****.***

305-***-**** (Home) 305-***-****(Cell)

Business Objects Developer

Summary:

. Growth Oriented Professional with experience in Data Analysis,

Architecture, Design, Development, Implementation and Support of DW

Solutions and Core Banking Applications.

. 6.0 Plus years of Professional Programming experience using Business

Objects (BO XI R2, BO 6.5, and BO 5.0) and expertise in Flexcube (Core

Banking System by Oracle Financial Services) and 3 years of Production

support expertise.

. Sound knowledge of the Banking Domain and worked with different areas

such as FX, Loans and Deposits, Money Market, Lending, Fixed Assets,

Fund Transfer, Retail Banking, Net Banking, ATM, POS etc.

. Well versed with complete Life Cycle Development process that includes

Designing, Developing, Testing and Implementation and Post Production

support.

. Well versed in BO Designer and BO Universe and was a member of 3 full

Life Cycle implementation projects.

. Expertise in DDL commands, stored procedures, functions and database

triggers using databases like Oracle 10g and SQL Server.

. Extensive Expertise in programming languages, development

environment/tools, configuration management, porting to platforms,

build management, administration and testing.

. Have worked with leading banks in the Middle East and India Such as

BARCLAYS BANK PLC, DUBAI ISLAMIC BANK, IICG, HDFC BANK etc.

. Well experienced in writing Complex queries, stored procedures,

functions, cursors and packages using PL/SQL Programming

. Expertise in working Crystal Reports 2008 and 10

. Experience in Installation and configuration, Creation of repositories

and security domain with user groups and security implementation

Technical Skills:

Languages: Java, SQL, PL SQL,C, C++

Operating Systems: Windows XP/2000/NT

Reporting Tools: BO XI 3.1,BO XI R2, BO 6.5, BO 5.0, Crystal

Reports 8,10, Webi, Xcelsius

Flexcube(Core Banking All modules in FCC (Flexcube Corporate) and

Solutions) FCR(Flexcube Retail)

Databases: MS Access, SQL Server 2000, Oracle

10g.9i,8i,8

PROFESSIONAL EXPERIENCE:

Barclays Bank PLC, Dubai

OCT 2007 - MAR 2010

Position: BO Consultant.

Barclays Bank PLC is a prominent Banking service industry providing banking

services to various clients across the globe. Gulf Computers works as an IT

consulting Partner for various IT Jobs.

Responsibilities:

. I worked as a Business Objects Consultant in a team of 4 member group

involved in analysis, design, implementation testing, delivering DW/BI

Solutions to their UAT,Stage and Production environments.

. Have extensively worked on development. QA, UAT, and Production

environments.

. Build the new universes as per the user requirements by identifying

the required tables from Data mart and by defining the universe

connection.

. Developed critical reports like drill down, Slice and Dice, master/detail

for analysis of parts benefits and headcount

. Designed RFC's and Change Request using User Cases and deployed reports

and Universes.

. Implemented the ETL process and business logic by using PL/SQL

. Provided training for end users for generating their own report.

. Developed universe/SQL user documentation guide for the end users

reference

. Expertise experience in relational database design, data extraction, and

transformation and writing Stored Procedures, User Defined Functions,

Triggers, DDL and DML SQL queries from large and complex data sources

using Oracle MSSQL Server 2000/2005.

. Proven abilities in creating complex reports by linking data from

multiple data providers, using free hand SQL, stored procedures and

functionalities like Combined Queries.

. Excellent Communication with Customers in Work environment and solving

urgent and important issues

. Extensively used Business Objects reporting functionalities such as

Master Detailed, Slice and Dice, Drilling methodology, Filters, Ranking,

Sections, Graphs and Breaks.

. Expertise Knowledge in Data Warehousing concepts, SQL, design and

development of Universes and for reporting solution in BO for Operational

Reporting System.

Environment / software: Business Objects XI r2, Crystal Reports 2008,

Designer, Desktop Intelligence, Web Intelligence, CMS, Oracle 10g, SQL,

PL/SQL, Windows XP, Flexcube Corporate/Retail.

Ideal Invent Technologies, Bangalore, India

Nov 2006 - Sep 2007

Client: Oracle Financial Services, Bangalore

Position: BO Consultant

'Flexcube' is the top ranked CORE banking solution from Oracle Financial

Services, having more than 300 implementations around the globe. The bank

has implemented the corporate modules of Flexcube, which are capable of

handling high volume of transaction.

Responsibilities:

. I worked as an Associate Consultant in a team of 4 member group

involved in analysis, design, implementation testing, delivering

Solutions to their BO Reporting System and Flexcube Application

Implementation.

. I was responsible for the delivery of the, Business Objects Reports

and WEBi Reports

. I was In charge of the full life cycle of the Business Objects reporting

Application Implementation.

. Have extensively worked on UAT, development and Production

environments.

. Have developed complex SQL, PL/SQL Queries/code to enable user queries to

the database for data access, using triggers and stored procedures

. Created Universes by defining connections against Oracle database.

. Created Reports based on sub total of Currency and General Ledger

category

. Performed unit testing, system testing and user acceptances test (UAT)

for universe, reports and security management

. Created Objects and prepared Reports like financial reports, security

reports, standard and adhoc reports, and universes.

. Involved in joining the tables by creating aliases to resolve the loop

. Prepared many reports by using master details, cross-tabs, slice and dice

and drill mode as per the requirement of the end-user

. Prepared the Report Requirement Specification Document (RRS) and Report

Functional Specification Document (RFS) along with the Sign-off Results

and Screenshots.

. Have conducted end user training for basic and advanced reporting

skills

. Webi Reports created and deployed through Info View

. Defined Aliases and Contexts to resolve loops in the universes

. Created New Classes and User Objects in designing the universes

. Also worked with Oracle Forms and Oracle Reports

. Deputed for an Onsite Assignment at DUBAI ISLAMIC BANK,UAE and IICG,

Jeddah, KSA

Environment / software: Business Objects XI r2, Desktop-Intelligence,

Designer, Info View, Toad9.0, Oracle 9i, SQL, PL/SQL Windows 2000/XP,

Flexcube Corporate, Oracle Forms and Reports

NeST Systems, Cochin, India

Sep 2005 - Oct 2006

NeST act as the system integrators for the bank to implement the Core

Banking solution. It provides both the Hardware and Software service to the

bank. This includes implementation at all the branches, Administering the

data center, help desk, generation of Financial Statement Using Business

Objects etc.

Client: Kerala State Co-operative Bank (KSCB), Thiruvanamthapuram

KSCB is the Apex Bank of the Short Term credit cooperatives in Kerala. It

guides, supervises, coordinates, monitors and controls all the 14 DCB's and

through DCB's to 1587 Primary Agricultural Cooperative Societies (PACS) in

the State. KSCB's active leadership is making the lower tier credit

cooperative institutions more accountable to the rural community.

Project: Implementation of FLEXCUBE

Position: BO Developer.

Responsibilities:

. Generating reports using BO 6.5.1

. Involved in gathering, analyzing, and documenting business

requirements, functional requirements and data specifications about

the financial system for Business Objects Universes and Reports.

. Created New Classes and User Objects in designing the universes

. Generated various reports on Daily, Weekly, Monthly and Yearly basis

. Created User Conditions and Filters to improve report generation &

readability of report and displayed the summary of data by creating

Charts

. Extensively used Calculations, Variables, Break Points, Drill, and

Slice and Dice for generating reports.

. Created reports using Oracle Databases and Personal Data File

Providers

. Involved in development and deployment of Complex Reports.

. Applied sections, Breaks, Calculation, Report Filters and Query

Filters and displayed the information in different Blocks

. Customized LOV' s in Universes for quicker performance of reports

. Used SQL against the database to check data retrieved

. Exported the universes to the Repository making resources available to

the users

. Interacted with the various users for reporting requirements

. Attended several business sessions with the business users and created

Views and altered some of the dimensional tables to satisfy their

reporting needs

. Involved in the Requirement Analysis and Preparation of System

Requirement Specification Document

. Created reports using the Universes and Free-hand SQL as data providers

. Developed Complex reports like Balance Sheet and Trial Balance and

Customer Statements.

. Developed universe user documentation guide for the end users reference

. Have automated report generation process using VB Macros.

. Performed Unit Testing.

. Involved in User Acceptance Test(UAT)

. Prepared Functional Specification Documents and Signoff Documents.

Environment /Software: Business Objects 6.5.1, Desktop-Intelligence,

Designer, SQL Navigator, Oracle8, SQL, PL/SQL Windows 2000/XP, Flexcube

Corporate/Retail, Oracle Forms 6.5 and Reports 6.5, Foxpro, Toad, VB Macro

HDFC Bank LTD., Bangalore, India

Jul 2004 - Aug 2005

Project: Personal Loans

Position: Database coordinator.

The Housing Development Finance Corporation Limited (HDFC) was amongst the

first to receive an 'in principle' approval from the Reserve Bank of India

(RBI) to set up a bank in the private sector, as part of the RBI's

liberalization of the Indian Banking Industry in 1994. The bank was

incorporated in August 1994 in the name of 'HDFC Bank Limited', with its

registered office in Mumbai, India. HDFC Bank commenced operations as a

Scheduled Commercial Bank in January 1995

Responsibilities:

. I worked in a Team of 3 developers to design and develop sales reports

of personal Loans.

. Generation of Sales Reports using Business Objects 5.0

. Monitoring size and growth of the database.

. Maintenance of the test setup database, export/import etc.

. Work with help desk of the bank.

. Help the management in increasing the sales

. Generated reports from the sales and distribution package such as

sales analysis report, profile wise reports etc

. Preparation of Technical documents

. Reports are developed using Free Hand SQL

TOOLS / SOFTWARE: Business Objects 5.0,oracle 8, MS access, MS Excel, MS

PowerPoint,Windows XP / Windows 2000.

Contact this candidate