Manager Sql Server

Mawela Tshikororo

Senior Manager

******@*****.*** - 1-503-***-****

Full Name - Mawela Tshikororo

Willing to relocate: Anywhere

WORK EXPERIENCE

Senior Manager

IT Governance - 2007-11 - 2015-03

Job Overview - IT Performance Measurement and Governance

- Consolidated IT performance monitoring and reporting

- Baseline with IT Exco and Sanlam Personal Finance IT Board the current draft IT Performance Management framework and measures.

- Develop appropriate scorecards as the basis for measuring and monitoring organisation performance.

- Aggregate and filter scorecard results in a consistent and true reflection of IT performance.

- Implement a structured Performance Management process.

- Ongoing maintenance and refinement of the IT Performance Management framework and process.

- Develop and review IT Governance of IT processes and mechanisms

- Own the IT Governance Process of the IT Process Architecture.

- Oversee delivery of IT services and ensure business and IT objectives are being met.

- Supervise the administration and clerical work of the various governance forums in IT

- Responsible for Sanlam Personal Finance Divisional Board Report (Quarterly) Previous Positions

Wells Fargo & Company - 2006-07 - 2007-07

• Metrics Reporting and Analysis at Wells Fargo & Company (USA) July 2006 to July 2007

[Wells Fargo & Company, through its subsidiaries, provides banking and financial products and services in the United States. The company operates in three segments: Community Banking, Wholesale Banking, and Wells Fargo Financial. Wells Fargo & Company is the fourth largest Bank in the US with 260 000 employees] Job Overview - Metrics Reporting and Analysis

- Responsible for consulting with clients to identify and define business requirements and translate business needs into complex analysis designs and recommendations.

- Identifies and recommends internal and external data sources, compiles/mines data from multiple, cross business sources; recommends and participates in the development of complex analysis designs using statistical analysis, predictive modelling, process documentation, comparative analysis, etc.;

- Interprets results and recommends solutions to increase revenue, reduce expense, maximize operational efficiency/quality, etc.

- Ensures adherence to data management regulations and policies.

- Manage project teams and provide guidance to less experienced analysts.

- Introduce new reporting tools and manage implementation to the business Notable Successes - Have successfully engineered our data warehouse, reporting and cube structure from manual process to fully automated platform.

Business Analyst

Wells Fargo & Company - 2004-08 - 2006-06

Job Overview - A top-level strategic role providing information and insight to guide the organisation's direction and position in the market, and to support Executive decisions

- Manage adhoc on-line request logs for data retrieval from DB2 to SQL server and present SQL reporting services

- Supervise Operations Analysts

- Generate operations pipeline reports.

- Produce intricate reports for four business channel's (7800 headcount)

- Co-ordinate day to day needs for business channel's business processes

- Project mapping and execution while reducing risk

- Work in conjunction with business channels to reduce costs (Six Sigma Methodology-control charts etc. studies)

- Study loan cycles using data analysis in order to reduce turnaround time. (#of days in process)

- Member of strategic team for implementing and selling Business Intelligence (BI)

- Design processes and provide input on training for BI (Business Intelligence). Business Systems Consultant

Wells Fargo & Company - 2003-02 - 2004-08

Job Overview

- Perform forms production management: forms creation / revision requests for LIS and AppTaker

- Manage Production Rollout of new, revised and obsolete forms.

- Perform batch rollouts and provide to WFSC by set deadline each week

- Manage Smart Doc applications/criteria tables

- Partner with Help Desk regarding forms issues

- Provide significant contribution to forms workflow documentation

- Provide significant contribution to forms workflow documentation

- Manage the VMP process and proof UFF files to ensure adherence to project needs

- Represent department in ongoing Projects (i.e., Project C and EMRG (ERMG is continuous project))

- Responsible for forms mapping on UNIX, LIS Mainframe, MVS (JCL) and Fusion Servers

- Write UNIX shell scripts to deploy forms on the mainframe system Credit Analyst

Wells Fargo & Company - 2002-09 - 2002-09

Job Overview

- Gather all necessary information for loan closure (working with HMC)

- Ensure accuracy of information before closing loan

- Check closing dates for accuracy

- Send closing documents to Settlement Agent

- Ensure Settlement Agent figures are correct

- Resolve disputes with Settlement Agent

- Fund all closed loans

- Ensure that all compliance documents are correct Consultant

PeopleSoft, Inc - 1998-07 - 1999-07

Job Overview

- Demonstrate sound knowledge of Work with PeopleSoft Student Administration 7.5

- Provide expertise on academic advising processes and panels

- Liaise with customers to apply updates and fixes for Student Administration from testing to production

- Ensure readiness of Student Records Implementation Teams for the PeopleSoft Student Administration Release

- Responsibilities include: mapping data from legacy system into PeopleSoft's Student Record 7.5

- Provide security administration of the PeopleSoft system

- Maintain and create various types of user information into the PeopleSoft system

- Use PeopleTools for the enhancement and addition of various tables Information System Analyst

University of Vermont - 1995-07 - 1998-06

Job Overview

- Code SQL scripts in UNIX environnement

- Write SQL queries for the office

- Roll over previous year's programs to New Year

- Install new releases (Banner SCT product) to UNIX O/S

- Maintain daily computer operations management and verification of data files

- Monitor, respond to and resolve system software and network performance problems.

- Compile statistical data for department, university, state and federal reports

- Train end-users before and after system upgrades Administrative Manager

Standard Bank of South Africa - 1984-03 - 1990-11

Job Overview - Head of branch operations (Reporting to head office)

- Process and approve loans (personal and small business)

- Check the trial balance (accounting)

- Budget projected branch revenue and expenditure

- Installation and purchasing of computers and equipment

- Determine grade level and salary of new employees

- Monitor payroll accounting activities for bank employees

- Supervise seventeen employees

- Develop training programs

- Interview prospective and current customers to improve customer service

- Prepare monthly, quarterly and yearly reports for our head office EDUCATION

Bachelor of Science in Statistics

University of Vermont

1996

SKILLS

DB2, MS SQL Server, SQL, SQL server, UNIX

ADDITIONAL INFORMATION

Technical Skills

Standard Structured Query Language (SQL) • Oracle database • DB2 database MS SQL Server • Reporting Service • Integration Services PeopleSoft: People Code • Security Tree • Process Scheduler MS: Office • Project • Visio • Access • Power Point • Excel Quark • UNIX •

Qualifications - B.Sc. Mathematics (Specializing in Statistics) University of Vermont (USA) Position Held - Metrics Reporting and Analysis (Current) at Wells Fargo Bank NA Phoenix in Arizona (USA)

"I believe my diverse background in banking, higher education and IT (consulting) has equipped me with wealth of knowledge that can be transferred to any business environment and add immediate value."

Contact this candidate