Overview

• 8 years of IT and telecom industry experience encompassing a wide range of skill set, roles and industry verticals.
• Extensive experience in working/coordinating with the end user groups/communities to gather and collate the requirements to determine the underlying business processes driving the needs of the enterprise.
• Strong database skills and good knowledge of Object Oriented Programming with over 7 years of programming experience as an Oracle PL/SQL Developer in Analysis, Design and Implementation of Business Applications using the Oracle Relational Database Management System RDBMS .
• Expertise in Client-Server application development using Oracle 11g/10g/9i/8i, PL/SQL, SQL Developer, TOAD and T-SQL.
• Developed Complex database objects like Stored Procedures, Functions, Packages and Triggers using SQL and PL/SQL.
• Have very good grasp of PowerBuilder language and PowerScript working for over 7 years and can work effectively with business users in helping design Analytical Solution and work closely with users or end clients in figuring out key business metrics for their functional areas.
• Experience in dealing with web services, web technology related application and experience in infrastructure design changes.
• Experienced in creating Business Requirement Documents, User Requirement Specification and Functional Requirement Specifications.
• Experienced in creating technical designs like Application Development Design and TDS Technical Design Specifications .
• Experienced working with various tools like Oracle SQL Developer, Quality Center, Microsoft Visio, Rational Clear case, Install Shield Express and Rational Portfolio Manager.
• Experienced working with Database and web servers like ASE Adaptive Server Enterprise , Web logic and EAServer.
• Worked with different relational database management systems like Oracle 9i, Oracle 10G and Sybase.
• Expertise in evaluating user requirements closely working with direct clients like Sprint, Development Credit Bank, Citibank providing effort estimation and technical feasibility for each project.
• Experienced in following and monitoring processes improvements throughout the product development lifecycle using SDLC for a point of sale/ enterprise application.
• Effective in executing multiple tasks and assignments ahead of schedule.
• Reputed for dedicated teamwork, high energy, work ethics and commitment with capability to handle new technologies and situations. Received consecutive appreciations from Senior Management for effective management of deliverables.
• Good understanding of Project Process and ability to analyze business problems and identify solutions.
• Experience in working in an Agile Development Environment.
• Worked extensively with the team to meet business requirement, create prototypes and analyze workflow.
• Provide support to Testing team and Production Support Team to analyze and fix any production issues.
• Experience in Migration of PowerBuilder applications to higher versions.
• Team player and self-starter with excellent communication, coordination, documentation, project planning and interpersonal skills.

.

Experience

Confidential

Associate Systems Analyst

Job Profile:

• Working as the Technical lead for the development and analysis of RMS Retail Management System application for Sprint USA.
• RMS has its thick client in PowerBuilder 11.5 and thin client in Java. Entire thick client related development and issues are handled by our team.
• RMS has its DB on Oracle 11g, lately upgraded from Oracle 9i.
• Design and develop Stored Procedures, Functions, Packages and Sequences using PL/SQL for new enhancements.
• Developed PL/SQL triggers and master tables for automatic creation of primary keys.
• Created indexes on the tables for faster retrieval of the data to enhance database performance.
• Responsible for designing application architecture in PowerBuilder, maintaining version control, packaging and deployment to production environments.
• Responsible for Change Management to transform the current application to store of the future on mobile and tablet devices.
• Review Detailed Application Design Document for new enhancements.
• Monitor the team to deliver high quality software code using various quality process and strict adherence to guidelines to SDLC standards.
• Maintain version source safe control by creating branches and code merges using tool Rational Clear Case and create installer exe using Install Shield Express for deployment.
• Responsible for Effort estimation of the project-- Prepare LOE Line of Estimation before and after contract approval.
• Responsible for performing technical feasibility study based on system requirement received from system analyst for a project and provide feedback for any modifications.
• Provide support for end to end testing by assigning, tracking, resolving and reporting defect metrics using change synergy and Jtrac.
• Responsible for maintaining process templates, training certification and other project management activities using tool Rational Portfolio manager for audit purpose.
• Received constant appraisal for understanding the application quickly and acquiring the required technical skills to deliver high quality solutions to the client in response to specific business requirements.
• Rearchitecture of the RMS application to move Business Logic written in PowerBuilder to Web services in Java and deploy on Web logic Server.
• Use .NET Web service engine to call Web Services on the Jboss Application server from PowerBuilder.
• Use Active X controls in PowerBuilder to connect to a Signature Capture Device to capture signature and display other forms used in RMS supplication.
• Develop forms using Form Builder to deploy on the Signature Capture Devices SCD that constitutes the peripheral part of the RMS application for capturing the customer signature.

Confidential

Job Profile:

• Excellent communication and interpersonal skills with clear understanding of business and ability to work as a part of team or lead the team.
• Gained functional technical experience in the design of Telecom Billing Amdocs Ensemble CSM Online during this period. Worked on all the phases of software development lifecycle from High Level Estimate HLE till User Acceptance Testing UAT .
• Prepare Detailed Application Design Document and required code changes for new enhancements.
• Responsible for performing technical feasibility study based on system requirement.
• Gained experience in following Ensemble modules viz. CSM Online, Price Plan, OL2 applications, Security Online. Also, supported CSM Backend during System Testing and UAT.
• Extensive hands on experience Involved in writing Test Plan, Test Cases, reviewing and executing test cases.
• Worked in PowerBuilder 10.5,8,9, which is the primary tool I work with for the front-end CSM Online and C, UNIX for the backend. In addition to this Quality Center and Version control are being used
• Worked with basic shell scripting and navigation tasks in Unix to identify errors.
• RDBMS Oracle 9i was used as the database for CSM application.
• Developed Complex database objects like Stored Procedures, Functions, Packages and Triggers using SQL and PL/SQL.
• Worked in the PowerBuilder Infra team that handles all the PowerBuilder issues allover Amdocs. Developed a tool called Internationalization in PowerBuilder for language translation between different languages English, French and German .
• Worked for the Bell Canada Project on Tax Harmonization CR that involves major Tax conversion in many provinces of Canada and had a major impact on the application.

Confidential

Software Engineer

Job Profile:

• Involved in complete SDLC for the development/enhancement of the application.
• Activities as Unit Test Case Creation, Coding, Unit testing document updating with respect to SDLC standards were carried out.
• Design and develop reports with complex Stored Procedures in PL/SQL for new enhancements.
• Responsible for development of reports and enhancements in the ISEC ICICI Securities application.
• Coordinated with the client and made regular visits to the client place to gather requirements, and analyze the system.
• Worked with Oracle 9i for clients ISEC and Citibank .
• Developed Application using PowerBuilder Version 6 and 9.
• Migration of the application from PowerBuilder 6.0 to PowerBuilder 9.0.
• Worked closely with the testing team for identifying any functional gaps and ensured a smooth bug free delivery.

Confidential

Job Profile:

• As a developer I worked on projects that involve end to end activities required for the development of the application using SDLC standards.
• Design and develop reports with complex Stored Procedures in T -SQL for new enhancements.
• Worked with PowerBuilder 8.0,9.0 and 6.0 to develop a treasury module for one of our clients Development Credit Bank Ltd. in Mumbai which involves:
• Development and testing of different interface screens.
• Preparing reports using PowerBuilder 8.0 and 6.0.
• Accordingly preparing SRS and User Manual Documentation.
• The backend used was ASA Adaptive Server Anywhere 7.0 Sybase, EA Server and Oracle9i.
• Had been working with ASE 12.5 Adaptive Server Enterprise .
• Located at Client side and was responsible for all the activities under the application.