Bhavesh Patel Email Address

Assistant Vice President

Industrial and Commercial Bank of China Ltd. (ICBC) (simplified Chinese: 中国工商银行; traditional Chinese: 中國工商銀行; pinyin: Zhōngguó Gōngshāng Yínháng, more commonly just 工行 Gōngháng) is China's largest bank and the largest bank in the world. It is one of China's \"Big Four\" state-owned commercial banks (the other three being the Bank of China, Agricultural Bank of China, and China Construction Bank). It is the largest bank in the world in terms of market value, the world's largest bank by deposits, and the world's most profitable bank.\r\n\r\nIt was founded as a limited company on January 1, 1984. As of 2009, it had assets of RMB 11 trillion (US$1.6 trillion), with over 18,000 outlets including 106 overseas branches and agents globally. In July 2007, with a market capitalization of US$254 billion, it became the world's most valuable bank after a surge in its share price, overtaking Citigroup.

A skilled Database Developer and Data warehouse architect with more than 7 years of MS SQL Server 7.0/2000/2005/2008/2008 R2 experience as a back end developer, data warehouse developer in financial industries. Experience with the database architecture, design, coding, implementation and production support,T-SQL (DDL/DML) queries, Stored Procedures, views, functions and Triggers, query optimization, performance tuning of Stored Procedures and with upgrading from MS SQL Server 2000 to MS SQL Server 2005,OLAP,MDX,SSRS,Excle,Power Pivot,Star and Snowflake schema, Crystal Reports X, migrating from heterogeneous sources including Oracle to MS SQL Server, data extraction and loading using DTS in MS SQL Server 2000 and SSIS in MS SQL Server 2005 , VBScript, HTML. Expertise using tools like SQL Profiler, Index tuning, Windows Performance for monitoring and tuning MS SQL Server performance. Strong knowledge and experience extracting and transforming data using DTS Import Export Data, DTS Packages, Bulk Insert and BCP. Experience with the Master Data Service /MDM to maintain reverence data and integration with the Data warehouse. Strong and influential communication and interpersonal skills with efficacy in follow-up and leadership roles. Highly motivated with a drive to take up challenges and put problem-solving to effect in a dynamic environment. Having experience in large Data warehouse system as Core member of Data warehouse designing team.Exposure to different reporting suite such as Tableau, Micro strategy reporting Suite. Familiar with different financial reporting such as Accounting ,revenue reporting,Trading PnL reports ,Margin Reporting,Fixed income,Equities,Income Expense allocation,Clearance Revenue,Daily compliance, Client profitability,Position,Market data,AgencyPool ,Whole Loan,GL and GAAP accounting,Budgeting,Forecasting reporting. fund / legal Entities transaction Reporting, Trading Desk,Credit Risk,Market Risk,Liquidity Risk,Operational Risk Reporting.