Resume

Sign in

Data Manager

Location:
Folsom, California, United States
Posted:
August 21, 2018

Contact this candidate

Resume:

RANJAN SAHOO

(***) ***- ****

SUMMARY

** **** ***** ** *.T industry experience in DataWarehouse Testing,ETL and Reports Testing.

Expertise in diverse domain technologies like Healthcare, Banking and Retail.

Experienced in every phase of Quality Assurance Life Cycle (QALC) and Software Development Life Cycle (SDLC)

Experience in software engineering methodologies of SDLC like Agile and Waterfall.

Extensive experience in Manual/Automated testing that is functionality testing, performance testing, System Testing, Build Verification Testing, Regression Testing, Load testing, using Automation Tools.,Load Runner, Quick Test Pro (QTP), Quality Center

Experience in ETL testing with Informatica and Abinitio to ensure business logic in data transformation.

Extensive experience in developing Test Plans, Test Cases and Test scripts using business requirements and design documents.

Expertise in Problem solving and Defect Tracking Tools like Quality Center, JIRA and Clear Quest.

Experience in back-end testing to query and access Oracle database using SQL

Involved in backend testing by writing and executing SQL queries. Good knowledge of writing and modifying UNIX scripts using commands and as per the UNIX requirements.

Ability to achieve targets and deliver results in a high-pressure environment.

Proactive and analytical problem solver with strong leadership and excellent interpersonal skills; also has good client interaction and team skills.

TECHNICAL SKILLS

Testing Tools: Quality Center, QC ALM, Rally, Rational Clear quest

ETL Tools: MSBI,Abinitio,DataStage,Informatica

Reporting Tools: Cognos,BO,

Defect Tracking Tools: Test Director/Quality Center, Merrant Tracker, JIRA, Clear Quest,

Other Tools TOAD, SQL developer, VmWare, Citrix, Rational Requisite Pro,

Microsoft office,

Operating Systems, Browsers: : Windows XP/ Windows, IE, UNIX, Chrome and Firefox

EXPERIENCE

Infosys Ltd March 2016 to Till date

QA Lead,BSC

Responsibilities:

Reviewed Business Requirement and Functional Specification docs for writing test cases.

Experienced in defining, creating and implementing testing process and methodology.

Prepared Test Plan and Test Cases based on business, technical and functional docs.

Submitted Status and Test Evaluation Reports.

Developed Test data for Test Scenarios as per the functionality of the application.

Involved in rigorous meetings with testing team, development and BA team to plan and implement testing efforts.

Review Test case written based on the Change Request Document.

Executed the test cases in Quality Center and HP ALM

Attend meetings to discuss all the outstanding Issues.

Validating the data at the backend.

Extracting the data from the database using SQL DEVELOPER.

Extracting the data by running the SQL queries on the database.

Logging the defects in to QC.

Developed Load Runner scripts

Executed and Analysed Load Test using Load Runner

Monitored the Load test using Solar Winds

Environment: QC ALM, SQL developer, Toad, Load Runner, Windows XP, VMware, IE8, IE9, Mozilla Firefox, Citrix.

Infosys Ltd March 2011 to March 2016

QA Lead,Payflex & Aetna INC

Nacha Rails/HSA/FSA Testing: The project deals with the NACHA file, that the federal govt deals with.Created data scenarios to test the NACHA File. Analyzed the various possible data scenarios that could be created for the Nacha File.

ETL (EDW & HWDM) testing :This project deals with extremely complex ETL SQL and reporting. Data warehouse is a database or a collection of data, from a variety of sources, specifically designed for data analysts in an organization and other end users for analyzing, reporting, tracking, and supporting strategic decisions. First, the data is transferred into the data warehouse using an ETL process. After the loading, data is organized and kept in Data Warehouse which is further sourced to downstream applications like data mart, reports, OLAP cubes and BOU. Worked in ICD9 to ICD 10 Conversion Projects for EDW application spread across different releases. Worked on various Medicare projects spread across various releases.

IODS testing :This project deals with Data from different operational databases across Aetna Book of Business integrated into IODS to provide the end user community with an integrated view of enterprise data enabling end users address operational challenges that span over more than one business function. Tasks Involved: Created testing scenarios in MF files,Trigering jobs and execution. Created the data coming from various source systems. The data created was of excel,.txt format.

Migration testing : Worked in ABINITIO 2.12 to 3.0.4.2 Migration project where jobs were migrated from older to newer version. Worked in the estimations proposal for this project. Worked in DB2 migration projects also. Responsible for resolving the issues raised by the team.

Ness Technologies Oct 2010 to March 2011

QA Assurance Lead

TMODS (Trail Management Operational Data Store):

The main objective of Trial Management Operational Data Store (TM ODS) is to establish a central project management data repository for consistent and accurate reporting and analytics. The Quintiles Data Factory will deploy Operational Data Stores to house operational reporting data, therefore, removing the need for direct analytics or reporting against current OLTP systems, which normally result in performance issues. The TM ODS primary purpose is to serve as an intermediary repository of current aggregated transactional Trial Management data which is populated on a near real-time basis. Operational data stores (ODS) are typically deployed to fill an architectural requirement to handle detailed, volatile, integrated data for the purposes of operational reporting.

To enhance the value of operational business applications, Data Factory provides a common data model for all data of interest regardless of the data's source. This makes it easier to report and analyze information than it would be if multiple data models were used to retrieve information.

Releases : TM ODS 1.0, TM ODS 2.0, TM ODS 3.0, TM ODs 3.1 TM ODS 4.0 and TM ODS 5.0 .

Roles:

Attend the Design / Model Review meetings.

Mentoring the team and helping them in understand the functionalities.

Reviewing the data mapping documents, FS Documents earliest and giving the comments.

Test Strategy preparation.

Assign daily priority tasks and closely monitor test activities to ensure that all aspects of the system has proper testing coverage.

Communicate issues and status information to the QA Manager concerning Testing activities on daily basis.

Prepare the weekly status report and sending it to the QA Manager.

Attend the daily scrum meetings and update the Testing Team progress on daily basis.Constant interactions with Dev /BA teams and update the issues /clarifications.

Test case creation and execution using Quality Center 9.0.

Validate the data between source and target tables through SQL’s (includes Row Count Check,

Meta Data validation, Data Validation, Null value handling, transformation rules, duplicates)as per the documents.

Read the informatica mappings.

Defect raising and defect tracking.

Defect triage meetings.

Generating the test reports and collecting the signatures for all the project documents.

SSU Dashboard Report

SSU Dashboard contains the key metrics used by the business related to Site Start up are calculated and displayed in tabular column and the cycle times (median values) for the important metrics are displayed in the graphs.

The dashboard will allow the user to view the data at each protocol level and can be viewed at Global, Region and Country level.

Roles :

Review of mapping documents.

Test Case creation (includes row count, structure validation, data validation using SQL Queries,UI validation) as per the documents provided.

Test Case execution using Quality Center.

Defect creation and tracking using Quality Center.

Interaction with Dev and BA teams for further resolutions of issues and clarifications.

Attending the daily status meetings and update the status.

Update the QA manager on daily basis, the status of the project.

Closely monitor the Project status as per the Project Plan and timely bringing to the project team notice, if any slippage.

Accenture Technologies March 2007 –Oct 2010

Software Engineer

Worked in multiple projects like BestBuy,Mobistar and Barclays Bank.

EDUCATION:

B.Tech (Mechanical Engineering) NIT Rourkela,Odisha,India

Immigration Status: H1B



Contact this candidate