[pic]
Tamilarasi Soundarapandian
***********@*****.***
Summary - Passionate towards writing bug-free software, eager to learn and
apply new concepts every day, devoted to the tasks assigned at the working
hours with excellent leadership qualities and logically sound individual
with 5years of experience in software development and maintenance.
. In-depth experience and knowledge in estimation, analysis, design,
development and testing of
o Application database
o Back-end patches using Oracle SQLs, PL/SQLs, UNIX shell scripts and
XML.
o Data migration programs using MS-Access, Ms-Excel, Oracle SQL
Loader, and Oracle SQLs.
. Excellent in leading team of 5 to 6 members. Handled team lead and
technical lead responsibilities in different projects. Excellent in
offshore coordination.
Around 1 year of experience in developing Java applications that uses SQL
results to feed web services.
. Around 1 year of experience in developing ad-hoc reports using Hyperion
technologies.
. Around 2 years of experience in developing .Net application using MVC
architecture.
Excellent in writing test cases and test plans provided the functional
specifications.
. Excellent in training, conducted technical sessions and guided and
mentored the software engineering trainees.
Education:
. Bachelor of Electronics and communication engineering - Anna
University, India
Certification:
. IZ-007 Introduction to Oracle9i SQL - Oracle University
. SCJP 1.4 - Sun Microsystems
. INS21 Property and Liability Insurance principles - American Institute
of Insurance for CPCU
. Preliminary level Business English certification - University of
Cambridge
. Diploma in Embedded Systems - ASK Technologies, India
Technical Skills:
. O/S: Windows and Unix
. Languages: SQL, PL/SQL, VB Macros, Core Java 1.5, XML, HTML,
JavaScript, .NET, ADO.NET, C#, ATMEL 89C51 Microcontroller programming
language
. Technologies: Microsoft .Net Visual Studio 2003, Hyperion Performance
Suite 8.2, Hyperion SQR 8.3.2
. Architecture/Framework: MVC, .Net Framework 1.1
. Application & Web Servers: IIS 6.0
. Database: Oracle 9i and 10g, SQL Server 2003 and 2005, MS-Access 2005.
. Methodology: Structured, Relational, XML, Object Oriented
. Tools: VSS, Eclipse 3.x, Toad, PLSQL Developer, Jasper Reporting, Robo-
Help, UMPS
Career Summary:
Larsen & Toubro InfoTech Ltd: 18-Jul-2005 to 27-Aug-2010
Professional Experience:
Larsen & Toubro InfoTech Ltd Jan 2008 -
Aug 2010
Client : Marsh Global Consumer, IOWA, USA
Project : Enterprise-Velocity Systems
Description : Marsh is an Insurance Broker for world's leading Insurance
providers. Marsh uses
Velocity, developed by VRC systems as its policy
administration system. The objectives
of this project are
o Migrating data from various systems to Velocity
o Developing small to huge reports that serves high level as
well as daily business needs
o Building data extracts from velocity to feeds various
reporting systems and web services.
Environment: Oracle 10g SQL and PL/SQL, Oracle SQL Loader, PL/SQL
Developer,
Jasper Reporting, UNIX, XML, Java, Eclipse, HTML, JavaScript,
Web Services
Responsibilities:
. Responsible for estimation, Design, work break down, planning, work
allocation (for a team of 6members), quality audits, follow up and timely
delivery of new business projects.
. Responsible for design and development of SQLs, Pl/SQLs, UNIX shell
scripts, VB macros and Jasper reports to build reports in
o Excel formats that meet the high level as well as daily business
needs
o XML format to feed data to web services
o Text and csv formats to feed to other reporting systems
. Responsible for migrating data from various file formats to Oracle
database, using UNIX shell scripts, SQL Loader, SQLs, PL/SQLs and Java.
The source files are extracts from the DB2, SQL server, MS-Access
database etc.,
. Responsible for developing synchronizing programs, that access data from
various systems on a daily basis and updates the source data after
comparison.
. Responsible for fine tuning the SQLs and programs that has lags quick
response time.
. Responsible for review of SQLs, UNIX and Java code written by other team
members to ensure there is no performance degradation and to ensure
proper integration of various modules.
. Responsible for conducting project specific knowledge transitions
sessions, so that the new team members are in par with the experienced
members; and conducting some soft skill sessions to make the team more
interactive and more communicating.
Larsen & Toubro InfoTech Ltd Sep 2007 -
Dec 2007
Client : Larsen & Toubro ECC Ltd, Tamilnadu, India
Project : Arise-Survey Instrument
Description : Larsen & Toubro is one of the world's leading legends in
civil constructions. The main objective of this project is to
conduct survey across organization, analyze various aspects of
IT usage across the enterprise, build analysis and statistics
reports that helps measure business improvement factors.
Environment: ASP .Net, C#, Asp, Java Script, IIS 6.0, HTML, SQL Server
2000, Microsoft .Net
Visual Studio 2005, .Net Framework 2.0, Crystal Reports 9, VSS
6.0.
Responsibilities:
. Responsible for estimation, Design & documentation, and work break down.
. Responsible for design and development of database for this application.
. Responsible for developing the MVC architecture class files for the
application.
. Responsible for developing one module of this application that involves
o UI development using HTML, JavaScript, and C#.Net
o Developing DVO, DAO, BO classes and error handling code for this
module.
o Validating and uploading of mass data into the application, using
XMLtype to pass data from application to PL/SQLs.
. Responsible for Integration testing.
. Responsible for coordinating the team for timely delivery of the project.
Larsen & Toubro InfoTech Ltd Aug 2007 -
Sep 2007
Client : Allvac, North Carolina, USA
Project : Allvac-Reports Migration
Description : Allvac systems manufacture Valves and ship goods to various
parts of the world. Different databases and Excel reports
already existed to support their business requirements. The main
objective of this project is to analyze the already existing
Excel reports and document their business functionalities. The
business approves for migrating them to Oracle Database if they
find the reports still meets their business requirements.
Environment: Excel VB Macros, Oracle 9i SQL, PL/SQL, MS-Word.
Responsibilities:
. Responsible for system study at the client location, and transfer
knowledge to team members at offshore.
. Responsible for business analysis, documentation and explaining the
requirements to the team members
. Responsible for developing PL/SQL, SQLs, oracle objects needed for
migrating reports from MS-Excel to Oracle.
Larsen & Toubro InfoTech Ltd May 2006 -
Jul 2007
Client : Technip, Abu Dhabi, United Arab Emirates.
Project : Janus-Project Management application
Description : Technip is one of the world's leading oil and gas
manufacturing company. The project is developed to create
projects and maintain the project metrics like budget, progress,
mobilization, and productivity of the Oil and Gas manufacturing
company. This project involves the calculation of the Physical
Progress of Home Offices services, including Engineering,
Procurement Services and Manufacturing. The project involves MVC
architecture.
Environment: ASP. Net, C#, ADO. Net, Java Script, IIS 6.0, HTML, Oracle9i,
Microsoft.Net
Visual Studio 2003, .Net Framework 1.1, Crystal Reports 9, VSS
6.0
Responsibilities:
. Responsible for production support and developing the enhancements for
this project.
. Responsible for trouble shooting and fixing the bugs reported by the
client.
. Responsible for fine tuning the application, SQLs and the PL/SQLs.
. Responsible for developing the enhancement that involved mass data upload
with proper validation and logging. I was appreciated for the approach
that I used for this enhancement, as the module got executed with a quick
response time.
. Responsible for taking project build for deployment of the application at
the client end with the changes done for enhancements, and maintaining
the same in VSS with proper documentation on the changes.
. Responsible for development of DB changes for the enhancements.
Larsen & Toubro InfoTech Ltd Nov 2005 -
Apr 2006
Client : Technip, Abu Dhabi, United Arab Emirates.
Project : Refer New - Contracts Information Management
Description : Technip is one of the world's leading oil and gas
manufacturing company. This project tracks and maintains the
contracts related information of the client. The user can also
generate the standard as well as the ad-hoc reports.
Environment: ASP. Net, C#, ADO. Net, Java Script, IIS 6.0, HTML, Oracle9i,
Microsoft.Net
Visual Studio 2003, .Net Framework 1.1, VSS 6.0, Hyperion
Performance
Suite 8.2, Hyperion SQR 8.3.2
Responsibilities:
. Responsible for developing the Referential module of the project. This
development involves ASP. Net, C#, ADO. Net, Java Script, IIS 6.0, HTML,
Oracle9i, Microsoft.Net Visual Studio 2003, .Net Framework 1.1
. Responsible for developing datamodel, design and query layers of the
Hyperion BQY reports.
. Responsible for re-engineering the Datamodel design of reports and re-
designing if needed to improve the performance or to fix the bugs.
. Responsible for developing and integration of Hyperion SQR reports.
. Responsible for unit testing and bug fixing.
References
References available upon request.