PROFILE SUMMARY:

• IBM Certified Big Data Architect, Data Scientist and QA Architect with 13+yrs of IT Experience with knowledge on Cloudera Hadoop (Big Data), AWS Cloud (Big Data), ETL, Data Warehouse, BI Analytics & Reports
• Good Business Knowledge in Banking domain with CCAR/Retail Credit Risk/Quantitative Risk Technologies, BASEL Compliances and Airport/Airfield Real Estate domain
• Experienced in managing a Team of 17 Members across globe (2 - Nearshores (Monterrey - Mexico), 2-Onshores (Charlotte, NC), 13-Offshores(Bangalore/Chennai/Hyderabad))
• Extensive knowledge in both AGILE and Waterfall Models
• Steward of the Entity Relationship Diagram and Component, Logical and Physical Data Models
• Act as a liaison between DBA team, Source Systems team, Business, Project & Release Management, Application and Solution Architects
• Perform Data Architecture, Data Sourcing, Data Modeling, Data Mining, Data Profiling, Data Analytics and Data Analysis to determine which data sources are most valuable from the loads of upstream source systems and produce reports
• Performed Data Discovery, Data Assessment, Data Completeness, Data Map and Gap Analysis to determine additional data required to accomplish business objectives, etc.
• Responsible for creation of technical mapping documents
• Responsible for understanding the impact the data migration could have on source systems, latencies and networks
• Experienced in building Testing Center of Excellence, documenting, delivering processes, procedures, training, presentations, reports, metrics, etc.
• Experienced in overseeing all testing activities, staffs for all assigned applications to ensure all testing standards are followed and being met by reviewing all the Project Artifacts
• Prepared Test Strategy, Estimations, Test Plans, Test Scenarios, Test Scripts, Defect Root Cause Analysis, Requirement Coverage, Traceability Metrics, Impact Assessment, Dashboard Reports, Status Reports, QA & Data Release Management Reports, etc.
• Prepared strategy to build Automation Framework & implemented with the help of Store Procedure/Shell Scripting/Python/Excel,
• To validate Mainframe data loaded to Cloudera Hadoop (Big Data - HDFS) environment
• To validate Cloudera Hadoop (Big Data - HDFS) loaded to Teradata & Oracle data
• To validate transformations, Business Logics applied on Teradata & Oracle data
• To validate and BI Reports data
• Conducted Technical Interviews for internal and external projects to On-board them to various projects

EMPLOYER:

Confidential

BI Analytics/Strategy - Data Architect & Analyst

Responsibilities:

• Steward of the Entity Relationship Diagram, Component, Logical and Physical Data Models
• Acted as an interface with DBA team
• Oversees development project task plan
• Responsible for creation of technical mapping documents
• Design the Data Flow Architecture for various upstreams and downstreams Source systems Perform Data Sourcing, Data Modeling, Data Mining, Data Profiling, Data Analytics and Data Analysis to determine the data sources which are most valuable from the loads of upstream source systems and produce reports
• Create tables as per designed model and load the Historical/Near - Real time data from the Source systems through Store Procedure
• Create tables as per designed model and load the Historical/Near-Real time data from the Source systems and work with through Informatica (ETL) team to transform the data.
• Identify and review the additional tables and fields within source systems
• Involve in Data Discovery, Data Assessment, Data Map Analysis, Data Gap Analysis, Data Completeness Analysis; Assess the data to determine which data sources are most valuable from the loads of upstream source systems and produce reports, to determine additional data required to accomplish business objectives, etc.
• Responsible for understanding the impact the data migration could have on source systems, latencies and networks
• Involve in ETL based Analytical testing with Informatica Power Center Designer 9.5.1 to determine the Sourcing, Transformational processes and Transaction processes and build Data Modeling
• Works with Solution Architect/Project Development/network team to define and create overall strategy to move data from Source systems and ensures that it is being achieved without latency

Technology: AWS (Amazon Redshift), Oracle 11G, Informatica Power Center 10.1 (ETL) and Micro Strategy BI Reports

SDLC Tools: HP QC 12.0/ALM, Version One and Sciforma

Technical Tools: Toad for Oracle 12.8, SQL Developer, Informatica Power Center 10.1 for ETL, Oracle SQL Developer 4.1.5, Aginity Workbench for Amazon Redshift, Microstrategy Developer 10.3.0, MS Excel, MS PowerPoint and MS Visio

Confidential, Dallas Fort Worth, TX

BI Analytics/Strategy - Data Architect & Analyst

Responsibilities:

• Acted as an interface with DBA team
• Researched & Analyzed new opportunities for data acquisitions
• Analyzed to verify the Data Completeness in the Warehouse with respect to the Business needs
• Analyzed & Assessed the data pulled from various Data Sources to the Warehouse
• Analyzed & implemented measures to ensure data accuracy and accessibility
• Acted as a liason between project team and Source Systems Team
• Collaborated with ITS to devise a data strategy that addresses business requirements
• Developed business focus data awareness program
• Performed Data Mining and Data Analysis to determine the data sources which are most valuable from the loads of upstream source systems and produce reports
• Identified and review the additional tables and fields within source systems
• Involved in Data Discovery, Data Assessment, Data Map Analysis, Data Gap Analysis, Data Completeness Analysis; Assess the data to determine which data sources are most valuable from the loads of upstream source systems and produce reports, to determine additional data required to accomplish business objectives, etc.
• Involved in ETL based Analytical testing with Informatica Power Center Designer 9.5.1 for understanding the Sourcing processes

SDLC Tools: Version One and Sciforma

Technical Tools: SQL Developer, Informatica Power Center 9.5 for ETL, Oracle SQL Developer 4.1.5, Aginity Workbench for Amazon Redshift, Microstrategy Developer 10.3.0 and MS Excel

Confidential, Dallas Fort Worth, TX

QA Test Architect

Responsibilities:

• Oversee all testing staff and activities for all assigned applications.
• Served as an escalation point for issues involving testing
• Served as a resource and communication point for decisions about test schedule changes
• Defined & implemented test process including required test activities and deliverables
• Designed Test Strategy for Data Validation, E2E Testing from Sourcing to Target transformation validations and BI reports
• Prepared Entry/Exit Criteria s, Release Management Reports, Weekly / Monthly Status Report, Defect Analysis Report, Traceability Metrics Report, Impact Assessment Reports, Requirement Coverage Analysis/Report, Gap Analysis Reports, etc.
• Designed and documented Test Plans, Execution Reports, Test Scripts for Data Validations and ETL Verification
• Tracked, managed initiatives and reports issues using HP ALM and Version One
• Involved in ETL based Analytical testing with Informatica Power Center Designer 9.5.1, Sourcing, Transformational and BI reports testing with respect to AWS Big Data against Oracle data with Micro Strategy Reports
• Validated AWS Big Data against Oracle, Transformation between Oracle and Redshift
• Coordinated with all shores and assist in smooth delivery without any slippages to manage Agile Scrum
• Provided Impact Assessment to update and estimate time/effort estimation for In Scope project (Weekly basis)
• Supported team members in understanding delivery requirements and helping in framing complex PL/SQL & POSTGRE SQL issues and queries

SDLC Tools: HP QC 12.0/ALM, Version One and Sciforma

Technical Tools: Oracle SQL Developer 4.1.5, Aginity Workbench for Amazon Redshift, Microstrategy Developer 10.3.0 and MS Excel

Confidential, Charlotte, NC

Senior Test Lead & QA Architect

Responsibilities:

• Established TCOE through documenting & delivering processes, procedures, training, presentations, reports, metrics
• Oversee all testing staff and activities for all assigned applications.
• Provided skills to synthesize requirements and design end to end testing solution considering all parameters while designing solution like infrastructure, technology, process, domain, tools, resource requirements, ROI for the client, test environment requirements, process improvements required and to setup processes to define solid test architecture by analyzing current processes, tools and applications and provide guidance on how to improve them
• Served as an escalation point for issues involving testing
• Served as a resource and communication point for decisions about test schedule changes
• Defined test process including required test activities and deliverables
• Identified test resources, estimates test effort and defines test schedule and milestones
• Ensured technical resources are organized for effective support of testing
• Developed testing schedule using Work Bench Structure & ensure testers are assigned
• Prepared Test Strategy for E2E Testing from Sourcing to Modeling to Reports, Test Plan, Complex SQL or Hive Queries, Entry/Exit Criteria s, Testing Release Management Reports, Weekly / Monthly Status Report, Defect Analysis Report, Traceability Metrics Report, Impact Assessment Reports, Requirement Coverage Analysis/Report, Gap Analysis Reports, etc
• Involved in ETL based Sourcing and Modeling testing with respect to Hadoop against Oracle with Micro Strategy Reports.
• Validated Hadoop data against Oracle, Transformation between Hadoop and Oracle
• Prepared strategy to build Automation Framework & implemented with the help of Store Procedure/Shell Scripting/Python/Excel o To validate Mainframe data loaded to Cloudera Hadoop (Big Data - HDFS) environment o To validate Cloudera Hadoop (Big Data - HDFS) loaded to Oracle data o To validate transformations, Business Logics applied on Oracle data o To validate and BI Reports data in Microstrategy and Tableau
• Demonstrated the ability to create, execute and validate results of test scripts created to regression test the business processes around the application being decommissioned
• Worked closely with Development to implement Test Driven Development (TDD) and Continuous Integration Process
• Coordinated and managed testing activities with all shores members, project managers and tracked on HP ALM, VersionOne to update the SIT Signoffs, SIT Dates, Status, etc. on daily basis to ensure HP ALM & VersionOne reflects the project information correctly and have smooth delivery without any slippages in each sprint (Agile Scrum) and Xtreme Pair Programming duration
• Provided Impact Assessment, estimated time/effort estimation for In Scope project (Weekly basis)
• Conducted Interviews for internal and external projects
• Provided training for Onshore/Offshore/Nearshore team members within organizations on Hadoop, DW, ETL Testing approaches and related scenarios

SDLC Tools: HP QC 11.0/ALM and CODE/JIRA/Version One

Technical Tools: TOAD for Oracle/Teradata SQL Assistance, SQL Workbench, SQL Squirrel Client and Tectia SSH Client/WinSCP/Super Putty