Profiles search
Juan Vivas
VP Information Security Engineer at Bank of America
Rock Hill, SC, United States
Details
Education:
Certification
Lean Sigma Green Belt
MoreSteam University
2013 : 2013
Bachelor
Science
Universidad de Venezuela
1996 : 2001
Lean Sigma Green Belt
MoreSteam University
2013 : 2013
Bachelor
Science
Universidad de Venezuela
1996 : 2001
Experience:
•Contribute to and generate metrics and analytics used to help quantify risks and the changing key control coverage and maturity over time.
•Ensure that the metrics and underlying data to mitigate risk contain sufficient detail to provide actionable intelligence to our risk partners and to those directly involved in risk remediation efforts.
•To conduct deep exploratory analysis through the use of MS Sequel Visual Studio querying to explain anomalies that arise in the metrics such as key controls not operating correctly, or actions taken against the environment like taking down a mainframe or migrating SAM accounts into CSDB, etc.
•Perform UAT testing on controls or applications that are shown to be defective, through scripts writing, test cases, user selection, and testing implementation under the waterfall methodology.
•Identify other risks exposed as a result of the Quality Team’s detailed analytic efforts which go beyond scorecard production by utilizing MS Access and Excel to present these to senior management as actionable data.
•Provide assistance to other departments and functions through the review and customization of SQL queries in order to obtain requested data more efficiently.
2015 : Present
Bank of America
Information Security Engineer
• Working closely with the IT departments as well as management to ensure proper and promptly patching of one thousand plus corporate servers.
• Follow up on daily bases with all stakeholders involved to ensure task completion and status updating of senior management.
• Managing all current data reporting efforts on the team through heavy use of MS Excel, data gathering, mining, analysis and conclusions.
• Facilitating Meetings between senior management and senior planners to ensure understanding and commitments are agreed upon.
• Ensuring guidelines and SLA’s are met ahead of spec deadline, acting as liaison between IT and Senior Maintenance planers.
2014 : 2015
Wells Fargo
Information Technology Project Manager
BANK OF AMERICA, Charlotte, NC May 2014 – Current
Technology Business Analyst
· Generate and delivery of Ad Hoc and standard reporting via SQL, MS Access and MS Excel.
· Decoding, formatting and uploading of large amounts of data into SBO2000 for default and accounting departments.
· Coordinated and contributed to the ongoing monitoring and correction of data mapping in system.
· Assist in developing and implementing UAT testing project activities and coordinate these with the different stakeholders.
· Provide assistance to other departments and functions through the review and customization of SQL queries in order to obtain requested data more efficiently.
· Responsible for the regular maintenance and updating of lines of business through the use of MS SharePoint.
· Review system codes and queries and ensure logic is functioning according to requirements.
2014 : 2014
Bank of America
Technology Consultant
• Analyzed and consolidated large amounts of data through the use of MS SQL as well MS Excel VBA Macro and tailored formulas.
• Managed data gathering platform wide utilizing MS Excel to elaborate and generate quality Pareto charts to be utilized on subsequent root cause analysis.
• Directed several green belt improvement projects that successfully decreased DPU from 3.7 to 0.9 within 30 days of implementation.
• Coordinated efforts and improvements by communicating with all level stakeholders.
• Worked closely on the reporting analytic aspect by extracting needed information for the leadership to determine business requirements (BRD).
• Designed and improved upon business process utilizing MS Visio to facilitate visual life cycle as well as areas of opportunity.
• Designed and implemented user forms for team members utilizing MS Access
2011 : 2014
Accenture
Operational Excellence Senior Analyst
• Managed a pipeline of 110 files.
• Provided customer service and a 90% customer satisfaction rate.
• Exceeded sales goals each month in position
2010 : 2011
Wells Fargo
Loan Document Specialist III
•Ensure that the metrics and underlying data to mitigate risk contain sufficient detail to provide actionable intelligence to our risk partners and to those directly involved in risk remediation efforts.
•To conduct deep exploratory analysis through the use of MS Sequel Visual Studio querying to explain anomalies that arise in the metrics such as key controls not operating correctly, or actions taken against the environment like taking down a mainframe or migrating SAM accounts into CSDB, etc.
•Perform UAT testing on controls or applications that are shown to be defective, through scripts writing, test cases, user selection, and testing implementation under the waterfall methodology.
•Identify other risks exposed as a result of the Quality Team’s detailed analytic efforts which go beyond scorecard production by utilizing MS Access and Excel to present these to senior management as actionable data.
•Provide assistance to other departments and functions through the review and customization of SQL queries in order to obtain requested data more efficiently.
2015 : Present
Bank of America
Information Security Engineer
• Working closely with the IT departments as well as management to ensure proper and promptly patching of one thousand plus corporate servers.
• Follow up on daily bases with all stakeholders involved to ensure task completion and status updating of senior management.
• Managing all current data reporting efforts on the team through heavy use of MS Excel, data gathering, mining, analysis and conclusions.
• Facilitating Meetings between senior management and senior planners to ensure understanding and commitments are agreed upon.
• Ensuring guidelines and SLA’s are met ahead of spec deadline, acting as liaison between IT and Senior Maintenance planers.
2014 : 2015
Wells Fargo
Information Technology Project Manager
BANK OF AMERICA, Charlotte, NC May 2014 – Current
Technology Business Analyst
· Generate and delivery of Ad Hoc and standard reporting via SQL, MS Access and MS Excel.
· Decoding, formatting and uploading of large amounts of data into SBO2000 for default and accounting departments.
· Coordinated and contributed to the ongoing monitoring and correction of data mapping in system.
· Assist in developing and implementing UAT testing project activities and coordinate these with the different stakeholders.
· Provide assistance to other departments and functions through the review and customization of SQL queries in order to obtain requested data more efficiently.
· Responsible for the regular maintenance and updating of lines of business through the use of MS SharePoint.
· Review system codes and queries and ensure logic is functioning according to requirements.
2014 : 2014
Bank of America
Technology Consultant
• Analyzed and consolidated large amounts of data through the use of MS SQL as well MS Excel VBA Macro and tailored formulas.
• Managed data gathering platform wide utilizing MS Excel to elaborate and generate quality Pareto charts to be utilized on subsequent root cause analysis.
• Directed several green belt improvement projects that successfully decreased DPU from 3.7 to 0.9 within 30 days of implementation.
• Coordinated efforts and improvements by communicating with all level stakeholders.
• Worked closely on the reporting analytic aspect by extracting needed information for the leadership to determine business requirements (BRD).
• Designed and improved upon business process utilizing MS Visio to facilitate visual life cycle as well as areas of opportunity.
• Designed and implemented user forms for team members utilizing MS Access
2011 : 2014
Accenture
Operational Excellence Senior Analyst
• Managed a pipeline of 110 files.
• Provided customer service and a 90% customer satisfaction rate.
• Exceeded sales goals each month in position
2010 : 2011
Wells Fargo
Loan Document Specialist III
Company:
Bank of America
Years of Experience:
17
Spoken Language:
Spanish
Skills
Banking, Business Analysis, Business Process, Credit, Customer Experience, Customer Satisfaction, Customer Service, FHA, Finance, Internal Audit, Leadership, Loans, Management, Mortgage Banking, Mortgage Lending, Operational Excellence, Process Improvement, Risk Management, Six Sigma, Software Documentation, Spanish, Underwriting, VA loans
About
Education
- Bachelor in Science (Venezuela)
- Six Sigma Green Belt. (Moresteam University, 2013)
- 5 Qualities of a Genuine Leader (CPCC Campus, 2012)
- Giving Recognition (CPCC Campus, 2012)
- Developing Others (CPCC Campus, 2012)
Profile Photo
