YASHWANTH
[email protected] 512-275-6741
MicroStrategy Consultant Note: Available Immediately *** ONLY FOR A CONTRACT POSITION *** ========================================================================= SUMMARY • Over 8 years of total IT experience in software development, deg and implementing Web based and Stand alone software application with major focus on Data Warehousing and Database Applications. • Over 6 years of experience with Business Intelligence tool Micro Strategy, in several business areas such as Health Care, Retail (Market Basket Analysis), Banking and Pharmaceuticals. • Extensive experience on MicroStrategy BI suite. Expertise in building projects and creating reports using MicroStrategy 7.X/8.X/9 product suites including MicroStrategy Narrowcast Server, MicroStrategy Desktop, MicroStrategy Web, MicroStrategy , MicroStrategy Intelligence Server and MicroStrategy Architect. • Extensive experience on Enterprise Reporting, Cube Analysis (MOLAP), Ad hoc query (ROLAP) & analysis, Statistical Analysis & Mining and Report Delivery & Alerting. • Extensively worked in creating and integrating Microstrategy reports and objects (Attributes, Filters, Metrics, Facts, Prompts, Templates, Consolidation and Custom Groups) with the data warehouse. • Very strong in developing Proactive Delivery Reports and implementing business intelligence solutions on the web using MicroStrategy Narrowcast Server. • Expert in Creating MicroStrategy Reports and implementing MicroStrategy projects. • Extensive work experience with Ad hoc reporting and standard reporting environment. • Experience in business functionality implementations, developing Data Models, Data Warehouses, and Data Marts from logical models as per specific business requirements. • Experience in deg ETL process for Data warehousing using ETL tools SQL Server Integration Services (SSIS) and DTS Packages. • Experience in Deg and Modeling the Data for Data Warehouse using the different Data Modeling Tools Erwin and Microsoft Visio. • Experience in various software development life cycle (SDLC) methodologies including RUP, Waterfall and Agile Methodologies. • Strong knowledge and understanding of SQL and ability to write SQL queries. • Proficient in Analysis, Design and Development of applications using ORACLE, SQL Server, Teradata, DB2 and MS Access as Backend and VB 5.0/6.0, Developer 2000 as a Front end. Good working Knowledge of MS Excel Macro development. • Extensive experience in developing multi-layered Windows and Internet/Intranet applications, full life cycle development with .NET technology (Win Forms, Web Forms, ASP.NET, ADO.NET, XML, Web services, window services, Remote.NET, IIS, Assemblies). • Develop the reports against Star Schema and Snow-Flake Schema. • Expertise in creating complex reports like Drill Down and Sub Reports and implementing Conditional Formatting, Interactive Sorting, Grouping and Filtering. • Expertise in handling the Datasets using complex queries and stored procedures for generating reports and deploying in various sources like Web browser, XML and PDF.
• • • •
Extensive knowledge of KPI/METRIC, Graphs, Data group, Explore the data, Visualize the data, Drill Through the data, Adhoc reports. Creating a superior web interface for the reports using Macromedia Dreamweaver, Fireworks, Microsoft Frontpage, JavaScript, XML and HTML. Have exposure to JAVA, JSP. Well-Organized, Quick learner, Self-motivated Team Player and have experience in all phases of the Systems Life Cycle including Project Definition, Analysis, Design, Coding, Testing, Implementation and .
EDUCATION
QUALIFICATION Bac
helor Of Technology in Computer Science SOFTWARE EXPERTISE
Business Intelligence/OLAP: MicroStrategy 9/8.1.1/8.0.1/7i/7.x ( Micro Strategy Desktop, MicroStrategy Architect, MicroStrategy Agent, MicroStrategy Web, MicroStrategy Intelligence Server, MicroStrategy Narrowcast Server, Microsoft OLAP Manager, Microsoft SQL Server Analysis Services, Business Objects, Microsoft Excel Databases: Teradata V2R5.1/V2R6, Oracle 7.x/8.0/9.x/10g, MS SQL Server2000/2005/2008, Sybase, MS Access 2000/97/7.0, and DB2. ETL Tools : SQL Server Integration Services(SSIS), DTS, Informatica Data Modeling: ERWIN , Microsoft VISIO Operating Systems : Windows XP/2003/2000/98/NT Programming Languages: SQL, PL/SQL, VB.NET, C #.NET, ASP.NET, JAVA, Visual Basic 6.0/5.0, C and C++. Others: HTML 4.0, DHTML, XML, VB Script, JavaScript, VBA, MS Office, Macromedia Fireworks, Macromedia Flash, Microsoft FrontPage.
PROFESSIONAL EXPERIENCE