SUMMARY

• Over 12+ years of IT Experience in Informatica Administration, Powercenter, Metadata Manager & Reporting doing Financial Analytics, Requirement Analysis, Applications & Data Testing, Release notes, Production support validations for DataWarehousing (DW) solutions.
• Business and Domain knowledge in Financials, Banking, Retail, Manufacturing, Media & Communications verticals with Oracle EBS Database.
• 8+ years of Informatica Power center, Metadata Manager, Informatica Administration, Quality assurance QA, Mappings, Sessions, Workflows, Power Exchange, Data Integration experience for Enterprise Data Warehouse solutions.
• 4+ years of extensive data validation experience in Oracle OBIEE Financial Analytics, Business Intelligence (Reports Development, Dashboards, iBots and Delivers), User Management, OBIEE Administration, Oracle DB, Autosys and Web services.
• 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.
• Expertise in Building Executive Dashboards using Dashboard Manager for Siebel Analytics Web / Oracle Presentation Services for Siebel Analytics / OBIEE.
• Expertise in Data Modeling design, analyze and implement - conceptual, logical and physical data model, Data conversion, Data integration and Data Mining specialization in the area of Data Warehouse and Business Intelligence.
• Experience in creating entity relational & dimensional relational data models with Ralph Kimball Methodology i.e., Star schema and Snowflake schema.
• Worked closely with Users, Developers and Administrators to resolve ongoing Production Problems by reviewing design changes made to production systems and made corresponding changes to OBIEE Repository.
• Delivering Informatica Mappings, Data Latency, Performance Iterations.
• Experience in Teradata DB, BTEQs, Oracle Loader, Unix, PERL scripting for reports generation using Agile Delivery model.
• Implementing the LDM/PDM efforts in EDW.
• Substantial work on Legacy Data systems.
• Significant experience using C++, Web consumer services, Notifications, Siebel EIM, Siebel configuration and Siebel workflows.
• Implementations for various Enterprise OBIEE applications.

PROFESSIONAL EXPERIENCE

Confidential

Responsibilities:

• Worked extensively with Administration, Mappings, Workflows and Sessions from Database, Quality assurance QA tasks.
• Created numerous executive level reports. 'Dashboards' were generated to provide insight into the financial data.
• Designed Schema/Diagrams using Fact, Dimensions, Physical, Logical, Alias and Extension tables.
• Created different types of Customized Reports Drilldown, Aggregation to meet client requirements.
• Strong OBIEE Reports and Dashboard design/debugging/development with data pipeline problems with Informatica ETL are being addressed.
• Strong OBIEE front End Development, Notifications, Reports Metrics, Aggregation metrics etc
• Experience with Extract data/Load data from/to Salesforce using Informatica PowerCenter 9.5.
• Development experience with real-time Informatica Applications, Informatica data service and web service.
• Ability to work with BI Events and Scheduling, LDAP, Active Directory settings, Native address book content
• OBIEE users, Security authentication, groups, privileges etc, Single signon, log management, Report runs tracking
• OBIEE Metrics derivation, association and data dependencies, User Management and logs
• Repository Management, Business Hierarchy, Metrics presentation standards, Reporting standards etc
• Ability to work with Data Lookups and Reusable transformations
• Experience in Performance Tuning, both OBIEE reports and data latency
• Working in various applications team collaborations routinely delivering new outputs in a phased manner.
• Taking inputs from Onsite team and putting them into development on adaily basis.
• Preparing Autosys JIL files, running autosys jobs etc.
• Preparing Runbook's, Technical design documents and daily status inputs.

Environment: Informatica Administration, Metadata Manager, Mappings, Sessions, Workflows, Data Layer, Informatica Repository, SQL queries, Oracle, Teradata Utilities BTEQ, Scripts, Korn, Microsoft Office

Confidential

Responsibilities:

• Informatica Administration, Powercenter, Metadata Manager, Quality assurance QA tasks
• OBIEE reporting expert to collaborate with various business teams to deliver Reports and Dashboards
• Powercenter, OBIEE Design reviews, development reviews and Implementation efforts
• Created business reports using BI Answers as per requirements.
• Generated various Analytics Reports using global and local filters.
• Oracle EBS, Identified the aggregate levels for each source and created dimension sources for each level of aggregates.
• Added users and configured security in web logic console of OBIEE 11g.
• Managed security privileges for each subject area and dashboards according to user requirements
• Created workflows for full load and incremental loads to be used by DAC.
• Assembled subject areas and created execution plan and accommodated the new Informatica mappings.
• Monitoring Incremental & Full load through DAC.
• Trained End Users and Pilot Users about OBIEE Tools.
• Source to target OBIEE Data mappings development review and suggestions
• Developed BI Consumer reports using OBIEE 11g.
• Expertise in segmentations and scheduled programs on daily basis.
• Expertise in SQL check and List pulls.
• Sessions, workflow development and execution
• Unit test cases preparation and parallel unit testing
• Excellent communications (oral and written)
• Strong interpersonal skills and data analysis skills
• Defect tracker, Jira, HP ALM, Various Data Interfaces
• QA, Sprint planning review and sprint participation

Environment: Informatica Powercenter, Metadata Manager, Administration, QA, OBIEE, Oracle EBS, Manual testing, JIRA, Sprint planning, Agile methodology, SQL developer Interface, SQL, ORACLE 11g and Microsoft suite

Confidential

Responsibilities:

• OBIEE technology initiative to deliver Sales applications portal potraying key metrics about the organization performances.
• Quaterly reports review, Configuring config file, administering OBIEE, Design reviews, development efforts and Implementation
• Full project life cycle implementation for Siebel Business Analytics Warehouse.
• Involved in business requirements gathering and translated the requirements into technical requirements.
• Installed and Configured OBIEE, DAC and Informatica on Unix/Windows Environment.
• Customized and developed RPD (Physical, Business model and Presentation Layer), configured metadata objects and Web Catalog Objects.
• Sessions, workflow development and execution
• Unit test cases preparation and parallel unit testing
• Excellent communications (oral and written)
• Strong interpersonal skills
• OBIEE Troubleshooting and Incident management

Environment: OBIEE 11g, Informatica PowerCenter 9.5(Mapping designer, Workflow Manager, Workflow Monitor, Repository Manager), SQL developer Interace, SQL, ORACLE 10g and Microsoft suite

Confidential

Responsibilities:

• Strong ETL design/debugging/development skills using Informatica 9.5.
• Experience with PowerExchange & CDC Real-Time (Datacom preferred) using Informatica PowerCenter 9.5.
• Experience in Mapping Designs and Workflow designs
• Experience with Extract/Load data from/to Salesforce using Informatica PowerCenter 9.5.
• Development experience with real-time Informatica data service and web service.
• Ability to work with Events and Scheduling
• Ability to work with Lookups and Reusable transformations
• Experience in Performance Tuning
• To monitor the everyday production runs.
• To troubleshoot any issues arising out of the production runs.
• To run siebel analytics(OBIEE) reports as and when requested.
• To troubleshoot any data discrepency errors arising out of siebel analytics(OBIEE) reports.
• To manage the Siebel Analytics platform in Quality and Production environments.
• Excellent communications (oral and written)
• Strong interpersonal skills

Environment: OBIEE 10.1.3, Informatica PowerCenter 9.5, Informatica PowerExchange, and ORACLE 10g

Confidential

Responsibilities:

• Understanding the scope of the project and functionality of the business at Dish network.
• Strong ETL design/debugging/development skills using Informatica 9.5.
• Experience in Mapping Designs and Workflow designs
• Experience with Extract/Load data from/to Salesforce using Informatica PowerCenter 9.5.
• Development experience with real-time Informatica data service and web service.
• Ability to work with Events and Scheduling
• Ability to work with Lookups and Reusable transformations
• Experience in Performance Tuning
• Co-ordinate the onsite call which happens routinely every day basis.
• Taking inputs from Onsite team and putting them into development on adaily basis.
• Developing Informatica mappings and Workflows to migrate data fromsource systems to staging area's.
• Writing Teradata Bteq's to complete the load migration thru stagingto the end target tables.
• Preparing Autosys JIL files, running autosys jobs etc.
• Preparing Runbook's, Technical design documents and daily status inputs.

Environment: OBIEE, Informatica PowerCenter 9.5, Informatica PowerExchange, Teradata V2R6, Teradata Utilities BTEQ

Confidential

Responsibilities:

• Collection of Requirement specifications.
• Extensively involved in preparation of Design Specifications.
• Responsible for Delegation of Tasks to offshore Dev Team.
• Involved in development and enhancement of ETL tasks.
• Worked with mappings design which includes active and passivetransformations.
• Extensively worked with Lookup, Expression, Aggregator and update strategy transformations.
• Creating JIL's in Autosys and testing Autosys boxes.
• Responsible to Handle Status calls with customer/onsite teams.
• Monitor and train the resources in ETL Informatica.
• Generation & Monitoring of Test Plans and Test Cases.
• Taking Domain and Quality level standards trainings on a time to time basis.

Environment: OBIEE, Informatica PowerCenter 8.1, Informatica PowerExchange, Autosys, JIL’s, Oracle Database, Unix

Confidential

Responsibilities:

• Requirement Analysis, ETL Coding, Unit/Integration/System testing sand Implementations.
• Daily monitoring of Production and test environments. Analysis andfixing issues in UAT as and when required.
• Domain knowledge interactions, Business Analyst reviews & Dailyupdate meetings with the Client & IT service/support groups.
• Data Transformations using ETL Informatica loading data fromSources/Legacy files to Staging & Target access layers.
• Designed and developed various Mappings, Mapplets, Active &Passive Transformations.
• Used various Transformations like Expression, Filter, Joiner andLookups for Data Conversions and accommodating business rules.
• Designing and configuring sessions with effective caching andoptimized values.
• Involved in creating, editing and scheduling of workflows usingworkflow manager in Informatica and Autosys Job scheduling tool.
• Writing Test Plans and test cases, Integration testing for the ETLcode.
• Handled time critical development requirements and delivery reviews.
• Migration of ETL code to Production environment and post production monitoring and support.
• To run siebel analytics(OBIEE) reports as and when requested.
• To troubleshoot any data discrepency errors arising out of siebel analytics(OBIEE) reports.
• To manage the Siebel Analytics platform in Quality and Production environments.

Environment: OBIEE, DAC, Informatica PowerCenter 7.1, Informatica PowerExchange, Autosys, JIL’s, Oracle Database, Unix, OBIEE 10.1.3, Sun Solaris 5.6

Confidential

Responsibilities:

• To run siebel analytics(OBIEE) reports as and when requested.
• To troubleshoot any data discrepency errors arising out of siebel analytics(OBIEE) reports.
• To manage the Siebel Analytics platform in Quality and Production environments.
• Interactions with the Business Analyst.
• Understanding the current client environments.
• Strong ETL design/debugging/development skills using Informatica 9.5.
• Experience with PowerExchange & CDC Real-Time (Datacom preferred) using Informatica PowerCenter 9.5.
• Experience in Mapping Designs and Workflow designs
• Experience with Extract/Load data from/to Salesforce using Informatica PowerCenter 9.5.
• Development experience with real-time Informatica data service and web service.
• Ability to work with Events and Scheduling
• Ability to work with Lookups and Reusable transformations
• Experience in Performance Tuning

Environment: Informatica PowerCenter 7.1, OBIEE 10.1.3, DAC, Informatica PowerExchange, Autosys, Unix, Sun Solaris 5.6, Oracle Database

Confidential

Responsibilities:

• Experience in Mapping Designs and Workflow designs
• Experience with Extract/Load data from/to Salesforce using Informatica PowerCenter 7.1.
• Involved in development and enhancement of ETL tasks.
• Worked with mappings design which includes active and passivetransformations.
• Extensively worked with Lookup, Expression, Aggregator and update strategy transformations.
• Creating JIL's in Autosys and testing Autosys boxes.
• Responsible to Handle Status calls with customer/onsite teams.
• Monitor and train the resources in ETL Informatica.
• Ability to work with Events and Scheduling
• Ability to work with Lookups and Reusable transformations
• Experience in Data Mappings and Performance Tuning

Environment: Informatica PowerCenter 7.1, OBIEE 10.1.3, Informatica PowerExchange, Autosys, Unix, Sun Solaris 5.6, Oracle Database