Software Engineering Experience

Krupp Asset Management (Financial Services / Real Estate)

Liaised between the business and technology teams to carry out strategic and operational assessment of business and information requirements, conduct feasibility assessment of IT infrastructure and data architecture capabilities, develop plans to move towards requirement-capability fit, and implement IT solutions for strategic and operational improvements.
Developed ETL procedures for automating data flows between property management application running on distributed computing platform (PCs, System/36) and G/L application running on mainframe platform (IBM).
Supported and enhanced user interface and reporting capabilities of commercial property management system for 15-20 users across four U.S. offices.

Defined user requirements, created logical design and supervised programming and implementation efforts for shareholder transaction reporting application.
Developed ETL procedure for automating data flow between external pricing service and internal securities price file to automate pricing update process.
Performed feasibility analysis, solicited and assessed vendor RFPs, and recommended vendor selection for an automated signature verification system for check-writing funds.
Managed and guided the efforts of office automation personnel who supported 300-350 users.

Restructured data architecture to support salesforce commission tracking and administration for transition to team-based salesforce organization.
Developed ETL procedures to explode bundled product codes into product components for loading into data warehouse, and set up views to support routine reporting requirements.
Worked with marketing and sales managers to define ad hoc reporting needs, and provided advisory and training services to business managers on 4GL report generator app run on flat (data) files.
Conducted requirement specifications, programming and implementation of data entry module for the corporate budgeting system.