Diptesh Patel Email & Phone Number

Perth, WA, AU

Perth, Western Australia, Australia

Perth, Australia

Perth, Australia

West Perth, Australia

• Background in Insurance / Financial Services
• Currently working with nationally recognized Insurance company
• Extensive experience with Microsoft stack - MS SQL Server 2008 R2 & 2012, SSIS, SSAS, SSRS
• Experience and knowledge of OLTP and OLAP systems.
• Extensive experience in OLAP design and modelling.
• Expertise in Microsoft Visual Studios, SSIS packages, Data Warehouse packages, Testing scripts, SSAS Cube,SSRS Reports, Continuous Integration - TeamCity, Visual Task Automation Tool - Automise etc.

Newcastle, Australia

• Responsible for changes to design and development of data warehouse solutions and reports for Internet Banking warehouse and Cube.
• Suggested and applied changes to optimise performance of the existing Warehouse Cube.
• Created and published Pay Anyone and BPAY reports for Intra-day reporting to assist corporate security division for fraud protection using SSRS.
• Designed and developed migration project of Finacle database to in-house Internet Banking Analytical database and ultimately to the cube.
• Created migration packages to fetch host customer data from Sandstone Oracle database to Warehouse using Attunity drivers.
• Involved with job automation using TIDAL and use of power shell scripting. e.g. Downloading IP and BSB Listing data from third party FTP server.

Perth, Australia

• Involved with three major data migration projects for Courts Technology Group 1] CHIPS - Childrens Court, Magistrates, District and Supreme Court 2] FER - Fines Enforcement Registry - Childrens Court, Magistrates.
• Migration of data from Oracle (PL/SQL) and CSV data and then to SQL Server 2012 database implementing complex business rules.
• Worked on the Australian government project.
• Developed and monitored data collection from variety of sources. Data loading using SSIS into SQL server database and generating various MS EXCEL reports periodically
• Demonstrated research and evaluation skills to identify and report unusual events in the data.
• Performed daily data queries and prepared related reports using SSRS for ICMS.

Melbourne, Australia

• Responsible for designing and monitoring the whole data collection process from a variety of sources maintaining the quality of data, and verifying data quality (frequency counts, descriptive mean stats, etc.)..
• Automated the verification and validation of data from different affiliates (25 countries) across the globe and manage customer requirements effectively with proactive communication.
• Employ different analysis and reporting techniques to generate a wide variety of reports like KPI, Effort Vs Sales, etc.
• Automated the verification and validation of data from different affiliates across the globe and manage customer requirements effectively with proactive communication.
• Determine more efficient ways of collecting and qualifying data and initiated efficient data collection procedures to ensure all data collected as per the acceptable standards.
• Proven ability to make tight deadlines while maintaining accuracy.

Melbourne, Australia

Primary roles and responsibilities for this project were ‘Testing and Support Engineer’. I was also involved in the preparation of all the software engineering related documents such as Project Charter, Project Definition, Software Requirement Specification, Design Specification Document, produce Use Case and technical UML based designs from business.

Vadodara Area, India

Development of software for ISO 9000 documentation system. The software helps ATR Associatesin handling all computerized generation of purchase orders and invoices, maintenance of record of orders, generation of various reports that help management analyzing and taking decisions. The front end was VB6.0 and the database was SQL Server 2000. The software.

Master Of App. Sci. (Info. Tech.), Information Technology

Masters of Applied Sciences (Information Technology)

Master Of Computer Management, Computer Management

Master of Computer Management

Bachelor Of Sci. (Comp. Sci.), Computer Science

Activities and Societies: Basket ball TeamBachelor of Computer Science