IT Software Development Advisor

Description Develop, maintain, test and debug software to meet generally defined requirements in a Windows client/server environment utilizing software development languages/environments such as PL/SQL, Oracle, Progress 4 GL Application Development Environment (ADE), .NET, Microsoft SQL, or other platforms. Formulate and define system scope and objectives through research and fact-finding for the purpose of developing or modifying moderately complex information systems. Prepare detailed specification from which programs will be written. Design, code, test, debug, document and maintain programs. Become familiar with most aspects of the application including reports, parameters, claims management, intake services, carrier/client interfaces and vendor/business partner interfaces. Analyze user needs as required. Assist in the design of specifications to meet end user needs. Develop and modify software to meet the specifications outlined in data processing requests. Develop and maintain software to meet requirements of insurance carrier and regulatory groups. Test and debug assigned projects. Assist in testing projects for other members of the programming staff. Prepare documentation on new or existing software. Investigate call escalations from the support staff. Make the necessary corrections to data and/or software. Assist in the professional growth of programmers. Follow departmental pre-established standards and guidelines as they pertain to design and development. Adhere to the goal of delivering and maintaining the highest quality of customer service to our clients. Keep abreast of software development language revisions and technology advances. Support the organization's quality program(s). Qualification : High School Graduate/GED. Preferred: Bachelor's degree major in Information Systems or Computer Science. 6 years of Language Development in a relevant and Applicable Language and/Or Business Analytical experience. Strong knowledge of Language Development and Applications Design. Oracle PL SQL Developer. Experience in writing Packages for data loads. Experience creating and maintained Stored Procedure (Packages, Procedures, Function, and anonymous block) with Oracle PL/SQL. Experience using Cursors to pull data from the Database. Experience creating and maintained from simple to complex queries pull data from the Database. Experience in SQL Tunning to improve the query performance by identifying key fields, adding/removing tables/fields, and use of indexes. Good understanding of Oracle Explain Plan. Experience in designing Relational Databases. Analytical and interpretive skills. Strong organizational skills. Excellent interpersonal skills. Excellent negotiation skills. Ability to work in a team environment. Ability to meet or exceed performance competencies. Progress 4GL/Open Edge experience At least 8 years of hand on experience in development, including 5 in Open Edge/Progress 4GL . Strong skills in Progress 4GL programming which includes GUI Development, Backend Development, Three tier architecture, App servers. Object Oriented Open Edge, Open API etc. Hands on experience on API developments with source/target Open Edge DB. Strong Skills in data analysis, data modeling, development, testing and documentation. Strong skills on automating jobs using UNIX Shell scripts to run all the Progress programs. Hands on writing Cursors, Transactions, User-defined Object types, Records, and Tables in Progress 4GL Programming. Strong Skills in Exception Handling extensively debug Progress Code, DML and display the error messages in the application. Experience in creating server-side programs for distributed Progress 4GL applications on Classic Progress, and V12 Open Edge App Servers. Experience in performance Tunning to improve the query performance by identifying key fields, adding/removing tables/fields, and use of indexes. Proven experience In Interpreting User Requirements, Business Applications Design, and Development of Business Applications. Benefits: Healthcare Insurance: Synectics offers eligible employees and their dependents healthcare coverage through BlueCross BlueShield of Illinois. Eligibility begins on the 1st day of the calendar month following 60 days of continuous full time employment with Synectics. Premiums are subsidized by Synectics. Dental Insurance: Synectics offers eligible employees and their dependents a dental plan through MetLife. Eligibility begins on the 1st day of the calendar month following 60 days of continuous full time employment with Synectics. Vision Insurance : Synectics offers eligible employees vision insurance through VSP. Eligibility begins on the 1st day of the calendar month following 60 days of continuous full time employment with Synectics.401(k) Plan: The Synectics Inc. Investment Savings Retirement Plan. Synectics offers all employees who are 21 years of age or older the opportunity to invest in the 401(k) Plan on the first enrollment date that is at least 30 days after employment begins. Enrollment dates are each January 1st, April 1st, July 1st, and October 1st. Technical Certification Bonus: Synectics is pleased to award its employees a bonus of up to $500 for an approved professional certification. In determining the bonus amount, Synectics will consider the cost of the test(s) for any certification relating to your current position, achieved during your employment with us. Only one Certification Bonus per calendar year may be awarded per employee. Only current, active employees will be eligible to receive this bonus. It will be awarded 90 days after the Synectics office has received documentation confirming the successful completion of the certification. Synectics is an equal opportunity employer.