Candidates About

 

Kalyan Gorantla

Sr. BO Developer/Tableau Developer/Lead

Accomplished Sr. BO Developer/Tableau Developer/Lead with 14 plus years of professional experience and demonstrated success designing and implementing solutions that improve business functionality and productivity with diverse technical background and proven ability to design, develop and implement technology on an enterprise level. Approach all projects with passion, diligence, integrity and exceptional aptitude.

 

Professional Summary:

 

• Extensive experience in Software Development Life Cycle (SDLC) including Analysis, Design, Development, Implementation, Deployment, Testing and Maintenance of Business Intelligence applications.
• Experience in the documentation of system and business requirements and specifications, step-by step technical and user manuals, design and development of use and test-case scenarios and root-cause analysis, developing test plans, conducting user acceptance testing, training, and implementing new processes and technology.
• Proficient in translating report requirements into detailed report specifications, confirm report design with business users and creating reports using Business Objects 4.1, 4.0, XIR3, XIR2, 6.5.x/5.x, Crystal Reports XI, 2011 and 2013.
• Expertise in Business Objects Products (Universe Design and Information Design Tools, BI Launch Pad, InfoView, Desktop Intelligence, Web Intelligence and Rich Client, Supervisor, Version and Promotion Management, LCM, CCM & CMC) and its deployment.
• Expertise in identification of Business and Data requirements and converting them into conceptual and logical data models.
• Very good understanding of Data Warehousing Design Methodology, Data Warehouse Concepts, Database Design/Architecture including both OLAP & OLTP data.
• Experience in designing the Dashboard with Dashboard (Xcelsius)  (Live Office, BIWS and QAAWS) and Tableau 7.0,  8.0, 9.0, 10.0, 10.3 Desktop and Server .
• Experience in creating Folders, user groups and setting user rights and managing the security using CMC and Supervisor.
• Strong working knowledge in implementing the Best practices for Business Objects Enterprise.
• Experience in Optimizing and tuning of universe and SQL to improve the performance of the Reports.
• Expert in mentoring/training/assisting business users on Business Objects Products.
• Experience in ETL with Business Objects Data Integrator/Data Services.
• Possess excellent communication, decision-making, Problem Solving, Analytical, and Interpersonal skills with result oriented dedication towards goals.
• Experience in Migrating/Upgrading Business Objects XIR2 to XIR3.1 ,XIR 3.1 to 4.0 and XIR3.1 to 4.1
• Possess leadership qualities of managing the Onsite/Offshore teams.
• Experience in Customization of Infoview/WEBI using BO JAVA SDK.
• Strong Knowledge of Business Objects Integration with SAP BI 7.0.
• Experience in SAP BI, BW and ETL.
• Strong Knowledge on BO 4.2 Architecture, Installation and Configuration.
• Knowledge in Planning, Designing, Developing and Deploying Data warehouses/Datamarts.

 

Core Competencies		Functional Areas
BI Project Life cycle development Design and deploy complex BI solutions Excellent skills in Universe & Report Design Excellent analytical & problem solving skills Excellent client relationship management skills Business Objects Migration Specialist		Banking Pharmaceutical Clinical Health Insurance Supply Chain Brokerage Financial Manufacturing General and Sales Ledger Accounting Sales and Marketing

 

Technical Skills:

 

BI Tools	Business Objects 4.1 and 4.0, XI 3.1,R1/R2,6.5.x/5.x, Supervisor, CMC, Universe and Information Design Tools, Broad Cast Agent, Desktop Intelligence, Web Intelligence and Rich Client, Dashboard/Performance Manager and Xcelsius 4.5/2008/4.1, Live Office, BIWS, QAAWS, Infoview, Report Conversion Tool, Import Wizard, Crystal Reports XI; Life Cycle and Upgrade Manager Tools, Cognos 8 BI Suite, Report/Query Studio, Framework Manager   Third Party Tools: Infoburst 2.6
Databases	Oracle 11x,10x, 9x, SQL Server 2000, 2005, 2008, 2012, Sybase,  DB2, Microsoft Access 2010, Visual Foxpro 9.0, Teradata,
Data warehousing	Star-Schema Modeling, Snowflakes Modeling, FACT, dimension tables
Operating Systems	Windows NT, Windows 2003, 2005 and 2008 Server, Unix
Development Tools	Developer 2000, Forms 6.0
Programing Languages	SQL, PL/SQL, JAVA, HTML, XHTML, C, C++, C #, COBOL
Modeling Tools:	Erwin R7.3, Visio
ETL Tools	Business Objects Data Services/Data Integrator XI 4.0/11.7
ERP	Movex 12, ECC 6.0, SAP R/3 4.7

 

Professional Experience:

 

Hackensack Meridian Health, Edison, NJ                                                                                        Dec 17 – Present

 

Role:                 Sr. Tableau Developer/Lead

Environment:   Business Objects 4.1; Web Intelligence; BI Launch Pad; Vertica; EPIC; Health Registries;

                          Tableau 10.3 

                        

 Hackensack Meridian Health is poised to better meet the needs of communities, benefiting both patients and the physicians who care for them. Hackensack Meridian Health have 13 hospitals and more than 200 ambulatory care centers, fitness and wellness centers, home health services, rehab centers, and skilled nursing centers spanning from Bergen to Atlantic counties.

 

Responsibilities:

 

Tableau Developer:

 

• Analysis of the requirements and lots of interaction with the end users to get to the report templates approved.
• Designed numerous Dashboards using Tableau server for Population Health Department.
• Provided Training to Business Users about the Tableau Dashboard's.
• Responsible for preparation of Detail Specification Documents and Training Guides.
• Written SQL queries for data level and Business Logic testing.

 

 

 

 

HSBC, Jersey City, NJ                                                                                                                       Apr 16 – Sep 17

 

Role:                 Sr. Business Objects Developer/Lead/Tableau Developer

Environment:   Business Objects 4.1; Universe and Information Design Tool; Web Intelligence; Rich Client;

                          BI Launch Pad; DB2, Customer Relationship Management System (CRM); CRM OLTP & DWH; 

                          HP Quality center 11.5; JIRA; DB2; Tableau 10; Aqua Data Studio

                           

HSBC Private Bank seeks to be the leading international private bank for business owners and their families. It provides clients with wealth, business and family succession solutions in the largest and fastest growing markets around the world. HSBC Private Bank is the marketing name for the private banking business conducted by the principal private banking subsidiaries of the HSBC Group.

 

Responsibilities:

 

BO Lead:

 

• Involved in the complete life cycle of FATCA, GDS (Trading) and Client Statement Reconciliation Projects from Requirement, Development, Deployment and Testing.
• Enhanced CLM Project as part of Customer Relationship Management System (Know Your Customer) user interface changes.
• Provided estimation for FATCA, GDS, Client Statement Reconciliation and CLM Projects.
• Business Analyst - Frequent interaction with Data Architect and Business to review requirements and results.
• Provide the team with a vision of the project objectives.
• Motivate and inspire team members.
• Ensure deliverables are prepared to satisfy the project requirements, cost and schedule.
• Worked in onsite-offshore Model.

 

 

Universe Designer/Developer:

 

• Developed Universes using UDT & IDT.  
• Designed and Developed FATCA and GDS (Trading) Universe from Scratch.

 

Report/Tableau Developer:

 

• Interacted with FATCA/ GDS (TRADING) users for Reporting Requirements.
• Designed, Developed and Implemented Complex WEBI reports.
• Created Scheduled reports as per user needs.
• Developed Tableau Dashboards for Business User/Management Group (Revenue).
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.

 

 

PEOPLE’s UNITED BANK, Bridgeport, CT                                                                                         Nov 13 – Feb 16

 

Role:                 Sr. Business Objects Developer/Lead/Tableau Developer

Environment:   Business Objects XI 3.1/4.1; Oracle 11.2; Sybase; SQL Server 2012; Web Intelligence; BI Launch                    

                           Pad; Dashboard Design; Live Office; Data Services 4.1; Universe and Information Design Tool;   

                           Version and Promotion Management (Life Cycle Manager); Upgrade Manager; Crystal Reports                                 

                          2013; Erwin Data Modeler 7.3; Sybase Power Designer 16.5, Loan Quest Mortgage Flex Systems   

                          Operational OLTP V 15.9; HP Quality center 11.5; AQT V 9.1; Share Point; Tableau 8.0

                          Windows 2008 Server

                           

People's United Bank is a subsidiary of People's United Financial, Inc., a diversified financial services company. People’s United Bank is a premier, community-based, regional bank in the Northeast offering commercial and retail banking, as well as wealth management services through a network of 410 retail locations.

 

Responsibilities:

 

BO Lead:

 

• Involved in the complete life cycle of Anti Money Laundering and Loan Quest Projects from Requirement, Development, Deployment and Testing.
• Provided estimation for AML and Loan Quest Projects.
• Frequent interaction with SAS and Mortgage Flex Vendors, Data Architect and Business to review requirements and results.
• Performed Code review of other Team Members.

 

Universe Designer/Developer:

 

• Developed Universes using UDT & IDT.  
• Designed and Developed Anti Money Laundering, Loan Quest Operational OLTP and Loan Quest Data Ware House Universes from Scratch.

 

Report/Tableau Developer:

 

• Interacted with the various departments like AML, Loans, Deposits, Mortgage and Sales and for Reporting Requirements.
• Designed, Developed and Implemented Complex WEBI reports.
• Worked extensively with the major functionality like Breaks, Sections, Pre- defined conditions, Calculations and Ranking, Context Operators (For all, For Each and In).  
• Created Custom Calendar’s to satisfy end user needs for Report Scheduling.
• Worked on different Business Change Requests to satisfy user needs.
• As part of Loan Quest Project, Created New Crystal Reports from scratch, and recreated Crystal Reports in  WEBI.
• Developed Tableau workbooks to perform year over year, quarter over quarter, YTD, QTD and MTD type of analysis (LOANS).
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• Created Standard, Cross-tab, Sub reports for AML department

 

BO Architect/Migration Expert/Administrator:   Installed, Configured and Administered BO 4.1. Provided estimate and roadmap for the Migration and Upgradation from Business Objects XI3.1 to 4.1. Implemented Business Objects Best Practices. Carried on Migration and Upgradation from Business objects XI3.1 to 4.1.

 

 

 

Upgradation Project 3.1 TO 4.1:

 

• Converted Universes from 3.1 UNV  to 4.1 UNX as part of Upgradation.
• Assisted Team by converting Reports from 3.1 to 4.1.
• Converted DESKI to WEBI Reports using Report Conversion Tool.
• Resolved the Reporting issues as part of Upgradation Project.

 

 

DIAGNOSTICA STAGO, INC, Parsippany, NJ                                                                                     Mar 11 – Oct 13

 

Role:                   Sr. SAP BO Developer/Architect/Administrator/Tableau Developer

Environment:     Business Objects XI 3.1/4.0; Oracle 10g; Web Intelligence; Crystal Reports 2011 BI Launch Pad;  

                            Xcelsius 2008; BIWS; Tableau 7; ERP Movex version 12; AS/400; Windows 2008; Data Services

                            4.0; Stored Procedures; VBA Macro; OLTP; Universe and Information Design Tool; Lifecycle

                            Manager; Upgrade Manager; PL/SQL; Track It 7.0

 

DSI is the exclusive provider of Diagnostica Stago Hemostasis product lines in the North America and offers a complete system of coagulation instruments and optimized reagent kits for research as well as for routine analysis. DSI is the U.S subsidiary of Diagnostica Stago, France a leader in development and manufacture of Hemostasis products. In the North America, DSI has been servicing the clinical and research Hemostasis laboratory community for over 25 years. The DSI application provides the flexibility to the users to access Sales, General and Sales Ledger (Financial) and Supply chain. Head quartered in Parsippany, NJ.

 

Responsibilities:

 

Architect/Migration Expert/Administrator:

 

• Frequent interaction with Functional Analysts and Business to review requirements and results.
• Provided sizing/scalability recommendations for current and proposed deployments to ensure compliance with overall Business intelligence Strategy.
• Design of Architecture to support to full Lifecycle Development of Universes and Reports.
• Installed and Configured BI 4.0, patches and upgrades.
• Administration of servers, Tomcat Webservers, Windows Active directory SSO.
• Provided estimate and roadmap for the migration from Business objects XI3.1 to 4.0.
• Performed the migration from Business objects XI 3.1 to 4.0 using Upgrade Management Tool.
• Migrated the Security, Universes and Reports from XI 3.1 to 4.0.
• Migration of Universes from one Domain to another like DEV-STG-PROD.
• Validated the Installation by checking the Public Folders, Reports, Groups and by Running Reports.
• Performed Regression testing after Migration.
• Implemented Business Objects Best Practices.

 

 

Universe Designer/Developer:

 

• Developed and Created classes with Dimensions, Detail and Measures Objects.
• Defined Hierarchies in Universe to provide the users with drill down option in Reports.
• Used Lifecycle Manager to promote Jobs from DEV-STG-PROD.
• Developed Universe user Documentation guide for the End Users reference.
• Preparing the Project Plan and update the status of the project to the client with progress and achievements.
• Involved in the entire Software Development Life Cycle of the Project on multiple Enhancements.

 

WEBI/CRYSTAL Report Developer/Tableau Developer:

 

• Involved in Requirement Analysis and effort estimation for Report Development and Deployment.
• Designed Reports in Web Intelligence for reconciliation in Sales and Finance.
• Worked closely with Controller, Finance Director and Executive for Auditing and Sales Revenue reports.
• Designed simple to complex reports using different data providers like Universe, Stored Procedures and Free Hand SQL.
• Scheduled the Daily, Weekly and Monthly publications.
• Developed complex reports using features like slice and dice, drill capabilities, Smart Measures, Input/Output Contexts, @Functions and Cross tab tables.
• Developed a Sales Book report which shows the entire Sales history of Customers at Account Manager Level through Web Intelligence. This report is emailed to all of the Account Managers of DSI in PDF format on first Business day of the month.
• Trained end users on using Business Objects.
• Responsible for preparation of Detail Specification Documents and Training Guides.
• Designed the Dashboards using Tableau for the Sales and Finance departments.
• Written SQL queries for data level and Business Logic testing.
• Created New Crystal Reports for Finance Department.
• Involved in modifying the Stored Procedures, which were used for Reports.
• Worked as an IT Support to solve issues/tickets related to Business Objects using Track It.
• Created Standard, Cross-tab, Sub reports for Supply chain department.
• Design Dashboards using Filters, Parameters and Action Filters.
• Work on generating various dashboards in Tableau server using various data source (Finance & Supply chain).

 

Data Services:

 

• Created, Tested and Executed Jobs using Designer to Transfer data from source to target.
• Created Scripts, Jobs, Workflows and Dataflows using Designer.
• Created, Monitored sessions and workflows in the Work Flow Manager.
• Worked on various Transforms like Query, Case, Merge, Date Generation, History Preserving, Table Comparison and Map Operation.
• Experience in debugging execution errors using Logs (trace, statistics and error) and by examining the Target Data.

 

 

EMA, Livingston, NJ                                                                                                                             Jun 10 – Jan 11

 

Role:                  Sr. Business Objects Developer/Administrator/Data Services

Environment:    Business Objects XI 3.1; Oracle 10g; SQL Server 2008; Microsoft Access  2010, Visual FoxPro 9.0;

                           Data Services 3.1; Web Intelligence and Rich Client; Dashboard Manager; Xcelsius 2008; QAAWS;

                           HP 3000; BO JAVA SDK; JSP; Eclipse; JDBC; Windows 2003 Server                     

 

EMA is focused on the provision of clinical excellence and emergency services to hospitals and health systems. EMA is one of the largest ED firms, and treats almost 1 million patients annually while serving over twenty four hospital clients. The company is widely recognized for clinical excellence, as well as the ability to increase patient volume and improve and sustain patient satisfaction. The EMARS application provides the flexibility to the users to access the reports. Head quartered in Livingston, NJ.

 

Responsibilities:

 

Administrator:

 

• Managing the Business Objects Servers using Central Management Console and Central configuration Manager.
• Setup the Security at the Folder level using Central Management Console.
• Created user accounts and resolved the user account issues.
• Designed the Security Architecture in Business Objects XI 3.1.
• Converted few reports from DESKI to WEBI by using Report Conversion Tool.

 

Universe Designer/Developer:

 

• Developed Universe using Designer Module.
• Extensively worked on the maintenance of complex universes.
• Interacted with Business Analysts, SME’s, Technical Leads and Data Architects for Design finalization.

 

Report/Dashboard Developer:

 

• Created File based events to trigger the scheduled WEBI reports. Scheduled the Daily, Weekly and Monthly reports.
• Designed simple to complex Reports using Web Intelligence and Rich Client.
• Designed the Dashboards using Xcelsius and Dashboard Manager for the different Hospital clients.
• Converted few reports from DESKI to WEBI by using Report Conversion Tool.

 

BO JAVA SDK: