Resume

Sign in

Project Manager Sql Server

Location:
Pittsburgh, PA
Posted:
August 17, 2012

Contact this candidate

Resume:

PREETY TAKKAR

QUALITY ANALYST

SUMMARY:

• Experienced in Quality Analyst manual testing using HP Quality Center 11.00 Enterprise Edition and Aegisoft Issue Tracking- Jira

• Experience with TRDA (Thomson Reuters Dealing Aggregator) product features including Totalizer, Montage and Ledger

• Has worked as a QA Lead and managed a team of 5

• Experienced in Web and application development, Database design, Entity Relationship model and application oriented design in SQL Server 2005

• Experience with HP Quick Test Professional in creating VBScripts to automate test cases

• Experienced utilizing Quality Assurance methodologies and processes within QA

• Proven understanding of the Software Development Lifecycle and Quality Lifecycle

• Strong expertise in MS SQL Server suite of products like SQL Reporting services (SSRS), SQL Integration services (SSIS)

• Extensive experiences in developing Stored Procedures, Views, Triggers, XML and Complex Queries on SQL Server 2005

• Worked on Windows Server, XP and IIS 5.0/6.0

• Solid exposure in creating SQL server Reports using SSRS 2005

• Develop and maintain existing application components developed in HTML and CSS

• Experience in handling and generating drill down reports, parameterized reports in SSRS 2005

• Proficient in working on Rational tools including Rational Clear Case, Rational Clear Quest and Rational Requisite Pro

• Expertise in Microsoft Visio software to design Business Process Modeling, process flow diagrams and work flow diagrams.

• Experience with Web Usability testing, assessment, redesign and rapid prototyping

• Expertise in Microsoft Visio software to design Business Process Modeling, process flow diagrams and work flow diagrams

• Worked on Microsoft Reporting Analysis

• Experience in managing alerts, operators and jobs through SQL Server Agent

• Experience in data loads, database integration/conversions, performance tuning and optimization

• Experience in troubleshooting database issues

• Performed database backup/recovery

• Excellent verbal and written communication skills combined with interpersonal and conflict resolution skills and possesses strong analytical skills

TECHNICAL SKILLS:

TOOLS:

MS Office, Microsoft Project, Visio, Adobe Photoshop, InDesign

Rational Requisite Pro, HP LoadRunner 8.0,

Mercury Quality Center 9.0, AEGISOFT JIRA,

HP Quality Center 11.0, HP Functional Test (QTP) version 10.0

OPREATING SYSTEM:

Linux (RedHat 4.0), Windows (9x,

2000, NT, XP, Vista, 7x), Solaris 10.0,

Leopard 10.5.2

DATABASES:

SQL Server 2005, MS Access,

ERWIN, MS Visio 2003, rational rose,

SQL Reporting Services 2005,

RUP (Rational Unified Process),

Waterfall method, Business and Data Modeling

LANGUAGES:

PL/SQL, Embedded SQL, HTML, CSS

Java Scripts, VB 06, VBScript,

VB.Net, PerlScript

SAP PRODUCTS:

SAP Exchange Infrastructure

(XI 3.0), SAP Enterprise Portal

(EP 7.0), SAP NetWeaver Process

Integration (PI 7.0), SAP ERP

Central Component (ECC), SAP

Customer Relationship Management

(CRM), SAP Solution Manager 4.0,

WEB TECHNOLOGY:

Export, Import, Load, DB2MOVE,

HTML, DHTML, XML,

Adobe Photoshop, DreamWeaver,

Flash, FrontPage

EDUCATION

• Masters in Information Technology, Rochester Institute of Technology, NY

• Bachelors in Information Technology, Mumbai University, India

CERTIFICATIONS:

Microsoft Certified Professional (MCP) – Microsoft SQL Server 2005 Implementation and Maintenance

IBM Certified Database Associate for DB2 Universal Database V8.1 Family

IBM Certified DB2 UDB V8.1 Database Admin for Linux, Unix & Windows

WORK EXPERIENCE:

Philips Respironics Monroeville, PA Feb 2012-August 2012

Data Analyst-Design V&V

Responsibilities:

• Developed and remodeled Access 2010 database

• Edited and ran SQL database scripts used for company merges

• Worked on scrum agile team

• Implemented scrum techniques

• Worked on dry-run and formal testing

• Worked on smoke testing on weekends

• Performed before, after and dry run testing on different release candidate builds

• Involved in System, Integration and Functional testing

• Used Visual Studio Test Suit to perform Functional testing and added PBI and tasks to the team project

• Worked on EPDE (Encore Patient Data Exporter) utility using different parameters

• Have gained domain knowledge about EncoreAnywhere, EncorePro, EncorePro Bulk Patient Data Import, EPDE (Encore Patient Data Exporter), EPDEsq (Encore Patient Data Exporter using SQL) and company merge database testing

• Wrote V&V test procedures

• Ran automated test scripts to create companies

• Created SQL Queries including Joins

• Edited and executed SSIS packages

• Created test sets in test lab

• Executed several SQL queries to perform database testing

• Worked closely with developers in identify database issues and fix defects

• Tested CPAP devices and made modem calls

• Generated patient data using CPAP devices and tested it on database

• Completed SAP training

• Checked documents in SAP

• Signed documents using digital signature in SAP

• Created and reported defects in Team foundations server (TFS) found during testing and ensured that reported defects were fixed

• Performed database performance testing

• Wrote, Reviewed and executed Test Cases as per the Product requirements in quality center

Environment: HP Quality Center 9.2, Microsoft SQL Server 2008, Visual Studio 2010, EncoreAnywhere, EncorePro, EPDE, EPDEsq, TFS 2010, Agile- Scrum Methodology, CPAP devices, SAP Logon 710

Thomson Reuters Pittsburgh, PA Apr 11-Dec 11

Quality Analyst

Responsibilities:

• Developed 254+ test cases in Quality Center Test Plan based on test specification

• Executed test cases in Quality Center Test Lab and performed manual testing

• Created bug tickets in Aegisoft Jira

• Gathered market data on live exchanges including LSE (London Stock Exchange), ISE (Irish Stock Exchange)

• Performed regression testing after the development of the product

• Added broker limits for each exchnage in Risk Management GUI

• Tested market data for several exchanges including BMF (Brazillian Stock Exchnage), CME (Chicago Mercantile Exchange), NYSE, NYSE ARCA, ICE (IntercontinentalExchange), NASDAQ, BATS (Better Alternative Trading System)

• Worked on TRDA (Thomson Reuters Dealing Aggregator) product features including Totalizer, Montage and Ledger

• Filed bugs in JIRA (Defect tracking tool)

• Documented bug report

• Worked with developers to understand new features and bugs to be tested in releases

• Developed and executed SQL queries to retrieve data from MGH (Market Gateway Hub) database

• Created basket and breakup orders from montage in TRDA

• Created orders using different algorithms including Stop Loss, Take Profit, Athena Iceberg, Pegging, Reserve, Aggressive Watch, Reserve, VWAP, WorkBalance(Aggressive), WorkBalance(Passive)

• Effectively worked with Business Analysts and product manager to gather requirements

• Effectively worked with developers inidentifying the defects in the product

• Achieved deliverable milestones by meeting project deadlines

• Experienced working with global end-user base

Environment: Mercury Quality Center 9.0, HP Quality Center 11.00 Enterprise Edition, Aegisoft JIRA, Microsoft SQL Server 2005

Lions Medical Center/High Field Imaging,Pittsburgh, PA Jan 10- Jan 11

QA Analyst

Responsibilities:

• Develop and maintain existing application components developed in HTML and CSS

• Developed and coordinated test plans and performed functional testing

• Created test scripts based upon specification documents

• Manage test envioenment and performed integration testing

• Performed validation testing at the end of the product release

• Conducted smoke and sanity testing

• Develop and maintain design documents

• Performeed cross-browser, cross-platform software testing

• Develop architecture-level and detailed technical design specifications for functional requirements

• Created and deployed SQL Queries

• Performed Web Usability testing, assessment, redesign and rapid prototyping

• Presented results of web usability analysis with key findings and recommendations

Environment: HP Quality Center 9.0, MS SQL Server 2005, MS Visio 2007

Marlabs, Inc, Pennsylvania, USA Mar 08-Jun 09

QA Analyst

Responsibilities:

• Developed various reports like Tabular reports, drill down reports, maps and charts.

• Performed Backup/recovery tasks, monitored performance and optimized SQL queries for maximum efficiency

• Developed functional specifications for technical analysis of testing

• Effectively worked with Business Analysts and product managers to gather requirements

• Tracked issues during UAT (User Acceptance Testing) throughout QA lifecycle

• Executed SQL queries to extract data for testing purposes from the product database

• Achieved deliverable milestones by meeting project deadlines

• Maintain test scripts for regression testing that covered front end and back end validations

• Created VB Scripts using HP Quick Test Professional

Environment: MS SQL Server 2005, Mercury Quality Center 9.0, HP Functional Test (QTP) version 9.0, VBScript

Upper Monroe Neighborhood Project, Rochester,NY Apr 07 – Dec 07 Assistant Project Manager

Responsibilities:

• Organizing, monitoring and coordinating the work of six different organizations working for the upper Monroe neighborhood group in Rochester and reporting the findings to the president of the association

• Development of risk management plan

• Developed Marketing plan

• Performed Urban Planning

• Developed Charrette Committee Structure

• Evaluated current practices of the subcommittees

• Conducted SWOT analysis

• Conducted Usability Analysis

• Conducted record keeping and report writing

• Developed website for the organization

• Documented project management plan

• Documented the recommended changes by producing written rationales

Environment: Microsoft Word 2007, Microsoft Excel 2007, Microsoft PowerPoint, Microsoft Project 2007, Visio 2003, Macromedia Dreamweaver 9.0

M.T.N.L (Mahanagar Telephone Nigam Ltd) - Mumbai, India Dec 04 – Jul 05

Intern

Responsibilities:

• Worked with Computerized CSMS System (Customized Subscriber Management System)

• Worked with integrated Commercial billing system

• Worked with pre-connection and post-connection telephone services

Environment: Microsoft Word 97/2003, Microsoft Excel 2003, Microsoft Project 2003, MS Visio 2003

New Jolly Tours & Travels- Mumbai, India Jul 04 – Aug 04 Training

Responsibilities:

• Worked as a Project Manager for Information Technology infrastructure and Customer Relationship Management

• Worked with accounts LAN server

• Maintained accounts

• Maintained invoicing information receivables from customers.

Environment: Microsoft Word 97/2003, Microsoft Excel 2003, Microsoft Project 2003, MS Visio 2003, Microsoft Access 2003



Contact this candidate