Data Project Manager

DEWAN H. CHOUDHURY

*** *. ****** ******, #****

Glandale, CA 91202

Tel: 917-***-****

E-Mail: **************@*****.***

SUMMARY & qualifications:Knowledge in data management and business analysis, Trade Processing, Valuation & Trade Settlements, Foreign Exchange, Funds Transfer, Securities Custody & Clearing, Structured Deal Reviewing, EAM/ERM applications, Reference Data/Market Data contents, Ad-Hoc Queries, Process Flow, Presentations, SDLC Project Management and Methodologies;Substantial experience in Banking/Financial Products and Systems Data Analysis using MICROSOFT EXCEL, ACCESS, POWERPOINT, SHAREPOINT, VISIO, ORACLE, SQL SERVER, CRYSTAL REPORTS that encompass preparation of Professional Reports for statistics and presentations; support Project Management, Administrative, Technical and Analytical Tasks, Application Usage including End User Support on computer applications.Accurately compile, calculate, process, and maintain informational data utilizing Data Source from BASEL II, SAP, BUSINESS OBJECTS, MUREX and HYPERION STAR Schema.Experienced in Accounting Reconciliation, AP/AR & GL, Billing and Exception Management Solutions, Data Warehousing, RDBMS, Operations Facility, Merger & Acquisitions(M&A)/Finance/Accounting/Cash Management Applications including Hands on experience on Installation, Implementation, Supporting Systems, Proprietary, Research and other application software; specifically knowledgeable in Accounting/Billing software modules and terminology.

TECHNICAL PROFILE:Software: Microsoft Excel, Access, Oracle, Sybase, SQL Server, UNIX.Other/Tools(Lite): RDBMS (SQL/T-SQL), Business Objects, Crystal Reports, ETL (TOAD), COGNOS.

PROFESSIONAL EXPERIENCE:

MAJOR CONSULTING FIRMS 1993 – PRESENT

Capital One Bank, McLean, VA

STRATEGIC STAFFING SOLUTION October 2011 to February 2012

(Contractor/Consulting) Project Application Support Analyst/Data Analyst MurexWorked with a Derivative Management Systems IT group, Treasury Accounting, Regulatory, Murex Market Data & Trading Systems in a Business System Migration (Reval to Murex) and integrations.Worked extensively with Murex Market Data Front Office systems in price feeding providers such as MarkIT & Bloomberg.Worked in development projects as well as various vendor package implementations throughout the Migration.Participated in Database clean-up activities, Trade, Market Data and Report purging.Worked with Offshore & internal DBA’s in various Data Mapping on upstream/downstream feeds, between Databases, cross systems via both running SQL queries against SQL Server DB tables, MS Access ODBC connected SQL Server Tables & via ETL tools to do the GAP analysis on Data Integration.

RBS Sempra Commodities, STAMFORD, CT

FOCUS CAPITAL MARKETS October 2010 to July 2011

(Contractor/Consulting) Price Desk Application Support Analyst – FX, Energy, Crude Oil, Commodities & Utilities MarketSetting new markets in our trading systems for traders to book trades against them, setup includes setting expiry dates, value dates and delivery periods for a futures contractsReconciling exchange traded spread options and ad hoc calculation and submission of correlations to accurately value the spread options for Oil products.Operational management of inter-company swaps for correctly valuing and reporting on holidays. Working with Risk dept. on developing models to ensure reporting of P&L at New York market close which includes accurate FX rates and time adjusting forward marks for European products to New York market close.Troubleshoot day-to day issues and ensure FX, Crude Oil, Fuel Oil, Energy Products, & Utilities prices (MTM prices/Forward Curves) are correct in the trading system, volumetric and price exposure/risk(s) are correct. Worked with Middle Office reconciling house outs between JMS/ICTS and Affinity that requires very good understanding of Trade Capture and MTM P/L & Forex trading.Marking and loading OTC prices for crude oil and utilities products’ traders in London, Geneva and Singapore for both out trading systems, JMS and Affinity.Managing daily price loads, including all foreign exchange, interest rate, published and OTC prices for both domestic and international markets in JMS and Affinity.Working towards automating and adjusting daily forward price feed procedures, spreadsheets macros and applications with a focus on improving the processes in a dynamically changing environment.Thorough understanding of Market Risk in terms of pricing and helping Trade Analyst with set-up spreadsheet to send daily marks and ran reports & queries in SQL Server & Oracle Databases for various adhoc requests.Good understanding of inventory for Oil related products. Fair knowledge of all JMS/Trade Capture applications such as Trade Entry, Portfolio Manager, Scheduling, P/L report.

MORGAN STANLEY SMITH BARNEY - Wealth Management, NYC

NETWORK & CO. / INSYS CONSULTING / tiger information systems May 2008 to October 2010

(Contractor/Consulting) Application Support Analyst – Equities, FID, Retirement & WMG SolutionsConferred with personnel of relevant organizational units to analyze current operational procedures and identify problems. Prepared and coordinated Client Side Equities/Fixed Income transactions on finalizing Business Requirements for trade modifications capture on Cancel & Correct or Amended trades and structured/nonstructural derivative products.Analyzed user requirements, procedures, and problems to improve business process and conducted extensive data quality, data cleansing, data remediation and data validation process.Writing detailed description of user needs, as well as functional and/or technical specifications and reviewing current business process, workflow and scheduling limitations. Prepared workflow charts and presentation diagrams and coding with Microsoft Access, Visual Basic and Business Objects on the legacy and system interface processes on equities, retirement products, and regulatory reporting. Produced a standardized structured operational due diligence report for each investment line, including reviews of key areas of the operations, trade process, risk management, compliance and business continuity planning.Fixed Income software supported for customers that consist of banks and institutions, and coordinate, implement, and deploy solutions for customers with different Reference Data Contents (Bloomberg, Reuters EJV/EJM, and Option Metrics) and Trading Strategies. Analyzed, updated and installed proprietary gateway components, and provided technical and analytical support to traders, or in-house support for day-to-day fixed income trading on Production and development systems.Worked with in-house fixed-income CO&T (Corporate Operations & Technology) Support Groups, in order to provide general to complex support for customized gateways, and components residing on the firm Application platform.Acted as liaison between the BU/OU Customer, sales and developers to provide the most efficient application support on the client live and ongoing development of fixed-income trading platforms.Updated Organizational (Business Unit)/Organizational Unit of Hierarchy in Hyperion Essbase Database for Month End & Quarterly Close, Actual, Flash and Planned Cost Allocations and roll ups analyzing source data across various Financial Systems for Accounting (Oracle GL Data), Products involving production and number issues that reflects mapped merging data into multi dimensional reports for higher management.

OGILVY AND MATHER, NYC

SOLOMON PAGE GROUP January 2008 to May 2008

(Contractor/Consulting) Applications, Data & Systems Analyst Aided in managing application specific reference data, updated HLC (High Level Concept) documentation for modification of a Globalized Database Data mart Integration Project. Reviewed requirements and created complex Visio diagram of Common Shared Landing Data Repository space interfacing processes for data standardization, data staging, data consolidation for inbound and outbound, single and bi-directional dataflow from source systems, tools, APs, ARs, GLs and Central Database Data mart with technical (i.e. Actuarial, finance, business) and non-technical (i.e. vendors, administration, systems) data.Analyzed database layers (PL/SQL), including functionality such as mapping and translation of data in the relevant format.Analyzed and implementation of data "intensive" functionality, focusing on quality and performanceOrganized and managed sets of data, verified data attributes and helped created test data and supporting the relevant test scenarios to be used by developers, testers, and business users during every phase of integration.Maintained liaison and provided support to software developers, data architects, and test managers with regards to BRDs, FRDs and DSDs.Carried out analysis of web search results for the InvestTool clients’ of Ogilvy and Mather. Studies downloaded data from Yahoo, Google, Ask and MSN websites and carry out search engine keywords, cost factor analysis. Using Analytics Tool, Analytics tool, queries and thus arrive at Keyword positioning for various queries that ran on Clients’ web sites. Made heavy use of Access/Excel and did relevant Grouping of data and X-Reference Checking.

LEHMAN BROTHERS, NYC

TACWORLDWIDE COMPANIES INC July 2006 to December 2007

(Contractor/Consulting) Application Support Analyst/Accounting & Finance Data Control – Systems SDLCInteracted with Traders, Product Controllers, Operations Managers, Risk Managers, Compliance Managers, and Legal Entity Controllers on new requirements and workflows being developed jointly with Enterprise Account Management (EAM) application for Firm Account Opening Workflow and rollout phases launched globally (through the beginning of June 2007 and rollout schedules). Phases supported single account opening requests for Cash business lines, Target Derivative businesses and also addressing multiple accounts on a single request and with the ability to copy from an existing account. Coordinated with Requesters and Technologists in Trade Capturing source system databases, Data Feeds and Hosts of trading accounts in functionality, workflow, metadata query download (e.g. Proprietary – PathFinder, GQuest, PALS, SUMMIT, CARRUSO, MUREX, RISC and Intranet – ERM, Enterprise Relationship Management and Others) across Lehman Brother Entities for Derivatives & Cash/Credit/FX/Commodities/Energy Trading systems, Front Offices, Equities, Risk Managements in categorizing the Firm Accounts of GL data reporting into downstream P&L Center data structures and data mappings.Analyzed High Volume AP, AR, GL Data involving Enterprise Accounting Projects in Book Map Accounts and also Post Deal GL Reconciliation, Discovery and troubleshooting from Back Office Systems, Escalation of issues to Technologists. Verifying Suspense accounts and P&L Failure/Exception reports which were the keystone via cross reference systems in cleansing Accounts successfully. Analyze heavy Journal Entry data and recommends appropriate course of action proactively identifying areas of risk & exposure and present alternative solutions.Rationalize and validate deals, account creation, maintenance and closure against the ER Model. Retrieve to examine the books/accounts in reporting discrepancies from repository & host systems and cleansing for PNL, Risk and for other attributes. Assess, monitor and track open Product Control internal and external audit items and summarize focus items for senior management. Contact Product Finance Controllers, Business Units Operations or Account Managers to research the books/trades in reconciliation, consolidation processes requiring alterations and account modifications in addition to meeting various audit discovery and requirements.Conducted Structured Deal Reviews on equities, fixed income and other Trade Booking Life Cycles to minimize risks and to avoid repercussions in the event of errors on modeling, valuation, settlement, compliance factors, etc.Created an MS Access (VBA) tool to determine on Implied Volatility of Underlier Securities for Out the Money Options.Assess and monitor Product Control environment by developing daily/weekly or monthly processes of actionable managerial reporting of key performances indicators.

MOODY’S INVESTOR SERVICES, NJ

ROBERT HALF TECHNOLOGY February 2006 to May 2006

(Contractor/Consulting) Application Support Analyst Gathered requirements in automation of Bloomberg Market Data Feeds (specifically with Bloomberg Updates) download to the desktops of Traders/Brokers/Business Users both in MS Access & MS Excel for recurring and high volume metadata from Bloomberg Real Time Server Data using APIs for Access and Excel. Automated Data Feeds from various databases into Moody’s In-house Central Securities (specifically Fixed Income Securities) & Rating Databases’ Data in comparison to other Rating Competitors Data to be loaded for analysis and business prospect and also automated the regional and group distribution along with further customized allocations of metadata monthly basis and in periodical requirements.Used Microsoft Access & Excel Query, Access/Excel VBA, ActiveX and ODBC direct connections, Sybase ASE, Embarcadero Rapid SQL and other tools to accomplish the automation. Also ran queries on databases for other similar manual ad-hoc reports. Worked as a Project Manager on recommending and streamlining several ongoing Projects’ Project Strategies of Public Finance Group (PFG), Corporate Finance Group (CFG) that interfaces with Web Hosting, Web Applications Development Cycles, and Data Capture for Financial Modeling Analysis, and supported End Users for various financial metadata, application usage and work order requests.

CITIGROUP - CITICAPITAL, N.A., NY

PEAK ORGANIZATION November 2005 to February 2006

(Contractor/Consulting) Business AnalystExclusively worked on a Project involving Cash Managements, Assets & Liabilities transaction Process flows in Citibank’s Proprietary Applications and Compliances for AFS/SI, CitiSmart, NCIS, NOLW, GTS Pega, CWS, CBusOL and across many other Business Applications and tools.Participated Intermediary with SME (Subject Matter Expert) and Procedural Implementers to create, revise Procedures and documentation for Relationship Managers (RM) & Client Relationship Managers (CRM)/Customer Service Specialist (CSS) and System integrators.

JP MORGAN CHASE, NYC

MODIS INC. May 2005 to November 2005

(Contractor/Consulting) Systems Data Analyst Worked as one of the Project Support Analysts on Approx. 200 Projects that were ranked as Business Vital on Data Merge/Data Migration Between BankOne and JPMorgan Chase - All projects required Gap Analysis due to decommissioning/phasing out of current IT Systems and Merging Data into one system and virtually to a completely New IT Systems and Architectures.Used MS Access (Link Tables, Action Queries, Data Export/Import) & MS Excel (pivot table/pivotchart report, grouping) to manipulate, extract and analyze high volume metadata.Used DTS/DTF and Data Type conversion from SQL/Oracle/Sybase Servers via ODBC & Direct connections. Responsible for extensive involvement on Ad-Hoc queries for Marketing & Sales Campaigns on Auto, Home, SBA, Annuities, Retirement, Credit Cards, Money Market, Securities Product Lines Data pull via SQL Scripting, Data Dictionary/Data Modeling, Created Macros and running MIS Reports using Oracle, SQL server, SQL Plus scripts, SAS scripts and T-SQL scripts. Evaluate performance matrix on the reports of various data migration on database servers.Created Databases & Reports using MS Access with VBA to support Automated/Scheduled Data Summary to destinations and On Demand Work Order Requests from various resources.Modified/Created documentations of MIS Reporting on Data Mapping/Data Modeling and resources for reference.

MORGAN STANLEY, NYC

IIT INC. May 2004 to May 2005

(Contractor/Consulting) Project Manager/Systems Data AnalystUpdated intranet websites (Via ASP/FrontPage/HTML), created Project Reports and graphical analysis on Projects' prospective, requirements, budget, forecasts via Microsoft Project & Visio Diagrams/PowerPoint Presentation Slides/SharePoint Data Mappings/Access Databases (Queries, Tables, Forms)/Excel Worksheets (Functions, Charts, PivotTables, Pivot Charts & Macros, Excel VBA) & Flash Slide, Form & Documents.Developed a Database using MS Access, Visual Basic for Application, Visual Basic in order to Monitor various IT & IT related Projects and Initiatives on MS Access Front End with SQL server for statistical analysis and the evaluation of performance matrix.Involved in various projects’ progression on deployment of Market Data including Capital Markets (Bloomberg, Thomson One, Instinet and Factset) and off the shelf applications & Third party software. Used MS Excel & VBA to create automated data input from feed points of traders’, brokers’, agents’ desktop application data flow to daily data reconciliation of individual trading segments.Downloaded and identified SMS, Varinfo and other Mechanism Data and troubleshoot on Exception Errors and other errors using via in-house developed tools to determine cause of errors and as well as reporting the errors to Developers regularly on the Rollout Builds of the phases of dissemination/deployment failures on Mass Hot Fixes/Patches/Software loads and the success rates of the loads onto the Firm wide servers/laptops/desktops.Worked with QA, Software testers, Automation Engineers on testing processes. Analyzed and prepared reports on escalating errors/bugs/compiler related issues.

THE TOKYO MARINE & FIRE INSURANCE CO., NYC

TEMPORATY ALTERNATIVE November 2003 to May 2004

(Contractor/Consulting) Systems Data AnalystEffectively worked on projects of transaction reconciliation processes due to data migration on recently deployed accounting systems (ClaimsPro) replacing older Btrieve/DOS based applications. Analyzed and investigated high volume transaction data disparities among the new and old systems.Retrieved and downloaded mass data in order to locate data integrity error using Excel and Access analyzer tool. Worked on methodology to cleanup data on similar error occurrence.

JP MORGAN CHASE, NY

RANDSTAD INC. August 2003 to Nov. 2003

(Contractor/Consulting) Systems Data AnalystWorked on developing standards and procedures for the corporation.Documented and published data models, technical reports, change management releases and issues, database DDL, corporate standards, business policies, and other technical documentation via the web, email or paper reports.Worked with HR Managers in downloading PeopleSoft data and other distributed systems and designed reports and queries using SQL in PeopleSoft and Business Objects. Also created customized reports for statistical requirements using databases, spreadsheets and queries; also created graphical presentations.Assisted in HR transaction processing group to streamline and enhance processes of Hiring, Background Screening workflow, Vendor Listings, Audits, Validation Logic, and PeopleSoft Panel design to improve data integrity and some PeopleSoft Administration requirements.

CITIBANK N.A., NYC

RANDSTAD INC. August 1999 to July 2003

(Contractor/Consulting) Inventory/Systems Data Analyst Assisted Senior Vice Presidents in Data Center Operations and Business Systems of approximately 1000+ technical employees providing support for Hardware/Software inventory data input, extraction, manipulation requiring Client Billing/Invoice validation, License Agreement information analyzing, Records Retention, Retrieval and Synopsis reports for Management requirement.Managed the deployment of Capital Markets’ Treasury Application (CitiDirect) running Windows XP.Used Microsoft Access/Excel advance functions (Pivot Table, Links, Charts, Data Base Export/Import and Queries) to analyze data information and also to create/modify in-house databases.Extracted/Manipulated Business & Systems data from Oracle, Sybase, SQL servers via complex queries, created macros and stored procedures. Also prepared various customized/scheduled reports and presentations.Coordinated with System Administrators, Implementers and Systems Personnel for Billing and Charges to Business Units/Departments for Application Systems' monthly and recurring charges.Managed Databases for Inventory Controlling, and Asset Management Systems of all Citigroup Hardware, Software, System and Business Applications including Peripherals of different platforms (IBM /IBM Mainframe, AIX, VAX/VMS, TANDEM, UNIX and NT).

LAW FIRM OF KREINDLER & RELKIN, P.C., NYC June 1998 to November 1999

(Direct Full time) Application Support Analyst Supported Time/Legal Billing software (Elite, Barrister) with usage of different modules for preparation of time/billing reports, preparation of client billing; database management; system administration of computer network; installation, ghost imaging of group of computers, user desktop support, system maintenance & trouble-shoot software/hardware issues.Managed the deployment of various off the shelf applications including Lexus Nexus, Time/Legal Billing software (Elite, Barrister), and Accutrack to desktops enterprise wide.

PR NEWSWIRE INC., NJ March 1998 to May 1998

(Direct Contractor) System Support Specialist - Operations & Network Facility

Supported Intranet application system flow for News Media clients and assisted Editors for filing Releases over the AP & WavePhore network to Media Points connected via X.25, Tl & dedicated leased lines.

MERRIN FINANCIAL - ADP INC., NY November 1997 to March 1998

(Direct Contractor) Client Service Manager/Product Support AnalystProvided client support services and training (specifically to traders and brokers) with the Merrin Financial Trading Platform (MFTP), a proprietary software for Portfolio Modeling, through the process of order inputting, allocation & execution systems and assisted clients to overcome implications of the system use for trading Securities. Provided exclusive support on Fixed Income Assets, Bloomberg Indexes and other financial products.Also provided Intranet Market Trading Network Platform support to clients with Financial Trading Systems based proprietary software applications to streamline and assurance of electronic data transmission (for both Buyside and Sellside) to TTN, connecting to a Network Cloud shared by money managers, brokers and exchanges.Assisted with basic operations, system navigation, system settings, maintenance and administration, data integration to the system database and created technical documentation.Assisted Product Development Group with the programming/developing/enhancing, including the testing and correction (software patches) processes of current and future versions of software releases.

CITIBANK N.A., NY

ACCUSTAFF INC. November 1995 to November 1997

(Contractor/Consulting) Treasury Application/Customer Data Delivery SupportCovered helpdesk technical support to clients of Citibank’s Treasury Software; CITIBANKING for funds transfer, trade securities and issuance of Letters of Credit.Monitored statistics of data moving process and troubleshoot in Citibank's GTN, VTAM, X.25, T1 communications.

KBC SYSTEMS CORP. /

KBC FINANCIAL SERVICES, NYC October 1993 to September 1994

(Direct Full Time) Senior Executive AssistantAssisted President/CEO with commercial and personal line insurance processing created and developed system input with daily business information and extracted synopsis reports, interactions with clients and subagents.

PREVIOUS CONSULTING POSITIONS IN NYC 1994 to 1995VIATEL Telecommunications, Assisted Financial Controller in consolidation project of the estimated Global budget projection, fiscal year revision and reconciliation using Quattro Pro for Win.Wasserstein Parella Securities, Inc., Examined Database report output inputting securities information in DOS based Fox Pro program from Bloomberg index information and participated in database upgrading in coordination with consultants.NYNEX, Worked with NYNEX Presentation Center Director on scheduling corporate clients' presentations and meetings of Telecom equipment sales using Paradox database program.Ernst & Young, Setups and installing software on Macintosh PCs configure and troubleshoot on users PCs.

EDUCATION:New York University (NYU), School of Continuing Education and Professional Studies, 2005 to CurrentThe City University of New York, Queens College, Continuing Education in Accounting and Information Systems, 1997 to CurrentDiploma in Computer Programming and Information Systems, Radiant Computer Systems, Edison, New Jersey, 1996Bachelor of Science, Chittagong University, Sylhet Government College, Bangladesh, 1987

VISA OR WORK STATUS:

US Citizen

REFERENCE:

Available upon request

Contact this candidate