A BI-MicroStrategy Developer/Architect with experience in Data warehousing and Business Intelligence. Industry experience includes working in the Health Care, Financial Services, Mortgage, Retail and Telecommunication verticals. Has worked on MicroStrategy projects involving administration and application lifecycle management and has built numerous dashboards. Also possesses solid experience in migrating reports from a Legacy System to web based reports utilizing MicroStrategy 9. Has excellent communication skills and works well independently or as a team member.

Confidential, Canada
Business Intelligence Consultant
Apr 2011 July 2011
Responsibilities:

• Cleaned the duplicated objects and unneeded objects from the project
• Worked on Custom report wizard o simulate existing legacy reporting tool
• Worked on Translating Midas Sas Reports to Microstrategy Reports
• Worked on converting DMS Reports to Microstrategy Reports

Confidential, Canada

Business Intelligence Consultant
Apr 2010 April 2011
Responsibilities:

• Created Reports and multi layer dashboards.
• Worked on Various projects from initial stage of data modeling to designing hierarchies, parent child relationships
• Worked on Object migration using object manager
• created schema objects like Attributes, Facts, Hierarchies, Tables and Transformations
• Created public objects like Metrics, Prompts, Custom group, consolidation, filters, Reports and Documents
• worked on various projects like Dsl , Legacy Order, Get Connected, Campaign Management, Billing ,Service assurance, Survey report, Bell Apps Reports and Dashboards
• Maintenance and support of the existing projects
• Troubleshot and validated reports, Performance tuned system

Confidential,

MicroStrategy Consultant
Apr 2009 Mar 2010
Responsibilities:

• Selected the warehouse tables to be used for creating the MicroStrategy Project using MicroStrategy Warehouse Catalog
• Created MicroStrategy public objects such as Reports, Filters, Custom Groups, Metrics and Prompts
• Designed MicroStrategy schema objects such as Facts, Attributes and Tables
• Analyzed business requirements and interacted with Business Analysts to design ad-hoc reports
• Created MicroStrategy public objects such as Reports, Filters, Custom Groups, Metrics and Prompts
• Create simple Metrics, Compound Metrics, Attributes, Templates, Reports, Prompts, Basic Filters, Advanced Filters using custom expressions, and Proficient at using Functions
• Created and managed users

Confidential,

Business Intelligence Consultant
Apr 2008 Apr 2009
Responsibilities:

• Documented the MicroStrategy BI application development
• Remodeled, redesigned and cleansed the existing MicroStrategy project
• Created simple Metrics, Compound Metrics, Templates, Reports, Prompts, Basic Filters, and Advanced Filters using custom expressions
• Created Attributes, Hierarchies, and Drill Maps
• Built new reports, dashboards, existing reports troubleshooting, enhancements and performance tuning
• Workedon capacity planning, indexes, PL/SQL, SQL optimization, Partitioning, .RMAN, Oracle Enterprise Manager, Oracle Tuning and Diagnostics
• Performed extensive analysis of Database to identify gaps
• Mapped all inconsistencies and recommended and implemented measures to address inconsistencies
• Maintained and enhanced MS Access databases
• Performed data extraction and translation using DTS from multiple sources
• Mapped and cleansed data in the Data Warehouse
• Performed data analysis and reported on marketing campaigns and customer survey responses

Confidential,

Business Intelligence Consultant
Oct 2007 Mar 2008
Responsibilities:

• Developed and managed models and reports in Microstrategy
• Worked closely with business users to verify data requirements and access needs
• Assisted in the development and update of the technical documentation
• Created simple Metrics, Compound Metrics, Templates, Reports, Prompts, Basic Filters, Advanced Filters using custom expressions, and Functions
• Created Logical Table Views in MicroStrategy
• Built new reports, dashboards, existing reports troubleshooting, enhancements and performance tuning
• Responsible for the administration of Microstrategy projects
• Responsible for the MicroStrategy BI application development documentation
• Performed data extraction and translation using SSIS from multiple sources
• Performed data consolidation and standardization
• Worked with database of size up to 9 Terra bytes
• Provided statistics on program performance areas to Clients and Internal Departments
• Developed and managed models and reports in SQL Reporting Services, SQL Reporting Servers (SSRS)
• Tested reports for usability, data quality and performance
• Provided end user training and knowledge transfer

Confidential,

MicroStrategy Architect
Nov 2005 Mar 2007
Responsibilities:

• Created and maintained processes and reports that documents portfolio and sub-ledger activity
• Worked with databases ranging from 800 Gb to 5 Terra bytes
• Created and updated technical documentation
• Wrote SQL Procedures
• Developed and managed models and reports in MicroStrategy and SQL Reporting Services, SQL Reporting Servers (SSRS)
• Performed data extraction and translation using SSIS from multiple sources
• Created simple Metrics, Compound Metrics, Templates, Reports, Prompts, Basic Filters, Advanced Filters using custom expressions, and Proficient at using Functions
• Built new reports, dashboards, existing reports troubleshooting, enhancements and performance tuning
• Administered MicroStrategy projects and managed the application lifecycle
• Documented the development of the MicroStrategy BI application
• Maintained and enhanced MS Access databases
• Worked closely with business users to verify data requirements and access needs
• Created, developed and updated technical documentation
• Tested reports for usability, data quality and performance
• Created subscriptions using MicroStrategy Narrowcast server
• Development and debugged complex batch Transact SQL Procedures and functions
• Provided all round support on technical issues, including report and query optimizations

Confidential,

MicroStrategy Architect
Feb 2004 Nov 2005
Responsibilities:

• Remodeled, redesigned and cleansed the existing MicroStrategy project
• Planned, designed and developed BI applications using MicroStrategy products in the EDW environment
• Built new reports, dashboards, existing reports troubleshooting, enhancements and performance tuning
• Administered MicroStrategy projects and managed the application lifecycle
• Documented the development of the MicroStrategy BI application
• Maintained and enhanced MS Access databases
• Performed data extraction and translation using SSIS from multiple sources
• Provided end user training and knowledge transfer
• Created simple Metrics, Compound Metrics, Templates, Reports, Prompts, Basic Filters, Advanced Filters using custom expressions, and Proficient at using Functions
• Worked closely with business users to verify data requirements and access needs
• Created subscriptions using MicroStrategy Narrowcast server
• Created, developed and updated technical documentation
• Involved in coding by writing SQL Procedures, sizing, creation and maintenance of tables, constraints, views and database links
• Monitored and optimize SQL maintenance plans to include backups, indexing
• Designed DTS Packages for importing and exporting data migration and cleanup from legacy and source systems onto SQL Server
• Assisted in testing and tuning of SQL Server to improve the database performances
• Converted the BI application to support combining businesses

Confidential,

Report Developer/Database Administrator
Oct 2001 Feb 2004
Responsibilities:

• Designed DTS Packages for importing and exporting data migration
• Consulted and validated data warehouse logical and physical models
• Created and restored system backups and updated System LOG
• Granted Roles and Permissions to SQL Server Users
• Responsible for database recovery and technical support
• Reviewed SQL diagnostic data and responded to server alerts
• Monitored, optimized and allocated physical data storage for databases
• Performed system analysis, design, coding and testing
• Executed SQL queries in Oracle, Sybase and SQL Server in order to view the state of Tables
• Worked with Transact-SQL, SQL backups, logs, DTS packages and Log Shipping

Confidential,

SQL Developer
Apr 1997 Aug 2001

EDUCATION :

Post Graduate in MIS and Computer Applications

Bachelors in Computer Science