Profile image of prashant542
@prashant542
Flag of India Ahmedabad, India
Member since May 3, 2011
0 Recommendations

prashant542

Online Offline
I am a freelancer, doing work on VB6, Excel Automation, VBA coding, VB6 Softwares, Access Database. In my total Five Year and six months experience of my career, I have acquired a very good knowledge of SQL SERVER , T-SQL, SSRS,SSIS,Pl/Sql, Oracle administrative task ,Linux script and PostgreSQL Database and core java.  Profound Knowledge of SSIS, SSRS and SSAS. Developed Packages using data flow and Execute SQL Tasks And also used SSIS For DEveloping CDC , Backup Database,  Shrink database, Index Rebuild and Reorganize, data mining and Analysis Tasks. Also deployed using SSIS DB Catalog. Developed Reports and deployed on Report Manager Server. Developed complex query.
$10 USD/hr
28 reviews
3.5
  • 97%Jobs Completed
  • 100%On Budget
  • 100%On Time
  • 56%Repeat Hire Rate

Portfolio Items

Recent Reviews

Experience

Technical Associates

Oct 2009 - Nov 2011 (2 years)

Technical Technology : Unix shell script, Perl Script, Sybase Operating System : HP Unix(Middle Level) Backend: : Sybase, SQL Developer, Oracle FUNCTIONAL Project Execution  Interfacing with ASM Leads / Clients for requirement gathering.  Adhering to plans & schedules, participating in team meetings for individual projects.  Conducting UAT for the client  Maintaining quality norms throughout the implementation of process.  Support to client for application. Key member of the team that successfully executed the following project Title : B+ Benelux [GUF, Concreto] Description : Billing+ Benelux ASM- This project involved transition of 12 systems from BT and other 3rd party vendors to Tech Mahindra. There are various billing systems, rating systems and order management systems that have to be transitioned and thus brought to be billed under Tech Mahindra account. In BAU it involves Application Support & Maintenance (ASM) / Application Development (AD) as part of Flexi capacity. Key Roles as Application support team member 1. Ensure application availability in the Benelux business hours and maintaining the SLAs as per GSLA. 2. Ensure Daily maintenance and support activity of the application. Doing feasibility study whenever there are any new enhancement requests. 3. Ensure deployment of any new enhancement request. 4. Facilitates effective Impact Analysis and Effort estimations. 5. Conduct review of low level designs, test plans and code. 6. Effectively provide third line support for application including handling faults raised by users and carrying out various proactive maintenance activities, to minimize fault levels. Working with the Application Support Group to determine nature of fault, fault resolution, etc. 7. Ensure that enhancement and maintenance of existing scripts pertaining to application and thereby improving both on business processes and performance. 8. Possesses understanding in the areas of application programming and database. 9. Possesses understanding in the Change Management with knowledge of bridge clarify. Accountabilities  End to End knowledge of Application Support Management  3rd Level Support which includes configuration and deployment activities.  Lead Role in supporting the primary system GUF and responsible for the same  Use of Sybase ASE, SQL developer for Database  knowledge of Unix and Perl scripting  Knowledge of Bridge Clarify for service request and change management  Report generation on daily basis and reporting to the higher management about SLA’s and KPI’s Attended and successfully completed Tech Mahindra’s Initial Training Program where subjects such as UNIX, SQL and PL-SQL were extensively covered.

Education

B.E. Mechatronics

2004 - 2008 (4 years)

Qualifications

How to reduce cost in import and export (2009)

Ahmedabad Management Association

This is Certification Course to reduce export and import process.

Certifications

  • Numeracy 1
    90%

Verifications

  • Facebook Connected
  • Preferred Freelancer
  • Payment Verified
  • Phone Verified
  • Identity Verified
  • Email Verified

My Top Skills

Browse Similar Freelancers