Sofia Ali
Business Analyst/Product Owner
Hillsboro,OR
Summary
Sofia is an IT Professional with over (20) years of experience in business analysis, application support, and customer support. Strong analytical, technical and communication skills to produce high quality business results. Great aptitude to work under pressure to meet both time and budgetary constraints. Most recent work experience was in the mortgage servicing and compliance industry, prior to that was in the data center for bank operations, legal/regulatory class action lawsuits, educational sector and multiple years in utilities industry. High energy, multi-tasker accountable for coordinating competing deliverables. Advanced PC program skills with heavy experience using Excel, SQL queries, data warehouse products, and other similar systems. Strong verbal and written communication skills for a variety of audiences (both technical and non-technical). Advanced a high level of analytical ability to understand sophisticated programs/systems for resolving business problems and respond promptly to customer needs.
Overview
25
25
years of professional experience
Work History
Business Systems Analyst
Epiq Systems
Beaverton, OR
01.2017 - Current
- Understood the entire lifecycle of a class action or similar matter, determined what data is required based on functional requirements, and defined how that data and business rules will translate to internal applications.
- Developed and published technical specifications, requirements, and other documentation, as required.
- Designed data mappings and transformations which was used to drive ETL procedures.
- Worked with QC Analysts to design testing strategies and plans to ensure all outcomes are as expected.
- Used tools such as Excel, Access, SQL Server, and others, directly query, assess, and analyze data to ensure requirements are being met.
- Served as liaison between Client Services (business) and Data Analysts (technical) teams to keep production work flowing smoothly.
- Worked with Technical Project Managers to ensure all required steps and actions were captured in project plans, and aligned with project timelines.
Business Analyst/IT Product Owner
Aspen Capital
Tigard, OR
12.2018 - 02.2023
- Collaborated with stakeholders to identify business needs and data sources, conducted interviews to collect information on business processes and user requirements and performed gap analysis to identify areas of improvement for our Mortgaging and Foreclosure Management systems.
- Interacted with internal users to understand business needs as it pertained to the mortgage servicing and compliance areas and translate into requirements and project scope.
- Improved business direction by prioritizing customers and implemented changes based on collected feedback. Consistently generated positive working relationships both internally and with third-party partners.
- Designed data mappings and transformations which were used to drive ETL procedures.
- Worked with QA Engineers to clarify testing strategies and plans to ensure all outcomes were as expected
- Utilized SQL scripts and queries to extract and analyze data from multiple sources.
- Enhanced project management skills and worked in a fast paced agile development environment. Planned and coordinated release management on a monthly cadence
- Elicited and clearly documented business and system requirements using Atlassian Products - JIRA and Confluence.
Business Systems Analyst
Umpqua Bank
Hillsboro, OR
01.2018 - 09.2018
- Prepared and published meeting agendas/topics, provided any pre-reading or participant preparatory materials, led requirements discussions and documented Business or Technical Use Cases (Stories),
- Determined system specifications, record layouts and developed procedures to process information.
- Worked on problems of diverse scope where analysis of data required evaluation of identifiable factors.
- Maintained a working knowledge of Bank's written policies and procedures regarding Bank Secrecy Act, Regulation CC, Regulation E, Bank Security and other regulations as applicable to this job description.
- Demonstrated compliance with all bank regulations for assigned job function and apply to designated job responsibilities.
Systems Support Specialist
Beaverton School District
Beaverton, OR
02.2015 - 11.2016
- Served as a coordinating function between the technical operations of the IT Department and District users
- Provided advanced systems support, taking ownership as needed, to troubleshoot and resolve issues pertaining to the District’s Student Information Systems – Synergy
- Supported the development team during implementation of new systems and projects; assured customization of vendor training materials to District users/needs; perform testing
- Provided training for users in individual and group settings including preparing written training materials, monitoring training effectiveness and responding to additional needs
- Trained users on Synergy, SharePoint 2013, and SchoolMessenger and Data warehouse tool – BaselineEdge
- Coordinated with management and other technical teams to ensure issues affecting enterprise systems were communicated to users in a timely and accurate manner
- Maintained integrity of confidential information relating to students, staff, or district patron
- Ability to effectively work and communicate with school personnel from diverse cultures and backgrounds.
Database Programmer/Analyst
Corpus Christi Independent School District
Corpus Christi, TX
10.2013 - 01.2015
- Collaborated with Student Information System teams (eSchoolPlus 3.0) and helped with upgrades and data integration with other third party tools
- Provided appropriate technical support to the Business Information System (BusinessPlus 7.9
- 8)
- Analyzed, translated and converted previously written C# programs into new SSIS packages in SQL 2014
- Planned, organized and prioritized assigned tasks efficiently in stressful situations and to meet deadlines
- Provided appropriate technical documentation and communicated effectively in oral and written form
- Developed well performing database stored procedures, views and queries for the district data warehouse and various application databases
- Developed and maintained ETL scripts consistent with defined specifications
- Created/modified SQL Server Integration Services (SSIS) packages for data ETL purposes
- Supported databases, business logic and reports and providing end-user support
- Worked as part of a project team to coordinate database development and determined project scope and limitations
- Managed relationships with customers and partners and driving quickest resolutions to their issues; participated in triage meetings to share knowledge with other groups to resolve customer solutions efficiently
- Acted as a support resource for broad issues
- Utilized skills in Visual Studio, C#, MS Office Suite, Visio, Business Intelligence tool – Cognos, SQL Server Integration Services, SQL Server 2014, SQL Server Reporting Services, Team Foundation Server (source code management) and SharePoint.
IT Systems Analyst
GDF Suez Energy North America
Houston, TX
12.2009 - 07.2011
- Provided IT production support for the business applications used by the Trading (Sungard Zainet), Mid- Office Risk Management (Sungard Risk Analytics), and Back Office Accounting departments
- Created and supported web reports using Visual Studio and MS SQL Server Reporting Services (SSRS)
- Ran T-SQL and Oracle query updates against the database
- Worked directly with system users to manage the technology requirements in each of the business functional departments
- Evaluated functional requirements for system enhancement projects
- Followed the IT System Development Life Cycle standards to design, develop and implement technical solutions
- Participated in system testing and developed test plans
- Excellent client facing skills including strong written and oral communication skills.
Customer Service Center- Application Specialist
Shell Oil Products US, SOPUS
Houston, TX
08.2008 - 12.2009
- Assisted in the analysis, clarification and communication of the non- functional requirements of system users, arising from investigations into requirements and problems, and identify available options for consideration
- Specifically worked on CRM application Siebel 7.0 for daily support and Siebel 7.8 during an upgrade project
- As a liaison between application users and development team, gathered business needs and suggestions to translate into business requirements and create effective technical solutions
- Supported the deliverables of the technical consultants by providing business and functional guidance, reviewed, tested, and validated scripted solutions (reports, scripts, and interfaces)
- Successfully delivered 2 major projects for the US Fuels Call Center
- Competent at aligning Shell's business and IT processes together and properly followed incident, change and problem management process as it applied to our group.
Business Analyst
Microsoft Corporation
Redmond, WA
10.2005 - 08.2008
- Service Management Division (MSIT)
- Application lead for critical CRM tools such as Siebel, PSM( Partner Sales Management) and DET ( Data Enrichment Tool) which connected the Microsoft field and their partners to facilitate business collaboration and build profitable relationships
- Worked with cross- functional teams (Development, Test, Analysis, etc.) to deploy and maintain CRM systems, reviewed and signed off on functional and technical specs and test plans throughout the SDLC process
- Wrote technical articles for knowledge base
- Represented the user support team to engage in the project readiness prior to the user acceptance testing
- Maintained high international visibility and regular interactions with counterparts from across the globe
- Certified in ITIL Foundation.
IT Business Consultant II
Duke Energy Corporation
Houston, TX
11.2001 - 06.2005
- Provided technical support for internal business tools and Microsoft SQL Server based applications deployed at Duke
- Some of the applications supported were the Credit Risk Management System, SQL Financials, SAP, and ICMS Treasury Application, eNable, Middleware batch processing tools, Business Objects 5.1 and Engage- Financial applications
- Coordinated with multiple technical and business teams to administer and manage production applications and processes, troubleshoot applications or process failures, generate customer data for internal customers or audit requests using SQL query and work with development teams/ vendors
- Developed and implemented standard performance testing processes and procedures as part of system and regression testing for Quality Assurance.
IT Consultant
Deloitte & Touche - Enterprise Risk Services
Houston, TX
01.2000 - 09.2000
- Identified information technology risk and control assessment for multiple clients in utilities, energy and healthcare industries
- Assisted with conducting, documenting and communicating the findings of activities related to internal audit services and submitted recommendations relevant in IT/Accounting practices
- Assessed departmental/business cycle risk and control assessments for various clients
- Performed General Computer Controls on various IT environments
- Helped client identify data issues with implementation of new ERP (SAP) package
- Served as a valuable resource during SAP control documentation phases and defined the segregation of duties and user profiles.
Cost Accountant
Occidental Chemical Corporation
Houston, TX
08.1998 - 12.1999
- Maintained an ongoing evaluation of the accuracy and reliability of the accounting data, effectiveness of accounting procedures and controls
- Provided accurate and timely reporting of sales and inventory information, reviewing pricing accruals, monitored/reconciled terminal and warehouse inventory using SAP (FI/CO, SD, MM modules)
- Analyzed and maintained control of balance sheet accounts through account reconciliations
- Supported business and manufacturing locations with analysis, as required.
Education
M.S - Management Information Systems
University of Houston-Clear
2000
B.S - Accounting
University of Houston-Clear
1998
Work Availability
monday
tuesday
wednesday
thursday
friday
saturday
sunday
morning
afternoon
evening
swipe to browse
Skills
- Research and analysis
- Production support
- Documentation abilities
- Technologically-savvy
- Requirements gathering
- Technical Analysis
- Interpersonal Communication
- Active Listening
- Dependable and Responsible
- Self-Motivated
Timeline
Business Analyst/IT Product Owner
Aspen Capital
12.2018 - 02.2023
Business Systems Analyst
Umpqua Bank
01.2018 - 09.2018
Business Systems Analyst
Epiq Systems
01.2017 - Current
Systems Support Specialist
Beaverton School District
02.2015 - 11.2016
Database Programmer/Analyst
Corpus Christi Independent School District
10.2013 - 01.2015
IT Systems Analyst
GDF Suez Energy North America
12.2009 - 07.2011
Customer Service Center- Application Specialist
Shell Oil Products US, SOPUS
08.2008 - 12.2009
Business Analyst
Microsoft Corporation
10.2005 - 08.2008
IT Business Consultant II
Duke Energy Corporation
11.2001 - 06.2005
IT Consultant
Deloitte & Touche - Enterprise Risk Services
01.2000 - 09.2000
Cost Accountant
Occidental Chemical Corporation
08.1998 - 12.1999
M.S - Management Information Systems
University of Houston-Clear
B.S - Accounting
University of Houston-Clear
Similar Profiles
Mackenzie LeeMackenzie Lee
Service Specialist at Epiq SystemsService Specialist at Epiq Systems
DARANIQUE K. MILLERDARANIQUE K. MILLER
Service Specialist at Epiq SystemsService Specialist at Epiq Systems
Jory SwenderJory Swender
Data Analyst at EPIQ SYSTEMSData Analyst at EPIQ SYSTEMS
Miguel VelezMiguel Velez
Receptionist (Administrative Assistant) at Epiq SystemsReceptionist (Administrative Assistant) at Epiq Systems
Dean ArmstrongDean Armstrong
Volunteer Clerical Assistant at PariyattiVolunteer Clerical Assistant at Pariyatti