Resume

Sign in

Project Sql Server

Location:
Lutherville-Timonium, Maryland, 21093, United States
Salary:
95000.00
Posted:
March 02, 2018

Contact this candidate

Resume:

Jiban Shrestha

ac4n7t@r.postjobfree.com

QUALIFICATIONS:

•Over 18 years of IT experience in analytical, technical and testing capacities during complete Software Development Life Cycle and Software Testing Life Cycle and ALM. Team Lead in various positions.

•Full life cycle development from interacting with customers, gathering requirements and analyzing needs, Program Analysis, Design, Development, Testing, Deployment and Post Production support.

•Experience in CI/CD, Agile and Scrum, JAMA Quality Center, TFS, and CA ARD tools.

•Experience in requirements collection, analysis, documentation, assessing testing processes, creating, implementing test plan, testing strategies and SQA strategies using different-testing methodology in UAT phase.

•Quality Assurance, Software testing (manual and automate) and Quality Assurance Metrics and Reporting.

•Solid experience developing, designing and report writing in test plans, test scripts (VBScript and JavaScript), testing and tracking and reporting in web and windows based application using automated testing and test management tools LeanFT, UFT/QTP, QC, Software Testing using Visual Studio(STVS) 2010 and Selenium (IDE, RC, and Grid), NUnit, JUnit, TestNG, DbUnit, and Jmeter.

•Experience in Web Service, API and dll files and apps testing using Visual Studio and SoupUI tools.

•Software development experience using Visual Studio .net (VB and C#), Python (data mining and Machine learning) and Java (J2EE).

•Create and build deployment package, delivery and release management experience.

TECHNICAL SKILLS:

Operating System:

Windows NT, Windows 95/98/2000/XP/Vista, Windows Server 2003/2008, Exchange Server 2003, Windows 95/98, and RedHat 5.

GUI:

Visual Studio.NET, MS SharePoint Designer 2007, MOSS (MS Office SharePoint Server 2007), Visual Basic 6.0, Dream weaver.

RDBMS:

SQL Server 2005/2008 (including SSAS, SSRS, SSIS and Informatica), Oracle 11g in including OBIEE, Sybase, MS Access and MS Excel.

S/W Language:

C#, ASP.NET, VB.NET, Python, Java 1.4, Prolog, Heskal.

S/W Testing Tools:

UFT 12.02, Quick Test Professional (QTP), Quality Center (QC), Team Tracker, Load Runner(Vusers,VUGen), Software Testing using Visual Studio(STVS) 2010 and Selenium (IDE, RC), NUnit, JUnit, TestNG, DbUnit and JMeter.

Internet/Intranet:

ASP.NET, ADO.NET, PHP, HTML, DHTML, JavaScript, Java, Eclipse VBScript, XML, SOAP, SOA, AJAX, ADO, ASP, Apache, COM/DCOM, and Joomla.

Others:

MS Project Management Tool, Eclipse, MS Office, LaTex, Adobe Photo Shop.

Reporting:

Crystal Reports, SSRS, VB Data Report, and Dashboard.

Data Mining Tools:

QuDA, Weka, FCA (Formal Concept Analysis) and SPSS.

Scripts:

VBScript, JavaScript, and WMI script.

PROFESSIONAL EXPERIENCE:

Project: PPS, UPS, Maryland

Duration: 11/26/2012 to date.

Title: QA Analyst

Job Responsibilities:

Environments (Servers and Workstations) Build, upgrade and verify the system is ready to use in production or operations.

New PPS and OCCG releases Install/upgrade on OPSV, PPM and QAs environments and Shakeout (ready to use the system in operations).

Experience in Waterfall, Agile and ALM SDLC methods.

Experience in writing shakeout documents for PPS applications (DPS, PAS/DMS, ICO and SNAP).

Developed automated tools to automate manual environment build stuffs.

New Release staging tool for production and testnet (CDE and non-CDE) environments.

Automated Staging and Deployment Tool (Continues and simultaneously).

Configuration, INI, XML and text/log file update tool.

DPS, PAS ICO and SNAP database restore tool.

Create New Release Manifest document tool.

DPS Plan Activation Tool.

TEMPackage create tool (ongoing).

OS, S/W and H/W auditing and recording tool.

Prepared test automation environments including QTP/UFT clean Install and upgrade and TestAdvantage Infragistics (Win Form and WPF).

Knowledge and experiences in selecting possible candidate test cases for automation.

Create automation frameworks, test plans and design using Coded UI, UFT and LeanFT. API, dll and Web Service testing using Visual Studio C# and SoapUI tools.

Implement Test Automation Frameworks and solved the issues. It includes verification (automation test steps with manual test steps from QC) and upgrading DMS and DPS automation Frameworks to UFT 12.02.

Evaluate automated scripts Code Review, upgrade and modify CRAFT and OCAF Automation Frameworks. Involved in UAT of Test Automation Framework build by offshore (Cognizant) and onshore (ACT) team.

Create DPS Concurrency Test Cases (manual) from DPS Concurrency Test scripts (written in C# using Silk Tool).

Involved in Execute Test Automation Framework (DPS Smoke Test, Concurrency test, Microsoft Patch testing and DMS).

Work experience with offshore (Cognizant) and onshore team (ACT, NJ) and as a support team member.

Plan, Design and Build Test Automation Frameworks.

Assisted in training automation framework, vbscript and UFT to interns and QA testers.

Environment: VB, C#.NET, Coded UI, VBScripts, Configuration file, INI files, Log files, CSS, HTA (Tool UI), WMI Scripts, MS SQL Server, PL/SQL, HTML, XML, MS Excel, UFT, QTP, QC, and Windows Environments.

Project: OCCG, UPS, Maryland

Duration: 10/05/2011 – 11/26/2012

Title: QA Analyst

Job Responsibilities:

Install/upgrade OCCG applications on QAs environments and verify the system is ready to use in production and operations.

Design and build test automation (Keyword driven and data driven) plan, Test Cases, Test Scripts, Test Scenarios.

Build test automation environments including QTP clean Install and upgrade and TestAdvantage Infragistics (Win Form and WPF).

Developed Test Automation frameworks for different OCCG functionalities and performances tests in using QTP, vbscripts, WMI, hta/html, CSS and Coded UI tools.

Unit of Work Information Service (UOWIS), Package Delivery Management (PDM, Events ICOD, CDW, CDI and DI)

Data Injector Tool and Verification.

Local CDD Memory Leak Test Automation (performance testing using QTP scripts).

Replication Monitor.

Environment Build (Upgrade OCCG applications, Clean Install, update configuration files, xml, log and INI files, verify registry, application version and verify dll and other files staged/copied on program files after installation with version and date).

Developed MS SQL statements and XML for back end database testing.

Code Review and Implementation (execute and reporting results).

Work experience as a support team member at OOG application deployment on production environments.

Execute Tests (Manual and Automation Frameworks) and reports.

Environment: VB, VBScripts, C#.NET, IIS, MS SQL Server, PL/SQL, HTML, XML, HTA (Tool UI), WMI Scripts, MS Excel, QTP, QC, Coded UI and Windows Environments.

NAEAST, JPMorgen Tampa, Florida

04/2011 – 08/2011

DB and QA Analyst

•Prepare necessary development environment and test bed for software testing and development. It includes installation/management/administrative parts of Visual Studios (VB.NET, C#.NET, ASP.NET), SQL Server, SSIS, SSAS, Sybase database, Informatica and Windows Server 2008.

•Installation, configuration and upgrading of MS SQL and Oracle database server software.

•Interface with MS SQL and Oracle for technical supports.

•Design and develop Test Plan, Test cases, Test scripts, Test Scenarios and automate using QC.

•Work closely with Developers and Engineering Teams in the review and modification of the product, specifications using Agile-testing methodology, developing, and designing.

•Perform Manual and Automated (Unit Testing, Data Driven, Key Driven Framework, integration, regression, system, end-to-end testing and Web Service testing) Test Tools including, QC, Coded UI and SoapUI for the application under test and work in Agile testing Environment.

•Provided Efforts Estimate and coordinate the test schedule using Agile testing methodology in UAT phase.

•Perform Functional, Smoke, System Integration, Regression testing and Cross Browser Testing as per the specifications and automated regression scripts using STVS 2010.

•Create and use check points to compare expected values to actual values of object properties, generated during test run.

•Test enhancement by inserting various checkpoints (database MS SQL, XML and text) to ensure test script’s reliability and validity.

•Compare and analyze, while validating the existing applications against the current environment.

•Perform Data-Driven automated tests, parameterized the values from spreadsheet onto STVS 2011.

•Extensive experience with development and test methodologies including Agile.

•Provide support to automation team in debugging and developing automated test scripts.

•Work closely with the developers to resolve the bug issues and unit testing issues.

•Develop MS SQL, T-SQL Scripts for back end database testing.

•Develop test scripts and test scenarios for performance and load test.

•Maintain QC for Defect tracking and creating Test Matrix and involve in UAT.

Environment: ASP.NET, VB, C#.NET, STVS 2010, MS SQL Server 2008 including SSAS, SSIS, SSRS and ETL Informatica, PL/SQL, T-SQL, HTML, XML, MS Excel, Selenium IDE, Selenium RC, JMeter, JUnit, NUnit, TestNG, SOA, Coded UI, soapUI, Win Runner, QC, Load Runner, Windows environment.

EzeCTD Project, BCC New Jersey

09/2009 – 05/2011

DB and QA Analyst

•Prepared development environment and test bed for software testing and development. It includes installation/management/administrative parts of Visual Studio (VB.NET, C#.NET, ASP.NET), SQL Server, Oracle database, Informatica and Windows Server 2003.

•Installation, configuration and upgrading of MS SQL and Oracle database server software.

•Interfaced with MS SQL and Oracle for technical support.

•Designed and developed Test Plan, Test cases, Test scripts, Test Scenarios and automate using QC.

•Worked closely with Developers and Engineering Teams in the review and modification of the product, its specifications using Agile-testing methodology and Developing, designing and analyzing SW-CMM.

•Performed Manual and Automated (Data Driven, Key Driven Framework, integration, regression, system, end-to-end testing and Web Service testing) Test Tools including QTP, QC, and Selenium (IDE and RC) and soapUI for the application under test.

•Provided Efforts Estimate and coordinated the test schedule using Agile testing methodology in UAT phase.

•Performed Functional, Smoke, System Integration, Regression testing and Cross Browser Testing as per the specifications and automated regression scripts (VBScript) using QTP.

•Developed re-usable VB functions and procedures for repeatable scenarios.

•Created and used check points to compare expected values to actual values of object properties, generated during test run.

•Test enhancement by inserting various checkpoints (database MS SQL and Oracle 11g, bitmap, XML and text) to ensure test script’s reliability and validity.

•Compared and analyzed, validating the existing applications against the current environment.

•Performed Data-Driven automated tests, parameterized the values from spreadsheet onto QTP Scripts.

•Provided support to automation team in debugging and developing automated test scripts, Descriptive Programming and VB functions using QTP.

•Worked closely with the developers to resolve bug issues and unit testing (NUnit) issues.

•Developed MS SQL and PL/SQL Scripts for back end database testing.

•Involved in ETL using SSIS and Informatica, analysis activities SSAS and report/publication.

•Maintained QC for Defect tracking and creating Test Matrix and involve in user Acceptance testing (UAT).

Environment: ASP, VB, C#.NET, STVS 2010, IIS, Apache, PHP, MS SQL Server 2008 including SSAS, SSIS, and ETL Informatica, PL/SQL, Oracle 11g, HTML, XML, MS Excel, Selenium (IDE, RC) JMeter, JUnit, NUnit, SOA, soapUI, Win Runner, QTP, QC, Load Runner, Windows and Linux.

Agricultural Development Bank Ltd. (ADBL) and Asian Development Bank (ADB/Manila)

02/2009 – 11/2009

Lead QA Automation

•Performed B-testing including Regression, Integration, and System testing of the Application software under test. It includes Functional, Smoke, System Integration, Regression testing, Web Service testing and Cross Browser Testing as per the specifications using QTP, Selenium (IDE, and RC), Nunit, TestNG and soapUI.

•Designed and developed Test Plan, Test cases, Test scripts, Test Scenarios and automated.

•Performed Manual and Automated testing (Data Driven, Key Driven Framework, integration, regression, system, end-to-end testing and Web Service testing) utilizing Test Tools including QTP, QC, and Selenium (IDE and RC) and soapUI for the application under test.

•Worked closely with the Developers and Engineering Teams in the review and modification of the product and its specifications using Agile-Scrum methodology.

•Interfaced with MS SQL, Oracle for technical support.

•Database Design, Development and Implementation (includes DDL, DML and DCL).

•Created Store procedure and Trigger Plan in MS SQL Server.

•Developed test data and test hardness using MS SQL, Oracle 11g and Excel as back end and VBScript and JavaScript as front end Test.

•Worked as a part of a team and provided 7x24 supports in database management.

•Performed Load, Stress, Volume and performance testing of the application using HP Load Runner and JMeter.

•Extensive experience with development and test including Agile and Test Driven Development.

•Conducted Users’ Acceptance (UAT) and participated in defect review status meetings.

Environment: ASP.NET, VB, C#.NET, VBScript, JavaScript, IIS, Apache, PHP, MS SQL Server 2008 including SSAS, SSIS, SSRS and ETL, PL/SQL, Oracle 11g, HTML, XML, MS Excel, QTP, QC, JMeter, Selenium IDE and RC, SOA, soapUI, WinRunner, LoadRunner (Vusers,VUGen), Unix and Linux.

University of Nantes France

10/2008 – 02/2009

Project Management

•European Master in Object Oriented Software Engineering (EMOOSE) program

•The project was done in University of Nantes, France under the guidance of the visiting Prof. Thomas Wallet. It was based on the initiation, development and implementation of Software Project Cycle including Agile and Scrum.

•Preparation of software project plan baseline, requirements, project cost, schedule, work breakdown and scheduling, resource management, work in progress, and work completed) of practical project Capita Selecta.

•Detailed design and preparation of project (above) by using MS Project Management software.

•Prepared and managed day to day activities, including the schedule of the project assigned.

•Identified the different possible project risks and possible risk management solutions.

•Took part in monitoring and Evaluation including Agile and Scrum.

Environment: MS Project Management Tool, Windows XP/Vista, MS Office, Excel. / Post: Project Lead

University of Nantes France

Duration: Oct. 2008 – Feb. 2009

Project of Library Book Keeping (Information System) software

•European Master in Object Oriented Software Engineering (EMOOSE) program.

•Project of Library Book Keeping (Information System) software: a project work of Emoose program. This was developed in Java and OOPs (Object Oriented Program) and the AspectJ concept was used.

•Designed and coded of Library Book, keeping application software in Java and Eclipse environment.

•Program development of Library Book, Keeping information system software.

•AspectJ was used in the project to validate as a crosscutting concern due to various scenarios and reservation policies that had to be validated whenever booking was performed.

•Object caching is another crosscutting concern that was implemented on a system seeking for performance optimization.

Environment: Java, JavaScript and Eclipse / Post: Project Lead

Agricultural Development Bank Ltd. (ADBL) and Asian Development Bank (ADB/Manila)

09/2007 – 10/2008

QA Automation Lead

•Project: ADBL’s CBS (Core Banking System) Procurement Project (Phase II).

•Involved in preparation of Request for Proposal /Invitation to Bid for Core Banking System of Agricultural Development Bank Limited, Nepal.

•Direct involvement/dealing with the Vendor in queries related to user’s requirements, RFP and ITB.

•Extensive experience with development and test methodologies, software CMM, including Agile and Test Driven Development.

•Reviewed business requirements and preparation of technical specification of the business requirements.

•Database Design, Development and Implementation (includes DDL, DML and DCL).

•Created stored procedures and Trigger Plans using SQL and PL/SQL statements.

•Developed test data and test hardness using MS SQL server 2005, Oracle 9i and Excel as back end and VBScript and JavaScript as front end Test.

•Performed ETL processes using MS SSIS and Informatica, analysis SSAS and reporting SSRS.

•Prepared various test plans of the project, test case and test scripts (VBScripts) maintained in QC

•Involved in Joint Application Design (JAD) session to gather requirements from all division and field offices.

•Developed and design necessary test plan and test scripts for functional and performance testing using testing tools QTP, Selenium (IDE and RC), TestNG, Nunit, LondRunner and Jmeter.

•Performed Manual and Automated testing (Data Driven, Key Driven Framework, integration, regression, system, end-to-end testing and Web Service testing) using Test Tools including QTP, LoadRunner(VUsers, VUGen), QC, and Selenium (IDE and RC) and soapUI for the application under testing and worked in an Agile testing Environment.

•Performed user’s requirement analysis and was involved in integrating of various modules.

•Performed Manual and Automated Test Tools including QTP, LoadRunner, QC, and Selenium for the application under test.

Environment: ASP.NET, VB, C#.NET, IIS, Apache, MS SQL Server 2008, Oracle, SQL, PL/SQL, HTML, XML, MS Excel, ETL Informatica, QTP, QC, VBScript, JMeter, JUnit, Selenium IDE and RC, SOA, WinRunner, LoadRunner, Unix and Linux.

AccountSoft Project, ADBL and partner institution

10/2006 – 06/2007

Project Lead

•Designed and developed user entry Screens to capture the customer orders.

•Developed windows based applications to generate various reports using Crystal Reports.

•Business components were incorporated in an application server (IIS).

•Built, developed and managed a SQL Server relational database using data warehousing.

•Created tables, indexes, views and Stored Procedures in MS SQL Server 2008.

•Maintained project plan on a daily basis and submitted project report to management.

•Developed project modules based on the given requirements.

•Arranged meetings with project management team and modified according to the Project team.

•Facilitated Integration of all the components and debugged for the final solution (Iterative process).

•Involved in Software development and tested complete Software Development Life Cycle (SDLC) of the project.

•Performed functional, and automation testing using QTP.

•Created SSIS packages to automate Import and Export of data to and from SQL Server 2005 using SSIS tools.

•Skilled in SQL 2005 Business Intelligence tools, Data Warehousing and ETL processes & strategies using SQL server Analysis and Integration Services.

•Utilized extensive knowledge in tuning SQL, PL/SQL (DDL and DML) queries to improve the database performance and availability.

•Worked as a part of a team and provided 7x24 supports when required.

Environment: ASP.NET, VB, C#.NET, IIS, Apache, PHP, MS SQL Server 2008, Oracle, SQL, PL/SQL, HTML, XML, Crystal Reports 8.5, QTP, WinRunner, JMeter, NUnit, .NET Framework.

Agricultural Development Bank Limited (ADBL) Nepal

07/2005 – 10/2006

Project Lead

•Project: Web, Mail and Database server configuration of Agricultural Development Bank Limited. (ADBL)

•Web Server Configuration and site hosting in MS Windows Server 2003 environment.

•Mail Server Configuration in Linux.

•Databases (MySQL, MSSQL Server 2008 and Oracle 9i) installation, configuration and management.

•Designed browser based Admin application for data maintenance.

•Create users and provide users right in active directory in platform windows server 2003.

•Intranet design and setup in ADBL, Head Office complex.

Environment: MS Windows Server 2003, MS Exchange Server 2003, Linux, IIS, Apache, PHP, MySQL, MS SQL Server 2008 and Oracle 9i.

Dept. of Computational Logics, Technical University of Dresden (TÜD) Germany

01/2004 – 11/2004

Data Mining and Pattern Matching

•Data Mining and Model Development Project

•JSM concepts

•Formal Concept Analysis (FCA)

•Data and Textual Data Mining technologies QuDa and Weka.

Environment: QuDA, Weka, MS Office, Excel, Power Point, Latex.

Post: Project Lead

ADBL, Central Training Institute (CTI)

12/1998 – 07/2005

IT Section Chief and Trainer

•Worked as a Section of the IT Management Faculty in CTI.

•Designed course materials and conducted computer related training program to staff of the Bank and partner offices.

•As a trainer: Computer Software (MS Office, Excel, Power Point, Access and SPSS package) and application software (ADBL Banking and Development Bank, Account software AccSoft); training the staff, researchers and partners of the Bank.

•Designed courses and instructional materials for the training program.

•Computer networking (intranet).

•Conducted Staff and Trainee database management and developed MS Office and Excel templates.

•Coordinated Statistical Data analysis of different research activities of Research Faculty.

•Publication of Annual Reports.

•Computer Software and H/W maintenance and repair.

Environment: MS Office, Excel, Power Point, MS Access, SPSS and Account Soft application software.

ADB/N. ADB/Manila, ADBL, and Central Training Institute (CTI)

07/1997 – 12/1998

Title: Project Member and Data Analyst Lead

•Project: Impact Evaluation of Sixth Credit Project

•Handled data collection, format design, format pre-test, and finalization.

•Sample design for data collection (Stratified), data collection from field clients, data validation, and compilation and interpretation of statistical data.

•Performed Data analysis and interpretation using different statistical tools and methods.

•Finalization of the report and presentation of the research findings.

Environment: SPSS, MS Office, MS Excel, and Latex.

ADB/Manila, ADBL, and Central Training Institute (CTI)

12/1995 – 07/1997

Project Member and Analyst

•Project: Effectiveness of Poultry Sector Loan of ADB/N, December 1998.

•Main responsibilities included data collection format design, format pre-test, and finalization of the format.

•Sample design for the data collection (Stratified), data collection from field clients, data validation and compilation of statistical data.

•Data analysis and interpretation using different statistical tools and methods.

•Finalization of the report and presentation of the research findings.

Environment: SPSS, MS Office, MS Excel, and Latex.

EDUCATION:

Dresden University of Technology, Dresden, Germany

Master’s Degree in Computer Science (Artificial Intelligence)

Tribhuwan University, Kathmandu, Nepal

Master of Science, in Statistics.



Contact this candidate