BO
Sudheendra

Professional Summary

  • Over 13 years of IT experience in Data Warehousing projects using tools like SAP Business Objects and Informatica.
  • Experience in Analysis, Design, Development, Production Deployment, project coordination and creating complex reports using Business Objects Universe Designer Tool (Designer), IDT, Web Intelligence, Desktop Intelligence, Xcelsius, SAP Dashboards, Crystal Reports, Data Architecture, SAP Mobile BI, Info View, BI Launchpad, infoburst, Central Management Console (CMC), Business Objects Data Services.
  • Hands on experience working in database design, analysis and implementation
  • Hands on experience working with the cloud migration team for migrating BO 4.1 into cloud and testing the reports compared to 3.1
  • Expertise at Universe Designing, Developing, Maintaining and Resolving loops, Chasm traps, Fan traps using Alias, Context. And also creating classes & objects (Dimensional, Detail, and Measure), defining Joins & Cardinalities and testing with Check Integrity.
  • Proficient in creating canned/adhoc reports from different data sources utilizing Business Objects Web Intelligence and Crystal Reports.
  • Worked using various data providers like Universes, Personal Data Files, Stored Procedures and Freehand SQL to generate reports.
  • Generated complex reports by linking data from multiple sources using functionalities such as Combined Queries, Master Detailed, Slice and Dice, Drilling methodology, Scope of Analysis, Merge, Filters, Ranking, Sections, Graphs and Breaks.
  • Built multiple dashboards for the projects and Engineering team using Xcelsius 2008 and SAP Dashboards with Live Data connectivity using Query as a Web Service (QaaWS), Live Office.
  • Created SAP Business Objects documents to effectively view and work on an iOS device (iPhone or iPad) using the SAP BI Mobile app.
  • Hands-on experience in migrating Business Objects applications from Business Objects 5.x/6.x to XIR2 and 3.1 to 4.1.
  • Experience working with multiple relational databases like Teradata, Oracle and SQL Server.
  • Expertise in developing complex queries and programs utilizing SQL and PL/SQL and strong experience in writing Stored Procedures and Triggers.
  • Experience in data architecture and have Good knowledge in implementation of Relational Database (OLTP) and Data warehousing systems (OLAP), Data Marts and Data Warehouse concepts Star Schema, Snowflake Schema.
  • Experience in design and development of Informatica Mappings and Workflows
  • Worked on complex mappings using various Transformation logics.
  • Have improved performance of data loading and reports running by understanding the requirements and data together.
  • Extracting data from multiple sources using Business Objects Data services and loading the data into multiple target databases.
  • Extensive experience on conducting JAD sessions for interacting with business users and business owners for requirements gathering, analysis of business processes, report enhancements etc. and ability to multi-task in a fast-paced technical environment.
  • Trained users in report development and running ad-hoc queries in Business Objects.
  • Excellent Oral communication and presentation skills.
  • Excellent team player at all levels with ability to perform independently with exceptional analytical, presentation and problem solving skills.
  • Well versed with CMMI level documentation
  • Experienced in project management activities such as team building, knowledge management, effort estimation, scheduling project, planning deliverable, handling clients, conducting stakeholder training etc.
  • Experienced working with business system analysts in requirements gathering phase and co-ordinating with functional and technical teams to provide best possible solution to end users
  • Passionate about analytics and business intelligence
  • Experienced in identifying and providing business insights to enable senior management in making best business decisions
  • Self-driven individual with an ability to work independently as well as in diverse teams

Education

  • Bachelors in Computer Science from Jawaharlal Nehru Technological University, India.

Technical Skills

BI Tools
BO 4.1/3.1(R3.1)/R2/R1/6.x/5.x(Universe Designer Tool (Designer), IDT, Web Intelligence, Desktop Intelligence, Xcelsius, Tableau 9.x Info View/Launch Pad, SAP Dashboards, SAP Mobile BI, Import Wizard, Info View, BI Launch Pad), Crystal Reports 2008/XI/10/9, Version Manager, Business Objects Data Services 4.2/12.2.2, infoburst, Autosys, Redwood
Languages
SQL, PL/SQL, Unix Shell Scripting (Korn/C/Bourne), Pro*C, Java, J2EE, C, C++
Databases
Teradata 12/13/14, Oracle 11g/10g/9i, SQL Server 2005/2008/2012, Progress OpenEdge 2009
Operating System
UNIX, LINUX, Windows NT/XP/Vista/98/95, Red Hat (RH5 to RHEL 6), MS DOS, IBM AIX, Sun Solaris
Reporting Tools
Business Objects Developer Suite 5.1, Business Objects XI/XIR2/XIR3.1, COGNOS Suite, COGNOS Report Net, Crystal Reports, Oracle Reports 10g/9i/6i
Oracle Utilities
SQL*Plus, SQL*Loader, SQL Developer, TOAD
Other Tools
Informatica 9.1.6/8/6/1/8.5.1 (Power Center), Erwin 8.1/7.3, Visio 2007, Oracle Forms and Reports, APEX, Golden Gate, Autosys, Subversion, Revision Control System, BMC Control-M

AWARDS

  • Received ‘Employee of the Month’ awards and RAVE awards at Credit Suisse
  • Recognized multiple times as ‘Movers & Shakers’ at Credit Suisse

Professional Experience

Credit Suisse Bank, NC
Duration
Nov 2012 – Till Date
Role
Sr. Business Objects Consultant & Lead
Description
Credit Suisse Operations IT team manages the booking and life cycle events of various investment banking products, the business team validates the booking process through various operational reports. Deep understanding of various booking modules and product behavior is expected to understand and cater to the operational reporting requirements
Project 1:
iDWH (International Data Warehouse)
Primary Role:
Sr. Business Objects Consultant & Lead
iDWH project’s vision has been to provide a single and consistent data source platform for Private Banking at International level and Investment Banking for the region. This also serves the needs of Local and Global Head Office reporting. This covers financial control, risk reporting, credit risk monitoring and compliance. Platform consists of a 3 layer architecture which consists of Staging, Transformation and Reporting. The Business Objects is aligned on top of the analytical data mart, covering all departments, lines of business and business functions.
Responsibilities
  • Worked as a lead in the current position and involved in Design and development of reports to cater to the regulatory requirements
  • Performed the role of a Business Analyst and created functional specification documents
  • Lead the team onsite and offshore in different phases of the project like Requirements gathering from Business users, participated in project sessions with the Project core Team, EDW Schema Design, EDW schema Test, Universe Design, ETL design, System testing of Universe and the Reports, Performance testing, Universe and Reports maintenance etc.
  • Expertise at Universe Designing, Developing, Maintaining and Resolving loops, Chasm traps, Fan traps using Alias, Context. And also creating classes & objects (Dimensional, Detail, and Measure), defining Joins & Cardinalities and testing with Check Integrity.
  • Experience in conducting various JAD sessions with end users and project team to collect the requirement and ensure the report output is as expected by the users.
  • Proficient in creating canned/adhoc reports from different data sources utilizing Business Objects Web Intelligence and Crystal Reports.
  • Hands on experience working with the migration team for migrating BO 4.1 and data services
  • And tested the reports to make sure it was matching the exact same results from our BO 3.1 environment.
  • Solved all the issues we were facing with the reports in the new environment.
  • Trained the users with the new BO 4.1 environment by directly accessing it from their PC’s, IPads and IPhones.
  • Was the data architect for all my projects and also involved in the universe design of regulatory reports
  • Strong Hands on Experience with macros and store procedures on Teradata and oracle.
  • Developed some complex views and also worked on SQL tuning and query performance improvements on Teradata and Oracle.
  • Followed the best practices on data warehousing and have strong knowledge on data warehousing concepts.
  • Analysis of data requirements and translation of these requirements into dimensional data models using Extended Star Schema data modelling techniques.
  • Strong Knowledge on ETL by Extracting Data from different sources, Transforming and loading them into the Enterprise Data Warehouse databases using SAP Business Objects Data Services.
  • Used to schedule all the batch jobs using Autosys and redwood. Had management console access to do so.
  • Created and maintained Views, Operational Data Stores, Workflow, Data flow, Data sources, Transform objects, Transfer rules and Update rules for Data targets in the Enterprise Data Warehouse.
  • Prepared design documents and showcased the solutions using UML diagrams
  • Reviewed/prepared technical specifications, test and review logs for the universes & reports
  • Developed .unx file using IDT tool
  • Created Secured (.cnx) connection and designed Data Foundation (.dfx) using multiple data sources using IDT
  • Customized Business layer by assigning row level and column level security using security editor
  • Implemented Aggregate awareness and hierarchy functionalities are developed in Business Layer(.blx)
  • Created the Classes, objects, detail objects, measures and filters in universe by using Universe Design Tool (UDT).
  • Designed snowflake, star and multiple star schemas in universe
  • Developed & Tested complex webi reports
  • Enhanced the universes using derived tables, alias tables and contexts.
  • Converted the reports from DESKI to WEBI using the report conversion tool.
  • Used the different data sources Universes, Custom SQL and Excel.
Environments
Business Objects XI 3.1/4.1, Information Design Tool (IDT), BI Launch Pad, Infoview, CMC, Import Wizard, BO Designer, Web Intelligence, Desktop Intelligence, Oracle 11g, Windows XP/2007, Unix, Control-M, SVN.
Project 2
Management accounting platform
Duration
Jan 2010 - Jun 2012
Primary Role
Management Account Analyst
Management accounting platform, apart from the Regulatory and Operational reporting, supports the regional financial controllers and global financial controllers to understand and interpret the performance of a various parameters like Turnover, Revenues, Assets, and Income across regions. Numbers of reports are created on a Daily/Monthly basis to support the credit Suisse senior management and client facing teams in making critical decisions.
The Key performance indicators are structured in the form of a complex tree which constitutes of negative hierarchy based aggregation. Creating reporting solutions involves traversing the tree structure without losing the factual data.
Responsibilities
  • Engaged with business end users and engineering teams to understand requirements
  • Lead the Business Objects team to ensure that tasks have been assigned appropriately and were delivered on time adhering to quality standards
  • Performed code reviews and mentored Business Objects team to adhere to quality standards
  • Designed and implemented complex approval reports which were used by local controllers to validate the monthly performance of various teams.
  • Designed and implemented reports to identify largest and smallest clients based on the Net New Assets brought in on a monthly basis
  • Worked on the Progress OpenEdge and SQL server database to create the reports.
  • Preparation of critical, Master Detail, Sub Reports, Cross Tab and Summary reports using BOXI R/3 and Crystal Reports.
  • Expertise at Universe Designing, Developing, Maintaining and Resolving loops, Chasm traps, Fan traps using Alias, Context. And also creating classes & objects (Dimensional, Detail, and Measure), defining Joins & Cardinalities and testing with Check Integrity.
  • Worked with the financial team to create a Daily Production Report for each plant.
  • Scheduled jobs with crystal reports and SQL server.
  • Published and Participated in UAT testing and then to production after getting approval from Users.
  • Performed data analysis to resolve data issues in data warehouse.
  • Had to mentor few developers with advanced reporting techniques.
  • Worked as an administrator in creating users and folders and managed access privileges in windows
  • Performed Admin tasks like monitoring DB services, monitoring BO server running with optimal performance.
  • Some daily admin tasks included verification BO user logins and security checks testing availability of all universe connections, Monitoring day to day scheduled jobs.
  • Designed and developed Universe and Report as per the requirements.
  • Tuned Universes & Reports to improve performance.
  • Created Analytics and Dashboards using Performance Manager to enable executives track progress and compare current and historical performance against established targets.
  • Created single or multi line chart for showing tendency over a period of time particularly used in revenue history using Dashboard.
  • Created graphical representation of reports such as Bar charts, 3D charts, Pie charts, Column chart, Line chart, Bubble chart using Dashboard 4.0.
  • Used Xcelsius for presenting dashboards to End users.
Environments
Business Objects XI 3.1, Infoview, CMC, Import Wizard, BO Designer, Web Intelligence, Desktop Intelligence, Oracle 10g, Windows XP/2007, Unix, Control-M, SVN.
Project 3
Trade Surveillance Platforms
Duration
Nov 2007 - Jun 2010
Project Specific Role
Operational Reporting Analyst
Credit Suisse Operations IT team manages the booking and life cycle events of various investment banking products, the business team validates the booking process through various operational reports. Deep understanding of various booking modules and product behaviour is expected to understand and cater to the operational reporting requirements
Responsibilities
  • Gathered requirements and developed functional specifications
  • Designed scalable reporting solutions
  • Involved in 3rd level production support activities
  • Planned and executed production deployments (Raised/Implemented RFC requests)
  • Conducted trainings to business users
  • Developed Universes & Reports for teams across APAC/UK/US
  • Created UI Documents as supporting documents for the Business Requirements Documents.
  • Developed Excel formulas for testing and verification of functional requirements.
  • Involved in building and designing Universes and resolved Loops and Traps using Contexts and Aliases.
  • Created Aggregate awareness functions on multiple summary tables to improve the query performance.
  • Updated Universes as per the changes of the Database table structure and notified the users about changes made to the Universe.
  • Set up Universe level conditions to restrict data based on report requirements.
  • Created reports using Business Objects functionality’s like slice and Dice, Drill Down, Cross Tab, Master Detail and Formulae’s.
  • Used Import Wizard to migrate reports from one environment to another environment.
  • Worked with Multiple data providers including Personal Data files, Stored Procedures and Freehand SQL to create reports.
  • Configured Local, Central and profile repositories and repositories are associated to the Job server.
  • Created Users in Data services management console and assigned roles based on the requirement.
  • Supported Production environment and fixing the issues raised by the jobs while running in production.
Environments
Business Objects XI 3.1, Infoview, CMC, Import Wizard, BO Designer, Web Intelligence, Desktop Intelligence, Oracle 10g, Windows XP/2007, Unix, Control-M, SVN.
CA Technologies, India
Duration
Jun 2006 – Oct 2007
Project (s)
Harvest Change Manager & CA Message Manager
Primary Role
Business Objects Analyst
CA Harvest Change Manager is a comprehensive, integrated, repository-based change and configuration management solution that can help organizations effectively manage complex, enterprise-wide development activities throughout the entire application development life cycle. CA Harvest Change Manager is fully scalable, serving project teams working on both large and small distributed enterprise systems.
CA Message Manager helps effectively to manage and secure the email messaging system as an integral part of overall business.
Responsibilities
  • Involved in design discussions and in gathering requirements from the business users to build the reporting application.
  • Performed admin role responsible for creating users and groups, and responsible for creating row level and objects level securities using Central Management Console
  • Managed and configured Servers, used the import wizard to migrate between different environments
  • Created universes from various data sources
  • Created reports using Business Objects WebI (Web Intelligence), DeskI, and Crystal Reports
  • Implemented localization at both Universe Level and Reports Level
  • The Sales Analysis and Billing reporting solution: Customers want full access to all the information and functionality they need to serve themselves. This system is a complete application for business intelligence that gives users the tools they need to analyze sales, marketing and other corporate data.
  • Performed in depth analysis and data & prepared weekly, biweekly, monthly reports by using Business Objects.
  • Set up hierarchies in the Universe for providing drill down options in the reporting environment.
  • Utilized Aggregate Awareness concept in the creation of objects.
  • Created reports using Business Objects functionalities like Queries, Sections, Group values, Breaks, Filters, Conditions, Alerters, Ranking, slice & Dice, Drill functions, Sorting, Formulas, etc.
  • Maintained and Modified existing reports according to needs of users.
  • Created report templates to maintain a uniform standard across all the reports.
  • Created charts and graphs to produce the net profit or gain for the marketing department.
  • Designed & developed various departmental reports by using Business Objects.
  • Creation of different types of reports, such as: Master/Detail, Cross Tab and Chart (for trend analysis). Use of filters, conditions, calculations, etc.
  • Use of Designer module to implement Universes, linkages between tables, creating prompts and queries, parsing the Universes, applying contexts and alias tables to remove cyclic dependencies.
  • Managing the report deliverables and the project timeline.
  • Gathering the functional specifications for the financial reports needed for the business.
  • Scheduled Documents on daily, weekly, and monthly bases.
  • Developed Business Objects reports with multiple currency conversions to enable global deployment of the reports.
  • Involved in developing PL/SQL scripts in case bad data is loaded into the Oracle Tables.
  • Understood basic business analysis concepts for logical data modeling data flow processing and database design. Utilized skills for problem solving.
  • Assisted in the analysis, design, coding and development of building a new schema (staging tables, views, SQL files).
  • Created and configured Data Connection, Dynamic Data Connections, and Business Elements
  • Created cascading list of values using Business Views
  • Developed technical and user documentation
  • Developed document from development environment to production system
  • Performed user training on ad-hoc reporting
Goldstone Technologies, India
Duration
Mar 2003 – Jun 2006
Role
Business Objects and Oracle Developer
Responsibilities
Worked as a Business Objects Developer on Web Intelligence (WebI) and full Client modules of Business Objects Product for the Business Objects support site in India

  • Designed Business Objects Universes and Reports (Full Client and WebI) for various clients of Business Objects all around the world
  • Worked on troubleshooting Business Objects Universes and Reports (Full Client and WebI)
  • Engaged with users to understand their specific requirements and business needs
  • Involved in troubleshooting users’ reports & universes
  • Developed and maintained various user groups and user groups security using Business Objects Supervisor
  • Extensively worked on Performance tuning by using Explain plans and various hints.
  • Used Oracle 9i features such as merge for various transformations.
  • Used UNIX Shell scripts (KORN) for Extracting and Parsing data from the files.
  • Used stored procedures in Oracle for retrieving the data from the database for solving complex queries.
  • Wrote Unix Shell Scripts, undertook Code Optimization and Performance tuning of the application.
  • Created Stored Procedures, functions and Packages in Oracle 9i using SQL and PL/SQL for the Audit Trail using Oracle 9i as backend.
  • Performed uploading and downloading flat files from UNIX server using FTP.
  • Involved in debugging and Tuning the PL/SQL code, tuning queries, optimization for the Oracle database.
  • Ensured that weekend data loads, end-of-month & end-of-quarter processing ran successfully and completely, transparent to user community.
  • Review data transformation rules and provide technical suggestions in data transformation logic and pseudo code (PL/SQL).
  • Creating Test scripts for the generated final Reports.
  • Involved in data migration from SQL Server to Oracle 9i.
  • Good working knowledge of PL/SQL and UNIX in Production Support.
  • Attended meetings and review to discuss current issues and processes to tackle issues.
  • Helped users in creating& troubleshooting Universes based on different databases such as Oracle, SQLServer based on the requirement
  • Developed customized reports such as drill down, slice and dice, filter change displays and charts
  • Developed enhancements to the existing reports in Full Client, ZABO and WebI
  • Mentored junior engineers in Business Objects components
  • Achieved highest client satisfaction score of 96%