Working at US Navy Personal Modernization (PersMod) Program, to develop Business Objects universes in a data warehouse environment, develop complex reports using advanced Business Objects techniques and build ad hoc capabilities into the universes.• Perform 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.• Ensure the logical and systematic conversion of product requirements into total systems solutions that acknowledge technical, schedule, and cost constraints.• Perform functional analysis, timeline analysis, detail trade studies, requirements allocation and interface definition studies to translate customer requirements into hardware and software specifications.• Maintain existing structure and make decisions for the design to make the appropriate technical decisions for the overall warehouse project.

Worked on Navy's Personnel Modernization (PersMod). Developed Business Objects universes in a data warehouse environment, develop complex reports using advanced Business Objects techniques and build ad hoc capabilities into the universes

• Apply an understanding of enterprise Army 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 Army 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.

SAP BOBJ Experience•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.•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.•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 Web intelligence reports in Advanced and Interactive mode using all the functionalities•Implemented Open Doc to drill down to detail Webi report •Organized data in the report Inserting Filters, Sorting, Ranking and highlighting data.•Published Reports to CMC (Central Management Console) and involved in Scheduling and exporting the reports in different Formats.SAP BW/BI ExperienceDescriptionWork on multiple BW projects, using multiple data sources (SAP, SQL, Flat files) for reporting purposes. Used Excel for Analysis and Webi as Front End reporting tools.

•Created six universes for Quality and Manufacturing data both from SAP and Oracle data source.•Interacted with end users and business analysts to identify and develop business requirements and transform it into technical requirements and ultimately responsible for delivering the solution.•Involved in gathering, analyzing, and documenting business requirements, functional requirements and data specifications for Business Objects Universes and Crystal Reports.•Design and Development of Business Objects Universes, which suits the standard, analytical and ad-hoc reporting requirements of the Business Objects users.•Involved in the designing and Building of Universes, Classes and objects•Involved in the troubleshooting of universe schema with loops, chasm and fan traps, and cardinality problems.•Involved in the creation of Key Performance Indicator and Metrics.•Implemented Row level and Object Level security as per the user requirement.•Created and tested classes and objects to organize the universe.•Exported the universes to the Repository to make resources available to the users•Created reports for various Portfolios using the various data Providers like Free Hand SQL, Stored Procedures.•Used Business Objects functionalities like applying breaks on reports, Slice and Dice to create the Crosstab and Master Detail reports•Created the reports using Business Objects functionality's like Queries, Slice and Dice, Drill Down, Cross Tab, Master Detail and Formulae's etc•Created Crystal Reports using BO universe as Data source.•Published and scheduled Business Objects Reports to users using Scheduler•Assist in the planning, design and implementation of the Business Objects upgrade from v3.1 to v4.0

• Work for U.S. Dept. of Home Land Security, Custom and Border Patrol division.• 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

• Work for Bawla and Bawla CPA firm in Long Island City, NY.• 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.

• 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