Project Developer
Resume:
Rajesh C
Mobile: +**-
E-mail:
******.****@*****.***
Professional Summary
V Total 3 years and 8 months relevant work experience of Designing,
Development and end to end implementation in Data warehousing (BI)
technology.
V Worked as tester, developer and Designer (as team member, Module/Team
lead role) in many projects having Data warehousing Technology and
Oracle Business Intelligence platform (focusing Management Information
Systems).
V Relevant experience in developing enterprise data warehouse. Good
experience in Banking, Finance and Health-Care domain.
V My technological expertise is mostly in OBIEE 10/11g, Data Modelling
and Dashboard/Reports development, BI Publisher 10g/11g and expert in
Excel analyzer.
V Working Experience in OBIEE, Oracle SQL, UNIX.
V Fair Knowledge in ETL (ODI, Informatica)
V Skilled in handling Administration and Infrastructure level issues
(OBIEE11g Installation, patches, designing, modelling and full
Weblogic Administration and infrastructure capacity planning exposure.
V Good experience in BI Publisher Report building (from SQL/Pl SQL data
source as well as on top of OBI metadata) and scheduling experience.
V Good understanding in PL/SQL code and has involved in performance
tuning at DB Code and RPD/Reports level
V Strong Team building skill, business acumen and satisfactory
communication and presentation skills.
V Willingness to learn new business processes and to work independently
as well as in teams as and when required in proactive manner.
Work summary
. Currently working as a System Engineer in Tata Consultancy Services,
Chennai.
. I had worked in eattributes soft technologies Pvt. Ltd, Chennai.
Education Qualification
Bachelor of Computer science engineering from Anna University with an
aggregate of 69%.
Technical skills
|System Design and |Management Information System (MIS) |
|Development |development and Support using Data |
|Experience |Warehousing Technology |
|Software Development|Requirements Collection & Study |
|Life Cycle |Impact Analysis |
|Experience |System and Application Development |
| |Application Implementation |
| |Application Testing |
| |Application Management, Support & Maintenance|
|Operating System |Windows 95, 2000, 2003 & XP |
|Experience |UNIX System V release 4.0 |
|Database Experience |Oracle 10g/11g |
|Tools Experience | SQL*Plus, SQL Developer |
| |Oracle Business Intelligence(OBI),OBIEE |
| |BI Publisher, Excel Analyzer. |
| |Informatica 8.6 |
|Domain Experience |Banking, Health Care and Insurance |
|Learning Tools |Oracle Data Integrator(ODI) 10g/11g |
|Production Support |BMC Remedy, Tortoise SVN |
|Tools | |
Project profile
Project 1:
Project Title : Storm II - Operational Reporting.
Client : Standard Chartered Bank.
Role : Data Modeler and report developer.
Environment : OBIEE 11g, Oracle 11g, Linux.
Project description:
STORMII & STREAM OBIEE project is a Reporting System Initiative which
focuses on designing Country Dashboards consisting a set of reports used
for following:
. Client Reporting - Reports sent to clients to fulfill their
requirements
. Regulatory Reporting - Reports required by the regulators
. Audit reporting - Reports required to cover audit
. Functional/Operational Reporting - Reports required for day to day
function/operation
. MIS reporting - Reports for update Management /stakeholders
These reports are for SCB operational users sitting in front office and
their clients with the selected financial and Non- Financial
metrics/information. This reporting system initiative focuses on designing
different Country and Global Dashboards and to automate and publish the
dashboards on an online and real time interface apart from creating a
metadata repository for creating Adhoc reports. This system will be
released to SCB operational users and front office users to support their
day to day operational reporting requirements (traditionally done by NCS or
other third party tools such as spreadsheet or VB basic programs) . The
main objective is to give the Bank more user friendly GUI based reporting
solution where apart from predefined reports and dashboards they can make
own customized reports by themselves.
Responsibilities:
. Analysis,design and developments of requirements
. high level design,low level design
. Deliver complex high quality solutions to clients in response to varying
business requirements.
. Writing various technical documents to fulfill the Project
lifecycle(Architecture document, Technical design document, High level
design document, Low level design document)
. Effectively communicating with the team in order to carry out assigned
tasks as a team and to provide day to day direction and regular project
status.
Project 2:
Project Title : Clinical decision support system.
Client : A healthcare major in US.
Role : BI Developer.
Environment : OBIEE10g, Informatica 8.6, Oracle 10g, Windows.
Project description:
The requirement was to provide the key metrics to the top management
of the hospital to operate efficiently and to comply the US healthcare
quality and reporting standards set by Joint Commission International.
Following KPAs are designed in Financial and Quality dashboards:
. Hospital mortality rate by disease
. Hospital mortality rate by age demographic group (infant, adult male,
adult female, new born etc)
. Month wise incidents of hospital acquired infection
. Disease wise incidents of hospital acquired infection
. Top ten diseases by revenue generation
. Top 10 rooms by revenue generation
. Top insurance plans by revenue generation
Responsibilities:
. Primary responsibilities include gathering business requirements,
designing the functional and technical specifications.
. Involved in Creating and Administering the Physical Layer, Business
Model & Mapping Layer and Presentation Layer using Oracle Business
Intelligence Admin tool.
. Created connection pools, physical tables, defined joins and
implemented authorizations in the physical layer of the repository.
. Created Dimensional Hierarchy, Level based Measures and Aggregate
navigation in BMM layer.
. Managed security privileges for each subject area and dashboards
according to user requirements.
. Created groups in the repository and added users to the groups and
granted privileges explicitly and through group inheritance.
. Developed custom reports/Ad-hoc queries using Oracle Answers and
assigned them to application specific dashboards.
. Developed different kinds of Reports (pivots, charts, tabular) using
global and local Filters.
. To load via staging tables in the ETL Layer.
. Enhancements for the Change requests using informatica.
Project 3:
Title : MDM (Master Data Management) Development
Role : BI Developer.
Client : A Leading Health Insurance Provider in U.S.
Environment : Informatica 8.6, Flat Files, Oracle10g, OBIEE10g, Windows.
Description:
It is one of the leading healthcare insurance providers in U.S,
earlier they used a legacy system which is not actually helping them to
achieve the business goal of the company, to overcome this problem they
have started a program called MDM. MDM project will be using Informatica to
create interfaces to handle the functionalities that exist in current
system. The project also involves implementing the OBIEE Reports. Each
interface deals with different functionality and different set of system
for getting and publishing data. Data which is published by the interface
will be used by an application for user to make any updates required.
Responsibilities:
. Validation of Business Rules.
. Created connection pools, physical tables, defined joins and
implemented authorizations in the physical layer of the repository.
. Created Dimensional Hierarchy, Level based Measures and Aggregate
navigation in BMM layer.
. Managed security privileges for each subject area and dashboards
according to user requirements.
. Developed custom reports/Ad-hoc queries using Oracle Answers and
assigned them to application specific dashboards.
. Developed different kinds of Reports (pivots, charts, tabular) using
global and local Filters.
Personal Details:
Date of Birth : 27th September 1987.
Father's Name : R Chandrasekaran.
Permanent Address : 21 Kamatchi Amman Lane,
Thuraiyur.
Trichy District,
Tamil Nadu.
Pin code: 621 010.
Languages Known
(Speak & Write) : Tamil, English.
Passport No : H3629945
Date : Rajesh C
Place : Chennai.
Contact this candidate