Candidates About

 

Devadoss Rajendran

SUMMARY:

·         About 9 years of diverse experience in Software Design, Development, Testing, Implementation, Data Analysis, Data Mining, Data Validation, Report design, Project Management, in Financial Services & Information Technology industry as Business Data Analyst.

·         Worked on all stages of software development life cycle (SDLC) including System study, Requirement gathering, Analysis, Design, Development, Testing, Implementation, Documentation, Maintenance, Enhancements and Training end users.

·         In-depth knowledge in Investments, with extensive knowledge on Front Office, Portfolio Management and Risk management applications.

·         Expert knowledge in SQL Server 2008 R2 and SQL Server 2012 databases.

·         Expert knowledge in MS Access 2003, MS Access 2010 and MS Access 2013 databases.

·         Expert knowledge in Data analysis, Investments Reports and Financial statement Reports.

·         Extensive knowledge in Front office Applications includes Bond & Corporate Finance, Loan Review, Credit Relationships, Allocations and Dealgen   (Trading Platform)

·         Extensive knowledge in Portfolio Analysis which includes Internal Rate Return (IRR) , Accrued Interest, Relative Value Analysis, Spread Analysis, Pricing, yield curve analysis , Data Reconciliation, Private Equity and Mezzanine

·         Expert in Liaising between Business and Information technology

·         Extensive knowledge in Risk Management systems which includes Portfolio Management  (Market Risk, Credit Risk, Interest Rate Risk) , Connections (Liquidity Risk ,  Country Risk )

·         Experience in defining and documenting business processes, identifying risks, base lining acceptance criteria, and deliverables. Documented Business Requirement Document (BRD) & Functional Requirement Documents (FRD).

·         Demonstrated client focus and client management skills within context of requirements definition, analysis and documentation.

·         Excellent communication, facilitation and mentoring skills.

 

TECHNICAL SKILLS:

 

 

Languages	VB .Net, VBA
Databases	SQL Server 2012, SQL Server 2008 R2, MS Access 2016, MS Access 2010 and Sybase.
Scripting Languages	Perl Script, Windows batch program
Tools	CA Automation tool, MS Visio, Service Now – SVN, Share point, PPM – Project and portfolio Management center, QTP and Visual Source Safe
Reporting Tools	SSRS, MS Access and Excel Reports
Business Intelligence	SQL Server Integration Services SSIS

 

FUNCTIONAL SKILLS:

 

·         Trading system -  Deal Generation Tool

·         Investments – Securities, Balances and Holdings

·         Market Value, Book Value , Par Value Allocation and credit Relationships Data Management -  BCF Systems

·         Portfolio Analysis - Accrued Interest, Internal Rate Return (IRR) ,Relative Value Analysis, Spread Analysis, yield curve analysis, pricing and Reconciliation

·         Private Equity & Mezzanine Fund Management

·         Risk Management includes Market Risk, Liquidity Risk, Credit Risk, Interest Rate Risk, Country Risk – Connections & Portfolio System 

·         Ratings systems - Moody Rating, S&P Rating, Fitch Rating and Hancock Rating

·         Derivatives (Interest Rate Swaps, Currency Swaps & Options)

·         Regulatory Reporting - On Balance sheet, Financial Statement, Liquidity Report, Holdings reports, Cash Flow reports, Investments Reports and portfolio analysis reports.

 

Methodologies: SDLC, Waterfall and Agile

 

 

 

 

PROFESSIONAL EXPERIENCE:

 

Business Data Analyst

John Hancock Financial Services

Boston, MA                                                                                                                                        Jan 2016 – Till Date             

 

The BCF Applications is built for Bond & Corporate Finance Group, Investments and Security Operations Groups. This project covers entire Trade Life cycle, Bonds & Equity, Portfolio Management, Private Equity & Mezzanine Fund Management, Pricing, Ratings, Derivatives and Risk Management.

 

As a Business Data Analyst worked closely with Portfolio Managers, Traders, Credit Analyst, Portfolio Analyst and Director to gather business requirements, understand workflow & analysis of functional and technical processes.

 

Responsibilities 

                       

·         Analyzed the Business Modules and their impact on the current system.

·         Analyzed data to collaborate with Business users in understanding the requirements and passing on the requirements to the vendors.

·         Prioritization of defect list as per Users requirements and planning the releases in timely manner.

·         Supporting Traders, Portfolio Managers, Analyst and Operations & Compliance Users across multiple interconnected platforms to resolve Production issues.

·         Resolving split created by multiple vendors on the system

·         Generating ad hoc database queries catering Business requirements to pull up Trade, Investments and Portfolio details etc.

·         Interacting with Vendors to get workaround and workflows to troubleshoot issues.

·         Created Business Requirement document, Functional Specification documents, Use cases and Data flow documents.

·         Created Requirement Specification Documents after conducting Interviews with End Users, JAD Sessions and analyzed their current systems.

·         Involved in project status meetings, QA review meeting, and System Test meeting.

·         Create test cases and test scripts for the User Acceptance testing.

·         Accountable for eliciting requirements from users and producing use case scenarios and functional requirement documentation to ensure that requirements were accurately specified, communicated and understood by the technical implementation team.

·         Communicated with business partners and technology to analyze the data to fit the requirements while working with Quality Assurance (QA) teams to ensure business needs were met and systematic bugs were eliminated.

·         Accomplishments in analysis of large-scale business systems, Business Requirement Documents, Functional Specifications and Technical Specifications, data warehousing, Application Development, reporting and testing plans.

·         Identified and managed project risk by creating an open forum where both developers and business users could participate equally in the continuous improvement of fixed income trading, Equities and portfolio management technology.

·         Performed Gap Analysis to check the compatibility of the existing system infrastructure with the new business requirements.

·         Created  proposals for performance improvements in data structures and  applications accessibility

·         Troubleshooting issues at Portfolio Analyst, Traders, and Director’s desk in less minimal time.

·         Involved in deployment , smoke testing , implantation review and documentation

·         Identified data issues and provided recommendations for resolution to ensure optimal performance.

·         Expert in Securities Data Management System includes ABS Securities, AGRI  Securities, Agri Loan   Securities, COMMON  Stock, Corporate Public, COR-PVT, GOV-AGENCY, GOV-FOREIGN , GOV-TREASURY, MUNICIPALS, Preferred Stock, SWAP Interest,SINKING FUND,BOND CALL and  BOND PUT

 

 

 

 

 

 

 

 

Senior Developer & Data Analyst

John Hancock Financial Services

Boston, MA                                                                                                                                        May 2011 – Dec 2015  

          

The BCF Applications is built for Bond & Corporate Finance Group, Investments and Security Operations Groups. This project covers entire Trade Life cycle, Bonds & Equity, Portfolio Management, Private Equity & Mezzanine Fund Management, Pricing, Ratings, Derivatives and Risk Management.

 

Responsibilities

 

·         Subject Matter Expert (SME) for all the applications assigned under Investments and Capital Market Division.

·         Expert in Liaising between Business and Information technology

·         Expert in Data modelling , Data mining and data validation

·         Created new databases, stored procedures, Views, Triggers, Indexes, reports, and data input interfaces using SQL Server 2005, SQL Server 2008 R2 and SQL Server 2012 for John Hancock Investment division.

·         Performed analysis and presented results by writing SQL Complex Queries, SSIS, Complex MS Access Queries, Excel and Visual Basic scripts.

·         Responsible for loading, extracting and validation of client data in Holdings, Securities, Balances and Funds Databases

·         Worked extensively on Importing Data into Holdings SQL Server Database from Maximis (Back office & Middle Office) using SSIS, VB .Net Console Application and SQL Scripts.

·         Worked extensively on Importing Data into CAMRA MS Access database from Bloomberg using Perl Script, VB .Net Console Application and Windows Batch Program.

·         Interpreted Investments data, analyzed results using statistical techniques and provided ongoing reports for Portfolio Analyst

·         Expert knowledge in Data modelling, Database design, Data Validation and Data Mining in Holdings databases and Securities & Balances data.

·         Developed basic to complex SQL queries to research, analyze, and troubleshoot data and to create business reports.

·         Worked extensively on creating Stored Procedures, Views, User Defined Functions, Sub-Queries and Joins for complex queries involving multiple tables

·         Proficient in SQL Server and T-SQL (DDL and DML) in constructing Tables, Normalization/ De normalization Techniques on database Tables.

·         Experience in Performance Tuning and Query Optimization.

·         Designed new application for Capital Market Division using MS access Forms & VB .Net as front end with MS Access Linked tables, SQL Linked tables as back end

·         Created new forms in MS Access with Tree view controls, Buttons, Labels, Text boxes and wrote VBA coding for Mezzanine & Private Equity application.

·         Designed new MS Access Reports using tool box controls. Generated report with source data from Query object, tables and SQL statements.

·         Created references in MS access file with DLL Controls, Active X controls, In Build Controls and user defined controls.

·         Worked extensively on creating Holdings reports, Pricing Report, Internal Rate Return Report, Relative Value Analysis Report, On Balances Report, Spread Report, Realization report, Spread Value analysis Report, Yield Curve Report for Portfolio Managers & Portfolio Analyst in MS Access 2010 and MS Access 2003.

·         Worked extensively on creating Cash flow report, Capital Balances Report, Distribution detail report, Remaining & total Commitments report, Income Report, Purchase Sales Report and performance with Incep Info report for equities in MS Excel, SSRS and MS Access.

·         Created tables and complex MS Access queries in Dealgen and BCF applications for Traders & Investors. Expert knowledge in Macros and VBA

·         Scheduling and Monitoring Batch jobs in CA Workload Automation.

·         Worked extensively on uploading and maintaining documents in share point website.

·         Worked extensively on trouble shooting production issues at Business user desk in less minimal time without SLA miss

·         Expert knowledge in Level2, Level 3 and Level 4 production support.

·         Created and tracked Service Now tickets, PPM tickets and implementation tickets.

 

 

 

 

 

Technical Lead

Horace Mann

Project –Horace Mann Auto Insurance System                                                                   

Pune, India                                                                                                                          Oct 2009- April 2011

 

The scope of the project is to build the new policy writer system. This includes Policy Holder details, Coverages at policy and location levels, Reports along with the terms and conditions.

 

This policy writer system is an ongoing project right from Development to Production and it had been implemented across all the states within United States.

 

As a Technical Lead, I worked on all the phases of software development life cycle process.

 

 

Responsibilities                              

 

·         Contributed to technical solutions from design to code implementation.

·         Built strong project teams and engaged in ongoing communication with customers to ensure quality applications were delivered.

·         Mentoring & Brainstorming programming team in developing new Horace Mann auto insurance systems.

·         Managed delivery of multiple complex auto insurance Systems development simultaneously.

·         Designed goals and completed problem-solving of software development issues.

·         Offshore Delivery Point of contact

·         Designed and Deployed .Net Applications.

·         Created ASP forms Using design tools, Controls.

·         Wrote VB .Net coding to implement the business requirements for Coverages, Ratings and under writing.

·         Maintained source code in Visual SourceSafe

·         Deployed source code in IIS server

 

Developer

NIIT Institute

Internal Projects – Online Booking & Theater Management Tool

Chennai, India                                                                                                                  June 2008 – Sep 2009

 

This System will provide online ticket facilities to the customers. Customers can manage their booking and blocking their tickets using credit/Debit cards.  It allows employees to manage the customers booking. Moreover, it can be used as the internal tool to manage daily shows, generate the cost analysis report and data monitoring.

 

As a developer, I will do Requirement Analysis, coding, Unit Testing, System testing, Implementation, Review and documentation.

 

EDUCATION

 

·         Hindustan College of Engineering, Anna University – Chennai - India (2004-2008)

Bachelor of Engineering - Computer Science

·         Kamaraj University – Madurai - India (2013-2015)

Master of Business Administration - Finance and Computers

·         Accelerated ANIIT Software Engineering  (ANIIT)

·         Insurance Level 1 Certifications

·         Capital Market Level 1 Certifications

·         Microsoft Certified Professional Developer - MCPD