Sql Server Manager

Professional Experience

Over thirteen years’ experience in Software Quality Assurance, System Integration, Data Analysis, Business Analysis, Development of in-house and external software projects/products working with database servers, web servers, application servers, wireless networking, data communications, and client/server software applications.

Strong experience in MS suite of tools Visual Studio, SQL Server, SQL Server Data Tools Business Intelligence for Visual Studio (Integration Services, Analysis Services, Reporting Services), Team Foundation Server, Test Manager, SQL Server Management Studio.

Experience in Database Administration, Business Intelligence reporting, High Availability and 24x7 on-call rotation to troubleshoot Production data issues. Extensive experience in application based troubleshooting in SQL server

Experience in preparation of SOPs for FarmOps and Production DBAs before the production deployment.

Strong experience in Management and Bug tracking tools Service Now, Confluence, Jira, and SharePoint.

Sound experience in architect and administrating HP ALM/Quality Center modules such as Management (previously Releases), Requirements, Test Plan, Test Resources, Test Lab, Defects, Dashboard and Version Control modules. Sound experience in automated testing and Test Management Tools like Quick Test Professional, Selenium, MS Team Foundation Server.

Experience in installing, configuring the new QA DB servers, Manage, Administering, Troubleshoot and implement the migration strategy.

Experience in AGILE SCRUM Methodology and Six Sigma Quality standards.

Developed quality assurance standards, processes, procedures and documentation templates.

Experience in Finance/ Health/Banking/Storage Value Card and Digital Marketing industries.

Strong knowledge on Data Warehouse/Data marts, Business Intelligence, OLTP and OLAP servers.

Knowledge on Project Management Body of Knowledge and expertise on reporting tools like Business Objects and MS SSRS.

Possesses strong communication skills, an adaptability to work within a variety of environments and a high tolerance for risk and stresses associated with tight deadlines.

Highly Committed, Enthusiastic, Creative team player possess good interpersonal and Communication skills. Strong Problem analysis and resolution skills.

Technical Skills:

Databases

MS SQL Server 2014, Oracle, In-Memory ExtremeDB, MySQL

Business Intelligence

SQL Server Data Tools (SSIS, SSAS, SSRS), SAP BODS, SAP BW

Automated Testing Tools

HP Quick Test Professional, Selenium, and HP Load Runner

Management Tools

ServiceNow, Confluence, MS Project, MS Visio, SharePoint, Wiki

Webservers

Tomcat, Apache, Web Logic, and IIS Web Server

Languages

C#, .Net, Java, PHP, Javascript

Other Tools

SQL Server Management Studio, Redgate SQL Compare 11, SQL Data Compare 11, Beyond Compare, TOAD, SOAP, REST, JSON, SOAPUI, MonkeyTalk, Appium, Mozilla HTTPFox, WinSCP, Cisco AnyConnect Mobility Client (VPN), RSA SecureID

Release Tools

Team Foundation Server, SVN, CVS

Operating Systems

Windows, Linux, and Unix

Trade Station Technologies, Plantation, FL Aug 2014 –Till Date

Role: Lead System Integration Test Engineer

NextGen Middle Office, Order Execution System, Data Network, Platform, GEM (Graphical Enterprise Management - Japanese Equity NextGen JPEQ product is an international Tradestation Platform to find new trade opportunities, Analyse the market, Execute the Trades, and monitor your trades specifically customized for Japanese market needs.

Classic BackOffice, OrderExecution, Data Network, Platform, BOWI (Back Office Web Interface) - US Equity – This is traditional classic TradeStation Platform easy-to-use trading platform can access from web browser to create a chart, check a price, place a trade or manage orders and positions. This platform gives streaming real-time data and lightning-fast trade execution – the same essential capabilities featured in desktop software. Trade stocks, options, or futures with our all-in-one order ticket.

Responsibilities:

Interact with product management, business and development teams on daily basis for requirement analysis and requirement gathering, design review, testing, and bug review.

Convert Business Requirement MBI into Jira stories. Collect Customer defects and Bugs into MBI and do business analysis.

Manage offshore Tokyo System Integration team to lead testing the Middle Office and Order Execution Projects.

Receive DR (Development Release) from Development team, review the code base that includes scripts, Data load and SSIS packages.

Verify the versions of the code base, validate the code base with Jira stories, Bugs and Defects. Review the code with development team if there are any mismatches.

Extensively used Visual Studio to import the SSIS packages from Team Foundation server source, review the Order of Tasks, Data Flows, Code Execute SQL Tasks, and Variables.

Developed complex SQL scripts and modified Stored Procedures to verify the data in various granularities.

Verify SSIS Projects, Packages, Meta data, parameters, properties. Used Designer Query in Editor to create views for reporting purposes.

Debugging Control flow tasks, Data flow tasks, Data mappings, Data types when errors reported in SSIS package execution report.

Performed data driven and Back end testing using SQL in testing ExtemeDB and MS SQL Server applications.

Performed High Availability checks and 24x7 on-call rotation to troubleshoot Production data issues.

Prepared the SQL Agent jobs to schedule the tasks to process SOD files, HireiHaibun, DekineResult files, EOD 1 and EOD 2 files for Integration Testing purposes.

Extensively used SQL Server Management studio features Generate Scripts, Import, Export, Shrink, Backup, Restore, Tasks and Disk Usage, Disk Usage by Top tables, Object Execution statistics on daily basis.

Performed data analysis from Start of Day (SOD) and End of Day (EOD) such as data checks in ExtremeDB, Solace Queue, OX Gateway queue, MO Gateway queue, MO Event Reader (OXArchive Stream Reader), INBQ (In-bound queue) db tables, Solace Archive db tables, ETL MRT database and History db.

Involving in releasing code to QA and Staging environments and support production DBAs for deploying in Production servers.

Used Remote Desktop Connection Manager to manage group of servers.

Manage QA and Staging Middle Office and MRT servers to support other applications such as Order Execution, GEM, platform, Data Network.

Experience in installing, configuring the new QA DB servers, Manage, Administering, Troubleshoot and implement the migration strategy.

Used SQL Profiler to monitor events in the SQL Server.

Participated in Retrospective meetings actively suggesting great ideas to improve the scrum process to achieve better results.

Extensively used Redgate SQL Compare, Redgate SQL Data compare to validate different SQL objects such as tables, views, stored procedures, Indexes, constraints and to prepare rollback scripts.

Performed on-call duties to troubleshoot Production DB server issues in trading hours.

Performed Unit level testing for DB scripts which includes stored procs, data load and versions.

Performed automation testing using Selenium suite of tools using java script for regression test cases and for sanity checks.

Developed release and configuration criteria depend testing status of Development releases.

Merged DB scripts and SSIS packages from multiple Development releases into one Change Request (candidate build). Performed releases to production servers by creating Change Requests by building staging build.

Extensively used Confluence to develop and manage Requirements, Service Now for Change Requests, and Test Manager for managing Test cases and executions, Jira for Bugs, and all other Tasks.

Extensively used Test Manager to lead System Integration Test activities including creating Test Strategies, Test Cases and project test executions for Middle Office and Order Execution Jira stories, Bugs and Customer Defects.

Designed, planned and managed data driven, manual and automated functional, system, performance, stress, regression and ad-hoc test activities.

Actively responded to the customer issues which were escalated to QA in situations where the customers were not familiar with the new application.

Participated in Sprint Planning meetings and estimated the stories accurately with proper understanding of the application.

Environment:

Microsoft Visual Studio 2012, SQL Server Management Studio, MS Test Manager, Team Foundation server, TOAD, Oracle, Redgate SQL Compare, Redgate SQL Data compare, Beyond Compare, ServiceNow, Jira, Selenium, Confluence, MS Business Intelligence Development studio, SSIS (SQL Server Integration Services), SSAS (SQL Server Analytical Services), SSRS (SQL Server Reporting Services), SharePoint, MS Visio

Sheridan Healthcare, Sunrise, FL Oct 2013-July 2014

Role: Lead BI Test Analyst

SMART Healthcare AR system: SMART portal is to mange internal billing system which controls Patient, Provider and Insurance management, Encounter creation, Claim process, Payment Processing, and to manage Sheridan healthcare master data.

Data Warehouse/BI Analytics Project is to build data marts in SQL Server by extracting data from AS400, Lawson, Misys, ADAL and other transactional servers. Develop the cubes for the various analytical purposes in Sheridan.

Health Information Exchange (HIE) Project is about integration of HL7 data from the Facilities or Hospitals for different Sheridan business processes. HL7 Data (ADT & MR’s) will be coming to Sheridan from its facilities for all line of business which Sheridan is providing to their clients or facilities.

Responsibilities:

Involved in Program and Project Management meetings to discuss the status of the Programs/Projects.

Extensively used Business Intelligence Development Studio to analyze and verify packages, cubes, and reports.

Develop Slice and Dice techniques to modify the reports in accordance with the user analysis needs.

Extensively used pivot tables to manipulate and verify the data by connect to different DW database dimension and fact tables.

Developed complex SQL scripts and modified Stored Procedures using SQL Server Management Studio (SSMS) to verify the reports in various granularities.

Extensively used Team Foundation Server to develop and manage Requirements, Change Requests, Bugs, and all other Tasks.

Interact with customers and stakeholders to simulate customer scenarios to help validate the product.

Extensively used Test Manager to lead System Integration Test activities including creating Test Strategies, Test Cases and project test executions for highly complicated applications.

Designed, planned and managed manual and automated functional, system, performance, stress, regression and ad-hoc test activities.

Conduct and manage UAT meeting with Business team and Stakeholders after the QA completion.

Proactively came up with innovative methods to improve software quality, test coverage efficiency and regression coverage.

Actively responded to the customer issues which were escalated to QA in situations where the customers were not familiar with the new application.

Participated in Sprint Planning meetings and estimated the stories accurately with proper understanding of the application.

Participated in retrospective meetings actively suggesting great ideas to improve the scrum process to achieve better results.

Scheduled reports on Daily, Weekly, Monthly and custom calendar dates basis.

Managing change management and production moves in a parallel development environment.

Environment:

Microsoft Visual Studio 2010, AS400, Team Foundation Server, Test Manager, SQL Server Management Studio, MS Business Intelligence Development studio, SSIS (SQL Server Integration Services), SSAS (SQL Server Analytical Services), SSRS (SQL Server Reporting Services), MS Project, SharePoint, MS Visio

QInteractiveInc, Sunrise, FL Feb 2006 –Sep 2013

Role: Lead QA Engineer

Contract-PriceDef - Contract, PriceDef Enhancements is to make better auditable accounting system to overcome present existing issues. Change Contract Editors (Sales, Media Buy) only to create and amend CPA, CPL, CPM and CPC contracts not edit or delete. Change the Contract editors to use new amendments table. Merge priceDef class with the new contract class.

CP-Great Plains Integration - The CP system has “purchase order” transactions that need to be entered as Payables Transactions in Dynamics GP. The process to create the payables transaction includes Import records from CP using SQL DTS, Run the CP Purchase Orders Import Integration in Dynamics GP, Export integrated records back to CP, Review the integration log file, Review the batch transactions, Post batches.

Finance – Accounts Payable - Finance Account Payable project is to reconcile each offer by client, Create Purchase Order, keep track of prepays.

Cognos Business Intelligence (BI) - The reporting portal is a web based interface separate from CP which provides business users to reports for business intelligence. Through the portal we can view reports, Create and edit ad hoc reports, schedule and distribute reports, Dashboards, personalize the portal to meet the needs.

Finance – Accounts Receivable - The Cash Application tool is used to apply incoming client payments to their applicable invoices. The tool provides the option of spreading a payment over any combination of the client's outstanding invoices as well as the ability to adjust pr void payments.

RegPath and Multi-Tenant Control Panel, IC Wall, Dynamic Path System, Vente, RJR, Memcache, Action Queue, Reports, Cron Jobs, Server Upgrades, LoadBalancer, Mobile API, Web services and Replication systems

The regpath includes the landing page, the profile page, hosted offers also called coregs(Co-Registration), Non hosted show me offers, and the non hosted up sell incentivized offers.

MCP is used to Maintain clients and contracts, Maintain objects on the reg path,Access reports, Create requests,View employee contact information and Manage various aspects of the business

Responsibilities:

Managed QA team by implementing effective testing process throughout the Software Test Life Cycle.

Involved in rebuilding QA Database Environments and refresh QA Servers from the ETL servers.

Extensively used HP Quality Center to architect, manage, build and maintain all modules of the Software Development Life Cycle.

Modify the Unix Shell scripts to dump the data depends on the application and project requirements.

Involved in meetings with business group to analyze the Product Requirement Documents.

Building Business Documents, Data Mapping, Work flow documents for the BI projects.

Built complex queries to retrieve data using Microsoft SQL Server management studio and MySQL Workbench and validate with front-end reports.

Used HP Load Runner to do performance testing of the application.

Automated Regression test cases using HP QuickTestpro and Selenium.

Verify different Client API Server functionality, Web services, Secure Servers and Mobile API.

Worked on Distributed systems such as Load Balancer, and Memcache servers.

Experience with Google Analytics to analyze the metrics.

Verify Real-time and Batch file transfers using TCP/IP, CURL, EMAIL, FTP, and SFTP using UNIX shell scripts to different client servers as well as Secure Servers.

Involved in building Regression test sets to support on-going inter dependent projects.

Involved in Sprint Planning meetings with Architect and development team to understand the Software Requirement Specifications.

Supporting Project Manager to develop Product Backlog chart from the Product Requirement Document.

Worked on decompose all product backlog items into chunks to schedule the project status on daily basis.

Involved in training other team members, developing test plan and automate the bug tracking system.

Extensively worked on cross device mobile testing using tools like MonkeyTalk, Appium.

Worked on testing Cron jobs, Action Queue, and Data Migration Script.

Extensively working on UI, Functional, Regression and Integration testing of all modules in the project.

Involved in UAT meetings and preparing checklist for the additional added requirements.

Worked on Configuration Management and Version Control using Subversion, CVS and Putty.

Worked on SharePoint and Wiki to manage business, software requirements and documentation.

Attended daily scum meetings to present the status of the project with team and discuss about any obstacles.

Environment:

HP Quality Center 10.0, HP QuickTest Professional 9.5, HP Load Runner, Microsoft SQL Server, MS SQL Server Management Studio, LAMP (Linux, Apache, MySQL, PHP), SOAP, REST, JSON, SOAPUI, Selenium, MonkeyTalk, Appium, Subversion Version Control, CVS (Concurrent Version System), Putty, Cognos, Great Plains, SQL Server, TOAD, JIRA, Java Script and Windows XP

Wildcard Systems, Sunrise, FL Feb 2005 to Jan2006

Role: Sr. QA Analyst

Simon & Base DB Consolidation Database Consolidation project is to improve systems performance and scalability, which comprises three significant modifications proven to drastically improve performance on database platform and eliminate complexity typically associated with a distributed database environment.

1. Consolidating the authorization, Settlement, Card Management and back office systems.

2. Upgrading from 32bit SQL Server Software on Dell 66509s to 64-bit SQL Server on Unisys ES7000

3. Replacing our current Dell CX600 disk subsystems, with Hewlett-Packard MSA 1500 having increased storage capacity, faster drive speeds, and number of physical disks.

Responsibilities:

Involved in SQL Server Environment test, Connectivity test, Data Loading test and perform Stress testing in the SQA Environment.

Authorization, Card Management, Batch process, fees, Embossing and BackOffice features had been tested with completion of their development by the Back Office team.

Also Reports, Statements and Settlement jobs had been tested with completion of their development by the Back Office team.

Involved in website MyAccount front-end, cardwiz back-end, Regression, Functional, System, Load and Stress Testing. Involved in testing middleware Customer Service tools such as Talon, Megaapp and servicewiz etc.

Involved in testing charge backs/settlement jobs.Retest the defects to ensure that indeed the problem has been resolved by dev environment.

Environment:

SQL Server 2000, C#, .net, VB, Java,Cold fusion, Visual Source Safe, C4, Talon, TrapperDog, Rational Clear Quest and Rational Test manager, primavera, XML, and IIS Web server.

BMC Software, Houston, TX Oct’ 03 to Jan’ 05

Role: Software Analyst

Control–SA Data martThe DataWarehouse developed extracted various volumes of data (regarding sales, marketing, contract) from different data sources which needs to be integrated and organized into a single infrastructure to calculate global inventories and have better view of product activity and performance.

Responsibilities:

Performed database testing by requesting the conflicts using SQL queries.

Tested mappings in Informatica to load the data from various sources such as Mainframe DB2 legacy data, sql server, unstructured data, into the Data Warehouse, using different transformations like Joiner, Aggregator, Stored Procedure, Update Strategy, Rank, Normalizer, Router, Lookup, Sequence Generator, Filter, Sorter, Source Qualifier, Mapplets, LookUp Caches (Static and Dynamic), XML Source Qualifier, etc.

Environment:

Mainframes, UNIX, Windows 2000, Informatica Power Center 6.2, Business Objects, ORACLE 8.1 (SQL Plus, PL/SQL), WinRunner7.5, TestDirector7.0.1 and MS Project.

Environment: Quick Test Professional 6.5, Test Director7.0, Java, Visual Basic, SQL, PL/SQL, MS Access, VB Script, Windows 2000

b-IQ Technologies, India Apr’ 99 to Aug’03

Role: Software Programmer

Clients: NetworkD, Verizon

Enterprise Software IntegrationESI is integration software for all the departments in a company. The modules involved in the project are Human Resource Management, Infrastructure Management, Library Management, Marketing Management and Finance. The system is designed to eliminate the tedious clerical work common to most personnel departments. With ESI you can quickly respond to management and employee with accurate and professional computer-generated reports.

Worked for

Responsibilities:

Developed web interface using Servlets and JSP.

Developed server side modules using JDBC to communicate with SQL Server database.Design and implement RMI using JDBC 2.0 for DB access.

Design and implement the GUI using JSP and HTML. Front page and were also used for animations and graphics. Design and develop the business logic layer using Java Servlets, JavaBeans and JDBC connections to the database. Connection Pooling was used to efficiently handle the connections to the database.

Design and implement PL/SQL Stored Procedures, triggers, view and other standalone queries needed to accomplish the data processing in the backend.

Environment: JSP 1.2, Servlet API 2.0, JDBC, Java Beans, HTML, DHTML, JavaScript, Win runner, SQL Server, Windows NT

Education: Bachelor of Engineering in Technology

Visa Status: GC-EAD (Eligible to work for any Employer)

References: Furnished upon Request

Contact this candidate