PROFESSIONAL SUMMARY:

• Possessing 9+ years of Professional Experience in IT Industry
• 1+ year experience in Blockchain research, understanding and solution development n Ethereum Blockchain
• Experience in developing smart contracts using Solidity.
• Experience in DAPP development and interact with Ethereum blockchain platform
• Good experience with Testrpc and Truffle frame work.
• Very good understanding of Blockchain technology, crypto currencies (Bitcoin or others), various consensus protocols (Proof - of-Work & Proof-of-Stake).
• Basic understanding of cryptography, symmetric/asymmetric (public/private key), hash functions, encryption/signatures.
• Contribution to open source projects on Blockchain/crypto currencies.
• Over 8+ years of rich experience in Big Data/Data Warehousing/ETL/Report/development on Ab-initio, Datastage, Informatica, SSIS, Cognos, Business Objects (BO), Teradata, Hive, HBase, Oracle, SQL server & DB2
• Having 2+ years of experience as a Data Analyst
• Good experience on Insurance, Banking (AML), Healthcare and Telecom domains
• Experience in writing complex SQL queries for data validation of both ETL and BI Reports testing
• Proficient in developing SQL queries for Oracle, Teradata, Hive, HBase and DB2 databases.
• Strong knowledge of working with Data Warehouse and Data Marts
• Have strong knowledge in Quality Center in writing test cases, plans, uploading test cases etc
• Generated Test Reports and Defect Reports from the QC/ALM for the Test Summary Reporting
• Involved in test data management activities and extensively worked on mapping documents
• Good experience with Data profiling
• Strong experience in data migration projects like using migrating the data from SQL Server to Teradata, Teradata to HIVE, DB2/Teradata to Text files,etc
• Sound understanding of Dimensional Modeling - Star and Snowflake Schemas
• Experience in Functional Testing, System Testing and Regression Testing
• Good experience in Agile SDLC, Continuous Integration, and Continuous Deployment
• Good experience in Performance testing, Functional Testing and Reports Testing
• Experience in performance testing using HIVE/HBASE database
• Familiarity with Business Intelligence multi-dimensional modeling concepts
• Good experience in defect tracking tools like Quality Center/ALM.
• Good knowledge on programming technologies like C, C++, Core Java & HTML
• Good amount of knowledge on Big data
• Extensive experience in validating the pre-run, Adhoc reports and Cubes in Cognos
• Strong knowledge on SAP tools like SAP BODS and HANA
• Worked on various Operating Systems which include Windows 95/98/2000/NT/XP and Linux (RedHat)
• Good experience in delivering complex enterprise application systems, distributed systems
• Good experience in managing onsite and offshore resources and coordination with multiple stakeholders
• Excellent analytical, problem solving, communication, technical, multi-tasking and a motivated team player with excellent inter-personal skills

TECHNICAL SKILLS:

Blockchain: DApp, Web3.js, Solidity, Bitcoin, Ethereum, HTML, CSS, JavaScript, Node.js,JSON, GitHub

ETL Tool: Ab-initio 3.0,DataStage 7.5x2,Informatica 7.1, BODS 4.1,SSIS

Reporting Tool: Cognos 10, Business Objects XI R2,SSRS

Database: Oracle 9 & 10g, Teradata 14.0, db2, SAP HANA SP5, SQL Server 2005/2008/2012 , MS Access, Hive 1.0,HBase

Software Tools: Hadoop, dn Director, Control M, Autosys

Defect Tracking Tool: Quality Center 10.0, Rational ClearQuest, ALM 11.5

Operating Systems: Unix/Linux, Windows Vista/NT/XP/2000

PROFESSIONAL EXPERIENCE:

Confidential

Blockchain Developer

Responsibilities:

• Involved in Ethereum blockchain development for Healthcare.
• Created smart contracts using solidity programming
• Involved in DAPP development using HTML, Java Script and Node.js and interact with Ethereum Blockchain by using Web3 JS API
• Deployed the smart contract code in Testrpc and perform testing
• Created private network with Go-Ethereum.
• Deployed smart contract in different environments using truffle
• Involved in integrating Ethereum blockchain with Metamask browser.
• Retrieve the data from SQL Server and develop BI reports.

Confidential

ETL Developer/Analyst

Responsibilities:

• Involved in project meeting and identify testing scope
• Provided test estimates based on the requirement
• Developed ETL jobs for various lines of businesses based on Business Requirement Document (BRD), ETL mapping document and covered the linkages and relationships between various source systems
• Designed test data using MS Excel sheet, created data driven test for testing the application with positive and negative inputs.
• Generating and writing clear and concise defect reports, verifying bug fixes.
• Performed various data analysis at the source level and determined the key attributes for designing of Fact and Dimension tables using star schema for successful creation of Data Warehouse and Data Marts
• Involved in reading the log files to identify issues/errors in scripts for ETL process
• Involved in validating the SSRS reports

Confidential

ETL Developer/Analyst

Responsibilities:

• Involved in project meeting and identify testing scope
• Provided test estimates based on the requirement
• Prepared Test strategy and Test plan based on the requirements
• Developed ETL jobs based on Business Requirement Document (BRD), ETL mapping document and covered the linkages and relationships between various source systems
• Supported the extraction, transformation and load process (ETL) for a Data Warehouse from flat files using Informatica and provide technical support
• Designed test data using MS Excel sheet, created data driven test for testing the application with positive and negative inputs.
• Generating and writing clear and concise defect reports, verifying bug fixes.
• Performed various data analysis at the source level and determined the key attributes for designing of Fact and Dimension tables using star schema for successful creation of Data Warehouse and Data Marts
• Involved in reading the log files to identify issues/errors in scripts for ETL process
• Writing the SQL queries to validate the Aggregate data in both Teradata and Hive databases
• Validated web-based applications/reports
• Performed data validating in BO reports
• Given walk through on test result documents to application support team before deploying the project in production

Confidential

ETL Developer/Analyst

Responsibilities:

• Understanding the client requirements by studying functional documents.
• Analyze the data in Confidential and all the Systems in Information systems area where BI Analysis and Reporting is performed.
• Developed ETL jobs based on Business Requirement Document (BRD), ETL mapping document and covered the linkages and relationships between various source systems
• Supported the extraction, transformation and load process (ETL) for a Data Warehouse from flat files using Informatica and provide technical support
• Identification of scenarios for the Requirements.
• Validating the data files from source to make sure correct data has been captured to be loaded to DB2 tables as per the transformation rules
• Involved in System Testing, Integration and Regression testing
• Involved in reading the log files to identify issues/errors in scripts for ETL process
• Checked the naming standards, data integrity and referential integrity
• Responsible for reporting and escalating data issues arising from project or daily support.
• Involved in validating the records after successful completion of jobs.

Environment: Informatica, Mainframe, DB2, Teradata 14.0, Quality Center 10.0, MS Access

ETL Developer/Analyst

Confidential, NY

Responsibilities:

• Developed ETL jobs for various lines of businesses based on Business Requirement Document (BRD), ETL mapping document and covered the linkages and relationships between various source systems
• Supported the extraction, transformation and load process (ETL) for a Data Warehouse from flat files using Ab-initio and provide technical support
• Developed Test Cases and Performed Manual Testing like Positive Testing, Negative Testing and Black Box Testing.
• Generate the source extracts by using dn:Director and validate the source extracts
• Executed Ab-Initio Graphs from the back end for Data extraction, transformation and loading process.
• Designed test data using MS Excel sheet, created data driven test for testing the application with positive and negative inputs.
• Generating and writing clear and concise defect reports, verifying bug fixes.
• Performed various data analysis at the source level and determined the key attributes for designing of Fact and Dimension tables using star schema for successful creation of Data Warehouse and Data Marts
• Involved in reading the log files to identify issues/errors in scripts for ETL process
• Writing the SQL queries to validate the Aggregate data.
• Performed data validating in Cognos reports
• Facilitated integration testing for various configuration, designed user test scripts and documents for UAT.
• Created ETL test data for all ETL mapping rules to test the functionality of the Ab-initio graphs
• Tested the ETL Ab-initio graphs and other ETL Processes (Data Warehouse Testing)
• Involved in validating the records after successful completion of jobs.
• Executed the test cases and reported bugs through defect tracking tool
• Involved in defect review meetings with the development team

Environment: Ab-initio 3.0, Cognos 10, Teradata 14.0, UNIX, Quality Center 10.0,dn:Director

ETL/BI Tester

Confidential

Responsibilities:

• Understanding the client requirements by studying functional documents.
• Identification of scenarios for the Requirements
• Prepared the test conditions and test cases as per the requirements
• Designed test data using MS Excel sheet, created data driven test for testing the application with positive and negative inputs
• Run the UNIX script from the back end to load the data into the Teradata target tables
• Involved in the error and duplicates checking post successful completion of ETL script.
• Involved in validating the records after successful completion of script.
• Wrote the SQL queries on data staging tables and data warehouse tables to validate the data results
• Performed data validating in Pre-run, Adhoc Cognos reports
• Performed Cognos cubes validation for Aggregate tables
• Responsible for running and analyzing quality check reports to ensure system is functioning properly
• Executing the Test cases and reporting the bugs through defect tracking tool
• Involved in defect review meetings with the Development team

Environment: Cognos 8, Teradata 12.0, UNIX, Quality Center 10.0

Confidential

ETL/BI Tester

Responsibilities:

• Understanding the client requirements by studying functional documents.
• Analyze the data in Confidential and all the Systems in Information systems area where BI Analysis and Reporting is performed.
• Prepared test schedules with inputs from Project manager and development team
• Create test plans and test cases as they relate to testing project requirements to ensure the overall quality of software delivered
• Identify automation opportunities for all phases of the project.
• Validate source extracts files generated in UNIX by using dn:Director
• Designed test data using MS Excel sheet, created data driven test for testing the application with positive and negative inputs
• Execute Ab-Initio Graphs from the back end for Data extraction, transformation and loading process.
• Check the naming standards, data integrity and referential integrity.
• Validated the data files from source to make sure correct data has been captured to be loaded into the target tables.
• Verify the alerts are generated as per the BLU rules present in the Fortent system
• Executed the test cases and reported the bugs through defect tracking tool
• Involved in validating the records after successful completion of jobs
• Validating the data files from source to make sure correct data has been captured to be loaded to target tables
• Involved in validating the aggregate table based on the rollup process documented in the data mapping.
• Wrote the SQL queries on data staging tables and data warehouse tables to validate the data results
• Performed data validating in Cognos reports
• Responsible for reporting and escalating data issues arising from project or daily support
• Assisted in creating test data and test cases and execute function system tests as needed
• Performed Black box Testing, Regression and end-to-end testing
• Involved in defect review meetings with the Development team

Environment: Ab-initio, Fortent, UNIX, Quality Center 10.0, dn:Director, Cognos 8

Confidential

ETL/BI Tester

Responsibilities:

• Analyzing the system and customer requirements
• Understanding the billing details and generate flat files from telecom billing application
• Identifying business rules and processing logic and creating and defining requirements to be used across all inbound interfaces.
• Prepared several test scenarios for the work flow of the entire ETL cycle
• Prepared test conditions and Test Cases for modules assigned
• Executed DataStage jobs for Data extraction, transformation and loading process
• Executed Ab-Initio jobs for Data extraction, transformation and loading process
• Validated the reject and duplicate records post successful completion of DataStage and Ab-Initio ETL jobs
• Involved in validating the records after successful completion of jobs.
• Wrote the SQL queries on data staging tables and data warehouse tables to validate the data results
• Performed data validating in BO reports
• Execute Test cases and reporting the bugs through defect tracking tool
• Involved in different test execution - Smoke, System, Regression and End to End
• Traced many critical defects in different testing phase(Smoke, System, Regression and End to End)
• Performed detailed analysis of data issues encountered during User acceptance testing
• Involved in defect review meetings with the Development team

Environment: Ab-initio, Datastage 7.5, Teradata 14.0, Business Objects XI R2

Confidential

ETL Tester/Support

Responsibilities:

• Understand business model and customer requirements
• Designed Informatica mappings for validating and loading data
• Created test plans and test cases as they relate to testing project requirements to ensure the overall quality of software delivered
• Extract data from sources such as oracle, Flat files to transform and load into target databases
• Designed and developed the ETL mappings in Informatica for moving data from legacy systems to Data Warehouse
• Developed jobs for incremental loading
• Validate the data which is loaded into the target tables after the successful completion of Informatica ETL jobs
• Wrote the SQL queries on data staging tables and data warehouse tables to validate the data results
• Used Control M to monitor the Informatica jobs in production
• Involved in unit testing of Informatica mappings
• Responsible for reporting and escalating data issues arising from project or daily support

Environment: Informatica 7.1, Oracle 9i, QC 9.2

Confidential

ETL Tester

Responsibilities:

• Understanding the client requirements related to healthcare plans by studying functional documents
• Created test cases as they relate to testing project requirements to ensure the overall quality of software delivered
• Executed Informatica and DataStage jobs for Data extraction, transformation and loading process
• Executed the test cases and reported the bugs through defect tracking tool
• Involved in validating the records after successful completion of jobs
• Wrote SQL queries to validate the Aggregate data
• Involved in defect review meetings with the Development team

Environment: Informatica 6.0, DataStage 7.5x2, SQL Server 2005, Oracle 8, QC 9.2

Confidential

ETL Tester

Responsibilities:

• Understood the business process that included sales processes, Rating methodology, different Products, Group Renewals and Enrollment process
• Performed Smoke Testing, End to End Functionality Testing, Regression Testing, Integration Testing and user Acceptance Testing (UAT)
• Designed and documented Test Procedures, Test Requirements, Test Scenarios and Test Cases for End to End functionality testing
• Extensively involved in testing Subscriber, Billing, Claims and Dental modules
• Validated source extracts files generated in UNIX
• Executed Informatica and DataStage jobs for Data extraction, transformation and loading process
• Executed the test cases and reported the bugs through defect tracking tool
• Verified bug fixes, generated and written clear and concise defect reports
• Involved in validating the records after successful completion of jobs
• Written SQL queries to validate the Aggregate data
• Involved in defect review meetings with the Development team

Environment: Informatica 6.0, DataStage 7.5x2, SQL Server 2005, Oracle 8, QC 9.2