We provide IT Staff Augmentation Services!

Data Architect/lead Resume

Fort Worth, TexaS

PROFESSIONAL SUMMARY:

  • Over 8 years of experience in IT Industry and 7 yrs. in ETL and Business Intelligence Applications/OBIA/BI Apps using Oracle Business Intelligence (OBIEE).
  • Experienced in Full Systems Development Life - Cycle Implementation of Various Oracle/ETL /OBIEE Projects.
  • Experience in Installation, Configuration, Upgrade, Migration and Administration of OBIEE, Oracle BI Apps, Informatica Power Center.
  • Proven experience in implementing complete software life cycle involving various phases of design, development and implementation of Data Warehouses & Data marts with OLAP Tools
  • Expertise in Data Modeling (design, analyze and implement) conceptual, logical and physical data model, Data conversion and Data integration specialization in the area of Data Warehouse and Business Intelligence.
  • Experience in OBIEE/BI Apps OBIA with Loyalty Analytics, Sales Analytics
  • High proficiency in SQL and relations Database, hands on in SQL developer and Toad.
  • Proven Experience in Software development cycle (SDLC), Design documentation, Unit/Functional testing.
  • Proven experience in Agile Project Management and Defect tracking tool Jira.
  • Good domain knowledge & experience in Business Intelligence & Data Warehousing in CRM based Applications.
  • Expertise in Oracle DAC installation and configuration, Tasks creation, synchronization, and execution.
  • Extensive BI and Data warehousing experience using reporting Solutions and Informatica PC 9.0.1, 8.1/7.x/6.x.
  • Have experience in managing and provide direction for the onshore & offshore teams in support of development activities.
  • Highly competent in Analysis, Design & Development phases.
  • Analyze business requirements and translate them into functional and technical design specifications and implementation plans.
  • Experience in different Analytics Reporting tools OBIEE and Tableau.
  • Worked on QA Activities and UAT to ensure the readiness of the applications.
  • Good team player with excellent communication, written and presentation skills with strong aptitude to learn new technologies.
  • Experience in translating user requirements into functional, technical and system specifications, managing clients/ vendors/ partners relationships, ensuring service delivery and tracking requests for system enhancements, improvements from end-users /customers.

TECHNICAL SKILLS:

Business Intelligence: OBIEE 10.1.3.2/ 10.1.3.3/ 10.1.3.4/ 10.1.3.4.1, 11G, DAC, DAC 7.9.4 / 7.9.6 / 7.9.6.1 / 7.9.6.2/ 10.1.3.4.1 .

ETL Tools: Informatica Power Center 8.6.1/ Informatica Power Center 9.0.1/ Informatica Power Center 9.6.1/Informatica Cloud

Agile Methodology Tool: Rally

Defect Tracking Tool: Jira

Siebel Applications: Siebel7.X/8.0,Siebel Call Center

Utilities: MS Office Suite (Word, Excel, PowerPoint,Visio)

CRM Verticals: Siebel eSales, Siebel e-Pharma, Siebel CallCenter,Microsoft Dynamics CRM

Operating System: Windows 95/98/2000/XP, UNIX, AIX OS, MS-DOS

DBMS: Oracle 10g, Oracle 11g, IBM DB2, SQL Server

Version Control Tools: Clear case, Visual Source Safe

Siebel Analytics: Siebel analytics 7.7 / 7.8

PROFESSIONAL EXPERIENCE:

Confidential, Fort Worth, Texas

Data Architect/Lead

Responsibilities:

  • Lead an OBIEE configuration team or development team, ensuring design, development and testing work is completed to standard and on time.
  • Designing and maintaining technical and functional documents for Oracle Loyalty application
  • Configured Oracle BI Applications Informatica, DAC and OBIEE, implemented Oracle out of the box Prebuilt Loyalty analytics Apps.
  • Captured and documented Management Information/Business Intelligence requirements from clients, via interviews or workshops, ensuring suitable balance of business needs and delivery feasibility.
  • Managing/coordinating on-shore and off-shore OBIEE Development Teams.
  • Hands on OBIEE (10g/11g/12c) to generate genuine reports for the stake holders.
  • Worked on OBIEE upgrade from OBIEE10g Application to OBIEE11g and then to OBIEE 12c.
  • Involved in business meetings and working closely with the business analysts to gather user requirements and did thorough Data Analysis.
  • Worked on migration, deployment and performance tuning of repositories.
  • Developing the ETL /OBIEE Report detail design documents for each target tables(Fact and dimension tables)/workflows/Reports
  • Interacting with the business analysts to get the business Requirements, reporting needs and creating Business Requirement Document.
  • Highly professional in SQL and Informatica PC to populate data to Oracle System, performed performance tuning.
  • Created the metadata in OBIEE RPD for reporting purpose.
  • Development of Dashboards and Reports for different Business groups
  • Developed Mappings, Sessions, Workflows and Shell Scripts to extract, validate, and transform data according to the business rules.
  • Performed Unit/System Testing, worked with users for UAT and done Performance tuning according the users feed back

Technologies Used: OBIEE 10.1.3.4.1, OBIEE 11.1.1.9.0, OBIEE 12.2.1.1.0, Informatica Power Center 9.0.1/ Informatica Power Center 9.6.1, Informatica cloud,BI Apps 10g/11g/12c Loyalty

Confidential, Texas

ETL Developer/Lead

Responsibilities:

  • Involved in R&D, model, design and Develop the process to setup dependency between Informatica Power Center (In-house) and Informatica Cloud process.
  • Designed Mapping Specifications based on the Transformation rules to load the data from source to the Staging.
  • Designed and developed Informatica Mappings/Sessions/Workflows to load data from Source systems to Staging DB.
  • Understanding the Business Process of the application and prepared flow diagrams/ERD
  • Worked closely with Business for the requirements and manage offshore and onsite Dev/QA team
  • Created test cases in Rally and provided the tasks to the QA team members
  • Managed Rally and acted as a scrum master
  • User demo for the BU and noted the enhancements as per the user feedback
  • Performed Unit and System and functional Testing

Technologies Used: Informatica Power Center 9.6.1, Informatica cloud

Confidential, Texas

Data Architect/BA

Responsibilities:

  • Analysis of Siebel Data
  • Development of new ETL Mappings to load data from Siebel to the OBIEE
  • Implementation of object level and position based data level security
  • Development of OBIEE RPD
  • Development of Dashboards and Reports for different Business groups
  • Modification of reports based on end user feedback
  • Generated test data for unit and system testing of ETL and OBIEE code
  • Unit and System Testing, Performance testing
  • Deployment of code to production
  • Performance Tuning

Technologies Used: OBIEE 10.1.3.4.1, Informatica Power Center 9.0.1/ Informatica Power Center 9.6.1

Confidential

OBIEE Consultant

Responsibilities:

  • Preparation of Informatica mapping based on the requirement.
  • Creating of Task, Workflow in Informatica.
  • Creating DAC Tasks to run the Informatica Workflows
  • Creating the metadata in OBIEE RPD for reporting purpose.
  • Preparing Dashboards to meet the client requirement
  • Creation and Scheduling iBots Reports

Technologies Used: OBIEE 10.1.3.4.1, Informatica Power Center 9.0.1/ Informatica Power Center 9.6.1

Confidential

BA/QA Resource

Responsibilities:

  • Understanding the Business Process of the Airline domain/functionalities.
  • Direct interaction with the client for the knowledge transfer and to understand the functionalities.
  • Creating the Data flow/ BRD for this project.
  • Provide KT to the other team members.
  • Performed QA activities to ensure the readiness of the system

Technologies Used:.NET

Hire Now