SUMMARY

• Accomplished Sr. BO Developer/Lead/Tableau Developer with 14 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.
• 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.
• 4 years of experience in Tableau Modelling, Reporting, Visualization and Dashboards.
• Expertise in Business Objects Products (Universe Design and Information Design Tools, BI Launch Pad, InfoView, Desktop Intelligence, Web Intelligence, Rich Client and Lumira, 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 Xcelsius (Live Office, BIWS and QAAWS) and Tableau 8, 9, 10.
• 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

• 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
• 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 Tableau 8,9,10

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

Confidential, Jersey City, NJ

Sr. Business Objects Developer/Tableau Developer/Lead

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; Tableau Desktop 10; Tableau Server; HP Quality center 11.5; JIRA; DB2; Aqua Data Studio

Responsibilities:

• Involved in the complete Software life cycle of GDS (Trading Application) from Requirement, Development, Deployment and Testing.
• Provided estimation for GDS (Trading application) Project.
• Developed Dashboards like Broker Commission and Confidential FEES.
• Developed Data Model for Tableau Reports and Dash boards.
• Created calculated fields and parameters.
• Designed, Developed and Implemented Tableau Business Intelligence reports.
• Developed Visualizations as per the user needs.
• Implemented Filters for user analysis.
• Enhanced CLM Project as part of Customer Relationship Management System (Know Your Customer) user interface changes.
• Provided estimation for FATCA, 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.
• Worked in onsite-offshore Model.
• Troubleshoot Production Issues.
• Ensure deliverables are prepared to satisfy the project requirements, cost and schedule.
• Developed Universes using IDT.
• Designed and Developed FATCA and Client Statement Reconciliation Universe from Scratch.
• Interacted with FATCA users for Reporting Requirements.
• Designed, Developed and Implemented Complex WEBI reports.
• Created Scheduled reports as per user needs.

Confidential, Bridgeport, CT

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 4.1; Live Office; Data Services 4.1; Tableau Desktop 9; Tableau server; Universe and Information Design Tool; Version and Promotion Management (Life Cycle Manager); Upgrade Manager; Crystal Reports 2013; Lumira 1.25; 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; Windows 2008 Server

Responsibilities:

• Developed, Designed interactive Tableau Dashboard reports for AML and Loan departments.
• Project to convert from BO Reports to Tableau.
• Developed data model to create reports and dashboards.
• Worked on Individual Axis, Blended Axis and Dual Axis concept while working with reports.
• Worked with Live and Extract connection.
• Performed Demo on the usage of Tableau Tool Visualizations and Dashboards to Business users.
• 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.
• Developed Universes using UDT & IDT.
• Designed and Developed Anti Money Laundering, Loan Quest Operational OLTP and Loan Quest Data Ware House Universes from Scratch.
• 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.
• 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.

Confidential, Parsippany, NJ

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/Dashboard 4.0; BIWS; Tableau Desktop 8; Tableau server; ERP Movex version 12; AS/400; Windows server 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

Responsibilities:

• Developed Supply Chain and Finance Dashboards for Supply Chain and Finance Departments.
• Experience with the design and development of Tableau visualization solutions.
• Created List, Cross Tab Reports with Quick Filters, Summarized Filters.
• Created Bar Charts, Columns Charts, water fall charts, Heat Maps, And Geographical Maps.
• Formatting the Data by using Legends, Marks, Colors, Sizes, and Shapes.
• Frequent interaction with Functional Analysts and Business to review requirements and results.
• 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.
• 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.
• 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.
• 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, 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.

Confidential, Livingston, NJ

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

Responsibilities:

• 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.
• 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.
• 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.
• Customized EMARS Application to meet the needs of end users using BO JAVA SDK.

Confidential, Boston, MA

Sr. BO Developer/Administrator/Team Lead/Architect

Environment: Business Objects XI 3.1/R2; Data Integrator 11.7.2; Oracle 10g; DB2 ; Teradata; Infoburst 2.6; Xcelsius 2008; Live Office; Web Intelligence and Rich Client; Auditor; Report Conversion Tool; IBM MAINFRAMES OS/390; UNIX and Shell Scripting; PL/SQL; Cognos 7; Clarity; Windows 2003 server

Responsibilities:

• Installed and Configured BO 3.1, patches and upgrades.
• Designing the security using CMC.
• Managing the Business Objects servers using CMC and CCM.
• Setup the security at the Folder Level in the CMC.
• Row level security is implemented with different user groups.
• Administer and maintain Business Objects XI 3.1 on Development, Testing and Production regions.
• Implemented the CMS clustering for load balancing.
• Performed the migration from Business objects XIR2 to XI 3.1 using Import Wizard.
• Migrated Users, Categories, Reports Folders, Universes, Security Model from XIR2 to XI3.1.
• Migration of Universes from one Domain to another like DEV-STG-PROD.
• Gathering and analyzing the requirements.
• Involved in understanding the end user requirements and business processes in creating and designing Universes, Queries and Reports.
• Maintained the universe by creating the Joins, aliases and contexts.
• Optimizing the Universe to improve the performance.
• Extensive universe testing and conducted UAT in multiple sessions with the end users.
• Created reports which involve complex Financial calculations, linking data from multiple data providers.
• Used Business Objects functionalities like Breaks, Sorts, Alerters, Filters, Data Tracking, Quick Display, Optional Prompts and Conditions.
• Tuning the SQL to improve the performance of the reports.
• Validated the Data in the Reports with the Databases.
• Enhanced the Existing reports using Sub queries.
• Worked on VBA Macros to email the Reports in PDF Format to relevant Sales Agents.
• Installed the Infoburst on the server to create the reports and email them to the relevant Users in PDF format for the Sales Agents.
• Provided Training to Business Users about the Business Objects Reports.
• Documenting the production and development environment changes made on the WEB servers.
• Designed the Xcelsius Sales Dashboard.
• Created New Reports in Cognos, Converted all Cognos reports to WEBI as part of Conversion Project.
• Involved in the entire Software Development Life Cycle of the Project on multiple Enhancements.
• Installed and Configured Business Objects/Data Integrator on Development, Testing and Production Regions.
• Implemented Business Objects Best Practices.
• Provide guidance to Business Customers on Sources.
• Provided sizing/scalability recommendations for current and proposed deployments to ensure compliance with overall Business intelligence Strategy.
• Provide technical oversight and subject matter expertise to BI team on key initiatives.
• Managed customer expectations to ensure strong customer satisfaction by meeting the Business needs for IT systems in timely manner.
• Leading the team of 3 by motivating the team to complete the tasks on time with appreciations.
• Developed Source to Target ETL BODI extract Jobs.
• Created and Enhanced several BODI extract Jobs.
• Used different Data Integrator transforms like Query, SQL, Key Generation, Table Comparison and other transforms available.
• Scheduled and Configured the Jobs so that concerned groups will be notified through email when a Job fails.

Confidential, Cranbury, NJ

Sr. Business Objects Developer

Environment: Business Objects XI R2; Data Integrator XI R2; Oracle 10i; Web Intelligence; OLTP; Windows 2003

Responsibilities:

• Analyzed the existing OLTP system, which is a Claims Management application with back-end Oracle.
• Involved in project planning sessions with Project Managers and Business Analysts to analyze business requirements and outline the proposed solution.
• Design, Develop and Test complex Universes with Features like Aggregate Awareness, Contexts, Joins and Derived tables.
• Resolved loops by creating Aliases and Context.
• Optimizing the Universe to improve the performance.
• Created Web Intelligence and Business Objects full client reports.
• Experience in creating various types of Reports like Cross tab Reports, Drill through Reports.
• Created User Prompts, Conditions and Filters to improve the report generation.
• Tuning the SQL to improve the performance of the reports.
• Linked the Universes to share the common components between the Universes.
• Created Objects with Hints at the Universe to improve the performance of the Reports.
• Provided Training to Business Users about the Business Objects Reports.
• Conducting periodic training for business users on reporting techniques.
• Extensive universe testing and conducted UAT in multiple sessions with the end users.

Confidential, Naperville, IL

Sr. Business Objects/BI/BW Developer

Environment: Business Objects XI R2; Dashboard Manager; SAP BI 7.0; SAP BW; ECC 6.0; Data Warehouse; Windows 2003 Enterprise

Responsibilities:

• Created and Loaded Master and Transaction Data from SAP R/3 as well as Flat File Source Systems into BW.
• Worked extensively in SAP BEx Query Designer, BEx Analyzer, Report Designer, Web Application Designer.
• Experience in Designing the BW Reports from Infocubes using different characteristics and keyfigures.
• Designed Universes using SAP BI Queries and Infocubes as Data Sources.
• Extensively worked with PSA in monitoring the Data Transfer from Source Systems into BW and debugged when required.
• Worked on Data Mapping Fields between R/3 and BW for Info Cubes.
• Analysis of the requirements and lots of interaction with the end users to get to the report templates approved.
• Designed a universe to support all identified enterprise reporting data and possible ad-hoc reporting with all subject areas of the warehouse.
• Created reports in XIR2 Web Intelligence with the lot of hyperlinks to provide guided analysis.
• Created reports which involve complex calculations, linking data from multiple data providers, using free hand SQL, stored procedures.
• Created User Prompts, Conditions and Filters to improve the report generation.
• Created Refresh on open and Scheduled Reports.
• Designed the Supply chain Corporate Dashboards.
• Provided Training to Business Users about the Business Objects Reports.
• Responsible for conducting UAT sessions with the end users.

Confidential, Chicago, IL

Sr. Business Objects Developer

Environment: Business Objects XI; Web Intelligence; Oracle 9i; Dashboard Manager ;Crystal Reports XI; Windows 2003 server

Responsibilities:

• BO universe and report developer.
• Gather and analyze the requirements.
• Installing and Configuring of BO Suite of products in Development, Production and QA environments.
• Design and develop universes.
• Performance optimization through implementing aggregate awareness.
• Created multiple complex objects in the universe to facilitate easy reporting.
• Created Web Intelligence and Business Objects full client reports.
• Designing Corporate Dashboards with automated rules and Dimensional Analytics.
• UAT with large group of users across the country.
• Extensive universe documentation and system documentation.
• Extensively involved in using of Formula fields, Parameter fields, Group and Record selection in Crystal Reports.
• Created queries using Add command objects in Crystal Reports XI.

Confidential

Business Objects Developer/Team Lead

Environment: Business Objects XI R2 / 6.5.x; SQL Server 2000/2005; Crystal Reports XI; Data Stage; Dashboard Manager; Infoview; Windows 2003 Enterprise; JSP; Eclipse; JDBC; ISPF; JCL; VSAM; COBOL; DB2; CICS; SPUFI; IBM MAINFRAMES OS/390

Responsibilities:

• Conducted user interviews and reviewed existing reporting / analytical solutions to understand the client’s specific reporting needs.
• Configuration and maintenance of server components.
• Designed a universe to support all identified enterprise reporting data and possible ad-hoc reporting with all subject areas of the warehouse.
• Implemented aggregate awareness to utilize the summary/aggregate tables.
• Designed custom hierarchies according to dimensional hierarchies while considering the client’s reporting needs.
• Extensive use of contexts and aliases to resolve the loops as well as to add functionality to design a functionally foolproof ad-hoc and enterprise reporting universe.
• Extensive universe testing and conducted UAT in multiple sessions
• Designing Crystal Reports using different data providers like Universes, Business views and from other Data sources.
• Involved in scheduling the Monthly and Weekly reports.
• Extensive usage of drill down option.
• Prepared user documentation for hands on training of end user community.
• Conducted training sessions for state level user groups with emphasis on the Web Intelligence tool.
• Assisted the administrators in the process of migration from 6.5.2 environment to the XIR2 environment.
• Converted all Full Client documents to Web Intelligence documents as part of the migration process.
• Report conversion is followed by extensive testing to make sure the formulas and formatting are intact.
• Extensively worked on Batch and OLTP IBM MAINFRAME SYSTEM like Job Control Language, VSAM Files, DB2, COBOL and CICS.
• Leading the team of 4 by motivating the team to complete the tasks on time with appreciations.
• Extensively worked on Batch and OLTP IBM MAINFRAME SYSTEM like Job Control Language, VSAM Files, DB2, COBOL and CICS.
• Hands on experience in Cobol Programming.

Confidential

Business Objects Developer/Administrator

Environment: Business Objects 5.1.6; Broadcast Agent; Web Intelligence; Oracle; DB2; Windows NT

Responsibilities:

• Analysis of Business Objects environment, Universes, Reports.
• Designing the security using supervisor.
• Setup and maintain the repository architecture necessary for centralized administration.
• Implemented the Group centric and Row level security.
• Developed Universe using Designer module in Business Objects.
• Created Condition in Universe.
• Ad-hoc reports were used for Business Objects user modules for various portfolios using the Universes as the main Data providers.
• Resolved loops by creating Aliases and Context.
• Organized data in reports by using filters, sorting, ranking and highlighted data with alerts.