Liya T. Weresom
Highly motivated Business Analyst with over 7+ years of experience. Proficient in database development life cycle including, database coding, testing, and implementation. In-depth knowledge and understanding of business requirements and changing them into meaningful business solutions. Capable of collecting and analyzing business requirements through the lens of the development life cycle. Hands on experience in designing complex reports using SQL Server Reporting Services (SSRS). Experienced in writing complex stored procedures and script optimization and performance tuning. Exceptional problem solving and verbal and written communication skills.
•Preparing specification and documentation
•Implanting Test Plan, Test case
•Testing and supporting next-generation database and application
•SQL Performance Tuning, Optimization & Capacity Monitoring
•Data Security, Backup & Recovery
•SSIS, SSAS, SSRS
•Software Development Life Cycle
•MS SQL Server 2000/2005/2008R2/2012
•Strong analytical skills
State of Tennessee, Nashville, TN Jan 2017- March 2019
•Create detailed systems analysis packages following State IT PMO standards. Each analysis package includes detailed business and functional requirements, data/process flow diagrams and a data dictionary.
•Actively working on TN Dept. of Health project in Agile Methodology in writing User Stories, documenting UAT progress.
•Providing application support for the Health Licensure system for both in-house regulatory and public online systems.
•Documentation of new project requests and estimating budget in PlanView.
•Provide customer service by developing on-time Help Desk solution delivery, proper application support documentation, user manuals and technical support/advise as needed.
•Review log files, reproduce bugs, provide work around, provide the vendor with proper documentation of the issue, track the progress and assist in deployment of the fix.
•Duties also include requirement elicitation sessions, presentations, root cause analysis packages, tickets status updates, user training and assistance in testing.
•Understanding business requirements and translating them into specific software requirements.
•Defines business processes both “To Be” and “As Is.”
•Liaison between technology teams, support teams, and business units.
•Review functional and design specifications to ensure full understanding of individual deliverables.
•Having strong technical skills, business intelligence, and a full understanding of the needs of the customer.
•Execute and evaluate manual or automated test cases and report test results.
• Manage and facilitate test plan and test case reviews with cross-functional team members.
•Identify any potential quality issues per defined process and escalate potential quality issues as needed.
•Ensure that validated deliverables meet functional and design specifications and requirements.
•Defining and implementing the required business transformation rules and logic (ETL development) and perform unit testing at various levels of the ETL.
•Created SSRS reports, modified and managed various reports using tools as SSDT and Tableau.
•Created database objects like tables, views, indexes, triggers and stored procedures based on the specifications as part of the development process.
Ardi Solutions IT Consulting, Springfield, VA April 2014 – December 2016
•Worked with Business Analyst, Data Architect and business users to understand business processes, document project requirements.
•Performed data extraction, transformation, and loading (ETL) between systems using SSIS.
•Utilized multiple sources and destinations, including Excel, Flat File, XML, and OLEDB connections.
•Performed all Agile ceremonies as required
•Function as a liaison between the stakeholders, user community, and internal Software Engineers
•Analyzed business strategy and user needs
•Documented requirements and specifications, and translate business objectives into proper system requirement specifications
•Planned and assisted with testing processes and activities, and assist business users in UAT
•Participated in test procedures to help compare test results against requirements
•Developed or assisted in the development of work plans, time schedules, and project task items for the scrum team
•Provided subject matter expertise and operational support to internal business partners
•Identified risks and issues, and seeks approval on complex matters
•Ensured quality and integrity across application implementations
•Maintained a working knowledge of system interaction to ensure success in overall architectural solution
Consistently exercise independent judgment and discretion in matters of significance
Ethiopian Airlines, Ethiopia, Addis Ababa May 2009 –September 2013
Analyzing the overall performance of the airline, competitors, potential market and building maintaining and monitoring of the daily ETL Process as well as build reports to enable the Manger for better decisions.
•Worked with business users and stakeholders to understand business processes, project requirements document
•Created interactive reports for upper management with functionalities like drilldown reports, drill through reports, parameterized reports, reports with multiple levels of cascading parameters.
•Identified problem areas performed troubleshooting when execution errors occurred and Deployed reports to Report Manager
•Identified problem areas & performed Optimization and Performance Tuning of Stored Procedures, SSIS packages and reports
•Maintained accuracy of a number of spreadsheets and pivot tables daily with new data entry
•Prepared monthly and quarterly reports or dashboards for different process
•Identified trends in data and relay this into information for the business
•Responded to data requests from supervisor, team and the business
•Prepared presentations and communication materials
•Conducted the thorough analysis of data to check for meaningful data.
•Model the data with using different modeling techniques.
•Created different kind of reports with using different Business Intelligence tools like SSRS
•Presented findings with good presentation through meetings, seminars and presentations.
Master’s in Business, Addis Ababa University