Previous Job
Previous
Application Developer - SQL, OOP, Web
Ref No.: 19-02827
Location: San Jose, California
Find out why eXcell is the employer of choice for contractors! Join eXcell and enjoy our generous employee benefits!
 
Project Scope:

Project 1: Customize and Integrate Software

The client is in the final stages of completing an addendum to their assessment tool agreement designed to modernize their current system. Given the enormous volume of transactions, this software will have a significant impact on productivity and accuracy. However, due to the Cobol-based legacy system and attendant manual processes, implementation requires significant customization and development. The Applications Developer will be automating significant functions.

Project 2: E-File and Paper Filing Enhancements


Manually processing, tracking and correcting business property statements is an exhaustive process involving review of account information, manual calculations, reimaging, and data entry. The process involves professional and clerical staff and is unnecessarily time-consuming with a high potential of error. E-file enhancements will include workflow tracking, assessment anomaly flagging, selective assessment review and correction, and integration with the electronic filing system intended to improve efficiency and accuracy.

Project 3: Business Data Discovery


The client has implemented a discovery program through the development of a data-matching tool to find businesses that are out of compliance with licensing. Discovery methods include the automatic integration of various databases.

Project 4: Automating Supplemental Corrections

The Applications Dev will be improving automation of this process to reduce manual calculation and potential for errors.

Skills:

Front-End Development – Expert
  • Codes in web centric environment (HTML3, JavaScript, VBScript, CSS3, XML, jQuery, JSON, etc.).
  • Develops, programs, and maintains the core web framework / template architecture.
  • Assures the accessibility of all web and mobile applications to all parties regardless of disability and compliance with state and federal laws regarding accessibility issues by developing, maintaining, and communicating policies for web access, and assessing individual site accessibility
Back-End Development – Expert
  • Programs in object-oriented languages and development environments (C#, .Net, etc.).
  • Develops deployment and infrastructure programs
  • Participates in discussions involving the application creation and understands the requirements and provides the back-end functionality for the applications
  • Works with all required development and documentation tools
  • Uses advanced functions and recommends new tools as required (Visual Studio)
SQL Development – Expert
  • Serves as technical lead for other development team members by understanding, advising, coordinating, and helping develop in the SQL Server environment
  • Creates Entity Relationship (ER) Diagrams to the proposed database
  • Creates database objects such as tables, views, stored procedures, triggers, etc.
  • Maintains referential integrity, domain integrity, and column integrity by using the available options such as constraints, etc.
  • Identifies columns for Primary Keys in all the tables at the design time and creates them
  • Creates functions to provide custom functionality as per requirements
  • Develops enterprise reports in SQL Server Reporting Services or equivalent components
  • Designs, develops, and deploys SSIS packages
  • Identifies and writes best possible code for new deployments or rewrites code to migrate newer version of SQL Server
  • Participates in development and creation of Data Warehouses
  • Creates cubes in SQL Server Analysis Services
  • Works with all required development and documentation tools
  • Uses advanced functions and recommends new tools as required (SQL Server Management Studio)
  • Determines appropriate technology for projects and uses database tools as required (T-SQL, SSMS, SSAS, SSIS)
  • Designs, recommends, and approves enterprise-wide SQL testing and troubleshooting
Typical Tasks:
  • Participates in application project planning processes, including identifying development tasks, efforts, and timelines
  • Participates in the software deployment process for new modules, upgrades, and fixes to the production environment
  • Suggests fixes to issues by doing a thorough analysis of root cause and impact of the defect
  • Evaluates existing applications and platforms and provides recommendations for improving application performance by conducting gap analysis, identifying feasible alternative solutions, and assisting in the scope of modifications
  • Assists in the development of user guides and training documentation for systems
  • Troubleshoots existing information systems to identify errors or deficiencies, and identifies alternative and/or innovative solutions to technical problems
  • Interfaces with the Business Analyst to determine the requirements for the development of or maintenance to application(s)
    • Designs, develops / codes, and integrates software solutions based on business requirements and using a disciplined development process
    • Reviews modules for quality assurance
    • Develops, executes, and documents unit test plans
    • Provides daily support with resolution of escalated tickets and ongoing maintenance of applications
    • Makes modules production-ready by moving them to libraries, completing forms, following procedures, completing version control documents, etc.
    • Documents functions and changes to new or modified modules and test activities / results
    • Evaluates new application packages and tools and performs research on best practices
    • May be assigned as a Disaster Service Worker, as required
    • Performs other related duties as required
Education:
  • Bachelor's degree from an accredited college in Information Systems, Computer Science, or other related field,
OR
  • Bachelor's degree from an accredited college AND five (5) years programming / systems experience
Knowledge of:
  • Relational databases, middleware, or object-oriented analysis
  • Development of user guides and training documentation for systems
  • Business requirements for the development of or maintenance to application(s)
  • Production operations development
  • Methods for troubleshooting information systems
  • Evaluation of applications and how to provide recommendations for improvement
  • Application project planning processes
  • Professional software engineering best practices for the full software development life cycle, including coding standards, code reviews, source control management, build processes, testing, and operations
  • Advanced programming techniques
  • Several programming languages of medium complexity and development tools
  • Business system applications and customer needs
  • Principles and practices of technical problem solving
  • Principles, practices, and techniques of customer service
  • Principles, practices, and current trends of project and technical documentation
  • Business application, program analysis, and design
  • Requirements analysis and documentation
  • Software training techniques
  • General theory and practices of business communication
  • System development life cycle concepts
  • Basic software quality assurance control
Ability to:
  • Translate business requirements into functional requirements for development
  • Identify errors or deficiencies and identify alternatives and/or innovative solutions to technical problems
  • Evaluate applications and provide recommendations for improvement
  • Define problems and recommend alternative solutions
  • Understand information systems and methodologies
  • Make oral presentations to technical and non-technical audiences
  • Read, interpret, and apply information from complex technical publications and documentation
  • Communicate effectively, both verbally and in writing
  • Promote and maintain a team environment
  • Organize, prioritize, and plan projects, and schedule multi-activity workloads
  • Establish and maintain effective working relationships with internal support units and customers
  • Gather, analyze, and present data
  • Analyze, research, and develop technical solutions to meet business requirements
  • Develop and evaluate technology alternatives for resolving customer business problems
  • Adhere to standards and procedures for development and documentation
 

We will consider for employment all qualified applicants, including those with criminal histories, arrest, and conviction records in a manner consistent with the requirements of applicable state and local laws. This includes the City of Los Angeles Fair Chance Initiative for Hiring Ordinance as well as the San Francisco Fair Chance Ordinance.

W2 only, no Corp to Corp. We are unable to sponsor H1B visas at this time. **eXcell™ Supports Equal Employment Opportunity** eXcell™, a division of CompuCom® Systems, Inc., a global company headquartered in Bellevue, Washington, provides IT staffing services and solutions to Fortune 1000 companies as well as small and medium business. For more information, visit www.excell.com.