SUMMARY:

• 9+ years of Professional experience in Design, Development and Implementation of Data Warehousing applications, with proficiency in Making Reports, Scorecards, Dashboards using MicroStrategy 10.5/9.5/9.4/9.3.1/9.2.1/8 i.
• Experience with all the modules of MicroStrategy Product Suite.
• 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.5/9.5/9.4/9.3/9.2.1/8 i (Desktop, Architect, Web, Intelligence Server, Narrowcast Server, Object 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

Business Analyst Documents: Business Requirement Document (BRD), Functional Requirement Document (FRD), Use Case

WORK EXPERIENCE:

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, OLAP reports.
• 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.

Environment: - MicroStartegy 10.5, Teradata 10.0, MySQL

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.

Environment: - MicroStartegy 9.5, Teradata 10.0

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

Environment: - MicroStartegy 9.5, Oracle, Sybase

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.

Environment: - MicroStartegy 9.2, Teradata

Graduate Public Service

Confidential, Springfield, IL

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

Environment: - MicroStartegy 9.2, Oracle

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.