Data Sql Server

RajaSekhar M

LinkedIn

Mobile# 678-***-****

*********@*******.***

Impeccable track record of consistently delivering highest Quality QA deliverables in all the organizations/projects.

Over 12 years of experience in Testing Database, DWH ETL, BI Reports, Web, Enterprise Application Integration (EAI), Client/Server, Product applications.

Over 4 years of experience in development of Client/Server, Web and Database applications.

Over 4 years of experience in MIS, application and Database Support, System/Network Administration and Helpdesk Support related activities.

Attainments:

In GameStop, received appreciation from QA Leads/Managers, Project/Program Managers and Directors for outstanding quality deliverables and implementing ETL QA process.

In BCBS received appreciation from Supervisor/TPMs for good QA deliverables without any production issues.

In Southwest, received appreciation from PMs and Leads for outstanding QA deliverables in all monthly releases (20+).

In Ness, changed existing data validation approach for 100% data quality/accuracy. Created automation framework for ETL data validation and implemented it.

Awarded with Deliver-IT Award by Microsoft IT Executive Team for LIR-Mithril Project, which enabled additional revenue recognition of $120 Million/per day.

Received appreciation from client (State Street Corporation) for delivering outstanding quality deliverables in all the releases (in DWH ETL / BI Reports / Web modules).

The Solvay Pharamaceuticals SFA CRM implementation at Dendrite is awarded as one of the top 10 2007 world’s most successful projects by Infoworld.com (http://www.infoworld.com/article/2642076/it-careers/2007-infoworld-100-awards.html?page=2).

In ItalCementi, developed financial and cost reporting application which reduced the month-end data consolidation of all Factories/Branches and financial/costing data processing time from 48 hours to 2 hours.

Experience Summary:

Excellent knowledge in complete Software Test Life Cycle (STLC).

Very good understanding of the Software Development Life Cycle (SDLC) methodologies.

Worked in Onsite, Offshore, Near Shore, Multi-Vendor delivery models.

Worked as Onsite Coordinator/Lead as well as Offshore Lead owning all QA activities.

Extensive experience in Manual Testing using Black box Testing, Grey box and white box testing.

Good Experience in QA Methodology and Validations to ensure industry standards.

Excellent troubleshooting and debugging skills.

Worked on Mobile/PDA applications testing.

Very good experience in developing automation frameworks for automating the data/ETL validation. Performance Testing of ETL Jobs.

Extensive experience in writing Test Plans, Test Cases/Scenarios, Traceability Matrix and Status Reporting.

Worked on Business domains like eCommerce, Travel, CRM, ERP, Accounting, Order Management / Billing / Invoicing, Sales, Stock Accounting, Finance / Securities (BFSI), Life Sciences, Pharma / Medical, Healthcare, Contract Management, Business Process Management (BPM), and Human Resources (HR).

Extensively used ETL methodology for supporting data extraction, transformations and loading processing, in a corporate-wide-ETL Solution using SSIS, Datastage, XTelligent, Informatica and HIVE (Big Data Hadoop).

Extensive testing experience in Business Intelligence tools like Actuate, Click-view, SSRS, Business Objects, Cognos and Crystal Reports testing.

Worked on Enterprise Application Integration (EAI) implementations (BizTalk & TIBCO) testing. Experience in Web, e-Commerce, SOA, Client/Server, Mainframes applications testing. Knowledge of PEGA.

Involved in testing the technical features like Index Management, Data Compression & Resource Governor as part of Dog Fooding in Microsoft.

Worked on 250+ Terra bytes Data Warehouse DB applications.

Good knowledge of Database architecture and Database Server/DBA Concepts.

Having experience in testing Data Conversion. (migrating data from legacy / heterogeneous applications/databases to new system / Up-gradation testing).

Good Collaboration and mentoring skills. And good technical/domain knowledge to actively participate in technical discussions with Developers, Architects, and PMs.

Extensive Experience in writing complex PL/SQL, and SQL Statements in Oracle, SQL Server, DB2, Sybase, Teradata databases and Big Data Hadoop. Good knowledge in developing Packages, Stored Procedures, Functions and Triggers.

Good knowledge of using Oracle APIs (Dynamic SQL, DBMS_PIPE, DBMS_ALERT etc).

Hands on testing experience in SIEBEL Loyalty and SIABEL CTMS data migration.

Proven experience in Automation, Functional Testing, Regression Testing, Integration Testing, End-to-End, Unit, Compatibility, Installation Testing.

Excellent at Problem Solving, anticipating risks, and finding/proposing Solutions for the Project risks/issues.

Ability to work independently as well as in team with excellent inter-personnel, problem solving skills.

Flexible and versatile to adapt any new environment and work on any project without supervision and full accountability. Quick onboarding in the new projects.

Technical Skills

ETL

Informatica 8.x, Datastage 7.X, Abinitio, SAP Data Services XI, SQL* Loader, Snap Logic, Shell Scripts.

Reporting Tools

Actuate, Click View, Crystal Reports, Cognos, Flex, Business Objects

RDBMS

Big Data, Hadoop, Cloudera Impala, Vertica, Oracle, SQL Server, Teradata, DB2, Sybase, Pervasive, MS-Access, Clipper, FoxPro and dBase

Testing Tools

Microsoft Internal DB automation framework, VSTF, QTP 8.0, WinRunner7.x, TestComplete 3.x, Clear Quest, Bugzilla, Product Studio, VSTF, Clarify, HP Quality Center, ALM, JIRA

Config. / Content Management Tools

VSTF, Surround SCM, Visual Source Safe, WIKI, Sharepoint

Packages / Tools

MS-Office, Borland Office, Star Office, TOAD, Benthic, SQL*Plus, SSMS, Putty, Tidal job Schedular, HIVE, dbVisualizer, dBeaver

Languages / Scripting

Visual Basic, Java, VB Script, PL/SQL, T-SQL, SQL, VBA, HTML, XML, PHP, Ruby

Operating System

Windows, Linux/Unix, DOS

Professional Experience:

GameStop, Inc., Grapevine-TX (Sr. QA Analyst)

April, 2015 to till date

Role & Responsibilities:

Simultaneously worked on multiple projects (handled 4 projects in parallel at one point of time). And responsible for all QA deliverables.

Implemented ETL QA Process.

Creation of Test Data and validating ETL Jobs.

Validation of BI Reports.

Environment: Big Data, Hadoop, Cloudera Impala, HIVE, Vertica, SQL Server, Oracle, TeraData, UNIX, Shell Scripts, Tidal Job Scheduler, SSIS, SnapLogic, Informatica, TIBCO, Ruby.

BCBS, Richardson-TX (Data Quality Analyst)

July, 2014 to April, 2015

Role & Responsibilities:

Test Planning, execution, and status reporting.

Test Data creation for ETL Jobs validation.

Creating SQL scripts / source data to verify Batch/Real time data loading jobs using test automation jobs.

Environment: DataStage, DB2, TeraData, BigData, Hive, XML, UNIX.

Southwest Airlines, Dallas-TX (QA Analyst)

July, 2011 to June, 2014

Role & Responsibilities:

Testing Air, Hotel and Car ecommerce modules (southwest.com, swabiz.com).

Validating SIEBEL Loyalty application. And Mobile applications testing.

Verifying data in mainframe application (SABRE and AMADEUS GDS) where all booking information is stored.

Worked on technical features, Reports and database performance tuning features testing using complex SQL queries. Validated Perl / Shell scripts.

Performing System, Regression, Data validation testing on below applications:

Swalife.com – used by southwest employees and other airlines employees for booking their Air tickets.

Exchange tickets related application.

Application used by customer support agents in airports (QIK, CS2).

Creation of Promotional Codes with various business rules for testing (alice.com).

Written complex VBA macros to generate customized reports from Quality Center and to format them in Microsoft Excel for Management.

Created Automation Test Scripts.

Environment: Windows, UNIX, Java, BizTalk, HP Quality Center/ALM, JIRA, XML, Teradata, Oracle, SQL Server, Abinitio, Oracle Jobs, Perl / Shell Scripts, VBA, SIEBEL, SABRE View.

Expedia, Bellevue-WA (Test Design Engineer - SDET/Onsite Coordinator)

August, 2010 to July, 2011

Role & Responsibilities:

Worked in Enterprise Data Warehouse group.

Provided guidance and support to off-shore team (in China).

Test Planning for multiple projects and Task allocation to the offshore resources.

Test scenario and test case authoring.

Written Complex SQL Queries to Check the data loads in Different Stages

Performed Hardware Upgrade testing and User Acceptance Testing (UAT) of the RAIDs (requirements / defects are called as RAIDs).

Building the code and deploying it in TEST and Pre-Production (PPE) Environments. And validating the applications.

Verifying the build deployment in Production environment (there will be daily Production deployments in EDW Group) and validating data.

ETL & Reports testing developed in SAP Data Services, Informatica & BO.

Testing of HR Data Mart, Problem Management DB ETL and BI applications testing.

Responsible for Final Journal Entry & Expedia Affiliate Network applications hotfixes and enhancements testing.

Environment: DB2, SQL Server 2005, Informatica, SAP Data Services, SSIS, SSRS, HIVE (Big Data Hadoop), Business Objects, PeopleSoft, Product Studio (RAID), Perforce, Toad, SSMS, WinSCP, Windows Server 2003, LINUX, Pearl, Shell Scripts.

Quintiles (Senior Validation Engineer (Lead QA))

December, 09 to May 10

Role & Responsibilities:

Created Test Plan / Test Strategy / Effort Estimation for SIEBEL CTMS Data Migration Project.

Implemented new approach for ETL data validation.

Developed automation framework for automating the data validation test cases.

Interacted with BA/Data Analysts and Developers to analyze and resolve the issues.

Performed Validation testing on the heterogeneous applications (Siebel, PeopleSoft, SalesForce, MDM [Master Data Management System] and legacy).

Closely worked with Data warehousing developers to understand the implementation of ETL mappings for data transfer from Source Staging Target databases.

Performed Back end / Schema Validation, Database testing using SQL.

Attended regular requirements walk-throughs, project meetings and weekly team meeting. Tested reports developed in Cognos, Flex.

Performed Data testing, Transformation testing, Business rules and Data quality

Collaborated with other application groups for knowledge transfer.

Suggested architecture level changes in implementation.

Environment: Oracle 10g, SQL Server 2000, Informatica 8.x, Cognos, Flex, Application Server, OSB, Siebel CTMS, PeopleSoft, SalesForce, MDM (Master Data Management), Legacy Applications, MS Office, Windows XP, Unix, Quality Center, QTP & PL/SQL.

Microsoft (Test Lead / SDET)

February, 2008 to November, 2009

Role & Responsibilities:

Test Planning and Involved in preparing Rough Order of Magnitude (ROM).

Created Test Scenarios, Test Cases based on Functional Specification, Data Mapping and Technical Specification.

Automating test cases using the Microsoft internal automation tools.

Involved in performing Data validation of Source, Delta, Staging, Factory & Repository databases in 2.5 Terra Byte data warehouse environment.

Used Product Studio & VSTF for defect tracking also followed up with development team to verify bug fixes and re-tested the fixed issues.

Tested Data movement and Data validation from various source’s to Data Warehouses (Factory & Repository servers).

Tested Resource Governor Technical feature in SQL Server.

Tested the functionalities as per business requirements in SQL Server Reporting Services (SSRS) for analyzing the data.

Performed the database testing by writing the SQL queries to validate the data.

Validated Windows NT Batch Jobs which pulls data from MSP COR LW databases.

Integration testing was performed on BizTalk implementation, validated the XML messages schema and data flow from LW BizTalk SAP.

Attended regular project meetings and weekly team meeting.

Hands on Experience in developing of Requirement Traceability Matrix (RTM).

Worked on License Wizard suite of applications (Web & Client/Server).

Environment: SQL Server 2005/2008, DTS, SSIS, SSRS, SSMS, Windows NT Batch, Windows 2003 Server, Visual Basic, ASP.Net, SAP, BiZTalk, MS-Access, SAP.

State Street Corporation (Module Leader)

April, 2007 to February, 2008

Role & Responsibilities:

Worked on Credit Risk application as part of BASEL-II implementation.

Tested ETL, Reports and Web applications in the project and delivered highest quality deliverables.

Reviewing Business/Functional requirements and technical specifications of the application.

Analyzing the test requirements and written new Test Cases as per the requirements.

Performed Manual Testing on Web and Reports applications as per the requirements. Created SQL for reports validation based on Reports Requirements and Technical Specification documents.

Involved in various kinds of testing (Regressions Testing, Functional Testing, System Testing).

Validated data enrichment logic based on the Data Enrichment Logic document.

Written SQL Queries and PL/SQL Anonymous Blocks to perform database testing.

Validated data flow from various sources like Text files, Oracle and SQL Server databases implemented using Data Stage jobs.

Tested various reports developed in Actuate.

Developed various reports to communicate testing issues with the project manager/client.

Environment: Oracle 9i, PL/SQL, Data Stage, Java, Web Spear, AutoSys, TextPad, FTP, Rational Clear Quest, Rational Robot, Windows 2000, Unix, MS Office, TOAD.

Dendrite (Sr. Test Engineer)

June, 2005 to April, 2007

Role & Responsibilities:

Worked on Life Science CRM - Sales Force Automation (SFA) implementations testing for Solvay Pharmaceuticals, UCB and Sanofi, Pfizer.

Performed Integration, Functional, Regression, Sanity, Installation and End-to-End testing.

Validated Enterprise Application Integration (EAI) implementation (TIBCO) by performing Integration and End-to-End testing.

Mobile/PDA applications testing and validation of data according to the Data mapping.

Worked on Application Integration Services (AIS) Testing.

Performed Feature Testing, System Testing, UAT Testing, mock Go Live testing.

Worked with Meta Data files used in the project and modified them to suit to the QA requirements.

Used DataStage for Extracting, cleansing, transforming, integrating and loading data into data warehouse.

Mentored team in understanding Integration and Database testing.

Performed security testing to see how well the system is protected against unauthorized access (User Manager Application).

Environment: Oracle 9i, Sybase, PL/SQL, Benthic, SQL* Plus, Data Stage, Informatica, XTelligent, TIBCO, EMS, Informatica, Clarify, Surround SCM, QTP, Test Complete, Windows 2000.

Zuari – ItalCementi (IT-Officer)

February, 1999 to June, 2005

Role & Responsibilities:

Developed application to consolidate different Factories Financial and Cost accounting information.

Converted Legacy FoxPro application which consolidates different branches Sales and Accounting data into Visual Basic.

Designed Finance and Costing reporting applications which provides reporting based on European / Indian Financial requirements (calendar / financial year).

Worked on Order Management / Billing / Invoicing, Sales & Stock Accounting applications extensively. Processing of month-end data and consolidating it.

Developed Human Resources (HR) application to track all the employees’ information and reports generation.

Monthly reports generation and MIS preparation based on the various sources data.

Co-ordinated with the external vendor for implementation of the Sales and Stock Accounting System development / testing / implementation activities.

Co-ordinated application and data migration testing activities.

Lotus Notes and GiftUlti mail administration. IT Assets tracking and management.

Network / System administration, Helpdesk support and Vendor Management.

Environment: Windows 2000, LAN, WAN, Lotus Notes Mail, GiftUlti Mail, MS-Access 2000, FoxPro, Visual Basic 6.0 and VBA, Oracle 8i, Developper/2000, ASP.NET, C#, XML, VB/JavaScript, MS-SQL 2000 & Crystal Reports, SAP.

Compaq - Digital Equipment India (Executive-Systems)

May, 1997 to February, 1999

Role & Responsibilities:

Supported client’s IT infrastructure as part of Compaq / Digital Equipment India’s Facilities Management Services.

Helpdesk support for all the desktops at various client locations. Installation of Hardware and Software. System administration of Novell Netware, Windows NT and UNIX. Access control and user administration.

Performed Mail servers (cc-Mail) admin. Windows and Lotus Notes clients config.

Daily, Weekly and Monthly MIS reports generation.

Co-ordinated with various vendors for H/W, S/W and Network related issues.

Developed application to track Helpdesk calls in Developper/2000 and Oracle.

Environment: LAN, Novell Netware 3.x/4.x, Windows NT/3.11, 95, SCO UNIX, DOS, Ingress, Oracle, cc-Mail, Lotus Notes, Borland Office, Microsoft Office.

Span Medicals (Systems Officer)

May, 1996 to May, 1997

Role & Responsibilities:

Handling all branch related IT operations.

Computerization of other branches and training the users on applications.

Collecting data from branches and consolidation of data.

Working on Order Management and Stock Accounting applications.

Environment: Windows, Novell Netware, Delphi, Power Builder.

Education:

Microsoft Certified Professional (MCP) in SQL Server.

Oracle Certified PL/SQL Developer.

ACE Secure Application Test certification (Microsoft Internal Certificate for Employees).

Certificate in Computing (CIC) from India Gandhi National Open University.

DCA (Diploma in Computer Applications).

PGDCA (Post Graduate Diploma in Computer Applications).

Graduate in Commerce from Osmania University.

Contact this candidate