Working on an existing Market Research application, I tackled the following tasks.
- Single sign-on: Allows external users who’ve authenticated at their company, to pass encrypted credential information to People Metrics reporting hub for login and access
- True XLS file upload/download: Developed import export modules in C# to update and download actual Excel 2003 and 2007 files, rather the CSV files. Allowed foreign language sample data to be imported to the system.
- Complete multi-lingual support: Developed C# libraries to interface with the existing ASP code to allow UTF-8 encoding for all language text, rather than the variety of code-page specific data stored in the database.
- SQL Optimization and support: Wrote numerous procedures and added optimizations to speed up reporting and database operations. Primary SQL 2005 support, while new development is using SQL 2008.