Vasu Bathula

actbkb@r.postjobfree.com

Cell: 770-***-****

Experience Summary

Having 10 years of experience in BI reporting, as a software developer involved in the design, development, maintenance and support of SAP Business Intelligence Applications including SAP Business Objects XI 4x/3x/XIR2/6.x, Xcelsius, Dashboard Designer, SQL, Microstrategy 9.4.1 and Tableau as a part of the Decision Support Systems (DSS) initiatives.

Technical Summary

Proficient in all phases of the Software Development Lifecycle(SDLC(Water Fall & Ageil methedology)) including Requirements gathering, Analysis, Design, System Implementation, Performance Tuning, Testing and Support.

Excellent experience with DW Concepts such as Star schema, Snowflake Schema, Fact, Dimensional tables, physical and Logical data modeling.

Well versed in SAP Business Objects XI 4x/3x/XI R2 Enterprise Suite (Universe Designer, Information Designer tool (IDT), Web Intelligence, LCM, Central Management Console (CMC), Central Configuration Manager, Central Management Server, Import Wizard, Publishing Wizard, Report Conversion Tool.

Experience in building Universes, Free Hand SQL methods and creating Complex and Ad-Hoc Reports using SAP Business Objects.

Experienced working with Universe Designer and Information Designer Tool.

Experienced in Migration process of the SAP Business Objects 3.x to 4.x.

Extensive experience in interacting with business users, business owners for requirements gathering, analyzing business process and making necessary changes to schema objects to fulfill reporting needs.

Experience in using various RDBMS like Oracle 11g/9i/8i, SQL Server 2005/2008.

Involved in designing Databases and data marts on Oracle/Access. Widely used TOAD (Oracle) and SQL Server Management studio to write complex queries to check for data quality, performance of reporting queries and tweaked them to reduce run time.

Created Indexes, Partitioning tables and executed the explain plan to check the statistics.

Experience in defining best practices for Tableau report development.

Experience in Developing Score cards, Prompts, Drills, Reports/Dashboards.

Extensive experience in designing/Support for Tableau dashboards.

Involving in Estimates and project plans.

Excellent analytical, problem solving, communication and interpersonal skills, with ability to interact with individuals at all levels.

Experience in giving training to the teams.

Education

B.Tech (Information Technology) from Madras University in Apr 2003.

Technical Skills

Business Intelligence:

SAP Business Objects XI 4.1 and 4.0/3.1/XI R2/6.5 (Supervisor, Designer,Info view

(Launch Pad), Universe Designer(UDT), Information Designer tool (IDT),

Import Wizard, Life Cycle Manager (LCM),CMC,CMS, Dashboard design,Xcelsius,

LiveOffice,Broadcast Agent, Publisher), Tableau 8.2/9.1, Microstrategy 9.4.1,

Microstrategy Developer, Architect, Web, Visual Insight, Intelligence Server, Cubes, Integrity Manager, Object Manager,Command Manger,System Manager,

Enterprise Manager,Report Services, Distribution Services.

Reporting Tools

Vermillion Reporting Suite, Actuate reporting Tool, Crystal Reports XI/2013.

ETL Tools

Informatica 8x, Ab Initio

RDBMS

Oracle 8i/9i/10g/11g, SQL Server 2005/2008,Teradata

Tools

SQL * Loader, Toad 7.1, Erwin 3.5.2,SQL Developer.

Languages

SQL, HTML,Actuate Basic.

Operating Systems

Windows 2003 Server, Windows2000/XP and Windows7.

Professional Summary

Home Loans BI Reporting (Originations),

BI Reporting/Tableau Consultant

CapitalOne, Plano,TX Mar 2015 – Dec 2015

Environment: SAP Business Objects 4.1 suite tools (WebI, IDT,UDT, BI Launch Pad), Tableau 8.2/9.1, Teradata,SQL Server 2008,Windows 7.

Provide BI reporting solutions to Home Loans Financial Services including Origination. This helps produce transnational & analytical reports which extract meaningful insights for leadership to better understand and improve business performance.

Responsibilities

Gather requirements by interacting with users and Business consultant systems for design of reports.

Providing walk-through sessions on the new features and functionality on the exist reports and tool wise.

Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop.

Created Prompts, customized Calculations, Conditions and Filter (Local, Global) for various analytical reports and dashboards. Develop Tableau module deliverables such as workbooks, package workbooks, building data views manually and automatically using different charts, graphs.

Combined views and reports into interactive dashboards in Tableau Desktop that were presented to Business Users, Program Managers, and End Users.

Reviewed basic SQL queries and edited inner, left, and right joins in Tableau Desktop by connecting live/dynamic and static datasets.

Scheduled data refresh on Tableau Server for weekly and monthly increments based on business change to ensure that the views and dashboards were displaying the changed data accurately.

Performed Tableau type conversion functions when connected to relational data sources.

Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots,geographical maps using show me functionality.

Developed the prototype reports for end users in Business objects to get sign off for actual designing and for presentation.

Managing of all BO universes and standard reports in BO XI 4.1 which is used by Home Loan Origination users.

Converted the Cognos reports (60+ reports) into BO reports.

Provided BOBJ reports to Community Mortgage,Home Equity and Mortgage teams based on their requirements.

Design and create the reporting data structures.

Prepare the technical documents and provide the pseudo code.

Created and modified universe (.unv/.unx) objects for canned reports basd on business needs.

Create standard reports using Web Intelligence functionalities.

Schedule the reports as requested by users on daily, Weekly,Monthly, Quarterly basises.

Preparation of Unit test plans & Unit test results for the reports.

Performed in data validation and testing process.

WFHM Statement Reporting,

BI/Tableau Consultant

Wells Fargo, Charlotte,NC Oct 2014 – Feb 2015.

Environment: SAP Business Objects 4.1 suite tools (WebI,IDT and Universe Designer, BI Launch Pad), Crystal Reports 2013,Tableau 8.2,SQL Server 2008,Windows 7.

WFHM Statement reporting will provide the details about the statements and schedule the BI reports based on the business users login ID’s.

Responsibilities

Understand the reporting Requirements.

Design and create the reporting data structures.

Design, development of tableau reports.

Generation of Tableau extracts and implementation of different calculations, visualizations in the tableau lay out design.

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

Used Trend Lines, Reference Lines and Annotations to describe the data.

Created Data extracts for better performance and accessing data offline.

Used parameters and input controls to give users control over certain values.

Created and Published Tableau Dashboards into Tableau Server.

Writing SQL queries for data validation by using join conditions.

Provide the Mapping documents for ETL team.

Prepare the technical documents and provide the pseudo code.

Create global universes(.unx and .unv) for ad hoc reporting for business needs.

Create standard reports using Web Intelligence / Crystal Reports with Drill Down and Slice & Dice analysis functionalities.

Implemented the custom schedule business logic in query level in Crystal Reports.

Developed OLTP reports using Crystal Reports XI with embedded sub-reports.

Preparation of Unit test plans & Unit test results for the reports.

Created the POCs and demo to Business Users and Business Managers.

Involved in data validation and testing process.

Prepare the user documents and provide the user trainings/walk-through sessions to users.

Legal Entity Aggregator (LEA)

BI Consultant

CITI Group, Tampa,FL Jun 2010 – Sep 2014

Basel II Legal Entity Aggregator (LEA) is the implementation project of PeopleSoft EPM 8.8 for the CITI Group US. The project aims to analysis on balance variances for different levels of managed segments based on the adjustment plugs from the PeopleSoft Financial EPM system /databases. Creating the reporting datamart .This helps to the users for analysis TGTREC and GOC data and also provides for ad-hoc regulatory reports on Credit RWA data.

Environment: SAP Business Objects XI 3.1/XI 4.0 SP4, Info view(Launch Pad), Universe Designer (UDT), Information Designer tool (IDT), Import Wizard, LCM, Crystal Reports, Dashboard design, Oracle 9i/11g, Ab-Initio, PeopleSoft, SQL server 2005/2008, ServiceNow, Windows XP, Windows 7.

Responsibilities:

Interacted with the client during analysis and documented the requirements and Gathering the report requirements from the users.

Developed the prototype reports for end users in Business objects to get sign off for actual designing and for presentation.

Managing of all BO universes and standard reports in BO XI 4.0 which is used by Regulatory reporting users.

Involved in installation and configuration of BO Enterprise XI 4.0 components, BI Launch Pad, Dashboard Design, Live Office, Webi, Advanced Analysis for Microsoft office and OLAP.

Created Connections for Information Designer tool IDT (.UNX) and exported to BOE server.

Setting up integrated common reporting Environment using Business Objects XI 3.1 suite.

Created user objects including Dimensions, Details and Measures

Interacted with the users to analyze the changes for improvement they need in existing reports and developed the reports to satisfy their needs and requirements.

Developing complex universes by using advanced features like aggregate aware and Conditions.

Implemented Index awareness to improve the performance.

Created Indexes, Partitioning tables and execute the explain plan to improve the performance.

Created various reports like Cross Tab reports, slice and dice reports, and drill down reports, Charts using Universe as the main data provider and also Personal data files as data providers.

Involved in creation of Reports, formatting reports, generation of charts, bars etc as per user requirements.

Developing of reports as per the requirements using Business Objects Web Intelligence

Implemented object level security and incorporated Unified security for Row level security.

Preparation of Unit test plans & Unit test results for the reports.

Drill down reports using Opendoc functionality.

Designed complex reports based on discussions with user groups and created various objects using built-in @functions (like @prompt, @select, @where, @aggregate), complex SQL queries and joins

Develop user interactive dashboards with KPI measures using Dashboard designer for business performance management.

Promoting the tested content form Development to IT, QA and Production using Life-Cycle Manager (LCM).

Implementing cascading LOVs, Drill data and linking of reports functionality

Preparation of Unit test plans & Unit test results for the reports.

Scheduling of reports and monitoring reports performance.

Worked on the Production issues and provided the report fixes,universe fixes.

Worked with support team for environmental issues.

User/Groups and user Folder creation and applying access restrictions. Migrations across the environments DEV, UAT and PROD.

Worked on Production support issues (SNOW tickets)/L3 Support and timeline solutions for the same.

Worked collaboratively with ETL team and Data Warehouse team.

Pioneer - Investment Management Vermilion Reporting – Boston

Analyst Programmer

Syntel Ltd, Chennai, India Mar 2008 – May 2010

Vermilion Reporting Suite (VRS) is using for Pioneer Investments core Institutional Client Reporting System. VRS is used in Pioneer Boston, Dublin, Milan and London for the production of weekly. Monthly, quarterly, semiannual and annual reports for Institutional Clients. VRS is a web-based client reporting application designed to assist users in the automatic production of all types of communication with their clients. At Pioneer Investments VRS retrieves data from Pioneer Investments core applications.

Environment: Business Objects XIR2 (Info view, Universe Designer, WebI, Crystal Reports, Publication Wizard, Import Wizard), Vermilion Reporting Suite (VRS), JSP, Jboss, Eclipse, Toad 9.1, Oracle9i, Windows 2000/XP.

Responsibilities:

Interacted with the client during analysis and documented the requirements and Gathering the report requirements from the users.

Developed the prototype reports for end users in Business objects to get sign off for actual designing and for presentation.

Developing of reports as per the requirements using Business Objects Web Intelligence.

Scheduling the BO reports and make it available for VRS reports data source.

Scheduling of reports and monitoring reports performance.

Worked with Vermilion product team for pioneer Dublin - Equity, Fixed Income reports and specific client reports - CNP Monthly, SANLAM, Invensys Pension, Invensys Allocation Analysis, Invensys Quarterly, Quarterly Pension reports, 2 Daiwa reports, Fact sheet reports, Performance Excel report and SG Quarterly.

Estimating and designing the Dublin new reports as client requested and providing the implementation documents and release notes for the production releases as per client branding guidelines.

Estimating and analyzing the change request requirements for Boston and Milan client reports.

Deploying and releasing the production releases.

Importing and exporting bulk requirements from one environment (Dev, QA, and UAT) to production environment.

Create/modify the Styles, Components, Reports, data sources and record sets.

Create/modify the commentary or other manual data using commentary module.

Create/modify Reference Data (Entities).

Re-branding the Milan Annual report.

Worked on UAT Sierra report Changes for Boston Pioneer and released the all Sierra reports (12 Reports) from UAT environment to Production Environment.

Place the java files in server folder structure and after bouncing the JBoss server and checking the server log files if VRS system files to generate or preview the reports.

Conducted Trainings on Vermilion Reporting Suite (VRS) Concepts for Boston and Dublin QA team’s and prepared the Training material.

Involved in upgrading the VRS tool from lower version to latest version (2.7.3).

Responsible to support the issues with reports on the BO environments (Development, UAT, Test and Production).

Develop and implement test scripts for evaluating service packs and future releases

Evaluate and design web services access points for data access in multiple and dynamic user interfaces.

Designed, developed and tested the reports based upon data generated by enterprise transaction, financial, and customer information systems using Business Objects XI connected to Oracle data source.

Set up groups and users for Business Objects deployment in CMC.

Developed WebI Reports as per the business requirements

Enterprise Portfolio Management (EPM) - Allstate, Chicago

Analyst Programmer

Syntel Ltd, Mumbai, India Apr 2007 – Feb 2008

The Enterprise Portfolio Management (EPM) Reporting and Analytics solution will be a consolidated and integrated data store that will provide reporting, analysis and decision making capabilities to Allstate Technology management. The future state vision calls for the integration of data from multiple IT management systems.

Environment: Business Objects XIR2 (Web Intelligence, Info view, Xcelsius 2008 &QaaWS), Crystal Reports, Publication Wizard, Import Wizard, Dashboard Manager, SQL, Windows 2000/NT, Oracle 9i.

Responsibilities:

Involved in Business user requirements gathering, analyzing, and documenting business requirements, functional requirements and data specifications.

Created reports using web Intelligence tools whereas Business Objects Universe as the Data Provider.

Specified the Joins and checked the cardinalities.

Implemented Contexts, Joins and Aliases for resolving Loops and Checked the Integrity of the Universes and exported the universes to the Repository making resources available to the users using Designer.

Check Integrity of the universe.

Exporting the Universes to repository to make it available to the users.

Created reports using web Intelligence tools whereas Business Objects Universe as the Data Provider.

Hands on creating Alerter, filters, variables, Prompts.

Format the reports as per the business requirements.

Creating the Folders using Central Management Console.

Copying the Reports from one folder to another in infoview.

Scheduling the Reports as per business needs through Infoview.

Preparation of Unit Test Cases for reports.

Performing Unit Testing.

Prepared ad hoc supporting documentation for senior financial management.

Exported reports into various formats like PDF, HTML, EXCEL and WORD for end users.

SSTL-Workstation Reporting (State Street Trustees Limited) -UK

Analyst Programmer

Syntel Ltd, Mumbai, India Nov 2005 – Mar 2007

This project helps State Street to report Breaches in the financial functioning of Clients to the Risk Management and Compliance (RMC). CFS (Collective Fund Services) has been appointed by a number of clients to perform the pricing administration function for regulated and non-regulated funds.

Environment: Business Objects 6.5, Web Intelligence, Informatica 5.1/6.x, Oracle 8i & Windows 2000.

Responsibilities:

Created list and cross tab reports using Business Objects Web I.

Worked with Business Objects Designer to modify the existing universe as per the Reporting and Sales Dashboard needs.

Defined Classes & Objects of the universe and organized the data along dimensions and hierarchies to perform multi dimensional analysis (Slice &Dice and Drill).

Created complex reports do display charts, alerts using Web Intelligence.

Worked on different data sources such as Oracle, SQL Server, XML, MS Access.

Designed reports by using different functionalities like drill down, using calculations with variables, comparing with previous year data to get change % etc.

Exported Reports to Excel based on User requirements.

Worked with a Team to develop a complex universe and generated reports exclusively using Full client.

Developed user friendly Universes using Business Objects Designer for various business needs.

Created the reports using Universes as the main data provider.

Worked on resolving some of the WebI issues which users had faced

Created and modified Universe by using @functions, Short-cut joins, Hierarchies and wrote custom SQL in derived tables.

Provide the Mapping documents for ETL team.

Created ETL process for different ETL modules based on the requirement.

Worked with various transformations like Query, Lookup, Pivot, Reverse Pivot, Hierarchy flattening and Merge transformations.

Designed ETL modules to implement security by creating User Role Hierarchy.

Used Informatica Designer tools to design warehouse using source definition, target definition and transformations.

Prepared UTP documentation and tested the Jobs, Workflows and mappings for each scenario as per the document.

Documented all the changes made to the Universes and Reports for future references.

Education:

B.Tech (Information Technology) from University of Madras, Tamil Nadu, India.

Certifications

ITIL Foundation Certificate in Service Managements.

Trainings Attended

Business Objects XI R2.

MicroStrategy Reporting.

Vermilion Reporting Suite.

Contact this candidate