TONY ALEX. S No **, II nd
Floor,(Vesta Building)
II nd Street Sivaprakash
Nagar,
Puzthivakkam,
Chennai - 600 091
Tamil Nadu - India.
Mobile: +91-
Email-id: -
**********@*****.***
Objective:
Looking for a challenging position in software development, where my
skills can be utilized to the development of the organization and better
career growth.
Summary:
. Overall 8+ years of experience in analysis, design, development and
testing of client server and multi-tier architecture applications
using Business Objects XI R2 / R3.1 Administration, Universe design,
WEBI/ Crystal Reporting and BO integration using SDK on J2EE, .NET
& SharePoint application in Banking & Retail domains in both Windows
and Linux platforms across globe.
. Responsible for installation, configuration and management of Business
Objects product suite (CMC, CMS, Designer, Reporter, Webi & Crystal
Reports) and apply Service Packs to individual client/servers
. Managing Licenses, Data sources & Connections, Users and Groups Server
Management Tasks, using Central Configuration Manager (CCM) and
Central Management Console (CMC).
. Managing Schedules/refreshes, Instances and monitoring Clustering of
Central Management Server (CMS) machines & Configuration of Web
Application Server
. Configuration of File Repository Servers, Cache and Page Servers, LOV
Job server, Web Intelligence Job and Report Servers, Desktop
Intelligence, Job, Report and Cache Servers, Destination Job Server,
Program Job Server, Event Server and auditing database
. Performed Business Objects Environment management including sizing,
capacity planning performance tuning and security administration.
. Configuring and maintaining the security framework for the Business
Objects repository and created the users / groups, administering user
accounts and privileges for repository users and implemented backup
strategy
. Expertise in Universe designing, developing and generating complex,
Adhoc, dashboard Reports, Business views, List of values along with
User Acceptance Test and data accuracy Test & Fine tuning of reports
both from Crystal and DB end.
. Frameworks developed to Integrate BO XI R2 & Crystal Reports with
ASP.Net & JSP Screens using BO SDKs.
. Worked with web technologies application server environments (ASP.NET
& JSP ) and web servers (IIS) and Tomcat 5.1
Work Experience:
MAR 2010 - Till Date
. Working in WIPRO TECHNOLOGIES CHENNAI - DWH Business Objects -
Technical Lead / Architect
Apr 2007 - MAR 2010
. Worked in SCOPE INTERNATIONAL PVT Ltd., CHENNAI - Lead Designer.
Jul 2005 - Apr 2007
. Worked in ESQUIRE SYSTEMS CHENNAI - Programmer Analyst (Outsourced
to Scope International Pvt. Ltd.)
Jan 2001 - Mar 2005
. LANSON GROUP, CHENNAI - Senior Software Engr.
Jun 2000 - Feb 2001
. TROIKA TECHNOLOGIES, CHENNAI - Programmer
Education:
M.C.A - First Class (68.5 %)
[pic] Bishop Heber College (1997-2000), Trichy - 17
Bharathidasan University - Trichy
B.Sc. (Physics) - First Class (88.5 %)
[pic] Aditanar College (1994-1997), Tiruchendur,
Manonmanium Sundaranar University - Tirunelveli.
Technical Skills
Report Server Administration : Business Objects XI R2 & R3.1 Enterprise
Admin (both Linux & Windows)
Web Reporting : Business Objects Web Intelligence /
Universe Design
Reporting Tools : Crystal Reports XI, xCelsius, Jasper
Reports
Databases : Teradata 12, Oracle, IBM DB2 & SQL Server 2005
ETL : Informatica 8.6
Programming Languages : Java 2.0, C++
Graphical User Interface : VB.NET / C#, Visual Basic 6.0
Windows Shared Services : MOSS 2007
Internet Programming : ASP 2.0, ASP.NET 2.0, JSP, VB Script, Java
Script, HTML, XML
Operating Systems : Linux 4.3 / Windows NT 4.0 / 98 / 2000 / XP
Projects
> MPM - Matrix Performance Management
Client : Wipro @ Best Buy - US
Software : Business Object XI R3.1 / Teradata
Role : Design & Architecture
Description: The MPM (Matrix Performance Management) project will provide
an integrated performance management capability in order to streamline
analysis, insight and decision-making across the organization. Listed
below are the key points in the case for change for Corporate Performance
Management teams.
* Metrics
o Various systems produce a disarray of metrics making it difficult
to determine "one version of the truth"
o Lack of system integration causes the business to spend large
amounts of time pulling together data and reconciling instead of
analyzing and making decisions
o The business needs a consistent customer view in order to boost
growth and drive customer retention
* Customer
o Corporate and vendor inability to view customer segment data
inhibits the ability to meet the customers' needs
* Trends
o Corporate business analysis and processes, focusing on point-in-
time information instead of trends, focuses attention on one day
instead of looking at longer term customer and market needs
o Business process is reactive to daily fluctuations instead of
driving proactive decisions based on market changes and trends
* Insights
o Lack of an integrated performance management process creates
differing insights and additional time and effort
* Process
o Limited access to consistent analytical data makes the budget and
forecasting processes sub-optimal
* Analytic Capability
o Ad-hoc, time intensive, and duplicate analytics provided by multiple
resources
> LABOR DRILL DOWN & FORECAST
Client : Wipro @ Best Buy - US
Software : Crystal Reports XI / Teradata
Role : Design & Architecture
Description: Labor Drilldown Report: This is a Retail Report containing
Revenue, Labor and Labor Productivity data. It can be run for any
timeframe available with the exception of day. The purpose of this report
is to enable the review of Labor Expense in comparison to Labor budget,
Labor 1/2 Rule Guidance and Store Forecasted Labor. The report allows for
performance review for current and archive time dimensions as well as the
various geography dimensions such as Store, District, Territory and Company
by individual Labor Departments.
Labor Forecast Report: This is a Retail Report containing future, or
budgeted Revenue, Labor and Labor Productivity data. While it is very
similar to the Labor Drilldown it looks at 2 future weeks. This is used
operationally for stores to modify their labor schedules.The purpose of
this report is to give a view to Labor Expense to Labor budget, Labor 1/2
Rule Guidance and store forecasted Labor for future week labor planning.
The report displays future week's information which is important for
forecasting. Productivity plans by Labor Department is also included on
this report.
> BBY EXPRESS
Client : Wipro @ Best Buy - US
Software : Business Object XI R3.1 / XCelsius / Teradata
Role : Design & Architecture
Description: Best Buy Express has new territory code that needs to be
added to the existing Crystal reports to pull the financial information per
territory. The main purpose of the report is to provides financial,
operational and customer reporting by Territory for the OG Hierarchy levels
(Senior VP, VP, Merch Lead and Class).
This Territory Report is accessed via the MPM Dashboard UNIVERSE from the
My Matrix Portal when the View selected is Territory. The parameters
passed from the MPM Dashboard Universe to the Crystal reports which drives
the data filters applied. These parameters are Hierarchy (My Stuff, My
Business, My Focus, or US SBU) and Time (Daily, Weekly, or Monthly).
> Business Object XI R2 Online, Batch & eStatement Customization for Core
& Non Core Banking Application
Client : Standard Chartered Bank
Role : Design, Architecture & Administration
Team : COE
Software : Business Object XI R2 on RedHat Linux 4.3 / IBM DB2
V9.5
Description: Restructuring the basic architecture of Crystal Enterprise 10
which was running under IIS, Considering the severities, downtime and
stability of crystal services the migration is suggested to latest
version of Business Objects XI R2 on Redhat Linux 4.3 having tomcat as web
server. This migration was achieved by developing Online, scheduled
reports / fax reports java/JSP files using Business Objects SDKs. And
architecture was successfully rolled out to all Ebbs Countries.
Additionally Java class Utilities were developed to convert rpt files to
PDF format.
.
> Business Object 115 R2 / R3.1 - Report Server Administration on Cluster
Environment
Client : Standard Chartered Bank
Role : Design & Administration
Team : CORE BANKING / NON CORE BANKING PRODUCTION SUPPORT
Software : Crystal Enterprise 10 / Business Objects XI - R2 on
Linux 4.3 / IBM DB2 V 8.0
Description: Providing extended support and Administration for the
following countries having CE report servers.
Malaysia, Indonesia, Thailand, Taiwan, UAE, Oman, India &
Nigeria
a) Managing the CE servers End to End. Installing & configuring the CE
servers for each and every country report servers.
b) Creating the Page and cache servers according the no of CPUs and CMS.
c) Publishing the report objects, scheduling as well as extracting.
(Automated tool for this and it has been awarded)
d) Creating and managing user groups as well as users in CE servers.
e) Taking care of the backups of SQL server in built database of CE.
f) Trouble shoot, stop/start as well as yearly shutdowns.
g) CMS Cluster using Remote DB2
> Global Lending Origination System (GLOS)
Client : Standard Chartered Bank
Role : Design & Architecture
Team : Consumer Banking
Software : Business Objects XI - R3 - Universe Design
Description: Global Lending Origination System (GLOS) is an Application
Processing System for processing all Credit Cards and Personal Loan (CCPL)
Products. The system will be first launched in Hong Kong. Eventually it
will be rolled out to other countries and retail asset products as well.
For this system, developed an Online and Batch Reports framework for
standard reports using Java / JSP interface and deployed on tomcat running
in Windows 2003. Additionally emailing system is integrated by SMTP
configured in Business Objects Enterprise Server.
> Technology Management Office (TMO)
Client : Standard Chartered Bank
Role : Design & Architecture
Team : Group Functions
Software : Business Objects XI - R2 - Universe Design
Description: Design and developed Business Objects Universe using Oracle
Instance and deployed and trained to end users in designing adhoc reports
using Web Intelligence. This solution is used to anlaysis Project resource
utilization, Timesheet, project delivery time and also measure the quality
of project delivery.
> EBBS INDIA (Reports Distribution & Decollation Framework)
Client : Standard Chartered Bank
Role : Design & Architecture
Team : EBBS
Software : Business Objects XI - R2 / ASP.NET / C#
Description: Report Archival System is a web based report distribution
solution that enables eBBS users to access end of day reports in a secured
manner from any system across the enterprise. This solution provides end
users the flexibility to export report in which ever format he require.
This has proved to be a very effective solution to our original file
transfer and distribution issues.
After the EOD completion the reports will be generated in report server in
ATOS. These reports will be transferred to two report distribution server
implemented in Mumbai and Chennai over international WAN (IWAN) in .rpt
format in compressed files. The total size of the file size is
approximately 1GB per day. The file transfer will be done with the Tectia
software approved by group through the secure FTP standards as PUSH method.
The report distribution box running on W2k3, having a VB.Net program which
will decompress the files to the actual size and put it in the specified
location.30 days reports will be available in the server and remaining
reports can be taken from the CMOD server which is in ATOS. User can view
the reports in their web browser (DHTML viewer) via report distribution
application deployed in the two servers.
> XREPORTS using Crystal Java Reporting Component (for Offline Branches)
Client : Standard Chartered Bank
Role : Design, Architecture & Administration
Team : COE
Software : Crystal Enterprise XI
Description: This is a plug-in for crystal reports to process and
display crystal reports. This component is plugged in to WAS 5.1 and is
available as default from WAS 6. This plug-in provides a java reporting
engine, which can enable the processing of crystal reports no matter in
which operating system it is developed. This report technology provides the
cost-effective reporting solution to the bank which neglects the need of
dedicated report server and Crystal Enterprise software. This can be useful
in those situations where-in the number of users is minimal. This is now
been used as reporting solution for on-going e-BRANCH offline capability in
the name of x-Branch Reports, where-in the solution will be deployed in
each Branch Servers serving those users of the respective branch. This
solution is successfully implemented in all African - Ebbs Countries
(Nigeria, Zambia, Tanzania, Botswana,Ghana & Uganda )
> NCS Stability
Client : Standard Chartered Bank
Role : Design & Architecture
Team : Wholesale Banking
Software : Business Objects XI - R2 / ASP.NET / C# / ORACLE
Description: The objective of NCS Stability Reports project is to
replicate transaction database, develop and convert the existing MS Access
based query to crystal report and provide user-friendly screens to view and
generate reports. This framework was developed using ASP.Net with MSMQ
Service for schedule reports. The role of MSMQ service is used to queue the
user requests before submitting to BO. The Scheduled output will be stored
inbox with an alert message to the end users by selecting desired formats
(XLS, doc & PDF etc). Thus the architecture consumes the minimal named
license to serve maximum request asynchronously.
> COLLATERAL MANAGEMENT SYSTEM (CMS)
Client : Standard Chartered Bank
Role : Design & Administration
Team : COE
Software : Business Objects XI R2
Description: Developed a tool to split Saved Reports (rpt Format) based on
primary grouping (Country) and Sub grouping (ARM). The all-branch reports
contain a primary grouping which is based on Branch Code and a sub grouping
which is based on ARM code. This tool can split the reports based on the
primary grouping as well as the sub grouping without requiring any change
to the existing report format. The output formats supported are RPT, PDF
and Excel. Each generated report would contain data pertaining only to a
specific branch or ARM. This would reduce the network bandwidth utilization
during report distribution apart from ensuring that only relevant
information is sent to the end user.
> EBRANCH - MALAYSIA, INDONESIA, THAILAND, TAIWAN, INDIA & NIGERIA TELLER
Client : Standard Chartered Bank
Reports : Crystal Enterprise 10.0 & Crystal Reports
Role : Programmer Analyst
Description: EBRANCH serves as an interface between Malaysia branch users
and HOGAN - the host system in SCB, Malaysia, Currently the interface is
provided by Pinnacle - an application implemented using proprietary
hardware and software and It is a browser based system and having the
following modules.
1. Financial Transactions
2. Phone Banking
3. User Daily Operations
4. Till Management
5. Enquiries
6. Reports
> Research on Web (RoW integration with CMS/ Cazenova)
https://research.standardchartered.com/Pages/home.aspx
Client : Standard Chartered Bank - Whole Sale Bank
Role : Design & Architecture
Software : ASP.NET / C# / SharePoint / SQL SERVER 2005
RoW is part of the family of Standard Chartered website properties. It
follows its current place in the Standard Chartered business hierarchy as a
sibling of the Wholesale Bank website, which is itself a sibling of the
main Standard Chartered .com
global website. Though it uses the family look and feel from its parent
sites, RoW uses additional design, functionality, content, and back-end
elements that are unique to RoW.
The site is largely informed by a Browse, Discover and Promote approach.
Browse routes are those where the user actively chooses a navigation option
from the main navigation, or browses through lists of search results.
Discover routes start on the homepage and accompany the user in their
browse route to provide additional options that can enable users to
discover content they would not otherwise actively be aware of. Promote is
largely an area on the right-hand-side of the site that provides access to
content that is promoted based upon the content that a user has chosen to
view.
> ORACLE BUSINESS INTELLIGENCE / COGNOS - PERFORMANCE BENCHMARK TESTING
Client : Standard Chartered Bank
Role : Design & Administration
Team : COE
Description:
. Benchmark testing designed to test the performance and scalability of
Cognos 8
. Benchmark conducted with Essbase, Oracle and Cognos
. The risk application was selected for the performance testing
. Scalability of the application was tested with 150 and 300 concurrent
users each operating in mixed mode: ad-hoc reporting and report
viewing / drill downs
> Service Appointment Schedule & ENS
Client : Lanson Toyota
Software : VB.NET / Oracle 8.0 / SQL SERVER / Crystal Reports
8.0
Responsibility : Design, Coding, Testing and Implementation.
Description: - Giving service appointments by referring customer master
/Service History for various Toyota models (Quails, Corolla, Camry) with a
graphical representation called Time Bucket. Vehicles are allotted to SA on
N-1 the day so that he can handle that vehicle for AWACS on Nth day.
Additional Module is added to calculate Expected Next Service using TOYOTA
formula. Finally this gives an alert message to Service Advisor so that he
can take limited no of vehicles with respect to major & minor service FRT
and also serviced vehicles can be delivered on promised delivery date and
time
> Employee Attendance, Salary, ESI, PF, Canteen with Bar Code Reader
(Swiping Card)
Client : Lanson Toyota
Software : Visual Basic 6.0 / ASP / MS-Access / Crystal Reports
4.6
Responsibility : Design, Coding, Testing and Implementation.
Description: Generation of Pay Slip is linked to the Bar Code Reader and
LOP is automatically fetched from Bar Code Reader as well as Canteen. Once
Pay slip is generated Salary Statement, ESI, PF, TDS, FORM 3A and Other
Reports can be generated easily through this Project. This application
gives effective solutions to HR management.
> TRACEABILITY VERSION 1.1 & 2.0
Client : Link Enterprises and Lanson Ventures
Software : Visual Basic 6.0 / ASP / MS-Access / Crystal Reports
4.6
Responsibility : Design, Coding, Testing and Implementation.
Description: This major project includes Shipping (Pappadum Exports),
Production Plan, Quality Control Reports, Maintaining Pappadum Stock,
Credit Note, Employee Salary, Attendance and Contractor's Loan. Suppose
there is a Complaint in Exported Puppodums then we can trace back to get
the details of Invoice Number, Factory Location, Contractor's Name and
Complete Raw Materials details by using Lot Numbers.
Personal Profile
Name : Tony Alex. S
Father's Name : A. Selvaraj
Date of Birth : 28/03/1977
Nationality : Indian
Marital Status : Married
Passport No : H3761990
Validity : 06/07/2019
Issued Place : Chennai
Permanent Address : No 9, Jeyapandian Street,
Varaguna Nadar Compound,
Nazareth - 628 617.
Tuticorin District
Tamilnadu State.
Place: Chennai
[TONY ALEX S][pic][pic]