Sr SAS Developer & Analyst
Resume:
Madevi Ravikumar
****.******@*****.***
Professional Summary:
Having total of 5+ years of IT Industry experience, which includes 2+ years of experience in development, implementation and support in SQL, PL/SQL.
Extensive experience in design, development of Oracle 9i database objects, SQL, PL/SQL programming.
Strong experience in Oracle packages, stored procedures, database triggers and tools like SQL*Plus and Toad.
Proficient in understanding business processes / requirements and translating them into technical requirements.
Demonstrates commitment to superior customer service through positive attitude, leadership, and hands-on teamwork.
Strong programming and problem analysis skills
High-energy, confident professional with a passion for technology.
An enthusiastic, quick learning and personable team player, able to communicate effectively with diverse cultures.
Skills Summary
Programming Languages SQL, PL/SQL
Database Oracle 9i, Knowledge of Oracle 10g
Application Software Oracle Developer 6i, Forms 6i, Reports 6i
Tools & Utilities SQL*Plus, Toad
Reporting Tools Oracle Report 6i
CRM tool Remedy, Dellserve
Operating Systems WIN95/98/NT/2000/2003/XP, Unix
Domain Insurance, CRM
Internet Technologies VB Script, HTML
Languages C, C++
Testing Tools Knowledge of Win Runner, Load Runner
Certifications VLSI , SQL
Major Projects
Project PREMIA 10i
Client Oriental insurance company
Period Mar 2008 – Aug 2009
Role Oracle PL/SQL Developer
Environment Oracle 9i, D2K,Toad 7.0
Description The PREMIA insurance management solutions suite is designed to proficiently perform all the functions of an insurance company such as Underwriting / Policy Administration, Claims Management, Reinsurance and Accounting. The offerings in this insurance software solutions suite are used by some of the most recognized names in the global insurance industry. The PREMIA insurance software solutions suite covers various business classes such as Property, General Liability, Workers Compensation, Commercial Auto, Business Owners Policy, Marine Cargo, Personal Auto, Homeowners, Health, Liabilities and related areas. The integrated modules available under the PREMIA insurance software solutions suite allow to capture information related to proposals, policy details and endorsements for all insurance business lines.
Responsibilities Performing System Study, System Analysis and Design.
Creating procedures and functions.
Coding using PL/SQL.
Fine Tuned the SQL queries using hints for maximum efficiency and performance.
Preparing test plans and testing Units based on test plans.
Performing System Testing.
User Acceptance Testing UAT
User Training and technical support
Project SHIP MANAGER
Client Teledata
Period Jun 2004 – Feb 2005
Role PL/SQL Developer
Environment Oracle 9i, D2K,Toad 7.0
Description ShipManager is a user-friendly and cost effective ERP software solution for the Global Marine Industry. The marine software product suite provides complete shipboard solutions, from inventory control and preventive maintenance, to overall vessel manpower management. This comprehensive solution is made up of individual modules that provide seamless information and integration between ship and shore for planned maintenance, inventory management, paperless requisition and purchasing, fleet personnel management, safety and security administration, dry dock management, budget and fleet accounting, fleet monitoring and document management.
Responsibilities Performing requirement Study.Creating procedures and functions.
Preparing test plans and testing Units based on test plans.
Preparing Implementation Documentation and user support documents
User Training and technical support
Prepared Functional and UI test cases.
Prepared Bug Tracker Report for tracking the various bugs in the product
Project HCL COMNET – Technical support
Client Cummins
Role Global Operations – Shift Lead (IT Service Desk)
Responsibilities Team Management (ITIL Process) and Problem Management
Leading Technical Helpdesk
Set KRA for the team according to the business requirements
Achieved Team and Individual SLA every month
Top 10 Problems analysis
Trend Analysis
Weekly dashboard
CGA reporting
Known error database documentation
User Interaction and follow ups on escalations
Training Team members on the user process
Heading the Shift for smooth operations
Using IT infrastructure management tool Remedy 5.
Hands-on Experience in Remedy Problem Management
Trouble shooting at server and client end, handling escalations, providing remote support in 24x7 environments.
EDUCATIONAL QUALIFICATIONS
Bachelor of Engineering (B.E) - four years, India
Training in Lotus Notes.
Training in ITIL.
Advance certification in VLSI
Oracle Certified In SQL
Contact this candidate