SUMMARY

• 9 years of IT experience (7 years in BI and DW) working for variety of companies within several industries mainly Retail, Banking, Insurance, Manufacturing and Government
• Very Strong experience inMICROSTRATEGY 10.x/9.x/8.x, MICROSTRATEGYDesktop (Developer), Web, Administration, Intelligence server, Office, Object manager, Integrity manager, Enterprise manager, Intelligent Cubes and configuring Intelligence Server from the scratch.
• Extensive Experience in creating the Dynamic Dashboards & Scorecards reports using MICROSTRATEGY
• Expertise in the concepts of Data Warehousing, Data Marts, ER MODELING, Dimensional MODELING, Fact and Dimensional Tables.
• Knowledgeable in business functionality for developing MULTIDIMENSIONAL MODELING.
• Extensive knowledge of SQL, PL/SQL, TSQL programming and worked on very large databases like Oracle 11g/10g/9i, and SQL Server 2005/2008, Teradata V2R5/V2R4.
• Experience inSchema designand creatingSchema objects usingStar and Snowflake(Hierarchies, Attributes and Facts, Transformations,).
• Excellent experience in MICROSTRATEGYReport development, Reporttesting, Reporttuning,Ad - hoc,scheduling and report delivery.
• Extensive experience on all types of MICROSTRATEGYFilters, Prompts, Templates, Metrics, Consolidations and Custom Groups.
• Proficient in SQL Command, Joins, Metadata, creating Simple Metrics, Compound Metrics, applying Transformation, using Prompts, Filters.
• Experience in using Project Merge, Object Manager,and Enterprise Manager.
• Experienced in preparing resource & effort estimations/forecasts, MICROSTRATEGY Roadmap Creation for end-to-end BI projects.
• Extensive experience in onshore/offshore coordination and responsible for project deliverables.
• Ensure the team follows the change control process when there is any request to change the agreed scope.
• Strong understanding of Data Warehousing methodologies and Data Modeling, normal forms, Star Schema, Snowflake Schema, Slowly Changing Dimensions, Fact tables, Dimension tables, type 1 and type 2, OLAP and OLTP systems
• Consulting experience working for high profile consulting companies on several projects
• Experience across all phases of SDLC and Agile from project initiation to post-implementation and support
• Experience in ETL processes and integration. Worked extensively on data extraction, cleansing, data integration, and loading from different data sources using DATASTAGE, Oracle PL/SQL, Unix Shell, Teradata and SAS EG
• Extensive knowledge of data warehouse design and development using Oracle 11g/10g/9i, Teradata and SQL Server
• Experience developing database objects such astables, views, stored procedures, triggers, row-level audit tables, cursors, indexes, user-defined data-types, functionsandconstraints
• Experience in developing and supporting complex ETL jobs using IBM INFOSPHERE DATASTAGE. Integrated multiple data sources and processing stages, including performance tuning and optimization
• Experience in Creating OBIEE Dashboards and Answers and BI Publisher reports
• Ability to quickly adapt to different project environments, work in teams and accomplish difficult tasks independently within time frame

TECHNICAL SKILLS

Business Intelligence Tools: MICROSTRATEGY 9.2.1m - 9.3.1 - 9.4, 10.2, OBIEE, BIP, Oracle Reports, SAS

Programming/web: Shell Script, Perl, VB.Net & ASP.Net (1.1, 2.0), XML Web Services, Visual C++ .net, C#, XML, JavaScript, Java

Database: Oracle 9i/10g/11g, SQL Server 2014, Teradata 14 - SQL Developer, Toad

ETL Tools: IBM INFOSPHERE DATASTAGE 8.5, Oracle SQL Loader, PL/SQL, SAS

Other Tools: Erwin, Control-M, ACCUREV, GIT, MS Project, MS Visio, HP Quality Centre, PVCS, MATLAB, SHAREPOINT, SVN

Methodologies: AGILE, SDLC, Prince2, etc.

PROFESSIONAL EXPERIENCE

Confidential

DATA WAREHOUSE/MICROSTRATEGY ARCHITECT

Responsibilities:

• Developed and implemented reporting solutions Using MICROSTRATEGY, Teradata and SQL Server for KPIs dashboard, Store Insights, Profit and Loss Dashboards, Offers flexible report, Laps Reporting and Channel Scorecard.
• Defined standards for data warehouse design and implementation.
• Conducted a full impact analysis and remediation of data warehouse migration from Teradata to SQL Server with Data Vault architecture.
• Performance tuning of the existing ETL codes and reports.
• Data warehouse architecture, design and data modeling for multiple projects.
• Designed and modeled multiple solutions with Star Schema Modeling and Snowflake Dimensional modeling.
• Data Modeling using ERWIN 4.0/3.5.2, SQL Server, Toad data modeler
• Importing tables using Warehouse catalog and Creating Logical Tables.
• Managed backup of Metadata.
• Analyzed the business requirements identifying the requirements reviewing and communicating with business.
• MICROSTRATGEY Upgrade from 9.4 to 10.2 for all the servers and rectifying all the issues associated with the upgrade
• Administered MICROSTRATEGYenvironments and formulated user groups.
• Installation of MICROSTRATEGY products and creating a MICROSTRATEGYproject.
• Handled user licenses for projects.
• Importing tables using Warehouse catalog and Creating Logical Tables.
• Managed backup of Metadata.
• Involved in fork lifting the MICROSTRATEGY project from Oracle to Teradata
• Built Complex Reports using advanced reporting functions like Level Metrics, Conditional Metrics, Derived Metrics and Advanced Filters.
• Created Apply Simple and Apply Comparison functions to develop complex metrics and filters.
• Provided support to consultants, Technical Support engineers in creating and troubleshooting MICROSTRATEGY SDK customizations.
• Analyzed and developed the new objects in Dev environment and after testing the objects and reports migrated to Production Environment.
• Involved as the principal technical lead providing input to application design regarding production tuning and administration requirements.
• Extensively worked on MICROSTRATEGY administration that includes Intelligence server administration, configuration of memory settings and performance monitoring.
• Used Administrator tools like Project Merge and object Manager to move the objects from one environment to another environment.
• Worked with the administrator to monitor and fine tune SQL queries for better performance of reports.
• Defining Drill Hierarchies and creating relationship between attributes.
• Involved in project discussions related to schema objects which acts has a semantic layer for the MICROSTRATEGY project.
• Made auto prompt filter feature to give the end user an option of various filtering criteria each time they run the report.
• Strong knowledge in creating Intelligent Cubes, which will give the performance when executing the reports and also enabling Dynamic Sourcing for specific cubes.
• Worked on Creating Security Roles, MICROSTRATEGYUser Groups and Users, assigning security roles to Users and Groups.
• Involved in creating security filters to end users to access data based on their privileges.
• Created services using Subscriptions, Schedules and distribution services
• Formulated grid, graph, document and dashboard reports.
• Designed and developed the Dynamic dashboards using Visual Insights or Documents.
• Created Datasets for the Dynamic dashboards using various selectors, panels and widgets.
• Extensively used report services to create dashboards to create summary level reports using multiple datasets.
• Used several new controls for dashboards like time series slider, radio buttons and dropdown menus for the Flash version of the dashboards.
• Worked in different environments like, Development, QA and Production and migrate jobs from environment to environment.
• Worked with different feature teams on different Roadmap's simultaneously to deliver the line items in a timely manner.
• Worked on Agile project tracking tools (such as JIRA) and structured development methodologies (such as Agile Scrum, iterative)

Environment: MICROSTRATEGY 9.4, 10.2 (Developer, Architect, Web, Integrity Manager, Enterprise Manager, Object Manager, Distribution Services), Teradata 13, SQL Server 2012, SAS EG, AUTOSYS, Data Vault, UNIX Shell, Windows Server, Amazon Cloud

Confidential

ORACLE/MICROSTRATEGY ARCHITECT

Responsibilities:

• Worked as the main Architect and Data Modeler to design the Dimensional Models as per requirements.
• Involved in Conversion of Corporate Data Model into a Warehouse Star and Snowflake Model.
• Developed 100s of complex ETL jobs using advance PL/SQL and Unix Shell Script
• Developed database objects: tables, views, procedures, packages and other database objects using Oracle tools like SQL* Plus, SQL*Developer and TOAD for Oracle
• Developed logical and physical data model using ERWIN by defining strategy for Star Schema with Fact and Dimension tables with Detail, Summary, Look-up tables, Indexes and views.
• Involved in maintaining optimal performance of BI application, performance monitoring, capacity planning, and tuning for multiple users.
• Design and development of end to end Enterprise Reporting Solutions (Merchandising, Finance, Operations) using Oracle 11g/10g/9i and MICROSTRATEGY 9.4/8.2/8.0.
• Delivered the full ETL process and reporting solution for 7 totally different large projects including Fresh Produce ordering / reports, Supplier’s Income analysis / reports, Multichannel, Workforce Management, Fresh Store Assisted Ordering and Logistics.
• Performed SQL and PL/SQL tuningand Application tuning using various tools likeEXPLAIN PLAN, SQL*TRACE, TKPROFandAUTOTRACE.
• Extensively involved in usingHINTS to direct the optimizerto choose an optimumquery execution plan.
• Created Partitions and Indexes on tables for faster execution of queries and improving performance.
• Loaded client data from ASCII files using SQL*Loader.
• Developed the scripts for creating the database objects like Tables, Global Temporary tables, Sequences, Indexes, Synonyms and triggers etc.
• Involved in modification/troubleshooting of batch jobs to meet the requirements and scheduling tasks
• Developed UNIX Shell scripts to automate table creation, execute procedures.
• Design and development of OBIIEE Dashboards and Answers for Customer Reporting and Loyalty.
• Designing end-to-end ETL process (BRD, BFS, BRN, IFM, LDM, and TSD) including gathering requirements from users and stakeholders and coordination with data providers and source systems.
• Leading technical Development & implementation of ETL for business solutions using Oracle 11g, Teradata, Shell Scripting and IBM DATASTAGE 8.5, including data validation and cleansing.
• Developed and implemented more than 100 reports, documents and mobile/desktop dashboards for variety of projects mainly in finance, marketing, operations, insurance and workforce management.
• Successfully migrated the whole Business Information Warehouse (BIW) from HP Superdome to Oracle Exadata in less than 4 month.
• Improved the performance of existing oracle scripts and legacy codes.
• Used analytical and governing settings in VLDB properties to tune the SQL and for calculating the metrics in dealing with the nulls and zeroes
• Created Transformations (table based, formula based) this week vs. last week analysis reporting.
• Drilling options (Drill up down across) were used to generate ad-hoc reports.
• Created design and technical specification documents for realizing MICROSTRATEGY objects to be integrated in the report.
• Built manyIntelligent Cubes, which will give the performance when executing the reports, and also enabling Dynamic Sourcing for specific cubes.
• Gathered requirements from management users for generation of reports in Web and Desktop.
• Involved in troubleshooting MICROSTRATEGY prompt, filter, template, consolidations and custom group objects in an enterprise data warehouse team environment.
• Created Dashboard and Scorecards using Report Services Documents.
• Involved in the Creation Document from multiple Datasets like Map Application Diagram, Grid and graph.
• Worked in customization of MICROSTRATEGY Web.
• Designed Custom drill maps using drill map editor as per the requirements for drill through functionality.
• Worked effectively with ETL team to assist them in data validation.
• Used several new controls for dashboards like time series slider, radio buttons and dropdown menus for the Flash version of the dashboards.
• Involved in Managing migration of MICROSTRATEGY projects and objects from Development to Testing and to production environment.
• Used Integrity Manager to test project level discrepancies after upgrades
• Optimized reports to improve the performance.
• Co-ordinate test plans and provided feature/functionality/usage scenarios for the Managers.
• Tested report layouts, validated the SQL query, prompt orderings, export/print functionality and drilling options.
• Involved in troubleshooting MICROSTRATEGY Reports, by optimizing the SQL using VLDB properties for creating complex reports using Advanced Filters, Compound Metrics, Conditional, Transformation and Level Metrics.
• Worked with MICROSTRATEGY Desktop/Web to create new documents/dashboards and fix the issues with existing documents/dashboards.
• Involved in complete life cycle of multiple BI reporting projects of the group.
• Developing logical models, building hierarchies, attributes and facts, extracting tables from warehouse catalog.
• Created Consolidations, Custom Groups and Prompts for the reports.
• Developed Scorecards and Dashboards that provide users a highly graphical, summary view of key metrics.
• Caching Reports in the Intelligence Server daily, enabling user to run the report immediately.
• Optimized the performance of the MICROSTRATEGY platform by implementing suitable report design processes, and SQL tuning.
• Worked on MICROSTRATEGY Object Manager to move objects from development environment to the test environment.
• Used Command Manager to automate the whole MICROSTRATEGY administrative tasks including, purge cache, user management, and trigger reports according to event load.
• Extensively used report services for creating summary level Enterprise Dashboards using Grid/Graphs, Gauges, Dials and Advanced Visualizations.
• Involved in troubleshooting MICROSTRATEGY Prompts, Filters, Templates, Consolidations, and Custom groups in an enterprise data warehouse team environment.
• Worked in creation of Projects, ODBC, database instances and configuration of project.
• Created transformational metrics (Market Share, and Growth) to compare monthly, quarterly and annual sales.
• Configured Enterprise Manager to collect statistical data related to different projects.
• Facilitated Business analysis by creating relevant reports by using filters, custom groups, consolidations and transformations (table based, formula based)
• Adapt at managing projects through entire systems development life cycle, including creating timely/thorough status reports and leading status meetings.
• Worked on MICROSTRATEGY Object Manager to move objects from development environment to the test environment.
• Created Cubes and scheduled them to run weekly bases.
• Provided postproduction support to end-users.

Environment: Oracle 11g, MICROSTRATEGY 9.4, IBM DATASTAGE, OBIEE, BIP, SQL Server, Toad, Erwin, Unix Shell, Perl, CONTROL-M, ACCUREV, LIQUIBASE, HP Quality Center

Confidential

DATA ANALYST/DEVELOPER

Responsibilities:

• Designed and developed a data migration solution to integrate data from various data sources into a centralized SQL Server 2008 database.
• Dealt with large weather data files was the main concern as the system required a fast and real time response.
• Developed a platform to load weather forecasts into the database and use it for trajectory prediction.
• Analyzed source systems; identified data rules, violations and cleansing strategies.
• Defined standards and implemented a framework for the development.
• Defined and implemented the required business transformation rules and logics.
• Implemented reconciliation processes; Identified and resolved inconsistencies.
• Tuning SQL queries in order to increase the performance related issues of the existing database packages & functions.
• Involved in Analysis, Design and Development, Testing, Maintenance and resolved problems during implementation

Environment: SQL Server, Java, MATLAB

Confidential

DATABASE/DATA WAREHOUSE SUPPORT

Responsibilities:

• Support more than 200 finance and business users with their ADHOC reporting needs.
• Providing data extracts out of DW to the business for user acceptance testing process.
• Upgrading the database and software to new releases.
• Managing the storage structures of the database.
• Managing users and security.
• Developing IPs and data extracts.
• Managing schema objects, such as tables, indexes, and views.

Environment: Oracle, Windows Server

Confidential

Analyst Programmer/Sales Consultant

Responsibilities:

• Analysis of business and organizational requirements for information management solutions.
• Implementation of third party tools, plug-ins and components.
• Tracking and monitoring the applications and providing resolutions to technical issues
• Maintaining reports and other documents.
• Identifying modification and renovation requirements for the application and developing update patches accordingly.

Environment: SQL Server, My SQL, C#, JAVASCRIPT, CSS, xml