· Business Objects Data Services Developer/Admin in the Design, Modeling, Development and Testing of Data warehouse housing and other applications using Object Oriented Analysis, Design and Methodologies.
· Expert in Data Extraction, Transforming and Loading (ETL) using Business Objects Data Integrator XI (BODI), Data-services xi3.2, 4.0(BODS)
· Worked in multiple responsibilities including ETL architecture, ETL design, analysis and development, writing technical specifications.
· Knowledge in Planning, Designing, Developing and Deploying Data warehouses / Data Marts with experience of both relational & multidimensional database design using Data Modeling tool Erwin (Physical and Logical data models).
· Strong Exposure to SQL, PL/SQL, RDBMS, Oracle 8i/9i/10g and MS SQL Server 2005.
· Knowledge in architecture design of Extraction, Transformation & Loading environment using Informatica Power Martand Power Center and Data Integrator.
· Created projects, batch jobs, Real time jobs, work flows and data flows.
· Creating Users, Installing client software on local machines, Creating Profile server, Configuring Web administrators, creating users to monitor Jobs on CMC of ETL tool BO Data Integrator.
· Worked on the DI scripting for different functionalities, including FTP the files to the exchange servers etc.
· Tested data flows and scripts against sample data and real data.
· Possess leadership qualities of leading the team, motivating and inspiring the team by recognizing the work by giving appreciations.
· Experience using SQL*PLUS, SQL*Loader, TOAD, DTS packages, PL/SQL , Developer 6i, VB6.0
· Extensively utilized Business intelligence Reporting Tools such as Business Objects XI 3.1,Business Objects XI R1/R2,Performance Management XI R2, Business Objects 5.X/6.X, Crystal Reports XI/10/9 and Seagate Info 7.5
· Knowledge in architecture design of Extraction, Transformation & Loading environment using Informatica Power Mart and Power Center and Data Integrator.
· Worked with End-To-End implementation with Data warehousing team and Strong understanding of Data warehouse concepts Star Schema, Snowflake Schemas and Multi-Dimensional Models for query and analysis requirements.
· Extensive experience in developing strategies for Extraction, Transformation, Loading (ETL) data from various sources into Data Warehouse and Data Marts using Accentual Data stage (Manager, Designer and Director)
· BI Tools: Business Objects XI 3.1, R1/R2/R3/, Web-Intelligence, Crystal Reports
· ETL Tools: BODI Data Integrator (ETL),BODS Xi3.2,4.0, Informatica 8.6 PowerCenter,
· Platforms: Windows, UNIX, LINUX, Web Sphere, Apache/Tomcat.
· Databases: Oracle 11g/10g/9i/ 8i/7.3, MS SQL Server 2000/7.0/6.5, Access, DB2.
· Languages: C, SQL, PL/SQL, MS.NET