 |
• Evaluation of current business needs for citizenship status
screening in acordance with the requirements set forth by the
U.S. Department of Homeland Security
• Design of database to support requirements
• Implementation of database, consultation on data transfers from
previous database
• Evaluated existing
databases and business use
• Conducted full requirements analysis
• Mapped business processes into process
flow diagrams, translated existing IT environment into system diagrams
• Reverse engineered existing production
databases, analyzed and evaluated design, scalability, and the
databases' ability to
support
the company over the next
5 to 6 years
• Drew up a list of modifications to enhance
performance and flexibility, organized by most–critical–first;
currently implementing
the modifications
• In 2003, updated DBMS to a new
version; modified user interface
• 1996-’97 evaluated business processes and existing
Paradox database
• Gathered requirements, designed and developed shared database that
allowed company to manage apartment units and renters and generate
reports
• Developed data processes to export data to Federal government mandated
reports
• Chose hardware and networking components, installed new database
and desktop applications
• Developed backup strategies and trained users
• Evaluated existing database
and application with a view toward replacing them
• Helped principal of the company
choose computing hardware, software, and networking solutions
• Completed installations and trained staff
• Evaluated possibility of replacing
FoxPro database management system and graphical user interface
(GUI), written in PAL (proprietary
programming language of FoxPro), with more current software in
order to support hand-held devices
• Brought in to evaluate existing
database and application
• Advised regarding requirements and database design
• Helped principal of the company
choose computing hardware, software, and networking solutions
• Installed equipment and trained staff
• Reviewed project requirements, SQL
Server 7 data model, physical requirements of the data model and
security requirements
• Reviewed progress on SAS to SQL Server integration
• Analyzed existing table design
• Re-architected some existing tables on current database
to improve performance
• Discussed data loading schemes and plans and the possibility
of using stored procedures to automate calculations
• Conducted physical design walkthrough
• Implemented new staging and production databases
• Evaluated design of two additional databases, made changes
and distributed files at client site
• Validated stored code data procedures to ensure “clean” data
in the production databases
• Planned role-based security access to the database environment
• Created and implemented audit logs
• Wrote and tested data pump procedures to transfer “cleansed” data
from the staging to the production databases, set up to run as
a batch procedure
•
Coordinated with client-side application programmer
to ensure smooth functioning of operations
•
Developed database
views for statistical analysis
• Developed, tested and implemented
backup and recovery strategies for all databases
• Developed and implemented handoff strategy
• Evaluated the feasibility of setting
up a repository, the Data repository, of financial data characteristics
for client’s
company, to assist with evaluating investments and managing portfolios
• Designed and implemented database on Microsoft MSDE
• Redesigned client interface, tested, installed and trained
clients
• Discussed requirements and developed
strategy for student retention data mart project
• Created model for Regis data mart
• Analyzed requirements and revised specifications
• Developed physical database model
• Created database
• Developed transform routines for source data
• Tested data ETL routines and analyzed data for accuracy
• Developed handoff procedures to Regis IT group
• Designed a database for the editors
so they could track articles, authors, the editing and publication
process
• Reviewed and analyzed database configuration,
assisted in developing short-term and long-term plan of action
for future operations and
performance enhancements
• Evaluated existing member management
software
• Made recommendations regarding requirements and database design
• Evaluated database design and analyzed
specific elements
• Devised alternative subschemas
• Discussed potential database platforms, reviewed data types and
lengths and suggested modifications
• Reviewed key fields and indexing, use of surrogate keys and what
should be indexed
• Analyzed existing distributed
database system
• Gathered new requirements, interviewed personnel
• Helped IT Manager select server software and hardware for new system
• Designed and developed mission-critical transactional database
and client interfaces to facilitate the functions of: academic
department management, course scheduling, textbook ordering, class
evaluations, faculty management, human resource management, student
advising and other student services, facilities management, marketing,
statistical reports for executive management
• Integrated the transactional database into the DU registration
system
• Developed role-based security
• Designed, tested and implemented backup and recovery schemes
• Implemented transactional replication
• Guided the development of the first Intranet at University College
and worked with the Web programmer to provide dynamic data from
the data mart
• Organized the various people writing reports and directed them
to extract data from the data mart, relieving the transactional
database from the overhead of multi-mode locking
• Implemented Microsoft Query in desktop applications including Excel
and Word, and trained personnel on how to create pivot table reports
and complete mail merge operations
• Completed handoff to college staff
• Helped company principal choose
computing hardware, software and networking solutions; completed
the installation and trained
staff
• Met
P2000 test group representatives
• Participated in product demonstration and discussion of Asset Manager
analysis and report preparation
• Assisted company principal to choose
computing hardware, software and networking solutions
• Completed installation and trained staff
• Consulted on database design and architecture
• Evaluated business processes and existing Paradox
database
•
Gathered requirements,
designed and developed shared database and user
interfaces
(GUI’s) that allowed organization to record data about wetlands flora
and fauna by location and generate reports
• Chose hardware and networking components
• Installed new database and desktop application, developed backup strategies
• Trained users and completed handoff to Wetlands Division staff
.
• Installed mortgage workflow control database
application and trained users at
various sites in New York State, Virginia, and Washington, D.C.
• Developed reports and modified user
interfaces for database/application development project already
underway
• Trained users in workflow tasks for mortgage applications
and assignments
• For a sales management database
application, added editing to customer profiles, changed working
and allowed editing on customer and consultant
forms, enforced rules to ensure that all needed information was
supplied
• Added company pricing tables, made all menu options keyboard accessible
• Added a fax file for consultants, ability to print all consultant
information on reports
• Added cost justification and business summary reports to the application
• Performed technical evaluation of
ESP software package to support company marketing
• Reviewed system functions at the application level, collecting,
reviewing and evaluating information on the DBMS, as well as evaluating
the system documentation
• Wrote and presented the technical evaluation as part of a complete
evaluation of the business
• System requirements and analysis for a
point-of-sale inventory control system, hot-to-inventory, integrating data from
central warehouse and retail outlets.
• As first Membership committee
chair, developed membership database that recorded members’ demographic
information; individual skills by product, category and level of
expertise
• Developed capability to generate reminder notices and telephone
and fax capability from the membership roster
• Developed company’s first
inventory system for computer tapes and geophysical exploration
information
• Integrated the system with GIS package already in place
• Developed user interfaces and documentation
• Trained users and performed handoff to client
• Developed menu driven, interactive
GIS database and geophysical exploration inventory system
• Developed user interfaces and wrote documentation
• Trained users and executed handoff to client
|
|
