SUMMARY:

• IT Business Analysis, Client Relationship Cultivation, SDLC, Product Integration, Innovative Problem - Solving, Visio, PowerPoint, Waterfall, Agile, SqlServer, MsAccess, Excel, Scrum, Solutions Architect, P&L, Budget, Product Roadmaps, Citrix, Project Management, EDI, Team Foundation Server
• Application Design, Staff Retention, Collaboration, Application Change Management, Product Management, Vendor Management, Application Integration, Legacy Application Upgrade, Enterprise Application Deployment, Pension Actuarial, Analysis, Data Transformation, Metadata Rules,, Pen Testing, Quantitative Risk Management (QRM), Relational Database Programming/Design, SaaS, Risk Mitigation

PROFESSIONAL EXPERIENCE:

Scrum Developer

Confidential

Responsibilities:

• Exceptional leader of large-scale teams, emphasizing cross-departmental, cross-functional collaboration in a team-focused environment for greater productivity;
• Able to improvise in order to create insightful solutions to often-complex problems or issues;
• Easily interacts with non-IT-centric business professionals, quantitative mathematicians and actuarial professionals;
• Sociable. Comfortable working with C-Level management, business partners, clients, peers and subordinates;
• Cultivates solid, lasting client relationships and vendor strategic partnerships based upon trust and industry expertise;
• Easily identifies areas requiring improvement, proactively making corrections to designs to eliminate obsolescence;
• Ensures quality performance/products and ensures optimal product success within set budgets and timelines;
• Consistently exceeds established goals and objectives through insightful strategic initiatives to integrate emerging technology for greater product relevance, operational efficiency and profitability.

Confidential

Vice President, Senior Treasury Systems IT Business Analyst

Responsibilities:

• Designed, managed, and implemented a $3.8 Million third-party enterprise quantitative software leasing and hardware purchase initiative from initial purchase to installation to current state;
• Utilized Visio and PowerPoint for presentations to C-Level Management;
• Managed full project documentation (e.g. SOW, SRD, BRD, gap analysis, storyboards, technical docs);
• Responsible for the technical configuration and implementation of the QRM Risk Framework application;
• Collected data from 18 SqlServer data sources, performed interim calculations and created new data structures within databases for further use by the quantitative analysts for risk management calculations;
• Managed/coordinated the activities of CIT technology resources assigned to this initiative, as well as manage the vendor’s technology resources involved with the implementation,
• Coordinate and manage the application vendor and various internal technology groups to resolve issues identified by Treasury Risk Management with the implementation and use of the application,
• Interface with Treasury Risk Management to define application data requirements and design/develop solutions for delivering the data;
• Increased the depth of IT thought leadership and IT application knowledge for the firm at a senior level;
• Drove and lead the delivery of disparate enterprise technology projects for the IT Department;
• Evaluated and recommended opportunities in the area of technology direction;
• Identified, evaluated and presented new business/technical opportunities to senior management for project approval;
• Assessed how existing & emerging solutions could make Treasury customers more effective and work more efficiently;
• Understood the Treasury business and advised them on solutions that applied to their needs;
• Supported, as required, capacity planning and disaster recovery to ensure sufficient resources to meet business requirements;
• Provided advice to customers regarding industry best practices and process methodology;
• Proactively reach out to Treasury to ensure that IT and Treasury are aligned regarding the IT project portfolio and business requests for solutions requiring technology.

Confidential

Senior Programmer and Senior IT Business Analyst

Responsibilities:

• ATM cash handling and tracking application
• Construction database estimating application
• CRM database marketing application
• Garment database system full manufacturing life cycle: ordering, overseas manufacturing, container tracking, stateside inventory, factoring cost tracking, store delivery & billing
• Machine-to-machine control
• Outplacement firm client data recordkeeping
• Parts Assembly & Costing Application
• Pension data recordkeeping and valuations
• Pension recordkeeping for international union
• Purchase order & tracking for nursing home chain
• Tracking of human parts for a medical tissue bank

Confidential

Programmer/Analyst

Responsibilities:

• Data mining - corporate warehouse databases (Access, Excel, SqlServer, Siebel, CICS and other data repositories) seeking actual sales that did not generate commissions payable to the sales staff;
• Sales Tracking - client-server application tool written in Access that was scalable to SqlServer;
• Commission calculations - client-server application tool written in Access that was scalable to SqlServer;
• Identified the database design flaws and recommended/implemented changes;
• Identified the work processes that generated data mismanagement and recommended changes;
• Improved data integrity validation processes, data storage policies and data-acquisition processes.

Confidential

Programmer/Analyst

Responsibilities:

• Converted an Excel-based, legacy employee compensation incentive application to a client-server Microsoft Access database application using heavy VBA and SqlServer as the database;
• Designed new Microsoft Access relational database tables by combining Microsoft Excel spreadsheets from every department into an Access database for data evaluation and preparation;
• Created a user-defined, Access interface in order to import spreadsheets on demand, regardless of the spreadsheet format or location;
• Included user-created Microsoft Word documents within the Access application so that the user could generate an unlimited number of custom mail merge documents with the Access data tables;
• Created a user-defined, rules-based application in Access that would permit the HR user to dynamically-establish rules for each compensation payment type (about 50 rules initially);
• Created an Access application that would seamlessly combine all possible compensation components into a single letter template, based upon dynamically-changing user-defined rules (metadata);
• Created “canned” reports and an Access interface for dynamic, user-defined ah-hoc reports;
• Wrote an 89-page user manual.

Confidential

Programmer/ Analyst

Responsibilities:

• Converted a legacy mainframe billing application to a Microsoft Access/VBA client-server application;
• Designed relational database tables;
• Mined corporate mainframe, SqlServer and Oracle databases and tables;
• Imported mainframe data, SqlServer and Oracle data into Access tables;
• Generated management reports and client invoices.

Confidential

Programmer/ Analyst

Responsibilities:

• Utilized SqlServer database tables to create five Microsoft Access/VBA applications: Property Lease Management, Bonds Management, Memorandum of Lease, Rent Reduction and Lease Termination;
• Generated management reports within each application;
• Developed an Access user interface for dynamically-created, user-defined reports.

Confidential

Programmer/ Analyst

Responsibilities:

• Created the following Microsoft Access/VBA client-server applications:
• Sales Order Acquisition;
• Sales Quote Application;
• Instrument Configuration Application (for manufacturing use and pricing);
• Created a dynamic rules-based application that can change the programming logic;
• Assisted the user in costing very complex electric power instruments by assuring that the selection of various options had generated the correct components (based-upon the dynamically-defined rules), eliminated flawed device configurations and eliminated pricing errors;
• Created a manufacturing bill-of-materials based upon the configuration of the device defined by the salesperson at the time of the sales quote;
• Created attractive and consistent sales quotations for email or postal mail delivery;
• Created “canned” reports and an Access interface for dynamic, user-defined ah-hoc reports.

Confidential

Programmer/ Analyst

Responsibilities:

• Created a client-server Press Release application in Microsoft Access/VBA that increased the quantity of customized press releases based upon the product (with pictures);
• Press Releases were sent to targeted periodicals via postal mail and/or email;
• Created a user-controlled, dynamic, rules-based (metadata) application that permits the user change the programming logic and measurement parameters;
• Created the ability of the users to dynamically generate custom Excel spreadsheets showing selected data within the Access database tables and defining the colors of each cell in the spreadsheet;
• Created a user interface to import data from spreadsheets or from trade-show registration data;
• Ability to identify where a media contact was developed (e.g. trade show), send a letter to thank them for visiting at the trade show and to identify trade shows that a publication company had attended;
• Created management reports that tracked press release penetration;
• Created “canned” reports and an Access interface for dynamic, user-defined ah-hoc reports.

Confidential

Programmer/ Analyst

Responsibilities:

• Created a client database in Microsoft Access/VBA consisting of “A” list celebrities;
• Created a history of invitations, responses and Identified types of events favored by “A” list candidates;
• Established metrics to identify the social ps of celebrities in order to avoid personality problems when seating invitees (personal likes and dislikes, former spouses/significant others, etc.);
• Created “canned” reports and an Access interface for dynamic, user-defined ah-hoc reports.

Confidential

Programmer/ Analyst

Responsibilities:

• Created a client-server Professor and Course Evaluation application in Microsoft Access in order to measure effectiveness of the courses and the professors;
• Created a Bounded Influence Estimator on-line statistical calculator using VBA;
• Utilized a form-scanning data input device to import questionnaires for evaluation;
• Wrote an applet in Access to validate the scanned data for accuracy and reasonability;
• Created a user-controlled, dynamic, rules-based application that permits the user change the programming logic and measurement parameters.

Confidential

Materials Handling Equipment Manufacturer

Responsibilities:

• Created the following Microsoft Access/VBA client-server applications:
• Sales Orders;
• Engineering Department Manufacturing Internal Cost Quotation;
• Manufacturing Bill of Materials.
• Created a dynamic rules-based application that can change the programming logic;
• Assisted the salespersons in acquiring specifics for custom designing, engineering, manufacturing and integrating horizontal carousels for material handling by assuring that the selection of various options had generated the correct components (based-upon the dynamically-defined rules), eliminated inaccurate carousel configurations and eliminated internal pricing errors;
• Created “canned” reports and an Access interface for dynamic, user-defined ah-hoc reports.

Confidential

Industrial Machinery Manufacturer

Responsibilities:

• Created a sales leads and tracking application in Microsoft Access/VBA;
• Generated leads based upon Dun and Bradstreet-provided data;
• Tracked sales leads and sales follow-up activities;
• Monitored the sales lifecycle from lead to closed sales;
• Identified trends in various SRDS, NAICS and SIC groups;
• Established metrics to identify efficient use of sales resources;
• Created “canned” reports and an Access interface for dynamic, user-defined ah-hoc reports.

Confidential

Programmer/ Analyst

Responsibilities:

• Created Behavioral Health hospital admissions application in Microsoft Access/VBA & SqlServer;
• Designed and programmed of the following hospital modules: