OBJECTIVE

I have a strong database administration and general office practice with particular emphasis in computerized data management and reporting. I am an excellent communicator who is also a cooperative team player with proven problem-solving ability. My in-depth experience along with my enjoyment of new challenges could be utilized to create a positive impact on any employers' operations.

SKILLSET AND EXPERIENCE

• Hands-on experience with various aspects of continuous improvement: project planning, requirements gathering, scope management, change control, execution oversight, issue management, and risk mitigation.
• Involved in every aspect of project life cycle, partnering with business owners to identify improvement opportunities, document current and future state, and provide solutions using both creative and analytical strategies
• Experience in modeling and building OBIEE repository layers for global, multicurrency implementation
• Experience in designing and developing reports to display data in multiple currencies depending on the currency selected by the user
• Ability to work independently and with other team members
• Strong verbal and written communication skills
• Provided high quality advice and solutions on-site and off-site to clients
• Managed client activities to ensure delivery of the best solutions for clients
• Translated high-level business requirements into logical business dimensional model
• Improved existing customer relationships and support operations to enhance current client portfolio
• Maintained a standard working environment in terms of conformity, risk, management, and continuous improvement
• Assisted in preparing client proposals, tenders and reports on a regular basis
• Worked on developing and rolling out new value propositions for the clients
• Provided training and guidance to other members of the team as required
• Developed and maintained technical documents for the future need
• Implemented the transition to Oracle Business Intelligence OBIEE as the preferred enterprise reporting software
• Expert understanding of Installation, Configuration, and Administration of OBIEE 10g and 11g standalone with extensive hands-on experience in business intelligence design and implementation
• Domain expertise includes mortgage financing, human resource management, sales, e-commerce, commercial, retail, insurance
• Five years of experience analyzing, designing, developing, implementing, tuning and supporting the OBIEE Suite of tools, including Oracle Intelligent Dashboards, Oracle Answers, Oracle Delivers and Oracle iBots/Agents.
• Responsible for administering oracle 11g/10g/9i and SQL Server 2005/2000 databases in DEV and TEST Environments.
• Proven team player who keeps multiple tasks in motion while maintaining the overarching project vision
• Strong experience in interacting effectively with business stakeholders and technical teams at all levels of the organization
• Analytical problem solver and critical thinker, innovative and creative, cooperative, results oriented, on-going learner, hands-on, self-motivated, multi-task oriented.
• Excel at mentoring and coaching team members and other colleagues. Demonstrated ability to work in a fast-paced, team environment.

WORK EXPERIENCE

Oracle BI Developer Contractor

Confidential

• Analysis of current and proposed systems
• JAD session chairing
• Designed repository, with complex Time Series Calculations, for prior months/ quarters/ years.
• Created Presentation catalogs, and Folders in Presentation Layer, and Performed Global Consistency Check in Siebel Analytics Administration Tool.
• Involved in performing the Impact Analysis of Migration.
• Built Reports and Dashboards for Business Users, and Set up Usage Tracking database.
• Implemented Dynamic Dashboard Prompts to zoom into different segments of the customers and Brokers, to achieve performance optimization and easy navigation of reports.
• Enhanced Query performance, by analyzing modifying SQL Query and Filters, for all the reports and dashboard prompts, to minimize the delay in Physical Query Execution
• Technical writing as part of team
• Delivery of system enhancement proposals to technical team
• Remote User interaction

OBIEE Consultant

Confidential

• Design and development the OBIEE/Siebel Analytics Metadata Repository .rpd using OBIEE Admin Tool by importing the required data base objects both Facts and Dimensions with integrity constraints into physical layer using connection pool.
• Translated high-level business requirements into logical business dimensional model.
• Installation of and building OBIEE Repository at 3 layers i.e., Physical Layer, Business Model and Mapping Layer and Presentation Layer.
• Created Hierarchies, Levels, and implemented Business Logic by creating level based measures in OBIEE business model mapping layer.
• Identified and created aggregate tables to improve query performance.
• Developed different kinds of Reports pivots, charts, tabular using global and local filters.
• Generated highly graphical reports using BI Publisher.
• Created Session Repository Variables to achieve desired functionality.
• Created web-groups for security purpose with access privileges
• Created OBIEE Intelligent Dashboards, Answers.
• Assigned Data level UI level security to the Users.
• Customized Dashboard reports using drill down capabilities.
• Created and used Siebel Delivers and iBots extensively.

Report Developer

Confidential

• Gathered business requirements, and analyzed business needs in a dynamic environment to prepare Functional Specifications. Participated in meetings with end-users and developers from cross-functional teams prepared project status reports.
• Worked with DBA to create Key Performance Indicators to help in personnel performance management and goal setting in OBIEE
• Helped with Business Intelligence by setting drill down and forecast capabilities using available data in OBIEE.

SQL Developer

Confidential

• Interaction with the end users for the requirements
• Prepared Technical Design Documents TDD of the complete implementation of the Business Module and User Guides for the use of Siebel Analytics and OBIEE.
• Participated in complete life cycle of the project from Project Initiation, to Development and Maintenance.
• Designed repository, with complex Time Series Calculations, for prior months/ quarters/ years in OBIEE.
• Created Presentation catalogs, and Folders in Presentation Layer, and Performed Global Consistency Check in Siebel Analytics Administration Tool.
• Ad-Hoc reports with high level of accuracy to senior management using SQL Reporting Services SSRS . Developed, tested, debugged, and documented business intelligence systems.
• Built Reports and Dashboards for Business Users, and Set up Usage Tracking database.
• Implemented Dynamic Dashboard Prompts to zoom into different segments of the customers and Brokers, to achieve performance optimization and easy navigation of reports.
• Enhanced Query performance, by analyzing modifying SQL Query and Filters, for all the reports and dashboard prompts, to minimize the delay in Physical Query Execution.
• Enabled Siebel Delivers using iBots for delivery of reports to business users, by setting up Scheduler and configuring Job Manager.
• Implemented Comprehensive Security Model, by creating User Roles, Web Groups and setting up External Table Authentication.

Data Developer

Confidential

• Gathered requirements and coordinated with various departments to assure satisfactory data content, quality, data integrity and receipt of desired information.
• Implemented SSIS Packages to perform ETL Operations from multiple data sources including flat files.
• Used various built in transformations in SSIS including SCD, Aggregate, Lookup etc. Managed Package Configurations for SSIS Packages in both XML files and SQL Server Tables. Populated Staging DB with Dimension and Fact data using various transformations in SSIS 2005. Unit Tested the SSIS Packages in BIDS and deployed the packages to the SSIS 2005 Service.
• Designed the Analysis Services Warehouse in BIDS and deployed the warehouse to SSAS 2005 Service in the form of a SSAS Database. Created cubes, Optimized cubes by designing aggregations, managing partitions, creating hierarchies and attribute relationships in SSAS.
• Used the .Net framework to develop and implement web parts for integration into a SharePoint Portal Site.

Software Development Lead

Confidential

• Created database objects like tables, views, indexes, indexed views stored procedures UDFs. Created and modified stored-procedures, triggers, cursors, and views in support of DBA day to day duties or reports.
• Actively involved as part of a team for gathering and analyzing the needs of End User Requirements and System Specifications. Created complex wealth management logic and modified existing database by adding tables and relationships to existing data model.
• Optimized the performance of queries with modification in T-SQL queries, removed unnecessary columns, eliminated redundant and inconsistent data, normalized tables, established joins and created indexes wherever necessary. Created complex views and scripts to convert business logic for different reports.
• Moved logic from Reporting Services into stored procedure to improve performance and keep data sets as simple as possible by balancing workload between Reporting Services and SQL Server 2000.
• Worked with Data Transformation Services DTS Wizards and DTS packages to load text files to SQL Server. Maintained the data, database backups and restoration, backup strategies, scheduled backups.

SQL Developer

Confidential

• Involved in creating logical and physical model of the database using MS Visio, MS SQL Server 2000.
• Implemented the developed database and database objects like complex stored procedures, UDFs, views, materialized views and indexes in SQL Server 2000 using T-SQL.
• Extensively used BCP to export and import data between text files and SQL server 2000
• Rearranged multiple indexes to complement the performance on several joins embedded in views and stored procedures.
• Supported some business specific relationships, and advance constraints by embedding triggers on tables. Set up scheduled Jobs and alerts for updates and backups.
• Assisted VB Developers in creating Data Entry Forms. Created several reports using MS Reporting Services and linked them to front end web applications.

BUSINESS INTELLIGENCE SKILLS

• Oracle Business Intelligence OBIEE
• Oracle BI Interactive Dashboards
• Oracle BI Administration Tool
• Oracle BI Answers, Publisher
• Oracle BI IBots disconnected analytics
• Multi User Development
• MSSQL BI, MS Office power user , MS Visio