SUMMARY

• 10+ years of IT experience in Business Objects, Web Intelligence, INFOVIEW, Business Views, Universe Design, Xcelsius, OLAP, Oracle 11g/10g/9i, Access, SQL Server.
• Database reports, spreadsheets, queries, data entry, research, internet searches.
• Technical customer service and support, project coordination, administrative tasks.
• Proprietary application support, basic network support/systems monitoring and email administration.
• Database experience using Oracle 9i, MS SQL Server 2005, SQL, PL/SQL. Hands on Working knowledge in Oracle and SQL Using Stored Procedures, Packages, Functions and Triggers.
• Competent in Business Intelligence administration and development of reports using Business Objects from 6. 5 to BOXI R3.1 with XCELSIUS 2008, CMC, Webi (Web Intelligence), Deski (Desktop Intelligence), Universe and Kronos 6.12 (Time & Attendance System).
• Extensive Data warehousing experience in administration and development using Business Objects, Business Objects and Data Integrator.
• Strong Knowledge with Star Schema and Snow Flake Schema Data Models.
• Extensively used Tables, Views, Stored Procedures and Functions for Complex reports.
• Experience on Reports by using Business Objects XI R2. /XI - R3.
• Experience in creating Universes with measures and dimensions objects, Join conditions, Filters, LOV, cardinality, Aliases, Contexts, Aggregate Awareness using Business Objects Designer.
• Experience in interaction with the Business Analysts, identifying the needs & the requirements of the system and involving in requirement study of the system.
• Excellent understanding of Normalization and demoralization of schemas, designed star schemas with snow flake dimensions.
• Migrated XI-R2 Business Objects deployment to XI R3.1 using Import Wizard.
• Optimized performance issues for the reporting after the migration.
• Successfully resolved the issues after the migration from Business Objects XIR2.to XI-R3.1.
• Being a key project player, observed a full Life Cycle of a project, which included Requirement Analysis, Planning, Designing, Development, Test and Roll-Out / Go Live.
• Expertise in gathering the business requirement and building Universes in the Designer, retrieving data using Universes, Personal data files, Stored procedures, Free hand SQL methods and creating complex ad-hoc Reports using data access and report design using Web Intelligence modules mapping of the objects and data correctness.
• Experience performing Unit Testing and Performance Testing for the reports.
• Expertise in building/enhancing/migrating Business Objects universes and using various data providers.
• Experience in Design and Development and expertise in all modules of Business Objects 6.5/XIR2/XI-3.1
• Comprising of Designer, Business Objects Reporter, Broadcast Agent, Web Intelligence, and Info View.
• An intelligent and responsible software developer, fast learner, good technical abilities and skills developed by a strong work ethic and self-learning.
• Worked with Business Users to analyze the business process and made necessary changes to schema objects to cater their reporting needs.
• Excellent analytical and teamwork skills and communication and interpersonal skills.
• Able to handle multiple projects simultaneously, team player, responsible and detail oriented.

TECHNICAL SKILLS

Operating System: Windows 95/98/2000/NT/XP-Professional/Vista/Windows7.

Languages: SQL, PL/SQL.

Databases: Oracle 10g/9i, MS SQL Server 2000/2005/2008, MS Access, DB2 / Toad.

Web Applications/Servers: Provider Portal, Confidential Blue Cross, ICR/ICG Application.

Tools: Business Object (6.x/XIR2/XiR3), Xcelsius 4.5, Kronos 6.2.12.

Hardware: HP, Dell, IBM, Intel.

Others: Star-Schema (ROLAP) Modeling, Snowflakes Modeling

PROFESSIONAL EXPERIENCE

Confidential

Business Objects Administrator

Responsibilities:

• Plan, monitor and assist with the business cases with excellent communication & writing skills using Agile methodology.
• Involved in gathering, analyzing, and documentation business requirements, functional requirements and data specification for Business Objects Universes and reports.
• Migrate SSRS 98 report to XIR 3.1.
• Understand Database Fields Names, Tables, objects, Database Schema & Application’s flows.
• Performed Unit Testing on DEV, UAT and Productions environments.
• Defect Fixing for the Report & Involved in Reports Signed off process for report and application quarterly Release.
• Connect and understand front end and Database mapping.
• Developed simple and complex reports as per business requirement.
• Added codes, editing and logics on existing reports on Universe Level.
• Created Classes, Dimension objects, Measure objects and Detail objects in the universe.
• Applied coded, editing, logics, report filters and variable on existing and new report on Report Level using Webi.
• Used Derived tables in the Designer to enhance the capabilities and performance of the universe.
• Detected Joins and checked the Cardinalities.
• Experience working with business users as well as senior management.
• Design mockups for business and signed off using Agile methodology user stories.
• Logs out defects on Rally using Agile methodology. Created mapping document from business rules and transform in technical detail e.g: databases table and columns.
• Excellent knowledge of HIPAA (Health Insurance Portability and Accountability Act) transaction codes.

Confidential, GA

BO Administrator

Responsibilities:

• Understand & obtain access to Confidential Network, computer systems and SAP Business Objects applications.
• Understand & obtain access to Business Objects 3.1 Production environment.
• Co-ordinate with DBA team to obtain access to SQL Servers DBs.
• Co-ordinate with help desk to get Access Confidential Network.
• Review Current 3.1 Infrastructure and provided documents assessment details.
• Finding Prioritize folders/objects and Identified user reports not in the repository
• Finding Non Business Objects reports.
• Identify customized, Web Intelligence & Desktop Intelligence reports requiring potential remediation.
• Open/Run representative set of 3.1 reports in BI Test environments.
• Identify universes to be Migrated.
• Identify universes that need remediation.
• Identify universes connections to be Migrated.
• Verify connections are pointing to correct DB sources.
• Identify Users to be migrated.
• Identify non essential Objects Report Instances & Inactive Users for last x months (i.e., users, reports, etc)
• Reviewed Security Model, Access Level & Row Level Security in current BO 3.1.
• Setup pre-Production Upgrade SAP BI 4.1 Test environment.
• Reviewed 4.1 Licensing.
• Reviewed available software versions, patches, fixes on SAP Marketplace Site.
• Reviewed Support agreement.
• Verify HW requirements.
• Setup/Install SAP BI on a test/sandbox.
• Configure SQL Server DB Client Software.
• Configure Business Objects Test\Server.
• Install/Configure BO software.
• Install/Configure BO software with Replicate 3.1 Security in 4.1
• Migrate representative sample of BO 3.1 content to Test environment using Upgrade Management Tool.
• Evaluate Audit Universes post migration.
• Complete Project Planning.
• Setup/Install SAP BI across 4.1 Production Server Landscape.
• Configure Business Objects Production Servers.
• Central Management Console (CMC).
• Configure Default Services.
• Configure Adaptive Processing Server - Services.
• Setup pertinent security (access Levels, promote and Validate security.
• Migration to Production with Perform Incremental Migration.
• Migrated Users Folders and verfiyied User folder content.
• Stress Testing and check health check of the BI Servers.
• Making sure BI 4.1 Production Availability and Post production support.
• Remediation included reports, universes, database, connections contents and etc.
• Knowledge transfer.
• Administration handed over to client.

Confidential, Wallingford, CT

Sr. System Analyst / BO Developer

Responsibilities:

• Deeply involved for requirement gathering with Business and System Analyst.
• Implemented completely SDLC process from high to bottom inclusive Project Scope Management, Objectives, Functional Requirements, and Technical Requirements, Boundaries Deliverables, Acceptance Criteria, Constraints and Standards.
• Used reverse engineering technique and tracked all the reports which were already in production environment.
• Created project related document and upload on share point portal and WLP University e.g. Technical document, reports mockups with POC and screen shot.
• Participated All Team - Weekly Status Call and provide updates on current project.
• Worked with System Analyst to understand the current business environment and proposed all the technical requirements for current and future quarterly release for reports.
• Understand upfront applications used for “Providers Portal and Watson”.
• Understand Database Fields Names, Tables, objects, Database Schema, and Application’s flows.
• Performed Unit Testing on DEV, UAT and Productions environments.
• Defect Fixing for the Report.
• Involved in Reports Signed off process for report and application quarterly Release.
• Participating March Release Reporting Meeting with Business and SAs.
• Project Alder Team Business and IT Q & A.
• Connect and understand front end and Database mapping.
• Created and added functional Documentation for New and Existing Reports.
• Developed simple and complex reports as per business requirement.
• Added codes, editing and logics on existing reports on Universe Level.
• Created Classes, Dimension objects, Measure objects and Detail objects in the universe.
• Applied coded, editing, logics, report filters and variable on existing and new report on Report Level using Webi.
• Used prompt function successfully in Webi as business demands.
• Proposed new mockup of the new Report for quarterly release.
• Verified and validated Data accuracy for current and newly made it reports using Toad.
• Created How to change Toad password before it expire document with screen shot.
• Verified &validated Data accuracy for all Reports before moved into Production Environment.
• Data Testing and verification performed for the reports before Application release.
• Identified all the reporting requirements flaws due the absence of dedicated SA by documenting the existing reports database fields and sat up direct line of communications between all the key stake holders and key players of business objects reports during weekly IT Business discussions.
• Followed business development time lines and change control process to make any further changes in reports and helped out Confidential to estimate LOE more effectively and reduce waste of time and funds.
• Created and provided on the share point portal for technical documentations of Business Objects system related (database, Schema, data modeling, Tables, flow diagram) and user guide.
• Documented reports inventory and reinvigorated Business Objects Universe by cleaning the unwanted items and streamlining it to most updated OLTP.
• Recommended data-mart for the existing OLTP for BO reporting to take full advantage of BO tools and database. It was accepted and implemented successfully.

Confidential, CA

Technical Lead /Data Analyst

Responsibilities:

• Coordination with Onsite / Offshore team (16 members) in report design and production support environment.
• Coordination with Data Warehouse team including Design, Data Modeling, ETL with Oracle and SQL Servers.
• Involvement in project requirement gathering and providing solution to deliver it on time.
• Assisted the Project Manager with writing and formatting written procedures for report generation and research.
• Ran reports in Business Objects, Salesforce, and Oracle identifying potential revenue opportunities.
• Review and data compilation to create comparisons and build complex spreadsheet reports to identify renewals
• Assisted with database cleanup.
• Performed troubleshooting and resolution of issues with process flow and requirements, addressed status requests, assisted with online issues
• Provided general service and support to client members.
• Knowledge Transfer with Business SMEs, shared and explained with Onsite & Offshore associates.
• Created SMTD (System Maintenance Technical Document), EPD successfully signed off process for Business Object and Kronos.
• Status update to client and Wipro management and weekly status and meeting with Client and Offshore Team.
• Supporting onsite / offshore developers with ongoing daily issues.
• Updated Project information for the different sections on SharePoint.
• Assure to provide Permanent resolution within SLA according to the priority and resolve within as less time.
• Created several Universes using Designer according to the Requirement.
• Created various User defined objects including Dimensional, Detail, and Measure objects and tested them to ensure correct mapping of data.
• Created new and modified existing Hierarchies in the universes to meet Drill Analysis of the user’s reporting needs.
• Involved in performance tuning and optimization on Business objects Universes by creating Aggregate tables.
• Defined Alias and Contexts to resolve loops and also tested them to ensure that correct results are retrieved.
• Performed integrity testing of the Universes (Universe Structure checking, Object parsing, Joins parsing, Conditions parsing, Cardinalities checking, Loops checking and Contexts checking) after any modifications to them in terms of structure, classes, and objects.
• Used multi-dimensional analysis (Slice & Dice and Drill Functions) to organize the data along a combination of Worked extensively with the major functionality of BO like Breaks, sections, Group values, Sorts, List of values (LOV), Pre-defined conditions, Calculations and Ranking and excellent experience in Data Modeling and UI Design usingWebi.
• Analysis of reports and data, working directly with the business to provide graphical reporting solutions.
• Primary Operations Consultant for the Lawson and HR’s Time & Attendance (Kronos) System.
• Lead Systems Administrator for the Kronos System, duties includes configuration design, adjustments and troubleshooting to meet company policy and contractual changes.
• Provide comprehensive customer support to all Kronos users and Resolve Login issue using “Service Now” Ticketing System.
• Monitoring and notifying for device failure, import error for Enhancement with the application on reducing the time on daily run after getting development access.
• Notify all active Kronos user through email for all basics things to know for Kronos application usages (e.g. how to navigate, user and password standards and policies).

Confidential, Boston, MA

Onsite Lead

Responsibilities:

• Coordination with Offshore team in report design.
• Coordination with Data Mart team in designing reporting marts for the reports.
• Requirements Gathering from Business users and status update to client and Wipro management.
• Updated Project information for the different sections on SharePoint.
• Expertise in analysis, design and development of business intelligence systems and strong database skills.
• Complex Report Development and defects fixing.
• Interact with Business Analysts team to understand exact business requirements.
• Interact with testing team to closing the gap in reports and singed off process.
• Gap Analysis of old reporting systems toBusinessObjects systems.
• Understandbusinesschallenges & translate them into requirements/solutions.
• Evaluate LegacyBusinessIntelligence system and Identify current gaps based onbusiness needs.
• Provide Solution Performance (analysis/tuning) and works acrossbusiness/technology teams to ensure alignment betweenbusinesssolutions, definition and systems architecture for the organization.
• Excellent concepts of data warehouse.
• Create and build custom reports using Jasper web based self-service.
• Generate and Export Multi section, List, Charts and Crosstab report, multiple layout such as PDF and Excel output.
• Create and published various related reports through Interactive Report Design, Webi and Info view portal.
• Customize content, Adjust size and placement and layout of report sections.
• Create and Apply Report Styles to Report Designs accommodate to business need.
• Create and defining calculated fields and parameters via Expression Builder.
• Implement Individual element style, font, positioning, sizing, and conditional formatting.
• Used formatting tools, Palette of graphical report elements, Report Section query fields.
• Scheduling, Time/ Event based delivery to Inbox, desktop, email and printer.

Confidential, Warren, NJ

Business Objects Developer

Responsibilities:

• Involved in gathering, analyzing, and documentation business requirements, functional requirements and data specification for Business Objects Universes and reports.
• Closely worked with Business Objects end-users and business owners to design and develop Business Objects Universes, which suits their standard, analytical, and ad-hoc reporting requirements.
• Connected SQL data base to generate reports.
• Involved in the designing, building, and testing of Universes, classes and objects, and universe level condition filters.
• Involved in the troubleshooting of universe schemas with loops, chasm and fan traps, and cardinality issues.
• Exported the universes to the Repository to make resources available to the users.
• Created the reports using Business Objects functionality's like queries, slice and dice, drill down, cross tab, master detail and formula's etc.
• Scheduled WebI reports in Infoview by creating publications.
• Created complex reports using functionalities like Slice and Dice, Drill Down, Scope of Analysis, Master Detail.
• Exported reports to the repository for Infoview users.
• Excellent understanding and work experience of EXCEL functions with Business Query reporting.
• Created Custom Hierarchies for several groups and design and develop the best practices.
• Optimized the XIR3 system performance by fine tuning the XIR3 servers.
• Implemented the minimal customizations of Info View in XIR3.

Confidential, New York, NY

Business Objects Developer

Responsibilities:

• Coordination with Offshore team in report design.
• Defined KPI’s Metrics (Key Performance Indicators) to analyze the user adoption to BI as a part of Data Governance Goal.
• Used QaaWs (Query as a Web Service) to feed data into Xcelsius.
• Created complex / simplex Xcelsius dash boards to reflect User Adoption Metrics.
• Created Classes, Dimension objects, Measure objects and Detail objects in the universe
• Analyzed specs and database model to generate the reports for the sign-off specs.
• Connected to Business Objects Repository as a Business View and created reports.
• Analyzed data using Slice/Dice, Drill Mode, Prepared different report layouts and blocks like Tables, Cross Tabs and Charts.
• Used different functionalities like Breaks, Filter, Sorts, and Ranking to generate reports.
• Created Business Objects Web Intelligence & Desktop Intelligence reports and published on the INFOVIEW.
• Prepared user documentation for hands on training for end user community.
• Handled Embedded Functions like @Prompt, @Select, @Where in the Designer to handle User requests for report generators.
• Secured system by developing system access, monitoring, control, and evaluation; establishing and testing disaster recovery policies and procedures; completing back-ups; maintaining documentation.
• Maintained and ensures the integrity and security of the server/processing/storage environments.
• Monitored and evaluates overallsystem/storage performance and day-to-daysystem/storage activity.
• Diagnosed and mitigatessystem/storage performance issues.
• Researched and applies patches and maintenance upgrades.
• Conducted advanced capacity planning analysis and created disaster recovery plan.

Confidential, Boston, MA

Business Objects Developer/Administrator

Responsibilities:

• Designed report templates for the report company standards.
• Analyzed specs and database model to generate the reports for the sign-off specs.
• Connected to Business Objects Repository as a Business View and created reports.
• Created Business Objects Web Intelligence & Desktop Intelligence reports and published on the Infoview.
• Used Drill down Group Levels, Conditional formatting, Alerter, Alternate row shading futures and Created Label reports for Providers and Subscribers.
• Developed reports by using Business Object XI R2/ XI-R3.1.
• Published report to Enterprise server, to get the report access from Infoview.
• Generated List of Values (LOV’s) from lookup tables.
• Worked extensively with @functions (@select, @prompt, @where) to overcome the problems with database when integrating with business objects.
• Used Derived tables in the Designer to enhance the capabilities and performance of the universe.
• Detected Joins and checked the Cardinalities.
• Implemented Data warehousing schemas like Star-Schema, Snow-Flake Schema.
• Migrated business objects 6.x to Business Objects XIR2 using Import Wizard.
• Checked the integrity of the Universes, and exported the universes to Repository for making available to users.
• Generated pictorial views in the form of 2D, 3D & Pie Charts from existing Reports & Chart Wizard.
• Involved in data modeling of the data warehousing system by creating facts and look-up tables using business objects.

Confidential, New Jersey, NJ 

Business Objects Developer

Responsibilities:

• Created complex Universes and report for General Ledger, Accounts Payable and Accounts Receivable
• Designed and implemented oracle based security in Business Objects.
• Resolved Loops using Aliases and Context, addressed chasm trap and Fan Trap using Multi Parse SQL
• Created Custom Hierarchies for several groups and was involved in Star Schema customization / Design session.
• Oversee daily activities of the project SDLC process and coordinate activities of team members, ensuring that module goals are met within predetermined time frames.
• Provided the first level support to approximately seven groups.
• Re-defined the security in XI R2 and implemented the best security model in XI R2 using new security features.
• Implemented the minimal customizations of Info View in XI R2.
• Co-ordinate with MIS team on Business Objects full client deployment.
• Developed reports in Desktop Intelligence & Web Intelligence XIR2.
• Developed General Ledger and Accounts receivable universes using Designer XI-R2.
• Created complex Universes and report for GL, AP and AR.
• Designed and Developed Xcelsius dashboards / analytics and exported to several formats
• Help client to deploy Business Objects XI 2.0 on 7 different environments (Development, System Test, Performance Test, UAT, Production, SLA, and Disaster Recovery.
• Created KPI visualization for the client dashboard using live data (Query as a Web Service) which address the performance of the LOB at the Organization Level.