<% set rscity=server.CreateObject("adodb.recordset") set rsindustry=server.CreateObject("adodb.recordset") set rsfunction=server.CreateObject("adodb.recordset") rscity.open "select distinct(id),city from citymst order by city",db,adopenstatic rsindustry.open "select distinct(id),industry from industrymst order by industry",db,adopenstatic rsfunction.open "select distinct(id),functionalarea from functionalarea order by functionalarea",db,adopenstatic %> <% skills=trim(request.form("txtskills")) industry=trim(request.form("cboindustry")) city=trim(request.form("cboprefcity")) functional=trim(request.form("cbofunctional")) if trim(skills)<>"" then skills=trim(replace(skills,",","','")) skills="'" & replace(skills," ","") & "'" end if set rs=server.CreateObject("adodb.recordset") myStr="select distinct(a.projectid),a.prjtitle,a.designation,a.workexp, a.dated from projects a" if trim(skills)<>"" then myStr=myStr & ", projectkeywords b" end if if trim(city)<>"" then myStr=myStr & ", projectlocation c" end if if trim(functional)<>"" then myStr=myStr & ", projectfunctionalarea d" end if myStr=myStr & " where " if trim(skills)<>"" then myStr=myStr & "b.keyword in(" & skills & ") and " end if if trim(industry)<>"" then myStr=myStr & "a.industry=" & trim(industry) & " and " end if if trim(city)<>"" then myStr=myStr & "c.location=" & trim(city) & " and " end if if trim(functional)<>"" then myStr=myStr & "d.functionalarea=" & trim(functional) & " and " end if if trim(skills)<>"" then myStr=myStr & "a.projectid=b.projectid and " end if if trim(city)<>"" then myStr=myStr & "a.projectid=c.projectid and " end if if trim(functional)<>"" then myStr=myStr & "a.projectid=d.projectid" end if myStr=trim(myStr) if right(myStr,3)="and" then myStr=left(myStr,len(myStr)-3) end if myStr=myStr & " and a.status='O' order by a.dated desc" rs.open myStr,db,adopenstatic 'response.write myStr %> <% if not rs.bof then %> <% else %> <% end if %>
 

Partner/Director - Business and Risk Advisory Services (Hyderabad/Bombay/Madras)

Company Profile
A Global Big 4 Accounting/Business advisory services Firm with a substantive base in India.

Role and Responsibility
The assignment encompasses working at building client relationships, develop customized value proposition to sector requirements, a point of view of the industry, network with key players, interact with the firm’s global resources and networks particularly with UK and US Partnerships and manage teams, project delivery of large scale high value jobs. BPO capabilities highly preferred.

Work Experience
Professionals with 12/14 years of consulting, business advisory services experience, particularly in the Utilities - Power, Oil & Gas, Entertainment, Pharmaceutical and Healthcare Industries.

Qualifications
Competencies for the role include amongst others client service, risk management, partner obligations and long-term career orientation. Only professionally qualified Chartered Accountants or Business Management Graduates may apply.

To apply for this job, send your detailed resume to jobs@careerfusion.com.
Alternatively, you can contact us at the contact details given below.