SUMMARY:

• 5.9 years of total experience in design, development and implementation of software products and applications
• 3.8years of experience in IBM Sterling application Version 7 and 9 Visual Modeler
• Worked on IBM Sterling Commerce implementations (CPQ) and gained expertise in data modeling using Configure, Price, Quote or Order Management Product Version 9x and 7.1
• Extensive business knowledge of telecommunication industry including Order Management System and Online product catalog systems

TECHNICAL SKILLS:

Programming Languages: SQL, VBScript

Web Tools: HTML, XML, FrontPage, SQL Developer

Oracle 10g, MS SQL Server, MS: Access, MYSQL

Operating Systems: Windows, DOS, Unix, Linux

Applications: IBM Sterling Commerce V7 & 9, MS Office Suite, SOAP UI, MS Visio, MS Project

PROFESSIONAL EXPERIENCE:

Confidential, CA

IBM Sterling System Analyst

Responsibilities:

• Analyze and Review the Project Requirement Documents with Business analysts.
• Discuss requirement with requirement team and create modeling design document with development team.
• Create Functional Requirement Documents based on the Business requirement and confirm with the Project Manager.
• Participate in UI Walkthrough meetings with Business users and Business Analysts.
• Managed Model Team while working on conversion Project and resolved complex Data & Model issues
• Participate to find the best solution and plan to fix number of defects in limited time
• Discuss the project tasks and HLEs with project manager.
• Create and modify Model Groups, Models, Option Class, Option Items, Rules, Properties and Lists using Sterling Visual Modeler.
• Perform Import and Export of Models from Development Env to Integration Env when needed
• Work on different sales channels such as Call Center, Aggregator and Dotcom
• Investigate complex Data & Pricing related issues in Database using SQL Developer
• Participate in system and integration testing with various teams.
• Work closely with System Testers & UAT Testers for new UI changes
• Use SOAPUI to do integration testing and identify critical issues for Aggregator and Dotcom sales channels
• Work with Application and Data Team to implement new business requirements
• Work on production issues and update them using Remedy software
• Analyze and resolve defects and update them using Quality Center.
• Use Modeling Rule Debug Trace to analyze rules and properties to fix modeling issues
• Work with data team to get SKUs and build them in models using Visual Modeler.
• Work with Apps team for custom control and custom functions.

Environment: IBM Sterling (Comergent) 7.2, IBM Sterling 9.2, Tomcat, Quality Center, SOAP UI, HTML, XML, MS Project, Oracle10g, Linux and SQL Developer

Confidential, CA

IBM Sterling Data Modeler

Responsibilities:

• Review the Project Requirements Specifications with Business analysts
• Analyze business requirements and create modeling detail design document and review it with development teams
• Create and modify Models, Option Class, Option Items, Rules and Properties using Visual Modeler in IBM Sterling Application
• Create products using Product Master and create/update pricing for different sales channels
• Participate in system and integration testing with various teams in an Enterprise
• Participate in UI Walkthrough meetings with Business users and Business Analysts
• Create release note when development is done. Release note includes limitation, known issue, test case and screen shot of test result
• Analyze and resolve critical defects related to requirements and modeling
• Use Modeling Rule Debug Trace to analyze rules and properties to fix modeling issues
• Work with data team to get SKUs and resolve SKU and other data related issues
• Participate in smoke testing and issue resolution
• Perform system checkout once build is done and make sure products and pricing are displayed correctly in the application. Also do regression testing to make sure existing functionality is not broken after build.
• Work with Apps team for giving requirements for custom control and custom functions.

Environment: IBM Sterling (Comergent) 7.2, IBM Sterling 9.2, Tomcat, Quality Center, SOAP UI, HTML, XML, MS Project, Oracle10g, Linux and TOAD

Confidential

Business System Analyst

Responsibilities:

• Participate in complete software development life cycle.
• Gather requirements for application design.
• Analyze business process with use cases, process flows and gap analysis techniques.
• Prepare Business Requirement Document and Functional Requirement Document, Project Plan and System use cases.
• Scope new projects, analyze business needs, translate functional issues, identify and model data requirements, identifying business rules requirements and test requirements.

Environment: MS Project, SQL Server, MS - Visio, Quality Center and Toad

Confidential

Technical Trainer

Responsibilities:

• Provided detail information on computer hardware configuration and troubleshoot devices.
• Provided information on network basics & Database.
• Perform troubleshooting for network connection & operating system.
• Set up client server environment within the same network and provide detail information for such connections.
• Deliver data and analysis using Microsoft word, Excel, Power Point & Outlook.
• Provided information on how to do day-to-day user administration such as adding or deleting users, password aging, installation, configuration and administration of Linux and Windows Servers.
• Instruct SQL queries to create, modify, extract, delete, insert and manage Database using Oracle Server.
• Provide detail knowledge of Linux operating system: such as Linux Installation, partition, format system, build server-client set up, configure LAN network, set up user permissions and manage operating system for all various tasks.

Environment: Redhat Linux, Microsoft XP, Microsoft 2003, Oracle, SQL Developer and MS-Visio