PROFESSIONAL SUMMARY:

• Overall 8.5 years of professional experience in the field of Information Technology under ETL Informatica Development, DWBI and Big Data Testing.
• Expertise in leading testing projects spread across diverse geographies and working in an onsite - offshore delivery model. Ability to work on multiple projects in parallel to ensure on-time delivery.
• Sound grasp of SDLC/STLC processes, capable of identifying and managing risks throughout project life-cycle. Through understanding of delivery models like Waterfall, Agile, V-Model and Staff Augmentation models.
• Proficiency in performing various development and test activities like FSD/LLD preparation, Unit Testing, Integration Testing, Regression Testing and UAT along with additional project support activities.
• Development knowledge on Informatica Power Center and DVO - designing workflows, sessions, mappings using multiple transformations, setting up the ETL logics, creating data validation scripts using DVO.
• Working knowledge on IBM ETL/BI Suite (Datastage and Cognos), Informatica and SAP-BI/BODS. Expert in defect tracking and monitoring progress using Test Management tools like HP QC/ALM, Rational Clear Quest, JIRA/ITrack and Rally.
• Hands-on experience in executing complex SQL queries against heterogeneous databases like Oracle, SQL Server, Teradata SQL and IBM DB2 as part of data validation process.
• Sound knowledge on Data Analytics, Data Mapping and Data Warehousing concepts including Fact/Dimension tables and Star/Snowflake/Fact Constellation Schema modeling.
• Experience in executing UNIX commands as well as writing shell scripts as part of ETL data flow validations. Working knowledge on Big Data Technologies including Map Reduce structure, HIVE and Hadoop DFS.
• Excellent leadership, communication and stakeholders management skills with decent client facing experience at multiple onsite location.
• Ability to solve complex issues with focus on delivery, strong decision-making capabilities. Good inter-personal skills and organizational skills.

TECHNICAL SKILLS:

Scripting Language: UNIX Shell scripting, Python, BTEQ, TPT, SQL, XML

Data Modeling: Logical, Physical, Multi-Dimensional, Star, Snowflake, OLAP, ROLAP

Big Data Ecosystem: Map Reduce, Hive, HDFS, SQOOP, HBASE, Oozie, HUE, AMBARI

DWH/ETL Tools: IBM Datastage 11/8.1/7.5.x, Informatica 10.1/9.x, SAP BODS

BI - Report Suites: IBM Cognos BI Suite 11, IBM Cognos TM1 11, SAP BI (My Insight)

Databases: Oracle - TOAD, SQL Developer, Teradata, MS SQL Server, IBM Mainframe DB2

SOA/API Testing: SOAP-UI Pro, IWS (Inter Networking Simulator)

Automation Framework: Robot Framework (RIDE) using Selenium

Test Management: HP QC & Application Lifecycle Management (ALM), Rational Clear Quest, JIRA, Rally

Operating Platforms: Windows - XP/7/8/10, LINUX (using Putty and WinSCP)

Other Utilities: GitHub, SVN, Jenkins, MS Office Suite, Project Professional (MPP)

PROFESSIONAL EXPERIENCE:

Confidential, Seattle, WA

Technical Lead/ETL Analyst

Responsibilities:

• Project Lead: Ownership and overall handling of end-to-end projects involving multiple DWBI and Big Data applications based on diverse technologies like Big Data (Hadoop), Teradata 16.10, Informatica 10.1.1, Oracle 12c, SAP-BI/BO etc. Planning and managing project resources across several phases of the project. Resource projections for active and pipeline intakes.
• Onsite-Offshore Synchronization: Knowledge transition and training offshore team, offshore query resolution, consistent enablement between client stakeholders and offshore team throughout project life-cycle. Scheduling daily/weekly status and deliverable review meetings with offshore team.
• Client Coordination: Regular reporting to client managers and other project stakeholders regarding the status of project/testing along with open risks, issues, dependencies as per established protocol. Conducting code review meetings, deliverable walkthroughs and automation demos with client SMEs.
• Requirement Gathering: Understanding overall project requirements from technical architects, functional analysts and client SMEs. Facilitating query resolutions and logging requirement changes. Getting technical insight of the project and applications involved in it. Working with upstream and downstream application teams for impact analysis.
• Project Estimation: Estimating test efforts in an effective way using diverse techniques like test case points (TCP) estimation, requirement complexity based estimation etc. Submitting and modifying estimates based on project scope, schedule and resource availability. Walkthrough with client managers for approvals.
• Test Planning: Overall test planning and scheduling. Drafting test strategy and plan documents based on project scope and applications involved. Gathering inputs from other teams and appending it to master test plan. Reviewing TS/TP documents based on changes received from client SMEs. Highlighting and resolving active risks, issues, dependencies.
• Test Design: Preparing and updating test scenarios and cases in-line with application functionality. Test design walkthrough with FAs, DAs and technical SMEs to ensure appropriate requirements coverage. Logging the approved test cases in QC/ALM and linking it to correct requirements.
• System Development: Coding and configuration of Informatica workflows, mappings, sessions with appropriate variable parameters. Working with aggregator, lookup, joiner, connected, unconnected transformations to create complex mappings. Create and update table, view DDLs based on technical requirements. Building UNIX shell scripts to run the workflows/jobs. Encode parametric files to accommodate new job parameters. Job scheduling using Control-M scheduler based on active dependencies. Debugging and fixing the errors, job failure by checking the job logs. Configure the Hadoop ingestion and dispatch jobs. Creating sqoop export jobs, managing sqoop entries for initial/incremental data loads. Working on HIVE tables, partition deletion, HDFS raw files for accurate data processing.
• Environment Setup: Assigning and cleaning up test environment before start of testing, setting up the required test data for execution, deploy the new code using Jenkins CI/CD and track the deployment progress for any discrepancies. Failure analysis and resolution.
• Execution and Validation: Prioritization of test cases, execution planning and blocker resolution. Data validation and data quality analysis including data completeness check, data transformation checks, data modeling validations, data sensitivity checks (encryption/decryption), data integrity/cardinality validations, exception/error handling checks, ETL logic validations, audit checks, historical data requirements like archival or purging validations, downstream data extracts, table metadata validations, ETL job performance, regression validations. Data validation in BO reports. Analyzing in case of failures.
• Defect Management: Rigorous defect tracking, defect review & analysis, arranging defect triage meetings, facilitation between different teams (Dev, QA, SMEs etc.) for resolution, retesting and closure.
• Project Reporting: Preparation and circulation of Daily Status Reports (DSRs), Weekly Status Reports (WSRs), Monthly Metrics, Estimated Vs Actual Testing Efforts etc.
• Test Closure: Preparation and review of Test Closure Report. Participating to the post implementation review meetings of the project. Circulating DEV/QA feedback on open defect.
• Delivery Management: Promote tested code package to production environment for live deployment. Consolidating test execution logs and evidences using HP QC/ALM. Tracking project delivery efforts in Rally to stay compliant with project guidelines.
• Test Automation: Development of automation scripts using shell/python scripting language and application regression testing through updated automation suite for multiple iterations. Identify, classify, configure and execute particular scripts for the respective functionality as part of test execution.

Environment: Informatica 10.1.1/9.5.1 , HUE (Hadoop), Oozie, Sqoop, Control-M 9.0, Tidal, GitHub, Jenkins CI/CD, HIVE, HDFS, Oracle 11g/12c, Teradata 16.10, MS SQL Server, UNIX, Python, SAP-BI/BO

Confidential, Austin, TX

ETL Analyst/Data Analyst

Responsibilities:

• Test Leadership: Complete control of dedicated ETL project integrated with its upstream and downstream applications based on multiple technologies - Informatica 9.6, UNIX, Oracle and SAP-BO.
• Client Reporting: Consistent reporting to client managers and other project stakeholders on project status along with open risks, issues, dependencies as per established protocol. Automation Demos.
• Estimation and Requirement Analysis: Enabling functional queries resolution and logging requirement or user stories changes. Efforts estimation, quotation and resource projections for upcoming Sprints.
• Planning & Scheduling: Planning and managing Sprint schedule. Preparation as well as review of project documentation - Functional Specification Document, Technical Design, Test Plan etc. Continuous updating documents based on schedule or scope changes to user stories, change requests, production defects or addition of user stories to current sprint.
• Test Design: Review of Test scenarios, Test cases and RTM in synchronization with Business Analysts, Technical SMEs and client stakeholders to analyze the requirement coverage achievement.
• Coding and Dev: Development, coding and unit testing for new enhancements, maintenance work and defect fixing. Working with Informatica workflows development, create tables, views and stats in DEV and QAT using Oracle. Functioning INFA workflow manager to schedule the workflows and run the sessions according to job dependencies. Developing UNIX shell scripts for processing/cleansing incoming text files, archive processed history files after certain interval. Implement SCD logics, surrogate key generation, complex ETL logics using Informatica transformations.
• Test Execution: Test execution of ETL functionality using Informatica Power Center 9.6 and Cron (UNIX) scripts. Data validation for target tables using Oracle - SQL utilities based on the S2TMs. BO Report functionality validation by executing the RIDE automation scripts built using Selenium Robot Framework. Data validations using Informatica DVO scripts.
• Defect Management: Defect tracking, Defect review and analysis, involvement in defect calls, assistance among various teams for Defect resolution, Defect retesting and closure using JIRA/iTrack tool.
• Status Tracking: Preparation and circulation of Daily Status Reports (DSRs) as well as Weekly Status Reports (WSRs) to client management for tracking test progress on user stories
• Closure: Preparation and review of Test Closure Report. Contribution in project review meetings.
• Test Supervision: Consolidating and organizing test results using Test Link for further audit purpose. Effort tracking using JIRA/iTrack.
• Onsite-Offshore Coordination: Transferring project knowledge to offshore team, offshore query resolution, consistent communication all the way through test life-cycle.
• Test Automation: Automated script execution by using Rational Robot Framework (RIDE).Continuous enhancement of automation framework (Rational Robot) for various scenarios and new reporting functionalities using the efficient automation suite.

Environment: Informatica Power Center 9.6, Informatica DVO,SAP-BI/BO, Oracle 11g, UNIX scripting, Cron-Scheduler, Rational Robot Framework (RIDE) using Selenium and Python, SVN Code Repository, WinSCP.

Confidential

ETL Analyst/Data Quality Analyst

Responsibilities:

• Participating in business requirements gathering meetings to collect business needs for Business Reporting and Financial Budgeting applications.
• Responsible for providing test effort estimate and capacity planning. Preparing and submitting effort estimation for multiple test phases.
• Preparation of test strategy and plan for testing the requirements. Designing test scenarios as well as cases based on client requirements.
• Interfacing with the client application SMEs and business consultants to clarify the requirements and modifying test plan as per changes or clarifications received.
• Perform execution of data extraction/transformation loads using IBM Datastage 11.0 across multiple schemas and stages.
• Analyze, query and manipulate data according to defined business rules and procedures. Develop and execute data cleanup measures.
• Execution of the test cases to validate the business requirements for backend data validation, BI reporting functionality and budgeting application functionality - CAPEX, OPEX, MANPOWER.
• End to end functionality testing for BSC-SM, CAPEX, OPEX, MANPOWER planning applications using IBM Cognos TM1 Performance Management tool. Execution of Test cases for ETL and BI reporting functionalities using IBM Datastage and IBM Cognos BI suite.
• Evaluate large dataset for quality and accuracy. Identify, compare, and resolve data quality problems.
• Determine root cause for data quality errors and make recommendations for long-term solutions. Work with ETL and Reporting developers to correct data quality errors.
• Verify generated test reports and analyze the root cause of the failed test cases. Defect Management and tracking through macro based excel.
• Perform system integration testing, end to end testing, regression testing and sanity testing for all the in scope applications.
• Validate the downstream application data for the correctness like backend DB to Cognos reporting layer.
• Coordinate with the team members to ensure the completeness of Deliverables.
• Develop process improvements to enhance overall data quality.

Environment: IBM Datastage 11.0, IBM Cognos BI Suite 11.0, IBM Cognos TM1 11.0, Oracle 11g, UNIX, Flat Files, WinSCP

Confidential

ETL Analyst/Data Quality Analyst

Responsibilities:

• Interact with client SME and gather application knowledge. Support preparation on project test plan and test scenarios.
• Test case preparation for data load jobs and upload in HPALM using macro. Identify test data requirement and set up the test data in test environment.
• Test execution of ETL functionality using Informatica Power Center 9.0 and UNIX scripts. Data validations for DB applications by writing SQL queries. ETL batch processes test using UNIX shell scripting.
• Compared DB results by writing SQL queries, macro based excels and tools like beyond compare.
• Understanding Hadoop application, Map Reduce and write queries on HIVE DB. Validate source and target data in HIVE.
• Defect tracking, defect review and analysis, involvement in Defect calls, assistance among various teams for Defect resolution, Defect retesting and closure using HP-ALM.
• Arranging walkthroughs and reviews for test results with clients and application SMEs.
• Status reporting to managers, application SMEs and other stakeholders on testing progress.

Environment: Informatica Power Center 9.0, Oracle 11g, UNIX scripting, Teradata SQLA 13.0, Mainframe DB2, Informatica Power Exchange, WinSCP, HUE, HIVE, Mongo DB.

Confidential

ETL Analyst/Data Quality Analyst

Responsibilities:

• Handling of individual projects involving single or multiple applications.
• Coordination with onsite team for getting knowledge and understanding on project.
• Requirement Gathering: Understanding overall project requirements from onsite leads and client SMEs. Getting query resolutions and logging requirement changes.
• Test Design: Preparation and review of Test Scenarios/Conditions as well as Test Cases with onshore leads to analyze requirements coverage.
• Execution of Test cases by performing job runs and respective output validations as per application functionalities. Complete control of ETL application involving IBM Datastage, DB2, Teradata and Oracle.
• Smoke testing, risk based testing and static testing. Executing ETL jobs using IBM Datastage 8.1/7.5.x. Working with Oracle/Teradata databases and querying the tables to fetch necessary data.
• Executing UNIX scripts for file validations and file transfers to landing zone. Working with Mainframe DB2 to setup the necessary test data.
• Understanding the data transformation and ETL logics. Working with large datasets to check for the desired output. Data quality analysis and resolving data quality issues.
• Defect tracking in HP QC, root cause analysis, participating defect meetings, working with dev team for resolution, defect retesting and closure.
• Preparation and circulation of Daily Status Reports (DSRs), Weekly Status Reports (WSRs) and Delivery Dashboards.
• Consolidating the execution logs and evidences in HP Quality center as per the project guidelines.

Environment: IBM Datastage 8.1/7.5.x, Teradata 13.0, Oracle 10g/9i, Mainframe DB2, UNIX, Flat Files, WinSCP, SOAP-UI Pro, XML