SUMMARY:

• Around 12 years of experience in IT Industry and 5 years of experience in Appian BPM Suite.
• Adept in BPM implementation using Appian versions (18.X,19.X,20.X,21.X), Cloud Environments.
• Expert in end to end BPM implementation involving Process Designing, Process Modeling, Rules, Data Management, User and Role Management, Process Reports, Tempo Reports, Tempo pages & Dashboards.
• Expertise in SAIL Interface.
• Involved in various phases of SDLC like requirement analysis, design and development.
• Worked on document generation smart services like Export CDT to Excel, DOCX From Dynamic Template, PDF from DOCX, Parse Excel Spreadsheet to CDT, PDF from Docx, Word Doc from Template etc.
• Worked on connectivity services like Call Web Service, Query Database, Set External PV, Get External PV etc.
• Worked on Process Management services like Modify Process Security, Upgrade Processes, and Upgrade Processes from Version.
• Worked on Data Services like Write to Data store Entity, Write to Multiple Data store Entities.
• Worked on Integration of Appian with external systems through web service and Sites.
• Worked on MySQL, Oracle, and MS SQL Server databases.
• Worked on creating database Tables, Views, Procedures, Triggers, Functions and Sequences.
• Expert in application deployment to QA and Production environment.
• Implemented Appian best practices on all developed applications.
• Developed a POC for clients to showcase new features of Appian.
• Working experience in an Agile/Scrum environment.
• Well versed in the complete SDLC starting from requirements gathering, use cases, design, developmentand testing

TECHNICAL SKILLS:

BPM Tools: Appian 18.x, 19.x, 20.x, 21.x, 22.x

Database: MySQL, Oracle, DB2, MS SQL Server

Languages: Unix Shell Scripting, Java, J2EE, HTML, SQL

Tools: JIRA, VSTS

EXPERIENCE:

Sr. Appian Developer

Confidential, Columbus, Ohio

Responsibilities:

• Working on a project enhancement to extract and migrate data source from in - house Mainframe to Financial Industry standardize Fiserv.
• Analyze current state column mapping documents to produce a future state column mapping documents.
• Responsible for requirement gathering and analysis.
• Understand the requirements and designing process based on the requirement.
• Providing the development estimates to the sprint JIRA’s.
• Designing, developing, modifying Appian BPM process applications for different workflow modules.
• Interact with business daily and be one of the point of contact for business.
• Perform code reviews and ensure quality of the overall delivery.
• Deploy code into test and production environments on schedule, provide follow up production support.
• Creating, modifying process models and user interfaces for functionality.
• Create CDT’s from XSD & create tables in database through data store.
• Create, modify query rules and reports for functionality.
• Created different areas to be displayed in the form, for each user group.
• Development of query rules, expression rules and CDTs (Custom Data Type).
• Building dashboards, tasks, and process reports.
• Unit Testing of application components.
• Attending Sprint reviews with Business and front-end processors, presenting the developed stories.

Environment: Appian (22.x,21.x), MySQL, DB2, Yellowbrick, WinSQL, Java, Jira, Splunk

Appian Developer

Confidential, Columbus, Ohio

Responsibilities:

• Interacted with business for requirements and for clarifications on stories.
• Followed the Agile methodology to deliver the application in sprints.
• Worked on column browser to select different product with different hierarchy, also displaying dynamic milestones using decision object.
• Performed bug fixing and full fleshed testing of UI forms and process models.
• Always took the responsibility if any major bugs or complex requirements to deliver.
• Design and implement complex enterprise integrations with internal systems to obtain required data.
• Deploy code into test and production environments on schedule, provide follow up production support.
• Create new process models and user interfaces for functionality.
• Unit Testing of application components.
• Good exposure to the agile tool JIRA in creating stories and story estimation.
• Expertise in SAIL which includes Forms, Dashboards and Reports.
• Created Expression Rules that restricts the data entered from user end as per the Business Requirements.
• Adding the members in different type of User Groups. Managed end-to- end application support for all Appian applications deployed.

Environment: Appian (20.x, 19.x), Oracle, Java, Jira

Appian Developer

Confidential, Winston-Salem, NC

Responsibilities:

• Involved in Requirement Gathering from the Business Users.
• Design the solution to meet user’s requirement.
• Responsible for Analysis, Design & Development.
• Create new process models for functionality.
• Create CDT’s from XSD & create tables in database through data store.
• Writing all the SQL queries to get data from database into model or store data into database.
• Create query rules, business rules & reports for functionality.
• Create new process models and user interfaces for functionality.
• Write JavaScript Code & CSS for the process models.
• Create templates for Docs & generate them after mapping them in process models.
• Report work progress & fix bugs in the code.

Environment: Appian (17.x, 18.x), Web Services, Java Script and SQL Server.

Confidential | Dublin, OH

Sr. ETL Developer

Responsibilities:

• Worked as a Sr. ETL Informatica Developer on ADW Securities team, implemented using Informatica PowerCenter.
• Worked closely with business users and requirements analysts to gather requirements.
• Created technical specification documents like system design and detailed design documents for the development of ETL mappings to load data into ODS tables.
• Led team of three Informatica developers for successful implementation of data flattening, cleansing, transforming of complex XML files.
• Reduced the overall run time from 3 hours to 10 mins by fine tuning several Informatica complex mappings and Unix scripts in Data Integrator and distributed commissions.
• Developed UNIX shell scripts for cleansing the source XML files, audit trialing.
• Developed ESP Jobs for the Informatica code
• Performed unit, integration and system testing and provided UAT support to business partners.
• Participated in code reviews and ensured that all solutions are aligned to pre-defined architectural specifications.

Environment: Informatica Power Center, Oracle, UNIX, Autosys, and Business Objects.

Confidential, Columbus, OH

Sr ETL Teradata & Informatica Developer

Responsibilities:

• Worked as a Sr. ETL Developer on multiple projects, implemented using Informatica PowerCenter 9.5, Teradata, Oracle and Microstrategy as the core technologies.
• Designed and coded the application components in an Agile/Scrum environment.
• Informatica mappings and workflows are developed to extract data from multiple databases, flat files, Mainframe files and load into the Teradata warehouse.
• Teradata jobs like Multiload, FastLoad, Fastexport and BTEQ programs are developed to cleanse, transform and load data into Teradata warehouse.
• Developed BTEQ's for loading the data from staging area to the final Dim/Fact tables.
• Created technical specification documents like system design and detail design documents for the development of ETL mappings to load data into various tables in Data Marts.
• Extensively Worked with ESP and Maestro Scheduling tool like creating, uploading job script files, creating dependencies on other Jobs and also developed calendars for scheduling.
• Involved in the analysis and optimization of long running jobs.
• Performed Unit, Integration and system testing and provided UAT support to business partners.
• Solved many User incidents/queries.
• Participate in code reviews and ensure that all solutions are aligned to pre-defined architectural specifications
• Created shell scripts to ftp the files between multiple servers like outbound/inbound.
• Responsible for providing the guidelines to production support team in order to resolve complex production abends.
• Identify and verify the impact based on the changes in downstream/upstream applications.
• Provide development estimates and planning. Created technical design documents to map sources and targets as per business requirements.
• Worked on claims reprocessing activity to fix the issues in the claims system. Due to the issue in source data.
• Responsible for data fix like rebuilding the dimensional, daily/monthly facts in production due to the issue with source data.
• Implemented automation on some of the Manual process in our system like Claims Reprocess.
• Co-coordinating with India based team in the onsite-offshore team model.

Environment: Informatica Power Center 9.5.1, Teradata 14, Oracle 11g, Netezza, UNIX, Maestro, and ESP