Post Job Free
Sign in

Data Quality Assurance

Location:
Albuquerque, NM, 87111
Posted:
March 09, 2010

Contact this candidate

Resume:

Revathi Vedula

Phone: 651-***-****

Email: *************@*****.***

PROFESSIONAL SUMMARY

. 6+years of experience as a Business Systems Analyst and Programmer

Analyst in Requirements Management, Business Modeling, Process

Engineering, Systems Design, Project Management, Case management, Change

Management, Configuration Management, Software Testing, and Business

Documentation.

. Strong domain knowledge in Banking, Finance, Medical, search engine,

Retail and Airlines industries. Good understanding of basic principles of

financial markets and instruments.

. Extensive experience in project management best practices, processes and

methodologies

. Extensive experience in Change management plan and SDLC methodologies and

procedures.

. Extensive experience in preparing High Level Logical Data Models and

BRD(Business Requirements Document)Functional and Non-Functional

supporting documents containing the essential business elements, detailed

definitions

. Extensive experience in Rational Unified Process (RUP), Water Fall model

and Agile Methodologies, Unified Modeling Language (UML), Software

Development Life Cycle (SDLC), Object Oriented Analysis and Design

Concepts (OOAD), Test Lifecycle, Multi-tier Web Applications, Data

Modeling (ORDBMS) and Prototyping

. Documented Project Estimates, Business Requirements, Functional and Non-

functional Specifications, System Requirement Specification

. Analyze the UI(User interface) needs of your users developing product

model components Mock-ups, Screen shots, wire framing, prototypes Like

Launch pages (Login & Navigation components, Search pages, Profile, Page

components (Banners, Expand banners Info and action bars), Inquiry pages,

Task pages

. Extensive experience in Credit risk management.

. Traceability Matrix, Test Plan, Test Cases, User Manuals, Technical and

Business Release notes,Incident Reports,Conversion,Migration plans and

security matrix

. Extensive experience in UAT testing and coordinating with UAT team for

the approval of test reports and Test deliverables.

. Proficient in developing Use Case Model, Analysis Model, Design Model,

Implementation Model, Use Case Diagrams, Behavior Diagrams (sequence

diagrams, collaboration diagrams, and activity diagrams),Class Diagrams

based on UML Methodology using Rational Rose

. Extensive experience in Data Modeling with Conceptual data models,

Logical data models (LDMs), Physical data models (PDMs).

. Extensive experience in Ensure, Validate data feeds and monitor to track

key data variables

Investigate and resolve of data integrity issues.

. Extensive experience in Medicaid Interfaces, Electronic Billing and

Claims Process using EDI(Electronic data interchange)

. Extensive experience in requirement gathering using Joint application

development(JAD) and Rapid application development (RAD) sessions with

technical and non technical people.

. Extensive experience in Implementing and Customizing ATG Suits for E-

Commerce sites

. Excellent report creation skills using SSRS(Microsoft SQL server

Reporting Services) and Cristal Reports

. Expertise in Service-oriented architecture (SOA) for systems development

and integration of functionality of business processes and interoperable

services.

. Retrieve and analyze data, to extract, transform and load data, and to

manage the data dictionary are also considered essential components of a

data warehousing system.

. Deploy software, and apply critical updates to an organization. Using

Active Directory stores information and settings in a central database

components of a data warehousing system

. Extensive experience in building applications with Share point

Extensive experience in Web Sphere Distributed Application & Web

Servers

including marketing, sales, customer and order processing functionality

in a tailor able, integrated packages.

. Well versed in different management scenarios like Change Control,

Quality Assurance, Defect Tracking, System Integration, and Scheduling

. Extensive experience in testing applications for functionality,

industrial strength, environment, and usability with emphasis on end-to-

end system testing and user acceptance testing, test plan & test

procedural development, tool validation and setup, project customization

& administration, and defect management

. Expertise in using Mercury Interactive Automated Testing tools: Test

Director, Win Runner, Load Runner, QTP

. Proficient in Manual Black Box Testing

. Proficient in Data Driven, System, Configuration and Regression Testing

. Extensive involvement in Functionality, GUI Testing and Integrated

Testing, and Performance, Load &Stress Testing

. Excellent client relationship management, communication and presentation

skills

. Worked on multiple projects in a fast-paced environment

education

. Master's of Computer Applications, MKU, India

. Bachelor's of Science, Osmania University, India

. Business Analysis Essentials Certification, USA

. Advanced Diploma in Software Technology (ADST), India

. PGDCA, NICE (National Institute of Computer Education), India

PROFESSIONAL EXPERIENCE

. Chickasaw Nation Industries,USA - Oct 2009 -to- till

. Verinon Technology Solutions Ltd, USA - Aug 2007 -to- Sep 2009

. Excellent IT Solutions Inc, USA - Jan 2006 -to-

July 2007

. HCL Technologies Ltd, INDIA - Oct 2004 -to- Dec

2005

. TERA Software Limited, INDIA - Jan 2003 -to- Sep

2004.

Medicare & Medicaid services (CMS) MSPRC Project - Chickasaw Nation

Industries, NM, USA

Oct 2009 to till

Systems Analyst

The Centers for Medicare & Medicaid Services (CMS) has consolidated all of

the functions and workloads related to Medicare Secondary Payer (MSP) post-

payment recoveries into one MSP Recovery Contract. The contract for the new

national MSP Recovery Contractor (MSPRC) leads and manages cases associated

recovery money from both Group Health Plans (GHP) and Non Group Health

Plans (NGHP) when Medicare paid for services.

Responsibilities

. Providing technical oversight on a range of enterprise applications which

support the MSPRC. Leading business requirement development efforts and

validates effectiveness and quality of system design responses.

. Ensures documentation of the entire systems life cycle and supports

systems testing activities. Documents and verifies enterprise data

process flows and MSPRC data dictionaries. Served as a member of the

MSPRC CCB and the technical consultant for several integrated project

teams.

. Reviews, analyzes, and evaluates business systems and user needs.

Formulates systems to parallel overall business strategies.

. Creating detailed description of user needs, program functions, and steps

required to develop or modify computer programs. Reviews, analyzes, and

evaluates business systems and user needs. Formulates systems to parallel

overall business strategies.

. Created Change Management Plan, SDLC process and procedures, Release

Management Plan, Test Plan and Templates.

. Data flow management, data quality evaluations and documentation of

multiple relational entities. Design.

. Strong Database Analysis, including database design and implementation

(Microsoft SQL Server and/or at least some Oracle, IBM DBII).

. Business process modeling combined with systems analysis for a variety of

systems

. Database logical and physical models, database conversion

. Software systems architecture (Web-based, Client/Server, multi-tier)

. Software development process knowledge and experience (best practices,

industry standards, etc.)

. Requirements development and management techniques( JAD,RAD)

. Facilitation and coordination of user and technical team meetings

. Unified Modeling Language and/or Structured modeling

Environment: Java (EJB / J2EE), SQL, PL/SQL, Legacy systems DB2,

Mainframe, Crystal Reports, Visio, Share Point, Power Builder, SQL Server

2007,MS Word. MS Excel.

Martindale-Hubbell Lexis-Nexis Book stores - Verinon Technology

Solutions Ltd

Aug

2007 to Sep 2009

Business Systems Analyst Consultant

LexisNexis provides solutions for Law Firms, Government, Corporate

citations, business and practice of law. The new E-commerce site will

provide services for Martindale-Hubbell Law Directory the fast, convenient

choice for simple searches of our extensive database. All entries are

indexed by name and more than 120 major practice areas for flexible access.

And the geographic arrangement of the volumes allows each one to function

as a stand-alone desktop reference.

. Basic Practice Profile data on virtually every attorney in the US.

. Detailed Professional Biographies of leading lawyers and firms.

. Exclusive lawyer and law firm ratings based upon peer review.

. Over 4,000 services & suppliers such as court reporters, private

investigators, title search companies and expert witnesses.

. Ever-expanding coverage of the legal profession, including more email

and Web site addresses than any other source!

Responsibilities

. Using ATG Commerce Suite implementing and customizing Shopping

Cart/Catalog,Commerce Search

Merchandising/Searchandising,Content Management,Campaign

Management, Self-Service,Business & Customer Analytics,Multivariate

Testing,Integrated Customer Service.

. Providing service to Customer and Sales Account

. Involved in defining the scope and defining business rules of the

project. Also involved ingathering business requirements, doing gap

analysis and documented them textually or within models.

. Used Rational Unified Process (RUP) for streamlining the team's

development activities.

. Gather Business Requirements, analyze data and workflow diagrams.

Defined the Scope, Financial projections and Cost/Benefit analysis.

Progressed from Problem statement to well-documented Designs.

. Analyze the UI(User interface) needs of your users developing

product model components Mock-ups, Screen shots, wire framing,

prototypes Like Launch pages (Login & Navigation components, Search

pages, Profile, Page components (Banners, Expand banners Info and

action bars), Inquiry pages, Task pages

. Identified and validated high potential business opportunities for

stakeholders and developed customized business strategies that are

aligned with corporate strategic objectives.

. Provided analysis, understanding and business perspectives on many

operational issues.

. Involved in defining the scope and defining business rules of the

project. Also involved ingathering business requirements.

. Used MS-Analysis Services to create OLAP cubes.

. Responsible for data warehouses using SQL data sets created from an

Oracle database

. Responsible to analyze the requirements and prepare the Specifications

of the

Testing and implementing the Crystal reports.

. Responsible for the complete development of the Crystal reports.

. Provide Web Sphere Distributed Application personalized access to a

variety of applications and aggregate disparate content sources and

services. Portals allow people to customize their user experience,

with personalized applications based on role, context, actions,

location, preferences and team collaboration needs

. Data Modeling in Identify entity types,Identify attributes, Apply

naming conventions,Identify relationships,Apply data model patterns,Assign keys.

. Tracking errors and troubleshoot the issues and Support the

application.

. Prepared test plans, test cases, test reports.

. Performing manual & automated testing, tracking the defects to closure

and certifying the releases after testing.

. Assists current or potential application users in identifying and

describing problems or opportunities

. Coordinating with UAT team for the approval of test reports and Test

deliverables.

Environment: ATG,Java (EJB / J2EE), JDK,C, C++, Unix, SQL, PL/SQL,

Solaris 9, Legacy systems DB2,WinRunner, Windows NES Server, Crystal

Reports, Visio, VSS, Agile.

AWD(Automated Work Distributor) - All State Insurance, IL

Business Systems Analyst Consultant

Retirement accounts [IRA, 401(k), pension plans] Non-retirement investments

(stocks, bonds, mutual funds) Liquid assets (checking, savings, CDs, money

market accounts) and Cash management. Personal property (actual value of

all your possessions if you sold them: cars, boats, jewelry, furniture,

etc.)Home and other real estate equity and mortgage loans. Accepts work

from multiple-channels like Annuity and life, AWD delivers information,

Retrieves work to process, paper or electronic claims are received, enter

them into the system (electronic, imaging, manual), store the claims, print

and mail necessary documents and handle all front end processes. Following

front end claims entry and handling, to manage the adjudication and

resolution of all claims documents including error correction and issue

resolution, workflow scheduling, quality assurance and reporting on

processed work, Scanned documents, Faxes, Voice/phone calls, XML/EDI,

Electronic data feed, Text, Email, Internet requests, Work is captured,

Workflow delivers information, Transaction is Processed, Information is

output, integrate and hide the complexity of business systems, provide

world-class customer service to maximize efficiency

Responsibilities

. Assists current or potential application users in identifying and

describing problems or opportunities

. Involved in defining the scope and defining business rules of the

project. Also involved ingathering business requirements, doing gap

analysis and documented them textually or within models.

. Used Rational Unified Process (RUP) for streamlining the team's

development activities.

. Gather Business Requirements, analyze data and workflow diagrams.

Defined the Scope, Financial projections and Cost/Benefit analysis.

Progressed from Problem statement to well-documented Designs.

. By implementing a new (automated or manual) system, or by changing

an existing application system.

. The insurance rate factor used to determine the amount, called the

premium, to be charged for a certain amount of insurance coverage

claims using central claiming system, peripheral claiming system

of independent claims and dependent claims,

. Investigates such problems and opportunities to determine the

feasibility of a system solution

. And to identify the general kinds of system solution that appear

appropriate.

. Using "Agile" iteration process worked with team through a full

software development cycle, including planning, requirements

analysis, design, coding, testing, and acceptance testing when a

working product is demonstrated to stakeholders.

. Using Object-oriented analysis (OOA), object-modeling techniques to

analyze the functional requirements for a system. Object-oriented

design (OOD) analysis models to produce implementation

specifications various models can be created to show the static

structure, dynamic behavior, and run-time deployment of these

collaborating objects.

. Data Modeling in Identify entity types,Identify attributes, Apply

naming conventions,Identify relationships,Apply data model

patterns,Assign keys,Normalize to reduce data redundancy and

Demoralize to improve performance.

. Analyzes users' business requirements in detail and, where

appropriate, prepares functional Specifications for a proposed new

(or changed) system.2

. Assists and guides prospective users of a proposed new or changed

system in: Retrieve and analyze data, to extract, transform and

load data, and to manage the data dictionary are also considered

essential components of a data warehousing system

. Deploy software, and apply critical updates to an organization.

Using Active Directory stores information and settings in a central

database components of a data warehousing system

. Quantifying the benefits of having the system (or the penalties for

not having it), and Assessing the impact of the system on their

organization and on the operation of their Business.

. Created data warehouses using SQL data sets created from an Oracle

database

. Preparing and running SQL scripts on TOAD for Data Analysis and

tracking errors, resolve the

issues and providing support to team.

. Installing, designing, developing and building SSRS.

. Gather Business Requirements, analyze data and workflow diagrams.

Defined the Scope, Designing Use cases Documents, Functional

documents

. Strong troubleshooting in VB.Net frame work environment.

. Using BizTalk integrates with Microsoft products like Office, and

Share Point to allow interaction with a user participating in a

workflow process.

. Developing Test Scripts and Test Cases for Manual as well as

Automated Testing.

. Test environment setup and smoke testing

. Performing System testing, Regression testing and test report

creation

. Coordinating with UAT team for the approval of test reports and

Test deliverables.

. Performing the reviews for all the test deliverables.

Environment: C#, VB.Net Services, BizTalk, AWE processor, Oracle 10, VB6.0

Legacy systems, TOAD, ETL on windows, UML, Agile, Test Case Management,

Crystal Reports, BETA Systems SQL, SQL Server 2005,Mainframes legacy

system, Share Point, Visio, Excel.

Global Integrated Banking Services system, WI

Business Systems Analyst Consultant

Project deals with Global Integrated banking services Metavante adheres to

the user-interface design principles by practicing the user-centered design

(UCD) process throughout the software development life cycle. This process

has been applied to the Metavante Insight suite, which includes: Customer

and Sales Account compliance Servicing, Security Administration,

Organization and Product Administration, Retirement accounts [IRA, 401(k),

pension plans] Liquid assets (checking, savings, CDs, money market

accounts)and Credit risk analysis.

Responsibilities

. Worked closely with Business teams/project stake holders/SME to map the

expectations to the delivery capabilities.

. Worked closely with the UI team to model the screens, which met user

defined requirements and company standards .Created prototypes for all UI

screens

. Analyze the UI(User interface) needs of your users developing product

model components Mock-ups, Screen shots, wire framing, prototypes Like

Launch pages (Login & Navigation components, Search pages, Profile, Page

components (Banners, Expand banners Info and action bars), Inquiry pages,

Task pages

. Identified and validated high potential business opportunities for

stakeholders and developed customized business strategies that are

aligned with corporate strategic objectives.

. Manages a team of Credit Risk Managers and Credit Risk Analysts

responsible for credit risk management and analysis.

. Applies highly complex mathematical modeling and forecasting techniques

to solve business problems for optimal solutions.

. Provides subject matter expertise on all matters of credit risk

management and analysis.

. Works directly with executive management, Marketing and team members to

develop, implement and validate products, programs and portfolio

management strategies to minimize credit risk in loan products while

optimizing financial returns.

. Works with all lines of business including Finance and Marketing to

develop new products and product offers to manage and appropriately price

the credit risk of the Bank and support financial objectives.

. Develops, delivers and implements credit policy to support

corporate risk and revenue growth objectives.

. Manages third party vendor relationships, ensuring consistent, efficient

delivery of high value, high performance products and services.

. Provided analysis, understanding and business perspectives on many

operational issues.

. Involved in defining the scope and defining business rules of the

project. Also involved ingathering business requirements, doing gap

analysis between Existing Metavante insight and Global Integrated banking

services and documented them textually or within models.

. Web Portal Service-oriented architecture (SOA) for systems development

and integration of functionality of business processes and interoperable

services

. Gather Business Requirements, analyze data and workflow diagrams. Defined

the Scope, Designing Use cases Documents, Functional documents based on

HALD's.

. Retrieve and analyze data, to extract, transform and load data, and to

manage the data dictionary are also considered essential components of a

data warehousing system

. Deploy software, and apply critical updates to an organization. Using

Active Directory stores information and settings in a central database

components of a data warehousing system

. Developed prototype of new information processing application.

Facilitated collection of functional requirements from system users and

preparation of business requirement documents using Rational Requisite

Pro.

. Involved in UI, requirement and data modeling sessions and

developed DFD Diagrams and ERD's.

. Worked as an Interface between the users and different teams involved in

the application development for the better understanding of the business

and IT process.

. Coordinating with UAT team for the approval of test reports and

Test deliverables.

Environment: Java(EJB / J2EE), DB2,JDK,Unix, Mainframes legacy system, UML,

DB2, Visio/XHTML, Agile, Test Case Management, SQL, SQL Server 2000/2005,BI

Reports.

Medicaid Management Implementation System, "State Project of Kentucky"

Frankfort, KY

Business Systems Analyst Consultant

Healthcare data Reporting module using MMIS (Medicaid Management

Implementation System)

This project deals with a joint federal-state program. Establish national

HIPPA (Health Insurance Portability and Accountability Act) standards using

Department of Health and Human Services (HHS)for electronic health care

transactions and national identifiers for providers, health plans, There

are number of different Medicaid eligibility categories; within each

category there are requirements based on "Income" requirements include, but

are not limited to, age, pregnancy, disability, blindness, income and

resources. Utilizing our systems or client's legacy systems ensure that

members are properly enrolled so eligibility can be verified. We also

ensure that employer groups are billed regularly for employee coverage.

When paper or electronic claims are received, we enter them into the system

(electronic, imaging, manual), store the claims, print and mail necessary

documents and handle all front end processes. Following front end claims

entry and handling, to manage the adjudication and resolution of all claims

documents including error correction and issue resolution, workflow

scheduling, quality assurance and reporting..

Responsibilities

. Worked closely with Business teams/project stake holders/SME to map the

expectations to the delivery capabilities.

. Responsible for analysis, documenting system specifications and testing

of the system.

. Responsible to interact and with Business partners and other technical

teams to facilitate joint application development sessions and document

the business requirements.

. Interaction with the Business Users/Technology teams to facilitate

Business and Quality assurance reviews.

. Business Requirements are analyzed according to System specifications and

to evolve a measurable Plan for the complete group.

. Service-oriented architecture (SOA) for systems development and

integration of functionality of business processes and interoperable

services

. Monitoring, Tracking and Closure of the defects reported from the

internal testing team.

Gather Business Requirements, conducting JAD, RAD sessions analyze

data and work flow diagrams. Defined

the Scope, Designing Use cases Documents, Functional documents

. Client Interaction for the issues in the development stage.

. send and receive healthcare data, including patient and organization

information reports exchanged on a daily basis using H7 tool

. Coding, Scripting and building utilities for the above systems

. Developed Crystal Reports in a .NET environment using Visual

Studio.net and Crystal XI.

. Using MS-Analysis Services to create OLAP cubes.

. Created data warehouses using SQL data sets created from an Oracle

database

. Preparing and running SQL, PL/SQL scripts on SQL Plus for Data Analysis

and tracking errors and troubleshoot the issues

. Prepared User Manual and Testing Manuals for the aforementioned product

suite.

. Code fixing, support and maintenance

. Coordinating with UAT team for the approval of test reports and Test

deliverables.

Environment: Java, C, C++, Embedded SQL, Pro*C, Unix (Solaris 8.0), Solaris

Workshop, SQL, PL/SQL, DBX Debugger, Mainframes legacy system,TeraTerm Pro

v2.3,Oracle 10g,XML,SQL Server 2000, Crystal Reports, RUP, Visio, Agile.

Merrill Corporation, MN - Excellent IT Solutions Inc

May 2006 - July 2007

Business systems Analyst (Consultant)

Project deals with banking and mutual funds. Project involved collecting

data from multiple departments, customer surveys, to a central repository

and provide an interface for sales and marketing teams to analyze the

customer needs, focus areas, geographic potential to sell multiple products

to individuals & families' retirement accounts [IRA, 401(k), pension plans]

and Liquid assets and Deposit Origination

Responsibilities

. Worked closely with the UI team to model the screens, which met user

defined requirements and company standards .Created prototypes for all UI

screens

. Using a prototyping tool Visio/XHTML to develop the product model

components Mock-ups, Screen shots, wire framing, prototypes screens and

reports needed by your users

. Identified and validated high potential business opportunities for

stakeholders and developed customized business strategies that are

aligned with corporate strategic objectives.

. Provided analysis, understanding and business perspectives on many

operational issues.

. Involved in defining the scope and defining business rules of the

project. Also involved ingathering business requirements, doing gap

analysis and documented them textually or within models.

. Used Rational Unified Process (RUP) for streamlining the team's

development activities.

. Gather Business Requirements, analyze data and workflow diagrams. Defined

the Scope, Financial projections and Cost/Benefit analysis. Progressed

from Problem statement to well-documented Designs.

. building applications with Share point

. Provides subject matter expertise on all matters of credit risk

management and analysis.

. Works directly with executive management, Marketing and team members to

develop, implement and validate products, programs and portfolio

management strategies to minimize credit risk in loan products while

optimizing financial returns.

. Works with all lines of business including Finance and Marketing to

develop new products and product offers to manage and appropriately price

the credit risk of the Bank and support financial objectives.

. BRD(Business Requirements Document)supporting documents containing the

essential business derived rules.

. Develops, delivers and implements credit policy to support corporate risk

and revenue growth objectives.

. Manages third party vendor relationships, ensuring consistent, efficient

delivery of high value, high performance products and services.

. Utilized Rational ReqPro as a user to analyze the business requirements

and created test plans, test cases and test strategy using Rational Test

Manager.

. Actively involved in validating the requirements and applying the RUP

framework throughout the SDLC.

. Defined and performed the Test Strategies and associated scripts for the

verification and validation of all defined business requirements and

associated functionality.

. Reviewed and analyzed the Use Cases and came up with System Design and

Test Plan Templates.

. Created business process workflow diagrams (Activity Diagrams) in

Enterprise Architect.

. Developed prototype of new information processing application.

Facilitated collection of functional requirements from system users and

preparation of business requirement documents using Rational Requisite

Pro.

. Involved in UI, requirement and data modeling sessions and developed DFD

Diagrams and ERD's.

. Worked as an Interface between the users and different teams involved in

the application development for the better understanding of the business

and IT process.

. Investigated faults within the application and interacted with the

development team to resolve technical issues.

. Involved in Incident Reporting and Change Control procedures using Clear

Quest and reports to track process of repairs and determine the current

quality of the application.

. Retrieve and analyze data, to extract, transform and load data, and to

manage the data dictionary are also considered essential components of a

data warehousing system

. Develop the test plans as per the Business requirements. Get the approval

of Test plan and test cases from BSAs and the Designers.

. Performing manual & automated tests, defect logging, tracking the defects

to closure

. Preparing and running SQL scripts on TOAD for Data Analysis and tracking

errors

. Installing, designing, developing and building SSRS.

. Coordinating with UAT team for the approval of test reports and Test

deliverables.

. Coordinated the testing process of various builds and integration using

different test cases and Rational Test Suite.

. Performing the reviews for all the test deliverables.

. Coordinating with UAT team for the approval of test reports and

Test deliverables.

Environment: C#,VB.Net Services, BizTalk, AWE processor, Legacy systems

VB6.0,Legacy systems Main frames, Oracle 10, TOAD, ETL on windows, UML,

Agile, Test Case Management, SQL, PL/SQL, SQL Server 2000,2005, Crystal

Reports,Share Point, Visio,Excel.

.

Northwest Airlines, MN

Business Systems Analyst Consultant

Distributed Flight Planning System

Its replacement of World flight planning system by Jeppeson Data Plan The

engine maintains the flight operations like flight planning and tracking

system that allows the dispatch interfaces like BEA TUXEDO and Unisys OLTP

(DUI) on HP/UX. The services of flight plan are passing messages for

Airline, flight number, Flight Origin, flight destination and flight plan

messages whether warnings graphics, flight maintenance etc.

Responsibilities

. Assisted senior business analyst in defining the scope and defining

business rules of the project. Also assisted ingathering business

requirements, doing gap analysis and documented them textually or within

models

. Worked closely with the UI team to model the screens, which met user

defined requirements and company standards .Created prototypes for all UI

screens

. Participated in System Integration Testing (SIT)

. Investigated faults within the application and interacted with the

development team to resolve technical issues.

. Involved in preparing product documentation including user manuals

. Develop the test plans as per the Business requirements. Get the approval

of Test plan and test cases from BSAs and the Designers.

. Developing Test Scripts and Test Cases for Manual as well as Automated

Testing.

. Data migration & Validation from older to new version.

. BRD(Business Requirements Document)supporting documents containing the

essential business derived rules.

. Test environment setup and smoke testing

. Performing System testing, Regression testing and test report creation

. Performing manual & automated tests, defect logging, tracking the defects

to closure

. Coordinating with UAT team for the approval of test reports and Test

deliverables.

. Performing the reviews for all the test deliverables.

Environment: C#, VB.Net Services, Legacy Systems VB6.0,Rational Rose,

Rational Requisite Pro, Rational Clear Case, UML, RUP,Unix,C++, Oracle 8i,

SQL, PL/SQL, Solaris, Web Logic 6.1, Load Runner, Test Director, Visio,

Excel.

.

Revenue Management of DYMOnD's (Dynamic Yield Management by Origin and

Destination)

Project Deals with Northwest Airlines Revenue Management of Schedule

planning & Scheduling, Pricing and Yield Management to manage the DYMOnD

Leg Forecasting, DYMOnD O&D Forecast, Pricing to create Demands, Leg

Displacement Costs (LDC), Network Fare Value Network Values Ranges, ENVI

Evolution Management, Married Segment Logic, Journey Control Logic and

Inventory Controls Background, Nested inventory, Pooled with Nesting

Inventory and Network Revenue Management.

Responsibilities

. Developed an Analysis Model that includes entity classes, use case

diagram, sequence diagrams, object collaboration diagram that provide the

development team a view of the requirements for construction phase

activity

. Initiated Use Case Analysis using UML, which provided the framework for

potential use case deliverables and their inter-relationships, and allow

for maximizing software reuse

. Participated in various meetings and discussed enhancements and

modification request issues. Interacted with analyst, system staff and

developers

. Created Mock-up forms in MS word for better visualization and

understanding of the software solution

. Prepared High Level Logical Data Models and BRD(Business Requirements

Document) supporting documents containing the essential business

elements, detailed definitions, and descriptions of the relationships

between the actors to analyze and document business data requirements

. Modeling of business processes in visual studio, graphically mapping

between different message formats using BizTalk server

. Retrieve and analyze data, to extract, transform and load data, and to

manage the data dictionary are also considered essential components of a

data warehousing system

. Implemented business modeling, data modeling using MS Visio to develop

the business architecture for the application and created use cases, use

case diagrams, activity diagrams, state transition diagrams, sequence

diagrams, data flow diagrams and collaboration diagrams using Rational

Rose in order to understand system flow and data flow, perform data

mapping, analyzed ER diagrams and performed critical path analysis.

. Helped other support members to gain deeper understanding of user issues

by facilitating proper training of future support personnel

. Conducted Back End Testing on the Oracle database using SQL, PL/SQL

. Executed test plans, identify and documented discrepancies found against

expected output.

. Onshore Offshore communication and documentation management

. Performed GUI, Functionality Testing and Regression testing

. Coordinating with UAT team for the approval of test reports and Test

deliverables.

Environment:

VB.Net, C#, ADO.Net, IIS, XML, XSLT,SQL, PL/SQL SQL Server 2000, Legacy

systems VB 6.0,Visual SourceSafe (VSS), Crystal Reports 9.0, JavaScript and

Win XP Professional,.

Lexis Nexis, OH - HCL Technologies, INDIA

Oct 2004 - Feb 2006

Software Engineer

Lexis-Nexis Shepard's Core Concept for DWA (Dayton web applications)

Keep track of precedent is a vital part of legal research. Shepard's

Citation Services is one of the vital tool on which legal researchers rely

to validate their Citations and to locate additional authorities their

arguments. Shepard's on Lexis-Nexis Academic allow the user to access one

important component of Shepard's Comprehensive coverage United States

Supreme Count Decisions Valid or Cite-check,Locate a comprehensive

listing of additional cases and other authorities that have cited the case

including annotations and law-review articles,Organize and Prioritize

search using Shepard's time-tested editorial analysis and a new generation

of navigation tools, Verify the Citation for case including case name,

jurisdiction, date of decision and all parallel Citations.

Responsibilities

. Worked closely with Business teams/project stake holders/SME to map the

expectations to the delivery capabilities.

. Responsible for analysis, documenting system specifications and testing

of the system.

. Responsible to interact and with Business partners and other technical

teams to facilitate joint application development sessions and document

the business requirements.

. BRD(Business Requirements Document)supporting documents containing the

essential business elements, detailed definitions, and descriptions of

the relationships between the actors to analyze and document business

data requirements.

. Developed Crystal Reports in a .NET environment using Visual

Studio.net and Crystal XI.

. Using MS-Analysis Services to create OLAP cubes.

. Created data warehouses using SQL data sets created from an Oracle

database

. Interaction with the Business Users/Technology teams to facilitate

Business and Quality assurance reviews.

. Business Requirements are analyzed according to System specifications and

to evolve a measurable Plan for the complete group.

. Responsible for identifying and documenting business rules and creating

detailed Use Case's.

. Created Use cases, Use Case diagrams, Business Flow diagram, Navigational

Flow diagrams, Creating process models, data flow diagrams, AS IS

diagrams and Activity diagrams using Visio.

. Conduct workflow, process diagram and GAP analysis to derive requirements

for existing systems enhancements.

. Responsible for providing all business event, rule, and process

information for workflow, external interfaces, and data definition

requirements.

Environment: Java (EJB / J2EE), C, C++, SQL, PL/SQL, Solaris 9, WinRunner,

Windows NES Server, VSS, Crystal Reports.

Lexis-Nexis Web search engine Services

CTS (Client Test System)

CTS provide the full regression validation testing of the infrastructure by

executing the pre-determined suites of S/L/R transactions and validating

the output of every transaction with the established standards. The

Objective of this project is to add a new refresh button to the header

frame that clears the cache and saves the current execution path of the

user. According to the current functionality whenever we do the refresh all

the previously opened nodes are collapsed and user loses all the

information, to overcome this Cookies are Introduced to save the current

execution path Using Java Script and CGI Scripts. This change is contained

entirely within the CTS there is no QLRB, LFD or LSR dependency.

Responsibilities

. Assisted senior business analyst in defining the scope and defining

business rules of the project. Also assisted ingathering business

requirements, doing gap analysis and documented them textually or within

models

. Worked closely with the UI team to model the screens, which met user

defined requirements and company standards .Created prototypes for all UI

screens

. Participated in System Integration Testing (SIT)

. BRD(Business Requirements Document)supporting documents containing the

essential business elements, detailed definitions, and descriptions of

the relationships between the actors to analyze and document business

data requirements.

. Analyzing Business requirements and thorough understanding of design

. Enhancement of user transactions updating against the test module

. Preparing Technical Specifications and Unit testing

. Process any change requests from the users

. Perform any enhancements to the system to fulfill the change requests

. Prepare documentation for the system

. Coordinating with UAT team for the approval of test reports and Test

deliverables.

Environment: Java (EJB / J2EE), JavaScript, CCI, Perl, VSS, WinRunner,

TestDirector

Defence Electronics Research Laboratories, India

Jan 2003 - Sep 2004

Programmer Analyst Consultant

Communication Processor for Defense Electronics Research Laboratories

Communication processor is an intelligent communication established between

remote areas, remote networks to Transfer data using Sockets and secure

principals like cryptography. This was supported by the predefined

algorithms like IDEA (inter national Data Encryption Algorithm), DSA

(Digital Signature Algorithm) etc. to avoid the damage in check sums, data

frame errors. It also included hardware tools like Communication Control

Protocol Card (CCPC). It provides complete implementation and processing

using TCP/IP, UDP/IP, and FTP networking protocols.

Responsibilities

. As a Software Engineer, I was responsible for:

. Using C, C++, on HP UX11i and TCP/IP protocols

. Coding of user transactions updating module

. Coding for Socket and Plug-in

. Creating Shell scripts for batch processing.

. Built Search, Lookup, and Retrieval XML services to display data.

. Performance Analysis and Bug Fixes using dbx tool

. Preparing Test Cases

. Unit Testing

Environment: C, C++, Pro*C,HP UNIX 11i,Oracle 10g, SQL, PL/SQL.

Sales Order Processing

This project is aimed to monitor records of all the sales transactions in

different registers. Item details are recorded in Item Master Register.

Item details include item no., item description, rate per unit, Quantity On

Hand (QOH), Re-Order Level (ROL), Re-Order Quantity (ROQ) and FSN status.

The FSN status describes the sale of items in terms of "Fast Moving", "Slow

Moving", and "Non-moving" items. Details of all customers are recorded in

Customer Master Register. The details include Customer Code, name,

address, city, pin code, phone, and outstanding amount. Whenever a customer

buys any item(s), the details are entered in Sales Register. The sales

Details include item code, Customer code, Date of sale, Unit sold. We have

used database for noting down these details.

Responsibilities

. Analyzing Business requirements and through understanding of design

. Enhancement of user transactions updating against the test module

. Data migration & Validation from older to new variation

. Preparing Technical Specifications and Unit testing

. Prepared test plans, test cases, test reports and developed Win Runner

test-scripts.

. Performing manual & automated testing, tracking the defects to closure

and certifying the releases after testing.

. Constructed keyword/data driven automated test scripts thru EMOS

Automation Framework. This helps in separating the test-scripts from the

test-data.

. Responsible for Smoke testing, Functional testing, Regression testing,

Integration testing and System testing.

. Involved in testing the application manually in the initial stages and

then developed the automated test-scripts in the later stages.

. Built Search, Lookup, and Retrieval OCI (Oracle call Interface) services

to display data.

Environment: C++,Unix, Oracle11i, SQL, PL/SQL.

SMG Defense Financial Services

Project deals with procurements of LP, FE, CP, SMB, Budget modules.

Maintaining the Procurement Data and providing facility to access and

update the data for different activities. This project handles the current

from initial stage and also facilitates for continuous updating of the data

related to each procurement case till all the stores are received and

complete payment is made. It also facilitates to filter the data based on

one or many combination criteria. It helps in producing periodic reports,

analysis, financial planning of the procurement. Using Crystal reports tool

we generated LP, FE, CP, SMB, Budget modules for periodic reports of

Procurement data and financial data reports for different activities of

SAB, SEB and SMB

Responsibilities

. As a Software Engineer, I was responsible for:

. Using VB6.0 and Oracle8i.

. Requirement Gathering

. Oracle's Procure Accounting processes for LP, FE, CP, SMB, Budget modules

. Coding of user transactions updating module

. Built Search, Lookup, and Retrieval services to display data.

. Performance Analysis and Bug Fixes

. Preparing Test Cases

. Unit Testing

Environment: VB 6.0, Oracle 8i, SQL, PL/SQL.



Contact this candidate