OBJECTIVE:

• To obtain a position with the responsibilities and challenges that will utilize my technical skills, analytical skills, interpersonal skills, and leadership skills in a progressive and innovative organization.

SUMMARY

• A results - driven business intelligence and data-warehouse specialist with over 10 years’ experience in system developmental cycles, project management life cycles, agile methodologies, systems design concepts, understanding data architecture concepts, data modeling, project design and project implementation.
• 10 + years MICROSTRATEGY experience in designing and developing different analytical applications.
• 2 years MICROSOFT POWER B.I
• Strong knowledge in finance, supply chain, logistics, retail, healthcare and manufacturing business functions.
• 2 years experience using IBM DESIGN STUDIOS for complex E.T.L and Entity Relationship Diagrams.
• Over 8 years’ experience in business analysis, requirement gathering, design, development, testing, data conversion, training, debugging and documentation (i.e.: user manuals, functional and technical specifications documents) and building complex analytical reports / dashboards.
• A strong problem-solving skill.
• An effective team player
• Excellent communication skills.
• A catalyst in presenting and up selling new products and solutions to clients.

AREAS OF EXPERTISE

• Business Intelligence
• MicroStrategy
• Microsoft Power B.I
• Cognos
• Data Warehousing
• Data integration
• Data modeling
• Business Analysis
• Enterprise Reporting
• Meta Data Development
• Dashboards
• UAT Testing
• SQL
• MicroStrategy Mobile Specialist

TECHNICAL SKILLS

POWER B.I: Microsoft Power B.I, Microsoft Power B.I Mobile, SSRS, Microsoft SQL Server

MICROSTRATEGY: MicroStrategy Architect, MicroStrategy Desktop, MicroStrategy Web, Visual InsightEnterprise Manager, Object Manager, Narrowcast, MicroStrategy Mobile, Cloud.

COGNOS: Cognos 8 (Report Studio, Analysis Studio, Metric Studio, and Framework Manager)

Databases: Oracle, MS-SQL, IBM-DB2, Teradata, SQL-Servers.

ETL Tools: Infosphere Design Studio, Working knowledge on Informatica and SSIS.

Data Modeling Tools: IBM-Rational Architect, Erwin, IBM-Infosphere Design Studio, Visio, DBDesigner4

BI/OLAP Tools: MicroStrategy 10.11, 10.7, 10.5, 10.4, 10.3, 10.2, 10, 9.2.1, 9.2, 8, 10.0, 10.1. 10.3, 10.4, Cognos 8 (Report Studio, Analysis Studio, Metric Studio, Frame-work Manager), Working knowledge on Cognos 10. MS Analysis Service, Power B.I, Power B.I Mobile.

Operating Systems: Windows 9x, 2003/2000, XP and working knowledge on Unix and Linux

Reporting Languages: SQL, MRE, Working knowledge on MDX and SAS

CASE Tools: Microsoft Visio, Rational Rose

IBM Infosphere: Warehouse SQL Warehousing, Predictive Modeling, Text Analytics

Computer Skills: Microsoft office suite (Outlook, PowerPoint, SharePoint, Excel EST.), H / Drive, P / Drive. Snagit, Office Communicator EST

PROFESSIONAL EXPERIENCE

Confidential

MicroStrategy Consultant

Responsibilities:

• Gathering requirements from Business users, organizing JAD sessions and brainstorming sessions.
• Documenting all business requirements and functional requirements.
• End-user training on MicroStrategy.
• Proper time management and scheduling meetings to discuss project timelines, key milestones and the project charter.
• Ensuring proper Agile methodologies are followed.
• Migrating objects from one environment to the next. Creating packages and using MicroStrategy object manager.
• Creating multiple schema objects like tables, attributes and facts. Fixing all schema related defects and suggesting report fixes.
• Creating logical tables and look-up tables using MicroStrategy Architect.
• Creating multiple public objects like filters, prompts and ad-hoc grid reports / graph reports.
• Creating configuration objects.
• Mapping MicroStrategy objects to the right columns in the database tables.
• Preparing all B.I design documents and support documents.
• Working on the technical requirements, using case scenarios, report mock-ups, mappings and other artifacts.
• Analyzing data problems, investigating and conducting user’s acceptance testing (UAT) as per project requirements or maintenance request documents.
• Writing complex SQL queries for testing and validating data using Teradata.
• Running DDL scripts, creating views, migrating views and testing views.
• Communicating the logical data model changes, data model gap analysis, transition planning and delivery.
• Providing design input to the physical data model to the DBA and the ETL developer on the team to enable the creation of the physical data models and data dictionary.
• Providing the design input for the data architect, data flows, and semantic data models.
• Working closely with other team members to identify data related problems and solve them.
• Working with business users on testing and validations.
• Building Microstrategy cubes, subscriptions and schedules
• Creating multiple reports, documents & complex report objects like metrics, filters and prompts.

Confidential

Microstrategy Business Analyst & Architect

Responsibilities:

• Organizing JAD sessions to understand user requirements and document them.
• End-user training on MicroStrategy and its self-service components like Visual Insight and cubes.
• Proper time management and scheduling meetings to discuss project timelines, key milestones and the project charter.
• Ensuring proper Agile methodologies are followed.
• Gathering requirements from users and complete requirement documents.
• Leading a team of developers and assigning task to them - offshore team members.
• Preparing all B.I design documents and support documents.
• Working on the technical requirements, using case scenarios, report mock-ups, mappings and other artifacts.
• Analyzing data problems, investigating and conducting user’s acceptance testing (UAT) as per project requirements or maintenance request documents.
• Creating multiple schema objects like tables, attributes and facts. Fixing all schema related defects and suggesting report fixes.
• Creating logical tables and look-up tables using MicroStrategy Architect.
• Creating multiple public objects like filters, prompts and ad-hoc grid reports / graph reports.
• Creating configuration objects.
• Mapping MicroStrategy objects to the right columns in the database tables.
• Writing complex SQL queries for testing and validating data using Oracle, SQL Server, DB2 and Teradata.
• Communicating the logical data model changes, data model gap analysis, transition planning and delivery.
• Providing design input to the physical data model to the DBA and the ETL developer on the team to enable the creation of the physical data models and data dictionary.
• Providing the design input for the data architect, data flows, and semantic data models.
• Working closely with other team members to identify data related problems and solve them.
• Working with business users on testing and validations.
• Building Microstrategy cubes and schedules
• Creating multiple reports, documents & complex report objects like metrics, filters and prompts.

Confidential

Microstrategy Consultant

Responsibilities:

• Creating other complex reports & documents using Microstrategy
• Investigating issues and resolving them.
• Organizing JAD sessions to understand user requirements.
• Creating / modifying multiple schema objects like tables, attributes and facts.
• Creating logical tables and look-up tables using MicroStrategy Architect.
• Creating multiple public objects like filters, prompts and ad-hoc grid reports / graph reports.
• Creating configuration objects
• Mapping Microstrategy objects to the right columns in the database tables.
• Preparing B.I Detailed Design Documents for all completed task and tickets.
• Working on the technical requirements, using case scenarios, report mock-ups, mappings and other artifacts.
• Analyzing data problems, investigating and conducting user’s acceptance testing (UAT) as per project requirements or maintenance request documents.
• Writing SQL queries for testing and validating data using Oracle SQL.
• Communicating the logical data model changes, data model gap analysis, transition planning and delivery.
• Providing design input to the physical data model to the DBA and the ETL developer on the team to enable the creation of the physical data models and data dictionary.
• Providing the design input for the data architect, data flows, and semantic data models.
• Working closely with other team members to identify data related problems and solve them.