Micheal Angelo Varma
Sterling,VA
Summary
Over 16+ years of rich software industry experience in manual/automation testing and development. A very good team player with excellent Communication (Verbal, Written and Technical) skills. Verticals include Capital Markets, Human Resources, Healthcare. Commercial Insurance Extensive experience in developing Automation Testing framework, Test Strategy, Testing tools and test scripts. Experience in Testing BI Reports and ETL tools. Organized and dependable candidate successful at managing multiple priorities with a positive attitude. Willingness to take on added responsibilities to meet team goals. Hardworking and passionate job seeker with strong organizational skills position. Ready to help team achieve company goals. To seek and maintain full-time position that offers professional challenges utilizing interpersonal skills, excellent time management and problem-solving skills.
Overview
17
17
years of professional experience
Work History
Technical Architect
Hexaware Technologies, USA
Reston, VA
01.2015 - Current
- Experience in AWS environment with proficiency in AWS Services (VPC, EC2, Fargate, CLOUDFORMATION, S3, RDS, IAM, CloudWatch)
- Extensive working knowledge in UNIX and Windows platforms
- Created and deployed ETL test framework in cloud using Fargate/EC2 services
- Experience using CI/CD pipeline with Jenkins
- Experience in remote code repository Bitbucket
- Extensive experience in ETL/ Data warehouse backend testing and BI Intelligence reports testing
- Performed Testing using SOAP and RESTful Web Services using POSTMAN and SOAP UI
- Experience in Behavior Driven Development (BDD) along with Cucumber and TestNG approach for test automation frameworks using Gherkin
- Extensive development and ETL testing experience using Informatica PowerCenter (Designer, Workflow Manager and Workflow Monitor) and SSIS
- Test Data Preparation for testing various ETL, BI reports and Web based applications
- Worked on Data Driven and Hybrid Testing
- Experience in Unix shell scripting and configuring cron-jobs for informatica sessions
- Experience in analyzing Business, Functional and Technical Specifications
- Developed SQL queries /scripts to validate data such as checking duplicates, null values, truncated values and ensuring correct data aggregations
- Extensive experience in developing SQL scripts to validate databases tables and reports data for backend database testing
- Proficient in troubleshooting SQL scripts issues and tuning long running queries
- Business Intelligence testing in various reports using MicroStrategy, Tableau
- Worked in creating and integrating MicroStrategy reports and objects (Attributes, Filters, Metrics, Facts, Prompts, Templates, Consolidation and Custom Groups) with data warehouse
- Involved in User Acceptance Testing (UAT) and Training of end users
- Participated in cross-functional teams to reengineer and improve business processes
- Experienced in working within fast-paced Agile/SCRUM systems maintained by JIRA
- Participated in Agile Scrum meetings, Daily Standup, Sprint Planning, Sprint Grooming and Sprint Review
- Created ETL test data for all ETL mapping rules to test functionality of Informatica graphs
- Testing XML files and validating data loaded to staging tables.
- Performed quality code review and removed technical debt and security vulnerabilities.
- Spearheaded adoption of cloud-based technologies, enabling faster deployment and scalability for various applications.
- Collaborated with cross-functional teams to design and implement effective software solutions, resulting in increased customer satisfaction.
- Resolved complex technical issues by troubleshooting systems, analyzing root causes, and implementing effective fixes.
- Reduced testing timeframes by automating repetitive tasks using industry-standard tools.
- Improved system performance by analyzing bottlenecks and implementing effective solutions.
- Developed expertise in multiple ETL tools, increasing flexibility in supporting diverse project requirements.
- Monitored resolution of bugs, tested fixes, and helped developers tackle ongoing problems by providing QA perspective.
- Operated under Agile and Scrum frameworks to complete releases and well-organized sprints.
Senior Software Engineer
Hexaware Technologies
Chennai, India
07.2010 - 12.2015
- Business Intelligence testing in various reports using Cognos and SSRS
- Experience in Functional, Regression and System testing using Manual and Automated testing tools using Selenium
- Experience in Data analysis, Data Validation Data Cleansing Data Verification and identifying data mismatch
- Back End Testing experience by writing and executing SQL Queries
- Experience in writing Path to locate web elements and xml files
- Worked on Databases Oracle, SQL Server, and Teradata
- Worked on projects that followed Agile process
- Extensive working knowledge in UNIX & Windows platforms
- Experience using query tools for Teradata, Oracle, DB2 and MS SQL Server to validate reports and troubleshoot data quality issues
- Worked on issues with migration of Data from development to QA-Test Environment
- Extensively tested several Cognos reports and Dashboards to validate reports data and cosmetics of reports
- Developed ETL test scripts based on technical specifications/Data design documents and Source to Target mappings.
- Demonstrated respect, friendliness and willingness to help wherever needed.
- Passionate about learning and committed to continual improvement.
- Managed time efficiently in order to complete all tasks within deadlines.
- Enhanced ETL processes by optimizing complex SQL queries and streamlining data extraction procedures.
- Managed data quality issues during ETL processes, directing qualitative failures to team lead for amelioration.
- Increased data accuracy by implementing thorough validation checks and error-handling mechanisms.
- Trained in coding for numerous Data Warehousing solutions.
- Wrote and optimized in-application SQL statements.
- Designed and developed analytical data structures.
- Conducted thorough testing of reports, dashboards, and universes to guarantee accurate results and optimal performance.
Software Engineer
Accenture Services Pvt. Ltd, Chennai
Chennai, India
03.2007 - 06.2010
- Understanding business requirements and Analysis of the specifications provided by clients
- Extensively worked with flat files and excel sheet data sources
- Wrote scripts to test flat files data in databases, Scheduling, and automating jobs to be run in batch process
- Tested several complex ETL mappings, mapplets and reusable transformations for daily data loads
- Developed SQL queries /scripts to validate data such as checking duplicates, null values, truncated values and ensuring correct data aggregations
- Performed data quality analysis using advanced SQL skills
- Ensured Error logs and audit tables are generated and populated properly
- Preparing ETL STM (Source to target Mapping) documents
- Developed ETL test scripts based on technical specifications/Data design documents and Source to Target mappings
- Identifying Test Approach to be followed for modules to be tested
- Preparing Test Cases, SQL Queries and Test Data
- Test execution, Logging, Retesting and closing defects
- Preparing test execution summary
- Involved in executing Unit Testing
- Involved in doing mappings in Informatica 8
- Reviewing work products developed by peers.
- Improved software quality by designing and executing comprehensive test plans and cases.
- Ensured compliance with industry standards by diligently following established protocols during all stages of manual testing.
- Managed defect tracking systems, ensuring accurate documentation of issues for efficient resolution.
- Reduced product defects by performing thorough manual testing and identifying issues before release.
- Designed testing scenarios for usability testing.
- Reviewed requirements, specifications, and technical design documents to provide timely and meaningful feedback.
Education
Master of Computer Applications -
Annamalai University
Chidambaram, India06.2010
Bachelor of Science - Computer Science And Programming
Manonmaniam Sundaranar University
Tirunelveli, India03.2006
Skills
ETL Testing, Cucumber with Java/Ruby, Selenium with Java
SQL, Python, Java, Ruby, VB Scripting, Net 11
PostgreSQL 802, Aurora 1365, Oracle 9i/10g/11g/19c, DB2 81/92, SQL Server 2005/2008, Sybase, Netezza 70, DB2
Tableau 201914, Cognos 101/83, MicroStrategy 111 (Web/Desktop)
Postman 614, Smartbear SoapUI 54
Toad Datapoint 42, DBeaver 21, Aginity Workbench 43, Advanced Query Tool 82, Sybase Central 6, Sybase Interactive SQL 11, WinSCP 519, Putty 072, Lotus Notes 6, Rational Requisite Pro
Informatica 81/11, SSIS 10, Alteryx Designer 2018, Talend
Capital Markets, Human Resources, Healthcare Commercial Insurance
Work Permit Status
H1B – Sponsorship Required.
Residence Address
24695 Pantzlaff Farm Terrace, Sterling, VA, 20166
Timeline
Technical Architect
Hexaware Technologies, USA
01.2015 - Current
Senior Software Engineer
Hexaware Technologies
07.2010 - 12.2015
Software Engineer
Accenture Services Pvt. Ltd, Chennai
03.2007 - 06.2010
Master of Computer Applications -
Annamalai University
Bachelor of Science - Computer Science And Programming
Manonmaniam Sundaranar University