SUMMARY:

• With over 8 years (Developer/Architect and 2 years as lead) of IT experience involved in various stages of the System Development Lifecycle (SDLC) from requirements gathering analysis, modeling, case diagrams, documentation, implementation including maintenance and support in different domains like Health care, Supply Chain Management, Logistics, Shipment Visibility, Warehouse Management and Banking.
• Experience in using Microstrategy 9 and 8 (Desktop, Web, Intelligence Server, Architect, Narrowcast Server and Mobile applications). Focusing on Microstrategy, Data warehouse and Business Intelligence application tools.
• Experience working with the full life cycle development process, which includes analysis, design, development and testing.
• Experience working in Project conversions from Cognos to Microstrategy and Microstrategy to BOBJ.
• Experience in working BOBJ project as System Analyst.
• Strong Proficiency in Microstrategy connectivity with Teradata, SQL Server, Oracle, Netezza and DB2.
• Extensive Microstrategy development hands on experience with Desktop, Architect, Intelligence Server, Report Services and Enterprise Reporting.
• Experience in Schema design and creating Schema objects using Star and Snowflake and for Type 2 dimensions (Hierarchies, Attributes and Facts, Transformations).
• Experince in developing intelligence cube based dashboards.
• Experience in developing Mobile dashboards with Multiple Layouts.
• Knowledge on Preparing scripts to ensure proper data access, manipulation and reporting functions with R.
• Excellent experience in Microstrategy Report development, Report testing, Report tuning, Ad - hoc, scheduling report delivery and Alerts.
• Extensive experience on all types of Microstrategy Filters, Prompts, Templates, Metrics, Consolidation and Custom Groups.
• Experience in using Project Merge, Object Manager, and Enterprise Manager.
• Experience in providing access to users and configuring ACL and experience in creating Security filters
• Exposure to ETL methodology for supporting Data Extraction, Transformations and Loading processing in a corporate -- wide-ETL solution using Informatica and Abnitio.
• Excellent experience configuring VLDB properties to fine-tune reports.
• Exceptional ability to quickly master new concepts and capable of working in group as well as independently with excellent communication skills.
• Experience working in a structured, multi-person development environment.
• Having theoretical knowledge on Microstrategy SDK.
• Experience non-technical users and providing customer support.
• Involved in Regression testing of reports and dashboards while upgrade happens from older to advanced versions.
• Associated with Implementation, Support & Enhancement projects.
• Worked Extensively on Distribution Services and Event caching (Triggers with EDW Cycle) the reports and dashboards.
• Developed Reports using Freeform SQL Queries and Logical Views in Microstrategy Desktop.
• Created different analysis reports, ad-hoc reports, Wizards and Intelligence cubes using MicroStrategy Desktop and Web.
• Involved in Unit Testing and User Acceptance Testing.
• Strong SQL Skills related to information retrieval and analysis.
• Excellent working attitude with strong analytical, communication skills and the ability to work independently as well as in a team environment.
• Created Enterprise Access Management Titles for Project access.
• Design of Report Requirement Templates (RRT), Report Logical Models (RLM) for the Reports.
• Adept at grasping new technical concepts quickly & utilizing the same in productive manner.

TECHNICAL SKILLS:

Business Intelligence: Microstrategy 9.4/9.3/ 8, SAP BOBJ, Qlickview, Tableau, Informatica, Abnitio

Databases: Oracle8i/9i, MySQL, DB2, MS Access, Teradata, Netezza,Erwin, Visio

Operating System: WINDOWS 9x/2000/NT/XP, MS-DOS, UNIX

PROFESSIONAL EXPERIENCE:

Confidential, Dayton, Ohio

Microstrategy Developer/ Architect

Tools: Used: Microstrategy 9.4.1, Teradata

Responsibilities:

• Created Reporting platform in MicroStrategy from scratch for Clinical Quality Monitoring Project.
• Worked on requirements gathering from the clients and estimation of efforts including analysis of existing system and analysis of data.
• Designed and developed the environment to generate reports and Dashboards.
• Extensively worked on Logical Data Modeling.
• Created Microstrategy Schema objects and Application objects using Microstrategy Desktop and Architect.
• Design and develop Reports and Dashboards with challenging requirements.
• Created Hyperlinking reports and ad-hoc reports in Grid & Graph mode consisting of data analysis by combining a template with filters using MicroStrategy desktop and web.
• Used apply functions like apply simple to meet the report requirements wherever necessary.
• 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 dashboards.
• Used several widgets for Dashboard reporting.
• Developed Transactional Services and Mobile dashboards.
• Worked extensively with the compliance officer to finalize the dashboard layouts and also worked on fine detail formatting for a desired look and feel.
• Created logical views in Microstrategy for complex report creations situations.
• Created advanced grid reports, consisting of data analysis by combining a template with filters. The end-users were able to generate ad-hoc report by drilling up, down, within and across dimension or anywhere.
• Performing all the administration tasks like Monitoring and Analyzing the system usage and managing the projects. And using the Command Manager to purge the caches on database loads.
• Sync up with testers to track the status of issues logged.
• Resolved issues found during functional testing.
• Handling and documenting the releases happened in the Project.
• Testing reports thorough MicroStrategy web to verify that reports are migrated properly from development to testing and Production.
• Enabled the UAT team by designing user acceptance test cases accommodating all the real life scenarios and endued the testing team for validating and testing the application.
• Prepared User guide documents, Design Documents and Unit test case documents.

Confidential, California, Foster City

Microstrategy Developer/ Architect

Tools: Used: Microstrategy 9.3.1, DB2

Responsibilities:

• Handled lead role in the Project and coordinate Onsite and Offshore team.
• Worked on requirements gathering from the clients and estimation of efforts including analysis of existing system and analysis of data.
• Designed and developed the environment to generate reports and Dashboards.
• Extensively worked on Logical Data Modeling.
• Extensively worked on Installing and setting up of Microstrategy Intelligence server and Web servers.
• Involved in Clustering of servers.
• Worked with ETL team in providing the different transformations and data enrichments needed for reporting.
• Proactively created report formats and delivered personalized messages from the BI platform through MicroStrategy Narrowcast Server to a wide range of users.
• Created Microstrategy Schema objects and Application objects using Microstrategy Desktop and Architect.
• Design and develop Reports and Dashboards with challenging requirements.
• Created Hyperlinking reports and ad-hoc reports in Grid & Graph mode consisting of data analysis by combining a template with filters using MicroStrategy desktop and web.
• Used apply functions like apply simple to meet the report requirements wherever necessary.
• Used several new controls for dashboards like time series slider, radio buttons and dropdown menus for the Flash version of the dashboards.
• Worked extensively with the compliance officer to finalize the dashboard layouts and also worked on fine detail formatting for a desired look and feel.
• Created advanced grid reports, consisting of data analysis by combining a template with filters. The end-users were able to generate ad-hoc report by drilling up, down, within and across dimension or anywhere.
• Used free form SQL editor for complex report creation.
• Sync up with testers to track the status of issues logged.
• Resolved issues found during functional testing.
• Handling and Documenting the releases happened in the Project.
• Testing reports thorough MicroStrategy web to verify that reports are migrated properly from development to testing and Production.
• Enabled the UAT team by designing user acceptance test cases accommodating all the real life scenarios and endued the testing team for validating and testing the application.
• Involved in configuring the reports to VISA ON LINE web page by using Microstrategy SDK.
• Having experience on Understanding the JAVA code errors and find the root cause for the error, and fixing the issues.
• Prepared User guide documents.

Confidential, California, Folsom

Microstrategy Developer/ Architect

Tools: Used: Microstrategy 9.3.0, Teradata

Responsibilities:

• Handled lead role in the Project.
• Worked on requirements gathering from the clients and estimation of efforts including analysis of existing system and analysis of data.
• Designed and developed the environment to generate reports and Dashboards.
• Extensively worked on Logical Data Modeling.
• Extensively worked on Installing and setting up of Microstrategy Intelligence server and Web servers.
• Involved in Clustering of servers.
• Proactively created report formats and delivered personalized messages from the BI platform through MicroStrategy Narrowcast Server to a wide range of users.
• Created Microstrategy Schema objects and Application objects using Microstrategy Desktop and Architect.
• Design and develop Reports and Dashboards with challenging requirements.
• Created Hyperlinking reports and ad-hoc reports in Grid & Graph mode consisting of data analysis by combining a template with filters using MicroStrategy desktop and web.
• Used apply functions like apply simple to meet the report requirements wherever necessary.
• Extensively used report services to create dashboards to create summary level reports using multiple datasets.
• Extensively worked on Dashboards and have utilized the new features to convert the dashboards into Flash mode.
• Used several new controls for dashboards like time series slider, radio buttons and dropdown menus for the Flash version of the dashboards.
• Used several widgets for Dashboard reporting.
• Worked extensively with the compliance officer to finalize the dashboard layouts and also worked on fine detail formatting for a desired look and feel.
• Created logical views in Microstrategy for complex report creations situations.
• Created advanced grid reports, consisting of data analysis by combining a template with filters. The end-users were able to generate ad-hoc report by drilling up, down, within and across dimension or anywhere.
• Performing all the administration tasks like Monitoring and Analyzing the system usage and managing the projects. And using the Command Manager to purge the caches on database loads.
• Used free form SQL editor for complex report creation.
• Fixed Defects and performed upgrades for existing projects.
• Created Reports and Dashboards from Intelligence cubes
• Sync up with testers to track the status of issues logged.
• Resolved issues found during functional testing.
• Handling and documenting the releases happened in the Project.
• Testing reports thorough MicroStrategy web to verify that reports are migrated properly from development to testing and Production.
• Enabled the UAT team by designing user acceptance test cases accommodating all the real life scenarios and endued the testing team for validating and testing the application.
• Delivered sessions to KTBR team and Business Users.
• Prepared User guide documents.
• Created Enterprise Access Management Titles for Project access.

Confidential, California, Folsom

System Analyst for Business Object project

Tools: Used: BOBJ, Teradata

Responsibilities:

• Prepared RRT’s for BOBJ reports by comparing Microstrategy existing Project.
• Access the Data model tool to understand the business meaning of tables and columns.
• Provide the design for Universe creation, involves tables, columns, mapping and logic for Metrics.
• Functional testing of BOBJ reports.
• Handling and documenting the releases happened in the Project.

Confidential, California, Folsom

Microstrategy Developer/Architect

Tools: Used: Microstrategy 9.3.0, Teradata

Responsibilities:

• As a member of team handled all the Schema design and Report development.
• Created schema/architect objects like attribute, facts, Table aliases etc.,
• Create application objects like metric, prompt, filter, and custom group.
• Create reports as per the user requirement.
• Create reports and dashboards on Intelligence cubes.
• Extensively worked on Dynamic Dashboards.
• Unit testing of created reports.
• Sync up with testers to track the status of issues logged.
• Resolved issues found during functional testing.
• Handling and Documenting release.
• Testing reports thorough MicroStrategy web to verify that reports are migrated properly from development to testing and Production.
• Enabled the UAT team by designing user acceptance test cases accommodating all the real life scenarios and endued the testing team for validating and testing the application

Confidential, California, Folsom

Microstrategy Analyst / Developer /Architect

Tools: Used: Microstrategy 9.3.0, Teradata & SQL Server

Responsibilities:

• Identifying the changes in upstream applications and modifying in MSTR Downstream Projects as per the changes in Teradata and SQL server databases.
• Identify the Schema object (Tables, Attribute, Facts) mapping changes as per the Database changes and implement the changes in MSTR projects.
• Testing all MSTR projects as per changes implemented in Schema and Backend.
• Enabled the UAT team by designing user acceptance test cases accommodating all the real life scenarios and endued the testing team for validating and testing the application.
• Sync up with EDW, ETL and Reporting testers to track the status of issues logged.
• Identifying the Reports and Projects statists by using Enterprise Manager. Depending on reports usage, removed the not frequently used reports from the Projects.

Confidential

Microstrategy Developer/Architect

Tools: Used: Micro Strategy 9.0.2, Oracle 10G

Responsibilities:

• Creating Schema Objects (facts, attributes, Hierarchies, Transformations) to Develop User Objects.
• Developing Public Objects (filters, prompts, metrics, Custom Groups, Consolidations, and Searches) to develop Documents and reports.
• Expertise in using Pass-Through Expressions like Apply Simple and Apply Comparison to develop complex Filters and Transformations.
• Creating Document from multiple Datasets like Map Application Diagram, Grid and graph.
• Developing Reports by using Free Hand SQL Queries in Microstrategy Desktop.
• Involved in report performance tuning.

Confidential

Microstrategy Developer/Architect

Tools: Used: Micro Strategy 8.1.1, Oracle 10G

Responsibilities:

• Creation of the Public Objects like Metrics, Custom Groups, Consolidations and Reports.
• Creating Schema Objects (facts, attributes, Hierarchies, Transformations) to Develop User Objects.
• Duplicating the projects and configuring with new database instance.
• Design, develop and implement reporting and analysis environment, including template driven and parameterized reports.
• Testing of the microstrategy Report Services Document objects.
• Interact with clients to gather and analyze business requirements
• Creating Document from multiple Datasets like Map Application Diagram, Grid and graph.

Confidential

Microstrategy Developer

Tools: Used: Micro Strategy 8.0.1, Oracle 9i

Responsibilities:

• Creation of the Public Objects like Metrics, Custom Groups, Consolidations and Reports.
• Creating Schema Objects (facts, attributes, Hierarchies, Transformations) to Develop User Objects.
• Duplicating the projects and configuring with new database instance.
• Design, develop and implement reporting and analysis environment, including template driven and parameterized reports.
• Testing of the microstrategy Report Services Document objects.
• Interact with clients to gather and analyze business requirements
• Creating Document from multiple Datasets like Map Application Diagram, Grid and graph.