Abymon A.

Abymon A.

Database Developer with expertise in SQL server and Plsql

Keecheri , India

Experience: 12 Years

Abymon

Keecheri , India

Database Developer with expertise in SQL server and Plsql

32914.4 USD / Year

  • Immediate: Available

12 Years

Now you can Instantly Chat with Abymon!

About Me

Skill Summary
Operating System: Windows XP, Windows 7
Languages: Sybase Power Builder, VB.NET, SQL, PL/SQL, Microsoft Excel Macros. 
Tools: SQL Develper, Microsoft Visual SourceSafe, Crystal Reports, TOAD, Basware, MyAccess, Oracle EB...

Show More

Portfolio Projects

Description

Diamond is a new integration and Electronic Data Interchange (EDI) platform, uses the latest Web services systems integration technology to process claim, make it easier for healthcare providers, consumers and payers to interact efficiently. Diamond supports various processes like Claims Processing, Member Eligibility, Group Eligibility, Benefits, Coordination of Benefits, Provider Contracts, Finance activities etc.

Duration: (Oct 2013 – Dec 2016)

Roles & Responsibilities:
• Coordinating with onsite team for Knowledge Transfer
• Build up Client University of Diamond at offshore.
• Member of maintenance, development and support team.
• Root cause analysis and solve the issues.
• Coding front end using Power Builder.
• Coding backend in PL/SQL (Packeges, Procedures, functions, cursors etc.)
• Unit testing of the system.
• Execute and deploy change requests and enhancements in unit environment.
• Prepare Design Memo, RCA documents, Daily Status Tracker and SDS.
• Software Used: Power Builder 12.5, Oracle PL/SQL

Show More Show Less

Description

Roles & Responsibilities:

  • Handling problem tickets with different severities well within the SLA.
  • Handling multiple applications like Oracle AP, Oracle GL, Oracle iExpense, Basware for managing purchase and invoices, MyAccess for identity and access management, Oracle Hyperion Financal Management, Adobe Sign…etc
  • Writing SQL scripts to create reports as requested by the Client/Users
  • Managing and Monitor Servicenow queue and alert mails
  • Creating incidents, problem tickets and change request using ServiceNow
  • Execute manual script to perform daily monitoring
  • Having discussion and meeting with the Application Team, Vendor Team and the Business Users in understanding the issue and fixing them.
  • Organizing Bridge calls
  • Software Used: Sql Server , Oracle PL/SQL

Show More Show Less

Description

Project: REPLIR

Replir is a tool for resource planning and scenario planning in a large organisation. Its primary target is to distribute information within the organisation concerning project requirements and resource allocations. With Replir we can able to improve the precision of our rolling forecasts and use the tool in the budget process. Another target is to have an overview of our resources that enables us not engage in tasks for which we do not have enough available resources.

Roles & Responsibilities:

  • Member of maintenance, development and support team.
  • Analysing and solving the issues.
  • Coding front end using Power Builder and MS Excel Macros (VBA).
  • Coding backend in PL/SQL (Packeges, Procedures, functions, cursors etc.)
  • Unit testing of the system.
  • Day to day support activities involve analysing large volumes of data to identify and fix data anomalies.
  • Execute and deploy change requests and enhancements.
  • Client interaction through mail and phone.
  • Create monthly, weekly reports.
  • Software Used: Power Builder 12.5, Oracle PL/SQL

Show More Show Less

Description

Health Care Information System, Assists hospitals in feeding clinical, financial and demographic data into a single system resulting in single repository.

HCIS includes

  • Front Office & Registration Management
  • Outpatient Management
  • Inpatient Managements
  • Ward and Nursing Management
  • Pharmacy Management
  • Lab and Imaging
  • Billing and Cash Counter
  • Medical Records
  • Inventory Management

Show More Show Less

Description

Agricultural Management Information System is a complete ERP solution for plantation industry. It include the following features

  • General Ledger
  • Accounts Receivables
  • Accounts Payables
  • Fixed Asset Management
  • Check Roll Management
  • Personnel and Payroll
  • Supply Chain
  • Inventory Management
  • Estate Management
  • Production Management

Duration: (July 2007 – April 2009)

Roles & Responsibilities:

  • Programmer and Member of Implementation team.
  • Preparation of documents like SFS(System Functional Specification), Use Case, IAD(Impact Analysis Document),
  • Coding front end using VB.NET, Crystal Report.
  • Coding backend in SQL (Creating Procedures, functions, triggers, cursors etc.)
  • Unit testing of the system.
  • Client interaction through mail and phone.
  • VB.Net 2005 , MS SQL Server 2005

Show More Show Less