Basireddy Sravani

ETL Developer

Professional Summary:

8+ years of work experience in IT implementing IBM InfoSphere / Data stage as ETL Tool in a Data warehouse environment and business intelligence applications.

8 years of experience in systems design, analysis and programming.

Experience in building Data Marts using Multidimensional Model (Kimball and Inmon).

Participated in requirements gathering and created Source to Target mappings for development.

Experience in designing parallel Jobs using various stages like Transformer, Joins, Merge, Lookup, Remove Duplicate, Filter, Sort, Copy, Funnel, Sequential file and dataset Stage. Actively involved in Unit Testing Data stage Jobs.

Expert in designing Server jobs using various types of stages like Sequential file, Hashed file, Aggregator, Transformer, Sort, Link Partitioner and Link Collector.

Worked on Sequence Jobs to Control the Execution of the job flow using various Triggers and Activities like Job Activity, Email Notification, Sequencer, Routine activity and Exec Command Activities.

Good Knowledge on Data warehousing concepts, relational database management systems and Dimensional modeling (Star schema and Snowflake schema).

Implemented Slowly Changing Dimension phenomenon with type 1 and type 2 while building Data Warehouses.

Implemented ETL processes using DataStage designer to load data from Oracle, Flat Files and XML files to staging database and from staging to the target Data Warehouse database.

Ability to integrate with External data sources including Oracle databases, SQL Server databases, Flat files (fixed-length and delimited), XML files.

Expert in unit testing, system integration testing, implementation, maintenance and performance tuning.

Documented ETL test plans, test cases, test scripts, and validations based on design specifications for unit testing, system testing, functional testing, prepared test data for testing, error handling and analysis.

Experience in integration of various data sources like Oracle, Teradata.

Knowledge on understanding Web Services (SOAP).

Scheduled job runs using DataStage director, and used DataStage director for debugging and testing.

Created shared containers to simplify job design.

Experience in different Scheduling tools like TIVOLI for automating and scheduling jobs run.

Possess strong ability to quickly adapt to new applications, platforms and languages

Excellent interpersonal and communication skills

Ability to work under pressure to meet job requirements and deadlines

Scheduling and monitoring jobs using Tivoli Work Scheduler.

Building, publishing customized interactive reports and dashboards, report scheduling using Tableau desktop and Tableau server.

Developed Tableau visualizations and dashboards using Tableau Desktop.

Developed Tableau workbooks from multiple data sources using Data Blending.

Achievement & Education

Bachelor of Engineering in Information Technology. India

Achieved PAT ON THE BACK award for the delivering complex project on time.

Achieved CORONA Award for 5CC project.

Technical Skills:

Databases : Oracle 10g, DB2 LUW, SQL Server

ETL Tools : IBM Info Sphere 8.x, 9.1, 11.3

Operating Systems : UNIX 4.3 and Windows

Tools : SQL developer, File Zilla, TOAD

Languages : SQL, UNIX

Reporting Tools : Tableau, IBM Cognos

Professional Experience

CSSOP, Verizon, Dallas, TX

Sr. DataStage Developer

July’16 to Till date

CSSOP refers to Customer Self Service and Operations. This project tracks the call logs and Bill logs for an each customer. The data from transactional database is loaded into data warehouse on day to day basis onto the different tables. The data is further loaded used for generating reports.

Responsibilities:

Participated in Business Analysis Development and Gathering Requirements phase and worked on Source to Target Mapping (STT) document.

Wrote SQL queries using joins, sub queries and correlated sub queries.

Worked SCDs to populate Type I and Type II slowly changing dimension tables from several operational source files.

Experienced in PX file stages that include DataSet stage, Sequential file stage.

Developed new jobs to load data from different Source systems such as Oracle, Flat files to staging tables.

Used different stages like lookup, Join, Merge, Filter, Sort, Funnel, Remove duplicates, Transformer Copy, Dataset file to load the data into target systems as per the business rules.

Debug, test and fix the transformation logic applied in the parallel jobs

Used the ETL Data Stage Director to schedule and running the jobs, testing and debugging its components & monitoring performance statistics.

Worked Extensively on DataStage Director for scheduling the Job to run and monitoring the jobs.

Involved in executing UNIX scripts using routines and parallel jobs.

Developed SQL scripts to load data from source systems and verify the data in target tables loaded correctly by ETL process.

Constructed SQL Scripts to validate the data after loading process.

Defined test scripts, test specs & testing methodologies.

Skill Sets:

IBM Infosphere DataStage 9.1, Oracle SQL, Flat files, Sequential files, TOAD, Microsoft Visio, IBM Cognos 8.0, and UNIX.

EPS,PDX, Dallas TX

EDW/DataStage Developer

June’15 to June'16

EPS refers to the Enterprise Prescription Processing. The Physician enters all the details of the patient and generates the prescription and this prescription is routed to the concerned patient and the patient’s data is loaded into various tables and Files. These tables are used to generate reports for further analysis.

Responsibilities:

Used Tivoli to schedule the jobs and for monitoring the jobs.

Involved in Analysis, Requirements gathering, SRS (Software Requirement Specifications) & HLD (High Level Design Document) & LLD’s (Low Level Design Document).

Worked on different types of transformations like, filter, aggregator, stored procedure, row generator and join.

Preparation of technical specification for the development of Data Stage Extraction, Transformation and Loading (ETL) mappings to load data into various tables and defining ETL standards.

Extracted data from multiple relational databases, i.e. Oracle 11g, Teradata to implement the business requirement.

Participated in weekly end user meetings to discuss data quality, performance issues. Ways to improve data accuracy etc.

Implemented mappings such as Slowly Changing Dimensions and Change data Capture (CDC).

Worked on Tivoli tool to schedule and Monitor jobs.

Developing test cases and carrying out Unit Testing.

Ensure that the defects for each task are being logged on to the defect tracking system and analyzing the defects and fixing those in a timely manner.

Skill Sets:

IBM Infosphere DataStage 9.1, Oracle SQL, Flat files, Sequential files, TOAD, DB2 LUW, Microsoft Visio, and UNIX.

EPG Fortification, BELL Canada, Austin TX

ETL Developer

Jan’14 to May ‘15

The ISERVICE EPG FORTIFICATION, project is based on testing XML files. EPG File and GLF files are the source files and the data will be loaded into different Target systems like Sling target System.

Responsibilities:

Implemented data mapping from source to target in view of the physical data models.

Used the DataStage Designer to develop processes for Extracting, Cleansing, Transforming, Integrating, and Loading data into Data warehouse.

Participated in requirement analysis and gathering to provide technical support to the team.

Involved in Job Design, Technical Reviews and Troubleshooting of jobs.

Worked on the logical and physical design of the Data warehouse. Identified sources/targets and analyzed source data for dimensional modeling.

Involved in creating and maintaining Sequencer and Batch jobs.

Creating local and shared containers to facilitate ease and reuse of jobs.

Designed XML stages for reading XML log files for capturing data stage jobs audit data.

Performed Unit Testing and tuned for better performance with updates on data warehouse tables using DataStage Director for jobs Monitoring and Troubles Shooting.

Developed the data warehouse repository using DataStage Manager by importing the source and target database schemas.

Maintained and configured the DataStage with a database back up of Oracle.

Distributed load among different processors by implementing the partitioning of data in parallel.

Vastly worked on Data Stage Job Sequencer to Schedule Jobs to run jobs in Sequence.

Worked with Reporting team for graphical representation of data.

Defect Tracking, unit testing, defect reporting, analyzing results and documentation.

Skill Sets: IBM Infosphere DataStage 8.5 (Parallel & Server), Oracle 9i, Flat files, XML files, TOAD, Filezilla, XML Marker.

5CC, BELL Canada, Austin TX

DataStage Developer

July’12 to Dec ‘13

5CC - CSG service codes are used in Bell TV environment primarily to support the billing of Bell TV products and services to Bell TV subscribers. New service codes are typically generated to support channel launches, programming platform introductions, promotional and other marketing offers. Programming service codes, non-programming service codes, package codes and adjustment codes presently all share the same range of 2-character alphanumeric expressions, amounting to a maximum of 2,916 unique combinations.

Responsibilities:

Interacted with Data analysts and DBA’s to understand different Data sources.

Worked with multiple teams to setup development, test and production DataStage environments which included creation of DataStage projects, estimation of file system size, configuring database connections, creation of user ids for databases, queues, ftp etc.

Developed the DataStage sequencers, Unix shell scripts to trigger the DataStage jobs

Extensively used Transformer, Lookup, Join and Oracle Stages

Implemented Slowly Changing Dimensions for accessing the full history of accounts and transaction information

Developed DataStage jobs implementing very complex business transformations and also involved in code review, performance tuning.

Worked on test data setup for unit testing and provided technical support during system, integration testing.

Modifying the existing jobs for increasing the length of the service code

Running, monitoring of the jobs using Data Stage Director and checking logs to check if the jobs are not impacted with the changes.

Documenting all the impacted jobs for further analysis.

Created Unit test Cases and performed System Integration Testing.

Skill Sets:

IBM Infosphere DataStage 8.5, Oracle SQL, Flat files, Sequential files, SQL Developer, Microsoft Visio, and UNIX.

OTTO, BELL Canada, India

EDW/DataStage Developer

Apr’11 to June ‘12

Bell introduced a new TV product OTTO which will enable customers to consume live Bell TV streaming online on a mobile device (i.e. cell phone or tablet, using Apple IOS or Android).

Responsibilities:

Used Info Sphere Data Stage 8.5 as ETL tool to extract data from source systems such as Oracle, Flat Files to target tables and files.

Sequential File, Aggregator, Transformer, Hashed-File, Sort, FTP Plug-in Stages were used to develop the server jobs.

Employed in writing SQL Queries (Sub queries and Join conditions)

Developed the ETL Development Standards and Best Practices to design the Data Stage Parallel jobs consistently across the project.

Used Data Stage Designer to Import and Export Data Stage components and Import table definitions from source databases.

Used UNIX Shell Scripts to execute Data Stage jobs. Developed shell scripts to automate file manipulation and data cleansing procedures.

Attended several business sessions with the business users and created daily and monthly.

Wrote custom SQL queries to extract the suitable data from Oracle sources and to perform joins between various tables in the respective databases.

Used Built-in, Plug-in and Custom Stages for Extraction, Transformation and Loading of the data, provided derivations over DS Links.

Used the Data Stage Director for scheduling, validating, running and monitoring the jobs.

Involved in writing Test Plans, Test Scenarios, Test Cases and Test Scripts and performed the Unit, Integration, system testing and User Acceptance Testing.

Skill Sets:

IBM Infosphere DataStage 8.x, Oracle SQL, Flat files, Sequential files, SQL Developer, Microsoft Visio UNIX, UNIX Shell Scripting.

PPV Buy 1 Get 1 Offer, BELL Canada, India

ETL Developer/Tester

July’08 to Mar ‘10

PPV Buy 1 Get 1 Offer is targeting a predefined list of customers. If these customers order two PPV events valued at $6.99 within 31 days of each other, and within the offer eligibility dates, they are able to receive the second $6.99 event at no cost.

Responsibilities:

Used Info Sphere Data Stage 8.1 as ETL tool to extract data from source systems such as Oracle, Flat Files to target tables and files.

Used various stages like Sequential file, Dataset file, look up, sort, copy, funnel, filter, join, remove duplicates stages and Transformer stages.

Employed in writing SQL Queries (Sub queries and Join conditions)

Developed the ETL Development Standards and Best Practices to design the Data Stage Parallel jobs consistently across the project.

Used Data Stage Designer to Import and Export Data Stage components and Import table definitions from source databases.

Implemented Surrogate key functionality for newly inserted rows in Data warehouse which made data availability more convenient.

Used UNIX Shell Scripts to execute Data Stage jobs. Developed shell scripts to automate file manipulation and data cleansing procedures.

Attended several business sessions with the business users and created daily and monthly.

Wrote custom SQL queries to extract the suitable data from Oracle sources and to perform joins between various tables in the respective databases.

Used Built-in, Plug-in and Custom Stages for Extraction, Transformation and Loading of the data, provided derivations over DS Links.

Used the Data Stage Director for scheduling, validating, running and monitoring the jobs.

Skill Sets:

IBM Infosphere DataStage 8.x, Oracle SQL, Flat files, Sequential files, SQL Developer, COGNOS, UNIX.

Contact this candidate