State Street CorporationBusiness Systems Analyst/Project Coordinator
Apr. 2013 - Mar. 2014Irvine• Worked with fixed income and Mortgage Lending teams to define life cycle, research, development, and initial implementation of pricing and credit rating models
• Analyzed data feeds from Bloomberg and S&P using MySQL and utilized Bloomberg terminals to ensure correct asset classification and pricing augmented with PL/SQL procedures.
• Provided 24/7-production support for STP (Straight Through Processing) of Trade Data to the back office for client PIMCO.
• Assessed business specifications and reporting audience to create vetted mapping specifications for migrating data from legacy source systems to production data mart by leveraging the ETL best practices
• Collaborated with senior management, functional managers, and project managers to plan business and technology initiatives with budget. Use formal and informal networks to present program objectives. Identify and resolve project issues and manage project risks.
• Provided quality control over change requests to ensure proper planning, assessment and quality of data.
• Developed Use Case diagrams, business flow diagrams, Activity diagrams and Process Flow diagrams using EA so that developers and other stakeholders can understand the business process
• Owned and maintained the requirement traceability matrix to ensure end-to-end linkage of the legacy product’s lifecycle management and traction of the implementation stages.
• Assisted in creating and reviewing test plan & test cases, designed the regression scripts and conducted User Acceptance Testing (UAT)