CAREER SUMMARY 5 years

• Have around 5 years of work experience in Datawarehousing and various technologies.
• Have good knowledge development, support and maintaining the Data warehouse projects using Informatica, Business Objects and Hyperion.
• Proficient in all phases of Software Development Life Cycle Requirements Study, Design, Coding, Testing and Implementation
• Expertise in handling and maintaining applications using MS-SQL 2k Oracle 10G.
• Expertise in handling applications in data warehousing mainly Informatica
• Good Knowledge on the Java, JavaScript, VB, HTML DHTML and JavaServlets JSP EJB.
• Have good Analytical, Communication and Leadership skills.
• Successfully completed few Freelance projects in last few months.

STRENGTHS And ACHIEVEMENTS

• Excellent exposure on Software Development Life Cycle and Onshore/Offshore model.
• Provided fixes to Pre-Production and Production issues of different severities and priorities
• Highly quality conscious with good knowledge of the quality processes to be followed through the complete life cycle of projects.
• Excellent analytical, design and problem solving skills.
• First Class Advanced Java Programming from Radiant Software, Madurai, India. From Oct 2001 to Dec 2001 .
• First Class Master of Diploma in Software Technology from Bureau of Data Processing Systems, Madurai, India. from Mar 2001 to Aug 2001
• Attended training on Datawarehousing Informatica, Business Object at RGS Technology, Singapore from Apr 2006 to May 2006.
• Highly proficient in ETL Development, Testing, Enhancement, Maintenance Production Support.
• Very good exposure to various quality and review processes
• Highly motivated with the ability to work effectively in teams as well as independently.
• Ability to work, manage and execute challenging Projects in a tight schedule.
• Ability to coordinate with various teams involved in the project. Other responsibilities handled have been in areas of estimation and dealing with day-to-day client requests.

SKILL SET

• ETL Tools : Informatica, PowerCenter Oracle Data Integrator
• Data Modeling : E-R Modeling, Star Schema, Snow Flake Schema
• DataBase : MS-SQL, Oracle 10G
• Operating Systems : Windows Server Platforms, Unix/Linux Platforms
• Languages : PHP, Java, JavaScript, VB, HTML DHTML
• Servlets, JSP EJB.

PROFESSIONAL EXPERIENCE

Project Profile

Confidential

Responsibilities:

• Analyze business requirements to develop source, target tables from the source databases solutions.
• Design, test, and inspect data sources, target systems.
• Perform data modeling, analysis, and planning.
• Implement data design tools in development, quality analysis and production env
• Develop transformations and mapping technology roadmaps.
• Configure sessions using workflow manager.
• Analyze, engineer, and execute software functions.
• Develop test plans, implementation plans, and project timelines.
• Manage technology vendors supported systems
• Determine production direction
• Write functional requirements/specifications documents
• Research and recommend innovative, and where possible, automated approaches for system administration tasks
• Resource training and knowledge transitions
• Solve complex problems with many variables
• Capable of quickly learning new technologies and adapting to new environments
• Assess vendor development/test strategies.
• Provide upper tier support per request from various constituencies. Investigate and troubleshoot issues

Responsibilities:

• Creating new records and adding the entry appropriate privileges.
• One time implementation done for the entire data cleansing with comparison of old data's and new Geoffrey system.
• Updating the data's with photos and ensured that will not be the repeated entries.

Responsibilities:

• Importing source/target tables from the respective databases and Developed mappings and tested
• Created transformations and mapping using designer toolset.
• Created sessions using workflow Manager
• QA tested in SIT environment.
• Scheduling batch jobs in control M for UAT and PI.
• Liaise with users for UAT.
• Followed the procedures as per the banking environment

Responsibilities:

1. Importing source/target tables from the respective databases and create reusable transformations and mappings using designer toolset of Informatica.

2. Developed and tested the mappings

3. Created transformations and mapping using designer toolset of Informatica.

4. Scheduled sessions and batches.

5. Created multi-dimensional reports using business objects.

6. Data retrieval, multi-dimensional analysis.

7. Created daily, weekly and quarterly reports for the management team and field operation

8. Created reports in simple, cross tab, master detail format.

Responsibilities

As Informatica Developer:

• Installation of Datawarehousing tools like Informatica Business Objects for development, UAT production environment
• Created ETL process for loading data from different supply chain data sources.
• Developed Mapping, Mapplet, Worklet and Workflow.
• Maintaining Repository Server, Repository and Informatica Server
• Monitoring and maintaining daily ETL process.
• As Business Objects Developer:
• Responsibility was to study the data on a daily basis, pull the required data through the universe, create reports and send them to the warehouses where the managers could view these reports.
• Extensively used Broadcast Agent to schedule the documents on a daily basis.
• Also generated weekly and monthly reports, to compare the sale of different products by region.

Responsibilities

• Developed the entire frame.
• Configured to send and received the messaging services.
• Involved Review the code and improve performance.
• Installing and configured JSFC.
• Written shell scripts for scheduling batch jobs using control M.
• Liaise with DW report team and ensure that the providing data is correct as per business requirement

Responsibilities

As a Developer role involved designing the Room Status module using Swing Components Developed the Client Server Communication using RMI.

Responsibilities

• Developed the entire frame.
• Configured to send and received the messaging services.
• Involved Review the code and improve performance.
• Installing and configured SJAS and MQ Series.

Responsibilities

• As a developer, Involved personal detail module, preparing wages module, pay slip module
• Also involved Analysis, design, coding and testing.
• Involved testing for black box white box.
• Successfully implement at minds soft.

Responsibilities

• As a developer, involved Analysis, design, coding and testing.
• Installed and configured successfully.

Responsibilities

• As a developer, involved design all UI, coding and testing.
• Successfully installed and configured