SUMMARY:

• Around 8 years of experience in Business Intelligence, ETL and Data warehousing technologies with proficiency in MicroStrategy versions 10.x/9.x/8.x/7.x: Administrator, Intelligence Server, Architect, Desktop Designer, Security Administration, MicroStrategy Web Administration, Object Manager, Command Manager Integrity Manager, Report Services, Enterprise Manager, Narrowcast Server and Dashboards. Application knowledge in Retail, Food and Beverages and Insurance domains.
• Expertise with entire Software Development Life Cycle (SDLC) which includes requirement gathering and analysis, Design and Development, Implementation, Testing, Deployment, Production support and Maintenance, Built and Release management.
• Extensive experience in MicroStrategy Dashboards, Report development, Documents, Report tuning, Report testing, Ad - hoc, Mobile and training Business Users in various OLAP services in MicroStrategy.
• Excellent knowledge of Business Intelligence and fundamental data warehousing concepts like dimensional modeling, data mart modeling, star and snow flake schemas.
• Strong experience in MicroStrategy connectivity with several databases such as Oracle, SQL Server 2012/2008/2005, Teradata, MS Access, Netezza, DB2.
• Expertise in schema architecture and report building objects.
• Expertise in Designing Report Service Documents and Dashboards with diverse datasets.
• Experience in various Performance Tuning methods such as Caching, VLDB properties, SQL tuning, and Creation of indexes on tables.
• Worked on transforming Legacy reports into MicroStrategy reports and working in both offshore and onsite environment. Worked on composing resource and effort forecasts/estimations, creation of MicroStrategy Roadmap for end-to- end Business Intelligence projects.
• Excellent analytical and problem-solving skills.
• Very good leadership qualities with experience in advising technical groups on MicroStrategy/Reporting best practices and training developers and excellent team player with different teams involved.

TECHNICAL SKILLS:

BI Tools: MicroStrategy10/9.x/8.x/7.x (Administrator, Intelligence Server, Architect, Desktop/Developer, Web, Distribution Services, Mobile, Integrity Manager, Command Manager, Object Manager, Narrowcast Server, Visual Insight, OLAP services), IBM Cognos 10, Tableau, SAP Business Objects, Spotfire 7.x

ETL Tools: SQL Server 2012/2008/2005, SSIS services, SSRS, SSMS, Informatica Power Center 9.x/8.x

Databases: Oracle11g/10g/9i, MS SQL Server, Teradata, Netezza, MySQL, DB2

Programming: PL/SQL, TSQL, SQL Plus, SQL Loader, C, HTML, CSS, JavaScript, Java, Python

Operating Systems: Windows 10/8/7, UNIX, Linux

Other Tools: Toad, SQL Assistant, MS Office, PL/SQL Developer, Erwin, Microsoft Visio, Selenium, TestNG, Cucumber, System I Manager

PROFESSIONAL EXPERIENCE:

Confidential, Hartford CT

Sr. MicroStrategy/Spotfire Developer

Responsibilities:

• Involved in requirements gathering, user interaction, design and development of reports (Underwriting KPI’s and metrics).
• Closely worked with the end users on finalizing the Dashboard layouts and worked on every minute detail formatting for a desired look and feel by suggesting them with various blue prints of dashboards available and customized it according to the client needs.
• Designed dashboard templates for future use of Underwriting department.
• Coordinated with Database Architect in the Design and Development of physical and logical schema in Star, snowflake schemas to build MicroStrategy schema by creating views on top of the data warehouse.
• Used the existing project sources and database instances and created them as required.
• Generated new schema and application objects for underwriting department and used existing objects from other departments.
• Developed filters and prompts (Product type, Year, Category and others), Metrics (Productivity score, Decisions/hour, RNA, RNF, Queue Size) to slice and dice the reports, and generate complex dashboards with derived and compound metrics.
• Developed interactive dashboards in Presentable modes.
• Involved in troubleshooting of dashboards, reports, prompts and filters in an enterprise data warehouse team environment.
• Used Freeform SQL for designing some custom reports.
• Extensively worked in designing and developing Interactive Scorecards and Dashboards.
• Customized and optimized reports for various users using MicroStrategy features like VLDB properties at Project level (sub totals) and report level.
• Extensively worked on Visual Insight Dashboards for excel, local databases and with the warehouse data with MicroStrategy and Spotfire tools.
• Worked with ETL developers in designing complex transformations tables and sometimes for the deformalized tables/Views.
• Worked with end users along with Business Analysts to gather requirements, build reports and dynamic dashboards. Involved in prototyping and POC Reports.
• Created dummy data for the high-fidelity wireframes, closest to their weekly data dumps.
• Involved in training the end users on how to use the dashboards and knowledge transfer to the Underwriting MicroStrategy development team.
• Worked on Data validation testing to ensure report development and data quality.
• Created Unit/System/User Acceptance test cases on the MicroStrategy/ Spotfire objects developed.
• Involved in migrating the objects from DEV to UAT/Staging using the Object Manager.

Environment: MicroStrategy 10.7 (Developer, Web, Architect, Object Manager), MicroStrategy Intelligence Server, Spotfire 7.8, Oracle, DB2, MS Office, MS Visio, SQL Developer, System I Manager.

Confidential, Richardson TX

Sr. MicroStrategy Developer

Responsibilities:

• Involved in the entire software development life cycle which includes requirements gathering, user interaction, design and development of reports (Sales, Customer reports).
• Closely worked with the end users on finalizing the Dashboard layouts and worked on every small detail formatting for a desired look and feel by suggesting them with various blue prints of dashboards available and customized it according to the client needs
• Coordinated with Database Architect in the Design and Development of physical and logical schema in Star, snowflake schemas to build MicroStrategy schema.
• Responsible for the Creation of Project source and projects by creating new database instances
• Generated different Schema Objects like Attributes, Facts, Hierarchies and application objects like Reports and Report related objects such as filters, templates and metrics.
• Developed Filters (on Year, Geography), Metrics (claims processed, revenue generated), prompts (for Regions, Year) for achieving the functionality of the canned reports and built advanced objects like Compound Metrics and Derived Metrics
• Report manipulations using various options like: data pivoting, page by (on geography, time, claims and other dimensions), sorting, totals, thresholds, etc.
• Developed MicroStrategy Dynamic Dashboards in the Presentable, Flash Mode and interactive dashboards.
• Involved in troubleshooting MicroStrategy dashboards, reports,promptsand filters in an enterprise data warehouse team environment.
• Used Freeform SQL for designing some custom reports.
• Extensively worked in designing and developing Interactive Scorecards and Dashboards.
• Customized and optimized reports for various users using MicroStrategy features like VLDB properties at Project level (sub totals) and report level.
• Used dynamic linking and URL API for prompts and selectors between different dashboards.
• Extensively worked on Visual Insight Dashboards for excel, local databases and with the warehouse data.
• Worked with ETL developers in designing complex transformations tables and sometimes for the deformalized tables/Views.
• Worked with end users along with Business Analysts to gather requirements, build reports and dynamic dashboards. Involved in prototyping and POC Reports and dashboards before the major dashboards kick off.
• Worked on Data validation testing to ensure report development and data quality.
• Involved extensively in the overall lifecycle of the Data Warehouse integration project.
• Created Unit/System/User Acceptance test cases on the MicroStrategy objects developed.
• Involved in migrating the objects from DEV to UAT/Prod using the Object Manager.
• Providing technical support, troubleshooting report design, monitor system usage and proactive troubleshooting.

Environment: MicroStrategy 9.x,10.x (Desktop, Architect, Object Manager), MicroStrategy Intelligence Server, SQL Server, Oracle, MS Office, MS Visio, SQL Developer, Tableau

Confidential, Atlanta, GA

MicroStrategy Architect

Responsibilities:

• Developed logical models for reporting environment based on the end user requirements. Accumulated source tables from the data warehousing team which are involved in making reports.
• Created Attributes, Facts and MicroStrategy logical views as per reporting needs (Distributor, Geography, Sale patterns, etc.), customized Hierarchies (Location, Stores) for Drill Maps.
• Manipulated attribute and attribute forms properties to enforce right table joins.
• Created Complex filters, prompts, and metrics with advanced qualifications involving Apply Simple & Apply Comparison functions. Created smart metrics with custom subtotals.
• Created complex metrics involving MTD/YTD Transformations to generate Y/Y sales reports, growth reports in various aspects and Level Dimensionality.
• Highly used the VLDB properties (on Joins- join type (inner join- to select the records that are common in both tables), Subtotal dimensionality aware (in calculating complex metrics), Apply filter options) for Performance tuning of the reports and significantly reduced the report run time. Also used OLAP services like Derived metrics, View filters wherever necessary.
• Worked extensively on Complex reporting needs which involved creating Consolidations (distributors) and Custom Groups (distributors, stores).
• Worked with ETL teams to implement complex product-based transformations.
• Implemented security filters at project level and report level to restrict certain products (only relevant details of the region are shown to the regional manager), based on user group assignment.
• Created Intelligent Cubes (on Regional Performance, transactional sales) to perform highly interactive analysis by using Dynamic Sourcing, View reports and Derived elements.
• Performed Administration tasks like User Creation, Session Handling, Creating Security roles, Analyzing Report performance, installed patches like sever installation and solved customer issues with MicroStrategy Administrator
• Designed many Freeform SQL reports by directly querying against the data warehouse.
• Extensively worked in both Ad-hoc and Standard Reporting Environments and involved in building reports scalable to large volumes of data. Managed projects through entire Systems Development Life Cycle.
• Developed Dynamic Dashboards both in interactive & flash mode using various Widgets and Selectors (Panel, radio, check box, drop down), ESRI maps, documents for summary level reporting with large datasets.
• Generated and implemented MicroStrategy Transactional Services reports.
• Creating Dashboards and Visual Insight Dashboards on mobile, iPad for the Managers and stakeholders who are involved in the day-to-day operations.
• Worked closely with various business functions to find opportunities to build new business enhancing reports and to automate existing labor and time intensive critical reports.
• Responsible for Unit Testing of the reports.

Environment: MicroStrategy Tool Suite 9.4.1, (Developer, Intelligence Server, Web, Mobile), Toad, MS Excel, Informatica, Erwin, SQL server, Oracle, SQL Developer, Teradata.

Confidential, Columbus, OH

MicroStrategy Architect

Responsibilities:

• Consult with stakeholders to gather requirements and plan milestones in the research, development, and implementation phases of the project lifecycle.
• Worked on building and maintaining analytical layer and MicroStrategy schema as an Architect.
• Created entity relationship diagrams and multidimensional data models, reports and diagrams for Inventory and Purchase departments with Erwin.
• Create Logical views in MicroStrategy to support the new requirements. Responsible for Architectural design changes and enhancements
• Created lookup tables for the Inventory, Brands and Customers.
• Responsible for understanding existing SSIS reports and converting them to MicroStrategy reports and Visual Insights (previous year sales report and brand reports).
• Fixed existing MicroStrategy Dashboards and schema objects and created dashboards and visualizations from scratch using Developer and Web
• Was involved in Performance Optimization by creating Aggregate tables and Intelligent cubes to existing reports and report response time was brought down remarkably by performing OLAP operations on the cube to generate reports.
• Performed unit testing, end-user testing on the reports and dashboards.
• Perform migration activities on the objects from DEV to Stage and Production.

Environment:: MicroStrategy Tool Suite 9.3(Developer, Intelligence Server, Web), MS SQL Server, MS Visio, MS Excel, Erwin, MySQL, Teradata, Spotfire, Business Objects

Confidential

MicroStrategy Developer

Responsibilities:

• Involved in collecting the Business Requirements and documenting the specifications, team coordination and managing time estimates for the project
• Gathered requirements from the users and defined KPI’s to build scorecards and dashboards.
• Created logical mapping of the project by identifying source tables and attributes.
• Designed MicroStrategy Schema and Application objects using Developer and maintained data dictionary for the project.
• Worked extensively in creating complex reports using simple metrics, compound metrics, relationship filters.
• Created several base formulas (mathematical expressions) using existing facts in MicroStrategy Agent that can be re-used to build any number of metrics.
• Reduced the time taken for the reports to run by taking advantages of VLDB properties like star join, query and sub query optimizations for oracle 9i and SQL hints.
• Created advanced grid reports, consisting of data analysis by combining a template with filters
• Extensively used MicroStrategy Report Services to generate Report Documents.
• Worked as a support resource for other related projects and was responsible for re-architecting required changes and checking the report results in QA.
• Tested all the reports by running queries against the warehouse using SQL Navigator. Also compared those queries with the MicroStrategy SQL engine generated queries.
• Responsible documentation and configuration of Enterprise Manager for logging statistics and reporting purposes.

Environment:: MicroStrategy 8.2.1/9.0.1 (Administrator, Architect, Desktop, Object Manager, Enterprise Manager), Dash Boards, Narrowcast Server, SQL Server, Oracle 9i, Netezza, SQL Navigator, HTML & DHTML., Cognos, Tableau

Confidential

SQL Developer

Responsibilities:

• Created database objects like Tables, Views and Indexes, Clusters and Sequences.
• Identified the Integrity Constraints and developed database triggers.
• Creating and maintaining triggers, packages, functions and procedures.
• Responsible for developing the online screens.
• Performed data imports and exports using the SQL Loader.
• Developing Reports using Oracle Reports 2.5.
• Analysis of the database for performance issues and conducting detailed tuning activities for improvement.
• Involved in performance monitoring and tuning of Oracle database servers.
• Wrote procedures to meet ad-hoc requirements to replicate data from one table to another.
• Involved in system maintenance.
• Performed backup and restoration of system and user databases and involved in scheduling the backups.
• Managing the use of disk space, memory and connections.

Environment: Oracle 7.1, SQL Developer, T-SQL, ASP, VB, PL/SQL, Shell Scripts, MS Office