Ram Chava

Work History

Work History
Jul 2010 - Present

Sr.Programmer

Accenture Services Pvt Ltd.
Project Name: Well Point PA Reporting

Client                                                         : Express Scripts Inc.

Data Warehousing Tools Used            : Business Objects XIR2

Database Tools                                       : SQL Assistance 12.0

Databases                                                : Teradata

Duration                                                    : Aug 2011 – Till Date

Role                                                            : Developer

Team Size                                                 : 6

Project Description:

Express Scripts is a Fortune 150 pharmacy benefits management company headquartered in St. Louis, Mo., with four other major facilities within the U.S. (Bloomington, Minn., Bensalem, Pa., Tempe, Ariz., and Orlando, Fla.).

The mission for Express Scripts as a company is to make the use of prescription drugs safer and more affordable for tens of millions of consumers through thousands of employers, government, union and health plans

Role: As a BO Developer, I am responsible for the following activities

  • Responsible for Projects plan, documentations (Design documents, Mapping Documents).
  • Developing the Reports using WebI
  • Writing complex queries to implement the logic behind the reports.
  • Updating/Creating derived tables in universe through designer.
  • Testing - unit testing of the reports before delivering to the clients.
  • Supporting QA/UAT teams during report testing.
Project Name: Express Alliance (EXA Reporting)

Client                                                   : Express Scripts Inc.

Data Warehousing Tools Used     : Business Objects XI R2

Database Tools                                 : SQL Assistance 12.0, SQL Developer.

Databases                                          : Teradata, Oracle 10g.

Duration                                            : Dec 2010 – Aug 2011

Role                                                     : Developer

Team Size                                           : 6

Project Description:

EXA (Express Alliance) A web-based application that provides Pharmacy Benefit claims information to a customer's medical management vendors.  Data is organized by Intervention Types and provides a mechanism for gathering the actionable information options performed with the patient by the vendor.

EXA system allows, ESI customers to contact the patients for enrolling them into selected campaigns to provide clinical opportunities/benefits to the patients.

Role: As a BO Developer, I am responsible for the following activities

  • Responsible for Projects plan, documentations (Design documents, Mapping Documents).
  • Creating Business Objects Universe in XIR2
  • Developing the Reports using WebI
  • Writing complex queries to implement the logic behind the reports
  • Scheduling and executing the jobs that yield different reports.
  • Testing - unit testing of the reports before delivering to the clients.
  • Supporting QA/UAT teams during report testing.
  •  Post Production Support.

Project Name: ESI AO - V3 Production Support

Client                                                   : Express Scripts Inc.

Data Warehousing Tools Used     : Business Objects XI R2/XI R3

Database Tools                                 : SQL Assistance 12.0,SQL Developer.

Databases                                          : Teradata, Oracle 10g.

Duration                                            : Aug 2010 – Nov 2010

Role                                                     : Production Support

Team Size                                           : 4

Project Description:

V3 support team is responsible for supporting the PAP WEB V3 application, reports that are to be delivered to the client, maintaining production servers.

Role: As a support engineer, I am responsible for the following activities

  • Work on the Remedy/Iservice/QC Tickets created by the business
  • Interact with the business to under the issue.
  • Follow up for the UAT from the business
  • Implement the changes to production post business Approval
  • Create release documentation required for the ticket to be migrated to production environment
May 2009 - Jul 2010

Programmer

Netenrich Technologies Pvt Ltd

NetEnrich is certified with ISO 27001, and it is the trusted brand for outsourced IT Management Services (IMS), business application support, and NOC services, managing thousands of devices worldwide using its secure, bulletproof and award winning remote management technology & services. NetEnrich Headquarters at Hyderabad and offices at USA & JAPAN. NetEnrich is a next-generation “IT as a Service” (ITaaS). NetEnrich, is a partner of Ingram Micro to deliver the Ingram Seismic Global NOC service to VARs in the U.S. and Canada from its Network Operations Centers (NOC).

Project Description:

This project MSP Operations Portal gives an overview of how clients are provided with services from Master Managed Service Provider (MMSP). Clients are some organizations that need services and approach Managed Service Provider (MSP). Operations portal means providing NOC services like monitoring device, servers etc. MSP provides services to clients.

                        Our project mainly deals with MMSP. MMSP indirectly provides services to clients. The clients don’t know that MMSP is providing services to them. This project records creation of MSP and creation of clients by Master MSP and their services provided to clients. 

Roles and Responsibilities:

  • Create/modify procedures/packages/functions as per the business requirements using Oracle PL/SQL.
  • Review of code(procedure/packages/functions) using Netenrich customized PL/SQL code review tool.
  • Involved in Defect Analysis and defect fixing.
  • Ticket Tracking using the Kayako Ticketing tool.
  • QA Support - Ensuring quality process compliance throughout te project.
  • Identifying the risks and come up with a risk mitigation plan.
  • Involved in writing Unit test cases and executing the same
  • Deploying the tasks and solving the issues in daily basis.
  • Developing the new ad-hoc reports based on the requirement.

Education

Education
Aug 2006 - Jun 2009

Master Of Computer Applications

Vivekananda School Of PG Studies
Jun 2003 - May 2006

B.Sc

Kavitha Degree College

Skills

Skills

Teradata

Oracle-PL/SQL

  Around 1.5 years of experience in Oracle development, maintenance and support. Good knowledge on canned/Ad-Hoc reports using SQL procedures,functions and sequences. Strong de-bugging skills on SQL. Good knowledge on creating and scheduling cron jobs.  

Business Intelligence-Business Objects-BI OLAP Tools

     Around 2 years of experience working in Data Warehousing, Business Intelligence, OLTP, OLAP, and ETL & REPORTING. Good working knowledge of OLAP reporting tool Business Objects. Well versed in Business Objects suite XI R2 (Supervisor, Designer, Reporter, WebIntelligence/InfoView,Central Management Server, Central Management Console, DeskI, Import Wizard, Report Conversion Tool and Designer), Dashboards, Scorecards and Schema Design. Experience in building Universes, retrieving data using Universes, Personal data files, free hand SQL methods. Experience in Installation and Configuration of Business Objects product Suite. Expertise in creating canned/Ad-Hoc reports using BO Full client, DeskI, WebI 5.x/6.x/XI R2. Good knowledge and experience using Oracle 8i/9i/10g, MS SQL Server 2005, Microsoft Office Tools and Toad. Good Knowledge in Data warehousing concepts, dimensional Star Schema and Snowflakes Schema and Ralph Kimball and Bill Inmon Methodologies.