Diptesh Patel Email & Phone Number

Perth, Wa, Au

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.• Expert level Skills to manage multiple releases in Subversion(SVN) • Writing deployment scripts and manage deployment• Strong skills in developing SSAS cube, writing and debugging complex MDX queries• Knowledge in Microsoft Tabular Modelling• Demonstrated experience in BI Performance tuning (SSIS, SSAS Cube and MDX) and handling large data processing Data Visualization: • Convert existing reporting tools to a standardized reporting infrastructure using Oracle and/or Microsoft products - SSRS, Power BI.• Reports/Dashboards development using Microstrategy

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.• Publish SSRS reports on Sharepoint portal and automatically send the reports to subscribed groups.

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, District and Supreme 3] Canberra, ACT- ACAT , Civil, Criminal and Energy & WaterDuring CHIPS and Fines Enforcement Registry (FER) Migration to ICMS. Each time migrated more than 300 GB of data in very tight deadlines. • 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.• Routinely used advanced Excel functions to generate spreadsheets and pivot tables.• Developed detailed Business rules documentation throughout the project. • Proactively coordinate and organise WebEx with stakeholders to understand exact data requirements• Assist in developing BI solution for ICMS and SSRS reports development using MDX/DAX• Assist in development of complex SSRS reports as per given specifications for eg. Case lodgement by offence type, Arrest warrants issued/returned, Licence Suspensions, Enforcement Warrants, Payment Arrangements etc.• Assisted Business Performance Manager in development, maintenance and optimization of OLAP cubes and data sets.

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.). Determine and Prepare sample data sets. Confirming data sets using scatter plots and cross-tab reports techniques.• 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.• Develop and support Data warehousing solutions for PRISMS• Create various reports/dashboards as per the given specifications using SSRS.

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 requirements and the Test Plan. Programming with Java Server Pages, Servlets, XML (XML Parsing using Xerses, XSLT) and Oracle 9i. Worked with Tomcat 4.1 as the application server and Apache 2.0 as the Web Server. Other functions were organizing whole testing process, preparing test cases, maintaining test logs, bug reports and test summary reports.

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 also generates various types of reports using Crystal Reports 8.0.Also developed different intranet applications for the same. And I worked as a team leader for 2 yrs during this experience.

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