Ahu Sieg 641 Huntington Blvd. • West Dundee, Illinois 60118 • 847-903-1401 • ahusieg@yahoo.comEXECUTIVE SUMMARY Nine years of extensive IT experience as developer in web and client/server technologies covering all phases of system development including business requirements analysis, architecture and design, user interface design, hands-on development, testing, and implementation. Excellent interpersonal and communication skills. Academic teaching experience as a part-time faculty member at DePaul University in Chicago, Illinois.
References are available upon request.
EDUCATION - Ph.D. candidate in Computer Science
Research Area: Artificial Intelligence
DePaul University, School of Computer Science, Telecommunications, and Information Systems - Master of Science Degree in Management Information Systems
Benedictine University, 2000 - Bachelor of Science Degree in Computer Science and Business Administration
Illinois Wesleyan University, 1997
Coursework IncludesCERTIFICATIONS - Microsoft Certified Solution Developer for .NET - MCSD
Exams Passed
70-229: Designing and Implementing Databases with Microsoft SQL Server 2000 Enterprise Edition
70-300: Analyzing Requirements and Defining Microsoft .NET Solution Architectures
70-315: Developing and Implementing Web Applications with Visual C# .NET and Visual Studio .NET
70-316: Developing and Implementing Windows-based Applications with Visual C# .NET and Visual Studio .NET
70-320: Developing XML Web Services and Server Components with Microsoft Visual C# .NET and the Microsoft .NET Framework - Microsoft Office Specialist
Expert Certification in Office XP - Principal Certified Lotus Professional
Application Development
System Administration
INDUSTRY EXPERIENCE International Restaurant Chain, Petroleum, Internet Provider, Computer Manufacturing, Corporate Training, Real Estate, Office Products Supplier, Shop-at-Home Service
TECHNOLOGIES | Languages | C# .NET, ASP .NET, Visual Basic .NET, Java, XML, HTML, DHTML, JavaScript, JSP, LotusScript, C++, Perl | | Databases | SQL Server 6.5/7/2000, Microsoft Access 97/2000/2002, Lotus Domino R5, Lotus Domino 4.6, ORACLE | | Programming Tools | Microsoft Visual Studio .NET, Microsoft Visual Interdev 6, Lotus Notes/Domino 4.6 - R5, Borland JBuilder | | Operating Systems and Protocols | Windows 2003 Server, Windows XP, Windows 95/98/2000, Windows 2000 Server, Windows NT 4.0, MS/DOS, HP/UNIX, TCP/IP, DNS, SSL, SMTP, LDAP | | Data Warehousing | SQL Server 2000 Analysis Services, Data Transformation Services, OLAP | | Graphics/Multimedia | Adobe Photoshop 6.0, Adobe Illustrator, Macromedia DreamWeaver, Image Composer, Microsoft FrontPage | | Office Software | All versions of Microsoft Office, Microsoft Project, Microsoft Visio | | Other Technologies | Internet Information Services, Microsoft Visual Source Safe, Web Services, Crystal Reports 10.0, Crystal .NET, Remote Desktop Connection, Macromedia JRun, WebTrends, Axosoft OnTime Defect Tracker, ERwin, Zebra Barcode Printers |
PROFESSIONAL ORGANIZATIONS ACM - Association for Computing MachineryIEEE - Institute of Electrical and Electronics EngineersUpsilon Pi Epsilon Honor Society
PROFESSIONAL EXPERIENCE Please note that some projects were done concurrently with other projects.
| Empire Today – Inventory Management System | September 2004 – Present |
The project involved developing a system called EIMS - Empire Inventory Management System. EIMS automates all warehouse activities by leveraging bar-coding technology, improves allocation of materials to orders to minimize remnant inventory, provides reporting capabilities, and provides efficiency in purchasing and receiving of materials. Majority of the users have wireless access to the system using handheld scanners with Microsoft Pocket Internet Explorer. The system can also be accessed on a desktop or laptop using Internet Explorer. The barcode labels are printed using Zebra Barcode printers.
Technologies Used Microsoft .NET C#, ASP .NET, Microsoft Visual Studio .NET, .NET Web Services, Windows Services, Microsoft SQL Server 2000, Epicor, Windows 2003 Server, IIS, Crystal Reports, Crystal .NET, Log4Net, Microsoft Visio, Zebra Barcode PrintersResponsibilities My responsibilities as one of the lead developers on this project were as follows:- Developed the system using ASP. NET and C#
- Implemented the data access layer for the application using the Microsoft Application Block for Data Access
- Wrote stored procedures to retrieve, add, and update data from the SQL Server database
- Used Visual SourceSafe 6.0d for source control
- Wrote .NET Web services to interact with the order entry system
- Developed .NET Web services to interact with Epicor which is used as the accounting software
- Developed a variety of reports using Crystal Reports and Crystal .NET
- Implemented Windows services to provide additional reporting capabilities
- Used Zebra Programming language to generate barcode labels
- Utilized log4net for logging
- Participated in meetings to gather and analyze business requirements
- Documented the functional requirements specification for the system
| Empire Today – Order Recovery System | April 2004 – August 2004 |
The project involved designing, developing, and implementing a system to automate the order recovery process. The project team included me as the technical lead at the client site and a team of offshore developers.
Technologies Used Microsoft .NET C#, ASP .NET, Microsoft Visual Studio .NET, Microsoft SQL Server 2000, Windows 2003 Server, IIS, Microsoft Visio, Axosoft OnTime Defect TrackerResponsibilities My responsibilities as the technical lead on this project were as follows:- Participated in meetings to gather and analyze business requirements
- Documented the functional requirements specification for the system
- Created the user interface design specification
- Created a very detailed technical design document
- Communicated the functional and technical requirements to the offshore resources
- Provided technical guidance to the offshore resources on a daily basis
- Engaged in the development tasks using C# and ASP .NET
- Wrote stored procedures to retrieve, add, and update data from the SQL Server database
- Used Visual SourceSafe 6.0d for source control
- Prepared and executed test scripts
- Used Axosoft OnTime for tracking defects and enhancements
- Wrote a user manual for the system
| Quill – Dash Board Application for Sales Team | January 2004 – February 2004 |
The project involved training the Information Systems department of Quill in developing Web applications using ASP.NET, C#, and Visual Studio .NET. After a one week training course, everyone in the department was divided into six development teams. The project teams were given the responsibility of developing certain functional areas of a Web application. The purpose of the application was to provide a dash board for the sales team where they could maintain accounts that are involved in the preferred customer program, track customer calls, review account performance data, and review the performance of account representatives.
Technologies Used Microsoft Visual Studio .NET, Microsoft .NET C#, ASP .NET, Microsoft SQL Server 2000, Windows 2000 Server, IIS, Microsoft Visio, Adobe PhotoShopResponsibilities My responsibilities as developer on this project were as follows:- Developed training materials and instructed a course on developing Web applications using ASP.NET, C#, and Visual Studio .NET
- The course also included overview of the .NET Framework and ADO.NET
- Created the functional requirements specification for the dash board application
- Divided up the development effort among the six teams and assigned each team a specific functional area
- Lead all of the teams in their development efforts
- Developed the main user interface for the system using ASP. NET with C# code behind
- Implemented the data access layer for the application using the Microsoft Application Block for Data Access
- Wrote stored procedures to retrieve, add, and update data from the SQL Server database
- Used Visual SourceSafe 6.0d for source control
| Falcon Living Real Estate – FalconLiving.com Project | October 2003 – November 2003 |
The project involved designing and implementing a web site for this small real estate firm. Falcon Living Real Estate did not have a web presence prior to this project. The goal of the web site was to introduce the firm to the clients, allow them to perform MLS searches, provide tools such as mortgage calculators, and get in contact with real estate agents. The project also involved developing a robust web-based content management tool which can be used by non-technical users to add content to the web site.
Technologies Used Microsoft Visual Studio .NET, Microsoft .NET C#, ASP .NET, XML, Microsoft SQL Server 2000, Windows 2000 Server, IIS, Microsoft Visio, Adobe PhotoShopResponsibilities My responsibilities as developer on this project were as follows:- Built a web site using the .NET framework and Microsoft SQL Server
- Designed and developed a web site using the .NET framework and Microsoft SQL Server
- For the development of the project, used the Microsoft Visual Studio .NET as the IDE
- Developed the web pages using ASP .NET with C# code behind
- Used ERwin to design the logical data model and the physical database schema of the backend database
- Used ADO.NET for data access and wrote several SQL Stored Procedures
- Designed the XML schema for the XML documents that are utilized by the content management system, wrote XPath code to query the XML documents
- Used Microsoft Visual Source Safe for version and source code control
- Participated in meetings to gather and analyze business requirements
- Participated in design and project status meetings
| DePaul University – Instructor | January 2004 – April 2004 |
Taught IS422 - Information Systems Design as a part-time faculty member at the School of Computer Science, Telecommunications, and Information Systems. The course is an introduction to the systems design and implementation phases of the software development life cycle. It emphasizes techniques for developing a logical and physical design from a systems analysis.Responsibilities Responsibilities include teaching the following:- Selecting the best alternative design strategy
- Detailed process modeling and data modeling
- Designing databases
- Designing forms and reports
- Designing interfaces and dialogues
- Finalizing design specifications
- Designing distributed systems
- System implementation
- Maintaining information systems
- Rapid application development
| DePaul University – Instructor | January 2003 - June 2003 |
CSC240 - Personal Computing for Programmers. The course is an introduction to relational database concepts using PC databases; data access methods; structured query language (SQL); query by example; networks and the use of networks to share data. The course also involves the use of spreadsheets and macro languages.
Technologies Used Microsoft Access 2002, Microsoft Excel, Windows XPResponsibilities Responsibilities include teaching the following:- Relational database concepts and rules
- Creating entity-relationship diagrams
- Enforcing referential integrity, and implementing different join types including inner joins, left-outer joins, right-outer joins, and self-joins
- Creating databases in Microsoft Access, setting field properties to establish primary keys, providing default values, and validating user input
- Creating tables and maintaining data using tables
- Creating queries including parameter queries, action queries, and SQL queries
- Designing and creating forms for displaying data as well as gathering user input
- Creating reports, using advanced reporting techniques such as sorting, grouping, and summarizing of data
- Creating data access pages to make data available on the Web
- Building a user interface for the database application using Switchboard forms, command buttons, and macros in Microsoft Access
- Exporting and importing data using spreadsheets
| Directions Training – Technical Trainer | June 2003 - October 2003 |
Provided Microsoft Office applications and Crystal Reports training as a technical trainer at a corporate training facility called Directions Training.
Technologies Used Microsoft Access, Crystal Reports 8.5, Microsoft Excel, Microsoft Word, Microsoft PowerPoint, Microsoft Visio
| McDonald’s Corporation – Global Toolkit Project | January 2000 – March 2002 |
The project involved developing a product called the Global Toolkit. The Global Toolkit delivers a common Intranet / Extranet solution for countries, departments, regions, and special workgroups. The product provides a consistent architecture and template set. It eliminates redundant / duplicate development efforts as well as standardizing development approach and practices within the company on a global level. The Global Toolkit also provides a robust web-based content management tool which is easy to use by non-technical users. I traveled to Sweden and worked closely with the team in Stockholm on this project. We had weekly meetings with the Swedish team via video conference. I was involved in preparing and executing test plans, and system documentation as well as development of the product. As of March 2002, the Global Toolkit product was being used by 16 different countries and 35 departments in the United States. I was responsible for coordinating the development efforts for the new releases and distribution of these releases to all parties.
For the initial implementation of the product, I traveled to Sao Paulo and created an Intranet site for the marketing department in Brazil. I was responsible for analyzing business requirements, information architecture and design, developing project estimates, and training. I trained developers with technical skills on the product as well as non-technical users. Additionally, I wrote a user manual that was distributed internationally to all locations using the product.
Technologies Used Lotus Domino R5, Java, XML, HTML, DHTML, LotusScript, JavaScript, Adobe Photoshop, MS Project, Visio, Windows NT 4.0 Server, LDAP (Lightweight Directory Access Protocol), SSLResponsibilities My responsibilities as technical lead and developer on this project were as follows:- Analyzing business requirements
- Information architecture and design Development of the product using Lotus Domino R5 databases, HTML, DHTML, and JavaScript
- Creating Web agents within the Lotus Domino R5 databases using Java and LotusScript
- Writing Java code to interface with LDAP in order to determine the names of users who were required to log into the system using specific user IDs
- Creating Domino forms to display XML data
- Creating web user interface elements such as images and navigation buttons using Adobe Photoshop
- Ensuring browser compatibility when implementing any new functionality
- Developing project estimates using Microsoft Project
- Training developers with technical skills on the product
- Training non-technical users
- System documentation
- System testing
- Maintaining release schedules and implementing new releases
- Wrote a user manual that was distributed internationally to all locations using the product
| McDonald’s Corporation – Department Intranet/Extranet | December 2000 – April 2001 |
The project involved developing an Intranet / Extranet solution for the Worldwide Marketing department. The website is available to employees, vendors, suppliers, and agencies from all over the world. This site allows users to search for department information, share knowledge by participating in discussions on topics of interest, and communicate on a global level. I was responsible for analyzing business requirements, implementation, and training. I also played an important role in integrating the departmental website into the company’s worldwide portal. I also provided advice in setting up the web site security, using Domino and LDAP in combination with digital certificates.
Technologies Used Lotus Notes Domino R5, Java, XML, HTML, DHTML, LotusScript, JavaScript, Adobe Photoshop, MS Project, Visio, Windows NT 4.0 Server, LDAP (Lightweight Directory Access Protocol), SSL, Digital Certificates, Yahoo Portal BuilderResponsibilities My responsibilities as developer for McDonald’s were as follows:- Analyzing business requirements
- Information architecture and design
- Implementation of the website using Lotus Domino R5 databases, HTML, DHTML, and JavaScript
- Creating web user interface elements such as images and navigation buttons using Adobe Photoshop
- Training non-technical users on the website
- Creating Domino forms to display XML data in order to integrate the departmental website with the McDonald’s worldwide portal, which uses Yahoo Portal Builder
- Providing expert advice in setting up the site security
- Providing advice on using Domino and LDAP in combination with digital certificates
| BP Amoco – Intranet Project | October 2000 – November 2000 |
The project involved prototyping a corporate intranet solution for BP Amoco using Lotus Domino R5. The objectives for the intranet system were ease of collaboration, user-friendliness, availability and organization of information. Various forms of documents such as Microsoft Word documents, spreadsheets, paper/fax copies, and printed manuals were to be used as content on the web site. Several Lotus Notes databases were designed to store these documents and make them accessible via the web.
Technologies Used Lotus Domino R5, HTML, DHTML, JavaScript, Adobe PhotoshopResponsibilities My responsibilities as developer were as follows:- Gathering and organizing content
- Designing the databases using Lotus Domino R5
- Designing and coding the navigation for the web site using HTML, DHTML, and JavaScript
- Working with the graphics to be used on the site to optimize them for the Web
| McDonald’s Corporation – Corporate Intranet (Archie) | January 1999 – December 1999 |
The McDonald’s corporate intranet was called “Archie”. The Intranet was to be rolled out to the 3,000 Oak Brook employees with a view toward rolling out to all 8,000 or so US domestic employees. Access to some Intranet applications would be given to McDonald’s suppliers via the extranet and to the owner/operators of stores. The Intranet would then be rolled out internationally. The system was hosted in various point releases of R4.6.x of Lotus Domino and IIS 4 on NT 4. All of the Intranet data including articles, press releases, etc. were stored in Notes databases for security reasons. The home page of the Intranet and the content editor were written in ASP and hosted on IIS. The home page was made up of modules which were periodically updated by an NT service. The content management interface was used by almost 100 content managers throughout the organization to post their articles and other content.Technologies Used Visual InterDev, Windows NT 4, IIS, Lotus Domino 4.6.x, HTML, DHTML, JavaScript, LotusScript, Active Server Pages, Visual SourceSafeResponsibilities My responsibilities as developer for McDonald's were as follows:- Worked with a team of developers to develop the system using Lotus Domino, HTML, DHTML, JavaScript
- Created Lotus Notes agents using formulas and LotusScript
- Wrote requirements and detailed design documentations
- Monitored and reviewed usability studies
- Designed and implemented the user interface for the content editing tool using ASP running on IIS
- Visual InterDev was used to maintain the ASP code, Visual SourceSafe was used for version control
- Evaluated 3rd party search tools
- Prepared and executed test plans
- System documentation
- Assisted in migration from development to staging to production
- Assisted with server and application stress/load tests
| McDonald’s Corporation – System Administration | August 1997 – January 1999 |
Functioned as a Lotus Notes System Administrator on the System Administration/Notes Support project. The company utilizes Lotus Notes for both their e-mail and Intranet. The e-mail and Intranet systems hold many database applications that served all home office and regional employees.Technologies Used Lotus Notes/Domino 4.x, HP/Unix, Host Presenter, Exceed, Expert Advisor, Notes Calendar, Organizer GSResponsibilities My responsibilities as system administrator were as follows:- Providing second level support for users
- Monitoring the servers
- Registering new users
- Installing applications on users’ machines
- Troubleshooting Notes group calendar and scheduling problems
- Restoring backup files
- Migrating databases from the development environment to the production environment
- Assisted in migrating users to the company’s new mail servers
| Advanced Microsystems – Online Shopping | April 1996 – May 1997 |
The project involved creating a virtual mall on the Internet for a computer retail store. Microsoft Merchant was used to develop the virtual mall as a part of Microsoft’s beta testing of this product. The system was highly integrated with SQL Server 6.0.Technologies Used HTML, Microsoft FrontPage, Microsoft SQL Server 6.0, Windows NT 4.0 Server, BackOffice, Microsoft Access, E-Commerce, Microsoft Merchant ServerResponsibilities My responsibilities as analyst and developer were as follows:- Designed, developed, and maintained the database for the on-line store using Microsoft SQL Server 6.0
- Administered the security for the SQL database
- Communicated with Microsoft to be able to participate in the beta testing for the Microsoft Merchant product
- Created HTML pages using Microsoft FrontPage
ACADEMIC RESEARCH | DePaul University – ARCH Project | July 2001 – current |
The effectiveness of Internet search engines is often hampered by the ambiguity of user queries and the reluctance or inability of users to build less ambiguous multi-word queries. Our system, ARCH (Adaptive agent for Retrieval based on Concept Hierarchies), is a client-side web agent, which incorporates domain-specific concept hierarchies together with interactive query formulation in order to automatically produce a richer and therefore less ambiguous query. The system also observes the user’s past browsing behavior and passively learns user profiles which are utilized to provide additional context to the initial query.
Technologies Used Microsoft Visual Studio .NET, Microsoft .NET C#, XML, Java Server Pages (JSP), Java, Allaire Jrun, Microsoft Access, Microsoft SQL Server 2000, Tomcat / Jakarta, Windows 2000 Server, IIS, Borland JBuilder Enterprise Edition, VisioResponsibilities My responsibilities as researcher are as follows:- Designed the object model using Microsoft Visio and implemented the code using Microsoft .NET C# and ASP .NET
- For developing the system, used the Microsoft Visual Studio .NET as the IDE and the .NET framework as the computing platform
- Used ERwin to design the logical data model and the physical database schema of the backend database
- Implemented the database using Microsoft SQL Server 2000 and enforced referential integrity to prevent inconsistent data
- Wrote several SQL Stored Procedures and used ADO.NET for data access
- Used serialization to facilitate the persistence of system objects by transforming their data members into XML
- Designed the XML schema for the XML documents that are utilized by the system, wrote XPath queries to extract nodes from these XML documents
- Used Microsoft Visual Source Safe for version control
- Before the system was converted to use Microsoft technologies, the original system code was written in Java using the J2EE framework
- Used Borland JBuilder Enterprise Edition to code the front end using JSP and HTML running under Macromedia JRun
- Programmed database connector objects via JDBC interface to SQL Server 2000 database
DePaul University – Data Warehousing Project | September 2002 - December 2002 |
The project involved data warehouse development methodology and issues surrounding the planning of a successful data warehouse.
Technologies Used Microsoft SQL Server 2000, Microsoft SQL Server 2000 Analysis Services, OLAP, Data Transformation Services, Visio ProfessionalResponsibilities My responsibilities were as follows:- Prepared data warehouse bus architecture matrix
- Dimensional modeling
- Used Data Transformation Services for analysis, transformation, and loading of data into the data warehouse
- Used Microsoft SQL Server for the implementation of the data architecture and physical design
- Used Microsoft SQL Server 2000 Analysis Services to aggregate data and create multi-dimensional OLAP cubes
- Data quality in the data warehouse and metadata
|
