PROFILE

Systems/Business Analyst who manages/leads and also gathers requirements, solves problems as well as analyzes, designs, tests, integrates and manages business software development that meets the complex needs of today\'s multi-tiered business computing/financial environments. Expert in Excel, Access, VBA and SQL (utilizing SQL Server and Oracle) data sources included Factset, Bloomberg, Micropal and Polypaths.

Programming Languages: VBA, Rexx, COBOL, SQL, PL/1, Easytrieve Plus, Basic, DTL, JCL
Applications Software: Excel, DtSearch, UNIX, Sharepoint, Crystal Reports, Visual Basic, Application Systems (AS), KBMS, CMMouse, ISPF Dialog Manager, TSO ISPF, Btrieve, SAS, WordPerfect, Microsoft Office (Word, PowerPoint), Project Workbench, Lotus 123
Relational Database Management Systems: SQL Server, Access, Oracle, Visual FoxPro and Sybase
Computer Systems: IBM PCs, RISC 6000 UNIX, IBM 4341/3090 (VM/CMS, MVS/TSO, DOS/VSE), VAX 11/780 VMS

Consulting Assignments

2006 to present

Confidential,Automated, and documented Trade Capture System for MBS/ABS and also enhanced to provide current status. Used SQL Server, Excel and VBA for automation and to maintain current model.
Created utilities in Excel/VBA and Batchcal for Brokers requiring integration of data from Polypaths, Bloomberg and other internal and external sources.
Automated reporting and data analysis of Close of Business Data System for easy tracking and reporting using SQL Server, Excel/VBA. Created views/triggers on SQL Server to speed process.
Updated, modified and documented BearXplorer modules using Excel, VBA, Access, SQL and R.
Automated loading and testing using VBA and Access for TrendsXplorer (isolate security exposure to economic factors) and SigmaXplorer (identify dislocation between long and short term trends).
Gathered requirements, modeled and automated HSBC and MSCI data feeds. Standardized on business objects, reformatted using VBA and SQL for loading into Cognos (SQL Server based business intelligence system). Used SharePoint for data sharing and discrepancy discussions.
Monitored financial data, streamlined and automated business processes to provide timely and accurate information using Excel/VBA and SQL.
Reconciled profit and loss data received from front and back office. Automated processes for efficient processing and investigated any discrepancies to meet aggressive auditing standards using Excel/VBA and SQL.
Forensics, data mining, analysis and internal corporate investigations, electronic discovery to meet needs of Compliance and Legal department using Orchestria and queries in DtSearch.
Evaluated and compared processes involved in investigations using Unix with Cygwin and other corporate approved utilities. Automated processes using VBA and Unix.
Monitored and administered Orchestria to facilitate smooth daily operations.

Confidential,Legg Mason, New York

2003 to 2006

Assistant Vice President/Systems Analyst
Created over 130 analytical reports of CAM equity products for Senior Management including Portfolio Managers and Board members and also for comparisons and analysis. Used Factset/Micropal/Morningstar/Bloomberg/Lana and Lipper data with Excel/VBA and SQL.
Monitored and evaluated the performance (based on a variety of dimensions) of the firm’s mutual fund and managed discretionary account products sold worldwide using Excel/VBA.
Produced dashboards for senior management to assess business risk associated with aggregate equity holdings for managed separate accounts using Excel/VBA and SQL.
Produced attribution and characteristics reports for separately managed equity strategies and completed periodic assessments of the competitiveness of the firm’s product line.
Researched discrepancies in weekly and monthly private client analytics to ensure accuracy and consistency and to assist in meeting the fiduciary oversight responsibilities.
Gathered requirements, developed and refined criteria to assess performance, in absolute, versus benchmark and against relevant peer groups using Excel/VBA and SQL.
Created analytical tools and systems to undertake appraisals using Excel/VBA and SQL.
Identified products requiring more in depth scrutiny or corrective action.
Actively participated in regular forums to discuss product performance and in resolving any issues.
Assisted in analysis and positioning of CAM products and strategies for successful position of firm offerings vis-à-vis competitors’ products. Used Oracle based GPW for data verification and analysis.
Collaborated in the evaluation and appraisal of new product concepts, particularly from the standpoint of investment feasibility as well as preparing periodic assessments of trends in the retail asset management business. This included requirements analysis to delivering final product.

Consulting Assignments

1995 to 2003

Confidential,Gathered requirements, formulated detailed business functional requirements, designed analyzed, coded and modified single and multi-user systems using Excel/Access/VBA with various back-ends including Oracle, Sybase and SQL server. Tested using Winrunner. Functionality included:

• Tracking controlled drugs to meet 21 CFR standards (Federal requirements).
• Created reports in Excel, Access and Crystal Reports that were transmitted to end-users or made available on the web. Created utilities that allowed web updates.
• Documented systems for coders and end-users. Used standard or client methodology (Polaris).
• Data mining and auditing DB2/Oracle/SQL data with aggressive time limits.
• Data Entry and Order Entry system, storing, tracking and transmitting information.
• Sales with multi aspect discount structure.
• Scheduling, project/resource/issue tracking.

Converted Access 2/ Paradox programs to Access 97/XP and trained users.
Used Easytrieve plus and COBOL for enhancements and to produce stored procedures and reports for data modification and verification as part of the Eclipse modification team. Stored procedures are called by Java code to retrieve data and improve performance.
Used VBA to automate some of the mechanical tasks performed in PowerPoint, Excel and Word. PowerPoint tasks included opening a presentation, template setup and slide formatting.
Tracked and charted progress using Pert/Gantt charts.
Managed programmers through the entire development process.

Confidential,Toronto

1989 to 1995

• Associate Office Systems Consultant

Gathered requirements, coded and modified the Daily Sales package in COBOL, Rexx, Xedit and Easytrieve Plus. Enhancements included incorporating weather information to see impact on sales.
Created, modified and supported KBMS (rules based - Knowledge Based Management System), Intellect (Artificial Intelligence), Rexx and CMMouse applications.
Created a conferencing application and a survey facility using Rexx and ISPF.
Handled client questions as a member of the Help Desk team.
Supported the Project Management System (Project Workbench) using SDLC - DMR P+ technology.
Created front-end panels using ISPF Dialog Manager, Rexx, DTL and Xedit for PROFS.
Trained the Help Desk support group in application-oriented programs involving Sears’s proprietary and commercial application software.

Confidential,Toronto

1988 to 1989

• Programmer Analyst

Modified and coded programs in COBOL and Easytrieve Plus for data extraction to be used in direct mail and also to create business phone directories.

Confidential,Toronto

1988

• Programmer/Analyst Trainee

Installed and instructed on using Project Management System written in Application Systems (AS).
Modified the AS code to meet user requirements such as to support a multiple user environment.

Confidential,Toronto

1984 to 1987

• Programmer

Gathered requirements, analyzed to formulate detailed business and functional specifications, designed, coded and implemented packages for costing and quotations.

Master of Business Administration.