Manager Sql Server

Tom Mathew

214-***-****/*********@*****.***

Professional Summary:

• Seven Plus Years of IT experience in performing as a MicroStrategy Developer, MicroStrategy Architect, and Business Intelligence solutions.

• Over Six Years of Experience in MicroStrategy tool Suite (Desktop, Web, Intelligence server, Architect, Report service Document, Dynamic Dashboards, NarrowCast Server, Administrator, Enterprise Manager, Object Manager).

• Worked on Data Modeling tools like Microsoft Visio and ERwin.

• Good knowledge in Data Warehousing concepts such as Dimensional Modeling, Star Schema, Snowflake Schema, Data Marts, OLAP, Fact and Dimension Tables.

• Experience in Architecture process creating Schema objects with MicroStrategy Desktop like simple and compound Facts, Attributes, Fact extensions, Hierarchies, Transformations.

• Worked on performance tuning of various MicroStrategy Reports in MicroStrategy Desktop by tuning the VLDB properties and by various design techniques.

• Extensively worked on MicroStrategy Administration that includes Intelligence Server Administration, configuration of Memory settings, Performance Monitoring, Assigning Privileges and Job Monitoring.

• Experience in working with MicroStrategy Security model including Users, Groups, Security Roles and Security filters.

• Configured Integrity Manger and Object Manager.

• Adept in Dash Boarding and Documents, worked extensively on panel stacks, widgets, and customized the web.

• Installed and configured Intelligent Server and Narrowcast Server to Schedule, Execute and Deliver Reports using various delivery methods like file and emails.

• Good Understanding of Intelligent cubes and Data mart design.

• Familiar with Data Management Systems – SQL Server 2000/2005/2008, Oracle 9i/10g

• Experience in translating business requirements into logical dimensional models.

• Extensive back ground and knowledge of Stored Procedures, Triggers, Functions, and Transact SQL.

• Self-starter and quick learner with proven analytical, technical, and communication skills. Very resourceful in problem solving.

• My professional interests include project management; systems integration, design and development, usability and information architecture for websites and database applications.

Technical Skills:

BI Tools MicroStrategy 9/8.x/7.x, Desktop, Web, Architect, Narrowcast Server, Object Manager, Project Merge, Integrity Manager, Dashboards and scorecards. Query Builder.

Data Modeling Microsoft Visio 2000/2003/2007, ERwin r7.3

ETL Tools Informatica Power Center 8 (Knowledge in creating a Repository Folder, Source, Target and Mapping)

RDBMS Oracle 10g/9i, MS SQL Server 2000/2005/2008

Management Tools Microsoft Project 2003/2007

Problem Solving Tools Mind Mapping tool: FreeMind - 0.8.1

Web Technologies Microsoft Expression Web 2.0/3.0, Adobe Dreamweaver CS4, Swish 2.0 (Flash)

Operating Systems Windows NT, Windows Server 2003/2008/XP/Vista/7 Business and Ultimate, Unix, Linux-Ubuntu, Redhat, SUSE, Fedora

Programming Languages SQL, PL/SQL, C++, HTML, DHTML, XML, CSS

Professional Experience:

M & T Bank, Buffalo, NY Jul 2009 – Till Date

MicroStrategy Developer/Administrator

M&T Bank traces its origins to the founding of Manufacturers and Traders Bank in Buffalo, New York and is one of the 20 largest commercial bank holding companies in the U.S. M&T Bank has over 750 branches & 1,800 ATM's across Delaware, Maryland, New York, Pennsylvania, Virginia, West Virginia, New Jersey and Washington, D.C.

I was involved in identifying source tables, analysis on requirements, communication with business users and assisted in data modeling and database design for BI solutions. Administered and monitored jobs, projects and Intelligent Server.

Responsibilities:

• Involved in collecting and documenting business requirements from end clients and translating them into report specifications for the MicroStrategy platform.

• Involved in Dimensional Modeling by selecting the business process, declaring the grain, and choosing the dimensions and facts.

• Generated reports for the cooperation for Assets period to period.

• Delivered documents for Financial Analysis, Statements and Summary, customer lifetime value and customer loyalty

• Generated Key Performance Indicators (KPI) metrics and other metrics.

• Developed Schema Objects (Facts, Attributes, Hierarchies and Transformations) using MicroStrategy Architect.

• Delivered personalized reports from MicroStrategy project to subscribers using MicroStrategy Narrowcast Server.

• Set Up MicroStrategy and Windows Performance Counters and Log them to Text or CSV for Performance Tracking.

• Worked with MicroStrategy Distribution Services and Monitored systems usage.

• Perform Daily Checks for job Monitor, User sessions and Cache Monitor to keep the system stable.

• Created intelligent cube and monitored memory usage, storage and loading.

• MicroStrategy I-Server Tuning for performance.

• Used various Event based Schedules for report delivery.

• Installed, upgraded and managed MicroStrategy 8.x to 9.x Intelligent and Web servers for development, test and production environments.

• Performed basic configuration of Intelligence server and updated projects.

• Performed system checks like licensing, functionality, managing user privileges of the system.

• Added new users to groups and assigning them security privileges.

Environment : MicroStrategy Architect, MicroStrategy Desktop 9/8, MicroStrategy Web 9/8, Narrowcast Server, MicroStrategy Intelligence Server 9i, Oracle 10g/9i,

Informatica Designer 8.1, Windows Server 2008 and UNIX

Farmers Insurance Group, Los Angeles, CA Aug 2008 – Jun 2009

MicroStrategy Developer/Architect

The Objective of the project was to analyze the various insurance service related queries. Created Customized reports and various OLAP reports as per management requirements. This helps Farmers Insurance Group in the area of revenue assurance, customer risk management, customers' accounts receivables and collections. The Business Directors or the report users access and analyze the reports and make intelligent business decisions to compete with other competitors.

Responsibilities:

• Involved in the gathering of business requirements and translating them to the report specifications for the MicroStrategy platform.

• Participated in BI team meetings to discuss the user requirements.

• Review of the requirement specifications and preparation of documents.

• Involved in the Design of Physical data models for the MicroStrategy applications.

• Involved in designing and updating the data model using Erwin 7.0.

• Created and established KPIs based on logical data model.

• Architected schema objects such as Attributes, Facts and Transformations.

• Created various MicroStrategy objects such as Metrics (simple and compound), Filters, and Prompts.

• Used Advanced Prompts, Conditional, Transformation metrics and Level metrics for creating complex reports.

• Created transformations (Table Based and Expression Based) for YTD (Year to date), MTD (Month to date) and WTD (Week to date) analysis.

• Set up Report Data Options, Formatting, Dynamic Dates, VLDB Properties, Advanced Sorting, Prompt Ordering, Totals, Outline Mode based upon the business user change request on UAT Testing.

• Involved in Maintenance & Performance Tuning of reports.

• Worked with MicroStrategy Object Manager to move objects among the Development, Testing and Production environments.

• Created reports with various Object prompts to generate various Ad hoc reports.

• Created various Monthly Dynamic Dashboard documents for Field marketing people with multiple panel stacks, selectors and customized widgets.

• Upgraded system from MicroStrategy 8.x to MicroStrategy 9.

• Set up report level security in MicroStrategy for users.

• Created various Narrowcast reports, subscriptions and schedules and posses sound knowledge on Distribution Services.

Environment: MicroStrategy 8.x (Desktop, Administrator, Web), MicroStrategy

Intelligence Server 9, Distribution Services, Micro Strategy Narrowcast Server 8

Erwin 7.0, Oracle 10g/9i, Informatica 8.1, Windows Server 2003

Interactive Data Corporation, Bedford, MA Sep 2007 - Jul 2008

MicroStrategy Developer/Administrator

Interactive Data is a leading provider of financial information and analytical software to global markets. Interactive Data supply mission critical data designed to support fund pricing, securities operations, research, and portfolio management. I worked on developing reports, documents and maintained the project, and assisted the management in analyzing performance against projected goals.

Responsibilities:

• Maintained a Multidimensional Model. Snowflake Schema was mainly used in dealing with different dimensions.

• Involved in MicroStrategy Administration like Creation of new users, roles, privileges, shared folders, Access Controls Lists, Day to Day Administrative activity of Financial transactions processing project including maintenance.

• Moved Objects between Different environments using Object Manager.

• Created and tested highly interactive and complex reports using MicroStrategy 8.x.

• Developed new reports and modified existing reports for the business line to satisfy the specifications.

• Created Ad hoc reports and analysis from intelligent cubes with interactive slice and dice OLAP using MicroStrategy Desktop

• Assisted in creation of schema objects facts, attributes and Hierarchies.

• Created Transformations to be used in comparative reports like sales this year to last year. Implemented security for different users to view reports for their regions using security filters.

• Extensively worked and developed Metrics, Templates, Filters to give Decision makers a handy tool to choose the criteria for reports and view information in different perspectives.

• Used various types of Prompts (filter definition, object, value and level) to dynamically modify the contents of a report during run time. Included Consolidations in order to group attributes and customize report.

• Extensively used MicroStrategy Desktop and Web to enable users to run pre-defined sales and inventory reports; build their own customized reports.

• Generated reports by using Custom Groups.

• Implemented drill maps that allow users view the reported information in greater detail, from a high-level enterprise wide overview to information relating to specific products.

Environment: MicroStrategy 8.x, Oracle 9i, MicroStrategy Desktop 8.x, MicroStrategy Web 8.x,Narrowcast Server 8.x, UNIX, Windows Server 2003

Bank of West, San Francisco, CA Oct 2006 - Aug 2007

MicroStrategy Developer/Administrator

Worked as a MicroStrategy Developer to design and develop application objects and configuration of the project.

Responsibilities:

• Involved and implemented the project from rudimentary stage.

• Participated in requirement gathering, data modeling, design and architecture.

• Created Attributes, Facts, Hierarchies, Transformations and application objects including advanced metrics.

• Designed and developed Dashboards for interactive analyses.

• Worked extensively on creating and making use Application Objects like Metrics and Compound metrics Relationship Filters Custom Groups and Consolidations.

• Day to Day Administrative activity of Sales processing project including maintenance, enhancement and User Management using Object Manager.

• Performance Optimization was done to existing reports and report response time was brought down remarkably.

• Implemented Security capabilities by creating Security filters and associated with Specific User Groups.

• Took help of MicroStrategy Knowledgebase to troubleshoot some Report related issues.

• Developed Attribute filter prompts to give end users a choice of different filtering criteria each time they run the report.

• Implemented Narrowcast tasks like service designs, subscription, scheduling and administration.

Environment: MicroStrategy 8.x (Administrator, Desktop, Architect, Web, Intelligence Server, Narrowcast), Oracle 9i, MS Office and Windows Server 2003.

Payless ShoeSource, Topeka, KS Sep 2005 - Sep 2006

MicroStrategy Developer

The purpose of the project was to develop various financial reports and also sales order reports which will help manager to take an effective decision on their business.

Responsibilities:

• Involved in gathering of business requirements.

• Analyzed and developed Application Objects (Metrics, Reports, Documents, filters, prompts) using MicroStrategy Desktop and MicroStrategy web interfaces.

• Created metrics (simple, nested & compound), advanced filters, advanced prompts, advanced report designs and drill maps.

• Created reports with various object prompts to generate various Ad hoc reports.

• Involved in Testing of reports and Optimized the Intelligence Server for better performance.

• Worked with Test Director to fix and close the defects for the project.

• Created multiple projects pointing to staging, testing and production data warehouse.

• Created various Narrowcast reports, subscriptions and schedules.

• Assisted MicroStrategy Administrator with regards to administrative tasks like Cache and Job monitoring, Database instance creation, user creation.

• Created various Report services and Dashboard documents on sales sent monthly to vendors.

• Created various alert based services and Page Personalization Subscriptions.

• Used Teradata Mload script and OLE Load for loading data into Teradata from various sources.

• Worked with MicroStrategy Object Manager to move objects among the Development, Testing and Production environments.

Environment: MicroStrategy 8.x (Desktop, Administrator, Web), MicroStrategy

Intelligence Server 8.x, MicroStrategy Narrowcast Server 8.x, Teradata v2r4, Windows Server 2003.

Ross Stores Inc, Pleasanton, CA Nov 2004 – Aug 2005

MicroStrategy Consultant

The Ross Merchandising and Operational Reporting Systems is an information access application designed to provide Finance Inventory Control Reporting, Merchandising Reporting, Operational Reporting & Inventory Reporting, Balancing Reports, Pre count Reports, Final Inventory Reports, Mark down Reporting, On order Management, Marketing, Post dated sales, Store Disposal, YTD Sales on each Product Sales

Responsibilities:

• Created MicroStrategy Public objects (Metrics, Filters, Prompts, reports) and Schema objects (Attributes, Facts, transformations, Documents) to generate ad-hoc reports using MicroStrategy Desktop and Report services.

• Implemented advanced Data drilling features that allow Enterprise users at all stages to view the data at different hierarchical levels.

• Created Report Templates for consistency in the look and feel of the reports

• Created Hierarchies for providing drill down options for the end-user through MicroStrategy Web.

• Created proactive reports and delivered them to various end users using MicroStrategy Narrowcast Server.

• Developed Filters (relationship, comparison) for complex reports.

• Data Marts reports are created based on user requirements.

• Involved in troubleshooting MicroStrategy prompt, filter, template, consolidations, and custom group objects in an enterprise data warehouse team environment.

• Involved in the business processes for understanding, developing, and finalizing the data warehouse requirements.

• Identified source tables and columns from the Oracle data warehouse to create a MicroStrategy project.

Environment: MicroStrategy 7.x (Desktop, Web, Intelligent Server, Narrowcast Server), Oracle 9i, ERWIN, UNIX, Windows 2000/NT, ER diagrams, Data Flow diagrams,

ICICI Bank, Chennai, India May 2003 – Aug 2004

SQL Server Developer

ICICI Bank is India's largest private sector bank by market capitalization and second largest overall in terms of assets. Worked on retail collection system, a GUI based client/server bill collection software, to assist brokers in carrying out their daily transactions. Upgrade from MS SQL Server 7.0 to 2000.

Responsibilities:

• Assisted the company with migrating from MS SQL Server 7.0 to SQL Server 2000 64-bit Edition

• Managing databases, tables, indexes, views, stored procedures.

• Enforcing business rules with triggers and user defined functions, troubleshooting, and replication.

• Writing the Stored Procedures, checking the code for efficiency.

• Maintenance and Correction of Transact Sequel Server (T-SQL) Statements.

• Daily Monitoring of the Database Performance and network issues.

• Administering the MS SQL Server by Creating User Logins with appropriate roles, dropping and locking the logins, monitoring the user accounts, creation of groups, granting the privileges to users and groups.

• I did backups on a regular basis and added logins and user accounts, installing and configuring reporting services.

• Entered information into the database, worked with spreadsheets, answered phones, completed orders, and managed invoices.

• Troubleshoot database performance issues and tuned database objects. Set up traces and profiler to troubleshoot performance issues. Analyze deadlocks & diagnose issues on the server.

• Perform SQL Server version updates & deploy changes to production databases.

Environment: SQL Server 2000, Visual Studio .NET (2002), Windows 2000 Server

Education:

• Bachelors in Engineering, SRM, Chennai, India

CONFERENCES

• Attended webinar on: MicroStrategy 9 R2 Upgrade

• Attended webinar on: Introduction to MicroStrategy 9 Distribution Services

• Attended webinar on: Fundamentals of MicroStrategy Dashboarding

• Attended webinar on: Slicing and Dicing with OLAP with WYSIWYG Editor

• Attended webinar on: Business Intelligence Inside of Microsoft Office

Contact this candidate