SUMMARY

• A professional with 8+ years of extensive IT experience in Manual Testing, Automation Testing, Database Administration, data architecture including data ingestion, data modeling and data mining.
• Adroit at analysing data, system requirements, assess business rules, collaborate with stakeholders and perform source - to-target data mapping, design and review
• Proficient in Data cleansing including standardization, removing duplicates, matching and Repair
• Working knowledge of SQL tuning using concepts like Explain Plan, Hints.
• In-depth understanding of security and backup procedures to ensure database integrity. Background in developing backup and disaster recovery plans.
• An expert in leading teams to successful project implementation with proper management, scope containment and quality assurance.
• Hands on experience with Manual and Automation Testing, Oracle DBCA, SQL Server Enterprise Manager, Windows Server 2008 administrative tools, Confidential Application Administration, Toad, Unix (IBM AIX, HP UX, RHEL, Solaris), Remedy, WinStep, Elite, Product Studio, JIRA,, Hadoop Pig, Python Pandas, HIVE, Tableau, Sqoop,
• Abreast with Machine (Supervised and Unsupervised) learning and advanced data processing techniques like Decision Trees, Neural Networks, KNN, PCA, Text and Sentiment Analysis, Qlikview,Naive Bayes, etc
• Familiar with R Programming, Python Scikit, Pandas,Agile Methodologies
• Mentoring and guiding the team players in performing the basic operations in UNIX. Making knowledge repositories for training new employees in the unit.
• Superior communication, presentation, analytical and problem solving skills.

TECHNICAL SKILLS

Programming Languages: R, Python, Java, Java Design Patterns, Unix, C, UML

Data Science Techniques: Linear Regression, Logistic Regression,Time series, Decision Trees, Neural Networks, KNN, K-Means, PCA, Text and Sentiment Analysis, Market segmentation analysis etc.

Tools: Toad,Putty, Star UML, Oracle(DBCA),Windows Server 2008 Administrative tools, SQL SSMS,SSRS

Software: Eclipse, IntelliJ, R Studio, Confidential, Jupyter Notebook, PyCharm, Anaconda, Tableau 10.5, Qlikview

Version Control: SourceTree,Git, Confidential TFS

Scripting/Modelling Languages: HTML, XML, UML

Testing Framework: JUnit

Database: SQL Server 2008 r2. SQL Server 2012, Oracle 10,11g

Bug tracking tools: JIRA, HP Quality Center, Remedy, Firestone

Methodologies: Agile, Waterfall

PROFESSIONAL EXPERIENCE

Senior Test Analyst

Confidential

Responsibilities:

• As Test Analyst, participated in review meetings conducted for System requirement specification, Functional requirement specification.
• Lead the analysis, Clarification calls, design, Test planning and control of the various payment systems and its testing environment databases.
• As DBA, set up test beds, necessary data creation, and backend setups etc for the test execution which involves importing scripts, Placing config .xml files creating necessary directories for file uploads in the backend..
• Analyzed the Specifications and involved in identifying the source data needs to be moved to data warehouse.
• Coordinating the Offshore/ Onshore team with respect to QA activities.
• Bridging the gap between the offshore and onsite team by communicating the latest updates from onsite team.
• Preparing Test Plan and test metrics, Test Cases and approving the same.
• Preparing status report and reporting.
• Performing Functional Testing, Integration Testing, System Testing, Exploratory Testing, Performance Testing and Regression Testing, Localization Testing.
• Generated tractability Matrix to ensure that all the requirements are covered by the test cases.
• Performed database testing with SQL queries to verify data integrity.
• Assigning and managing the bugs in Defect Tracking Tool.
• Preparing System Test Readiness Report.
• Well exposed to SDLC (Software Development Life Cycle) and Test methodologies.
• Configured the QA Environment for Manual Testing as well as Automation.
• Creation of automated test scripts using IBM RFT.
• Wrote SQL queries to test for multiple needs of XML
• Loading Flat file Data into oracle tables using Unix Shell scripts
• Involved in Database testing by writing & executing SQL & PL SQL queries using ORACLE SQL Developer, TOAD to validate that data is being populated in an appropriate tables & manually comparing the results with front-end values.
• Worked with XML transactions for multiple feeds
• Wrote SQL and PL/SQL scripts to perform database testing and to verify data integrity.
• Utilized Firestone, Jira for Tracking and Reporting Defects, which are assigned to developers. Designed and developed Test Plans, Test Scripts and Test Cases in
• Providing testing inputs to the Project team (Project manager, Planner and the Development lead) during the Planning sessions to finalize the Work Breakdown structure (WBS).
• Retesting the scenarios for which bugs have been raised and closing them after successful execution.
• Raising critical bugs and Working simultaneously with engineering team to take them to closure with proper fix.

Environment: AIX 6, Oracle 11g, HP UX, Firestone, Toad, TFS

Project Engineer

Confidential

Responsibilities:

• Monitoring the servers for any Hardware/SQL/IIS issues, keeping the servers in healthy condition and make sure all SQL jobs are running fine on servers without having any revenue loss to Confidential .
• Ensuring all the services are running fine on the server so that the front end applications are available all the time. Restarting the services if necessary.
• Verifying the error logs in event viewer and troubleshoot accordingly.
• Installing the MOM agents on the unmanaged servers (for Windows 2003)
• Ensuring appropriate monitoring agents are installed on the servers and collaborating with monitoring team to uninstall and install monitoring agents.
• Engaging site service support in case of hardware failures on servers and having them fixed within time without impacting the business
• Monitoring the performance, CPU, memory utilization of the servers 24 X 7 and troubleshoot accordingly to keep servers in healthy state.
• Monitoring of databases remotely by regular backup checks and database availability.
• Administering SQL Server Production Database Servers. Mainly working with the SQL Server 2000, 2005 and 2008.
• Monitoring the jobs configured on SQL servers and ensuring the jobs are running properly.
• Troubleshooting the issues on Replication /Log Shipping/Backup & Recovery /Mirroring.
• Taking log backups of the databases in case of drive space issues
• Managing the disk space on the servers.
• Handling repetitive issues, identifying High Volume Incident Drivers. Collaborating with property for the same and creating white boards, bugs etc.

Environment: SQL server, Confidential Windows Server 2008