Highly accomplishment business/systems analyst with demonstrated success as a project manager in creating, implementing and managing system solutions from conception to implementation. Special expertise lies in problem solving, workflow systems analysis, procedures redesign and user training. Excellent analytical, communication and interpersonal skills. I have a working knowledge of the following operational systems: UNIX, ORACLE, NT and PC based.
PROFESSIONAL EXPERIENCE
***employerName1***
TECHNICAL/LEAD/ANALYST
1983 - 2000
COBRA PROJECT
As a Data Architect I analyzed, developed, tested and maintained logical system design specification and functional data models for a new ***employerName1*** Special Services Billing System.
Performed system design specification to clarify, refine, and revise system requirements.
Reduced company costs by a half million dollars by mechanizing several manual processes.
Engineered and implemented a process that enabled the Billing Control Office to create bills to address specific customer requirements.
IMPLEMENTION OF CONSUMER LOCAL SERVICE PROJECT
Architected the implementation of local service, process improvements and service introduction.
Partnered with a team to develop the architectural procedures and policies required to implement ***employerName1*** local service for the state of New York.
Researched and developed system solutions for incorporating governmental regulation impacting internal systems.
Coordinated and guided a team in planing and implementing system enhancements to meet customers request for change.
Consulted with and advised project managers in the review, preparation and modification of time and cost estimates for projects.
BILLING PROMOTIONS IMPLEMENTATION PROJECT
Architected the billing system process, for business customers, to ensure timely and accurate billing.
Designed, developed and implemented system enhancements for Product Managements promotional offerings.
Designed status reports to track the timeliness and accuracy of the promotions implemented within the systems.
Developed, re-engineered and implemented the promotions process to improve efficiency and reduce cost by a quarter of a million dollars.
BILLING INTEGRITY PROJECT
Designed and implemented new support functions within the Billing Control Office to support local service for Business Customers.
Researched and developed business requirements for ***employerName1***'s entry into local service for Business customers.
Instituted and implemented several groups to verify local data within the local system databases and to process recourse claims with multiple service providers.
BILLING CONTROL OFFICE PROMOTIONS PROJECT
Developed and implemented a team to provide fast and accurate system solutions for promotional offerings supported by the Billing Control Office.
Developed, re-engineered and implemented a new system process reducing costs and building efficiencies within the Billing Control Office. The changes saved the company approximately four hundred thousand dollars.
Developed several measurement reports.
BILLING AND JOURNALIZATION SYSTEM ANALYST
Researched and recommended system solutions for new and enhanced international and domestic services.
Consulted with Product Management to obtain requirements for the new services.
Designed, tested and implementated the system solution.
Researched and published several system measurement reports.
Coached new team members in understanding the capabilities of ***employerName1*** billing systems and determining which system can process the customer request in a timely and accurate manner.
PREVIOUS EXPERIENCE
Held increasing responsibilies in the feild of fraud investigation of international calls.
EDUCATION
BBA in Consumer/Marketing Research, Bernard M. Baruch College, City University of New York, New York.
PROFESSIONAL DEVELOPMENT
Dale Carnegie Leadership
Introduction in Project Management
Quality in Project Management
Systems Design
Systems Development
AWARDS:
Circle of Excellence Award - implementing consumer local service in New York.
COP Spot Award - implementing FCC mandates
Marketing Director Recognition Award - developing process improvements
Vice President / General Manager Recognition Award - developing process improvements
To implement and enhance my skills for the exciting IT career opportunities
Profile
Professional in manner and appearance with strong interpersonal skills
Well organized, detail oriented, responsible, good work ethic, and ability to learn quickly
Very patient, clear communication skill, and user friendly attitude in face-to-face situation
Qualifications
On a M.C.S.E. track with the following MCSE exams passed; Microsoft Certified Professional in NT Workstation, NT Server, NT Server in Enterprise, and Networking Essentials
Proficient knowledge & experiences to utilize various software such as Microsoft Office Suite (Word, PowerPoint, Excel, Access, Outlook) 98 & 2000, FrontPage 98 & 2000, WordPerfect, Adobe PhotoShop, Eudora Pro, Internet Explorer, Netscape, Anti Virus programs (McAfee & Dr. Solomon), Seagate Crystal Reports 6.0, and Windows 95, 98 & 2000
Proficiency & experience in network configuration on PC using TCP/IP & IPX/SPX
Familiarity with Macintosh set up & network configuration using TCP/IP & Appletalk
Being able to modify user profiles in Netware 4.1
Familiarity with backup strategies & programs such as ArcServe & Backup Exec
Working knowledge of MS Exchange administration
Working knowledge of MS IIS 4.0 administration
Working knowledge of MS SQL 7.0 administration
Working knowledge of Oracle 8 & 8i (including Developer 2000) installation & configuration issues
Working knowledge of Oracle PL/SQL, and Form & Report Development using Developer 2000
Experience
Programmer/Analyst II at Psychology Department at ***universityName1***
(12/98 - Present)
Managing general network & helpdesk issues for over 400 users & computers for the department
Setting up user machines in Windows 95, 98 & 2000 environment with various software such as MS Office Suite, web browsers, anti-virus programs, SPSS, TN3270, FTP, etc.
Setting up e-mail clients program on users' machine using Outlook 98 & 2000
Setting up network configuration of PC & Mac for users in Psychology Department network using TCP/IP, IPX/SPX, and Appletalk
In charge of daily & monthly backup & restoration of files using ArcServe & BackupExec 8.0
In charge of upgrading the backup server from ArcServe to Veritas' Backup Exec 8.0
In charge of maintaining & troubleshooting of the department backup servers including BDC's
In charge of maintaining & troubleshooting of the department web server using IIS 4.0
In charge of department-wide Year 2000 Preparation project including help in determining Y2K status of BIOS, providing Y2K patches for the software, and presentation for the department users
Creating various reports using Seagate Crystal Reports 7.0
Creating print ques on Novell server & NT server
Installation and troubleshooting of local & network printers (HP network printers)
Responding to various helpdesk requests from users Computer Lab Assistant at ***universityName1*** Extension in L.A.(6/98 - Present)
Administering computer labs of servers and workstations running Windows NT 4.0
Providing technical support for the faculty members and students users
Creating & maintaining user profiles in Windows NT environment
Creating shared folders with appropriate user rights in Windows NT environment
Setting up new computer labs in which the removable hard drives are used, and multiple operating systems are installed on a single hard drive using Partition Magic.
Setting up new computers using Drive Image to clone multiple computers over the network
Installation & configuration of video cards, NIC cards, and CD-ROMs
Performing installation and configuration of Windows NT 4.0
Troubleshooting various hardware and software problems
Installation & configuration of Oracle 8 & 8i, Developer 2000 on workstations
Installation & configuration of Exchange & Outlook on SQL administration course
Installation and troubleshooting of printers using Microsoft TCP/IP printing service
Programmer/Analyst I at Health Services Resource Center of NPI at ***universityName1***
(11/98 - 4/99)
Managing network & helpdesk issues for over 50 users & computers
Setting up user machines in Windows 95, 98 & NT environment with various software such as MS Office Suite, Eudora Pro, web browsers, anti-virus programs, SPSS, SAS, and etc.
Setting up network configuration for users in Health Services Resources Center network including creating & maintaining user profiles in Windows NT environment
Maintaining NT server including periodical checkup of access-rights on shared folders, remaining disk space, event viewer, etc.
Purchasing computers & providing recommendations for the other peripheral devices for the center
In charge of daily & monthly backup & restoration of files using Backup Exec
Installation and trouble shooting of local & network printers
Education
Took Windows 2000 Active Directory at ***universityName1*** Extension (Nov. 2000)
Took Exchange 5.5 Concepts & Administration at ***universityName1*** Extension (Nov. 2000)
Took Supporting Windows 2000 Professional & Server at ***universityName1*** Extension (Aug. 2000)
Took many of the practical & hands-on classes such as SQL 6.5 & 7.0 Administration, Web Fundamentals, Oracle PL/SQL, Oracle Form Design, and Database Management at ***universityName1*** Extension (Sept. 98 - June 2000)
Took NT 4.0 Core Classes at NovaQuest Computer Learning Center at Torrance (4/98)
Post Graduate Teaching Credential at C.S.U.N. in Northridge (9/93 - 6/96)
Bachelor of Art in History at C.S.U.N. in Northridge (1/89 - 6/91)
Majored in Electrical Engineering at U.S.C. in L.A. (9/84 - 5/89)
Ms ***Name*** has worked as an Information Technology Project Leader, Senior Systems Analyst, Business Analyst and Programmer Analyst over past 15 years.
Her experience includes positions of responsibility on a wide range of projects in the public and private sectors. Ms ***Name*** has excellent communications skills, both written and verbal, strong interpersonal skills, an ability to gather challenging requirements and superior interviewing techniques for both end users and IT personnel.
Ms ***Name*** has consistently demonstrated her ability to lead teams in the delivery of high quality systems solutions. She has worked in the Internet, Client/Server and mainframe computing environments. She is very knowledgeable in relational database systems, such as DB2 and Oracle. Ms ***Name*** has also proven herself as an excellent supervisor of Systems Analysts and Programmer/Analysts.
Her business experience includes applications in marketplace (auction and reverse auction models), accounting, insurance, transportation, human services, telecommunications, energy, payroll, Year 2000 compliance efforts and most recently in working with an Internet Start-Up.
EMPLOYMENT HISTORY:
***employerName1***
Irvine, CA
1997 to Present
Senior Systems Analyst
Ms. ***Name*** worked as a Senior Systems and Business Analyst for a B2B eCommerce start up Company. She had many responsibilities that changed as the company grew. She had researched competitive sites and prepared detailed competitive analyses. She was the lead analyst and created the user requirement documents and GUIs for the site. She wrote the testing scripts and was also the quality assurance specialist to ensure that the developers were coding as to spec.
She also wrote the help text, FAQ's and overall summary documentation.
She assisted the founder and chief architect of the company with some of the Project Management and control of the development effort (assist in day to day structure and management of all development and test groups).
Project Manager
Ms. ***Name*** worked as a Project Manager Consultant on the Year 2000 project for ***clientName1***. Her primary responsibility was to provide overall Project Management leadership and control of the Y2K effort at ***clientName1*** and to provide day-to-day structure and management of all Y2K work groups, technical teams and business unit teams. She had to develop the master and unit work plans. She also had to provide Management Reporting to all levels at ***clientName1***. She had to prepare and deliver full Y2K system test and certification plans, Business Continuity Plans, government responses to the ***governmentDepartments***. This Y2K project also included creating Business Continuity plans with the Plan Partners and the external Business partners of ***clientName1***. (1999 - 2000)
Senior Systems Analyst
Ms. ***Name*** worked as a Consultant on the Year 2000 project for ***clientName2***. Her primary responsibility is the assessment and impact analysis of the Year 2000 on Home Saving's departmental level information systems.
This included all the large client server applications and numerous mainframe applications. In this role she has conducted many user interviews, analyzed and documented systems in a variety of technical environments, has assisted in the creation of a project plan to remediate impacted programs and created implementation plans for each application. It is the responsibility of the Ms ***Name*** to monitor the progress and resolve problems of each application with the modifications, migrations and testing teams. (1997 - 1999)
***employerName2***
Winnipeg, Manitoba
1992- 1997
Senior Systems/Data Analyst
Senior System and Data Analyst on the Year 2000 BARS (billing) project at ***clientName3***. Worked with a team responsible to create the plan and make the BARS system Year 2000 compliant. Worked on detail date (where-used) analysis, data conversion, data interface strategies, test planning, testing, and implementation strategies. BARS is a billing system which consists of over 2 million lines of code and of COBOL, PLI, Easytrieve, Telon, DB2 and IMS components with over 50 identified external data interfaces. This system contained numerous online screens and over 400 reports.
Performed numerous end user interviews and did a high-level data and systems analysis on the CINArgy project at Cargill. Created a list of recommendations and identified architectural components (programs, data elements, files, screens, etc.) of the project that needed improvement. Defined and created a Change Request system on Lotus Notes, standardized the training procedures in both Canada and US and created a project 'Startup Handbook". (1997-1997)
Project Manager/Technical Lead
Project manager and technical lead on the DISTAX project. This system created tax T4As for all clients on disability. The DISTAX system was an old PLI/IMS system that was not Year 2000 compliant and therefore required to be re-written or updated. Managed the technical and functional aspects of the project, prepared estimates on all project phases using GWL's methodology, defined user and technical requirements and also performed the high level and detail analysis on the system and its data stores. (1996-1997)
System Leader
System Leader at ***clientName4*** for over 3 1/2 years. Her area of responsibility was the entire Passenger Revenue Systems (RAPID). RAPID contained many sub-systems such as Ticket Sales, Sales Reporting and Audit, Refund, Interline Billing, Interline Receivable, and Sales Credits. These systems resided on a Honeywell Mainframe platform, and were replaced over a period of 2 1/2 years by a UNIX Client/Server system (PANDA). As a system leader, Ms ***Name*** was responsible for all the activities related to phasing in PANDA and phasing out RAPID.
She did the systems and data analysis, planning, and coordinating of all application service requests.
She was also responsible for the supervision of the Systems Analyst, Database Administrator, and Programmer Analyst. She was responsible for high level analysis of numerous data interfaces and smaller projects (electronic ticketing, aeroplan, billing, reservation system [3]). RAPID also implemented several stand-alone PC systems on a Novell network using MicroFocus COBOL, PowerBuilder, and FoxPro. Ms ***Name*** was liaison to seven other System Leaders managing parallel and inter-related projects. She prioritized service requests and assessed staff for the assignments. Ms ***Name*** was responsible for project reporting, staff reviews, and administration tasks. (1992-1996)
Senior Systems Analyst
Ms ***Name*** worked on the Agent Compensation Project at ***clientName5***, as an Analyst. She worked with a team responsible for the detailed analysis and documentation of the current agent compensation process. Ms ***Name*** interviewed numerous users and documented the related functional and operational processes. (1996-1996)
Business Analyst
Ms ***Name*** worked on the Bull Replacement project at ***clientName6*** as a Business Analyst. She worked with the team responsible for preparing an RFP to replace all the accounting applications. Ms ***Name*** worked in the analysis of the client's Fixed Assets System, and documented the functional processes. She also did data analysis at a high level. These items were included in the RFP. She also performed the preliminary analysis of their smaller systems, including navigation landing, passenger fees, Cara and Non-Cara meal system, and the flight performance system. (1996-1996)
***employerName1***
Los Angeles, CA
1991 - 1992
Programmer/Analyst
Ms ***Name*** developed a new accounts receivable system and helped to develop a system to handle a California legal requirement to collect state taxes yearly from out-of-state corporations at ARCO. These systems were developed using COBOL/DB2/TELON in an IMS DB/DC environment. She was responsible for program design, coding, function testing, and integration testing of on-line screens and batch programs. She also wrote IMS interfaces to existing systems. Ms ***Name*** was also responsible for supervision of a group of Programmers/Analysts on the project team.
***employerName3***
Winnipeg, MA
1987 - 1991
Programmer/Analyst
Ms ***Name*** worked on the CALM project for a 10 month period. This was the Canadian Asset Liability Management System at ***clientName7***. The system was developed using PL/1/TELON in a DB2 environment. She wrote program specifications, coded, and tested on-line and batch programs.
Ms ***Name*** participated in the development and implementation of the Successful Efforts Accounting System at ***clientName8***. The system was developed using COBOL/DB2 in an IMS DC environment. During the design phase, she was responsible for the general and detail design specifications, program design, coding, and function testing. She supervised two Programmer/Analysts.
Ms ***Name*** participated in the development of the "Public Trustee System" for the Department of Justice. The system was developed using TELON/DB2/COBOL. During the development, she was responsible for coding and testing on-line and batch programs.
***employerName4***
Los Angeles, CA
1987
Programmer/Analyst
As a member of the team, converted on-line screens using TELON/COBOL/IMS for the Parts Master Inventory, Receivable, and Financial systems at ***clientName9***.
The ***clientName10*** project involved conversion from a Honeywell system to IBM hardware and upgrading the functions available to the users.
***employerName5***
Winnipeg, Manitoba
1986 - 1987
Programmer/Analyst
As a member of a team, involved in developing a pilot system using a DB2 Data Dictionary to give updates and reports written with ISPF dialogue and TELON.
Her responsibilities included analysis of business requirements, design of the on-line dialogue, programming, and testing.
***employerName6***
Winnipeg, Manitoba
1985 - 1986
Programmer
Created and maintained IMS test databases and created test cases with the users of a Cargo System at ***clientName4***. DATAMACS and PL/1 programs were used.
***universityName1***
Winnipeg, Manitoba
1983 - 1984
Programmer
Developed Basic programs on a PC for several administrative application systems. Responsible for testing and documentation.
EDUCATION/TRAINING:
1984
B.Sc. Information Management Systems
UNIVERSITY OF OTTAWA
Ottawa, Ontario
1981
Bachelor of Physical Education
***universityName1***
Winnipeg, Manitoba
TECHNICAL SKILLS:
Hardware:
SUN SPARC Server, IBM Mainframe, IBM PC, Honeywell BULL
Master of Technology from I.I.T., Bombay in January 1995.
Countries of Work Experience
- USA
- United Kingdom
- India
Experience Summary
6 years of experience in IT field as Project Coordinator , Systems Analyst, and Analyst/Programmer. Experience of handling more than 1 projects at a time
Experience of complete Software Development Life Cycle (SDLC) using SSAD. Knowledge of Object Oriented Analysis and Design. Experience of interacting with the users and IT managers for developing systems from scratch. Developed prototypes for requirements Analysis.
Have worked on more than 1 projects at a time, so some of the projects have got overlapping dates.
Projects in ***employerName1***, NC, USA
----------------------------------------------------------
Client :
***clientName1*** Duration : July 2000 - Till Date
Role :
Systems Analyst Location : NC, USA
Project: Client provides Automobile damage appraisers to the insurance companies.
This is a B2B site wherein Insurance companies can sign in to the System and book time slots for the Appraisers.
Responsibilities:
Prepared User Requirements Specification from client, user interviews.
Designed User Interface, Database Schemas.
Preparing Unit, System Test specifications and Training documents.
Preparation of project plan, input to ***employerName1*** for estimation of effort.
Managing work from offshore development team.
Reporting project status to client.
Environment: JAVA, MS-SQL Server , Windows NT and MS-IIS, Use cases, UML
Client :
***clientName2*** Duration :Jan 2000 - June2000
Role :
Systems Analyst Location : NC, USA
Project: Client business is checking the Semantic meaning, pronunciation and other possible adverse effect of the words in various International Languages.
The project is the complete automization of this process.
Prepared User Requirements Specification from client, user interviews.
Designed User Interface, Database Schemas.
Prepared Unit, System Test specifications and Training documents.
Prepared project plans, input to ***employerName1*** for estimation of effort.
Managed work from offshore development team of size 6+1.
Reporting project status to client.
Environment: JAVA, MS-SQL Server , Windows NT and MS-IIS, UML, Class Diagram
Client :
***clientName3*** Duration : April 2000 till Date
Role :
Systems Analyst Location : NC, USA
Project:
1. Client is one of the biggest Beddings and Bathroom accessories manufacturing company in the USA. They use a software for their Enterprise Solutions The NET Collection. The project is Production support for this system.
2. Proposal for developing a System for Data Interchange with ***clientName3*** Vendors using XML.
Responsibilities:
Project team consists of 3 Programmers and 1 systems Analyst. Am doing the analyst and client/user interaction job.
Interaction with users, getting requirements, analysis and design of changes, estimation of effort and getting the changes developed from team.
Preparing weekly status report, inputs to ***employerName1*** for Invoicing client.
Preparing Technical proposal for a new E-commerce application with vendors using XML. This application is to use XML for transmission of ASNs, POs, Invoices, Vouchers etc. from Vendors to ***clientName3*** and vice-versa.
Operating system:
OS/400, Windows 98, XML, RPG, CL/400, SQL
Special Software:
NET Collection, DFU, DBU, MS-Excel, MS-Outlook Express, MS-Word, Peregrine Service Centre.
RDBMS :
DB2/400
Projects in ***employerName2***, U.K.
----------------------------------------------
Client :
***clientName4*** Duration :Dec. 98 - Feb. 2000
Role :
Senior Systems Analyst Location : London, U.K.
Project: RCT is a distribution System for Containers of ***clientName4*** within U.K. The project involved enhancements, maintenance and 24 hour production support of this system. Development work done in the project was the developments of Archiving Module and Management Information Reporting Module.
Responsibilities:
The project team consisted of 2 parts. One was offshore development team (5+1) based in India, other was on-site Team (4+1) in London.
Single point of contact from ***employerName2*** to the client for Onsite and Offshore team.
User Requirements Analysis, Analysis and design of system changes and enhancement projects.
Work planning for Offshore and Onsite team. Providing and managing work for the offshore and onsite team.
Providing support to offshore Team leader for CMM level 5 efforts (***employerName2*** GG2 office where the project was getting executed is a CMM Level 5 office).
Inputs to ***employerName2*** for Invoicing and submitting Weekly Status report to ***employerName2*** Management and Client.
Resource planning for the Offshore and Onsite team.
Preparation of Contract between ***employerName2*** and ***clientName4***.
Operating system:
OS/400, Windows 98
Softwares:
RPG, CL, Query/400, SQL/400, RCT, Ami Pro, Lotus 123
Client :
***clientName5*** Duration :Feb 98 - Nov 98
Role :
Systems Analyst Location : ***employerName4***, U.K.
Project: The project was the year 2000 Project- Planning, Conversion & Testing support for ***clientName5*** ICMS Software. The Software size was 6 million LOC, consisting of RPG and CL programs. The project was done in 3 phases.
Responsibilities:
Estimation of the size of the code impacted by Y2K, deciding the conversion strategy, configuring the BYPASS 2000 software (used for conversion), according to the conversion strategy.
Analysis, review of changes, coding for changes , Work distribution, monitoring the work of the team. Technical help to the team.
Conversion of the ICMS software thru BYPASS 2000,
Development support to the testing Team. Designing the Test Cases by analyzing the system, so as to execute the code not executed by testers.
Hardware :
IBM AS/400 system.
Operating system:
OS/400, OS2
Programming :
RPG/400, CL/400
Softwares :
Query/400, SQL/400, Debugger, DFU, SDA
Projects in ***employerName2***, Delhi. India
----------------------------------------------
Client:
JPM New York Duration : April 97 - Jan 98
Role :
Analyst Programmer Location : ***employerName2***, New Delhi. India
Project :The client's application is built around Future and Options software.
The project deals with the analysis and conversion for year 2000 compliance.
Responsibilities:
Designing and executing a pilot project for estimation of capabilities of Y2K tool to be used. Based on this analysis the conversion strategy and team size for the project was decided.
Analysis of Impacted fields, development of tools for project, conversion. Giving inputs to PL for preparing reports to be submitted to client.
Technical help to Team members.
Distribution of work to the team, Giving status report of team (4 members) to the Project Leader.
Quality Review of work as per ISO 9001 standards.
Preparation of Test Specifications and Test Cases.
Preparation of packages for delivery to the client.
Hardware :
IBM AS/400 system
Operating system :
OS/400, Windows 98
Programming :
RPG/400, CL/400 , SQL, Query/400
Special Software :
Y2KIT/400
***employerName2*** Duration : Jan 96 - March 97
Role :
Analyst Programmer Location : ***employerName2***, New Delhi. India
Project:
Development of Y2K toolset (Y2KIT/400). The product consisted of modules for Inventory of software, Analysis of software for date fields, Conversion of programs, DSPFs depending on the Conversion strategy and testing of the converted source using data agers.
Responsibilities:
Preparation of Program specifications and development of programs.
Code Walkthrough, quality review of code developed by other team members.
Preparation of test cases and unit testing.
User manual preparation
Operating system:
OS/400, Windows 98
Programming Languages:
RPG/400, CL/400
Software:
Query/400, SQL/400, Debugger, DFU, SDA
Projects at ***employerName3***, New Delhi
***employerName3*** New Delhi. INDIA Duration : April 95- Aug 95
Role : Analyst/Programmer Location : New Delhi. India
Project: The project was the development of Hotel Management System for small hotels. It consisted of modules for Customer Entry, Rooms allocation, Check Outs, Billing and reporting. The project was developed on C for a PC based environment. Database used was MS-Access.
Responsibilities:
Meeting with the users for requirements gathering.
Coding and development of database tables.
Preparation of program specifications
Unit testing, System testing, and the implementation of the project to the client site.
Operating system:
DOS, Windows 3.11
Programming :
Turbo C
Software :
EXCEL, MS-Word, Flow, MS-Access.
***employerName3*** New Delhi. INDIA Duration : Aug 95 - Dec 95
Role : Analyst/Programmer Location : New Delhi. India
Project: Public Transport System Design
Project: The project was the development of a software for Mass Transport system for Metropolitan cities in India. The developed software was capable of projecting population, trips made per household, origin-Destination matrix preparation , Traffic Assignment on Network of city, and calculations of various options for the routes.
Responsibilities:
Methodology for the transport Network design.
Preparation of Flow Charts, program specifications.
Users opinion survey for their transit behaviour, preparation of data for the city of Nagpur, digitisation of network, coding, testing.
Ten years experience in information technology with concentration in customerordering, billing, marketing and decision support systems.
Fifteen years prior experience in customer sales and service.
A flexible, self-motivated professional with excellent analytical and management skills
Exposure to all phases of the systems development life cycle
A natural sense of urgency with regard to developing client system solutions
Understands the importance of building relationships with both business clients and software developers in order to increase the likelihood of project success
ACCOMPLISHMENTS
Led an accelerated development project that consolidated data on hot marketing leads from multiple sources into a database to allow quick customer contact regarding a new product. Enabled over 20,000 leads to be created within one month's time, meeting the marketing manager's expectations
Led the requirements definition effort for a marketing promotion tracking and analysis system project designed to improve marketing effectiveness.
Utilizing business and ordering system subject matter expertise coordinated and executed the gathering of requirements over a one week period making it possible to meet marketing's aggressive project timeline
Developed a strategic initiative for an application designed to provide a common customer ID across business units. The team put together a proposal for the project where the benefits had a net present value of $13 million
Led a prototype effort for a system designed to analyze customer call records and determine the feasibility of a multi-terabyte data warehouse. Contributing knowledge of the data and coordinating the team to succeed in processing the resulting large data volumes enabled delivery of information and reports to marketing that exceeded the manager's expectations
EXPERIENCE
***employerName1***
IL
1990-2000
Solutions Consultant
Responsible for the identification and support of large development projects, especially during the early concept and definition phases of the systems development lifecycle
Consulted with clients and mentored less experienced employees enabling worthwhile projects to progress through their lifecycle
Led our division's input into the annual budget planning process
Specialist
Systems analyst on a decision support systems project providing subject matter expertise on the call record and customer data areas
Provided business consulting for marketing information delivery improving the ability of mangers in multiple business units to perform their jobs
Data expert on a team that developed the core strategic building blocks for the marketing and decision support business area
Guided business clients through the development of requirements for extract files from at least four data warehouse and decision support systems to provide data for a marketing datamart
Team Leader
Managed four programmer analysts responsible for developing and delivering ad-hoc reports and files from a customer data warehouse. Consistently exceeded client's expectations by completing requests in less than the expected turnaround time
Programmer Analyst
Performed extracts, merges and manipulations of customer and product data from a Teradata relational database using Teradata SQL and SAS in MVS. By working closely with clients, established a reputation of delivering quality output that enabled marketing managers, product managers and others to increase revenue and reduce costs
Business Analyst
Played a key role, including leadership roles, on self-directed work teams developing requirements and performing gap analysis of complex services for a large billing system
Test Analyst
Analyzed requirements and data flow diagrams to develop the Integration Test Plan for a large customer ordering and billing system.
***employerName2***
Chicago, IL
1986-1990
System Administrator/Project Manager
Performed table maintenance and project management role for a direct order system
Trainer
Trained Service Representatives in the sales and service centers in customer billing, order negotiation, sales, contact handling and use of the systems
***employerName3***
Downers Grove and Naperville, IL
1974-1986
Service Representative/Order Writer/Teller
Performed duties covering all aspects of consumer sales and customer care, including order negotiation, order entry, billing, sales, collections and bill payment processing
EDUCATION
Roosevelt University, Schaumburg, Illinois
Nine hours completed toward Graduate degree in Information Systems Management (MSIS), 2000 - present
Lewis University, Romeoville, Illinois
Bachelor of Arts with Highest Honors in Business Administration, 1996
College of DuPage, Glen Ellyn, Illinois
Associate of Arts in Business Adminstration, 1988
Over 8 years analyzing, designing, testing, implementing and supporting systems within the Financial department of General Motors Service Parts Operations, as an employee for EDS. A graduate of the Systems Engineer Development (SED) program and believes strongly in implementing quality results using the System Life Cycle (SLC) methodology. Over the past six years, has had a majority of experience in a MVS/OS mainframe environment designing, constructing and maintaining systems written in PL/1 and COBOL II, referencing both IMS and DB2 databases.
Education
University of Michigan - Flint, Bachelors Degree in Business Administration, emphasis in Finance and Accounting, Graduated with honors (GPA 3.2)
EDS Systems Engineer Development Program, Resulted in a promotion to Systems Engineer
Technical Skills
Hardware:
IBM System 370
Operating System:
IBM MVS/OS
Databases:
DB2, IMS, GSAM
Computer Languages:
PL/1, COBOL II
Application Software:
TSO-ISPF, SYNCSORT, IDCAMS, IBM Utilities, Abend-Aid, File-Aid, Easytrieve, WSF2, SPUFI, Control M Scheduler, MS Access, Panvalet, Windows 3.1, MS Word, Datefind, Viaduct (Data Aging Software)
Experience
Senior Analyst & Programmer
***employerName1***
1/00 - present
Responsible for Bank Card Systems.
Project experience includes card conversion from Visa to Mastercard.
Reconciliation of new switch processing with STAR, EBT, NYCE.
Programs supported using COBOL 370, VSAM and flat files, JCL and Changeman utility for promoting production charges.
Currently working with other team members to form a System Life Cycle methodology to ensure quality and minimize rework.
Senior Analyst & Programmer
***employerName2***
11/97 - 1/00
Testing coordinator for ***employerName1*** responsible for Year 2000 conversion, audit compliance, integration and system testing Credit and Debit card applications within the bank.
Systems Programmer/Analyst
***employerName3***
8/97 - 11/97
Worked as a contract employee on a Year 2000 project for ***employerName3***.
Responsibilities included quality assurance of test JCL, design and write new programs for aging of test files and consult with NBD customers to verify that needs are met.
Activity Based Management Project
***employerName4***
9/96 - 8/97
Led a team of 7 Systems Engineers, Database Administrators, Client Server SE's and network infrastructure support staff as a project manager for ***employerName4*** to promote the current Activity Based Costing system to an Activity Based Management system.
Role in this project was to personally design the mainframe IMS and DB2 system changes.
Also assisted and participated in the systems infrastructure design for the client server portion of the project.
Hands-on participation in the projects as listed below:
System Analysis 30%
System Design/Mainframe 100%
System Design/CS 20%
Technical Design/Mainframe 100%
Construction/Mainframe 40%
User Acceptance Testing/Mainframe 100%
Implementation walkthroughs & Moves into Production 75%
Production Support and Abend Resolution 100%
Team Lead
***employerName5***
1/96 - 9/96
As the team leader of 5 Systems Engineers, responsibilities included designing Year 2000 changes for the systems that the team supports, training new team members in the efficiency use of the productivity tools, teaching ***employerName5*** standard (SLC) procedures, tracking time for billing purposes, updating the Monthly Operating Letter for progress to upper management, estimating development time, report status, and setting priorities with the GM customer departments of Cost, Physical Inventory and Activity Based Management Systems.
Resolved technical problems, instructed in business processes and trained in system support/abend resolution.
System Support Activity Based Costing
***employerName5***
9/95 - 1/96
Gained customer trust and satisfaction through dedicated system support.
This support included 24 hour system maintenance during critical quarterly reporting.
Also used systems knowledge along with business experience and coding expertise to develop and improve system efficiency, accuracy and decrease cost.
Has a "keep it simple" method of design and construction that is easy to maintain and well documented.
This system is coded in PL/1, COBOL II with IMS and DB2 databases.
System Support Disbursement Analysis
***employerName5***
6/94 - 9/95
As a support SE, proposed, designed and constructed coding changes to support the needs and changing direction of GM North American Operations.
Projects included grading in the level of service by the suppliers, and the transition of the Freight Payment system to an outside supplier.
This system is coded in PL/1 (both on-line and batch) with IMS databases.
System Support of Ship Direct Invoicing
***employerName5***
4/92 - 6/94
Automated tie-in processes and reject/recycle processes that were able to reduce the head count of the Ship Direct Invoicing department by 20%.
Emphasis was also to propose and construct run-time efficiency changes and cost savings to the system.
These changes resulted in annual cost savings of $45,000 per year for this department.
This system is coded in PL/1 (both on-line and batch) with IMS databases.
Bachelor of Engineering (B.E) in Production Engg., P.S.G College of Engineering Coimbatore, INDIA, April 1996.
Experience Summary
Developed Components For ***clientName1*** using CBD Standard Currently Developing a System using CoolGen Javaproxy,Java and JSP.
Development of utilities to facilitate COBOL Conversion from OS/VS COBOL to VS COBOL II, Madras, INDIA.
Overall understanding and knowledge of MVS and IEF.
Analysis, design, construction in Enhancement phase and support for IT Assessment BSD, File Transfer BSD, Installment BSD, Foreign Artist BSD, Misassessment BSD and Taxpayer BSD and support for Integration Assessment and Collection System, INTACTSG, IRB Kuala Lumpur.
Involved in Analysis development, Implementation of Different Projects in Patent Trademark Office at Virginia USA.
Overall Understanding and Knowledge of Web Development and Client server technology
CAREER PROFILE:
Organization ***employerName1***, Madras, India.
Present Designation Systems Analyst.
Joining date 22 April, 1996.
Organization ***employerName2*** Atlanta USA.
Present Designation Systems Analyst.
Joining date 01 March 1999.
PROJECT PROFILE:
(MAR 1999 - till date)
Project PALM-MIGRATION
Client ***clientName1***
Description Palm-Migration is a Migration Project developed for ***clientName1*** from UNISYS-A16 to Client server technology by using CASE TOOL called Cool Gen
The PALM-MIGRATION Project has been decided to implement in different Modules like Infrastructure, Pre-Examination, Examination, Post-Examination , Fileordering and Pre-Grant Publication.
The Entire System has been Developed by using Component Methodology(CBD96).
Role
Team Lead For the Infrastructure Subsytem
Project Lead for the ***** application
Project Lead For the File Ordering SubSystem
Project Lead for the Infrastructure and File ordering component Development and implementation
Team Lead for the Pre-Grant Publication Subsyetm Which Deals with Web Interface
Responsibility PACE:
Analyzed the existing PACE Application to Improve the Performance as well as implement business logic to satisfy business requirements. Since the Composer 3 is a Y2k Non compliant case tool, I have done analysis to implement Y2k Compliant strategy to make PACE application as Y2k Compliant system.
Solved three IEF exception problems that were affecting the Productivity of Patent.
Developed reports to track the Productivity of the USERS.
INFRASTRUCTURE:
Developed Worker Listing, Organization Information reports by using COOL GEN:5.0, C, Report Composer, which involved 5 Procedure Action diagrams, 12 Process Action Blocks, four "C" programs and 4 Report Composer Programs.
FILE ORDERING:
Involved in Analysis, design, and implementation of different phase of the project. Improved the Performance of the application by restructuring the Queries. Enhanced the Web Front end to be more users friendly, as well as to implement user requirements.
Developed reports for the User to track the number of files ordered a day.
Used PL/SQL programs and Unix shell Scripts to implement this.
Component Development:
Involved in Design and Development of Component Development for Entire Patent Application by using CBD Standards
Pre-Grant Publication:
Developing the Web pages using JSP and JavaProxy (Coolgen generated) and XML Documents.
Involved in redesign and development of Out going Correspondence Module to improve the performance and change the Browser from Netscape to Internet Explorer 5.0
Hardware/OS PentiumIII, Windows NT 4.0 ,HP-UX B.11..00 U 9000/800,Windows NT server,IIS, JRUN webserver, Netscap Server
Languages COOL GEN:4.1a, COOL Gen:5.0, COOL Gen:5.1(ComProxy,JavaPRoxy), C, C++, Crystal Reports, Report Composer, HTML 4.0,Active Server Pages, XML,PL/SQL,VB,JSP,XSL,Javascript
DBMS Oracle 8.0, Oracle 8.0.5, Oracle8i
(May 1996 - Feb1999)
Project Integrated Assessment And Collection System (INTACTSG).
Client ***clientName2***, Malaysia.
Description Integrated Assessment and Collection System, is a software for assessment and collection related applications for Salary Group (SG) taxpayers which uses IEF as the front end and DB2 as back end. INTACTSG uses SAS for batch printing applications, REXX for Pseudo online printing applications and C for online printing applications.
The project also has a data migration component, where the existing data distributed across different platforms and databases has to be integrated and migrated so as to make the data compatible to the new system. This component makes use of PL/I, REXX, COBOL, DIALOG MANAGER programs, IEF and Role ß Designing Developing and construction of INTACTSG in Enhancement phase for ITASSESSMENT BSD, File transfer, Foreign Artist Taxpayer and MIS assessment of INTACTSG.
Involvement in testing and QA.
Support and bug-fixing during Unit Test, Integration Test, System Test ,User Acceptance Test, ECP Internal Test and ECP User Acceptance Test.
Responsibility
Analyzed the existing system and INTACTSG data model, came out with Construction Strategy and Requirements document. Planned, scheduled and monitored the construction phase of the above mentioned BSDs. Had sole responsibility of Bug fixing during all the Phases of testing.
Also unit tested, prepared test plans, prepared test results for the above mentioned BSDs during INTACTSG construction phase.
Involved in the planning of Migration strategies and Rules for ECP.
Involved in creating skeletons, common routines, utilities during INTACTSG construction phase.
Involved in the development and maintenance of few tools for Version Control of the Models and Database, Backup facilities of error logs.
Preparation of test plans for all Testing phases.
Hardware/OS
Pentium, ES 9000/ Windows NT 3.51 , MVS 5, MVS 3, Win-95 and OS/2.
Experienced Systems Analyst, Spreadsheet Analyst. Background includes pharmaceutical, legal, academic environments. Design, debug databases; provide client server application solutions. Excellent troubleshooter, hard worker, dependable, eager to take on new tasks. Area of expertise includes: Word, WordPerfect, Excel, Lotus123, Access, Visual Basic, Approach, PowerPoint, PageMaker, Outlook, FoxBASE, Quicken, Publisher, Works, Freelance, Visio, BeyondMail, Reachout, PlanPerfect, DOS, Windows 95, Windows 98, Internet Explorer, Netscape, Compuserve.
PROFESSIONAL EXPERIENCE
INDEPENDENT CONSULTING
Philadelphia, PA
1999-Present
Systems Analyst
Designing and developing databases using Visual Basic and Access. Creating spreadsheets, graphs and reports using Microsoft products. Testing and debugging systems to ensure performance. Prepare written user documentation. Using Publisher to create and edit brochures, newsletters and other various publications.
***employerName1***
West Conshohocken, PA
1997-1999
Systems Analyst
Analyzed current business functions and provided client server application solutions to enhance performance. Defined goals of system, type of information collected, how it is to be processed and what types of reports are to be produced.
Designed, developed and implemented Visual Basic and Access databases. Used Excel to created spreadsheets, graphs and reports for various departments.
Tested and debugged systems to ensure performance. Made sure hardware and software allow free exchange of data. Prepared written user documentation.
Assisted with training of end-users.
***employerName2***
Philadelphia, PA
1994-1997
Spreadsheet Specialist
Designed and developed Access databases. Designed Excel spreadsheets and graphs.
Used Viso to create flowcharts for numerous departments. Provided telephone and on-site support for spreadsheets, word processing, graphic and database programs. Installed, configured software and troubleshoot various PC-based software products. Assisted with training of end-users. Created macros and templates to automate tasks. Converted DOS files and mainframe downloads into Windows-based applications.
***universityName1***
Syracuse, NY
1992-1994
Office Coordinator
Created FoxBase databases and designed reports to manage and present a large volume of confidential information. Provided troubleshooting for software problems. Prepared instructional materials, letters and reports using wide range of Macintosh software. Scheduled daily operations. Planned, organized and assigned work to support staff. Coordinated departmental purchases and prepared financial reports. Interviewed, hired and supervised Federal work study students. Assisted in maintaining budget of over $250,000.
***employerName3***
Syracuse, NY
1992
Secretary/Receptionist
Maintained client database. Prepared proposals, letters and other correspondence.
Updated client mailing list for dissemination of monthly newsletter. Gathered information for Account Executives, filed, answered telephones and took messages and/or referred calls.
EDUCATION
BS, Information Studies, ***universityName1***, Syracuse, NY 1991
B.S.E., Civil and Environmental Engineering, University of Michigan, 1997
EXPERIENCE
***employerName1***
Systems Analyst/Project Coordinator
1998-present
Project coordinator for developing financial system for ***employerName3***.
Maintained programming code for a new financial system for ***employerName3***.
Developed and utilized a Visual Basic/MS Access application for tracking production system failures. Maintained programs developed using COBOL II, IMS, DB2, UNIX scripts, and PLSQL.
Developed and executed extensive system testing for new programs and JCL streams.
Developed and maintained the mainframe to UNIX segment of ***employerName3***'s mainframe/client server/web financial system.
Developed specifications for and wrote conversion programs for ***employerName3***'s Accounts
Payable system using JCL, COBOL and DB2. Worked in production and test environments. Modified existing production programs.
***employerName2***
Assistant Engineer
1997-1998
Worked on and utilized a client server application developed in Visual Basic version 4.0.
Performed queries and manipulated data pertaining to SARA chemical reporting for ***employerName3***.
Prepared SARA Title III toxic release inventory reports for ***employerName3*** Assembly Plants.
Responsibilities included development of summary reports, toxic chemical computations.
Completed USEPA SARA 313 Form R reports using AFR for Windows.
Also prepared proposals and reports for various environmental projects including construction and renovation project oversight, Phase I environmental assessments, and sampling and testing activities.
***employerName3***
Certification Test Laboratory Technical Assistant
May 1996 - August 1996
Issued parts change notices, diagnostic requests and movement notices for emissions test vehicles to and from the test track and the EPA.
Logged test data from emission certification tests from the test lab as well as from the EPA.
Under the supervision of a senior engineer, diagnosed and corrected vehicle problems during emission testing.
***employerName3***
Environmental Quality Office Technical Assistant
May 1995 - August 1995
Developed a database system via MS Access to monitor and track assembly plant compliance to environmental regulations, alleged violations or agency audit findings.
Reviewed the 40 CFR for application to plant environmental issues.
Developed forms, tables, queries, macros and reports for tracking database.
Made assessments and calculations and calculations for spills using MS Excel.
Assisted in development of mandatory environmental training programs for employees.
COMPUTER SKILLS
Microsoft Windows NT, MS-DOS, UNIX, Macintosh operating systems
Microsoft Office (MS Access, Excel, Power Point, Word)
A position as an Information Systems Analysis. Willing to relocate and travel.
KEYWORD SUMMARY
Excel, Access, Word Perfect, Notepad, PowerPoint, Project Manager, Java, C++, Visual Basic, Cobol, Access, HTML, Systems Analyst, Presentation skills, Management skills, System planning and implementation skills, Microsoft SQL
SUMMARY OF QUALIFICATIONS
Ability to interface with all levels of management
Demonstrate team leadership
Knowledge of Information Technologies
Understanding of System Development Life Cycle
CLASSROOM PROJECTS
Planned, developed, implemented a Cobol based inventory system following the Systems
Development Life Cycle phases in a team of four.
Created my own Web page
Developed a object-oriented program in a group of four to help a company choose between different proposals.
EDUCATION
BS degree in Business Administration, emphasis in Information Decision Systems.
San Diego State University, California
Expected graduation date: December 2000
RELATED COURSEWORK
Information Systems Technology (hardware, software, LANs
Systems Analysis and Design (design and implementation of a system)
Networking (technology and terminology)
Advanced Business Writing (documentation)
Database Information Systems (Access, HTML)
COMPUTER SKILLS
Spreadsheet programs: Excel and Access
Microsoft applications: Word Perfect, Notepad, PowerPoint, Project Manager
Maintained Intuit QuickBooks, updated company customer records and generated monthly billings.
***employerName2***
Customer Service, San Diego, CA
Jan '98 - Dec. '98
Utilized teamwork to maintain customer satisfaction and cleanliness. Networked with all levels of management to address concerns and come up with a deliverable solution.
***employerName3***
Activities Director Assistant, Paicines, CA
May '96- August '96
Coordinated and arranged weekly hour of children's activities. Developed and taught daily aqua size lessons for the elderly. Trained and managed new employees for weekend activities. Accountable for daily customer relations.
Networked with all levels of management in monthly meeting.
ACTIVITIES
Catholic Club President at Stanislaus
University 1992-1994
Planned trips and outings for club, guided weekly meetings, coordinated fund raisers, recruited new membership, presented awards.
Ski Club Stanislaus
University 1993-1994
Coordinated different outings and participated in fund raisers.
Accounting Society Stanislaus University
1992-1994
Volunteered to do taxes, attended weekly meetings, presented new ideas, helped with recruiting.
Systems analyst contributing to innovations in a development or technical support position.
Qualifications:
Systematic, logical, and detail-oriented professional with 15+ years experience in MIS arena with recognized proficiency in:
Decision Making Establishing Procedures Organizing
Accounting Applying Technology Training
Auditing Support Disaster Recovery Cost Control
Writing Protocols Customer Relations Problem Solving
Achievements:
Combined cost accounting with computer system skills to automate a complex standard cost revision system that reduced the time required to perform an annual task from weeks to hours. This success led to being tasked with 17 of the 20 IBM systems in the shop including developing six of those systems.
Wrote narratives and Job Control Language flow charts for documentation designs which were adopted by Production Control as models for other analysts to follow.
Designed electronic forms for project development to meet structured methodology employed by EDS for its project management.
Welcomed increased responsibility: with attrition of senior staff, took on system support of $125 million Payroll system for 400-600 employees; advanced from installation and support of $350 million Accounts Payable system to $1.75 billion EDI system.
Installed vendor A/P software and fine-tuned system to cut run time by 50 percent. Added benefit was having reports ready for customer each morning.
Converted various platforms: IBM 4331 mainframe to PR1ME system with database capability.
Cut costs and time by writing programs to design multi- purpose custom forms that included all logistics infor- mation for warehousing, transporters and end users.
Represented MIS department in oral presentations for new employees om various departments.
Performed classified duties requiring top secret security clearance while serving in United States Navy.
PROFESSIONAL EXPERIENCE
INFORMATION TECHNOLOGY ANALYST
Southfield, MI
06/2000 - 12/2000
***employerName1***
Contracted to EDI group of Federal Mogul, a global automotive parts manufacturer.
Projects centered on developing interfaces between GENTRAN:Realtime and batch applications, and batch interfacing into a WEB-based ASN tracking system.
Also did customer mapping.
SR. SYSTEMS ANALYST
La Vergne, TN
01/2000 - 05/2000
***employerName2***
Contracted to EDI department of Ingram Entertainment, the country's leading distributor of home entertainment products.
Primary duties were mapping and testing transactions for new customers (most are Internet customers) utilizing Gentran software, then overseeing installation onto production system.
Secondary duties included on-going customer service/ resolving problems.
INFORMATION ANALYST
Westerville, OH
1993 - 1999
***employerName3*** (***employerName4*** account)
Administered technical support for ***employerName4***'s critical EDI system utilizing GENTRAN software.
Provided primary technical support for the ***employerName4*** Payroll and Accounts Payable systems.
Wrote and upgraded programs for other financial systems, and later helped convert these to J.D. Edwards system on AS/400 platform.
Developed methodology project forms which became models for other EDS employees' use.
Effectively handled 7 X 24 support for multiple-system responsibility.
SYSTEMS ANALYST
Dublin, OH
1987 - 1993
***employerName4***
Installed and maintained Global Software Accounts Payable package.
Fine-tuned the A/P system achieving a 50% reduction in batch run times.
Created narratives for A/P system adopted by Production Control as models.
Assumed technical support role for Frigidaire's $125 million annual payroll system utilizing Cyborg software in batch and real time modes.
Provided back-up support for other financial systems.
Promoted Information Systems department through oral presentations at new employee orientations.
PROGRAMMER/ANALYST
Columbus, OH
1973 - 1987
***employerName5***
Developed and installed formerly manual standard cost revision system on IBM mainframe.
Wrote and installed six systems, maintained 17 systems, and had knowledge of all 20 IBM systems in shop.
Converted programs from COBOL to INFO/BASIC for PR1ME system.
Provided training to replacement programmers on IBM and PR1ME systems.
COST ACCOUNTANT
Columbus, OH
1970 - 1973
***employerName5***
Provided and supervised diverse accounting functions including annual standard cost revision, monthly journal entries, auditing functions, physical inventory reconciliation and reporting.
Assisted supervisor in recruitment and in expanding scope of departmental responsibility.
To establish a challenging role as a Systems Analyst, which will utilize my education and skill-set, while expanding my knowledge as a IT professional.
Education:
Western Washington University- Bellingham, WA
B.A., Business Administration
Concentration: Management Information Systems
Projects:
Database Design
Developer in a database development team, which designed a working database for Western Washington University's (MIS) reservation system.
Provided the university with a database to enter and retrieve student, employee, course, and section information within given constraints.
Duties included: Entity relationship diagrams, normalization, building tables, forms, queries, and reports, SQL builder, and writing user and technical manuals.
Technical Skills:
Operating Systems:
Microsoft Windows 95/98/2000, NT 4.0, and Novell Netware 5.0.
Programming languages:
Microsoft Visual Basic 6.0.
Applications:
Microsoft Word, Excel, Access, PowerPoint, Outlook, and Visual Analyst.
Internet:
Internet Explorer, Netscape Navigator, FTP, Telnet.
Capable of installing hardware and software on personal computers.
General Skills:
Strong communication and interpersonal skills
Devoted team player with excellent leadership abilities and organizational skills.
Great analytic and problem solving skills, paying close attention to details.
Experience:
Customer Associate: ***employerName1***, Bellingham, WA
10/1998 - 12/2000
Customer service, sales support, ordered and received inventory from various vendors and suppliers, constructed promotional and store displays, opening and closing duties.
Precision Finisher/Team Leader: ***employerName2***, Walla Walla, WA
5/1995 - 9/1998
Responsible for ensuring specific jobs were completed in a timely manner with superior quality.
Communication link between production managers and shop employees.
Developed ways to reduce material usage and improved job times, which added value to a product, and a competitive advantage to the company.
Trained new employees on shop safety and tool usage.
Firefighter/First Responder: ***FireDistrict***, Walla Walla, WA
5/1994 - 7/1996
Responded to both fire and emergency calls, completed various technical incident reports, volunteered at numerous community events, involved in continuous training and education.
Activities & Memberships:
Member of Management Information Systems Association (MISA).
Volunteer Firefighter/First Responder.
Western Washington University Backpacking Club Trip Leader.
Over 5+ experience in client server application development, worked as a system analyst and having good command on development of application life cycle.
Involved in interacting with the users for specifications, preparation of technical documents, CDM, PDM, dividing complete application in to various modules and distributing among programmers, Maintaining quality and insuring the accuracy of application. Worked extensively with Powerbuilder 5,7, Sybase 11.x and Developer2000 and Oracle. And I am a self-learner and ready to start working on any platform mentioned in Area of expertise with little training.
Seeking an opportunity as a System Analyst with growing, progressive organization.
AREA OF EXPERTISE
Prog. Lang. :
PBScript, PL/SQL, C, C++
RDBMS :
Oracle 7.X, Sybase 11.5, Sybase SQL Anywhere
GUI :
Developer 2000, Powerbuilder 5.0, VC++
Data Extract :
Sql*Loader, Using ODBC
Case Tools :
ER Win 2.X, Power Designer 32bit
Networks :
Windows NT, TCP/IP
O/S :
Dos, Sco Unix, Windows 95
CAREER PROFILE
Aug 2000 to Dec 2000 System Analyst
***employerName1***
Singapore.
June - 1999 to July 2000 System Analyst
***employerName2***
Dubai - U.A.E.
Nov -1997 to June - 1999 System Analyst
***employerName3***
Noida , U.P India.
May - 1996 to Nov - 1997 Analyst Programmer
***employerName4***
Al-Khobar - Kingdome of Sudi Arabia.
July - 1995 to April - 1997 Programmer
***employerName5***
Warangal, A.P- India.
Projects Handled in
***employerName1*** Singapore.
DEX (Consultant desk) & Payroll
Duration 4 months
Platform Powerbuilder 7.0, Sybase SQL Anywhere
Description This system is enhanced by me for further functionality for Human Resource Company ***employerName1***. This application contains order, candidate, and consultant information for recruiting the qualified persons, according to the company needs. It has features like down loading candidate information from the web site (***httpAddress***) after searching on requirements of companies. Search can be made on qualification, skills, industry and experience.
Payroll system contains processing of payroll for permanent, temporary candidates.
It has hourly weekly and monthly salaries/wages calculations for different candidates.
***employerName2*** (Sybase Application Partners, Middle East), Dubai, UAE.
Visual Integrated Business System
Platform PowerBuilder 5, Sybase11.5, Power Designer
Client ***clientName1*** (Dealers for VW, Porsche and Audi cars for Middles East)
Duration June - 1999 to July 2000
Workshop modules
Duration 3 months
Description This module is a part of Visual integrated Business system. This module is developed for the maintenance of workshop. It has Jobcard, Spares issue, Spares return, updation of workshop inventory, Automatic purchase order generation according to demand of spares, Spares Transfer-in request generation from other workshop. And invoice generation with Time unit rate calculations. It is integrated with Swapping machine to down load the mechanic's time spent on each jobcard. This module is integrated with accounts, Payroll and spares inventory.
Spares Inventory
Duration 4 months
Description This module is part of VIBS. This is developed for maintenance of spares inventory. It has Purchase, Sales and stock. Purchase cycle includes Local purchase and Import purchase. It contains purchase requisition, purchase order, Goods Receipt and costing. Sales cycle includes export sales, Local sales, workshop sales. It contains Quotation, Sales order, Stores Receipt Voucher and invoicing. Stock includes physical stock counting and calculation of stock value and updation of stock from purchase and sales.
Fixed Asset and Logistics
Duration 3 months
Description This is a part of VIBS. This is developed for Fixed Assets and logistics.
Fixed Asset includes calculation of depreciation of used vehicles, Second hand vehicles and written off vehicles. Logistics includes movement of vehicles, Rent-e-cars and sales of second hand cars.
01. Inventory Management System.
Duration : Nov 98 to June 99( 7 Months ).
Client : ***clientName2***, Mumbai, India.
Platform : Windows - 95.
Front End (GUI) : Developer 2000
Database (Back End) : ORACLE 7.1.
Role : Analysis, Design, Programming, Testing.
Team Size : 3 Members.
Description
This system developed to automate the 'Inventory System' of the ***clientName2***, Mumbai, India. It consists mainly two parts called as 'Sales' and 'Purchase'.
Stock will be updated automatically based on the kind of transaction( 'stock delivery' or 'GRV' ) . Items average cost will be calculated by the system automatically. This system also some monitor screens to view the current stock qty and different transactions made on the item. This module is integrated with 'Financial Accounting System' so various accounts of vendors and customers will be updated automatically. Various kinds of reports like 'Item List' , 'Sales Analysis' , 'Purchase order list' 'GRV' , 'Invoice list' etc: are provided.
02. Hospital Management System.
Duration : Feb 98 to Nov 98 ( 8 Months ).
Client : ***clientName3***, Hyderabad, India.
Platform : Windows - 95.
Front End ( GUI ) : Developer 2000
Database (Back End) : ORACLE 7.0.
Role : Analysis , Design, Programming, Testing.
Team Size : 4 Members.
Description This system was developed to automate the management of the ***clientName3***, Hyderabad. It covers all the details about the doctors, patients. Complete inventory control of the stores regarding the items purchased and issued to different sections of the hospital. Complete details of the drug suppliers also maintained. It also includes payroll management to generate the payslips for the staff. It also has the reports to generate the patient's complete bills when they leave the hospital.
03. Material Management System.
Duration : Nov 97 to Feb 98 ( 3 Months ).
Client : ***clientName4***, Mumbai,India
Platform : Windows - 95.
Front End ( GUI ) : Developer 2000
Database (Back End) : ORACLE 7.1.
Role : Analysis , Design, Programming, Testing.
Team Size : 3 Members.
Description This project developed to automate the sales of the machines and to keep track the customer's information. It maintains the information about the machines to which dealer they were supplied along with the service duration period. Registration of the accessories to the main machine is provided. Raw material registration facility, updating of stock, down loading the raw materials during the bill- of - materials will be automatically carried out by the system.
Various reports also provided.
Saudi Aramco, Dhahran, KSA, As a consultant from ***employerName4*** Al-khobar, KSA.
01. Contract Management System (CMS)
Duration : Feb 1997 To Nov 1997
Team Size : 6
Database : Oracle 7.1
Front End : Powerbuilder 5.0, Robo Help
Version Control : Pvcs
Case Tool : ER Win 2.1
Platform : Oracle 7.1 Client/Server Using Windows NT
Responsibility : Design, Development, Testing & Performance Tuning.
Description The main objective of this system is to eliminate the file system. Automating contracting procedures of CMS dept . This system maintains and creates different contracts namely short form contract; Long form contract and service orders (release orders) and contractors related data. It includes completely reliable automation of data replication to remote sites. And automated control of service orders in respect to AEL. It supports attachments like Engineering drawings, word documents and Excel sheets. Document processing, controlling workflow are the main features of this system.
02. Manpower Planning System (MPS)
Duration : Sep 1996 To Feb 1997
Team Size : six
Database : Oracle 7.2
Front End : Powerbuilder 5.0, Robo Help
Version Control : Pvcs
Case Tool : ER Win 2.1
Platform : Oracle 7.2 Client/Server Using WindowsNT
Responsibility : Design, Development, Testing & Performance Tuning.
Description This system is developed specially for the purpose of eliminating discrepancies between the major Saudi Aramco manpower planning exercises namely the Operating plan, Business plan and Saudization plan. The user could create manpower database for any future period and generate reports in organization or model formats. MPS also allows the user to plan personal actions and compare that plan against those actually completed. Actions such as new-hires, promotions, reductions and retirements are included in the system. Data for this system is down loaded from IBM mainframes, it is taken from IMS database a sequential file and then through SQL loader this sequential file is loaded in ORACLE.
03. Manufacturing Operations Profit and Cost Management System.
Duration : May 1996 To Sep 1996
Team Size : 3
Database : Oracle 7.2
Front End : Power Builder 5.0, Robo Help
Version Control : Pvcs
Case Tool : ER Win 2.1
Platform : Oracle 7.2 Client/Server Using WindowsNT
Responsibility : Design, Development, Testing & Performance Tuning.
Description This is mainly a reporting system for monitoring the cost, profit flow of Saudi Aramco manufacturing department. It provides high level security and gives access to higher authorities.The reports like History of profit, History of Cost, Cost verses profit history, Item level cost & profit history, etc. of different divisions. It provides drill down graphs to monitor by different criteria. Extensively used: dynamic data windows,class user objects.
Data Logic Computer S/W & Electronics Data Processing Center, Wgl, India.
01. Servicing Information System (SIS)
Client : ***clientName5***, Hyd, India
Duration : Dec 1995 To May 1996
Team Size : 5
Database : Oracle 7.2
Front End : Developer 2000
Responsibility : Design, Development, Testing & Performance Tuning.
Description Maintenance of customer register, registration of complaints, servicing reports given by engineers in servicing register, renewal of Annual maintenance of contract, service wise schedule of engineers and preparation of different reports like call history of a given customer, performance report of a given engineer, pending servicing report, answer management queries.
Preparing list of AMC (warrant getting expired on a given month.)
02. Payroll Management System
Client : ***clientName5*** Hyd, India
Duration : Aug 1995 To Dec 1995
Team Size : 5
Database : Oracle 7.2
Front End : Developer 2000
Responsibility : Design, Development, Testing & Performance Tuning
Description This is mainly a prototype for payroll management. Action: Employee records maintenance, Loan/Advance, voluntary provident fund, over time, days worked, pay calendar, salary increase and dictionary for update. Reports: salary data of every month, overtime data of every month, master records for employees detailed information. Individual/combined salary slip, overtime for different divisions, P.F. Statement generation, advance/loan recovery statement and monthly payroll report.
QUALIFICATION
Bachelor of Engineering in Computer Science.
Passed from Gulbarga University, India in July 1995.
Developed intranet sites for division to consolidate information and provide easy access with minimal need for training. Utilized Crystal Reports, FrontPage 2000 and Internet Information Server 4 for publishing.
Lead implementation of Regional Sales Office Order Entry process at remote sites. On-site visits performed to train and users on CA-PRMS order entry and business processes.
Developed internal "Order Requirements" report using Crystal Reports, SQL and ODBC to supplement MRP generation reports. This report monitored customer orders, open purchase orders and inventory by location to provide a status by product snapshot for all departments. Copied and adapted previously mentioned report for use by manufacturing staff for components below top level of bill of material. The report has been adapted to cover all products in the division and in some cases has replaced standard AS400 MRP reports.
Developed daily reporting using macros in MS Access and scheduled file downloads from off-site AS400. Distributed daily order reports to internal staff to monitor new regional sales staff. Daily shipment reports and daily stock availability spreadsheets are emailed automatically to regional office order entry staff and distributors.
Created weekly and monthly delivery performance reporting, which, for the first time provided, an accurate quantity shipped.
Grew network to 162 nodes. Managed 182 NT users and 204 AS400 users.
Provided all CA-PRMS application support for remote and local users.
Supervised Accounting Clerk and Payroll Coordinator.
Responsible for administration of accounts payable and payroll functions.
Developed interface between ADP Payroll Service and general ledger to allocate payroll expenses to cost centers.
Prepared monthly and annual reconciliation and reporting for expenses and fixed assets.
Implemented system in coordination with Purchasing and Quality Assurance to accurately track and recover costs due to vendor scrap.
Maintained computer systems including repairs, preventive maintenance and installations for PC's, printers, hardware, software, terminals and telecom/datacom cabling.
Installed and configured hardware and software for EDI link with Caterpillar.
Served as interface between plant and off-site MIS center.
Maintain product costs, develop estimates for new products, and calculate labor rates and depreciation allocations.
Established manuals to document payroll, accounts payable, accounts receivable, inventory and MIS procedures.
Created payroll/personnel-reporting system that increased information available to management and led to timely employee reviews.
Member of ISO 9002 steering committee and audit team.
***employerName2*** Nashville, TN
Lead Accountant 8/31/94 - 1/27/95
Responsible for District Office Accounts Payable and coordination of Accounts Payable function for three branch offices.
Prepared capital asset acquisitions and tax capitalization reporting.
Responsible for District cash management reporting auditing of expense and weekly sales reports.
ADDITIONAL QUALIFICATIONS
Software Experience
Server Software
Microsoft NT Server 4.0
Microsoft Windows 2000 Server
Microsoft Proxy Server 2.0
Microsoft Exchange Server 5.5
Microsoft IIS 3 and 4
Veritas Backup Exec 8.0
Business System Software
Computer Associates PRMS Version 7.2 and 8.4
SAP R/3 3.01F
Desktop/Client Software
MS DOS, 3.x, 95, 98, NT4.0, 2000 Professional
MS Outlook 97,98, 2000
ADP E-Time, Total Time
Visio Professional
Desktop/Client Software (Cont.)
IBM Client Access 95/NT and Express
Seagate Crystal Reports 7
MS Office 95, 97, 2000
MS Frontpage 98
ADP Payroll for Windows, Payroll for DOS
MS Project 98
Extra Personal Client for 3270/5250
McAfee(NAI) Remote Control, SecureCast, Group Shield, NetShield
Specialized Client/Server Application
Walter Info Systems TDM (Tool Data Management)- Oracle
Datastream MP2 Pro - Access
Harrington Group Corrective Action Web (CAWeb)
Training
Administering Windows NT
ISO 9000 Internal Auditor
BC400 SAP Intro to ABAP/4
BC420 SAP ABAP/4 Data Interfaces
Autotester for Client Server
SAP50 SAP R/3 Basis Technology
BC405 SAP ABAP/4 Workbench Reporting
BC430 SAP ABAP/4 Dictionary
EDUCATION
Bachelor of Science: Accounting 1994
Clemson University, Clemson, SC
Systems Analyst and Application Developer with skills in SQL Server, Visual Basic, MS Access and Focus.
Strengths include developing specifications based upon a client's goals and objectives. Lecturer with expertise teaching undergraduate courses in Systems Analysis and Project Management.
PROFESSIONAL EXPERIENCE
***employerName1***
Consultant - Systems Analyst (April 2000 - February 2001)
Relocation Center Web Site - Relocation Center is designed for ***employerName1***'s clients and their employees. The site contains various web based tools to assist with the employee's relocation.
Responsibilities:
Developed detailed systems specifications based upon business requirements
Developed prototype web sites for review by business and development teams
Communicated systems requirements to development and testing teams
Designed web based applications for the site including: Discussion Forum, Relocation Cost Estimator and Property Management Inspections
Prepared interactive presentations for various internal/external conferences
Development Environment: MS SQL Server 7.0, HTML, JAVA Script, VB Script, MS Visual SourceSafe 6.0, MS Internet Information Services , MS Transaction Server
Project Tools: MS Project, Caliber-RM, Mercury Test Director, MS Front Page
***employerName2*** New York, NY Systems Analyst (1991-2000)
Responsible for development of information systems to manage the transportation of oil and gasoline products
Constructed SQL Server database to automate the scheduling of tug and barge activities
Coordinated replacement of manual tasks with real-time data entry screens written in MS Access and Visual Basic
Established procedures to support 24x7 dispatching operations
Developed automated tools to increase vessel utilization by identifying marketing opportunities
Produced enhanced vessel positioning data that improved scheduling of voyages and reduced delays
Instituted automated invoicing procedures to decrease billing time for various lines of business
Developed Focus and MS Access payroll systems for use onboard company owned vessels
Designed automated system to monitor and control cash disbursements to port agents
Implemented reporting system for vessel repair and maintenance projects
Created various costing and financial forecasting models
Development Environment: MS SQL Server 6.5, Visual Basic, MS Access, Focus
***employerName3*** New York, NY
Senior Financial Analyst (1989-1991)
Responsible for financial and economic analysis of refining, marketing and gas station operations
Performed economic evaluations of capital projects
Prepared financial forecasts and comprehensive analysis of inventory reserve components
Monitored forecasting methodology to incorporate changing business practices and analysis requirements
Developed inventory valuation model and recommended hedging strategies based upon forecasted values
***employerName4*** Woodcliff Lake, NJ 1987 - 1989
Senior Financial Analyst
Analyzed manufacturing and marketing of voice/data/video communications equipment
Administered $200 million operating budget and $50 million capital spending plan
Developed monthly and quarterly financial reviews for distribution and presentation to senior management
Worked with manufacturing to reduce tariffs by obtaining raw materials from local sources
Provided analytical support for new product development
Responsible for financial analysis associated with negotiations to sell $10 million lease portfolio
***employerName5*** Stamford, CT 1982 - 1987
Financial Analyst
Performed financial analysis and marketing support in the real estate and mortgage banking divisions
Assisted in preparation of the annual business plan and capital budget and presented periodic operational reviews
Developed performance measurement system for real estate and mortgage banking subsidiaries
Issued competitive analysis and market share reports and developed sales information management database
Managed publication of the "Annual Survey of Employee Relocation Policies"
OTHER PROFESSIONAL EXPERIENCE
Marist College
1999 - Present
Poughkeepsie, NY
Taught undergraduate Information Systems courses
Systems Analysis Methods
Project Management
Independent Consulting
1996 - Present
MS Access and Visual Basic
Developed billing, commission and payroll reports for a nationwide entertainment company
Created insurance and billing forms for private medical practices
EDUCATION
New York University - Leonard N. Stern School of Business
MBA 1985
University of Pennsylvania - Wharton School
Bachelor of Science in Economics 1981 - Major in Finance