Amare Getachew
*********@*****.***
SUMMARY OF QUALIFICATIONS
Experienced Information Technology (IT) professional with 5plus years of BPM development exclusively in Analysis, Design, Development, Testing, Maintenance, Integration and Support BPM applications using Appian BPM technologies
Good understanding of Appian Objects such as Records, Site, Action, Security, Expression Rules, Query Rules, Interface Rules, CDTs, Process Models, Decisions, Integrations, Constants, Data Store, Groups, connected systems, and Web API.
Experienced in configuring, debugging, and system integration, including configuring forms, reports, underlying logic, and interface components.
Hands-on experience in designing, implementing, and producing Appian BPM applications.
Excellent technical and analytical skills with the ability to analyze system functionality with customers and resolve production issues.
Proficient in incorporating the functional requirements into the Appian business flows using Process Models, Rules, CDTs, and Web Service integration
Excellent analytical skills and sound knowledge of weighing the pros and cons of design choices and making suggestions to management, Product owner, and team members.
Hands-on experience designing, developing, modifying, integrating, testing, deploying, and supporting Appian-based BPM applications.
Proficient in developing a library of reusable appian components that can be leveraged in different applications
Excellent time management and ability to prioritize work with little direction.
Excellent knowledge of collaboration with internal teams, partners, and client resources on project– related tasks to meet delivery dates.
Sound experience in participating in story refinement, design, development, testing, and support for applications.
Experienced in working with an agile framework, including user story refinement, Sprint planning, deployment, and retrospectives.
Excellent understanding of BPM and delivered applications using Appian Enterprise BPM application.
Experience in SAIL Forms, Sail Dashboards, and Web and entity-backed reports.
Experience in end-to-end Appian BPM implementation.
Experience in writing T-SQL Scripts to improve the overall quality & reliability of the information
Hands-on experience in Implementing new features and updating existing features on the Appian Platform.
Strong knowledge of Power BI data querying and modeling capabilities, such as creating calculated columns, measures, and relationships.
Experience with data integration and database design, knowledge of data warehousing methodologies
Expert in Designing Data integration packages and documentation to provide insight into data lineage EMPLOYMENT HISTORY
Appian Developer
NAIC- (Chamber It Inc) Mar 2022-Current
Worked with Business to understand their requirements and design and develop them into to Workflows / process flows and models.
Worked on Increasing Performance of the queries by minimizing multiple calls from database.
Creates Appian objects such as records, models, rules, CDTS, interfaces, sites, etc.
Constructs conceptual application architecture including records, reports and news feeds.
Review Business and functional requirement documents conduct Impact analysis.
Designs conceptual workflows and related actions n Defines application user roles and responsibilities.
Build intuitive and usable interface and workflows.
Implements application security and defines user groups.
Monitors activity within each application and escalates potential environment and infrastructure issues.
Creates relational database schemas and SQL views and integrates with other systems.
Works with Subject matter experts, stakeholders to gather requirements.
Performed analyzing JIRA user stories, designing, and developing application modules.
Resolve technical issues within applications.
Performed performance testing using JMeter and Functional Testing.
Participated in designing security applications n Performed validations, Flows and Process Modular design using Appian.
Worked on Appian Integration with SharePoint and Microsoft dynamics.
Created sites and records for different modules.
Created various expressions and logic for handling the Process variables & Global variables.
Created SAIL Forms, SAIL Dashboards, SAIL Reports, Service and Entity Backed Records.
Created various expressions and logic for handling the Process variables & Global variables.
Involved in assisting team by testing and checking dependencies during migration from MySQL to Oracle n Performed analysis, design, development and managing Workflows, User Interface (UI).
Designed and Created Workflows, Activities, Activity Step Methods, Layout and Sections.
Created database views, Store procedures.
Business Intelligence Developer
Freedom Mortgage -(Chamber It Inc) Feb-2019-Mar 2022
Created & Managed Database Objects such as Stored Procedures, Views, Tables & Function to support application team & Ad Hoc Data Request.
Updated existing Stored Procedures to accommodate new business rules and processes.
Utilized MS SQL Server system functions to identify and resolve Query Performance issues.
Built Data Integration workflows to transfer data from heterogeneous sources (Flat file, Excel, CSV, & Access).
Worked on Data Mapping and Documentation.
Responsible for Data Profiling to determine data integrity for transformation of Data from Source to Target.
Developed several detail and summary reports including line and pie charts, trend analysis reports and sub- reports according to business requirements using SQL Server Reporting Services (SSRS).
Involved in Data Analysis, Dimensional Data Modeling, and ETL Design & Report Development.
Conducted and automated the ETL operations to Extract data from multiple data sources, transform inconsistent and missing data to consistent and reliable data and finally load it into the multi-dimensional data warehouse.
Monitored time taking queries with Performance Tuning to reduce the execution time and created packages in SSIS with error handling and tested the packages for Incremental Data Load & duplications.
Analyzed data and generated different kinds of graphs and charts using Excel.
Created custom columns and measures using DAX in Power BI
Configured Enterprise Getaways and Scheduling Datasets in Power BI Service
Configured report Subscription and report sharing rules in Power BI workspace.
Utilized Custom Visuals from Power BI marketplace.
Developed data visualizations in Power BI Desktop and Power BI Service
Designed dynamic visuals using Bookmarks, Slicers, custom tooltips in Power BI
Created and managed Power BI App workspaces (Classic and Modern)
Published and Shared Power BI reports and Data models in Power BI workspace TOOLS AND TECHNOLOGY
RDBMS: SQL Server 2008/2012/2014/2016, Oracle 11g, AWS, Redshift
Appian: Version 21.x,22.x,23.x,24.1
BI/Database Tools: SSIS, SSAS, SSRS and SQL Server Data Tool, Alteryx, Power BI, Tableau, Crystal report
Data source: XML, JSON, Text file, Web service, etc.
MS-Office: MS Excel, MS Access, Microsoft Office Tools.
Languages: VB.NET, C#, T-SQL & PL/SQL
Others: Trello, JIRA, TFS, Visual studio, FTP, SFTP PROJECT DELIVERY METHODOLOGY
Agile methodology with Multiple Sprint Cycles
o Customer-focused and rapid delivery
o Adaptive to changes in technology & requirements o Highly collaborative with Daily Scrum meetings
EDUCATION
BS in Engineering