Shirley Lu

A senior financial professional and certified TM1 developer with proven success to model and deliver financial solutions in IBM Planning Analytics TM1. Technical lead in TM1 architecture design, advanced Turbo Integrator process and rule statement scripting. Hands on experience in TM1 and Hyperion administration (installation, configuration, security, system backup, performance monitoring), TM1 system enhancement and upgrade.

Strong knowledge of general ledger accounting, financial planning and analysis and reporting, budgeting and rolling forecasting, demand planning/predictive modeling, statistical analysis and modeling, financial and non-financial data mining, business analytical tool modeling. Proficient in SQL/Python/SAS/R/VBA programming. Ability to interact with various clients, deliver desirable TM1 project outcome with least amount of rework and ongoing maintenance overhead.

IBM Planning Analytics Developer - Royal Bank of Canada

(2024-12)

• Bank wide perspective to PAfE websheet conversion using IBM PAfE utility, python and VBA to manage conversion process ensure all action buttons got converted for 17 servers.
• Performed forecast model enhancement and support, the model calculates project related capitalization cost, depreciation expense, and non-capitalized IT expense got allocated to different transits. Rush ti to make cross server call to export cube, dimension extract to csv files and load to target servers.
• Implement off-gl items project from user managed dimension cube creation, rule, TI to upload user input, control logic, and advanced active form in TM1 web.
• Lead SOX audit related to bank's regulatory disclosure tables and templates in TM1, and Fix script vulnerability discovered by Claude Mythos Vulnerability AI model.
• Perform other enhancement projects, production ticket troubleshooting, and support.

Planning Analytics TM1 Consultant - Park Computer System Inc.

(2024-06 - 2024-10)

Administrated, developed, maintained a workforce planning model for the client, monthly headcount forecast, HC related expense forecast, overhead expense, cost allocation to product by headcount driver, and consolidated financial reporting, FX conversion for various regions. Controlled forecasting and budgeting cycle by the system including final submission and user support, system documentation using Confluence wiki.

• Enhancement projects include write data from an external system using TM1py write data frame, convert rule to TI process, partition large security data load using Rushti parallel loading.

AWS App Dev Eng – IBM Planning Analytics - Amazon Web Service Fintech - Las Vegas, NV

(2021-05 - 2024-05)

Administrated and operated AWS Finance Cognos TM1 system with seven instances (1-2 TB each), data models include revenue, operating expense planning, capital expenditure planning, workforce planning, driver-based cost allocation, P&L reporting, segment analysis, and reporting & analytics. Conducted month-end closing, planning cycle ad hoc system processes (Cognos Command Center), daily ad hoc system and customer support tickets, and wiki documentation and user training.

• Developed projects from initiation to completion including dimension/ cube creation, rule/TI process scripting, use parallel TI via TM1py for large data set load from various data sources, data in and out of S3 bucket, create spectrum table from S3 and partition, looping through files, elements in a dimension, hierarchies, children of a consolidation, a subset, attributes and cells, cube data import/export, dim sync, alternate hierarchy creation, snapshot process, AWS cloud product integration w
• One project received 2023 Q4 team work award, snapshot enhancement project received accolade of 2023 CFO goal.

Sr. Business Intelligence Developer - MGM Resorts International - Las Vegas, NV

(2017-05 - 2021-05)

Administrated Cognos TM1 system with two application models, one daily P&L with driver-based forecasting, one annual budgeting and forecasting. Performed system administration tasks such as system backup and recovery, security setup (CAM mode 5), log file periodic cleanup, real time server monitoring, performance check, supporting over 180 users for system and data issue in production environment. Led many post-go-live systems enhancement and development projects to ensure a daily TM1 model operational under tight time constraints.

• Prepared documentations and trained users to understand data flows, developed self-service process templates with action buttons allowing users to master their own data loads into a dynamic daily model, created an active form with excel proportional ratios and adjustments for users to validate month-end true up process.
• Administrated Cognos Finance including month-end report bursting, report modification, batch report bursting via scripts, report library creation and maintenance, share-point administration.
• Developed a statistical KPI cube in TM1, upgraded PAX and PAW in DEV environment including installation and configuration, automation in planning analytics for excel using API, planned the development of integrated retail's python/SAS predictive model output to TM1 retail rolling forecast model using TM1py/TM1r package.
• Participated in Oracle ERP cloud implementation, oracle FSSC/ARCS system administration, FRS web studio reporting, and Power BI reporting.

Sr. Financial Analyst-TM1 Specialist - TESTAMERICA INC. - DARIEN, CT

(2013-08 - 2015-03)

Administrated company's Cognos TM1 10.1 system, served as a single technical resource for over 90 users. Developed and managed company's TM1 solutions including forecasting, budgeting, profit and cash flow planning, costing, workforce planning, and KPIs models. Led TM1 building blocks' development: cubes, dimensions, elements and attributes.

Built business logic using rule statements and feeders, automated TM1 models using TI processes, enhanced user experience via web application design and business insight.

• Created and developed on data connections to other data sources for automating and enhancing business analytic abilities, leveraged TM1 models and other data sources to design/develop new business solutions and performance metrics.
• Created alternative dimension hierarchies, lookup and virtual cubes, wrote advanced TI scripting, developed dynamic subset using MDX queries, advanced worksheet & web sheet reports, active forms with drill down and special formatting, drill through process, and admin and data uploading template with active buttons.

TM1 Consultant - Starpoint Solutions (Client: Dow Jones) - Princeton, NJ

(2016-10 - 2017-02)

Prototyped KPI model in Cognos TM1 10.3, responsible for cube and metadata structure design, source data import using TI processes, rule statement to calculate ratio KPIs and weighted average KPIs based on publication days, and KPI reporting.

• Upgraded Cognos TM1 9.5.2 to TM1 cloud 10.3, responsible for converting VBA based dynamo reports to active form dynamic reports or CAFÉ reports, performed unit testing, testing plan, and UAT.
• Created a small and dense FX reporting cube from a large FX analysis cube, created dynamic forecast scenarios using control cube, rule scripting and TI process to automate multiple scenarios, multiple currencies, variances and FX impacts' reporting requirement, improved cube performance.

Sr. Technical TM1 Consultant - Larson Toubro InfoTech Limited (Client: Johnson & Johnson) - N.BRUNSWICK, NJ

(2016-03 - 2016-09)

Conduct technical documentation, model business logic, rule statement and TI process review of existing TM1 applications in two instances. TM1 server administration, application's user support, IT ticket resolution, open item break fix, model enhancement including complex feeder optimization, user input template developed by VBA and API functions to include error trapping codes, large cube allocation using proportional spread.

• Active form report and input template recreation using MDX and Workday data source. Alternative solution demo development in Dev environment.
• Support 2017 planning cycle including data loading, troubleshooting, analyze and reconcile TM1 vs. data source to identify gaps, fix problems. Achieved one day ticket turn around.

TM1 Consultant - Trident Technical Solutions (Client: Verizon Wireless) - TAMPA, FL

(2015-06 - 2016-02)

Led architect and code development of TM1 10.2.2 models for Verizon Wireless's National Customer Service, Business Operations with 18,000 employees. Gathered business requirements, analyzed business logic, designed, prototyped, developed TM1 dimensions, attributes and cubes. Coded and tested rules and TI processes to ensure error free TM1 models. Created an Admin control cube for relative time modeling, time control.