IT Systems Analyst

• Major: Financial Engineering

Financial Engineering and Operations Research

Work as a Business Analyst to liaise between business, technology and support teams domestically and internationally. Collect, manipulate and analyze data and create reports and visualizations to address critical business problems.
• Initiate and oversee company-wide implementation of mobile solutions for company procure-to-pay processes
• Organize efforts and develop IT solutions that meet requested specifications
• Work closely with the executive team on data science initiatives to build dashboards that gives them insight into marketplace dynamics and other long-term trends
• Write SQL procedures, create data models, design ETL processes and develop visualizations to present appropriate information to the end-user
• Create applications, forms and reports using Oracle development platform to meet the day-to-day needs of the business
• Manage the end-to-end lifecycle of company ERP Implementation projects for several modules (Example: Oracle Internet Expenses, Oracle Internet Suppliers, etc.)
• Mentor and coach junior business analysts

Worked as a Senior Consultant to help clients solve their strategic problems in different areas of business to increase profits and sales, and take advantage of process efficiency opportunities as well as running their current business.
• Improved existing processes to effectively and efficiently communicate data to the client through various specialized reports and media.
• Created and produced high quality data to support ad-hoc customer requests on schedule and within budget for General Motors' Network and Site planning.
• Extracted, manipulated, and analyzed data from various sources such as dealership sales and financials, vehicle registrations, demographics, etc. heavily using Microsoft SQL Server and Excel.
• Updated and maintained work instructions/documentation for company processes

Worked as a business analyst on facilitating the migration of a massive, multi-release legacy application for an enterprise payments / file gateway with a large team of IT and business staff.
• Facilitated requirements gathering sessions and establish good working relationships with all project stakeholders.
• Created and maintained complex project documentation such as requirements specifications, requirements management plans, and user guides and obtain sign-off.
• Interviewed subject matter experts to articulate the solution scope, technical and business requirements, and process models for migration of legacy applications to a new web-based platform.
• Documented test level assessment, test plan, test cases and traceability matrices and led the solution validation and assessment aspects by delegation and providing direction and support to testing team.
• Reviewed test cases prepared by external consultants, provided review comments, coordinated and supported the extended end to end testing activities for the bank’s EDI system migration.
• Acted as the project lead and facilitate dialog with managers, developers and IT staff on project and report requirements, priorities, business and testing needs for large projects involving several groups across the bank.
• Defined project deliverables, and timelines for several application migration and infrastructure system upgrades projects.
• Conducted project team meetings, share meeting minutes and follow up on action items.
• Trained team members in using new requirement and test management software.
• Developed volunteering plans that improved team spirit and strengthened intra-office communication.

CBAP Certificate

Oracle PL/SQL

Database querying

–

–

–