Business Analyst/QA

Ramanathan Sarangapani

Profile

Senior Analyst with more than 9 years of experience in IT Industry and has been involved in developing Business Reports through Crystal Reports, Microsoft SQL Reporting Services, SQL database Administration, developing procedures, functions and PL/SQL packages and maintenance and more than 2 years of Global experience in United Kingdom and The United States of America. Involved in Design, Development, implementation and support for major projects and has a rich Industrial experience

Industry Experience

• Mortgage & Finance

• HRMS

• Sales and Manufacturing

Skills Summary

Application Skills:

• Microsoft SQL Server Reporting Services 2008

• Crystal Reports 11

• Crystal Enterprise 10

• .Net Technology

• Mercury Quality Center, Remedy, Perforce, SAP Basis, VSS

• Tally (Accounting Software)

Database Skills:

• Microsoft SQL Server 2000/2005

• Oracle 9i

• Microsoft Access

Platforms:

• Microsoft Windows® 2000

• Microsoft Windows XP

Career Summary

Oct 2008 - Till Date ISGN LTD, INDIA

May 2007 - Oct 2008 BIRLASOFT LTD, INDIA

March 2005 – April 2007 NESS TECHNOLOGIES, UNITED KINGDOM

May 2004 – March 2005 TENT SOFTWARE, INDIA

March 2001 - April 2004 PROLEASE, INDIA

March 1999 - Feb 2001 VASDOR INVESTMENTS, INDIA

Career Experience

Senior Analyst – ISGN Ltd 2008-till date

Lenstar & Fortracs, Default and Servicing Products, United States (Mortgage)

ISGN is a global company comprised of the mortgage lending industry’s best platform-based technology products, services, and outsourcing solutions. Led by a top team of trade veterans, ISGN is a single-source provider of end-to-end products and services for the residential mortgage industry. ISGN mission is to be the company lenders can count on to meet all of their mortgage technology needs. No other technology provider offers such an extensive array of products and services including mortgage automation, construction loan servicing and mortgage default servicing systems, origination, default and construction outsourcing services, IT and attorney referral services and integrated third-party connections through Bridgelink and Plug-In Partner Networks.

LENSTAR is the industry-leading web-based attorney referral and communication system for the default management market. It comprises of Foreclosure Referrals and Processing, Bankruptcy Referrals and Processing, Evictions, Imaging, Title Requests and AVM & BPO Services

FORTRACS automates the default management of a loan. The FORTRACS application drives the user through loss mitigation, foreclosure processing, bankruptcy monitoring, claims processing and REO management, with fully integrated modules and synchronization of activities. FORTRACS automates default management processes, decisioning and document management, allowing the lender to manage credit and collateral risk

• Creating New T-SQL Stored Procedures, Functions, Triggers in SQL Server 2005/2008, Data cleansing and duplicate errors,

• Creation of New Reports in SSRS 2008 and migrated all Crystal Reports to SSRS 2008

• Review existing and new procedures for proper standards and worked on performance enhancements and maintaining Development and QA server.

• Worked on creating a new standards and work flow process for new releases and development.

• Query Optimization, trouble shooting, performance tuning and providing input to database design and development.

• Provide Production support for SQL related problems, SSRS Reports and Crystal Reports

Career Experience [Contd.]

System Analyst – Birlasoft Ltd 2007-2008

Centex Homes, Dallas, Texas, United States (Finance)

Centex Homes is one of the leading construction company in US and they are into building homes and Insurance sector. FRA – (Financial Reporting and Analysis Tool is the major application to get all their financial information. This Application acts like a data warehouse where in which all financial details captured from various financial packages like SAP and other custom build applications through automatic interfaces

Lotus Domino as front end Microsoft Reporting Services and Crystal Reports for creating and maintaining reports, SQL Server Enterprise Manager to administer the Database, VSTS to keep a production library of code and reports. Successfully completed the Knowledge Transfer and supporting the FRA Application from Birlasoft Chennai Centre.

• Query Optimization, trouble shooting, performance tuning and providing input to database design and development of specialized Reports

• Provide Production support for SQL related problems, SSRS Reports and Crystal Reports

• Creating New Stored Procedures in SQL Server 2000/2005, Data cleansing and duplicate errors,

• Data Migration using SSIS and DTS

• New Division Set-ups &New enhancements like creating New Reports through SSRS 2005 and Crystal Reports are any new business logics through Stored Procedures

Senior Software Engineer – Ness Technologies 2005-2007

HBoS Employee Equity Solutions, London (Finance)

HBOS Employee Equity Solutions offers an unrivalled range of products and services, delivered using advanced technology underpinned by an exceptional standard of service that aims to exceed our clients' expectations at all times, providing web-based solutions for global share plan administration. Their core areas of expertise covers UK Plans, Global Share Plans, Offshore employee benefit trust services and specialist services.

Crystal Reports for creating and maintaining reports, SQL Server 2000 Enterprise Manager to administer the Database, PERFORCE to keep a production library of code and reports, Planetarium (to administer share plans) and all other standard applications and responsible for all aspects of data management like data protection, data integrity and database reporting.

• Production of Participant advices i.e. statements, dividends & tax vouchers.

• Data Imports i.e. contribution files & demographics files,

• Data cleansing like formatting issues and duplicate errors,

• Admin reporting,

• Data migration

• Production and maintenance of Planetarium reports within Planetarium.

• Production and maintenance of client website data on demand reports.

• New Scheme Set-ups

• Database Maintenance within Planetarium.

• Projects work like Data reconciliation & report optimization.

Career Experience [Contd.]

Senior Software Engineer – TENT SOFTWARE 2004-2005

Basic Chemicals Solutions LLC, California (Sales and Manufacturing)

A world leader in oil and natural gas exploration and production and a major North American chemical manufacturer

Primary Job responsibility was to take care of their entire Management View Reports and maintaining their enterprise database system. Getting requirements from various branches and departments and understanding their needs and develop reports accordingly and publish the reports in Crystal Enterprise to enable the user to view the reports. Maintain daily backup schedules and Query optimization and tuning their database performance and Coordinated with other areas of Company Operating Systems.

• Query Optimization, trouble shooting, performance tuning and providing input to database design in SQL Server 2000 and development of specialized Reports

• Involved in getting requirements directly from the Users

• Development of the reports in Crystal Reports 8.5/10,

• Testing Reports with their ERP systems and Queries generated through SQL Server 2000 and with the previous year results.

• Publish reports in Crystal Enterprise to enable the users to view them with the latest parameters used and the success/failure History of latest executed reports.

• Analyzed their database architecture and their major ERP system and developed various reports accordingly.

• Maintaining daily backup schedules

• Coordinates software issues with other areas of Company Operating Systems

• Worked on their requirements and maintaining the entire Management View reports, developed procedures, Views in SQL 2000 and create various kinds of reports like Sub Reports, Cross Tab Reports, Drill down Reports etc,

Career Experience

Software Engineer (Product Specialist) – Prolease 1999-2004

PROLEASE INDIA (Business Process Outsourcing)

Prolease is a part of the Interpro Global group U.S.A is one of the Human Resources service providers offering a range of innovative HR Solutions. They offer customized solutions for Temp and Permanent Staffing, payroll processing & benefits administration, consulting & training and transaction processing. In addition their recruitment & executive search services both in the IT and Non IT area supports.

Analyzed various Payroll, Reimbursement and Tax packages and involved as a core member in design, development and maintaining their Payroll, Reimbursement and Transaction processing packages.

• Designed, developed and maintained a major Payroll Processing System (Prolease India Payroll Processing System - PIPPS) which can deal with any type of payroll in India. It has all features like Tax calculation, PF, ESI and Overtime and even caters the needs of manufacturing industries. Developed in Visual Basic 6.0, SQL Server 2000 to administer the database and Crystal Reports 8.5 for creating and maintaining reports.

• Designed, developed and maintained Reimbursement Processing System (Prolease India Medical Reimbursement - PROMED). Rule engines were developed to cater the needs for various clients to process their Medical Reimbursements with various government rules were incorporated and linked to Payroll system. Developed in Visual Basic 6.0, SQL Server to administer the database and Crystal Reports for creating and maintaining reports.

• Designed, developed and maintained Travel Management, Invoice Generation and Customer Contact System

• Being the first employee of the company been involved in all activities like administration, development, maintenance and coordinated with vendors of purchasing hardware, software and taken care of their Data Center

• Installing Windows 2000 Servers, Configuring Group and Local Security Policy, Setting up and Managing User Accounts,

• Taking Regular Database backup, User Permissions and Recovering data when needed.

Contact this candidate