PROFESSIONAL PROFILE:

• Experienced IT professional with a strong technical and data analytics background. QA and Business Analyst Management Experience

SKILLS & TECHNOLOGY:

• Effective Communication & Presentation skills
• Relationship Management
• IT Project Management
• Stakeholder Management Systems Analysis & Application Design
• Data Warehouse & Data Mart Implementations
• SQL Query Tools Navigator/SQL Developer
• SQL Queries & some Data Modeling
• Relational Databases
• Oracle, SQL Server
• Teradata SQL Assistant
• ETL tools - Ab Initio
• DST, TS2 - Bank mainframe systems
• MS Office Suite
• Business Objects
• HP Quality Center (ALM)
• Genesys call center technology
• Microsoft TFS

PROFESSIONAL EXPERIENCE:

Confidential

IT Consultant

Responsibilities:

• Write/Execute SQL scripts to support data migration test efforts for an acquired portfolio
• Perform database analysis using Teradata SQL assistant or Oracle SQL developer to research data issues
• Understand data lineage and data transformation/mapping rules in order to resolve data issues
• Research data issues with system of record contacts both internal and external
• Solve data problems and proactively identify emerging issues
• Document/discuss known data issues with downstream users of the system

Confidential

Business Analyst & Test Manager

• Managed onshore/offshore business analysts & testers, mostly contractors,
• Reviewed test plan/test strategy documents for quality and also to make sure automation tools such as WinRunner or LoadRunner could be leveraged
• Reviewed business analysis deliverables and facilitated stakeholder participation during analysis
• Participated actively to help gather requirements on high profile projects by interviewing senior level stakeholders such as senior directors and partners
• Resources on my team supported a wide variety of development efforts including including Web applications, data Marts, reporting solutions as well as infrastructure projects such as Server upgrades and security stack installations
• Assisted my team in performing data analysis using SQL on key initiatives to assist with design considerations
• Active participation in defect meetings during systems testing and UAT to make sure defect SLA’s werebeing met and no urgent or high defects were unresolved prior to UAT
• Created Engagement Proposals to get bids from vendors for development work
• Reviewed statements of work submitted by the vendors to make sure estimates were reasonable
• Created RFP (Request for Proposal) questionnaires to facilitate build vs buy analysis

Confidential

Business Systems Analyst Lead

• Lead analyst for the Global Receivables Data Warehouse, working on data integration projects and on a new payment platform to collect payments on behalf of government agencies
• Worked with different data feed providers such as banks or other payment solution providers to standardize payment data coming into the analytical solution
• Created and reviewed requirements with vendors, senior stakeholders and the technical team
• Created project plans, data mapping and functional specifications documents for project work.
• Coordinated ETL/business intelligence development and systems testing with onshore/offshore teams, reviewing test plans/cases and developer code to make sure they aligned with requirements.
• Used SQL queries to find trends in data as well as data profiling tools such as Abinitio data profiler
• Assisted in the development of logical and physical data models to support business intelligence/Data Warehouse requirements.
• Also assigned as the lead analyst for the metadata management project, which utilized Ab Initio metadata management modules and Business Objects to standardize data internally across different business units.
• Supported Anti Money Laundering projects as needed by providing data extracts to the AML team .

Confidential, Wilmington, DE

Business Systems Analyst Lead

• Lead analyst supporting one of the largest Oracle data warehouses in the financial industry with approximately 62 terabytes of data and 40 million transactions daily
• Worked on a lot of projects that involved receiving files or sending file extracts as well as projects that involved migrating data from acquired firms and building data marts/business intelligence reports.
• Lead data warehouse analyst on complex initiatives such as data migration of Washington Mutual Bank data warehouse data to Chase after the acquisition.
• Analyzed data from a wide variety of source systems using SQL queries or Abinitio data profiler;
• Met with business users to understand data and define requirements, created source to target mappings with detailed transformation logic and metadata
• Coordinated JAD sessions with onshore/offshore developers, business users, data architects and the testing team to discuss requirements and design solutions
• Wrote detailed functional design specifications and reviewed code/test plans to make sure there were aligned with business requirements
• Worked with data architects to define logical and physical dimensional data models
• Coordinated User Acceptance Testing with business stakeholders and triaged defects
• Directed the work of other team members as they worked on project deliverables including business requirements, functional & technical specifications, source to target mapping documents & test plans
• Managed the work order request and scheduling process for the entire card data warehouse group.
• Created project estimates, including identification of additional resources needed, for assigned projects

Confidential, Owings Mills, MD

Business Intelligence Analyst

• Lead the requirements analysis & design effort for a new 4Terabyte mutual fund data warehouse repository
• Worked closely with business users to define requirements
• Lead data mapping sessions and created source to target documentation, standardizing metadata across different data sources
• Performed data analysis using Abinitio data profiler and running SQL in an Oracle database.
• Working closely with data modeler to develop logical and physical data models as per requirements
• Working with Business Objects developer to design business objects universes
• Coordinated User Acceptance Testing with business users and lead weekly issues meetings to set priorities and deadlines for fixes.
• Created user manual for Business Objects Universe and conducted training to users

Confidential, Owings Mills, MD

QA Analyst

• Tested a brand-new investment management portal used by call center investment representatives
• Coordinated defect tracking/issue resolution and provided weekly status reports on the project
• Worked with developers to come up with programming solutions for defects & wrote an application support guide for the application
• Functioned also as a Voice Response Unit analyst by collecting business requirements and writing functional design specifications for changes to the Genesys call center application
• Performed systems testing and coordinated UAT for call routing changes and the addition of new virtual queues and skill sets.
• Created functional specifications for the existing call center application since none existed. Analyzed the existing code in order to decipher and document current state functionality

Confidential, Laurel, MD

Sr. Business Analyst

• Interviewed business users and documented requirements for the deposit and telephone banking system
• Developed functional specifications document for VRU enhancement projects
• Coordinated and performed User Acceptance Testing with business stakeholders for all changes made to the Interactive Voice Response systems
• Assisted Jr. Analysts on their projects, working with them to identifying functional solutions.
• Researched and resolved production defects

Confidential, Riverdale, MD

Loan Systems Support Analyst

• Gathered requirements for loan system upgrades performed by outside vendor
• Performed User acceptance testing for system enhancements.
• Supported the operational loan systems group by identifying and researching existing system issues and working in conjunction with programming staff to resolve system problems.
• Subject Matter Expert for deposits & consumer loans.
• Provided training to users of the loan system
• Developed reports for Senior Management on defaulted loans..etc using business objects 5i.

Confidential, Owings Mills, MD

Investment Representative

• Receiving inbound calls from shareholders and servicing shareholder accounts. Performing mutual fund trades, product guidance, asset allocation & balance inquiries
• Discussing fund performance, history, yield, price and market conditions with shareholder
• Tax Liaison - Trained to answer complex 1099, 5498, Corporate and IRA tax form questions.
• Assisting with UAT systems testing on mutual fund trading applications