• Over 12 years of IT experience in Data Warehouse and Business Intelligence System design, development, testing and implementation.
• Proven experience in developing ELT/ETL, Performance Tuning and Identifying bottlenecks in process flow.
• Designed dimensional data models using best practices from Kimball methodology.
• 5 years of industry experience using ODI Oracle Data Integrator - Designer, Operator, Topology and Security Manager.
• Good insight into the data model of Oracle Financial modules like Oracle Receivables, Oracle Payables, Oracle Loans and Oracle General Ledger.
• Extensively used ODI Oracle Data Integrator in developing ELT jobs and customizing Knowledge Modules LKM, IKM, CKM .
• Expertise in full life cycle Business Intelligence implementations and have an understanding of all aspects of an implementation project using OBIEE 11g/Siebel Analytics 7.x/Microsoft Analysis Services 2008.
• Experienced in gathering reporting and analysis requirements, documenting the report specifications, implementing the metadata layers including Physical, Business Model and Mapping, and Presentation layer.
• Expertise in design and development of the three layers Physical/Business Model and Mapping/ Presentation of an OBIEE Metadata Repository using Oracle BI Administration Tool.
• Highly skilled at configuring OBIEE Metadata Objects including repository, variables, interactive dashboards, and reports.
• Installing and Configuring ODI and OBIEE in windows environment.
• Extensively worked with various kind of application data like Oracle Finance, CRM, ERP, Orders and Sales, Self-Serve, Web Analytics, Foresee Survey, LDAP, online campaigns, middle ware
• Experienced in Requirement Analysis, Test Design, Test Preparation, Test Execution, Defect Management, and Management Reporting.
• Strong database experience in Oracle and MS SQL Server. Extensively worked with T-SQL, PL/SQL, SQL Loader, Stored Procedures, Cursors, Constraints, Triggers, Indexes-B-tree-Index, Bitmap Index, Views, Inline Views, Materialized Views
• Experienced working with offshore vendors and establishing offshore teams and processes.
• Excellent self-learner and team player with an ability to perform individually, good interpersonal and analytical skills
• Facilitated JAD sessions and interviews.

SKILL SUMMARY

PROFESSIONAL EXPERIENCE

Confidential

Lead ODI/OBIEE ETL Consultant

• The Export-Import Bank of the United States Ex-Im Bank is the official export credit agency of the United States. Ex-Im Bank's mission is to assist in financing the export of U.S. goods and services to international markets.
• Leading customized integration effort to incorporate Oracle E-Business Suite EBS Financials and Oracle Loan.
• Integrated Oracle E-Business Suite EBS Financials and Oracle Loan to the current data warehouse. The Oracle EBS is replacing one of major data sources of the data warehouse.
• Participated in requirement gathering sessions with business users architecture design discussions and project planning with client's stake holders and technical enterprise integration meetings with other project teams
• Prepared detailed Level of Effort analysis for data integration projects
• Design and develop major components of the ETL process using Oracle Data Integrator
• Developed and customized ODI Knowledge Modules KM to add functionalities such as database partition switching, Oracle analytic functions and Slowly Changing Dimension SCD attribute assignment
• Performed gap/impact analysis and complexity estimate, source-to-target mapping, data reconciliation and data cleansing
• Worked extensively with Physical Layer, Business Layer and Presentation Layer to customize the existing business models and also developed new business models using OBIEE Admin tool
• Customized and created dimensional hierarchies, measures and assigned aggregation levels based on dimension hierarchies.
• Used the Security settings in Admin Tool to set up users, groups, access privileges and logging levels.
• Created dashboards and ad-hoc reports for business users.
• Created dashboard to monitor the performance of ODI ETL job.
• Perform complete impact analysis of current data warehouse and its OBIEE implementation

Confidential

Lead Data Warehouse Analyst

• Rogers provides media, cable, wireless, home phone, Internet and high-speed data services to residential and business customers. Rogers has more than 3500 retail stores across the Canada. Rogers wireless has 3 ecommerce websites that provides the online services to their customers.
• Designed, developed and implemented ELT jobs in ODI 11g and dashboards and reports in OBIEE 119.
• Defined and implemented complete ODI setup with governance and ELT development standards.
• Installed the Oracle Data integrator and configured the Master and Work Repositories.
• Created/imported Master Repository and Work Repositories in Dev, QA and Production environments.
• Set up the Topology including physical architecture, logical architecture and contexts.
• Created new models for the data sources flat files, MS SQL server, Oracle and XML.
• Did reverse engineering for the data sources and targets.
• Developed, supported and maintained ELT Extract, Load and Transform processes using Oracle Data Integrator ODI .
• Developed interfaces to load the data from flat files, SQL Server to stage and from stage to Oracle Server.
• Created PL/SQL stored procedures, functions and triggers for tasks outside of ODI.
• Built the ODS in Oracle Server to centralize the web analytical data and the middle ware request and response data.
• Customized ODI Interfaces using LKM, CKM IKM Knowledge Modules.
• Performance tuned the ODI interfaces and optimized the knowledge modules to improve the functionality of the process.
• Created load plans to run the scenarios in a hierarchy of sequential and parallel steps
• Analyzed the data and developed Logical Star Schema model with consultation from Data Modelers and Business Analysts.
• Developed metadata repository using OBIEE Administration tool in Physical, Business Model and Mapping, and Presentation Layer.
• Created new logical columns, dimensional hierarchy, calculated measures, and aggregate mappings in the BMM layer as per the business requirements.
• Designed and developed various Interactive Dashboards and reports with drilldowns, guided navigation, filters, and prompts.
• Created various session and repository variables and initialized them in the Initialization Blocks to change metadata dynamically as the environment changes.
• Configured BI Scheduler and Oracle BI Delivers- iBots to deliver alerts and publish updated content to subscribed users as per the schedules and requirements.
• Worked towards the Performance Tuning of Dashboards and Reports with Business Analysts and DBAs.

Environment: Oracle 11g, Microsoft SQL Server 2008, ODI/OBIEE 11g, Adobe SiteCatalyst, Foresee Survey

Confidential

Sr. Data Warehouse Consultant

• Dynexa is a software consulting company providing consulting service in Microsoft Dynamic products.
• I worked on the reporting and business intelligence solution for the Microsoft Navision and Microsoft Dynamic CRM using Microsoft Integration Service, Microsoft Analysis Service and Microsoft Reporting Service.
• Worked with clients/stakeholders and documented business reporting requirements
• Extracted data using SSIS packages ETL from different server locations and heterogeneous data sources like Microsoft Navision Server, Microsoft Dynamics CRM Server, Excel files, Flat files, etc.
• Designed high level ETL architecture for overall data transfer from the source server to the Enterprise Services Warehouse which encompasses server name, database name, accounts, tables and direction of data flow, column mapping, data dictionary and metadata.
• Created parameterized, linked, snapshot, cached, ad hoc, click through, drill down, drill through, sub reports for sales, services and support.
• Designed and implemented parameterized and cascading parameterized reports using SSRS.
• Deployed reports into report server to access them through browser.
• Created various geographical and time dimension reports of fiscal year, quarter month, week and daily reports for all domains and published through Report Server.
• Created various reports by comparing the growth of sales based on each quarter by using bar charts.
• Responsible for generating annual reports based on the growth of sales with respect to customers.
• Created a number of cubes, dimensions and business critical KPIs using SSAS representing aggregations in several different ways - hierarchically and using custom groupings that the company will use to analyze performance.
• Created several MDX queries according to business requirements.
• Created score cards with executive summary dashboards using MS Office Performance Point Server 2007 Dashboard Designer that display performance monitoring measures for sales, sales trends, sales cycle, service cycle deriving data from a SQL Server 2005 OLAP data source and deployed them to SharePoint sites.

Environment: Microsoft SQL Server 2005, Windows Server 2003, Microsoft Navision, Microsoft Dynamics CRM 3.0/4.0, Microsoft Performance Point Server 2007, SharePoint 2000.

Confidential

System Analyst

• Worked on the XM Satellite Radio's Subscriber Management System SMS . The SMS contained the Siebel for CRM, Portal Infranet for Billing Solutions, and Vitria Business ware as the middleware for EAI implementation, Informatica for data integration and Siebel Analytics and Crystal Enterprise for reporting.
• Extensively used ETL to load data from excel, flat files, CRM and billing sources to the enterprise data warehouse.
• Involved in Designing of Data Modeling for the Data warehouse
• Involved in Requirement Gathering and Business Analysis
• Developed data Mappings between source systems and warehouse components using Mapping Designer
• Worked extensively on different types of transformations like source qualifier, expression, filter, aggregator, rank, update strategy, lookup, stored procedure, sequence generator, joiner, XML.
• Setup folders, groups, users, and permissions and performed Repository administration using Repository Manager.
• Involved in the performance tuning of the Informatica mappings and stored procedures and the sequel queries inside the source qualifier.
• Created, launched scheduled sessions.
• Involved in the Performance Tuning of Database and Informatica. Improved performance by identifying and rectifying the performance bottle necks.
• Used Server Manager to schedule sessions and batches.
• Wrote PL/SQL Packages and Stored procedures to implement business rules and validations.
• Involved in Performance Tuning at Mapping and Database level.
• Involved in Unit testing, Assembly testing and performance tuning.
• Built Siebel Analytics Repository at all three layers i.e., Physical Layer connecting to Data sources and import schema , Business Model / data mapping create Logical tables and data source mapping and Presentation Layer level create presentation catalogs
• Created drill-down hierarchies and implemented business logics for Facts.
• Created pivot tables and manipulated initialization blocks for report analysis
• Worked on Siebel Answers to build interactive dashboards with drill-down capabilities
• Supported Integration testing and User Acceptation testing.
• Investigated and fixed the problems occurred in production.
• Participated in Knowledge Transfer program
• Taken corporate training like teamwork, leadership etc.

Environment: Informatica 7.1.3, Siebel Analytics, Crystal Enterprise 10, ORACLE 9i, UNIX, Windows 2003, UNIX Shell Programming, PL/SQL, TOAD Quest Software.

Confidential

Sr. Software Engineer

• I worked on various web applications and data warehousing projects.
• Developed class and functional diagram in Rational Rose
• Developed thin client application for the call center reps using J2EE, JavaScript, XML, XSLT, VML and Java Script in Web Sphere for Aspect Communications
• Developed automated test cases using JUNIT open source
• Developed hundreds of reports in Crystal Report 9/10 for CRM application
• Developed hundreds of stored procedures in Oracle, SQL Server and DB2
• Customized schedule.csp in crystal enterprise to support dynamic parameters
• Published and scheduled the reports in ePortfolio
• Developed the Data population tool and Report converter tool in VB6 using Crystal Enterprise API
• Designed and developed OLTP database for the web application
• Developed stored procedures, triggers and views to support the web application functionality
• Designed and developed ETL routines to populate data marts
• Developed summary, detail, balance sheet, graph and sub report to meet the business requirements
• Developed Workflow, Mappings, Transformations in Informatica Power Center 6.5
• Written and executed Unit test cases
• Developed web application in ASP.Net and C
• Migrated web application from development to production environment

Confidential

Software Engineer

• AMTEL is an IT based company providing IT solution in security and parking.
• I worked on java based web application and database development.
• Responsible for Database design in SQL Server 7
• Prepared Data Model in Visio 2000
• Written Stored Procedure, Triggers and Views in SQL Server 7
• Developed various web application using JDK 1.1, JavaScript and Apache Web Server
• Worked on Java RMI and JNI
• Prepared design and testing document