SUMMARY

• Having more than 11 years of extensive and diversified experience in requirements management, systems, software design and development encompassing Retail, Pharma & Aerospace Domains.
• Performed Mobile testing of web pages, applications in iOS, Android using Xamarin
• IT experience in the Analysis, design, development, testing and Implementation of ETL & Business Intelligence solutions using Datawarehouse/ Data Mart Design, ETL, BI,UNIX
• Strong working experience on DSS (Decision Support Systems) applications and Extraction, Transformation and Load (ETL) of data from Legacy systems.
• Expert in testing BI Reporting and ETL procedures and mappings
• Good experience in data sources, data profiling, data validation, developing low level design patterns based on the business and functional requirements.
• Extensively used ETL methodology for supporting data extraction, transformations and loading processing, in a corporate - wide-ETL Solution using Transact, AbInitio
• Worked with databases such as Oracle, SQL Server, DB2 and Teradata and used ETL tools such as SSIS, DTS and many different BI tools such as Cognos, Crystal Reports and Business Objects
• Performed ETL (Informatica, Data Stage) testing on DWH and Data Migration projects.
• Involved in XML data verification and validations.
• Have good experience in Designing,developing,modifying,testing and validating software application using various modules of C++, Cobol,C#,VB,VB.Net,ASP,JSP,ASP.Net, HTML, DHTML.
• Extensive experience in Analysis, Design, Development and Implementation of various intranet, client-server and web based applications.
• Understanding of all the phases of Software Development Life-cycle (SDLC) such as analyzing, designing, coding, testing and documentation of software products.
• Extensive experience in developing, implementing applications and products using ASP.NET, C# Win Forms, VB.NET, ADO.NET, ASP.
• Experience in HTML, DHTML, XML, XSL, XSLT, UML.
• Performed Web Service testing using SoapUI.
• Extensive experience in SQL Server Development and DBA experience and in developing large-scale, performance critical client/server and web applications using Microsoft Technologies like ASP and VBScript, developing solutions with Microsoft .NET using Visual Studio.NET, ASP.NET, C#.NET, and VB.NET with SQL Server 2000/ 2005 and Access as databases.
• Expertise in writing complex SQL and PL/SQL statements.
• Experience in the QA Life Cycle, includes preparing the Test Cases and Testing the developed programs (Unit testing, Integration testing, Regression testing).
• Experience preparing Traceability matrix (RTM) for end client.
• Extensive experience in versioning using Visual SourceSafe (VSS) and Rational Clear Case, Subversion (SVN).
• Experience in process management tools like Rational Clear Quest.
• Expertise in using the bug tracking tools like Quality Center, JIRA, Bugzilla and Source control like Subversion, GIT and VSS.
• Have been involved in agile testing and UAT testing
• Good experience in testing tools like Win Runner, Load Runner, QTP, Quality Center.
• Highly skilled at interfacing with the customer and resolving their issues with a quick turnaround time.
• Good knowledge of quality process and a good team player with good communication, leadership and documentation skills.

TECHNICAL SKILLS

OS Environments: Windows 2003/ 2000/ NT/ Vista/ XP/ 2000/ 98

Languages: C++, C#, VB.NET, .NET 1.1/2.0/3.5, VB 6.0, C, C++, PL/SQL, Abinitio

Web Technologies: ASP.NET 3.5/2.0, DHTML, HTML, JavaScript, Jquery XML, XSLT, UML, AJAX, PHP, WPF, WCF, Web Services, VB Script

IDE: Visual Studio 2008/ 05/ 03

Design Tools: ORCAD, MS Visio 2007/03, RTRT, Pronto Edit, Image Magic, TOAD, SQL Navigator, Xamarin

Version Control: Rational Clear Case, MS-Visual SourceSafe, Subversion (SVN), GIT

Project Management Tools: MS Office, Rational Clear Quest, Doors 8.0

Software development:

Methodology: Agile, Waterfall

Databases: MS-Access, Oracle 9i, SQL Server 2000/ 2005, Netezza

Web Server: IIS

Office Suite: MS Office 2003/ 07/ XP

QA Tools: Quality Center (Test Director), QTP, Win runner, Load Runner, Rational Quality Manager, Selenium, JIRA, Bugzilla

PROFESSIONAL EXPERIENCE

Confidential

QA Lead

Responsibilities:

• Performed Mobile testing of web pages, applications in iOS, Android using Xamarin
• Applications are tested in different tablets like iPad, Samsung and kindle Fire
• Coordinate the QA activities in the project & Work on the QA estimation
• Define test approach, strategy, manage test data, and create test bed.
• Tested the SQL queries on data staging tables and data warehouse tables to validate the data results
• Testing on number of SQL queries to validate the data between sources and targets.
• Check the naming standards, data integrity and referential integrity
• Experience in writing SQL queries, generating reports to ensure data integrity and validating business rules for testing activities
• Checked the reports for any naming inconsistencies and to improve user readability
• Compared the actual result with expected results. Validated the data by reverse engineering methodology ie backward navigation from target to source.
• Validating the load process of ETL to make sure the target tables are populated according to the data mapping provided that satisfies the transformation rules and business rules
• Involved in validating the aggregate table based on the rollup process documented in the data mapping.
• Written several complex SQL queries for validating Cognos Reports.
• Performed Black box Testing, Regression and end-to-end testing.
• Tested Ab Initio graphs for data loading
• Involved in designing scripts using Selenium
• Define the test scenarios and test cases for complete system integration tests
• Interact with the QA team, business SME and Dev leads
• Managing onshore team and coordinating with offshore team to ensure Quality releases.
• Ensure that all information systems, products, and services meet organizations standards and end user requirements.
• Review Project Artifacts and Requirements.
• Conduct Test Readiness Assessment and execute manual test cases, automated test scripts.
• Log and review issues and defects identified.
• Ensures that all aspects of testing, such as: manual execution, regression, automation, and performance are completed.
• Assess progress, escalate issues, and manage technical decisions.
• Develops and maintains automated performance test scripts, test data and test cases.
• Make recommendations regarding defect prioritization and conduct daily triage meetings
• Work with developers to resolve defects and issues
• Worked on Mobile Web page and Application testing using Xamrain for iOS and Android.

Environment: ORACLE 10.0/9.0/8.0 , PL/SQL, QC, MS-office, TOAD Win XP, SQL Plus, PL/SQL Developer, Abinitio, Cognos, JIRA, Bugzilla, Xamarin.

Confidential

.Net Developer

Responsibilities:

• Developed user interface using Asp.net
• Developed a component to export/imports list of data's
• Developed web services using C# and implemented across the system
• Involved in retrieving data using ADO.Net with C#. NET, ASP .net and presenting it to XSLT.
• Developed component for Encryption using C#
• Developed component with WCF and WPF
• Involved in creation of tables and writing Stored Procedures.
• Creating Indexes and stored procedures on various business rules
• Executed SQL queries to validate that actual test results match with expected results.
• Implemented Forms-based Authentication in ASP.NET to authenticate the users.
• Deployment of project at client place
• Performed System Testing, Integration Testing, User Acceptance Testing and Requirement Testing
• Executed Test Cases with respect to Source and Target database tables.
• Written SQL queries tovalidate reports against the database.

Environment: VS .net 2005, C#, ASP.NET 2.0\3.5, PL/SQL, Oracle,T-SQL,SQL Server 2000/ 2005, JavaScript,Jquery, XML,XLST,WCF, HTML,Source Forge, OOAD, Peoplesoft, Web Services, AJAX

Confidential

.Net Developer

Responsibilities:

• Configuration for DVD players, Sat TV receivers, XM receivers, CD Changer, Cameras, VCRs and Carry-On Equipments to be installed on the business aircrafts.
• Number of bulkhead Monitors and Cabin speakers to be installed on the aircraft.
• Configuration for ZDE (Zone Distribution Equipment), VEE (Video Encoder Equipment), DTE (Digital Tapping Equipment), RDE (Relay Drive Equipment).
• Water heater configuration
• Briefing and PA(Passenger Announcement) configuration
• Galley Lights and number of Galley appliances to be installed on aircraft
• Configuration for Cabin Climate Control.
• Cabin and Lavatory Shades Configuration
• Airshow configuration
• Global Office and Printer Configuration
• Number of PDE(ACPDE and DCPDE) configuration
• Seating layout configuration based on the seating diagram of the aircraft
• Read/Table/Call configuration using MDSB protocol.