SUMMARY

• Solution - oriented IT professional with over 10 years of IT experience with 7+ years of experience in Business Objects Designer, Info View and Web Intelligence.
• Involved in designing Universe and creating reports on different versions of Business Objects.
• Well versed in Business Objects (XIR3, 3.1, 4.x) with experience in Supervisor, Designer, Reporter, BCA (Publisher and Scheduler), Web Intelligence, Info View, Dashboards, Auditor and Schema Design.
• Extensive experience in Querying and Reporting modules of Business Objects Enterprise XI R3.0,3.1, 4.X
• Worked on Web Intelligence to develop and publish thin client reports.
• In-depth knowledge in creation of WEBI reports and Dashboards using Crystal Xcelsius
• Experience in creating Universes with measures and dimensions objects, Join conditions, Filters, LOV, cardinality, Aliases, Contexts, Aggregate Awareness using Business Objects Designer.
• Created Drilldown Reports, Sub Reports, On-Demand Sub Reports, Label Reports, Chart Reports, Dash Boards, Styles and GUIs.
• Ability to transform powerful complex data into a comprehensive dashboard using Crystal Xcelsius.
• Created visually stunning and interactive dashboards and visualizations from Microsoft Excel or a live data source
• Integrated SAP data (BI) based on the BI query with BO Crystal Xcelsius using the SAP NetWeaver BI Connection connectivity present within Xcelsius.
• 5+ years of industry experience as Business Analyst with solid understanding of Business Requirement Gathering, Business Process Flow, Business Process Modeling, and Business Analysis.
• Experience in conducting GAP analysis, SWOT analysis, and ROI analysis
• Expertise in all phases of Software Development Life Cycle (SDLC) with different methodology such as Agile, Waterfall and RUP. Strong Experience in interviewing End- Users, Stakeholder, Business Owners and Subject Matter Expertise.
• Excellent skills in developing Dataflow Diagram and UML diagrams such as Use Case diagram, Activity diagrams, Class diagrams and Sequence diagrams. Excellent experience with MS Office Suite and MS Visio. Experienced in creating BRD, SRS, and FDS with the help of MS Word, MS Excel, and, Rational Requisite Pro. Detail knowledge of creating artifacts like Business Vision Document, Scope Document, and Use Case Specification.
• Excellent understanding of Six Sigma Methodology
• Heavily participated in brainstorming sessions, Walkthroughs, meetings, JAD sessions with all stakeholders in the project and also created meeting minute documents.
• Excellent skills in developing Dataflow Diagram and UML diagrams such as Use Case diagram, Activity diagrams, Class diagrams and Sequence diagrams.
• High comfort level and business focus with clients from various regions and cultures around the world. Excellent interpersonal and communication skills, technically competent and result-oriented with problem solving skills.

TECHNICAL SKILLS

Operating Systems: Windows 95/98/NT/2000/XP/Vista/7, AIX, Linux

RDBMS: SAP Hana, Oracle 10.2g,9i/8.i, MS SQL Server 2000,2005, 2008, MS Access, IBM DB2

Languages: SQL, PL/SQL, XML, HTML

Application Server’s: Web logic, OAS, Oracle 9IAS, Apache Tomcat, Webshpere

OLAP and Reporting: SAP Fiori, SAP Lumira, Business Objects, 4.x, CMC, Designer, Business Object Desktop Intelligence, Web Intelligence, Crystal Reports 2008, XI/9.0), Dashboard/Xcelsius 2008.

Other Tools: Toad, MS Visio

ETL Tool: Data Integrator, Business Object Data Services, SLT

Business Warehouse: SAP BW 7.x, 3.5, Hadoop

Methodology: Waterfall, ASAP, Scrum/Agile

PROFESSIONAL EXPERIENCE

Confidential

Lead SAP Business Objects

Responsibilities:

• Performs technical planning, system integration, verification and validation, evaluates alternatives including cost and risk, supportability and analyses for total systems.
• Analyses are performed at all levels of total system product to include: concept, design, fabrication, test, installation, operation, maintenance and disposal.
• Ensures the logical and systematic conversion of product requirements into total systems solutions that acknowledge technical, schedule, and cost constraints.
• Performs functional analysis, timeline analysis, detail trade studies, requirements allocation and interface definition studies to translate customer requirements into hardware and software specifications.
• Maintains existing structure and make decisions for the design to make the appropriate technical decisions for the overall warehouse project.

Confidential

Lead Software Engineer

Responsibilities:

• Apply an understanding of enterprise Confidential logistics processes to determine data processing optimizations and consolidations for the customer organizations.
• Perform data, processing and workflow analysis to determine redundancies in the current organization’s Confidential logistics data processing. Work closely with the customer to determine workflow processing implementations that will eliminate redundancies and consolidate data processing.
• Perform further analysis to determine how data sets from different organizations can be merged in workflows. As required, determine modifications to current data structures and processes to facilitate merging of these data sets.
• Capture all results in data flow diagrams and review with customer stakeholders.
• Work with customers to develop system implementation plans for proposed optimizations.

Confidential, Rockwall, TX

Senior SAP BI/Business Objects Developer

Responsibilities:

• Involved in collecting requirements, Interacted with prospective clients to gather their analytical requirements, which are very important to customer.
• Responsible for understanding end user requirement and convert into functional requirement and involved in preparing project plan.
• Designed, developed, maintained and tested universes for supporting ad hoc queries and canned reports according to the business requirements.
• Interacted with Users to know their Business views while gathering the Report requirements and provided Several Report Mock-ups to finalize the requirements.
• Extensive knowledge of working with company specific proprietary software and third party Software.
• Created Technical Specification requirements (use cases, interface specifications) by translating business requirements
• Converted business requirements in business/technical requirement documents.
• Defined security models with row level data security, role based security etc in Business Objects Universes and Central Management Console (CMC)
• Created users, groups, server groups and setup security architecture.
• Implemented Row Level, Object Level security for data restriction at Universe level.
• Developed BOBJ 3.1 using advanced features including Database Delegated (Smart Measures), Hyperlinks, Delegate Search, Data Tracking, Input Controls and Merge Dimensions
• Tuned and Enhanced Universes with SQL Queries for the Report Performance.
• Created Web Intelligence Ad-hoc and canned reports.
• Written SQL queries have been used on the Universe and created as Derived Tables.
• Tuned and Enhanced Universes with SQL Queries for the Report Performance.
• Created Views, Stored Procedures and validated data for the Performance.
• Created Web intelligence reports in Advanced and Interactive mode using all the functionalities
• Implemented Open Doc to drill down to detail Webi report
• Designed, developed Universes and Webi Reports.
• Created web reports through report template in Web Application Designer.
• Converted business requirements in business/technical requirement documents.
• Designed web intelligence reports for dimensional hierarchical data
• Involved in unit testing and User acceptance testing.
• Deployed the reports to CMC for the users to able to see the reports in Info View and run, schedule and view the reports in different formats (PDF, Excel)
• Wrote formulas, parameters and conditions depending upon selection criteria.
• Implemented dynamic cascading prompts and defined business views
• Involved in Modifying and Performance tuning of the Existing Reports.
• Created the reports using Business Objects functionality’s like Queries, Slice and Dice, Drill Down, Cross Tab, Master Detail and Formulae’s etc.
• Organized data in the report Inserting Filters, Sorting, Ranking and highlighting data.
• Developed reports specific with these Delegated Search, Database Delegated, Open Document and Data tracking new functionalities.
• Published Reports to CMC (Central Management Console) and involved in Scheduling and exporting the reports in different Formats.
• Deep understanding of SAP Fiori and Data services.

Confidential, McLean, VA

SAP BI/Business Objects Developer

Responsibilities:

• Created Crystal Reports from Remedy using Remedy Help desk and Asset data.
• Work with the end users and the higher management to define the requirements. Review the requirements and convert them into design specifications.
• Work closely and cooperate with the end users, delivery group to deliver reports, and ensure designs and development of data usage is maximized
• Conducted user sessions and supported them with new requests, enhancements, and modifications.
• Designed and developed Crystal Reports, according to the requirements. Used complex formulae, conditional formatting, sub reports, parameters with drill-down capabilities.
• Used Central Management Console to perform administrative tasks related to user groups, accounts, report publishing, folder management etc.
• Developed complex SQL queries for the report command objects.
• Performed data analysis by writing complex SQL queries on various source systems and data warehouse to find trends and anomalies in the data to support the requirements.
• Created business process documentation
• Created internal team documentation for tracking time and training
• Peer review the existing Functional and Technical documentation for Remedy Team
• Analyzed the Budgeting tool for Business Objects
• Gathered requirements for Windows 7 - Remedy Compatibility Testing (both Remedy 6.3 and Remedy 7.6)
• Develop Functional Specification documents, user interface specifications, and user requirement specification documents.
• Create documentation including data flow diagrams and online system process flows
• Conducted UAT (User Acceptance Test) and working with QA and QC Teams
• UAT includes both manual and automated testing tools to troubleshoot systems, integration, user acceptance, positive and negative, functionality, object, and regression

Confidential, Edison, NJ

SAP Business Intelligence Analyst

Responsibilities:

• Used questionnaire, survey, JAD sessions, and Brainstorming sessions as requirement gathering techniques to communicate with users, SME (Subject Matter Experts), and developers
• Designed several Universes using Designer according to the requirements
• Created Classes, Dimension objects, Measure objects and Detail objects in the universe
• Resolved issues related to RDBMS flaws such as Fan Traps, Chasm Traps using BO multi parse SQL functionality
• Create stunning presentations with exciting visual components using Crystal Xcelsius
• Enable up-to-the-minute information for dashboard with live data using various connections
• Create and modify reports using SAP Business Objects Web Intelligence and Desktop Intelligence.
• Created repository and security domain with user groups and security implementation.
• Prepared different report layouts and blocks like Tables, Cross Tabs and Charts
• Used different functionalities like Breaks, Filter, Sorts, and Ranking to generate reports.
• Used the formatting options like cross tab representation, section breaks, data sort options, calculations, font, colors, etc.
• Used aggregate awareness in universes. Involved in full life cycle of Business Objects reporting Application.
• Updated and maintained Universes based on changing user requirements and data source changes
• Checked Universes for Integrity and exported them to the Repository to make resources available to the users and groups.
• Handled Embedded Functions like @Prompt, @Select, @Where in the Designer to handle User requests for report generators Developed Xcelsius presentations/visualizations for profitability Analysis, Distributor Sales Analysis, Monthly Sales Analysis, Forecasted Sales What if Analysis.
• Interactive visualizations were made for executives to visually evaluate different scenarios by adjusting key variables.
• Conducting UAT (User Acceptance Test) and working with QA and QC Teams positive and negative, functionality, object, and regression

Confidential, Wilmington, DE

Business Systems Analyst

Responsibilities:

• Develop use cases, user interface specifications, and user requirement specification documents.
• Work with and liaise between ESS clients and ESS middleware-IS Development team to ensure requirements and goals are correctly met and understood during all phases of projects.
• Work directly with the development team to ensure system enhancements are correctly transitioned to the build phase.
• Create documentation (including data flow diagrams, batch and online system process flows, subsystem touch points and dependencies) to assist in planning RTE activities for projects and normal BAU activities.
• Create additional documentation to communicate planned system functionality and implementation processes to the business and development teams consisting of data flow diagrams, batch and online system process flows and subsystem touchpoints and dependencies.
• Conduct impact assessments to understand business and application implications to requests being considered.
• Understand, at a SME level, the ESS infrastructure and plan out implementations, outages and task lists, and provide technical and business consultation to various departments throughout the bank as directed by Tech Leads and Development Manager.
• Responsible for ensuring current and accurate system documentation, educational tools and materials as a result of activities and will be involved with the Project Manager regarding planning, scheduling and resource allocation approved by Tech Leads and Development Manager.
• Involved in Installation, Configuration and Deployment of Business Objects Suite.
• As a part of report development, created the reports using universes as a main data provider and using the Powerful business objects functionalities, and formulae
• Updated data for crystal Xcelsius visualizations by using export setting commands.
• Complex data was retrieved from excel files
• Worked extensively on the analysis of the dashboards and ways that would improve client decision making.
• Drafting the Technical design Documentation for the reports created as part of dashboard design.
• Designing and Developing Universe structure as per the Technical System Design Documentation.
• Resolving issues encountered during universe creation, to remove the cyclic dependencies, thereby checking universe integrity and creating aliases, contexts where needed.
• Creation of Universe Classes, Objects, Joins, Predefined conditions, etc.
• Applying Row level, Report level & Object level security in the universe to make the sensitive data secure.
• Creation of standard Full Client / Webi reports, involving both Ad-hoc and canned Reports for analysis.
• Involved in the creation of various report formats including Master/Detail Reports, Sub Reports and Cross Tab Reports to show cast the functionalities of Business Objects.