SUMMARY:

• 10 years of total IT experience.
• Extensive of experience in Business Intelligence Applications using Siebel Analytics / Oracle Business Intelligence (OBIEE) / Oracle Business Intelligence Apps (BI Apps) / Microsoft Business Intelligence (MSBI) with SQL Server 2012 / Tableau Visualizations and Dashboards.
• Expertise in Business Intelligence Applications using Siebel Analytics / Oracle Business Intelligence (OBIEE/OBIA) in Marketing, Sales, Procurement modules.
• 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.
• Expertise in ETL using Informatica to facilitate Extraction Transformation and data Load from OLTP systems to OLAP systems.
• 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 Oracle DAC installation and configuration, Tasks creation, synchronization, and execution (data warehouse load).
• Experience in creating entity relational & dimensional relational data models with Dr. 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.
• All round experience in the BI/Data warehousing domain including some exposure/understanding to ETL and data modeling.
• Strong analytical skills; ability to analyze raw data, draw conclusions, and understand how best to visualize.
• Knowledge of data manipulation using R, PYTHON, and SAS programming.
• Knowledge using MSBI with SQL Server 2012.
• Strong aptitude for learning and understanding business process and needs.

TECHNICAL SKILLS:

BI: OBIEE 10.1.3.3/ 10.1.3.4/11 g/12c,BI Publisher, DAC 7.x, Siebel Analytics 7.7 / 7.8, MS BI, TABLEAU 9.x/10.x

ETL: Informatica Power Mart, Informatica Power Center 9.x/8.x/7.x/6.x

Languages: SQL, PL/SQL, HTML, C, C++, C#, XML, SAS, R, PYTHON

Databases: Oracle 11g, 12c, Microsoft SQL SERVER 2005, 2008, 2012

Tools: Clear case, Visual Source Safe

OS: Windows XP/2010, UNIX, Linux

WORK EXPERIENCE:

Confidential, Houston, TX

OBIEE 11g Developer/ BI Apps Developer/ Tableau developer

Responsibilities:

• Interacted effectively with the end users for requirement gathering and defined requirement specifications document.
• Designed dashboards and reports that summarized data for digital marketing metrics using Tableau.
• Installed, Configured and developed BI Apps Financials, HR modules.
• Worked extensively with Physical Layer, Business Layer and Presentation Layer.
• 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.
• Built Business model and established relationships & Foreign Keys Physical & Logical between tables.
• Created business reports using BI Answers as per requirements.
• Developed dashboards and visualizations that empower decision makers.
• Diagnosed and responded quickly and effectively to service desk requests regarding data integrity and functional or interactive issues in existing and future dashboards.
• Generated various Analytics Reports using global and local filters.
• 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
• Set up LDAP authentication to enable Single Sign on for Users in Development environment leveraging Analytics Repository.
• Used Informatica Mapping Designer to create/update mapping using different transformations required to move data into data warehouse.
• 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.
• Monitored Incremental & Full load through DAC.
• Responsible for installing, configuring, developing, support and maintenance of the BI APPS.

Environment: OBIEE 11g, BI Apps 7.9.6.3, Web Logic Server, Tableau 10.5, Informatica 9.0.1, Oracle 11.2.0.2, SQL, PL/SQL, DAC 7.8.4, TOAD, SQL* Plus, Linux, Windows XP.

Confidential, MN

Siebel Analytics/Siebel Analytics Applications

Responsibilities:

• 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.
• Developed Reports / Dashboards with different Analytics Views (Drill - Down / Dynamic, Pivot Table, Chart, Column Selector, with global and local filters) using Oracle BI Presentation Services.
• Setup Multi User Development Environment (MUDE) in OBIEE.
• Created new requests and opened Answers for adhoc reporting to the End users
• Used Informatica Mapping Designer to create/update mapping using different transformations required to move data into data warehouse.
• Used Informatica Power Center Workflow manager to create sessions, batches to run with the logic embedded in the mappings.
• 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.
• Documented all the configurations and new reports creation and published it to the end users.
• Involved in the preparation of Technical design documents, Source to target (S2T) document, review checklist and Technical Specifications.
• Created proper documentation to describe program development, logic, coding, testing, changes and corrections.

Environment: Siebel Analytics 7.8.4, BI Apps 7.8.4, Informatica 7.1, Oracle 10g/9i, SQL, PL/SQL, DAC 7.8.4, TOAD, SQL* Plus, Unix, Windows XP.

Confidential, Minneapolis MN

OBIEE/BI Apps Developer

Responsibilities:

• Full project life cycle implementation for Oracle Business Analytics Warehouse (OBAW)
• Performed Project Scoping, Project Organization and Management including Business & IT Requirements, Priorities, Project Execution Plan and Resource Plan.
• Created Custom SDE Adaptors and built new Subject areas and Execution Plans in DAC for new customized subject area.
• Expertise with Siebel Base tables and EIM workflows.
• Used the OBIEE 10.1.3.4 Administration tool to develop and enhance Data Model.
• Configured and created OBIEE Repository, Involved in modifications of the physical, the BMM, and the presentation layers of metadata repository using OBIEE Administration Tool.
• Designed schema using KPIs, Fact, Dimensions, Physical, Logical, Alias and Extension tables.
• Built Business Model and established relationships & Foreign Keys (Physical & Logical) between tables.
• Identified the aggregate levels for measures and created dimension hierarchy sources for each level of aggregates for performance enhancement.
• Created executive level Reports and Dashboards catering to provide insight into the sales / marketing data.
• Developed custom reports/Ad - hoc queries using Answers and assigned them to application specific dashboards.
• Developed BI Consumer reports using OBIEE 11g.
• Expertise in segmentations and scheduled programs on daily basis.
• Expertise in SQL check and List pulls.
• Proficient in using Xcelsius tools.
• Developed new Informatica mappings for enhancement and bug fixes for various brands as per various requirements.
• Worked on Informatica Performance tuning methods like various ways of using lookup caches depending on the size of source and lookup tables.
• Added new facts and Dimensions to the OBAW and created new execution plan in DAC for dial load into these table.
• Proficient in working with HP Service center and Quality center.
• Worked in production support and seen through the phase of the developments in the production and done various bug fixes.
• Worked with Siebel EIM tables and tweaked the batch file (.ifb) to process more no. of rows at a time.

Environment: OBIEE 10.1.3.3./11 g, BI Apps 7.9.6, Xcelsius, Informatica 8.0, Oracle 10g, SQL, PL/SQL, DAC, TOAD, SQL* Plus, Windows XP.

Confidential, MEMPHIS, TN

Siebel Analytics Developer

Responsibilities:

• Worked closely with the business community to assess business needs, define requirements and Implement solutions.
• Interacted with different QA teams and program managers located at different locations in onshore and offshore before delivering fix packs to customers ensuring quality of fix packs.
• Design Siebel Web Components including OBIEE Answers and Intelligence Dashboards.
• Implement Marketing Analytics module from Oracle BI Apps.
• Implemented new data modeling and new hierarchies on the existing marketing module as per client requirements.
• Customized Siebel Repository defined Physical Data Layer and developed Business Model and Presentation Layer using Siebel Analytics Administration Tool and using OBIEE.
• Configured DAC and created containers, subject areas and tasks.
• Customized the repository and created new requests using Answers.
• Managed day - to-day .rpd, Scheduler &iBots
• Worked on creation and configuration of Siebel dashboards, customized reports and charts (like Sales, Service and marketing), in Siebel Answers.
• Redefined hierarchies in Marketing Accounts and contacts as per client requirement.
• Mapped the tasks to execute mappings in Informatica.
• Extensively used Transformations like Lookup, Router, Aggregator, Source Qualifier, Joiner, Expression, and Update Strategy.
• Modified mappings as per the changed business requirements.
• Developed UNIX and PL/SQL scripts to automate chronological loads.
• Used Toad to debug the SQL query to identify duplicate rows in the warehouse tables, and to debug the SQL query issued during report execution.

Environment: OBIEE, DAC 7.9.4, Oracle 10g, SQL, PL/SQL, UNIX, Windows XP.

Confidential, Houston, TX

Field Support Engineer Technician

Responsibilities:

• Analyzed LAN to determine what were the major problems and improvements needed to be made to the network infrastructure.
• Performed Project Scoping, Project Organization and Management including Business & IT Requirements, Priorities, Project Execution Plan and Resource Plan.
• Involved in node segmentation and network engineering projects.
• Worked on design verification, fiber documentation and quality control.
• Examined and tested lines or cables, recording and analyzing test results to access transmission characteristics and establishing faults and malfunctions.
• Measured signal power at utility poles, by means of electronic test equipment.
• Identified potential risks in the cable systems by conducting regular maintenance and inspection.
• Attended to problems regarding interrupted signals.
• Monitored the daily performance of all cable networks.
• Interpreted technical manuals during problem investigations.
• Provided the corrective solutions for the breakdown or problems faced.
• Installed network equipment and cables and checked their performance.
• Conducted field service trips to install, repair, and set up systems amplifiers and line extenders.
• Prepared reports for completion of the tasks and submitted them to the management.

Confidential, New York NY

Design Engineer

Responsibilities:

• Designed computers networks namely LANs, MANs, and WANs for Fortune 1000 companies.
• Worked on multiple large scales WAN projects and provided capacity planning and expert assistance on future growth.
• Supported senior network administrators in setting up hardware and installing software.
• Assisted in wiring and installing peripherals and multi drive network servers.
• Tasked with using bridges, routers, hubs, network servers, peripherals, and associate cabling to allow various computer systems to be linked into a homogenous network.
• Designed and implemented network installations using Cisco routers and switches, voice gateways and IP phones.
• Developed implementation plans and wrote design documents.