Highlights:

Skills:MS SQL, SSIS, SSAS, ETL

Certification:Microsoft Certified Technology Specialist: SQL Server 2008, Database Development, Microsoft Certified: Azure Fundamentals

Data Engineer 09/2020 - 08/2021
Shell Infotech, Singapore, Singapore Singapore
Industry: IT
Worked with their client Prudential Assurance Company Singapore
• Part of the Data Team that oversees the migration of the financial report from IFRS4 to IFRS17 • Create Technical Specification Documents that will define the requirements or changes in the system for the Transition Team. • Develop an ETL package that will generate the historical data and integrate the changes base on the requirements in preparation for the IFRS17 report. • Work closely with the Testing team during the testing phase while continuously working on improving the stability and performance of the jobs.--
Senior Business Intelligence Consultant Aug 2018 - June 2020
Capitaland, Singapore, Singapore
Responsible for leading the global in-house software development team, deployment team, provide application services, BAU support within the organisation. Deliver software releases to support the growing business need to add new modules, include new functionalities, develop subsystems, enhance existing functionalities and develop interfaces to other systems.
Key Projects Ascott BI • Reverse engineer current Data Warehouse and MS OLAP Cubes for Ascott Hotel • Provide end to end support to Ascott BI users • Developed dashboard used for the monthly consumption of the properties. • Execute and deliver the revamp Data Warehouse architecture • Enhance Capitaland's operational report using SSRS as per client specifications • Ensure that all the applications related to Ascott are running Universal Data Store (UDS) • Maintain the servers that is being used by the UDS and applications • Provide support, troubleshoot and work with vendor on UDS and related systems--
Data Engineer April 2018 - June 2018
Ernst and Young, Singapore, Singapore
• Developed an ETL package that will ingest XML and XBRL files that will be used by the client for their report. • Designed Data Model that will be used for the new ETL jobs that is being developed. • Maintain the SASVA reports of the user before decommissioning the SAVA server and transfer all the reports to tableau server. • Maintain the current SSIS jobs that is currently running on the production server
Technologies used where MSSQL 2017, Talend Data Integration, SASVA--
Software Engineer Nov 2012 - March 2018
Housing and Development Board, singapore, Singapore
• Developed an ETL package that will convert the flat file source and store it to a Database source. • Developed Cube for the client’s OLAP as per the client’s specification. • Analyze and Design the Data warehouse that will be used for the ETL and the cube. • Analyze, Improve and maintain the Data warehouse performance and scalability as part of our continuous improvement initiatives and to meet the requirements of the users. • Analyze and Improve the ETL and Cube performance and scalability to meet the requirements of the users.
Technologies used where MSSQL 2005, MSSQL 2008, SSIS, SSAS, SSRS--
Software Engineer June 2011 - June 2012
Accenture, , Philippines
• Analyze, Improve and maintain the Database performance and scalability as part of our continuous improvement initiatives. • Provide Application Support by troubleshooting issues and resolve bugs. • Conducts analysis and study to assist the client in finding ways of improving the performance and enhancing the scalability of their .Net applications • Created an SSIS package that will send an email to the customers reminding them to answer a survey about the assets that they have previewed on the site.
--
Associate Software Engineer Feb 2010 - June 2011
Accenture, , Philippines
• Provide technical support to all related Microsoft based applications tickets raised by the client’s helpdesk in Asia pacific region such as Singapore, New Zealand and Australia. • Conducts analysis and study to assist the client in finding ways of improving the performance and enhancing the scalability of their .Net applications • Designs, builds and tests all new additional requirements needed to their .Net applications. • Extracts data and generates report needed by the client’s financials department on a daily, weekly and monthly basis.
--

Mapua Institute of Technology july 2005 - oct 2009
Makati City, , Philippines
Degree: Bachelor's Degree
Major:Computer Science
An average student that became the Student Council President of our department

Login to view resume: Mharpee Panday - SSIS Developer
Login to view resume: Mharpee Panday Sql Server - ssis,ssas,ssrs
Login to view resume: Mharpee Panday -
Login to view resume: Mharpee Panday -
Login to view resume: Mharpee Panday Data Engineer -