SYNOPSIS:

• Over 7 years of software experience in Business Objects (Designer, Reporter, Desktop Intelligence, Web Intelligence, Info View, Central Management Console), SSIS and System Testing.
• IT experience in Analysis, Design, Development and Implementation of Data Warehousing and other applications using Object Oriented Analysis, Design and Methodologies
• 7 years of Business Intelligence experience with complete life cycle Implementations using Business Objects 4.0/XIR3.1/XIR 2/ 6.5/6.1/6.0/5.1 (Supervisor, Designer, Info view, Business Objects Reporting Business, Xcelsius, Web - Intelligence).Good experience in SAP BI 4.0, Dashboard design 4.0, Information Design tool (IDT).
• 7 years of Extensive experience in Business Objects full client & thin client environment. Created complex reports by linking data from multiple sources, using functionalities like Combined Queries, Slice and Dice, Drill Down, Master Detail, etc. Used Stored Procedure Data Provider for frequently running tasks. Trained Users in report development and running ad-hoc queries in business objects. Tested business objects reports for data validation and compared results with TOAD.
• Well versed with the creation and execution of test scripts, test scenarios, System test cases, System Test plans and executing the Manual test cases in QA environment and production environment.
• Solid database experience on Oracle 11i/11G/10G/9i/8i/8.0/7.3, PL/SQL, SQL*Loader, Physical database design, Logical database design, Data Modeling, Gap Analysis, Data Mapping, Cleansing, Massaging, Transformations, Data Exports & Imports, Inbound/Outbound Interfaces, Application Support, Performance Tuning, Oracle Tuning & Optimization.
• Strong back-end programming experience using PL/SQL, SQL, Stored Procedures, Functions, Ref Cursors, Constraints, Triggers, Index, Bitmap Index, Views, Inline Views, Materialized Views, Database Links, Export/Import Utilities, Ad-hoc queries using SQL.
• Experience in Creating, Testing and Executing Data Integrator jobs using Data Integrator Designer to transfer data from source to target.
• Strong Knowledge in all phases of Software Development Life Cycle (SDLC) such as developing, testing, Migrating, Administrating, security management and production supporting on various platforms like Windows NT/2000/XP/98.
• Extensive experience in building and managing Universes, creating Complex, Ad-hoc Reports, Canned Reports, Charts using Business Objects.
• Expertise in using various data providers like Universes, Personal Data Files and SQL to generate reports.
• Experience in retrieving data, using Business Objects Universes, personal data files (MS Excel) and SQL methods and also validated data by writing SQL scripts.
• Collaborative team player with excellent interpersonal relationship.
• Quick learner and very effective communication, interpersonal skills and able to handle multiple tasks and projects simultaneously.
• Good Programming knowledge in SQL and tuning the performance of SQL queries.
• Experienced in interacting with business users to analyze the business process and requirements and transforming requirements into screens, designing Data Model in universe, documenting and rolling out the deliverable.
• Adapt quickly and efficiently in a dynamic business environment.
• Able to work on own initiative or as part of a team, backed by excellent organizational and communication skills along with the capability to solve problems as they arise.

TECHNICAL SKILLS:

Business Intelligence: Business Objects 4.2/4.1/XIR3.1/R2/XI/ 6.5/6.1/6.0/5.1 (CMC, Supervisor, Designer,Infoview,Web-Intelligence 6 .0/2.7/2.6/2.5 , XI, Designer, Application Foundation Dashboard Manager, Microstrategy,Tableau 9.3.

Business Analysis: Functional Requirements Gathering, User Interviews, Business Requirements Gathering, Process Flow Diagrams, Data Flow Diagrams, Data Analysis, Requirements Analysis, Design, Data Modeling, Data Architecture, Data Flow, Data Cleansing

Dimensional Data Modeling: Dimensional Data Modeling, Data Modeling, Star Join Schema Modeling, Snowflake Modeling, FACT and Dimensions Tables, Physical and Logical Data Modeling, ERWIN 4.5/4.0/3.5/3.2 , Oracle Designer, Visio and Sybase Power Designer.

Oracle: Oracle11i/11g/10g/9i/8i/8.x/7.x, Oracle Forms 4.5/5.0/6i, ORACLE ERP GL/OM/AP/AR, BAAN, Oracle Data Integrator, Data Exports & Imports, Inbound/Outbound Interfaces, Performance Tuning, Administration, Software Maintenance, User & Security Management, Query Optimization, Export/Import Utilities

ETL: Informatica Power Center 8.1/8.0/7.1.2 , Power Mart 6.2/5.1.1, Workflow Manager, Work flow Monitor, ETL, ETI, Data mart, OLAP, OLTP, Mapplet, Transformations, SQL*Plus, SQL*Loader

Databases: Oracle 10g/9i/8i/8.0/7.x, IBM DB2 UDB 8.0/7.0, MS SQL Server 2005/2000/7.0/6.0 , Teradata V2R5/V2R4/V2R3, Sybase 12.x/11.x, MS Access.

Programming: Unix Shell Scripting, Kernel Programming, Perl Programming, SQL, PL/SQL, SQL Plus, Transact SQL, ANSI SQL, VB, Java, C, C++

Environment: Sun Solaris 2.6/2.7, HP-UX 10.20/9.0, IBM AIX 4.2/4.3, MS DOS 6.22, Novell NetWare 4.11/3.61, Win 3.x/95/98, Win NT, Red Hat Linux, Sun-Ultra, Sun-Spark, Sun Classic, SCO Unix, HP9000, RS6000, Win 3.x/95/98, Win 2000, Win XP. MS-Dos

PROFESSIONAL EXPERIENCE:

Confidential, Washington, DC

Business Objects Developer/ Business Analyst

Responsibilities:

• Involved in modifying the existing Universes SLS & GL Analytics, LAI Engine Analytics and Exception Reports based on the work environments requirements.
• Analyzed and modified Management Analytic Reports, Disclosure Reports, Regulatory ReportsValidation Reports, Exception Reports, Control Reports and Semi - Canned Reports to create Ad-hoc Reports
• Interacted with the Users and Business Analysts to find the Reporting requirements.
• Worked on Loan Accounting project (LAI) to create and modify BI reports in WEBI.
• Analyzed the design of the project to provide the better design techniques for Data Model/Process flow for Business Intelligence needs based on requirements.
• Co-ordinated with ETL developers to better understand ETL mapping in Informatica for better throughput in oracle/Netezza DB s.
• Worked with Business Objects Developers to provide the design techniques to create and modify the Universe in IDT for WebI reports development.
• Reviewed the WebI reports/Universe and implemented the design changes and captured the time differences before and after and provided the metrics to higher management.
• Worked with SAP support on Various BOBJ limitations to come up with work around solutions.
• Mentored the Business users about the guide line to follow while creating the Ad-hoc reports so that the production system is not at risk by run-away queries.
• Created new Ad-hoc reports and defect fixes on existing BO reports.
• Assisted Business team by creating Ad-hoc reports and resolved issues for identical variances.
• Working to convert existing Spotfire reports to Tableau and Business Objects reports.
• Created and tested Microstrategy reports and Dashboards by working directly with business for requirement gathering and prototyping discussions.
• Provided the design changes to create the complex reports in single DB read for better performance/user experience.
• Analyzed and reviewed 68 canned /49 Semi-Canned WebI reports/3 Universes on daily basis while developing and suggested various changes to simplify and reduce the development time.
• Led the responsibilities to setup the Development/test/production environment for BOXI projects.
• Involved in production support and triage the issue for Semi-Canned reports.
• Created complex SQL queries for validating the Disclosure reports.
• Migrated the BO reports from lower environments to Production.
• Worked with L2/L3 team to create DCU tickets.
• Assisted and designed the process flow for developing the complex BOXI reports.
• Analyzed complex SQL queries of the derive table to create the report.
• Tuned the SQL for better performance using the Explain plan.

Environment: SAP Business Objects BI Platform 4.2 (Universe Design Tool, Information design Tool, Web Intelligence Rich Client, BI Lauch Pad), Oracle 11g,Netezza 7, MS Access,Windows 7 Enterprise, Microstrategy, Tableau 9.3, IBM Rational Clear Quest, Remedy, SVN, iCART, Rally.

Confidential, Rockville, MD

Sr. Business Objects Developer

Responsibilities:

• Worked for the project NARMS(National Antimicrobial Resistance Monitoring System ) and OSC EDSR(Office of Surveillance and Compliance Electronic Document Submission and Review) and created Ad - hoc and Canned reports for Release 1
• Interacted with Business Users and Managers in gathering business requirements.
• Analyze the reporting requirements with the business users and the QA team and come up with the technical specifications for the BO Reports.
• Fulfilled the business objects development needs for various applications and also performed the day to day tasks.
• Modified existing universes and implemented new universes according the reporting needs by detecting cardinalities, resolving traps and using contexts and also developed hierarchies and derived tables.
• Based on the requirement developed SQL queries for the Derived Tables in Universe and created reports.
• Developed complex WEBI reports using combined queries, merging dimensions, complex functions at the report level and complex filters to satisfy the end user requirement.
• Handled various tickets for business objects issues for the end users.
• Designed complex reports and created various objects using built-in functions (like prompt, select where, and aggregate),complex report level filters and contexts and complex SQL queries and joins involving case statements, some analytic functions like partition by.
• Gave demo to the end users over the newly developed WEBI reports.
• Involved in the designing and Building of Universes, Classes and objects.
• Set up Universe level conditions to restrict data based on report requirements.
• Developed and created classes with Dimension, Detail & Measure objects and Developed Custom hierarchies to support drill down reports.
• Created Derived tables in the Designer to enhance the capabilities and performance of the universe.
• Customized Universe level Prompts as per Functional Requirements.
• Check the integrity of the Universes and export the universes for making available to users.
• Created reports using Business Objects functionality's like Queries, Drill Down, Cross Tab, Master Detail and Formulae's.
• Created Standard Reports utilizing all the features on Web Intelligence like Optional Prompts, Functions and Alerters etc.
• Created Breaks, Filters at Different Levels of the reports and applied ranking in the WEBI reports.
• Extensively worked with formatting the reports according to the user requirements.
• Migrated reports from SAP BI 3.1 to SAP BI 4.0 on development environment.
• Completed Documentation, Recommendations and Best Practices after migrating reports from SAP BI 3.1 to SAP BI 4.0.
• Created, maintained and modified the business critical reports using the Web Intelligence.
• Performed smoke testing after the WEBI reports migrated to production.
• Followed standards of good practices of report development and maintenance of universes.

Environment: SAP Business Objects BI Platform 3.1, 4.0, 4.1 (Universe Design Tool, Information design Tool, Web Intelligence Rich Client, BI Lauch Pad), Oracle, MS Access, Windows 7 Enterprise, Jira

Confidential, Elkridge, MD

Business Objects/ETL Developer

Responsibilities:

• Worked with Business users to understand the data needs/expectations from new System.
• Coordinated with data modeling team in building the new data model which will serve the better needs for Business Objects Universe and Reports Development
• Created the database tables and loaded the data form legacy systems using SSIS by creating the necessary mapping.
• Scheduled the Jobs to run during night time to load the data on DW from OLTP.
• Created the Universes pointing to DW by defining the necessary ODBC connections.
• Defined table joins as per the data model while designing the universe and created user objects by using advance SQL functions.
• Created Various Filters/Aggregate Objects in Universe as per the report development needs.
• Created the Detail design/High level design documents for ETL/Universe/Reports development and reviewed them with Team before development.
• Created universe using Information Design tool by defining objects, classes and predefined filters.
• Converted the universe which is created in Universe Design Tool (.unv) to Information Design Tool(.unx)
• Worked on projects Child Support Enforcement Administration, Client Automated Resources and Eligibility Systems and Social Service Administration.
• Created various Reports like Monthly Compliance Report, Under Overpayment District Office Report, Check Extract Exception Report, Daily Manual Review Report, Monthly Report Statewide summary, Eligibility Report Statewide.
• Generated various Reports on Daily, Weekly, Monthly and Yearly basis.
• Extensively used Calculations, prompts, Alerters, Variables, Drill Down and Slice and Dice for creating Business Objects reports.
• Extensively used various techniques like Sectioning, Ranking, Filtering, Slice and Dice to develop the reports.
• Extensively used the Business objects Functionalities such as Master Detail, Breaks, Alerts, Merging common Dimensions, Cross Tab, Drill Down, Drill Up, Drill Through, Drill by and Formulas to develop the complex reports.
• Involved in creating Dashboard for CSEA and CARES.

Environment: SAP Business Objects BI Platform 4.0 (Universe Design Tool, Information design Tool, Web Intelligence Rich Client),Dashboard Design, Microsoft SQL Server Management Studio, Microsoft SQL Server Business Intelligence Development Studio, Microsoft visual studio 2008,IBM DB2, Windows 7 Enterprise, QTP 10.0

Confidential, Richmond

Senior Business Objects Developer/Quality Analyst

Responsibilities:

• Interacted with customer support regularly, in order to generate the reports required and to resolve the existing issues.
• Created Universes by defining connections and retrieving data from database.
• Created Aliases and Contexts for solving the Join Problems in Business Objects.
• Created New Classes and User Objects in designing the universes.
• Worked for the project Treasury Management and created Reports for Release 1,Release 2 and Release 3
• Created various Reports like Service Variance Report, Customer Variance Report, Account Type Mix Report and Waivers Report
• Created and modified the WebI Reports for various groups using the Universe as a main data provider.
• Analyze the Business Requirement Document, Functional Specification documents to prepare Test Cases based on the Test Plans and Use Cases.
• Involved in Black box, Smoke testing functional testing, integration testing, load testing, regression and System testing.
• Prepared test case to test the back end Database by retrieving the data for the tables using SQL Queries.
• Using Use Cases written test cases in Quality Center.
• Created custom reports like Gross Margin, Account Query, Aging, Balance Sheet, Income Statement, Bad Debt and Payment Reports in response to user needs. Some of these reports are extremely complicated and retrieve data from multiple data sources
• Created Charts to display summary data using universe as main data provider.
• Using PL/SQL, developed ETL scripts to extract the data from Legacy systems, Transfer the data in to staging database and Load the data in to target tables.
• Design of a Conceptual data model and Logical data models.

Environment: Business Objects XIR2/XIR3 (CMC, Oracle11g/10g/9i,PL/SQL, Quality Center, Designer, Desktop Intelligence, Web Intelligence and Info View), MS Access, Oracle, Toad, SQL, PL/SQL