List of Freelancers

PRASHANT PANDEY
F 404, Daffodils
Magarpatta City, Hadapsar,
Pune
Pin Code 411013
Mobile No: 9890458653
E-mail: panprashant@gmail.com

CDAC ACTS alumni having an experience of 7 years and 2 months.

Strong analytical and logical skills with a knack of getting solutions to problems.
A strong liking for Linux environment.
Immunity from tools or technologies as long as it is on Unix like OS.
Ability to work independently with minimum of guidance.
The drive to go that extra mile for meeting deadlines.

Completed Post Graduate Diploma in Computer Application from IGNOU in 2007 with First class.
Completed Diploma in Advanced Computing from CDAC ACTS Pune in 2004 with 56.75% aggregate marks.
Completed Bachelor in Computer Science with First Class from University of Pune in 2003.

Operating Systems : Linux, Windows 9X/2000
Database Systems : MySQL, Oracle
Languages : Perl, Shell

Tools : SVN, CVS

Dynpro India. from June 01, 2010 till date.

Project Title : Datastar data migration
Client Name : Proquest.
Environment : Linux, XML, Perl, Shell, Sed, Awk.
Role / Position : Senior Software Developer
Period : June 2010 - Current date

Description :
ProQuest LLC is an Ann Arbor, Michigan-based electronic publisher and microfilm publisher. It provides archives of sources such as newspapers, periodicals, dissertations, and aggregated databases of many types. Its content is estimated at 125 billion digital pages. Content is accessed most commonly through library internet gateways, with navigation through such search platforms as ProQuest, CSA Illumina, Dialog, Datastar, Chadwyck-Healey, eLibrary and SIRS.
Our project Datastar migration involves transforming data feeds provided in various format to XML and then mapping XML tags found in these data files to pre determined and specific tags of Proquest, which facilitates conversion to Proquest format.

Responsibilities :
Developing tools to convert input data to XML. These tools are scripts in Perl, Shell.

Cleaning malformed XML data. This involves extensive use of regular expression.

Mentoring new joiners on understanding project details and usage of data migration tools.

EXFO India. from September 07, 2009 to May 28, 2010.
Project Title : Custom Solutions
Client Name : EXFO.
Environment : Linux, Apache, Perl, Mason, Oracle.
Role / Position : Senior Developer
Period : Sep 2009 - May 2010

Description :
EXFO owns a Telecom Service Assurance product BrixWorx which it sells to various Telecom companies to pro-actively monitor their networks by running a set of network tests from the array of standard and customised tests available. The data generated from these tests is used to generate reports . The report suite available to a customer can be customised. The job of Perl team is to customise BrixWorx as per the Statement of Work signed with a telecom company. UI and report generation logic has been developed in Perl using Mason. Some sections of report also use Cognos as a technology.

Responsibilities :
Building up new web pages using Mason.

Writing perl scripts which act as business logic behind the data reported by HTML/Mason pages.

Communicating with EXFO US team for requirement gathering, consolidation, defect clarification, defect resolution etc.

Providing progress report to technical manager and interacting with QA team on defect reporting and fixing.

Cybage Software Private Ltd. from September 21, 2004 to August 28, 2009.

Project Title : RCG_WEBCRAWLING
Client Name : The Rubicon Group, Atlanta GA.
Environment : Linux, Apache, Perl, MYSQL.
Role / Position : Programmer Lead
Period : Dec 2005 - Aug 2009

Description :
The chief product we work on is MarketVision – a competitive rates
shopping application. This web-based application gathers, stores and reports competitor
rates from various web sites. Reports available in MarketVision compare the rates that a
specific customer (such as an individual hotel) charges for their products (hotel rooms),
with the rates that the competition (other similar hotels in the same city) charge for
similar products.
MarketVision delivers the results of rate shopping through various reports and outputs.
Users can view reports online, through the MarketVision user interface, in html, PDF,
excel, or CSV formats. Reports can also be emailed to customers on a scheduled basis in
those same formats.
MarketVision gather rates to support customer competitive rate shopping reports by executing software agents that extract rates from the data sources where rates are displayed. The software code for each agent is customized/hand-crafted for a specific data source.

Responsibilities :
Developing the Web shopping agents referred to by an abstraction ‘repository’ for various web sites which cuts across the domain of hotels, car rentals, airlines and travel packages. Comfortable with perl modules WWW::Mechanize, Date::Parse, Date::Calc, Date::Format, XML::Simple and apt with the usage of regular expressions. Over 3.5 years of my association with this project I have matured from being a developer to being the technical lead of the project. Have developed repositories from scratch for around 50 sites and have fixed broken repositories for around 500 sites. Being a lead have to coordinate the efforts of team members with regards to websites under my domain and also solve the technical and logical roadblocks they face.

Have written perl scripts to automate tasks of fetching data from remote servers in order to synch up local databases, automating tasks of periodic backups of database.

Have written scripts to generate XLS reports for frequently run database queries, using perl modulesSpreadsheet::WriteExcel, Spreadsheet::ParseExcel::Simple.

As our delivery model is built around a ticket based system, have to send deliverables every single working day.This requires exhaustive reviewing. Have been leading this task since 2 years. This has given me ample experience of client communication primarily in written mode.

Project Title : IS HELPDESK
Client Name : Cybage Software Pvt. Ltd.
Environment : Linux, Apache, Perl, MYSQL.
Role / Position : Programmer
Period : Aug 2005 - Nov 2005

Description : A ticket and event management system for regulating and recording day to day working of an inhouse department of Cybage i.e Information Systems. The system was developed in Perl and Javascript with MySQL at the back end. The system was based on CGI paradigms.

Responsibilities:
Addition of features which included ability to view unhandled tickets list, assign tickets to a resource, ability to create, edit and close a ticket from the level of a user and an admin. The project involved working with perl modules CGI, DBI and an extensive use of Javascript and HTML.

Project Title : CEON BELLSOUTH
Client Name : Ceon, Redwood City CA.
Environment : Java, J2EE ,Oracle 9i, Windows 2000.
Role / Position : Programmer.
Period : Feb 2005 - Jun 2005

Description : This project was to integrate CEON IPS (Order and Provisioning & Activation server) with Bellsouth VoN, Billing Support System and Operational Support Systems release 1.0 .It aims to create a Market Package over Ceon IPS .The technologies used in the project are EJBs(mainly stateless session beans and entity beans),JMS ,CORBA-IIOP.

Responsibilities :
Due to the brief association with this project and as it was my first project in the organization had very limited responsibilities. The tasks undertaken by me during this period can be summarized as:
Working on assignments involving EJBs (Stateless Session Bean), JMS, Workflows on Weblogic Application Server as part of ramp-up plan.

Was involved in internal testing (Integration Testing), of all the modules in the system
Namely Customer Profile , User Profile ,Order Management, User Subscription etc. It was a kind of sanity testing to be undertaken before releasing the build for User Acceptance Testing.

Date of Birth : 27th Dec 1981.
Marital Status : Unmarried.
Permanent Address : F-404 Daffodils , Magarpatta City, Hadapsar, Pune - 411013.