Profile : Well organized, self directed, dependable and dedicated person with data management, processing and analytical skills.

- Good working knowledge of datawarehouses (snowflake & star schema design) as well as relational databases like ORACLE, DB2 and MS SQL Server, working in UNIX & Windows environment
- Technical skills: SQL, SAS, ETL and other BI Applications like OLAP Cubes, Information Maps, Stored processes on the web portal.
- Presented insights based on data analysis; analyzed data with datamining tool to identify trends
- Received awards and letters of commendation for providing business improvement suggestions

Most Recent Employment History :

* Oct’ 05 – Present : Confidential,
TX
Contract Consultant

- Developed the ETL ( Extraction, Transformation and Loading) processes and implemented the Data warehouse design (mapping Oracle 10g source system data into the datawarehouse model). Migrated the ETL process to the multi tier application ‘Data Integration Studio’ from the \'Datawarhouse Administration\' tool. Built programs and queries to conduct test cases for the implementation ( using \'SAS Enterprise Guide\' application). Maintained and provided primary support for the datawarehouse as well as implemented enchancements. Duties included troubleshooting, performing regular performance and ad-hoc requests
- Conducted data analysis, resolved data discrepancies and proactively administered fixes for the datawarehouse
- Implemented OLAP Cubes, Information Maps and Stored processes on the web portal.
- Supported the daily batch processing of Energy Credit Risk application ( maintained on MS SQL Server 2005 ); also created SSIS packages as well as implemented stored processes on Sql Server Reporting Services (SSRS)
- Contributed in data processing improvements and decision support projects that evaluate \'Value at Risk\' and \'price / profit value\' variations.

* Jun ‘01 – Aug’05 : Confidential,

Data Consultant

Contributed to Marketing Projects with development & analysis of information from an Oracle based Datawarehouse using SQL and SAS within UNIX and Windows NT environment; supported by BI query tools. Accomplishments:

- Design and development of solutions working off the CRM datawarehouse, manipulation and transformation of the data to decision support information.
- Data analysis, providing data insights and trends supporting business growth objectives.
- Identified relationships and opportunities related to customers and their products
- Mentored new team members on the Datawarehouse structure, program design and table joins to efficiently extract data off the data warehouse

* Jan ‘01 – Apr ’01 : Confidential,

Contract Consultant

- Completed User Acceptance Testing of the data for the CRM Data Warehouse implementation. This involved understanding the Data warehouse schema and structure as well as the understanding the bank’s products, business rules and development of required inputs from a DB2 Data warehouse using SAS (UNIX and PC) and SQL
- Tested the Data warehouse design, with SQL programs to verify the customer profitability measure

* Dec ‘96 – Jul ‘00 : Confidential,

Senior MIS Analyst

Supported the Datawarehouse implementation with datamarts and providing the business requirements; worked with NBK’s Data Warehouse to identify opportunities to deepen customer relationships, acquire new customers and retain existing ones. The job required interaction within various teams and understanding bank products.

- Contributed to the design of the datamarts; by providing reports and other frequent business requirements.
- Conducted tests on the data and entities of the Datawarehouse
- Developed programs utilizing SQL, SAS for the production of statistical analysis reports for monitoring and effective marketing of the products and services of the bank.
- Worked with datamining tool to complete analytical projects & offered recommendations based on pattern analysis
- Automated daily reports using SAS and Excel to improve the efficiency and speed of delivery by 80%. This involved building excel macros using Visual Basic.

( Used PC SAS and a client/server connection as well as MVS/JCL Batch processing to extract and analyze data from NBK’s Enterprise Data Warehouse and Operational DB2 Systems. Trend analysis was done using cluster analysis feature from SAS and using the datamining tool \'ALICE\' )

* Oct ‘95 – Dec ‘96 : Confidential,

Computer Engineer, Customer Support

- Provided software and hardware customer site support, meeting the satisfaction of Diyar’s customers
- Worked independently on the installation, configurations and maintenance of PC’s, networks, internets, printers, plotters and related software packages

* Oct ’91 – Oct ‘95 : Worked in various development roles supporting IT initiatives. Details, work experience letters & references can be provided, if needed.

Education Qualification : BACHELOR’S DEGREE IN COMPUTER ENGINEERING.
( Hold degree evaluation certificate for US equivalency to BS degree)

Professional Development Trainings :

- Data Warehouse Architecture Boot Camp
- Data Modeling Workshop
- INFORMATICA Powercenter 8
- Data Mining using Alice 5.12
- Advanced workshop for SAS programming, Report Writing
- Basic MVS and JCL
- Advanced Managing and Analyzing Financial Databases
(includes usage of MS-Access, Visual Basic, Excel and Powerpoint)
- Oracle - PL/SQL , Developer 2000
- Unix and C Language

References: Excellent references available upon request