Manager Developer
Resume:
Resume of Samuel Raj
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