We provide IT Staff Augmentation Services!

Bi Resume

4.00/5 (Submit Your Rating)

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.

We'd love your feedback!