• Around 9 years of extensive experience in Data warehousing and Data Analysis, design, development and Implementation of Business Intelligence solutions using Data Warehouse/Data Mart Design, ETL and Reporting on Windows and UNIX platforms. • Highly experienced in Oracle Business Intelligence Enterprise Edition (OBIEE)/Siebel Analytics, Oracle Discoverer (Desktop Edition, Plus Edition, Viewer Edition and Admin Edition of Versions 4i, 9i and 10g), BI Publisher (Formerly Known As XML Publisher). • Experience with ETL tools like Oracle data Integrator(ODI) and Informatica. • Expertise in debugging and optimizing the Business Objects/Oracle BI / Siebel Analytics Dashboards / Reports • Extensive knowledge on linking data from multiple sources, using functionalities like combined queries, drill down, and master detail using Business Objects. • Worked in financial, healthcare and banking domains. • Experience in setting up a Multi-User Development Environment (MUDE). • Designer and processing tasks using Workflow Manager to move data from multiple sources systems into targets. • Experience in complete Software Development Life cycle (SDLC) including Requirement, Analysis, estimations, Design, Construction, Unit and System Testing and implementation. • Used Type 1 SCD and Type 2 SCD mappings to update Slowly Changing Dimensions for accessing the full history of accounts and transaction information. • Hands on experience with Data Extraction, Transformation and Data Loading in Data Warehouse environment. • Experience in writing, testing and implementation of the PL/SQL triggers, stored procedures, functions, packages. • Strong experience in OBIEE 18.104.22.168/10.1.3.x, which includes design and development of OBIEE repositories at three levels (Physical Layer, Business Model and Presentation Layer). • Involved in Data Modeling techniques like normalization, denormalization, Star Schema/Snowflake modeling, Fact and Dimensions tables, Physical and logical data modeling. • Involved in the data analysis for source and target systems and good understanding of Data Warehousing concepts, staging tables, Dimensions, Facts and Star Schema. • Good understanding of ODI architecture and installation of Topology, Security Manager, agents, Designer, Operator, Master repository and Work repository. • Experience in integration of various data sources from Databases like MS Access, Oracle, DB2, SQL Server and formats like flat-files, CSV files, COBOL files, XML, DTD, XSD files, legacy system files etc. • Extensive work in ETL process consisting of data transformation, data sourcing, mapping, conversion and loading • Strong in Quality Assurance and debugging skills in ETL Process and hands on experience in troubleshooting and handling production support jobs. • Extensive experience in Documentation of Data Assessment, Data Mapping, Code Review, Test plan and operations. • Good knowledge on Agile Methodology and the scrum process TECHNICAL EXPERTISE ETL Tools ODI (Oracle Data Integrator), Informatica Power Center 9.1/8.x/7.x, Power Exchange. 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, Oracle Designer, MS Visio. DBMS Oracle 11g/10g/9i/8i, DB2, MS SQL Server 2005/2000, MS Access, Excel, Teradata (Fast-Load, Multi-Load, Fast Export, BTEQ), ODBC Programming Languages SQL, PL/SQL, Unix Shell scripting OLAP/Reporting Tools OBIEE 11x/10.1.3.x, Business Objects22.214.171.124, OBIA 7.9.x, Scheduler (iBots),Tableau. Operating Systems Windows XP/2008/2003/2000/NT/98/95, UNIX, LINUX Other tools VISIO, ERWIN, Control-M (Batch Scheduling), Toad 9.0/8.5.1, SQL *Loader, Putty, SQL Navigator 5.5.
* Click the button to send an offerSend offer