SUMMARY

• Skilled in analyzing problem situations and finding creative solutions.
• Able to meet demanding time goals and work well under pressure.
• Experienced in clear and effective business communication with the ability to communicate how business needs translate to system and user requirements. Well organized and thorough in researching information.
• In depth knowledge and experience in all phases of the Software Development Life Cycle (SDLC) including requirements gathering, analysis, design, implementation testing and deployment
• Experience in defining project business need, business process re - engineering, allocating project resources, project scope and prioritization, transition requirements, finalizing and validating project.
• Demonstrated project and program management ability including managing and leading teams.
• Flexible and able to manage simultaneous priorities and changing deadlines.
• Ability to work excellently as an individual or a part of team with no supervision/assistance.

TECHNICAL SKILLS

Methodologies: Waterfall, Agile, SDLC

Business Modeling Tools: MS Visio

Defect Tracking/Bug Reporting: JIRA

Project Management Tools: MS Visio, MS Project, SharePoint, RACI

Business Application: SharePoint, MS Office, Visio, Adobe

Operating System: Windows (2000/2003/XP/7/8/10)

Databases: MySQL, Teradata, MS Access, Oracle

Other: MS Excel, Tableau

PROFESSIONAL EXPERIENCE

Business Systems Consultant 6 /Data Analyst

Confidential

Responsibilities:

• Provided data analysis to support business requirement definitions and document key functions. Translated business requirements into workable technical requirements.
• Acted as a liaison between the functional data team, data stewards, other cross-functional finance and technical data teams to understand business processes and regulatory reporting data requirements (eOne, CCAR).
• Reviewed incoming data streams for missing data or corrupt data, and verified tables/fields for the purpose of mapping reference data attributes to systems of record (SOR).
• Created current state mappings of existing processes to identify areas of improvement or to design new processes.
• Identified data sources and sourcing requirements in order to bridge the gaps between requirements, design and testing.
• Worked to track, monitor and resolve issues as requirements moved through the project pipeline.
• Ran SQL queries to analyze data and identify trends and/or gaps.
• Manipulated data using Excel to create reports for tracking data quality.
• Identified reference data code sets and value-to-value relationships for governance.
• Coordinated release implementation tasks and participated in prioritization sizing for release planning.

Business/Data Analyst

Confidential

Responsibilities:

• Worked with product managers, architects, developers and engineers to ensure that database repository was being designed, engineered and launched within specified regulatory implementation timeframes.
• Reviewed incoming data streams for missing data or corrupt data, and verified tables/fields for the purpose of mapping reference data attributes to systems of record (SOR) for regulatory reporting.
• Documented business requirements and structured information, created architectural system flows, and current state dependencies using Visio.
• Worked with the front and middle office technology teams responsible for providing sources of reference data across the organization, to collect, store, analyze, and distribute static reference data for various financial products.
• Assisted with all areas of the project life cycle including analysis, design, User Acceptance Testing (UAT), as well as providing training and implementation assistance for each release.
• Reviewed and analyzed data quality, business rules, use cases, and BRDs to define data mappings.
• Managed risk issues and participated in the application of the capital markets risk management process.

IT Project Manager/Business Analyst

Confidential, Charlotte, NC

Responsibilities:

• Created, and improved ground up business processes for data quality, controls, regulatory initiatives and governance for various applications that supported federal reporting functions.
• Responsible for leading project teams and managing activities in high visibility.
• Responsible for developing new data management and controls processes; focusing on the full SDLC project lifecycle including scope definition, project planning, design, build, and deployment.
• Created training materials and process documentation for newly created procedures.
• Created project plans and tracked project progress using Visio and Excel.
• Ensured that related fixes and enhancements were tested successfully by key technical teams; and that implementation of these changes in production were within the designated thresholds.
• Conducted research and investigation for remediation and tracking of data defect/enhancement JIRA tickets as well as change management system tickets.
• Ran SQL queries to analyze metadata, identify changes needed for coding, and updates to the business logic
• Worked closely with the enterprise data teams, upstream/downstream application teams and other partners in identifying the end-to-end data lineage and metadata mapping.
• Created and delivered presentations on program or project goals and plans, including progress reports on project status.

IT Business Systems Analyst

Confidential, Charlotte, NC

Responsibilities:

• Gathered complex lineage and enterprise-wide metadata for applications within the Global and Commercial Banking supply chains for critical risk functions. Traced metadata from end-to-end, to/from system of record.
• Used advanced knowledge Excel (pivot tables, macros, advance filters v-look up, model creation, data interpretation) to help the team with accurate and timely data gathering and reporting.
• Reviewed submissions of metadata and lineage from system owners for completeness and reasonableness.
• Drafted current and future state workflows in Visio and worked with LOB's to accomplish their various process objectives.
• Worked to identify and document data controls.
• Acted as a liaison between the lines of and technical teams to identify key business elements, and physical data elements for data analysis and source to target mapping.
• Worked with Data Steward Executives and LOB Architects to define interim and strategic sources of data within the bank for a given product or reference data.
• Translated user needs into business requirements (BRDs) and functional specs (TRDs).
• Documented SLA's, and monitored SLA for timeliness and accuracy with data sharing agreements.
• Developed action plans and SOP (standard operating procedures) documentation for issue governance of defect items that were in breach of SLA's.

Sr. Business Analyst

Confidential

Responsibilities:

• Lead the implementation and management of core credit risk products for Confidential ’s Making Home Affordable (Dodd-Frank, CFPB, MHA, HAMP, HARP) program as directed by the US Treasury.
• Spearheaded process improvement and system implementation projects from start-to-finish to improve customer data quality.
• Created dashboards within Tableau to display mortgage servicer’s loan volume and performance.
• Managed and developed planning process for software releases in each quarter.
• Drove continuous improvement in operational process development for monthly activities including data quality improvements, security improvements, application configuration, and change management.
• Acted as lead liaison between key business stakeholders and the technical teams, building and maintaining a strategic partnership between business and technology.
• Partnered with upstream data providers in order to develop metrics to determine inefficiencies and areas for improvement, and to create remediation plans for existing issues.
• Identified overall risk controls to mitigate organizational risks and establish processes to implement changes.

Quality Control & Risk Analyst

Confidential

Responsibilities:

• Coordinated and led audits of internal processes with various internal and external groups and used audit analytics to launch a tactical risk monitoring plan.
• Gained a strong understanding of the infrastructure concepts in order to implement changes within an ITIL environment.
• Exercised independent judgment in helping to identify and report on compliance and operational defects or violations to lines of business, senior management, internal audit and applicable board committees.
• Partnered with process owners to identify control deficiencies and evaluate controls after identifying top risks and compliance goals.

Business Process Analyst

Confidential

Responsibilities:

• Reviewed existing default loan servicing processes and conducted tests to create new processes that promoted accuracy and efficiency in processing default loans.
• Assisted in developing and implementing strategies in the areas of internal audit, servicer process improvement and compliance.
• Handled escalation cases and addressed issues in a timely manner for resolution.

Quality Control Systems Analyst

Confidential

Responsibilities:

• Responsible for maintaining the highest quality standards by ensuring that all processes were in compliance with GLP, cGMP regulations and ISO standards for documentation.
• Provided technical assistance as needed for development, maintenance and reporting of Key Performance Indicators (KPIs).
• Served as an in-house consultant for quality improvement efforts and as a resource for quality improvement strategies related to strategic planning, daily workflow, and the development of processes and procedures.
• Prepared Quality System reports, including corrective actions and Quality Incidents