SUMMARY:

• A highly competent senior BI and ETL Administrator/Technical Support Analyst with 12+ years of experience in administrating and supporting OBIEE, Informatica PowerCenter 10.2/9.6.1/9.0.1 /8.6.1/7.1.4/6 and databases Confidential 11g/10g/9i, SQL Server 2012/2008/2005 to ensure service tickets are acknowledged, resolved, and closed within defined SLA’s. A de facto primary contact for OBIEE, Informatica, Confidential and SQL Server support when product issues are encountered and support tickets need to be opened, while keeping Standards and Procedures documentation up - to-date
• Strong techno-functional service attitude exceptional organizational ability, works well within a team, have excellent written and verbal communication skills, and able to create and follow procedures. Ability to work unsupervised, have the ability to work proactively, possess attention to detail and a ‘can do’ attitude. Commit to getting the job done, excellent troubleshooting skills, works well under pressure and have the ability to multitask. Excellent interpersonal and leadership skills. Experience working with onsite and offshore software development teams
• Provided support in managed code deployments facilitated by the release coordinators for migration, monitoring the jobs, user management and associated security levels, backup and restoring repositories, support and maintain the environment as well as to make sure High Availability is maintained across the environments
• Created new enhancement in OBIEE, ETL jobs, DB Patching, Backup, Restore, Deployments, Upgrades, Performance tuning, troubleshooting issues and root cause analysis follow-ups, Investigate and fix user raised incidents, break fixes, fix system generated alerts by providing Level 1/2/3 operational support for production and non-production environments
• Acted as OBIEE, Informatica environment gatekeeper looking out for best interest of overall Environment in terms of stability and functionality across all projects.
• Perform database refresh activities in non-production for QA and UAT support activities
• Flexible with working hours, handling weekend shifts and on call support
• Experience in Dimensional Data Modeling, Star and, Snowflake schema modeling, and ER Modeling.
• Expert resource for designing the architecture for the Extract/Transform/Load environment, implementing data integration standards and processes, authoring very complex transformation rules, Grid and High Availability Installations, Configuration, Upgrade and training.
• Demonstrates a commitment to continuous improvement. Able to work well independently or in a team.

TECHNICAL SKILLS:

ETL Tools: Informatica PowerCenter 9.6.1/9.5.1/9.1.0/8.6/8.5/8.1/7.1/7.0. PowerExchange, SSIS

Business Intelligence:: OBIEE, BI Publisher, OBIA (Siebel, EBS, PeopleSoft, Fusion Applications), Finance, HR, OM, Projects, Sales, Marketing

Databases: Confidential 12c/11g/10g/9i, MS SQL Server 2012/2008/2005/2000

Operating Systems: Sun Solaris 2.6.1, 7, 10 HP-UX 11, AIX 5, 6,7, RHEL Linux 5.x, 6.x, 7 Windows Server, 7, 2012

Languages: SQL, PL/SQL, XML.

Tools: TOAD, PL/SQL Developer, Confidential Enterprise Manager SQL*Plus

PROFESSIONAL EXPERIENCE:

Confidential, Pleasanton, CA

Senior Support Administrator

Technology: OBIEE 11g/10g, Informatica PowerCenter 10.2/9.6.1/9.0.1 , Confidential 11g /10g

Responsibilities:

• Administered OBIEE11/10g, Informatica environments with respect to change management request and incident controls.
• Successfully Upgraded Dev, Test and Production OBIEE 11.1.1.6.0 to 11.1.1.7.0 and 11.1.1.9.0
• Successfully Upgraded Dev, Test and Production Informatica environments from 8.6.1 to 9.0.1 to 9.6.1 version
• Migrated Informatica code across environments using code migration techniques.
• Performed deployments for OBIEE in Multi User development environment
• Responsible for Backup and recovery and providing 24x7 Support of repository and DWH Database environments which includes Confidential database 11g and SQL Server 2012.
• Provided proactive technical support for OBIEE, Informatica ETL end users, which includes performing detailed investigations to identify root causes/fixes for complex issues
• Analyzed ETL failures and interact with Development team for debugging and troubleshoot production issues. Respond to critical Informatica outages or issues
• Partnered with Delivery Management team to ensure a smooth transition from enhancement and project teams to ensure that service level agreements are met
• Communicated the status of all production problems and upcoming maintenance and release activities to business partners, stakeholders and upper management.
• Provided on-call support for after-hours batch processes
• Continually look for opportunities to improve batch processes, etc. to improve overall experience and maintain a stable production environment.

Confidential, Houston, TX

Senior Support Engineer

Technology: Informatica PowerCenter 9.0.1, OBIEE 11g, Confidential 11g

Responsibilities:

• Primary area of responsibility is effective analysis, troubleshooting and accurate problem solving of technical incidents of varying degree by responding to issues received by Service tracking tool, email, or phone Includes hardware/software break/fix troubleshoot ETL, BI and database
• Major Incident Handling: Provide clear diagnosis of time sensitive or high priority issues. Act as escalation point and work with I.S. resolver teams to facilitate resolution and follow up. Participate in oncall support.
• Monitor daily product reports and perform customer remediation as required.
• Aggressively respond to service requests from Client facing support teams, Operations, Risk/control partners.
• Responsible for the day-to-day maintenance of the application systems in operation, including tasks related to identifying and troubleshooting application and data issues and issues resolution or escalation.
• Code deployments from DEV to QA and Production
• Involved in defining the Clinical data repository and data mart architecture, technical requirements
• Responsible for analyzing, designing and developing ETL processes using Informatica PowerCenter 9.0.1
• Designed and developed various Clinical study data load process, workflows and Sessions to suit the requirements.
• Implemented various ETL Mappings in Informatica PowerCenter 9.0.1 for data extractions, data transformations, data staging and aggregation.
• Developed the complex Mappings, mapplets, Transformations, UDFs for loading Study Protocol Deviation Repository.
• Developed ETL processes for building, deploying, and managing the data migration to Datamart.

Confidential, Irvine, CA

Consultant

Technology: Informatica PowerCenter 8.6.1 /9, OBIEE 11g, Confidential 11g

Responsibilities:

• Performed fit gap analysis and collected the requirements, analyzed the requirements and customized prebuilt Informatica mappings and OBIEE repository for Fusion Applications PPM Pillar to add new functionality which is specific to this client like cost by task structure, report showing my estimate to complete and estimate at complete, want to see who has charged to my project for the first time, List of Invalid Transactions against my project and to compare authorized funding to the budget, actual cost actual cost plus commitments and forecast, etc.
• Sourced commitment and invalid transactions data from a legacy application using Informatica and loaded into new custom tables of OBAW
• Worked with Confidential ON Demand to get the installation and configuration done on Confidential Linux 5.7.
• Performed ETL to load the data into Warehouse. Created OBIEE Repository and created analysis and Dashboards for enrollments, Disenrollment’s, call center, Plan Summaries
• Created BI Publisher Reports/Documents for Child Care Assistance, Food Assistance and Cash Assistance
• Liaison between Confidential support and the client to manage and escalate the service requests related to product bugs and issues

Confidential, Costa Mesa, CA

Senior Consultant

Responsibilities:

• Worked on six different projects using Informatica and OBIEE technologies for the clients of Confidential:

Confidential, New York City, NY

OBIEE/Informatica Maintenance

Responsibilities:

• Performed maintenance, created documentation and did re-work of client’s Informatica ETL’s
• The client’s trustees needed invoice reports to access their receivables from various customers to start collections
• Assessed the client trustee’s requirements and translated them into a new OBIEE metadata repository (RPD) from Confidential EBS R12
• Created OBIEE reports and dashboards to meet the clients reporting requirements
• In-house training provided to Confidential team on (OBIEE, Informatica).

Technology: Informatica 8.6.1, OBIEE, Exadata

Confidential, Santa Ana, CA

Responsibilities:

• Our team developed a custom data warehouse called SWRDW (State Wide Reporting Data Warehouse) for source CCMS (Court Case Management System)
• Lead the effort as SWRDW Project Lead and SME to redesign, develop and unit test their technology architecture, providing leadership and expertise on BI & DW and technology threads in Onsite-Offshore delivery model
• Responsible to design, development and unit test different components (Informatica mapping, PL SQL, UNIX shell scripts) to maintain the data marts (Extract data, Transform data, Load data)
• Setup Procedures & Mappings to Extract, Transform and Load (ETL) data from Operational and Legacy Systems to the Data Warehouse tables by using Informatica
• Extensively used Erwin data modeler in dimensional modeling for Facts and dimension table designs
• Implemented OBIEE with Confidential EBS R12 as source system. Primary objective is to replace the existing Cognos data warehouse and to facilitate the end user to create analytics reports within the above subject areas.
• Perform research and business/data analysis on Supply Chain and Order Management Analytics, and Confidential Process Manufacturing analytics initiative.
• Facilitated discussions and wrote business use cases, detailed business requirements.
• Analyzed 400+ requirements to determine the scope of the project. During this process, individual requirements were analyzed and extracted the metrics and dimensions.
• Undertaken the initiative to do business and data analysis for total of 46 reports.
• Managed and delegated tasks to offshore team and was accountable for delivery
• Defined and developed ETL Processes to source EBS r12 data to load target OBAW (Supply Chain and OM, Analytics, OPM custom Module)
• Documented the design so as to make power users understand the data model to do ad hoc reporting
• Designed in-house training material on Confidential Business Intelligence to train the client resources.

Technology: OBIA 7961, Informatica 861, OBIEE, Confidential 10g

Confidential, Atlanta, GA

Responsibilities:

• The purpose of the project was to create a roadmap for a CRM system and help the client standardize business capabilities across various states and stakeholders. The project spanned across both the Consumer and Commercial lines of business.
• Collected and mapped the new Business requirements to standard OBI out-of-the-box functionality and performed Gap Analysis. Defined efforts involved in addressing gaps and rated the gaps based on complexity involved.
• Reviewed analysis documents created by developers and approved development
• Designed and developed Informatica ETL workflows/mappings for marketing Segmentation Analytics
• Aid the functional team in completing the FDD (Functional Design Document).
• Review code with the aid of analysis document and approve

Technology: OBIA 7961, Informatica 861, Siebel Marketing, Confidential & Teradata

Confidential, Atlanta, GA

Responsibilities:

• Lead business requirement gathering sessions for master data management program. Provided educational sessions to the client on master data management, Universal Customer Master and industry best practices.
• Did ETL POC’s with various tools to populate one time bulk load into Siebel EIM tables.

Technology: MDM-Siebel UCM, PeopleSoft and Confidential database

Confidential, Santa Clara, CA

Responsibilities:

• The goal for the project was to enhance and extend the capabilities for the sales reporting applications.
• Enhance Existing ETLs, OBIEE repository to in corporate new business requirements to existing Dashboards, Reports for added functionality in Confidential Incentive Compensation and security authentications for newly created groups.
• Worked and interacted with business on functional requirements.

Technology: OIC R12, Informatica, OBIEE, and Confidential database

Confidential, Alpharetta, GA

Senior OBIEE, Informatica Developer

Responsibilities:

• Gathered business and functional requirements to Improve Restaurant Performance Monitoring and to Increase Reporting Flexibility and Accessibility
• Did a discovery of the databases objects required to design the whole BI project.
• Single handedly designed the high-level architectural design, which includes the dashboard/report mockups and low level dashboard/report design.
• Designed a dashboard for sales scorecard view and current detail view to the upper management.
• Designed a weekly sales summary and week to date sales dashboard for the business users.
• Installation and configuration of the OBIEE platform as well as the scheduling weekly sales summary by creating ibots.
• Created two business models in the .rpd (Subject Area’s) one for upper management - scorecard, and other for regular business users - weekly sales.
• Integrated the Essbase cube to fetch the financial data into the .rpd and generated the answers.
• Integrated Active directory for authentication and authorization of users.
• Installed and configured production components /Go live

Technology: OBIEE 10g, SQL server 2005

Confidential, Palo Alto, CA

Senior OBIEE, OBIA Developer

Responsibilities:

• Responsible for gathering, analyzing, building AS-IS and TO-Be business processes, build work flow analysis, identify key gaps, while prioritizing those requirements to best fit business transformation needs and overall program, project initiatives which includes design and development phases for the OBIEE. My responsibilities included working with the SME’s to develop requirements and assessing the level of scope. During the client JAD sessions I gave recommendations on what functionality in OBIEE is available out-of-the-box and others that needed to be customized. I then managed and architected the project (team sized was 5 resources) from developing the Functional and Technical Design Specifications Document, implementation, testing, and Deployment.
• Audit OLTP database, recommended remediation plans and facilitate the data Integration and cleansing process.
• Defined standards for interfaces with external data sources.
• Mainly involved in the project definition, project discovery & design and development phase of the project. Created Project Charter, Project plan, Communication & Change control management plan and defined release and test strategy for the entire initiative.
• Mapped the new Business requirements to standard OBI out-of-the-box functionality and performed Gap Analysis. Defined efforts involved in addressing gaps and rated the gaps based on complexity involved.
• Worked closely with the Business to define Analytics requirements and maintain a data quality Service Level Agreement.
• Worked with Application Development and Support to address application and interface flaws that may contribute to a loss of data quality.
• Configured out-of-the box and custom Analytics/Dashboard reports using Siebel Answers
• Involved in designing and development of building Physical Layer, Business model and presentation layer.
• Designed and build OBI data model, designed & customized Star and Snowflake schemas by extending Fact and Dimension tables.

Technology: EBS 11.5.10, OBIEE - Partner Reporting Infrastructure, Confidential BI Apps (Siebel PRM 7.8, Informatica 7.1.4, Confidential 10G, SQL Server 2000, Erwin 7.2. ODI (Sunopsis).