Resume of Samuel Raj

Page * of *

SSAAMMUUEELL RRAAJJ

MMaaiill IIdd::ssaammuuaallrraajjiinnffooddeevv@@ggmmaaiill..ccoomm PPhhoonnee :883322--554488--55885599

IInnffoorrmmaattiiccaa DDeevveellooppeerr

WWoorrkk EExxppeerriieennccee::

• 9+ years of IT experience in the analysis, Design, Development, Testing and Implementation of business application systems for insurance domain

• Strong Data Warehousing ETL experience of using Informatica 9.1/8.6.1/8.5/8.1/7.1 Power Center Client tools - Mapping Designer, Repository manager, Workflow Manager/Monitor and Server tools like Informatica Server, Repository Server manager.

• Expertise in working with relational databases such as Oracle 11g/10g/9i/8x, SQL Server 2008/2005

• Extensive experience in developing Stored Procedures, Functions, Views and Triggers, Complex SQL queries using SQL Server and Oracle PL/SQL.

• Extensive experience in writing UNIX shell scripts and automation of the ETL processes using UNIX shell scripting.

• Proficient in the Integration of various data sources with multiple relational databases like Oracle11g /Oracle10g/9i, MS SQL Server, VSAM files and Flat Files into the staging area, ODS, Data Warehouse and Data Mart.

• Experience in using Automation Scheduling tools like CA workload automation and Control-M

• Extensive experience in software testing and Project related activities in Financial Services Domain

• Hands on experience as a 24x7 Production support specialist

• Worked on Performance Tuning, identifying and resolving performance bottlenecks in various levels like sources, targets, mappings and session

• Experience in requirements gathering, System Integration Testing, Component Testing, Regression testing, Supporting User Acceptance Test(UAT)

• Experienced in software testing methods and Quality Assurance, Software engineering practices for Life cycle development

• Excellent interpersonal and communication skills, and is experienced in working with Client, business people and developers.

EEdduuccaattiioonnaall qquuaalliiffiiccaattiioonn &cceerrttiiffiiccaattiioonn

• Master of Computer Applications (MCA-2005-2008)

• Bachelors of Compute science (Bsc-2002-2005)

• Oracle Certificate Associate (OCA –Certified )

TTeecchhnniiccaall SSkkiillllss::

Languages : Shell Scripting, Pro*C, Perl, HTML XML, XSLT Databases : Oracle, SQL server

Operating Systems : UNIX, Linux, Windows 95,

Windows 2000, Windows XP

Resume of Samuel Raj

Page 2 of 5

ETL Tools and Techniques : Informatica 9.*

Scheduling Tools : CA workload automation, Control –M Other Tools : Borland Star team, Beyond Compare, Xming, Winscp3, Putty Product : Charles River IMS 9.1.4.3.4, ALIP

Microsoft & other tools : MS Project Plan, MS Office, VISIO, Lotus Notes, MS Excel Certification : OCA-Oracle Certified Associate

Professional Experience:

Allianz Life Insurance Company of North America MN March 2014-Present

E-commerce capability Variable support -

Ecommerce is service provide by Allianz to their broker dealer through DTCC or DST. Fixed, Variable Annuities and life insurance policies related financial and not financial information are been send/received to/from the broker dealer and Rep's through a well-established secured channel provide by DTCC and DST on a standard format provided by DTCC and DST. The data are exchanged in a flat file (Called as feed files) format with proper layout provided by DTCC and DST. The services are broadly classified into inbound services and outbound services. Inbound services are designed to receive the feeds from Broker dealer. Outbound services are designed to send the feed to broker dealer. Working in this project till date Roles & Responsibilities:

Monitoring day to day production activities.

Resolving and reporting issues in production.

Coordinating with support and maintains activates between various teams.

Tracking daily status and reporting to Client.

Coordinating with the team regarding various technical as well as non-technical issues related to the project.

Detailed design development for Allianz Ecommerce Support tickets.

Providing technical solutions to the team and resolve technical issues.

Worked on Informatica Power Center tools- Designer, Repository Manager, Workflow Manager, and Workflow Monitor.

Understanding data requirements for test and development

Involved in Peer review activities for Code & Testing.

Finding the Root causes of the bugs raised

Optimized performance by tuning the Informatica ETL code.

Used debugger to test the data flow and fix the code.

Supporting the on call support on Quarter end and production release management deeds

Monitoring and tracking for all project deliveries.

Involved in Performance tuning at source, target, mappings, sessions, and system levels.

Preparing installation packets and working with release management for smooth execution.

Tools and Technology used: Informatica, Oracle, SQL, VAX/VMS, CA work load automation

Resume of Samuel Raj

Page 3 of 5

United services Automobile Association (USAA) Dec 2009 -Feb 2014

Cost Basis Fixed Income and Options - Aug 2013 - Feb 2014 Role : Senior Developer

Technology: PL/SQL, Pro*C, PERL and UNIX

This project involves in developing scripts to process the cost basis data and send to source system using Pro*C, PERL and UNIX shell scripts. Worked as an UNIX Senior developer.

Roles & Responsibilities:

Developed programs using PL/SQL, Pro*C, PERL and UNIX shell scripts.

Developing re-usable scripts

Daily Interaction with Client

Active participation in Peer Reviews of Analysis and design document and unit/integration test Cases.

Reporting the daily and weekly status report to client.

Created complex functions, procedures and packages by using PL/SQL and enhanced the PRO C code for Trading functionalities

Preparation of clarification document.

Providing Training to new Team Members.

Tracking and analyzing defects.

Responsible for Customer interaction and Dev team/Test team coordination.

CRIMS -May 2012-Jun2013

Role : Senior Developer

Technology: PL/SQL, Pro*C, PERL and UNIX

Roles & Responsibilities:

Worked as an offshore coordinator by allocating the tasks to the team and providing updates by EOD to the Onsite coordinator

Communicated with onsite coordinator for requirements understanding and clarifications

Presenting Project status to the client on weekly basis

Responsible for all the middleware requirements

Analysis and Design document creation for the middleware requirements

Unit test case creation and execution Construction of SQL queries and shell scripts Defect fixing

Involved in analyzing the technology and Functional flow of each source system which are integrating and prepare the design for integrating those systems with Charles River Investment Management system and come to an agreement with vendor system

Identifies business needs and develops conceptual systems design, including identify bottlenecks/constraints in different stages of implementation of Charles River product

Configured imports into Charles River to load source system files from Northern Trust, State Street Bank, GIM2 and CAMRA system

Configured exports in Charles River export to export the trade data and security master out from the Charles River system

Resume of Samuel Raj

Page 4 of 5

Created shell scripts for the file watcher and file validation to perform the checks for all the vendor files

Created shell scripts to utilize the import and export configuration to automate the flow

Implemented complete automation by Creating Control-M job with right sequencing and dependency to perform functionalities like portfolio load, Trade and Sec master export and so on.

Configured and customized the Bloomberg Batch ini files for Security Master Data refresh for Equities, Fixed Income, etc. securities

Created customized script, procedures and functions in performing USAA specific Fixed Income Analytic requirements not supported by Bloomberg/Charles River.

Migration of SFA/GOP/PIM to UMP platform- Feb 2012- Apr 2012 Role : Senior Developer

Technology: PL/SQL, Pro*C, PERL and UNIX

This project involves the migration of legacy retail funds SFA(Strategic Fund Advisor), GOP(Global Opportunities Fund) and PIM(Private investment management) to new product UMP(Unified managed Portfolio) so that managing funds will be easier and better tax benefits. The project involves introduction of UMP products, new investment models and mail notifications to 60000 customers about the change using PL/SQL, Pro*C, PERL and UNIX shell scripts.

Roles & Responsibilities:

Developed programs using PL/SQL, Pro*C, PERL and UNIX shell scripts.

Developing re-usable scripts

Daily Interaction with Client

Active participation in Peer Reviews of Analysis and design document and unit/integration test Cases.

Created complex functions, procedures and packages by using PL/SQL

Reporting the daily and weekly status report to client.

Preparation of clarification document.

Providing Training to new Team Members.

Tracking and analyzing defects.

Responsible for Customer interaction and Dev team/Test team coordination.

Involved in System Test and release review.

Staff Aug process compliance

Member Notification updates -Nov 2011- Jan 2012

Role : Senior Developer

Technology: PL/SQL, Pro*C, PERL and UNIX

Roles & Responsibilities:

Developed programs using PL/SQL, Pro*C, PERL and UNIX shell scripts.

Developing re-usable scripts

Daily Interaction with Client

Active participation in Peer Reviews of Analysis and design document and unit/integration test Cases.

Created complex functions, procedures and packages by using PL/SQL Resume of Samuel Raj

Page 5 of 5

Reporting the daily and weekly status report to client.

Preparation of clarification document.

Providing Training to new Team Members.

Tracking and analyzing defects.

Responsible for Customer interaction and Dev team/Test team coordination.

Involved in System Test and release review.

PIM Migration -Dec 2009- Oct 2011

Role : Developer

Technology: PL/SQL, Pro*C, PERL and UNIX

Roles & Responsibilities:

Analyzing the requirements by understanding business use cases and system design documents

Analyzing and understanding the existing system

Working with client to understand the requirement specific matrix and design

Created complex functions, procedures and packages by using PL/SQL

Coding and debugging

Preparation of test plan and test cases

Carrying out Unit / Integration Testing

Peer reviewing the design documents and codes.

Coordinate with onsite team members and client to track and resolve issues faced by offshore team.

Prepared training slides for the Functionalities handled.

Contact this candidate