Dependable IT professional with data management and business intelligence experience 

Profile summary:

• Good working knowledge of data warehouse (snowflake & star schema design) with development, testing and support as well as with RDBM systems like ORACLE, DB2 and MS SQL Server, executing process in UNIX & Windows environment
• Demonstrated expertise utilizing ETL tools: SAS Data integration studio, SQL Server Integration Services (SSIS) & Informatica Powercenter.
• Implemented programs using SQL and SAS as well as Business Intelligence solutions with OLAP Cubes, Information Maps and Stored processes on the web portal.
• Extensive background in development, implementation and testing of software applications and products.
• Sound understanding of design goals of ER modeling for OLTP and dimension modeling for OLAP.
• Presented insights based on data analysis; analyzed data with data mining tool to identify trends
• Team player with good communication and problem solving and analytical skills.

Most Recent Employment History:

2010 - Present : Confidential, North Carolina Contract Consultant

• Integrated data from Teradata based data warehouse and MS SQL Server 2008 databases ( this included creating SQL queries running against various databases, using Aginity Netezza Workbench tool, Teradata
• SQL assistant & MS SQL Server 2008 Management Studio)
• Designed and developed the ETL processes to populate the dimensional data model for the Risk Data
• Provided conceptual & logical data model ( using MS Visio 2007), for the ‘loan applications’ of the Risk Evaluation Dimensional Model
• Mentored new team members on the Data warehouse structure, program design and efficient table joins; functioning as technical lead on project co-coordinating with offshore team and onsite business users.

2005 – 2009 : Confidential, Houston, Texas Contract Consultant

• Designed and developed the ETL (Extraction, Transformation and Loading) processes and implemented the data warehouse design (mapping Oracle 10g source system data into the data warehouse model).
• Migrated the ETL process to the multi tier application ‘Data Integration Studio’ from the \'Data warehouse 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 data warehouse as well as implemented design enhancements. Duties included troubleshooting, performing regular performance and ad-hoc requests.
• Conducted data analysis, resolved data discrepancies and proactively administered fixes for the DW
• 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 Reporting Services (SSRS)
• Contributed in data processing improvements and decision support projects that evaluate \'Value at Risk\' and \'price / profit value’ variations.
• Gathered requirements and designed the data marts

2001 – 2005 : Confidential, Data Consultant

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

• Design and development of solutions working off the CRM data warehouse, 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

2001: Confidential Contract Consultant

• Conducted unit and system testing 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

1996 - 2000: Confidential Senior MIS Specialist

Supported the Data warehouse implementation with data marts 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 data marts; by providing reports and other frequent business requirements.
• Conducted tests on the data and entities of the Data warehouse
• 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 data mining 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\' )

1995 – 1996: 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

1991 – 1995 : Worked in various development roles supporting IT initiatives. Details, work experience letters & references can be provided, if needed.

Education: Bachelor of Engineering (BS) degree in Computer Engineering.

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
• Certified Data Management Professional ( from the Data Management Association)