PAVAN MANEPALLI

SENIOR BI DEVELOPER

937-***-****

ad3lh1@r.postjobfree.com

PROFESSIONAL SUMMARY:

Having 10 years of experience as an IT professional including 7+ years of experience in Business Intelligence technologies using Power BI, Advanced excel, MySQL, SQL Server Management Studio, Oracle SQL developer, Azure, ServiceNow.

Expertise in Tableau 2022.x/2020.x/2019.x/2018.x,10.x, Power BI, Business Objects 4.0, 4.1.

Experienced in requirement gathering/analysis, design, development, testing, and production rollover of reporting and analysis projects.

Hands on experience on Power BI, Tableau Desktop versions 2022.x/2020.x/2019.x/2018.x,10.x Tableau Reader and Tableau Server.

Produced attractive visuals/dashboards to convey the story inside the data.

Built dashboards using techniques for guided analytics, interactive dashboard design, and visual best practices.

Involved in creating many Ad-hoc reports. Involved in trouble shooting of performance issues which were associated with Power BI and Tableau reports.

Worked on Jira, helping scrum master across the company to customize Jira for the requirements.

Worked on Jira and source code version SVN control.

Also involved in administration tasks such as publishing workbooks, setting permissions, managing ownerships, providing access to the users, and adding them to the specific group and scheduled instances for reports in Tableau Server.

Worked in all phases of BI full life cycles including analysis, design, development, testing, deployment, post-production support/maintenance, documentation, and end-user training.

Worked with Hadoop database by connecting to impala as a data source and fetching tables.

Expertise in designing and creating various analytical reports and Automated Dashboards to help users to identify critical KPIs and facilitate strategic planning in the organization.

Converting all operational excel reports into Power BI Reports.

Experience in efficiently using standard Business Content, extending, and enhancing according to the report requirements.

Created and maintained pages in confluence based on the requirements.

TECHNICAL SKILLS:

Reporting Tools: POWER BI,Tableau 10/11,BO Live Office, Import Wizard), SSIS,SSRS,Crystal Reports 2008/XI/10/9.0, SSRS, Cognos, Business Objects BO 4.2.

ETL: Ab Initio, Informatica 7.1, Data stage, SSIS.

Languages: C#.Net, Oracle Pl/SQL, NET Platform, VB, C, C++, Java, XML, AS/400.

Internet Technologies: ASP.Net, HTML, JSP.

Scripting Languages: Java Script, VB Script, Unix Shell scripts.

Databases: Oracle 10g/9i/8i, Teradata 14.0/14.1,MS SQL Server 2008/2005/2000, Informix, DB2 UDB 7.x/8.x, DB2, MS Access, Teradata v2r6/v2r5/v2r4.

Databases Tools: TOAD, SQL Navigator, Quest Central, MS Sql Server Management Studio, SQL Assistant.

CERTIFICATIONS:

EPIC Certified (Clarity, Tapestry & AP claims)

EDUCATION:

Bachelor of Engineering, Manipal, India Jun 2003-Jun 2007

PROFESSIONAL EXPERIENCE:

SENIOR BI Developer ENGINEER HARRIS HEALTH Feb 2023– PRESENT

Designed, developed, tested, and maintained Tableau functional reports based on user requirements.

Developed various Tableau data visualization using cross tabs, Heat maps, Box and Whisker Charts and many more.

Built and published customized interactive Tableau reports and dashboards along with data refresh scheduling using Tableau Desktop and Tableau Server.

Perform analysis for senior leadership and provide solutions for data related queries.

Lead the development of new Power BI reports to provide real-time insights based on requirements.

Implemented data blending to blend data from different data sources.

Responsible for creating calculated fields and hierarchies using Tableau Desktop.

Utilize business analytics to create performance analysis reports and compile data to drive process improvement opportunities.

Proficiency in creating Ad-hoc Reports, Drill-Down, Drill-Through, Cascaded, Matrix, Sub-reports, Pie Chart Reports and Tabular Reports for different business domains depending on the specifications and requests.

Made Power BI reports more interactive and activate by using story telling features such as bookmarks, selection panes, drill through filters and created many custom visualizations.

Extract and organize datasets using Excel to create business models and compile data for the organization’s risk index.

Working directly with stakeholders for requirement gathering and developing various decision-making dashboards.

Experienced with connecting multiple data sources in Power Bi to implement working reports.

Design and develop of reporting data module for Credit Card Marketing Analytics.

Developed Up-selling and Cross-selling reports using DAX functions.

Used Confluence for storing and maintaining all the documents based on the requirements.

Involved in creating internal and external tables in Azure Datawarehouse.

Developed Azure data factory pipelines to move the data from source systems.

Creating Row level security with power bi and integration with power bi service portal.

Responsible for creating SQL datasets for Power Bi and Ad-hoc reports.

Developed Power Pivot reports in excel 2013 by publishing them to sharepoint2013 for providing ad-hoc reports as per client needs.

Created joins and sub-queries for complex queries involving multiple tables.

Proven experience in developing and managing data integration solutions using Microsoft BI technologies.

Participated in daily scrum meetings with the team to discuss challenges and development of the project.

Used Jira for all the story and task related updates.

Involved in testing and publishing reports to servers and higher ENV’s and setting up refresh.

Environnent : Power BI Desktop, Tableau 2022.x/2020.x/2019.x, MS SQL Server 2016/2017, SSRS, SSIS, SSAS, SQL Server Management Studio, Python, sOracle, Tableau Server 2022.x.

CRICO,Remote

July 2022-Feb2023 SR BI DEVELOPER

The CRICO insurance program is a group of companies owned by and serving the Harvard medical community, with an established reputation as a leader in evidence-based risk and claims management.CRICO's mission is to provide a superior medical malpractice insurance program to its members, and to assist them in delivering the safest health care in the world

Developed several parameterized dynamic dashboards, scorecards, with drill down and drill through capabilities.

Designed rich dashboards with Power BI and referred user stories to create compelling dashboards to deliver actionable insights.

While designing the Power BI reports and dashboards, the measures are created using DAX programming language. Writing all the calculations using DAX formulas.

Experience in Power Query in Power BI to Pivot and Un-pivot the data model for data cleansing and data massaging.

Migrated existing self-service reports and ad hoc reports to Power BI.

Implemented several DAX functions for various fact calculations for efficient data visualization in Power BI.

Used SSRS to create, execute and deliver tabular matrix and chart reports.

Used SSIS to create ETL packages .dtsx files to validate, extract, transform and load data to data warehouse databases.

Created packages in SSIS and SSRS with error handling.

Developed and maintained ETL (Data Extraction, Transformation and Loading) mappings using SSIS to extract the data from multiple source systems that comprise databases like Oracle 10g, SQL Server 7.2, flat files to the Staging area, EDW and then to the Data Marts.

Designed rich dashboards with Power BI and referred user stories to create compelling dashboards to deliver actionable insights.

Involved in developing complex Azure analysis services tabular databases.

Involved in creating internal and external tables in Azure Datawarehouse.

Developed Azure data factory pipelines to move the data from source systems.

Created Report filters, parameters, and DAX sets for preparing dashboards and worksheets in POWER BI. Defined best practices for POWER BI report development.

As a POWER BI SME I was responsible for the design, development and production support of interactive data visualizations used across the company.

Created URL Actions to navigate from one Dashboard visual to another Dashboard for a smooth eye-catching presentation along with using Tableau Data Extracts for better performance on rendering the visualizations.

Environnent : Power BI, Tableau 2020.x/2019.x, MS SQL Server 2008 R2, SQL Server Management Studio, Oracle, Tableau Server 2020.x, SSIS.

United Health Care,Remote

Jan 2022-June 2022

Understand the Requirements and Functionality of the application from specifications.

Provide guidance to IT Infrastructure and Application teams on Architecture’s Frameworks, Patterns, Best Practices, and Programming concepts.

Used Power BI, Power Pivot to develop data analysis prototype, and used Power View and Power Map to visualize reports.

Published Power BI Reports in the required originations and Made Power BI Dashboards available in Web clients and mobile apps.

Hands on experience in Performance Tuning, Query Optimization.

Strong Knowledge of Power BI to import data from various sources such as SQL Server, Azure Data Explorer SQL DB, SQL Server Analysis Services (Tabular Model), MS Excel etc.

Scheduled Automatic refresh and scheduling refresh in Power BI service.

Developed SSIS Packages to Extract, Transform and Load (ETL) data into the Data warehouse from SQL Server.

Performed Parallel Testing or Production Testing, which ensures that the new system will perform correctly in a production environment and interface correctly with other production systems.

Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop-down menu option and Parameters using Tableau.

Created different KPI using calculated key figures and parameters.

Developed Tableau data visualization using Cross tabs, Heat maps, Scatter Plots, Geographic Map, Pie Charts and Bar Charts and Density Chart.

Hands on experience with API gateway and DynamoDB

Worked extensively with SNS and SQS to post queries to the tables.

Creating Row level security with Power BI and integration with Power BI service portal.

Developed donut charts and implemented complex features in charts like creating bar charts in tooltip.

Worked on all types of transformations that are available in Power BI query editor.

Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps, Trend Lines, Statistics, and table calculations.

Hands on building Groups, hierarchies, sets to create detail level summary reports ad Dashboard using KPI’s.

Environment :- PowerBI, Tableau 2020,SAP Business Objects XI 3.2, Kerberos, Crystal Reports XI/2008, Web Intelligence, Oracle 19c/11g, MS Sql Server 2008, Sql Developer, Sql Server 2008 Management Studio.

SANTA CLARA COUNTY, SANTA CLARA, CA

JAN 2020-Dec2021

SR BI EPIC / CLARITY ANALYST / DEVELOPER

Enabled new tables for extract, creates new custom tables and columns in existing tables in Clarity as needed for Clarity to Diver ETL

Created Management Level Dashboards using Tableau from various sources like Excel, Webi, Snowflake Database.

Installing, updating, maintaining, and troubleshooting Clarity and Caboodle Consoles

Worked on creating SSIS packages for COVID-19 Reporting Data.

Did Analysis and created Daily COVID-19 Reporting using SSRS, Tableau dashboard.

Developed Provider scorecard reports using Webi as the reporting tool

Developed complex webi Core Measures Scorecard report which is used by the organization to track various core measures of the Auto Finance by month, quarter, year against the benchmarks.

Moving custom data model and ETL development to production for Caboodle.

Created Reports for Eligibiltiy and Enrollment of patients to submit the monthly numbers to ecternal clinics.

Developed a complex provider scorecard dashboard with multiple tabs using dynamic visibility. This POWER BI dashboard shows the high level information of rolling 12 months of provider performance data varying across different areas like productivity, machine utilization, compliance and quality. The dashboard also has the capability of drilling down to the detail data on to the detail webi reports

Re-Developed an existing dashboard which shows the high-level rolling 12 month information of patient medication administration. This dashboard also had drill down capabilities to get to the detail data by month and by facility.

Written automated scripts to check eligibility of a patient from state website.

Analysing, updating, maintaining, and troubleshooting the SlicerDicer tools as appropriate

Installing new Reporting Content and Epic Analytics tools as they become available from Epic

Working with business intelligence developers to move pieces of non-Epic data back to Hyperspace as necessary

Utilize Microsoft SQL to build extracts and custom calculations as may be needed Installing, configuring, and maintaining the SSAS cubes to ensure optimal performance and integrity.

Report bursting, Create events, custom queries, and create burst and schedule them and deliver the information as required by project

Analyzing non-Epic datasets to identify required data elements to be moved into Caboodle to insure integrity, performance

Created complex webi reports with multiple queries, custom sql, using complex fuctions, merging dimensions at report level, drill down, drill up, drill across, complex filters etc

Worked on creating Webi reports as a part of the homeless project

Created trending images and published them to the server images folder and used them in the webi reports to show trending of the data

Had Expereince in Report Busting using Infobust in 4.0 Enterprise Tool to burst reports as per user Access.

Actively involved in knowledge sharing, documentation and troubleshooting any SAP business objects related problems

Environment :- SAP BI/BO 4.2, PWER BI,Tableau 2020,SAP Business Objects XI 3.2, Kerberos, Crystal Reports XI/2008, Web Intelligence, Oracle 10g/11g, MS Sql Server 2008, Sql Developer, Sql Server 2008 Management Studio.

CAPITAL ONE

MARCH 2018-DEC 2019

PROJECT TITLE: FLOGA (AUTO FINANCE)

BI DEVELOPER

Floga is part of the enterprise-wide Data Transformation program tasked with creating a brand new data ecosystem that will simplify the producer and consumer experience. The Floga program is responsible for creating this new data ecosystem for financial services by rebuilding our data ecosystem from the group up, in the cloud, using modern tools and technologies. Floga derives the name from the Greek word flame which symbolizes Financial Services need to “burn the ships” and transition away from our current data warehouses in to cloud.

Created Management Level Dashboards using Tableau from various sources like Excel,Webi,Snowflake Database.

Created complex dashboards which uses live office to feed the data into Tableau from the source webi reports

Developed Provider scorecard reports using Webi as the reporting tool

Developed complex webi Core Measures Scorecard report which is used by the organization to track various core measures of the Auto Finance by month, quarter, year against the benchmarks.

Created Reports like Vehicle remarking, Borrower, Co-borrower analysis for the fiannce department to meet the month end numbers.

Validated New IDEs in various new tables while transforming to Snowflake from MS SQL and Teradata.

Worked on optimizing the performance of the dashboards. Reduced the dashboard loading time by scheduling the backed source webi reports for the live office and changing the live office refresh option to pick from the latest instance.

Modified the existing universes for performance tuning and maintained common dimensions across all the universes with unique naming as a part of clean up activity

Worked on optimizing the performance of the dashboards. Reduced the dashboard loading time by scheduling the backed source webi reports for the live office and changing the live office refresh option to pick from the latest instance.

Modified the existing universes for performance tuning and maintained common dimensions across all the universes with unique naming as a part of clean up activity

Developed a complex provider scorecard universe which involved multiple fact tables. Created multiple contexts to resolve loops. Performed integrity checks and documented them

Validated the source to target data for referral and medications scanning data marts.

Created sql test scripts to validate the source to target data for the provider scorecard datamart.

Created complex webi reports with multiple queries, custom sql, using complex fuctions, merging dimensions at report level, drill down, drill up, drill across, complex filters etc

Worked on creating Webi reports as a part of the homeless project

Created trending images and published them to the server images folder and used them in the webi reports to show trending of the data

Did Report Busting to various Enterprsie level users and outside Orginzation Vendors by creating Groups.

Validated Millions of data using various Python scripts to perform the Data validation management.

Actively involved in knowledge sharing, documentation and troubleshooting any SAP business objects related problems

Environment :- Tableau 11,SAP BI/BO 4.0/4.1/4.2, SAP Business Objects XI 3.2,, Crystal Reports XI/2008, Web Intelligence, Oracle 10g/11g, MS Sql Server 2008, Sql Developer, Sql Server 2008 Management Studio,

KAISER PERMANENTE

JAN 2015-MARCH 2018

PROJECT TITLE: KAISER PERMANENTE CLAIMS CONNECT (KPCC)

SR BUSINESS OBJECTS UNIVERSE DEVELOPER/ANALYST

The Kaiser Permanente Claims Connect (KPCC) Program will implement Epic’s Tapestry AP module as the new claims system for all the Kaiser Permanente (KP) regions. The implementation will replace the end-of-cycle legacy claims systems and bring contemporary technology to our claims and encounter processing, products, pricing, and customer service, contributing to the competitiveness of Kaiser Permanente in the regional markets. HPBIO National Reporting team is a part of KPIT’s “Kaiser Permanente Claims Connect” (KPCC) Program that produces and supports National Operational and Financial reports across all regions (HI, NW, MAS, SCAL, NCAL and CO), on the nation’s largest EPIC Tapestry AP Claims Implementation.

Responsible for development of National Financial reports consists of various regions like HI, NW, MAS, SCAL, NACL and CO as a part of KPIT’s financial reporting team.

Developed and maintained National Universe in UDT for all the regions to source the Financial Reports.

Involved in Design, Development, Testing, and Enhancement

Performed extensive GAP analysis in the project as there were numerous 'As-Is' and 'To-Be' conditions.

Involved in creating database objects like tables, views, procedures, triggers, and functions using PL-SQL to provide definition, structure and to maintain data efficiently.

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

Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.

back last 13 months for Business to check how long the claims status is in Pending.

Created Report on Paid and Pend logic for checks and claims with no GL Data for the Business to look after the claims for their month end financial closure.

Modified, designed, configured and built fields, records, sub records, setting up keys to records, assign table edits like prompt table.

Developed Ad-hoc Reconciliation Reports as per request of the business users for their Financial month-end Closure.

Had Experience in working with Center Millennium Database and creating reports using these database.

Developed number of interface reports using SQR to read the data from file and load it into PeopleSoft tables and send data from PeopleSoft to other external applications.

Supported the Multi source universes using IDT sourcing the Financial Reconciliation reports.

Extensively worked in the project of Upgrading Business Objects universes and reports from version XI 3.1 to 4.1

Involved in Solving issues of IDT, Reports while migrating from 3.1 to 4.2.

Involved in Unit testing of people soft delivered and modified functionality & customized SQR programs using HR, Benefits and Payroll Modules.

Used Webi rich client to validate local connections and to pivot the reports from one universe to other across multiple regions.

Worked on Versioning of reports to keep track of the changes made to the reports.

Created BIAR Files in CMC for Migration of Reports and universes.

Created Universe using the Data from Various Data sources like Kofax, Millennium Databases etc.

Created TNS Entries and ODBC system DSN’s to connect to various reporting databases.

Participated in the evaluation of business requests and/or modifications.

Environment: Business objects 4.2/4.1,XI 3.1,4.0,Tableau 11, AWS Snowflake, Python,Crystal 11,Info View, DB2,Business Objects Designer, BO Web Intelligence 3.1, Epic Clarity, Epic Hyperspace, Healthy Planet, and Toad, SQL developer

AMERICAN MEDICAL ASSOCIATION

OCT 2014-DEC 2014

PROJECT TITLE: PHYSICIAN ENGAGEMENT AND CRM

BI DEVELOPER

American Medical Association mission is to promote the art and science of medicine and the betterment of public health. AMA is built on its legacy of leading physician ethics, setting standards for medical education, and advancing medical science to serve as the premier voice for the core values of the medical profession.

Extensively worked in the project of Upgrading Business Objects universes and reports from version XI 3.1 to 4.0.

Installing, configuring and administering the Business Objects 4.0 SP6 environment.

Created Drill-down and Sub-Report using SSRS. Monitored the performance of the reports.

Generated Dashboards with Quick filters, Parameters and sets to handle views more efficiently.

Generated context filters and data source filters while handling huge volume of data.

Built dashboards for measures with forecast, trend line and reference lines.

Created and refreshed quarterly Dashboard using Tableau Dashboard.

Used Crystal Report XI Enterprise to design the front-end reports.

Created classes, subclasses and objects including complex measure objects according to the business requirements from the Universe schemas and database tables.

Modified the existing Universes by merging different Classes and resolving the Loops and Chasm Traps by context.

Created and reviewed the conceptual model for the EDW (Enterprise Data Warehouse) with business users.

Analyzed the source system (JD Edwards) to understand the source data and JDE table structure along with deeper understanding of business rules and data integration checks.

Identified various facts and dimensions from the source system and business requirements to be used for the data warehouse.

Created the dimensional logical model with approximately 10 facts, 30 dimensions with 500 attributes using ER Studio.

Environment:,Business objects 4.0, XI 3.1,4.0, Tableau 11,Info View, DB2, Business Objects Designer, BO Web Intelligence 3.1 UNIX, Windows 2003/NT, Oracle 10g, SQL Server 2008.

MAYO CLINIC, MN

JUN 2012 – OCT 2014

PROJECT TITLE: SUPPLY CHAIN ANALYTICS/PRODUCTION SUPPORT

BUSINESS OBJECTS ADMIN/ DEVELOPER

Mayo Clinic is a nonprofit worldwide leader in medical care, research and education for people from all walks of life. It Priorities are aimed at ensuring that our patient focus permeates the entire organization, in every department at every location. To inspire hope and contribute to health and well-being by providing the best care to every patient through integrated clinical practice, education and research.

Migrated the SAP BO Environment from BO 3.1 to 4.1.

Inventory, Accounts Payable and Purchase Orders were the different subject areas within the data warehouse.

Used advanced universe functionalities like Derived tables, Index Awareness, custom LOVs.

Created Info providers & BEx queries to simulate/validate results achieved from Design Studio reports. Architected the Re-org of BW objects to maintain standards.

Created custom hierarchies to aid in Drill-Through analysis of WebI documents and built cascading prompts.

Participated in the complete development lifecycle: analysis, design, build and test reports.

Created custom cloud formation scripts for automation and deployment of Windows CRM, SharePoint 2013 and RSA Archer platforms in AWS.

Published and Migrated reports in Development/Test to Production Domains.

Working with team of developers designed, developed and implement a BI solution for Sales, Product and Customer KPIs.

Developed a 360 business dashboard with multiple panels and parameters that became a favorite sales tool for most of the sales force at CE.

Implemented Tableau mobile dashboards via Tableau mobile application.

Developed Tableau workbooks to perform year over year, quarter over quarter, YTD, QTD and MTD type of analysis.

Created hyperlinks to link between reports.

Provided architecture guidance for selected AWS customers, assessing migration feasibility and deployment strategy based on AWS Architecture best practices

Worked on Data Warehousing technologies using Informatica Power Center and data stage Star Schema modeling, Snowflake Schema modeling, MS Access.

Planned and designed web services using QAAWS to fed Xcelsius as a data provider.

Extensively used QaaWS to query from Universes.

Experience developing and supporting Invoice Reports including Time and Materials.

Performed data maintenance using LOAD, UNLOAD, REORG, RUNSTATS

Writing Custom SQL for reports performance in DB2, Oracle and MS Sql.

Streamlined SQL generation from Universes by implementing Aggregate Aware functions and @ Variables.

Involved in Design, Development, Testing, and Enhancement of PeopleSoft HRMS for HR Payroll and Base Benefits modules.

Involved in testing the reports while migrating from XI 3.1 to 4.0.

Involved in Unit testing of people soft delivered and modified functionality & customized SQR programs using HR, Benefits and Payroll Modules.

Modified, designed, configured and built fields, records, sub records, setting up keys to records, assign table edits like prompt table.

Installing, configuring and administering the Business Objects 4.0 SP6 environment.

Designed and maintained Universes using different schemas in the Oracle Database.

Used Model Mart of Erwin for effective model management of sharing, dividing and reusing model information and design for productivity improvement

Detected cardinalities, loops, and checked the Integrity of Universes.

Created custom hierarchy in Universe using BO Designer.

Created and refreshed quarterly Dashboard using SAP Business Objects Xcelcius Dashboard and Live office.

Created classes, subclasses and objects including complex measure objects according to the business requirements from the Universe schemas and database tables.

Environment: Business objects 4.0, XI 3.1,4.0, Tableau, BO Web Intelligence 3.1 UNIX, Windows 2003/NT, Oracle 10g, DB2 10.5, SQL Server 2005, Crystal Reports, People soft v 8.3/v7.9 Xcelsius, AWS Redshift, QaaWS, CMC, BO Data Service 3.1, ASP.NET, C#, HTML, XML, ERWIN, MS OFFICE, Visio, JIRA, Subversion.

PIMA COUNTY

DEC 2011-JUN 2012

BI DEVELOPER

PIMA COUNTY is one of the well-versed counties in the state of Arizona. It has various departments like Financial, ITD, P&B, Sherriff, and Transportation, etc. The reports such as Financial, planning and budgeting and HRM are created using Web Intelligence and crystal Reports on a day-to-day basis and performance is measured against the productivity. Financial reports include quarterly, periodical, and Fiscal reports.

Installing the Business Objects 4.0 SP04 on the server and setting up the environment, and configuring Secure Socket Layer (SSL).

Involved in project planning sessions with project managers, business analysts and team members to analyze business requirements and outline the proposed solution.

Extensively worked on Crystal and Webi reports for Elections and Addendums in modifying the existing templates and in creating new ones and worked on the functionality to reduce the number of Webi reports needed to a minimum.

Created Complex reports in crystal using DB2 as Database.

Experience developing and supporting Invoice Reports including Time and Materials.

Created pages for selecting addendums and contractors from the list that comes up for a department.

Worked at conceptual/logical/physical data model level using SAP ECC and BW data sources according to requirements.

Worked on making changes in the existing queries and renaming them, then on making the database up to date to make previous versions compatible to the existing ones.

Extensively worked on Logic behind the Formula fields created and used in Webi reports according to the requirement.

Tested the templates in 2-tier and 3-tier for different environments like Dev, New, Prod and Training.

Generated Reports using the Universe as the main Data provider and using the personal data files provided by the users and Free-hand SQL as data provider.

Worked at conceptual/logical/physical data model level using Erwin according to requirements

Created New Classes and User Objects according to the requirements.

Created various simple and complex reports using drill down, filters and alerts.

Environment: Business Objects XI R2, Web Intelligence, Crystal Reports XI R2,,Design Studio, SAP Luminar, Xcelsius, Oracle SQL Developer, Oracle 10g,DB2 10.5,PL/SQL, T-SQL, SQL SERVER 2008, Info Advantage, AMS,ERWIN,Advantage, Java, J2EE Business View Manager.

HP@CVS/CAREMARK

JAN 2011-DEC 2011

PROJECT TITLE: PATIENT-CENTERED CARE/ADVANCE CLINICAL

BUSINESS OBJECT

Contact this candidate