Team Lead /IT Project Manager
Brookfield Office Properties
Total des années d'expérience :23 years, 1 Mois
Responsibilities include managing the company’s Real Estate Property Accounting and Asset Management applications portfolio with a net worth of $50M.
Worked as the Technical Project Manager for IBM iSeries OS V5 R4 to V7.1 operating system migration. Coordinated testing with employees at various locations around the country and US. Tracked and reported progress to stakeholders.
Designed and built cloud service models for SAAS applications including its interfaces with AS/400 - CTI (Yardi).
Company-wide implementation of Sage FA (SAAS) environment & Salesforce (SAAS) environment
Configuration and implementation of MS Azure environment for Brookfield Properties
Design, Configuration and implementation of Web API’s between Workday, Salesforce and Sage FA with CTI
Design and configuration of data warehouse and data marts.
Vendor Management: Business cases, RFP, Bidding process, RFP responses, vendor evaluation criteria, vendor evaluation, contract negotiation, Budget allocation and Budget monitoring.
Managed and provided direction for 15 technical 5 onshore (Toronto) 10 offshore (India) direct reports regarding everyday operational activities and possible issues, including Resource Optimization, Resource Management and Resource Leveling.
Conducted multiple training sessions to End Users, Business Technology Analysts (BTA) and Business Analyst (BA)
Integration & amalgamation of newly acquired business entity Rouse properties’s 30+ applications stack to Brookfield environment. Project cost was $1.2M with a duration of 8 months
Requirement Gathering, elicitation /Kaizen workshop and confirming requirements from stakeholders
Understand business requirements and apply technical background/understanding in the development of PMO artifacts (e.g. Cost benefit Analysis, Business Case, System Requirements Specification (SRS), high level requirements documents, detailed requirements documents (BRD), reporting specifications, Weekly /Monthly Status reports etc).
Executed > 10 Lean and Just-Do-it (JDIs) projects with combined saving in excess of $250, 000 per year.
Administration /support and upgrades of CTI (Yardi) /AS400, Clarity, Basware P2P and MS SQL servers.
Managed the technology team and systems during the production integration for Brookfield AS/400 - CTI (Yardi) with Rouse Properties AS/400 - JD Edwards - AR, AP, GL, FX, FR and JC modules
Setup automated EFT /ACH transfer interfaces between AS400 and banks for various Brookfield's accounts in CIBC, RBC, JP Morgan, US Bancorp and BMO banks
Design, Configuration and Implementation of ARGUS DCF environment for property valuation
Deployment, Configuration and Updates of reports packages in SQL Server using SSRS & BIDS.
Designing and Deployment of Reports for the End-User requests using Web Interface & SSRS.
Involved in Huge data migrations, transfers using utilities like Data Transformation Services (DTS), and SSIS, Bulk Copy Program (BCP) and Bulk Insert.
Modifying /creating and implementing custom Stored Procedures, Triggers and Cursors using SQL Server 2005/2000/7/8 for various business requirements and / or initiatives.
Performed Database Refresh tasks from production to Development and Staging Servers
Analyzed and validated the business needs of project stakeholders as well as perform impact analysis of changes to an application.
Developing metrics and Key Performance Indicators (KPI) to support the management of business processes and outcomes, particularly as related to finance
Conducted JAD sessions with developers, Unit testing, QA /Use Case /Testing, test case and test plans and UAT with end users in design and implementation of various business applications
Developed work-flow charts and diagrams (DFD, ERD, State) to ensure production team understanding and compliance with client deadlines.
Proven track record of consistently meeting deadlines and requirements for all projects.
Managed creative projects from concept to completion while managing external vendors
Responsibilities include business process/systems reengineering; research and implementation of financial systems upgrade projects, financial Analysis, and including
financial reporting for Finance department.
System /Database administration
Conducted multiple upgrades of AS/400 - CTI and MS SQL databases
Performed upgrade /testing of Jacada servers and AS/400 server.
Add /Delete /Modify user accounts
Add /Delete /Modify user /system profiles
Add /Delete /Modify of Windows AD groups
Provisioning of various access profiles, e.g., FTP etc
Setup printers, job queues, validations, various configurations for the ERP system.
Setting up CTI /AS400 automated jobs for various business requirements/ initiatives.
Add /Delete /Modify of job scripts /stored procedures on SQL server
System Maintenance and upgrade of CTI /AS400 and MS SQL Server 2005.
Re-design & implementation of company-wide Capital Expenditure process. Implemented a new model that resulted saving business 1 month of effort in the overall process
Designed Overhead report processes for management on Business Objects which saved the company 5 days of processing time
Automated 100+ financial reports on Leasing Stats, Occupancy Stats, Rent Roll, Tenant Deposits and Inducement and Recoveries.
Leasing analysis, variance analysis, Trend analysis and making recommendations to management on the basis of those analysis
Worked with internal auditors to design database application and processes for auditing purposes
User requirement gathering, analysis, documentation and application/database Software design, development & implementation of various small to medium sized projects
Facilitated JAD sessions with business users and technical representatives to determine and generate functional solutions
Successful design, development, and implementation of company-wide Capital Expenditure process/system
Managed a technology upgrade project, design, and implementation a new Budgeting System on VB .NET platform. Migrated from flat file system to RDBMS platform.
Responsibilities include business process/systems reengineering; research and implementation of financial systems upgrade projects, financial analysis, and including
financial reporting for Licensing and Underwriting department.
System /Database administration
Add /Delete /Modify user accounts
Add /Delete /Modify user /system profiles (Windows)
Add /Delete /Modify of Windows AD groups
Add /Delete /Modify of job scripts /stored procedures on SQL server
System Maintenance and upgrade of MS SQL Server.
Worked as a liaison between IS and Finance department decreasing the time required for automation of management information systems
Recommendation, design and implementation of various initiatives to automate Month-end /Quarter-end /Year-end reporting process.
Received an award for successfully completing company-wide PeopleSoft/Oracle Financials implementation
Designed/enhanced various weekly/monthly/quarterly/yearly reports for management
Performed Variance analysis, Trend analysis, Cost vs. Budget analysis, and Revenue and Expense analysis, Inflation vs. cost analysis, KPI analysis, and internal
audits.
Reduced month-end accounting processes from 15 days to 5 days. Received financial reward /commendation
Created Test Plan, and test scripts and conducted UAT sessions on multiple implementations
Designed templates to performed fees sensitivity analysis on various initiatives.
Responsibilities include analysis and automation of financial systems processes, and including financial analysis for financial reporting.
Saved the company $ 50K by designing a database on MS Access which would feed directly to their ERP system to help in the year-end budgeting process
Designed “Vendor Management” database in MS Access, to track vendor expense
Designed and implemented Revenue Reconciliation process
Prepared Statement of Revenue and Expenses, Fee Review Process, Cost Analysis, Revenue and Expense Analysis, Inflation vs. Cost Analysis, Cost allocation and apportionment, systems analysis and design, data mining and data integrity testing
Responsibilities include analysis and automation of financial systems for a merger into CI Mutual Funds systems, and also included financial analysis for financial
reporting.
Designed MS Access database to automate the reconciliation of Client balance and Supplier balance accounts on a trade date and settlement date basis.
Wrote various SQL scripts to automate the migration of their ERP system from a legacy system to Oracle.
GL account analysis of Operating Suspense, General Suspense, Client Settlement, Supplier Settlement, and Net Settlement accounts, Unbalanced GL entries Analysis,
Commission Expense, Commission Receivable/Payable Analysis, Operating Bank reconciliation
Analysis of Adjusted Trial Balance, including posting correction journal entries to production system
Prepared month-end reports for auditors
Regression Testing of Oracle database
Assisted in year-end Audit of their system
Responsibilities include business process/systems reengineering, research and implementation of financial systems/applications developments/upgrade projects, and including financial reporting for Cash Treasury department.
System /Database administration
Add /Delete /Modify user accounts
Add /Delete /Modify user /system profiles
Add /Delete /Modify of job scripts /stored procedures on SQL server
Setup printers, job queues, validations, various configurations for the AS /400 ERP system.
Add /Delete /Modify of job scripts /stored procedures on SQL server
System Maintenance and upgrade of JDE /AS400 and Sybase SQL Server.
Configuration, setup and maintenance of MS IIS server
Setting up JDE /AS400 automated jobs for various business requirements/ initiatives.
Created a customized Windows NT environment for all Salon Treasury users.
Developed and conducted application testing for various initiatives
Prepared specifications and project plan for enhancements and problem resolutions
Analyze gross profit, accounts receivable, accounts payable and inventory
Prepare quarterly earnings and expense reports for Finance
Prepared financial statements, and provided financial and cost/benefit analysis on projects
Prepared government regulatory reports, prepared working papers, account analyses, and accounts reconciliation
Developed standards to measure ongoing activities and monitor internal control procedures
Designed management reports for cost control and profit analysis
Analyzed information systems, recommending improvements
Worked with management in the development and updating of the business plan
Conducted JAD sessions and UAT for various applications created for business process improvement
Enhanced the legacy accruals process to help Finance for the month-end accruals process
Implemented Weiland Financial software and saved $1.5 million of bank charges for the company
3.65 Out of 4.0 Cumulative GPA