Mathew Joseph

 Work on the RFP's and give business solution.
 Analysis based on user reviews, app rating and devices used by customers.
 Scripting using Python.
 Work with sales, pre sales and account teams to understand client requirement and
give the best possible solution.
 Keep up to date on the new happenings in mobility quality assurance.
 Work with the account teams for the resource fulfillment and ensure the fulfillment.

 Responsible for conceptual, logical, and physical data modeling.
 SQL Server, PDW, SSIS development including procedures, functions, query
optimization and deployment automation.
 Design and implement ETL processes to source transactional data sources into the data
warehouse and mart applications.
 Conducted performance tuning and optimization of OLTP and OLAP database schemas
on Microsoft PDW platform.
 Held code reviews, and lead optimization efforts of new or modified business logic,
database schema and ETL processes.
 Established standards and best practices initiatives covering client subject area usage
and consumption, development practices, change control and platform best practice.
 Gap Analysis for the phase 1 implementation and its solutions
 Architecture and design document review.
 Work with Business/technical teams on finalizing KPI’s, Facts and Dimensions and their
process flow.
 Wipro representative for operation committee and steering committee meetings.

 Collected the requirements and Designed Logical Data model.
 Implemented Physical Data model with partition management, Index management and
archiving process.
 Hands on database development using oracle exadata, Design ETL process and
Informatica development.
 Architecture and design document creation.
 Work with Cognos/Tm1 experts to design Facts and Dimensions and their process flow.
 Root cause analysis & problem management.

 Responsible for the delivery of enhancements & maintenance requirements in finance IT
Profit & Loss applications in UBS.
 Root cause analysis & problem management.
 Hands-on in sybase, oracle, informatica, unix, perl, autosys
 Analysis and development of reusable components.
 Achieved ZERO DEFECT Delivery in majority of the releases.
 Escalation point for the RTB issues in APAC region.

 Production Support, Root cause Analysis
 Problem Simulation, Debugging & Fixing.
 Modifying, Reviewing and Tuning Database and PB objects
 Creating &reviewing unit test cases, unit testing.
 Created Packages(Hot fix, Roll up’s and service packs)

 Analyzing the requirements, Designing the database objects
 Development, unit testing, Reviewing, Tuning Database objects
 Application Integration & Implementation.
 Appreciation received from the accounts Head for the “Funding Module” design

UAE Exchange FS, Cochin UAE Exchange www.uaeexchange.com

 Problem Analysis
 Development & Unit Testing.
 Implementation at Central Bank of India, United Bank of India