Project Quality Assurance
Resume:
SULAGNA PATRA
Phone: 201-***-****
Englewood CO 80112 Email: ************@*****.***
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