SULAGNA PATRA

**** * ********* **, *** ****

Phone: 201-***-****

Englewood CO 80112 Email: ab8r72@r.postjobfree.com

SUMMARY

More than 5 years of IT experience that includes Quality Assurance and

Programming.

Experienced in developing and maintain overall test methodology and

strategy, Documenting Test plans, Test cases and editing, executing Tests

cases and Test scripts.

Implemented various testing methodologies like waterfall model, V-model,

spiral model, Butterfly model

Experienced in Oracle 9i, SQL Server, PL/SQL procedures, triggers and

packages coding.

Good Experience with Defect or Bug Reporting Tools (Quality Center,

Rational Clear Quest Element Tool).

Knowledge and good understanding of Programming Languages like C,C++,JAVA.

Good communication skills, organized, highly motivated good analytical & a

team player

Proficient in interacting with developers, team members and clients to

ensure the delivery of a quality software

Legal Status: L2 EAD

Professional Certification: Oracle Certified Associate: Oracle PL/SQL

Developer (OCA).

PROFESSIONAL EXPERIENCE

Organization: Thomson Reuters, Denver, CO

Title: Quality Assurance Analyst

Project: LIPPER for Investment Management

Duration: April, 2011 - July, 2012

Description: Designed to work seamlessly with workflow, Lipper for

Investment Management offers the flexibility to manage data and information

in a way that suits needs.

Lipper for Investment Management features the content, analytics and

reporting capabilities needed by marketing, product management, sales and

performance teams to conduct meaningful comparative analysis to define new

product opportunities and positioning strategies.

Quickly access Lipper's global database which covers over 205,000 share

classes and includes mutual funds, closed-end funds, ETFs, hedge funds,

domestic pension and insurance products. Compare and benchmark performance

with Lipper Global and local market classifications, Lipper Leaders fund

ratings and over 55 performance and risk statistics. Our comprehensive fund

information is combined with analytic tools to enhance reporting and

analysis technologies that simplify deployment and allow you to access

Lipper information anytime, anywhere.

Environment: PL/SQL Developer, Oracle 11g, HP Quality Center, Rational

Clear Quest, Bugzilla, Microsoft Access.

Responsibility:

Mostly worked on back end testing for oracle database.

Worked on incremental load and full load syncs i.e. LSRA and QDBM syncs.

Perform and experience in Regression, Functional, System, Integration,

Black Box, White Box, and UAT

Strong working knowledge in HP Quality Center, Clear Quest and Bugzilla.

Have experience in testing applications in following environments: Java

Script, XML, Java, JEE, SQL, PL/SQL, and HTML/DHTML.

Performed Database Verification and Validation testing using SQL quires.

Experience in writing test cases in Quality Center.

In-depth understanding of project lifecycle in both waterfall and agile

methodologies.

Organization: Dish Network, Englewood, CO

Title: Analyst

Project: Sales Communication

Duration: October, 2010 - February, 2011

Description: Sales communication team is responsible for calculating

commissions weekly and monthly for all distributors and partners of DISH

Network.

Environment: Toad 8.5.3, SQL Developer, Autosys, PVCS, Oracle 9i/10g, MS

Visio, Putty, UNIX, Oracle Form 6i, Team tracker

Responsibilities:

Supported Software Installation of TOAD 8.5.3, Oracle PL/SQL Developer,

Putty/Unix, and other third party tools.

Involved in gathering requirements, reviewing and documentation.

Participated in project kick-off meeting and weekly status meeting.

Participated in preparing the technical requirement documentation.

Involved in coding and the development of Inventory modules of the items of

Project.

Created stored procedures, functions, triggers and packages based on

requirements.

Good experience in creating database objects like tables, views, synonyms,

constraints, indexes, sequences based on requirements.

Provide support in production data.

Good use of named, positional and mixed notations in the subprograms of

pl/sql.

Performed in deliverable duties based upon the milestone and also generated

reports.

Trained the end-users step by step in using the whole system correctly.

Good use of bulk collect and for all statements to improve performance and

execution of the procedures.

Good experience in creating database links and moving data between

different databases and schemas with proper privileges.

Generated reports for the end user based on the requirement.

Organization: Xecutesmart, Scottsdale, AZ

Title: Programmer Analyst

Project: Commercial Web Portal

Duration: June, 2009 - July, 2010

Description: The Company develops commercial web portals to serve varied

client base nationwide, including various classified modules of Financial,

Payment gateway services, Marketing, Sales, Mortgage/Real Estate,

Automobiles and Transportation.

Environment: Toad 8.5.3, Oracle 9i/10g,ETL Tools, MS Visio, UML,

SQL*loader, Putty, MS-access, HP-UX, UNIX shell scripting.

Responsibilities:

Supported Software Installation of TOAD 8.5.3, Oracle PLSQL Developer,

Putty/Unix, and other third party tools.

Involved in gathering requirements, reviewing and documentation.

Participated in Data ware house module and power center tool of

Informatica.

Participated in preparing the technical specification documentation.

Involved in coding and the development of Inventory modules of the items of

Project.

Created stored procedures, functions, triggers and packages based on

requirements.

Good experience in creating database objects like tables, views, synonyms,

constraints, indexes, materialized views, sequences based on requirements.

Good use of bulk collect and for all statements to improve performance and

execution of the procedures.

Expertise in tools like toad, oracle sql developer, Erwin, SQL*loader and

import/export utility.

Worked with Technical writers in preparing the system documentation and

user manuals.

Good experience in creating database links and moving data between

different databases and schemas with proper privileges.

Experience in working with Import / Export utility and Import / Export dump

utility.

Involvement in testing the application in Java.

Project: Asset Explorer

Duration: October, 2009 - December, 2009

Description: Asset Explorer is an IT Asset management tool designed to keep

inventory of all the hardware and software assets in an organization. Its

primary function is to keep accountability for the life-cycle management of

information technology assets throughout the organization.

Environment: Windows XP, Oracle 10g, PL/SQL, UML,HP Quality Center, UNIX

shell scripting, Visual Basic.

Responsibilities

Participated in Database Design for the system

Written PL/SQL code using stored procedures, cursor, arrays, exceptions and

constructs

Responsible for the overall technical aspects of the Oracle based

development

Involved in day to day activities for Oracle developers

Created test project plan and test methodology

Test case creation, execution and reporting defects in HP-Quality Center

Prepared test summary report, requirement test metrics report, defects

report and status report

Performed Automation Testing using Quick Test Pro 10

Performed Integration & System testing

Organization: Cognizant Technology Solutions, India

Title: Programmer Analyst

Project: Web Content Development

Duration: December, 2006 - May, 2009

Description: The Web Content Development project demands developing the web

content in accordance with the Business Requirement Document received from

the client. The scope of the project includes BRD analysis, web content

development along with stored procedure and unit testing of the developed

code. Also, there are enhancement activities in the form of updating of

existing web contents as and when new BRD is released. One important scope

of this project is to analyze the Problem Logs issued due to developmental

defect in web development and to provide solutions to those.

Environment: Oracle 9i, PL/SQL, SQL Developer, Sybase, UML, UNIX,JavaScript, HTML, Version Controller- Harvest, FTP tool, e-Tracker.

Responsibilities

Working as the team member and programmer for the web content development

project.

Involve in analysis of the Business Requirement Document (BRD) and

designing web content accordingly.

Understanding the business logic from the BRD received from client and code

the Stored Procedure accordingly.

Mainly responsible for database development tasks and duties by using SQL

database programming knowledge

Developed Packages and customized functions and Triggers based upon the

business logics.

Created stored procedures, functions, triggers based on requirements.

Responsible for the development, implementation and support of the database

of the server.

Extensively worked in Oracle SQL, PL/SQL, SQL*Plus, SQL*Loader, Created

database objects like Tables, Views Indexes, Synonyms and Sequences.

Used Bulk Collect feature to improve performance.

Experience in handling errors and use of pragma exception_init and

raise_application_error.

Fixing bugs once the system went to production.

Working on UNIX environment and working with FTP to transfer files to

remote servers.

Maintaining web Content and Stored Procedure versions in DEVELOPMENT, TEST

and Production servers and also ensuring the synchronization of the content

in all three environments.

Solving Problem Logs issued due to defect identified during UAT phase.

Supporting co-ordination between Onsite and Offshore.

Involved in various internal Knowledge Training sessions and monitoring

various quality processes for the deliverables.

EDUCATION

Bachelor of Engineering (Computer Science and Engineering) - Silicon

Institute of Technology, India (2006).

Contact this candidate