Summary

IT professional with 8 years of dynamic experience in Business Intelligence system design, development, architecture, administration, testing, UAT, implementation, maintenance and documentation using different databases, platforms and various BI tools, functional business knowledge and company proprietary tools. Possess extensive functional knowledge in Pharmaceuticals, Healthcare Retail industries.

SKILL

BI Tools MicroStrategy, COGNOS, Business Objects, QLIKVIEW.

Functional Knowledge Pharmaceuticals, Healthcare, Retail

DBMS Netezza, Oracle, SQL Server, DB2 etc

Environment AIX, Windows, LINUX

SQL Tools Aginity Workbench, NZAdmin, Toad, WINSQL, SQL Developer etc

Company Proprietary Cognizant 2.0, Prolite, Aspire

Others Microsoft Office, Microsoft Project Plan, Visual Basic, Erwin and Embarcadero data modeler etc

• Specialized in leading and implementing BI/DW projects to enable informed decision making.
• Expert at BI Capability/Roadmap determination.
• MicroStrategy certified technical specialist: Business Intelligence development, maintenance and administration.
• Technical / Team Leader/ Architect/ Business Development/ BI Project Management.
• Requirement gathering, stakeholder level status report preparation.
• Excellent Communication Skills, team player, presentation skills.
• Expert at prioritization of several business modules, providing enterprise level BI support to various business processes.
• Assessing accurate effort, cost estimation and resourcing requirements of BI projects.
• Experienced in utilizing the onsite-offshore working model and team building exercise.
• Excellent understanding of data model, logical data modeling ownership and model version maintenance.

Skills

• Worked on different phases of data warehouse and business intelligence development lifecycle including requirement gathering, design, development, testing, implementation, project management and extensive support.
• Team leader with strong leadership capabilities with experience in mentoring developers and advising technical teams on BI best practices.
• Involved as consulting MicroStrategy architect for mobile BI project with large user base.
• Demonstrated expertise including MicroStrategy, Business Objects, COGNOS, Business Objects, Qlikview etc. Proficient in Dimensional Modeling, data model insights. Worked in RDBM systems like Oracle, Netezza, DB2 etc.
• Experienced in setting up the MicroStrategy system administration, configuration, metadata maintenance, user management, clustering etc in both Unix and Windows environment.
• Experience as a business analyst driving the pharmaceuticals alignment targeting event of sales force reorganization.
• Used MicroStrategy Narrowcast Server to automate the delivery of customized data load specific reports.
• Extensively worked in creating and integrating MicroStrategy reports and objects Attributes, Filters, Metrics, Facts, Prompts and Hierarchies with the Data warehouse.
• Certified Mobile BI designer and aware of current market trends of BI reports using mobile devices.
• Proficient in setting up MicroStrategy environment including Installation, upgrade and maintenance of the environment.
• Worked in COGNOS 8.3 dimensional modeling and data cube development.
• Familiar with ETL processes and possess hands on experience on Informatica.
• Exceptional background in analysis, design, development, customization, and implementation and testing of software applications and tools.
• Excellent technical and analytical skills with clear understanding of design goals of OLTP and OLAP systems.
• Part of Organizational MicroStrategy and BI CoE and Best practices core group.
• Took part in Cognizant's MicroStrategy internal certification set-up and question set preparation.

Project 1

Business Intelligence Architect

Confidential

Job Summary:

• Technical lead and architect that is responsible for BI deliverables of a global campaign management and other BI initiatives.
• Consulting on multiple BI projects for leading retail clients like at various stages like requirement, design, development, UAT, rollout etc.
• Provided consultation for MicroStrategy implementation and test planning on integrating new source systems for Merkle internal financial and payroll system.
• Architecting the BI dimensional model using Netezza and Microstrategy 9.3.
• Logical data model design and dimensional modeling of BI layer.
• Requirement gathering and BI model determination based on retail campaign management case study.
• Development of MicroStrategy model, reports, dashboards and use cases.
• Performance optimization troubleshooting and recommendations.
• BI Project management.
• Upgrade and set-up of different components of MicroStrategy including I-server and web server.
• Mentor and guide the team to build high quality deliverables.
• Coordinate different teams to adhere to the deliverable time and standards.
• Administering the BI Code and quality control.
• Coordinate the QA and UAT process.
• Support global project roll-out.
• Status reporting suitable for upper management and client stakeholders.
• Contribution to the best practice and competency building.

Project 6

MicroStrategy Business Analyst

Confidential

Job Summary:

• Track and review the MicroStrategy dashboards built on Sales Rep performance summary and achievements.
• Coordinated between teams to track the milestones and deliverables.
• Conduct UAT, validate feedback and coordinate to UAT closure
• Provide the BA support to business on the existing project deliverables. Act as a bridge between business and technical teams.
• Provide occasional technical consultancy to development team on business feedback.
• Project tracking, status report preparation and presentation to the stakeholders.
• Gather requirements and effort estimation on new initiatives.

Project 5

BI Architect

Confidential

Achievements:

• Lead the initiative and implemented quarterly MicroStrategy user license review and clean-up process that helped AstraZeneca saving an average of 15K/year and immensely appreciated for it.
• Initiated and guide the team build an operational dashboard as part of client system improvement program. The dashboard was designed to integrate performance monitoring and information portal of various applications. Also it was built using both MicroStrategy and Business Objects to cover different user communities.
• Initiated the transition and automated a system performance evaluator application. This implementation helped AstraZeneca reducing around 50K annual maintenance cost, which is a saving of approximately 80 cost reduction compared with the rate of previous vendor.