Ramyasri Bandla

Project:

 Title : Health care service center (HCSC) Medical Climes

 Environment : Data stage, SQL, Zena workstation, Unix ,Control-M

 Type : ETL Data Stage developer

 Duration : Jul 2022 – till date

Description: Health Care Service Corporation Bangalore, India Description: Health Care Service Corporation (HCSC) is the largest customer-owned health insurer in the United States and fourth largest overall, operating through Blue Cross and Blue Shield. Work with Upstream/Downstream Teams to acknowledge and complete their requests. Resolving Data Stage Director Job Issues, if connection / Resource Unavailable Errors. Analyzing Director Logs and informing the Onsite about the Findings. Helping L1.5 Team to Rerun common/usually failing jobs for known Errors.

Responsibilities:

 Thorough understanding business, application and analysis of Requirements.  Involved in Unit Testing and integration testing.

 Developing and Maintaining ETL jobs.

 Converting the design into well structured, high quality and usable/reusable data stage jobs and tuning the jobs for performance.

 Involved in development of ETL jobs using sequential File, dataset, Copy, Funnel, Pivot, Join, Lookup, Transformer stages.

 Extensively involving in daily scrum meetings with client, Business team and analysts.

 Creating web services for real time integration of jobs using Information Server Console and web console

• Roles and Responsibilities Projects Handled
• BELL TV Overview of BELL TV:
• BELL TV is the division of Bell Canada that provides satellite television service across Canada
• Launched on September 10, 1997 and formerly known as Bell ExpressVu
• Provides over 500 digital video and 100 HD and audio channels to over 2 million subscribers
• It offers various services such as Programming options, HD/SD channels,
• Premium sports, Pay Per View, Remote Personal-Video recording, Video On
• Demand (VOD), 3D TV (from 2010), iTV gaming
• Technologies used by the BELL TV applications:
• DataStage is an ETL tool which extracts data, transform and load data from source to the target
• The data sources might include sequential files, indexed files, relational databases, external data sources, archives, enterprise applications, etc
• DataStage facilitates business analysis by providing quality data to help in gaining business intelligence
• DataStage is used in a large organization as an interface between different systems
• It takes care of extraction, translation, and loading of data from source to the target destination
• It was first launched by VMark in mid-90's
• With IBM acquiring DataStage in 2005, it was renamed to IBM WebSphere
• DataStage and later to IBM Info Sphere.

Projects Handled

Consumer Electronics, Banking, Telecom, Audio System, Fast Food, Audio & Music System, Personal Care, Retail Stores, Luxury Brands, Airlines, EDAP, Information Technology.

Responsibility

Responsible for developing Sentiment Analysis Tagging

Responsible for analyze the user's intention and identify whether it relates an opinion, news, marketing, complaint, suggestion, appreciation or query.

Responsible for help and improve the customer experience by putting customer feedback to work.