Jeffray J Michael Email & Phone Number

Toronto, ON, CA

Toronto, Ontario, Canada

• Products: Commission Processing, Employee Payroll, Mortgage Compliance
• Defined product vision, strategy, and road map based on market analysis and customer feedback industry trends, resulting in 20 new clients per year.
• Conducted market research, competitor analysis, and customer interviews to identify market needs and drive product improvements, resulting in 100% customer retention.
• Successfully Integrated with a payment gateway to facilitate payroll/commission payments via EFT. This reduced EFT processing time to 1 day as compared to previous 2 day EFT via bank processing.
• Achievements include managing a high volume payroll system that facilitates payment of $50M+ on a monthly basis.
• Successfully integrated with multiple APIs to read/push data that adds value to the Product.

Singapore

• Business Analyst for ERP CRM customization and implementation, digitize and automate several business processes that were otherwise complex, time-consuming and manual.
• Gathered client requirements and translated those requirements to BRD's and FSD's.
• Spearheaded the Implementation of 30+ workflows which improved operational efficiency by 40% and increased customer retention rate.
• Conducted end user Training by creating user manuals and training workshops.
• Assisting in testing by performing UAT and data validation.
• Developed and managed detailed project plans including effort estimation and deliverables.

Bengaluru Area, India

• The project is to provide support and enhancement to the production DWBIS of a Malaysian Telecom Client.
• Analyse, evaluate the needs and performance of the Data warehouse application.
• Develop, maintain Netezza SQL and procedures for ETL. Perform Query analysis and performance tuning of existing SQL and Data warehouse.
• Problem identification and Solution proposal for production issues.
• Perform Data Analysis functions such as Data Profiling and Data Lineage.
• Designed and maintained BI data sets for reporting needs.

Bengaluru Area, India

• The project is to build a Web-based Product that involves building a back end administrative application for ETL, monitoring and a booking platform for tourism and hospitality industry.
• Elicit Functional Specifications, Work flow Diagrams and use cases.
• Design logical Data Model and Entity Relationships of the Data Base. This includes Static, Master and Fact Data, Views and Data Marts.
• Build Data Analysis reports to identify trends in the tourism industry using Tableau. Reports include Top performing partners, Revenue Trend, Season Hot Spots, Booking Pattern, Customer Analysis etc.

Mumbai Area, India

• Part of the Development Team as Netezza Developer for a surveillance & Business Intelligence project based on Stock market Trading using Netezza for our Client, the Government of India
• Design, develop and test ETL solutions using Netezza and UNIX shell scripting. Monitor the full ETL jobs in Data Stage.
• Perform production support including incident and problem management.
• Conduct performance analysis and optimized queries in the production environment.
• Develop SQL for stock market trading surveillance. Some complex SQL for reports include Insider trading report, Rouge trading report, Churning report, Wash trading report etc.

Master Of Science (Msc), Management Of Technology, 3.95/5

Activities and Societies: Non Uniformed Officer, National Police Cadet Corps Publicity & Publications, Graduate Student SocietyModules.

Bachelor Of Technology (Btech), Computer Science & Engineering, 7.6/10

Activities and Societies: Student Chairman, National Service Scheme PR committee, National Level Tech Fest Organizer, Departmental.