Business Analyst/Data Analyst/Developer

864-***-**** ● ************@*****.***

PROFESSIONAL SUMMARY

Seasoned professional with the ability to analyze a full range of business concerns, needs, and requirements to identify and recommended processes, products, and solutions to meet goals and objectives. Lead system and process reengineering projects to capture improved efficiencies, fail-safe business continuity and produce cost savings. Able to conduct in-depth data mining, visualization and analysis to uncover and rectify process weaknesses and vulnerabilities, mitigate risk and resolve business and IT deficiencies. In-depth understanding and hands-on experience with all aspects of Software Development Life Cycle.

EDUCATION

Bachelor of Science, Management Information Systems, Park College, Parkville, MO

Graduate, United States Marine Corps Computer Sciences School, Quantico, VA

SOFTWARE SKILLS

Microsoft Office, Adobe Photoshop, Microsoft Project, Visio, DataGate, Remedy, Informatica, MQSeries, Crystal Reports, Teradata, Microsoft SQL Server, Microsoft SSIS, Microsoft Azure Cloud, Triton, OCP

PROFESSIONAL EXPERIENCE

2017 to Present Bank of America, Sr Business Analyst/Data Analyst/Developer

Analyzed the requirements, designed solutions, built and tested SQL code for regulatory testing of business process and procedures

Performed data analysis tasks that included data mapping, business process analysis, compliance analysis and source system documentation maintenance

Wrote SQL queries in the discovery and analysis of data issues used in producing sample data sets

Developed SSIS packages to retrieve, cleanse and join data to meet compliance testing requirements

2016 - 2017 TEKSystems – Business Analyst/Consultant

Coordinated and conducted application interviews to gather current state and technologies utilized by the applications under review

Documented findings in DB that would be used in analysis of applications migration eligibility to the Azure Cloud

Worked with LOB to understand their applications and communicate these details to the developers

2004 – 2016 Bank of America, Sr. Business Analyst/Data Analyst

Mortgage Servicing

Collaborated with LOB (Line of Business) partners to maintain business logic and enhancements used in the reporting of the LAS (Legacy Asset Servicing) mortgage portfolio

Wrote SQL queries in the discovery and analysis of data issues used in producing mortgage portfolio reports

Analyzed requirements, designed solutions, built and tested SQL code changes within the application, and deployed to production

Conducted data validations to support the application production processes including: data analysis, issue research and resolution to confirm high data quality and compliance with enterprise data standards.

Performed data analysis tasks that included data mapping, data lineage assessments, business process analysis, compliance analysis and metadata documentation

W-Data Warehouse supporting AML (Anti Money Laundering)

Conducted analysis of issues that were discovered in application data which involved analysis of business and computer processes from multiple data sources and data transformations

Gathered and documented requirements for the High Level and Low Level design documentation for system enhancements and changes

Produced system flow charts, data diagrams, entity relationship diagrams and Metadata documentation and kept them updated as changes occurred during projects and in production

Assisted in the development of the Privacy Engine Application that is used to determine what data the employee can see for a customer based on the customer's sharing preference and laws

2000 – 2003 First Union/Wachovia, Sr. Business Analyst/Project Lead

Worked with management to establish project scope

Coordinated the Corporate Real Estate project team and business users to determine solution alternatives and choose best approach. Conducted business analysis and identified business objectives and requirements

Analyzed business processes of proposed or completed acquisitions. Provided migration processes of acquired businesses to various applications/processes.

Developed Datamart utilizing Informatica PowerCenter that was used in the extraction, transformation, and loading (ETL) of data. Contained data from all platforms to include Mainframe and Unix sources

1993 - 2000 Consultant, Business Analyst

1987 - 1993 United States Marine Corps, Computer Specialist

1981 - 1987 United States Marine Corps, Non-Commissioned Officer

Served in a variety of jobs not directly related to information systems management. Served as an Embassy Marine Guard with the Department of State in Cairo Egypt, Tokyo Japan and Brasilia Brazil

Contact this candidate