PROFESSIONAL SUMMARY:

• Software professional wif work experience in web and data application development, testing and designing.
• Appian Designer, Appian Analyst and AWS Solution Architect Certified.
• Experience using Appian Self Assembling Interface Level (SAIL) to develop user - friendly applications.
• Experience creating Records and Reports for displaying data from Processes, Data Entities and Web Services.
• Experience in building Sites, Tempo and Embedded UIs in Appian.
• Experience creating CDT's, Process models, expression rules and other Appian objects.
• Good team player as well as individual contributor for the projects.
• Good Understanding of Web Services like SOAP and REST.
• Experience working wif MS SQL, MySQL, SQL Server and Oracle databases.
• Enthusiastic to learn new technologies or languages based on the requirement of the role.
• Agile experienced
• Project Management experience
• Excellent analytical skills
• Appian Designer Certified wif expertise in Appian 18.x, 19.x and 20.x

TECHNICAL SKILLS:

Software and Languages: Appian, Java, C++, MySQL, HTML, CSS, MATLAB.

Tools: Tableau, Visio, Microsoft Access, Microsoft Excel (Pivot tables), Microsoft Project

PROFESSIONAL EXPERIENCE:

Appian Developer

Confidential, VIENNA, VA

Responsibilities:

• Created test tools for different scenarios to enter the data manually.
• Created various batch processes to get triggered at particular timing to load the data from one table to another based on various conditions.
• Created various views and altered many tables to add in new columns based on the requirements and added data manually into the tables.
• Created various process models and using them as actions by calling in a record type into the interface.
• Added in security rules for visibility of the related action between 6:30 AM to 6 PM.
• Used “a recordActionField” as a function to call a record type in an interface.
• Created various Interfaces, Process Models, Expression Rules, Query Rules, Sites, Record Types, Database Views.
• Usage of Amazon S3 plugin to store the documents to S3 and not having a copy of them in Appian for security.
• Created validation rules for null check, character limit and bytes to MB conversion.
• Worked on many bug fixes.
• Used Jira to monitor the progress of the tickets for the sprint and to add in comments on the ticket.

Appian developer

Confidential, richardson, tx

Responsibilities:

• Provided Appian development support for the existing applications.
• Worked on bug fixing and enhancement requests.
• Used Service Now tool for incident management, where the users get to post their issues related to the applications/Appian usage.
• Checkout practices for every deployment on Friday and Saturday nights on a roaster basis involving changes to Appian environment to check if the application is affected or not.
• Monitored the batch processes on a daily basis which happen over-night and provided a detailed analysis if any of the process fails.
• Worked as a full-time support for the application by taking the ownership of it.
• Used JIRA ticketing tool to create defects based on the users reporting their issues by differentiating if it is a defect or an enhancement.
• Application mainly deals wif Medicaid and Commercial medical insurance policies to the members which deals wif different integrations and Web APIs.
• Participated in SCRUM and Business discussion meetings.
• Worked wif the architect to determine the number of human hours required for the defect correction and enhancement requests.
• Worked wif BAs’ and Architect to discuss the overall architecture and business design.
• Interaction wif the end users on a monthly basis to know the changes to be made to the application.

Appian developer

Confidential, dallas, tx

Responsibilities:

• Worked wif the different teams to ensure the development is done on time to reach the business requirements.
• Supported technical team members in testing the changes wif users from different user groups to make sure the application is working correctly.
• Provided Appian development support for the existing applications.
• Shared my view on the existing design of Interfaces, Database Schema, Process Models and made sure the functionality worked properly after the design change.
• Created PoC for an application which deals wif allocating hangars to flights and vehicles of the employees working at the Airport.
• Shared my view on Appian Record Type and usage of it where the team was creating a replica of the Record Type using an interface.
• Created various Expression Rules for the visibility of the Related Actions for Super Users and Authorizers.
• Created a CDT to store documents in the external database wif “BLOB” datatype in the Oracle DB.
• Worked on “Send file to RDBMS BLOB” plugin to store the document uploaded to an external DB.
• In the same way, worked on “Receive File from RDBMS BLOB” plugin in order to retrieve the document from the external DB based on the “DOC ID” and made it readily available for download at the click of a button.
• Used “a startProcessLink()” function to retrieve the document from external DB by passing the “DOC ID” as the parameter.
• Created process models(batch processes) which get triggered at 2 am, to delete all the documents in a folder.
• Created Reports, which display the Company details in a grid which has “Submitted” and “Not Submitted”, “Monthly” and “Annual” Logs by a click, on the respected area in the “Pie Chart”.
• Helped Project Manager in preparing the User Documents in a PowerPoint file wif all the required screen shots for better understanding.
• Created Process Models to notify the Users who has not submitted “Monthly” and “Annual” Logs and triggered them accordingly to run on “15th of every month” for “Monthly Logs” and “30th day from the start of every Fiscal year” for “Annual Logs”.
• Created expression rule to count the number of rows in an excel sheet.

Appian developer

Confidential

Responsibilities:

• Interact wif Business and co-ordinate wif the team to build the environment survey and permitting system
• Worked in Agile environment to report updates and velocity for each 2 weeks sprints.
• Created sites for different user groups such as admin, reviewers, permit approvers and others to interact wif the application.
• Created various process models for related actions in order to update the survey application.
• Created various Expression Rules for the visibility of the Related Actions for the reviewers.
• Created a re-usable “Project Document Repository” process model to use to it across the application wherever required to save, update and delete the documents.
• Developed Appian Process Models, developed Interfaces using SAIL, developed Task Reports and other Reports required for the application.
• Created many Reports wif various “Pie”, “Bar” and “Column” Charts to display the number of Reviews, Documents and Projects based on Area, Plan Type etc., and added various dependent filters making it easy for the user to track the desired record.
• Created User Documents by writing the User Stories and giving them the Acceptance Criteria and explaining them what to anticipate next.
• Worked on Appian Application deployments from Development to Test Environment as well as to Production environment by exporting the application from Dev environment after testing the application thoroughly for any errors or issues and checking for the Missing Precedents and Security Summary.
• Worked wif the network team of KDOT and Appian Service to establish Single Sign On using SAML Autantication in Appian which had 3 different Identity Provider Choices where one was for System Admin, KDOT users and one for KDOT offline users wif different sign-in pages for the users to select where 2 of the sign-pages were Appian sign-in and one was for KDOT users whose IdP was configured.
• Guiding the interns on their work and monitoring their work on a daily basis by assigning them small tasks.
• Created many Views in MySQL Database to fetch the data by writing a simple expression rule to reduce the complexity and to increase the Performance level.
• Used functions in Expression Rule to read the data from excel sheet and insert dat into the database where the CDT is already created and published to the Datastore.
• Supported users during the UAT testing and fixing the defects identified for the next scheduled Sprint.

Appian DeVELOPER

Confidential, DULUTH, GA

Responsibilities:

• Design and implementation of BPM process applications for different workflow modules in Appian.
• Worked on creating Utility Permitting System Application and Invoice Approval for state government projects.
• Created Interfaces, Process-Models and Sites for the Applicants to enter Data and to store it to the Database.
• Created Record and Site for the Approver, so dat the Approver can investigate the data entered by the Applicant and take a decision on to “Approve or Deny” the Applicants Request.
• Created Records for Company and Permit where the Company Record holds the details of various Companies registered and Permit Record holds the details of the Permit Applied by the Company.
• Created various Interfaces and related Process Models for the Petitioners to register their Company to the Client, for Approvers to investigate the details of the Company and to “Approve or Deny” the Register Request.
• Created various Expression Rules to fetch the data for a record from the database, visibility rules for the Petitioners to Update the data entered by them.
• Supported all phases of testing and defect resolution for the project.

Database Analyst

Confidential, DALLAS, TX

Responsibilities:

• Performed application support and database (Microsoft SQL Server and Oracle) maintenance tasks.
• Developed procedures and scripts for continuous improvement, repeatable processes and database maintenance.
• Created function in SQL Database to add an auto incremented index to a View created combining various tables using joins to get the distinct values from the tables.
• Provide expertise in SQL tuning, backup and recovery support, installation and configuration of Microsoft SQL Server and Oracle.
• Facilitate resolution for production issues in the databases.
• Monitor and maintain database backups, optimizing jobs and integrity checks and take corrective action as required.
• Analyzed and filtered large, complex data sets using Excel, SQL Tables, views and stored procedures.
• Identify and initiate process improvements.

Programmer Analyst

Confidential, Lewisville, TX

Responsibilities:

• Extracted and collected data to create needed reports.
• Design and maintain SQL scripts.
• Created and optimized diverse SQL queries.
• Developed SQL queries to fetch complex data from different tables in remote databases using joins.
• Configured and monitored database application.
• Created Tables, Indexes and Constraints
• Generate reports and spreadsheets detailing database changes and performance
• Used Inner and Outer joins to write complex SQL queries