SUMMARY

• Around 6+ years of experience in the field of Information Technology with an emphasis on Business Intelligence concepts like data reporting, data analysis, design & development.
• Have experience in SAP Business Objects Products (XIR2/4.0), Web Intelligence, Crystal Reports.
• Have experience in creating data visualizations using Tableau.
• Have good communication, interpersonal & presentation skills.
• A strong team player with a proven ability to deliver organizational improvements supporting business objectives and streamline procedures across the enterprise.
• Expertise in Requirement Gathering, Analysis, Design and Maintenance of the system.
• Created Master Test plans and participated in all the aspects of UAT Testing.
• Expertise in writing Business Requirements Document (BRD), System Requirement Document (SRD).
• Results driven Analyst and a strong team player with a proven ability to deliver organizational improvements supporting business objectives and streamline procedures across the enterprise.
• Exceptional ability to manage multicultural staff and skilled to prioritize and execute tasks in a high - pressure environment.
• Have good analytical and problem solving skills.
• Good knowledge of Data modeling (Star schema & Snowflake schema), Data Warehousing and Business Intelligence Concepts with emphasis on ETL and Data Warehouse.
• Experience in RDMS using Oracle, SQL Server, Teradata & MS Access.
• Strong experience with Microsoft Office Suite (MS Word, Excel, Power Point).

TECHNICAL SKILLS

BI/OLAP Tools: Business Objects XIR2/3.1/ 4.1, Crystal Reports

Languages: C, Java

Packages: Microsoft Office Suite (MS Word, Excel, PowerPoint), Sharepoint, HP ALM

Operating Systems: Windows 2000/98/95/98 , Windows NT, MS DOS

RDBMS: Oracle 9i, SQL SERVER, Teradata,MS Access.

PROFESSIONAL EXPERIENCE

Confidential, Richmond VA

BI Developer

Responsibilities:

• Worked collaboratively with development and business teams to identify and define requirements for Business Objects software application and day-to-day management of assigned project plans, schedules and test requirements as it relates to Business Objects and/or user reporting needs
• Involved in creating new Universes.
• Updated the existing Universe based on the reporting needs.
• Extensive reporting was done using Business Objects functionality's like Drill Down, Cross Tab, Master Detail.
• Created dashboards using Tableau Dashboard and user stories to create compelling dashboards to deliver actionable insights.
• Created dashboard using parameters, sets, groups and calculations.
• Involved in creating interactive dashboard and applied actions (filter, highlight and URL) to dashboard.
• Involved in creating calculated fields, mapping and hierarchies.
• Involved in performing Data Analysis, writing SQL Queries for Testing and Troubleshooting against Data Warehouse.
• Created Webi reports based on the business requirements.
• Responsible for meetings with QA and PROD team members to identify problems, resolve issues and to improve the process to ensure a stable and accurate solution
• Worked in an Agile methodology, attended the daily Scrum status meeting & provided the updates and uploaded the documents in Team Forge.

Environment: Business Objects XI 4.1,Teradata, Tableau 8.2

Confidential, Houston, TX

BI Developer

Responsibilities:

• Created Web Intelligence reports based on the user requirements.
• Created both Full Client (Desktop) and Thin Client (Web Intelligence) reports based on the user requirement using the Business Object reporting tool.
• Created complex formulae’s, variables, classes, user and measure objects.
• Extensive reporting was done using Business Objects functionality's like slice and Dice, Drill Down, Cross Tab, Master Detail, Alerters
• Accessed corporate data Using Live Office and Query as Web Service (QaaWS) used them extensively to create visually rich Xcelsius dashboards.
• Developed complex interactive/dynamic dashboards with Xcelsius and implemented prompts, drill down capability and Applied alerts.
• Created different types of reports such as Master/Detail Cross Tab & Charts.
• Created & modified existing Universes to meet the business needs.
• Responsible for meetings with QA and IT team members to identify problems, resolve issues and to improve the process to ensure a stable and accurate solution.
• Responsible to write the SQL queries and test the report data accuracy.

Environment: Business Objects 3.1, Crystal Reports, BO Designer, Oracle

Confidential, GEORGIA

BI Developer

Responsibilities:

• Involved in designing, developing and testing of the Universe.
• Designed and created reports based on the business requirements.
• Interacted with Project Manager and other resources in understanding the requirements and writing universe, report specifications.
• Worked very closely with other developers for their SQL requirements, with Business Analyst and end users to understand the report requirements.
• Created Universe for ad-hoc and canned reports based on the relational data model and exported to repository.
• Developed Business Objects Universes with classes, objects and condition objects and different level of hierarchies to support drill down functionality in the reports
• Used aliases & contexts to resolve the loops while designing the Universe.
• Implemented aggregate awareness for the better performance of the query.
• Implemented various @functions like @Prompt, Select and @Where Confidential the Universe level.
• Implemented Object level security in Universe to in corporate security Confidential Business level.
• Worked in an Agile methodology and attended the daily Scrum status meetings

Environment: Business Objects 4.0, IDT, Web intelligence, Oracle, PL/SQL

Confidential, Georgia

BO Developer

Responsibilities:

• Worked collaboratively with development and business teams to identify and define requirements and day-to-day management of assigned project plans, schedules and test requirements as it relates to reporting needs.
• Support existing Data Warehouse reporting platform and applications to ensure operational availability and scalability.
• Created Ad-hoc reports by gathering specific requirements from the different users.
• Generated different kinds of Pass-Through Functions and used for time filters like current month and previous year etc.
• Worked closely with all aspects of the Business Intelligence group in order to deliver the required solutions in a timely manner.
• Created the Web Intelligence reports using the BI Launch pad using Universes as the data providers.
• Involved in performing Data Analysis, writing SQL Queries for Testing and Troubleshooting against Data Warehouse.
• Involved in documenting the Business required documents & Unit test documents.
• Provided training to the Super users about the functionality & the interface of the reporting tool.

Environment: Business Objects XI R2, BO Designer, Oracle, SQL

Confidential, ILLIONIS

Business Objects Developer

Responsibilities:

• Analyzed, designed, built and tested reports while working directly with end-users and technical members of a data warehouse team.
• Formatted the Reports to meet the user requirements using Multi-Dimensional Analysis like Drill Down.
• Worked on Web Intelligence to develop and publish thin client reports. and incompatibility between the objects to make sure users can build their own reports
• Developed test-case scenarios, test plans and conducted user acceptance testing & training
• Created reports using Crystal Reports with Grouping, Sorting, Formula fields and Parameter fields.
• Performing Data Analysis, writing SQL Queries for Testing and Troubleshooting against Data Warehouse.
• Responsible for production support services and project development and implementations relative to Business Objects application
• Trained the users to use the tool and create Ad-hoc business objects reports.
• Provided end user training for basic and advanced reporting skills like how to use templates and explained the hierarchy levels.

Environment: Business Objects XI R2, BO Designer XI R2, Oracle