PROFESSIONAL SUMMARY

* ***** ** ** ******** Analysis within LexisNexis, Google, JP Morgan Chase and others.

* ***** ** ***, **********, VB Script development within LexisNexis and Google.

TECHNICAL SKILLS

SDLC methodologies such as AGILE, Waterfall, and RUP, Use Cases and Test Cases, JIRA, Version One, SQL in Oracle Dev or MS Access, JavaScript, CSS, VBScript, MS Excel, PowerPoint, Visio, CRMs

PROFESSIONAL EXPERIENCE

WELLS FARGO

Innovations: January 2017 – February 2017

Systems Analyst – contract

Responsible for Documenting the implementation of new services to customer-facing APIs (iOS and Android)

Met with Outside service vendors to assist with determining whether or not their services were adoptable

Provided improvements to the business requirements documentation – i.e. Error handling documentation

JP MORGAN CHASE

Document Management Office: June 2016 – December 2016

IT Business Analyst – contract

Responsible for SQL-based Reporting Requirements gathering for a web-based customer-geared portal

Utilized JIRA for Capital Market focused:

oStory creation – when enhancements are needed for existing processes, i.e. recording t-shirt size

oIssue tracking – when user is not clear on how to carry out a function, and resolving the matter

oBug tracking – when feature is not carrying out expected behavior (QC)

oPhase movements

Data Mapping and ETL based on Taxonomy (SQL enumeration fixes) for databases’ comparison

Reporting via MS Access

STANDARD AND POOR’S GLOBAL

S&P Ratings: September 2015 – Jan 2016

S&P Index Services: March 2015 – August 2015

Sr. Business Analyst – contract

Responsible for Requirements gathering for SharePoint, RADAR, HTML, CSS, and JavaScript

oCapital Market projects: calculations, ETL values (i.e. FX rate), ETL for NZ data towards new NZ index creation

Daily Scrum calls, ensured releases on time, within budget, with open communications, change management

MS Office: Work flow displayed in Visio, burn charts and calculations via Excel

Utilized Version One for story tracking, creation, monitoring, phase movement in line with Sprint Release goals

oPhases: Requirements Gathering, Impact Analysts, Development, QA - ALM, UAT and Production

Met several times a day with Developers as well as Quality Assurance to assist with QC workflow. Met with SMEs for projects focusing on foreign exchange rates, fixed income (bonds, derivatives) and structured finance.

Worked with the UX team for PowerPoint mockups, use cases and wireframes for reviews with business stakeholders and the development team lead, towards intranet portals for customer use with Service Level Agreements (SLAs)

Reporting and dashboards were generated through proprietary software

CITIBANK

August 2014 – March 2015

Business Analyst – contract

Waterfall methodology:

oDocumented Key Business Requirements (KBR)s into Business Requirements Document (BRD) towards online surveys for Citibank employees across all business lines in all geographic regions (i.e. NAM, LATAM, etc.)

oETL: Documented needs with data fields’ references, field placement, and derived field traits.

oCommunicated regularly with Technology group, to understand the most cost efficient approaches to problem solving through readily available solutions, and getting easy agreement to push some limits.

oHeld meetings of varying intervals to Record, Assess, Plan, and examined Build, Test, and Implement phases leading up to Gaining Acceptance and a Close. For meetings with LATAM, I used conversational Spanish.

Met with Capital Markets stakeholders and UX team to build PPT mockups, use cases and wireframes for review.

Utilized SharePoint and MS Access for reporting - retrieving data from internal Citi SharePoint site (i.e. lists for MS Access querying and joining with other tables). Developed solutions with Service Level Agreements (SLAs).

GOOGLE

October 2013 – August 2014

Business Analyst (Agile) / Business Intelligence Developer (SQL) – contract

Coordinated with Business Users and Development for setting up Stories, Use Cases, Test Environment, Test Data and Backend Interfaces.

Asserted Enterprise wide Best Practices in Systems Integration, Business Intelligence, and Data Warehousing.

Worked with the team for BI Data Warehousing Tools and technology teams for testing, development and post production support.

Partnered with Business owner, Project Manager and Program Oversight to communicate business impacts and participate in strategy (mitigation plans). Used SQL in extracting telecommunications data from the database in the system (i.e. iPhone, Blackberry, Android model numbers) for report friendly categories and higher-up output.

Verified and managed changes to the project scope, project schedule and project costs as defined in the change management plan. Timely and periodic review with senior management on project status and process change.

Created system/user documentation and conduct training for end users as required.

Performed off hour’s regression and application testing during web portal data processing updates/implementations. Provide on-call support on an as needed basis.

Enhanced and created SQL queries for standard and custom reports. Converted a 3 day process into a 3 hour one.

Regularly met with stakeholders.

MS Office: Extensive data analysis and SQL work (i.e. ETL) utilizing MS Access (for reporting) and Excel.

LEXISNEXIS

October 2007 (March 2008 converted to full time) to October 2013

Business Analyst (Agile) / Business Intelligence Developer (SQL)

Developed CRM (as a BA) which displayed: number of phone calls a client made to customer service (from one database) to rate by which LexisNexis customer adopted Lexis Advance tools (additional databases), and the invoice details for customers (what billing plans they were on, etc.) – via Intranet token authentication.

Created standard reporting and custom SQL queries, JavaScript code and VBScript code.

Assisted in the business process re-design and documentation as needed for migration from legacy systems. Reviewed process flow and compare and contrast current system capabilities and document any gaps between the current processes and required processes. Implemented solutions per LexisNexis Service Level Agreements for group.

Worked with BI Data Warehousing Tools and technology teams for testing, development and post production support.

Partnered with Business owner, Project Manager and Program Oversight to communicate business impacts and participate in strategy (mitigation plans). Used SQL in extracting data from the database in the system.

Coordinated with Business Users and Development: Test Environment, Test Data, QC and Backend Interfaces.

Verified and managed changes to the project scope, project schedule and project costs as defined in the change management plan. Timely and periodic review with senior management on project status and process change.

Troubleshooting and support of solutions on an ongoing basis, ensuring effective problem resolution. Created system/user documentation and conduct training for end users as required.

Performed off hour’s regression and application testing during application implementations (i.e. Mobile Web App, Website, Oracle Publisher customer-facing dashboards and reporting). Provide on-call support on an as needed basis.

Developed SharePoint site for Chicago office, to inform staff of office transitions.

Regularly met with stakeholders.

Worked with the UX team to put together PPT mockups, use cases and wireframes for review by business stakeholders.

EDUCATION

SCRUM Master Certification (in progress)

Courses currently covered:

Agile Overview

Agile Manifesto

Scrum Overview

Roles in Scrum

VILLANOVA UNIVERSITY

Essentials of Project Management Certification

CUNY Queens College

Master of Arts in Computer Science (partial)

Clark University and CUNY Queens College

Bachelor of Arts in Sociology

MICROSOFT

Certification in Microsoft Access

IBM

Global Support Delivery Agent

Contact this candidate