SUMMARY

• Over ten years of experience in System Analysis, Design and Development of customized Business Intelligence applications and reporting solutions.
• Experienced and Proficient in all Phases of SDLC (Software Development Life Cycle).
• Expert in design, development and testing Business Objects.
• Proficient in business requirements gathering, gap analysis, documentation and testing of various reports and BI applications.
• Expert in Business Objects Web Intelligence Reporter, Desktop Intelligence, Designer, IDT, UMT and Infoview/Launchpad.
• Experience in BI dashboard tools like Tableau, Qlikview and SAP Lumira.
• Strong Knowledge in BI reporting tools like Cognos and Brio Intelligence.
• Developed Stacked and Side by Side Bar Chart, Line Graphs, Pie Charts etc using Crystal Reports Chart Expert.
• Experienced in Data Modeling using Erwin and Designer 2000.
• Expert level working knowledge in tools like TOAD, PL/SQL developer.
• Experience in Handling and the creation of Data Flows and Workflows the core components in extracting and transforming Data in Business Objects Data Integrator.
• Well versed in resolving Loops and Traps using Alias and Context, designing complex objects using @prompt, perform tuning & performance analysis using @aggregate aware and related built - in functions
• Experienced in customizing new and existing Reports according to client specifications to suit improvised business processes.
• Possess Strong Analytical and Comprehensive problem-solving abilities, coupled with self-motivation and result oriented collaborative thinking.
• Able to plan, monitor, support and deliver on time while within the budget in high pressure environments.
• Excellent verbal communication and inter-personal skills at the technical and user level.

TECHNICAL SKILLS

Languages: Visual Basic, SQL, PL/SQL, C, C++, Java, UML, R, Python

Database: Oracle 10g/9i/8i/7.x, MS SQL Server, DB2, MS Access

Operating Systems: UNIX (Sun Solaris, AIX), LINUX, Windows (98/NT/XP)

Reporting Tools: SAP Business Objects Xi R2/ R 3/4.0/4.1/4.2 , Crystal Reports xi, Universe Designer, Desktop Intelligence, Web Intelligence, Infoview, CMC, IDT, Crystal Xcelsius 2008, Brio Intelligence, SAP Lumira, Qlikview, Tableau

Web Technologies: ASP, VB, XML, PHP, HTML, DHTML, JavaScript, VBScript, Adobe Flex

Web Servers: IIS 4.0/5.1/6.0, Apache v2, Tomcat v 4.1

Case Tools: Microsoft Visio, Rational Rose, CaliberRM, Erwin, Designer 2000

PROFESSIONAL EXPERIENCE

Confidential, Bristol, CT

Senior Business Objects Developer

Environment: SAP Business Objects XI 4.2 SP7, Universe Design Tool, Web Intelligence, Infoview/BI LaunchPad, Oracle DB 12c, PL/SQL Developer 11.0.4, Windows 2017, Solutions Business Manager(SBM), Jira 8.20.3, Slack.

Responsibilities:

• Responsible for requirements gathering, development, unit testing, and PROD support of universes and reports for Ad Sales & Liability management team.
• Responsible for updating BO WebI reports and universe using data warehouse tables/views.
• Responsible for CMC promotion jobs and package creation for deployment across DEV, QA, UAT and PROD.
• Designed and updated reports and universe to capture complex formulae using context operators.
• Used formatting options such as Cross Tab representation, Sections, Breaks, Conditional Formatting, etc.
• Identify opportunities to consolidate or retire reports that are no longer of value to the organization.
• Participated in Sprint Planning meetings to identify work from the backlog that will fit into the current sprint, attend daily stand-up meetings to communicate completed efforts, items in progress and blockers to the team.
• Assist with effort estimation and on-time delivery for each Sprint.

Confidential, Leetsdale, PA

Senior Business Objects Developer/Admin

Environment: Business Objects XI 4.1 SP4, Business Objects XI 4.2 SP7, IDT, Web Intelligence, Infoview/BI LaunchPad, Axis/Verticent ERP, Microsoft SQL Server 2017, Windows 2017, Infolytik Metaminer 5.2, Solarwinds WebHelpdesk.

Responsibilities:

• Responsible for requirements gathering, development, deployment, PROD support and administration of BOBJ servers, universes and reports for Axis ERP project for Tirus and NF&M.
• Involved in design, implementation of SAP BI BO 4.1 Suite and upgrade to 4.2.
• Implemented Infolytik Metaminer and used the tool for Axis implementation and BO upgrade.
• Responsible for BI security set up and maintenance of users and folder/user level security within Business Objects in CMC.
• Responsible for any universe and/or report promotions across DEV, QA and PRODenvironments.
• Lead the on-site and offshore BI resources/consultants and met all project delivery timelines successfully.
• Responsible for mapping data structures for BI from Verticent ERP to Axis ERP.
• Efficiently down-sized and organized the data structures into 7 universes instead of 20 universes and reports from about .
• Designed and developed universes in IDT for all business modules of Axis ERP system.
• Performance tuned reports and made recommendations to update databasestructures to improve query performance.
• Designed complex reports like Line of Balance merging data from Finance, Procurement, Sales and Inventory modules in a single report for material planning/ management and on-time deliveries.
• Developed Finance reports like Trial Balance, AP, AR using Axis Finance modules.
• Worked extensively with AXISDW and Axis transactional data for BOBJ reports development.
• Built Reports in WEBI based on custom, union queries and merged objects based on different data sources at the report level.
• Used custom sorts, cross tabs, query filters, sections and Breaks in WebIntelligence reports.
• Created variables, formulae and detail objects at report level and Universe.
• Assimilated most of the modules of Axis ERP, performed transactions and validated for data integrity in BI reports.
• Provided training to business users in WebIntelligence.
• Provided BI support for all users in west coast and east coast operations.

Confidential, Coraopolis, PA

Tableau Developer

Environment: Tableau Desktop 10.0, Microsoft SQL Developer.

Responsibilities:

• Developed tableau worksheets, dashboard and stories using SQL data connections.
• Used filters, parameters and calculated fields to track and improve customer KPIs.
• Performed unit testing and data validation using SQL.

Confidential, Moon Township, PA

Senior Business Objects Developer/ Admin

Environment: Business Objects XI 3.1/4.1 SP6 Designer, IDT, UMT, Web Intelligence, Infoview/BI LaunchPad, Report Conversion Tool, Crystal 2013, Oracle 10g, SQL Developer.

Responsibilities:

• Involved in planning and implementing the BO migration from XI 3.1 to 4.1.
• Involved in server setups for BO 4.1 DEV and QA environments.
• Responsible for setting up the new users/group structures in 4.1.
• Reports were divided into 3 waves and moved from 3.1 to 4.1 and tested across DEV, QA and PROD using Upgrade Management Tool (UMT).
• Tested reports that were moved to Crystal 2013 for functionality.
• Responsible for setting up schedules and publishing reports based on triggers.
• Worked with the users in testing reports that were migrated to 4.1.
• Tested universes for functionality after migration.

Confidential, Stamford, CT

Business Objects Developer/Analyst

Environment: Business Objects XI 4.1 SP3, IDT, Web Intelligence, Infoview/BI LaunchPad, SAP Lumira, Live Office, Oracle 10g, SQL Developer, Information Steward, Windows 7.

Responsibilities:

• Involved in requirements gathering, development of reports for TAOS project.
• Responsible for BO Support.
• Involved in requirements gathering, development and testing of TAOS Domestic data and BOreports.
• Co-ordinated with on-shore and offshore resources and conducted user meetings.
• Responsible for updating universe objects and maintaining the Summary and Detail Universe forTAOS project.
• Fine-tuned the performance of reports and made recommendations to update databasestructures to improve query performance.
• Created dashboards using Lumira.
• Used custom sorts, Slice and Dice, cross tabs, query filters, sections and Breaks in WebIntelligence reports.
• Created variables, formulae and detail objects at report level and Universe.
• Responsible for Business Objects Support to all applications using BO and one of the Administratorsof Business Objects.
• Responsible for any universe and/or report promotions across DEV, QA and PRODenvironments.
• Provided one-on-one training to business users in WebIntelligence.

Confidential, Pittsburgh, PA

Business Objects Developer/Analyst

Environment: Business Objects XI R3/4.1 Designer, IDT, UMT, Web Intelligence, Infoview/BI LaunchPad, Report Conversion Tool, Oracle 10g, SQL Developer, Information Steward, Tableau 9.0, Qlikview, Xcelsius 2008, Windows Vista/Windows 7.

Responsibilities:

• Involved in reporting of various projects within FHLB into the CDR (Central Data Repository).
• Involved in requirements gathering, development and deployment of reports of MPF (Mortgage Partnership Finance), AHP (Affordable Housing Program), Derivatives Clearing, Capital Plan in FHLB.
• Responsible for conversion of all IT developed reports from R3 to 4.1 and re-pointing to .unx universes.
• Responsible for conversion of DeskI reports to WEBI using Report Conversion tool.
• Responsible for impact analysis during conversion and table structure changes in other projects using Infolytik Metaminer tool.
• Responsible for design, development and testing of reports for supporting ad-hoc queries and canned reports using Business Objects XI R3 and BO 4.1.
• Responsible for updating universe objects and structure using both ODS (transactional) and data warehouse data.
• Created derived tables in universe and used contexts.
• Defined and created classes, objects, conditions, prompt objects to capture complex formulae.
• Tuned the universe and reports for optimum query performance.
• Built Reports in WEBI based on custom queries, used multiple queries in documents and merged objects based on different data sources at the report level.
• Developed reports which include the features like parameter fields, formulas, conditional formatting, multiple grouping, running totals.
• Participated in SAP BO Explorer, Qlikview and Tableau testing to be used as new dashboard tool for the client.
• Prepared user stories using Tableau and helped the business user super group understand, test and evaluate the tool for their business needs.
• Created worksheets with different styles like bar, pie, tree maps, dual axis, and filled maps.
• Responsible for conversion of DeskI report to WebI before migration to BO 4.1.
• Responsible for production support for BI reporting.
• Provided one on one training to business users in BO 4.1 adhoc report development.

Confidential, New York, NY

Business Objects Developer/Analyst

Environment: Business Objects XI R3 Designer, Web Intelligence, Infoview, Desktop Intelligence, Cognos 8.4 (Framework Manager, Query studio, and Report studio), Oracle 10g, Infoburst, Xcelcius 2008, Version Manager, Ultraedit, Infolytik Metaminer, Windows XP.

Responsibilities:

• Involved in requirements gathering, development and deployment of reports of three core areas of Confidential including Scheduling, Rights Management, Products, and Contracts.
• Responsible for updating universe objects and structure using both transactional and data warehouse data.
• Involved in reporting for the latest applications Confidential GO and MAX GO.
• Created Free-Hand SQL reports in DeskI using Oracle SQL queries.
• Involved in the design and creatin of database view and structures with the DB and ETL teams.
• Extensively used linked universes and contexts in universes.
• Responsible for design, development and testing of reports for supporting ad-hoc queries and canned reports using Business Objects XI R3.
• Defined and created classes, objects, conditions, prompt objects to capture complex formulae.
• Tuned the universe and reports for optimum query performance.
• Built Reports in WEBI based on custom queries and merged objects based on different data sources at the report level.
• Developed reports which include the features like parameter fields, formulas, conditional formatting, multiple grouping, running totals.
• Used Custom Sorts, Slice and Dice, Cross tabs, Report Filters and Breaks in both Web Intelligence and Desktop Intelligence Reports.
• Created variables, formulae and detail objects at report level and Universe.
• Developed reports using Report studio and Query Studio.
• Modified Metadata in the model by defining Filters and adding Calculations to better suit the requirements of the end users.
• Used Version Manager and Infoburst for version control and scheduling of reports.
• Version manager was also used for migration of universes and reports across development, testing and production environments.
• Responsible for maintenance and creation of Dashboards using Xcelcius.
• Performed Impact Analysis of Reports and Universes for multiple project integrations using Metaminer and Ultraedit.
• Documented and maintained the various Impact analysis and responsible for integration modifications to reports and universes.
• Performed various levels of testing and UAT.
• Involved in production support as part of the team.

Confidential, Greensboro, NC

Business Objects Developer

Environment: Business Objects XI R3 Designer, Web Intelligence, Infoview, Desktop Intelligence, SQL Server 2005, Brio Intelligence, Tableau, Windows XP.

Responsibilities:

• Involved in requirements gathering, development and deployment of reports for three projects, each for different clients of Confidential .
• Responsible for design, development and testing of reports for supporting ad-hoc queries and canned reports using Business Objects XI R3.
• Responsible for updating universe objects and structure with varying requirements for reports.
• Extensively used the master-kernel (linked) universes approach in universes.
• Built queries and reports in Brio Intelligence.
• Used Custom Sorts, Report Filters and Breaks in Web Intelligence Reports.
• Created Slice and Dice, charts, and Cross tab reports in WebI.
• Created variables, formulae and detail objects at report level and Universe.
• Created metrics, attributes, advanced chart types in dashboards for visualizations and to manipulate data.
• Provided extensive training in Business Objects XI R3 for the staff.

Confidential, North Wales, PA

Business Objects Developer

Environment: Business Objects XI R3 Designer, Web Intelligence, Infoview, Desktop Intelligence, SQL Server 2005, Compass Application, Windows XP.

Responsibilities:

• Involved in requirements gathering, development and deployment of reports.
• Responsible for design, development and testing of reports for supporting ad-hoc queries and canned reports using Business Objects XI R3.
• Responsible for updating universe objects and structure with varying requirements for reports.
• Tuned the universe and reports for optimum query performance.
• Developed reports which include the features like parameter fields, formulas, conditional formatting, multiple grouping, running totals.
• Used Custom Sorts, Report Filters and Breaks in Web Intelligence Reports.
• Created Slice and Dice, and Cross tab reports in WebI.
• Created variables, formulae and detail objects at report level and Universe.
• Documented and maintained the various Business Objects environments, database connectivity, reports and universes existing in each environment.
• Participated in SCRUM stand up meetings and planning sessions.

Confidential, Somers, NY

Business Objects Developer/ Admin

Environment: Business Objects XI R2 Designer, Desktop Intelligence, CMC, DB2, RapidSQL 7.6.4, Windows XP.

Responsibilities:

• Involved in requirements gathering, development and deployment of Enterprise-wide BI solutions.
• Responsible for design, development, testing and of reports for supporting ad-hoc queries and canned reports using Business Objects XI R2.
• Developed custom reports.
• Used Custom Sorts, Filters and Breaks in Desktop Intelligence Reports.
• Created Slice and Dice, and Cross tab reports in DeskI.
• Created variables, formulae and detail objects at report level in Desktop Intelligence.
• Managing user accounts and group accounts in Business Objects XI R2 CMC enterprise environment.
• Troubleshooting adhoc reports developed by business users using BO Universes.
• Involved in the troubleshooting of universe schema with loops, chasm and fan traps, and cardinality problems.

Confidential, NYC, NY

Business Objects Developer/ Admin

Environment: Business Objects XI R2/R3 Designer, Desktop Intelligence, Web Intelligence, CMC, and Import Wizard, Crystal Reports XI, Crystal Xcelsius 2008, Live Office, Cognos 8.2 (Framework Manager, Query studio, and Report studio) BO Data Integrator, SQL Server 2008, Rally, and Windows XP/2000.

Responsibilities:

• Involved in scope definition, design/development and deployment of Enterprise-wide BI solutions.
• Responsible for design, development, testing and maintenance of universes for supporting ad-hoc queries and canned reports using Business Objects XI R2.
• Implemented and documented migration plan from Business Objects XI R2 to XI R3.
• Defined and created classes, objects, conditions, and measure objects to capture complex formulae.
• Set up hierarchies in the Universe for providing drill down options in the reporting environment.
• Used Custom Sorts, Filters and Breaks in Desktop Intelligence Reports.
• Created Slice and Dice, and Cross tab reports in DeskI and WebI.
• Created variables, formulae and detail objects at report level in Desktop Intelligence.
• Utilized Aggregate Awareness concept in the creation of objects.
• Created reports using Free-Hand SQL, Stored Procedures, Excel files and other data sources.
• Created reports in WebI and DeskI facilitating drill down.
• Created users, groups, profiles and publications in BO CMC.
• Setup, implemented the security model and documented it.
• Installed and configured BO Enterprise XI software.
• Designed and analyzed Reports using Crystal Reports XI and Crystal Xcelsius 2008.
• Built models containing query subjects, query items, and namespaces using Framework Manager.
• Used Report Studio to develop reports, which consisted of a combination of List, Chart and cross tab Containers.
• Created and updated ETL processes using Business Objects Data Integrator and scheduled them periodically.
• Created and updated Data Flows and Workflows, the core components in extracting and transforming Data in Business Objects Data Integrator.
• Created the User Acceptance Test scripts.
• Provided training in Business Objects XI R2.
• Provided technical Support for the production Team.