Anupam Mandal

15+ years of experience in Application support, Release management, Environment Management, ETL and Database development and maintenance predominantly in banking and services domain (Prime Services, Hedge Fund Services, Treasury Services, Investment and Wealth management).

• 15+ years of experience in Release management, Environment Management, application support and development and maintenance predominantly in banking and services domain (Prime Services, Hedge Fund Services, Treasury Services, Investment and Wealth management).
• Hands on experience in Application Development, maintenance and support – Incident management (Incident tickets Creation and handling / troubleshooting and resolving daily incidents), Problem Management (Create, track, coordinate and resolve major problem tickets).
• Environment Management and Release Management – Change Management (Reviewing RFCs, represent  and propagate RFCs in CAB, deployment check outs coordination) . Application and DB Releases and automation  using conductor scripts and Bladelogic.
• Programming experience in C#, VB.net, ASP.net, HTML, JavaScript pertaining to development and maintenance of reporting applications.
• Extensive SSIS (SQL Server 2012/2008) development, deployment and maintenance experience. Extensive hands on with data modeling using Data vault warehouse model, ETL design and implementation using SSIS, ETL reconciliation and recovery implementation using SSIS.
• Proficient in Requirement and data analysis, Development of Crystal Reports 10\XI, SQL Server 2012/2008/2005 Database Programming and maintenance, Oracle PL/SQL, Crystal Enterprise Server Set Up & Management, ETL development and maintenance using SSIS(SQL Server 2005). 
• Have work experience in Cognos 8 report studio, Query studio, Cognos Framework Manager.
• Has extensively worked on:

• Domain experience (more than 2 years) of Application development and support, reporting and database support on Hedge Fund Services, Transfer Agency and reconciliation application modules.
• Domain experience(4 years) on Application development and support, Database support of Prime Services applications (PrimeSwap, Blotter, D1 cache).   
• Application support of reporting tools like Crystal reports, Crystal Enterprise, Tableau and Power BI.
• Application support of middleware workflows with  IBM MQ, AIFG Adaptors and MQDirMon and MQFIleCopy related setup.
• L1 Application support of Osirium
• Environment management, Coordinating, Building and Deployments of Packages to prod/UAT/QA, DB deployments, Performance Monitoring and DB health checks, DB tuning and Recovery, DB Refresh, Control M Batch Monitoring and  maintenance, UC4 support and maintenance of scheduling and automation of Jobs, Tidal Jobs creation and support, Control M job creation, modification and xml refresh, Checkouts and maintenance post DR/QMW activities /Patch Upgrades. 
• Windows and DB release automation using conductor scripts, provisioning of releases using Bladelogic, Octopus. 
• Coordinate and own the cycle of deployment process using ITSM and Snow.
• Production support of Prime Finance and Hedge fund application base, Incident management and change management.
• Programming in VB.Net, C#, ASP.Net, scripting in HTML, Javascript pertaining to development, maintenance and support of Prime Finance Applications, Mshare and Hedge Fund reporting Apps.
• Development and support of reports using Crystal Reports 10\XI.
• Development of reports using Cognos 8 report studio.
• Modeling of data for enterprise data warehouse, using DATA VAULT model. HUBs, LINKs and SATELLITE design creation and loading of the same from transactional DB for warehousing purposes using SSIS, SQL Server.
• Vivid Programming experience in TSQL(SQLServer 2005/2008/2012) for development, maintenance and testing purposes of reports, creating stored procedures, Functions, Views, Triggers, SQL agent jobs.
• Development experience of development and maintenance of ETL processes for enterprise data using SSIS packages, for SQL server 2008/2012, release Packaging and Deployment of  SSIS packages.
• Performance Tunning activities on SQL Server 2008/2012
• CDC process development and support in SQL Server2008, for Sybase IQ data replication from  SQL Server.
• Developing and maintenance of DTS packages, SSIS solutions, for data transfer,

And scheduling jobs and maintaining them using SQL Job agent / Windows scheduler.

• Management, Configuration and Support of Crystal Enterprise Server and CMS(Crystal Management Server). 
• Modeling of data using Crystal enterprise 10, Cognos Framework Manager and  SQL Server 2005 for end user reporting.. Development and Maintenance of Business Views with Crystal Business View Manager v10.
• Development and maintenance of packages in SQL Server Integration Services(SSIS).

• Masters in Computer Application from Jadavpur University, Kolkata, India in 2002-2005
• Bachelor of Science(Physics Honours) from Burdwan University, West Bengal, India in 1998-2001
• C.B.S.E (+2) (Central Board of Secondary school certificate) from DAV Model School, Durgapur, India
• I.C.S.E (Indian Certificate of Secondary Education) from St. Xavier’s School, Durgapur, India