• 17 years of experience in Information Management, developing end-to-end Data Warehousing Applications, Business Intelligence, Data Integration & Migration Systems. Involved in Developing Data Warehouse roadmap, strategy and architecture, enterprise data warehouse, ODS, MDM, Dimensional Data Marts and BI reports. I have also worked on creating interfaces for Oracle Applications. • Good Experience in designing and implementing a Data Warehouse System. • Good experience in Business Analysis, preparing functional and technical design documents and Data Modeling using Designer 2000, Erwin and Rational Rose. • Familiarity of ETL process and OBIEE reports. • Good knowledge of Network concepts configuring ports and integrating legacy systems to implement and support Data Warehouse and Web applications. • Good experience in Developing PL/SQL programs, Performance Tuning, Monitoring and Supporting Production environments. • Specialized in Database Concepts and Oracle Products. (Oracle 7.x, 8i, 9i, 10g, 11g Architecture) • Extensive experience dealing with Order Entry, Manufacturing, Enterprise Asset Management, Insurance, Financial systems and Data Migration Projects. • Very strong in developing Unix shell scripts using AWK and SED for data handling and writing batch programs. Database : ORACLE (11g, 10g, 9i, 8i, 7.x, 6.x) – SQL *PLUS, PL/SQL (8.x, 2.x), SQLJ, C, PRO *C (ver. 2.x, , Oracle Applications 10.7/R12, DB2, Teradata Database Utilities : SQL *Loader, SQL *Net (version 8, 2.x, 1.x), Export/Import, DbDebugger, Toad, Sql Navigator, Oracle Discoverer, Server Manager, SQL *DBA, Sql Tuning using Sql Trace, Hints, TKPROF and Explain Plan. DWH Tools : Informatica v4.5 to 9.x, Datastage 7.x/8.x, Hyperion MDM 9.x, Talend MDM 5.x, Informatica MDM, OWB 9g/10g/11g, SSIS BI Tools : OBIEE 10g/11g, Microstrategy 9.x, Cognos 7.x/8.x, SSRS Operating Systems : UNIX (Solaris, Sun OS, SCO Open Server, AT&T, AIX) WINDOWS Server 2008 / 2012 and WINDOWS7 /8.1 Languages : C, C++, Java, MF COBOL, Perl Front End Tools : Developer 2000(Forms 5.0, 4.5, Reports (3.0, 2.5) Networking : TCP/IP, ODBC, JDBC, TELNET, and FTP Scripts : Unix Shell (Bourne, Korn) – Shell scripts using AWK and SED Web Platform : Oracle Web Server, HTML, XML, Java Servlets, EJB, JSP, ASP, .NET, JDBC, Wiki, Share Point Data modeling Tools : ER-win, Silverun, Designer 2000 Test Tools : Silk, Load Runner, Win Runner, Data Quality Centre Version Control Tools : MKS, PVCS, Clear case, Serena ChangeMan Dimensions.
* Click the button to send an offerSend offer