SUMMARY

• 19+ years of combined IT experience in system analysis, development and in Quality Assurance of AWS, Big Data, Salesforce, ETL, Client/Server, Network and Web based applications. Looking for a career opportunity where I can utilize my skills, technically working with leading industry automated tools like Selenium, SOAP, Rest API and UFT to design, develop and maintain automation suites needed to perform regression testing to ensure that the product is defect free and is above and beyond the customer’s expectation and managerially, to lead a team to achieve the end user requirements, and mentoring the teams members as needed.
• Involved in Preparation of Test Plans, Test Cases and Test Scripts.
• Well experienced in Test planning, documentation, defining and executing the test cases using automated tools as well as manual Tools.
• Good experience in Servers JBoss, BEA Web logic, Tomcat.
• Proficient in QA processes, test strategies, and in performing Functional, GUI, Regression, Database, Integration, Stress, Validation and Performance testing
• Assisted in creating test cases using HP - ALM-Quality Center, Version One, JIRA
• Involved in converting manual test cases into automated scripts on Mercury’s Win Runner, Quick Test Pro, Selenium and Rational Robot.
• Good knowledge in J2EE, EJB, ASP, VB, .NET, Git Eye
• Strong skills in SQL, PL/SQL and UNIX (Solaris, Linux)
• Good knowledge of creating shell scripts in UNIX based environments.
• Work experience in writing and using Stored Procedures and Triggers.
• Good Knowledge in RDBMS like Oracle, Sybase, MS-SQL Server, MS-Access
• Good Knowledge in DevOps, Agile and Waterfall methodologies and Pipeline Regression Automation Process.

TECHNICAL SKILLS

Big data: Hadoop, Spark, Presto. HBase, Zeppelin, Oozie, SQL, Hive, Pig, SQOOP, Domino, Dremio, Tableau

Salesforce: experience in integration, implementation and integration. Skilled in creating functional dashboards and reports

Operating System: Win XP Professional, Solaris, Linux, AIX, RHEL

Databases: SQL Server 2000, Oracle, MySQL, Postgres, Amazon Aurora, AWS Redshift

NoSQL Databases: Amazon Dynamo DB, MongoDB, ElasticSearch, Memcached, Redis

Application severs: J Boss, J Run, Web logic, Web sphere, MQ, Apache Tomcat

Web servers: Apache, Nginx

Federation servers: Active Directory, Amazon Cognito

Languages: Java, JavaScript, PL/SQL, Perl, PHP, Python, JSON, Groovy, HCL, XML, Bash, YAML, Boto3 Python AWS SDK, AWS CLI

e-CRM/CRM tools: Brick street Connect, KANA Response, Kana Response Live 8.x,9.x, Kana IQ, Kana Enterprise

ETL: Informatica, Pentaho, DataStage, Amazon Redshift

CI/CD tools: Chef, Puppet, Ansible, Docker, Vagrant, Terraform, AWS CloudFormation, AWS Code*

Version control & build tools: Git, GitHub, Bitbucket, Gitlab, Bamboo, SourceTree, MS visual source safe

Ticketing tools: JIRA, HP Quality Center, Service Center

Frameworks: Waterfall, Agile, Scrum, Kanban, TDD, ATDD BDD, DevOps, CI/CD

Automated Test Tools: HP ALM, Quick Test Pro 10.0, EMPIRIX Test Suite (e-Tester, e-Load), Rational Robot, Test Manager, Clear Quest. UFT, Selenium

Business Tools: Tableau, Oracle BI, Splunk, Crystal Report, MicroStrategy, Doors,Version One, Jira

Java Technologies: J2EE Arch., JDBC, Java Server Pages (JSP), Servlets, Java Beans, EJB, AWT/Swing, Java Applets, XML.

Operating Systems: Windows (XP/2000/NT), UNIX (Linux 7.2/8.0, Fedora), Novell NetWare 4.11, Apple macOS, Android, Apple macOS, Linux, Android, Solaris

RDBMS: Oracle10.X, Sybase, MS-SQL Server2005, DB2. Amazon RDS (Aurora,PostgreSQL,MySQL,MariaDB,OracleDatabase, andSQL Server) Languages Python, Java, C, C++, C#, SQL, PL/SQL, SQA Basic, Shell Scripting.

Web application Servers: IIS 4.0, Java Web Server 2.0, Tomcat 4.x.

PROFESSIONAL EXPERIENCE

Confidential, McLean, VA

Test Lead/SME/Business Analyst

Responsibilities:

• Implementedand managing testing team to performed AWS Cloud platformand its features which includes EC2, VPC, EBS, AMI, SNS, RDS, EBS, Cloud Watch, Cloud Trail, Cloud Formation AWS Config, Autos calling, Cloud Front, IAM, S3, R53, Security group for Public and Private network, NACL and define the roles-based permissions (IAM) and setting up different accounts (environments for Dev, QA and Prod). Proficient with container systems likeDockerand container orchestration likeEC2 Container Service,Kubernetes, worked withTerraform.
• ManagedDocker orchestration and Docker containerizationusingKubernetes
• Testing created public and private subnets, route tables, IGW, allocation of IP address and EIP and provisioning the web application, DB services, application on appropriate subnets and confiture the NAT gateway, inbound and outbound rules based on application for in/out traffic
• Responsible for Data Engineering team and Technical interaction with client for Sign off on design docs and upfront provide tech. solutions if technical challenges for team
• As a Test Engineer/Lead designed and developed Test Plan, High level and Detailed Test Cases based on the available use cases
• Used DOORS to verify the requirements during Test Case development
• Worked closely with business engineers when reviewing the business requirements and in writing and reviewing the Test Cases
• Interacted with team members for reviewing test plans and test cases
• Prepared the data for integration and end-to-end testing
• Performed manual system testing for the applications
• Switched between different work requests depending on the priority
• Used HP ALM for logging the defects encountered while running the test cases
• Interacted with developers when revalidating bugs
• Used DB2 to perform backend validation
• Provided assistance during the manual to automated turnover of the test cases
• Worked with different Systems such as Quantum, CCTS, CSP, LP, PE, SAP and PEF during integration testing
• Performed regression testing of the application using UFT and Selenium
• Mentored the new team members about the Selling System
• Worked closely with QA Manager during integration testing periods to discuss strategies and the status of the testing

Confidential, McLean, VA

Big Data - ETL, Automation System Test Engineer

Responsibilities:

• Reviewing the ETL Mapping sheet and identifying the test scenarios
• Written Test Cases for ETL to compare Source and Target database systems.
• Involved in creation/running of high-performance jobs through Expertise in ETL testing experience usingMSBI (SSIS - SQL Server Integration Services, SSRS - SQL Server Reporting Service)to generate test data.
• Creation and testing of spark jobs using python to process source files from S3 to RDS (Arora) and S3 destination, responsible for AWS Lambda function based on events through (S3, Cloud Watch logs, SQS, SNS to trigger / Spin up EC2 instances through EMR cluster and Submit the Spark (Scala) programs by STEP function and build the server less Architecture Solutions and Using STEP functions Services for orchestration.
• Have performed the below activities as part of ETL testing:
• Make sure that data transformation from source to destination works as expected, verify that expected data is added in target system.
• Developed Test Scenarios and Test Data
• Developed automation scripts using Win Runner, Load Runner, Astra Quick and Conducted Web Testing for hyperlinks and navigation
• Executed manual and automated test cases and verified results with expected results
• Developed automation scripts using Win Runner, LoadRunner, Astra Quick and conducted web testing for hyperlinks and navigation
• Executed manual and automated test cases and verified results with expected results
• Responsible for weekly status updates showing the progress of manual and automation testing

Confidential, McLean, VA

Sr. System Analyst

Responsibilities:

• Analyzed the Business Requirement Document (BRD) and developed detailed test plans and prepared test cases
• Worked on the enterprise data warehouse development to support reporting needs.
• Analyze business requirements and technical specifications of applications in development to see how they can be developed into testable elements following agile methodology.
• Work cross-functionally with key business partners to help establish strategic goals and objectives, project objectives, and set expectations on functional scope. As a data Analyst conducts analysis of business and user needs and then document requirements.
• Working with business process teams and application system personnel, the Data Analyst identifies data sources, confirms conversion requirements, and resolves data mapping and data integrity issues.
• Attend scrum meetings to ensure project roadmap is on track and proper organizational alignment is in place.
• Performed data analysis by writing complex SQL queries on various source systems and data warehouse to find trends and anomalies in the data in support of the requirements.
• Developed and optimized stored procedures and data loads using SQL, PL/SQL and T-SQL.
• Executed manual and automated test cases and verified results with expected results
• Involved extensively in conducting integration, performance and stress testing
• Selected the steps that could be automated for the regression testing using Win Runner

Confidential

System Analyst

Responsibilities:

• Experienced Business System Analyst worked on financial services software development projects focused on creating BRD, BI reports, operations business process models (BPM), performing data analysis, UI design, high-level data models and data entity relationship models. Also creating use case development, scenarios development, matrix documents, project reports, business process management, ETL requirements and GAP analysis.
• Pull information from proprietary systems and leverage external data sources to conduct quantitative analysis;
• Analyze highly complex business issues using information to draw insight and help identify opportunities for growth and improvement.
• Develop presentations and communicate analysis and modeling result to various stakeholders including senior level leaders
• Manage multiple complex projects, with shifting priorities that require the ability to work with ambiguous issues and see relationships between them.
• Work within our systems and with engineers to achieve high standards of data integrity, ensuring supporting metrics are accurate and complete.
• Develop dashboards, tools and reports focusing on key performance metrics
• Partner closely with cross-functional colleagues including IT and Finance
• Manage relationships across the organization and at times with external parties, senior leaders and vendors.