designed Data ware house and dashboard for department of telecomunication and post ICT. project with Microsoft, involved From KPI desginning with analyst team till stageing Data warehouse desginning and cube and implementation and also involved in ETL process with ETL developer ,our reporting tool was Dundas BI and I was involved in reporting too.

Working as DBA as well as BI consultant

I am working part time as SQL Server DBA for Dorsa I am responsible for Performance tuning, Database Designing, Data Migration etc as DBA and Data warehouse consultant as well.

I am currently working as Data warehouse Consultant and Business intelligence expert in Tax Administration and Reform Automation (TARA) Program .

Mr. Khorram is working as database administrator on Namvaran high-tech. I was responsible for day to day Operation for production databases as well as developing new databases in Namvaran. I was also responsible for any changes in database structure as well as database optimization and performance. I have created many new stored procedure as well as ad-hoc report on existing database. I have done SharePoint administration and software development in VB.NET as well.

Mr. Khorram is working as production support/system analyst on sunrise Senior living Budgeting system This system was responsible for communities budgeting and it was written in combination of Excel macro ,ASP ,and Visual basic. The back end system also has SQL server . I was responsibleTo write a sql script to upload Excel spreadsheet and inserted into sql database.

Developed, designed and maintained Relational Data warehouse in SQL server, I was responsible for enhancement of data model as well as writing a ETL script for Data migration from legacy system intoData warehouse. I was also responsible for writing many different Reports on Data warehouse.

Maintained and enhancement of Complex web application for NIH and NIDA in VB.NET as well enhancement and maintenance of its data base, and working as database programming by SQL server on this Project.

Performed database migration and data conversion by writing a complex script in T-SQL to convert the old database (SQL Server 2000) to a new database (SQL Server 2000) with new database schema.Designed and implemented a 95th Percentile Billing report web application using VB.NET/ASP.NET and SQL Server.Performed software reverse engineering and source code documentation for Health Care System written in ASP/VB. Created ER diagrams, Source code inventory, Flowcharts, and many other Reports using Erwin and LivingDoc.Created a web application to use IIS Indexing service to generate a Custom Source code inventory, utilizing XML and Excel.

Designed and developed Courier Web application in VB.NET and SQL server in order to support IMF Global meeting.in the mean time I also help other project for World Bank .Created a database programming to build an economic model for various financial institutes, to be used by World Bank economists for the purpose of analysis, and eventually transfer it into other analytic applications over the internet using web services in VB.NET and SQL Server 2000.Designed and implemented an economic model from Excel into Dataset.

Primary responsibilities included Web application programming and database design for E-learning systems and video conferencing in VB.NET, ASP.NET and SQL Server 2000.Designed and implemented Web services for Events.Designed and implemented Event calendar/Event registration.Designed and implemented Appointment and Room Management system.Designed and implemented database for E-learning systems.

Primary responsibilities included Database administration (SQL Server 7.0 and 2000) and Web application programming. Supported 5 Hub managers and 15 Program managers internally and generated reports for external customers.Designed and implemented various Web Applications systems in ASP and Visual Basic with SQL Server 2000.Developed and tested the new Inventory Management system using Visual Basic and ASP.Maintained existing applications and developed new reports using Visual Basic, Crystal Reports and Vantive. Analyzed data from various SQL Server databases to create the reports.Designed and implemented a Web application for tracking Telecommunication circuits in ASP, Visual Basic and JavaScript. This application was responsible for 5000 live circuits owned by Hughes Network Systems and generated reports for management and internal clients.Wrote business logic for Circuit Inventory system in VB Script.Designed and implemented a Web application for network engineers that is used to track network engineering assignments for 2000 customers. The system generates reports and updates information regarding customers and related issues.Designed and implemented a disaster recovery system used in the event of satellite failure or other major communication interruption. This system enables personnel to manage major network recovery activities.Performed database migration and synchronization.Developed ad hoc reports using Crystal Reports and Visual Basic for internal clients in the form of a Web report or an Excel spreadsheet.Maintained day-to-day database administration for three databases including a Disaster Recovery database with over 200,000 records. Synchronized Oracle database with SQL server database using DTS package .