Summary:

• 8 years of Professional experience in Design, Development and Implementation of Data Warehousing applications, with proficiency in Making Reports, Scorecards, Dashboards using MicroStrategy 9.4.1/9.3.1/9.2.1//8i.
• Certified MicroStrategy Developer in 9.2.1 CPD, CRD, CDD
• Experience with all the modules of MicroStrategy Product Suite.
• Experience in working with Oracle RDBMS database.
• Build MicroStrategy architect by using RDBMS database as project source.
• Experience working with the Business Analysts and Business users in gathering and documenting user requirements.
• Experience in managing the team, working in agile environment.

Technical Skills:

Work Experience:

Sr. Solution Architect, Sr. MicroStrategy Consultant

Confidential

• Gather and translate business requirements into technical specifications
• Design and code from specifications, analyzes, evaluates, tests, debugs, documents, implements complex apps.
• Perform project management of estimating, scheduling, and monitoring tasks and life cycle BI Development.
• Interface with different departments within the organization regarding new deployments
• Research/analyze data processing functions, methods and procedures
• Monitor program execution for expected performance
• Design and build pixel perfect report service documents and interactive Flash dashboards.
• Created Dashboards using various widgets like Micro charts, Time Series Slider, Heat map and Gauge.
• Used intelligent cube reports in dashboard as datasets to achieve performance.
• Involved in moving the objects between two projects and two different environments by using Object Manager.
• Provided post implementation production support.
• Extensively involved with data modeling.

Solution Architect Sr. MicroStrategy Consultant

Confidential

• Leading a team of six people in offshore onshore model.
• Facilitate daily one to one discussion with client and Business user. Give demo to business user and constantly sync up with customer.
• Working on Sybase IQ and Oracle database management.
• Responsible for data analysis and Data modeling for projects.
• Involved in design/development life cycle including gathering requirements, user interaction and report design and development
• Developed Metrics, Filters, Prompts to achieve the functionality of the canned reports and created advanced objects like Derived Metrics, Compound Metrics.
• Developed MicroStrategy Dynamic Dashboards using several controls and worked extensively on widgets.
• Created report services documents for HR and Finance Data.
• Developed a web course and took several classes to train the end users to efficiently use MSTR.
• Involved in tuning of longer running queries by setting appropriate VLDB properties and by applying various design techniques to minimize the number of SQL passes generated by MicroStrategy.
• Customized and optimized reports for various users using MicroStrategy features like VLDB properties at Project level and report level.
• Worked with end users along with Business Analysts to build reports and dynamic dashboards.
• Worked on administrative tasks like User Groups, Roles, Privileges, Cache Management.
• Involved extensively in the overall lifecycle of the Data Warehouse integration project

Technical Leader, Sr. MicroStrategy Consultant

Confidential

• Performed Design Code reviews Unit testing and data validation of MicroStrategy reports.
• Involved in managing Migration of MicroStrategy projects and objects from Dev to Testing and to Prod.
• Troubleshoot and tune MicroStrategy reports by analyzing the MicroStrategy generated SQL to determine data issues such as double counting, hitting incorrect fact tables, incorrect joins and insufficient data.
• Extensively involved in troubleshooting support and resolving all outstanding issues.
• Excellent experience configuring VLDB properties to fine-tune reports.
• Experienced in working with Maps using Visual Crossing Map widget.
• Implemented SAVE and Export Links for dashboards.
• Experienced in doing the quick POC's to satisfy business requests.
• 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.
• 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.
• Created logical views in MicroStrategy for complex report creations situations.
• Worked extensively with the End Users to finalize the dashboard layouts and also worked on fine detail formatting for a desired look and feel.
• Used different types of selectors/controls for dashboards like time series slider, radio buttons and dropdown menus for the Flash version of the dashboards.
• Designed and Developed Reports and Dynamic Dashboards with challenging requirements.
• Created Schema Objects and Application Objects using MicroStrategy Desktop and Architect.
• Took part in full data warehousing application lifecycle starting from creating logical and physical data model, to implement and test ETL processes in Teradata environment.
• Performed Customer Requirements Gathering, Analysis, Design, Development, Testing, End User Acceptance Presentations, Implementation and Post Production support of Precision Market Insights Project.
• Worked as a MicroStrategy developer/ analyst in a team of six for design and development in the product development.
• Experience in Dashboard integration with ACI Portal Java based web application .
• Extensively worked on various Pass-Through functions like ApplySimple, Apply Comparison.
• Worked on Admin tools including Command Manager, Object Manager, and Enterprise Manager and Integrity manager.

Assistant Data Manager,

Confidential

• Worked as HIV/AIDS Surveillance Assistant Data Manager
• Worked with software including MicroStrategy 9.2, SAS, MS-ACCESS, the evaluation HIV/AIDS Reporting System eHARS database.
• Working in SAS 9.2 reporting tool for generating different reports for various departments.
• Received advanced training in the statistical analysis software package SAS .
• Responsible for transmitting statewide data to the U.S. Centers for Disease Control and Prevention CDC on a monthly basis and processing the acknowledgement file from CDC monthly.
• Providing data management and computer programming support for the Surveillance Program staff.
• Generated different reports using SAS Reporting tool on weekly and monthly basis.
• Writing SAS Program with using SQL as per requirement.
• Developed MicroStrategy Schema objects, Application objects.
• Worked on the performance tuning of the MicroStrategy reports.

Project Engineer,

Confidential

• System Analysis, Data Analysis and Computer Aided Design.
• Proficiently worked on JDE ERP for handling logistic work, purchase and finance.
• Actively involved in preparing periodic reports for management decision using DSS.
• Developed a computer based module which handled Purchase, Planning, and Logistics Supply Chain process.
• Have experience in doing excellent documentation on business requirements.
• Experience in business functionality implementations, developing Data Models, Data Warehouses, and Data Marts from logical models as per specific business requirements.
• Extensively used MicroStrategy Report Services to generate Report Documents.
• Strong knowledge and understanding of SQL and ability to write SQL queries.

Assistant Manager,

Confidential

• Worked on SAP for data keeping and planning of different business process.
• Associated in Project of ABS.
• Work as an Assistant Manager in NPI New Product Introduction planning.
• Responsible for logical and physical design of SQL Server databases.