Adroit Architecture LimitedBusiness Data Analyst
Aug. 2013 - Dec. 2019Crystal Plaza, Off Mai Mahiu Road, (Opposite T Mall). 2nd Floor.• Primary responsibilities included gathering and documenting requirements, performing systems analysis, modelling data flows between IT systems, creating and updating use case diagrams, and preparing technical specifications of application functionality. • Applied strong SQL knowledge (querying tables) to source and compile data. Interpreted and analyzed data for accuracy and efficiency, effectively communicating analysis output. • Performed medium to complex data transformations and cleansing in excel using formulas like VLOOKUP, INDEX/MATCH, IFS, MID, Conditional Formatting, and array formulas. • Maintaining relationships with important clients by making regular visits, understanding their needs, and anticipating new marketing opportunities • Supported daily inquiries, integrated content, and managed internal communications, including management of • weekly management meetings, data reporting, and other day-to-day business administrative activities. • Tracked and monitored progress against a timeline and key milestones, also tracked project-related financial expenditures.