SUMMARY:

• More than 11+ years of IT experience with Business Intelligence, ETL Applications, Data Warehousing, Data Architecture, Data Modeling and Validation.
• Extensive experience as MicroStrategy Developer, Architecture and Administrator.
• Extensive experience in developing Schema Objects (Facts, Attributes, Hierarchies, and Transformations) and Public Objects (Filters, Prompts, Metrics, Custom Groups, Consolidations, Searches and Templates) to develop reports.
• Extensive experience creating Reports, Documents, Dashboards and Scorecards according to client/business user requirements.
• Having good experience of VLDB properties to Fine tune report.
• Good experience in development of Dashboard for Mobile and Ipad Devices.
• Expertise in Creating Intelligent cubes in MicroStrategy.
• Good knowledge to move MicroStrategy project from old version to new version.
• Having good knowledge on developing and designing interactive Tableau Dashboard reports.
• Experience on convert Business Object Report to MicroStrategy Report.
• Proficient with Data modeling using Erwin and Toad for dimensional data modeling techniques such as Star schema and Snowflake schema, which includes Logical and Physical data modeling.
• Good Knowledge for understanding Physical and Logical Data model and Creating Hierarchies in MicroStrategy.
• Expert in Database development skills using SQL, PL/SQL, Stored Procedures and Packages.
• Very strong SQL skills using various functions of SQL.
• Pleasant experience in MicroStrategy Web SDK, Knowledge on Web UI Customization and MicroStrategy Web API.
• Developed Interactive dashboard with using different Graph option and also with Grid & Graph combination.
• Experienced with the concepts of Data Warehousing, Data Marts, Logical and Physical data modeling, ER Modeling, Dimensional Modeling, Fact and Dimensional Tables.
• Extensive experience on Full Software Development Life Cycle (SDLC) Initiation, Planning, Analysis, Design, Construction, Documentation, Testing, Implementation and Maintenance in data warehousing environment.
• Good Experience in RDBMS like DB2, Oracle, SQL Server, Netezza, Teradata and DBMS like MS Access.
• Having Good Knowledge on BIGDATA, Apache Hive, Hadoop.
• Good Knowledge MicroStrategy to connect HDFS using Hadoop Gateway.
• Extensive experience creating Reports, Documents, Dashboards and Scorecards according to client/business user requirements.
• Good Knowledge of Extract Transformation Loading (ETL) process.
• Expertise in Data Verification.
• Good work experience with Public and Private Sector client.
• Self - initiative, excellent analytical and Communication skills and ability to work independently and as good team player.

TECHNICAL SKILLS:

BI Tools: MicroStrategy 10.x/9.x/8.x/ 8.1/8.0.2/7. x (MicroStrategy Administrator, MicroStrategy Desktop, MicroStrategy Intelligence Server, MicroStrategy Web, MicroStrategy Narrowcast Server, MicroStrategy OLAP Services, MicroStrategy Architect, MicroStrategy Distribution Services, MicroStrategy Office, MicroStrategy Command Manager), Business Objects.

Databases: Oracle 11g/10g/9i/8i, DB2 9.5/9.1/8, SQL Server 2008 R 2/2008/2005/2000 , Netezza TwinFin 5.0.8, Teradata 12/ V2R 6.1.1/6.0.2/6.0 , MS Access, MySQL

Languages: C, C++, Java, SQL, PL/SQL, T-SQL, UNIX Shell Scripting

Web Technologies: HTML, XML, PHP, JavaScript, Ajax.

Operating Systems: Windows 7/Vista/XP/NT/2000, MS-DOS, UNIX, Linux, Macintosh.

Data Modeling: ER Studio 8.5, Toad Data Modeler, ERwin.

ETL Tools: SSIS 2012/2008/2005 , Informatica 8.6/7.1, Ab Initio.

Packages: MS Office Suite (2010/2007/2003 ), Adobe Dreamweaver (CS4/CS3), ALM 11.52.444

PROFESSIONAL EXPERIENCE:

Confidential , Westlake Villege, CA

Sr.MicroStrategy Architect / Developer

Responsibilities:

• Working on PRD(Project Requirement Document) Ticket.
• Extensive experience on configuration of Intelligence Server, Web Server and Mobile Server.
• Good Hands on experience on creating report based on Intelligent Cubes.
• Experience on installation of MicroStrategy 10.4, SDK using Web Customization Editor.
• Good experience on customization on plugins using SDK.
• Created iPhone/iPad/Android Mobile configuration and customize MicroStrategy mobile app by generating URL.
• Created prompt using Custom Groups, Attributes and Metrics.
• Created Filter, Canned report, Prompted report, Document and Dashboards.
• Created Enterprise manager project report like PIN Usage Report, User Analysis, PIN Explorer Subscription Report etc.
• Migrating Objects from DEV to QA and QA to PROD using Object manager.
• Creating User and provide privileges to user based on assigned group.
• Giving timely solution to Explorer and Navigator user based on issues come.
• Created dashboard using selector, panel, panel stack, widget, graph and grid with multiple dataset.
• Participate daily and weekly meeting.

Environment: MicroStrategyDesktop 10.x,MicroStrategyWeb10.x,MicroStrategy Mobile 10.x, Informatica Power center, Oracle 12, Target Process, Share point, SQL Server 2016.

Confidential, Baltimore 

Sr. BI Architect / Developer - MicroStrategy, Tableau

Responsibilities:

• Working with business analyst to understand requirement and create mock up reports for client.
• Create attributes, filters, metrics, prompts and documents and dashboard
• Using MicroStrategy Architect define the hierarchy and attributes relationship.
• Defined advanced prompt expressions to create Hierarchy prompt, prompt-in-prompt and nested prompts.
• Coordinated with ETL and DBA teams for data availability and data model related issues and problems and provided solutions that support MicroStrategy application.
• Extensively worked and developed Metrics, filters and prompts to enable decision-makers to view reports in different perspectives.
• Created mock up dashboard in Tableau using excel dataset.
• Define security role using system prompt for each group of user and report user getting access as per role based.
• Monthly Micro Strategy report release using Agile Methodologies and Tracking all work hours for related report in Target Process.
• Participate to daily scrum session and provide status update to team.
• Weekly migration form DEV to VAL environment.
• Create Promotion folder each time to use for migration and doing migration using Object Manager.
• Verifying report data and trying resolve data issue with Database and ETL Team.
• Track and Resolved defect using Application Life Cycle Management (ALM).
• Create Promotion request file and add all listed object need to be promoted from one environment to other environment and send request for the approval and maintain all files on GIT shared folder.
• Review System Design Document (SDD) and Database Design Document (DDD) for MicroStrategy Report.

Environment: MicroStrategyDesktop 10.x,MicroStrategyWeb10.x,Informatica Power center, HP ALM (Quality Center)), Oracle 12, Target Process, Share point, Tortoise GIT, Windows 7.0 Professional.

Confidential, Washington DC

Sr. BI Consultant - MicroStrategy, Business Object

Responsibilities:

• Understand the Business requirement and meeting with different team to finalize the report requirement
• Create attributes, filters, metrics, prompts and documents.
• Create Simple, Drilldown and Prompted report.
• Create various project source for different environment like validation, integration and production
• Worked on different kind of Pass thru function like Apply Simple and Apply Compression and using them in to Metric and Attributes.
• Good Understanding for report which needs convert business object to Micro Strategy.
• Understand Stored procedure based Business Object report and convert into MicroStrategy Report.
• Having good experience to migrate project in one server to another server.
• Good Knowledge of VLDB properties and also troubleshoot performance of the report
• Using Micro Strategy Admin Creating new users, roles, access control, privileges.
• Expertise into analyze and troubleshoot complex SQL queries.
• Created report and intelligent cubes using multisource option
• Having pleasant experience in developing a dynamic dashboard in flash mode using different controls and extensively worked on widget and scorecard.
• Followed Agile Methodology and attained daily scrum session and giving status to scrum master.
• Followed DevOps Procedure in Software Development life cycle.
• Created different Schema & Public Objects as per requirement.
• Working with Database team to create a view for report.
• Create Pseudo code before developing a report to understand how the report look like.
• Create SQL Query and match with the report data for unit testing.
• Good Knowledge about snow flake and star flake schema.
• Create aggregate tables, partition mapping to improve performance of the reports.
• Having good Knowledge to connect MicroStrategy to BIGDATA Yarn component using HDFS.

Environment: MicroStrategyDesktop 9.x,MicroStrategyWeb9.x,MicroStrategy Intelligence Server 9.x, Object Manager, MicroStrategy Architect, Informatica Power center, HP ALM (Quality Center)), Microsoft SQL Server, Business Object, Windows 7.0 Professional, BIGDATA, Apache Hive.

Confidential, Baltimore

Sr. MicroStrategy Developer / Architect

Responsibilities:

• Understand the business requirements, update design documents, Involved in weekly meetings. Worked cohesively with business and technical teams to fulfill their requirements.
• Create Canned, Drilldown and Prompted report using Logical Views and summary table.
• Create Time and Region Hierarchy for report.
• Developed Dashboard with using Line and Bar Graph with Different selection option.
• Created filters, metrics, attributes, prompts, custom groups, documents and prompts.
• Created Transformation for Metric Comparison.
• Good experience in handling data like slow changing dimension scenario.
• Developed reports involving compound metrics containing prompted filters, relationship filters.
• Extensive knowledge about how to resolve Performance of Report.
• Created and Updated design document which contains all the detailed information of internal and external reports in summary and detailed level.
• Well-coordinated with the ETL team and data modeling team to build reporting database according to our requirements.
• Validate reports with creating SQL query and match with report result.
• Extensive Knowledge about whole project application process.
• Good Experience in whole process of Application Lifecycle Management tool to Validate report.
• Extensive knowledge about Core Database (DB2) and report Database (Oracle).
• Participate in application new functionality implementation Brown Bag Session.
• Designed Documents, Templates, created Filters and generatedMicroStrategyReports in grid and graph mode.
• Used analytical and governing settings in VLDB properties to tune the SQL and for calculating the metrics in dealing with the nulls and zeroes.
• Tested report layouts, validated the SQL query, prompt ordering, prompt defaults, security filters, export/print functionality and drilling options
• Test & validated the reports and dashboards from Dev to QA. Supported & fixed issues for Unit testing, Incremental testing and System testing.
• Production supports including troubleshooting reports, views used in the reports and coordination with the ETL team for quick resolution of issues.

Environment: MicroStrategy9,MicroStrategyDesktop 9.x,MicroStrategyWeb9.x,MicroStrategy Intelligence Server 9.x, HP ALM 11.52.x, Oracle11, Req Pro Client, Windows 7.0 Professional, Object Manager, MicroStrategy Architect.

Confidential, TX 

Sr. BI Developer - MicroStrategy

Responsibilities:

• Involved in meetings with Business Users to discuss and finalize the requirements for reports and provided best practices wherever required.
• Followed Full Software Development Life Cycle Process (SDLC) of Initiation, Planning, Analysis, Design, Construction, System Testing and Implementation.
• Developed data model exclusively for this project.
• Assisted DBA’s in populating various tables by proving the SQL codes.
• Coordinated with ETL and MicroStrategy SDK developers.
• Developed Schema Objects like Facts, Attributes, and Hierarchies and assigned relationships between attributes.
• Developed Public objects like Consolidations, Custom Groups, Metrics, Prompts, and Filters according to the report requirements.
• Used Pass-through functions like ApplySimple in attributes and metrics to get desired results.
• Coordinated with MicroStrategy administrator for migration of objects from Dev to QA, QA to PROD.
• Modified VLDB Settings to improve the performance of the reports.
• Tested all the reports running queries against SQL Server using SQL Server Management Studio.
• Developed complex dashboard for Ipad and Web.

Environment: MicroStrategy 9.2.1 (Desktop, Architect, Web, Object Manager, Command Manager, Integrity Manager, Enterprise Manager), Microsoft SQL Server Enterprise 2008 R2, Microsoft SQL Server Management Studio 10.

Confidential, Hoffman Estates, IL

Sr. MicroStrategy Developer

Responsibilities:

• Worked with Business Users to discuss and finalize the requirements for reports and provided best practices whenever required.
• Followed Full Software Development Life Cycle Process (SDLC) of Initiation, Planning, Analysis, Design, Construction, System Testing and Implementation.
• Documented the Technical Design’s for the reports according to the requirements.
• Documented all the testing results following the Test Case Documents.
• Developed Schema Objects like Facts, Attributes and Transformations, and assigned relationships between the attributes.
• Created Various Hierarchies which allows drilling on the reports.
• Developed Public objects like Consolidations, Custom Groups, Metrics, Prompts, and Filters according to the report requirements.
• Created logical tables in MicroStrategy Desktop to create various reports which were not supported by current database structure.
• Created several Base Formulas using facts that can be reused to build any number of metrics.
• Tested reports by running queries against the Netezza database using Aginity Netezza Workbench.
• Developed Prompted Filters that gave user a choice of different filtering criteria each time they run the reports.
• Coordinated with DBA and ETL developers for table creation, loading data and other database related issues.
• Developed various Dashboards and Scorecards for Iphone and Android devices.
• Coordinated with MicroStrategy administrator for migration of objects from Dev to QA and QA to Prod.
• Modified VLDB Settings to improve the performance of the reports.
• Provided production support and fixed bugs in existing reports.

Environment: MicroStrategy 9.1/9/0.2 (Desktop, Architect, Web, Object Manager, Command Manager, Integrity Manager, Enterprise Manager), Netezza TwinFin 5.0.8, Aginity Netezza Workbench 1.5.

Confidential, CA 

MicroStrategy Architect

Responsibilities:

• Gathered requirements from Business users, Stake holders for the project.
• Followed Full Software Development Life Cycle Process (SDLC) of Initiation, Planning, Analysis, Design, Construction, System Testing and Implementation.
• Extensively used Command Manager to create schema objects in bulk.
• Proposed naming standards for Attributes, Metrics and Filters to make easy for Business users.
• Prepared documentations related to the MicroStrategy project implementation.
• Created Various Hierarchies which allows users to drill on reports.
• Developed Public objects like Metrics, Custom Groups, Consolidations, Prompts, Templates and Filters.
• Tested all reports by running queries against the Netezza database using DbVisualizer.
• Coordinated with Database Architect and ETL developers for data availability and data model related issues by providing solutions that support MicroStrategy application.
• Documented the MicroStrategy Data Dictionary.
• Developed various Ad-Hoc reports and canned reports for the users.
• Used auto prompts filter feature to give the end-user a choice of different filtering criteria each time they run the report.
• Used Enterprise Manager to check the performance of the reports and usage of objects.
• Created static and dynamic dashboards using various widgets according to the requirement.

Environment: MicroStrategy 9.0 (Desktop, Architect, Web, Object Manager, Command Manager, Integrity Manager, Enterprise Manager), Netezza, TwinFin 5.0.8, ER Studio 8.5, DbVisualizer 7.0.7, HP Quality Center 10.0, MS Access (2007).

Confidential , King of Prussia, PA

MicroStrategy Developer 

Responsibilities:

• Involved in meetings with business users to discuss and finalize the requirements and design of the reports.
• Developed different reports according to the requirements.
• Developed Schema Objects like Facts, Attributes, and Hierarchies and assigned relationships like one-to-one, one-to-many and many-to-many between different attributes.
• Extensively used Command Manager to create schema objects in bulk.
• Interacted with DBA and Data Modeler to build Dimensional Data Modeling (Star Schema, Snow-Flake Schema).
• Worked extensively on developing Metrics and Compound Metrics, Filters, Custom Groups, Templates, Consolidations and OLAP Reports using MicroStrategy 9.0.
• Performed routine administrator tasks during absence of MicroStrategy administrator.
• Created Users, Roles & Privileges using the MicroStrategy Desktop (Administrator).
• Extensively worked with Object Manager to migrate the MicroStrategy Objects from development to QA and then to production environment.
• Used several new controls for Dash boards like time series slider, radio buttons, and drop down menus for the flash version of the dashboards in 9.0
• Created Ad-hoc Reports by drilling up, down, with across hierarchies.
• Involved in upgrading MicroStrategy 8.1.2 to MicroStrategy 9.0.
• Developed Auto Prompt Filters that gave user a choice of different filtering criteria each time they run the reports.
• Responsible for various administration tasks like Tuning, Caching, specifying Query Governing, Thresholds and Report Optimization.
• Extensively used Integrity Manager to test reports when upgraded from MicroStrategy 8.1.2 to MicroStrategy 9.0.
• Used MicroStrategy Narrowcast server to deliver reports directly to business users by various delivery methods.
• Generated Freeform SQL reports writing SQL queries against different databases.
• Provided Business user training for the MicroStrategy Desktop/Web.
• Created the Metadata & Statistic tables for the MicroStrategy projects on an Oracle database.
• Involved in troubleshooting of reports and eliminating cross joins in the SQL to produce correct results.

Environment: MicroStrategy 9.0/8.1.2, Teradata 12.0, Oracle 11g, Query Man, UNIX, Windows XP

Confidential , Wisconsin

MicroStrategy Developer 

Responsibilities:

• Worked with business users to verify data requirements and provided best practice consulting when needed.
• Tuned MicroStrategy implementation for greater performance based on recommendations from internal testing.
• Reduced intelligence server pressure by increasing number of Database connection threads in optimal way.
• Worked with MicroStrategy architects to build a dimension data model.
• Assisted in Project setup (Installing, Configuring, Managing and controlling) and Project Lifecycle management.
• Developed Dashboard for Ipad and Mobile devices.
• Developed a 3-tier client/server product in the corporation for use by the merchandising department to access a relational DB2 database using MicroStrategy tool suite.
• Extensively used Command Manager to create schema objects in bulk.
• Periodic maintenance of Intelligence server and Narrowcast server installation in all environments to determine the current state of server parameters, performance, as well as identify potential issues and limitations.
• Created Transformations like YTD (year to date), MTD (month to date), and WTD (week to date) analysis.
• Configured, Managed clustering of Multiple Intelligence server nodes and web server nodes to implement automatic failover, load balancing and boost the performance and scalability.
• Responsible for Installation and Configuration of Intelligence server, Web Server and Enterprise Manager.
• Involved in managing objects between different environments by using object manager.
• Created various Narrowcast Services to deliver reports to users by various delivery methods.
• Implemented Narrowcast tasks like service designs, subscription, scheduling and administration.
• Provide optimum performance and scalability through Multi-pass SQL and VLDB settings.
• Used MicroStrategy Enterprise Manager to see the usage of reports and their performance.

Environment: MicroStrategy 8.1.2(MicroStrategy Desktop, MicroStrategy Intelligence Server, MicroStrategy Web, MicroStrategy Administrator, MicroStrategy OLAP Services, MicroStrategy Project Manager, MicroStrategy Narrowcast Server), DB2 9.5, Windows 2003 Server, Windows XP, Teradata 12.0.

Confidential 

SQL Developer

Responsibilities:

• Performed System Analysis, Dataflow Diagram, Entity Relationship Diagram (ERD) and Created tables.
• Prepared prototype screens and reports and set standards.
• Involved in the Design and Development of the product.
• Developed various user interfaces and report presentation mainly for on-line analysis using Oracle
• Forms 4.0, Reports 2.0 and interfaces between them.
• Performed Database testing & maintaining the data by using the procedures.
• Designed and validated the Forms according to client requirement by using VB.
• Performing Data Transfer/Migration using Export/Import.
• Involved in developing cross-reference and report generation programs.

Environment: MS-SQL Server 2000, Developer 2000(Forms 4.0, Reports 2.0), SQL, PL/SQL, UNIX, Windows