Michele Jacobs Email and Phone Number

Support the Specialty Asset Management reporting processes to ensure timely and accurate analysis, report output and delivery.

• Implemented database structure for more than 20 funds which allowed fund management to cut reporting time by more than 70% and ensured complete and accurate reporting to investors.• Integral part of team that designed the multi-level Oracle relational database and subsidiary data warehouse. The database and data warehouse were star schema structures and used normalization database design (3NF).• Used SQL, Excel and Cognos to manage realty management division’s relational database holding assets in excess of $1 billion. The database is a multi-level Oracle relational database which holds all information relating to the real estate and loan assets owned and managed by Goldman Sachs.• Analyzed and defined user requirements and created design specifications for new business applications and reports using SQL, Excel, Word and other tools. Worked with business and developers to design solutions in an Agile environment.• Performed in depth data analysis of large datasets for internal clients in the business and fund groups. Updated data to ensure data integrity in database using SQL and Excel. In addition, able to find issues with data that appeared correct but was inaccurate.• Designed and implemented full level of static and financial data points on more than 1,000 assets which allowed portfolio and asset management a complete window into the performance of assets. Reduced the time needed to report and perform analysis as well as streamline the business plan processes.• Recognized as the SME for database, table structure and data providing consistency and efficiency in troubleshooting options for data management. Point person for all additions to database tables and fields ensuring consistent data governance, structure, integrity and quality.• Senior leader on GS Dallas Women in Technology group.• Established framework for mentoring for Dallas areal technology division.• Mentored team members, improving and empowering individual and team performance.

• Integrated all data on newly acquired assets, funds and other data sets into existing database.• Updated data, ensure data integrity and identify data issues in database and data warehouse using SQL, Toad, SQL Plus and advanced Excel analysis.• Used SQL, Toad and Excel to pull, analyze and organize data which various business users and groups used to report on performance.• Worked with finance, accounting, compliance, audit and asset management to acquire and report on new assets and investments. Also assisted groups to interact with database and determine financial reporting solutions.• Re-designed database into a larger, more robust schema as business needs expanded. Designed and implemented a process to transfer data from the old Oracle database using a combination of MS Excel, text files, and SQL.• Produced monthly reports for Asia region operating partner from database using SQL and importing data into a pre-formatted MS Excel template. Built an automated reconciliation process within template to ensure accuracy of data.