Quality Assurance Project

Ishana Batta

**** ******** ****** **** #**** San Diego CA 92123

Phone: 281-***-****(M) Email:***********@*****.***

Visa Status: Permanent Resident/Green Card Holder

Profile

. Analytical, enthusiastic and innovative Business Analyst with over 5

years of IT experience in business analysis, development of business

processes and solutions for the Retail, Healthcare and Banking Industry.

. Comprehensive knowledge of Software Development Life Cycle (SDLC) having

thorough understanding of various phases like requirements,

Analysis/Design, Development and testing.

. Extensive experience in designing functional specification documents

using UML, MS Word, MS Visio and several other technologies.

. Understanding large conceptual problems or projects, breaking it into

components, establishing plans and critical paths to achieve incremental

goals and deliver projects on time and within budget.

. Adept at achieving results by effectively communicating using analytical,

interpersonal, and presentation skills to provide key personnel with the

right information at the right time.

. Comprehensive knowledge of project development and management

methodologies to include Agile Programming Model, Waterfall model and Use

Cases.

. Expertise in writing stored procedures, packages, triggers for oracle

10g, 9.x, 8.x.

. Excellent skills in debugging, fixing the issues by applying delivered

patches and upgrades and developing additional features for the missing

delivered solutions.

. Strong with adhering to deadlines and working on multiple projects

simultaneously.

Certifications

. Oracle 9i Database Administrator Certified Associate

. Microsoft Certified professional in Web designing

. Certificate in Programming in C++ from GTE Computer Education

. Certificate in Programming in C from International Computer Academy.

Education

. Master's in Management Information Systems, University of South

Florida Aug 2007 - Dec 2008

. B.Tech in Computer Science and Engineering, India

May 1999 - May 2003

Professional Experience

CIBER Global Solutions Tampa, FL Feb 2009-

Apr2010

Consultant

Client: State Street of Boston, MA

. Reviewed and updated Business Flow Processes to insure applications

were meeting the objectives of the business.

. Participated regularly with the walkthroughs and review meetings with

the Project Managers, QA and development team both on-site and

offshore.

. Conducted conference calls and meetings with the CIBER team on-site to

gather information.

. Did the data modeling for the various conversion projects.

. Coordination with technical architect for development and maintenance

of the existing system.

. Designed and developed various applications for ETF (Exchange Traded

Funds), a financial trade transaction system, using PowerBuilder for

front-end development and Oracle PL/SQL as back-end.

. Designed the technical specification for the trade management system

which dealt with the global settlement of fund orders. Did development

for the same.

. Conducted a through business and process analysis during the

conversion of the global bank calendar from the ATI (Auto Trade

Instructions) system to the ETF (Exchange Traded Funds) system,

documented the same using MS Visio.

. Extensively involved in creating Technical Specifications which were

in line to the functional specifications provided by the client and

used these develop various applications.

. Was involved in other projects like the Custody Conversion and

Canadian order taking and documented and developed the updates upon

various packages/procedures related to these to handle different

funds.

. Involved in the development and analysis of the Eiger ETF system which

was designed to handle the European funds.

. Assisted the client side QA team in creating test cases and test

plans, unit testing and integration testing on all the

procedures/packages developed.

. Documented all the system changes and uploaded all the business

documents at a SharePoint location.

. Provide weekly status report to the client -side team and upper

management in Tampa office.

Environment: PL/SQL, Oracle 10g/9i, Oracle Developer, Toad, MS Office,

Visio, Excel, SharePoint,Windows XP/2000/Vista, PVCS Version Manager,

Mercury Quality Center.

University of South Florida Tampa, FL Aug 2007- Dec

2008

Data Analyst (Doing a Project for VA)

My research work deals with data mining on medical records of patients who

suffer from critical brain injuries in order to identify the patient

characteristics and differentiate between the characteristics of patients

suffering from critical brain injuries and those who are suffering from

mild brain injuries.

. Responsible for gathering information from the medical records and VA

team converting them into functional /technical specifications.

. Used data mining applications like Weka to generate data models and

define rules based on the data analysis.

. Document all the data analysis results via bar charts, data flow

diagrams to keep track of project progress.

. Conduct and participate in meetings with the VA team to gather

requirements and ensure the project is on track. Funnel the knowledge

to the development team.

. Developed stored procedures/triggers and functions using PL/SQL and

optimized performance.

. Conducted UAT, unit and integration testing and documented them via

test cases and test plans.

. Wrote SQL quires for data manipulation.

Environment: PL/SQL, Oracle 9i, Oracle Developer, SQL*Plus, Windows

XP/2000/Vista, Weka, MS Word, Visio, Excel

Moreworld Technologies Chandigarh, India July 2003- May2007

Consultant/Business Analyst

. Gathering user requirements, performing analysis, process flow and use

case development for integration of order entry system for a retail

client.

. Reviewed and updated Business Flow Processes to insure applications

were meeting the objectives of the business. Changes and revisions

were illustrated using Microsoft Visio and other Microsoft Office

applications.

. Developed specific requirements for clients, and was responsible for

providing Work Orders.

. Performed program analysis and process assessment for Operations

Management (retail client) by reviewing existing business processes

and recommending modification to existing processes and implementation

of new processes to meet the objectives of the business group.

. Recommended changes to Business Processes and Software Applications

used were presented to the users with Use cases, activity flow

diagrams and flow charts developed using Microsoft Visio.

. Involved in gathering business requirements and converting them into a

functional document using Microsoft word.

. Ensured all artifacts complied with corporate SDLC Policies and

guidelines.

. Created images of the new forms using tools like Adobe Photoshop to

adhere to the new business requirements.

. Interacted with cross - functional teams in understanding and

analyzing business processes, systems analysis and development,

integration of systems, documenting technical specifications, user

training and implementation support.

. Developed the extract programs to populate the files with the consumer

details, which the customers target for their business, using PL/SQL

and automate the process using UNIX shell scripts.

. Participated regularly with the walkthroughs and review meetings with

the Project Managers, QA and development team.

. Coordinated with the Quality Assurance/Testing team members to perform

system integration and aggregation testing.

. Create test plans, prioritizing, documenting, tracking issues and

ensure timely resolution of issues.

. Uploaded all the documentation at a SharePoint Location.

. Conducted UAT. Wrote SQL queries in Oracle for data manipulations.

Environment: Oracle 9i, Developer Version 6.0, PL/SQL, SQL*Plus, Microsoft

Word, Visio, MS Access, Excel, SharePoint, Adobe Photoshop, Mercury Quality

center,Windows2000/XP.

Contact this candidate