Professional Summary:

• Over 7 years of experience in Information Technology as Business Objects Developer
• Extensive experience in analysis, design, development and implementation of Business Intelligence applications

Summary

• Proficiency with Business Objects enterprise Products, Universe Designer, Desktop Intelligence, Web Intelligence, Info View, Central Configuration Manager CCM , Central Management Server CMS and Central
• Participated in all phases of Software Development Life Cycle SDLC - Requirement Analysis, Design, Development, Testing and Documentation
• Experience in gathering Business Requirements Document BRD , System Requirements Specifications SRS , System Design Specifications SDS and functional requirements while working with the client and project managers
• Developed Requirements Traceability Matrix RTM to assist and update stakeholders with the progress and successful implementation of project
• Experience in working and implementing Crystal Reports XIR2/10/9/8 and Crystal Xcelsius.
• Proficiency in design and implementation of Xcelsius Dashboards using QaaWs, Live office and XML sources
• Good understanding of Data Warehousing Design Methodology, Data Warehouse Concepts, Database design and architecture including both OLAP OLTP data
• Experience in using Star Schema, Snowflake Schemas and Multi-Dimensional models for faster and effective querying
• Strong database experience using Oracle 10g/9i/8i, MS SQL Server 2008/2005, MS Access.
• Completed two full life cycle implementations for different modules in SAP BI/BW which involve Gap analysis, Blue Printing, Realization, Production support, Testing and Documentation
• Proficiency in ETL activities such as Data Extraction, Data Modeling, Loading Full/ Delta upload , and scheduling, monitoring and process chains for automated data loads from different source systems
• Conducted analysis of Big Data by successful installation, configuration and administration of Hadoop ecosystem components and architecture
• Strong knowledge in developing, designing and implementing data mining models using neutral networks and logistic regression
• Experience in a variety of industries such as Facilities Management, Finance, Healthcare, Insurance, Emergency Preparedness, Transportation, Oil Gas, Renewable Energy and Energy Conservation

Technical Skills:

Professional Experience:

Confidential

Sr. BO Consultant

Confidential is a leading Computerized Maintenance Management System CMMS software aimed at providing solutions for Facility Management.Confidential specifically targets the emergency preparedness sector of the Facility Management Industry. The context for this project is to move data from disparate systems into one integrated warehouse Technology with their own portal contributing major information of Reports Dashboards for their users.

Responsibilities:

• SAP Business Objects developer to support BI requirements gathering to report delivery for new projects and made improvements to existing project reports
• Participated in monthly meetings of Board of directors, stakeholders and staff to provide an update and help understand progress of their units
• Involved in Software Development Life Cycle SDLC by gathering Business requirements and specifications from client and beta user groups and developed technical documents
• Implemented Agile/Scrum project methodologies for stand-up meetings to provide updates for project team members and move the story cards accordingly
• Worked with Central Management Console CMC to set security levels, publish and schedule reports
• Designed Universes using SQL Databases to build queries in Web Intelligence, Crystal Reporting and Implementation of BO Dashboards
• Responsible for design, deployment and maintenance of universes using BO web intelligence and scheduling reports on daily, weekly and monthly basis
• Implemented Cardinality settings, Joins, Contexts, Conditions and Global Filters in Universe
• Worked in Aliases and Contexts to resolve looping problems and used Derived tables methods
• Implemented Custom Hierarchies for drill analysis and worked with Aggregate functions
• Used Cascading prompts and Filters to minimize data cost and performed Drill operation for lower child level analysis
• Applied Breaks and Sections in Webi reports and developed graphical charts and bars
• Created Web Intelligence Ad-hoc and canned reports and implemented Ad-hoc Webi reports and Sub-Reports against Universes
• Identified and removed bottlenecks to improve performance of Dashboards and personalized the dashboards to reflect user-specific alerts and metrics to track Key Performance Indicators KPI
• Worked extensively with functions aggregate aware, select, prompt, where in the creation of dimensions, measures and conditions
• Worked closely with DBAs to create aggregate tables to support Universes and dashboard.
• Data Extraction Transfer Loading ETL using SAP BOBJ Data Services 4.0, loading data from SAP ECC system to SAP HANA and SAP HANA Data Provisioning using SAP LT replication server SLT , Flat Files, Data Extraction Connection
• Used Import Wizard/ Life Cycle Management LCM tool and transported objects dimensions, measures, details, universes, connections, calendars, publications from Development to Testing to Production Systems

Environment: SAP Business Objects 4.0 Desktop Intelligence, CMC, CMS, Application Foundation, Data Integrator, Web Intelligence, Universe Builder, Import Wizard , BI7.0, Dashboards, Crystal Reports, ECC 6.0, BEx Analyzer, Oracle 10g, Windows 7, MS office, SQL Server 2005

Confidential

Sr. BO Consultant

Confidential provides contractual services, including financing, operating, improving and expanding the utilities services infrastructure to its clients. LEI have implemented Business Objects for their reporting purpose and corporate management decisions. The data comes from different operational sources and stored in a data mart and then data is transformed and loaded into a centralized data warehouse for various strategic business reports. The objective is to automate the entire data load on a schedule basis and generated reports for the management.

Responsibilities:

• Introduced the team to Agile Work principles, practices and disciplines in an interactive fashion that assists in teambuilding and applied Agile Work methodologies to existing problems
• Developed Requirements Traceability Matrix RTM in order to assist and update stakeholders with the progress of the project for successful implementation
• Scheduled recurring daily, weekly and monthly reports Webi, Deski, and Crystal Reports in Info View and used calendar based scheduling for reports
• Developed reports using functionalities such as drill down, master detail tables, functions, slice dice, cross tab and formulas to speed up query and processing time
• Improved the performance of reports by implementing Aggregate tables, Materialized Views, Creation / Re-building of Indexes and managing Cache
• Modified dashboards with performance issues and prepared Gap analysis for clients Sakeholders
• Designed, developed and managed universe in IDT for generating Pay roll reports, expense marketing reports and mapping data for marketing user group
• Migrated BO content on a phased manner from Win 3.1 to Linux 4.1
• Promoted them through new Promotion Manager Tool LCM into QA and Prod boxes
• Worked closely with ETL developers to design, develop, test, maintain, and support the data architecture to ensure optimal performance and reporting flexibility while maintaining data warehouse quality standards
• Selected data mining prospects for direct marketing including mailing, lead user and calling lists
• Prepared reports describing the results of the program and made recommendations for reaching target demographics for a successful market entry
• Tracked results of database marketing programs and gathered information for post-program analysis
• Developed statistical models describing characteristics of respondents to the marketing program and presented program proposals for management to take advantage of database marketing opportunities
• Coordinated and provided 24x7 production support both onsite and offshore for client

Environment: SAP BI 4.0 Web Intelligence Rich Client, BI Launch Pad, Information Design Tool, Data Foundation Business Layer , Business Objects XI 3.1, Universe Design Tool, Live Office, Promotion Management, Upgrade Management Tool , SAP BW 3.5, HANA 1.0, BI7.0, ECC 6.0, BEx Analyzer, Windows 2003server, DB Visualizer, Netezza, Oracle 11g, MS Office, SQL Server 2005

Confidential

BI BO Developer/ Admin

Confidential Ag-Products is a bio-technology based manufacturer of innovative plant health solutions.Confidential Ag uses SAP Business Objects universes and reports for the management team. The Project focused on gathering of user requirements for reporting and develop reports to cater to various business functions. Several Data warehouses and Data Marts in areas of Supplier Management, Customer Order Management, Materials management, Finance, Logistics were developed and implemented.

Responsibilities:

• Developed universe for sales and marketing department to analyze sales and enable marketing team to make informed decisions
• Used Designer Module to design universes, join tables, create prompts, queries and applied contexts and aliases to remove loops
• Used Designer functions like Aggregate Aware to make use of aggregated table like year to date employee information, Total Funds allotted to employee for Each Fiscal Year FY and Prompt to allow the users to enter the values like Pay period Number, Fiscal year and calendar year when running reports
• Defined hierarchies in universe to provide users with drill down option in reports and predefined conditions to use in Business Objects
• Created various drillable Webi reports
• Created ad-hoc reports with cascaded multiple prompts to retrieve required data for the user and minimize unnecessary load on the server
• Created reports with heavy conditional formatting and functions to meet user requirements
• Customized the reports with custom functions and loops to leverage the user reporting needs
• Scheduled recurring daily, weekly and monthly reports Webi, Deski, and Crystal Reports in Info View and used calendar based scheduling for reports
• Created various group based publications and distributed reports to the users
• Setup predefined conditions in the universe level to restrict the volume of data to be pulled by users
• Interacted with users to analyze changes and improvements they needed in existing reports and developed these reports to fulfill user requirements
• Created Cross Tab Reports, Sub Reports and addressed chasm and Fan Trap using Multi Parse SQL
• Prepared user documentation for hands on training for end user community

Environment: Business Objects 6.5.1 Supervisor, Designer, Reporter , Web Intelligence, BCA 6.5.1, 3 Tier BO, BO XI R2 CMS, CMC, CCM, Designer, Desk I, Web I, Import Wizard, Performance Management , BOXIR3, Crystal XI, BO XCelsius 2008 ,ORACLE 10g/9i, TOAD, Windows 2003 Server, Microsoft Excel 2007, UNIX, Informatica Power Center, SQL Server 2005

Confidential

Business Intelligence Consultant

Confidential designed a software program identifies and prevent sales to individuals legally prohibited from buying alcohol and Tobacco. The data from different source systems were extracted into one integrated data warehouse, which would allow for storage and reporting. The project involved extensive data cleansing work with data drawn from numerous different databases and spreadsheets. The data was then consolidated on Business Objects Data Services, SAP Business Objects Data Integrator.

Responsibilities:

• Involved in the Requirements gathering, Development, UAT and production support phases of Business Objects Report development
• Installed Business Objects version 5.1.3,
• Created user groups and managed access privileges using Business Objects Supervisor
• Responsible for Business Objects Repository, Web Intelligence maintenance and tuning
• Performed release management of Business Objects reports using Broadcast Agent Server
• Extensively used Designer to design various universes for different business groups
• Created complex reports using cascading prompts, decode objects, etc.
• Broadcasted reports Crystal Webi to individual recipients using InfoView scheduling functionality
• Created roles/iViews in SAP portal for the users to access webi reports using single sign on
• Designed, built, maintained Business Objects universes and repository
• Created Dash boards, Key Performance Indicator scorecards using Crystal Xcelsius
• Troubleshot problems and customized reports according to the specifications of the user group
• Conducted info-sessions with end users on recurring basis to educate and communicate existing and new functionalities of Business Objects
• Performed efficient tuning of SQL source queries for data load and usage of stored procedures
• Used multiple join statements to retrieve data from multiple tables
• Created stored procedures, views, triggers, user defined functions to incorporate the flow of business and invoked various stored procedures

Environment: Business Objects 4i/5i, broadcast agent server, Web Intelligence, Informatica Power Center, Visual Basic 6.0, Oracle 8i, TOAD, Windows 2000 Server, MS Excel 2007, SQL Server 2005

Confidential

Business Intelligence Consultant

Confidential is an herbal company specializing in highly effective solutions to a whole range of common health concerns. The Project involved in the design and development of an Online Transaction System. This project consists of online Shopping Stores, Content Management, Customer Relationship Management CRM , content deployment, Product Search, Messaging, Online billing and Payment.

Responsibilities:

• Designed, developed and unit tested linked universes using Business Objects XI 3.1.
• Worked on universe security at different levels including row level and object level
• Worked in partnership with business users and performed data source analysis
• Participated in the development life cycle to ensure the projects are properly structured
• Verified the use of correct delivery process for the semantic layer and reporting environment
• Conformed deliverables are accurate and appropriately documented in appropriate dimensions
• Developed high-end interactive Web Intelligence XI 3.1 reports and documented all requirements and parameters
• Provided support, re-modeling and enhancement of existing Objects in BI.
• Responsible for requirement analysis, end user documentation, data extraction, data modeling, data loading and Reporting in Business Objects
• Troubleshot and managed enterprise reporting system used by organization
• Performed SQL query tuning to enhance query performance
• Worked on MS SQL Server tasks such as batch jobs, BCP, DTS linked servers and indexes.
• Designed, developed and maintained report updates
• Tasks involved decision-making, manual approval and exceptional report handling
• Responsible for unit testing of reports to confirm results in development and test environment
• Performed data quality validations and monitored integrity of data via test scripts

Environment: Business Objects XI 3.1, Broadcast agent server, Web Intelligence, Informatica Power Center, Visual Basic 6.0, HTML, SQL Server2000, Oracle 8i, Windows NT.

Confidential

Portfolio Manager

Responsibilities:

• Performed portfolio rebalancing and trade execution for Regents portfolio
• Generated investment ideas through fundamental equity analysis and quantitative screening
• Looked at the investment policy statement, portfolio objectives, constraints, benchmarks and reports
• Identified trends and sectors that will outperform the overall market
• Developed Comprehensive reports, abstract and charts to guide investment strategies
• Provided stock market data analysis, daily market reports and weekly performance evaluation/attribution, analysis economic, industry, company
• Performed stock price valuations and provided weekly, monthly buy, sell or hold recommendations
• Examined the optimization of investment returns subject to risks and market conditions
• Provided analysis of securities, survey of information available, market behavior, price movements, risk/return diversification and security selection

Confidential

System Administrator

Responsibilities:

• Created user accounts and assigned permissions to access resources using Windows Active Directory
• Managed Windows 2003 domain server with 45 clients for day to day and administrative working
• Responsible for monitoring and maintenance of users accounts, resource management, email servers, print servers, security, data integrity, backups and updates
• Provided LAN/WLAN installation/administration/support Windows 2003 servers
• Installation and configuration of switches, u rack, Rack Servers, jack pointing and I/O Boxes
• Maintained a disaster recovery plan by documenting current system configuration, meeting schedule, allocating equipment and vendor procedures
• Established and implemented monitoring procedures by establishing a baseline and benchmarking against organization metrics for security audits
• Generated security monitoring procedure, implement scripts for auditing/verifying the system