We provide IT Staff Augmentation Services!

Onsite Lead (bi Solutions) Resume

Pleasanton, CA

SUMMARY:

  • Over 10 years’ experience in designing and developing ETL/BI solutions using Informatica/ODI/OBIEE/ Tableau platforms.
  • Expertise in Informatica Metadata/Repository Management, Client Tools, Mappings, Mapplets and Transformations like Lookups (connected and unconnected), Normalizer, Stored procedure, Router,Aggregator, Update strategy, Joiner, Source qualifier, Expression and Sequence generator
  • Expertise in scheduling and running the ETL jobs in workflow Manager and Workflow Monitor in Informatica Power center
  • Extensively involved with user requirements gathering, functional analysis, Data Modelling, development,Implementation and testing of data warehousing, analytical and reporting application development
  • Expert database development skills using Oracle PL/SQL to write stored procedures, stored functions,packages, triggers and cursors
  • Experience creating dashboards in line with the analytical uniformity using the Advanced Analysis of Tableau Desktop, and organizing Dashboard views and objects.
  • Experience using Tableau functionalities for creating various views, Filters, Charts, Interactive dashboards with Page and dashboard Prompts.
  • Skilled in Tableau Desktop for data visualization, Reporting and Analysis; Cross tab, Scatter Plots, Geographic Map, Pie Charts and Bar Charts.
  • Proficient in creating Calculations (Table Calculations, Hide Columns, Creating/Using Parameter, Totals) and Formatting (Annotations, Layout Containers, Mark Labels, Rich Text Formatting, Shared Encoding) using Tableau Desktop.
  • Knowledge in dealing with various functionalities like Dashboard prompts, views, aggregates, global filters, scheduling, conditional formatting of reports.
  • Strong expertise in customizing OBIEE SDE and SIL mappings using Informatica Power center, configuring and scheduling workflows with Oracle Data Warehouse Application Console(DAC)
  • Good experience in Metadata Modeling at all three layers (Physical, Business Model and Presentation) using the OBIEE Administration Tool.
  • Good understanding in creation of dimension & fact tables, logical columns, hierarchies, level based measures in Business model and catalog folders in Presentation layers
  • Good Experience in creating ad - hoc reports using OBIEE Answers, publishing them on to the dashboards and scheduling ibots.
  • Expertise in performing Administration tasks including Analytics web Administration and Manage Catalog.
  • Good Experience in implementing data and object level security in OBIEE.
  • Good Experience in debugging and performance tuning of Sources, Targets, Mapping, Transformations and Sessions in Informatica.

TECHNICAL SKILLS:

Applications/Tools: Informatica Power Center 8.x, 9.0.1,9.1,10.1, Tableau 10.1.1,OBIEE 10g, 11g(11.1.1.5.x, 1.1.1.7.x),Cognos 10.2, BI Publisher 11g(11.1.1.7.x), Oracle Clinical Development Analytics (OCDA1.x,2.x,3.x),Life Science Data Hub (LSH 2.1.x, 2.2.x), Oracle Data Integrator(ODI),Datawarehouse Administration Console (DAC) 10.1.3.4.1, Oracle Healthcare Master Person Index 1.1, 1.2 (OHMPI), Weblogic, Siebel CTMS,Oracle Clinical (OC), SQL, PLSQL

PROFESSIONAL EXPERIENCE:

Confidential, Pleasanton, CA

Onsite Lead (BI Solutions)

Responsibilities:

  • The scope of the project is to collect/analyze business requirements from HR team, identify KPIs and build ETL/Reporting solutions to enhance business decision-making.
  • Designed and developed ETL interfaces for TriNet internal and external data warehouses using Informatica and ODI
  • Involved in Data Modeling and Data Mapping review, including sources, staging area and target databases.
  • Designed and developed Star Schemas by interfacing with the database teams for proposed Subject Areas, Fact, Dimension tables and their hierarchies.
  • Identified the bottlenecks and Performed extensive Debugging and Performance tuning of ODI/Informatica Process and conducted Unit Testing to validate the Interfaces/mappings in accordance with the Business Specifications.
  • Migrated existing HR internal reports from Cognos to Tableau along with incorporating new enhancements.
  • Developed complex calculated fields for the business logic, field actions, sets and parameters to include various filtering capabilities for the dashboards, and to provide drill down features for the detailed reports.
  • Designed dashboards on the concept of Dynamic Availability where in a variety of worksheets / views were connected by Actions, and provided an interactive reporting in the developed dashboards.
  • Performance optimization of various dashboards in all the dashboard files.
  • Used Data blending to connect data from multiple sources.
  • Trained the end users to effectively use the reporting tool to build and customize their ad-hoc reports
  • Used Release management tools like Source Tree and JIRA to migrate code between environments.
  • Lead the release management activities by working closely with the offshore and onsite teams.

Environment: Informatica 10.1, ODI 12c, Cognos 10.2, Tableau 10.1, SQL, PLSQL

Confidential, Redwood City, CA

Senior Software Engineer

Responsibilities:

  • Worked in Product development of OCDA and DMW in the Life Sciences Business Unit
  • OCDA (Oracle Clinical Data Analytics - 4 years) - Product used by Pharmaceutical companies for conducting clinical trials and analysis
  • Responsible for data platform enhancements leveraging best practices and appropriate design principles.
  • Designed and developed ETL mappings (using Informatica Power Center) for multi source integration. (Siebel, Oracle Clinical and Inform).
  • Configured OBIEE RPD, developed reports (out of the box, adhoc) and dashboards (real-time) based on the requirements.
  • Integrated a MDM based de-duplication solution (OHMPI) into the OCDA product.
  • Scheduled and configured full/incremental ETL in DAC.
  • Migrated the Informatica mappings to ODI (Oracle data integrator) along with incorporating new enhancements into the product
  • Worked on the cloud initiative to move OCDA into the cloud by building automation scripts for Weblogic installations, domain creation/configurations.
  • DMW (Data Management Workbench - 1 year) - a customized ETL product for the Life Sciences domain.
  • Worked on building new enhancements in DMW - Used PL/SQL to build custom features for the product.
  • Developed new PL/SQL APIs which are consumed by the front end ADF UI layer.
  • Fixed product issues that were indicated by the clients by debugging the existing PL/SQL APIs

Environment: Informatica 8.6.1/9.0, LSH, OBIEE 11g, DAC, OHMPI, ODI, DMW,PLSQL,SQL

Confidential, Santa Clara, CA

Senior BI Consultant

Responsibilities:

  • Analysed the Business Requirements for Call Center Telephony Module.
  • Designed and developed Star Schemas by interfacing with the database teams for proposed Subject Areas, Fact, Dimension tables and their hierarchies.
  • Created logical tables and custom aggregation rules.
  • Involved in Data Modeling and Data Mapping review, including sources, staging area and target databases.
  • Identified the Bottlenecks and implemented performance tuning logic on targets, sources, mappings, sessions to provide maximum efficiency and performance.
  • Troubleshoot problems by checking sessions and error logs. Used debugger for complex problem troubleshooting.

Environment: Informatica Power Center 8.6.1, Siebel CRM 8.0, OBIEE 10.1.3.4, Teradata, Oracle BI Data warehouse Application Console 7.9.4

Confidential, Sunnyvale,CA

Senior BI Developer

Responsibilities:

  • Analyzed the Business Requirements for Sales, Service analytics, Marketing and HR subject Areas and upgraded Informatica ETL solutions according to the Business Specifications as per OBIEE standards
  • Developed new SDE and SIL mappings and customized the existing OOB mappings to accommodate the data from the Siebel CRM application to the upgraded OBIEE warehouse for producing the reports.
  • Deployed Informatica Workflows to OBIEE DAC, determined the data transfer dependencies, upgraded the tasks as per the new version and streamlined the execution plans for both full and incremental loads
  • Performed extensive Debugging and Performance tuning both at the Informatica process level as well as DAC tasks and conducted Unit Testing to validate the mappings in accordance with the Business Specifications.
  • Developed and customized repository at the Physical Layer, Business Model and Presentation Layer.
  • Designed and developed Star Schemas by interfacing with the database teams for proposed Subject Areas, Fact, Dimension tables and their hierarchies.
  • Identified the Bottlenecks and implemented performance tuning logic on targets, sources, mappings, sessions to provide maximum efficiency and performance.
  • Created ad-hoc reports in OBIEE Answers and Dashboards as per the business requirements.
  • Resolved and Triaged the Business Intelligence Tickets that were identified as part of the post production issues.

Environment: Informatica Power Center 7.1.4, Siebel CRM 8.0, OBIEE 10.1.3.3, Oracle 10g, Oracle SQL Developer, Oracle BI Data warehouse Application Console 7.9.4

Confidential, Denver,CO

Senior ETL Developer

Responsibilities:

  • Developed Informatica mappings that would load the Retro active Premium Adjustment Extract from the mainframe legacy systems into the data warehouse tables from which the discretionary entries would be later loaded into Facets.
  • Extensively used Informatica client tools - Source Analyzer, Warehouse designer, Mapping Designer, Mapplet Designer, Transformation Developer, Informatica Repository Manager and Informatica Workflow Manager.
  • Created sessions, worklets and workflows for carrying out test loads and initiated the job through the Autosys Scheduler whenever an input file is created on the Unix Server.
  • Identified all the ETL bottlenecks and tuned the complex Informatica mappings for better Performance.
  • Worked on Parameterization of the variables and connections at all levels in UNIX in different environments

Environment: Informatica Power Center 7.1.4 Oracle 10g, Toad 8.6, SQL, FACETS 4.X, Hyperion 8.2 (Brio)

Confidential, Orville, OH

Informatica/OBIEE Developer

Responsibilities:

  • Modified the OOB Informatica mappings using Informatica Power Center Designer and deployed them to DAC for execution in full load and incremental load.
  • Streamlined the Execution plans with the respective tasks in Siebel DAC in terms of the available system resources like dependency profile and job priorities.
  • Designed slowly changing dimension transformations (SCD) and customized the existing mappings.
  • Customized the physical layer, business model and presentation layer in the repository which is mapped to the data sources. Performed metadata validation checks like checking global consistency.

Environment: Informatica Power Center 7.1.4, Siebel CRM Analytics 7.8, Siebel Answers 7.8, Oracle 9i, Oracle SQL Developer, SQL/PLSQL, Erwin

Confidential, CA

Informatica/OBIEE Developer

Responsibilities:

  • Analyzed the Requirements for Promotion and Performance schemas and developed Informatica ETL solutions according to the Business Specifications.
  • Developed new mappings and customized the existing Out of the Box mappings to store the custom data from the Siebel CRM application to the warehouse component as necessary for producing the reports.
  • Performed extensive Debugging and Performance tuning of Informatica Process and conducted Unit Testing to validate the mappings in accordance with the Business Specifications.
  • Worked on merging process for Metadata and Webcat.
  • Worked extensively on the Cache seeding and the Cache Purging Techniques.
  • Created reports and dashboards based on the business requirements.
  • Configured Analytics scheduler services on Windows box. Created and Scheduled iBots.

Environment: Informatica Power Center, Siebel CRM Analytics 7.5.3.4, Siebel Answers 7.7, Oracle 9i, Oracle SQL Developer, SQL/PLSQL, Erwin, Windows NT.

Confidential, Denver,CO

ETL Developer

Responsibilities:

  • Developed Informatica mappings that performed transformations on the Legacy Systems data((BENandComputrak) and the Facets data that would load the data into the Oracle tables and the flat files that will be sent to ODS(Operational Data Store) on a daily basis
  • Extensively used command, event-wait, event-raise and control tasks for keeping track of events in the ETL process.
  • Responsible for Performance Tuning of Informatica code to increase the performance and throughput.

Environment: Informatica Power Center 7.1.4/6.2 Oracle 9i/10g, DB2 UDB, MS-Access 2003,CaliberRM 2005 release 2, ERWIN 4.0, Toad 8.6, Unix Shell Scripts,, SQL, FACETS 4.X, MS Office Visio 2003, Hyperion 8.2 (Brio)

Confidential, Denver,CO

ETL Developer

Responsibilities:

  • Analyzed the Business Requirements for Orders, Service Requests, and Agreements and identified the source data to locate required elements in the report specifications.
  • Designed and mapped the custom fields from Siebel PRM Application to the Siebel PRM AnalyticsApplication
  • Streamlined the Execution plans with the respective tasks in Siebel DAC in terms of the available system resources like dependency profile and job priorities.
  • Performed tuning of Informatica processes by removing the bottlenecks on all instances of the mapping

Environment: Informatica Power mart 6.2.2, Siebel PRM Analytics 7.5.3.4, Siebel Answers 7.7, Oracle 9i

Hire Now