SUMMARY:

• Tableu, ETL(SSIS), SSAS, OBIEE, OBIA Solution Architect/Lead/SME (15 plus years)
• Involved in end to end development/design which includes the following responsibilities
• SQL Server 2008 to 2017, SSIS, SSMS and SSAS - Worked extensively on various versions of SQL Server, SSIS DTSX packages and exposure to SSAS.
• OBIEE/Siebel Analytics (8 Projects, 10 Years’ experience)
• End to end project architecture design, Data Modelling, Customization, ETL, RPD, Dashboards and Reports development.
• Expertise in succeeding proof of concepts (POC), Prototypes, Mockups for requirements/feasibility phases
• Hands on expertise, SME, Architect and Lead roles
• Creation of Technical design docs/Functional specs for the RPD Metadata and Advanced Dashboard and complex report development in 11g.
• Projects include Siebel Analytics 7.7,7.8, OBIEE 10g, OBIEE 11g and Exalytics
• Experience implementing 11g Security, Using EM, Web logic Admin and Oracle 11g Stack Architecture
• OBIEE Administration, RPD, Webcat migrations, Installations and configure OBIEE 11g Stack
• Experience in implementing LDAP, OID and OSSO implementations in OBIEE
• Professional experience with First-rate knowledge in Siebel Analytics Data warehouse concepts & Siebel Analytics DW Developer
• Extensive knowledge in using BI Publisher 11.1.1.6 , BI Publisher Desktop version
• Creation of pixel perfect PDF reports and style templates
• Creation of Data Models, Datasets using Analysis, SQL and xml
• Exalytics, Exadata, Times Ten, Exa logic
• Summary Advisor, issues and trouble shooting
• Usage of Dashboards/reports/RPD on Exalytics
• Solution the deployment of BI components in Oracle Engineered Systems (Exalytics and Exadata)
• Expertise on Shell Scripts (Run Summary Advisors, Check ETL completion Status, Run Ibots, Purge cache etc.) and skills in using Linux and Unix Operating Systems, Shell and Cron Scripts
• Using Informatica 7.1 and 9.1 / DAC 7.9, and 11.1.1.6 and Oracle R12
• Using Siebel CRM, EBS and HR as Source Systems
• Customization and extending DW
• ETL Development/Support for Informatica and DAC
• Development and real time production support using MS SQL Server SSIS/DTSX packages
• Development and real time production Support Experience using Informatica 7.7 and 9.1
• Development and real time production Support Experience using Data Stage 9.1
• Production Support on running jobs using Zeke/Mainframe
• Hands-on expertise in CRM (Siebel) Domain, CRM software development using SIEBEL ( 7.5 to 8.0 ).
• Siebel Tools, Siebel Scripting, Siebel Call Center and Data Model
• SQL/PL SQL programming, DB Design and Tuning
• Expert in Dimensional Modelling and Relational Data Modelling
• Extensive knowledge using ERWIN and Other Data Models
• Data Architect, Data governance, data quality and exposure to MDM concepts
• Experience in working the Data architect teams and corporate data models
• Hands on expertise with Performance Tuning
• Tuning at various levels RPD, DB, Web cat, DAC and ETL
• Work with clients and business analysts to translate requirements to OBIEE/DW environment.
• Work with Oracle Tech support for any un-resolved issues.
• Present POC, mock ups, conduct review meetings and technical brain storming sessions with clients
• Excellent problem solving skills with a strong technical background and good interpersonal skills.
• Solution oriented & Excellent Team player.
• Ability to lead bigger teams, task distribution, Daily Status reports, Drive Weekly Con calls, Review actual status and analysis, Timely updates on progress and immediate notification of problems.Conversion of Hyperion data models/ reports/dashboards to OBIEE data models/reports/dashboards
• Working knowledge on Hyperion Reporting tool and Hyperion Interactive Reporting Studio 11.1.2.2

TECHNICAL SKILLS:

TABLEAU: Tableau 10.1 onwards, Dashboard Developement, Tableau Server Administation, MS SQL Server SQL Server 2008 to 2017, SSMS, SSIS Packages, SSAS, MS Visual Studio, Import/Export Wiz, Package Utilities, Python Script integration for Custom schedules.

ORACLE BUSINESS INTELLIGENCE: OBIEE 11.7.1.3.1 , OBIEE 10g,Informatica Power Center 8.6.1,7.4,ETL, DAC 7.9.6.1,RPD,Webcat, Exalytics, Exadata

SIEBEL ANALYTICS: Siebel Analytics (7.7,7.8), Informatica Power Center 7.1,ETL,DAC,RPD,Webcat

BI PUBLISHER: BI Publisher 11.7.1.3.1 , BI Publisher 10.1.3.2.1 , BI Publisher Desktop version

HYPERION: Oracle Enterprise Performance Management System (EPM) Workspace, Fusion Edition - 11.1.2.3, Hyperion Interactive Reporting Studio - 11.1.2.2

ETL/INFORMATICA: Informatica Power Center 8.6.1,7.4,7.1,6.1, Data Stage 8.7

SIEBEL: CRM Siebel 7.5, 7.7, 7.8. (Siebel Tools, Siebel VB, escript, VBC, EBC, Web Services

RDBMS: Oracle, Confidential, SQL Server, MS-Access

TOOLS: Microsoft Project, TOAD, SQL Assistant, Microsoft VSS,XML Spy, UML, MS-Visio,WinRunner, Load Runner, Erwin Unix, Solaris, HP-UX, AIX, Windows NT, Win CE and Win XP

PROFESSIONAL EXPERIENCE:

Confidential, Atlanta, GA

BI Technical Architect (Tableau, Confidential, ETL Lead)

Environment: Tableau 10.2, Confidential 15.0, SQL/PLSQL, BTEQ, SSIS packages, SSAS, SSMS, MS SQL Server 2008 R2

Responsibilities:

• Created 10 rich dashboards using Tableau Dashboard and prepared user stories to create compelling dashboards to deliver actionable insights.
• Responsible for interaction with business stake holders, gathering requirements and managing the delivery.
• Created a Sharepoint portal with published Reader versions for un-licensed User base.
• Created custom and advanced visualizations using Data Blend and other Techniques.
• Migration of Tableau Dashboards from SQL Server to Confidential without breaking Presentation Layers.
• Generate KPIs for Revenue Management Analytics.
• Creation of metrics, attributes, filters, reports, and dashboards created advanced chart types, visualizations and complex calculations to manipulate the data.
• Transformed Tableau into a managed service offering for consumption across America, AMEA and Greater China regions.
• Act as a Point of Contact/Administrator in Data Interoperability, Analytics and Business Intelligence and Production Support issue resolution.
• Implemented advanced geographic mapping techniques and use custom images and geo coding to build spatial visualizations of non-geographic data.
• Work directly with management, vendors, and third parties to ensure that Web-site’s financial transactions and database management applications operate at peak efficiency.
• Ensured projects were completed on time and within budget.
• Played key role in enhancing client’s Web reporting system, reducing time of delay financial tracking analysis by 30%.
• Consolidate multiple data silos that exist on to one location.
• ·Scheduled data extracts on a daily basis.
• Server Reboot, weekly maintenance, Tab Commands, Log file cleanup, DB Connectivity issues, authentication issues etc.
• Create Users
• Create Projects
• Assign Permissions
• Create Data Sources
• Create and Publish Extracts
• Create Refreshes/Tasks
• Site Admin Role
• Manage both Online and Desktop Server versions
• Analyze Site Usage and Performance
• Configure Site Access
• Created 20 Stored Procedures.
• Create ETL SSIS Packages for monthly, daily and weekly ETL Loads.
• Schedule SSIS Packages
• Well versed with Microsoft SQL Server Visual Studio and all other Tools
• Design and develop Entire ETL for 10 different Tableau Dashboards.
• Create Python Scripts and integrate SSIS Packages, Stored Procs using BAT files/Python Scripts
• Create ETL Scheduled Tasks, BAT Files for automation.
• Design/Develop/ SSAS Cubes
• Connect SSAS Packages to Tableau

Confidential

Responsibilities:

• Build and maintain SQL scripts, indexes, and complex queries for data analysis and extraction.
• Designed, developed and supported BI solutions, Involved in Debugging and monitoring, and troubleshooting issues.
• Create and maintain Data Models.
• Create and maintain Complex Stored procedures using Confidential (created more than 25 complex stored procedures)
• Performance tuning and maintain data volumes
• Constantly maintain the Spooling issues, Data lab
• Coordinate with BI/Tableau team for the data requirements
• Assist BI/Tableau team with data and the business logic
• Confidential Explain plan and Collect Stats
• Confidential Architecture and Indexing strategy
• Usage of Confidential derived tables and complex queries
• Create Materialized Views in Confidential and access it through Tableau Reports/Dashboards

Confidential, Florida

BI Technical Architect

Environment: SSIS packages, SSAS, SSMS and MS SQL Server 2008 R2, Tableau

Responsibilities:

• Coordinated for the purchase of SQL Server 2017 in AWS RDS Instance.
• Setup SQL Server in AWS.
• Setup AWS-RDS, Setup Security Groups, Cloud Buckets, configure through AWS Console, Backups, Mirroring
• Design and develop ETL, SSIS Packages for the entire project
• Design ETL to load 225 million worth of Historical data.
• Design ETL to transform data from Star Schemas to De-normalized data structures
• Create Stored Procedures
• Create Indexes, Performance tuning
• Create ETL Tasks using SSIS, Python and Schedule
• Data validation and SQL View Creation
• Connect Tableau to SSAS Cubes

Confidential, Orlando

BI Technical Architect

Environment: SSIS packages, MS SQL Server 2008 R2, Tableau

Responsibilities:

• Develop strategy to load historical data from 2003 to 2017
• Reverse Engineer the Informatica ETL to understand the existing Policy, Claim, Coverage and Vehicle History mapping.
• Design Business logic and ETL mapping documents.
• Design and develop ETL, SSIS Packages for Monthly Policy and Claim ETL’s.
• Design ETL to transform data from Star Schemas to De-normalized data structures
• Create Stored Procedures
• Create ETL Tasks using SSIS, Python and Schedule
• Data validation and SQL View Creation
• Create/Update SSIS Cubes.
• Connect Tableau to SSIS Cubes.

Confidential, Atlanta, GA

BI Technical Architect

Environment: Confidential 15.0, SQL/PLSQL, BTEQ, SSIS packages, MS SQL Server 2008 R2

Responsibilities:

• Constant interaction with the various stake holders (Business users, partners and vendors) to gather requirements
• Assist business partners to Create reports based on Direct DB Requests to Confidential
• Provide Segmentation insight and decision capabilities to business partners through Confidential programs
• Create and maintain Data Models
• Create and maintain Complex Stored procedures using Confidential (created more than 30 complex stored procedures)
• Create and schedule SSIS jobs
• Trouble shoot and update SSIS packages
• Performance tuning and maintain data volumes
• Constantly maintain the Spooling issues, Data lab
• Coordinate with BI/Tableau team for the data requirements
• Assist BI/Tableau team with data and the business logic
• Confidential Explain plan and Collect Stats
• Confidential Architecture and Indexing strategy
• Usage of Confidential derived tables and complex queries
• Create Materialized Views in Confidential and access it through Tableau Reports/Dashboards

Confidential, Atlanta, GA

BI Technical Architect (OBIEE) / Senior Dashboard, Report Developer

Environment: OBIEE 11.1.1.7140175 , Data Stage 8.7, BI Publisher 11.1.1.7, Confidential 15, Exadata, Exalytics, Times Ten, Oracle Enterprise Performance Management System (EPM) Workspace, Fusion Edition - 11.1.2.3,

Responsibilities:

• Create requirement documents, HLDs, LLDs
• Design and Architect the 11g Stack, Security, development and deployment
• Work with users, presentations, brain storming sessions
• Team leading and mentoring
• Shell scripts for Summary Advisors/Invoking Ibots/Purging cache/ETL completion status
• Customization of Trend Lines in Charts
• Sending XML reports (BI Publisher) to Tibco Messaging
• Complex Materialized Views in RPD
• Digital version of BI Publisher reports
• Complex OBIEE PDF reports with more than 200 pages
• KPI’s, KPI watch lists, Score Cards and Strategy maps
• Act as Proxy user to troubleshoot user related access control issues
• SA System Subject Area implementation for the Email profile for the entire corporation.
• Write back feature for Update, Delete and Insert
• Controlling data position in the Charts
• Java scripts / View Selectors for dynamic dashboard page selections
• Complex combined service request reports up to 4 reports etc.
• FTP report outputs using Java/JSP through Ibot Actions
• Usage of Web Services for user authentication
• Design/Develop Business intelligence Reports and Dashboards for the end users using OBIEE
• Creating pixel perfect reports in PDF formats using complex reports and multiple views
• Designing report layouts with pixel perfect templates, paging etc
• Combining multiple reports on Dashboards in to Pixel perfect PDF reports
• Develop all kinds of OBIEE Charts/Drill down reports with pixel perfect formatting
• Expertise in creating variety of Trend Reports/Trend lines/Customization of Chart engine
• Usage of Selection Steps, Calculated Items, Grouping, Shared Filters,
• Advanced Bins, Case Statements,
• Efficient Dashboard and report building with respect to query performance
• Create Complex reports using multiple Pivot tables and variety of Views (Column selector, View Selectors etc)
• Trouble shooting Reports/Dashboards
• Conversion of reports from Hyperion, MS Access to OBIEE
• Create reports based on Direct DB Requests
• Create reports based on Combined Query Requests
• Conditional Navigation, Java Scripts, Federated and Inline queries, Landing/help pages, Calling from Narrative Views etc
• Develop Dashboard pages with standards in place (ex Header, Footer, Guided Navigation, Logos, Page no’s, Print formats etc)
• Data Model below scenarios in RPD Combining data from multiple data sources (federated) Snow flakes, Bridge tables, Star schemas Aggregate navigation and summary tables Hierarchies - multiple, level based, ragged/skipped and parent/child (value based) Modelling multiple facts in single subject area Horizontal and Vertical Federation Fact fragmentation Fact partition Level based measures In line queries / Opaque Views Combining multiple Subject Areas
• Create Dimensional Hierarchies, Level based measures, Calculated items, Alias tables, left/Right Joins in RPD
• Create Initialization blocks, Repository and Session variables
• Create projects and usage of MUD
• Create Subject Areas for efficient Adhoc querying
• Efficient RPD design for query performance
• Developed RPD with the Oracle recommended Best Practices in place
• Create Materialized Views in Confidential and access it in RPD/Reports
• Create reports based on Direct DB Requests to Confidential
• Create BI Publisher reports based on Confidential Views and Queries
• Fine tune reports based of Confidential queries
• Build Opaque views in RPD using Confidential Union queries for cross DB federated queries
• Create BTEQ’s and call them from Data Stage, Mainframe Zeke Scheduler and from Cron tabs
• Usage of Fast Load and Multi Load utilities and handling data movements
• Confidential Explain plan and Collect Stats
• Experience implementing 11g Security, using EM, Web logic Admin and Oracle 11g Stack Architecture
• Creation of Application roles and association of users to role mapping
• 11g Security migration
• Oracle 11g Stack configuration, Java M Bean browser
• Usage tracking and Summary Advisor configuration in EM
• Extensive usage of Ibots/Job Manager
• Email bursting of reports using Data Visibility rules
• Creating System Profiles using SA System Subject Area
• Develop Business intelligence Reports and Dashboards for the end users using BI Publisher
• Creation of BIP PDF/A reports for better size management
• Pixel perfect reporting using the repeating groups/Charting, Grids and variety of BIP Views
• Create advanced and complex reports using variety of Charts, Pivots using BI Publisher
• Sending XML reports (BI Publisher) to Tibco Messaging
• Creating of BIP publisher reports using OBIEE reports, Subject Areas, Query based
• Creation of BIP Data models, data sets using SQL, OBIEE Analysis and xml
• Creation of BIP style templates
• Creation of BIP Scheduler Jobs
• FTPing of BIP reports and bursting
• Usage of Microsoft Office BI Plugins for Custom Excel formatting of the downloaded OBIEE reports
• Interact with end users/clients on day to day basis
• Present Dashboard/report demo’s and deliverables
• Drive Review meetings
• Analysis and design HLD’s and LLD’s
• Design of Test cases/Data Validation, test bed setups
• Translation of business requirements into functional and technical designs
• Participate in walkthroughs of program, code and test specifications
• Develop exception handling, SQL Queries, functions and triggers for data retrieval and data manipulating standards.
• Deploy OBIEE applications into Production environment.
• Ability to troubleshoot Exalytics, Summary Advisor, Times Ten issues and identify and execute resolution
• Expertise on Shell Scripts (Run Summary Advisors, Check ETL completion Status, Run Ibots, Purge cache etc.) and skills in using Linux and Unix Operating Systems, Shell and Cron Scripts
• Aggregate Persistence Wizard
• Tuning at various levels RPD, DB, Web cat and ETL
• Usage of Index, Explain plan, Collect Stats
• Usage of Usage tracking and setup
• Summary Advisor and Aggregate Persistence Wizards
• Webcat migration, archive, permissions
• Webcat Privileges through Admin screen
• Change Management PVCS and Webcat change scripts
• Backup web cats
• Configure Instance config.xml
• Credential stores xml
• Run Ibot’s and trouble shoot
• Setup SNQ tables
• Conditional requests and Ibot trouble shooting through subject area RPD (Development, migration and change management)
• Making sure the best practices are implemented
• Create RPD templates with Global variables etc.
• Create MUD projects
• Configure NQS config.ini
• Conn Pool setups, access, resolve RPD warnings
• DB property Settings
• Grant privileges to underlying tables etc.
• Setting up write back properties etc.
• LDAP and OID setup
• Migrating RPD three way merge, shared RPD
• RPD Security
• User Access control UNIX
• Create shell scripts
• OBIEE instance server start/stop
• Work with Oracle Support team, log tickets, escalate issues, coordinate to resolve
• Data stage objects
• Confidential objects
• Setup Delivery
• Setup Data Sources
• Setup Runtime Configuration
• Reverse engineering using Oracle EPM workspace and Hyperion Interactive Studio
• Analyze existing data models
• Understand Report layouts, charts etc.
• Process queries
• Extract custom SQL, Filters, Grouping, Sorts,
• Derive business logic from logical calculations
• Re design the reports and data models DW and in OBIEE
• Analysis based on .BQY query files and Confidential .oce files
• Subscribe to the existing reports, create Ibots in OBIEE based on existing Hyperion jobs

Confidential, Atlanta, GA

Environment: OBIEE 10.1.3.4.1 , OBI Applications 7.9.6, ETL Tool Informatica 8.6.1, DAC and Siebel Tools.

Responsibilities:

• Design Daily, Monthly, Yearly, Weekly Summary Aggregate Tables
• Aggregate Navigation in RPD, Usage of Aggregate Persistence wizards, Complete Adhoc support.
• Query tune with the help of Explain plan
• Identify the Index strategy columns used in where clause, filters, drill downs, columns that join the dim and fact tables, columns that are used in Prompts. Fix the column with the correct Index type (Bitmap etc)
• Analyze Tables
• Fact Partition (Partition by Range 12 months and 365 partitions)
• Usage of Inline Queries in RPD
• Avoid Casting, String Operations, Case statements while joining in RPD, Less Joins and push the load down to the DB and ETL
• Usage of Driving Tables during Federated queries
• Fragmentation, Inline queries
• UI-All Techniques which render high Usability with low query response time
• Implement DAC tasks and definitions for new Informatica mappings.
• Manage Design/Setup/Execution tabs of DAC repository.
• Run/Schedule ETL from DAC Client, trouble shoot, monitor session/ complete ETL log files, DAC email notifications.
• Troubleshoot DAC Server issues.
• Production Support for ETL issues.
• Unit testing & Support work for deployment & maintenance
• Develop pixel perfect BI Publisher Reports and Dashboards and delivery
• Creating of BIP publisher reports using OBIEE reports, Subject Areas, Query based
• Usage of Microsoft Office BI Plugins for Custom Excel formatting of the downloaded OBIEE reports

Confidential

Technical Architect

Responsibilities:

• Involved in Designing/developing End to End Architecture of the project.
• Implementation of Authentication with OID (Oracle Internet Directory) and integration with OSSO
• Implementation of data visibility (based on vanilla Position Hierarchy)
• Run Full and Incremental Loads and troubleshoot
• Customize mappings with Informatica 8.6.1.
• Experience in customization of Siebel Analytics application (Change password facility etc.)
• Siebel Answers and Siebel Dashboards.

Environment: Windows Client, HPUX, OBIEE 10.1.3.4.1 , OBI Applications 7.9.6, ETL Tool Informatica 8.6.1, DAC and Siebel Tools, Oracle 11g

Confidential, Atlanta, GA

OBIEE - Lead

Environment: Windows, Oracle Business Intelligence 10.1.3.2.1 , OLTP - Oracle 10.1.2.0.2 , OLAP- Confidential 5.5, ETL/ Informatica Power Mart -7.4.

Responsibilities:

• Designed and developed 3 Subject Areas Marketing Reactive Retention, TOSC ad IRSC from the scratch on top of Confidential RPD template
• Meet Confidential RPD standards, pure Time Hierarchies, Hierarchies for all Dims, Proper Aggregation Content settings, Delineation of Presentation Layers for Complete Adhoc supports, no aliasing at presentation Layers, Sort Orders, Alias tables etc
• Confidential specific Conn Pool settings (DB qualifier, Dev Accounts, Usage of Confidential Global Variables, SA name specifications etc)
• Designed and developed more than 100 reports and 3 Dashboards for the above 3 modules on top of the Confidential Web Template
• Develop reports using Bins, GO URLs, Combined Service Requests, Passing Parameters from one Dashboard to Other, Pivots, Calculated items, hidden reports, Conditional Navigation, Java Scripts, Federated and Inline queries, Landing/help pages, Calling from Narrative Views etc
• Develop Dashboard pages with Confidential Standards in place (ex Header, Footer, Landing Pages, Help Pages, Guided Navigation, Confidential logos, Page no’s, Print formats etc)
• Creation of Technical design docs for the RPD Metadata and Dashboard development.
• Creation of User reference guides, Migration Documents, Review documents and Review Check lists
• Code reviews with Confidential Client team for Confidential specific Code standards and Best Practices (RPD/Web cat)
• Create Test Servers at Offshore and interact with QA teams
• Help and lead QA teams in building Test Cases, Test Plans for ETL, OBIEE
• Coordinate for the Defect resolution, bug fixes and QA internal meets
• Help ETL teams to resolve data issues related to Source Systems, ETL Specific
• Identify Slow running reports coordinate for ETL and DB specific fixes
• Collaborate with ETL team in Aggregate design
• Compare OBIEE results with ETL results as part of data validations
• Involved in reviewing, coordinating, partial development of NRSC RPD / Webcat
• Involved in Reviewing NRSC RPD / Webcat
• Involved in Reviewing NRSC RPD / Webcat

Confidential

Responsibilities:

• Creation of Technical design docs/Functional specs Actuate to BI Publisher conversion.
• Liaising with the client for the Business validations and the User sessions.
• IO Creation in Siebel Tools CRM
• Generate XML Data from Siebel CRM
• Create BI Publisher Template RTF’s and XLIFF generation
• Integrate BI Publisher with SIEBEL CRM and Publish Reports in BI Publisher
• Publish BI P Reports in Siebel CRM
• Parameterization and usage SQL joins at BI Publisher

Environment: Windows, BI Publisher, BI Publisher Desktop version, Siebel Tools 6.0, Actuate Reports 6.0

Confidential

Responsibilities:

• Creation of Technical design docs/Functional specs for the RPD Metadata and Dashboard development.
• Liaising with the ETL team to gather requirements and discuss the feasibility & finalizing the technical design according to the architectural guidelines.
• Data model analysis to build the Star/Snowflake Schema.
• Data Analysis to understand the Joins for the Dimensions, Facts involved in the Schema Informatica
• Informatica Mapping development and maintenance using Power Mart Designer, Work Flow Manager, Repository Manager, Work Flow Monitor.
• Pull data from Siebel OLTP to OLAP.
• Configuration of the Informatica Power Mart environment.

Environment: Windows, Oracle Business Intelligence 10.1.3.2.1 , OLTP - Oracle 10.1.2.0.2 , OLAP- Confidential 5.5, ETL/ Informatica Power Mart -7.4.

Confidential, Stamford, CT

Environment: Oracle Business Intelligence 10.1.3.2.1 , EBS, Siebel Application 8.0, OLTP - Oracle 10.1.2.0.2 , OLAP-Oracle- 10.1.2.0.2 , ETL/ Informatica Power Mart -7.4.

Responsibilities:

• Informatica Mapping development and maintenance using Power Mart Designer, Work Flow Manager, Repository Manager, Work Flow Monitor.
• Pull data from 10 external data sources which are not SIEBEL.
• Handle Informatica Design, Informatica Exception Handle Design
• Configuration of the Informatica Power Mart environment.
• Data ware house design and modeling following data warehousing concepts.
• Ibot related requirements
• Configuration required for managing Siebel Delivers
• Action Links
• Integration of Oracle Business Intelligence with SIEBEL
• Implement DAC tasks and definitions for new Informatica mappings.
• Manage Design/Setup/Execution tabs of DAC repository.
• Run/Schedule ETL from DAC Client, trouble shoot, monitor session/ complete ETL log files, DAC email notifications.
• Troubleshoot DAC Server issues.
• Production Support for ETL issues.
• Unit testing & Support work for deployment & maintenance
• Estimation of the work requirements provided by the Business
• High level Design and Involved in building/technical design
• Work with clients and business analysts to translate requirements to Siebel environment.
• Work with Siebel Tech support for any un-resolved issues.
• Provide and develop POC of requirements
• Provide support during the Product and UAT testing phase.
• Involved in supporting the business on the day -to day support