Project Lead µ Strategy Architect Resume
CaliforniA
SUMMARY:
- Fifteen years of IT industry experience encompassing a wide range of skill set, roles and industry verticals.
- Extensive Knowledge in Architecting Micro Strategy Schema Layer using various Data Models and Large Databases.
- Profound knowledge in Tuning the reports and Dashboards.
- In depth knowledge in the usage of Native Cubes and MDX Cubes.
- Very Good Understanding about Big data Databases like Hadoop and HANA.
- Exposure to Micro Strategy Projects using Hadoop Database as the Backend Database.
- Extensive knowledge in using Multi Source Databases and Reporting out of it.
- Extensive experience with analysis, design, development, customizations and implementation of software applications including Data warehousing applications.
- Proficient in analyzing and translating business requirements to technical requirements and architecture.
- Executed multiple Micro strategy projects with the Architect Role. Also well experienced as a Schema Developer, report Developer and. Dashboard developer, Very Much experienced in tuning the reports and dashboards.
- Extensive knowledge on ETL processes using Informatica.
- Strong database skills, well experienced in handling PL/SQL and SQL coding.
- Experience in leading and managing teams. Handled multiple roles - Project Lead, Microstrategy Architect, Informatica Architect, Developer, System Admin, BI Systems Analyst
- Executed software projects for Automotive, Retail, Pharmaceutical, Insurance and Telecom industry
- Good communication skills, interpersonal skills, self-motivated, quick learner, team player.
- Creative Writer and Contributed around 10 PoCs for various industry related implementations.
TECHNICAL SKILLS:
BI Tools: Micro Strategy (8.x,9.x,109.x), Informatica, 8.x, 9.x Tableau 7.0, 8.0, 9.0, QlikView11 (Trained)
BigData: Big Data Hadoop, Cloud era Manager, Hue, Hive and Impala.
Relational Databases: MS SQL Server 2005/2008/2012 , Oracle 8i/9i/10g/11g, ETL, Teradata, Netezza, HMS Access.
Tools: SQL Server Management Studio, Microsoft Visual Studio, Toad.
Operating Systems: Windows /XP/2000/Vista/7, Unix, Linux.
PROFESSIONAL EXPERIENCE:
Confidential, California
Project Lead &Micro Strategy Architect
Responsibilities:
- Participated in the end user meetings to obtain the business requirements for creating reports.
- Created the Semantic Layer from the Scratch and completed tested and released the Schema to the development team.
- Participated in the end user meetings to obtain the business requirements for creating reports.
- Developed Micro Strategy application objects such as Metrics, Filters, and prompts to compare monthly, quarterly and annual sales.
- Created Schema Objects - facts, attributes, hierarchies, Transformation and application objects -filters, prompts, metrics, consolidations, custom groups, and reports needed to create the Micro Strategy objects necessary for the deliverable components
- Experienced in performing Micro Strategy Administrative tasks, governing, tweaking settings on Project Configuration for optimal performance.
- Extensively Used Object Manager and Command Manager Tools.
- Developed Transformations to generate reports of type Sales this period to Sales this period Last Year and so on.
- Created reports & Dashboards from Tableau to Micro strategy.
- Applied Tuning methods to improve the performance of Reports and Dashboards.
- Developed the freeform SQL Reports, Canned Reports and Ad-hoc Reports.
- Using Micro Strategy web deployed various reports on web and customized the reports to confirm the corporate standards.
- Created Customized Hierarchy for Drill Maps.
- Created Advanced Prompts, Conditional Transformation Metrics and Level Metrics to create complex reports.
- Designed Intelligent Cubes to reduce the report execution time with the help of cube services.
- Distributed reports to different users and users groups using Delivery Engine Mechanism
- Scheduled reports, documents and dashboards using Schedule Manager.
- Expertise in customize SQL query by setting VLDB properties at different levels Database Instance, Report and Metric.
Environment: Micro Strategy 10.4 (Intelligent Server, Delivery Engine, OLAP Services, Micro Strategy Desktop, Micro Strategy Web), Configuration Wizard, Attribute Creation Wizard, Fact Creation Wizard, Windows 7 Teradata 5.6
Confidential, California
Micro strategy Consultant
Responsibilities:
- Reviewed the object migration from old project to new project. Identified the object conflict and related aftereffects. Provided the applicable solutions to the Concerned project DBA.
- Reviewed the modified and updated Semantic Layer and completely tested the Schema in the Dev and QA Instances of the project.
- Provided the presentation to the concerned stake holders to explain the importance of the findings after testing the project in the DEV and QA regions.
- Developed Micro Strategy application objects such as Metrics, Filters, and prompts to compare monthly, quarterly and annual sales.
- Provided required suggestions to modify the Schema Objects - facts, attributes, hierarchies, and Transformation and application objects -filters, prompts, metrics, consolidations, custom groups, and reports needed to create in the updated and modified MicroStrategy Project.
- Created reports & Dashboards Micro strategy as a part of the new requirement.
- Applied Tuning methods to improve the performance of Reports and Dashboards.
- Developed the freeform SQL Reports, Canned Reports and Ad-hoc Reports.
- Created Customized Hierarchy for Drill Maps.
- Created Advanced Prompts, Conditional Transformation Metrics and Level Metrics to create complex reports.
- Designed Intelligent Cubes to reduce the report execution time with the help of cube services.
Environment: Micro Strategy 10.4 (Intelligent Server, Delivery Engine, OLAP Services, MicroStrategy Desktop, Micro Strategy Web), Configuration Wizard, Attribute Creation Wizard, Fact Creation Wizard, Windows 7, Teradata 10.12
Confidential
Senior Developer
Responsibilities:
- Created Advanced Prompts, Conditional Transformation Metrics and Level Metrics to create complex reports.
- Designed Intelligent Cubes to reduce the report execution time with the help of cube services.
- Distributed reports to different users and users groups using Delivery Engine Mechanism
- Scheduled reports, documents and dashboards using Schedule Manager.
- Expertise in customize SQL query by setting VLDB properties at different levels Database Instance, Report and Metric.
- Created the Semantic Layer from the scratch using the MDX Cubes provided from SAP BW side and completed the testing and released the Schema to the development team.
- Created and Modified Schema Objects - facts, attributes, hierarchies, Transformation and application objects -filters, prompts, metrics, consolidations, custom groups, and reports needed to create the Micro Strategy objects necessary for the deliverable components
- Experienced in performing Micro Strategy Administrative tasks, governing, tweaking settings on Project Configuration for optimal performance.
- Extensively Used Object Manager and Command Manager Tools.
- Developed the appropriate Transformations to implement in metrics to generate reports with time dimension comparison
- Applied Tuning methods to improve the performance of Reports and Dashboards.
- Developed the freeform SQL Reports, Canned Reports and Ad-hoc Reports.
Environment: Micro Strategy 9.6, 10 (Intelligent Server, Delivery Engine, OLAP Services, Micro Strategy Desktop, Micro Strategy Web), Configuration Wizard, Attribute Creation Wizard, Fact Creation Wizard, Windows 7, SAP BW.
Confidential
Project Lead &Micro Strategy Architect
Responsibilities:
- Participated in the end user meetings to obtain the business requirements for creating reports.
- Created the Semantic Layer based on the existing data model and business guidelines and completed the testing and released the Schema to the development team.
- Participated in the end user meetings to obtain the business requirements for creating reports.
- Developed Micro Strategy application objects such as Metrics, Filters, and prompts to compare monthly, quarterly and annual sales.
- Created Schema Objects - facts, attributes, hierarchies, Transformation and application objects -filters, prompts, metrics, consolidations, custom groups, and reports needed to create the Micro Strategy objects necessary for the deliverable components
- Experienced in performing Micro Strategy Administrative tasks, governing, tweaking settings on Project Configuration for optimal performance.
- Extensively Used Object Manager and Command Manager Tools.
- Developed Transformations to generate reports of type Sales this period to Sales this period Last Year and so on.
- Developed the Semantic Layer based on the MDX Cubes provided out of the SAP BW database system.
- Applied Tuning methods to improve the performance of Reports and Dashboards.
- Developed the freeform SQL Reports, Canned Reports and Ad-hoc Reports.
- Using Micro Strategy web deployed various reports on web and customized the reports to confirm the corporate standards.
- Created Customized Hierarchy for Drill Maps.
- Created Advanced Prompts, Conditional Transformation Metrics and Level Metrics to create complex reports.
- Designed Intelligent Cubes to reduce the report execution time with the help of cube services.
- Distributed reports to different users and users groups using Delivery Engine Mechanism
- Scheduled reports, documents and dashboards using Schedule Manager.
- Expertise in customize SQL query by setting VLDB properties at different levels Database Instance, Report and Metric.
Environment: Micro Strategy 9.4, 9.6 (Intelligent Server, Delivery Engine, OLAP Services, Micro Strategy Desktop, Micro Strategy Web), Configuration Wizard, Attribute Creation Wizard, Fact Creation Wizard, Windows 7, DB2.
Confidential, Milwaukee, Wisconsin
Project Lead
Responsibilities:
- Responsibilities include creation and review of design documents.
- Establish timelines for development and completion of Project deliverables
- Design, Develop and implement the Informatica Mappings, Sessions and Workflows for the different stages of ETL.
- Chart out the Schedule of the Work flows.
- Perform unit testing at various levels of the ETL process.
- Unit testing and capturing the results which is part of project deliverables.
- Utilize knowledge in SQL and UNIX to deliver solutions to customer.
- Follow the Quality Procedure to ensure delivery meets the quality standards.
- Responsible for coordinating for System testing and User Acceptance test
Environment: Informatica 9.0, Windows XP, Oracle 10g
Confidential, Overland Park, Kansas
Senior Developer and QA Analyst
Responsibilities:
- Developed Micro Strategy application objects such as Metrics, Filters, and prompts to compare monthly, quarterly and annual sales.
- Reviewed the Schema Objects - facts, attributes, hierarchies, Transformation and application objects -filters, prompts, metrics, consolidations, custom groups, and reports needed to create the Micro Strategy objects necessary for the deliverable components
- Participated in performing Micro Strategy Administrative tasks, governing, tweaking settings on Project Configuration for optimal performance.
- Extensively Used Object Manager and Command Manager Tools.
- Applied Tuning methods to improve the performance of Reports and Dashboards.
- Developed the freeform SQL Reports, Canned Reports and Ad-hoc Reports.
- Created Customized Hierarchy for Drill Maps.
- Created Advanced Prompts, Conditional Transformation Metrics and Level Metrics to create complex reports.
- Designed Intelligent Cubes to reduce the report execution time with the help of cube services.
- Distributed reports to different users and users groups using Delivery Engine Mechanism
- Scheduled reports, documents and dashboards using Schedule Manager.
- Expertise in customize SQL query by setting VLDB properties at different levels Database Instance, Report and Metric.
Environment: Micro Strategy 9.0, (Intelligent Server, Delivery Engine, OLAP Services, Micro Strategy Desktop, Micro Strategy Web), Configuration Wizard, Attribute Creation Wizard, Fact Creation Wizard, Windows XP, Teradata.
Confidential, Hoffman Estates, Chicago
Project Lead &Micro Strategy Architect
Responsibilities:
- Created Schema Objects - facts, attributes, hierarchies, Transformation and application objects -filters, prompts, metrics, consolidations, custom groups, and reports needed to create the Micro Strategy objects necessary for the deliverable components
- Developed Micro Strategy application objects such as Metrics, Filters, and prompts to compare monthly, quarterly and annual sales.
- Experienced in performing Micro Strategy Administrative tasks, governing, tweaking settings on Project Configuration for optimal performance.
- Participated in the end user meetings to obtain the business requirements for creating reports.
- Created the Semantic Layer based on the existing data model and business guidelines and completed the testing and released the Schema to the development team.
- Extensively Used Object Manager and Command Manager Tools.
- Developed Transformations to generate reports of type Sales this period to Sales this period Last Year and so on.
- Developed the Semantic Layer based on the MDX Cubes provided out of the SAP BW database system.
- Applied Tuning methods to improve the performance of Reports and Dashboards.
- Developed the freeform SQL Reports, Canned Reports and Ad-hoc Reports.
- Using Micro Strategy web deployed various reports on web and customized the reports to confirm the corporate standards.
- Created Customized Hierarchy for Drill Maps.
- Created Advanced Prompts, Conditional Transformation Metrics and Level Metrics to create complex reports.
- Designed Intelligent Cubes to reduce the report execution time with the help of cube services.
- Distributed reports to different users and users groups using Delivery Engine Mechanism
- Scheduled reports, documents and dashboards using Schedule Manager.
- Expertise in customize SQL query by setting VLDB properties at different levels Database Instance, Report and Metric.
Environment: Micro Strategy 9.2, 9.4 (Intelligent Server, Delivery Engine, OLAP Services, Micro Strategy Desktop, Micro Strategy Web), Configuration Wizard, Attribute Creation Wizard, Fact Creation Wizard, Windows XP, Teradata.
Confidential, Tampa, Florida
Micro StrategyConsultant
Responsibilities:
- Participated in the end user meetings to obtain the business requirements for creating reports.
- Created the Semantic Layer based on the existing data model and business guidelines and completed the testing and released the Schema to the development team.
- Developed Micro Strategy application objects such as Metrics, Filters, and prompts to compare monthly, quarterly and annual sales.
- Created Schema Objects - facts, attributes, hierarchies, Transformation and application objects -filters, prompts, metrics, consolidations, custom groups, and reports needed to create the Micro Strategy objects necessary for the deliverable components
- Experienced in performing Micro Strategy Administrative tasks, governing, tweaking settings on Project Configuration for optimal performance.
- Extensively Used Object Manager and Command Manager Tools.
- Developed Transformations to generate reports of type Sales this period to Sales this period Last Year
- Developed the Semantic Layer based n the MDX Cubes provided out of the SAP BW database system.
- Applied Tuning methods to improve the performance of Reports and Dashboards.
- Developed the freeform SQL Reports, Canned Reports and Ad-hoc Reports.
- Using Micro Strategy web deployed various reports on web and customized the reports to confirm the corporate standards.
- Created Customized Hierarchy for Drill Maps.
- Created Advanced Prompts, Conditional Transformation Metrics and Level Metrics to create complex reports.
- Designed Intelligent Cubes to reduce the report execution time with the help of cube services.
- Distributed reports to different users and users groups using Delivery Engine Mechanism
- Scheduled reports, documents and dashboards using Schedule Manager.
- Expertise in customize SQL query by setting VLDB properties at different levels Database Instance, Report and Metric.
Environment: Micro Strategy 9.0(Intelligent Server, Delivery Engine, OLAP Services, MicroStrategy Desktop, Micro Strategy Web), Configuration Wizard, Attribute Creation Wizard, Fact Creation Wizard, Windows XP, Oracle 9i.