Julia Jie Li (李婕） Email and Phone Number

-- Builds bilingual team to focus on Asian, especially Chinese investor market-- Founder and host of Chinese New York real estate forums-- Represents buyers, sellers and investors to seek, negotiate and close residential and commercial real estate transactions;-- Provides A to Z real estate service from buy to rent and property management-- Specialized in Manhattan Coop and Condos; Long Island and Westchester.-- Expert in handling international deals, serving foreign buyers and investors. -- Assists clients on board package preparation and board interview-- Strong negotiator, has multiple track records of winning bidding war on behalf of clients

-- Manages day to day operation-- Provides business consultancy to small businesses, such as doctors office, art studio-- Helps small businesses to stream line their operation by leveraging computer information systems-- Promotes small business on internet, social medias--Trains business owners and employees on internet marketing and computer skills

Brought to AIG Corporate Comptrollers as a Project Manager to lead corporate legal entity restructure project. Promoted to System & Development Manager in 2008, managed a team of 6-11 members, successfully delivered 20+ projects cross 10+ departments and functional areas.-- Responsible and accountable for the coordinated management of multiple related projects directed toward key business processes in AIG Corporate Comptrollers.-- Built credibility, established rapport, and maintained communication with stakeholders at multiple levels, including those external to the company.-- Coached, mentored and led staff within a technical team environment.-- Presented periodic status reports on the current projects, issues and potential risks.Major Achievements:-- Inherited derivative consolidation accounting system when AIG was in deep financial crisis. Team took over complete processes in as short as 2 months, cut $2 millions per year of consulting cost and passed Federal Reserve audit.-- Customized 3rd party entity software, by expending data model and creating web interfaces into existing financial applications, significant enhanced financial reporting’s efficacy and accuracy. Shorten quarterly closing time from 3 weeks to 3 days.-- Inherited legacy payroll system, through a series redesign and migration efforts, team subsequently converted it onto corporate standard platforms, standardized data transfer (ETL) process from 16 sources in multiple formats. Save over $5 million potential outsource consulting cost.-- Researched and evaluated software and new technologies, advised senior management to save ⅓ in budget.-- In charges of day to day operation of 30+ database systems (Oracle and Microsoft SQL server ) with over 300TB data, 90+ data feed processes interfacing 18 applications, on multiple platforms.

--Top 5 Global Pharmaceutical Company - Safety Data Warehouse May 2003 – June 2006Developed an analytical and statistical tool, a fully validated repository for client’s safety data. It incorporates a Global Safety Data Warehouse (SDW) and Data Mart. Data is extracted nightly from 5 source systems, allowing users to query via Business Objects and have a faster mean of accessing and analyzing critical safety data. This project supports the Safety Evaluation and Epidemiology (SEE) group within Regulatory Affairs with regulatory reporting, pharmacovigilance, labeling reviews, and a wide range of complex analysis. In addition, every aspect of this project was developed and implemented to provide a validated system that is 21CFR Part 11 compliant. Led team to design , develop, maintain and implement logical/physical data models (Staging, Data Warehouse, Data Mart) throughout 15 releases. Decreased Extract Transform Load (ETL) program’s from 20 to 6 hours by using advanced Oracle features. Established cross-functional team weekly “checkpoint” meetings to enable communication across the business,, technical and quality domains, therefore to early detect and mitigate risks, issuesRisk management and change control. Created detailed change management guideline Coordinated system integration and validation test of over 10 different source systems cross 6 functional departments. Created a complete checklist of over 50 testing action items -- Top 5 Global Pharmaceutical Company - Clinical Data Analytics & Reporting System May 2001 – May 2001Provided client’s Clinical Data Operation department with an enterprise data warehouse solution to enhance information sharing among clinical teams, and enable clinician-scientists, clinical research associates, clinical project managers, and project planners to make greater use of various sources of information, such as clinical trial data, resource data, and project management data

Database Administrator, New York District Attorney’s Office,March 1999 – March 2001, New YorkA sole production DBA, supported and managed all production databases 24x7.