Engineer Data
Resume:
Rachel Manisha
Harrisburg, NC - *****
Phone: +1-980-***-****
E-mail: *************@*****.***
Professional Synopsis
Over 12+ years of total IT Industry experience in all phases of Software Development Life Cycle (SDLC) with comprehensive background in End-to-End implementation of Business Intelligence in Finance using Oracle Business Intelligence (OBIEE 12c/11g/10g), BI Publisher and ETL (Datastage 8.1/11.5)
Has good experience in OLTP/OLAP Source System Analysis and Dimensional modelling developing database Schemas like Star schema, Snowflake schema.
Has good experience in installation, configuration, administration and upgrade of standalone as well as clustered OBIEE 11g/10g.
Has good understanding of Security and Architecture model of OBIEE 12c/11g/10g.
Skilled in Repository (Metadata) design and development at all three layers.
Experienced in designing customized interactive Dashboards and Answer reports.
Expertise in creating executive reports with BI Publisher integrated with OBIEE 12c/11g.
Expertise in Email bursting using BI Publisher.
Good experience in creating OBIEE Write back reports and enhancing the GUI with drop down (single/multi) etc using javascript, action framework report for write back.
Has experience in Scheduler setup and iBots/Agents Configurations for delivering reports using Oracle BI Delivers component of OBIEE.
Hass good experience in creating prompted dashboard url and go url for embedding the analytics application within different applications like CRM dynamics etc.
Has good understanding of the way OBIEE generates queries.
Experienced in migration of RPD and web catalog reports from one environment to another environment OBIEE 12c/11g/10g.
Expertise in enabling Channel secure Single sign on for OBIEE and BI Publisher with IIS web server.
Has good knowledge in customizing OBIEE UI interface, style and skin.
Has good experience in applying the Oracle patches.
Has interacted with oracle for the various issues found in the upgrade and resolved them eventually.
Good understanding of ETL concepts and Modelling, setup a whole data warehouse for the current client, where multiple systems are integrated into a single data model.
Has good experience in Data Stage jobs and Sequence development.
Has good knowledge in Oracle 11g/10g and writing SQL and PL/SQL.
Trained in Oracle DRM and has worked on integrating Oracle DRM with Siebel UCM 8.2 for data imports and extracts.
Has been offshore point of contact for the Master Data Management (MDM) quality assurance team for a retail major in USA. For the retail customer implementation, was responsible for the QA and UAT testing of the MDM implementation. Building test scenarios, test cases satisfying the business requirements.
Experience in interacting with Business users to analyse the business process and gathering requirements.
Excellent communication skills, Self-motivated, hardworking, ability to work independently or cooperatively in a team.
Good problem solving skills, having the ability to work under tight schedules and meet deadlines and to quickly learn new technologies.
Quick to build rapport and trust.
Key Technology and Expertise
Tools: OBIEE 12c/11g/10g, BI Publisher, SQL Developer, MS SQL Management Studio, IBM Data Stage 9.1, HP ALM Quality Centre, Version One, JIRA
Languages: Oracle SQL, MS SQL, Java Script, HTML
Database: Oracle 10g, 11g,12c (Exadata), MS SQL Server 2008
OS: Windows / UNIX
Others: IBM Master Data Management, Oracle Hyperion Data Relationship
Educational Course
Course
Area of Specialization
From
To
University/
Institution Name
City/State/
Country
BTech
BioTechnology
Aug 2004
Jun 2008
SASTRA
Tanjore, Tamil Nadu,India
Organizational Experience
KForce
Client: Wellsfargo Bank, Charlotte NC
Project: ITRAC Reporting
Duration: Oct 2018 – Till Date
Position: Senior Software Developer
Immigration status: H1B
Description: ITRAC a Treasury management reporting application, for reporting on all treasury products, sales managers and theirs accounts.
Key Responsibilities:
Interacting with the business team to collect functional requirements and translating into technical requirements.
Responsible for Dashboard and RPD development for monthly enhancements.
Responsible for the ETL design, development for the monthly enhancements.
Responsible for design, development, review, testing, implementation and release coordination for monthly release for both OBIEE and ETL.
Worked on Answers to build Interactive Dashboards and reports with drill-down and writeback capabilities (OBIEE writeback and action framework writeback).
Worked extensively on RTF templates using the Oracle BI Publisher Desktop
Worked on enabling channel Secure Single Sign On for OBIEE, BI Publisher with IIS web server
Design/Develop/Review of ETL Jobs for integrating data from different source systems.
Leading and mentoring the team through the life cycle of the project. Communicating tasks to the offshore team, tracking and providing technical guidance to them in completing their tasks on time.
Handle a team of 2-3 offshore members.
Weekly status reports
Estimations and presentations
Infosys Technologies Limited
Client: Wellsfargo Bank, Charlotte NC
Project: ITRAC Reporting
Duration: Oct 2015 – Sep 2018
Position: Technology Analyst
Description: ITRAC a Treasury management reporting application, for reporting on all treasury products, sales managers and theirs accounts.
Key Responsibilities:
Interacting with the business team to collect functional requirements and translating into technical requirements.
Responsible for Dashboard and RPD development for monthly enhancements.
Responsible for the ETL design, development for the monthly enhancements.
Responsible for design, development, review, testing, implementation and release coordination for monthly release for both OBIEE and ETL.
Extensively used Oracle Delivers to provide alerts.
Worked on Answers to build Interactive Dashboards and reports with drill-down and OBIEE writeback capabilities.
Worked extensively on RTF templates using the Oracle BI Publisher Desktop and BI Publisher editor for creating pixel perfect publishing reports
Worked extensively to burst the BI Publisher pixel perfect reports to Email in almost real time.
Worked on enabling channel Secure Single Sign On for OBIEE, BI Publisher with IIS web server.
Worked on Proof of Concept for enabling Single Sign on for Smart view and visual analyzer.
Design/Develop/Review ETL Jobs for integrating data from different source systems
Leading and mentoring the team through the life cycle of the project. Communicating tasks to the offshore team, tracking and providing technical guidance to them in completing their tasks on time.
Handle a team of 2-3 offshore members.
Weekly status reports
Estimations and presentations
Infosys Technologies Limited
Client: Wellsfargo Bank, Charlotte NC
Project: Wholesale Scoreboard Analytics
Duration: Aug 2014 – Jul 2015
Position: Technology Analyst
Description: Wholesale Scoreboard Analytics builds Dashboards/Reports for the different Wholesale Cross Sell Group Managers to understand the portfolio performance and discover cross-sell, up-sell and business retention opportunities and drive strategic conversations and sales activity
Key Responsibilities:
Interacted with the client and end user to collect requirements. Prepared High level design documents for all requirements. Involved in translating functional requirements into technical requirements.
Responsible for design, development, testing, implementation and release coordination for quarterly release.
Leading and mentoring the team through the life cycle of the project. Communicating tasks to the offshore team, tracking and providing technical guidance to them in completing their tasks on time.
Development of repository at physical, business model and mapping and presentation layer using Administration tool.
Development of dashboards and Reports with drill-down capabilities.
Handled a team of 2 offshore members.
Weekly status reports.
Estimations and presentations
Conduct Technical interview to on-board new resources to scale up team in OBIEE, BI Publisher and ETL.
Infosys Technologies Limited
Client: RBS, Chennai, India
Project: Rainbow2
Duration: Apr 2014 – Jul 2014
Position: Technology Analyst
Description: The RBS Group is a large international banking and financial services company. Rainbow2 builds a new instance similar to the existing instance of OBIEE. Migrating the latest Catalog, Repository, Configuration files and testing the instance for correct setup.
Key Responsibilities:
Work with the team and understand the requirements, prepare / modify technical design documents.
Designing Test cases documents
Migrating Catalog, Repository file and config files.
Conducting Technical interviews
Infosys Technologies Limited
Client: Citi Group, Chennai, India
Project: Global Transaction Services Analytics
Duration: Nov 2011 – Jan 2014
Position: Technology Analyst
Description: Global Transaction Services Analytics project builds BI dashboards/reports for the senior management of the service center unit to help to make right decisions. And In parallel the OBIEE application was upgraded from 10.1.3.4 to 11.1.1.6.7
Key Responsibilities:
Successfully driven OBIEE 10.1.3.4 to 11.1.1.6.7 upgrade project for standalone as well as clustered environments.
Along with the migration of existing customizations, server clustering, additional modules like BIP, write back, usage tracking were also implemented.
Implemented Security – created roles, groups.
Resolved Data/UI/Catalog/RPD/Configuration/BIP defects.
Worked with Oracle closely to resolve and track many 11g product bugs/UI enhancements.
Worked in applying the Oracle patches.
Migrated Web catalog and RPD from one environment to other environment.
Involved in Creating and Administering the Physical Layer, Business Model and Presentation Layer using Oracle Business Intelligence Admin tool.
Developed custom reports/Ad-hoc queries using Oracle Answers and assigned them to application specific dashboards.
Developed different kinds of views on Reports (pivots, charts, tables).
Designed and built Dashboards.
Weekly status reports.
Infosys Technologies Limited
Client: Bank of America, Chennai, India
Project: FSR– Hierarchy Master Data Management
Duration: Apr 2011 – Oct 2011
Position: Senior Systems Engineer
Description: Hierarchy master data management project is about creating a functional environment to create, control, and store valid eLedger dimensions as master data and hierarchies. The values are to be loaded through a controlled tool and syndicated to multiple environments for analysis and reporting.
Key Responsibilities:
Analyze Business Requirement.
Create Functional and Technical design documents.
Create and manage hierarchies to store valid master data.
Infosys Technologies Limited
Client: The Infosys Oracle Center of Excellence, Chennai, India
Project: The Infosys Oracle Center of Excellence
Duration: Feb 2011 – Mar 2011
Position: Systems Engineer
Description: This is an Infosys initiative to create working demos to showcase Oracle UCM 8.2 capabilities.
Key Responsibilities:
Built working demos showcasing Oracle UCM 8.2 capabilities.
Was responsible for designing and building Task Based User Interface (TBUI’s) model for Retail business processes.
Integrated Oracle DRM with Siebel UCM 8.2 for data imports and extracts.
Infosys Technologies Limited
Client: JC Penney, Chennai, India
Project: Customer Data Integration – CDB to CDI Conversion
Duration: Feb 2010 – Jan 2011
Position: Systems Engineer
Description: Customer data integration is about conversion and migration of customer data from legacy customer database to IBM MDM. This involves building of custom MDM services for internal systems to create and maintain customer data. Data governance and business rule and suspect duplicate processing were also implemented to create the golden record of customer information.
Key Responsibilities:
Has been offshore point of contact for the Master Data Management (MDM) quality assurance team.
Analyze Business Requirement.
Built test scenarios, test cases satisfying the business requirements.
Performed the QA and UAT testing for the MDM implementation.
Executed the test Case in QC.
Created test suite for Regression Testing.
Contact this candidate