Leo Bazil Email & Phone Number

New York, Ny, Us

New York, Ny

Define a cohesive finance systems strategy to bridge business and IT stakeholders. Deliver enterprise-class solutions that lift corporate planning to the next level of efficiency and transparency, as well as alignment with long-term goals.Data Modeling, Warehousing, Governance- Assembled a team of skilled professionals with extensive domain knowledge and a wealth of finance and technology experience by drawing on industry connections and internal talent.- Developed FP&A data standards across five major businesses within AIG (general insurance, life and retirement, mortgage guaranty, aircraft leasing, and asset management / financial products).- Produced initial taxonomy of global functions and established guiding principles for ongoing governance of functional hierarchies and cost centers, later expanded to other dimensions such as profit centers and locations.- Established and chaired CCAR data governance council to address evolving data needs and regulatory requirements.Data Management- Enabled corporate FP&A, expense management and CCAR teams to spend time doing analysis rather than spreadsheet gymnastics by spearheading the build-out of a highly scalable application (CART SAIL) for development, consolidation, and reporting of budget, forecast, CCAR (stress testing), and granular functional expense management.- 10,000 times data volume increase and 40 times adoption in CART SAIL achieved by identifying and strategically deploying new functionalities and data structures with the most positive impact across operations and businesses.- Implemented advanced data management features, such as hierarchy-based security, gating, submission locking, change auditing, multi-dimensional mapping, on-the-fly FX conversion, and data replication.- Established automatic integration of “gold source” Master Data residing within the authoritative governance tool (SAP MDG) in downstream financial systems using RPA (Robotic Process Automation) tools

New York, Ny

Served as a subject matter expert in financial and management reporting, business intelligence, and data governance supporting FP&A, corporate and regulatory reporting, and the financial controls unit. Designed and delivered strategic long-term solutions for ad-hoc, self-service, and packaged reporting.Project Management- Strengthened usability and boosted user adoption by leading a major redesign of the Business Objects Universe in partnership with finance and technology.- Standardized and refined FX variance calculation rules across reporting platforms, developed and documented business requirements to support the new rules, and guided the development teams to successful implementation.- Allowed the CFO and the controller to monitor the monthly financial close process by building a QlikView dashboard with key metrics encompassing a full cycle of creating SQL scripts for fact data and dimension hierarchy extracts as well as designing the table structure, drill-down paths, and QlikView visualizations. Finance and Management Reporting - 2,000 finance community users served by leading a major redesign of Business Objects universe in partnership with finance and technology to build a report library relevant to most business groups and reporting objects reusable across reports and easily combined to customize presentations, all vast improvements in usability.- Built, automated, and maintained consolidated Citigroup financial reports on a management and external basis for monthly operating reviews, board of directors meetings, and press release publication.Financial Systems - 90% decrease in the new report production cycle by efficiently using Citilens, a custom application with Sybase as a back-end, database tools, and front-end reporting capabilities of Excel. - Created a prototype of an online management reporting system using OLAP tools (Pilot DSS and Essbase) later expanded into a full-fledged financial reporting system still used today.