SUMMARY:

• Having more than 11 years of IT industry experience encompassing a wide range of skill set, roles and industry verticals. Currently working with Tech Mahindra Pvt Ltd, Kolkata.
• Deputed to New Zealand (client - 2 Degrees Mobile) for about 4 month on work permit.
• Deputed to Canada (client - Air Canada) for two months on business visa.
• 8 years of experience in telecom domain.
• Extensive experience with analysis, design, development, customizations implementation and Project Management of software applications.
• Extensive experience in Oracle, Unix, Informatica.
• Expert in Agile Project Management Method Using Scram.
• Proficient in analyzing and translating business requirements to technical requirements and architecture.
• Good communication skills, interpersonal skills, self-motivated, quick learner, team player.
• Experience to handle client in different GEOs like (U.S, Canada,Europe,China etc).

TECHNICAL SKILLS:

RDBMS: PL/SQL Oracle 11G.

Scripting Language: Unix Shell Script.

ReportingTool: Business Object(B.O),Crystal Report

ETL Tool: Informatica .

Programming Languages: C, PRO* C

Operating Environment: Windows NT/2000 Server, Windows XP, Solaris UNIX, LinuxRTOS- LYNXOS.

Quality Tool: Rational Clear Quest, Infoman.

Configuration Management Tools: MS-VSS (Visual Source Safe), IBM Rational Clear Case,MKS,SVN

Development Environment: TOAD 8.6.

PROFESSIONAL EXPERIENCE:

Technical Lead/Designer

Confidential

Responsibilities:

• Requirement gather, impact analysis, preparing design document for team to develop the new changes.
• Project Management activity
• SQL tuning and optimization for manipulation of data.
• Database performance Tuning and monitoring.
• Report generation in B.O Crystal report and BI Publishers.
• Used Informatica power center for (ETL) extraction, transformation and loading data from heterogeneous source systems.
• Performance tuning of Informatica.
• Emphasized in analysis of some typical product bug and suggested required changes to address issues pending for a long time.
• Import source/target from respective database, creating mapping by usingtransformations (Joiner, Routers, Lookups, Filter, Expression, and Aggregator) and Mapplet to load the data in target through Designer module of Informatica.
• Coordinated the change management process and documented as mandated by the client and organization.
• Involved in the testing phase of the project in different areas. Authorized to review the UAT test cases prepared by the development team.
• Performed GAP analysis of the documents provided by client during different releases.

Technical Lead /Senior Solution Designer.

Confidential

Responsibilities:

• Requirement gather, impact analysis, preparing LLD(low level design document) for team to develop the new changes.
• Tuning and monitoring Database performance.
• Understand Business Service Request and translate into configuration design specification impacting various modules of BFG.
• SQL tuning and optimization for manipulation of data.
• Used Informatica power center for (ETL) extraction, transformation and loading data from heterogeneous source systems.
• Import source/target from respective database, creating mapping by usingtransformations (Joiner, Routers, Lookups, Rank, Filter, Expression, and Aggregator)and Mapplet to load the data in target through Designer module of Informatica.
• Emphasized in analysis of some typical product bug and suggested required changes to address issues pending for a long time.
• Coordinated the change management process and documented as mandated by the client and organization.
• Involved in the testing phase of the project in different areas. Authorized to review the UAT test cases prepared by the development team.
• Performed GAP analysis of the documents provided by client during different releases.

Senior Solution Designer.

Confidential

Responsibilities:

• Understand Business Service Request and translate into configuration design specification impacting various modules of KUBIS. Configuration of Promotion, Discounting, Free Unit and Rate Plan for GSM specific services in CRM(KUBIS).
• SQL tuning and optimization for manipulation of data related to customerDesigned and developed applications based on technical/functional requirement document.
• Emphasized in analysis of some typical product bug and suggested required changes to address issues pending for a long time.
• Complex report generation as per the client requirement.
• Coordinated the change management process and documented as mandated by the client and organization.
• Delivered and created documents for the team to use it as a future and knowledge transition purpose.
• Performed GAP analysis of the documents provided by client during different releases.

System Analyst.

Confidential

Responsibilities:

• Identified recurring issue related to Salesview Application and altered the code to provide solution to fix the issue.
• SQL query tuning.
• Designed and developed applications based on technical/functional requirement document.Emphasized in analysis of some typical product bug and suggested required changes to address issues pending for a long time.
• Coordinated the change management process and documented as mandated by the client and organization.
• Performed GAP analysis of the documents provided by client during different releases.
• Developed the test cases to capture every step to ensure that the system is functioning properly as per the expectation.
• Involved in the testing phase of the project in different areas. Authorized to review the UAT test cases prepared by the development team.
• Delivered and created documents for the team to use it as a future and knowledge transition purpose.

Senior Developer.

Confidential

Responsibilities:

• Designed and developed applications based on technical/functional design documents for different business process.
• Resolved critical issues across multiple releases for the client that has severe business impact.
• Involved in the testing phase of the project in different areas. Authorized to review the UAT test cases prepared by development team.