Bhavani Kotla

Contact No: +* (***) *** - ****

Email ID: adt5cd@r.postjobfree.com

Summary:

Around 7 years of experience in System Analysis, Design, Development, Testing, and Implementation of Data Warehouse Applications using the ETL tools, IBM Infosphere DataStage, Informatica and SSIS.

Expertise in Dimensional Data Modeling, Star Schema modeling, Snowflake Schema modeling, fact and dimension table design, and physical and logical Data modeling.

Proficient in Extraction, Transformation, and Loading (ETL) processes using IBM Infosphere Information Server.

Implemented various Data Warehousing Methodologies using ETL/IBM Infosphere DataStage.

Extensive experience in working with Oracle, SQL queries, PL/SQL Stored Procedures, and Databases like Oracle, Postgres, SQL Server, and MySQL.

Extensively Worked on DataStage transformations including - Lookup, Filter, Expression, Union, Joiner, Update, Rank, Aggregator, Sorter, and Sequence Generator.

Experience in implementing Slowly Changing Dimensions Type-1&2 Methodologies.

Responsible for effective communication between the project team and the customer. Provide day-to-day project updates and status to the customer.

Expertise in preparing Functional & Technical Specifications besides User Guides.

Expertise in Debugging DataStage jobs for Error Handling, Bug Fixes, and Performance tuning by Identifying and Resolving various Bottlenecks at various Levels.

Good Experience in Scheduling the DataStage jobs using Autosys Application.

Good experience in Documenting Functional Specifications, ETL Technical Design, Mapping Details, Data Validation Test Cases, and Code Migration Guides.

Expertise in debugging PL/SQL Stored Procedures, Indexes, Functions, Procedures Triggers, and Cursors using DB2 and SQL Server.

Experience in writing Python and Unix Shell scripts to handle Source files, DataStage loads, and Notifying Business users.

Provided 24 x 7 support for the projects during go-live and postproduction support activities.

Excellent interpersonal and communication skills, technically competent and result-oriented with problem- solving skills and the ability to work independently and use sound judgment.

Expertise in Off-shore/On-site work culture, leading and mentoring Data Warehouse teams.

Good Experience in handling change requests related to DataStage, Unix, Stored Procedures, and DB2 Database.

Responsible for managing scope, planning, tracking, change control, and aspects of the project.

Involved in Migrating DataStage Components to higher Environments like Dev, SIT, UAT, and Prod.

Started career as an ETL DataStage tester and acclaimed client confidence in moving to the development team.

Experience in working with Agile Safe & Waterfall structure methodology and coordinating with onshore and offshore team members for Project Implementations.

Good communication, Interpersonal, learning, and organizing skills matched with the ability to effectively manage stress, time, and people.

Professional Skills:

ETL Tools IBM Infosphere DataStage, Informatica Power Center Data Modeling Relational and Dimensional Modeling, Entities, Attributes, Star Schema Modeling, Snow- Flake Modeling, FACT and Dimensions tables, physical, Azure Data Bricks, and logical data modeling

BI & Reporting Cognos and Power BI

Databases Oracle, MS SQL Server, DB2, Postgres

Other tools Autosys, Toad, PVCS, MS Office, JIRA, ALM, TFS, Beyond Compare, ServiceNow. Environments Windows10, Linux

Languages SQL, PL/SQL, Shell Script (Unix & Linux), Python, HTML. Education:

Bachelor’s Degree in Computer Science Engineering. 2012 -2016 Certifications:

DB2 9

DB2 10.1

98-381 Introduction to python programming

Microsoft Azure 900

Professional Experience:

Client: BCBSM, Michigan, US Aug 2021- Present

Role: ETL Tester/ Developer.

Responsibilities:

Testing Team:

Played various roles in this project as Tester, Developer, and Data Analyst.

Involved with the Business Analysis Team in collecting the business requirements based on user specifications.

Participated in various project planning sessions with managers.

Developed test plans based on test strategy for Data warehousing Applications.

Involved in developing the source-to-target process and mapping documentation.

Created and Executed test cases based on test strategy and test plans based on ETL Mapping Document.

Written Complex SQL Queries for querying data against different databases for the data verification process.

Prepared test scenarios to cover every Specification in Source to Target Mappings.

Created UAT test cases and Scenarios based on Use cases and ensured those cases met the business requirements.

Used Quality Center to track and report system defects design and execute the test cases on the application as per company standards.

As a Developer working on a few codes change issues according to Business Requirements.

Involved in Performance tuning of SQL Queries and Debugging the Stored Procedures. Migration Team:

Tested Automated SSIS packages for data migration and integration processes between multiple systems, including Oracle EBS, SharePoint, SQL Server databases, etc.

Provided technical support for existing production environments by troubleshooting issues within SSIS packages deployed across the organization’s infrastructure.

Involved in testing various SSIS packages that extract data from various data sources including SQL Server databases, Excel spreadsheets, and text files.

Part of validating SSIS packages which load data into the data warehouse according to the defined schedule.

Environment: Informatica Power center, SSIS, Control M, Windows 10, Postgres, Oracle, SQL Server Management Studio, SSAS, SSRS, PL/SQL, JIRA.

Client: Prudential Financials, IBM. Hyderabad Oct 2019 - Jul 2021 Role: ETL Tester Project 3:

Responsibilities:

Performed Data Profiling, Data Migration, Extraction, Transformation, and Loading using DataStage and designed data conversions from a wide variety of source systems including Oracle, DB2, SQL Server, Hive, and non - relational sources like flat files, and XML.

Worked on DataStage tools like DataStage Designer, DataStage Director, and DataStage Administrator.

Involved in Business meetings to understand the business requirement specifications and implemented the ETL jobs using the Data stage.

Involved in analysis, requirements gathering, functional/technical specifications, development, deployment, and testing.

Engaged in significant interaction with business users and senior management, effectively communicating highly technical information.

Installation, configuration, setup, and Administration of Data Stage Server.

Involved in developing the source-to-target process and mapping documentation.

Participated in the review and approval of the technical transformation requirements document used to design and build the ETL modules in Data stage Designer.

Participated in daily status meetings.

Developed parallel jobs using various stages of the transformer, join, look up and merge.

Extensively used Email Notification, Nested Condition, Sequencer, and Terminator activities in Job Sequences.

On Data stage 11.5 Extender extensively used the Filter, Copy, Funnel, Data Set, Join, Merge, Aggregator, Column Generator, Sort, SCD, and Remove Duplicate stages.

Utilized the parameter set feature in Data stage 11.5 to create common project-level parameters.

Used the Data Stage Administrator to assign privileges to users or user groups (to control which Data Stage client application or jobs they see or run), move, rename, or delete projects and manage or publish jobs from development to production status.

Used Director for executing, analyzing logs, and scheduling the jobs.

Created jobs in Autosys to schedule ETL Code in the development environment and migrate the code to the production environment.

Involved in code migration activities by checking into code into TFS, creating a build, and deploying the code to QA and UAT environments.

Schedule the DataStage jobs using DataStage director and using scripts in Autosys Scheduler to schedule and run jobs.

Written a few shell Scripts to Automate the Regular Report Generation activities and scheduled these activities through Autosys JILS.

Prepared Unit Test Query to Test and Validate the Target Data in DEV, SIT, UAT, and PROD Environments and Documented for Business help.

Followed Agile methodology for completion of stores from development to production migration. Environment:

IBM Information Server 11.5 (DataStage, Quality Stage, and Information Analyzer), Windows 10, Unix Shell scripting, TOAD, DB2 10.1, Oracle, SQL Server, PL/SQL, and Autosys. Project 2: Prudential Financials Mar 2018 - Sep 2019 Role: ETL Tester

Responsibilities:

Participated in discussions with the Project Manager, Business Analysts, and Team members on different Business Requirement issues.

Worked on the existing documents and developed the required technical specification per business needs.

Worked on extracting data from Flat files, Sequential files, and Oracle database.

Designed ETL jobs by identifying various source files and applying transformations and ETL logic to them.

Developed various jobs using stages like Transformer, Lookup, Datasets, Funnel, Change Capture stage, Change Apply stage, Sort, Copy& Job Activity Stages, etc.

Mapped Data Items from Source Systems to the Target System.

Performed performance tuning of Data Stage jobs to improve the extraction, transformation, and loading time of data Worked on Fast track component of IBM Information Server 9.1 for mapping source to target subject area

Validation of all the metrics is done well in advance, before migrating it into a production environment.

Used the DataStage Director and its run-time engine to schedule running the solution, testing, and debugging its components, and monitoring the resulting executable versions.

Extensively used UNIX Shell Scripts to trigger the DS jobs through a Master Sequencer.

Developed UNIX shell scripts to automate data loading in batch mode.

Used Control M to schedule the jobs based on prerequisites in and dependencies out of the jobs.

Performed Unit testing for jobs developed to ensure that it meets the requirements. Environment:

IBM Information Server 11.5, Data Stage 11.5(Designer, Administrator, Director), Oracle, Autosys, PVCS, Unix, SQL Developer Client, Windows 10.

Project 1: Prudential Financials Sep 2016 - Feb 2018 Role: QA Automation

Responsibilities:

Analyzed and understood the ETL workflow Developed.

Strong in Validating ETL Data, transformations, and End to End data using DataStage and BI Systems.

As an ETL tester needs to validate whether the data from source to target is populating correctly by performing Integration Testing.

Worked closely with Software developers/project owners and BAs to develop and execute thorough test suites in all phases of the software development cycle.

Develop test strategy, test plan/design, execute test cases, and defect management for the ETL workflows.

Prepared the functional, and integration test scripts and captured test Evidence.

As there are many transformations from source to target need to write the query according to it to validate the Overall Data from Source to Target.

Tested for different scenarios either source is file/table, and the target may be table/file.

Worked in migration testing to validate the new workflow and jobs. In this, we need to compare the existing ETL jobs against newly migrated jobs in Oracle Database.

Validated the historical data as we need to migrate data from DB2 to oracle hence old data must be validated for its correctness.

Need to Validate Data type and Data Size of the fields.

Mappifieldic check for each field as per ETL mapping documents.

Data truncation checks and Row count checks.

Identified the test cases for the scenarios to test and prepared the SQL scripts according to the test scenario.

Written complex SQL scripts to perform Unit and Integration testing on Source to Target data and notify the application team.

Documented all the findings to keep track of what works and what doesn’t.

Identified the test Automation Opportunities to improve the efficiency and effectiveness of test services.

Executed the test cases according to the test results, capturing the positive and negative result sets and attaching them to the respective test case.

Documented and reported the defects found during test cycles and participated in defect prioritization sessions.

Worked on task Estimation and assisted team members to keep the overall project on target by committing to the schedule.

Active participation in technical, scrum calls, retrospective, backlog grooming, sprint review, sprint planning, and sprint demo sessions.

Environment:

Data Stage 9.1(Designer, Director), DB2, Beyond Compare, Microsoft Excel, HP ALM, Autosys, Putty, Unix, Toad, Windows 10.

Contact this candidate