Summary

• Extensive experience in Data Management, Data Warehouse Dimensions and Fact/Measures , Business Intelligence and Data Mining using tools
• Strong understanding of financial industry experience in developing Trading and Risk Management application for Equity, Fixed income, Back and Middle Office, Derivatives, FX, Finance, Prime Brokerage and Investment Banking.
• Strong System knowledge in Digital Marketing, CRM Systems Web Analytics Tools, and Mobile and Web e-commerce in developing application for multichannel CRM Campaigns, web and inbound and outbound channel analytics,
• Has more than 10 years experience in IT group and project management, system architect, modeling, design, development, system integration, testing, quality control assurance, implementation and maintenance of IT solution system. Acted as Director of development team and interact with internal and external clients/vendors for project tasks, participate in work prioritization meetings with business group teams and clients.
• Performed data ware house 10 TB build, database system modeling and design, physical and logical design, database development, configuration and performance tuning software system architecture, design and analysis using object oriented techniques, software programs/components design and development, web/windows application User interface design and development, Data store and Data interface system/subsystems architect, design analysis, development oversight, evaluation and testing, database administration and maintenance support of client/server, n-tier web based database systems in the following environments:

PROFESSIONAL SKILLS:

SOFTWARE: Microsoft SQL Server v2000/05/08 with replication, Transact-SQL, BIDS-SSIS, SSRS, SSAS,

IBM Ascential Data Stage Version 8.x, Informatica, Business Objects XIR2, Crystal Report V8.5, SAS v9.x/8.x System, SAS BI Enterprise, SAS/Base, SAS/Macro, SAS/Graph, SAS/Connect, SAS/STAT, Data Flux , SSPS, S-Plus, R Kxen Framework,

Oracle 10g/9i Tools, Pro C, PL/SQL, MySQL DB engine,

Sybase Adaptive DB and replication servers, Sybase SQL Anywhere, Sybase T-SQL,

Microsoft Access 97/2000, Microsoft Office 200x Excel, Word, PowerPoint , MOSS/Share point

Autosys, XML Web Services, JAVA, J2EE, SWING/AWT, XML,XSL, DB2/UDB, SQL XML

Erwin, MS Visio 200x, MS Project 200x Visual Source Safe,SVN,Perforce

Enterprise Data Ware house, Data Mining, Data Mart and

OLAP Cubes ,Fusion Charts Dundas Tools, Autosys 4.5, RedGate SQLTools Belt

OS: MS Windows , Window NT/200x Red Hat Linux, SOLARIS, HP- UNIX

HARDWARE: HP System 9000 1000 Series, Sun/Solaris System, Windows NT/2000 based servers, Linux System, Windows OS 9x, NetWare servers, DEC System, VAX, PDP 11, MICROVAX, IBM 386/486/Pentium, Transputer Parallel System, MARS, TRANSPORT 5500 series, Intelligent Character Recognition System, Radar and Communication systems.

LANGUAGE: C , ASP.NET, Web Services, XML, VB, VBA, MDX , C/C , C and .Net Framework, Visual Studio v6.x, IIS v5.x, Visual Basic.net/C , SQL,VBA,HTML, XHTML,CSS, JavaScript, PHP , Unix Shell, Perl, Python, AJAX

PROFESSIONAL EXPERIENCE:

Confidential

Application Solutions Lead/Tech Manager

• As Solution Lead architect working on the following Enterprise application work:
• Working on a Cloud application platform performing architect, design , development and migration of a Enterprise Tier application to cloud based solutions.
• Cloud Strategy, Scoping and Analysis, Application evaluation , design, development and migration for cloud implementation.
• BI System migration to Cloud to provide as Platform as a service Using Azure and MS BI stack SSIS,SSAS,SSRS and MS SharePoint.
• Analytical Framework for High Performance computing using Hadoop, Map-Reduce.
• Digital Marketing Mulch-Channel System in SAAS System development with DB , ETL , BI tools on ESB Enterprise Service Bus .

Confidential

Solutions Lead/Tech Manager- Sr. Consultant

• As Technical Lead/Solution Architect worked with an offshore vendor team to perform a design and optimal development of SSIS ETL packages to do data integration mapping engines across multiple vendor platforms to import market and asset pricing data feeds of multiple data format, data connections from multiple systems b data integration and validation, c process data verification,error logging and data loading into PDM databases/DWs.
• The Portfolio Management Group focus on Barcap FICC assets class namely Fixed Income , Commodities,and Currency product platforms. The PM-IT is the nodal group manages design and development of IT solutions system for Barcap Capital Asset products, servicing for a Bonds and its Derivatives b Syndicate Loans/CDO c CDS d Equities and Indexes e ABS/MBS residential and Commercial and f Currencies Trading and Portfolio analysis. The Portfolio Data Mart PDM System consists of multi -tier architecture system layers namely 1 Source System Layer consumes Market data from data vendors like MarkIt, Bloomberg FISS Systr , Impact , internal Barcap systems ACBS, GCIS, SDS, SDAPS, ARMS, interest Rate and Currency data Feeds 2 Portfolio Data Mart System layer does the snapshot of EOD market data synchronization mapping for all portfolio assets , Asset value Pricing and management,Mark to Market, ROEC and RVAT calculations, Risk models Engine runs, CDS curve builds and Risk forecasting using Simulation models and 3 Front end Portfolio Management application Portfolio Asset Register PAR , Trade and Portfolio Log etc., are used by PM managers and Traders to perform Portfolio analysis, Risk and Trade Management. The PM-IT PDM Asset operational and Data Ware system databases are data processed, synchronized and replicated on multiple regional systems to support Global PM groups operating on multi market regions like Americas, Europe, Asia Pacific etc..
• Perform the technical management of offshore team to carryout design and development of integrated optimal PDM system in building out system modules and system integration with data vendor systems, PDM Data marts and BI financial reporting and PM applications system.

Environment: MS-SQL 2005/2008 Server SSIS,SSAS,SSRS , Microsoft Visual Studio 2008, .Net 3.5 Framework, C , Autosys 4.5, RedGate SQLTools Belt , Erwin, MS Office,MS Share Point 2010, XML Spy,Perforce

BI Architect Lead Consultant:

Confidential

• Financial Reporting
• Engagement Reporting
• Pipeline Management
• Capacity Reporting

Confidential

Business Intelligence lead architect

• Strategy, System requirements scoping and Analysis, business strategy design and evaluation for implementation.
• Business Functional Information and DATA flow diagrams development
• BI system specifications, system architect and design modeling both physical and logical structures
• System Modeling , Architect, Design and Development of Source and Target data systems mapping, ETL process design, development and optimization.
• Data ware house Dimension and OLAP modeling.
• Global Analytical system development for real time apps, reporting and analysis for risk, liability and assurance
• OLAP Cubes building processing, synchronization and query processor and Enterprise Reporting system functional reports driven out of OLAP cubes/data marts for Standard and Adhoc Reporting, Guided analysis for corporate wide network units.

Environment: MS-SQL 2008 R2 Server , SSIS,SSAS,SSRS, MOSS Portal, Excel 2007/VBA Microsoft Visual Studio 2008, .Net Framework, C , MS Share Point 2010 Server, Performance Point Server and MS Excel services, ProClarity, MS-Visio.

BI Architect Consultant

Confidential

• As BI Architect worked on a design and optimal development of SSIS ETL packages to do data integration mapping engine across multiple vendor platforms to import data feeds of multiple data format, b data cleansing and validation, c data loading and error logging and data verification to integration into EDW data ware house.
• Performed design and developed module evaluation of 1. DW ETL, Data cube build and processing on SSAS and 2. Optimisation of Reporting data model structures and Reporting system architecture based on reporting services of MS BI stack.

Environment: MS-SQL 2005/2008 Server SSIS,SSAS,SSRS , Microsoft Visual Studio 2008, .Net Framework, C , Java App Platform SDK , J2EE,SWING, NetBeans IDE, MS Office EXCEL, POWER POINT, Perl script,SVN.