We provide IT Staff Augmentation Services!

Principal Consultant Resume

PROFESSIONAL SUMMARY:

  • Over 12+ years of experience in Data Warehousing & Business Intelligence application development, maintenance and various project implementations
  • 11+ years of IT experience with strong expertise in using MicroStrategy tool Suite as Reporting, dashboard and Administration.
  • Have strong skills in Microstrategy,Teradata, Oracle, Tableau & Qlikview
  • 4 years of experience in Toronto, Canada.
  • Proficient in data analytics tools like R, Rapid Miner, Microstrategy Analytics and Advanced analytics.
  • Experienced Product Development engineer with highly competitive technical and team management experience and in depth experience of product development.
  • Worked extensively with the onsite - offshore model and worked with large technical teams, main responsibilities include client interaction, understanding of client requirements, provide estimations and cost effective solutions.
  • Huge experience in working with multilingual teams and travelled to many business locations like Italy, Denmark, Gibraltar, Austria, United Kingdom, Canada, Spain & Switzerland
  • Good hands on Schema design, data modeling and Microstrategy Administration
  • Created Compensation, Attrition and Recruitment analysis documents and VI dashboards and also implemented D3 Visualizations as well.
  • 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 all the modules of MicroStrategy Product Suite namely MicroStrategy Intelligence Server, MicroStrategy Web, MicroStrategy Dashboard, MicroStrategy Narrowcast Server Microstrategy Command Manager, Microstrategy System Manager, Microstrategy Distribution Services, Microstrategy Mobile, Microstrategy Architect and MicroStrategy Desktop.
  • Professional experience in Design, Development, and Implementation of Data Warehousing applications, with proficiency in Making Reports, Scorecards, Dashboards using MicroStrategy 10.7/10.6/10.4/10.2/9.5/9.4/9.3.1/9.2.1/8. X/7.X
  • Certified MicroStrategy Developer (CPD)
  • Experienced in developing ETL applications using Informatica
  • Extensive domain knowledge in Gaming, Health, Retail chain sector & transportation (CSX )
  • Extensive knowledge and experience in Games Development (Poker, Casino, Bingo & Gammon)

TECHNICAL SKILLS:

Special Skills: Client interaction, Domain knowledge in Health & Retail Chain sectorMicro Strategy Certified Report Developer, Domain knowledge in Gaming Sector

Programming Languages: SQL, PLSQL, Shell scripts, sed and awk programming

Micro Strategy:, Tableau, Qlik View, Qlik Sense

Informatica: Power Center

Teradata,DB2:, Informix, Redbrick, Netezza

Operating Systems: Windows 95/ 98/NT, UNIX

Utilities: PQEDIT,TOAD, SQL Assistant, R

PROFESSIONAL EXPERIENCE:

Principal Consultant

Confidential

Responsibilities:

  • Extensively involved in developing Public Objects Metrics, Filters, Prompts, Reports, Custom Groups, Consolidations, drill maps and subtotals for reporting
  • Created Micro strategy Schema objects such as attributes, tables, Hierarchies and facts using Microstrategy Architect.
  • Creation of Interactive dashboards with multi-panels and selectors
  • Creation of Intelligent Cubes using Cube Advisor and publishing, scheduling of created cubes.
  • Creation of Simple, Transformation, Conditional, Level and Derived metrics
  • Creation of Simple, Implicit, Derived attributes
  • Creation and execution of Integrity / Performance tests using Integrity Manager
  • Worked through Start from the scratch of the project building the data model, schema creation, public objects creation, tuning the schema, creation of reports, visual insights, documents, dashboards, report delivery schedules, setting up system manager, security applied through command manager scripts, testing through integrity manager and other miscellaneous micro strategy objects.
  • Upgraded the Micro strategy environment from 9.X version to 10.4 and later to 10.7.
  • Have solid knowledge on the Microstrategy Administration and version upgrades.
  • Creation of Analytic models on Player’s activity using Micro strategy and Analytic tool R.
  • Work extensively on the Micro strategy Narrowcast Server and automated reports and dashboard delivery.
  • Developed the training material for Microstrategy users and trained around 200 business users across the globe on this project. As part of it I travelled to Milan, Rome, London, Switzerland, Vienna etc. and trained lot of business users in microstrategy.
  • Working closely with ETL team to make sure the data met the reporting needs
  • Prepare reports and maintain records of work accomplishments and administrative information, as required. Coordination the preparation, presentation and communication of work related information to the above supervisor. Coach, facilitate, solve work problems and participate in the work of the team

Environment: Micro Strategy BI reporting(10.6), Teradata 15, Informatica, 9.6, Tableau 10, Unica, Sales force, Qlikview

Confidential

Tech Lead - Software Development

Responsibilities:

  • Gather report requirements and create reports using MicroStrategy 10.6
  • Co-ordination with the Business users and understanding the Business requirements
  • Identifying different source tables and columns required to create a MicroStrategy project.
  • Designed interactive reports with extensive use of prompts (object, value) as per user requirements in Graph and Grid form of reports.
  • Created Transformations (table based, formula based) for using in comparative reports like sales this year to last year (year to date and month to date).
  • Used Filters, Facts, Prompts, Consolidations, Transformations and Custom Groups to generate reports for business analysis.
  • Developed various Visual Insights in Microstrategy and presented to business
  • Automated delivery was set to deliver the Analytics Reports to business on everyday
  • Created different dashboards for multiple states using Tableau/Microstrategy and applied different unsupervised and supervised techniques to build different models for prediction and to provide recommendations to the client.
  • Couple of objectives are similar to this

Confidential

Tech Lead - Software Development

Responsibilities:

  • Involved in creation of Schema Objects Attributes, facts, hierarchies and transformations for development of application objects on it.
  • Created hierarchies metrics, advanced metrics (level metrics, non-aggregate metrics, transformation metrics and conditional metrics).
  • Created filters, prompts (Object prompt, Value prompt, Level prompt, filter definition prompt) for creation of MicroStrategy reports.
  • Involved in Dimensional Data Modeling (Star Schema, Snow-Flake Schema) Data Architecture, Business and Data Analysis.
  • Created the regulator reporting and automated the delivery of reports New Jersey regulator

Confidential

Team Lead

Responsibilities:

  • Requirements collection, Requirement Analysis, ROM / Definitive Estimate creation, SoW creation, Technical Design, Coding, UTP and RTM creation, System Testing, Integration testing, Implementation plan, Review of all the above tasks, Implementation of project in production environment. This includes creation of new ETL’s, Micro strategy BI reports & Unix shell scripts
  • Production support tickets resolution
  • User support tickets resolution
  • Prepare reports and maintain records of work accomplishments and administrative information, as required. Coordination the preparation, presentation and communication of work related information to the above supervisor. Coach, facilitate, solve work problems and participate in the work of the team

Environment: Unix Shell Scripting, Informatica Power Center, Micro Strategy BI reporting, Sed and Awk Programming, db2, Redbrick & Netezza

Confidential

Senior Consultant

Responsibilities:

  • Actively Participated in Requirements collection for ETL’s and for Micro strategy BI Reports
  • Participation in creation of ROM, Definitive estimation and creation of SOW documents
  • Creation of high level design document and STM documents Source to Target Mapping
  • Creation of Informatica ETL process to build the RX BI data ware house.
  • Creation of Micro strategy BI Reports. It involves creation of simple, compound metrics, attributes, facts, hierarchies, prompts, filters, templates. As part of this 25 Micro strategy reports were created. It includes Transaction Summary report, SHN exceptional Din’s report, Rx’s by store report etc.
  • For Microstrategy projects, Created schema objects like attributes, facts, hierarchies, transformations and public objects like metrics, prompts, consolidations, custom groups, drill maps, and templates
  • Designed various kinds of reports like Scorecards & Dashboards, Operational Reports, Business Reports, and Ad-hoc Reports.
  • Created various monthly Dynamic Dashboard Documents with multiple panel stacks, selectors, and customized widgets.
  • Created advanced reports using MicroStrategy Desktop Designer.
  • Involved in the creation of Data mart Reports and Report Scheduling as per user need and data periods.
  • Distributed reports to different users and user groups using Narrowcast Server

Environment: Informatica Power Center, Micro Strategy BI reporting & db2

Confidential

Consultant

Responsibilities:

  • Worked directly in the client environment.
  • Actively Participated in Requirements collection for ETL’s and for Micro strategy BI Reports
  • Participation in creation of ROM, Definitive estimation and creation of SOW documents
  • Creation of high level design document and STM documents Source to Target Mapping
  • Creation of Informatica ETL process to build the Active Track Data Mart .
  • Creation of Micro strategy BI Reports. It involves creation of simple, compound metrics, attributes, facts, hierarchies, prompts, filters, templates. As part of this 11 Micro strategy reports were created. It includes Executive summary report, Alert status Executive Summary, % Affected National Map / % affected National Map by Symptom, Market Statistics Summary, Regional Demographic Report, Customer Segmentation, Market share analysis with demographics & Time series Affinity reports etc
  • Created unit test cases to validate the data and technical process involved.
  • Participated in preparation of System integration test plans.
  • Implemented the project in production environment.
  • Participated in post-production activities.

Environment: Informatica Power Center, Micro Strategy BI reporting & db2

Confidential

Consultant

Responsibilities:

  • Creation of Informatica ETL process to build the Confidential mart.
  • Creation of Micro strategy BI Reports. It involves creation of simple, compound metrics, attributes, facts, hierarchies, prompts, filters, dashboards & templates. As part of this 19 Micro strategy reports were created.

Environment: Informatica Power Center, Micro Strategy BI reporting & db2

Confidential

Consultant

Responsibilities:

  • Actively Participated in Requirements collection for ETL’s and for Micro strategy BI Reports
  • Participation in creation of ROM, Definitive estimation and creation of SOW documents
  • Creation of high level design document and STM documents Source to Target Mapping
  • Creation of Informatica ETL process to build the Home Health Care data ware house.
  • Created unit test cases to validate the data and technical process involved.
  • Participated in preparation of System integration test plans.
  • Implemented the project in production environment.
  • Participated in post-production activities.

Environment: Unix Shell scripting, Informatica Power Center, db2, Microstrategy

Confidential

Team Member

Responsibilities:

  • Requirement Analysis, ROM / Definitive Estimate creation, SoW creation, Technical Design, Coding, UTP and RTM creation, System Testing, Integration testing, Implementation plan and Review of all the above tasks.
  • Production support tickets resolution
  • User support tickets resolution

Environment: Unix Shell Scripting, Sed and Awk Programming, Perl, Informix, Redbrick, db2 & Informatica Power Center.Microstrategy

Confidential

Team Member

Responsibilities:

  • Providing the documents for the application Tecsys Interfaces.
  • Providing documents on the IMS applications.
  • Order placing on the Tecsys System by using the Menu.
  • Analyzing and documentation on 4gl programs.
  • Maintaining application and documentation.

Environment: Unix Shell Scripting, Informix, Informix 4gl.

Hire Now