SUMMARY

• 6 years of experience in the field of IT 3 years of experience in the Software QA and Development
• Experience in Web Testing, Mobile Testing Windows, iOS and Android and Application Testing
• Exposure to different QA and development methodologies: Agile, Waterfall
• Hands on experience in writing test scripts, preparing test data and creating SQL scripts for testing complex data transformation
• Experience in gathering requirements from the business and creating Business Requirement Documents BRD and maintaining Technical Design Document TDD
• Familiar with the concept and application of Big Data
• Experienced in maintaining automation scripts in QTP for Regression Testing
• Experience in Data Analysis, Data Validation, Data Cleansing, Data Matching/Merging, Data Verification and identifying data mismatch
• Excellent judgment skills to identify areas of high-risk critical business areas early in an application and prioritize tasks to focus efforts on when time is limited
• Work closely with Developers, Business Analysts, and Subject Matter experts to help facilitate the quick resolution of issues / defects found during testing
• Excellent Knowledge in Defect Tracking and change request process
• Testing and Development experience in all phases and stages of Software Testing Life Cycle and Software Development Life Cycle with good working knowledge of testing methodologies, disciplines, tasks, resource and scheduling
• Work closely with Developers, Business Analysts, and Subject Matter experts to help facilitate the quick resolution of issues / defects found during testing
• Highly Motivated Team Player with the ability to lead, managed and work in all environments to meet deadlines Quick Learner with strong problem solving skills and excellent communication and interpersonal skills

TECHNICAL SKILLS

PROFESSIONAL EXPERIENCE

Confidential

Warehouse Developer

• Sole Developer from the BI group for Five major email marketing campaigns while transitioning from NCR to Exact Target as the Email Marketing service provider
• Worked directly with the business owners from gathering requirements, documenting and creating BRDs and maintained TDDs
• Responsible for designing and developing ETL maps in Redpoint in an Agile Environment
• Responsible for running and maintaining the Integration Job Automation in Production
• On Production Support Rotation every other week for EDW and UDW Analyzed and corrected any validation errors in Production via DBCR Database Change Request
• Developed framework automation / projects in Redpoint that can be used in other Projects
• Actively participated in the requirement gathering process with the business and BA
• Responsible for developing and maintaining Staging mappings for various sources flat files csv, xml, txt , tables in SQL Server
• Created and maintained tables in SQL Server Used User defined Data Types Triggers
• Designed and developed mappings with complex transformation rules in Redpoint Used Parameters in the mappings and successfully generalized the mapping for other data points
• Responsible for creating Test Data for Unit and Integration Testing and documenting the results for future reference in Excel Participated in Code Reviews and mapping reviews
• Backfilled Lead QA position and lead a team of 3 for the data migration from the Salesforce to CRM Project Reported and reviewed the defects in JIRA defect tracking system
• Used Selenium to automate the process of creating data at CRM side for Begin-to-End testing
• Performed End-to-End functional testing on the new CRM system all the way to the reports
• Worked closely with the Business Users and the BA to lead the User Acceptance Testing for the Salesforce to CRM migration project Educated users on MS CRM

Confidential

QA Data Analyst

• Responsible for the Quality Assurance of the new Unified Data Warehouse and Enterprise Data Warehouse Lead a team of 3
• Designed and Developed framework for automated regression tests for the Enterprise Data Warehouse in SQL Server 2008 saving manual effort and time on regression testing
• Created Test Plan and Test Report for every scheduled release Provide QA estimates
• 30 allocated to myLT project which included web and mobile testing for the myLT website
• Participated and contributed in creating a QA Process in the project with the senior QA
• Worked with the Sr. Data Architect to create the templates and patterns used in ETL and database structure for the new data warehouse
• Tested system's Data Cleansing, Person Matching and Merging for accuracy, consistency and uniformity Tested the Person Match Web Services using Soap UI
• Performed extensive testing on the mappings and wrote queries/scripts in SQL to validate the data across different tables in the data warehouse in SQL server 2012 /2014
• Reported and reviewed the defects in JIRA defect tracking system Explained found defects to the development team to avoid repeat error

Confidential

Quality Assurance Consultant

• Responsible for monthly scheduled release testing of new database structure and ETL code for the Enterprise Data Warehouse and Cognos Report
• Solely responsible for the scheduled release testing of the database structure and ETL code for the Financial Data Warehouse
• 25 allocated to executing test cases for regression testing for the LTF Suite in house built Application based Member Management System team for the month release
• Responsible for Production Support including investigating any data anomaly reported by business and logic errors in the existing code
• Responsible for product maintenance testing and worked on Ad-hoc report sql queries requested by the business
• Analyzed and reviewed the user/business requirements and functional specification documents
• Created and Executed complex SQL queries to fetch data from a source table in SQL Server database server to validate and compare expected results with the actual records in the target table
• Back filled the QA position for the LTF Suite team In house developed Windows based Member Management System
• Tracked and maintained defects using HP Quality Center with details and example for the defect Completed follow up of the defect backlog and drove prioritization efforts as needed.
• Developed and maintained regression tests for Data Warehouse in SQL Server 2008 and Cognos Reports and stored them in QC

Confidential

Subordination Specialist

• Worked with borrower's second mortgage lenders to obtain the subordination agreement
• Created daily, weekly and monthly reports on the progress of each team members and the department as a whole for the upper level managers using MS Excel and Visual Basic Editor
• Participated in the requirement gathering process with the BA for the new and improved web application application
• Participated in UAT testing as an end user
• Verified subordinating lender's requirements and submit the request with the required documents
• Followed up with the subordinating lenders on a weekly basis for the status of the subordination requests and update LPS and the loan processors
• Ensured that all liens on the Title policy are correctly documented and work with title agents in revising a title if a lien is missing and/or paid off lien is present
• Received Personal Best Shot Awards in the month of September 2011 and January and March 2012

Confidential

IT Consultant

• Provided technical support, both in-person and over the phone to the end users
• Responsible for software trouble shooting and installation
• Helped clients with LAN networking, Wireless Setup, and installed and maintained Residential Hall Networking
• Worked with hardware technicians technicians to support the electronic classrooms, General Access Labs, and all faculty/staff offices across campus
• Provided remote assistance when needed using Remote Desktop tools such as Team Viewer, Bomgar and MS RDA to resolve the issue remotely
• Followed proper troubleshooting steps and escalation processes detailed in the Service Level Agreements SLA and log every incident in Altiris Service Desk
• Maintained confidentiality of faculty, staffs and students information