SUMMARY:

• 7 years of experience in SQA(Software Quality Assurance) with ETL, Web applications, database, regulatory reports
• Profoundly comfortable in validating various applications that includes Web UI, database, performance, ETL(Informatica) and reports(Microstrategy, Tableau, Actuate)
• Experience in data analysis at every stage of calculation performed by the application and create a analysis chart in Microstrategy Web dashboard
• Profoundly comfortable working in a fast - paced environment with time sensitive deadlines and ever changing priorities
• Highly skilled in most stages of project life cycles(SDLC & STLC) and testing methodologies
• Experience in writing complex validation SQL queries to validate data transformation, data consistency, data quality and Incremental ETL testing(SCD)
• Possess good knowledge in STAR schema and performed ETL testing with multiple source systems, staging, fact and dimension tables targeting to final views
• 6 years of domain experience Risk & Capital Management based on Basel I,II,III regulations and have good knowledge of Risk factors, Risk Rating, RWA, EAD, LGD calculations and FFIEC 101, HCR reporting
• Experience in Test Planning, Test estimation, Test strategy, Requirement Traceability, defect metrics and status report preparation
• 4 years of experience in Agile methodology using Version One tool
• Expertise in partnering with BAs, product owners, dev managers to define the scope and priority of release and to coordinate test planning, execution, and communication activities.
• Experienced in Business Analyst for 2+years critical during project migration phase, coordinating with Business to get/clarify requirements, coordinate with development team for deployment
• Expertise in Functional testing, Manual Testing, Regression testing, User Acceptance testing (UAT), System testing, Integration testing and Black Box Testing
• Strong experience in Onshore Team coordination and Onshore-Offshore Coordination in multiple applications
• Leading E2E automation team integrating different automation tools/languages like Python, TOSCA, UFT
• Experienced in test coordination tools like HP Quality Center, JIRA, Version One used to generate status report and defect metrics
• Have strong functional knowledge and good domain knowledge across all applications in current project that projected me as E2E test lead/coordinator
• Expertise in testing optimization and provide E2E strategic solution demonstrated via VISIO flow diagrams

TECHNICAL SKILLS:

Agile & Test Mgmt Tools: VersionOne, JIRA, Confluence, SVN, QC/ALM, Share Point

ETL Tools: Informatica

DB Tools: Aginity for Netezza, Teradata SQL assistant, Toad Data Point

BI Tools (OLAP): Microstrategy, Actuate, Tableau

Automation Tools: QTP/UFT, TOSCA

Languages: C, VB script, Python, Unix

PROFESSIONAL EXPERIENCE:

Confidential

Senior Software Engineer

Responsibilities:

• Handled different applications under Saber2 - MAT, Wholesale, Numerator and Reporting
• Lead 8 members offshore team in reporting, 3 members offshore team in Wholesale and 3 members offshore team in Numerator
• Gather requirements from Business users/BA and coordinate with product team to understand the priority, estimate the testing effort and Proactively communicate the risk
• Microstrategy Reporting application processes(ETL) data from different source calculators like Wholesale(TCP, CRM), Retail(Mortgage, QRE), Traded Products(Repo, Derivatives) and Securitization at exposure/transaction level from different legal entities.
• Regulatory Capital reports (such as FFIEC 101, HCR-RCR) and internal management data control reports are being developed and generated on monthly basis and validated for data accuracy and format standards
• Participate in all Agile meeting starting with Sprint Planning(story estimation), Capacity planning(resource estimation), scrum meeting(daily status), Breakout meeting(Issue discussion) and Retrospective
• Developing test approach and ETL test scripts based on requirement document and review with business users, BA and product team
• Develop SQL scripts as per the Transformation rule provided in mapping document and validate them in Teradata, Netezza
• Building complex SQL statements involving all join variants to enable them to make robust comparisons of source versus target data loaded by the ETL
• Validating multiple regulatory and internal management reports created in Microstrategy, Tableau, Actuate against business requirement
• Prepare analysis graph/table using Microstrategy Web dashboard and share with Business users
• Reconciling data between old and new system, analyze the differences and identify the root cause
• Worked with offshore automation team to create a automation framework to automate Microstrategy report validation using UFT - Hybrid Framework that yielded huge return on investment across the team
• Worked with offshore to create framework in Python to automate ETL regression suite
• Numerator application deals with Schedule A calculation which is source for FFIEC 101 report (Web UI, Python, SQL, ETL)
• Wholesale deals with credit risk and economic capital calculation for large group of industries (Python, SQL, ETL, Data analysis)
• Prepared test scenarios and test data for slowly changing dimension (SCD) testing
• Defect tracking, defect reporting using Quality Centre, VersionOne(Agile Tool)
• Defining scope for regression testing and updating regression suite based on latest enhancement every sprint
• Identifying automation scope for regression testing and coordinating with centralized automation team
• Lead/coordinated E2E component testing, system integration testing and user acceptance testing for multiple workstreams/applications Go Live
• Provided strategic solution to environment set up and Go live planning for multiple application E2E initiatives
• Proactively communicate areas of improvement across team to deliver the quality product on targeted timelines
• Communicate the improvement points in regulatory reports to business users and coordinate with dev/BA team to implement the same

Business Analyst

Confidential

Responsibilities:

• Worked with Business Users to gather and clarify requirements to prepare ETL mapping document and Microstrategy Report Specifications
• Coordinated with development teams to implement the changes and review the output with Business Users
• Understand and analyze UAT and PROD defects from Business team and create enhancement request or create production emergency deployment process
• Coordinated between UAT/Business users and project management to get UAT testing status and issues or to review SIT test results

Confidential

Software Engineer

Responsibilities:

• Understand the business use case of Web application (MAT) and develop test case and prepare test data for validation
• Review test results with onshore lead, Dev team and BA team, provide suggestion to dev team to upgrade the functionality that meets business needs
• Validate the METADATA of each table present in web application
• Partnered with UAT team and performed UAT testing for MAT application
• Worked on QTP to automate regression test cases of MAT Web application that yielded huge savings
• Understand the enhancement request from business for Wholesale workstream/application, prepare test approach and review with business and BA
• Validating calculation of KBE’s such as Risk Weighted Assets (RWA) and Economic Capital (EC) in DB and Reports
• Perform smoke test for environment readiness and coordinate with environment team and onshore lead for any issues
• Participating in daily standup, break-out meeting and interact with onshore lead, Developer, BA, PO and ensure story objective is meet and defects are communicated and fixed
• Building complex SQL statements involving all join variants to enable them to make robust comparisons of source versus target data loaded by the ETL
• Validation Transformation logic (ETL) through complex SQLs
• Validation of BI reports generated through ACTUATE tools which are critical for internal bank management
• Working on multiple application with different testing scope
• Conducting Defect Analysis for the defect raised in SIT, UAT and PROD, prepare lessons learnt document and improve the SIT testing scope/quality
• Mentor all new joiners to the team and conduct sessions on testing process and domain
• Participated in delivery deck preparation for Confidential management for every release that shows SIT effectiveness, Defect Acceptance ratio