We provide IT Staff Augmentation Services!

Senior Bi Architect Resume

San Jose, CA

SUMMARY:

  • Energetic, Business Analyst/Senior BI Consultant with solid base of experience in all areas of business accounting and financial analysis. Excellent problem solver with high - level management skills and proven abilities to mediate sensitive, even volatile, business climates. Extensive experience with highly sensitive, proprietary projects. Effective communicator and problem solver. Strong PC and financial-systems skills.
  • Information and Financial Technology professional with over Ten(10) years of global consulting and implementation experience across multiple sectors/ industries
  • Worked on multiple source system as Oracle EBS, Peoplesoft, CRM, custom Oracle source systems for requirements gathering and involved in data modelling
  • Functional hands-on experience with Oracle Financials, modules including General Ledger, Fixed Assets, Payables, Receivables,
  • Extensive hands on experience using Oracle, MYSQL, Teradata and SQL Server databases and several of its tools.
  • Ensure the security and accessibility of data to all users across the enterprise and also the end-users
  • Involve in data cleaning procedure by removing old, corrupted or irrelevant data in consultation with the teams
  • Outstanding ability to define business functions as generalized metadata, enabling systems to provide long-term stability and reliability.
  • Management and implementation of database models, data flow diagrams, database schemas, db scripts, structures and data standards to support a robust data management infrastructure.
  • Solid experience translating business requirements into conceptual, logical, and physical data models and implement best practices and methodologies in data analysis, design and modeling.
  • Data warehousing experience using ODI, OBIA, OBIEE, OWB, MSBI-SSRS, SSIS, DataStage, Informatica, Tableau, QlikView & ELT and ELT Concepts and BIG DATA Technologies
  • Hands on Experience in PL/SQL( Procedures, Triggers, Packages, functions)
  • Extensive experience in extraction, transformation and loading of data directly from different heterogeneous source systems like Flat Files, Oracle, MySQL, SQL Server.
  • Involved in Control-M Job Scheduling for Production Jobs,
  • Working experience in using Oracle 10g/9i/8i, SQL, SQL Plus, PL/SQL, Shell Scripts, Windows XP/2000/98/95, and UNIX.

SKILLS:

Technology Software: Oracle EBS, CRM, Oracle DRM, Informatica, Oracle data integrator 11g,12c, OBIEE11g & 12c, MSBI, TABLEAU, OWB, Hyperion Brio

RDBMS: Oracle, MSSQLSERVER2010, Teradata

Programming: Python, Plsql, shell Scripting, SQL

OPERATING SYSTEM: Unix, windows, AIX, LINUX

APPLICATION SERVER: WebLogic 11g

PROFESSIONAL EXPERIENCE:

Confidential, San jose, CA

Senior BI Architect

Responsibilities:

  • Utilized extensive data architecting skills principles and standards, management company. to define enterprise data architecture vision, strategy, and business partners, and propagate throughout the
  • Designed and developed complex ETL mappings making use of transformations like Source Qualifier, Joiner, Update Strategy, Connected Lookup and unconnected Lookup, Rank, Expression, Router, Filter, Aggregator and Sequence Generator.
  • Working with various sources such as Flatfiles, Relational, XML and Webservices as part of Informatica Mappings.
  • Designed and developed dimensional model for Customer Data Warehouse in Oracle and Created Fact and Dimensional tables in the Star Schema for data warehouse.
  • . Responsible for Unit testing and Integration testing of mappings and workflows. Extensively used Informatica Power Center Data Validation tool to unit test the ETL mappings.
  • Effectively provided framework, stewardship, governance and decision making for management of data for project development teams, business users and other stakeholders, and delivered a road map to achieve the vision.
  • Created Tables, Views, Constrains, Synonyms, Sequences, Used the inner join, outer join, cross join while writing the complex SQL Queries. Used Collection objects, ref cursor, and bulk collect, aggregate functions while Writing SQL Queries.
  • Used workflow Monitor to monitor the performance of the Jobs.
  • Selected bottom-up approach and developed enterprise data warehouse (EDW) for the company, progressively moved applications from different sources (SQL SERVER to Oracle EDW. )
  • Skillfully developed conceptual, logical and physical data models, deployed, tested and moved to production for the EDW.
  • Upgrading Hyperion Brio to OBIEE reports.
  • Creation of metrics, attributes, filters, reports, and dashboards created advanced chart types, visualizations and complex calculations to manipulate the data.
  • Expert level stored procedures development in Oracle, SQL Server & DB2 environments.
  • Experience in Dimensional Modeling such as star schema, snow flake schema, creating Facts, Dimensions and Measures.
  • Developed interactive Dashboards and Reports in Tableau and Oracle BI Answers as per the reporting specifications.
  • Created Hierarchies, Levels, and implemented Business Logic by creating level based measures in OBIEE business model & mapping layer.
  • Integrate all data in the data management platform enabling accessibility
  • Used the Informatica Designer to develop processes for extracting, cleansing, transforming, integrating, and loading data into Target database.
  • Experience in designing ETL mappings and custom logics from multiple data sources using Informatica Designer, workflows, Monitor, Repository.

Confidential, San Jose, CA

Senior ETL consultant

Responsibilities:

  • Involved in the requirement study, design and development and database design
  • Diligently developed strategies for the data movement, Oracle DRM data architecture for consolidation of all applications to enhance system efficiency
  • Mapping involves various types of transformation like Lookups, Update, Joins, Filters and Error handling using ODI. worked on Data modeling for data lineage impact analysis on down streams applications (OracleEBS, Hyperion Essbase/Planning, Hyperion Financial Management, Data warehousing)
  • Created architectural principles and strategies. Provided recommendations on approach, technology, and design to virtually every major project toward achieving the overarching architectural initiatives of reducing process and data redundancy, integrating applications, increasing application flexibility, and reducing overall complexity.
  • Expert in data analysis, migration, modeling, integration and data warehousing concepts and application
  • Ability to translate and present the ideas into design and implementation
  • Integrate all data in the data management platform enabling accessibility
  • Used the Oracle Data Integrator Designer to develop processes for extracting, cleansing, transforming, integrating, and loading data into Target database.
  • Experience in designing ETL mappings and custom logics from multiple data sources using ODI Designer, Interfaces, Packages, and Scenarios

Confidential, KY

Senior Technical Lead

Responsibilities:

  • Utilized extensive data architecting skills to define enterprise data architecture vision, strategy, principles and standards, management and business partners, and propagate throughout the company.
  • Effectively provided framework, stewardship, governance and decision making for management of data for project development teams, business users and other stakeholders, and delivered a road map to achieve the vision.
  • Selected bottom-up approach and developed enterprise data warehouse (EDW) for the company, progressively moved applications from different sources to EDW.
  • Skillfully developed conceptual, logical and physical data models, deployed, tested and moved to production for the EDW.
  • Designed and developed complex ETL mappings making use of transformations like Source Qualifier, Joiner, Update Strategy, Connected Lookup and unconnected Lookup, Rank, Expression, Router, Filter, Aggregator and Sequence Generator.
  • Expert level stored procedures development in Oracle, SQL Server & DB2 environments.
  • Experience in Dimensional Modeling such as star schema, snow flake schema, creating Facts, Dimensions and Measures.
  • Developed interactive Dashboards and Reports in Oracle BI Answers as per the reporting specifications.
  • Created Hierarchies, Levels, and implemented Business Logic by creating level based measures in OBIEE business model & mapping layer.
  • Involved in Creating and Administering the Physical Layer, Business Model & Mapping Layer and Presentation Layer using Oracle Business Intelligence Admin tool.

Confidential

Senior Data Architect /BI Consultant

Responsibilities:

  • Provide development support for reporting system to enable business users to meet their functional operational objectives using large enterprise data warehouse and other data sources.
  • Mentor team members to increase their proficiency in using unfamiliar technologies.
  • Work with end users to understand business process of Credit Union and gather requirements for the necessary reports.
  • Hands on Experience in Performance tuning and Partitioning, Hints, Explain Plain worked on OWB Mappings and Packages and Control Center Setup and Code deployments
  • Implemented data level and object level securities.
  • Designed the implementation of ETL and OBIEE for various Modules like incentives, loans and cross sales.
  • Developed custom reports/Ad-hoc queries using Answers and assigned them to application specific OBIEE dashboards
  • Worked with different groups in organization to understand their business requirement and give valuable suggestions for reports and dashboards.
  • Developed the source to target mappings and (ETL) data design documentation for fact and dimension tables, including architecture blueprint and program specifications.
  • Extensively worked with performance tuning of the mappings, sessions and Stored Procedures.
  • Involved in the design, development and testing of the PL/SQL stored procedures and packages for the ETL processes.

Confidential

Senior Technical Lead

Responsibilities:

  • Involved in Various phases of the project like Requirement understanding, preparing mapping documents and development of the mappings.
  • Involved in Migration ETL Mappings from Oracle to Microsoft SQL Server.
  • Mapping involves various types of transformation like Lookups, Update, Joins, Filters and Error handling using ODI.
  • Installation and Configuration, Deployments of ODI in LINUX/AIX environments
  • Worked on configuration, setup and deploying OK Analytics product in Web logic
  • Extensive Experience on web logic clustering and managed servers and domains.
  • Creation of PL/SQL cursors, functions, procedures, packages and Triggers in Oracle and calling then in ODI through ODI Procedures.
  • Hands on Experience in Performance tuning ( Materialized Views, Partitioning, Hints, Explain Plain)
  • Studying the existing environment and accumulating the requirements by querying the Clients on various aspects and Identification of various Data Sources and Development Environment.
  • Extensively used Oracle Data Integrator for loading the data from various sources involving flat files and oracle tables.
  • Experience in Dimensional Modeling such as star schema, snow flake schema, creating Facts, Dimensions and Measures.
  • Developed interactive Dashboards and Reports in Oracle BI Answers as per the reporting specifications.
  • Created Hierarchies, Levels, and implemented Business Logic by creating level based measures in OBIEE business model & mapping layer.
  • Developed custom reports/Ad-hoc queries using Answers and assigned them to application specific OBIEE dashboards
  • Involved in Creating and Administering the Physical Layer, Business Model & Mapping Layer and Presentation Layer using Oracle Business Intelligence Admin tool
  • Involved in Developing Mappings, Creating Interfaces, Packages and Scenarios.
  • Responsible for Mapping and Test case development, unit testing and documentation.
  • Hands on Experience in ODI Administration and Security Configuration

Confidential

Senior Technical Lead

Responsibilities:

  • worked as data analyst for health care and academic and sports sectors
  • Studying the existing environment and accumulating the requirements by querying the Clients on various aspects.
  • Identification of various Data Sources and Development Environment.
  • Worked as a team member for design and development of Data Mart and integrating it with Global Data Warehouse
  • Used the different stages like copy, modify, Transformer, Lookup stage, Funnel, Join Stage, Remove duplicates, Sort, Aggregator, Sequential file, Dataset etc
  • Expertise in building complex reusable Informatica jobs and shared containers
  • Involved in Developing Mappings, Creating Interfaces, Packages and Scenarios.
  • Tuned and tested the mappings to perform better using different logics to provide maximum efficiency.
  • Experience in Designing, Compiling, Testing, and Scheduling and Running Informatica jobs against variety data sources.
  • Developed Informatica jobs and Sequencers for Source to Staging and Staging to Data Marts by referring to the Functional Specification Document
  • Created and Monitored packages using designer and Operator, Job Scheduling in SIT and UAT
  • Responsible for monitoring the sessions that are running, scheduled, completed and failed.
  • Responsible for Mapping and Test case documentation.
  • Involved in unit testing and peer reviews.
  • Hands on Experience in Performance tuning ( Materialized Views, Partitioning, Hints, Explain Plain)
  • Involved in Extracting, transforming, loading and testing data from XML files, Flat files, Oracle and DB2 using Informatica jobs.

Confidential

Senior BI Consultant

Responsibilities:

  • Analysis of Physical Data Model for ETL mapping.
  • Studying the existing environment and accumulating the requirements by querying the Clients on various aspects.
  • Involved in Developing Mappings, Creating Interfaces, Packages and Scenarios.
  • Involved in designing of star schema and facts and dimensions using Erwin Data Modeler.
  • Responsible for Mapping and Test case documentation.
  • Hands on Experience in Performance tuning ( Materialized Views, Partitioning, Hints, Explain Plain)
  • Design of Packages to Load bulk data into different Data base like Oracle, in ODI tool.
  • Creating different interfaces and modifying knowledge Module in the process of creating packages for data.
  • Designed the implementation of ETL and OBIEE for various Modules like incentives, loans and cross sales.
  • Experience in Dimensional Modeling such as star schema, snow flake schema, creating Facts, Dimensions and Measures.
  • Developed interactive Dashboards and Reports in Oracle BI Answers as per the reporting specifications.
  • Created Hierarchies, Levels, and implemented Business Logic by creating level based measures in OBIEE business model & mapping layer.
  • Developed custom reports/Ad-hoc queries using Answers and assigned them to application specific OBIEE dashboards
  • Installation and configuration of ODI in AIX, windows, OBIEE Installation
  • Creation of PL/SQL cursors, functions, procedures, packages and Trigger in Oracle and calling then in ODI through ODI Procedures
  • Hands on Experience in ODI Administration and Security Configuration and Repository creation and configuring Topology and creating different contexts for different sources

Hire Now