Summary

• Extensive knowledge in building close professional relationships with clients based on trust, understanding and carrying out solutions of all involved.
• Proven ability to work independently or with multi-disciplinary team; proficient in supervising others in a varied work-environment.
• 15 years of diversifiedIT and financial services, management, IT Security/ Risk Management and IT Audit experience with excellent leadership skills.

Applications:OpenLinkEndur, Nucleus, SAP

SAP R/3 and My SAP:

PA- Personnel Management, Organizational Management, Time Management, and Payroll
PD- Personnel Data Management

Software:

Active Directory, MS Project 2007, MS Office Suite 2007, Visio 2007,
Access 2007, Client Assist, Visual Banker Platform, Peregrine Ticketing
System, PeopleSoft, Mercury, 3270 Backup, AS/400, Knowledge Base
(Learning Management) Business Objects

Frame Works:

PMI PMBOK, ITIL,COBIT, Six Sigma, Togaf

Operating Systems:

Linux, Windows, Unix, MS Exchange

Databases:

SQL Server 2005/2008, SQL Server Reporting Services, SQL Server
Analysis Services

Strategized project scope to maximize efficiency in regards to removal of access to end-users.

• Administered audit findings/removal of any permission access into an organized database in line with the risk’s group protocol.
• Provided roles to the “team risk” with read/write access in folders considered as “risk-only” to eliminate any potential access by individuals that may modify any data.

Communicated business requirements, project objectives, and time and motion calculation to effectively deliver the application on specified project timeframe.
Involved in configuration, management, testing, systems programming, system administration, post-implementation support, and policy enforcement of EndurOpenlinkv5.0 to v9.0

• Demonstrated leadership, teamwork, collaboration, negotiation, and influence skills with team members in addressing challenges.

Configured global settings, including security roles; managed relational databases, system design, customizations and hot fixes.

• Provided QA management and support; ensured stability and data integrity of all production and stage environments.
• Established new processes to drive efficiencies that resulted in cost avoidance/savings.

Gathered implementation requirements, business process on agreed solution for gaps, testing, documented training manuals, support and maintenance, but not limited to the go live process.
Involved in SAP HR implementations and upgrade project using ECC 6.0.

• Understood configuration process that interfaced with payroll, time benefits, OM, and PM.
• Configured global HR modules in the United States and Canada.
• Interfaced, supported, and transferred knowledge to the internal teams.
• Gained the ability to analyze current and upgraded systems for feasibility and profitability.

Brachfeld Associates:

IT Business Analyst
November 2010 – Current

• Provided Business Intelligence analysis tools and reporting services.
• Database Analysis, Reporting, Development and basic administration tasks.
• SQL 2005/2008 Business Intelligence tools, Data Warehousing and ETL processes.
• Delivered comprehensive BI utilizing MS solutions including MS Excel.
• Extract Transform Load (ETL) development using SQL Server Integration Services.
• Proficient in delivering dynamic reporting solutions using SQL Server 2005 Reporting Services (SSRS).
• Create ad-hoc queries from SQL Server databases for custom reporting needs.
• Interfaced with business users to prepare and update Business Process /Reporting Requirements.
• Utilized SQL Server Integration Services to define imports of the data.
• Utilized Ms Access database for data analysis and reporting.
• Created and managed scheduled jobs utilizing SQL server agent.
• Documented business and IT processes.
• Created training manuals for technical and business users.
• Analyze VAR reports.
• Assisted Project Manager with IT deliverables during application conversion.
• Collaborated with IT Director, PM regarding project planning and tracking project progress.
• Prepared weekly and monthly status reports.
• Assisted the PM in maintaining the task list, issue list, and risk register.
• Maintained project documents using MS SharePoint.
• Assisted the IT Director with Resource Management.
• Provided analysis, design and implementation of business processes, procedures, and policies to meet compliance requirements.
• Provided business development services that resulted in an increase of company revenue.

Confidential,Business Analyst
March 2009- June 2010

• Communicated directly with client for requirement gathering.
• Ensure development or implementation for IT systems to comply with Enterprise company provisioned policies.
• Created security compliance reports using MS Excel for auditing requirements.
• Perform risk assessment surveys to identify security requirements.
• Responsible for applications, systems supporting the Shell Trading business processes, required implementations, controls, and infrastructure within the scope of the applications and system standards. (Infrastructure).
• Analyzed implementation, configuration, and development processes and procedures.
• Ensure audit tasks are completed accurately within established timeframes.
• Created flowcharts to document business systems and processes for IT audit reports.
• Coordinated with various departments to create remediation plans for deficiencies found during audit.
• Tested new nested groups for Global access for memberships.
• Analyzed / Tested AD during production phase for successful role outs of new configured AD groups
• Manage Access Management processes and procedures for establishing access to Shell North America, Asia-Pac, Africa, and Europe.
• Responsible for all production IT Systems/Components within the scope of SOX.
• Involved in Shell Perimeters, NRG NT Domain/Citrix, Wintel/ Unix Operating Systems, Database support for SOX applications, (EndurOpenLink) and Middleware support for SOX applications.
• Responsible for all controls, implementations as a result for remediation efforts, risk assessment performed and accepted by the business.
• Implemented, configured and developed processes and procedures, assessed EndurSoD Matrix (IRM)
• Created Compensating Control Form with business advice (GRA Team); createda dispute Control Form with business advice (GRA TEAM).
• Performed functional, negative regression, security testing, system integration, and acceptance (UAT) compatibility.
• Tested and developed security changes for implementation and production of Endur for IT users for Shell Energy North America and Shell Trading US Company.
• Collaborated with Developers regarding reduction and performance of any influential constraints.
• Manage framework relevant to requirements, and authorization of mechanisms of roles for data access by applications and databases; maintain the application, data and its environment.
• Ensure accountability over the lifetime of the application; designed to minimize the risk of unauthorized access of database level.
• Served as a liaison between the clients for delivery to ensure application meets business requirements.
• Support IT Applications associated with roles by default to Read Only access to the databases, roles with privileged rights assumed by self permissioning process and toolset.
• Supported functional applications to perform specific application functions, interact with DBAS for assistance.
• Work directly with HR to assist Team Lead with monthly reports for user’s access to different applications, employment verification
• Worked with different IT Teams to ensure Software License Compliance.
• Maintained and Stored Compliance Documentation for Evidence requirements.
• Provide advice and direction to other staff members.
• Worked with External Auditors to gather relevant information to ensure all requests and requirements are in compliance with Sox and Non-Sox.
• Maintained test plans for the use of automated testing tools.

Confidential, Business Analyst IRM
March 2000-Febrary 2009
JPMorgan Chase Manhattan Bank, System Support Analyst
January 1995- March 2000

• Provided oversight for the ITRM Risk Evaluation function.
• Evaluated IT risk across the business with a perspective towards the aggregated IT risk profile for business environment.
• Worked directly with Global core team support in the activities of risk evaluation.
• Excellent understanding of banking guidelines regardingInformation Technology policies and directives at or above the Bank\'s performance and evaluation standards.
• Worked closely with LOB risk managers regarding business initiatives/goals to provide a well-controlled operating environment.
• Review Risk Logs and provided remediation risk issues/controls.
• Contribute perspective to the establishment of a control technology in its alignments with the business needs.
• Participated in IT risk governance forums as well as coordinated awareness sessions for business users on various Information Security and Application Security.
• Assisted the client with AP/AR and GL process implementation with Home grown financial applications.
• Coordinated closely with Project Management team to identify remediation approach for high end risk issues and strategic planning.
• Planned and tested key IT Controls.
• Analyzed Segregation of Duties components for business applications.
• Documented IT controls as per COBIT framework.