SUMMARY

• Having 10 years of experience in Full life cycle gathering requirements, documentation, developing, designing, implementing and deploying Business Intelligence Solutions.
• Expert in maintenance of various applications in Data Warehousing Business Objects(SAPBO) 4.x/XI3.1/3.0/R2/6.5, Tableau 10.x/9.x/8.x Crystal Reports, Microsoft SSRS, WebFOCUS.
• Having Industrial Experience in implementation of BI Solutions for various verticals such as Finance, Sales, Insurance domains.
• Experience with Installing and Administration of entire hardware, and software products like Tomcat, and Apache (Clustered and Standalone environments) on windows.
• Implemented load balancing techniques by increasing no of Adaptive Processing Server /Job servers, & Installing Service packs / Fix Packs to fix issues and make use of additional Features.
• Extensively used Transport tools Promotion Management, Upgrade Management Tool, LCM, Import Wizard, for Business Objects.
• Expertise in working with all the modules of Business Objects (All Versions) like Supervisor, Designer, BO User, Web Intelligence, Desktop Intelligence, CMC, CMS, Instance Manager, Crystal Reports 2008, 2011.
• Worked in Migration Projects (from BO 5.1/6.5 to XIR2, BO 6.5 to XIR3.1, XI3.1 to SAP BI4.x)
• Proficient in Universe Designing using Universe Design Tool (UDT), Information Design Tool (IDT).
• Created the Relational and OLAP connections, Projects, using Information Design Tool.
• Hands on experience in designing and building Universes using Information Design Tool/Designer by Objects data model selecting/joining tables, indicating cardinalities, creating aliases/contexts to resolve the Loops, Traps and creating the classes/objects.
• Working noledge in designing the Universe on top of BW Query and developed the Web Intelligence Reports.
• Mastered in designing Simple, Complex Ad hoc Reports and fine - tuning the reports using Calculations, User Report Level Variables and Multiple Data providers.
• Involved in creating Merged Dimensions, Combined Queries, Report Level Details, Charts, Crosstabs, Sections, Ranking, multilevel Breaks, Sorting, Drill, Slice and Dice and Alerts for creating Web Intelligence (WEBI) reports.
• Take ownership of the maintenance and development of key product components within an Oracle database design, rich in PL/SQL stored procedures, packages, and complex analytical and financial reports.
• Effectively made use ofTable Functions, Indexes, Table Partitioning, Collections, Analytical functions, Materialized Views, Query Re-WriteandTransportable table spaces.
• CreatedTables, Views, Constraints, Index.
• Developed Complex database objects likeStored Procedures, Functions, Packages and Triggers using SQL and PL/SQL.
• CreatedPackagesandProceduresto automatically drop table indexes and create indexes for the tables.
• Extensively using joins and sub-queries for complex queries which were involving multiple tables from different databases. Analyzing data and re-mapping fields based on business requirements.
• Store procedures, User defined functions, Views scripting for complex business logic.
• Extensively worked on SSRS and delivered complex reports from different data sources such as SQL Database and Cubes.
• Tuning of the SQL queries, which takes long time to process the request using Explain Plan reduce the response time.
• Tableau Administration - Performance Testing using tabljolt and AvailabilityMaintaining Security and Create/manage Users, Groups, Licenses and integrate with Active directory.
• Setup Sites and Access policiesKnowledge of Tableau repository, TABCMD and TABADMIN commands
• Expert in Installations/configuration in windows environment.
• Monitor server activity/usage statistics to identify possible performance issues/enhancements.
• Experience in User/License Management.
• Ability to effectively assist with user support / reporting community questions and inquiries
• Experience in generatingSub Reports, Standard, Mailing Labels, Cross Tab Reports & Graph Reportsby usingChart expertof Crystal Reports.
• Knowledge in creatingComplex Crystal Reports(Ad Hoc Reports, Frequency Reports, Summary Reports, Drill-down, Dynamic grouping, graphical, aging reports).
• Involved in SQL Tuning at Universe/ Report Level & Database Level to increase the Report Performance
• Experience with Data Integrator for ETL (Extraction, Transformation, and Loading) of data from multiple sources database systems to Data Warehouses.
• Conducted thorough review and coordinated with the designated team to identify issues and areas for improvement.
• Compile project status reports, develop project plans, define process flows, coordinate project schedules, manage.
• Manage project budgets, ensured project tracking and reporting, monitored performance, resolve critical issues, mitigate risks, communicated project status, and facilitated the use of best practices
• Coordinate with other project managers regarding resource management among various projects.
• Responsible for developing and managing the project plan and holding weekly status meetings with the program director and team.

TECHNICAL SKILLS

Data Warehousing / OLAP / Business Intelligence Tools: Business Objects 5.1/6/6.1A/6.1B/6.51/XI R2/XI 3.0/ XI 3.1/4.x - CMC, CCM, Auditor, Designer, Supervisor, Desktop Intelligence, Info View, Web Intelligence, Import Wizard, Report Conversion Tool, Publishing wizard, Broadcast Agent Server, Query Builder, Xcelsius Dashboard, Microsoft SSRS

ETL Tools: SAP BO Data Services (3.X/4.1), BO Data Integrator XI7.x, Informatica

Administration: Business Objects, Tableau, WebFOCUS

Operating Systems: MAC OS X/Windows 95/98/NT/2000/XP/Unix AIX and DOS

RDBMS: Oracle 12/11/10.x/9.x/8.x/7.x/5.x, Teradata, SQL TOAD, MS Access 2000/2007/2010

Programming: SQL, PL/SQL, HTML, .Net

WEB/GUI: Apache Tomcat, Web Sphere 5.1/6, IIS 4/5, Web Logic, site minder, Visual Basic

Others: Microsoft Excel, TOAD 9.1.0, SQL Navigator

PROFESSIONAL EXPERIENCE

Confidential, Connecticut

BO - Developer

Responsibilities:

• Understanding the data model and developing the universes using IDT and UDT and creating data sources using Tableau.
• Creating complex Reports, Cross Tab and Master Detail reports by using BO Functionalities like Slice and Dice, Drill Down, Variables, Filters, Breaks, Alerters and other features.
• Expertise in Resolving the Daily issues in the Daily Production Environment.
• All the Scheduled report jobs were built and maintained through Info view. Output destinations include email and user BO Inbox in various formats such as PDF & Excel. Prior to the installation of BOXI.
• Develop Tableau reports that provide clear visualizations of various industry-specific KPIs.
• Access and transform massive datasets through filtering, grouping, aggregation, and statistical calculation.
• Consult with clients and internal stakeholders to gather requirements and plan milestones in the research, development, and implementation phases of the project lifecycle.
• Strong understanding of advanced Tableau features including calculated fields, parameters, table calculations, row-level security, R integration, joins, data blending, and dashboard actions.
• Extensively using joins and sub-queries for complex queries which were involving multiple tables from different databases. Analyzing data and re-mapping fields based on business requirements.
• Used prompts, alerts, drill down analysis as per the end user requirements.
• Testing the Universe and Reports based on business criteria.

Environment: SAP BO 4.x, SQL Server, Oracle, Windows

Confidential, Illinois

BO/Tableau - Developer/Administrator

Responsibilities:

• Understanding the data model and developing the universes using IDT and UDT and creating data sources using Tableau.
• Resolving the loops by using universe functions like context and alias.
• Creating Predefined conditions, prompts, Custom Hierarchies and using @functions like @ prompt, @select, @variable, @aggregate awareness.
• Creating complex Reports, Cross Tab and Master Detail reports by using BO Functionalities like Slice and Dice, Drill Down, Variables, Filters, Breaks, Alerters and other features.
• Participated in project planning sessions with project managers, business analysts and team members to analyze business requirements and outlines proposed solutions.
• Expertise in Resolving the Daily issues in the Daily Production Environment.
• Ensured all the environments are in synchronization and checked supported environments and hardware requirements from the Products Availability Report (PAR) document for the new installation.
• Validated the installation by checking the public folders, Reports in Personal folders, Groups, Row level security, Scheduling and by running some sample reports.
• All the Scheduled report jobs were built and maintained through Info view. Output destinations include email and user BO Inbox in various formats such as PDF & Excel. Prior to the installation of BOXI.
• Develop Tableau reports that provide clear visualizations of various industry-specific KPIs.
• Access and transform massive datasets through filtering, grouping, aggregation, and statistical calculation.
• Consult with clients and internal stakeholders to gather requirements and plan milestones in the research, development, and implementation phases of the project lifecycle.
• Strong understanding of advanced Tableau features including calculated fields, parameters, table calculations, row-level security, R integration, joins, data blending, and dashboard actions.
• Using Table Functions, Indexes, Table Partitioning, Collections, Analytical functions, Materialized Views, Query Re-WriteandTransportable table spaces.
• Extensively using joins and sub-queries for complex queries which were involving multiple tables from different databases. Analyzing data and re-mapping fields based on business requirements.
• Store procedures, User defined functions, Views, T-sql scripting for complex business logic. Optimized the database by creating various clustered, non-clustered indexes and index views. Using aggregate strategies to aggregate data, sorting and joining tables.

Environment: SAP BO 4.x, Oracle, PL/SQL, DB2, SQL Server, Windows

Confidential, Illinois

BO Administrator

Responsibilities:

• Participated in project planning sessions with project managers, business analysts and team members to analyze business requirements and outlines proposed solutions.
• Expertise in Resolving the Daily issues in the Daily Production Environment.
• Involved in full life cycle of Business Objects XIR2/R3/4.0.
• BO Upgrade from XIR2 to XIR3 to XI4, and also responsible for applying service pack and fix pack to BO installation.
• Ensured all the environments are in synchronization and checked supported environments and hardware requirements from the Products Availability Report (PAR) document for the new installation.
• Uninstalled BOXI from the server to install and Removed Registry Entries with keywords such as Business Objects, business objects, busobj, bobj, Crystal Decisions, Designer, Desktop Intelligence, Web Intelligence etc before the installation.
• Installed Microsoft .net framework prior to the installation of BOXI for successful installation of all the BO components.
• Apart from promoting info objects, used Life Cycle Manager to create, copy, Edit and scheduled a job.
• Maintained & managed different versions of the same document using Life Cycle Manager.
• Verified the remaining Business Objects installation works without any issues.
• Validated the installation by checking the public folders, Reports in Personal folders, Groups, Row level security, Scheduling and by running some sample reports.
• Created repository and security domain with user groups and security implementation.
• Extensively worked with security issues and user maintenance in XIR2/XIR3.1/XI4.
• All the Scheduled report jobs were built and maintained through Info view. Output destinations include email and user BO Inbox in various formats such as PDF & Excel. Prior to the installation of BOXI

Environment: SAP BO 4.x, Windows, DB2, SQL Server

Confidential

Sr. BO Developer

Responsibilities:

• Develop SAP BW based BO reports (modification and new reports) to satisfy reporting requirements
• Enhancements to existing open hubs to expose the new fields extracted from SAP CRM to Teradata as per the LSAP
• Modifying BEx queries to pull out Landlords information into semantic layer.
• Creating Bex connection to connect to the bex queries.
• Modifying reports with addition of new info objects without impacting existing business logic.
• Resolve complex issues arising in projects execution.
• Involved in various discussions with Client to get requirements for Universe in Analysis Phase of Universe.
• Preparation of Technical design document for reports based on the functional specifications.
• Prepared Templates, Rationalized data by analyzing the requirements, prepared documentation.
• Perform realistic assessments of development time.
• Analyzed the reports, corrected them and published it on Enterprise.
• Develop business object in accordance to clients' needs and requirements.

Environment: SAP BO 4.x, SAP BW, SAP CRM, Oracle PL/SQL

Confidential

Tableau Developer

Responsibilities:

• Preparation of Technical design document for reports based on the functional specifications.
• Prepared Templates, Rationalized data by analyzing the requirements, prepared documentation.
• Perform realistic assessments of development time.
• Analyzed the reports, corrected them and published it on Enterprise.
• Generated Tableau Dashboard with quick/context/global filters, parameters and calculated fields on Tableau (7.x) reports.
• Created Tableau Dashboards with interactive views, trends and drill downs along with user level security.
• Develop Tableau reports that provide clear visualizations of various industry-specific KPIs.
• Access and transform massive datasets through filtering, grouping, aggregation, and statistical calculation.
• Consult with clients and internal stakeholders to gather requirements and plan milestones in the research, development, and implementation phases of the project lifecycle.
• Strong understanding of advanced Tableau features including calculated fields, parameters, table calculations, row-level security, R integration, joins, data blending, and dashboard actions.

Environment: Tableau, Teradata, Netizza

Confidential

Sr. BO Developer

Responsibilities:

• Changing BO Symantec layer by modifying Table and Column names and using with Teradata functions.
• Preparing validating Universe SQLs and Functions comparing with Netizza Functionality.
• Rewriting Derived tables queries along with Teradata functions.
• Optimizing Teradata Quires by collecting stats and rewriting the SQLs and logics.
• Involved in various discussions with Client to get requirements for Universe in Analysis Phase of Universe.
• Preparation of Technical design document for reports based on the functional specifications.
• Prepared Templates, Rationalized data by analyzing the requirements, prepared documentation.

Environment: SAP BO 4.x & BO 3.1, Teradata, Netizza

Confidential

BO Developer/Administrator

Responsibilities:

• Worked with CMC for Scheduling reports and for Creating folders, Users and Groups
• Scheduling the reporting by the frequency set by the Business and publishing and sending to the user inbox in different format.
• Exported the Universe to the Repository to make resources available to the users.
• Testing the Universe and Reports based on business criteria.
• Extensively worked with Business Users on regression testing the Monthly/Quarterly Reports and convey the errors/issues to Developers and get them fixed on tight deadlines.
• Responsible to talk to business users and finalize on any enhancements/new requirements needed by reporting department.
• Working with business users on getting specification for reports, build proto types, developed and implemented the reports on Crystal Reports Server.
• Analyzed the reports, corrected them and published it on Enterprise.

Environment: SAP BO XIR2 & BO 3.1, Oracle, DB2 and SQL Server

Confidential

BO Administrator/Developer

Responsibilities:

• Installed Business Objects XIR2 server products in clustered environments on Windows 2008 servers: full installs /custom installs, and installed client tools on desktops on all Environments
• Installed and configured all the three environments (DEV/QA/PROD) with Business Objects XIR2 on windows.
• Implementing New Security system in BOXIR2 by creating new groups and users with folder level security.
• Configured and Customized the BO Services/Server Sizing in CMC with various settings as a part of Performance Tuning and applied Service Packs and Fix Packs as and when needed in Windows
• Migrating Universe and Reports from the Business Objects 6.5 Business objects XIR2.
• Handling issues while migrating the universe and reports to the BOXIR2.
• Handling production support issues like report not fetching data, Date format, No of days calculation.
• Creating new views in universe database as per the business requirement for the trends calculations and creating corresponding objects in universe.
• Working on Production support activities like daily refreshing reports locally and refresh in BCA to reflect the data in Portal.
• Worked with CMC for Scheduling reports and for Creating folders, Users and Groups
• Creating user views in database as per the report requirement.

Environment: SAP BO XIR2 & BO 6.5, SQL Server 2003, 2008

Confidential

TD/ Crystal Reports Developer

Responsibilities:

• Defines database usage concepts, selects records, organizes data and formats reports; exports (distributes) reports; builds, applies and removes report templates.
• Creates complex reports requiring multiple parameters, summarizing data with crosstabs, using sections and section underlay for groups, and related report functions; builds specialized reports utilizing.
• Developed reports using Crystal Reports.
• Generated reports with parameters, sub reports, cross tabs, charts using Crystal Reports8.5
• Used prompts, alerts, drill down analysis as per the end user requirements.
• Monitoring scheduled Jos of countries (TW,HK,SG,ID & CN) by using Instance Manager.
• Extracting and downloading files from Repository and FTP Voyager for missing files respectively.
• Handling change request as per the requirement.

Environment: Crystal Reports 8.5, Teradata, FTP Voyager

Confidential

BO Developer

Responsibilities:

• Working on Production support activities like daily refreshing reports locally and refresh in BCA to reflect the data in Portal.
• Worked with CMC for Scheduling reports and for Creating folders, Users and Groups
• Maintenance and support of the BO Universe
• Functional support, assist users with functional questions with regards the application.
• Scheduling the reporting by the frequency set by the Business and publishing and sending to the users inbox in different format.
• Handle first line support on all technical issues reported by the users via the Aces Help desk. Liaise with the technical team if needed.
• Creating user views in database as per the report requirement.

Environment: Business Objects 6.5, SQL Server