BUSINESS KNOWLEDGE: Financial accounting, Wireless Telecom Billing, Manufacturing, Logistics, RFID, Customer Services, Geographical Information System, Health Care

EXPERIENCE:

Confidential

• Software: C .Net, VB.Net, ASP.Net, VBA/Excel, AJAX, ISS, Telerik, CSS, Java Script, SQL Server, SSMS, SQL, Visual Studio 2008/2010/2012, N-Unit, SOAP,WCF, Web Services, XML, TFS, Agile
• Enhancement of Capital Asset Tracking System application and associated reports.

Confidential

Software: C .Net, VB.Net, ASP.Net, ADO.Net, AJAX, ISS, Telerik, CSS, Java/ Ecma script, Kana-Ciboodle, Perl, Oracle, SQL server 2008, PLSQL, SQL, TOAD, Visual Studio 2008/2010, N-Unit, SOAP,WCF, Web Services, XML, Java, VSS, SVN Tortoise, Jira, Linux, Agile

• Analysis, design and development of CRM application covering the functional area of call tracking, Mail Order Pharmacy, Claims, Prior Authorization and Financial Accounting.
• Developed business layer libraries using object oriented methodology and design patterns.
• Developed web services for data access from different data sources.
• Leading and mentoring a team of six developers based at various geographical locations.
• Prepared unit test cases and developed N-Unit test scripts for testing of business layer methods and web services.
• Custom development and implementation of Kana-Ciboodle CRM.

Confidential

Software: C .Net, ASP.Net, AJAX, CSLA.Net, Infragistics, C/C , STL, Perl, DBI, Oracle, SQL server 2005/2008, PLSQL, SQL, TOAD, Visual Studio 2005/2008, ADO.Net, VB.Net, N-Unit, SOAP,WCF, Java Web Services , XML, JCAPS eView ,VSS, Business Object, Tuxedo, IIS, WebLogic, Unix, Remedy

• As Technical Lead, analyzed, designed and developed Group Insurance, Individual Insurance enrollment and Pharmacy benefit application.
• Analyzed, designed and developed EDI file processing system using JCAPS eView .
• Analyzed designed and developed Business Object universe and reports.
• Provided training to all development team in the area of CSLA.Net, Design Patterns and Generics.
• Analyzed, designed and developed new enhancements required for Financial Accounting application with features such as account receivables, adjustments, accruals and payments.

Confidential

Software: Oracle, PLSQL, SQL, C , STL, Visual Studio 2005, ADO.Net, C .Net, ASP.Net, Java Swing, JSP, ANT, ARM, Perl, DBI, XHTML, RogueWave, XML/SOAP, OpenSSL, Great Circle, Workshop debugger, UML, PFUnit, Doxygen, Telelogic Synergy

Middleware: HTTP/HTTPS, CORBA, Tuxedo, Tomcat

Hardware: Sun Solaris UNIX, Linux, AIX, HPUX

During this period, I worked on analysis, design and development of 3G wireless telecom billing application ATLYS/INFINYS . This system was developed for rating and billing of wireless telecom usage records in real-time using multithreading.

• As Team Leader and developer, I was responsible for design and development of Financial Accrual Accounting system. I worked on this project from the very beginning and prepared various design documents such as Design concept, FDS, Detail Design and unit test scenarios. This system had various real time processes, batch programs and event based processing for creating real time accrual data in database table. I designed various triggers and stored procedures for optimizing this task.
• As a developer, I analyzed, designed and developed application for price plan management for wireless clients using Java Swing.
• As Team Leader and developer, I designed and developed ARM Application Resource Measurement sub system for measuring the performance of APIs and batch jobs using C , C and Java. This system can be configured for measuring the performance at detail and aggregate level.
• As lead developer, I analyzed, designed, and developed features of real-time prepaid rating and billing engine for prepaid wireless services Go-Phone . This is a mission critical application and is capable of charging the customer, when their balance falls below a predetermined level using a credit card or electronic fund transfer EFT . This application interfaces with client's payment system UPS- Universal Payment Systems- Cingular wireless and clearinghouse using secured connection OpenSSL .
• As lead developer, I designed and developed APIs for making automatic payment using credit card and EFT Electronic Fund Transfer . Earlier this process was batch program and had significant time lag in posting the payment in the financial system.
• As Team Leader and developer, I was responsible for enhancement of real-time rating engine for supporting 30 million subscribers on a single database. Various real time batch processes were developed for sorting and merging of usage files and updating the database with real time usage and rating information. Various validation and translation plugins were developed for this enhancement.
• As lead developer, I analyzed, designed and developed APIs for calculating taxes on payment and adjustment in real-time using Vertex.
• As Team leader and developer, I was responsible for back porting of HTTP based middleware application. By using HTTP based connection, client can call the APIs directly and thus bypassing CORBA and Tuxedo. This is being used by AT T Wireless for their Siebal based CRM system.
• Analyzed various APIs and batch process for improving performance and suggested changes in code and SQL query. Also worked as development DBA on Infinys-Wireless Extension development for creating tables, indexes, views, triggers and stored procedures.
• Analyzed, designed and developed report scripts for compliance of Sarbanes Oxley requirement.
• Designed and developed Walkthrough process tracking system, as part of CMMI using core Java and JSP. Prepared walkthrough process for various design documents i.e. design concept, detail level requirement, detail level design, and test plan and guide line for code review.
• Provided training on memory leak testing using Great Circle to all 3G-development team.

Confidential

Software: ORACLE, Ingres, PL/SQL, SQL, C/C , Tuxedo, and ClearCase

Hardware: HP/UNIX

Worked on development project of Wireless Telecommunication Billing System

for Nextel Communication. The enhancements were related to DirectConnect iDEN - Horizontal Networking and data services.

• As technical lead and developer, I analyzed, designed and developed the changes required for Horizontal Networking Dispatch Service- Direct Connect , Wireless internet Packet Data , Data Provisioning and DAP migration tools in Billing, Rate Plan, Switching, Finance and Customer Care modules.
• As lead developer, I analyzed, designed and developed lock-box payment system. This process had various batch programs and interfacing with lock-box files provided by financial institutions.
• Analyzed various SQL queries for performance improvement of various real-time and batch processes. Suggested modification to program logic and query for improving performance of API's and batch processes.

Confidential

Software: INGRES V6.4, INGRES Windows 4GL, CA-OpenRoad, ESQL-C, Oracle, PL/SQL, Triggers, Stored Procedures, and Tuxedo

• generated from various businesses of the company. A large number of reports and batch jobs were developed for reporting and automating the data entry tasks.
• Client Server technology. This application is being used for tracking down the revenue
• IRMS Integrated Revenue Management System was developed using GUI and
• Hardware: DEC ALPHA/Open VMS, UNIX, Windows NT
• As lead developer, I analyzed, designed and developed GUI based financial accounting application for Multiple Cash, On Account Cash, Transfer Cash, Estimations and COI Centralization of Invoicing modules.

• Analyzed SQL queries used in front end, ESQL-C and Report script. Analysed the QEP Query Execution Plan and recommended to create new indexes and manipulation of IISTATS catalog. Introduced the method of optimizing the temporary tables during run time for enhancing the performance of reports.

Confidential

Software: INGRES RDBMS V6.4, INGRES 4GL, ESQL-C,

Hardware: HP/UNIX

• TRIS Telecommunication Record Information System is a Cellular Phone Billing System. It was developed in Ingres 4GL, ESQL-C and Ingres RDBMS. This application covers the areas of customer installation, activation of the phone switches and generating the bills. TRIS supports multiple services i.e. Cellular, Short Messages, Voice Mail, Dispatch and PCS.
• As Developer, analyzed the enhancements in Customer, Switch Co-Processor, Daily Update and Billing Download applications in TRIS . Analyzed the impacts on other sub-systems, and created test plan and release documents.

• Analyzed SQL queries and made changes to front end and batch jobs, to improve performance and remove the possibility of data inconsistency.