Bi Resume
SUMMARY:
- 11 Plus years of experience in full life cycle development gathering requirements, documentation, developing, designing, testing, implementing, and deploying BI Solutions.
- 7 years experience working for Federal (SSA) and Health care (CMS) IT Projects.
- Experience working in agile projects and Certified safe Agile Professional.
- Expertise in Designing IDR Data at Claim, Beneficiary, Provider and Encounter Subject Areas for report Development.
- Expertise in using MicroStrategy 9/8.x/7i/7.x product suites including MicroStrategy Desktop, Web, Architect, OLAP Services, Administrator, Intelligence Server, Narrowcast Server.
- Expertise in working on Direct Project Source (Two - Tier) and Server Project source (Three-Tier).
- Two years of working experience with off shore development team.
- Expertise in designing Data model for Datamart and development of Logical and Physical Data models using Erwin 7.2.
- Experience in working with data modelers to translate business rules/requirements into conceptual/logical dimensional models and worked with complex de-normalized and normalized data models.
- Well versed in designing the reporting applications according to BRD, SRS and TDS.
- Expertise in creating schema objects (Facts, Attributes, Hierarchies, and Transformations) to develop user objects.
- Expertise in developing Application Objects (filters, prompts, metrics, Custom Groups, Consolidations, DrillMaps, Templates, Searches), developed Reports, Documents and Dashboards .
- Expertise in using pass-through Expressions like Apply Simple and Apply Comparison to develop complex Filters and Transformations.
- Expertise in creating document from multiple datasets like Map Application Diagram, Grid and Graph.
- Expertise in creating hyper links in documents and drill reports.
- Expertise in migrating objects from development to QA and QA to Production by using Object Manager Window.
- Expertise in using administration tools like System Monitor, System Administration, User Manager, Object Manager and Command Manager.
- Expertise in developing Reports by using Freeform SQL Queries and Logical Views in MicroStrategy Desktop.
- Expertise in creating dashboard reports in an Interactive and Flash Mode by using Selector, Sliders and Widgets to view personalized reports based on user requirements.
- Expertise in fine tuning of the MicroStrategy reports using Data Mart Reports, Partition Mappings, Aggregate Tables and Intelligent Cubes.
- Expertise in defining Microstrategy Narrow Cast Server objects like Service, Schedule, Subscription Set and Information Objects.
- Expertise in customization of Web home page and reports by using SDK.
- Expertise in migrating Business Objects, Cognos Reports to Microstrategy reports.
- Expertise in Development dashboards using Visual Analytics By using Tableau.
- Proficient in using Oracle 10g, SQL Server 2000/2005, Teradata V2R6, DB2
- Involved in upgradation of Microstrategy projects from 8.1.2 to 9.x and 9.2.1 to 9.3.1.
- Experience in developing test cases and test plans for system testing, unit testing and UAT extensively.
- Experience in code optimization and performance tuning of database queries.
- Three years of experience on ETL tools Oracle Warehouse Builder, Data Stage and Informatica.
- Specialized in developing stored procedures, functions, packages and database triggers using Oracle SQL and PL/SQL.
- Expertise in using Microstrategy with Netezza, Oracle, Teradata, Sql server as data warehouse system.
- Strong presentation, analytical, multi tasking, decision making, problem solving and excellent inter-personal skills
- Strong communication skills (written, reading comprehension, listening, verbal, training and presentation).
TECHNICAL SKILLS:
Business Intelligence: Microstrategy 10.2/9.4.1/9.3.1/9.2.1/9.0.2/8.1.2/8.1.1/8.0.2 (Microstrategy Desktop, Web, Intelligence Server, OLAP Services, Report Services, Narrowcast Server, Object Manager, Integrity Manager, Command Manager, Analytical Dash Boards, Interactive Dash Boards, Administration), Business Objects XIR2/6.5,Cognos 8.4.1,SSIS,SSRS,SSAS, Framework Manager, Query Studio, Report Studio, Tableau, Microstrategy Mobile Application for IPad and Iphone .
ETL Informatica: 8.6.1/8.1/7. x/ 6.x, Oracle warehouse Builder 10.2, Data Stage 7.5.2
Languages: SQL, PL/SQL, C, ASP.Net, JSP.Net, SDK, XML.
Development Tools: Oracle Developer 2000 (Forms 6i & Reports), SQL*Plus, Erwin 7.2SQL*Loader, TOAD
O/S: Windows XP/2000/NT/98, UNIX, Linux, MS-DOS
Database: Oracle 10g/9i/8i, MS SQL Server 2000/2005, Netezza 5.0, DB2 7.0Teradata 12.
