1. Also, please study up on the company (specifically the Loyalty Group) as much as possible.

Remember that Affinion is an EXTERNAL client-driven environment and you should stress your versatility in prioritizing tasks, meeting quick deadlines and working in a very fast-paced environment. You should be able to quickly reference specific projects/situations to support these attributes. You also need to convey confidence in your abilities and your desire to continue to learn.

A couple of other pointers:

You need to sell yourself and come across as you really want this position – be positive, upbeat, smile and speak confidently

1. Do not speak negatively about your current/previous company, position, etc.
2. Dress very, very sharp
3. Know the details of your recent projects. Get technical with your answers. Don’t get too lengthy but also avoid one word answers
4. With each question confirm that they understand your answers
5. With each question when appropriate, ask if they need additional information beyond what you have told them
6. MUST HAVE, MUST HAVE: 2-3 strategic technical questions prepared – could be around platforms, architecture, business case, etc. – DO NOT ask administrative questions about vacation, salary or working from home, etc.
7. This final one is not easy but don’t be afraid to ask for feedback after the interview is over and ASK FOR THE JOB!

1.
A few days before the deadline, stored procedure we realized that(we needed to implement an extra feature) Some clients have Oracle database but scripts were developed in SQL Server... We worked very hard put extra hours,
package for them to Copy from this Study to another study. quickly developed

2. Quick demand from Clinical data managers...we prioritize task...especially a feature that can make life easier for user....talk to the immediate supervisor...If it's OK then we prioritize the task

3.

• Logical and physical Data modeling of Oracle database for Clinical data subjects management (ERWIN)
• Development of Oracle PL/SQL packages to automate genetic data processing (Oracle PL/SQL)
• Creation of Informatica ETL process for loading clinical trial subjects data (Informatica PowerCenter 7.0)
• Coded various scripts for customized data quality verification and file processing (SSIS, PERL)
• Tuned various SQL statements for PL/SQL package and web development (Oracle 10g)

• Development of data warehouse ETL process for Law firm time billing BI reporting for various multinational law firms such as Linklaters LLC and Orrick LLC (Informatica 7, Oracle 10g)
• Configuration and support of the database replication environment of time management web application for various multinational law firms (SQL Server 2005)
• Data modeled and designed SQL server databases for the HR department of various clients (SQL Server 2005, T-SQL)
• Development of reports for manager time-tracking(SSRS)
• Development and support of web portal for mobile user registration and web services allowing upload of time data entries following object-oriented paradigm(C#, ASP.net)

· Development of DTS package, Oracle and SQL Server script for software deployment and data migration (DTS, T-SQL, Oracle PL/SQL)

· Designed and programmed phonebook web application by following a strict coding standard (ASP.net, C#, HTML, JavaScript)

· Designed OLAP reports using crystal report 10, SQL report service, mdx query language

· Customization, configuration and deployment of OrgChart web application for multinationals such as InBev, Airbus, etc

· Developed web user controls to manage user web search (ASP.net)

Software Developer

05/2003 – 12/2003(Contract) Wyeth Inc. Montreal, Canada

· Developed intranet web application for employee training program and logon form (ASP.net, Oracle P/SQL).

· Wrote high-level software designs and specifications for feature implementation

· Developed Web User controls such as addremovelistbox and datepicker controls (ASP.net)

· Wrote testing script and documented applications