SUMMARY

• Over seven years of IT experience in Business Intelligence and Data warehousing applications.
• Experience in all phases of Software Development Life Cycle (SDLC)
• Extensive experience with Data Services, Data Integrator, Data Services Management Console, BO Designer, Infoview, Web Intelligence Rich Client, Import Wizard.
• Well versed in preparing the Requirement Specification document based on the understanding of given Business Specification document.
• Expertise in preparing Mapping documents, Report Specifications, Database Designs to support ETL and reporting requirements.
• Expertise in Extraction of Source Data, Data profiling, and Transforming data from different data sources to a data warehouse
• Experience in Performance Tuning of the ETL process and Data Warehouse Testing
• Extensive experience with Data Integrator, Data Quality and Platform transforms
• Excellent experience in implementing Dimensional Modeling Techniques like star-schema, snow flake schema
• Experience in building Universes, retrieving data using Universes and Personal Data Files, Stored Procedures and Free Hand SQL methods and creating Ad-Hoc reports using Business Objects & Web Intelligence Tools.
• Successfully generated reports using BO reporting functionalities such as Master Detailed, Slice and Dice, and Drilling methodology, Filters, Ranking, Sections, Graphs and Breaks. Also extensively worked with Crystal Reports for creating complicated reports that includes sub-reports, parameter based reports, formula based, well-formatted reports, and analysis reports.
• Linked reports using Open Document syntax to link master report to a detail report by creating hyperlink objects in the universes and reports
• Developed Reports, Sub Reports, custom prompts and formatted the same with respect to the requirements
• Excellent administration skills to manage the environment, server, users, groups and security setup for BOE/DS/DI/DQ tools.
• Strong database concepts with experience in using Oracle, SQL Server, Teradata and MS Access
• Strong understanding of kalido DIW, BIM model and BODS Integration to SAP Hana
• Proficiency in working with PL/SQL stored procedures, packages, and triggers.
• Excellent understanding of Agile and Waterfall implementation approach
• Experience in diverse domains including Financial, Sales, Insurance, Pharmaceuticals, Healthcare and Telecommunications.
• Excellent teaming and Interpersonal skills, leadership qualities, detail oriented, innovative, self- motivated and quick learner.

TECHNICAL SKILLS

• OLAP Tools: BO XI 3.2/BO XI 3.1/BO XI R2/6.x Web Intelligence Rich Client, Info View, Import Wizard, CMC, Designer, Desk I, Web I, Crystal Reports 2008, Xcelsius.
• ETL: Data Services, Data Integrator, Informatica
• Databases: Oracle 10g/9i/8i, Teradata, Sybase, DB2, MS SQL Server 2005/2008, Access
• Operating Systems: Windows XP/2000/2003/NT, UNIX, AIX
• Programming: SQL, PL/SQL, Transact SQL, C, C++,
• Other Tools: SQL Developer, SS Management Studio, SQL*Plus, TOAD, Excel, Word, Tidal

PROFESSIONAL EXPERIENCE

Confidential, IN Jun 11- present
Position: Business Objects Data Services Consultant

Responsibilities:

• Worked closely with Bank\'s Enterprise Reporting team and Business Analyst to translate functional specifications to technical design.
• Attended project planning and sprint sessions and assisted identifying the critical paths and dependencies
• Attended the Agile/scrum meeting sessions
• Worked on multiple projects assisting in different phases of development life cycle
• Responsible for creating the ETL mappings and high level technical design documents
• Administering and maintaining BO Data Services management console and repository management.
• Extensively used BODS Designer to migrate from heterogeneous source systems including Oracle, SQL Server, Teradata, and flat files
• Created XSD structure for XML output in Data Services
• Worked with Data Integrator and Platform transforms for implementing CDC and developing ETL jobs creating datamarts
• Developed ETL jobs by calling Stored functions/Procedures in Data Services
• Used custom SQL inside SQL transform and database functions
• Performed Debugging using breakpoints, trace, monitor, error logs and debug mode
• Used Aggregate, String, Database and Lookup functions to implement required business requirement
• Created Data Services/Data Quality workflow to clean and standardize names and address using USA and multi plug-in address transforms
• Responsible for writing and executing the test cases for ETL Validation
• Performed the Unit testing, Regression Testing and Integration Testing for the new ETL code
• Identified the dependencies and designed the workflows to run in parallel to enhance the performance of the job
• Scheduled ETL jobs using Data Services scheduler and Tidal Web Client
• Worked on performance tuning techniques by identifying the bottle necks
• Worked with QA for data reconciliation by identifying the data discrepancies
• Created the DDL scripts and migration documents for deploying in Test and Prod environments
• Created Tickets and Work orders for the issues and new code deployment
• Provided support for troubleshooting and resolving issues for data anomalies or technical issues
• Created Web I reports with multiple data providers and synchronized the data using merge dimension option in BO XIR3.
• Created reports using Business Objects functionalities such as Drill down reporting, Slice/Dice, Master Detail reporting using Hyperlinks, Alerter, Sorting, Ranking, Breaks, Sections, Cross tabs, complex Formulae, etc.
• Developed complex reports using combinational charts, graphs, Pie charts Etc.
• Worked on SQL performance tuning to fix slow running reports.
• Tested business objects reports for data validation and compared results and query run time in bank-end i.e., Teradata SQL Assistant and Business Objects.
• Conducted training sessions to get business users familiar with Business Objects
• Supported end users during UAT phase and worked on tracking fixing the bugs during this phase

Environment: BOBI 4.0, BOXI 3.2, Business Objects XI 3.1, SQL Server 2008/2005, Oracle 10g/9i, Terradata, Tidal Web Client

Confidential, NJ Sep 10 - Sep 11
Position: Sr.BO/BODS Developer

Responsibilities:

• Involved in gathering business requirements, functional requirements and data specification.
• Involved in Creation of jobs that specify data mappings and transformations by using Data Integrator Designer.
• Responsible for setting up Development, Test and Production Environment by additionally setting up a central repository, and also migrating reusable objects( Jobs, Workflow, Dataflow) from central repository to test environment.
• Creation of ETL Processes for the added new subject areas and developed data extraction, transformation and loading program using Data Services.
• Worked on Data Migration from SAP ECC to Oracle
• Created ETL jobs to extract from SAP ECC to BW using Data Services
• Involved in the Data Migration from heterogeneous data source.
• Involved in scheduling and running batch jobs on time using Data Services Management Console.
• Created Users, Access Server, Central Repository between different environments using Data Services Management Console.
• Involved in writing scripts and also used some built-in functions like to date, lookup, key generation and custom functions like checking whether the load is an initial load or a bulk load.
• Used BOBJ Data Services cleansing transformations for de-duplication, house-holding and address parsing
• Integrated Data Quality jobs with DI job for data leasing and standardizing
• Scheduled, monitored and fixed the errors of the jobs.
• Performed tuning at source, transformation, and target levels.
• Extensively worked on CMC (Central Management Console) in maintaining objects, Universes, Connections, Resources, Users, User Groups and Categories in Business Objects XI.
• Used Designer Module to implement Universe, Joining the Tables, Create Prompts and queries, parsing the Objects, linking universes, apply Contexts and Alias Tables to remove Loops and Traps.
• Created Custom LOV's (List of Values) and Custom Hierarchies for drilling down Reports.
• Used various @Functions like @Prompt (for user defined queries), @Where (For creating conditional filters), and @Select.
• Applied security features of Business Objects like report level & object level security in the Universe so as to make the sensitive data secure.
• Created and maintained complex DESKI, WEBI and Rich client reports.
• Worked on SQL performance tuning to fix slow running reports.
• Created Web I reports with multiple data providers and synchronized the data using merge dimension option in BO XIR2.
• Exported Reports to schedule, monitor, and publish the reports.
• Created reports using Business Objects functionalities such as Drill down reporting, Slice/Dice, Master Detail reporting, sorting, etc.
• Supported end users during UAT phase. Worked on tracking fixing the bugs during this phase
• Provided 24/7 support lead for Business Objects from installation to production environment.

Environment: BO 3.1/XIR2, Designer, Web Intelligence Rich Client, Xcelsius 2008, Crystal 2008, Data Services,SAP ECC, SAP BW, Windows 2008/2003 Server, Oracle 10g, SQL Server2005, Toad.

Confidential, TX Mar 09 to Aug 10
Position: Sr. BOBJ/BODI Developer

Responsibilities:

• Worked with business users to define and analyze problems, create conceptual and logical data model, implement physical data model, and considers the implications of business solutions to the current and future environment; effort estimation for change requests.
• Involved in database design, implemented the ETL processes and jobs using Data Integrator.
• Monitor all aspects of organizational business engagements, both internal as well external, to ensure that the interfaces are developed and delivered to meet ETL standards and best practices
• Created ETL Jobs in BODI to load monthly, weekly, daily data, to track issues and resolve them based on the priority.
• Extracted the data using BODI from the flat files and other RDBMS databases like SQL Server and Oracle into staging area and populated onto Data Warehouse.
• Collaborated with Database Administrators, Developers, and Analysts on all aspects of data management.
• Used error handling strategy for trapping errors by defining error handling in all crucial steps of ETL transformations and sending errors to an error table.
• Monitor and troubleshoot batches and sessions for weekly and Monthly extracts from various data sources across all platforms to the target database.
• Involved in performance tuning at source, target, mappings, sessions, and system levels.
• Tested the data and data integrity among various sources and targets. Associated with Production support team in various performances related issues.
• Involved in Installation of all Components of Business Objects XI R2.
• Imported Users/Groups, documents (Web I and Desk I), Universe, Document, folders, categories and objects using Import Wizard.
• Involved in the design/development of Universes, Classes, Objects and Conditioned Objects for Business Analysis and Report Generation.
• Created Shortcut Joins and Aggregate tables in Universe Designer to improve the performance.
• Created the reports using Business Objects functionalities like Queries, Slice and Dice, Drill Down, Cross Tab, Master Detail and Formulae etc.
• Created Crystal reports using Business Views and Universes as data providers.
• Responsible for reviewing and analyzing reporting requirements and translating them as per the requirement.
• Developed Stored Procedures Using Oracle PL/SQL programming to improve the performance of the Reports using complex queries.
• Involved in User Acceptance Test (Universes and Reports) throughout the migration process.
• parameters, special fields, formulae and used multiple data sources to create the reports.
• Created Sub Reports and custom prompts in crystal
• Reports.
• Extensively work on scheduling and distributing the documents.
• Tested the reports and modified the relevant Objects in the Universe as per the user specifications.
• Involved in supporting end users in resolving issues related to Business Objects.

Environment: Business Objects XI R2 (CMS, CCM, CMC, Auditor, Web I, Desk I), Oracle 9i, DB2, SQL*PLUS , Windows 2003 Server, Xcelsius, UNIX, Crystal Reports XI/10/9.0.

Confidential, Overland Park, KS Oct 08 - Mar 09
Position: Business Objects Consultant
Responsibilities

• Created new groups, users and set access privileges for them with Business Objects Supervisor.
• Documented the creation and maintenance of the Business Objects Universe/Reports and Standard Operating Procedures.
• Created Cardinalities, Contexts, Joins and Aliases for resolving Loops.
• Checked the Integrity of the Universes.
• Created Reports using universe, stored procedure, freehand SQL as the Data providers and writing the complex queries including Sub Queries, Unions, Intersect and Aliases.
• Created User Prompts, Conditions and Filters to restrict the data as per the specifications.
• Created the reports using Business Objects functionalities like Queries, Slice and Dice, @Functions, Cross Tab, Master Detail and Formula etc.
• Created Alerts and Implemented Ranking in the reports to highlight critical data.
• Created Master Detail and Cross Tab reports to view the data in an analyzed way.
• Defined Customized Sorts in Universes and Reports Level.
• Created Reports using grouping, sorting, totaling, charts etc., and exported reports into various formats like PDF, txt, xml.
• Resolved Year Ago Variance Calculation, Percentage Calculation in Cross Tab in Web I.
• Automated document Scheduling, Publishing and Distribution for WebI and Info View clients, using the Broadcast Agent for Web-Part Reports.
• Involved in resolving issues relating to pre implementation of Reports
• Created reports using Crystal Reports with Standard, Summary, Cross Tabs, SQL, Command Objects, Selection Criteria, grouping, sub reports etc.
• Developed Crystal Reports for Invoices, Notices and Mailing labels.
• Created parameterized dashboard reports (these reports show information from highest level by company and can be drill-down to single product using hyperlinks and drill-down technique), cross-tab, conditional, Top N, Summary, Form, OLAP reports and Sub reports.

Environment: Business Objects 6.5.1(Supervisor, Designer, Reporter), Web Intelligence, BCA, ZABO, Info View, Oracle9i, MS SQL Server 2000, MS Access 200 Windows 2000 Server, Unix, Sun Solaris.

Confidential, Richardson, TX Jan 08 - Sep 08
Position: Business Objects/Crystal Developer

Responsibilities:

• As a part of Universe designer team, created Semantic Layer, went through the two different levels of Database.
• Designed, developed complex Universes with multiple Fact Tables , several hundreds ofobjects as per the Universe design, Joins, Resolving Traps and Loops, @functions, specified hierarchies using Business Objects Developer Suite to perform various tasks specific to every component Experience in Publishing, Scheduling the Documents and setting privileges to the users.
• Developed Universe using Designer module, established users, user groups and assigned user privileges.
• Expert in testing the created reports and modified the relevant Objects in the Universe.
• Created Reports in Web-Intelligence XI R3.1 SP2 using complex functions and supported the deployment of Universes and Reports.
• Designed and developed complex universes with multiple Fact Tables and several hundreds ofobjects as per the Universe design best practices.
• Created Ad-hoc reports using Webi, Deski and Crystal Reports on a daily, weekly and monthly bases as per the user requirements
• Created Cardinalities, Contexts, Joins and Aliases for resolving Loops and checked the Integrity of the Universes.
• Organized data in reports by using filters, sorting, ranking and highlighted data with Alerts.
• Created many reports like daily, monthly, yearly Sales report and Space Management reports by product groups.
• Designed and developed technical user documentation and involved in end user training and support.
• Exported the universes to the Repository to making resources available to the users.

Environment: Business Objects 6.0, Universe Designer, Web Intelligence, Desktop Intelligence, Crystal reports, Infoview, Oracle 8.0 and SQL Server 2000.

Confidential, India Jan 05-Nov 07
Position: Business Objects/Crystal Reports Developer
The application enabled the project managers and team leads to track the status of the projects.

Responsibilities:

• Creating universe, testing the new and updated universes.
• Testing of the Universes and writing detailed test cases.
• Created Measure objects and Dimension objects, Detail Objects and applied Hierarchies based on Business logic.
• Developed Universes and creating Contexts and Aliases for resolving Loops in the Universes.
• Developed Business Objects reports using Business Objects full client.
• Developed different types of reports such as Master/Detail, Cross Tab and Chart (for Trend analysis).
• Developed Business Objects reports using calculations, variables, filters, conditions, breaks, sorting, drill down and slice and dice.
• Created complex reports using cascading prompts.
• Developed Business Objects reports connecting various data sources like Business Objects Universes, Excel spreadsheets.
• Involved in creating report templates for consistency in the look and feel of the reports.
• Exported Business Objects Universe and Reports to the BO Repository.
• Scheduled Business Objects reports using Broadcast Agent (BCA).
• Worked closely with Business analysts and database administrators.
• Worked on Toad to run SQL queries for validating Business Objects reports.

Environment: Business Objects 5x, Crystal Reports, C++, Oracle 8.x, PL/SQL, Toad 7.4.0.1, Visual Basic, MS Excel, MS Word, Oracle and SQL Server.

EDUCATION

• Bachelor of Engineering