8500 Leesburg Pike, Suite 300

                         Vienna, VA - 22182

 

 

Pradeep Mishra

 

SUMMARY

·          Over five years of professional experience in analysis, design, development and implementation of software applications using Microsoft technologies.

·          Web application development using COM/DCOM, ASP, ASP.NET, XML, ADO, ADO.NET, HTML/DHTML, Java Script / VBScript, Oracle 8i/9i, SQL Server 2000, Microsoft Access, Crystal Reports, Actuate Reports.

·          Client Server Application development using VB6, VB.Net, VC++, C#,  SQL Server 2000, Oracle 8i/9i

·          Automating and customizing Microsoft Office applications (Excel, Outlook, Visio, Project) using VBA and designing Add-ins Using Visual Basic 6

·          On-site Development and implementation experience, which includes Architecting plug & play architecture so that application adopts new functionality without changing existing code, providing technical support, analyzing performance and web logs to fine tune  the application and increase performance. Implement custom load balancer service to increase scalability and performance.

·          Strong Programming Logic and Techniques

·          Good Searching skill on internet

 

 

ACADEMIC RECORD

3 Year diploma in system analysis and design (GNIIT) from National Institute of Information Technology (NIIT) in 1999 with outstanding grade and 1 year of professional practice done at Sage Computers Private Limited and PathInfoTech Limited.

 

 

TECHNICAL SKILLS

Operating Systems: Windows 95, 98, NT/2000, Linux, DOS

 

Languages: Visual Basic, Visual C++, C#, Visual Basic .Net

 

GUI/RAD: Visual Studio 6 and Visual Studio .Net

 

Entreprise Technologies: .Net, COM/DCOM, MTS

 

Web Technologies: IIS, ASP, ASP.Net, HTML/DHTML, Java Script/VB Script, XML

 

Databases: Oracle 8i/9i, SQL Server, Microsoft Access

 

Tools: PLSQL Developer, TOAD, Dev-Partner Studio, Soft-ice, Visio, MS Project, Visual Source Safe, CVS, BugZilla

 

Reporting Tools: Actuate, Crystal Reports


WORK EXPERIENCE

 

Name of Employer: Induslogic, New Delhi, India.

Induslogic is the leading business process integration solutions provider. This US based company was founded to address the growing need to reduce the time, expense, and technical expertise required to integrate applications within the enterprise and between business partners.

 

Job Title:                                 Senior Software Engineer

Dates of Employment:           Feb 2003 to till date

 

Projects Done:

 

1.       CAPP .Net (Spectrum/KTA)

KTA specializes in consulting and inspection in the protective coatings (paint) and construction industries.  The main purpose of a KTA inspector is to analyze and assess the performance of paint on several varying pieces of machinery, parts and structures.  KTA inspectors assess a variety of protective coatings (paint) and compare the substrate condition and paint adhesion to the particular environment and make recommendations with regards to maintenance scheduling and cost for various painting activities. When a KTA inspector visits a job site, they break the site (building, structure, room, etc.) into a conceptual hierarchy consisting of: Region, Area, SubArea, Grid, Item, SubItem.  Structures, mechanical equipment and any items that need inspection are defined as Items or SubItems.  Ultimately, it is the Items and SubItems that are analyzed, assessed, and rated as to how well the paint is performing.

 

The objective of the CAPP.NET system is to provide KTA inspectors with an easy to use interface for defining job site Items/SubItems and grade each according to the environment, adhesion, and other factors. Following data entry, inspectors will be able to generate printable reports base on the data and system settings.  Reports will forecast various painting activities for each Item and provide present and future costs for those activities based on system settings and user defined cost per square footage.

 

The software has following features

Grading Scale, Unit Cost, Master Item List, Master Substrate List, Accessibility Factor, User Management, Paint Cycle Management, Priority, Deterioration Curves

 

o         Duration: 1 Month

o         Team Size: 3

  • Environment: .NET Framework 1.1, C#, Microsoft Access, ADO.Net, Crystal Reports

o         Responsibilities:

o         Design and development of forecast viewer, budget planner, data export and import functionality and multiple undo/redo functionality in data entry screens.

 

2.        Engenia Unity Microsoft Project Plug-in and Engenia Unity Visio Plug-in

Engenia Software, Inc. provides innovative enterprise solutions that use intelligent “software agents” to integrate the planning, execution and reporting functions of complex organizational processes. Engenia’s Unity is an agent based solution for IT Process management. Unity provides a platform for automatic IT Project life-cycle management. Unity allows a company to improve entire life-cycle of process management by automating

    • Resource Management
    • Process Management
    • Project Planning
    • Report and Monitoring

There are 3 User Interfaces to Unity.

    • MS Visio
    • MS Project
    • Role Based Console (RBC) – a web based client

 

The project involves development and integration in different technologies. For e.g., the RBC uses, J2EE architecture, using struts and tiles framework, the UI is in form of JSP widgets. For planning, a 3rd party planning engine (Cougaar) is being used and for creating processes, MS Visio, and MS Project plug-ins have been developed in Visual Basic. WebSphere is being used as application server and database is SQL Server 2000.

 

o         Duration: 1.5 Years

o         Team Size: 22

  • Environment: Visual Basic 6, COM, XML, WebServices, MS SQL Server 2000, Microsoft Office Applications (Outlook, Exchange Server, Visio, Project)

o         Responsibilities:

o      Design, development and Integration of Microsoft office products with the Application.

 

3.        Arbinet the xchange  (AxcessRate)

Arbinet is the leading electronic market for trading, routing and settling communications capacity.

 

AxcessRate is the web based system for getting voice minutes pricing and quality statistical reports. This information is powered by real-time voice on thexchange trading activity.  Users can subscribe to multiple daily/weekly/Monthly Reports and pay online with credit card. Once payment is received user is entitled to view these reports from the site or can subscribe them so that the site delivers these reports directly to user’s inbox.

 

AxcessRate shows a daily report with:

 

·                      Average rate / average ASR of over 500 active markets

·                      Minimum rate and associated ASR

·                      Maximum rate and associated ASR

·                      Rate change compared with the day before

·                      The top 10 price gainer and loser markets

 

o         Duration: 3 Months

o         Team Size: 6

  • Environment: IIS 6.0, COM+, ASP.Net using C#, ADO.Net, Oracle 9i, Actuate Reporting server

o         Responsibilities:

o      Design, development of website, Mailing utility, scheduler and Voice/Minutes report

 

 

 

Name of Employer:              PathInfotech Limited, New Delhi, India.

Job Title:                                 Analyst Programmer

Dates of Employment:           Jan 2000 to till Feb 2003

 

Projects Done:

 

4.        Security Audit (Sona Koyo Steering Systems Ltd)

Sona Koyo Steering Systems Limited (SKSSL) is a technical and financial joint venture company of Koyo Seiko Company, Japan, the global technology leader in Steering Systems. With a market share of 50% in volume terms and 30% in value terms, the company is the largest manufacturer of steering gears in India and is the leading supplier of steering systems and columns.

 

Management at SKSSL wanted a third party security audit of their Computer System and make the employees working there aware of security risks involved on the network.  The work involved port scanning all the computers, finding weak points in security of the network and applications etc.

 

o         Duration: 1 Month

o         Team Size: 2

  • Environment: Solaris, Windows 2000

o         Responsibilities:

o      Network and Application security audit.

 

5.        TMS (Transport Management System) Convergys Gurgaon

 

Convergys is a leading BPO and gives its employees transportation facility. This software has been developed to manage their transportation. The software has following features

 

·                      Optimized route generation

·                      Billing

·                      Employee Attendance

·                      Data Upload from excel files

 

o         Duration: 1 Month

o         Team Size: 3

  • Environment: Tomcat running on Linux, JSP, Visual basic, Oracle 9i

o         Responsibilities:

o         I was involved in developing the File Upload Modules and part of team for designing the logic for Optimized Route Generation

 


6.        Data Upload for Airtel IVRS system (Bharti Mobitel Ltd)

 

Airtel offers its customers a facility through which customer can get information such as billing details, activation / deactivation of services etc. This system has choices, which depend on the type of connection the customer owns. This information is sent to the main office in form of excel / Flat file. They can not provide access to their central database from all of their branches. These branches collect the data in form of flat/excel files, at the day end they upload the files to ftp server. Here at ftp server there is a scheduler running which picks up the files and upload them to database accordingly. This system also generates reports regarding the status of the uploaded file

 

o         Duration: 1 Month

o         Team Size: 2

  • Environment: Visual Basic, Oracle 8i

o         Responsibilities:

·          Design, develop and Implement Client/Server utility to manage IVRS database, Upload program to read flat file and update IVRS database accordingly, Scheduler to invoke upload module.

 

7.        I-LOAN (Loan Processing System) Citi financials

Citi financials is a leader in auto and personal loans in India, its loan processing system known as FINNESS developed by Nucleus has become industry standard software used in organizations dealing with loans.

 

I-Loan is a central web based leasing system, conversion of client/server system FINNESS for use with different branches of Citi financials including that of Singapore, Philippines. Initially project involved development of the Application Processing Module of the I-Loan System and eventually converting whole product to web.

 

The application consists of 3-Tier architecture, Active Server Pages (ASP) as the Presentation Layer, COM Components as the Middle Layer/Business Layer and Oracle 8i as the Database Layer.

 

The system consists of many modules which are tightly integrated with the product, which covers the whole functionality of the system such as I- Collect, I- Foreclosure, Renewal. The Loan Processing System consists of the following steps beginning with application for a loan to disbursal of the loan. The product consists of following modules.

 

·          Application form: Accepting loan and Personal details of the customer. Checking authenticity of the customer.

·          Soft approval of loan.

·          Contact point verification & telephone verification (CPV & TVR).

·          Repayment schedule generation, Charges generation, Advices generation.

·          Final decision for loan.

·          Pre Disbursal Documents collection

·          Authorization.

·          Disbursal of loan.

·          Check printing.

·          Post Dated Cheques Management

·          Foreclosure of loan

·          Collection System

·          Receipts & Payments

·          EOD (End of day activity)

 

o         Duration: 2 Years

o         Team Size: 25

  • Environment: IIS 5.0, MTS/COM+, ASP, ADO, Oracle 9i, Pro C/C++.

o         Responsibilities:

·          Design, development an architecture which would involve least effort to convert existing system to fulfill needs of Singapore, Philippines, Hong Kong Branches

·          Internationalization (making application change its contents depending on the location of the user)

·          Designing generalized transactional secure COM components for providing single data access point.

·          PDCMS (Post Dated Cheque Management System)

·          Performance Analysis and Performance enhancement by implementing custom caching for frequently used data.

·          Implementing and customizing custom load balancer developed by Microsoft Corp for Citi financials.

·          Document Management Module

·          Application form for Philippines

·          Receipts and Payments Module

·          Designing of  generalized custom controls for providing features such as LOV( List of values)

·          Providing technical support while the system was being implemented at Citi Bank’s data center at Singapore.

 


8.        Batch Upload (The Associates now a part of Citi Financials)

 

The branches of Associates collect much of their data in excel/flat files due to convenience and non availability of online system. Later this data was entered in to the system manually, due to the expansion of the Business by Associates the local branches increased and so did the offline data. The process of entering this offline data in to the system was a lengthy process and took around 10 minutes for entering one application details to the system. Overtime it became necessary so as to automate the process of entering offline data in to the main database.

 

Batch Upload Process automates the work of manual data entry done for different modules by different branches; the process involved collecting data in a specified file format offline and then submitting the file to the server. It was where Services running at server merged the file with the main database informing the user about the uploaded records and rejected records and reason for rejection.

 

The Utility is designed such that any new module can be integrated to it with out changing any of the code

 

The utility was broken into 4 parts

o         User interface, providing option for uploading files for different modules

o         Program to check integrity of the file uploaded

o         Program to verify information provided in file

o         Program to upload the file in database

o         Program to do any post upload activity if desired 

       

 

o         Duration: 4 Month

o         Team Size: 2

  • Environment: Visual Basic, Visual C++, ActiveX, ASP, COM Oracle 8i

o         Responsibilities:

·          Design, develop and Implement User Interface for uploading file and online Module addition and deletion and updation.

·          Design, develop and implement Secure file transfer mechanism, including development of an custom ActiveX Control to transfer file and calculate checksum of the file

·          Design, develop and implement upload, file integrity checking, pass the file to a database stored procedure for upload and any post update activity