Sql Server Software

Madras Ravindran

**** ****** ****, **** # *, Mississauga, Ontario, Canada, L5N 7Y6

Mobile: 647-***-**** ** E mail: *********.******@*****.***

Job Applied for - Applications Support Analyst (Crystal Reports)

Total 10 Years, 1 Year .Net - 8 Years VB6 Programmer – 8 Years Crystal Reports 8 Years SQL Server

Starting Date : As soon as possible

CRM/ERP/E Commerce systems architecture, development, administration, Database modeling, design,

development, warehousing.

Expert convert from HTML, XML to SQL Database

Effectively working in a team environment as well as independently.

Expertise environment Visual Basic 6, PL/SQL Server 2000, 2005, 2008, MYSQL, Store Procedures,

Microsoft Access, Crystal Report, Design pattern & Microsoft FoxPro.

Expert knowledge of Database Management for all business activities & Migrate application reporting

from 32 to 64 bit

Flexible attitude, ability to perform under pressure.

A commitment to quality and a thorough approach to the work.

Professional Experience and Significant Achievements

21st Century Software Services, Mississauga ON May 2010 to Till Date

Programmer

Technical Skills

Languages : .Net, Visual Basic 6

Databases : MS SQL 2000, MS SQL 2005, MS SQL 2010, MYSQL, MS Access, FoxPro

Technologies : ODBC, Crystal Report and HTML, XML

Servers OS : Windows Server 2003/2008, Window Vista/XP/7

Network : Local network systems project, Installation, Configuration, Maintenance.

.Net/VB Programming

Analyzed requirement and developed modules and participated in all phases of software development life

cycle of CRM/ERP system which includes Customers, Contracts, Orders, Inventory, Billing, Purchases,

Payments, Human Resources, Payroll, General Book keeping/Accounting, Manufacturing Operations and

Manufacturing Sequences, Assets Depreciation, Service Support both in middle scale service companies and

in large scale enterprises.

Design, develop and implement PC based business applications / systems for the department according to

existing corporate software development standards.

Produce system and user documentation during the development of systems.

To design and develop database systems in both MS Access and SQL Server.

Test, debug and document software developed both internally and externally.

To carry out maintenance and support of assigned systems.

To plan how work is to be carried out to meet targets of the project or team task.

Page # 1

Discussed with the Database Project personnel on requirements functionality, operational aspects, technical

issues, and scope of work.

Total Financial System, Manufacturing, Retail Trading, Employment Agency, Travel, Clearing & Forwarding,

Clinic, Catering, Insurance, Supermarket, Construction, Bakery, Auto Garage, Hardware & Auto Parts are

some of the client handled.

Madras Ravindran

7190 Atwood Lane, Unit # 7, Mississauga, Ontario, Canada, L5N 7Y6

Mobile: 647-***-**** ** E mail: *********.******@*****.***

Crystal Report 2008

Gather reporting requirements from the requestor and shared report options with the requestor.

Help staff to decide on replacement software for Crystal Reports that will work with current software

implementation.

Retrieved information from customer support database to allow managers to have better understanding of

current trends at company.

Prepared time estimates for all Crystal reports developed.

Support, modified and maintained Crystal reports that are currently in production.

Respond expediently for requests to create, modify and fix reports.

Develop complex, production level reports.

Translate end user reporting requirements into technical design documents.

Install and configured software on client and servers

Design and implemented complicated reports and sub reports

Test and implement system components using techniques

Develop complicated stored procedure

Analyze and resolve problems of simple to medium complexity

SQL 2005/2008

Extensive Physical and Logical data modeling skills.

Database Transformation Services (Design, Development, Deployment and Administration)

Databases: MS SQL Server 200*-****-****, MYSQL, Sybase System 12.X, MS Access, Replication Server.

Designed the migration strategy, test plans and scripts to verify data and migrated databases from SQL

Server 2000 to SQL Server 2005-2008.

Planned, designed and implemented application database code objects, such as stored procedures, triggers,

cursors, tables, views, joins and statements for applications.

Actively involved in designing the logical and physical architecture of the Databases.

Database backup, recovery and restoration.

Abdul Majid Niaz Ali Electronics L.L.C., Dubai, U.A.E. Oct 96 to May 2010

Programmer

Languages : Visual Basic 6, VB.Net, Foxpro

Databases : MS SQL 2000, MS SQL 2005, MS SQL 2010, MYSQL, MS Access

Technologies : ODBC, Crystal Report

VB Programming

CRM system software modules, testing, implementation, support, maintenance, Customers, Orders, Billing,

Payments, Service Support, Inventory.

Supervising, developing and coding software projects.

Transforming bank transactions from bank web site into DB by parsing Excel /report files.

Page # 2

Troubleshooting and support management.

Documentation and Training.

Train junior programmers and provide assistance in resolving problems.

Crystal Reports

Developed a User Guide/Shortcuts specific to client’s needs.

Train users to Use Crystal Reports, Modify and enhance Crystal Reports, Save Crystal Reports.

Worked with multiple divisions within the clients company.

Review and understand multiple databases.

Provided weekly updates to Team lead or Manager.

Prepared Weekly Team Status reports for upper management.

Gathered Documentation and Requirement for report creation

Troubleshooting and support management.

Train junior programmers and provide assistance in resolving problems.

Madras Ravindran

7190 Atwood Lane, Unit # 7, Mississauga, Ontario, Canada, L5N 7Y6

Mobile: 647-***-**** ** E mail: *********.******@*****.***

Academic Qualification

Bachelors of Arts – Corporate Secretary ship, Chennai, DRBCCC Hindu College, Madras University, India.

(Subject : Accounting, Economic, Costing, Finance, Budgeting, Industrial Training and Commerce)

Post Graduates Diplôma in Computer Science : Bureau of Data Processions System, Chennai, India.

(Subject Programming, Design, Flow Chart, Testing, Documentation & Data Security)

Certificate Course : Microsoft Visual Basic 6. Programs, Sharjah, U.A.E.

Page # 3

Contact this candidate