Olap architect

SUMMARY:

• Over ** Yrs of Experience in Transact SQL (T SQL) Programming , OLAP, reporting and in all aspects of the BI Stack.

• Resolved performance issues and proactive monitoring of performance bottlenecks

• Extensively worked on system analysis, design, development, testing and implementation of projects (SDLC) and capable of handling responsibilities independently as well as a proactive team member.

• Extensive experience in using the SQL Enterprise Manager, DTS, SQL Profiler, MSSQL Analysis Services (OLAP), BCP Utility, Replication, Erwin, Visio, IIS Configuration, Clustering and Administration.

• Brain bench Certified in SQL Server

• Configuration of Web Servers using IIS and integrating it with MS SQL Server

• Extensive work experience in Configuring and Setting up architectures.

• Involved in Designing and Implementation of data warehousing solution which includes Building an OLAP database, creating data source, Defining the dimensions & dimension levels, Building up Cube, assigned fact table in cube, Optimizing an OLAP database with aggregation & partitions also Designing of multidimensional tables, cubes and fact tables in OLAP.

TECHNICAL SKILLS:

Databases: SQL Server 6.5 / 7 / 2000,2005,2008 ORACLE 8i, MySQL, MS Access ,Teradata

Web Development: HTML, DHTML, ASP, PHP4, VBScript, JavaScript, FrontPage, Flash 4 & Dreamweaver, Vb.net

Operating Systems: Microsoft Windows (9x – XP) , Red Hat Linux ( 7.0 – 8.0 ), Free BSD,.net

Etltools/Reporting tools: Ascential Data stage Ascential Quality Stage, ProClarity, and Informatica

Hardware: Microprocessor 8085 – 80386, Micro controller 8051, 8255 PPI

Programming: C, C++, COBOL, Pascal, Visual Basic 6, Developer 2000

EXPERIENCE:

10/08 to CITIBANK – New York, NY

06/09 Lead SSAS Architect

Project Description: Citibank. is a leading banking and financial services company which provides a comprehensive range of financial services: personal banking, commercial banking, insurance, and investment planning and wealth management. My responsibilities in this bank were to support the EDW environment.

Responsibilities:

• Designed and developed data mart models

• Tuning oracle databases and performance optimization

• Developed BI Dashboards & OLAP reports

• Generate Ad-hoc Reports with Microsoft Reporting Services 2005

• Audited the process used to acquire and transform data and validated transformed data

• Enabled advanced data analysis with PerformancePoint Server and ProClarity

• Created data models

Environment :- SQL Server 2000, sql server 2005, sql server 2008, Oracle 10g, PL/SQL, VBA, SQL Analysis services, Query Analyzer, ISQL, WS_FTP , Ascential Data stage, Quality Stage ERWIN,sharepoint, UML, Sql server 2005,MS Project, MS Access 97 / 2000,Performance point 2007 & Windows Server 2003.

08/07 to WELLS FARGO - San Francisco, CA

09/08 Business intelligence Architect

Project Description: The assignment was to analyze the requirements to be met to implement and support new features on existing mortgage products in the single family division of Wells Fargo.

Responsibilities:

• Created OLAP databases, cubes and created calculated measures using MDX.

• Created briefing books or views in ProClarity

• Monitoring of backup and recovery processes

• Generated Reports using Business objects

• Created SQL Server database to responsively handle complex queries (T-SQL, DTS,SSIS, triggers, stored procedures, functions, optimization) and .NET data access components

• Created scorecards with Performance point

Environment :- SQL Server 2000, sql server 2005, sql server 2008, Oracle 10g, PL/SQL, VBA, SQL Analysis services, Business Objects , Query Analyzer, ISQL, WS_FTP , Ascential Data stage, Quality Stage ERWIN, UML, Business objects XIr2,Dundas, Sql server 2005,sharepoint,MS Project, C#,MS Access 97 / 2000 & Windows Server 2003.

09/06 to INTEL – San Jose, CA

08/07 BI developer

Project Description: - Intel wanted to understand business intelligence data of their world wide service pricing strategies. This project in addition to monitoring the OLTP database also consolidated lot of information for the business intelligence data.

Responsibilities:

• Optimized hardware and SAN design

• Deployed and administrated SQL 2005/2000 Enterprise servers on production environment.

• Generate Ad-hoc Reports with Microsoft Reporting

• Administer, maintain, develop and recommend policies and procedures for ensuring the security and integrity of the company's databases.

• Manage and Create database schemas for Relational Database Systems (optimize index creation, table creation, storage allocations, etc.).

• Identify and resolve database performance issues, database capacity issues and other distributed data issues.

• Integrated dundas with olap.

• Running and monitoring SQL Server 2005 Integration Services (SSIS) packages

Environment :- SQL Server 2000 Enterprise Edition, sql server 2005,Oracle 10g, PL/SQL, VBA, SQL Analysis services, Cognos, Enterprise manager, Query Analyzer, ISQL, WS_FTP ,Business Objects XI, Ascential Data stage, Quality Stage ERWIN, UML, Sql server 2005,MS Project, MS Access 97 / 2000 & Windows Server 2003,DUNDAS.

09/05 to SCIF – San Francisco, CA

09/06 Business Intelligence architect

Project Description: SCIF is one of the leading Insurance providers in California. This project is developed for District Health System in California. SCIF aspires to provide continuous improvement in their ability to use corporate and third-party data for the pricing process, customer and analytic research programs, sound daily management of results, and increased data management efficiency with the business intelligence team.

Responsibilities:

• Supporting Active/Active and Active/Passive cluster for SQL Server 2000 and 2005

• Implemented ETL process architecture and data warehouse capacity planning

• Actively engaged in design discussions for all Business Intelligence and database initiatives.

• Used SSIS to perform ETL operations for Master Data Management (MDM) needs as well as auditing reasons

Environment :- SQL Server 2000, sql server 2005, sql server 2008, Oracle 10g, PL/SQL, VBA, SQL Analysis services, Query Analyzer, ISQL, WS_FTP , Ascential Data stage, Quality Stage ERWIN, UML, Sql server 2005,MS Project, MS Access 97 / 2000 & Windows Server 2003.

03/04 to VERIZON - TX

09/05 SQL Server DBA/Developer

Project Description: - Worked as Sql DBA for Verizon. Verizon communications is the largest provider of Telecommunication Services in US. Verizon focuses greatly on data mining, reporting, queries and other business intelligence services to further up its position in the market.

Responsibilities:-

• Provided an estimation of the migration plan in terms feasibility, time duration and resources.

• Extensively worked on DTS packages and BCP to load large volumes of data into data warehouse.

• Configured and managed clusters; set up Sql Server 2000/2005 on active/active, active/passive clusters; configured resource dependencies; Implemented cluster fail over.

• Capacity planning in estimating and sizing of tables.

• Designed the deployment of MS SQL Server 2000 in a Windows 2000 cluster using Cluster Services.

• Used SQL Server Profiler to trace the slow running queries and the server activity.

• Provided 24/7 Support for Production, Development & Test Servers of MSSQL Servers.

• Worked on database builds, cloning, performance tuning, load balancing, backups/restores

• Database creation, database tuning, and performance planning, backup planning and database administration.

Environment :- SQL Server 2000 Enterprise Edition, Oracle 10g, PL/SQL, VBA, SQL Analysis services, Enterprise manager, Query Analyzer, ISQL, WS_FTP, Teradata, Ascential Data stage, Quality Stage ERWIN, UML, MS PowerPoint, MS Project, MS Access 97 / 2000 & Windows 2K platform, SharePoint.

02/04 to NATIONWIDE INSURANCE - Columbus, OH

03/04 Ascential Senior Database Developer

Project Description: - Reviewing the Name/Address domain split process and assist Nationwide in identifying a solution to resolve the current issues with the rule set.

Responsibilities:-

• Developed ER diagrams (Physical and Logical using ERWIN) and mapping the data into database objects.

• Ascential Parallel Extender canvas was used to develop all the jobs due to high volume of data/feeds

• Working on address cleansing schemes using Integrity and quality Stage.

09/03 to MEDSTAT - Ann Arbor, MI

02/04 to SQL Server DBA /Developer

Project Description: - The objective of this project was to define ETL Specifications including Jobs for Data sources to load and mappings of sources in different formats to target. The project was also to create a database for the production department & work on various possible performances related issues including Database Tuning with the sole intention of achieving faster response times and better throughput.

Responsibilities:-

• Capacity planning in estimating and sizing of tables.

• Monitoring the database objects growth, managing the extents growth and de-fragmenting the objects, which are running out of maximum extents. Monitoring the excessive fragmentation of Indexes and taking remedial steps.

• Developed ER diagrams (Physical and Logical using ERWIN) and mapping the data into database objects.

• Materialized views, dimensions and stored outlines for optimal performance.

• Wrote Triggers and Stored Procedures to capture updated and deleted data from OLTP systems.

• Involved in Installation of Analysis Services in MS SQL SERVER 2000.

• Created OLAP Cubes and performed data mining on the data using the fact table and the dimension.

• Scheduling, running, and monitoring multiple concurrent DTS jobs

• Captured metadata within the data model for the metadata repository.

Environment :- SQL Server 2000 Enterprise Edition, PL/SQL, SQL Analysis services, Enterprise manager, Query Analyzer, HIPPA , ISQL, WS_FTP, Developer 2000, Crystal Reports Pro, ERWIN, UML, MS PowerPoint, MS Project, MS Access 97 / 2000 & Windows 2K platform.

11/01 to ARAMARK UNIFORM SERVICES – Burbank, CA

09/03 SQL Server DBA/ ETL Developer

Project Description: - ARAMARK continues to be a global leader in professional services, providing award-winning food, hospitality, facility management services and high-quality uniform and work apparel. This system was intended for proving intelligence on loads of work apparel.

Responsibilities:-

• Complete administration of MS-SQL Server version 7.0/MS SQL 2000.

• Migration of databases from SQL7.0 to MS SQL 2000 wherever required.

• Used Performance Monitor and SQL Profiler to optimize queries and enhance the performance of database servers

• Wrote Triggers and Stored Procedures to capture updated and deleted data from OLTP systems.

• Coded and deployed the ETL architecture using Data Stage

• Maintained the physical Databases by monitoring Performance, Space utilization and Physical integrity.

Environment :- SQL Server 7.0/2000, T-SQL, Enterprise Manager, Query Analyzer, Oracle 8i, PL/SQL, Visio, Db2.

09/00 to TOSHIBA MEDICAL SYSTEMS – Irvine, CA

10/01 SQL Server DBA/ ETL Developer

Project Description: - Toshiba's medical system continues to save lives and improve health of people around the world with some of the most powerful and patient-friendly systems available.

Responsibilities:-

• Forcing multiple encoding specifications using Unicode.

• Migration of databases from SQL7.0 to MS SQL 2000 wherever required.

• Used Performance Monitor and SQL Profiler to optimize queries and enhance the performance of database servers

• Wrote Triggers and Stored Procedures to capture updated and deleted data from OLTP systems.

Environment :- SQL Server 7.0/2000, T-SQL, Enterprise Manager, Query Analyzer, Oracle 8i, PL/SQL, Visio, Teradata, Data stage, Ascential Quality Stage.

08/99 to ELECTRONIC TEE SHEET – Irvine, CA

09/00 T-SQL Analyst & SQL Server Developer

Project Description :- This project involved migrating data from 3RD party application software’s to tables and then executing complex queries on the data.

Responsibilities :-

• Worked with the DBA to prepare a Disaster Recovery Plan for their database in a scenario wherein the Master Database File is Lost / Corrupted.

• Tuned the batch programs and online transactions to alleviate performance problems.

• Developed & executed several Optimized queries in SQL on this data.

Environment: - SQL Server 6.5 2000, Windows NT Platform, Data stage, Ascential Integrity T-SQL, EXCEL, Access 97, Erwin, Crystal Reports 9, MS WORD.

06/95 to GOKALDAS EXPORTS - Bangalore – India

06/99 VB5 Programmer & SQL Server Developer

Project Description: - This project involved a team of 3 to build an application using VB5 & SQL Server 6.5 for the Accounts Department which could take care of the daily transactions. Concepts from Software Engineering & SDLC were put to use during this project. Teamwork was crucial as deadlines had to be met along with the quality of the software. Less importance was given towards the Performance related issues. More emphasis was given towards meeting the specified User requirements in a very short period of time.

Responsibilities:-

• Developed various client applications using Visual Basic( front-end ) & SQL Server 6.5 for the Accounts Department.

• Worked on generating Crystal reports.

• Designed a Beta Version of the accounts Database from the scratch after following the SDLC specifications.

• Monitored system activity tables & documented the results.

• Created Complex PL/SQL Queries.

• Involved in development, testing and implementation of the whole application.

Environment: - Visual Basic, SQL Server 6.x, HTML, Crystal Reports, MS WORD, UML.

06/93 to AMPERSAND - Mumbai – Bangalore

05/95 Web Developer & Database Designer

Project Description: - Building and maintaining application in asp and sql server.

Responsibilities:-

• Worked as a Database & WEB developer.

• Analyzed and Designed the Database in My SQL containing 7 tables.

• Create tables, primary keys, foreign keys, constraints, views, clustered, non-clustered, unique, non-unique indexes.

• Create and manage jobs for daily / weekly batch runs and database / server maintenance activity.

• Wrote complex stored procedures, triggers.

• Creating the GUI using HTML editor & Photoshop.

• Embedded PHP scripts & My SQL in HTML.

Environment: - Windows NT Platform, My SQL, Adobe Photoshop, PHP, HTML.

EDUCATION:

• MS in Computer science

• Post graduate diploma in business administration

Contact this candidate