SUMMARY:

• Over nine years of IT experience in Software Development Life Cycle (SDLC) analysis and development as well as 5 years in Quality Assurance, Software Testing Life Cycle (STLC) testing for client/server and web - based and BI applications from various domains such as Telecom and commercial.
• Extensive working experience in analysis Business Requirements (BRD), system Requirement (SRD) and various other artefacts and complete exposure to all phases of the software development life cycle, including architecture, analysis, design, development, Testing, performance and implementation.
• Actively involved, tested and implemented web based application following Agile and waterfall methodology. Proficient in creating Test Plan, Test Cases, Test Scenarios, executing scripts and Requirement Traceability Matrix on analyzing the Business Requirement Document (BRD) and System Requirement documents (SRD).
• Extensive experience and strong ability to work closely with Development team and Business Analyst, SME to analyse the test scenarios and plan and implement testing and quality assurance initiatives to ensure solution quality before and after deployment.
• Acquired detail understanding of QA methodology to ensure quality control and Iterative life cycle of Software Development (Planning, Analysis Design, Deployment, Testing, Integration and Support).
• Extensive experience with different phases of Testing like Black Box Testing, White Box Testing, Functionality Testing, Unit Testing, Integration Testing, System Testing, Backend Testing, Regression Testing and User Acceptance testing(UAT), End to End (E2E), Sanity testing, component testing on Windows and RDBMS such as Oracle, SQL server.
• Extensive experience in using test management suite like HP ALM/QC (application lifecycle management- Mercury Quality Centre/Test Director to define and maintain requirements and tests, defects across projects)
• Extensive experience in executing automation scripts. Documenting & reporting bugs using Rational Clear Quest and QC, Dev track, Quick Test Professional (QTP), VBScript, Shell script, Load Runner, Win-Runner for testing client/server, web-based n-tier applications.
• Hands on working experience to execute automation scripts with required data and review Frameworks (Record & Playback) to run manually records each step ( Navigation and User Inputs), Inserts Checkpoints ( Validation Steps) and plays back the recorded script in the subsequent rounds to simply record the steps and add validation steps with automation team and knowledge about other defect tracking tool.
• Strong experience with client interaction, understanding business applications, business data flow and data relations, assistance for integration of front end and back end applications.
• Good communication skills with strong ability to interact with end-users, customers, and on-offshore team members. Solid analytical and dynamic troubleshooting skills, able to work individually and as a team member to resolve identified defects via communicating tools, development team and senior management.
• Developed and tested troubleshot the applications, websites and components using waterfall, agile based practices according to the application requirements.
• Extremely involved in managing defect tracking tools like Quality Center (QC), Dev track, JIRA.
• Hands on working experience with databases developing SQL queries, Stored Procedures, Functions & Triggers using Oracle 8i/9i/10/11g, MS SQL Server 2000/2005, and MS Access, MS Project, Word, Excel, Visio, PowerPoint.
• Self-motivated and enjoy working in a technically challenging environment, great team player as well as ability to work independently.
• Outstanding organizational and communication skills including ability to multi-task prioritize, face new challenges and take ownership of the task specified.
• Over 5+ years’ experience Software Development in analysis, administration, testing and implementation of various applications such as BI tools (Cognos), web based technology and client/server applications.
• Acquired experience working with Agile, Waterfall and Iterative life cycle of Software Development (Planning, Analysis Design, Deployment, Testing, Integration and Support).Excelled in business analysis and gathering requirements definition and converting them to project deliverables.
• Extensive working experience in design and develop prototype and various related reports using COGNOS 6 thru 8.4/ hands on experience with COGNOS 10.1.
• Perform various levels of user client support for installation, administration after deployment of applications such as COGNOS Connection, Report Studio, Analysis Studio, Query Studio, Metric Studio and Transformer), Report Net, Impromptu, Power Play Transformer, and Power Play Windows/Web and COGNOS EP Series 7, HTML, DHTML, ASP, Java script, Apache.
• Actively involved in design, developed and tested troubleshot the applications, websites and components using waterfall, agile based practices and backend databases Oracle 8i/9i/10/11g, MS SQL Server 2000/2005, and MS Access, MS Project, Word, Excel, Visio, PowerPoint.
• Provided and updated detail about analysis and project status details to higher management on daily, weekly basis. Involved in daily weekly client meetings to gather information about reports and user access details.
• Good communication skills with strong ability to interact with end-users, customers, and team members, client interaction, understanding business applications, business data flow and data relations, assistance for integration of front end and back end applications. Solid analytical and dynamic troubleshooting skills, able to work individually and as a team member.
• Self-motivated and enjoy working in a technically challenging environment. Willingness and Ability to learn new technologies and tools.

TECHNICAL SKILLS:

Testing Tools: Mercury Interactive tools HP ALM/QC, Test Director, Win Runner, Rational Clear Quest, Soap UI, QTP, HP Quality Center, Jing, Dev track.

Languages: ASP, Java Script, VBScript 3., HTML, DHTML, COBOL, Visual basic, XML, SQL, PL/SQL & C.

Databases and Tools: Oracle 7/8i/9i/10/11g, SQL Server 6.5/7/2000, DB2, Access, Toad, Sybase, FoxPro 2.5 and dBase III+/IV.

Operating System: UNIX, IBM, Windows NT 4.0, Windows 2000/7, Windows 95/98/XP and DOS.

OLAP/BI / ETL Tools: Report Net 1.1MR1, MR2, COGNOS 6 thru 8.4/ COGNOS 10.1 (COGNOS Connection, Framework Manager, COGNOS configuration and Analysis studio Event studio, Report Studio, Query Studio, Business Insight, Metric Studio and Transformer 8.3/8.4/Cognos10.1), COGNOS EP Series 7.1(Impromptu Administrator, Power Play Transformer 7.3/7.4, Enterprise Server, Architect, Access Manager, Visualizer, Upfront, COGNOS Query), Business Objects 5.1, Crystal reports 7/8, Informatics (Power Center/ Power Mart) Client Tools (Repository manager, Designer, Server Manager and Informatics Server).

Web server: IIS 4.0, & 5, Apache Server 1.2, Apache J server, Citrix Browser

Software / Tools/ Utilities: Visual Studio 6.0, MS-Office, Outlook, Excel, MS-Project, power point, Visio and IIS Server, Adobe, Photoshop

PROFESSIONAL EXPERIENCE:

Confidential, NY

QA analyst

Responsibilities:

• Participated in peer reviews of all the documents and Test Cases, performed gap analysis by comparing actual result with expected result, interacted with SME and developers to provide clear solutions to requirements.
• Actively involved, verified and implemented various design documents, mockups, UX diagrams through reviews and business requirements as per user requirements.
• Extensive working experience in creating and implemented, prepared Test Plan, Test Cases, Test Scenarios, executing scripts and Requirement Traceability Matrix on analyzing the Business Requirement Document (BRD) and System Requirement documents (SRD) using Test plan.
• Participated in peer reviews of all the documents and Test Cases and effectively interacted with SME business analyst and developers to provide clear solutions to requirements.
• Extensive working experience and involved in executing UAT test cases with the business users and reported defects using Quality Center and Dev track.
• Actively involved in writing use cases when required and created Requirement Traceability Matrix from target operating model, BRD, GAP, Use Cases and Test cases.
• Performed execution of test cases in UAT and Unit Test and identified, created related defects in Dev track defect tracking tool with all details attached video recording via Jing screencast for development and linked the detected defect with requirement, release, log detail documents and test cases.
• Perform end to end QA activity to gather requirements and document the proposed processes to the existing system. Modules included: Account contact, document management, Neutral management, and service definition, notes management to improve quality and test process.
• Perform various tests including Production, UAT, End to End, Integration, Functional, Stress, Regression, System testing, Data Driven as well as Performance testing.
• Actively involved in cross browser testing with IE, Safari, Firefox and Chrome using browser stack and communicated with all the work team lead for E2E testing, gap analysis by comparing actual result with expected result.
• Validated data for existing clients using Oracle SQL Validating database tables and parsing/comparing files.
• Acceptance testing on every module or screen to test the functionality and proper navigation, track bugs and reporting defects Quality Center, Dev track.
• Completed User Acceptance and End to End, performance testing using HTTP Load to test web servers by running several http or https fetches simultaneously to determine how a server handles the workload on time for projects before release.
• Closely interacted and communicated with clients, developers, and system engineers to identify application defects, minimize the defects prior to build, reviews, and follow ups to improve test quality.
• Actively participated in status meetings to report issues and provided technical support to the offshore-onshore team and users.
• Provided and updated detail UAT test plan, scripts and test cases using business requirements and shared with offshore, business teams using share point on daily basis and major releases for case management application
• Tested across operating systems including UNIX and Microsoft as well as cross browser functionalities between Internet Explorer, Safari, Fire fox, Chrome using browser stack.
• Identified, opened and resolved new defects using Dev track ticketing tool and provided root cause details to development team for the issues using database tools, generating SQL queries and various log details and test recordings screencast using Jing.
• Developed associated project documentation, test plan, test scenarios, performed gap analysis, and test tracking reporting for all phases of testing including user acceptance testing.
• Actively participated in release meetings to update on impacted reported issues, technical support to the team,submitted daily status call for team(tm)s progress report and high priority defects report for senior management daily basis.

Environment: UNIX, Windows NT, 2003/XP/S/W: MS Office 2003, MS Outlook, Excel, Visio, PowerPoint, MS Project, shell script, Novell, LAN, SQL*PLUS, Java Script, J unit and XML,HP ALM QC, Visio, MS Internet Explorer 8, 9, 10, 11 Protocol Telnet, FTP, TCP/IP, LAN, WAN, HTTP, Ethernet, Jing, Snagit, Browser stack, Dev track, Quilix (Fax, scan, email test), Oracle 11g, Oracle, MS-Access, Toad, MS- SQL: Successfully completed online for JIRA (defect tracking tool)

Confidential

Consultant

Responsibilities:

• Performed and actively participated in various tests including Production, UAT, End to End, Integration (SIT), Functional (everything), Stress, Regression, System testing, smoke (high level), Sanity (only key functionality not defect), Data Driven as well as Performance testing, Web, GUI, End to End (E2E) testing and User Acceptance Testing, cross browser testing with IE, Safari, Firefox and Chrome and communicated with all the team lead for E2E testing.
• Participated in peer reviews, analyzed and reviewed BRD, reviews functional specifications/BRD and assists in evaluating test approach of manual and automate test cases, gaps and documents to design quality test cases.
• Verified and Implemented design documents through reviews and business requirements as per user requirements.
• Developed test plans, document test results by interfacing with IT development team as well as with business process engineers using HP Quality Center/HP Application Life cycle Management test repository toolset for test management (Test Plan/test Lab), Requirements and Defect tracking modules.
• Actively involved in creating System Test Strategy, UAT Test Plan, Test Procedures, Traceability matrix based on analyzing the Business Requirement Document (BRD) and System Requirement documents (SRD) using Quality center test plan.
• Managed project libraries with updated set of entities and the relationships between requirements, tests, test resources, and business components.
• Actively involved and managed Requirements module to setup for creating, uploading, requirement traceability and traceability matrix to define, manage and track requirements at all stages of the software lifecycle to minimize rework after UAT. Functionality includes to create requirements and assign to releases/cycles, uploading requirements using MS excel (Add ins), requirement traceability to enables and to define traceability links between requirements and dependencies that exist between the requirements and traceability matrix for user to view the traceability matrix that lists source requirements and their associated requirements and tests.
• Actively involved and performed various tasks to create and maintain UAT test plan with Creating Tests, uploading tests, requirement and tests coverage, test configuration under test plan. Includes create folders of test subjects in the test plan tree and to add tests, Uploading Tests using MS excel (Add ins), Requirement and Test Coverage for the relationship between the requirements and tests, Test Configuration for a run-time environment for the test.
• Managed and involved to create tests for each modules covering with all scenarios and parameters after uploading/ exporting test case from excel using create test under test plan for both manual and automate types.
• Managed requirement and test coverage module to link requirements and tests and generate traceability matrix with percent of executed tests for a specific requirement has passed/failed.
• Performed test execution of test cases using Test Lab in Quality Center, defect tracking and linked the detected defect with requirements and test cases and submission of test summary report with project management and business teams.
• Used Quality Center for defect tracking, test cases, test plan, updating the bug status and discussed with developers to resolve the bugs.
• Actively involved in weekly defect tracking, status and technical support meetings with development, offshore team and get the defects status tracked, ensured participation of clients in the process of development.
• Documented all the test execution for the audit purpose. Performed gap analysis by comparing actual result with expected result.
• Provided assistance for integration of front end and back end applications. Verified and communicated the client/organizational needs and provide suitable agile system based solutions as per business needs and specifications.
• Provided details to development team with user stories, comply with acceptance criteria, business value and selling points to break down large and complex user story into simplified versions for execution.
• Tested various integrated web services using soap UI, performance test (using multiple user load) using load runner to test applications under real life loads to determine their behavior under expected loads and user stories for accuracy and compliance to ensure undisputed acceptance and validation of stories.
• Validated data for existing clients using Oracle SQL Validating database tables and parsing/comparing files.
• Performed acceptance testing on every module or screen to test the functionality and proper navigation, executed exceptional modularized re-usable automated scripts using Quick Test Professional.
• Involved in execution of test cases using Test Lab in Quality Center and linked the detected defect with requirements and test cases.
• Completed User Acceptance and End to End, performance testing on time for projects before release. Tested across operating systems including UNIX shell scripts (data parsing, manipulation) and Microsoft as well as cross browser functionalities between Internet Explorer.
• Track bugs and reporting defects using Rational Clear Quest and HP Quality Center, implementing the test case and test process with project time frames.
• Identified, opened and resolved new defects using HP Quality Center and provided root cause details to development team for the issues using database tools, generating SQL queries and various log details.
• Actively participated in status meetings to report issues status, provided test details and support on weekends for major release with test status for user acceptance before go no go process, technical support to the offshore team.
• Provided and attended, submitted daily status call for team(tm)s progress report with offshore and onshore team and high priority defects report for senior management.

Environment: COGNOS, 8.4, Framework Manager, Query Studio, Report Studio, Event Studio, Analysis Studio, COGNOS connection, Oracle 10G, Power Play, Transformer, IIS 5.0, Informatics 7.1, MS Project, Word, Excel, Visio, PowerPoint, Windows NT/2000, SQL Server 2000

Confidential, NJ

Senior COGNOS developer

Responsibilities:

• As a consultant work as an analyst, developer, lead in establishing standards and procedures for process improvement and process re-engineering.
• Actively involved in requirement analysis and writing technical specifications for business processes, planning and implementing COGNOS infrastructure in windows environment.
• Prepared detailed project plans, statements of work and prepared full project lifecycle plans.
• Design & develop and test a models and cubes in Transformer for analysis studio users, build package using framework manager publish a package for dashboard report development.
• Design and develop simple, complex, drill down/thru Reports using Report Studio and created ad-hoc queries using Query Studio.
• Actively involved in development, test and deployment of Dashboard, Scorecard, Metrics, catalog, impromptu reports, Prompts, query, model, cubes, and power prompts reports and impromptu reports.
• Implemented security at catalog and user class levels using governor settings in Impromptu catalogs and used Access Manager for IWR.
• Extensive work with Metric studio to Monitor, Analyze, report on KPI. Audited and re-wrote test plans and tracked results using Excel to document processes.
• Complete QA, UAT responsibility for testing interface and data integrity, writing test cases and scripts, user support for all the COGNOS applications in group. Trained users on COGNOS reports and administration.
• Administrative: Providing specific security on data level, user level and creating Roles and Groups at COGNOS connection and Framework manager, Access manager. Using technical COGNOS support to fix the unknown issues and problems.
• Environments Setup for COGNOS 8 server to tune server performance to optimize speed and efficiency performed daily monitoring of Dispatchers & Services and logs.
• Scheduling and administering COGNOS Report studio reports in COGNOS Connection. Extensively work with event studio to generate scheduling & monitoring system, and administering reports using COGNOS Connection. Providing various supports for server administration for user’s security using Access Manager.

Environment: COGNOS series 7 & 8.2, COGNOS connection, Report studio, Query studio, Analysis studio, Metric studio, event studio, Metrics Manager, Metrics designer, Framework manager, Impromptu, JavaScript, Power Play, Transformer, Upfront, Access manager, IIS 5.0 with Windows NT/2000, Oracle 9i, SQL Server 2000, Toad, Power Point, MS-project.

Confidential, NJ

Senior COGNOS Developer

Responsibilities:

• As a consultant actively involved in system study, analysis, and design and develop and test the Reports/Cube requirements and writing technical specifications from sales and finance users for specific business need.
• Involved in development and deployment of catalog, impromptu reports, Prompts, query, models, cubes, and power prompts reports to COGNOS 8 as per business requirement.
• Implemented security at catalog and user class levels using governor settings in Impromptu catalogs and used Access Manager for IWR. Published reports, cubes and schedule to auto run web reports for users every day using scheduler.
• Providing various QA support and security for server administration using Access Manager and worked on creating list reports, cross-tab reports and chart reports using multiple queries in a single report and by using filters, calculations, conditional highlighting, creating Prompts and Cascading Prompts Pages,
• Worked on summary reports and detail Reports. Created drill through reports and associated with the summary reports to get details, tested and administered Impromptu Web reports (IWR) for global access for users.
• Worked on creating Impromptu Query definitions by filtering and formatting the source data to feed as Data source in creating Power play models and eventually power cubes, creating power cubes with cube groups and applied security in viewing the cube by an authorized user/user class in Upfront portal.
• User and maintenance of COGNOS reporting and ad-hoc reports. IWR consumer reports created in power prompts developer studio using HTML, SQL and Scripts to obtain interaction with report consumers and database.

Environment: COGNOS 7.3, 8, Transformer, Power Play, Access Manager, Scheduler, Script Editor, COGNOS Macros, HP QC, JavaScript, Impromptu Web Reports, SQL, PL/SQL, Oracle 9i, Access, Upfront, IIS 5.0 with Windows NT/2000, Oracle 9i, SQL Server 2000, Access.

Confidential

Senior system analyst

Responsibilities:

• Worked on Creating Impromptu reports using catalogs created as per business requirement, building cubes using Transformer with Date dimension, alternate drill downs, Drill thru reports and Prompt Reports. By writing a macro to automate the movement of the Reports from developing environment to production environment.
• Implemented security at catalog and user class levels using governor settings in Impromptu catalogs and used Access Manager for IWR.
• Actively involved in publishing the Reports, Cubes, Visualizations and setting the standards in Upfront and granting the permissions to the users based on their roles with appropriate user-classes.
• Worked on IWR Distribution Shuttle builder and COGNOS Upfront Portal to organize the Reports access in web and train end user in Personalizing, Subscribing and Scheduling Reports.
• Using Access Manager to provide user level, create user classes, groups and role to access specific for accessing Reports.
• Worked on Scheduler to schedule reports in regard to the period and time. Publishing Power play Cubes from Power Play Enterprise Server to upfront and Impromptu Reports on to upfront from Report Administrator.
• Maintenance of development, testing and strong support for the needs of both production and ad hoc reporting users.
• IWR consumer reports created in power prompts developer studio using HTML, SQL (Known as Dynamos) and Scripts to obtain interaction with report consumers and database and non-dependent on specific report or catalog and conducted sessions for global users. Prepared technical documents for operations of business. Executed jobs automatically without manual intervention using Job Scheduler. Implement user access using access manager for reports, cubes data security.
• Actively involved in installation of COGNOS Tools in NT (6.x, 7) and interfaces. Automated tasks using NT Scheduler (Jobs stored in batch files)

Environment: COGNOS 7.3, Impromptu, Transformer, Power Play, Access Manager, COGNOS Scheduler, COGNOS Script Editor, COGNOS Macros, JavaScript, Impromptu Web Reports, SQL, PL/SQL, Oracle 9i, Access, Upfront, IIS 5.0 with Windows NT/2000, Oracle 9i, SQL Server 2000.

Confidential, Washington DC

Consultant

Responsibilities:

• As a consultant worked on System analysis of business process and requirements for Account department for different levels of members e.g. national, state, and local.
• Prepared detailed project plans, statements of work and prepared full project life cycle plans and as a developer to gather User Requirements, Created COGNOS Impromptu Catalogs for Impromptu Reporting and Power Cube development
• Actively involved in creating catalogs, Impromptu reports and cubes using various business data. Implemented security at catalog and user class levels using governor settings in Impromptu catalogs and used Access Manager for IWR. By writing a macro to automate the movement of the Reports from developing environment to production environment.
• Worked on IWR Distribution Shuttle builder and COGNOS Upfront Portal to organize the Reports access in web and train end user in Personalizing, Subscribing and Scheduling Reports. Worked on Access Manager on security and create user classes for accessing Reports, Scheduler to schedule reports in regard to the period and time.
• Managed Multi-user access using Authenticator and automated reports through Scheduler. Implement user access using access manager for reports, cubes data security.
• Prepared technical documents for business operations and to end users. Installed Impromptu NT version software for users, assisted in Product demonstration of COGNOS products.
• Interacted with business partners to identify information needs and business requirements for reports/cubes. Assisted users in troubleshooting their reports Documenting changes, new requirements and Technical documentation for future enhancement. Generating various files hot files, csv, excel, text, snapshot etc., for various clients like McGraw-Hill, Gieco, etc. and other purposes for their members.

Environment: COGNOS 5, 6 & 7. Impromptu, Transformer, Power Play, Access Manager, Scheduler, Script Editor, COGNOS Macros, Impromptu Web Reports, Upfront, SQL, PL/SQL, Oracle 8i, Access, IIS 5.0 with Windows NT/2000,Citrix browser, MS Project, Word, Excel, Visio, Power Point, Access,.