I am a Senior Software Developer based in London, UK. I've ten years extensive experience on developing enterprise applications, integration framework and solutions for telcommunications domain. I’ve worked on both large scale and small scale projects and have dealt with people at all levels of seniority. I’ve strong hands on experience on .NET 2.0, SQL Server 2000/2005, ETL using DTS and SSIS, reporting using SSRS 2005, AJAX, distributed computing. I am familiar with the use of design patterns, automated unit testing, performance tuning and optimising .NET and SQL applications.

Languages/Web:C#.NET, ASP.NET, VB.NET, JavaScript, XML, XSLT, XHTML, HTML, DHTML, JQuery

Framework: .NET 1.1, 2.0, 3.5, MBUnit, Microsoft Enterprise Library, WCF, ASP.NET AJAX

Database: SQL Server 2000, SQL Server 2005, SQL Integration Services 2005, SQL Reporting Services, SQL Analysis Services, TSQL

Data Access: ADO.NET, NHibernate, Microsoft Enterprise Library Data Access Block

Dev Tools: Visual Studio 2005, Visual Business Intelligence Studio 2005, SQL Server Management Studio 2005, Telerik Web Components, FxCop, Subversion, TestDriven.NET, WaitN, WaitNTestRecorder, CodeRush. Rhino.Mock

Development Methodologies: Object Oriented, Test Driven Development (TDD), Refactoring, Agile, XP, Waterfall

Design Patterns Expertise: Repository, Unit of Work, Facade, Singleton, Factory, Adaptor, Iterator, Observer and listener, Specification, Strategy, Gateway etc

• Migrated error prone customer facing legacy ASP websites to ASP.NET AJAX, helping 20% increase in traffic on the primary web pages.
• Identified revenue leaks and software design issues on the legacy shortcode based SMS top up system, therefore convincing the business stakeholders to rewrite the application using web services in C#2.0, XML and message queues with inbuilt logging and monitoring system. It helped reduce number of support calls to the call centre and 10% increase on the top ups for first 3 months.
• Developed the online business dashboard featuring key performance business indicators, enabling the upper management to make quick business decisions. I used SQL Analysis Services and Reporting Services 2005.
• Developed revenue assurance and financial reconciliation system using SSIS, SSAS and SSRS 2005. Worked closely with the head of revenue assurance and helped identify several disputed transactions ranging anything from £100 to £100,000.
• Developed a credit card payment gateway interface using ASP.NET C# 2.0, XML, SQL Server 2005, adhering to stringent PCI-DSS compliance policy of software development and implementation.

Bachelors of Technology (B. Tech, 4 years Graduate Degree) in Computer Science and Engineering 1995 – 1999, from NIT Hamirpur India, passed with academic honours.

Microsoft Certified Technology Specialist in .NET 2.0 distributed applications and SQL Server 2005 Business Intelligence.

Microsoft Transcript: Click here to see the transcript
Transcript ID: 814343
Access Code: mithunbose

April 2008 – Present

Senior Software Developer

Organization: The Carphone Warehouse, UK: Europe's leading independent retailer of mobile phones and telecoms services, with over 2,400 stores in 9 countries.

Duties Include:

Full software development life cycle including requirement gathering, analysis and design for new and existing software development projects as well as other IT projects as directed by the departmental manager.

Upgrade and rewrite of the legacy systems, including the websites, databases, reporting and CRM system.

Development and maintenance of data warehouse and MIS.

Development and maintenance of the websites and the databases for www.just-dial.com and www.ratebuster.co.uk.

Development and execution of Financial Reconciliation, Revenue Assurance and key performace indicators for the Finance department.

Projects Undertaken

Mobile top up services by sending SMS/PSMS via Shortcode for making cheap international calls.

This was a Greenfield project. It is a real-time 3 tiered distributed system processing the regular stream of incoming and outgoing SMS traffic.

This was designed as a loosely coupled architecture. The top most layer was .NET 2.0 WSE (Web Service Enhancement Services) which was responsible to receive requests from external internet bound sources. These requests were Encrypted and signed SOAP messages over HTTP. It then stored the requests in XML format in a MSMQ (Message Queue). The business logic layer was written as C# objects deployed as windows service background process. The data layer was in SQL 2005 database, with stored procedures and ADO.NET as data access methods

Upgrade the legacy data driven dynamic websites from ASP to ASP.NET

Migrated the websites such as www.rb-mobile.co.uk, www.ratebuster.co.uk, www.telcosecure.com and www.just-dial.com, from ASP to ASP.NET AJAX. I used C#, CSS, XML and Telerik web components. The part of the project was to normalize the database structure and deploy it on SQL 2005. It also included rewrite of all the legacy DTS 2000 packages in SSIS 2005. .NET Form authentication over 128bit SSL transport was the security model for secure pages.

Management information system - Financial and customer based reports.

The legacy reporting system was a SQL 2000 DB. I rewrote the reporting system on SQL Server 2005 and SQL Reporting Service 2005, using SSIS as the ETL tool and SSRS as front-end. For advance excel users, created and published cubes in SSAS 2005.

Typical reports were monthly revenue and margin analysis, customer churn, customer profiling, trend analysis, top products, agents distributors, forecasting, system reconciliation, revenue assurance etc. I created a web based management dashboard with summarized financial KPIs indicating the recent business health.

October 2002 - March 2008

Senior Software Consultant

Organization: Primus Telecommunications Ltd, UK: Leading independent carrier and service provider in the global telecommunications marketplace.

Projects Undertaken

Real time call data record (CDR) and electronic data record (EDR) rating and mediation system

This was a two tiered multi threaded background application, with capability of processing thousands of real time transactions per second. These transactions were received from heterogeneous systems with different data source format. It was responsible to bill the phone calls or electronic data services used by the Primus commercial or residential customers.

The application layer with business logic consisted of C# 2.0 windows service and class libraries. The data layer was a SQL 2005 DB, with Enterprise Library data wrapper for ADO.NET and stored procedures as the data access method. This application also integrated with the in house billing system, which was an Informix/Unix system to fetch customer plan information and feed back the rated information

Development of Business Intelligent System for retail and calling card business.

This was a centralized data warehouse for calling card, prepaid and retail business used to access management information including customer and financial growth, customer churn, margin analysis, cost analysis, forecasting, trend analysis, top destinations and numerous other key performance indicators. We used SQL Reporting Services 2000 web front end to publish the reports as well as OLAP tools with database in SQL Server 2000. DTS 2000 was used as an ETL tool to transfer data from heterogeneous data sources (around 100 databases including SQL Server, Informix, MS Access, flat files, XML etc).

Carrier Preselect interface development between Primus Telecommunications Ltd and British Telecom and Energis.

This was a Business to Business interface application. The messaging format was in XML which was wrapped in SOAP over HTTPS. This application was responsible to provision or deprovision the customers who wanted to switch to Primus from other voice or data providers and more importantly keep the customer care database up to date, to enable the customer care representatives to be able to update customer with the latest status of their order.

It was three tier based architecture, with asynchronous ASMX Webservices to transport two way messages. The business logic was C# class library and SQL 2005 as data layer.

Calling Card Activation System

This was an intranet based application for internal company users. This was an ASP.NET web based application with windows based authentication. The database was SQL Server 2000.

It had web based front-end to create prepaid distributors, define commission structures, prepaid products, authorizing card activation request, validating card activations, activating phone cards live on the prepaid platform and monitor any fraudulent transactions. Role based authorization was used for enabling any particular action for a user. It also fed data to heterogeneous systems including MIS, commission engine, and SAGE accounting and invoicing package.

August 1999 - September 2002

Software Professional

Organization: Usha Communications Technology, India: It delivers software solutions such as billing, customer care, interconnect billing, meditation, partner settlement solution, and revenue assurance. It caters to fixed, mobile, broadband/IP, and cable and satellite markets. It’s the first billing company to receive CMM Level 4 of certification and has 35 customers across the globe. www.ushacomm.com Calcutta, India

Duties Included

Involved in full development cycle of Unicorn Convergent Billing System, a solution which includes local exchange carrier (LEC), mobile voice and data, IP billing, and customer care modules. It’s based on an open architecture that is CORBA-compliant and supports JAVA and XML.

Worked at various clients’ sites worldwide including North and South America. Gained extensive client/server experience and successfully managed challenging client interaction. Two simultaneous projects completed within an extremely tight deadline.

Projects Undertaken

Onsite development, installation and customization of billing and rating system for

Verizon Wireless, Puerto Rico Telecomm, USA

CDS, Hutchison, Buenos Aires, Argentina

Union Telecomm, Wyoming, USA

Cable and Wireless, Panama

Involved as a module leader in development of the rating system that included rating of all CDMA services for North American telecomm market and GSM services for Argentina and Panama. The technology used was Visual C++, CORBA, Oracle 9i and ILOG Rules in Solaris platform. This application is also known as real time rating engine and used to rate the calls made by the customers. The most challenging project was the one in Puerto Rico due to sheer volume of calls received i.e. millions of calls each day with over a million customer base. I had to manage resource optimally by using load balance processes to reduce the possibility of failure by managing the process state in real time.