We provide IT Staff Augmentation Services!

Facets Systems Developer Resume

TECHNICAL SKILLS

Web Application Development Ecosystem: HTML, SQL,PL/SQL,XML,.NET,TOMCAT, HTML5,CSS,LINUX

Programming, Scripting & IDE: PL/SQL, JavaScript, Oracle, Shell Scripting, Textpad, Putty, VISULAL BASIC.NET,UNIX/LINUX

Databases: My SQL, PL/SQL, Amazon RedShift, Oracle

Version Control: GitHub

Methodologies: Agile, Waterfall

Tools: Jira, Git, Docker

Cloud: Amazon Web Services

PROFESSIONAL EXPERIENCE

Confidential

Facets Systems Developer

Responsibilities:

  • Worked with a cross functional and diverse team of business users and developers to enable accurate communication of requirements and ensure consensus for BRD and FRD and business docs.
  • Build and maintain SQL scripts, indexes, and complex queries for data analysis and extraction and Identifying issues with teh database and resolving them.
  • Designed databases, stored procedures, reports, and data input interfaces using SQL Server 2005, 2008 and C#.
  • Involved in configuration of FACETS Subscriber/Member application and Worked onFACETSData tables and created audit reports using queries. Manually loaded data inFACETSand has good noledge onFACETSbusiness rules.
  • Develop ad - hoc reports on data from teh other applications on claims, benefit plan, provider and financials using Business Objects Enterprise XI, Desk Intelligence, SQL Developer, MS Access and Excel, SQL, and Oracle.
  • Compile SQL Queries to validate teh data integration between teh various Database tables and diagnosing and resolving database access and checking on performance issues
  • Work closely with teh business team, development team and teh Quality Assurance team to ensure dat desired functionalities has been achieved by teh application
  • Assisted teh project with Change requests and held responsible for weekly changes to teh applications. Maintained and recorded teh ticket numbers for request changes on CR manager tool.
  • Involved in testing Facets Member/Subscriber, Billing, Medical Plan, Dental Plan modules.
  • Plan, design, and implemented application database code objects, such as stored procedures and views.
  • Monitored teh performance of teh database and checked on teh execution time and developed various SQL servers and ensured dat they were properly maintained and supported.
  • Integrating with third-party services and external APIs as a part of implementation of teh mission-critical progressive web application standardizing teh way of user accounts management amongst different projects and mitigating code duplicity.
  • Worked with Facets TriZetto Batch Scheduling and monitored daily for updates in various domains of teh Facets .
  • Designed and populated specific tables, databases for collection, tracking and reporting of data.
  • Reviewing teh quality of code for teh mission-critical internal web application ensuring compliancy with teh company coding standards

Confidential

Computing and Teaching Assistant

Responsibilities:

  • Maintained databases for student records. Performed update and delete operations.
  • Used Ansible playbooks for updates and installations in all systems.
  • Responsible for contacting faculty teaching undergraduate statistics and methods to request access as Graduate Assistants to their D2L pages.
  • Co-written papers by teh professor and conducted and performed experiments for teh professor.
  • Helped students with various errors in technologies like Linux, AWS, Java and Python.
  • Provide telephonic support for a variety of technical problems like computer software’s installations, updates hardware support and user access issues.
  • Scheduling meetings and appointments and being a point of contact for a range of staff and external students.
  • Conducted independent research under teh supervision of a faculty member and provided support to a faculty member's research program.
  • Writing and issuing emails to teams and departments on behalf of teams or senior staff,