We provide IT Staff Augmentation Services!

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:

Hire Now