SUMMARY:

• Over 9.0 years of Business Data Warehousing experience in Data Modeling, Design, and Development mainly focusing on Implementing Business Intelligence.
• Information Technology - Data Warehousing Tools like OLAP-Microstrategy Reporting Tool, In memory Analytics-QLIKVIEW 11.0, ETL-Informatica and Teradata Utilities (BTEQ, Fast Export).
• Hands on experience as Developer, Administrator, Architect in Microstrategy.
• Extensively worked in creating and integrating Microstrategy Reports and objects (Attributes, Filters, Metrics, Facts, and Prompts) with the data warehouse.
• Adept in Dashboards and Documents, worked extensively on panel stacks, widgets, and web development and customization.
• Delivered reports in Desktop, Web and via Narrowcast Server.
• Hands on experience in UNIX-Shell Scripting.
• Exp in using all the transformations like Aggregator, Lookup, Normalizer, Joiner, Router, Expression, Update Strategy.
• Experience in Debugging, Troubleshooting and Performance tuning.
• Handled large volumes of data warehouse databases.
• Expertise in error analyzing.
• Efficient in in corporation of various data sources such as Oracle, MS SQL Server, DB2, Teradata, XML and Flat files into the staging area.
• Hands on Experience in UNIX and SQL.
• Hands on Experience in creating Grid and Graph reports.
• Having strong Knowledge in creating necessary report objects like Filters, Metrics and Prompts.
• Have good knowledge in Scheduling Reports.
• Have strong knowledge in DB2 and Teradata.
• Capability to meet deadlines and work under pressure.
• Team player and self starter with ability to work independently or part of a team and ability to pick up new skills quickly.

TECHNICAL SKILLS:

Business Intelligence: Microstrategy 8.0.2 / 8.1.1 / 9.0.2 / 9.2.1 m / 9.4.1/10.1/10.2ETL Tools: Informatica 7.1.1/8.6.1/9.1/9.6.1

Languages: SQL

Operating Systems: Windows 2000, XP and NT & UNIX

Databases: Netezza, Oracle,DB2 and NCR Teradata.

PROFESSIONAL EXPERIENCE:

Confidential

Application Developer

Responsibilities:

• Gathering Customer Requirements, Performing Analysis, Design, Development, End User Acceptance Presentations and Implementation.
• Being architect, need to create the required Schema Objects and Public Objects for the report development.
• Create new Grid Reports based on the requirement and develop the documents (multi layout and with different group fields) which are made available in pdf, excel etc..,
• Being part of Agile methodology; active involvement into the other work streams design whenever required.
• Mentor the team and provide guidance for effective utilization.
• Brainstorming for the design along with Microstrategy Architects for better BI platform.
• Deliver Product demos to end users and business partners.
• Train the new team members and scale them according to project needs.
• Worked aggressively on performance tuning and achieved the best execution time for the existing reports.

Environment: Microstrategy 9.4.1 / 10.2 & Oracle, Teradata and Netezza.

Confidential

Application Architect

Responsibilities:

• Gathering Customer Requirements, Performing Analysis, Design, Development, End User Acceptance Presentations and Implementation.
• Created new Grid Reports based on the requirement.
• Being part of daily status calls and mentoring the offshore team.
• Worked in Agile Methodology and provided solutions within SLAs.
• Worked closely with ETL - Informatica team on data loads and understood the business flow required for Microstrategy Reporting.
• Worked effectively in tuning the reports.

Environment: Microstrategy 9.2.1 / 9.4.1 & Oracle.

Confidential

DW Module Lead BI

Responsibilities:

• Performed Customer Requirements Gathering, Requirements Analysis, Design, Development, Testing, End User Acceptance Presentations, Implementation and Post production support of BI projects.
• Created new Facts, Attributes and Attribute Form Expressions as needed in the project.
• Worked with back end Database Administrators to provide requirements for necessary back end tables.
• Involved in Testing and Tuning of Reports and Objects.
• Maintenance and Support for the project and end users.
• Created all possible Metrics for users to build their own reports on Web by creating their own Templates and filters using the available Metrics.
• Loading data into tables using PL/SQL Scripts for ETAC Project every month. Taking backup of existing tables and validating the data.
• Involved in Microstrategy version up gradation from 9.0.1 to 9.2.1m and testing done across all the reports and dashboards.
• Developed Micro Strategy application objects such as Metrics, Filters, and prompts to compare monthly, quarterly and annual sales.
• Developed transformations to generate reports of type Sales this period to Sales this period Last Year and so on.
• Designed Templates, Filters to generate Reports in grid and graph mode. Auto prompt filter feature gave end-user a choice of different filtering criteria each time they run the report.
• Tested the Microstrategy objects across Database.
• Creating Dashboards / Documents as per the BRD discussion.
• Mobile BI (Ipad) Development
• Developed Microstrategy Visual Insights.

Environment: Microstrategy 9.2.1m & Oracle 10g.

Confidential

Module Lead

Responsibilities:

• Executing Month End jobs, Performance Monitoring, User Account Management.
• Metadata Maintenance (MD Doctr and Scan MD), Server Configuration (NCS, Web and I server), Narrowcast Scheduling and Customer Reporting
• Application Monitor for Teradata.
• Performed testing of all reports for the final deployment.
• Created Reports using complex Filters and Compound Metrics and Prompts.
• Hands on experience on Object Manager, Command Manager and Integrity Manager.
• End User / Client User training on Microstrategy for Ad-hoc Report creation.
• Created Freeform SQL Reports.
• Involved in Narrowcast Server Configuration, User Creation, subscription creation and schedule creation.
• Involved in various back end ETL development tasks and Production Support.

Environment: Microstrategy 8.1.1 / 9.0.2, NCR Teradata & Informatica 8.6.1.

Confidential

Programmer Analyst

Responsibilities:

• Assess and analyze business requirements; system impacts, system requirements and manage the development activities.
• Involved in creating the IMRs and CMRs using Amex internal tools for tracking the issues and any change implementation in production as per Amex standards
• Interaction with Business partner and Client of Amex and providing the innovative solution for their business reporting analysis.
• Daily status meeting with team to discuss for current day activities, pending deliverables and issues.
• Updating the weekly status and monthly status meeting documents.
• Developing Standard and Create reports using Microstrategy Desktop.
• Developing Attributes, Facts, Metrics, Filters, Prompts and Hierarchies as per Specifications for developing reports.
• Tuning SQL queries for the report optimization by using VLDB settings.
• Preparing Report Mapping Documents as per Specifications.

Environment: Microstrategy 8.0.2, DB2 & Abinitio.