Adroit Associates Inc interview questions

• Facilitated JAD sessions as Facilitator and conducted interviews with various Subject Matter Experts (SMEs) and stakeholders, process reviews and policy & procedure reviews to elicit requirements. • Used MS Visio for Process modeling, Process mapping and Business Process flow diagrams. • Performed GAP analysis to assist Product Owner and Project Manager in planning the transition. Interacted with stakeholders to Identify business needs and evaluated business solutions. • Prepared Business Requirement Document (BRD) and assisted in the preparation of System Requirement Specification (SRS). Analyzed, modified and validated these documents from the requirements gathered. • Assisted incash flow analysis and preparing a summarized reports relating to cash in-flow and cash out-flow • Developed Conceptual and Logical ER diagrams for the database. Created Data Dictionary for the data models. Identified Source systems for financial data profiling of the legacy system to be moved into target systems. • Performed Data Mining to find correlation and pattern in existing data and constructed SQL queries. • Assisted in the implementation of Integrated Data Warehouse with individual data marts to address areas of business interest. Used ETL to map data, assemble data repository and created data marts. • Strong knowledge in ETL tool, Informatica Power Center for Data Normalization (1NF, 2NF), Data Indexing & mapping using and Informatica Data Quality for Data Profiling and Data Integrity using Informatica DQ. • Worked closely with Project Manager for any change request and helped SMEs to do Impact Analysis.Designed and developed all Use Cases, Activity diagrams and UML models using tools such as MS Visio. • Managed and tracked requirements using HP ALM through Application Life-Cycle. • Conducted User Acceptance Testing (UAT), Manual Testing using Test Lab in HP Quality Center (HP QC) and assisted automation testers with system testing, integration testing and Regression testing. • Was involved in using Tableau for effective visual representation of Business Intelligence (BI) to facilitate expenditure tracking using various parameters critical to decision making.