RK lane,Tondairpet,
Chennai – 600081
Mobile : 994*******
Mail : **************@*****.***
J.K. Aarthi
SUMMARY
• 3.7+ years of experience in IT & SQL Server Database development experience.
• Hands on Experience in installing, configuring, managing, monitoring Upgrading, migrating
and troubleshooting SQL Server.
• Hands on Experience in Writing T- SQL code and creating jobs to
Automate repetitive tasks.
• Hands on Experience in database backups, restores, performance tuning
and capacity analysis
• Extensive experience with SQL Server and T-SQL in constructing triggers,
Tables, user functions, views, indexes, user profiles, relational database models.
• Extensive experience with profiler, performance Monitor, tune and analyze
Db performance and Allocate server resources to achieve optimum db performance.
• Working Experience in designing, implementing, maintaining, and
Documenting complex database applications in financial/production Environments.
• Strong troubleshooting and organizational skill
TECHNINCAL SKILLS
Operating System : Windows 98/ 2000/2003/2008, XP, MS-DOS
Database : SQL Server 2000/2005, MySQL,PostgreSQL
Web Designing Tools : HTML,JavaScript, VBscript, PHP
Programming Languages : C, C++,Core Java
EXPERIENCE
Ramco Systems, Chennai (www.ramco.com)
Analyst Programmer (March 2011 – Till Date)
Ramco, part of the Ramco Group, has delivered enterprise software and services. Ramco delivers solutions that address this with flexible enterprise applications that can be delivered quickly and cost-effectively into complex environments. Ramco’s enterprise applications are pure business-process-web-component-centric and available on-premise or via an Application Service Provider (ASP). Ramco’s ERP applications for the Aviation Manufacturing industry are available on-demand (Ramco’s Cloud-SaaS), on-premise or via an ASP.
Murugappa Groups,
Laser words Pvt ltd, Chennai (www.laserwords.com)
SQL Server Developer (OCT 2008 – Feb 2011)
Laser words Pvt ltd. is leading software and e-publishing services company, which provides a comprehensive range of production services: Software services, Production management, Composition, New media, Illustration and Graphic art, Editorial, Xml and Keyboarding.
PROJECT EXPERIENCE
Project : INTEGRATION
Employer : Ramco Systems
Role : Procedures,View,DB Design
Team Size : 10
Environment: SQL Server 2008 R2
This Project would be implemented for various customers (AVEOS, AIRINMAR, AIRINDIA, and IDMR) for third party Integration. Aveos uses Airinmar to connect with their vendors and suppliers for the Outside Vendor (OV) Repair Order process. Airinmar provides a portal which works as an intermediary between buyers and sellers and also provides support services like quotation, warranty verification and shipment tracking. Ramco will be the authoritative source of data for creating and maintaining the Repair Order information. The repair order information from Ramco will be communicated to Airinmar in electronic format. Airinmar services of quotation, order tracking and status updates need to update the information in Ramco and vice versa. This integration has to be developed to maintain and update the Repair orders details in Airinmar on a scheduled/Adhoc basis from Ramco application. Ramco and Aveos Integration Engine would be on the same network. Airinmar will be in a different location and will communicate over internet to Aveos Integration Engine. Data’s are received either through Biz Talk server or SSIS Package depend upon the client Requirement.
Project : ONLINE PROOFING SYSTEM
Employer : Laser Words
Role : DB Developer
Team Size : 15
Environment : PHP and SQL Server
This project will deliver a standardized online proofing system for authors/proofreaders to use. It is an extension of our current e-proofing and e-annotation proofing systems. Authors/proofreaders will be able to edit their proofs using Adobe functionality in a live web environment. They will be able to save work in the live environment and return to it at a later time. Once completed, they will finalize their corrections and an automated notice will be sent to the next point of contact in the production workflow. Each Online Proofing System must use Adobe electronic annotation capabilities built into the live web environment. Each system must allow for authors/proofreaders to stop editing and return to editing at a later date, with all of their previous edits saved. Each system must integrate email notification to users. Each system must allow for system customization based on a journal’s workflow. Production Editors should have administrative access to work with the proofs if necessary.
Project : DOCSTATION
Employer : Laser Words
Role : DB Developer
Team Size : 8
Environment : PHP and SQL Server
DocStation is a web based environment where the authors, editors and QC personnel can retrieve files to work on or post completed documents. Initially work will be assigned to the paginators to work on. After that files will automatically enabled to QC to check that file. Error free will be sent to the team in charge to make upload. Automatic emails are triggered at various stages to keep everyone involved updated on the progress. Customized reports can be generated to view the status of files.
Project : Scriptorium
Employer : Laser Words
Role : DB Developer
Team Size : 10
Environment : PHP and SQL Server
Scriptorium a web-enabled system, used to maintain the workflow management of the company. It is highly customizable and can be quickly and easily adaptable to any workflow. It includes various modules like Projects, Workflow, Production, Hr, Reports, Quote and Invoice. Involving in creation and maintaining of Databases, Procedures, Functions and Views for all modules.
Project : Smart HRMS
Employer : Laser Words
Role : DB Developer
Team Size : 10
Environment : PHP and SQL Server
Human Resource Management Systems represent the life of any organizations. It helps the company to administrate a work force to its success and growth. Smart HRMS helps companies in managing information based on their unique HR structure needs.
Data is entered just once and is shared with the entire HR systems. It support recruiting and maintaining a competitive work force. With HRMS, Manager can plan right from Power Planning, Interviewing of Man Power. This project control the personnel management, Exist Interviews, Online Questionnaires, selecting the candidates, organization structures, payroll of the employee, training for the selected candidates, online library and all regular routines.
EDUCATION
BE CSE with 76% distinction, From Anjalai Ammal Mahalingam Engg College in the year, Kovilvenni - 2007
HSC with 86.41%, ARR Matriculation Higher Secondary School in the year, Kumbakonam - 2003
SSLC with 83.45%, ARR Matriculation Higher Secondary School in the year, Kumbakonam - 2001
PERSONAL PROFILE
Date of Birth 31-01-1986
Marital Status Single
Passport No G5509628
Declaration:
I here by declare the above-furnished details are correct and true to the best of knowledge and belief.
Date:
Place: (Aarthi.JK)