Summary
Overview
Work History
Education
Skills
Projects
Disclaimer
Accomplishments
Timeline
Generic

Varsha Sabbani

Lutz,FL

Summary

  • Over 5.5 years of IT experience in software analysis, test, design, and development for various software applications in the client-server environments and also in Cloud server environments.
  • My experience spans on Retail Banking and in Digital Media Industries.
  • Strong Knowledge in full Software Development and Quality Life Cycle(SDLC) with experience in Agile/Scrum and Waterfall development Methodologies.
  • Strong knowledge of Data Warehousing concepts and AWS Cloud based services.
  • Experience in the Analysis, Design and Development of Data warehousing solutions and in developing strategies for Extraction, Transformation and Loading (ETL) mechanism using Ab Initio & Informatica.
  • Experience in writing test plans, test cases, test automation and test coverage.
  • Extensive experience in System Integration, User Acceptance, Performance, Regression testing in both Front end and Back End Applications.
  • Hands on experience in handling data from various source systems such as XML Source, Apache Parquet files, JSON, Excel.
  • Experience in relational database systems and writing complex queries in Oracle, MS SQL Server, IBM DB2, Teradata, PostgreSQL, NoSQL, Big Data/Hadoop.
  • Extensively used ETL methodologies for supporting banking fraud detection.
  • Experience in implementing CI/CD Pipelines in Gitlab and with Cloud Orchestration tools like Apache Airflow. Knowledge on Amazon Web Services (EC2, Elasticache, S3, IAM, CloudWatch, SNS and SQS).
  • Experience in Design, Development, Testing and Automation, Enhancement and Maintenance of Application and Tools.
  • Expert in writing UNIX Shell Scripts, Python scripting, Python test tools(Selenium) and experience in .NET applications.
  • Very strong skills in project management, requirement analysis, business analysis, database modeling, design and analysis, issue coordination and development with Oracle/SQL Server-based Relational Databases.
  • Involved in implementing BI reporting using Cognos and Business Objects. Experience in developing Entity-Relationship diagrams, Logical and Physical Data Models, and Data modeling tools.

Overview

10
10
years of professional experience

Work History

Quality Assurance Engineer, Data Acquisition

Nielsen LLC
Florida, USA
09.2022 - 02.2024
  • Played a pivotal role within the QA team, driving initiatives to enhance the monitoring capabilities of Over-the-Top streaming platforms, thus contributing significantly to audience measurement accuracy
  • Demonstrated initiative by spearheading a new project within the streaming resolution team, focusing on the integration of mobile devices into Nielsen's strategic efforts to refine audience measurement techniques
  • Adapting to BBD(Behavior Driven Development) has allowed for effective, comprehensive and continuous improvement to drive cross functional collaboration, to deliver impactful solutions and to ensure software development aligns closely with business goals
  • Executed a diverse array of testing methodologies, including chaos testing, monkey testing, User Acceptance Testing (UAT), performance testing, and SOAP UI testing as part of the new project
  • These efforts were aimed at discerning patterns and logic to effectively accommodate mobile devices and emerging platforms
  • Made substantial contributions to the development of new Airflow DAGs using Python, ensuring the seamless flow of BAU processes while comprehensively understanding the architecture, including other micro-services
  • Leveraged Python scripts, particularly Selenium, to write and test data validation procedures, thereby reducing faults and errors in reporting and improving overall data quality
  • Implemented GitLab Continuous Integration/Continuous Deployment (CI/CD) pipelines to facilitate smooth deployments as needed, and also to address Emergency Change Requests (ECRs) in order to meet Service Level Agreements (SLAs)
  • Collaborated on enhancements for VB.NET applications to accommodate downstream requirements and enhance reporting capabilities, thereby ensuring alignment with evolving business needs
  • Proficiently prepared comprehensive documentation and Confluence pages to publish crucial information regarding releases, projects, and conceptual understandings using UML charts, data flow diagrams etc, facilitating seamless knowledge transfer and effective brainstorming within the team
  • Demonstrated commitment to Agile methodologies by actively participating in the iterative development process, offering insightful recommendations and comments on user stories, and diligently resolving issues at each phase of initiatives and projects.

IT Analyst

Tata Consultancy Services
India, India
10.2013 - 02.2018
  • Primarily worked in Anti Money Laundering module for Citibank North America in retail banking sector
  • Have good banking domain knowledge on retail banking sector
  • Worked in both Waterfall and Agile methodology for different modules in AML
  • The business models in banking on which I have dealt with are 1
  • Enterprise Fraud Detection 2
  • MANTAS 3
  • AML- Remote Deposit Cash 4
  • AML- Risk Assessment Collaborated with multiple infrastructure teams, onshore/offshore and client leadership throughout the project
  • Implemented code logic and tools to get good KYC information on customers for proper monitoring
  • Regular monitoring of production data was done to improve the quality of data presented for compliance which is done by the Office of Comptroller of Currency(OCC)
  • Tracked the flow of the transactions from End to End for suspicious transactions/customers/accounts as per the instructions from OCC or MANTAS
  • The quality of KYC information provided for monitoring has improved from 60% to 90% which the clients appreciated
  • Direct interaction with clients on design of the projects based on the business models or requirements
  • Involved in all phases of the project, including preparation of SOW, HLD, DLD with Unit Testing, SIT, UAT, and PROD & after support
  • Handled production incidents during critical failure scenarios quickly
  • Queries were run in the database to monitor the data quality and reconciliation between the flat files and the data in the table was done at each step
  • Worked extensively in migration of file systems from UNIX based servers to Cloud Based Servers using python scripts
  • Worked with multi-file systems extensively and have good knowledge on Plans, Continuous Flow and Dependency Analysis.

Education

Skills

Database skills:

  • Oracle 10G/9i/8i
  • TeradataV2R6
  • SQL Server
  • DB2
  • PostgreSQL
  • No SQL
  • Jupiter(Hive)
  • Apache Zeppelin

Scripting:

  • C/C
  • Python
  • Unix Shell Scripting
  • VB net

Cloud Technologies:

  • AWS-S3
  • Ec2
  • Lambda
  • IAM
  • Redis Elasticache
  • SNS
  • SQS
  • Cloud watch

Testing Tools:

  • Version Control Systems- Git Lab/ Bit Bucket
  • Selenium Python
  • SOAP UI
  • Postman UI

ETL Tools:

  • Ab Initio
  • Informatica
  • Cognos
  • Business Objects

Projects

Project 1: 10/01/13, 02/01/18, Tata Consultancy Services, India, Citibank NA, NY, IT Analyst 

Project 2: 09/01/22, 02/01/24, Nielsen LLC, Florida, USA, Quality Assurance Engineer, Data Acquisition

Disclaimer

I here declare that the information furnished above is true to the best of my knowledge and belief.

Accomplishments

  • Copper Award - contributions to the Streaming Platform Ratings Breakout By App initiative

Timeline

Quality Assurance Engineer, Data Acquisition

Nielsen LLC
09.2022 - 02.2024

IT Analyst

Tata Consultancy Services
10.2013 - 02.2018

Similar Profiles

CREATE PROFILE
Varsha Sabbani