Post Job Free

Resume

Sign in

Project Manager Data Analyst

Location:
Katy, TX
Posted:
July 25, 2023

Contact this candidate

Resume:

OBJECTIVE: IT Internal Auditor

QUALIFICATIONS:

●Seasoned IT Auditor with 10+ years of experience in the technology domain, renowned for exceptional decision-making, problem-solving, and project management skills.

●Diverse experience in energy, finance industry, and consulting firms, specializing in auditing, data analysis, implementation, and reporting using various statistical tools.

●Proficient in working with database schemas and executing complex SQL queries, stored procedures, functions, and views to implement business logic, perform data conditioning, and conduct backend data verification.

●Advanced skills in Excel and VBA, including Pivot tables, Array formulas, Vlookup/Hlookup, Regression, trend analysis, and forecast functions.

●Hands-on experience with data visualization tools such as SAS,Tableau, Power BI, SSRS, and Macro for deriving business insights, designing and configuring dashboards, automating business logic, and generating scheduled periodic reports.

PROFESSIONAL EXPERIENCE:

SAP Consultant, Inossem North America 06/2019- Present

Serve as an SAP SD/MM/PP consultant, providing daily support and implementing new projects for high-profile customers such as Segway, Greenworks, and Phonix Paper.

●Analyze, define, and document requirements for data, workflow, logical processes, interfaces, internal and external checks and controls, and outputs.

●Assist partners with upfront implementation discovery diligence, project analysis, scope of work creation, proposal building, and complex Fit-Gap Analysis.

●Collaborate and coordinate with various stakeholders, including business users and functional consultants, to finalize business requirements and standardize solutions.

●Develop comprehensive test strategies, test plans, test scripts, and conduct test execution in SharePoint.

●Conduct unit testing and integration testing on the QA server before transporting to the production server.

●Provide daily support and implement new projects for high-profile customers.

Senior IT Auditor, CITIC Bank 11/2012 - 06/2019

●Conducted comprehensive IT general controls (ITGC) audits to verify compliance with SOX provisions and professional standards.

●Reviewed management's work, assessed the operating effectiveness of the SDLC lifecycle, identified risks and implementation gaps, and communicated issues and recommendations to relevant parties.

●Led PCI DSS and ISO27000 audits on bank and insurance providers, ensuring adherence to industry standards.

●Executed risk-based audits of IT general controls and application controls, assessing access control, change management, IT operations, and other critical areas.

●Conducted comprehensive IT infrastructure audits covering operating systems, databases, servers, networks, and other elements..

Audit Manager, Hong Kong and China Towngas Group Company 02/2007 - 11/2012

●Conducted IT audits in accordance with established audit standards, procedures, and policies.

●Evaluated the effectiveness of internal controls over IT systems, financial reporting, and operational processes.

●Assessed risks associated with information security, business continuity, and IT governance.

●Provided recommendations to management for improving IT processes and controls.

●Conducted interviews with business unit personnel and documented findings and conclusions.

●Prepared written reports detailing audit findings and recommendations.

Project Manager, PingAn Group Company 06/2002 - 02/2007

●Led and actively participated in the establishment and administration of the commodity futures trading settlement system, successfully introducing a financial futures trading settlement system.

●Administered databases, networks, and systems, including installation, configuration, upgrade, migration, maintenance, troubleshooting, and issue resolution.

●Conducted regular maintenance of server and storage systems, participated in the evaluation and testing of new server systems and storage solutions.

●Collaborated with business and end users to understand and meet their needs, employing strategic planning and designing, developing, testing, and implementing solutions.

EDUCATION

University Jean Moulin Lyon 3, Master, International Trade Finance & Law

Zhongnan University of Economics and Law, Master of Business Administration

Central South University of Technology, Information Engineering

CERTIFICATIONS/LICENCES

Auditing & Security:

Certified Information Systems Auditor (CISA ISACA)

Certified in Risk Information Systems Control (CRISC, ISACA)

Certified Internal Auditor (CIA, IIA)

Certification in Risk Management Assurance (CRMA, IIA)

ISO27001 LA(IRCA)

Data Analyst & Programming:

SAS Base/advanced programmer (SAS)

SPSS (IBM)

MCDBA/MCSD (Microsoft)

Google Data Analytics Certificates (Google)

Business Certifications:

SAP Certified Application Associate MM/SD/PP



Contact this candidate