Jay Karuna-Ratne Email & Phone Number

Foxborough, MA, US

Boston, MA

• Data Scientist (2019 - Present)Venture Realty( Formerly Clockhouse Realty), Boston, MA
• Work as a consultant specializing in real estate in Boston and 12 surrounding cities for providing data-mining and Business Intelligence (Tableau Server) solutions.
• Imported data into MS-SQL server from flat files generated by different third-party vendors to in-house data warehouse. This was done by primarily using SQL Server Data Transformation Services (DTS) and T-SQL bulk.
• As a Licensed Real Estate agent in Massachusetts and Rhode Island, worked with several Developers and Contractors in Boston/ Providence and the surrounding areas representing full cycle marketing to sales process.

Boston, MA

• Responsible for initiating complex customized data sets that includes Predictive Analysis( Snowflake/ Tableau), identifying customer data repositories and come up with best strategies to deliver best insight.
• Perform data research and deliver data extracts( SQL/DTS) and information to clients. This role needs a solid understanding of real estate data and write algorithms to create various customer supply chains.
• Feed unstructured data from a various customer data sources and Formalize data to identify the best analytical approach( SQL/ Tableau).

Boston, MA

• Wrote algorithms from company data sets to create revenue generating leads.
• Collected and analyzed data and statistical model(SAAS/ Tableau) to evaluate existing and potential product/service markets.
• Utilized multiple data sources including the company’s internal public real estate database, CRM, marketing databases( SQL Server/ PostGRE SQL) to create integrated views that can be used to drive decision making.
• Gathered, analyzed, interpreted, and presented real estate trends and information for business development opportunities, client support and internal analysis, as well as noteworthy story lines and press releases and.

Melrose, MA

• Developed a client server graphical user interfaces in MS SQL-server Data Bases.
• Design and debug reports by SQL/PoweBuilder Infomaker tools.
• Participated in the development of enterprise wide customer information solution. This required redesign of the existing end user customer databases, design and implementation of corporate customer back end.

Newton, MA

• Built a BI - Executive Dashboard that offers instant snapshots of key performance indicators (KPI), such as new sales orders, commissions, support cases and accounts receivable
• Worked with CFO of the company to create organizational strategy with KPI and communicates them across the extended enterprise
• Created Cognos OLAP cubes to view and analyze KPI details including actual, target, status and trend values

Waltham, MA

• Involved in full life cycle development and technical supporting of the company flagship product: Dynamic Radplus.
• Designed, developed, tested and executed scripts used for data implementations and data conversions. Creating enhancements to organization’s existing code.
• Modified and tested interface tool that interfaces between the hospital systems and the Dynamic ADT system.