Please note that some projects were done concurrently with other projects.

Renkara Media Group (RMG) was among the first iPhone application developers, working with the iPhone SDK shortly after it was announced by Apple. Quickly developing solid expertise in this new technology, RMG soon became one of the top iPhone application development companies in the world. Our team specializes in developing intuitive and elegant iPhone applications.

iPhone Software Development Kit (SDK), Quartz, Core Animation, and Core Graphics, Core Audio, Audio Video Foundation, and Audio Queue Services, RPC-XML

My responsibilities as the Director of Research and Operations are as follows:

• Contribute in the design, implementation, and delivery of over two hundred iPhone® and iPod touch® applications
• Manage customer service and support
• Work closely with content partners in managing and maintaining applications

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.

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 Printers

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

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.

Microsoft .NET C#, ASP .NET, Microsoft Visual Studio .NET, Microsoft SQL Server 2000, Windows 2003 Server, IIS, Microsoft Visio, Axosoft OnTime Defect Tracker

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

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.

Microsoft Visual Studio .NET, Microsoft .NET C#, ASP .NET, Microsoft SQL Server 2000, Windows 2000 Server, IIS, Microsoft Visio, Adobe PhotoShop

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

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.

Microsoft Visual Studio .NET, Microsoft .NET C#, ASP .NET, XML, Microsoft SQL Server 2000, Windows 2000 Server, IIS, Microsoft Visio, Adobe PhotoShop

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

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 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

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.

Microsoft Access 2002, Microsoft Excel, Windows XP

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

Provided Microsoft Office applications and Crystal Reports training as a technical trainer at a corporate training facility called Directions Training.

Microsoft Access, Crystal Reports 8.5, Microsoft Excel, Microsoft Word, Microsoft PowerPoint, Microsoft Visio

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.

Lotus Domino R5, Java, XML, HTML, DHTML, LotusScript, JavaScript, Adobe Photoshop, MS Project, Visio, Windows NT 4.0 Server, LDAP (Lightweight Directory Access Protocol), SSL

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

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.

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 Builder

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

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.

Lotus Domino R5, HTML, DHTML, JavaScript, Adobe Photoshop

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

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.

Visual InterDev, Windows NT 4, IIS, Lotus Domino 4.6.x, HTML, DHTML, JavaScript, LotusScript, Active Server Pages, Visual SourceSafe

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

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.

Lotus Notes/Domino 4.x, HP/Unix, Host Presenter, Exceed, Expert Advisor, Notes Calendar, Organizer GS

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

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.

HTML, Microsoft FrontPage, Microsoft SQL Server 6.0, Windows NT 4.0 Server, BackOffice, Microsoft Access, E-Commerce, Microsoft Merchant Server

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

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.

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, Visio

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

The project involved data warehouse development methodology and issues surrounding the planning of a successful data warehouse.

Microsoft SQL Server 2000, Microsoft SQL Server 2000 Analysis Services, OLAP, Data Transformation Services, Visio Professional

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