Resume 15

• Business Analyst for over 8 years--for a internet Wired & Wireless web portal development project and for a client server development project;
• Project Coordinator for two years in a project office;
• Support Engineer for two years in client support environments
• Business Analysis & Design and documentation; Project Liaison, Tracking & Reporting and Documentation
• Release Management, Product Development
  • Hands on Oracle / Excel VBA skills / SQL development skills
  • MBA - Information Systems

Project: Track, reconcile the transfer of a small group of Customers and Accounts from Middle Market systems to Small Business Financial Services due to the recent Business Realignment of 3-10MM Middle Market MM customers to Small Business Financial Services SBFS and facilitate information thereof to departmental needs. Reported to VP / Project Manager, Customer Value Management.

• Analyze and facilitate retrieval of MM-to-SBFS customers information from CAPRS / CMIP / IDB
• Report on pertinent information from the above systems for Sales & Marketing and Customer Management requirements throughout the project and for the cut over to SBFS production systems.

Project Executive View-EV : Secured Internet portal www.executiveview.somewhere.com design, development & implementation for top-tier investment banking clientele. Liaison between business, development and content provider teams. Reported to VP / Relationship Manager, Client Coverage / M & A Technology.

• Brainstorm new content requirements with the product development business team--Reuter s Market Data Stock / Fund / Indices / FX Spots & Cross Rates / LIBOR / Treasury , Tradeline Historical Charts Stock / Index / Fund , Dow Jones News Factiva Industry News / DJ Web Plus - Newswire / AFX news , Global Investor News, Fixed Income Economic & Other Research, Equity Research, Fixed Income High-Yield and High-Grade Bond Data, Commercial Paper, Money Market Funds, JP Morgan Multi-media and others--and integrate into requirements gathering.
• Assist in prototype development requiring consistency in pre-established GUI design and navigation rules
• Evaluate technical interface requirements XML / SQL / HTML with content providers
• Conduct data analysis for functional variances, exceptions and processing rules
• Responsible for Functional Specifications Document and signoff for all scheduled requirement deliverables

• Brainstorm content requirements and conduct data / chart requirement analysis with the business team for the wireless delivery of wired-site contents palatable for Palm / RIM platforms.
• Draft display page design and navigation rules for Palm / RIM delivery based on PDA / Browser characteristics and constraints
• Assist vendors in Information Architecture Diagram / Design Specifications requiring consistency in pre-established GUI design and navigation rules
• Assist in preparation of Statement of Work SOW for the wireless program
• Assist EV development team to draft rules for XML schemas for interfacing with Mobile Web Server

• Conduct Technical Reviews with the development team
• Review and assist in development of Use Cases
• Provide clarifications to the development team throughout the development process
• Conduct unit testing at the desktop environment, log results and sign-off
• Conduct integration and regression testing in the development environment, log results and sign-off
• Coordinate UAT user acceptance / QA testing and Production Verification sign-off

• Managed development for two critical releases end-to-end from requirements to production deployment
• Provided daily reporting on development desktop & integrated status
• Provide daily reporting on testing desktop, integrated, UAT, QA statuses and sign-off for the entire period of these two releases
• Check spec sufficiency and approve on defects, enhancements prior to packaging for each of the releases

Project: Project office coordination for tracking compliance, certification and independent validation & verification statuses for the entire ESS suite of applications, Y2K coordination. Reported to VP / Project Office Manager, Enterprise System Solutions Project Office.

• Responsible for a team of 3 staff members throughout the project for monthly activity reporting.
• Responsible for coordinating the project plans, development, maintenance, documentation and implementation of an MS-Access based Interface Tracking System ITS . Developed an automated process for Enterprise Project Office EPO reporting needs using feeds from other project offices. Responsible for enhancements and periodic / ad hoc reporting. Developed ITS-Web prototype for the use of future corporate initiatives. Coordinated communication efforts for the project office. Tracked various project milestones. Developed reports to track signoff requirements & statuses from 3rd qtr of 98 to 2nd qtr of 99 for senior management.
• Responsible for liaison with vendors / department coordinators for status tracking, vendor findings and cost reporting throughout the Independent Validation & Verification IV&V process from 2nd qtr to 3rd qtr of 99.
• Helped in the conversion and trouble-shooting five different MS-Access 2.0 HR/Payroll applications into MS-Access 97. Helped in the re-design and enhancements to Leave of Absence and Retiree Billing Systems.
• Facilitated closure of the ESS project office with document retention, archiving procedures and activities.

Project: Process redesign, prototype and full life cycle development of a document automation system from initiation to implementation for "Business Financial Planner" BFP product--using VB and MS-Office suite with NT client GUI and Sun / Oracle server. Reported to Director, Product Development-BFP.

• Responsible for a team of 3 developers throughout the project for activity reporting.
• Coordinated the project--requirements gathering from product development group, scheduling quarterly releases, development efforts with other consultants, implementation efforts and user training--in a project lead position.

• Brainstormed financial planner requirements, workflow and business decision rules involving various financial planning product recommendations for Cash Management, Financing, Asset Allocation, Insurance Planning, Retirement Planning, Succession Planning, Deferred Compensation, and Estate Planning.
• Brainstormed workflow processes for efficiency and map data dependencies from data entry to production output.
• Analyzed requirements of historical review and five years projections of the clients financials using contemporary, flexible financial forecasting methods and business valuation practices.
• Systems analysis and design involve normalizing client profile data and templating various line items of client financials--Income Statement, Balance Sheet and Cash Flow Statement--into appropriate table spaces / schema.
• Translated financial forecast / business rules to detailed specifications and maintenance of such documents.
• Established structure and conventions for varied application architectural components--production Excel .XLS, Word .DOT, .INI files and stored procedures for business rules.
• Developed a prototype design for a client / server model, data modeling for Oracle database and document automation system using Excel/Word. Evaluated client/server architectural components.
• Documented BFP-wide functional, operational workflow and financial forecasting design specifications.
• Developed an Intranet Web Server for User Support and System-wide documentation. Hands-on Development Oracle DBA & VBA Programming role:
• Performed the role of Oracle DBA in the development environment throughout the project. Upgraded Oracle, designed table spaces, administered and periodically reviewed BFP database. Wrote stored procedures for business rules of financial products and recommendations.
• Designed and developed the backend modules using MS-Excel / VBA / MS-Word / WordBasic for document automation.
• Developed operational / business results reporting and implemented FTP for data warehousing needs. Prepared sample plans and participated in Unit Testing major releases.

• Supported--full time--production environment in a lead position to over 40 users and trouble log coordination.
• Configured Client PC / NT setups and actively worked on upgrades of various PC components.
• Provided for DBA support for a period of three years until production systems took over.
• Supported User Acceptance Testing for major releases. Liaison with other systems personnel for interface and reporting needs.

• Requirement analysis, budgeting, procurement and implementation for local area networking of the Computer Center - Fall 90, the School of Education - Spring 91 and the School of Business - Spring 93.

• Requirements analysis and development of SFT III on Novell NetWare and Fault Control System for Dept. of Communications-a transaction processing system to facilitate MIS reports.
• Undertook feasibility studies and coordinated development for Customer Service and Excise applications.
• Undertook feasibility studies for JIPMER Hospital, various departments of the Government of Pondicherry and a publication company.

• Implemented PC-Banking Software--checking account, savings account--at various State Bank of India and State Bank of Travancore branch offices on behalf of the company. Undertook training.

• Developed Payroll application using Cobol on a mini-computer. Maintained Inventory, Warehouse and Production Control & Product Costing applications as a member of the EDP team.

• Oracle, ODBC, SQL
• Net, Report Writer, GQL, DbArtisan ERWIN-like , DbStudio
• MS-Access, Excel-VBA/WordBasic, HTML, SQL, PL/SQL, MF-COBOL, MS-Access/VBA Basic
• MS-Project, MS-Word/Excel/PowerPoint, MS-Publisher, Lotus Notes, VISIO
• FrontPage 98, HTML, XML
• Windows / NT, Sun Solaris, Novell NetWare

Hand-on skills

Windows / VB / MS-Word VBA / MS-Excel VBA / MS-Access / Oracle ODBC - client; Sun OS / Oracle 7.3.2 - server Oracle - Development DBA / Stored procedures / Install / Upgrade / Cron jobs / backup / restore etc, Oracle administration tools used: dbArtisan / Oracle Enterprise Manager, MS-Word / MS-Excel VBA - based application development using Word / Excel templates, Windows tools - PC-NFS, ODBC manager, SQL*Net, SQL*Plus

MS-Access 97 based development and upgrading older applications to MS-Access 97, Lotus Notes MS - Access - based application development using Word / Excel templates

Websphere 3.4, Netscape Application Server, Sun Servers, IE / Netscape client browser, Oracle databases, XML interfaces to external data-providers, Java, JSP, Servlets / Beans, HTML, and XML, Oracle SQL, HTML, XML data types, formatting, data modeling, data mapping