SUMMARY

• Around 10 years of experience in Information Technology worked in various roles as a Scrum Master, Project coordinator, Implementation/Release Coordinator, Hadoop/Data Lake QA lead, ETL/Informatica developer.
• Experienced in facilitating and implementing scrum process, having hands - on skills in various technologies like Hadoop, Data Lake, ETL, Data Ingestion application Development, Testing and DevOps.
• Also, experienced in Implementing cross platform multiple complex projects using agile project methodologies and having excellent project coordination skills worked with team size ranging from 5 - 25.
• Around 10 years of experience in IT Industry in Analysis, Design, Development, Testing and Implementations of various software applications mainly in Hadoop, Data Warehousing and ETL Data Pipeline (Informatica) applications in industry verticals like Insurance and Healthcare.
• Having experience as a Scrum Master facilitating Spring ceremonies includes Release Planning, Sprint Planning, Daily stand-up meetings, Sprint Demos, Sprint Retrospective.
• Responsible for Scrum team performance including the team’s commitments and quality of the deliverables and ensure that all standard scrum practices are followed by the scrum team and improve the effectiveness of their practices by self-organizing and taking the decision as needed.
• Having experience in Software Quality Assurance methodologies and strategies with strong technical skills in Testing and Defect Management.
• Having experience in testing ETL applications, Cognos and OBIEE Reports.
• Have good experience on database query tools such as Data Studio, PGAdmin, Oracle SQL Developer and MS SQL Server.
• Having experience on Big data testing and experience on hadoop components like HDFS, Kafka, Flume, Spark, PIG, HIVE, Oozie coordinator, Prepared Pig ETL scripts and defined Hive tables/views for User validations.
• Expertise in Unit, Integration, System, System end to end, Functional, testing with good interaction with developers, Product owners, managers, UAT users, and team members to coordinate job tasks.
• Having experience with ALM (Test Management Tool), VersionOne, and Test Link.
• Having experience in ETL Methodology for supporting of Extract, Transform and Load using Informatica Power Center extensively having experience on (Designer, Repository Manager, extensive experience in using various informatica Designer Tools like Source Analyzer, Transformation developer, Mapping Designer, Schedulers and Target Designer.
• Having experience as a Change/Release coordinator worked on complicated project and coordinated with various teams to implement various changes like Hadoop, Informatica, JAVA, (Mainframe)Host and Database in Pre-prod and production environment.
• Extensively worked with HP Service Manager Tool, actively involved in implementation activities like Issuance preparation for Hadoop, UNIX and Informatica components and Autoflow chart preparation for Control-M (scheduling tool). Coordinated with various teams having successful implementation in SIMPORD (Pre-PROD) and PROD environments.
• Coordinated with stakeholder during development, Testing, and implementation in Pre-prod and Production.
• Worked with Project Manager throughout project development life cycle updated the development status on daily/weekly basis.
• Having excellent analytical, communication, documentation and interpersonal skills.

TECHNICAL SKILLS

Hadoop: HDFS, Kafka, Flume, PIG, HIVE, Oozie, Spark, Scoop

ETL Tools: Informatica Power Center 9.x/ 8.x/7.x

Test Management Tool: ALM (Application Lifecycle Management), VersionOne, Test Link, Trac defect

Service Manager: HP Service Manager 7.11

Databases: Oracle, SQL Server, DB2, Postgres

Languages: C, C++, SQL, COBOL, Python

RDMS Query Tools: Data Studio, Postgres, PGAdmin, Oracle, MS SQL Server

Automation Testing Tools: Load Runner, Quick Test Pro (QTP)

Operating Systems: Microsoft Windows NT/98/XP, Linux

Methodologies: SAFe Agile (Scrum and Kanban)

Reporting: Cognos

Scheduling Tool: Control-M, Oozie Coordinator

PROFESSIONAL EXPERIENCE

Confidential, Richardson TX

Scrum Master

Responsibilities:

• Conducting Scrum ceremonies includes Release Planning, Sprint Planning, Daily stand-up meetings, Sprint Reviews, Sprint Retrospective, Product Backlog Reviews.
• Organizing all aspects of Sprint delivery includes analysis, design, development, testing, deployment activities in Test, pre-prod and Prod.
• Conducting daily stand-up meetings to understand the status of the Sprint reviewing sprint stories with team.
• Conducting and updating capacity and velocity planning.
• Responsible for Scrum team performance including the team’s commitments and quality of the deliverables.
• Monitoring Internal dependencies, and working with other teams to have strategy on external dependencies.
• Eliminating the impediments and helping the team to achieve their goals successfully on timely manner.
• Organizing Spring Retrospective meetings and documenting lesson learned, Scrum team improvement sessions.
• Negotiating the scope and timelines with the leadership, depending teams and stake holders.
• Encouraging the team to create required artifacts and maintained.
• Attending and updating teams progress in scrum of scrums meetings and resolving dependencies and roadblocks.
• Ensure that all standard scrum practices are followed by the scrum team and improve the effectiveness of their practices by self-organizing and taking the decision as needed.

Confidential, Bloomington, IL

Hadoop QA Lead

Responsibilities:

• Gathered requirements from Business Analyst and Agile Development team through formal meetings and prepared System test Plan.
• Created test cases for shakedown testing, Integration testing and System end to end testing, functional testing and uploaded in Test link tool.
• Created Linux scripts, Pig ETL scripts, Hive tables/views to validate various scenarios which execute on xml files, Json file, CSV files.
• Coordinated with Hadoop admin team, and Developers for formal system test environment readiness.
• Coordinated with various stakeholders during System end to end testing, pre-prod test.
• Used VersionOne to log defect and conducted defect triage meeting.
• Updating status to Test Manager on daily basis and updates the tasks in VersionOne.
• Management tool.
• Prepared various test related document line System under Test (SUT) Visio diagram,
• System Test Plan, dependencies, Document of understanding (DOU) etc.
• Working with development team to gather information related to deployment and creating change record in HPSM and coordinating with Agile team and business partners for technical and functional checkout during pre-prod and Prod.

Environment: Hadoop HDFS, Kafka, Flume, Hive, Spark, Oozie, HPSM, Test link, VersionOne, SoapUI and PGAdmin query tool

Confidential, Richardson TX

QA Analyst & Onsite Project Coordinator

Responsibilities:

• Preparing Test timelines and involved in the creation of Test Plan.
• Coordinating with Product owners, Test team during Pre-release Testing and System Testing.
• Creating Test cases and uploading in Test Link (Test Management Tool).
• Executing Test cases on need basis and logging defect if any.
• For Development and testing roadblocks like issues and defects, coordinating with different teams and ensuring that they get resolved within the SLA.
• Coordinating during acceptance testing, Implementation testing and Production. Monitoring ESR updates on servers during scheduled time.
• Create and maintain the implementation plan.
• Working with offshore team in creating change records in HP Service Manager Tool and providing instructions based on server types present in the scope.
• Preparing task sheet and schedule for implementation which includes dependencies tasks etc.
• Coordinating various application and support teams to complete pre-tasks before TEST and Production.
• Monitoring server updates during implementation ensuring ESR updates are completed as expected. In case of issues during Implementation, analyzing the issues and coordinating with OS team and support Team

Confidential, Bloomington, IL

Release/Implementation Coordinator

Responsibilities:

• Create and maintains theImplementationPlan.
• Create ChangeRecord in HP Service Manager Tool for Implementing Project and Service changes.
• Coordinate with various teams and planning information about theImplementation of the project.
• Facilitate engagement and readiness assessments of work effortsinclude Test, SLM, Configuration Management and Change.
• AssistProjectManager in coordinating Change Management activities throughout theProjectlifecycle.
• Support theProjectManager in carrying out activities that have been delegated to the Implementation.
• Ensure allchangetasks are being completed in a timely manner.
• Monitor external dependencies to the projectand communicates any impacts to theprojectteam.
• Ensure outstanding defects (known errors) are reported and managed.
• Coordinate IT service and business functional support throughout theprojectlifecycle until acceptance by Service.
• Work withReleaseCommunications to create appropriate communications to all stakeholders regarding aproject implementation.
• Provide input to the final implementation sign-off process from Change Advisory Board.
• Develop Executive Go/No-Go Decision Documentation.

Environment: Host, Existing +, JRA, WAS 8.5, WAS 6.1, TP, Data Base and Message Broker changes.

Confidential, Bloomington, IL

Content Developer

Responsibilities:

• Apply instructional design principles and project standards to content and leverage standard tools, processes and methodology
• Manage design and development of training materials for assigned segment
• Conduct onsite interviews with the SMEs to understand the content and develop the course material accordingly
• Update training content based on input received
• Draft and manage corporate style guide and terminology conventions
• Utilize Microsoft Word and Power Point to provide information in a well-organized, convenient form, while ensuring the overall quality and accuracy of content
• Provide comprehensive editing services, including substantive editing, copyediting and proofreading

Confidential, Charlotte/Troy

ETL Test Analyst

Responsibilities:

• Involved in the creation of MTP which includes gathering project related information from the Project meetings, TDD’s, Requirement Documents.
• Attending daily stand up meeting to update the project status, work accomplishment and road blocks to the lead.(Agile Methodology)
• Uploading requirements into ALM (Application Lifecycle Management) tool.
• Creating Requirement traceability matrix in ALM.
• Creation of Test cases and uploading test cases into ALM and Creating Test Lab.
• Validating test cases based on mapping rule and Requirement document and logging defect to development team with evidence in ALM.
• Once defects are fixed, validated and close the defect and sending execution status to team related to project.
• Creating Test summary Report.

Environment: ETL tool Data stage, Databases: OracleDB2, and SQL Server, Query tools: SQL developer, SQL Server Management Studio, OBIEE.

Confidential, Bloomington, IL

ETL Developer, ETL Test Analyst

Responsibilities:

• Performed Environment setup for the team.
• Involved in preparing Mapping sheets and developing ETL mappings and Workflows for the source systems data extraction and data transformations.
• Extensively used transformations like expression, Lookup, Joiner, Sorter, Aggregator, Lookups, Filters, Stored Procedures, Update Strategy transformations.
• Identified the bottlenecks in the source, target, mapping, and loading process and successfully attended/resolved the performance issues across this project.
• Created parameter files, workflows using Workflow manager for different tasks like sending email notifications, timer that triggers when an event occurs, and sessions to run a mapping.
• For the high volume data used DB scripts to load data from staging table to atomic tables.
• Opened Change Records updated the task to move from Dev to Formal Environment, Formal environment to Production.
• Involved in implementation activities like Issuance preparation for UNIX and Informatica components and Autoflow chart preparation for Control-M (scheduling tool). Coordinated with various teams having successful implementation in PROD environments.

Environment: Informatica Power Center 9.5.1, DB2, UNIX Scripting, HP Service Manager DataStudio Query Tool

Confidential, Bloomington, IL

ETL Developer /QA Analyst

Responsibilities:

• Worked with business analysts, SME and technical advisor to achieve business and functional requirements.
• Used Informatica Power Exchange to create ETL mappings, sessions and Workflows for the source systems data extraction and moved the data from Salesforce into common target area such as EPMA Datawarehouse.
• For the high volume data we have developed Informatica extraction patters called PK chunking and Time Based Extract Patterns to extract the data.
• Created different parameter files and changed session parameters, mapping parameters and variables at run time.
• Written SQL queries and Database checkpoints to verify data quality prepared unit test report.
• Created workflows using Workflow manager for different tasks like sending email notifications, timer that triggers when an event occurs, and sessions to run a mapping.
• Executed Workflows and Sessions using Workflow Monitor.
• Identified the bottlenecks in the source, target, mapping, and loading process and successfully attended/resolved the performance issues across this project.
• In this process we have developed ETL process for 14 objects.
• Developed ETL procedures translates business rules and functionality requirements into ETL procedures.
• Involved in implementation activities like Issuance preparation for UNIX and Informatica components and Autoflow chart preparation for Control-M (scheduling tool). Coordinated with various teams having successful implementation in PROD environments.
• Responsible for creating business solutions for Incremental and full loads.

Environment: Informatica Power Exchange, DB2, UNIX Scripting, HP Service Manager DataStudio Query Tool, SQL, Flat Files.

Confidential, Bloomington, IL

ETL Developer and QA Analyst

Responsibilities:

• I involved in setting up environment for the team.
• Developed high level and detailed level technical documents to define the system components, development and implementation planning/strategies.
• Involved in preparing Mapping sheets.
• Designed and developed ETL mappings/workflows using Informatica Power Center to move the data from Host DB2 to Postgres DB2.
• Extensively made use of Transformations like Sorter Joiner, Lookup, and Filter.
• Wrote Param files and Unix Shell Scripts.
• Developed Test cases based upon the data mapping documents.
• Validated Test Cases and logged defect in Trac defect tool with the proper evidence.
• Preparing test summary report.
• Involved in implementation activities like Issuance preparation for Unix and Informatica components and Autoflow chart preparation for Control-M (scheduling tool).
• Coordinated with various teams having successful implementation in PROD environments.

Environment: Informatica Power Center 9.1, DB2, UNIX Scripting, HP Service Manager, Postgres Query Tool

Confidential, Bloomington, IL

Data Analyst

Responsibilities:

• In this project, involved in gathering requirements and designing phases.
• Gathered business rules by working closely with the Business Users and Business Analyst, documented the Business Specifications and transformed the same into Design Specs.
• Worked closely withdata modelers/DBA for data model designs.
• Analyzed the Business Requirements and Rules and worked with Business analysts and prepared Source to Target Specification (LLD) and 70 mapping sheets.
• Worked with Linux shell Scripts to validate the process of the vendor file receiving process.
• In this project I also worked on mapping business data elements to physical tables and columns.
• In this project, involved in gathering requirements and designing phases.
• Gathered business rules by working closely with the Business Users, documented the Business Specifications and transformed the same into Design Specs.
• Worked closely withdata modelers/DBA for data model designs.
• Analyzed the Business Requirements and Rules and worked with Business analysts and Prepared Source to Target Specification (LLD) and prepared mapping sheets as per business rules.
• Worked with UNIX shell Scripts to validate the process of the vendor file receiving process.

Environment: Informatica Power Center 9.5.1, DB2, UNIX Scripting, DataStudio Query Tool

Confidential

ETL Developer and Test Analyst

Responsibilities:

• Gathered business rules by working closely with the Business Users, documented the Business Specs and transformed the same into Technical and Design Specs.
• Worked closely withdata modelers/DBA for data mapping and data by-pass rules.
• Designed, developed and supported 40 ETL mappings/workflows for the source systems data extraction and data transformations for 40 tables.
• Gathered data from various sources like MAINFRAME (Host and UDB DB2), UNIX files and Delimited (CSV) files by FTP process and transformed the file layout to a common layout of the warehouse tables (DB2) which involved extensive Aggregations based on the key fields.
• Worked on Power Center tools like Designer, Workflow Manager and Workflow Monitor.
• Extensively made use of all Transformations like Aggregator, Sorter, Joiner, Lookup (connected and Un connected).
• Wrote Unix Shell Scripts to automate the process of the vendor file receiving process.
• Identified the bottlenecks in the source, target, mapping and target loading process and successfully attended/resolved the performance issues across this project.
• Designed the Informatica ETL processes for loading Stage layer / Atomic layer and DAL Layer.
• Involved in the requirements definition and analysis in support of Data Warehousing efforts.
• Performed unit test, load test, system testing, integration test and user acceptance tests.
• Prepared the Project documentation for design and Test related document like unit test cases, system test cases and user acceptance validations.

Environment: Informatica Power Center, DB2, Oracle, Mainframe Flat Files, UNIX Scripting, Optim

Confidential

ETL Test Analyst

Responsibilities:

• Analyzed the Business Requirements and Rules and worked with Business Analysts and Business Users in preparing Test Plans.
• Developed Test cases from the data mapping documents, functional Specification documents and mapped the test cases with the requirements for generating the Requirement Traceability Matrix (RTM)
• Validated Test Cases and logged defect if found in QC with the proper evidence.
• Conducted defect triage meeting with development team.
• When the defect was fixed retested and closed the defect.
• Preparing test summary report.
• Involved in preparing Low level design document.
• Development ETL mappings and Workflows for the source systems data extraction, data transformations and target loading.
• Extensively used transformations like Expression, Lookup, Joiner, Sorter, Aggregator, Lookup, and Filter.
• Created workflows using Workflow manager for different tasks like sessions, email notification task, and event task.
• Created different parameter files and changed Session parameters, mapping parameters, and variables at run time.
• Executed Workflows and Sessions in Workflow Monitor.

Environment: Informatica Power Center, DB2, Oracle, Mainframe Flat Files, UNIX Scripts