SANGEETH ANTONYSAMY

ac43z1@r.postjobfree.com

571-***-****

Experience Summary:

** ***** ** ********** ** BI reporting, as a Lead 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, Design Studio, Lumira, Tableau and SQL as a part of the Decision Support Systems (DSS) initiatives.

Technical Summary

Proficient in all phases of the Software Development Lifecycle(SDLC(Water Fall & Agile methodology)) 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 modelling.

Well versed in SAP Business Objects XI 4x/3x/XI R2 Enterprise Suite (Universe Designer, Information Designer tool (IDT)), Web Intelligence, Promotion management/ LCM, Central Management Console (CMC), and Import Wizard.

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 fulfil 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.

Experience in Business Analysis, Data Migrations, Data Processing, Quality Analysis and Project Management.

Well versed in developing Dashboard designer and Xcelsius.

Experience in front-end Business Warehouse (BW) Components like Queries, Calculated Key figures, Restricted Key figures, Structures, Variables, Exceptions, and Conditions.

Designed and Developed universes using SAP BEx Queries, Multiprovider and relational sources.

Knowledge and understanding on SAP HANA, and hands on experience on HANA studio.

Successfully implemented SAP HANA (Proof of Concept).

Experience on Prototyping the new technologies like SAP Lumira, SAP Design Studio, Analysis Office SAP BO Mobility (Proof of Concept).

Experience in creating SAP BEx Queries using calculated and restricted key figures, variables, structures, Exceptions and conditions.

Experience in building SAP BO Universes with DB Stored Procedures as a data source

Expertise in configuring Distribution Services to enable Subscriptions to be delivered to file/e-mail.

Hands-on experience working with Query optimization and Performance.

Involving in Estimates and project plans.

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

Keen interest in learning new technologies.

Technical Skills

Business Intelligence

Business Objects XI R3.1/R2/XI/6.5/6.1/6.0/5.1 (Designer, Desktop Intelligence, Web-Intelligence Rich Client, Infoview, Web-Intelligence, Xcelsius, Web-I SDK, Broadcast Agent, Import Wizard, Publisher, Auditor, Application Foundation Dashboard Manager, Report Writer, BO Set Analyzer, Query as Web Service, Business View Manager, Query Builder, Report Conversion Tool, Application Foundation & Dashboard Manager),Crystal 2008, Business Objects SDK. Informatica Power Center 8.6.1/8.1/8.0/7.1.2, (Designer, Repository Manager, Workflow Manager, Workflow Monitor),Data Services, ETI, Data mart, OLAP, OLTP,Mapplet, Transformations, SQL*Plus, SQL*Loader, BW, Bex, Netweaver 7.x Tableau, SAP Lumira,SAP Design Studio. Analysis Office,

Business Analysis

Functional Requirements Gathering, User Interviews, Business Requirements Gathering, Process Flow Diagrams, Data Flow Diagrams, Data Analysis, Requirements Analysis, Design, Data Modeling, Data Architecture, Data Flow, Data Cleansing, Personalization, Analysis Office

Dimensional Data Modeling

Dimensional Data Modeling, Data Modeling, Star Join Schema Modeling, Snowflake Modeling, FACT and Dimensions Tables, Physical and Logical Data Modeling, Erwin 4.5/4.0/3.5/3.2, Oracle Designer, Visio and Sybase Power Designer.

Databases

SAP HANA, MS SQL, MS ACCESS, Postgres SQL, MySQL, Oracle, DB2,Teradata

Servers

Windows Servers, Linux Environment, Unix

Professional Experience:

Delta Dental, November 2017 – Till Date

San Francisco CA,

Project Lead (Architect)

Delta Dental is the largest dental plan system in the United States. The Delta Dental Plans Association is composed of 39 independent Delta Dental member companies operating in all 50 states, the District of Columbia and Puerto Rico. These member companies provide coverage to 68 million people, enrolled in over 120,000 groups. While many of the Delta Dental member companies and Delta Dental Plans Association (DDPA) are non-profit organizations

Responsibilities:

Worked on the projects for Data Segregation for Delta Dental. Which includes Data Security for Multi-Tenant Organizations

Worked on Gathering requirement from the Multi-Tenant Stake Holders and providing the Data Segregation for the Business Objects Reports and Tableau Dashboard.

Worked on creating new reports and Universe with multi data source universe for Adhoc Reporting.

Designed and developed universe in both IDT and UDT.

Worked on creating complex reports with multiple data providers

Created Custom SQL and Free Hand SQL reports based on the Requirements.

Worked on CMC, CCM, PMT and other Admin tools and have delivered Admin activities.

Analyzing end to end business requirement and converting it into project scopes with technical and Functional Specifications

Have developed and have done enhancements to Crystal reports.

Worked with ETL teams in converting the Data from different data sources to support same business applications.

Worked on creating ETL jobs for data scope for ODS environments.

Worked on Creating the PL/SQL views and Procedures to implement data security.

Have worked on Oracle Hash Functions and Replication DB for the MPP system implementation for better performance of the Oracle.

Worked on ITIL models for Operational activities.

Worked creating add ins for Analysis Office

Multidimensional cubes research through Analysis Office

Worked on Row Level security in the Business Objects Universes

Involved on Onsite – Offshore coordination in giving continuous project deliveries.

Doing proper unit testing/UAT on the project scope for the business

Worked on creating Tableau Dashboard and Stories with interactive charts.

Have done multiple POC’s and Wireframes for the business and have done the Dashboards for the business.

Worked on Implementing SAP BO on AWS Cloud systems and managed BO Clustered environment

Environment:

Business Objects 4.2, BODS, SSIS, Tableau, MSSQL, Oracle 12G, AWS, Analysis Office

Fifth Third Bank June 2016 – October 2018

Cincinnati OH

Technical Leader – Business Intelligence

Fifth Third Bank (5/3 Bank) is a U.S. regional banking corporation, headquartered in Cincinnati, Ohio at Fifth Third Center, and is the principal subsidiary of holding company Fifth Third Bancorp. The company operates under an Ohio charter. The company's main businesses include branch banking, commercial banking, consumer lending, payment processing, investment advising, and title insurance.

Responsibilities:

Managing Onshore and Offshore teams for the Business Intelligence Activities which includes Business Objects, Tableau and DataStage ETL

Worked on Coordinating the Onshore/Offshore teams conducting regular meetings

Concentrating on Project development and Incident Management for the Consumer Business Intelligence Group for the Bank for BO, Tableau and ETL

Involved in Business Objects Universe Developments, Universe Enhancements, Auditing Users and Groups, Creating Primary Webi Reports for the Stakeholders

Migrations of Business Objects 3.1 Environments to 4.1 Environments

Connected Business Objects universes in Oracle Essbase Cubes and have created reports

Worked on Complex reports with Multiple Data Providers

Worked on Data Modeling in Erwin Tools.

Worked on Performance Optimization of BO Reports and made considerable optimization using Aggregate awareness and Index.

Created Universe which best suited for Ad-hoc reporting

Enhancement on the reports for various business requirements.

Worked on Critical project Deadlines and Deliverables.

Creating and Supporting Xcelsius dashboards

Created Report Bursting through Personalization and also Personalization for Dynamic recipients

Created various Tableau Reports for Internal and Business needs with different chart representation.

Acted as a Tableau Site Admin for the whole team.

Created Tableau Visualization for Monitoring the ETL job flows.

Worked on IBM Information Server (Datastage) and have created jobs and monitored the jobs and the job flows.

Supported the ETL jobs by the time of the Job aborts

Created Tableau reports on the data flow of the ETL and tracked the Jobs.

Thrivent Financial:

Minneapolis MN May 2015 – June 2016

Business Objects Lead

It is financial services non-profit organization headquartered in Minneapolis, Minnesota and Appleton, Wisconsin. As a member-owned fraternal benefit society, it operates under a chapter system, serving approximately 2.4 million members. Operating through its local chapters nationwide, Thrivent Financial and its subsidiaries offer financial products and services including life insurance, annuities, mutual funds, disability income insurance, credit union products and more.

Responsibilities:

Managing the Team and coordinating the Business Activities.

Have Done POC for the Customer based on the requirement.

Created Data Flow Diagrams (DFD) to define the data element flow to the most granular level to translate data requirements to ETL processing

Worked in Agile methodology, had regular Status calls with the Client.

Done ETL implementation Jobs for mapping database for transactional purposes.

Have Done Design Documentation including High Level and Low Level Documents.

Working with database connections, SQL joins, cardinalities, loops, aliases, views, aggregate conditions, parsing of objects and hierarchies.

Created Universe with Complex functionality Including aggregate awareness and Conditional Filters.

Cleared Fan/Chasm Traps with various trap clearing methods such as Short Cut joins, Context and Alias

Created Reports in BI Launchpad with Multiple Data provider.

Created complex report with applying logics for multiple variables for a high calculation reports.

Worked on Date functionalities to change the data formats.

Worked extensively on performance management for reports.

Created Xcelsius Dashboard with multiple functionalities and tabs to retrieve data.

Created Tableau Visualization Reports.

Integrated Tableau and BO universe with Toreo Data Tool

Created various Cache reports for the Dashboards.

Developed various Charts and Graphs like Bar chart (Side By Side, Stacked), Line graphs, Pie -Charts etc by using Chart expert of Reports.

Have done Unit testing, done Bug Tracking and have also created Test cases for the same.

BO Support Activities.

Installed Tableau Server and Desktop.

Worked on creating BO reports on Teradata Systems.

Creating Users and Groups.

Scheduling the Reports and Personalization of the reports to Bursting for Enterprise

Windows AD SSO configuration and Management.

Worked in BO Backup and restore activities through Promotion Management tool.

Maintain Audit/CMS database.

Communicating with SAP Support for Product support.

Consulted on Tableau server performance enhancements; upgrades from version 8.1.5 to 9.2 and server reconfiguration based on workbook complexity and data extraction

Customized the Tableau landing page with site listing as icons and descriptions

Constructed the reports page for internal strategy group with standardized custom right and left side sections within Tableau

Environment: Business Objects 4.1, Oracle 11G, Tableau 8.0, 8.1.5, 9.2, Informatica, Teradata

Lexmark October 2014 – May 2015

BI Infrastructure Lead

Lexington KY

Lexmark International, Inc. is an American corporation that manufactures laser printers and provides enterprise software.

Responsibilities:

Gathering Business Requirements and documenting

Migrating Business Objects 3.1 to 4.1

Worked on HANA Installation in Amazon Web Service and Linux Suse Machine.

Worked closely with SAP Technical team on implementing the First Customer's project on HANA.

Involved in installation of SAP HANA 1.0.17 in two environments.

Involved in installation and configuration of SAP Business Objects Data Services 4.0.

Used SAP BW/SAP CRM/Oracle as source and HANA as target with SAP Data Services as the Integrator.

Developed Jobs in SAP Business Objects Data services which do the ETL between BW/CRM/Oracle and HANA.

Worked closely with WEBI Reporting team on the requirements.

Involved in Support and Monitoring activities after go-live.

Involved in enhancements of Data Services Jobs, HANA Models and applying Patches on HANA.

Following the ITIL Concepts in the Change and Release Management

Have Connected SAP BW/HANA as a source and have done BO reports.

Worked Extensively in Universe Designer and Web Intelligence. Worked on Infocubes and Bex Queries.

Installed Tableau Desktop

Created Data Visualizations on Tableau.

Have worked on Complex Reports with Multiple Data Providers.

Worked on Data blending on Tableau

Worked on Different Charts and Maps in Tableau

Environments: Business Objects 4.1, HANA 1.0.17, BODS 4.2, Tableau 8

BMC Software May 14’ – Oct 14

BMC Analytics for Business Service Management

Houston TX

Application Specialist:

Responsibilities:

Working on BMC Analytics for BSM which is working on SAP BO.

Working on ITSM universe and performing Installation, Migration, Creating Users and Other BO Administration for various Federal and Other clients in US through remote.

Working on Functional Requirement at ITIL terms.

Recommendations for ITSM installation with ITIL concepts.

Done ITIL process management.

Done interaction with the client in getting the Business requirements.

Development of Reports and Universe based on ITSM needs.

Backup Activities through BIAR UDT and PMT tools

Done patches and Service Pack Installation.

BO License Management.

Configured Atrium SSO, Windows AD and LDAP

Have worked on Linked universes.

Worked extensively in the BO support activities.

Has communicated with SAP support on various issues and have supported the End Clients.

Worked on the Down times of the Server and making the system up and running.

Worked on Creating User groups and Access restrictions.

Have acted as Migration Specialist and have done migration from R3 to R4 versions.

Interacting with the customers and helping them as per the Business needs of the customers.

Performance Tuning Activities of the Universe, Reports & Servers.

Environment: Business Objects XI R3.1, 4.X CMC, CCM, MS-SQL 2012, UDT, IDT, PMT, UMT, Import Wizard

Well Point Inc Sep 13’– May 14

Sr. Business Objects Counsultant

Indianapolis IN

Responsibilities:

Worked as a Business Objects Associate in a BO migration Project from Crystal Reports to BO

Gathered Requirements from the Client and through Business Analyst.

Documentation of reports which Includes HLD(High level Design) & LLD(Low Level Design)

Analyzing Stored Procedures and converting into BO Reports.

Created complex universe with Aliases Table and Derived table.

Working on conversion of Enrolment and Disenrollment reports which was running on Crystal Report.

Done complex reports with multiple query’s and multiple data providers.

Have created many conditional objects in the universe.

Have worked on Query level filters and Report filters.

Migration Activities like Migration of the reports and universe from Development environment to Testing, UAT, Performance and Production.

Supported the BO Admin team in terms of Admin activity.

Leaded a team of 4 and made them to work independently on the tasks assigned.

Motivated and trained the team in completion of the project.

Have created Unit Testing Test cases and done unit testing.

Creation of BO universe and reports

Conducting reviews with the Client and Business users

Coordinating with the BO Admin Team in Migration of reports & Universe to various environments.

Environment: Business Objects XI R3.1, Crystal Report, Webi, MS-SQL 2012,

North Western Mutual

Milwaukee WI July 2012 - July 2013

SAP- Business Objects Consultant

Northwestern Mutual old mutual company serving the insurance and investment. Northwestern Mutual focuses on clients long-term needs and the company offers clients a financial security solution which is backed by the company's exceptional financial strength.

Responsibilities:

Identified and road mapped the Business Requirements (functional & technical) with the Business users, which acted as a base for the project initiation and implementation.

Gathered Customer, User and Owner requirements; analyzed and documented them.

Created Data Flow Diagrams (DFD) to define the data element flow to the most granular level to translate data requirements to ETL processing

Integrated with Business Intelligence ETL team to give out better performance.

Extensively used Business Objects Designer to design and maintain Data warehouse Universe.

Expertise in migrating, testing and troubleshooting the Business Object XIR2 to XI3.1 content and environment

Setup, execute, and test the assigned programs utilizing BO XI3.1 Primary Webi and DeskI tools.

Worked on creating Universes using the Business Object Designer and connected to the database using ODBC. Resolved join problems, fan and chasm traps using aliases and contexts.

Creation of reports like Reports by Product, Reports by Customer, Reports by Period, Demographic reports and Comparative reports, Working with database connections, SQL joins, cardinalities, loops, aliases, views, aggregate conditions, parsing of objects and hierarchies.

Developed ad-hoc and recurrent reports from a number of internal and external data sources like Oracle, MS ACCESS which has ODBC links from Data ware house.

Created complex reports using WEBI, DESKI and WRC with multiple data providers.

Developed various Charts and Graphs like Bar chart (Side By Side, Stacked), Line graphs, Pie -Charts etc by using Chart expert of Reports.

Have sound knowledge in Excel -- Created graphs using Pivot tables and written VB scripts for macros.

Used Complex EXCEL formulae v lookup and H LOOKUP to generate complex Dashboards.

Experience on creating dashboards using Xcelsius by importing data file to create the visualization utilizing QAAWS and Live office connection.

Created Dashboards in Crystal Xcelsius 2008using Charts, Selectors, Gauges, Maps, Arts and Background and Web Connectivity

Scheduled and monitored reports using Broadcast Agent Console.

Created, refined and delivered functional test materials collaborated with test cases, set up test plans, schedules and scenarios.

Used Business Objects Central Management Console in creating and managing the users, giving access permission for Business Objects Reports.

Responsible for designing many SQL queries, procedures, Cursor, Triggers.

Written dynamic PL/SQL procedures, which were used for porting and generating data and responsible for optimizing SQL queries and Stored Procedures.

Tuned Report Performance by exploiting the Oracle’s new built in functions and rewriting SQL statements.

Created parameterized and summary Crystal reports and tested them thoroughly.

Customized existing reports for presentations using Cross-Tab reports. Developed sub-reports, Running Totals, Sorting, Alerting, used Crystal syntax to create formulas for the reports.

Involved in the creation of Cross Tab Reports and Sub Reports using Crystal Reports with different data sources like Oracle and MS ACCESS.9

Designed, implemented and maintained enterprise-wide application via Visual Basic and SQL database.

Enhanced server database with Stored Procedures, Indexing, Triggers and performance analysis functions.

Trained end users in understanding the reports. Functionalities such as Slice and Dice, Prompt, Drill mode and Ranking were used for Multidimensional Formatting.

Expertise in using Import Wizard and Report Conversion Tool for migrating the Universes and Reports between different environments like Dev, QA and Production and converting Deski reports to Webi

Environment: Business Objects XI3.1/XIR2/6.5/6.1,Data Integrator XI, Dashboard Manager, Web I 6.1, Deski, Windows 2000/NT, SQL, Oracle 10g, T-SQL scripts, TOAD,PL/SQL, MS ACCESS, DTS.

Kaiser Permanente

Chennai india February 2011 – May 2012

Business Objects Developer

The Kaiser Permanente Institute for Health Policy provides a focus and resources for Kaiser Permanente to better participate in shaping the health policy agenda in the United States. Kaiser Permanente shares its health care vision and experiences with governments, health plans, and other international organizations striving to improve their health care systems. The organization’s annual report outlines Kaiser Permanente’s work in 2008 caring for 8.6 million Americans and contributing to health research, clinical excellence, and the communities the organization serves.

Responsibilities:

Gathered Customer, User and Owner requirements; analyzed and documented them.

Migrated Report, universes, user from XIR2 to XIR3.

Troubleshooting BO XI installation and migration issues.

Experience in Warehouse development, working with Data Migration, Data Conversion and Extraction/Transformation/Loading using Data Integrator and Data Services with Oracle PL/SQL.

Experience in administration of Business Objects XI Enterprise Suite (Desktop Intelligence, Central Management Server, Central Management Console, Auditor and Dashboard Manager).

Setup, execute, and test the assigned programs utilizing BO XIR3 WebI and DeskI tools.

Extensively used Business Objects Designer to design and maintain Data warehouse Universe.

Responsible for Universe Designing, Hierarchy Building for Data Analysis and applied conditions in Business Objects.

Creation of reports like Reports by Product, Reports by Customer, Reports by Period, Demographic reports and Comparative reports, Working with database connections, SQL joins, cardinalities, loops, aliases, views, aggregate conditions, parsing of objects and hierarchies.

Created complex reports using user-defined functions like @variables, @prompt, condition Objects and Aggregate Awareness Functions for SQL enhancement.

Developed standard canned, ad-hoc reports & crystal reports.

Developed more than 25 Full client and thin client (WebI) reports for all modules and update to version 6.

Use of BO Designer Module to implement Universes, linkages between tables, creating prompts and queries, parsing the Universes, applying contexts and alias tables to remove cyclic dependencies.

Designed, developed, tested and maintained highly complex reports.

Used query as a web services and live office for automation of Dashboards.

Scheduled and monitored reports using Broadcast Agent Console.

Deployed the development and QA domains to reduce the server loads and to increase the performance.

Environment: Business Objects XIR3/XIR2,Crystal Reports 2008, Data Integrator XIr2,Dashboard Manager, Xcelsius 2008, Web I 3.2, Deski, Windows 2000/NT, PL/SQL, T-SQL scripts, TOAD

Dept. Health and Senior Services

BO Developer

Chennai India November 2009 –January 2011

The State Board of Health serves as an advisory body for activities of the department. It consists of seven members appointed by the governor and confirmed by the Senate. The State Board of Health advises the director of the Department in planning for and operating the department; and acts in an advisory capacity regarding rules promulgated by the Department.

Responsibilities:

Requirements Gathering and Business analysis

Familiarized the business, its strategy and implementation.

Gathered Customer, User and Owner requirements analyzed and documented them.

Worked on Installation and Configuration of Business Objects XI.

Designed and customizing data models for Data warehouse supporting data from multiple sources on real time.

Migrated reports from BO 6.5 to BO XI2.

Setup hierarchies in the Universe for providing drill down options in the reporting environment.

Created Sets, Metrics, Rules, using Set Analyzer and Dashboard Manager.

Created and customized application dashboards using Application Foundation and used balanced score cards and speedometers.

Experience in cleansing data in DI using proper data types and mappings and to create Workflows using object library and tool palette to execute data flows.

Linked two universes sales and customer using kernel approach.

Created multiple universes and resolved Loops by creating table aliases and contexts.

Worked with database connections, SQL joins, cardinalities, loops, aliases, materialized views, views, aggregate conditions, parsing of objects, LOVs, and hierarchies.

The universes were frequently tested for validity and correctness of inferred SQL.

Created reports on development data to test the functionality of universes with a group of power users.

Scheduled reports to business users and owners using Broadcast Agent.

Extensively worked on OLAP cubes for building universes.

Performance tuned Business Objects Data Integrator XI jobs to ensure optimal performance.

Extensively used Data Integrator to cleanse and populate target database.

Developed Internal control reports to validate the ETL load and scheduled it.

Created reports using WEBI, DESKI, full client.

Created reports using the business object functionality like queries, Slice and Dice, Drill down, functions and formulae.

Knowledge of Crystal Reports reporting system including Crystal Server reports distribution infrastructure.

Fine-tune the existing universes to enhance their performance.

Created graphs/charts for the reports, Created Master Detail and Cross Tab Reports.

Enabled/Disabled different servers in Central Configuration Manager and Central Management Console.

Performed Server Management Tasks, using Central Configuration Manager (CCM) and Central Management Console (CMC).

CarolinaTechonology Solutions

Offshore – Onsite October 2008 –January 2009

System Administrator

Responsibilities:

Internal Domain Controller & network Support (Wired & Wireless)

Remote Maintenance of Server’s Located in USA for many clients globally based on Microsoft Server 2003

Network Monitoring VPN infrastructure.

Exchange Server 2007 & Active Directory Maintenance Active Directory Maintence.

Mezoblanca Solutions March 2007 – August 2008

Junior Network& System Administrator

Involving Network planning and Implementation.

Active Directory Infrastructure and Exchange server support

Backup/Recovery operations

Field work for network implementation & Tech Support

WLAN Implementation

Active Directory Maintenances.

Web Server support operation

Slash Support India,

Technical Support Engineer June 2006 – February 2007

Worked for Linksys and supporting Customers Globally on Networking Products like VPN devices, Wired/Wireless Routers, Access Point, Have provided support for the customers technically in Installing and configuring networking devices.

Education:

Bachelors in Engineering (Computer Science and Engineering)

Contact this candidate