Sunilkumar N Hassan (Sunny)
	Qualification: BS in Electronics Post Graduate Diploma in Computer Applications (P.G.D.C.A) ITI Computer Science Lotus Notes Professional, Principal CLP (Application Development), R5.x/R4.x CLP and R4.x CLP (System Administration) Skills: Lotus Notes Domino 5.x/ 4.6/ 4.5/ 4.1, Notes Pump (LEI) and DECS Lotus Notes Administration 4.x / 5.x ASP, SQL Server (DTS/Agents) Languages: Lotus Script 3.0, Java, Java Notes Classes, Turbo C, COBOL and Basic. Internet tools: Domino, ASP, HTML, XML, Java Script, and Lotus Bean machine Front End: Visual Basic 4.0, Visual FoxPro, FoxPro 2.5/2.6a, Clipper 5.2 Administration: Lotus Domino 4.61, Novell NetWare 3.11 / 3.12. Databases: FoxPro 2.5/2.6, Dbase IV, MS-Access and Oracle, MY SQL Platforms: Microsoft Windows, Linux, UNIX, Novell NetWare Ver. 3.11/3.12 and MS DOS. Exposure to: My-SQL, DB2, PERL and Oracle Hardware: Compaq Pentium, IBM Compatibles Experience: (11/92 – Till Date) SBC – South Western Bell Internet solutions (04/02 – Till date) Software: ASP, SQL, HTML, JavaScript, SQL DTS, SQL Agents Role: Programmer Analyst / Developer / QA/ Support Call ticker for Tier 1 Agents: This is a Call Tracker tool for all the call Support Tier 1 Agents. This will log the Type of call for different Regions and generate a daily Report in Excel Spread sheet form. Also View is available to see the details of Log online. SBCIS Support Contacts: Stores all the important employee Support contacts with a categorization of Department, Group Etc. built with a easy navigation for a quick lookup. SBCIS Feedback Center: This is a feedback tool for all the SBCIS tools. Users can submit different type of Feedback and the tool has a built in Workflow that will notify respective people/group depending on the nature of the Feedback. When the feedback is closed with a proper remedy, automatically the person who submitted the feedback will be notified via e-mail. SBC Yahoo Dial Call Tracker: This tool will allow Support Agents to log different types of calls that they come across. This tool has around 30 – 40 fields to gather and store Important details. Role: Programmer Analyst / Developer / QA/ Support SBC– Prodigy Communications Corporation (09/00 –03/01) Software: Lotus Notes/Domino 5.x, Lotus Script, HTML, CGI, JavaScript, DECS, MY SQL Role: Programmer Analyst / Developer / QA/ Support Migration of LN application to MY-SQL Migrated more than 2000 complex LN documents (each of them having more than 50 fields including few RICH text fields from 5 different databases) into MY-SQL database on LINUX server to be used by an application developed with PERL front-end. Customer Care Knowledge Base Repository Database This Database holds information pertinent to the business (ISP) conducted by Prodigy. It includes the Product, Account Management and Technical Support information needed by several call centers to support over 3M customers. It is comprised of six integrated databases on multi-server environment constantly updated through scheduled Replication with five levels of security based on individual and support site logins. Constantly being updated for enhancement. Product Initiation form (PIF) Browser enabled information tool, which maintains the product-level communication flow from Marketing to Customer Care Knowledge Base. It includes a complex workflow. Change Request and Suggestion Database Call center Agents and Representatives who works on the above applications can make a Suggestion or Change request that is flowed thro’ a series of workflow. Department Status Report Database (Internal) Weekly status report will be filled up each employee that gets routed to their managers and their managers. Training Database Computer Based Training Module for agents and representatives to train them for Prodigy Products. ABBOTT Laboratories (05/00 – 08/00) Software: Lotus Notes/Domino 4.x /5, Lotus Script, Notes Pump/LEI, DB2 and Oracle Role: Developer / QA/ Support Contribution: · Client Interaction / Requirement Analysis / Development / Testing / QA / Support Items of Interest Database All division Managers and their subordinates create “Item” document every month that gets rolled up automatically to their higher manager till it reaches Director. With facility for auto notify reminders… Decision Support Group Project Maintenance Database This Application allows the Decision Support group Employees to maintain their Projects details/ various Forms/ File Attachments. Involves Workflow and Document level Security. R5 Migration Testing / Assurance (On-going with all other development works) All 4.x software were tested and assured of working in R5. One that does not work, were modified to work. Pharmaceutical Products Division (PPD) Mail System Description: PPD Divisions Executives will be sending the mails to group of people based on certain criteria. For e.g. “All employees in Lake County”, or “All Employees in Building AP30”…. This Application will allow the user to generate the Group list based on Available data on the mainframe systems. The group generation can also be scheduled to regenerate every night/ or as desired, and allow the executives to create a mail and send it to all the employees in the group. ENRON CAPITOL TRADE (ECT) NTU Training Database (02/00 - 05/00) Software: Lotus Notes/Domino 4.6/5, Lotus Script, Lotus Bean machine, JavaScript and HTML Role: Programmer Analyst This is a browser-enabled registration application for the National Technological University program at ECT. Available for all the Houston based Enron business unit employees. An on-line video session will be available for a specified period of time for the Registered Student to access it on their desktop through this application. It has a build in workflow where the registration document flows from Student to his/her Manager and from Manager to Director for approvals and finally the Training Admin will receive it and enable the student(s) to view the class. Contribution: · Requirement Analysis / Drafting Estimates and Deployment Document / Development and unit testing. Enron Energy Services (05/99 - 02/00) Software: Lotus Notes/Domino 4.6/5, Lotus Script, JavaScript, Lotus Bean machine, HTML Role: Programmer Analyst Contribution: · Client Interaction / Requirement Analysis / Development and Testing / Drafting Estimates and Deployment Documents / Low Level Design specification The Enron Edge Enron Energy services Software: Lotus Notes/Domino 4.6/5, Lotus Script, JavaScript and HTML Role: Programmer Analyst Intranet site allows the Information Asset Protection group to help advertise their group and post information such as presentations, tools, policies, and links to other sites. Water Risk Management A survey Application used by a group of people. This involves workflow Automation. Safety Department Web Site Stores the general Information for the employees about the safety Awareness, Policies and procedures, forms for the Group to Fill up and Submit from various Locations. Stores information about the upcoming training Classes. People Profiles (EES Directory) Web Site EES Directory of all the people in Enron. User can request for a change in his/her profile. Option to attach his/her picture, Quick search for particular Person. Alphabetical View Templates list to give user-friendly navigation. Vision Site Main Home page of EES that provides the link to all other Intranet Application. The Front page is a Dynamic HTML page Generator that will be updated by the Site Admin on the Notes Client. To show events like New and Notables, Current News, Buzz, Accolades, EES Spotlight Etc. Tesco UK Project Tracking Database Internet Application, The Admin Group will create the Project task document and specify the Readers and Authors of that group. EB2 Database Internet Application, which is available for a group of People who are involved in Enron 2^nd Building Project. Project Group Members will be accessing this Database from different part of the world. Application is basically used as a discussion database and also used to get some project-related forms Approved by their managers. EFS Global Clients Database This is an Internet Application, which is available for the Enron Facility management users around the world. This gives all the required information about their customers IS&S Web Site This is an Intranet Application, which is available for the Enron users around the world. Application is used to get all the latest information about the department like Quick Reference, Technology Talk, Web links to other application and links to frequently used sites, Announcements, Feedback and Quick Search. Focus Software Inc. Supplier Help Desk (01/99 - 04/99) Software: Lotus Notes/Domino 4.6, Lotus Script, Lotus Bean machine, JavaScript and HTML Role: Programmer Analyst / Developer / QA This product is used by the company Suppliers, carries the information about the company products, product Designs and brochures, and all required application forms, for e.g. New Tender form, Order acceptance form, inquiry form, Etc. Contribution: · Client Interaction / Requirement Analysis / Drafting High Level and Low Level Design specification Document / Development and testing Lotus Notes Intranet Setup & Administration (7/98 - 05/99) Focus Software Inc Software: Lotus Notes/Domino 4.6a, Windows NT 4.0 Role: System Administrator Key points: ·Security and Access Level Planning and Management ·Design and Setup of Development Environment ·Trouble shooting client connectivity and access problems ·Periodic Domino Server Sizing - Evaluation ·Planning & Implementation of Internet Mail Setup ·Setup of document and discussion libraries ·Documenting and Updating Administration Task carried out on day-to-day basis. ·Backup Policy Implementation Sales Force Automation - Generic Product Development (6/98 - 12/98) Focus Software Inc. Software: Lotus Notes/Domino 4.6, Lotus Script Role: Programmer Analyst Generic system for organizing Sales & Marketing Information and automating workflow. Sales Forecasting, Sales Budgeting and Tracking, Inquiry processing, Quotation Management, Sales Order Processing, Contact Management and Sales Administration. Customized interface for updating the inventory from existing RDBMS. Contribution: ·Drafted Workflow for the Sales Administration and Inquiries modules. ·Drafted the High Level and Low Level design specifications for Sales Administration Module ·Development of Sales Administration Module ·Designed a standard form template to ensure common GUI across the modules ·Integration of Sales Administration module with other modules Sales Force Automation System (12/97 - 5/98) Phillip Morris Software: Lotus Notes/Domino 4.5/4.6, Lotus Script, Windows NT 4.0, JavaScript, HTML Role: Programmer Analyst The functional coverage of this application includes Inquiry processing, Quotation, Sales Process and Stores management. Stores management modules. Supports Mobile users. And hosted on multiple servers. Contribution ·System requirements analysis ·Development of design strategy and design specifications · Software development and testing Stores and Requisition modules · Verification & Validation of Sales Process modules Library Management System (8/97 - 11/97) Focus Software Inc. Software: Lotus Notes/Domino 4.1, Lotus Script Role: Programmer Analyst Description: This package is used for maintaining the information of software CD's, books and periodicals in an organization. Contribution: · Drafting workflow / Development and Implementation RPG Telecom Role: System Analyst/Programmer, Team Leader with one other programmer reporting to me. Contribution: · System Study and Design / Software development, Testing & Implementation. / Designed User Manual Gate Pass Monitoring System (1/97 - 7/97) Software: Lotus Notes 4.1, LotusScript Handling of RETURNABLE and NON-RETURNABLE items in the store thro’ Gate Passes. Rework Monitoring System (11/96 - 1/97) Software: Visual Basic 4.0 and MS-Access Tracking Telephone Cable Drums that are rejected and moved out of the circuit for rework. Scrap Management System (8/96 - 11/96) Software: Visual Basic 4.0 and Ms-Access Scrap Inventory, Scrap Buyers and Accounts Monitoring. Purchase Monitoring System (Multi User Application) (6/95 - 7/96) Software: FoxPro 2.6, Novell Network Material Indents / Purchase Order / Goods Received Note (GRN) Pay Roll System (1/95 - 5/95) Software: FoxPro 2.5, Novell Network Materials Planning System (10/94 - 12/94) Software: FoxPro 2.5, Novell Network Planning Statement for the manufacturing output. Vivek Hotels Inc. Designation: IT department Head Pay Roll System (8/93 - 09/94) Software: FoxPro 2.5, Novell Network Role: Designer and Programmer This Software is used to generate and print the monthly PAYROLL of all the employees. Contribution: · System Design / Programming, Testing & Implementation Implementation and Administration of Local Area Network (Novell 3.11) (5/93 - 8/94) Vivek Hotels Inc. Software: FoxPro 2.5, Novell Network Role: System Analyst Contribution: · Planning of Local Area Network / Installation and Administration of Local Area Network. Integrated Inventory and Billing Management System (11/92 - 5/93) MFL Inc. Software: Dbase IV Role: Programmer/ Analyst Contribution: · System Design / Programming, Testing & Implementation Sunny Hassan Austin, TX.