Summary

Around 5 years of expert level experiencein Business Requirements Analysis, Application Design, Data Modeling, Development, Implementation and Testing of Data warehousing, report generation and Database business systems for Health Care, Oil and Financial industries. Extensive knowledge of Siebel and ERP solutions, including needs assessment, implementation, Analytics repository management and administration and the development of custom modules for the Warehouse using Oracle Business Intelligence Enterprise Edition, Siebel e-Business Applications, Siebel Analytics.

• Around 5 years of total IT experience in the Business Requirements Analysis, Application Design, Dimensional Data Modeling, Data Modeling, Development, Implementations and Testing of Data Warehousing and Database business systems.
• 2+ years of Dimensional Data Modeling experience using Data modeling, Star Schema/Snowflake modeling, FACT & Dimensions tables, Physical & logical data modeling using Sybase Power Designer.
• 2+ years of Business Intelligence experience using Siebel Analytics.
• More than 2 years of experience with Siebel Analytics, Siebel Data Warehouse Administration Console (DAC), and Siebel Web Client in the Siebel eFinance, Siebel Sales. Installing DAC, configuring, administering and managing the repository, creating complex reports and role based Analytics Intelligence Dashboards using Siebel Analytics.
• 5+ years of experience using MS SQL, UDB, Sybase, Oracle, MS SQL Server 2000, SAS, PL/SQL, SQL Anywhere, Rapid SQL, Windows 95/98/2000 XP, Win NT 4.0 and Sun Solaris 2.x.
• Enthusiastic team player, with excellent communication and interpersonal skills. Can take up individual responsibilities and thorough in the analysis approach.

Technical skills

Data Warehouse
SIEBEL DAC
POWERMART

Business Intelligence
OBI EE 10.1.3
SIEBEL ANALYTICS 7.5/7.7
SIEBEL ANSWERS/DELIVERS

POWER ANALYZER

Databases: DB2, Sybase, MS SQL, Oracle 8.1, MS Access
Operating Systems: Windows 95/NT/XP, UNIX
Languages: C /C++, Java, Java Script, Power Builder, Siebel, VB
Data Modeling: Power Designer, Erwin
Software: MS Visio Professional, Visual Source Safe, PVCS, SAS, Autosys, MS Project, MS Office, UNIX Scripting

• Master of Project Management
• Master of Computer Science
• Bachelors in Software Engineering

Confidential, Dearborn, Michigan Sep11-present
Responsibilities:

• Provide support for the university in meeting business intelligence and analytic needs, especially as those needs involve the primary ERP databases and the use of BI reporting software.
• Design and maintain the infrastructure for the data warehouse including Extract, Transform and Load (ETL) processing, data validation, and other related processing.
• Plan, design, and create reports, cubes, and dashboards for executives and other business users to meet strategic and operational needs.
• Work closely with campus offices responsible for data research, reporting, and analysis to determine needs and facilitate use of common data source and common reporting tools.
• Work closely with campus offices and data stewards to create and maintain an authoritative data dictionary for the University.
• Evaluate, test, and implement new or upgraded software.
• Train campus users on business intelligence tools.
• Monitor and troubleshoot problems.
• Collaborate on the design of new database tables as needed and maintain associated data models.

Confidential, Tehran, Iran Aug08 - Nov10
Confidential, is a leading supplier, distributor and producer of high quality automotive and industrial products and services.

Oracle BI Consultant
Responsibilities:

• Responsible for implementing Data-level security and Object-level (Dashboards/Reports) security among users, groups and web-groups using various authentication systems
• Responsible for gathering the Customer Care and Billing Analytical Business Requirements, preparation of Requirement Specifications documents
• Designed and Developed Customer Care and Billing Analytics Metadata repository (.rpd) that consists of physical layer, business model layers with aggregates & dimensions, presentation layer with catalogs & folders using Oracle BI Administration tool
• Integrated BI Publisher with OBIEE and created Templates, Reports, Prompts in BI Publisher
• Schedule reports and bursting as per the requirement in BI Publisher and represented then in OBIEE dashboards
• Responsible for creating additional Users and maintaining Visibility Privileges using OBIEE Administration on Repository side as well as front end to display OBIEE reports based on the business user for that particular area
• Designed and developed many Performance Measurement Dashboards/Reports that are Dynamic & Interactive with intuitive drilldowns, drill-across & flash-based drillable charts (bar-charts, pie-charts, radars, and bubble-charts)
• Designed and developed security settings like data visibility based on position and login of the User in a Stand-Alone environment
• Involved in setting up Session and Repository (Static and Dynamic) variables using various Initialization blocks. Created Analytics star schema and snow flake schema in physical and business model layer
• Configured connection pool for the database connection in the Physical Layer
• Created new logical columns defining the business logic as per the requirements
• Configured iBots to deliver Analytics content based on schedule, automated iBot queries to obtain weekly reports
• Debugged reports and Dashboards visibility with respect to user's responsibility and web groups in an integrated environment
• Created Mappings using different transformations like Expression, Lookup, Joiner, Router, Filter, Update Strategy, Sequence Generator to perform the process of Extract, Transform and Load effectively in the Mapping Designer as per the requirement
• Coordinated with Data team in customizing ETL mappings to the load data in target tables
• Used Mapping Variables, Mapping Parameters in the Informatica Mappings to filter the daily data from the source systems
• Created Workflows and used various tasks like Email, Event-wait and Event-raise, Timer, Scheduler, Control, Decision, Session in the workflow manager
• Developed technical solutions to business problems in the OBIEE repository
• Upgraded to the most current version of OBIEE, and performed the regression and functionality testing necessary for the upgrade. Developed new subject areas in the repository per business requirements
• Responsible in updating, scheduling and delivering snapshots of Dashboard pages through Briefing books
• Performed environment migrations between the Development, Quality Assurance, and Production environments
• Made use of Post-Session success and Post-Session failure commands in the Session task to execute scripts needed for clean up and update purposes
• Responsible for Unit Testing, Integration Testing of the RPD and Web Catalog objects
• Used the Data Warehouse Administration Console (DAC), for management, configuration, administration, loading and monitoring of the Oracle Data Warehouse

ENVIRONMENT: ORACLE BUSINESS INTELLIGENCE EE 10.1.3.3.0, ORACLE 9I/10G, INFORMATICA POWER CENTER 8.5, ORACLE UTILITIES APPLICATIONS 11I, WINDOWS XP, SOLARIS

Confidential, Tehran, Iran July 07 - Jun08
Senior Oracle Business Intelligent Solutions
Confidential, is theIranianNational Products and Services Classification and Codification system. It enables producers and distributors to identify, classify and codify their products and services.
Responsibilities:

• Created SDE and SIL mappings to extract data from the transactional system and flat files and subsequently load them into the warehouse tables via staging tables.
• Extensively used filter, update, lookup, expression, router and sequence generator transformations.
• Defined the refresh extraction and load logic based on the last updated column in the Transactional Tables.
• Created workflows for the Initial load and refresh load.
• Created mappings to populate the aggregate, hierarchy and helper tables.
• Create/Modify Metadata repository suiting to bank's data requirements by using Siebel Analytics Server Admin tool.
• Created connection pools, physical tables, schema folders and catalog folders in the physical layer of the repository.
• Defined Primary key-Foreign key relationships, complex joins bridge tables between dimension tables and Fact tables in the physical layer.
• Defined static and dynamic repository variables to modify metadata content dynamically to adjust to a changing data environment.
• Administered security privileges and permissions for each subject area and dashboards according to customer requirements.
• Created Aggregate tables and fragmented fact tables for efficient query performance.
• Involved in the integration testing and unit testing the data. Identified bugs during the testing phase and fixed them.
• Tested and Validated the Repository before making it available for queries.
• Defined session variables for users to enhance data level security.
• Created presentation layer catalog folders, to show different views of the business model to different users and assigned group permissions to the catalog folders.
• Responsible for making the end users understand the features of Answers.
• Worked Extensively on Siebel Answers to create the reports as per the client requirements.
• Created and modified the request, modified the result layout and added filters to them according to the need of end-users.
• Configured I-Bots to deliver analytics content-based alerts as per user requirements.

Environment: OBIEE 10.1.3, Informatica Power Center 7.1, Oracle 9i, Erwin, MS Visio, Unix Shell Scripting, MS PowerPoint.

Confidential, Esfahan, Iran Sep 04 - June05
Siebel Developer/Administrator
The Siebel Analytics BI Platform Solutions was implemented for providing interactive Dashboard access to strategic business information from the company-wide data warehouse. The project involved development of repository at all three layers and development of reports and dashboards using Answers.
Responsibilities:

• Involved in Analysis, Requirement gathering, function/technical specification, development, deploying and testing.
• Identified and created Facts, Dimensions, and Hierarchies of the business model.
• Architected and implemented change data capture and slowly changing dimension design.
• Created and modifying the physical, business, and presentation layer of the repository.
• Worked extensively on Siebel Answers and created the reports as per the client requirements.
• Built reports using Answers including drilldown objects, union based reports, formatting and functions within the reports, dashboards, filters, and prompts.
• Developed different kinds of reports (pivots, charts, tabular) with global and local Filters.
• Created corporate standard variables in the metadata to ensure standard measures and followed best practices.
• Implemented Time Comparison and calculation measures in the business model and modeled Slowly Changing dimension data.
• Performed Repository Testing and validated Business Models in the repository.
• Created proactive agents (iBots) and interactive dashboards and alerted the sales manager about the sales of the particular item.
• Worked on answers and created reports. Setup the visibility of dashboards to employees with respect to their responsibilities.
• Created groups in the repository and added users to the groups and granted privileges explicitly and through group inheritance.
• Developed Role-Based dashboards for managers and business Heads to review the data to analyze the statistics, Customized pre-built dashboards.
• Involved extracting data and transforming the data before loading the data into target (warehouse) Oracle tables
• Tuned ETL procedures and STAR schemas to optimize load and query performance.
• Worked on different transformations like Source Qualifier, Expression Filter, Lookup, Update Strategy, Stored Procedure, Sequence Generator, Joiner, Router, Aggregator Transformation and SQL override.

Environment: Siebel Analytics 7.7, Informatica 6.1, Oracle 9i and Windows 2003.