Azure Data Factory
Resume:
Ravi
****.**********@*****.***
Summary
** + Years of diverse experience in Information Technology with emphasis on Developer and Testing in Client/Server and Web based applications. Proficient in Manual and Automation testing using Mercury tools (QTP, Win Runner, Quality Center/Test Director), Selenium and Rational Tools (Clear case, Clear Quest) on Windows, Mainframe (IMS) and Unix/Linux Environment.
●Experience in Manual and Automation (Load and Performance) testing of Web and client/server applications on UNIX and Windows environment.
●3 years of development experience on cloud platforms (Azure).
●Solid experience on building ETL ingestion flows using Azure Data Factory
●Good understanding of Software Development Life Cycle (SDLC), Software Testing Life Cycle (STLC), Bug Life Cycle (BLC). Experience in building the Orchestration on Azure Data Factory for scheduling purposes. Experience in building the data pipeline by leveraging the Azure Data Factory
●Involved in Stress testing, performance testing and Load testing using Mercury Tool Load Runner
●Expertise in RDBMS backend testing for data validation and data integrity using SQL Queries on DB2, Oracle and SQL Server and using stored procedures in PL/SQL, Executed negative and
●positive test cases to test application functionality against user requirements
●Excellent Reporting and Presentation skills using MS Excel and MS PowerPoint.
●Experienced in software analysis, Requirements Management, Quality Assurance, Modeling and Configuration Management.
●Extensive knowledge in implementing Structured Methodologies test plans, test cases, test scenarios and test deliverables. Strong Knowledge in web application testing.
●Knowledge of protocols, FIX, VOIP, TCP/IP, FTP and HTTP.
●Hands-on experience in Azure Analytics Services – Azure Data Lake Store (ADLS), Azure Data Lake Analytics (ADLA), Azure SQL DW, Azure Data Factory (ADF), Azure Data Bricks (ADB) etc.
●Experience in building the data pipeline by leveraging the Azure Data Factory.
●Proficient in designing and executing test cases – both manual and automated. Involved in developing and maintaining automation test scripts. Strong Knowledge of Oracle and PL/SQL Data Bases.
●Extensive experience in PL/SQL Stored Procedures and Functions
●Experience in building the test cases using Azure DevOps.
●Experience in building the test-cases for a seamless integrations and deployments using DevOps.
●Experienced in various types of testing like, Black box, White box, Functional test, Integration test, System test, User Acceptance test, Regression test, and Performance Testing.
●Proficient in Oracle9i/11G, SOAP, XML, SQL, Unix, Linux, Cobol
●Expertise in review and documentation of system Test plans and creating Test cases on the basis of products releases features, client's requirements and related technical document.
●Experienced in building Automation Regressing Scripts for validation of ETL process between multiple databases like Oracle, SQL Server using Python.Scripts to test the ETL Pipelines in ADF and Databricks.
●Experienced in creating the Stress Tests using the latest technologies and find out the optimal points for applications.
●Enthusiastic team-oriented member with good communication skills. Ability to work in tight schedules and on different applications concurrently.
Technical skills
Programming Languages : J2EE, .Net, C, C++, VB,COBOL, Unix Shell Scripting,Perl.
Database : SQL, Oracle 9i/10G/11G,.MYSQL,
Web : HTML, XML, VB Script, Java Script, Apache, Web Logic
Operating System : Windows 95/98/2K/XP/NT, UNIX, Linux, SAP NWF .
Testing Tools : Win runner, Test director, QTP8.0, Quality Center, Selenium
Test Strategies : Manual, Integration (System), Regression, User Acceptance (Beta), Functional, Compatibility, Product Verification.
Version Control : Rational Clear Case, Requisite Pro, SVN, CVS, Mercator.
Cloud Technologies : Microsoft Azure,ADF,Databricks
Bug Tracking Tools : Rational Clear Quest, Heat, Bugzilla, Dragnet,
Jira, Test director, Quality Center, Trac, Version One
Project Details
Client: Broadridge Financial Services (Prudential, All State,Valic,TIAA,Talcott,Voya,Empower,Massmutual) March 2011 to Present.
QA Lead consultant
Project: POD (Print on Demand)
Broad ridge Convert the documents as PDF and Deliver the update document to customer
Print on Demand (POD), E-Delivery Process, Assign the document ID for Each document .Implement the various rules Suppression Logic,House hold rule, Postage .For Annual files, Semi annual,Regulated and First Dollar.
Role and Responsibilities:
●Created the detailed test plan, Test strategy, test scripts, test cases from the business requirements documents and meetings.
●Develop Test Scripts Using Use cases and User Procedures or Business requirement document (BRD).
●Work closely with Developers, Business/Systems Analysts, Project Managers, and other Business Subject Experts (SMEs) deliver Quality test result .
●Developed Test plan for each Client Separately (objectives, scope, resources, scenario’s, test cases, schedule)
●Created Linked Services for multiple source systems (i.e.: Azure SQL Server, ADLS, BLOB, Rest API).
●Created a Pipeline to extract data from on-premises source systems to Azure cloud data lake storage; Extensively worked on copy activities and implemented copy behaviors such as flattening the hierarchy, preserving hierarchy, and Merge hierarchy; Implemented Error Handling concept through copy activity.
●Implemented Azure Data Factory activities such as Lookups, Stored procedures, if condition, for each, Set Variable, Append Variable, Get Metadata, Filter, and Wait.
●Load a Data into Dashboard on daily basis using ETL process .
●Process a Batch Jobs using the Perl scripts in Windows system and verify the each document and sections
●Generating a test cases using Selenium
●Responsible for understanding Business requirements and developing domain knowledge for ownership.
●Create a daily account files process those files validate the data against with data base
●Run a batch jobs for Client process, Back end Process and Post edge Process
●Trading a fund codes and verify the reason codes in Database
●Verify the Mandatory Attributes values in Database Level and E-delivery documents .
●Validate the loading of trac files into the staging area and promoting data into Main table
●Automate the all process using the job runner and verify the run logs .
●Involved the Performance monitoring web application for PNET VIEWER and Desktop app for Fund Point application.
●Coordinate with team update the status to QA director on regular basis
●Writing a complex SQL Queries and verify the populated data in database
●Involved in Regression Testing and Retesting of Each Build.
●Performance monitor and Observability tools using for Dashboard portal for all clients
●Interact with Offshore team update their status to Client team.
●Able to work in tight deadlines, as well as independently.
●Run the ETL process and load a daily data into dashboard and capture results using selenium .
●Attend the Regular Meetings with Project Manger and Update the QA Status report weekly Basis.
●Create SQL Scripts and verify the request and response files in windows system as well as in database level
●Build VMware setup for QA Environments for each client and take back up each Iteration.
●Validate generated data processing error report and error messages
●Process files for UAT Testing and Trained to end user about the process.
●Create test data for Different clients and Process a batch jobs and verify the generated response files and validated data against the database.
●Report a defect in Bugzilla and Quality center.
●Create a checklist and do the validations against the business rules
●Process and schedule a job on daily basis, weekly basis and Monthly basis.
●Prepare test Evidence Document and Traceability matrix
Environment: C Net,Oracle 10G, Adobe 10.0, FTP, Unix, XML, Job runner,Job scheduler, Perl, Java script, VMware, Web services (SOAP), web logic, Selenium,DevOps,Oracle SQL Developer 2.1.1.64, Linux,PL/SQL, GIT, Jenkins, Business Objects, Azure Data Factory, Azure Data Bricks, Azure DW, ADLS, Azure DevOps, BLOB, Azure SQL Server, Azure DW, Loadrunner,Azure Azure DevOps, Azure synapse.Informatica, SOAP, Windows NT, QTP, Bugzilla,Quality Center .
Client: Waters Corporation /Protégé Services, Milford, MA June 2010 to March 2011.
ETL Consultant
Waters creates business advantages for laboratory-dependent organizations to enable significant advancement in healthcare delivery, environmental management, food safety, and water quality.
Role and Responsibilities:
●Created the detailed test plan, Test strategy, test scripts, test cases from the business requirements documents and meetings.
●Develop Test Scripts Using Use cases and Use Procedures
●Each ODI(Oracle Data Integrator) Run Compare the Table count Against the Empower Instance
●Interact closely with Developers, Business/Systems Analysts, Project Managers, and End Users.
●Developed Test plan for necessary elements to do Load testing(objectives, scope, resources, scenario’s, test cases, schedule)
●Clone a Primary Development each Iteration and Start Testing Identifying issues then Create a Issues in Version One Tracking to Tool .
●Dashboard Testing focus on Report links,Drill down, Drop down options and preparing Document and upload into share point .
●Involved in Regression Testing and Retesting of Each ODI run
●Tested the Hierarchy Level and Roll up Counts of all Reports Presented in the Dashboard
●Interact with Offshore team update their status to Client team.
●.Able to work in tight dead lines, as well as independently.
●Involved Security Testing and Verify the Dashboard Presented data against the DWH Instance .
●Generate a Answers and Pages in dashboard,Develop Pivot tables and Bar graphs and Validate the Displayed data in Database level .
●Attend the Regular Meetings with Project Manger and Update the Status Regular Basis .
●Create SQL Scripts and Collect the Table count and Verify the Empower instance of Each node .
●Create a Report Document and Publish for UAT Testing and Trained to End Users
●Prepare test Evidence Document and Report to Client end of each Iteration .
Environment: Oracle 11G/10G,ODI11G/10G,OBIEE11G/10G, Version One, XML, HTML, DHTML, Java script, VMware vSphere Client, Web services (SOAP), web logic, Oracle SQL Developer 2.1.1.64, SAP, PL/SQL, UNIX and Windows NT, Quality Center .
Client: BECKMAN COULTER, Brea, CA Apr 09 to May 2010
Role: ETL and OBIEE Consultant
Beckman Coulter, Inc. is a leading manufacturer of biomedical testing instrument systems, tests and supplies that simplify and automate laboratory processes. The project is to build and maintain the enterprise level data warehouse.
Job Responsibilities:
●Understand the Functional and Design Requirements.
●Under standing the software development life cycle (SDLC)
●Create the Test Plan, Test Scripts using Business rule from mapping document
●Using SQL Query Compare each customized column one sample from Target and Source.
●Create DB compare query and validate data source and target systems
●Create the SQL Scripts for Table count, Null Values, Zero’s and Rowid’s.
●Involved in ETL testing Initial and Incremental load of each cycle in different schemas
●Create the test result of each cycle and upload the client internal site share point.
●Participate the test status meeting weekly and update the status to QA Director.
●Involved in repository testing.
●Performs data quality analysis using advanced SQL skills.
●Tracks defects to ensure appropriate management and escalation of defects. Coordinate defect resolution and retesting.
●Run the Reports and Log the Defects in Quality Center .
●Testing ETL components by Executing SQL and PL/SQL Queries.
●Run the automated scripts for all Service reports created by using load runner tool .
●Tested Service, Data Marts each load of data for Initial and Incremental.
●Involved all modules(Service, SCM,HR, Order Management, General Ledger, AR and AP) of ETL testing
●Tested all modules reports data and validate the data against Oracle EBS source system
●Involved in Different type of testing Like Security testing, Regression testing.
●Using UPK tool create Report documents and publish for UAT Testing.
●Participates in root cause analysis for defects and provides process improvement suggestions to eliminate future occurrences of similar defects.
●Tested all Modules of Dash Board and BI Publisher Reports Navigation and Data validation
●Interact with Offshore team update their status to Client team.
●Able to work in tight dead lines, as well as independently.
●Performed Regression testing with QTP by executing the automation test scripts
Environment: Windows XP,QTP9.0,SQL Server, Quality Center, MS- Office,Core-FTP, Shell scripting,Unix, CITRIX, Oracle BI Interactive Dashboards, Answers, UAT Environment, Share Point,Security Testing,Test Track, Source(GCX/GCT) and Target Systems (DWH),Data Marts, Oracle 11i, Oracle EBS 11.9.5(Financial, HR, Service and Supply Chain Management, Order Management),Citrix, Informatica 8.1.1, TOAD 8.0, DAC, Test Director, Business Objects, OBIEE, IIS, Windows XP Client and UNIX Server, UPK Client.
Client: ABN AMRO/RBS, Chicago, IL Feb 08 to Mar 09.
Project: Access Direct.
Role : Sr QA Analyst
Access Direct is a banking application that is designed to handle the sending and processing of large volumes of payment/collection instructions and multi-bank reporting information by direct electronic communication. Moreover, AD generates status acknowledgements as well as routes the status acknowledgements received from the various partner banks or back offices back to the customers. All the processes that take place in AD are for the functioning of these basic flows (Payments, Acks, and Reports).
Job Responsibilities:
●Understand the Functional and Design Requirements.
●Under standing the software development life cycle (SDLC)
●Create the RTM’s (Requirement Traceability Matrix) and wrote the test cases based on the functional document.
●Create the payment files like different formats ( BELI,DTA,PEXR,CLIOP,NORMA,BTL91
●FLAT FILE, EDIFACT (PAYMUL & DIREDEB), XML, X12, LSV, SEPA)
●Process the payment files thru different channels like FTP, AO, File Act, File Handler and GXS.
●Process the payment files thru Different Security Mechanisms like Entrust, AUTACK,TD Access,SAFEX.
●Verify the complete payment, ack and report flows using the TOAD and Access Direct.
●Create the customer, ack and report routing setups and process the payment files and verify the recreate formats
●Log the project-related issues on test management tool Test Director update the test case result in TD.
●Analyzing results, identifying solutions that may improve application performance or system capacity
●Completely involved manual regression cycle on different environments like SIT,UAT, Pre-Prod
●Involved the web application testing developed in HTML/Java technologies
●Involved in the Performance testing and High Availability testing on UAT and Preprod Environments
●Verify the payment files in Access direct UI monitor.
●Write/Execute SQL Queries to perform UI/Database validations
●Coordinate with other team members and update the test status to test manager on daily basis
●Tested on UAT and Production Tickets and immediate support to customers.
●Involved the GPL (Global Payment Link) Formats ISO8583, Bankline IAT, Bank line HVP, Royal line IAT and GPL end to end testing.
●Involved User Acceptance testing web based application of Access direct
●Write and executing SQL Queries for complete payment process
●Create the Payment, ack and report files for different customers and account numbers.
●Involved the customer migration and create the customer and account setup in both databases and upload the payment files and verify the database payment successfully loaded
●Verify Forward mechanism in Payments, Acks and Reports on both databases.
●Report the problems and interact with Access online team on regular basis.
●Migrate customers and roll back the same customers and verify the data on Access Direct Using the Web Monitor.
●Support of SWIFT FIN Messages,SWIFT Connectivity and SWIFT Functionality
●Tested extensively the new Link (GXS) to Access Direct ABNAMRO Payment Gateway that replaces the existing FTP.
●Using selenium generate a test scripts for regression testing .
●Understanding and Testing of RBS legacy formats to process Payments and Acknowledgements using Access Direct Payment Gateway.
●Testing of Reports, supporting RBS specific SWIFT ADDRESSSES via ACCESS DIRECT Payment gateway.
●Validate the SWIFT Incoming and Outgoing MT’s and Message flows.
●Learning and executing Automation Regression of various RBS legacy Payment formats using Win Runner
●Experience with performance testing on Web sphere commerce and Web Sphere Commerce Server
●Tested extensively the New Production environment built by RBS to support Access Direct Payment Gateway.
●This testing includes:
●Testing of all the 3 flows Payment, Acknowledgements and Reports.
●Testing of Access Direct Connectivity with other supporting Application like, Payment Router, Report Router and Access Online.
Environment: Windows XP, Clear Quest, Quality Center, QTP, Win runner, Business Objects, J2EE, XML, Oracle 9i, FIX, TOAD, Ultra-Edit, MS- Office, Core-FTP, Unix, CITRIX, MYSQL, Access Direct, UAT and Pre-Prod Environment, WCS, Selenium, FLEX, Web Monitor,ETL, IBM Web Sphere(Mercator), WTX,Access Online,File act(Swift Net),SWIFT Ready,File Handler, Adobe flex, Load Runner, Entrust,WATIR, Load Runner .
Education
●B.E (Computer Science and Engineering) from Karnataka University.
Contact this candidate