SUMMARY:

• I have been in information technology industry, delivering solutions as a Technical Lead, System Analyst, Sr. Software Engineer and Developer. Experience includes full - life cycle systems/solutions developments, extensive knowledge in client reporting and analysis.
• As a Business Inteligence professional (10+ years) have implemented various BI projects with OBIEE/Siebel Analytics, Informatica and Business Objects. With Microsoft Certified Solution Developer (MCSD), have 6 years of experience in Client-Server, Component Based Architecture and WEB technologies, and have implemented various projects using C++, VB, ASP, SQL Server & Oracle
• OBIEE 11g certified - 8+ years in OBIEE/Siebel Analytics/Informatica/DAC/ODI
• Extensive experience in OBIEE repository, dasboard & report development, security implementation and tuning quries
• OBIEE Reporting: Dashboards, Analysis/Reports, Alerts/Agents/Ibots/Delivers, Prompts/ Filters, Conditions
• OBIEE Metadata: Repository development - star/snowflake schema, LDAP, data and object security implementation, dimensions, hierarchies & aggregate implementation,
• Experience in installation, configuration, and administration of OBIEE 11g with weblogic server and EM, BI Scheduler configuration for Alerts/ibots, BI Publisher.
• Strong knowledge of operating systems, networking, DBMS, programming languages and SDLC
• Dimensional modeling (Kimball), UML object modeling, process modeling, Data Modeling using Visio & ERWIN
• Experience in requirement gathering, use cases, test cases, sequence, activity & state diagrams
• Good communication skill to clearly articulate technical and business concepts
• Strong problem solving skills and ability to customize all levels of software
• Capable of working individual/team in high pressure, target oriented environments

TECHNICAL SKILLS:

BI: Business Objects

DBMS & Tools: Oracle 11g, Teradata, SQL Server, MySQL, MS-Access, SQL Anywhere, TOAD, SQL Developer, PL/SQL

Web Technologies: IIS, HTML, DHTML, ASP, VBScript, JavaScript, ActiveX, JSP, PHP, CSS

Languages & Tools: C, C++, JAVA, VB.NET, MS Visual Studio

Other Tools: MS-Project, MS-Exchange/Outlook, Data Warehousing, COM, DCOM, MTS, MSMQ

PROFESSIONAL EXPERIENCE:

Confidential, MN

OBIEE Consultant

Responsibilities:

• Worked with Business Analyst, gathered analytics requirements from different user groups and created the Business Model for OBIEE Star/Snowflake schemas with existing conformed dimensions in EDW. Followed Kimball methodology.
• Coordinated with architecture team in installation, configuration and administration of OBIEE
• Designed and created repository with Physical Layer, Business Model and Mapping Layer, and Presentation Layer using administration tool and modified as needs change.
• Administered MUDE environment for multiuser repository development.
• Created various dimensions and defined aggregation levels for logical table sources and fact table measures in Business Model and Mapping Layer.
• Configured repository & session variables to get dynamic reports and dashboard.
• Developed and highly interactive business intelligent Analysis and Dashboards with advanced views.
• Created and managed complex analytical reports like Business Fundamental Tables, KPI's, Scorecards, Polarity Reports, Fact Tables, Channel Maps, Trends, etc.,
• Responsible to deliver adhoc reports required by Business Analysts and Account Managers
• Installed and created analysis with maps views using Navteq maps
• Customized Analysis and Dashboards using javascript.
• Merged catalog using catalog manager.
• Created proactive Alerts and customized to users for different threshold values.
• Created Agents, Configured OBIEE Delivers to deliver Analytics content based on schedule and automated Agents to obtain daily and weekly canned reports.
• Cache management by using polling tables to trigger seeding queries on data load.
• Created and managed Seeding queries.
• Improved query performance by managing cache effectively.
• Worked with DBA to tune and improve performance for queries.
• Imported security data from LDAP server to Weblogic security realm and automated to do the same on daily basis using javascript and ODBC.
• Assigning permissions for catalog objects and implementing access privileges and query privileges for application roles in admin tool Identity Manager.
• Configured Siebel Analytics Briefing book to port the entire needed reports to a lightweight report to make it easy for users to view the reports offline.
• Worked on integrating and configuring BI Publisher with OBIEE.
• Took backups of repositories and webcat files.
• Extensively worked on SRs as per the client’s requirement to get the reports for the business analyzation.
• Created business specs, tech specs and UAT documents
• Created document and trained user for dashboard adoptation
• Manage OBIEE Dasboard environment and implememt enhancements by working closely with Enterprise Architecture and Enterprise Data Warehouse teams

Software: OBIEE 11.1.1.6.1 , Oracle 10g, PL/SQL, SQL PLUS, SQL Loader, TOAD, javascript

Confidential, Cupertino, CA

Senior Consultant

Responsibilities:

• Develop repository, reports & dashboards, implement security at data and object level
• Configuration of Delivers/IBots
• Performance tuning
• Integration with HR Analytics dashboard
• In corporate external data
• Document functional/technical specifications, test scripts and business process procedures
• Dashboard/reports maintenance and improvement

Software: Windows, Unix, OBIEE 10.1.3.4.1 , Oracle 9i, TOAD 6.2, SQL Plus, PL/SQL

Confidential

OBIEE Developer

Responsibilities:

• Analyze and design the Siebel dashboard, gap analysis in data
• Repository, report and dashboard development, security design and implementation
• Report and dashboard development, building and seeding cache
• Functional, technical, UAT and documentation
• Maintenance and enhancement
• POC for OBIEE and Teradata

Software: Windows, Unix, Weblogic, Siebel Analytics 7.7.3, Oracle 9i, TOAD 6.2, SQL Plus, PL/SQL

Confidential

Siebel Analytics developer

Responsibilities:

• Modified online and disconnected repositories for report needs.
• Modified and created new dimensions, levels and level based measures using admin tool in the business model and mapping layer.
• Configured repository & session variables to get dynamic reports and dashboard.
• Customized reports and dashboards using siebel analytics web.
• Modified sourcing queries for disconnected reports.
• Configured siebel scheduler and created IBots in Delivers to cache files for disconnected users.
• Migrated repository and webcat from Siebel Analytics 7.7.1 to 7.8.2.3
• Set up Groups, access privileges and query privileges with the Security settings in siebel analytics admin tool.
• Modified Informatica mappings for report needs.
• Verified the reports using TOAD in OLAP (SRMW) and OLTP (Siebel OLTP) databases and in SQL Anywhere mobile database.
• Created batch files for installation of mobile analytics for the users to install in silent mode.
• Created the user documentation for installation and Mobile Analytics reports.
• Integrated Pharma Analytics reports and dashboards into the Siebel CRM interface.
• Used siebel security and position based hierarchy for authentication and data extraction.

Software: Windows, Unix, Weblogic, Siebel Pharma Analytics 7.8.2.3 (Online & Mobile), Infomatica (PowerCenter 7.1.2), Oracle 9i and SQL Anywhere, TOAD

Confidential

Senior Consultant

Responsibilities:

• Designed repository to in corporate data from different data sources.
• Created summary tables, dimensions, aggregations and levels using admin tool in the Business Model and Mapping layer.
• Configured Siebel Scheduler and created proactive Delivers-IBot/Alerts
• Configured Siebel Analytics Briefing book to port needed request to a lightweight report to make it easy for users to view reports offline
• Set up groups, access privileges and query privileges with security settings in Siebel Analytics administration tool.
• Configured repository & session variables to get dynamic reports and dashboard.
• Involved in cache management.
• Created and managed complex and analytical reports like Business Fundamental Tables, Scorecards, Polarity Reports, Fact Tables, Channel Maps, Trends, etc., using Siebel Answers
• Responsible to deliver adhoc reports required by Business Analysts and Account Managers
• Implemented QA procedures, trained users to acquire the required data

Software: Siebel Analytics 7.7, Infomatica (PowerCenter 6.5), Microsoft DTS, Oracle (8i & 9i) and SQL Server 2000, TOAD 6.2, VB 6.0, ASP, MS Access

Confidential

Responsibilities:

• Designed migration plan, installed and configured Siebel Analytics
• Developed repository, implemented aggregate measures
• Used session and repository variables in reports, designed prompts for global & column filters
• Created and managed complex analytical reports like Business Fundamental Tables, Polarity
• Reports, Fact Tables, Channel Maps, Trends, etc., using Siebel Answers
• Responsible to deliver adhoc reports required by Business Analysts
• Created dashboards and made available canned reports and updated status of the data availability and other messages to the user
• Used IBots for scheduling and Delivering the reports to the user
• Customized the Siebel Screens for Corporate use
• Implemented object and data level security to restrict & control data exposed to user groups
• Imported security attributes from LDAP servers and applied for internal and external users.

Software: Siebel Analytics 7.5, Infomatica (PowerCenter 6.5) Microsoft DTS, Oracle (8i & 9i) and SQL Server 2000, TOAD 6.2, VB 6.0, ASP, MS Access

Confidential

Responsibilities:

• Performed data modeling using ERWIN, Generated data flow diagrams
• Developed mappings and workflows in Informatica, involved in mapping-level optimization
• Developed and managed universes using Business Objects, Implemented security on universe objects
• Developed MIS reports, Automated BO reports using Business Objects SDK
• Planned and implemented Data Quality procedures and QA procedures
• Prepared document and trained users

Software: Business Objects (5.1.4 and 6.5), Web Intelligence 2.1.7, Infomatica (PowerCenter 6.5)

Confidential

Software Engineer

Responsibilities:

• Designed and developed Star/Snowflake model, data structure for the Data Marts (Staging, Dimension Tables and Fact Tables)
• Developed ETL processes using Informatica and Active X Scripting
• Created complicated mappings using various transformations in Informatica
• Developed universe, canned reports and security in Business Objects
• Automated BO reports using Business Objects SDK and VBA
• Designed and developed a web portal for publishing the reports
• Developed document and trained clients.

Software: Informatica Power Mart 5.1, Business Objects 5.1.4, Web Intelligence 2.1.7, Oracle 8i, SQL Server 2000, Visual Basic 6.0

Confidential

Web Developer

Responsibilities:

• Handled partners and clients from project initiation to implementation
• Involved in design, development, implementation and testing
• Developed the Data Transformation Engine and Reports Engine for the Loyalty Network Software
• Design and implementation of the SQL Server 7.0 Database
• Created HTML reports using ASP
• Created Graphical reports using Active-X components and ASP
• Coded MTS components using VB
• Tuned database for better performance

Software: Windows 2000, Visual Interdev 6.0, Visual Basic 6.0 HTML, VBScript, JavaScript, IIS, SQL Server 2000, MTS, COM, ASP, ADO.