SUMMARY:

• 10+ years of Professional experience in Design, Development and Implementation of Data Warehousing applications, with proficiency in Making Reports, Scorecards, Dashboards using MicroStrategy 10.4/9.5/9.4/9.3.1/9.2.1/8 i.
• Experience with all the modules of MicroStrategy Product Suite, including OLAP Services Environment.
• Experience working with OLAP cube, Cube partition, prompt based report on Cube, transaction services Report
• Experienced in creating Ad - Hoc report by using Visual Insight.
• Experience in Dashboard integration with ACI Portal (Java based web application).
• Participated in the Full life Cycle Development (FLCD) of the data warehousing project; project planning, business requirement analysis, data analysis, logical and physical database design, setting up the warehouse physical schema and architecture, developing reports, security and deploying to end users.
• Optimizing report generation with respect to Very Large Databases (VLDB) to make absolute use of database flexibility, caching, security and scalability issues suited for Oracle, Teradata, DB2 and SQL Server.
• Experience with other BI tools like Tableau.
• Experience in working with Oracle RDBMS database.
• Experience working with Star and Snow-flake schema.
• Build MicroStrategy architect by using RDBMS database as project source.
• Experience working with the Business Analytics and Business Users in gathering and documenting user requirements.
• Experience in managing the team, working in agile environment.

TECHNICAL SKILLS:

Business Intelligence: MicroStrategy 10.4/9.5/9.4/9.3/9.2.1/8 i (Desktop, Architect, Web, Intelligence Server, Narrowcast Server, Enterprise Manager, Object Manager, Command Manager). Tableau 9/10, Statistical analysis software package (SAS), OBIEE10g/11g

Databases: SQL Server 2000/05/08, DB2, Teradata 10, Oracle 11g/10g/9i/8i, MS-Access, Sybase IQ, MySQL

Languages: C, C++, Java, CSS, ASP.Net, MS-SQL, PL/SQL, Oracle SQL*Plus

Web Technologies: HTML, XML, DHTML, ASP.Net

Data Modeling Tools: Microsoft Visio2007/10, Erwin 4.0/3.5.2, Designer 2000, UML

Operating Systems: Windows NT / XP / 2000/98, UNIX

ETL Tools: Informatica 7.1.2/7.1, DataStage

WORK EXPERIENCE:

MicroStrategy Architect

Confidential, Saint Louis, MO

• Involved in the documentation of technical specifications of the Broker insurance payment and insurance claim Project.
• Worked with Data Import using MicroStrategy Web from Databases, URL API.
• Created different Project Sources for different environments like production, testing and development.
• Created different schema objects like Attributes, facts by using MicroStrategy BI Suite.
• Generated reports using Advanced Metric objects, Filters, Prompts and also created Customized Templates to facilitate the End users to create customized reports by choosing Filters, Metrics and Report Attributes.
• Involved in creating MicroStrategy objects like Metrics (Conditional, Transformational, Dimensional, and Compound), Filters, Prompts (Filter, Object), Templates and Reports
• Generated different kinds of Pass-Through Functions and used for time filters like current month and previous year etc.
• Created Ad-hoc reports by gathering specific requirements from the different users.
• Involved in the troubleshooting and Performance Tuning of the reports using VLDB properties.
• Created Data mart Reports, Partition Mappings and Aggregate tables to improve performance of reports.
• Interacted with users from different functional teams across the organization in gathering requirements for developing departmental dashboards and Key Performance Index corporate dashboards
• Involved extensively in the overall life cycle of the Data Warehouse integration project.

MicroStrategy Architect

Confidential, Hoffman Estates, IL

• Initiated BI projects for business reporting
• Simultaneously working on multiple projects, define scope, develop and implement
• Provides reporting solutions, visualization for reports and dashboards for Supply Chain team
• Provides end to end solution of supply chain process by defining metrics and KPIs.
• Handle a team of 4 people to delivery projects on MicroStrategy Platform.
• 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
• Involved extensively in the overall lifecycle of the Data Warehouse integration project
• Experienced in doing the quick POC's to satisfy business requests using Tableau.
• Involved in design/development life cycle including gathering requirements, user interaction and report design.
• Create MicroStrategy Schema object based star schema, snow flake schema and hybrid schema.
• Developed Metrics, Filters, Prompts to achieve the functionality of the canned reports and created advanced objects like Derived Metrics, Compound Metrics, and OLAP reports.
• Working with OLAP cube, Cube partition, and prompt based report on Cube.
• Using derived metric to do calculation on Analytical Engine and enhance performance of dataset.
• Developed MicroStrategy Dynamic Dashboards using several controls and worked extensively on widgets.
• 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.

Technical Specialist

Confidential, Nashville, TN

• 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.

Technical Leader

Confidential, Warren, NJ

• 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

Programmer Analyst

Confidential, Warren, NJ

• Worked as a MicroStrategy developer/ analyst in a team of six for design and development in the product development.
• Performed Customer Requirements Gathering, Analysis, Design, Development, Testing, End User Acceptance Presentations, Implementation and Post Production support of Precision Market Insights Project.
• 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.
• Created Schema Objects and Application Objects using MicroStrategy Desktop and Architect.
• Designed and Developed Reports and Dynamic Dashboards with challenging requirements.
• Used different types of selectors/controls for dashboards like time series slider, radio buttons and dropdown menus for the Flash version of the dashboards.
• 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.
• Experienced in doing the quick POC's to satisfy business requests.
• Implemented SAVE and Export Links for dashboards.
• Experienced in working with Maps using Visual Crossing Map widget.
• Excellent experience configuring VLDB properties to fine-tune reports.
• Extensively involved in troubleshooting support and resolving all outstanding issues.
• 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.
• Involved in managing Migration of MicroStrategy projects and objects from Dev to Testing and to Production.
• Performed Design & Code reviews Unit testing and data validation of MicroStrategy reports.
• 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.

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

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