Data Warehouse Sql Server
Resume:
Ancy Joy Tel :
Houston, Texas
Email : ******@*******.***
Dependable IT professional with data warehouse, data processing 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), 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, customization, 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:
. Oct' 05- Sep'09: Calpine Corporation, 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 data warehouse
- 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.
- Gathered requirements and designed the data marts
. Jun '01- Aug'05: Canadian Imperial Bank of Commerce, Toronto, Canada
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
- Mentored new team members on the Data warehouse structure, program design
and table joins to efficiently extract data off the data warehouse
. Jan '01- Apr '01: Bank of Nova Scotia, Toronto, Canada
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
. Dec '96-Jul '00: National Bank of Kuwait, Kuwait
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' )
. Oct '95 - Dec '96: Diyar United Company, Kuwait
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: Bachelor of Engineering (BS) degree in Computer Engineering.
Professional Development Trainings and Certification:
- 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 (CDMP) - Dec' 09 from ICCP / DAMA
International
References: Excellent references available upon request
Contact this candidate