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 wif 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 teh 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

PROFESSIONAL EXPERIENCE

Senior 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 teh requirements and designing process based on teh requirement.
• Providing teh development estimates to teh sprint JIRA’s.
• Designing, developing, modifying Appian BPM process applications for different workflow modules.
• Interact wif business daily and be one of teh point of contact for business.
• Perform code reviews and ensure quality of teh 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 teh 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 wif Business and front-end processors, presenting teh developed stories.

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

Appian Developer

Confidential, Columbus, Ohio

Responsibilities:

• Interacted wif business for requirements and for clarifications on stories.
• Followed teh Agile methodology to deliver teh application in sprints.
• Worked on column browser to select different product wif different hierarchy, also displaying dynamic milestones using decision object.
• Performed bug fixing and full fleshed testing of UI forms and process models.
• Always took teh responsibility if any major bugs or complex requirements to deliver.
• Design and implement complex enterprise integrations wif 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 teh agile tool JIRA in creating stories and story estimation.
• Expertise in SAIL which includes Forms, Dashboards and Reports.
• Created Expression Rules dat restricts teh data entered from user end as per teh Business Requirements.
• Adding teh 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 teh Business Users.
• Design teh 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 teh 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 teh process models.
• Create templates for Docs & generate them after mapping them in process models.
• Report work progress & fix bugs in teh 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 wif business users and requirements analysts to gather requirements.
• Created technical specification documents like system design and detailed design documents for teh 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 teh 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 teh source XML files, audit trialing.
• Developed ESP Jobs for teh Informatica code
• Performed unit, integration and system testing and provided UAT support to business partners.
• Participated in code reviews and ensured dat 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 teh core technologies.
• Designed and coded teh 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 teh 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 teh data from staging area to teh final Dim/Fact tables.
• Created technical specification documents like system design and detail design documents for teh development of ETL mappings to load data into various tables in Data Marts.
• Extensively Worked wif ESP and Maestro Scheduling tool like creating, uploading job script files, creating dependencies on other Jobs and also developed calendars for scheduling.
• Involved in teh 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 dat all solutions are aligned to pre-defined architectural specifications
• Created shell scripts to ftp teh files between multiple servers like outbound/inbound.
• Responsible for providing teh guidelines to production support team in order to resolve complex production abends.
• Identify and verify teh impact based on teh 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 teh issues in teh claims system. Due to teh issue in source data.
• Responsible for data fix like rebuilding teh dimensional, daily/monthly facts in production due to teh issue wif source data.
• Implemented automation on some of teh Manual process in our system like Claims Reprocess.
• Co-coordinating wif India based team in teh onsite-offshore team model.

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