• Designed, developed and deployed multithreaded online/offline/hourly data processing application using C#, SQL/T-SQL to process a huge amount of telecommunication data (Call Detail Record).• Rewrote in-house applications and programs to adapt new requirements.• Designed, developed, deployed and executed SSIS packages to serve regular and on-demand data processing request.• Analyzed, created and modified complex SQL procedures, queries, user defined functions, triggers according to database specification.• Implemented indexing and partitioning in SQL Database for performance tuning of long running queries.• Monitored Revenue Assurance & Fraud Management (RAFM) alerts and took immediate action based on alert to ensure uninterrupted client’s services.• Ensured periodic system health check and proper housekeeping as per SLA to ensure smooth data processing.• Provided 24/7 L2 support for production systems.• Created views to avoid query complexity for front end developers.• Followed ISO and ITIL standards to handle incident, service request, problem, change and release management.• Assisted other team members to meet delivery timeline or critical operation support.

• Analyzed project requirements and prepared database documentation.• Designed, developed and maintained in-house database application (e.g. Buyer Information Management System, Members Directory, Utilization Declaration Automation) using .Net technologies.• Used ADO.NET and data objects such as Data Adapter, Data Reader, Dataset, data table for accessing data from SQL data sources.• Designed and implemented database objects according to ERD.• Developed Stored Procedures and User-Defined Functions using SQL/T-SQL.• Installed and configured Microsoft SQL Server 2012 in database servers.• Created, deployed required reports using Crystal Report and SSRS.• Operated, maintained and monitored database servers.