Technical Lead Resume
SUMMARY:
- Over 8 years of experience in to Software Application Development
- Extensive experience in using Informatica Designer, Repository Manager, Repository Server Admin control, Workflow Manager and Workflow Monitor
- Experience in Installation, Configuration, and Administration of Informatica Server and Informatica Repository Server on Client/Server environment
- Oracle Business Intelligence Foundation Suite 11g certified - 1Z0-591
- Oracle Business Intelligence Cloud Service Specialist - Oracle BICS
- Boomi Integration Developer I certified
- Boomi Integration Developer II certified
- Experience in Installation, Configuration, and Administration of OBIEE 10g & 11g and BI Apps 7.9.6.0, 7.9.6.2 & 7.9.6.3
- Experience in Installation, Configuration, and Administration of OBIEE 12c
- Extensive experience working with OBIEE 10g & 11g Administration Tool
- Experience in defining and development of dimensions, fact tables, star schema, hierarchies, level based measures in Business modeling of OBIEE 10g/11g
- Experience in Object level & Data level security setup for users using repository objects in OBIEE 10g & 11g
- Experience in creating Web Catalog Objects (Dashboards, Pages, Reports, iBots, Agents) using OBIEE 10g/11g Web UI
- Extensive ETL designing, development & debugging experience using Informatica Power Center Designer Tools
- Extensive experience in Designing, Development & Monitoring of production interface jobs through Data Warehouse Administration Console (DAC)
- Involved in requirement analysis, design, development and implementation of Enterprise Data Warehouse
- Extensive experience in Data Warehousing development, defining ETL methodology and Dimensional Data Modeling
- Expertise in Database development skills using SQL, PL/SQL, stored procedures, functions, packages, and triggers
- Proficient using TOAD for Oracle, TOAD for SQL Server, SQL Server Management Studio, SQL Developer
TECHNICAL SKILLS:
Database Languages: SQL, PL/SQL, T-SQL
Databases: Oracle 11g R2, Oracle 12c, MS SQL Server 2008, MySQL
Database Tools: TOAD, SQL Developer, SQL Server Management Studio
Reporting Tools: OBIEE 10g/11g, OBIEE 12c, Oracle BICS, Endeca, Qlikview
OBIEE Components: OBIEE 10g/11g Administration tool, Dashboards, Reports, iBots(10g), Agents(11g), BI Publisher (11g)
ETL Tools: Informatica PowerCenter 8.x, 9.x, MS SSIS, ODI, Clover ETL
ETL schedulers: Datawarehouse Administration Console (DAC), Informatica Scheduler
Programming languages: C, C++, Java, MATLAB, VC++
Scripting languages: Perl, Python
Computing platforms: Linux/Unix, Cygwin, Windows Server 2003, 2008
Web programming: HTML, PHP, CSS
Performance Tool: HP LoadRunner 11
GUI design toolkits: Java AWT/Swing
PROFESSIONAL EXPERIENCE:
Confidential
Technical Lead
Responsibilities:
- Assist team in gathering business requirements
- Perform source system discovery and data analysis
- Create high-level and low-level design documents including entity relationship diagrams
- Design relational and dimensional enterprise BI data models
- Develop and test Informatica Mappings and optimize them
- Move ETLs from lower to production environments
- Develop and test PL/SQL code on Oracle database
- Lead the offshore (India) Informatica ETL and OBIEE development team
- Develop OBIEE 11g repository and build Reports/Dashboards/iBots/Agents for users
- Do OBIEE Administration - Security, Configuration, and Maintenance (manages web catalog objects, archive/unarchive, set permissions and ownership, start/stop server, deploy RPD, etc.)
- Design Physical, Business Model and Presentation layers; define logical views and physical data Security structures
- Create and Support following Subject Areas/Analysis in OBIEE 10g/11g: